eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_ORDER_COPY_UTIL dependencies on OE_ORDER_PUB

Line 10: G_HDR_ADJ_TBL OE_Order_PUB.Header_Adj_Tbl_Type;

6: G_ORDER_NUMBER NUMBER := NULL;
7: G_VERSION_NUMBER NUMBER := NULL;
8: G_ORDER_TYPE_ID NUMBER := NULL;
9: G_ADJ_HDR_ID NUMBER := NULL;
10: G_HDR_ADJ_TBL OE_Order_PUB.Header_Adj_Tbl_Type;
11: G_NEED_TO_EXPLODE_CONFIG BOOLEAN := FALSE;
12: G_COPY_TO_DIFFERENT_ORDER_TYPE BOOLEAN := FALSE; -- 5404002
13:
14: -- Added for the ER 1480867

Line 34: x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type);

30: PROCEDURE sort_line_tbl(p_line_id_tbl IN OE_GLOBALS.Selected_Record_Tbl,
31: p_version_number IN NUMBER,
32: p_phase_change_flag IN VARCHAR2,
33: p_num_lines IN NUMBER,
34: x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type);
35:
36: -- End
37:
38: -- Added as part of Inline Code Documentation Drive.

Line 81: (p_line_tbl IN OE_Order_PUB.Line_Tbl_type,

77:
78: END Get_copy_rec;
79:
80: Function Find_LineIndex
81: (p_line_tbl IN OE_Order_PUB.Line_Tbl_type,
82: p_line_id IN NUMBER
83: )
84: Return Number
85: IS

Line 380: ,x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type)

376:
377: Procedure Copy_Header
378: ( p_header_id IN NUMBER
379: ,p_copy_rec IN copy_rec_type
380: ,x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type)
381: IS
382: l_api_name CONSTANT VARCHAR(30) := 'Copy_Header';
383: l_orig_category VARCHAR2(30);
384: l_cpy_category VARCHAR2(30);

Line 779: ,x_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Tbl_Type)

775: PROCEDURE Load_and_Init_Hdr_Scredits
776: (p_header_Id IN Number
777: ,p_version_number IN NUMBER
778: ,p_phase_change_flag IN VARCHAR2
779: ,x_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Tbl_Type)
780: IS
781: l_api_name CONSTANT VARCHAR(30) := 'Load_and_Init_Hdr_Scredits';
782: --
783: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 864: ,p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type)

860: Function Load_and_Init_Hdr_Holds
861: (p_header_Id IN Number
862: ,p_version_number IN NUMBER
863: ,p_phase_change_flag IN VARCHAR2
864: ,p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type)
865: Return OE_Order_PUB.Request_Tbl_Type
866: IS
867: l_api_name CONSTANT VARCHAR(30) := 'Load_and_Init_Hdr_Holds';
868: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;

Line 865: Return OE_Order_PUB.Request_Tbl_Type

861: (p_header_Id IN Number
862: ,p_version_number IN NUMBER
863: ,p_phase_change_flag IN VARCHAR2
864: ,p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type)
865: Return OE_Order_PUB.Request_Tbl_Type
866: IS
867: l_api_name CONSTANT VARCHAR(30) := 'Load_and_Init_Hdr_Holds';
868: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
869: k NUMBER := 1;

Line 868: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;

864: ,p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type)
865: Return OE_Order_PUB.Request_Tbl_Type
866: IS
867: l_api_name CONSTANT VARCHAR(30) := 'Load_and_Init_Hdr_Holds';
868: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
869: k NUMBER := 1;
870: l_hold_source_tbl OE_Hold_Sources_PVT.Hold_Source_TBL;
871: l_return_status VARCHAR2(1);
872: l_v_number NUMBER;

Line 1007: ,x_Header_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Header_Payment_Tbl_Type)

1003:
1004: -- Added for multiple payments
1005: PROCEDURE Load_and_Init_Hdr_Payments
1006: (p_header_Id IN Number
1007: ,x_Header_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Header_Payment_Tbl_Type)
1008: IS
1009: k pls_integer;
1010:
1011: --R12 CC Encryption

Line 1113: ,p_action_request_tbl IN OUT NOCOPY OE_Order_PUB.Request_Tbl_Type)

1109: -- This function loads Line based holds into the action request table.
1110: PROCEDURE Load_and_Init_line_Holds
1111: (p_line_Id IN Number
1112: ,p_new_line_id IN Number
1113: ,p_action_request_tbl IN OUT NOCOPY OE_Order_PUB.Request_Tbl_Type)
1114: IS
1115: l_api_name CONSTANT VARCHAR(30) := 'Load_and_Init_Line_Holds';
1116: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1117: k NUMBER := 1;

