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: l_po_comm_email_default VARCHAR2(10); --

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: l_po_comm_email_default VARCHAR2(10); --
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: l_po_comm_email_default VARCHAR2(10); --
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 1219: -- 1. po_headers_all

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

Line 1260: from po_headers_all poh,

1256: into x_default_method,
1257: x_email_address,
1258: l_fax_area,
1259: l_faxnum
1260: from po_headers_all poh,
1261: po_vendor_sites_all pvs,
1262: po_vendor_contacts pvc
1263: where poh.vendor_site_id = pvs.vendor_site_id and
1264: poh.vendor_contact_id = pvc.vendor_contact_id (+) and

Line 1304: from po_headers_all poh,

1300: into x_default_method,
1301: x_email_address,
1302: l_fax_area,
1303: l_faxnum
1304: from po_headers_all poh,
1305: po_vendor_sites_all pvs,
1306: po_vendor_contacts pvc,
1307: po_releases por
1308: where poh.vendor_site_id = pvs.vendor_site_id and

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

1343: --Name: get_transmission_defaults_edi
1344: --Pre-reqs:
1345: -- N/A
1346: --Modifies:
1347: -- po_headers_all.xml_flag, po_releases_all.xml_flag (unless
1348: -- p_retrieve_only_flag = 'Y')
1349: --Locks:
1350: -- N/A
1351: --Function:

Line 1423: po_headers_all ph

1419: from
1420: (select pvs.tp_header_id, ph.authorization_status, ph.type_lookup_code
1421: from po_vendor_sites_all pvs,
1422: po_vendors pv,
1423: po_headers_all ph
1424: where ph.vendor_id = pv.vendor_id (+)
1425: and ph.vendor_site_id = pvs.vendor_site_id (+)
1426: and ph.vendor_id = pvs.vendor_id (+)
1427: and ph.po_header_id = p_document_id

Line 1443: po_headers_all ph,

1439: from
1440: (select pvs.tp_header_id, pr.authorization_status
1441: from po_vendor_sites_all pvs,
1442: po_vendors pv,
1443: po_headers_all ph,
1444: po_releases_all pr
1445: where ph.vendor_id = pv.vendor_id (+)
1446: and ph.vendor_site_id = pvs.vendor_site_id (+)
1447: and ph.vendor_id = pvs.vendor_id (+)

Line 1494: RETURN PO_HEADERS_ALL.org_id%TYPE

1490: FUNCTION get_org_id_from_vendor_site
1491: (
1492: p_vendor_site_id IN NUMBER
1493: )
1494: RETURN PO_HEADERS_ALL.org_id%TYPE
1495: IS
1496: x_org_id PO_HEADERS_ALL.org_id%TYPE;
1497:
1498: BEGIN

Line 1496: x_org_id PO_HEADERS_ALL.org_id%TYPE;

1492: p_vendor_site_id IN NUMBER
1493: )
1494: RETURN PO_HEADERS_ALL.org_id%TYPE
1495: IS
1496: x_org_id PO_HEADERS_ALL.org_id%TYPE;
1497:
1498: BEGIN
1499:
1500: SELECT org_id

Line 1518: ( p_clm_src_doc_num IN PO_HEADERS_ALL.CLM_SOURCE_DOCUMENT_ID%TYPE,

1514:
1515: --FOR CLM PROJECT
1516:
1517: PROCEDURE get_vendor_id
1518: ( p_clm_src_doc_num IN PO_HEADERS_ALL.CLM_SOURCE_DOCUMENT_ID%TYPE,
1519: x_vendor_id OUT NOCOPY PO_HEADERS_ALL.vendor_id%TYPE
1520: )
1521: IS
1522: BEGIN

Line 1519: x_vendor_id OUT NOCOPY PO_HEADERS_ALL.vendor_id%TYPE

1515: --FOR CLM PROJECT
1516:
1517: PROCEDURE get_vendor_id
1518: ( p_clm_src_doc_num IN PO_HEADERS_ALL.CLM_SOURCE_DOCUMENT_ID%TYPE,
1519: x_vendor_id OUT NOCOPY PO_HEADERS_ALL.vendor_id%TYPE
1520: )
1521: IS
1522: BEGIN
1523:

Line 1526: FROM PO_HEADERS_ALL

1522: BEGIN
1523:
1524: SELECT VENDOR_ID
1525: INTO x_vendor_id
1526: FROM PO_HEADERS_ALL
1527: WHERE PO_HEADER_ID = p_clm_src_doc_num;
1528:
1529: EXCEPTION
1530: WHEN OTHERS THEN

Line 1535: ( p_clm_src_doc_num IN PO_HEADERS_ALL.CLM_SOURCE_DOCUMENT_ID%TYPE,

1531: x_vendor_id := NULL;
1532: END get_vendor_id;
1533:
1534: PROCEDURE get_vendor_site_id
1535: ( p_clm_src_doc_num IN PO_HEADERS_ALL.CLM_SOURCE_DOCUMENT_ID%TYPE,
1536: x_vendor_site_id OUT NOCOPY PO_HEADERS_ALL.vendor_site_id%TYPE
1537: )
1538: IS
1539: BEGIN

Line 1536: x_vendor_site_id OUT NOCOPY PO_HEADERS_ALL.vendor_site_id%TYPE

1532: END get_vendor_id;
1533:
1534: PROCEDURE get_vendor_site_id
1535: ( p_clm_src_doc_num IN PO_HEADERS_ALL.CLM_SOURCE_DOCUMENT_ID%TYPE,
1536: x_vendor_site_id OUT NOCOPY PO_HEADERS_ALL.vendor_site_id%TYPE
1537: )
1538: IS
1539: BEGIN
1540:

Line 1543: FROM PO_HEADERS_ALL

1539: BEGIN
1540:
1541: SELECT VENDOR_SITE_ID
1542: INTO x_vendor_site_id
1543: FROM PO_HEADERS_ALL
1544: WHERE PO_HEADER_ID = p_clm_src_doc_num;
1545:
1546: EXCEPTION
1547: WHEN OTHERS THEN