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_VENDOR_SITES

Line 1: PACKAGE BODY PO_VENDOR_SITES_SV AS

1: PACKAGE BODY PO_VENDOR_SITES_SV AS
2: /* $Header: POXVDVSB.pls 120.13.12010000.2 2008/08/04 08:33:55 rramasam ship $*/
3:
4: -- Read the profile option that enables/disables the debug log
5: g_asn_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_RVCTP_ENABLE_TRACE'),'N');

Line 103: FROM po_vendor_sites

99: --SQL What: Query org-striped view to validate vendor site ID
100: --SQL Why: No org_id specified, so validate in current OU.
101: SELECT vendor_site_id
102: INTO l_vendor_site_id_v
103: FROM po_vendor_sites
104: WHERE vendor_site_id = p_vendor_site_id
105: AND SYSDATE < NVL(inactive_date, SYSDATE + 1)
106: AND purchasing_site_flag = 'Y'
107: AND ( ( p_document_type IN ('PO', 'BLANKET')

Line 119: FROM po_vendor_sites_all

115: --SQL What: Query base table to validate vendor site ID
116: --SQL Why: Validate site in specified org_id
117: SELECT vendor_site_id
118: INTO l_vendor_site_id_v
119: FROM po_vendor_sites_all
120: WHERE vendor_site_id = p_vendor_site_id
121: AND org_id = p_org_id
122: AND SYSDATE < NVL(inactive_date, SYSDATE + 1)
123: AND purchasing_site_flag = 'Y'

Line 140: po_message_s.sql_error('PO_VENDOR_SITES_SV.val_vendor_site',l_progress,sqlcode);

136:
137: when no_data_found then
138: return (FALSE);
139: when others then
140: po_message_s.sql_error('PO_VENDOR_SITES_SV.val_vendor_site',l_progress,sqlcode);
141: raise;
142:
143: END val_vendor_site_id;
144:

Line 185: from po_vendor_sites

181: max(vendor_site_id)
182: into X_vendor_site_count,
183: X_temp_vendor_site_code,
184: X_vendor_site_id
185: from po_vendor_sites
186: where vendor_id = X_vendor_id
187: and purchasing_site_flag = 'Y'
188: and sysdate < nvl(inactive_date, sysdate + 1)
189: and nvl(rfq_only_site_flag, 'N') <> 'Y' ;

Line 198: from po_vendor_sites

194: max(vendor_site_id)
195: into X_vendor_site_count,
196: X_temp_vendor_site_code,
197: X_vendor_site_id
198: from po_vendor_sites
199: where vendor_id = X_vendor_id
200: and purchasing_site_flag = 'Y'
201: and sysdate < nvl(inactive_date, sysdate + 1);
202:

Line 257: from po_vendor_sites_all --

253: freight_terms_lookup_code,
254: terms_id ,
255: invoice_currency_code,
256: shipping_control --
257: from po_vendor_sites_all --
258: where vendor_site_id = X_vendor_site_id;
259:
260: X_progress varchar2(3) := '';
261:

Line 580: FROM PO_VENDOR_SITES_ALL PVS --

576: */
577:
578: CURSOR C is
579: SELECT PVS.vendor_site_code
580: FROM PO_VENDOR_SITES_ALL PVS --
581: WHERE PVS.vendor_site_id = X_vendor_site_id;
582:
583: BEGIN
584:

Line 627: sql_str := 'SELECT vendor_site_id, vendor_id, vendor_site_code,org_id FROM po_vendor_sites WHERE ';

623: vendor_site_id_null BOOLEAN := TRUE;
624:
625: BEGIN
626:
627: sql_str := 'SELECT vendor_site_id, vendor_id, vendor_site_code,org_id FROM po_vendor_sites WHERE ';
628:
629: IF p_vendor_site_record.vendor_site_code IS NULL and
630: p_vendor_site_record.vendor_site_id IS NULL THEN
631:

Line 763: l_hold_all_payments_flag PO_VENDOR_SITES_ALL.hold_all_payments_flag%TYPE;

759: x_error_status OUT NOCOPY VARCHAR2,
760: x_error_message OUT NOCOPY VARCHAR2
761: )
762: IS
763: l_hold_all_payments_flag PO_VENDOR_SITES_ALL.hold_all_payments_flag%TYPE;
764: l_pay_site_flag PO_VENDOR_SITES_ALL.pay_site_flag%TYPE;
765: BEGIN
766: IF p_remit_to_site_id IS NULL THEN
767: x_error_status := 'E';

Line 764: l_pay_site_flag PO_VENDOR_SITES_ALL.pay_site_flag%TYPE;

760: x_error_message OUT NOCOPY VARCHAR2
761: )
762: IS
763: l_hold_all_payments_flag PO_VENDOR_SITES_ALL.hold_all_payments_flag%TYPE;
764: l_pay_site_flag PO_VENDOR_SITES_ALL.pay_site_flag%TYPE;
765: BEGIN
766: IF p_remit_to_site_id IS NULL THEN
767: x_error_status := 'E';
768: x_error_message := 'All blanks';

