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.PO_COPYDOC_SUB dependencies on PO_ONLINE_REPORT_TEXT

Line 52: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

48: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
49: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
50: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
51: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
52: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
53: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
54: );
55:
56: PROCEDURE get_vendor_values(

Line 53: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE

49: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
50: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
51: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
52: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
53: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
54: );
55:
56: PROCEDURE get_vendor_values(
57: x_vendor_id IN po_headers.vendor_id%TYPE,

Line 64: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

60: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
61: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
62: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
63: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
64: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
65: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
66: );
67:
68: PROCEDURE get_vendor_site_values(

Line 65: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE

61: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
62: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
63: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
64: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
65: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
66: );
67:
68: PROCEDURE get_vendor_site_values(
69: x_vendor_id IN po_headers.vendor_id%TYPE,

Line 77: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

73: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
74: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
75: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
76: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
77: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
78: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
79: );
80:
81: PROCEDURE validate_buyer_id(

Line 78: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE

74: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
75: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
76: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
77: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
78: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
79: );
80:
81: PROCEDURE validate_buyer_id(
82: x_buyer_id IN OUT NOCOPY po_headers.agent_id%TYPE,

Line 83: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

79: );
80:
81: PROCEDURE validate_buyer_id(
82: x_buyer_id IN OUT NOCOPY po_headers.agent_id%TYPE,
83: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
84: x_sequence IN OUT NOCOPY po_online_report_text.line_num%TYPE
85: );
86:
87:

Line 84: x_sequence IN OUT NOCOPY po_online_report_text.line_num%TYPE

80:
81: PROCEDURE validate_buyer_id(
82: x_buyer_id IN OUT NOCOPY po_headers.agent_id%TYPE,
83: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
84: x_sequence IN OUT NOCOPY po_online_report_text.line_num%TYPE
85: );
86:
87:
88: PROCEDURE validate_vendor(

Line 100: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

96: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
97: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
98: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
99: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
100: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
101: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
102: );
103:
104: PROCEDURE validate_location_terms(

Line 101: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE

97: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
98: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
99: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
100: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
101: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
102: );
103:
104: PROCEDURE validate_location_terms(
105: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,

Line 112: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

108: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
109: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
110: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
111: x_clm_flag IN po_doc_style_headers.clm_flag%TYPE, -- CLM
112: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
113: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
114: );
115:
116: PROCEDURE validate_item(

Line 113: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE

109: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
110: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
111: x_clm_flag IN po_doc_style_headers.clm_flag%TYPE, -- CLM
112: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
113: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
114: );
115:
116: PROCEDURE validate_item(
117: x_item_id IN OUT NOCOPY po_lines.item_id%TYPE,

Line 123: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

119: x_item_revision IN OUT NOCOPY po_lines.item_revision%TYPE,
120: x_category_id IN OUT NOCOPY po_lines.category_id%TYPE,
121: x_line_type_id IN po_lines.line_type_id%TYPE,
122: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
123: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
124: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
125: x_line_num IN po_online_report_text.line_num%TYPE,
126: x_clm_info_flag IN po_lines.clm_info_flag%TYPE, --CLM
127: x_return_code OUT NOCOPY NUMBER

Line 124: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

120: x_category_id IN OUT NOCOPY po_lines.category_id%TYPE,
121: x_line_type_id IN po_lines.line_type_id%TYPE,
122: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
123: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
124: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
125: x_line_num IN po_online_report_text.line_num%TYPE,
126: x_clm_info_flag IN po_lines.clm_info_flag%TYPE, --CLM
127: x_return_code OUT NOCOPY NUMBER
128: );

Line 125: x_line_num IN po_online_report_text.line_num%TYPE,

121: x_line_type_id IN po_lines.line_type_id%TYPE,
122: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
123: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
124: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
125: x_line_num IN po_online_report_text.line_num%TYPE,
126: x_clm_info_flag IN po_lines.clm_info_flag%TYPE, --CLM
127: x_return_code OUT NOCOPY NUMBER
128: );
129:

Line 137: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

133: -- Removed the x_destination_type_code and x_ship_to_organization_id arguments.
134: -- Added NOCOPY to x_project_id and x_sequence.
135: -- x_destination_type_code IN po_distributions.destination_type_code%TYPE,
136: -- x_ship_to_organization_id IN NUMBER,
137: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
138: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
139: x_line_num IN po_online_report_text.line_num%TYPE,
140: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
141: x_distribution_num IN po_online_report_text.distribution_num%TYPE

Line 138: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

134: -- Added NOCOPY to x_project_id and x_sequence.
135: -- x_destination_type_code IN po_distributions.destination_type_code%TYPE,
136: -- x_ship_to_organization_id IN NUMBER,
137: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
138: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
139: x_line_num IN po_online_report_text.line_num%TYPE,
140: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
141: x_distribution_num IN po_online_report_text.distribution_num%TYPE
142: );

Line 139: x_line_num IN po_online_report_text.line_num%TYPE,

135: -- x_destination_type_code IN po_distributions.destination_type_code%TYPE,
136: -- x_ship_to_organization_id IN NUMBER,
137: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
138: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
139: x_line_num IN po_online_report_text.line_num%TYPE,
140: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
141: x_distribution_num IN po_online_report_text.distribution_num%TYPE
142: );
143:

Line 140: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

136: -- x_ship_to_organization_id IN NUMBER,
137: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
138: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
139: x_line_num IN po_online_report_text.line_num%TYPE,
140: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
141: x_distribution_num IN po_online_report_text.distribution_num%TYPE
142: );
143:
144: PROCEDURE validate_task_id(

Line 141: x_distribution_num IN po_online_report_text.distribution_num%TYPE

137: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
138: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
139: x_line_num IN po_online_report_text.line_num%TYPE,
140: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
141: x_distribution_num IN po_online_report_text.distribution_num%TYPE
142: );
143:
144: PROCEDURE validate_task_id(
145: x_task_id IN OUT NOCOPY NUMBER,

Line 147: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

143:
144: PROCEDURE validate_task_id(
145: x_task_id IN OUT NOCOPY NUMBER,
146: x_project_id IN NUMBER,
147: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
148: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
149: x_line_num IN po_online_report_text.line_num%TYPE,
150: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
151: x_distribution_num IN po_online_report_text.distribution_num%TYPE

Line 148: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

144: PROCEDURE validate_task_id(
145: x_task_id IN OUT NOCOPY NUMBER,
146: x_project_id IN NUMBER,
147: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
148: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
149: x_line_num IN po_online_report_text.line_num%TYPE,
150: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
151: x_distribution_num IN po_online_report_text.distribution_num%TYPE
152: );

Line 149: x_line_num IN po_online_report_text.line_num%TYPE,

145: x_task_id IN OUT NOCOPY NUMBER,
146: x_project_id IN NUMBER,
147: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
148: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
149: x_line_num IN po_online_report_text.line_num%TYPE,
150: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
151: x_distribution_num IN po_online_report_text.distribution_num%TYPE
152: );
153:

Line 150: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

146: x_project_id IN NUMBER,
147: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
148: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
149: x_line_num IN po_online_report_text.line_num%TYPE,
150: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
151: x_distribution_num IN po_online_report_text.distribution_num%TYPE
152: );
153:
154: PROCEDURE validate_account_id(

Line 151: x_distribution_num IN po_online_report_text.distribution_num%TYPE

147: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
148: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
149: x_line_num IN po_online_report_text.line_num%TYPE,
150: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
151: x_distribution_num IN po_online_report_text.distribution_num%TYPE
152: );
153:
154: PROCEDURE validate_account_id(
155: x_account_id IN OUT NOCOPY NUMBER,

Line 159: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

155: x_account_id IN OUT NOCOPY NUMBER,
156: x_account_type IN VARCHAR2,
157: x_gl_date IN DATE,
158: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
159: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
160: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
161: x_line_num IN po_online_report_text.line_num%TYPE,
162: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
163: x_distribution_num IN po_online_report_text.distribution_num%TYPE

Line 160: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

156: x_account_type IN VARCHAR2,
157: x_gl_date IN DATE,
158: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
159: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
160: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
161: x_line_num IN po_online_report_text.line_num%TYPE,
162: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
163: x_distribution_num IN po_online_report_text.distribution_num%TYPE
164: );

Line 161: x_line_num IN po_online_report_text.line_num%TYPE,

157: x_gl_date IN DATE,
158: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
159: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
160: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
161: x_line_num IN po_online_report_text.line_num%TYPE,
162: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
163: x_distribution_num IN po_online_report_text.distribution_num%TYPE
164: );
165:

Line 162: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

