DBA Data[Home] [Help]

APPS.POS_ACK_SEARCH dependencies on PO_HEADERS_ALL

Line 57: from po_headers_all where po_header_id = to_number(pk1);

53:
54: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
55:
56: select org_id into l_org_id
57: from po_headers_all where po_header_id = to_number(pk1);
58:
59: update icx_sessions
60: set org_id = l_org_id
61: where session_id = l_session_id;

Line 65: from po_headers_all

61: where session_id = l_session_id;
62: commit;
63:
64: select segment1 into l_po_number
65: from po_headers_all
66: where po_header_id = to_number(pk1);
67:
68: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
69: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);

Line 1933: from po_headers_all

1929: select po_acceptances_s.nextval into l_acceptance_id
1930: from dual;
1931:
1932: select revision_num,org_id into l_revision_num , l_org_id
1933: from po_headers_all
1934: where po_header_id = pos_ack_po_header_id(l_counter);
1935:
1936: select description into l_accp_type
1937: from POS_ACK_ACC_TYPE_LOV_V