APPS.PO_COPYDOC_S2 dependencies on PO_HEADERS

Line 12: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,

8: **** Find next available po_header_id and segment1
9: *****************************************************************/
10: PROCEDURE validate_header(
11: x_action_code IN VARCHAR2,
12: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,
13: x_to_global_flag IN PO_HEADERS_ALL.global_agreement_flag%TYPE, -- FPI GA
14: x_po_header_record IN OUT NOCOPY PO_HEADERS%ROWTYPE,
15: x_to_segment1 IN po_headers.segment1%TYPE,
16: x_agent_id IN po_headers.agent_id%TYPE,

Line 13: x_to_global_flag IN PO_HEADERS_ALL.global_agreement_flag%TYPE, -- FPI GA

9: *****************************************************************/
10: PROCEDURE validate_header(
11: x_action_code IN VARCHAR2,
12: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,
13: x_to_global_flag IN PO_HEADERS_ALL.global_agreement_flag%TYPE, -- FPI GA
14: x_po_header_record IN OUT NOCOPY PO_HEADERS%ROWTYPE,
15: x_to_segment1 IN po_headers.segment1%TYPE,
16: x_agent_id IN po_headers.agent_id%TYPE,
17: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,

Line 14: x_po_header_record IN OUT NOCOPY PO_HEADERS%ROWTYPE,

10: PROCEDURE validate_header(
11: x_action_code IN VARCHAR2,
12: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,
13: x_to_global_flag IN PO_HEADERS_ALL.global_agreement_flag%TYPE, -- FPI GA
14: x_po_header_record IN OUT NOCOPY PO_HEADERS%ROWTYPE,
15: x_to_segment1 IN po_headers.segment1%TYPE,
16: x_agent_id IN po_headers.agent_id%TYPE,
17: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
18: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,

Line 15: x_to_segment1 IN po_headers.segment1%TYPE,

11: x_action_code IN VARCHAR2,
12: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,
13: x_to_global_flag IN PO_HEADERS_ALL.global_agreement_flag%TYPE, -- FPI GA
14: x_po_header_record IN OUT NOCOPY PO_HEADERS%ROWTYPE,
15: x_to_segment1 IN po_headers.segment1%TYPE,
16: x_agent_id IN po_headers.agent_id%TYPE,
17: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
18: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
19: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

Line 16: x_agent_id IN po_headers.agent_id%TYPE,

12: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,
13: x_to_global_flag IN PO_HEADERS_ALL.global_agreement_flag%TYPE, -- FPI GA
14: x_po_header_record IN OUT NOCOPY PO_HEADERS%ROWTYPE,
15: x_to_segment1 IN po_headers.segment1%TYPE,
16: x_agent_id IN po_headers.agent_id%TYPE,
17: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
18: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
19: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
20: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

Line 260: /** find the next available po_headers.po_header_id **/

256:
257: x_po_header_record.enabled_flag := 'Y';
258: x_po_header_record.summary_flag := 'N';
259:
260: /** find the next available po_headers.po_header_id **/
261: x_progress := '001';
262: BEGIN
263: SELECT po_headers_s.nextval
264: INTO x_po_header_record.po_header_id

Line 263: SELECT po_headers_s.nextval

259:
260: /** find the next available po_headers.po_header_id **/
261: x_progress := '001';
262: BEGIN
263: SELECT po_headers_s.nextval
264: INTO x_po_header_record.po_header_id
265: FROM SYS.DUAL;
266: EXCEPTION
267: WHEN OTHERS THEN

Line 296: ( x_table_name => 'PO_HEADERS_RFQ'

292: x_progress := '002';
293:
294: x_po_header_record.segment1 :=
295: PO_CORE_SV1.default_po_unique_identifier
296: ( x_table_name => 'PO_HEADERS_RFQ'
297: );
298:
299: ELSE
300: x_progress := '02a';

Line 304: ( x_table_name => 'PO_HEADERS'

300: x_progress := '02a';
301:
302: x_po_header_record.segment1 :=
303: PO_CORE_SV1.default_po_unique_identifier
304: ( x_table_name => 'PO_HEADERS'
305: );
306: END IF;
307:
308: ELSE

Line 319: FROM po_headers_all

315:
316: BEGIN
317: SELECT umbrella_program_id
318: INTO x_po_header_record.umbrella_program_id
319: FROM po_headers_all
320: WHERE po_header_id = x_po_header_record.clm_source_document_id;
321:
322: EXCEPTION
323: WHEN OTHERS THEN