158: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
159: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
160: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
161: x_line_num IN po_online_report_text.line_num%TYPE,
162: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
163: x_distribution_num IN po_online_report_text.distribution_num%TYPE
164: );
165:
166: PROCEDURE validate_destination_type_code(

Line 163: x_distribution_num IN po_online_report_text.distribution_num%TYPE

159: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
160: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
161: x_line_num IN po_online_report_text.line_num%TYPE,
162: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
163: x_distribution_num IN po_online_report_text.distribution_num%TYPE
164: );
165:
166: PROCEDURE validate_destination_type_code(
167: x_destination_type_code IN OUT NOCOPY po_distributions.destination_type_code%TYPE,

Line 171: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

167: x_destination_type_code IN OUT NOCOPY po_distributions.destination_type_code%TYPE,
168: x_item_id IN po_lines.item_id%TYPE,
169: x_ship_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
170: x_accrue_on_receipt_flag IN varchar2,
171: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
172: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
173: x_line_num IN po_online_report_text.line_num%TYPE,
174: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
175: x_distribution_num IN po_online_report_text.distribution_num%TYPE,

Line 172: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

168: x_item_id IN po_lines.item_id%TYPE,
169: x_ship_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
170: x_accrue_on_receipt_flag IN varchar2,
171: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
172: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
173: x_line_num IN po_online_report_text.line_num%TYPE,
174: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
175: x_distribution_num IN po_online_report_text.distribution_num%TYPE,
176: x_line_location_id IN po_line_locations.line_location_id%TYPE, -- CONSIGNED FPI START

Line 173: x_line_num IN po_online_report_text.line_num%TYPE,

169: x_ship_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
170: x_accrue_on_receipt_flag IN varchar2,
171: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
172: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
173: x_line_num IN po_online_report_text.line_num%TYPE,
174: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
175: x_distribution_num IN po_online_report_text.distribution_num%TYPE,
176: x_line_location_id IN po_line_locations.line_location_id%TYPE, -- CONSIGNED FPI START
177: x_po_line_id IN po_lines.po_line_id%TYPE, -- Bug 3557910 Additional Input Parameter PO LINE ID

Line 174: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

170: x_accrue_on_receipt_flag IN varchar2,
171: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
172: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
173: x_line_num IN po_online_report_text.line_num%TYPE,
174: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
175: x_distribution_num IN po_online_report_text.distribution_num%TYPE,
176: x_line_location_id IN po_line_locations.line_location_id%TYPE, -- CONSIGNED FPI START
177: x_po_line_id IN po_lines.po_line_id%TYPE, -- Bug 3557910 Additional Input Parameter PO LINE ID
178: p_transaction_flow_header_id IN NUMBER --< Bug 3546252 >

Line 175: x_distribution_num IN po_online_report_text.distribution_num%TYPE,

171: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
172: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
173: x_line_num IN po_online_report_text.line_num%TYPE,
174: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
175: x_distribution_num IN po_online_report_text.distribution_num%TYPE,
176: x_line_location_id IN po_line_locations.line_location_id%TYPE, -- CONSIGNED FPI START
177: x_po_line_id IN po_lines.po_line_id%TYPE, -- Bug 3557910 Additional Input Parameter PO LINE ID
178: p_transaction_flow_header_id IN NUMBER --< Bug 3546252 >
179: );

Line 183: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

179: );
180:
181: PROCEDURE validate_deliver_to_person_id(
182: x_deliver_to_person_id IN OUT NOCOPY po_distributions.deliver_to_person_id%TYPE,
183: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
184: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
185: x_line_num IN po_online_report_text.line_num%TYPE,
186: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
187: x_distribution_num IN po_online_report_text.distribution_num%TYPE

Line 184: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

180:
181: PROCEDURE validate_deliver_to_person_id(
182: x_deliver_to_person_id IN OUT NOCOPY po_distributions.deliver_to_person_id%TYPE,
183: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
184: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
185: x_line_num IN po_online_report_text.line_num%TYPE,
186: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
187: x_distribution_num IN po_online_report_text.distribution_num%TYPE
188: );

Line 185: x_line_num IN po_online_report_text.line_num%TYPE,

181: PROCEDURE validate_deliver_to_person_id(
182: x_deliver_to_person_id IN OUT NOCOPY po_distributions.deliver_to_person_id%TYPE,
183: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
184: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
185: x_line_num IN po_online_report_text.line_num%TYPE,
186: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
187: x_distribution_num IN po_online_report_text.distribution_num%TYPE
188: );
189:

Line 186: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

182: x_deliver_to_person_id IN OUT NOCOPY po_distributions.deliver_to_person_id%TYPE,
183: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
184: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
185: x_line_num IN po_online_report_text.line_num%TYPE,
186: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
187: x_distribution_num IN po_online_report_text.distribution_num%TYPE
188: );
189:
190: PROCEDURE validate_osp_data( x_wip_entity_id IN NUMBER,

Line 187: x_distribution_num IN po_online_report_text.distribution_num%TYPE

183: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
184: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
185: x_line_num IN po_online_report_text.line_num%TYPE,
186: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
187: x_distribution_num IN po_online_report_text.distribution_num%TYPE
188: );
189:
190: PROCEDURE validate_osp_data( x_wip_entity_id IN NUMBER,
191: x_wip_operation_seq_num IN NUMBER,

Line 196: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

192: x_wip_resource_seq_num IN NUMBER,
193: x_wip_repetitive_schedule_id IN NUMBER,
194: x_wip_line_id IN NUMBER,
195: x_destination_organization_id IN NUMBER,
196: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
197: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
198: x_line_num IN po_online_report_text.line_num%TYPE,
199: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
200: x_distribution_num IN po_online_report_text.distribution_num%TYPE);

Line 197: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

193: x_wip_repetitive_schedule_id IN NUMBER,
194: x_wip_line_id IN NUMBER,
195: x_destination_organization_id IN NUMBER,
196: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
197: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
198: x_line_num IN po_online_report_text.line_num%TYPE,
199: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
200: x_distribution_num IN po_online_report_text.distribution_num%TYPE);
201:

Line 198: x_line_num IN po_online_report_text.line_num%TYPE,

194: x_wip_line_id IN NUMBER,
195: x_destination_organization_id IN NUMBER,
196: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
197: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
198: x_line_num IN po_online_report_text.line_num%TYPE,
199: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
200: x_distribution_num IN po_online_report_text.distribution_num%TYPE);
201:
202: PROCEDURE validate_deliver_to_loc_id(

Line 199: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

195: x_destination_organization_id IN NUMBER,
196: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
197: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
198: x_line_num IN po_online_report_text.line_num%TYPE,
199: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
200: x_distribution_num IN po_online_report_text.distribution_num%TYPE);
201:
202: PROCEDURE validate_deliver_to_loc_id(
203: x_deliver_to_location_id IN OUT NOCOPY po_distributions.deliver_to_location_id%TYPE,

Line 200: x_distribution_num IN po_online_report_text.distribution_num%TYPE);

196: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
197: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
198: x_line_num IN po_online_report_text.line_num%TYPE,
199: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
200: x_distribution_num IN po_online_report_text.distribution_num%TYPE);
201:
202: PROCEDURE validate_deliver_to_loc_id(
203: x_deliver_to_location_id IN OUT NOCOPY po_distributions.deliver_to_location_id%TYPE,
204: x_ship_to_organization_id IN NUMBER,

Line 205: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

201:
202: PROCEDURE validate_deliver_to_loc_id(
203: x_deliver_to_location_id IN OUT NOCOPY po_distributions.deliver_to_location_id%TYPE,
204: x_ship_to_organization_id IN NUMBER,
205: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
206: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
207: x_line_num IN po_online_report_text.line_num%TYPE,
208: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
209: x_distribution_num IN po_online_report_text.distribution_num%TYPE

Line 206: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

202: PROCEDURE validate_deliver_to_loc_id(
203: x_deliver_to_location_id IN OUT NOCOPY po_distributions.deliver_to_location_id%TYPE,
204: x_ship_to_organization_id IN NUMBER,
205: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
206: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
207: x_line_num IN po_online_report_text.line_num%TYPE,
208: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
209: x_distribution_num IN po_online_report_text.distribution_num%TYPE
210: );

Line 207: x_line_num IN po_online_report_text.line_num%TYPE,

203: x_deliver_to_location_id IN OUT NOCOPY po_distributions.deliver_to_location_id%TYPE,
204: x_ship_to_organization_id IN NUMBER,
205: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
206: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
207: x_line_num IN po_online_report_text.line_num%TYPE,
208: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
209: x_distribution_num IN po_online_report_text.distribution_num%TYPE
210: );
211:

Line 208: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

204: x_ship_to_organization_id IN NUMBER,
205: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
206: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
207: x_line_num IN po_online_report_text.line_num%TYPE,
208: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
209: x_distribution_num IN po_online_report_text.distribution_num%TYPE
210: );
211:
212: PROCEDURE validate_dest_subinventory(

Line 209: x_distribution_num IN po_online_report_text.distribution_num%TYPE

205: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
206: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
207: x_line_num IN po_online_report_text.line_num%TYPE,
208: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
209: x_distribution_num IN po_online_report_text.distribution_num%TYPE
210: );
211:
212: PROCEDURE validate_dest_subinventory(
213: x_destination_subinventory IN OUT NOCOPY po_distributions.destination_subinventory%TYPE,

Line 216: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

212: PROCEDURE validate_dest_subinventory(
213: x_destination_subinventory IN OUT NOCOPY po_distributions.destination_subinventory%TYPE,
214: x_ship_to_organization_id IN NUMBER,
215: x_item_id IN po_lines.item_id%TYPE,
216: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
217: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
218: x_line_num IN po_online_report_text.line_num%TYPE,
219: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
220: x_distribution_num IN po_online_report_text.distribution_num%TYPE

Line 217: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

213: x_destination_subinventory IN OUT NOCOPY po_distributions.destination_subinventory%TYPE,
214: x_ship_to_organization_id IN NUMBER,
215: x_item_id IN po_lines.item_id%TYPE,
216: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
217: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
218: x_line_num IN po_online_report_text.line_num%TYPE,
219: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
220: x_distribution_num IN po_online_report_text.distribution_num%TYPE
221: );

Line 218: x_line_num IN po_online_report_text.line_num%TYPE,

214: x_ship_to_organization_id IN NUMBER,
215: x_item_id IN po_lines.item_id%TYPE,
216: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
217: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
218: x_line_num IN po_online_report_text.line_num%TYPE,
219: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
220: x_distribution_num IN po_online_report_text.distribution_num%TYPE
221: );
222:

Line 219: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

215: x_item_id IN po_lines.item_id%TYPE,
216: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
217: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
218: x_line_num IN po_online_report_text.line_num%TYPE,
219: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
220: x_distribution_num IN po_online_report_text.distribution_num%TYPE
221: );
222:
223: --

Line 220: x_distribution_num IN po_online_report_text.distribution_num%TYPE

216: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
217: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
218: x_line_num IN po_online_report_text.line_num%TYPE,
219: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
220: x_distribution_num IN po_online_report_text.distribution_num%TYPE
221: );
222:
223: --
224: -- this is now added to regular submission check (POXVDCKB.pls 115.30)

