APPS.XDP_OE_ORDER dependencies on XDP_OE_ORDER_PARAMETERS

Line 111: -- Insert any XDP OE Order Parameters.

107: IF( lv_oe_order_parameter_list.COUNT = 0 ) THEN
108: -- No Parameters.
109: NULL ;
110: ELSE
111: -- Insert any XDP OE Order Parameters.
112: lv_param_count := lv_oe_order_parameter_list.FIRST ;
113: FOR lv_temp IN 1..lv_oe_order_parameter_list.COUNT
114: LOOP
115: INSERT INTO XDP_OE_ORDER_PARAMETERS (

Line 115: INSERT INTO XDP_OE_ORDER_PARAMETERS (

111: -- Insert any XDP OE Order Parameters.
112: lv_param_count := lv_oe_order_parameter_list.FIRST ;
113: FOR lv_temp IN 1..lv_oe_order_parameter_list.COUNT
114: LOOP
115: INSERT INTO XDP_OE_ORDER_PARAMETERS (
116: ORDER_NUMBER,
117: ORDER_VERSION,
118: PARAMETER_NAME,
119: PARAMETER_VALUE

Line 355: FROM XDP_OE_ORDER_PARAMETERS

351: l_sdp_order_id NUMBER;
352:
353: CURSOR lc_param IS
354: SELECT PARAMETER_NAME, PARAMETER_VALUE
355: FROM XDP_OE_ORDER_PARAMETERS
356: WHERE ORDER_NUMBER = p_oe_order_number
357: AND ORDER_VERSION = p_oe_order_version ;
358:
359: /* p_oe_order_version made mandatory. This cursor is never opened.

Line 365: -- FROM XDP_OE_ORDER_PARAMETERS

361: ** 02/27/2001. skilaru
362: */
363: -- CURSOR lc_param2 IS
364: -- SELECT PARAMETER_NAME, PARAMETER_VALUE
365: -- FROM XDP_OE_ORDER_PARAMETERS
366: -- WHERE ORDER_NUMBER = p_oe_order_number
367: -- AND ORDER_VERSION IS NULL;
368:
369: CURSOR lc_line IS