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:
37: --Added for bug 9004082
38:

Line 39: FUNCTION Only_Model(l_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type,

35:
36:
37: --Added for bug 9004082
38:
39: FUNCTION Only_Model(l_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type,
40: model_line_id IN NUMBER) RETURN BOOLEAN;
41:
42:
43:

Line 44: FUNCTION Only_Model(l_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type,

40: model_line_id IN NUMBER) RETURN BOOLEAN;
41:
42:
43:
44: FUNCTION Only_Model(l_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type,
45: model_line_id IN NUMBER) RETURN BOOLEAN
46: IS
47: l_only_model BOOLEAN :=TRUE;
48: k NUMBER;

Line 120: (p_line_tbl IN OE_Order_PUB.Line_Tbl_type,

116:
117: END Get_copy_rec;
118:
119: Function Find_LineIndex
120: (p_line_tbl IN OE_Order_PUB.Line_Tbl_type,
121: p_line_id IN NUMBER
122: )
123: Return Number
124: IS

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

415:
416: Procedure Copy_Header
417: ( p_header_id IN NUMBER
418: ,p_copy_rec IN copy_rec_type
419: ,x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type)
420: IS
421: l_api_name CONSTANT VARCHAR(30) := 'Copy_Header';
422: l_orig_category VARCHAR2(30);
423: l_cpy_category VARCHAR2(30);

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

847: PROCEDURE Load_and_Init_Hdr_Scredits
848: (p_header_Id IN Number
849: ,p_version_number IN NUMBER
850: ,p_phase_change_flag IN VARCHAR2
851: ,x_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Tbl_Type)
852: IS
853: l_api_name CONSTANT VARCHAR(30) := 'Load_and_Init_Hdr_Scredits';
854: --
855: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 936: ,p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type)

932: Function Load_and_Init_Hdr_Holds
933: (p_header_Id IN Number
934: ,p_version_number IN NUMBER
935: ,p_phase_change_flag IN VARCHAR2
936: ,p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type)
937: Return OE_Order_PUB.Request_Tbl_Type
938: IS
939: l_api_name CONSTANT VARCHAR(30) := 'Load_and_Init_Hdr_Holds';
940: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;

Line 937: Return OE_Order_PUB.Request_Tbl_Type

933: (p_header_Id IN Number
934: ,p_version_number IN NUMBER
935: ,p_phase_change_flag IN VARCHAR2
936: ,p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type)
937: Return OE_Order_PUB.Request_Tbl_Type
938: IS
939: l_api_name CONSTANT VARCHAR(30) := 'Load_and_Init_Hdr_Holds';
940: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
941: k NUMBER := 1;

Line 940: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;

936: ,p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type)
937: Return OE_Order_PUB.Request_Tbl_Type
938: IS
939: l_api_name CONSTANT VARCHAR(30) := 'Load_and_Init_Hdr_Holds';
940: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
941: k NUMBER := 1;
942: l_hold_source_tbl OE_Hold_Sources_PVT.Hold_Source_TBL;
943: l_return_status VARCHAR2(1);
944: l_v_number NUMBER;

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

1075:
1076: -- Added for multiple payments
1077: PROCEDURE Load_and_Init_Hdr_Payments
1078: (p_header_Id IN Number
1079: ,x_Header_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Header_Payment_Tbl_Type)
1080: IS
1081: k pls_integer;
1082:
1083: --R12 CC Encryption

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

1181: -- This function loads Line based holds into the action request table.
1182: PROCEDURE Load_and_Init_line_Holds
1183: (p_line_Id IN Number
1184: ,p_new_line_id IN Number
1185: ,p_action_request_tbl IN OUT NOCOPY OE_Order_PUB.Request_Tbl_Type)
1186: IS
1187: l_api_name CONSTANT VARCHAR(30) := 'Load_and_Init_Line_Holds';
1188: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1189: k NUMBER := 1;

Line 1188: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;

1184: ,p_new_line_id IN Number
1185: ,p_action_request_tbl IN OUT NOCOPY OE_Order_PUB.Request_Tbl_Type)
1186: IS
1187: l_api_name CONSTANT VARCHAR(30) := 'Load_and_Init_Line_Holds';
1188: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1189: k NUMBER := 1;
1190: l_hold_source_tbl OE_Hold_Sources_PVT.Hold_Source_TBL;
1191: l_return_status VARCHAR2(1);
1192:

Line 1311: ( p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type

1307: -- Delete Class items always.
1308: -- This functions also deletes fully cancelled lines based on the flag.
1309:
1310: Procedure Handle_Return_Lines
1311: ( p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
1312: ,p_incl_cancelled IN VARCHAR2
1313: )
1314: IS
1315: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 1315: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

1311: ( p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
1312: ,p_incl_cancelled IN VARCHAR2
1313: )
1314: IS
1315: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1316: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
1317: l_api_name CONSTANT VARCHAR2(30) := 'Handle_Return_Lines';
1318: l_top_model_index NUMBER;
1319: k NUMBER;

Line 1316: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;

1312: ,p_incl_cancelled IN VARCHAR2
1313: )
1314: IS
1315: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1316: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
1317: l_api_name CONSTANT VARCHAR2(30) := 'Handle_Return_Lines';
1318: l_top_model_index NUMBER;
1319: k NUMBER;
1320: j NUMBER := 1;

Line 1464: ( p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type

1460: --For bug 3923574, we added new parameter x_top_model_tbl to mark the
1461: -- has_canceled_flag on the model.
1462:
1463: Procedure Handle_NonStandard_Lines
1464: ( p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
1465: ,p_incl_cancelled IN VARCHAR2
1466: ,x_top_model_tbl IN OUT NOCOPY Top_Model_Tbl_Type
1467: )
1468: IS

Line 1469: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

1465: ,p_incl_cancelled IN VARCHAR2
1466: ,x_top_model_tbl IN OUT NOCOPY Top_Model_Tbl_Type
1467: )
1468: IS
1469: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1470: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
1471: l_api_name CONSTANT VARCHAR2(30) := 'Handle_NonStandard_Lines';
1472: l_top_model_index NUMBER;
1473: l_link_to_index NUMBER;

Line 1470: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;

1466: ,x_top_model_tbl IN OUT NOCOPY Top_Model_Tbl_Type
1467: )
1468: IS
1469: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1470: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
1471: l_api_name CONSTANT VARCHAR2(30) := 'Handle_NonStandard_Lines';
1472: l_top_model_index NUMBER;
1473: l_link_to_index NUMBER;
1474: l_service_index NUMBER;

Line 1932: ,x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type

1928: ,p_hdr_type_id IN NUMBER
1929: ,p_line_type_id IN NUMBER
1930: ,p_version_number IN NUMBER
1931: ,p_phase_change_flag IN VARCHAR2
1932: ,x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
1933: /* Added the following line to fix the bug 1923460 */
1934: ,x_top_model_tbl IN OUT NOCOPY Top_Model_Tbl_Type
1935: )
1936: IS

Line 1941: l_line_rec OE_Order_PUB.Line_Rec_Type;

1937: l_top_model_index NUMBER;
1938: l_line_id OE_Order_LINES.Line_id%Type;
1939: l_cpy_category VARCHAR2(30);
1940: l_line_category VARCHAR2(30);
1941: l_line_rec OE_Order_PUB.Line_Rec_Type;
1942:
1943: l_api_name CONSTANT VARCHAR(30) := 'Load_Lines';
1944:
1945: /* Start - Code added for the bug 1923460 */

Line 2287: p_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type)

2283:
2284: End Load_Lines;
2285:
2286: procedure Clear_Missing_Attributes(
2287: p_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type)
2288: IS
2289: --
2290: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2291: --

