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_VENDOR_SITES_SV dependencies on PO_HEADERS

Line 26: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE

22: -- EXCEPTIONS : -
23: --==============================================================================
24: FUNCTION get_vendor_site_id
25: (
26: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
27: )
28: RETURN PO_HEADERS_ALL.vendor_site_id%TYPE
29: IS
30: x_vendor_site_id PO_HEADERS_ALL.vendor_site_id%TYPE;

Line 28: RETURN PO_HEADERS_ALL.vendor_site_id%TYPE

24: FUNCTION get_vendor_site_id
25: (
26: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
27: )
28: RETURN PO_HEADERS_ALL.vendor_site_id%TYPE
29: IS
30: x_vendor_site_id PO_HEADERS_ALL.vendor_site_id%TYPE;
31: BEGIN
32:

Line 30: x_vendor_site_id PO_HEADERS_ALL.vendor_site_id%TYPE;

26: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
27: )
28: RETURN PO_HEADERS_ALL.vendor_site_id%TYPE
29: IS
30: x_vendor_site_id PO_HEADERS_ALL.vendor_site_id%TYPE;
31: BEGIN
32:
33: SELECT vendor_site_id
34: INTO x_vendor_site_id

Line 35: FROM po_headers_all

31: BEGIN
32:
33: SELECT vendor_site_id
34: INTO x_vendor_site_id
35: FROM po_headers_all
36: WHERE po_header_id = p_po_header_id;
37:
38: return (x_vendor_site_id);
39:

Line 1054: l_party_site_id po_headers_all.vendor_site_id%type;

1050: l_fax_area po_vendor_sites_all.fax_area_code%type;
1051:
1052: l_faxnum varchar2(30); -- Need to change this also as part of bug 5765243
1053:
1054: l_party_site_id po_headers_all.vendor_site_id%type;
1055: l_party_id po_headers_all.vendor_id%type;
1056: l_retcode pls_integer;
1057: l_errmsg varchar2(2000);
1058: l_result boolean := FALSE;

Line 1055: l_party_id po_headers_all.vendor_id%type;

1051:
1052: l_faxnum varchar2(30); -- Need to change this also as part of bug 5765243
1053:
1054: l_party_site_id po_headers_all.vendor_site_id%type;
1055: l_party_id po_headers_all.vendor_id%type;
1056: l_retcode pls_integer;
1057: l_errmsg varchar2(2000);
1058: l_result boolean := FALSE;
1059: l_preparer_id po_headers.agent_id%type;

Line 1059: l_preparer_id po_headers.agent_id%type;

1055: l_party_id po_headers_all.vendor_id%type;
1056: l_retcode pls_integer;
1057: l_errmsg varchar2(2000);
1058: l_result boolean := FALSE;
1059: l_preparer_id po_headers.agent_id%type;
1060: l_authorization_status po_headers.authorization_status%type;
1061: l_transaction_subtype VARCHAR2(240);
1062:
1063: l_progress varchar2(3);

Line 1060: l_authorization_status po_headers.authorization_status%type;

1056: l_retcode pls_integer;
1057: l_errmsg varchar2(2000);
1058: l_result boolean := FALSE;
1059: l_preparer_id po_headers.agent_id%type;
1060: l_authorization_status po_headers.authorization_status%type;
1061: l_transaction_subtype VARCHAR2(240);
1062:
1063: l_progress varchar2(3);
1064: l_consigned_consumption_flag po_headers_all.consigned_consumption_flag%TYPE;

Line 1064: l_consigned_consumption_flag po_headers_all.consigned_consumption_flag%TYPE;

1060: l_authorization_status po_headers.authorization_status%type;
1061: l_transaction_subtype VARCHAR2(240);
1062:
1063: l_progress varchar2(3);
1064: l_consigned_consumption_flag po_headers_all.consigned_consumption_flag%TYPE;
1065: l_api_name CONSTANT VARCHAR2(50) := 'Get_Transmission_Defaults';
1066: l_xml_flag po_headers_all.xml_flag%TYPE; --bug fix 2764348
1067: l_approved_date po_headers_all.approved_date%TYPE; --Bug 6074733
1068:

Line 1066: l_xml_flag po_headers_all.xml_flag%TYPE; --bug fix 2764348

1062:
1063: l_progress varchar2(3);
1064: l_consigned_consumption_flag po_headers_all.consigned_consumption_flag%TYPE;
1065: l_api_name CONSTANT VARCHAR2(50) := 'Get_Transmission_Defaults';
1066: l_xml_flag po_headers_all.xml_flag%TYPE; --bug fix 2764348
1067: l_approved_date po_headers_all.approved_date%TYPE; --Bug 6074733
1068:
1069:
1070: BEGIN

Line 1067: l_approved_date po_headers_all.approved_date%TYPE; --Bug 6074733