Line 1116: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;

1112: ,p_new_line_id IN Number
1113: ,p_action_request_tbl IN OUT NOCOPY OE_Order_PUB.Request_Tbl_Type)
1114: IS
1115: l_api_name CONSTANT VARCHAR(30) := 'Load_and_Init_Line_Holds';
1116: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1117: k NUMBER := 1;
1118: l_hold_source_tbl OE_Hold_Sources_PVT.Hold_Source_TBL;
1119: l_return_status VARCHAR2(1);
1120:

Line 1239: ( p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type

1235: -- Delete Class items always.
1236: -- This functions also deletes fully cancelled lines based on the flag.
1237:
1238: Procedure Handle_Return_Lines
1239: ( p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
1240: ,p_incl_cancelled IN VARCHAR2
1241: )
1242: IS
1243: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 1243: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

1239: ( p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
1240: ,p_incl_cancelled IN VARCHAR2
1241: )
1242: IS
1243: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1244: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
1245: l_api_name CONSTANT VARCHAR2(30) := 'Handle_Return_Lines';
1246: l_top_model_index NUMBER;
1247: k NUMBER;

Line 1244: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;

1240: ,p_incl_cancelled IN VARCHAR2
1241: )
1242: IS
1243: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1244: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
1245: l_api_name CONSTANT VARCHAR2(30) := 'Handle_Return_Lines';
1246: l_top_model_index NUMBER;
1247: k NUMBER;
1248: j NUMBER := 1;

Line 1392: ( p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type

1388: --For bug 3923574, we added new parameter x_top_model_tbl to mark the
1389: -- has_canceled_flag on the model.
1390:
1391: Procedure Handle_NonStandard_Lines
1392: ( p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
1393: ,p_incl_cancelled IN VARCHAR2
1394: ,x_top_model_tbl IN OUT NOCOPY Top_Model_Tbl_Type
1395: )
1396: IS

Line 1397: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

1393: ,p_incl_cancelled IN VARCHAR2
1394: ,x_top_model_tbl IN OUT NOCOPY Top_Model_Tbl_Type
1395: )
1396: IS
1397: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1398: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
1399: l_api_name CONSTANT VARCHAR2(30) := 'Handle_NonStandard_Lines';
1400: l_top_model_index NUMBER;
1401: l_link_to_index NUMBER;

Line 1398: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;

1394: ,x_top_model_tbl IN OUT NOCOPY Top_Model_Tbl_Type
1395: )
1396: IS
1397: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1398: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
1399: l_api_name CONSTANT VARCHAR2(30) := 'Handle_NonStandard_Lines';
1400: l_top_model_index NUMBER;
1401: l_link_to_index NUMBER;
1402: l_service_index NUMBER;

Line 1822: ,x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type

1818: ,p_hdr_type_id IN NUMBER
1819: ,p_line_type_id IN NUMBER
1820: ,p_version_number IN NUMBER
1821: ,p_phase_change_flag IN VARCHAR2
1822: ,x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
1823: /* Added the following line to fix the bug 1923460 */
1824: ,x_top_model_tbl IN OUT NOCOPY Top_Model_Tbl_Type
1825: )
1826: IS

Line 1831: l_line_rec OE_Order_PUB.Line_Rec_Type;

1827: l_top_model_index NUMBER;
1828: l_line_id OE_Order_LINES.Line_id%Type;
1829: l_cpy_category VARCHAR2(30);
1830: l_line_category VARCHAR2(30);
1831: l_line_rec OE_Order_PUB.Line_Rec_Type;
1832:
1833: l_api_name CONSTANT VARCHAR(30) := 'Load_Lines';
1834:
1835: /* Start - Code added for the bug 1923460 */

Line 2168: p_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type)

2164:
2165: End Load_Lines;
2166:
2167: procedure Clear_Missing_Attributes(
2168: p_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type)
2169: IS
2170: --
2171: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2172: --