Line 2473: ( p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type

2469:
2470: END Clear_Missing_Attributes;
2471:
2472: Procedure Init_Lines_New
2473: ( p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
2474: ,p_x_top_model_tbl IN OUT NOCOPY Top_Model_Tbl_Type
2475: ,p_line_type IN NUMBER
2476: ,p_header_id IN NUMBER
2477: ,p_line_price_mode IN NUMBER

Line 2486: ,p_action_request_tbl IN OUT NOCOPY OE_Order_PUB.Request_Tbl_Type

2482: ,p_default_null_values IN VARCHAR2
2483: ,p_reason_code IN VARCHAR2
2484: ,p_comments IN VARCHAR2
2485: ,p_copy_rec IN COPY_REC_TYPE
2486: ,p_action_request_tbl IN OUT NOCOPY OE_Order_PUB.Request_Tbl_Type
2487: )
2488: IS
2489: l_api_name CONSTANT VARCHAR2(30) := 'Init_Lines_New';
2490: l_temp_line_rec OE_ORDER_PUB.Line_Rec_Type;

Line 2490: l_temp_line_rec OE_ORDER_PUB.Line_Rec_Type;

2486: ,p_action_request_tbl IN OUT NOCOPY OE_Order_PUB.Request_Tbl_Type
2487: )
2488: IS
2489: l_api_name CONSTANT VARCHAR2(30) := 'Init_Lines_New';
2490: l_temp_line_rec OE_ORDER_PUB.Line_Rec_Type;
2491: l_orig_line_category VARCHAR2(30);
2492: l_cpy_line_category VARCHAR2(30);
2493: l_order_number NUMBER;
2494: l_order_type_id NUMBER;

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

3073: G_REGULAR_TO_RMA := TRUE;
3074: -- Process order will fill all remaining columns for the line,
3075: -- when it is copied from reg to return.
3076:
3077: p_x_line_tbl(k) := OE_Order_PUB.G_MISS_LINE_REC;
3078: p_x_line_tbl(k).line_type_id :=
3079: nvl(p_line_type,l_temp_line_rec.line_type_id);
3080: p_x_line_tbl(k).return_reason_code := p_return_reason_code;
3081:

Line 3326: (p_line_tbl IN OE_Order_PUB.Line_Tbl_type

3322:
3323: END Init_Lines_New;
3324:
3325: Procedure Load_and_Init_Line_Scredits
3326: (p_line_tbl IN OE_Order_PUB.Line_Tbl_type
3327: ,p_version_number IN NUMBER
3328: ,p_phase_change_flag IN VARCHAR2
3329: ,x_Line_Scredit_Tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type )
3330: IS

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

3325: Procedure Load_and_Init_Line_Scredits
3326: (p_line_tbl IN OE_Order_PUB.Line_Tbl_type
3327: ,p_version_number IN NUMBER
3328: ,p_phase_change_flag IN VARCHAR2
3329: ,x_Line_Scredit_Tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type )
3330: IS
3331:
3332: l_line_id NUMBER;
3333: I NUMBER := 1;

Line 3334: l_sub_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

3330: IS
3331:
3332: l_line_id NUMBER;
3333: I NUMBER := 1;
3334: l_sub_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3335: l_api_name CONSTANT VARCHAR(30) := 'Load_and_Init_Line_Scredits';
3336: K NUMBER; -- Used as loop index.
3337: --
3338: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 3442: (p_line_tbl IN OE_Order_PUB.Line_Tbl_type

3438: END Load_and_Init_Line_Scredits;
3439:
3440: -- Added for multiple payments
3441: PROCEDURE Load_and_Init_Line_Payments
3442: (p_line_tbl IN OE_Order_PUB.Line_Tbl_type
3443: ,p_line_type IN NUMBER
3444: ,x_Line_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Line_Payment_Tbl_Type)
3445: IS
3446:

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

3440: -- Added for multiple payments
3441: PROCEDURE Load_and_Init_Line_Payments
3442: (p_line_tbl IN OE_Order_PUB.Line_Tbl_type
3443: ,p_line_type IN NUMBER
3444: ,x_Line_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Line_Payment_Tbl_Type)
3445: IS
3446:
3447: l_sub_payment_tbl OE_Order_PUB.Line_payment_Tbl_Type;
3448: l_line_id NUMBER;

Line 3447: l_sub_payment_tbl OE_Order_PUB.Line_payment_Tbl_Type;

3443: ,p_line_type IN NUMBER
3444: ,x_Line_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Line_Payment_Tbl_Type)
3445: IS
3446:
3447: l_sub_payment_tbl OE_Order_PUB.Line_payment_Tbl_Type;
3448: l_line_id NUMBER;
3449: k NUMBER;
3450: I NUMBER := 1;
3451: l_line_category VARCHAR2(30);

Line 3727: l_header_rec OE_Order_PUB.Header_Rec_Type;

3723: l NUMBER; -- Used as loop index.
3724: k NUMBER; -- Used as loop index.
3725: j NUMBER; -- Used as loop index.
3726:
3727: l_header_rec OE_Order_PUB.Header_Rec_Type;
3728: l_control_rec OE_GLOBALS.Control_Rec_Type;
3729: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
3730: /* Added the following line to fix the bug 1923460 */
3731: l_top_model_tbl top_model_tbl_type;

Line 3729: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

3725: j NUMBER; -- Used as loop index.
3726:
3727: l_header_rec OE_Order_PUB.Header_Rec_Type;
3728: l_control_rec OE_GLOBALS.Control_Rec_Type;
3729: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
3730: /* Added the following line to fix the bug 1923460 */
3731: l_top_model_tbl top_model_tbl_type;
3732: l_line_final_tbl OE_Order_PUB.Line_Tbl_Type;
3733: l_header_out_rec OE_Order_PUB.Header_Rec_Type;

Line 3732: l_line_final_tbl OE_Order_PUB.Line_Tbl_Type;

3728: l_control_rec OE_GLOBALS.Control_Rec_Type;
3729: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
3730: /* Added the following line to fix the bug 1923460 */
3731: l_top_model_tbl top_model_tbl_type;
3732: l_line_final_tbl OE_Order_PUB.Line_Tbl_Type;
3733: l_header_out_rec OE_Order_PUB.Header_Rec_Type;
3734: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
3735: l_line_rec OE_Order_PUB.Line_Rec_Type;
3736: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 3733: l_header_out_rec OE_Order_PUB.Header_Rec_Type;

3729: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
3730: /* Added the following line to fix the bug 1923460 */
3731: l_top_model_tbl top_model_tbl_type;
3732: l_line_final_tbl OE_Order_PUB.Line_Tbl_Type;
3733: l_header_out_rec OE_Order_PUB.Header_Rec_Type;
3734: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
3735: l_line_rec OE_Order_PUB.Line_Rec_Type;
3736: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3737: l_header_price_att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 3734: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;

3730: /* Added the following line to fix the bug 1923460 */
3731: l_top_model_tbl top_model_tbl_type;
3732: l_line_final_tbl OE_Order_PUB.Line_Tbl_Type;
3733: l_header_out_rec OE_Order_PUB.Header_Rec_Type;
3734: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
3735: l_line_rec OE_Order_PUB.Line_Rec_Type;
3736: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3737: l_header_price_att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3738: l_header_Adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 3735: l_line_rec OE_Order_PUB.Line_Rec_Type;

3731: l_top_model_tbl top_model_tbl_type;
3732: l_line_final_tbl OE_Order_PUB.Line_Tbl_Type;
3733: l_header_out_rec OE_Order_PUB.Header_Rec_Type;
3734: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
3735: l_line_rec OE_Order_PUB.Line_Rec_Type;
3736: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3737: l_header_price_att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3738: l_header_Adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3739: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

Line 3736: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

3732: l_line_final_tbl OE_Order_PUB.Line_Tbl_Type;
3733: l_header_out_rec OE_Order_PUB.Header_Rec_Type;
3734: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
3735: l_line_rec OE_Order_PUB.Line_Rec_Type;
3736: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3737: l_header_price_att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3738: l_header_Adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3739: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3740: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 3737: l_header_price_att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

3733: l_header_out_rec OE_Order_PUB.Header_Rec_Type;
3734: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
3735: l_line_rec OE_Order_PUB.Line_Rec_Type;
3736: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3737: l_header_price_att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3738: l_header_Adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3739: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3740: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3741: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 3738: l_header_Adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

3734: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
3735: l_line_rec OE_Order_PUB.Line_Rec_Type;
3736: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3737: l_header_price_att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3738: l_header_Adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3739: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3740: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3741: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3742: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 3739: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

3735: l_line_rec OE_Order_PUB.Line_Rec_Type;
3736: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3737: l_header_price_att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3738: l_header_Adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3739: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3740: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3741: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3742: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3743: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 3740: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

3736: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3737: l_header_price_att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3738: l_header_Adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3739: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3740: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3741: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3742: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3743: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3744: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 3741: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

3737: l_header_price_att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3738: l_header_Adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3739: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3740: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3741: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3742: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3743: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3744: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3745: l_line_Adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 3742: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

3738: l_header_Adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3739: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3740: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3741: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3742: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3743: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3744: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3745: l_line_Adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3746: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 3743: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

3739: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3740: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3741: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3742: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3743: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3744: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3745: l_line_Adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3746: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3747: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 3744: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

3740: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3741: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3742: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3743: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3744: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3745: l_line_Adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3746: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3747: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3748: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 3745: l_line_Adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

3741: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3742: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3743: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3744: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3745: l_line_Adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3746: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3747: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3748: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3749: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 3746: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

3742: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3743: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3744: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3745: l_line_Adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3746: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3747: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3748: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3749: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3750: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 3747: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

3743: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3744: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3745: l_line_Adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3746: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3747: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3748: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3749: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3750: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3751: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;

Line 3748: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

3744: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3745: l_line_Adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3746: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3747: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3748: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3749: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3750: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3751: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
3752: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;

Line 3749: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

3745: l_line_Adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3746: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3747: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3748: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3749: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3750: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3751: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
3752: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
3753:

Line 3750: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

3746: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3747: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3748: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3749: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3750: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3751: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
3752: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
3753:
3754: l_header_exists BOOLEAN; -- variables added for bug 1935675

Line 3751: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;

3747: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3748: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3749: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3750: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3751: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
3752: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
3753:
3754: l_header_exists BOOLEAN; -- variables added for bug 1935675
3755: l_copy_partial_or_full BOOLEAN := FALSE;

Line 3752: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;

3748: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3749: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3750: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3751: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
3752: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
3753:
3754: l_header_exists BOOLEAN; -- variables added for bug 1935675
3755: l_copy_partial_or_full BOOLEAN := FALSE;
3756: l_all_lines_copied BOOLEAN;

Line 3771: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

3767: l_copy_header_id NUMBER;
3768: l_temp_var VARCHAR2(2000) := NULL;
3769: l_copy_rec COPY_REC_TYPE;
3770: --serla begin
3771: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3772: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3773: --serla end
3774:
3775: --R12 CC Encryption

Line 3772: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

3768: l_temp_var VARCHAR2(2000) := NULL;
3769: l_copy_rec COPY_REC_TYPE;
3770: --serla begin
3771: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3772: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3773: --serla end
3774:
3775: --R12 CC Encryption
3776: l_cpy_category VARCHAR2(30);

Line 5394: x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type)

