[Home] [Help]
2350: --increment the lv_temp_counter
2351: lv_temp_counter := p_service_order_line_list.COUNT + 1;
2352:
2353: --select the sequence from xdp_order_line_s
2354: select xdp_order_line_items_s.nextval
2355: into l_line_item_id
2356: from dual;
2357:
2358: --increment the lv_fnd_counter
2658: P_ITEM_NUMBER => l_item_number ,
2659: P_INVENTORY_ITEM_ID => l_inventory_item_id ,
2660: P_ACTIVATION_FLAG => l_activation_flag );
2661:
2662: SELECT XDP_ORDER_LINE_ITEMS_S.nextval
2663: INTO l_line_item_id
2664: FROM dual ;
2665:
2666: /*** Add Exploded component line of service to p_service_order_line_list ***/
3113: lv_fnd_count := lv_fnd_count + 1;
3114:
3115: -- select the sequence from xdp_order_line_s
3116:
3117: select xdp_order_line_items_s.nextval
3118: into lv_det_id
3119: from dual;
3120:
3121: -- explode the detail lines in p_service_order_line_list
3857: END IF;
3858: END IF;
3859:
3860: --======================================================================================================
3861: --Loop through all the lines and asign the columns to variables for bulk inserts in XDP_ORDER_LINE_ITEMS
3862: --===================================================================================================
3863:
3864:
3865: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
3937: END IF;
3938: END IF;
3939:
3940: --========================================================================================================
3941: --Insert into XDP_ORDER_LINE_ITEMS
3942: --========================================================================================================
3943: -- TODO!! MAKE SITE USE IS NOT NULL
3944: -- TODO REMOVE STATE
3945: FORALL lv_temp IN 1..p_order_line_list.COUNT
3943: -- TODO!! MAKE SITE USE IS NOT NULL
3944: -- TODO REMOVE STATE
3945: FORALL lv_temp IN 1..p_order_line_list.COUNT
3946:
3947: INSERT INTO XDP_ORDER_LINE_ITEMS
3948: (LINE_ITEM_ID ,
3949: ORDER_ID ,
3950: LINE_NUMBER ,
3951: STATUS_CODE ,