DBA Data[Home] [Help]

APPS.CTO_AUTO_PROCURE_PK dependencies on PO_HEADERS_INTERFACE

Line 1457: -- , po_headers_interface phi

1453: -- p_to_currency,
1454: -- p_rate_date
1455: -- FROM hr_organization_information hoi
1456: -- , gl_sets_of_books GLB
1457: -- , po_headers_interface phi
1458: -- WHERE phi.interface_header_id = p_int_header_id
1459: -- AND hoi.organization_id = phi.org_id
1460: -- AND org_information_context = 'Operating Unit Information'
1461: -- AND TO_NUMBER(hoi.org_information3) = glb.set_of_books_id;

Line 3675: select po_headers_interface_s.nextval

3671: begin
3672:
3673: g_pg_level := g_pg_level + 3;
3674:
3675: select po_headers_interface_s.nextval
3676: into x_int_header_id
3677: from dual;
3678:
3679: If nvl(p_batch_id,-1) = -1 Then

Line 3688: Insert into Po_headers_interface(

3684: oe_debug_pub.add(lpad(' ',g_pg_level) || 'insert_blanket_header: ' || 'Interface header id ='||to_char(x_int_header_id),1);
3685: END IF;
3686:
3687:
3688: Insert into Po_headers_interface(
3689: interface_header_id,
3690: batch_id,
3691: process_code,
3692: action,