DBA Data[Home] [Help]

APPS.OE_ORDER_ADJ_PVT dependencies on OE_ORDER_PUB

Line 48: , p_x_Header_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type

44: PROCEDURE Header_Adjs
45: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
46: , p_validation_level IN NUMBER
47: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
48: , p_x_Header_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type
49: , p_x_old_Header_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type
50: );
51:
52: PROCEDURE HEader_Price_Atts

Line 49: , p_x_old_Header_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type

45: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
46: , p_validation_level IN NUMBER
47: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
48: , p_x_Header_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type
49: , p_x_old_Header_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type
50: );
51:
52: PROCEDURE HEader_Price_Atts
53: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE

Line 56: , p_x_HEader_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.HEader_Price_Att_Tbl_Type

52: PROCEDURE HEader_Price_Atts
53: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
54: , p_validation_level IN NUMBER
55: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
56: , p_x_HEader_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.HEader_Price_Att_Tbl_Type
57: , p_x_old_HEader_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.HEader_Price_Att_Tbl_Type
58: );
59:
60: PROCEDURE Header_Adj_Atts

Line 57: , p_x_old_HEader_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.HEader_Price_Att_Tbl_Type

53: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
54: , p_validation_level IN NUMBER
55: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
56: , p_x_HEader_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.HEader_Price_Att_Tbl_Type
57: , p_x_old_HEader_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.HEader_Price_Att_Tbl_Type
58: );
59:
60: PROCEDURE Header_Adj_Atts
61: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE

Line 64: , p_x_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type

60: PROCEDURE Header_Adj_Atts
61: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
62: , p_validation_level IN NUMBER
63: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
64: , p_x_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type
65: , p_x_old_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type
66: );
67:
68: PROCEDURE Header_Adj_Assocs

Line 65: , p_x_old_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type

61: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
62: , p_validation_level IN NUMBER
63: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
64: , p_x_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type
65: , p_x_old_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type
66: );
67:
68: PROCEDURE Header_Adj_Assocs
69: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE

Line 72: , p_x_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type

68: PROCEDURE Header_Adj_Assocs
69: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
70: , p_validation_level IN NUMBER
71: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
72: , p_x_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
73: , p_x_old_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
74: );
75:
76: PROCEDURE Line_Adjs

Line 73: , p_x_old_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type

69: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
70: , p_validation_level IN NUMBER
71: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
72: , p_x_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
73: , p_x_old_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
74: );
75:
76: PROCEDURE Line_Adjs
77: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE

Line 80: , p_x_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type

76: PROCEDURE Line_Adjs
77: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
78: , p_validation_level IN NUMBER
79: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
80: , p_x_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type
81: , p_x_old_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type
82: );
83:
84: PROCEDURE Line_Price_Atts

Line 81: , p_x_old_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type

77: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
78: , p_validation_level IN NUMBER
79: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
80: , p_x_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type
81: , p_x_old_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type
82: );
83:
84: PROCEDURE Line_Price_Atts
85: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE

Line 88: , p_x_Line_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type

84: PROCEDURE Line_Price_Atts
85: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
86: , p_validation_level IN NUMBER
87: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
88: , p_x_Line_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type
89: , p_x_old_Line_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type
90: );
91:
92: PROCEDURE Line_Adj_Atts

Line 89: , p_x_old_Line_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type

85: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
86: , p_validation_level IN NUMBER
87: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
88: , p_x_Line_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type
89: , p_x_old_Line_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type
90: );
91:
92: PROCEDURE Line_Adj_Atts
93: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE

Line 96: , p_x_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type

92: PROCEDURE Line_Adj_Atts
93: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
94: , p_validation_level IN NUMBER
95: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
96: , p_x_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type
97: , p_x_old_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type
98: );
99:
100: PROCEDURE Line_Adj_Assocs

Line 97: , p_x_old_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type

93: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
94: , p_validation_level IN NUMBER
95: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
96: , p_x_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type
97: , p_x_old_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type
98: );
99:
100: PROCEDURE Line_Adj_Assocs
101: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE

Line 104: , p_x_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type

100: PROCEDURE Line_Adj_Assocs
101: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
102: , p_validation_level IN NUMBER
103: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
104: , p_x_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
105: , p_x_old_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
106: );
107:
108: procedure calculate_adjustments(

Line 105: , p_x_old_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type

101: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
102: , p_validation_level IN NUMBER
103: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
104: , p_x_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
105: , p_x_old_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
106: );
107:
108: procedure calculate_adjustments(
109: x_return_status out nocopy varchar2,

Line 124: ,x_Header_Rec out nocopy oe_Order_Pub.Header_REc_Type

120: x_Req_related_lines_tbl out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE
121: ,p_use_current_header in Boolean Default FALSE
122: ,p_write_to_db Boolean Default TRUE
123: ,x_any_frozen_line out nocopy Boolean
124: ,x_Header_Rec out nocopy oe_Order_Pub.Header_REc_Type
125: ,x_line_Tbl in out nocopy oe_Order_Pub.Line_Tbl_Type
126: ,p_honor_price_flag VARCHAR2 Default 'Y'
127: ,p_multiple_events in VARCHAR2 Default 'N'
128: ,p_action_code in VARCHAR2 Default 'NONE'

Line 125: ,x_line_Tbl in out nocopy oe_Order_Pub.Line_Tbl_Type

121: ,p_use_current_header in Boolean Default FALSE
122: ,p_write_to_db Boolean Default TRUE
123: ,x_any_frozen_line out nocopy Boolean
124: ,x_Header_Rec out nocopy oe_Order_Pub.Header_REc_Type
125: ,x_line_Tbl in out nocopy oe_Order_Pub.Line_Tbl_Type
126: ,p_honor_price_flag VARCHAR2 Default 'Y'
127: ,p_multiple_events in VARCHAR2 Default 'N'
128: ,p_action_code in VARCHAR2 Default 'NONE'
129: );