Line 228: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

224: -- this is now added to regular submission check (POXVDCKB.pls 115.30)
225:
226: PROCEDURE validate_contract_num(
227: p_contract_id IN PO_LINES_ALL.contract_id%TYPE, --
228: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
229: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
230: x_line_num IN po_online_report_text.line_num%TYPE
231: );
232:

Line 229: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

225:
226: PROCEDURE validate_contract_num(
227: p_contract_id IN PO_LINES_ALL.contract_id%TYPE, --
228: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
229: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
230: x_line_num IN po_online_report_text.line_num%TYPE
231: );
232:
233: --

Line 230: x_line_num IN po_online_report_text.line_num%TYPE

226: PROCEDURE validate_contract_num(
227: p_contract_id IN PO_LINES_ALL.contract_id%TYPE, --
228: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
229: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
230: x_line_num IN po_online_report_text.line_num%TYPE
231: );
232:
233: --
234: --Procedure that validate that the referenced global agreement is not cancelled or

Line 239: p_online_report_id IN po_online_report_text.online_report_id%TYPE,

235: --finally closed
236: PROCEDURE validate_global_ref(
237: p_from_header_id IN po_headers_all.po_header_id%TYPE,
238: p_from_line_id IN po_lines_all.po_line_id%TYPE,
239: p_online_report_id IN po_online_report_text.online_report_id%TYPE,
240: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
241: p_line_num IN po_online_report_text.line_num%TYPE
242: );
243: --

Line 240: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

236: PROCEDURE validate_global_ref(
237: p_from_header_id IN po_headers_all.po_header_id%TYPE,
238: p_from_line_id IN po_lines_all.po_line_id%TYPE,
239: p_online_report_id IN po_online_report_text.online_report_id%TYPE,
240: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
241: p_line_num IN po_online_report_text.line_num%TYPE
242: );
243: --
244:

Line 241: p_line_num IN po_online_report_text.line_num%TYPE

237: p_from_header_id IN po_headers_all.po_header_id%TYPE,
238: p_from_line_id IN po_lines_all.po_line_id%TYPE,
239: p_online_report_id IN po_online_report_text.online_report_id%TYPE,
240: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
241: p_line_num IN po_online_report_text.line_num%TYPE
242: );
243: --
244:
245: -- SERVICES FPJ Start

Line 250: p_online_report_id IN po_online_report_text.online_report_id%TYPE,

246: -- Procedure to validate the temp labor Job on PO lines
247:
248: PROCEDURE validate_job(
249: p_job_id IN po_lines.job_id%TYPE,
250: p_online_report_id IN po_online_report_text.online_report_id%TYPE,
251: p_line_num IN po_online_report_text.line_num%TYPE,
252: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
253: );
254:

Line 251: p_line_num IN po_online_report_text.line_num%TYPE,

247:
248: PROCEDURE validate_job(
249: p_job_id IN po_lines.job_id%TYPE,
250: p_online_report_id IN po_online_report_text.online_report_id%TYPE,
251: p_line_num IN po_online_report_text.line_num%TYPE,
252: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
253: );
254:
255: -- SERVICES FPJ End

Line 252: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE

248: PROCEDURE validate_job(
249: p_job_id IN po_lines.job_id%TYPE,
250: p_online_report_id IN po_online_report_text.online_report_id%TYPE,
251: p_line_num IN po_online_report_text.line_num%TYPE,
252: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
253: );
254:
255: -- SERVICES FPJ End
256:

Line 295: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

291: PROCEDURE validate_exp_item_date(
292: x_project_id IN NUMBER,
293: x_task_id IN NUMBER,
294: x_exp_item_date IN OUT NOCOPY DATE,
295: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
296: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
297: x_line_num IN po_online_report_text.line_num%TYPE,
298: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
299: x_distribution_num IN po_online_report_text.distribution_num%TYPE

Line 296: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

292: x_project_id IN NUMBER,
293: x_task_id IN NUMBER,
294: x_exp_item_date IN OUT NOCOPY DATE,
295: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
296: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
297: x_line_num IN po_online_report_text.line_num%TYPE,
298: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
299: x_distribution_num IN po_online_report_text.distribution_num%TYPE
300: );

Line 297: x_line_num IN po_online_report_text.line_num%TYPE,

293: x_task_id IN NUMBER,
294: x_exp_item_date IN OUT NOCOPY DATE,
295: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
296: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
297: x_line_num IN po_online_report_text.line_num%TYPE,
298: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
299: x_distribution_num IN po_online_report_text.distribution_num%TYPE
300: );
301:

Line 298: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

294: x_exp_item_date IN OUT NOCOPY DATE,
295: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
296: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
297: x_line_num IN po_online_report_text.line_num%TYPE,
298: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
299: x_distribution_num IN po_online_report_text.distribution_num%TYPE
300: );
301:
302: PROCEDURE validate_exp_type(

Line 299: x_distribution_num IN po_online_report_text.distribution_num%TYPE

295: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
296: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
297: x_line_num IN po_online_report_text.line_num%TYPE,
298: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
299: x_distribution_num IN po_online_report_text.distribution_num%TYPE
300: );
301:
302: PROCEDURE validate_exp_type(
303: x_project_id IN NUMBER,

Line 305: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

301:
302: PROCEDURE validate_exp_type(
303: x_project_id IN NUMBER,
304: x_exp_type IN OUT NOCOPY po_distributions.expenditure_type%TYPE,
305: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
306: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
307: x_line_num IN po_online_report_text.line_num%TYPE,
308: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
309: x_distribution_num IN po_online_report_text.distribution_num%TYPE

Line 306: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

302: PROCEDURE validate_exp_type(
303: x_project_id IN NUMBER,
304: x_exp_type IN OUT NOCOPY po_distributions.expenditure_type%TYPE,
305: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
306: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
307: x_line_num IN po_online_report_text.line_num%TYPE,
308: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
309: x_distribution_num IN po_online_report_text.distribution_num%TYPE
310: );

Line 307: x_line_num IN po_online_report_text.line_num%TYPE,

303: x_project_id IN NUMBER,
304: x_exp_type IN OUT NOCOPY po_distributions.expenditure_type%TYPE,
305: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
306: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
307: x_line_num IN po_online_report_text.line_num%TYPE,
308: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
309: x_distribution_num IN po_online_report_text.distribution_num%TYPE
310: );
311:

Line 308: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

304: x_exp_type IN OUT NOCOPY po_distributions.expenditure_type%TYPE,
305: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
306: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
307: x_line_num IN po_online_report_text.line_num%TYPE,
308: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
309: x_distribution_num IN po_online_report_text.distribution_num%TYPE
310: );
311:
312: PROCEDURE validate_exp_org(

Line 309: x_distribution_num IN po_online_report_text.distribution_num%TYPE

305: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
306: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
307: x_line_num IN po_online_report_text.line_num%TYPE,
308: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
309: x_distribution_num IN po_online_report_text.distribution_num%TYPE
310: );
311:
312: PROCEDURE validate_exp_org(
313: x_org_id IN OUT NOCOPY NUMBER,

Line 314: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

310: );
311:
312: PROCEDURE validate_exp_org(
313: x_org_id IN OUT NOCOPY NUMBER,
314: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
315: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
316: x_line_num IN po_online_report_text.line_num%TYPE,
317: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
318: x_distribution_num IN po_online_report_text.distribution_num%TYPE

Line 315: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

311:
312: PROCEDURE validate_exp_org(
313: x_org_id IN OUT NOCOPY NUMBER,
314: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
315: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
316: x_line_num IN po_online_report_text.line_num%TYPE,
317: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
318: x_distribution_num IN po_online_report_text.distribution_num%TYPE
319: );

Line 316: x_line_num IN po_online_report_text.line_num%TYPE,

312: PROCEDURE validate_exp_org(
313: x_org_id IN OUT NOCOPY NUMBER,
314: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
315: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
316: x_line_num IN po_online_report_text.line_num%TYPE,
317: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
318: x_distribution_num IN po_online_report_text.distribution_num%TYPE
319: );
320:

Line 317: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

313: x_org_id IN OUT NOCOPY NUMBER,
314: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
315: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
316: x_line_num IN po_online_report_text.line_num%TYPE,
317: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
318: x_distribution_num IN po_online_report_text.distribution_num%TYPE
319: );
320:
321: -- End Bug 3488117

Line 318: x_distribution_num IN po_online_report_text.distribution_num%TYPE

314: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
315: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
316: x_line_num IN po_online_report_text.line_num%TYPE,
317: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
318: x_distribution_num IN po_online_report_text.distribution_num%TYPE
319: );
320:
321: -- End Bug 3488117
322:

Line 329: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

325: PROCEDURE validate_proj_end_date(
326: x_project_id IN NUMBER,
327: x_task_id IN NUMBER,
328: -- x_exp_item_date IN OUT NOCOPY DATE,
329: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
330: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
331: x_line_num IN po_online_report_text.line_num%TYPE,
332: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
333: x_distribution_num IN po_online_report_text.distribution_num%TYPE

Line 330: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

326: x_project_id IN NUMBER,
327: x_task_id IN NUMBER,
328: -- x_exp_item_date IN OUT NOCOPY DATE,
329: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
330: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
331: x_line_num IN po_online_report_text.line_num%TYPE,
332: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
333: x_distribution_num IN po_online_report_text.distribution_num%TYPE
334: );

Line 331: x_line_num IN po_online_report_text.line_num%TYPE,

327: x_task_id IN NUMBER,
328: -- x_exp_item_date IN OUT NOCOPY DATE,
329: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
330: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
331: x_line_num IN po_online_report_text.line_num%TYPE,
332: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
333: x_distribution_num IN po_online_report_text.distribution_num%TYPE
334: );
335:

Line 332: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