5390: PROCEDURE sort_line_tbl(p_line_id_tbl IN OE_GLOBALS.Selected_Record_Tbl,
5391: p_version_number IN NUMBER,
5392: p_phase_change_flag IN VARCHAR2,
5393: p_num_lines IN NUMBER,
5394: x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type)
5395: IS
5396: i binary_integer := 1;
5397: j binary_integer := 1;
5398: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 5401: l_line_rec OE_Order_PUB.Line_Rec_Type;

5397: j binary_integer := 1;
5398: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5399: l_line_id T_NUM := T_NUM();
5400: l_source T_V1 := T_V1();
5401: l_line_rec OE_Order_PUB.Line_Rec_Type;
5402: CURSOR C_MODEL IS
5403: SELECT line_id
5404: FROM OE_COPY_LINE_SORT_TMP
5405: WHERE top_model_line_id = line_id;

Line 5854: (p_ref_line_rec IN OE_Order_PUB.Line_Rec_Type,

5850: END sort_line_tbl;
5851:
5852:
5853: PROCEDURE copy_line_dff_from_ref
5854: (p_ref_line_rec IN OE_Order_PUB.Line_Rec_Type,
5855: p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type)
5856: IS
5857: BEGIN
5858: p_x_line_rec.context := p_ref_line_rec.context;

Line 5855: p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type)

5851:
5852:
5853: PROCEDURE copy_line_dff_from_ref
5854: (p_ref_line_rec IN OE_Order_PUB.Line_Rec_Type,
5855: p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type)
5856: IS
5857: BEGIN
5858: p_x_line_rec.context := p_ref_line_rec.context;
5859: p_x_line_rec.attribute1 := p_ref_line_rec.attribute1;

Line 5998: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type,

5994:
5995: PROCEDURE COPY_LINE_SETS(
5996: p_old_header_id IN NUMBER,
5997: p_new_header_id IN NUMBER,
5998: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type,
5999: p_copy_fulfillment_sets IN BOOLEAN,
6000: p_copy_ship_arr_sets IN BOOLEAN,
6001: x_result OUT NOCOPY VARCHAR2)
6002: IS