Line 145: ,x_line_Tbl in out nocopy oe_Order_Pub.Line_Tbl_Type

141: p_Req_Line_Detail_Attr_tbl QP_PREQ_GRP.line_detail_attr_tbl_type,
142: p_Req_related_lines_tbl QP_PREQ_GRP.related_lines_tbl_type
143: ,p_write_to_db Boolean
144: ,p_any_frozen_line in Boolean
145: ,x_line_Tbl in out nocopy oe_Order_Pub.Line_Tbl_Type
146: ,p_header_rec oe_Order_Pub.header_rec_type
147: ,p_multiple_events in Varchar2 Default 'N'
148: ,p_honor_price_flag in Varchar2 Default 'Y' --bug 2503186
149: );

Line 146: ,p_header_rec oe_Order_Pub.header_rec_type

142: p_Req_related_lines_tbl QP_PREQ_GRP.related_lines_tbl_type
143: ,p_write_to_db Boolean
144: ,p_any_frozen_line in Boolean
145: ,x_line_Tbl in out nocopy oe_Order_Pub.Line_Tbl_Type
146: ,p_header_rec oe_Order_Pub.header_rec_type
147: ,p_multiple_events in Varchar2 Default 'N'
148: ,p_honor_price_flag in Varchar2 Default 'Y' --bug 2503186
149: );
150:

Line 158: ,p_request_rec OE_Order_PUB.request_rec_type default oe_order_pub.G_MISS_REQUEST_REC

154: ,p_Header_id Number DEfault Null
155: ,p_Request_Type_code Varchar2
156: ,p_Control_Rec QP_PREQ_GRP.control_record_type
157: ,p_write_to_db Boolean DEFAULT TRUE
158: ,p_request_rec OE_Order_PUB.request_rec_type default oe_order_pub.G_MISS_REQUEST_REC
159: ,x_line_Tbl in out nocopy oe_Order_Pub.Line_Tbl_Type
160: ,p_honor_price_flag VARCHAR2 Default 'Y'
161: ,p_multiple_events Varchar2 default 'N'
162: ,p_action_code VARCHAR2 Default Null

Line 159: ,x_line_Tbl in out nocopy oe_Order_Pub.Line_Tbl_Type

155: ,p_Request_Type_code Varchar2
156: ,p_Control_Rec QP_PREQ_GRP.control_record_type
157: ,p_write_to_db Boolean DEFAULT TRUE
158: ,p_request_rec OE_Order_PUB.request_rec_type default oe_order_pub.G_MISS_REQUEST_REC
159: ,x_line_Tbl in out nocopy oe_Order_Pub.Line_Tbl_Type
160: ,p_honor_price_flag VARCHAR2 Default 'Y'
161: ,p_multiple_events Varchar2 default 'N'
162: ,p_action_code VARCHAR2 Default Null
163: );

Line 170: ,p_request_rec OE_Order_PUB.request_rec_type default oe_order_pub.G_MISS_REQUEST_REC

166: X_Return_Status out nocopy Varchar2
167: ,p_Header_id Number DEfault null
168: ,p_Line_id Number DEfault null
169: ,p_request_type_code varchar2
170: ,p_request_rec OE_Order_PUB.request_rec_type default oe_order_pub.G_MISS_REQUEST_REC
171:
172: );
173:
174: procedure price_action

Line 364: p_line_rec in oe_Order_Pub.Line_Rec_Type Default oe_order_pub.g_miss_line_rec,

360:
361: Procedure Get_Manual_Adjustments (
362: p_header_id in number Default Null,
363: p_line_id in number Default Null,
364: p_line_rec in oe_Order_Pub.Line_Rec_Type Default oe_order_pub.g_miss_line_rec,
365: p_level in Varchar2 default 'LINE',
366: p_pbh_mode in Varchar2 default 'CHILD',
367: p_cross_order in Varchar2 Default 'N',
368: p_line_level in Varchar2 Default 'N',

Line 382: (p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type

378: p_line_id in Number default null
379: );
380:
381: PROCEDURE Insert_Adj_Assocs
382: (p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
383: );
384:
385: PROCEDURE Insert_Adj_Atts
386: (p_Line_Adj_attribs_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type

Line 386: (p_Line_Adj_attribs_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type

382: (p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
383: );
384:
385: PROCEDURE Insert_Adj_Atts
386: (p_Line_Adj_attribs_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
387: );
388:
389:
390: Procedure copy_Header_to_request(

Line 391: p_header_rec OE_Order_PUB.Header_Rec_Type

387: );
388:
389:
390: Procedure copy_Header_to_request(
391: p_header_rec OE_Order_PUB.Header_Rec_Type
392: ,px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
393: ,p_Request_Type_Code varchar2
394: ,p_calculate_price_flag varchar2
395: );

Line 399: p_Line_rec OE_Order_PUB.Line_Rec_Type

395: );
396:
397:
398: Procedure copy_Line_to_request(
399: p_Line_rec OE_Order_PUB.Line_Rec_Type
400: ,px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
401: ,p_pricing_event varchar2
402: ,p_Request_Type_Code varchar2
403: ,p_honor_price_flag VARCHAR2 Default 'Y'

Line 415: Procedure Reset_Fields(p_line_rec in Oe_Order_Pub.Line_Rec_Type);

411: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
412: );
413:
414:
415: Procedure Reset_Fields(p_line_rec in Oe_Order_Pub.Line_Rec_Type);
416: -- bug 6718566
417: Procedure GET_MANUAL_ADV_STATUS(p_event_code IN VARCHAR2);
418:
419: end oe_order_adj_pvt;