328: -- x_exp_item_date IN OUT NOCOPY DATE,
329: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
330: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
331: x_line_num IN po_online_report_text.line_num%TYPE,
332: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
333: x_distribution_num IN po_online_report_text.distribution_num%TYPE
334: );
335:
336: PROCEDURE validate_task_end_date(

Line 333: x_distribution_num IN po_online_report_text.distribution_num%TYPE

329: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
330: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
331: x_line_num IN po_online_report_text.line_num%TYPE,
332: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
333: x_distribution_num IN po_online_report_text.distribution_num%TYPE
334: );
335:
336: PROCEDURE validate_task_end_date(
337: x_project_id IN NUMBER,

Line 340: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

336: PROCEDURE validate_task_end_date(
337: x_project_id IN NUMBER,
338: x_task_id IN NUMBER,
339: -- x_exp_item_date IN OUT NOCOPY DATE,
340: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
341: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
342: x_line_num IN po_online_report_text.line_num%TYPE,
343: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
344: x_distribution_num IN po_online_report_text.distribution_num%TYPE

Line 341: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

337: x_project_id IN NUMBER,
338: x_task_id IN NUMBER,
339: -- x_exp_item_date IN OUT NOCOPY DATE,
340: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
341: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
342: x_line_num IN po_online_report_text.line_num%TYPE,
343: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
344: x_distribution_num IN po_online_report_text.distribution_num%TYPE
345: );

Line 342: x_line_num IN po_online_report_text.line_num%TYPE,

338: x_task_id IN NUMBER,
339: -- x_exp_item_date IN OUT NOCOPY DATE,
340: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
341: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
342: x_line_num IN po_online_report_text.line_num%TYPE,
343: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
344: x_distribution_num IN po_online_report_text.distribution_num%TYPE
345: );
346:

Line 343: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

339: -- x_exp_item_date IN OUT NOCOPY DATE,
340: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
341: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
342: x_line_num IN po_online_report_text.line_num%TYPE,
343: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
344: x_distribution_num IN po_online_report_text.distribution_num%TYPE
345: );
346:
347: -- End bug 14296213

Line 344: x_distribution_num IN po_online_report_text.distribution_num%TYPE

340: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
341: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
342: x_line_num IN po_online_report_text.line_num%TYPE,
343: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
344: x_distribution_num IN po_online_report_text.distribution_num%TYPE
345: );
346:
347: -- End bug 14296213
348:

Line 353: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

349:
350: --
351: PROCEDURE validate_blanket_ref(
352: p_blanket_id IN PO_LINES_ALL.from_header_id%TYPE,
353: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
354: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
355: x_line_num IN po_online_report_text.line_num%TYPE
356: );
357:

Line 354: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

350: --
351: PROCEDURE validate_blanket_ref(
352: p_blanket_id IN PO_LINES_ALL.from_header_id%TYPE,
353: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
354: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
355: x_line_num IN po_online_report_text.line_num%TYPE
356: );
357:
358: --

Line 355: x_line_num IN po_online_report_text.line_num%TYPE

351: PROCEDURE validate_blanket_ref(
352: p_blanket_id IN PO_LINES_ALL.from_header_id%TYPE,
353: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
354: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
355: x_line_num IN po_online_report_text.line_num%TYPE
356: );
357:
358: --
359: PROCEDURE clm_named_cols_check(

Line 361: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

357:
358: --
359: PROCEDURE clm_named_cols_check(
360: x_po_header_record IN po_headers%ROWTYPE,
361: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
362: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
363: );
364:
365: -- end private function declarations

Line 362: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE

358: --
359: PROCEDURE clm_named_cols_check(
360: x_po_header_record IN po_headers%ROWTYPE,
361: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
362: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
363: );
364:
365: -- end private function declarations
366:

Line 374: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

370: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
371: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
372: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
373: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
374: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
375: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
376: ) IS
377:
378: x_progress VARCHAR2(4) := NULL;

Line 375: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE

371: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
372: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
373: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
374: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
375: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
376: ) IS
377:
378: x_progress VARCHAR2(4) := NULL;
379:

Line 433: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

429: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
430: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
431: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
432: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
433: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
434: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
435: ) IS
436:
437: x_progress VARCHAR2(4) := NULL;

Line 434: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE

430: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
431: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
432: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
433: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
434: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
435: ) IS
436:
437: x_progress VARCHAR2(4) := NULL;
438:

Line 496: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

492: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
493: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
494: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
495: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
496: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
497: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
498: ) IS
499:
500: x_progress VARCHAR2(4) := NULL;

Line 497: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE

493: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
494: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
495: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
496: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
497: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
498: ) IS
499:
500: x_progress VARCHAR2(4) := NULL;
501:

Line 553: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

549:
550:
551: PROCEDURE validate_buyer_id(
552: x_buyer_id IN OUT NOCOPY po_headers.agent_id%TYPE,
553: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
554: x_sequence IN OUT NOCOPY po_online_report_text.line_num%TYPE
555: ) IS
556: x_valid_flag VARCHAR2(2) := NULL;
557: x_progress VARCHAR2(4) := NULL;

Line 554: x_sequence IN OUT NOCOPY po_online_report_text.line_num%TYPE

550:
551: PROCEDURE validate_buyer_id(
552: x_buyer_id IN OUT NOCOPY po_headers.agent_id%TYPE,
553: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
554: x_sequence IN OUT NOCOPY po_online_report_text.line_num%TYPE
555: ) IS
556: x_valid_flag VARCHAR2(2) := NULL;
557: x_progress VARCHAR2(4) := NULL;
558:

Line 613: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

609: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
610: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
611: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
612: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
613: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
614: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
615: ) IS
616:
617: x_progress VARCHAR2(4) := NULL;

Line 614: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE

610: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
611: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
612: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
613: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
614: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
615: ) IS
616:
617: x_progress VARCHAR2(4) := NULL;
618: x_valid_flag VARCHAR2(2) := NULL;

Line 770: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

766: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
767: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
768: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
769: x_clm_flag IN po_doc_style_headers.clm_flag%TYPE, -- CLM
770: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
771: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
772: ) IS
773:
774: x_progress VARCHAR2(4) := NULL;

Line 771: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE

767: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
768: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
769: x_clm_flag IN po_doc_style_headers.clm_flag%TYPE, -- CLM
770: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
771: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
772: ) IS
773:
774: x_progress VARCHAR2(4) := NULL;
775: x_valid_flag VARCHAR2(2) := NULL;

Line 919: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

915: x_item_revision IN OUT NOCOPY po_lines.item_revision%TYPE,
916: x_category_id IN OUT NOCOPY po_lines.category_id%TYPE,
917: x_line_type_id IN po_lines.line_type_id%TYPE,
918: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
919: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
920: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
921: x_line_num IN po_online_report_text.line_num%TYPE,
922: x_clm_info_flag IN po_lines.clm_info_flag%TYPE, --CLM
923: x_return_code OUT NOCOPY NUMBER

Line 920: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

916: x_category_id IN OUT NOCOPY po_lines.category_id%TYPE,
917: x_line_type_id IN po_lines.line_type_id%TYPE,
918: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
919: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
920: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
921: x_line_num IN po_online_report_text.line_num%TYPE,
922: x_clm_info_flag IN po_lines.clm_info_flag%TYPE, --CLM
923: x_return_code OUT NOCOPY NUMBER
924: ) IS

Line 921: x_line_num IN po_online_report_text.line_num%TYPE,

917: x_line_type_id IN po_lines.line_type_id%TYPE,
918: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
919: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
920: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
921: x_line_num IN po_online_report_text.line_num%TYPE,
922: x_clm_info_flag IN po_lines.clm_info_flag%TYPE, --CLM
923: x_return_code OUT NOCOPY NUMBER
924: ) IS
925:

Line 1245: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

1241: x_account_id IN OUT NOCOPY NUMBER,
1242: x_account_type IN VARCHAR2,
1243: x_gl_date IN DATE,
1244: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
1245: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1246: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1247: x_line_num IN po_online_report_text.line_num%TYPE,
1248: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1249: x_distribution_num IN po_online_report_text.distribution_num%TYPE

Line 1246: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

1242: x_account_type IN VARCHAR2,
1243: x_gl_date IN DATE,
1244: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
1245: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1246: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1247: x_line_num IN po_online_report_text.line_num%TYPE,
1248: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1249: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1250: )IS

Line 1247: x_line_num IN po_online_report_text.line_num%TYPE,

1243: x_gl_date IN DATE,
1244: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
1245: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1246: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1247: x_line_num IN po_online_report_text.line_num%TYPE,
1248: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1249: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1250: )IS
1251: x_valid_flag VARCHAR2(2);

Line 1248: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

1244: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
1245: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1246: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1247: x_line_num IN po_online_report_text.line_num%TYPE,
1248: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1249: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1250: )IS
1251: x_valid_flag VARCHAR2(2);
1252: x_progress VARCHAR2(4) := NULL;

Line 1249: x_distribution_num IN po_online_report_text.distribution_num%TYPE

1245: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1246: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1247: x_line_num IN po_online_report_text.line_num%TYPE,
1248: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1249: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1250: )IS
1251: x_valid_flag VARCHAR2(2);
1252: x_progress VARCHAR2(4) := NULL;
1253:

Line 1308: * Modifies: PO_ONLINE_REPORT_TEXT