Line 2354: ( p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type

2350:
2351: END Clear_Missing_Attributes;
2352:
2353: Procedure Init_Lines_New
2354: ( p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
2355: ,p_x_top_model_tbl IN OUT NOCOPY Top_Model_Tbl_Type
2356: ,p_line_type IN NUMBER
2357: ,p_header_id IN NUMBER
2358: ,p_line_price_mode IN NUMBER

Line 2367: ,p_action_request_tbl IN OUT NOCOPY OE_Order_PUB.Request_Tbl_Type

2363: ,p_default_null_values IN VARCHAR2
2364: ,p_reason_code IN VARCHAR2
2365: ,p_comments IN VARCHAR2
2366: ,p_copy_rec IN COPY_REC_TYPE
2367: ,p_action_request_tbl IN OUT NOCOPY OE_Order_PUB.Request_Tbl_Type
2368: )
2369: IS
2370: l_api_name CONSTANT VARCHAR2(30) := 'Init_Lines_New';
2371: l_temp_line_rec OE_ORDER_PUB.Line_Rec_Type;

Line 2371: l_temp_line_rec OE_ORDER_PUB.Line_Rec_Type;

2367: ,p_action_request_tbl IN OUT NOCOPY OE_Order_PUB.Request_Tbl_Type
2368: )
2369: IS
2370: l_api_name CONSTANT VARCHAR2(30) := 'Init_Lines_New';
2371: l_temp_line_rec OE_ORDER_PUB.Line_Rec_Type;
2372: l_orig_line_category VARCHAR2(30);
2373: l_cpy_line_category VARCHAR2(30);
2374: l_order_number NUMBER;
2375: l_order_type_id NUMBER;

Line 2952: p_x_line_tbl(k) := OE_Order_PUB.G_MISS_LINE_REC;

2948: G_REGULAR_TO_RMA := TRUE;
2949: -- Process order will fill all remaining columns for the line,
2950: -- when it is copied from reg to return.
2951:
2952: p_x_line_tbl(k) := OE_Order_PUB.G_MISS_LINE_REC;
2953: p_x_line_tbl(k).line_type_id :=
2954: nvl(p_line_type,l_temp_line_rec.line_type_id);
2955: p_x_line_tbl(k).return_reason_code := p_return_reason_code;
2956:

Line 3176: (p_line_tbl IN OE_Order_PUB.Line_Tbl_type

3172:
3173: END Init_Lines_New;
3174:
3175: Procedure Load_and_Init_Line_Scredits
3176: (p_line_tbl IN OE_Order_PUB.Line_Tbl_type
3177: ,p_version_number IN NUMBER
3178: ,p_phase_change_flag IN VARCHAR2
3179: ,x_Line_Scredit_Tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type )
3180: IS

Line 3179: ,x_Line_Scredit_Tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type )

3175: Procedure Load_and_Init_Line_Scredits
3176: (p_line_tbl IN OE_Order_PUB.Line_Tbl_type
3177: ,p_version_number IN NUMBER
3178: ,p_phase_change_flag IN VARCHAR2
3179: ,x_Line_Scredit_Tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type )
3180: IS
3181:
3182: l_line_id NUMBER;
3183: I NUMBER := 1;

Line 3184: l_sub_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

3180: IS
3181:
3182: l_line_id NUMBER;
3183: I NUMBER := 1;
3184: l_sub_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3185: l_api_name CONSTANT VARCHAR(30) := 'Load_and_Init_Line_Scredits';
3186: K NUMBER; -- Used as loop index.
3187: --
3188: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 3292: (p_line_tbl IN OE_Order_PUB.Line_Tbl_type

3288: END Load_and_Init_Line_Scredits;
3289:
3290: -- Added for multiple payments
3291: PROCEDURE Load_and_Init_Line_Payments
3292: (p_line_tbl IN OE_Order_PUB.Line_Tbl_type
3293: ,p_line_type IN NUMBER
3294: ,x_Line_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Line_Payment_Tbl_Type)
3295: IS
3296:

Line 3294: ,x_Line_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Line_Payment_Tbl_Type)

3290: -- Added for multiple payments
3291: PROCEDURE Load_and_Init_Line_Payments
3292: (p_line_tbl IN OE_Order_PUB.Line_Tbl_type
3293: ,p_line_type IN NUMBER
3294: ,x_Line_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Line_Payment_Tbl_Type)
3295: IS
3296:
3297: l_sub_payment_tbl OE_Order_PUB.Line_payment_Tbl_Type;
3298: l_line_id NUMBER;

Line 3297: l_sub_payment_tbl OE_Order_PUB.Line_payment_Tbl_Type;

3293: ,p_line_type IN NUMBER
3294: ,x_Line_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Line_Payment_Tbl_Type)
3295: IS
3296:
3297: l_sub_payment_tbl OE_Order_PUB.Line_payment_Tbl_Type;
3298: l_line_id NUMBER;
3299: k NUMBER;
3300: I NUMBER := 1;
3301: l_line_category VARCHAR2(30);