1063: l_progress varchar2(3);
1064: l_consigned_consumption_flag po_headers_all.consigned_consumption_flag%TYPE;
1065: l_api_name CONSTANT VARCHAR2(50) := 'Get_Transmission_Defaults';
1066: l_xml_flag po_headers_all.xml_flag%TYPE; --bug fix 2764348
1067: l_approved_date po_headers_all.approved_date%TYPE; --Bug 6074733
1068:
1069:
1070: BEGIN
1071: l_progress := '000';

Line 1090: FROM po_headers_all poh

1086: x_document_num,
1087: l_party_site_id,
1088: l_party_id,
1089: l_approved_date --Bug 6074733
1090: FROM po_headers_all poh
1091: WHERE poh.po_header_id = p_document_id;
1092: exception
1093: when others then
1094: po_message_s.sql_error('Get_Transmission_Defaults',

Line 1115: from po_headers_all poh,

1111: x_document_num,
1112: l_party_site_id,
1113: l_party_id,
1114: l_approved_date --Bug 6074733
1115: from po_headers_all poh,
1116: po_releases_all por
1117: where por.po_release_id = p_document_id and
1118: poh.po_header_id = por.po_header_id ;
1119: exception

Line 1193: update po_headers_all

1189:
1190: elsif ((p_document_type = 'PO') and
1191: (p_document_subtype = 'STANDARD')) then
1192:
1193: update po_headers_all
1194: set xml_flag = l_xml_flag -- bug 2764348
1195: where po_header_id = p_document_id;
1196:
1197: end if;

Line 1216: -- 1. po_headers_all

1212: -- Bug 5295179 If the supplier notif method is defined on the
1213: -- PO (i.e. for POs created/modified in HTML), use that instead
1214: -- of the Supplier Site defaults. Also, we default email/fax
1215: -- from 3 places, in order of priority:
1216: -- 1. po_headers_all
1217: -- 2. po_vendor_contacts (see Bug 4597324)
1218: -- 3. po_vendor_sites_all
1219:
1220: -- Bug 6625807 / 6526600

Line 1240: from po_headers_all poh,

1236: into x_default_method,
1237: x_email_address,
1238: l_fax_area,
1239: l_faxnum
1240: from po_headers_all poh,
1241: po_vendor_sites_all pvs,
1242: po_vendor_contacts pvc
1243: where poh.vendor_site_id = pvs.vendor_site_id and
1244: poh.vendor_contact_id = pvc.vendor_contact_id (+) and

Line 1280: from po_headers_all poh,

1276: into x_default_method,
1277: x_email_address,
1278: l_fax_area,
1279: l_faxnum
1280: from po_headers_all poh,
1281: po_vendor_sites_all pvs,
1282: po_vendor_contacts pvc,
1283: po_releases por
1284: where poh.vendor_site_id = pvs.vendor_site_id and

Line 1323: -- po_headers_all.xml_flag, po_releases_all.xml_flag (unless

1319: --Name: get_transmission_defaults_edi
1320: --Pre-reqs:
1321: -- N/A
1322: --Modifies:
1323: -- po_headers_all.xml_flag, po_releases_all.xml_flag (unless
1324: -- p_retrieve_only_flag = 'Y')
1325: --Locks:
1326: -- N/A
1327: --Function:

Line 1399: po_headers_all ph

1395: from
1396: (select pvs.tp_header_id, ph.authorization_status, ph.type_lookup_code
1397: from po_vendor_sites_all pvs,
1398: po_vendors pv,
1399: po_headers_all ph
1400: where ph.vendor_id = pv.vendor_id (+)
1401: and ph.vendor_site_id = pvs.vendor_site_id (+)
1402: and ph.vendor_id = pvs.vendor_id (+)
1403: and ph.po_header_id = p_document_id

Line 1419: po_headers_all ph,

1415: from
1416: (select pvs.tp_header_id, pr.authorization_status
1417: from po_vendor_sites_all pvs,
1418: po_vendors pv,
1419: po_headers_all ph,
1420: po_releases_all pr
1421: where ph.vendor_id = pv.vendor_id (+)
1422: and ph.vendor_site_id = pvs.vendor_site_id (+)
1423: and ph.vendor_id = pvs.vendor_id (+)

Line 1470: RETURN PO_HEADERS_ALL.org_id%TYPE

1466: FUNCTION get_org_id_from_vendor_site
1467: (
1468: p_vendor_site_id IN NUMBER
1469: )
1470: RETURN PO_HEADERS_ALL.org_id%TYPE
1471: IS
1472: x_org_id PO_HEADERS_ALL.org_id%TYPE;
1473:
1474: BEGIN

Line 1472: x_org_id PO_HEADERS_ALL.org_id%TYPE;

1468: p_vendor_site_id IN NUMBER
1469: )
1470: RETURN PO_HEADERS_ALL.org_id%TYPE
1471: IS
1472: x_org_id PO_HEADERS_ALL.org_id%TYPE;
1473:
1474: BEGIN
1475:
1476: SELECT org_id