1304:
1305: /**
1306: * Private Procedure: validate_project_id
1307: * Requires: Destination type is EXPENSE.
1308: * Modifies: PO_ONLINE_REPORT_TEXT
1309: * Effects: Validates that the given project_id exists as a
1310: * chargeable PA project. If not, writes an error message to
1311: * PO_ONLINE_REPORT_TEXT.
1312: * Returns: none

Line 1311: * PO_ONLINE_REPORT_TEXT.

1307: * Requires: Destination type is EXPENSE.
1308: * Modifies: PO_ONLINE_REPORT_TEXT
1309: * Effects: Validates that the given project_id exists as a
1310: * chargeable PA project. If not, writes an error message to
1311: * PO_ONLINE_REPORT_TEXT.
1312: * Returns: none
1313: */
1314: PROCEDURE validate_project_id(
1315: x_project_id IN OUT NOCOPY po_distributions.project_id%TYPE,

Line 1321: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

1317: -- Removed the x_destination_type_code and x_ship_to_organization_id arguments.
1318: -- Added NOCOPY to x_project_id and x_sequence.
1319: -- x_destination_type_code IN po_distributions.destination_type_code%TYPE,
1320: -- x_ship_to_organization_id IN NUMBER,
1321: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1322: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1323: x_line_num IN po_online_report_text.line_num%TYPE,
1324: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1325: x_distribution_num IN po_online_report_text.distribution_num%TYPE

Line 1322: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

1318: -- Added NOCOPY to x_project_id and x_sequence.
1319: -- x_destination_type_code IN po_distributions.destination_type_code%TYPE,
1320: -- x_ship_to_organization_id IN NUMBER,
1321: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1322: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1323: x_line_num IN po_online_report_text.line_num%TYPE,
1324: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1325: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1326: )IS

Line 1323: x_line_num IN po_online_report_text.line_num%TYPE,

1319: -- x_destination_type_code IN po_distributions.destination_type_code%TYPE,
1320: -- x_ship_to_organization_id IN NUMBER,
1321: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1322: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1323: x_line_num IN po_online_report_text.line_num%TYPE,
1324: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1325: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1326: )IS
1327: x_valid_flag VARCHAR2(2);

Line 1324: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

1320: -- x_ship_to_organization_id IN NUMBER,
1321: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1322: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1323: x_line_num IN po_online_report_text.line_num%TYPE,
1324: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1325: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1326: )IS
1327: x_valid_flag VARCHAR2(2);
1328: x_progress VARCHAR2(4) := NULL;

Line 1325: x_distribution_num IN po_online_report_text.distribution_num%TYPE

1321: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1322: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1323: x_line_num IN po_online_report_text.line_num%TYPE,
1324: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1325: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1326: )IS
1327: x_valid_flag VARCHAR2(2);
1328: x_progress VARCHAR2(4) := NULL;
1329:

Line 1388: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

1384:
1385: PROCEDURE validate_task_id(
1386: x_task_id IN OUT NOCOPY NUMBER,
1387: x_project_id IN NUMBER,
1388: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1389: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1390: x_line_num IN po_online_report_text.line_num%TYPE,
1391: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1392: x_distribution_num IN po_online_report_text.distribution_num%TYPE

Line 1389: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

1385: PROCEDURE validate_task_id(
1386: x_task_id IN OUT NOCOPY NUMBER,
1387: x_project_id IN NUMBER,
1388: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1389: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1390: x_line_num IN po_online_report_text.line_num%TYPE,
1391: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1392: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1393: )IS

Line 1390: x_line_num IN po_online_report_text.line_num%TYPE,

1386: x_task_id IN OUT NOCOPY NUMBER,
1387: x_project_id IN NUMBER,
1388: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1389: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1390: x_line_num IN po_online_report_text.line_num%TYPE,
1391: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1392: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1393: )IS
1394: x_valid_flag VARCHAR2(2);

Line 1391: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

1387: x_project_id IN NUMBER,
1388: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1389: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1390: x_line_num IN po_online_report_text.line_num%TYPE,
1391: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1392: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1393: )IS
1394: x_valid_flag VARCHAR2(2);
1395: x_progress VARCHAR2(4) := NULL;

Line 1392: x_distribution_num IN po_online_report_text.distribution_num%TYPE

1388: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1389: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1390: x_line_num IN po_online_report_text.line_num%TYPE,
1391: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1392: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1393: )IS
1394: x_valid_flag VARCHAR2(2);
1395: x_progress VARCHAR2(4) := NULL;
1396:

Line 1438: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

1434: PROCEDURE validate_exp_item_date(
1435: x_project_id IN NUMBER,
1436: x_task_id IN NUMBER,
1437: x_exp_item_date IN OUT NOCOPY DATE,
1438: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1439: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1440: x_line_num IN po_online_report_text.line_num%TYPE,
1441: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1442: x_distribution_num IN po_online_report_text.distribution_num%TYPE

Line 1439: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

1435: x_project_id IN NUMBER,
1436: x_task_id IN NUMBER,
1437: x_exp_item_date IN OUT NOCOPY DATE,
1438: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1439: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1440: x_line_num IN po_online_report_text.line_num%TYPE,
1441: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1442: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1443: )IS

Line 1440: x_line_num IN po_online_report_text.line_num%TYPE,

1436: x_task_id IN NUMBER,
1437: x_exp_item_date IN OUT NOCOPY DATE,
1438: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1439: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1440: x_line_num IN po_online_report_text.line_num%TYPE,
1441: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1442: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1443: )IS
1444: x_valid_flag VARCHAR2(2) := 'N';

Line 1441: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

1437: x_exp_item_date IN OUT NOCOPY DATE,
1438: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1439: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1440: x_line_num IN po_online_report_text.line_num%TYPE,
1441: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1442: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1443: )IS
1444: x_valid_flag VARCHAR2(2) := 'N';
1445: x_progress VARCHAR2(4) := NULL;

Line 1442: x_distribution_num IN po_online_report_text.distribution_num%TYPE

1438: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1439: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1440: x_line_num IN po_online_report_text.line_num%TYPE,
1441: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1442: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1443: )IS
1444: x_valid_flag VARCHAR2(2) := 'N';
1445: x_progress VARCHAR2(4) := NULL;
1446: BEGIN

Line 1488: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

1484:
1485: PROCEDURE validate_exp_type(
1486: x_project_id IN NUMBER,
1487: x_exp_type IN OUT NOCOPY po_distributions.expenditure_type%TYPE,
1488: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1489: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1490: x_line_num IN po_online_report_text.line_num%TYPE,
1491: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1492: x_distribution_num IN po_online_report_text.distribution_num%TYPE

Line 1489: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

1485: PROCEDURE validate_exp_type(
1486: x_project_id IN NUMBER,
1487: x_exp_type IN OUT NOCOPY po_distributions.expenditure_type%TYPE,
1488: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1489: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1490: x_line_num IN po_online_report_text.line_num%TYPE,
1491: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1492: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1493: )IS

Line 1490: x_line_num IN po_online_report_text.line_num%TYPE,

1486: x_project_id IN NUMBER,
1487: x_exp_type IN OUT NOCOPY po_distributions.expenditure_type%TYPE,
1488: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1489: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1490: x_line_num IN po_online_report_text.line_num%TYPE,
1491: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1492: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1493: )IS
1494: x_valid_flag VARCHAR2(2) := 'N';

Line 1491: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

1487: x_exp_type IN OUT NOCOPY po_distributions.expenditure_type%TYPE,
1488: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1489: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1490: x_line_num IN po_online_report_text.line_num%TYPE,
1491: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1492: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1493: )IS
1494: x_valid_flag VARCHAR2(2) := 'N';
1495: x_progress VARCHAR2(4) := NULL;

Line 1492: x_distribution_num IN po_online_report_text.distribution_num%TYPE

1488: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1489: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1490: x_line_num IN po_online_report_text.line_num%TYPE,
1491: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1492: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1493: )IS
1494: x_valid_flag VARCHAR2(2) := 'N';
1495: x_progress VARCHAR2(4) := NULL;
1496: BEGIN

Line 1532: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

1528: END validate_exp_type;
1529:
1530: PROCEDURE validate_exp_org(
1531: x_org_id IN OUT NOCOPY NUMBER,
1532: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1533: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1534: x_line_num IN po_online_report_text.line_num%TYPE,
1535: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1536: x_distribution_num IN po_online_report_text.distribution_num%TYPE

Line 1533: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

1529:
1530: PROCEDURE validate_exp_org(
1531: x_org_id IN OUT NOCOPY NUMBER,
1532: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1533: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1534: x_line_num IN po_online_report_text.line_num%TYPE,
1535: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1536: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1537: )IS

Line 1534: x_line_num IN po_online_report_text.line_num%TYPE,

1530: PROCEDURE validate_exp_org(
1531: x_org_id IN OUT NOCOPY NUMBER,
1532: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1533: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1534: x_line_num IN po_online_report_text.line_num%TYPE,
1535: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1536: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1537: )IS
1538: x_valid_flag VARCHAR2(2) := 'N';

Line 1535: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

1531: x_org_id IN OUT NOCOPY NUMBER,
1532: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1533: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1534: x_line_num IN po_online_report_text.line_num%TYPE,
1535: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1536: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1537: )IS
1538: x_valid_flag VARCHAR2(2) := 'N';
1539: x_progress VARCHAR2(4) := NULL;

Line 1536: x_distribution_num IN po_online_report_text.distribution_num%TYPE

1532: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1533: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1534: x_line_num IN po_online_report_text.line_num%TYPE,
1535: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1536: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1537: )IS
1538: x_valid_flag VARCHAR2(2) := 'N';
1539: x_progress VARCHAR2(4) := NULL;
1540: BEGIN

Line 1576: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

1572: PROCEDURE validate_proj_end_date(
1573: x_project_id IN NUMBER,
1574: x_task_id IN NUMBER,
1575: -- x_exp_item_date IN OUT NOCOPY DATE,
1576: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1577: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1578: x_line_num IN po_online_report_text.line_num%TYPE,
1579: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1580: x_distribution_num IN po_online_report_text.distribution_num%TYPE

Line 1577: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

1573: x_project_id IN NUMBER,
1574: x_task_id IN NUMBER,
1575: -- x_exp_item_date IN OUT NOCOPY DATE,
1576: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1577: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1578: x_line_num IN po_online_report_text.line_num%TYPE,
1579: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1580: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1581: )IS

