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_CONFIG_PVT dependencies on OE_ORDER_PUB

Line 29: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type

25: ,x_cancellation OUT NOCOPY /* file.sql.39 change */ BOOLEAN
26: ,x_current_quantity OUT NOCOPY /* file.sql.39 change */ NUMBER);
27:
28: PROCEDURE Handle_Inserts
29: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type
30: ,p_config_hdr_id IN NUMBER
31: ,p_config_rev_nbr IN NUMBER
32: ,p_config_instance_tbl IN csi_datastructures_pub.instance_cz_tbl
33: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type

Line 33: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type

29: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type
30: ,p_config_hdr_id IN NUMBER
31: ,p_config_rev_nbr IN NUMBER
32: ,p_config_instance_tbl IN csi_datastructures_pub.instance_cz_tbl
33: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
34: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
35: ,p_direct_save IN BOOLEAN := FALSE
36: ,p_ui_flag IN VARCHAR2 := 'Y');
37:

Line 34: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type

30: ,p_config_hdr_id IN NUMBER
31: ,p_config_rev_nbr IN NUMBER
32: ,p_config_instance_tbl IN csi_datastructures_pub.instance_cz_tbl
33: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
34: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
35: ,p_direct_save IN BOOLEAN := FALSE
36: ,p_ui_flag IN VARCHAR2 := 'Y');
37:
38: PROCEDURE Handle_Inserts_Old

Line 39: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type

35: ,p_direct_save IN BOOLEAN := FALSE
36: ,p_ui_flag IN VARCHAR2 := 'Y');
37:
38: PROCEDURE Handle_Inserts_Old
39: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type
40: ,p_config_hdr_id IN NUMBER
41: ,p_config_rev_nbr IN NUMBER
42: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
43: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type

Line 42: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type

38: PROCEDURE Handle_Inserts_Old
39: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type
40: ,p_config_hdr_id IN NUMBER
41: ,p_config_rev_nbr IN NUMBER
42: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
43: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
44: ,p_direct_save IN BOOLEAN := FALSE);
45:
46: PROCEDURE Handle_Updates

Line 43: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type

39: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type
40: ,p_config_hdr_id IN NUMBER
41: ,p_config_rev_nbr IN NUMBER
42: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
43: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
44: ,p_direct_save IN BOOLEAN := FALSE);
45:
46: PROCEDURE Handle_Updates
47: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type

Line 47: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type

43: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
44: ,p_direct_save IN BOOLEAN := FALSE);
45:
46: PROCEDURE Handle_Updates
47: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type
48: ,p_config_hdr_id IN NUMBER
49: ,p_config_rev_nbr IN NUMBER
50: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
51: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type

Line 50: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type

46: PROCEDURE Handle_Updates
47: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type
48: ,p_config_hdr_id IN NUMBER
49: ,p_config_rev_nbr IN NUMBER
50: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
51: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
52: ,p_direct_save IN BOOLEAN := FALSE
53: ,p_ui_flag IN VARCHAR2);
54:

Line 51: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type

47: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type
48: ,p_config_hdr_id IN NUMBER
49: ,p_config_rev_nbr IN NUMBER
50: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
51: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
52: ,p_direct_save IN BOOLEAN := FALSE
53: ,p_ui_flag IN VARCHAR2);
54:
55: PROCEDURE Handle_Updates_old

Line 56: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type

52: ,p_direct_save IN BOOLEAN := FALSE
53: ,p_ui_flag IN VARCHAR2);
54:
55: PROCEDURE Handle_Updates_old
56: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type
57: ,p_config_hdr_id IN NUMBER
58: ,p_config_rev_nbr IN NUMBER
59: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
60: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type

Line 59: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type

55: PROCEDURE Handle_Updates_old
56: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type
57: ,p_config_hdr_id IN NUMBER
58: ,p_config_rev_nbr IN NUMBER
59: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
60: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
61: ,p_direct_save IN BOOLEAN := FALSE
62: ,p_ui_flag IN VARCHAR2);
63:

