Oracle Technical , Functional and DB Information

apps.WF_ITEM_TYPES apps.WF_ITEM_ATTRIBUTES APPS.WF_ACTIVITIES apps.WF_ACTIVITY_ATTRIBUTES apps.WF_MESSAGES apps.WF_MESSAGE_ATTRIBUTES apps.WF_NOTIFICATIONS apps.WF_NOTIFICATION_ATTRIBUTES apps.WF_ITEMS SELECT STA.ITEM_TYPE                ITEM_TYPE       ,  STA.ACTIVITY_RESULT_CODE     RESULT       ,  PRA.PROCESS_NAME ||':'||              PRA.INSTANCE_LABEL       PROCESS_ACTIVITY_LABEL       ,  STA.PROCESS_ACTIVITY         INSTANCE_ID       ,  STA.ITEM_KEY                 ITEM_KEY, STA.ACTIVITY_RESULT_CODE, STA.ERROR_MESSAGE, STA.ACTIVITY_STATUS, STA.BEGIN_DATE, STA.*  FROM  apps.WF_ITEM_ACTIVITY_STATUSES  STA       , apps.WF_PROCESS_ACTIVITIES      PRA  WHERE...

DECLARE v_api_version_number           NUMBER  := 1; v_return_status                VARCHAR2 (2000); v_msg_count                    NUMBER; v_msg_data                     VARCHAR2 (2000); -- IN Variables -- v_header_rec                   oe_order_pub.header_rec_type; v_line_tbl                     oe_order_pub.line_tbl_type; v_action_request_tbl           oe_order_pub.request_tbl_type; v_line_adj_tbl                 oe_order_pub.line_adj_tbl_type; -- OUT Variables -- v_header_rec_out               oe_order_pub.header_rec_type; v_header_val_rec_out        ...

/* Formatted on 12/7/2016 1:32:27 PM (QP5 v5.115.810.9015) */ declare l_category_rec INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE; l_return_status   VARCHAR2(80); l_error_code      VARCHAR2(100); l_msg_count       NUMBER; l_msg_data        VARCHAR2(80); l_out_category_id NUMBER; CURSOR c_cat IS select  * from stm_cust.MISSING_CAT_SEG ; begin FOR lc_cat IN c_cat LOOP l_category_rec := NULL; l_category_rec.structure_id := 51114; --l_category_rec.structure_code := g_cat_flex_code; l_category_rec.summary_flag := 'N'; l_category_rec.enabled_flag := 'Y'; l_category_rec.segment1 := lc_cat.segment1; l_category_rec.segment2 := lc_cat.segment2; l_category_rec.description := lc_Cat.des; --l_category_rec.segment3 := lc_cat.segment3; --l_category_rec.segment4 := lc_cat.segment4; -- -- After the category record is loaded, then call the create_category api to -- create the new mtl_categories record. Inv_Item_C...