DBA Data[Home] [Help]

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.17.12020000.2 2013/02/11 00:09:20 vegajula 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 1221: -- 3. po_vendor_sites_all

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

Line 1261: po_vendor_sites_all pvs,

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

Line 1285: -- 4597324), then po_vendor_sites_all.

1281:
1282: elsif (p_document_type = 'RELEASE') then
1283: begin
1284: -- We default email/fax from po_vendor_contacts (see Bug
1285: -- 4597324), then po_vendor_sites_all.
1286:
1287: -- Bug 6625807 / 6526600
1288: -- Added pvs.vendor_site_id = NVL(pvc.vendor_site_id,
1289: -- pvs.vendor_site_id) condition so that following query returns

Line 1305: po_vendor_sites_all pvs,

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

Line 1392: l_tp_header_id PO_VENDOR_SITES.tp_header_id%TYPE;

1388: x_email_address OUT NOCOPY VARCHAR2,
1389: x_fax_number OUT NOCOPY VARCHAR2,
1390: x_document_num OUT NOCOPY VARCHAR2,
1391: p_retrieve_only_flag IN VARCHAR2) IS
1392: l_tp_header_id PO_VENDOR_SITES.tp_header_id%TYPE;
1393: l_edi_flag ECE_TP_DETAILS.edi_flag%TYPE;
1394: BEGIN
1395:
1396: -- Retrieve the non-EDI tranmission setups.

Line 1421: from po_vendor_sites_all pvs,

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

Line 1441: from po_vendor_sites_all pvs,

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

Line 1502: FROM po_vendor_sites_all

1498: BEGIN
1499:
1500: SELECT org_id
1501: INTO x_org_id
1502: FROM po_vendor_sites_all
1503: WHERE vendor_site_id = p_vendor_site_id;
1504:
1505: return (x_org_id);
1506:

Line 1555: END PO_VENDOR_SITES_SV;

1551: --FOR CLM PROJECT
1552:
1553:
1554:
1555: END PO_VENDOR_SITES_SV;