Line 60: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type

56: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type
57: ,p_config_hdr_id IN NUMBER
58: ,p_config_rev_nbr IN NUMBER
59: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
60: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
61: ,p_direct_save IN BOOLEAN := FALSE
62: ,p_ui_flag IN VARCHAR2);
63:
64: PROCEDURE Handle_Deletes

Line 65: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type

61: ,p_direct_save IN BOOLEAN := FALSE
62: ,p_ui_flag IN VARCHAR2);
63:
64: PROCEDURE Handle_Deletes
65: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type
66: ,p_config_hdr_id IN NUMBER
67: ,p_config_rev_nbr IN NUMBER
68: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
69: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type

Line 68: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type

64: PROCEDURE Handle_Deletes
65: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type
66: ,p_config_hdr_id IN NUMBER
67: ,p_config_rev_nbr IN NUMBER
68: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
69: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
70: ,p_direct_save IN BOOLEAN := FALSE
71: ,p_ui_flag IN VARCHAR2);
72:

Line 69: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type

65: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type
66: ,p_config_hdr_id IN NUMBER
67: ,p_config_rev_nbr IN NUMBER
68: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
69: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
70: ,p_direct_save IN BOOLEAN := FALSE
71: ,p_ui_flag IN VARCHAR2);
72:
73: PROCEDURE Handle_Deletes_Old

Line 74: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type

70: ,p_direct_save IN BOOLEAN := FALSE
71: ,p_ui_flag IN VARCHAR2);
72:
73: PROCEDURE Handle_Deletes_Old
74: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type
75: ,p_config_hdr_id IN NUMBER
76: ,p_config_rev_nbr IN NUMBER
77: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
78: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type

Line 77: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type

73: PROCEDURE Handle_Deletes_Old
74: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type
75: ,p_config_hdr_id IN NUMBER
76: ,p_config_rev_nbr IN NUMBER
77: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
78: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
79: ,p_direct_save IN BOOLEAN := FALSE
80: ,p_ui_flag IN VARCHAR2);
81:

Line 78: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type

74: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type
75: ,p_config_hdr_id IN NUMBER
76: ,p_config_rev_nbr IN NUMBER
77: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
78: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
79: ,p_direct_save IN BOOLEAN := FALSE
80: ,p_ui_flag IN VARCHAR2);
81:
82: PROCEDURE Print_Time(p_msg IN VARCHAR2);

Line 145: l_model_line_rec OE_ORDER_PUB.Line_Rec_Type;

141:
142: -- general, column_changes and and cz's delete api stuff
143: l_direct_save BOOLEAN;
144: l_return_status_del VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
145: l_model_line_rec OE_ORDER_PUB.Line_Rec_Type;
146: l_profile_value VARCHAR2(1) :=
147: upper(FND_PROFILE.VALUE('ONT_CONFIG_QUICK_SAVE'));
148:
149: -- process_order in params

Line 151: l_header_rec OE_Order_PUB.Header_Rec_Type;

147: upper(FND_PROFILE.VALUE('ONT_CONFIG_QUICK_SAVE'));
148:
149: -- process_order in params
150: l_control_rec OE_GLOBALS.Control_Rec_Type;
151: l_header_rec OE_Order_PUB.Header_Rec_Type;
152: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
153: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
154: l_class_line_tbl OE_Order_PUB.Line_Tbl_Type;
155: l_operation VARCHAR2(1) := 'A';

Line 152: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

148:
149: -- process_order in params
150: l_control_rec OE_GLOBALS.Control_Rec_Type;
151: l_header_rec OE_Order_PUB.Header_Rec_Type;
152: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
153: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
154: l_class_line_tbl OE_Order_PUB.Line_Tbl_Type;
155: l_operation VARCHAR2(1) := 'A';
156: l_msg_count NUMBER;

Line 153: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