Line 774: FROM PO_VENDOR_SITES

770: END IF;
771:
772: SELECT hold_all_payments_flag, pay_site_flag
773: INTO l_hold_all_payments_flag, l_pay_site_flag
774: FROM PO_VENDOR_SITES
775: WHERE vendor_site_id = p_remit_to_site_id;
776:
777: -- Check for hold payments flag
778: IF nvl(l_hold_all_payments_flag, 'N') = 'Y' THEN

Line 817: X_sql_str VARCHAR2(2000) := 'SELECT povs.inactive_date, povs.purchasing_site_flag, povs.pay_site_flag , povs.hold_all_payments_flag FROM po_vendor_sites povs where ';

813: IS
814:
815: X_cid INTEGER;
816: X_rows_processed INTEGER;
817: X_sql_str VARCHAR2(2000) := 'SELECT povs.inactive_date, povs.purchasing_site_flag, povs.pay_site_flag , povs.hold_all_payments_flag FROM po_vendor_sites povs where ';
818:
819: X_vendor_site_code_null BOOLEAN := TRUE;
820: X_vendor_id_null BOOLEAN := TRUE;
821: -- X_organization_id_null BOOLEAN := TRUE; bug 621385

Line 1050: l_fax_area po_vendor_sites_all.fax_area_code%type;

1046: x_document_num OUT NOCOPY VARCHAR2,
1047: p_retrieve_only_flag IN VARCHAR2)
1048: IS
1049:
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;

Line 1218: -- 3. po_vendor_sites_all

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
1221: -- Added pvs.vendor_site_id = NVL(pvc.vendor_site_id,
1222: -- pvs.vendor_site_id) condition so that following query returns

Line 1241: po_vendor_sites_all pvs,

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
1245: poh.po_header_id = p_document_id and

Line 1265: -- 4597324), then po_vendor_sites_all.

1261:
1262: elsif (p_document_type = 'RELEASE') then
1263: begin
1264: -- We default email/fax from po_vendor_contacts (see Bug
1265: -- 4597324), then po_vendor_sites_all.
1266:
1267: -- Bug 6625807 / 6526600
1268: -- Added pvs.vendor_site_id = NVL(pvc.vendor_site_id,
1269: -- pvs.vendor_site_id) condition so that following query returns

Line 1281: po_vendor_sites_all pvs,

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
1285: poh.vendor_contact_id = pvc.vendor_contact_id (+) and

Line 1368: l_tp_header_id PO_VENDOR_SITES.tp_header_id%TYPE;

1364: x_email_address OUT NOCOPY VARCHAR2,
1365: x_fax_number OUT NOCOPY VARCHAR2,
1366: x_document_num OUT NOCOPY VARCHAR2,
1367: p_retrieve_only_flag IN VARCHAR2) IS
1368: l_tp_header_id PO_VENDOR_SITES.tp_header_id%TYPE;
1369: l_edi_flag ECE_TP_DETAILS.edi_flag%TYPE;
1370: BEGIN
1371:
1372: -- Retrieve the non-EDI tranmission setups.

Line 1397: from po_vendor_sites_all pvs,

1393: select phv.tp_header_id, nvl(etd.edi_flag,'N')
1394: into l_tp_header_id, l_edi_flag
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 (+)

Line 1417: from po_vendor_sites_all pvs,

1413: select phv.tp_header_id, nvl(etd.edi_flag,'N')
1414: into l_tp_header_id, l_edi_flag
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 (+)

Line 1478: FROM po_vendor_sites_all

1474: BEGIN
1475:
1476: SELECT org_id
1477: INTO x_org_id
1478: FROM po_vendor_sites_all
1479: WHERE vendor_site_id = p_vendor_site_id;
1480:
1481: return (x_org_id);
1482:

Line 1491: END PO_VENDOR_SITES_SV;

1487:
1488: END get_org_id_from_vendor_site;
1489: --
1490:
1491: END PO_VENDOR_SITES_SV;