Line 1578: x_line_num IN po_online_report_text.line_num%TYPE,

1574: x_task_id IN NUMBER,
1575: -- x_exp_item_date IN OUT NOCOPY DATE,
1576: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1577: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1578: x_line_num IN po_online_report_text.line_num%TYPE,
1579: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1580: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1581: )IS
1582: x_valid_flag VARCHAR2(2) := 'N';

Line 1579: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

1575: -- x_exp_item_date IN OUT NOCOPY DATE,
1576: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1577: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1578: x_line_num IN po_online_report_text.line_num%TYPE,
1579: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1580: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1581: )IS
1582: x_valid_flag VARCHAR2(2) := 'N';
1583: x_progress VARCHAR2(4) := NULL;

Line 1580: x_distribution_num IN po_online_report_text.distribution_num%TYPE

1576: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1577: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1578: x_line_num IN po_online_report_text.line_num%TYPE,
1579: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1580: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1581: )IS
1582: x_valid_flag VARCHAR2(2) := 'N';
1583: x_progress VARCHAR2(4) := NULL;
1584: BEGIN

Line 1614: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

1610: PROCEDURE validate_task_end_date(
1611: x_project_id IN NUMBER,
1612: x_task_id IN NUMBER,
1613: -- x_exp_item_date IN OUT NOCOPY DATE,
1614: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1615: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1616: x_line_num IN po_online_report_text.line_num%TYPE,
1617: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1618: x_distribution_num IN po_online_report_text.distribution_num%TYPE

Line 1615: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

1611: x_project_id IN NUMBER,
1612: x_task_id IN NUMBER,
1613: -- x_exp_item_date IN OUT NOCOPY DATE,
1614: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1615: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1616: x_line_num IN po_online_report_text.line_num%TYPE,
1617: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1618: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1619: )IS

Line 1616: x_line_num IN po_online_report_text.line_num%TYPE,

1612: x_task_id IN NUMBER,
1613: -- x_exp_item_date IN OUT NOCOPY DATE,
1614: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1615: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1616: x_line_num IN po_online_report_text.line_num%TYPE,
1617: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1618: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1619: )IS
1620: x_valid_flag VARCHAR2(2) := 'N';

Line 1617: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

1613: -- x_exp_item_date IN OUT NOCOPY DATE,
1614: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1615: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1616: x_line_num IN po_online_report_text.line_num%TYPE,
1617: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1618: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1619: )IS
1620: x_valid_flag VARCHAR2(2) := 'N';
1621: x_progress VARCHAR2(4) := NULL;

Line 1618: x_distribution_num IN po_online_report_text.distribution_num%TYPE

1614: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1615: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1616: x_line_num IN po_online_report_text.line_num%TYPE,
1617: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1618: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1619: )IS
1620: x_valid_flag VARCHAR2(2) := 'N';
1621: x_progress VARCHAR2(4) := NULL;
1622: BEGIN

Line 1664: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

1660: x_destination_type_code IN OUT NOCOPY po_distributions.destination_type_code%TYPE,
1661: x_item_id IN po_lines.item_id%TYPE,
1662: x_ship_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
1663: x_accrue_on_receipt_flag IN varchar2,
1664: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1665: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1666: x_line_num IN po_online_report_text.line_num%TYPE,
1667: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1668: x_distribution_num IN po_online_report_text.distribution_num%TYPE,

Line 1665: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

1661: x_item_id IN po_lines.item_id%TYPE,
1662: x_ship_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
1663: x_accrue_on_receipt_flag IN varchar2,
1664: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1665: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1666: x_line_num IN po_online_report_text.line_num%TYPE,
1667: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1668: x_distribution_num IN po_online_report_text.distribution_num%TYPE,
1669: x_line_location_id IN po_line_locations.line_location_id%TYPE, -- CONSIGNED FPI START

Line 1666: x_line_num IN po_online_report_text.line_num%TYPE,

1662: x_ship_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
1663: x_accrue_on_receipt_flag IN varchar2,
1664: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1665: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1666: x_line_num IN po_online_report_text.line_num%TYPE,
1667: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1668: x_distribution_num IN po_online_report_text.distribution_num%TYPE,
1669: x_line_location_id IN po_line_locations.line_location_id%TYPE, -- CONSIGNED FPI START
1670: x_po_line_id IN po_lines.po_line_id%TYPE, -- Bug 3557910

Line 1667: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

1663: x_accrue_on_receipt_flag IN varchar2,
1664: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1665: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1666: x_line_num IN po_online_report_text.line_num%TYPE,
1667: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1668: x_distribution_num IN po_online_report_text.distribution_num%TYPE,
1669: x_line_location_id IN po_line_locations.line_location_id%TYPE, -- CONSIGNED FPI START
1670: x_po_line_id IN po_lines.po_line_id%TYPE, -- Bug 3557910
1671: p_transaction_flow_header_id IN NUMBER --< Bug 3546252 >

Line 1668: x_distribution_num IN po_online_report_text.distribution_num%TYPE,

1664: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1665: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1666: x_line_num IN po_online_report_text.line_num%TYPE,
1667: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1668: x_distribution_num IN po_online_report_text.distribution_num%TYPE,
1669: x_line_location_id IN po_line_locations.line_location_id%TYPE, -- CONSIGNED FPI START
1670: x_po_line_id IN po_lines.po_line_id%TYPE, -- Bug 3557910
1671: p_transaction_flow_header_id IN NUMBER --< Bug 3546252 >
1672: ) IS

Line 1827: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

1823:
1824: /* deliver_to_person = Requestor */
1825: PROCEDURE validate_deliver_to_person_id(
1826: x_deliver_to_person_id IN OUT NOCOPY po_distributions.deliver_to_person_id%TYPE,
1827: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1828: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1829: x_line_num IN po_online_report_text.line_num%TYPE,
1830: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1831: x_distribution_num IN po_online_report_text.distribution_num%TYPE

Line 1828: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

1824: /* deliver_to_person = Requestor */
1825: PROCEDURE validate_deliver_to_person_id(
1826: x_deliver_to_person_id IN OUT NOCOPY po_distributions.deliver_to_person_id%TYPE,
1827: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1828: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1829: x_line_num IN po_online_report_text.line_num%TYPE,
1830: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1831: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1832: )IS

Line 1829: x_line_num IN po_online_report_text.line_num%TYPE,

1825: PROCEDURE validate_deliver_to_person_id(
1826: x_deliver_to_person_id IN OUT NOCOPY po_distributions.deliver_to_person_id%TYPE,
1827: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1828: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1829: x_line_num IN po_online_report_text.line_num%TYPE,
1830: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1831: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1832: )IS
1833: x_valid_flag VARCHAR2(2);

Line 1830: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

1826: x_deliver_to_person_id IN OUT NOCOPY po_distributions.deliver_to_person_id%TYPE,
1827: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1828: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1829: x_line_num IN po_online_report_text.line_num%TYPE,
1830: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1831: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1832: )IS
1833: x_valid_flag VARCHAR2(2);
1834: x_progress VARCHAR2(4) := NULL;

Line 1831: x_distribution_num IN po_online_report_text.distribution_num%TYPE

1827: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1828: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1829: x_line_num IN po_online_report_text.line_num%TYPE,
1830: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1831: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1832: )IS
1833: x_valid_flag VARCHAR2(2);
1834: x_progress VARCHAR2(4) := NULL;
1835:

Line 1889: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

1885: x_wip_resource_seq_num IN NUMBER,
1886: x_wip_repetitive_schedule_id IN NUMBER,
1887: x_wip_line_id IN NUMBER,
1888: x_destination_organization_id IN NUMBER,
1889: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1890: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1891: x_line_num IN po_online_report_text.line_num%TYPE,
1892: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1893: x_distribution_num IN po_online_report_text.distribution_num%TYPE)

Line 1890: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

1886: x_wip_repetitive_schedule_id IN NUMBER,
1887: x_wip_line_id IN NUMBER,
1888: x_destination_organization_id IN NUMBER,
1889: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1890: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1891: x_line_num IN po_online_report_text.line_num%TYPE,
1892: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1893: x_distribution_num IN po_online_report_text.distribution_num%TYPE)
1894: IS

Line 1891: x_line_num IN po_online_report_text.line_num%TYPE,

1887: x_wip_line_id IN NUMBER,
1888: x_destination_organization_id IN NUMBER,
1889: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1890: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1891: x_line_num IN po_online_report_text.line_num%TYPE,
1892: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1893: x_distribution_num IN po_online_report_text.distribution_num%TYPE)
1894: IS
1895: x_count number;

Line 1892: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

1888: x_destination_organization_id IN NUMBER,
1889: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1890: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1891: x_line_num IN po_online_report_text.line_num%TYPE,
1892: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1893: x_distribution_num IN po_online_report_text.distribution_num%TYPE)
1894: IS
1895: x_count number;
1896: x_progress VARCHAR2(4) := '10';

Line 1893: x_distribution_num IN po_online_report_text.distribution_num%TYPE)

1889: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1890: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1891: x_line_num IN po_online_report_text.line_num%TYPE,
1892: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1893: x_distribution_num IN po_online_report_text.distribution_num%TYPE)
1894: IS
1895: x_count number;
1896: x_progress VARCHAR2(4) := '10';
1897: --Bug# 2090549 togeorge 11/05/2001

Line 2045: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