149: -- process_order in params
150: l_control_rec OE_GLOBALS.Control_Rec_Type;
151: l_header_rec OE_Order_PUB.Header_Rec_Type;
152: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
153: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
154: l_class_line_tbl OE_Order_PUB.Line_Tbl_Type;
155: l_operation VARCHAR2(1) := 'A';
156: l_msg_count NUMBER;
157: l_msg_data VARCHAR2(2000);

Line 154: l_class_line_tbl OE_Order_PUB.Line_Tbl_Type;

150: l_control_rec OE_GLOBALS.Control_Rec_Type;
151: l_header_rec OE_Order_PUB.Header_Rec_Type;
152: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
153: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
154: l_class_line_tbl OE_Order_PUB.Line_Tbl_Type;
155: l_operation VARCHAR2(1) := 'A';
156: l_msg_count NUMBER;
157: l_msg_data VARCHAR2(2000);
158: l_return_status VARCHAR2(1);

Line 440: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type

436: top model and child lines
437: -------------------------------------------------------------------*/
438:
439: PROCEDURE Handle_Inserts
440: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type
441: ,p_config_hdr_id IN NUMBER
442: ,p_config_rev_nbr IN NUMBER
443: ,p_config_instance_tbl IN csi_datastructures_pub.instance_cz_tbl
444: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type

Line 444: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type

440: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type
441: ,p_config_hdr_id IN NUMBER
442: ,p_config_rev_nbr IN NUMBER
443: ,p_config_instance_tbl IN csi_datastructures_pub.instance_cz_tbl
444: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
445: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
446: ,p_direct_save IN BOOLEAN := FALSE
447: ,p_ui_flag IN VARCHAR2 := 'Y')
448: IS

Line 445: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type

441: ,p_config_hdr_id IN NUMBER
442: ,p_config_rev_nbr IN NUMBER
443: ,p_config_instance_tbl IN csi_datastructures_pub.instance_cz_tbl
444: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
445: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
446: ,p_direct_save IN BOOLEAN := FALSE
447: ,p_ui_flag IN VARCHAR2 := 'Y')
448: IS
449:

Line 470: l_line_rec OE_ORDER_PUB.Line_Rec_Type;

466: AND l.open_flag = 'Y')
467: ORDER BY c.component_code;
468:
469:
470: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
471: l_class_line_rec OE_ORDER_PUB.Line_Rec_Type;
472: l_line_count NUMBER;
473: l_class_line_count NUMBER;
474: l_return_status VARCHAR2(1);

Line 471: l_class_line_rec OE_ORDER_PUB.Line_Rec_Type;

467: ORDER BY c.component_code;
468:
469:
470: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
471: l_class_line_rec OE_ORDER_PUB.Line_Rec_Type;
472: l_line_count NUMBER;
473: l_class_line_count NUMBER;
474: l_return_status VARCHAR2(1);
475: l_concatenated_segments VARCHAR2(163);

Line 576: l_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;

572:
573: l_line_count := nvl(p_x_line_tbl.LAST, 0);
574: l_class_line_count := nvl(p_x_class_line_tbl.LAST, 0);
575:
576: l_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;
577: l_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;
578: l_line_rec.header_id := p_model_line_rec.header_id;
579: l_line_rec.item_identifier_type := 'INT';
580: l_line_rec.config_header_id := p_config_hdr_id;

Line 812: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type

808: variable l_default_child_line has been created.
809: -------------------------------------------------------------*/
810:
811: PROCEDURE Handle_Inserts_Old
812: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type
813: ,p_config_hdr_id IN NUMBER
814: ,p_config_rev_nbr IN NUMBER
815: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
816: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type

Line 815: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type

811: PROCEDURE Handle_Inserts_Old
812: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type
813: ,p_config_hdr_id IN NUMBER
814: ,p_config_rev_nbr IN NUMBER
815: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
816: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
817: ,p_direct_save IN BOOLEAN := FALSE)
818: IS
819:

Line 816: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type