Line 3577: l_header_rec OE_Order_PUB.Header_Rec_Type;

3573: l NUMBER; -- Used as loop index.
3574: k NUMBER; -- Used as loop index.
3575: j NUMBER; -- Used as loop index.
3576:
3577: l_header_rec OE_Order_PUB.Header_Rec_Type;
3578: l_control_rec OE_GLOBALS.Control_Rec_Type;
3579: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
3580: /* Added the following line to fix the bug 1923460 */
3581: l_top_model_tbl top_model_tbl_type;

Line 3579: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

3575: j NUMBER; -- Used as loop index.
3576:
3577: l_header_rec OE_Order_PUB.Header_Rec_Type;
3578: l_control_rec OE_GLOBALS.Control_Rec_Type;
3579: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
3580: /* Added the following line to fix the bug 1923460 */
3581: l_top_model_tbl top_model_tbl_type;
3582: l_line_final_tbl OE_Order_PUB.Line_Tbl_Type;
3583: l_header_out_rec OE_Order_PUB.Header_Rec_Type;

Line 3582: l_line_final_tbl OE_Order_PUB.Line_Tbl_Type;

3578: l_control_rec OE_GLOBALS.Control_Rec_Type;
3579: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
3580: /* Added the following line to fix the bug 1923460 */
3581: l_top_model_tbl top_model_tbl_type;
3582: l_line_final_tbl OE_Order_PUB.Line_Tbl_Type;
3583: l_header_out_rec OE_Order_PUB.Header_Rec_Type;
3584: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
3585: l_line_rec OE_Order_PUB.Line_Rec_Type;
3586: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 3583: l_header_out_rec OE_Order_PUB.Header_Rec_Type;

3579: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
3580: /* Added the following line to fix the bug 1923460 */
3581: l_top_model_tbl top_model_tbl_type;
3582: l_line_final_tbl OE_Order_PUB.Line_Tbl_Type;
3583: l_header_out_rec OE_Order_PUB.Header_Rec_Type;
3584: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
3585: l_line_rec OE_Order_PUB.Line_Rec_Type;
3586: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3587: l_header_price_att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 3584: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;

3580: /* Added the following line to fix the bug 1923460 */
3581: l_top_model_tbl top_model_tbl_type;
3582: l_line_final_tbl OE_Order_PUB.Line_Tbl_Type;
3583: l_header_out_rec OE_Order_PUB.Header_Rec_Type;
3584: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
3585: l_line_rec OE_Order_PUB.Line_Rec_Type;
3586: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3587: l_header_price_att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3588: l_header_Adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 3585: l_line_rec OE_Order_PUB.Line_Rec_Type;

3581: l_top_model_tbl top_model_tbl_type;
3582: l_line_final_tbl OE_Order_PUB.Line_Tbl_Type;
3583: l_header_out_rec OE_Order_PUB.Header_Rec_Type;
3584: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
3585: l_line_rec OE_Order_PUB.Line_Rec_Type;
3586: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3587: l_header_price_att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3588: l_header_Adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3589: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

Line 3586: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

3582: l_line_final_tbl OE_Order_PUB.Line_Tbl_Type;
3583: l_header_out_rec OE_Order_PUB.Header_Rec_Type;
3584: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
3585: l_line_rec OE_Order_PUB.Line_Rec_Type;
3586: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3587: l_header_price_att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3588: l_header_Adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3589: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3590: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 3587: l_header_price_att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

3583: l_header_out_rec OE_Order_PUB.Header_Rec_Type;
3584: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
3585: l_line_rec OE_Order_PUB.Line_Rec_Type;
3586: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3587: l_header_price_att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3588: l_header_Adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3589: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3590: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3591: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 3588: l_header_Adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

3584: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
3585: l_line_rec OE_Order_PUB.Line_Rec_Type;
3586: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3587: l_header_price_att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3588: l_header_Adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3589: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3590: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3591: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3592: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 3589: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

3585: l_line_rec OE_Order_PUB.Line_Rec_Type;
3586: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3587: l_header_price_att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3588: l_header_Adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3589: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3590: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3591: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3592: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3593: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 3590: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

3586: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3587: l_header_price_att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3588: l_header_Adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3589: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3590: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3591: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3592: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3593: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3594: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 3591: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

3587: l_header_price_att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3588: l_header_Adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3589: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3590: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3591: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3592: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3593: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3594: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3595: l_line_Adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 3592: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