2041: /* Deliver To Location */
2042: PROCEDURE validate_deliver_to_loc_id(
2043: x_deliver_to_location_id IN OUT NOCOPY po_distributions.deliver_to_location_id%TYPE,
2044: x_ship_to_organization_id IN NUMBER,
2045: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
2046: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
2047: x_line_num IN po_online_report_text.line_num%TYPE,
2048: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
2049: x_distribution_num IN po_online_report_text.distribution_num%TYPE

Line 2046: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

2042: PROCEDURE validate_deliver_to_loc_id(
2043: x_deliver_to_location_id IN OUT NOCOPY po_distributions.deliver_to_location_id%TYPE,
2044: x_ship_to_organization_id IN NUMBER,
2045: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
2046: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
2047: x_line_num IN po_online_report_text.line_num%TYPE,
2048: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
2049: x_distribution_num IN po_online_report_text.distribution_num%TYPE
2050: )IS

Line 2047: x_line_num IN po_online_report_text.line_num%TYPE,

2043: x_deliver_to_location_id IN OUT NOCOPY po_distributions.deliver_to_location_id%TYPE,
2044: x_ship_to_organization_id IN NUMBER,
2045: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
2046: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
2047: x_line_num IN po_online_report_text.line_num%TYPE,
2048: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
2049: x_distribution_num IN po_online_report_text.distribution_num%TYPE
2050: )IS
2051: x_valid_flag VARCHAR2(2);

Line 2048: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

2044: x_ship_to_organization_id IN NUMBER,
2045: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
2046: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
2047: x_line_num IN po_online_report_text.line_num%TYPE,
2048: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
2049: x_distribution_num IN po_online_report_text.distribution_num%TYPE
2050: )IS
2051: x_valid_flag VARCHAR2(2);
2052: x_progress VARCHAR2(4) := NULL;

Line 2049: x_distribution_num IN po_online_report_text.distribution_num%TYPE

2045: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
2046: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
2047: x_line_num IN po_online_report_text.line_num%TYPE,
2048: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
2049: x_distribution_num IN po_online_report_text.distribution_num%TYPE
2050: )IS
2051: x_valid_flag VARCHAR2(2);
2052: x_progress VARCHAR2(4) := NULL;
2053:

Line 2106: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

2102: PROCEDURE validate_dest_subinventory(
2103: x_destination_subinventory IN OUT NOCOPY po_distributions.destination_subinventory%TYPE,
2104: x_ship_to_organization_id IN NUMBER,
2105: x_item_id IN po_lines.item_id%TYPE,
2106: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
2107: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
2108: x_line_num IN po_online_report_text.line_num%TYPE,
2109: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
2110: x_distribution_num IN po_online_report_text.distribution_num%TYPE

Line 2107: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

2103: x_destination_subinventory IN OUT NOCOPY po_distributions.destination_subinventory%TYPE,
2104: x_ship_to_organization_id IN NUMBER,
2105: x_item_id IN po_lines.item_id%TYPE,
2106: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
2107: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
2108: x_line_num IN po_online_report_text.line_num%TYPE,
2109: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
2110: x_distribution_num IN po_online_report_text.distribution_num%TYPE
2111: )IS

Line 2108: x_line_num IN po_online_report_text.line_num%TYPE,

2104: x_ship_to_organization_id IN NUMBER,
2105: x_item_id IN po_lines.item_id%TYPE,
2106: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
2107: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
2108: x_line_num IN po_online_report_text.line_num%TYPE,
2109: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
2110: x_distribution_num IN po_online_report_text.distribution_num%TYPE
2111: )IS
2112: x_valid_flag VARCHAR2(2);

Line 2109: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

2105: x_item_id IN po_lines.item_id%TYPE,
2106: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
2107: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
2108: x_line_num IN po_online_report_text.line_num%TYPE,
2109: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
2110: x_distribution_num IN po_online_report_text.distribution_num%TYPE
2111: )IS
2112: x_valid_flag VARCHAR2(2);
2113: x_progress VARCHAR2(4) := NULL;

Line 2110: x_distribution_num IN po_online_report_text.distribution_num%TYPE

2106: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
2107: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
2108: x_line_num IN po_online_report_text.line_num%TYPE,
2109: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
2110: x_distribution_num IN po_online_report_text.distribution_num%TYPE
2111: )IS
2112: x_valid_flag VARCHAR2(2);
2113: x_progress VARCHAR2(4) := NULL;
2114:

Line 2169: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

2165:
2166:
2167: PROCEDURE validate_contract_num(
2168: p_contract_id IN PO_LINES_ALL.contract_id%TYPE, --
2169: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
2170: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
2171: x_line_num IN po_online_report_text.line_num%TYPE
2172: ) IS
2173: x_valid_flag VARCHAR2(2);

Line 2170: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

2166:
2167: PROCEDURE validate_contract_num(
2168: p_contract_id IN PO_LINES_ALL.contract_id%TYPE, --
2169: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
2170: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
2171: x_line_num IN po_online_report_text.line_num%TYPE
2172: ) IS
2173: x_valid_flag VARCHAR2(2);
2174: x_progress VARCHAR2(4) := NULL;

Line 2171: x_line_num IN po_online_report_text.line_num%TYPE

2167: PROCEDURE validate_contract_num(
2168: p_contract_id IN PO_LINES_ALL.contract_id%TYPE, --
2169: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
2170: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
2171: x_line_num IN po_online_report_text.line_num%TYPE
2172: ) IS
2173: x_valid_flag VARCHAR2(2);
2174: x_progress VARCHAR2(4) := NULL;
2175:

Line 2239: p_online_report_id IN po_online_report_text.online_report_id%TYPE,

2235: --finally closed
2236: PROCEDURE validate_global_ref(
2237: p_from_header_id IN po_headers_all.po_header_id%TYPE,
2238: p_from_line_id IN po_lines_all.po_line_id%TYPE,
2239: p_online_report_id IN po_online_report_text.online_report_id%TYPE,
2240: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
2241: p_line_num IN po_online_report_text.line_num%TYPE
2242: ) IS
2243: l_valid_flag VARCHAR2(2);

Line 2240: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

2236: PROCEDURE validate_global_ref(
2237: p_from_header_id IN po_headers_all.po_header_id%TYPE,
2238: p_from_line_id IN po_lines_all.po_line_id%TYPE,
2239: p_online_report_id IN po_online_report_text.online_report_id%TYPE,
2240: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
2241: p_line_num IN po_online_report_text.line_num%TYPE
2242: ) IS
2243: l_valid_flag VARCHAR2(2);
2244: l_progress VARCHAR2(4) := NULL;

Line 2241: p_line_num IN po_online_report_text.line_num%TYPE

2237: p_from_header_id IN po_headers_all.po_header_id%TYPE,
2238: p_from_line_id IN po_lines_all.po_line_id%TYPE,
2239: p_online_report_id IN po_online_report_text.online_report_id%TYPE,
2240: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
2241: p_line_num IN po_online_report_text.line_num%TYPE
2242: ) IS
2243: l_valid_flag VARCHAR2(2);
2244: l_progress VARCHAR2(4) := NULL;
2245:

Line 2308: p_online_report_id IN po_online_report_text.online_report_id%TYPE,

2304: --End of Comments
2305: -------------------------------------------------------------------------------------------------
2306: PROCEDURE validate_job(
2307: p_job_id IN po_lines.job_id%TYPE,
2308: p_online_report_id IN po_online_report_text.online_report_id%TYPE,
2309: p_line_num IN po_online_report_text.line_num%TYPE,
2310: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
2311: ) IS
2312:

Line 2309: p_line_num IN po_online_report_text.line_num%TYPE,

2305: -------------------------------------------------------------------------------------------------
2306: PROCEDURE validate_job(
2307: p_job_id IN po_lines.job_id%TYPE,
2308: p_online_report_id IN po_online_report_text.online_report_id%TYPE,
2309: p_line_num IN po_online_report_text.line_num%TYPE,
2310: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
2311: ) IS
2312:
2313: l_valid_flag VARCHAR2(2);

Line 2310: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE

2306: PROCEDURE validate_job(
2307: p_job_id IN po_lines.job_id%TYPE,
2308: p_online_report_id IN po_online_report_text.online_report_id%TYPE,
2309: p_line_num IN po_online_report_text.line_num%TYPE,
2310: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
2311: ) IS
2312:
2313: l_valid_flag VARCHAR2(2);
2314: l_progress VARCHAR2(4) := NULL;

Line 2427: x_line_num po_online_report_text.line_num%TYPE := NULL;

2423: x_po_line_record po_lines%ROWTYPE;
2424: x_po_shipment_record po_line_locations%ROWTYPE;
2425: x_po_distribution_record po_distributions%ROWTYPE;
2426:
2427: x_line_num po_online_report_text.line_num%TYPE := NULL;
2428: x_shipment_num po_online_report_text.shipment_num%TYPE := NULL;
2429: x_distribution_num po_online_report_text.distribution_num%TYPE := NULL;
2430:
2431: x_progress VARCHAR2(4);

Line 2428: x_shipment_num po_online_report_text.shipment_num%TYPE := NULL;

2424: x_po_shipment_record po_line_locations%ROWTYPE;
2425: x_po_distribution_record po_distributions%ROWTYPE;
2426:
2427: x_line_num po_online_report_text.line_num%TYPE := NULL;
2428: x_shipment_num po_online_report_text.shipment_num%TYPE := NULL;
2429: x_distribution_num po_online_report_text.distribution_num%TYPE := NULL;
2430:
2431: x_progress VARCHAR2(4);
2432: x_sequence po_online_report_text.sequence%TYPE := 1;

Line 2429: x_distribution_num po_online_report_text.distribution_num%TYPE := NULL;

2425: x_po_distribution_record po_distributions%ROWTYPE;
2426:
2427: x_line_num po_online_report_text.line_num%TYPE := NULL;
2428: x_shipment_num po_online_report_text.shipment_num%TYPE := NULL;
2429: x_distribution_num po_online_report_text.distribution_num%TYPE := NULL;
2430:
2431: x_progress VARCHAR2(4);
2432: x_sequence po_online_report_text.sequence%TYPE := 1;
2433: x_return_code NUMBER := NULL;

Line 2432: x_sequence po_online_report_text.sequence%TYPE := 1;