812: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type
813: ,p_config_hdr_id IN NUMBER
814: ,p_config_rev_nbr IN NUMBER
815: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
816: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
817: ,p_direct_save IN BOOLEAN := FALSE)
818: IS
819:
820: CURSOR config_ins_cursor IS

Line 836: l_line_rec OE_ORDER_PUB.Line_Rec_Type;

832: AND l.component_code = c.component_code
833: AND l.open_flag = 'Y')
834: ORDER BY c.component_code;
835:
836: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
837: l_class_line_rec OE_ORDER_PUB.Line_Rec_Type;
838: l_line_count NUMBER;
839: l_class_line_count NUMBER;
840: l_return_status VARCHAR2(1);

Line 837: l_class_line_rec OE_ORDER_PUB.Line_Rec_Type;

833: AND l.open_flag = 'Y')
834: ORDER BY c.component_code;
835:
836: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
837: l_class_line_rec OE_ORDER_PUB.Line_Rec_Type;
838: l_line_count NUMBER;
839: l_class_line_count NUMBER;
840: l_return_status VARCHAR2(1);
841: l_concatenated_segments VARCHAR2(163);

Line 852: l_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;

848:
849: l_line_count := nvl(p_x_line_tbl.LAST, 0);
850: l_class_line_count := nvl(p_x_class_line_tbl.LAST, 0);
851:
852: l_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;
853: l_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;
854: l_line_rec.header_id := p_model_line_rec.header_id;
855: l_line_rec.item_identifier_type := 'INT';
856:

Line 975: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type

971: the selected value from cz
972: ------------------------------------------------------------*/
973:
974: PROCEDURE Handle_Updates
975: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type
976: ,p_config_hdr_id IN NUMBER
977: ,p_config_rev_nbr IN NUMBER
978: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
979: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type

Line 978: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type

974: PROCEDURE Handle_Updates
975: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type
976: ,p_config_hdr_id IN NUMBER
977: ,p_config_rev_nbr IN NUMBER
978: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
979: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
980: ,p_direct_save IN BOOLEAN := FALSE
981: ,p_ui_flag IN VARCHAR2)
982: IS

Line 979: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type

975: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type
976: ,p_config_hdr_id IN NUMBER
977: ,p_config_rev_nbr IN NUMBER
978: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
979: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
980: ,p_direct_save IN BOOLEAN := FALSE
981: ,p_ui_flag IN VARCHAR2)
982: IS
983: CURSOR config_upd_cursor IS

Line 1003: l_line_rec OE_ORDER_PUB.Line_Rec_Type;

999: AND l.component_code = c.component_code
1000: AND l.configuration_id = c.config_item_id
1001: AND l.open_flag = 'Y';
1002:
1003: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
1004: l_class_line_rec OE_ORDER_PUB.Line_Rec_Type;
1005: l_line_count NUMBER;
1006: l_class_line_count NUMBER;
1007: --

Line 1004: l_class_line_rec OE_ORDER_PUB.Line_Rec_Type;

1000: AND l.configuration_id = c.config_item_id
1001: AND l.open_flag = 'Y';
1002:
1003: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
1004: l_class_line_rec OE_ORDER_PUB.Line_Rec_Type;
1005: l_line_count NUMBER;
1006: l_class_line_count NUMBER;
1007: --
1008: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1038: l_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;

1034:
1035: l_line_count := nvl(p_x_line_tbl.LAST, 0);
1036: l_class_line_count := nvl(p_x_class_line_tbl.LAST, 0);
1037:
1038: l_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;
1039: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1040: l_line_rec.top_model_line_id := p_model_line_rec.line_id;
1041:
1042:

Line 1110: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type

1106: we should fail.
1107: ------------------------------------------------------------*/
1108:
1109: PROCEDURE Handle_Updates_Old
1110: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type
1111: ,p_config_hdr_id IN NUMBER
1112: ,p_config_rev_nbr IN NUMBER
1113: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
1114: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type

Line 1113: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type