3588: l_header_Adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3589: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3590: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3591: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3592: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3593: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3594: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3595: l_line_Adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3596: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 3593: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

3589: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3590: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3591: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3592: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3593: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3594: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3595: l_line_Adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3596: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3597: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 3594: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

3590: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3591: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3592: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3593: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3594: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3595: l_line_Adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3596: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3597: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3598: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 3595: l_line_Adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

3591: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3592: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3593: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3594: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3595: l_line_Adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3596: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3597: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3598: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3599: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 3596: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

3592: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3593: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3594: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3595: l_line_Adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3596: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3597: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3598: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3599: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3600: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 3597: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

3593: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3594: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3595: l_line_Adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3596: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3597: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3598: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3599: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3600: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3601: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;

Line 3598: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

3594: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3595: l_line_Adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3596: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3597: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3598: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3599: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3600: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3601: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
3602: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;

Line 3599: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

3595: l_line_Adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3596: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3597: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3598: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3599: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3600: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3601: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
3602: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
3603:

Line 3600: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

3596: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3597: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3598: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3599: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3600: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3601: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
3602: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
3603:
3604: l_header_exists BOOLEAN; -- variables added for bug 1935675

Line 3601: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;

3597: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3598: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3599: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3600: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3601: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
3602: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
3603:
3604: l_header_exists BOOLEAN; -- variables added for bug 1935675
3605: l_copy_partial_or_full BOOLEAN := FALSE;

Line 3602: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;

3598: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3599: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3600: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3601: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
3602: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
3603:
3604: l_header_exists BOOLEAN; -- variables added for bug 1935675
3605: l_copy_partial_or_full BOOLEAN := FALSE;
3606: l_all_lines_copied BOOLEAN;

Line 3621: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

3617: l_copy_header_id NUMBER;
3618: l_temp_var VARCHAR2(2000) := NULL;
3619: l_copy_rec COPY_REC_TYPE;
3620: --serla begin
3621: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3622: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3623: --serla end
3624:
3625: --R12 CC Encryption

Line 3622: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

3618: l_temp_var VARCHAR2(2000) := NULL;
3619: l_copy_rec COPY_REC_TYPE;
3620: --serla begin
3621: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3622: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3623: --serla end
3624:
3625: --R12 CC Encryption
3626: l_cpy_category VARCHAR2(30);

Line 5223: x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type)

5219: PROCEDURE sort_line_tbl(p_line_id_tbl IN OE_GLOBALS.Selected_Record_Tbl,
5220: p_version_number IN NUMBER,
5221: p_phase_change_flag IN VARCHAR2,
5222: p_num_lines IN NUMBER,
5223: x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type)
5224: IS
5225: i binary_integer := 1;
5226: j binary_integer := 1;
5227: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 5230: l_line_rec OE_Order_PUB.Line_Rec_Type;

5226: j binary_integer := 1;
5227: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5228: l_line_id T_NUM := T_NUM();
5229: l_source T_V1 := T_V1();
5230: l_line_rec OE_Order_PUB.Line_Rec_Type;
5231: CURSOR C_MODEL IS
5232: SELECT line_id
5233: FROM OE_COPY_LINE_SORT_TMP
5234: WHERE top_model_line_id = line_id;

Line 5683: (p_ref_line_rec IN OE_Order_PUB.Line_Rec_Type,

5679: END sort_line_tbl;
5680:
5681:
5682: PROCEDURE copy_line_dff_from_ref
5683: (p_ref_line_rec IN OE_Order_PUB.Line_Rec_Type,
5684: p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type)
5685: IS
5686: BEGIN
5687: p_x_line_rec.context := p_ref_line_rec.context;

Line 5684: p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type)

5680:
5681:
5682: PROCEDURE copy_line_dff_from_ref
5683: (p_ref_line_rec IN OE_Order_PUB.Line_Rec_Type,
5684: p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type)
5685: IS
5686: BEGIN
5687: p_x_line_rec.context := p_ref_line_rec.context;
5688: p_x_line_rec.attribute1 := p_ref_line_rec.attribute1;

Line 5806: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type,

5802:
5803: PROCEDURE COPY_LINE_SETS(
5804: p_old_header_id IN NUMBER,
5805: p_new_header_id IN NUMBER,
5806: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type,
5807: p_copy_fulfillment_sets IN BOOLEAN,
5808: p_copy_ship_arr_sets IN BOOLEAN,
5809: x_result OUT NOCOPY VARCHAR2)
5810: IS