2428: x_shipment_num po_online_report_text.shipment_num%TYPE := NULL;
2429: x_distribution_num po_online_report_text.distribution_num%TYPE := NULL;
2430:
2431: x_progress VARCHAR2(4);
2432: x_sequence po_online_report_text.sequence%TYPE := 1;
2433: x_return_code NUMBER := NULL;
2434:
2435: --
2436: l_encumbrance_on BOOLEAN;

Line 2887: -- Write the message to the PO_ONLINE_REPORT_TEXT table as an error.

2883: , X_msg_data => X_msg_data
2884: , X_billable_flag => X_billable_flag);
2885:
2886: IF x_msg_type = 'E' and x_msg_data is not NULL THEN
2887: -- Write the message to the PO_ONLINE_REPORT_TEXT table as an error.
2888: po_copydoc_s1.online_report(x_online_report_id,
2889: x_sequence, x_msg_data,
2890: x_line_num, x_shipment_num, x_distribution_num,
2891: PO_COPYDOC_S1.G_ERROR_MESSAGE_TYPE);

Line 2893: -- Write the message to the PO_ONLINE_REPORT_TEXT table as a warning.

2889: x_sequence, x_msg_data,
2890: x_line_num, x_shipment_num, x_distribution_num,
2891: PO_COPYDOC_S1.G_ERROR_MESSAGE_TYPE);
2892: ELSIF x_msg_type = 'W' and x_msg_data is not NULL THEN
2893: -- Write the message to the PO_ONLINE_REPORT_TEXT table as a warning.
2894: po_copydoc_s1.online_report(x_online_report_id,
2895: x_sequence, x_msg_data,
2896: x_line_num, x_shipment_num, x_distribution_num,
2897: PO_COPYDOC_S1.G_WARNING_MESSAGE_TYPE);

Line 2917: -- Write the message to the PO_ONLINE_REPORT_TEXT table as an error.

2913: x_error_code => l_val_proj_error_code,
2914: x_return_code => l_val_proj_result);
2915:
2916: IF ( l_val_proj_result = PO_PROJECT_DETAILS_SV.pjm_validate_failure) THEN
2917: -- Write the message to the PO_ONLINE_REPORT_TEXT table as an error.
2918: po_copydoc_s1.online_report(x_online_report_id,
2919: x_sequence, FND_MESSAGE.get,
2920: x_line_num, x_shipment_num, x_distribution_num,
2921: PO_COPYDOC_S1.G_ERROR_MESSAGE_TYPE);

Line 2923: -- Write the message to the PO_ONLINE_REPORT_TEXT table as a warning.

2919: x_sequence, FND_MESSAGE.get,
2920: x_line_num, x_shipment_num, x_distribution_num,
2921: PO_COPYDOC_S1.G_ERROR_MESSAGE_TYPE);
2922: ELSIF ( l_val_proj_result = PO_PROJECT_DETAILS_SV.pjm_validate_warning) THEN
2923: -- Write the message to the PO_ONLINE_REPORT_TEXT table as a warning.
2924: po_copydoc_s1.online_report(x_online_report_id,
2925: x_sequence, FND_MESSAGE.get,
2926: x_line_num, x_shipment_num, x_distribution_num,
2927: PO_COPYDOC_S1.G_WARNING_MESSAGE_TYPE);

Line 3016: -- PO_ONLINE_REPORT_TEXT

3012: --Name: validate_transaction_flow
3013: --Pre-reqs:
3014: -- None.
3015: --Modifies:
3016: -- PO_ONLINE_REPORT_TEXT
3017: --Locks:
3018: -- None.
3019: --Function:
3020: -- Validates the transaction flow if it is not NULL. If it is a valid

Line 3034: -- PO_ONLINE_REPORT_TEXT.sequence.

3030: --p_shipment_num
3031: --p_item_id
3032: --IN OUT:
3033: --x_sequence
3034: -- PO_ONLINE_REPORT_TEXT.sequence.
3035: --End of Comments
3036: --------------------------------------------------------------------------------
3037: PROCEDURE validate_transaction_flow
3038: (

Line 3124: -- PO_ONLINE_REPORT_TEXT

3120: --Name: validate_org_assignments
3121: --Pre-reqs:
3122: -- None.
3123: --Modifies:
3124: -- PO_ONLINE_REPORT_TEXT
3125: -- PO_SESSION_GT
3126: -- PO_SESSION_GT_S
3127: --Locks:
3128: -- None.

Line 3133: -- error message to PO_ONLINE_REPORT_TEXT table under ID p_online_report_id

3129: --Function:
3130: -- Validates all the enabled org assignments of the Global Agreement
3131: -- p_po_header_id. Checks if the Requesting Org, Purchasing Org, and
3132: -- Purchasing Site are still valid for all the enabled records. Inserts an
3133: -- error message to PO_ONLINE_REPORT_TEXT table under ID p_online_report_id
3134: -- for each check that fails.
3135: --Parameters:
3136: --IN:
3137: --p_po_header_id

Line 3146: -- written to PO_ONLINE_REPORT_TEXT.

3142: -- The online report ID to write to if an error occurs.
3143: --IN OUT:
3144: --x_sequence
3145: -- The online report sequence, which gets incremented when an error is
3146: -- written to PO_ONLINE_REPORT_TEXT.
3147: --End of Comments
3148: --------------------------------------------------------------------------------
3149: PROCEDURE validate_org_assignments
3150: (

Line 3166: l_text_line PO_ONLINE_REPORT_TEXT.text_line%TYPE;

3162: l_err_prefix VARCHAR2(256);
3163: l_populate_failed_exc EXCEPTION;
3164:
3165: l_key PO_SESSION_GT.key%TYPE;
3166: l_text_line PO_ONLINE_REPORT_TEXT.text_line%TYPE;
3167: l_message_type PO_ONLINE_REPORT_TEXT.message_type%TYPE;
3168:
3169: BEGIN
3170:

Line 3167: l_message_type PO_ONLINE_REPORT_TEXT.message_type%TYPE;

3163: l_populate_failed_exc EXCEPTION;
3164:
3165: l_key PO_SESSION_GT.key%TYPE;
3166: l_text_line PO_ONLINE_REPORT_TEXT.text_line%TYPE;
3167: l_message_type PO_ONLINE_REPORT_TEXT.message_type%TYPE;
3168:
3169: BEGIN
3170:
3171: l_progress := '000';

Line 3200: INSERT INTO po_online_report_text

3196: -- Validate the Requesting Orgs for all enabled org assignments
3197: l_text_line := FND_MESSAGE.get_string
3198: (appin => 'PO',
3199: namein => 'PO_GA_INVALID_REQUESTING_ORG');
3200: INSERT INTO po_online_report_text
3201: (
3202: online_report_id,
3203: last_update_login,
3204: last_updated_by,

Line 3248: INSERT INTO po_online_report_text

3244: -- Validate the Purchasing Orgs for all enabled org assignments
3245: l_text_line := FND_MESSAGE.get_string
3246: (appin => 'PO',
3247: namein => 'PO_GA_INVALID_PURCHASING_ORG');
3248: INSERT INTO po_online_report_text
3249: (
3250: online_report_id,
3251: last_update_login,
3252: last_updated_by,

Line 3324: INSERT INTO po_online_report_text

3320: -- Validate the Purchasing Sites for all enabled org assignments
3321: l_text_line := FND_MESSAGE.get_string
3322: (appin => 'PO',
3323: namein => 'PO_GA_INVALID_PURCHASING_SITE');
3324: INSERT INTO po_online_report_text
3325: (
3326: online_report_id,
3327: last_update_login,
3328: last_updated_by,

Line 3407: -- written to PO_ONLINE_REPORT_TEXT.

3403: -- The online report ID to write to if an error occurs.
3404: --IN OUT:
3405: --x_sequence
3406: -- The online report sequence, which gets incremented when an error is
3407: -- written to PO_ONLINE_REPORT_TEXT.
3408: --OUT:
3409: --x_return_status
3410: -- FND_API.g_ret_sts_success - success
3411: -- FND_API.g_ret_sts_unexp_error - unexpected error occurs

Line 3490: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

3486: -- Validate the Source Document status at line.
3487: -- It should not be closed, freezed, cancelled, on hold
3488: PROCEDURE validate_blanket_ref(
3489: p_blanket_id IN PO_LINES_ALL.from_header_id%TYPE,
3490: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
3491: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
3492: x_line_num IN po_online_report_text.line_num%TYPE
3493: )
3494: IS

Line 3491: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

3487: -- It should not be closed, freezed, cancelled, on hold
3488: PROCEDURE validate_blanket_ref(
3489: p_blanket_id IN PO_LINES_ALL.from_header_id%TYPE,
3490: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
3491: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
3492: x_line_num IN po_online_report_text.line_num%TYPE
3493: )
3494: IS
3495: l_valid_flag VARCHAR2(1);

Line 3492: x_line_num IN po_online_report_text.line_num%TYPE

3488: PROCEDURE validate_blanket_ref(
3489: p_blanket_id IN PO_LINES_ALL.from_header_id%TYPE,
3490: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
3491: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
3492: x_line_num IN po_online_report_text.line_num%TYPE
3493: )
3494: IS
3495: l_valid_flag VARCHAR2(1);
3496: l_progress VARCHAR2(4) := NULL;

Line 3542: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

3538:
3539: -- CLM Checks: Validations for CLM named columns
3540: PROCEDURE clm_named_cols_check(
3541: x_po_header_record IN po_headers%ROWTYPE,
3542: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
3543: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
3544: )
3545: IS
3546: l_frozen_flag VARCHAR2(1);

Line 3543: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE

3539: -- CLM Checks: Validations for CLM named columns
3540: PROCEDURE clm_named_cols_check(
3541: x_po_header_record IN po_headers%ROWTYPE,
3542: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
3543: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
3544: )
3545: IS
3546: l_frozen_flag VARCHAR2(1);
3547: l_progress VARCHAR2(4) := '000';