1109: PROCEDURE Handle_Updates_Old
1110: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type
1111: ,p_config_hdr_id IN NUMBER
1112: ,p_config_rev_nbr IN NUMBER
1113: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
1114: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
1115: ,p_direct_save IN BOOLEAN := FALSE
1116: ,p_ui_flag IN VARCHAR2)
1117: IS

Line 1114: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type

1110: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type
1111: ,p_config_hdr_id IN NUMBER
1112: ,p_config_rev_nbr IN NUMBER
1113: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
1114: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
1115: ,p_direct_save IN BOOLEAN := FALSE
1116: ,p_ui_flag IN VARCHAR2)
1117: IS
1118: CURSOR config_upd_cursor IS

Line 1133: l_line_rec OE_ORDER_PUB.Line_Rec_Type;

1129: AND l.top_model_line_id = p_model_line_rec.line_id
1130: AND l.component_code = c.component_code
1131: AND l.open_flag = 'Y';
1132:
1133: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
1134: l_class_line_rec OE_ORDER_PUB.Line_Rec_Type;
1135: l_line_count NUMBER;
1136: l_class_line_count NUMBER;
1137: --

Line 1134: l_class_line_rec OE_ORDER_PUB.Line_Rec_Type;

1130: AND l.component_code = c.component_code
1131: AND l.open_flag = 'Y';
1132:
1133: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
1134: l_class_line_rec OE_ORDER_PUB.Line_Rec_Type;
1135: l_line_count NUMBER;
1136: l_class_line_count NUMBER;
1137: --
1138: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1146: l_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;

1142:
1143: l_line_count := nvl(p_x_line_tbl.LAST, 0);
1144: l_class_line_count := nvl(p_x_class_line_tbl.LAST, 0);
1145:
1146: l_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;
1147: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1148: l_line_rec.top_model_line_id := p_model_line_rec.line_id;
1149:
1150:

Line 1215: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type

1211: oe_order_lines.
1212: ----------------------------------------------------------*/
1213:
1214: PROCEDURE Handle_Deletes
1215: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type
1216: ,p_config_hdr_id IN NUMBER
1217: ,p_config_rev_nbr IN NUMBER
1218: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
1219: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type

Line 1218: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type

1214: PROCEDURE Handle_Deletes
1215: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type
1216: ,p_config_hdr_id IN NUMBER
1217: ,p_config_rev_nbr IN NUMBER
1218: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
1219: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
1220: ,p_direct_save IN BOOLEAN := FALSE
1221: ,p_ui_flag IN VARCHAR2)
1222: IS

Line 1219: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type

1215: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type
1216: ,p_config_hdr_id IN NUMBER
1217: ,p_config_rev_nbr IN NUMBER
1218: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
1219: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
1220: ,p_direct_save IN BOOLEAN := FALSE
1221: ,p_ui_flag IN VARCHAR2)
1222: IS
1223: CURSOR config_del_cursor IS

Line 1249: l_line_rec OE_ORDER_PUB.Line_Rec_Type;

1245: AND c.config_hdr_id = p_config_hdr_id
1246: AND c.config_rev_nbr = p_config_rev_nbr
1247: AND c.quantity = 0));
1248:
1249: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
1250: l_class_line_rec OE_ORDER_PUB.Line_Rec_Type;
1251: l_line_count NUMBER;
1252: l_class_line_count NUMBER;
1253: l_cancellation BOOLEAN;

Line 1250: l_class_line_rec OE_ORDER_PUB.Line_Rec_Type;

1246: AND c.config_rev_nbr = p_config_rev_nbr
1247: AND c.quantity = 0));
1248:
1249: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
1250: l_class_line_rec OE_ORDER_PUB.Line_Rec_Type;
1251: l_line_count NUMBER;
1252: l_class_line_count NUMBER;
1253: l_cancellation BOOLEAN;
1254: l_change_reason VARCHAR2(30);

Line 1287: l_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;

1283: END IF;
1284:
1285: l_line_count := nvl(p_x_line_tbl.LAST, 0);
1286: l_class_line_count := nvl(p_x_class_line_tbl.LAST, 0);
1287: l_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;
1288:
1289: IF l_debug_level > 0 THEN
1290: oe_debug_pub.add( 'CONFIG_DEL CURSOR OPENED' , 1 ) ;
1291: END IF;

Line 1404: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type

1400: oe_order_lines.
1401: ----------------------------------------------------------*/
1402:
1403: PROCEDURE Handle_Deletes_Old
1404: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type
1405: ,p_config_hdr_id IN NUMBER
1406: ,p_config_rev_nbr IN NUMBER
1407: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
1408: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type

Line 1407: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type

1403: PROCEDURE Handle_Deletes_Old
1404: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type
1405: ,p_config_hdr_id IN NUMBER
1406: ,p_config_rev_nbr IN NUMBER
1407: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
1408: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
1409: ,p_direct_save IN BOOLEAN := FALSE
1410: ,p_ui_flag IN VARCHAR2)
1411: IS

Line 1408: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type

1404: ( p_model_line_rec IN OE_Order_Pub.Line_rec_Type
1405: ,p_config_hdr_id IN NUMBER
1406: ,p_config_rev_nbr IN NUMBER
1407: ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
1408: ,p_x_class_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_Type
1409: ,p_direct_save IN BOOLEAN := FALSE
1410: ,p_ui_flag IN VARCHAR2)
1411: IS
1412: CURSOR config_del_cursor IS

Line 1436: l_line_rec OE_ORDER_PUB.Line_Rec_Type;

1432: AND c.config_hdr_id = p_config_hdr_id
1433: AND c.config_rev_nbr = p_config_rev_nbr
1434: AND c.quantity = 0));
1435:
1436: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
1437: l_class_line_rec OE_ORDER_PUB.Line_Rec_Type;
1438: l_line_count NUMBER;
1439: l_class_line_count NUMBER;
1440: l_cancellation BOOLEAN;

Line 1437: l_class_line_rec OE_ORDER_PUB.Line_Rec_Type;

1433: AND c.config_rev_nbr = p_config_rev_nbr
1434: AND c.quantity = 0));
1435:
1436: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
1437: l_class_line_rec OE_ORDER_PUB.Line_Rec_Type;
1438: l_line_count NUMBER;
1439: l_class_line_count NUMBER;
1440: l_cancellation BOOLEAN;
1441: l_qty NUMBER;

Line 1450: l_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;

1446: Print_Time('Handle_Deletes_Old start time');
1447:
1448: l_line_count := nvl(p_x_line_tbl.LAST, 0);
1449: l_class_line_count := nvl(p_x_class_line_tbl.LAST, 0);
1450: l_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;
1451:
1452: IF l_debug_level > 0 THEN
1453: oe_debug_pub.add( 'CONFIG_DEL CURSOR OPENED' , 1 ) ;
1454: END IF;

Line 1810: ( p_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type

1806: MACD: Modified the control record to pass security
1807: ---------------------------------------------------------------*/
1808:
1809: PROCEDURE Call_Process_Order
1810: ( p_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
1811: ,p_class_line_tbl IN OE_Order_Pub.Line_Tbl_Type
1812: := OE_ORDER_PUB.G_MISS_LINE_TBL
1813: ,p_control_rec IN OUT NOCOPY OE_GLOBALS.Control_Rec_Type
1814: ,p_ui_flag IN VARCHAR2 := 'N'

Line 1811: ,p_class_line_tbl IN OE_Order_Pub.Line_Tbl_Type

1807: ---------------------------------------------------------------*/
1808:
1809: PROCEDURE Call_Process_Order
1810: ( p_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
1811: ,p_class_line_tbl IN OE_Order_Pub.Line_Tbl_Type
1812: := OE_ORDER_PUB.G_MISS_LINE_TBL
1813: ,p_control_rec IN OUT NOCOPY OE_GLOBALS.Control_Rec_Type
1814: ,p_ui_flag IN VARCHAR2 := 'N'
1815: ,p_top_model_line_id IN NUMBER := null

Line 1812: := OE_ORDER_PUB.G_MISS_LINE_TBL

1808:
1809: PROCEDURE Call_Process_Order
1810: ( p_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
1811: ,p_class_line_tbl IN OE_Order_Pub.Line_Tbl_Type
1812: := OE_ORDER_PUB.G_MISS_LINE_TBL
1813: ,p_control_rec IN OUT NOCOPY OE_GLOBALS.Control_Rec_Type
1814: ,p_ui_flag IN VARCHAR2 := 'N'
1815: ,p_top_model_line_id IN NUMBER := null
1816: ,p_config_hdr_id IN NUMBER := null

Line 1823: l_line_rec OE_Order_PUB.Line_Rec_Type;

1819: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1820: IS
1821: -- process_order in variables
1822: I NUMBER;
1823: l_line_rec OE_Order_PUB.Line_Rec_Type;
1824: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1825: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1826: l_msg_count NUMBER;
1827: l_msg_data VARCHAR2(2000);

Line 1824: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

1820: IS
1821: -- process_order in variables
1822: I NUMBER;
1823: l_line_rec OE_Order_PUB.Line_Rec_Type;
1824: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1825: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1826: l_msg_count NUMBER;
1827: l_msg_data VARCHAR2(2000);
1828: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 1825: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

1821: -- process_order in variables
1822: I NUMBER;
1823: l_line_rec OE_Order_PUB.Line_Rec_Type;
1824: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1825: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1826: l_msg_count NUMBER;
1827: l_msg_data VARCHAR2(2000);
1828: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1829: l_index NUMBER;

Line 2627: l_ato_line_rec OE_ORDER_PUB.Line_Rec_Type;

2623: l_shipping_method_code varchar2(30);
2624: l_freight_carrier_code varchar2(30);
2625: l_ato_line_id number;
2626: l_option_line_id number;
2627: l_ato_line_rec OE_ORDER_PUB.Line_Rec_Type;
2628: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
2629: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2630: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2631: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 2628: l_line_rec OE_ORDER_PUB.Line_Rec_Type;

2624: l_freight_carrier_code varchar2(30);
2625: l_ato_line_id number;
2626: l_option_line_id number;
2627: l_ato_line_rec OE_ORDER_PUB.Line_Rec_Type;
2628: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
2629: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2630: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2631: l_control_rec OE_GLOBALS.Control_Rec_Type;
2632: l_line_count NUMBER := 0;

Line 2629: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

2625: l_ato_line_id number;
2626: l_option_line_id number;
2627: l_ato_line_rec OE_ORDER_PUB.Line_Rec_Type;
2628: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
2629: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2630: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2631: l_control_rec OE_GLOBALS.Control_Rec_Type;
2632: l_line_count NUMBER := 0;
2633: l_return_status VARCHAR2(1);

Line 2630: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

2626: l_option_line_id number;
2627: l_ato_line_rec OE_ORDER_PUB.Line_Rec_Type;
2628: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
2629: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2630: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2631: l_control_rec OE_GLOBALS.Control_Rec_Type;
2632: l_line_count NUMBER := 0;
2633: l_return_status VARCHAR2(1);
2634:

Line 3483: ( p_model_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type

3479: x_config_effective_date : null if p_check_effective_date is N
3480: x_frozen_model_bill : null if p_check_effective_date is N
3481: ------------------------------------------------------------*/
3482: Procedure Explode_Bill
3483: ( p_model_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type
3484: ,p_do_update IN BOOLEAN := TRUE
3485: ,p_check_effective_date IN VARCHAR2 := 'Y'
3486: ,x_config_effective_date OUT NOCOPY DATE
3487: ,x_frozen_model_bill OUT NOCOPY VARCHAR2

Line 3680: l_line_rec OE_Order_Pub.Line_Rec_Type

3676: (x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
3677: IS
3678: I NUMBER;
3679: l_index NUMBER;
3680: l_line_rec OE_Order_Pub.Line_Rec_Type
3681: := OE_Order_Pub.G_Miss_Line_Rec;
3682: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
3683: l_control_rec OE_GLOBALS.Control_Rec_Type;
3684: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 3681: := OE_Order_Pub.G_Miss_Line_Rec;

3677: IS
3678: I NUMBER;
3679: l_index NUMBER;
3680: l_line_rec OE_Order_Pub.Line_Rec_Type
3681: := OE_Order_Pub.G_Miss_Line_Rec;
3682: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
3683: l_control_rec OE_GLOBALS.Control_Rec_Type;
3684: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3685:

Line 3682: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

3678: I NUMBER;
3679: l_index NUMBER;
3680: l_line_rec OE_Order_Pub.Line_Rec_Type
3681: := OE_Order_Pub.G_Miss_Line_Rec;
3682: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
3683: l_control_rec OE_GLOBALS.Control_Rec_Type;
3684: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3685:
3686:

Line 3791: l_line_rec := OE_Order_Pub.G_MISS_LINE_REC;

3787: END IF;
3788:
3789: l_index := l_index + 1;
3790: l_line_tbl(l_index) := l_line_rec;
3791: l_line_rec := OE_Order_Pub.G_MISS_LINE_REC;
3792:
3793:
3794: END LOOP; -- end cursor
3795: I := OE_MODIFY_INC_ITEMS_TBL.NEXT(I);

Line 3830: ( p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type

3826: that is called from OEXULINB
3827: __________________________________________________________________*/
3828:
3829: PROCEDURE Included_Items_DML
3830: ( p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
3831: ,p_top_model_line_id IN NUMBER
3832: ,p_ui_flag IN VARCHAR2
3833: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
3834: IS

Line 3836: l_line_rec OE_Order_Pub.Line_Rec_Type;

3832: ,p_ui_flag IN VARCHAR2
3833: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
3834: IS
3835: I NUMBER;
3836: l_line_rec OE_Order_Pub.Line_Rec_Type;
3837: l_found BOOLEAN;
3838: l_ordered_qty NUMBER;
3839: l_component_sequence_id NUMBER;
3840: l_creation_date DATE;

Line 3894: l_line_rec := OE_Order_Pub.G_Miss_Line_Rec;

3890:
3891: IF SUBSTR(l_rec.component_code, 1,
3892: INSTR(l_rec.component_code, '-') -1) = l_code
3893: THEN
3894: l_line_rec := OE_Order_Pub.G_Miss_Line_Rec;
3895: l_line_rec.operation := p_x_line_tbl(I).operation;
3896: l_line_rec.line_id := l_rec.line_id;
3897:
3898: l_line_rec.ordered_quantity := p_x_line_tbl(I).ordered_quantity;

Line 3927: l_line_rec := OE_Order_Pub.G_Miss_Line_Rec;

3923: FROM oe_order_lines
3924: WHERE top_model_line_id = p_top_model_line_id
3925: AND line_id = l_rec.link_to_line_id;
3926:
3927: l_line_rec := OE_Order_Pub.G_Miss_Line_Rec;
3928: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
3929: l_line_rec.line_id := l_rec.line_id;
3930: l_line_rec.ordered_quantity := l_ordered_qty; -- ratio??***
3931: l_line_rec.change_reason := 'SYSTEM';

Line 4066: ,x_line_rec IN OUT NOCOPY OE_Order_Pub.line_rec_type)

4062: ( p_line_id IN NUMBER
4063: ,p_change_reason IN VARCHAR2 := null
4064: ,p_change_comments IN VARCHAR2 := null
4065: ,x_cancellation OUT NOCOPY BOOLEAN
4066: ,x_line_rec IN OUT NOCOPY OE_Order_Pub.line_rec_type)
4067: IS
4068: l_return_status VARCHAR2(1);
4069: I NUMBER;
4070: l_msg_count1 NUMBER;