APPS.AP_VENDORS_PKG dependencies on PO_VENDORS

Line 157: FROM po_vendors

153: X_calling_sequence IN VARCHAR2 ) IS
154:
155: CURSOR C IS
156: SELECT rowid
157: FROM po_vendors
158: WHERE vendor_id = x_Vendor_Id;
159:
160: current_calling_sequence VARCHAR2(2000);
161: debug_info VARCHAR2(100);

Line 202: WHERE table_name = 'PO_VENDORS';

198: --Bug :2809214 MOAC - Supplier Attribute Change Project
199: --Replaced the 2 SQLs with the below 2 SQLs.
200: /* UPDATE PO_UNIQUE_IDENTIFIER_CONTROL
201: SET current_max_unique_identifier = current_max_unique_identifier + 1
202: WHERE table_name = 'PO_VENDORS';
203:
204: --
205: --
206: debug_info := 'Select current_max_unique_identifier';

Line 210: WHERE table_name = 'PO_VENDORS'; */

206: debug_info := 'Select current_max_unique_identifier';
207: SELECT current_max_unique_identifier
208: INTO x_segment1
209: FROM po_unique_identifier_control
210: WHERE table_name = 'PO_VENDORS'; */
211:
212: -- Bug 6830122. Replacing following two statements with
213: -- autonomus transactions
214: /*SELECT next_auto_supplier_num

Line 230: debug_info := 'Select next sequence value from PO_VENDORS_S';

226: p_vendor_number => x_segment1,
227: X_calling_sequence => current_calling_sequence );
228: --
229: --
230: debug_info := 'Select next sequence value from PO_VENDORS_S';
231: Select PO_VENDORS_S.NEXTVAL
232: into x_vendor_id
233: from sys.dual;
234: --

Line 231: Select PO_VENDORS_S.NEXTVAL

227: X_calling_sequence => current_calling_sequence );
228: --
229: --
230: debug_info := 'Select next sequence value from PO_VENDORS_S';
231: Select PO_VENDORS_S.NEXTVAL
232: into x_vendor_id
233: from sys.dual;
234: --
235: --

Line 236: debug_info := 'Insert into PO_VENDORS';

232: into x_vendor_id
233: from sys.dual;
234: --
235: --
236: debug_info := 'Insert into PO_VENDORS';
237: INSERT INTO ap_suppliers (
238: vendor_id,
239: last_update_date,
240: last_updated_by,

Line 544: FROM po_vendors

540: x_vendor_id OUT NOCOPY NUMBER) IS
541:
542: CURSOR C IS
543: SELECT rowid
544: FROM po_vendors
545: WHERE vendor_id = x_Vendor_Id;
546:
547: current_calling_sequence VARCHAR2(2000);
548: debug_info VARCHAR2(100);

Line 581: debug_info := 'Select next sequence value from PO_VENDORS_S';

577: X_calling_sequence => current_calling_sequence );
578: -- Bug 6940256 End
579: --
580: --
581: debug_info := 'Select next sequence value from PO_VENDORS_S';
582: Select PO_VENDORS_S.NEXTVAL
583: into x_vendor_id
584: from sys.dual;
585: --

Line 582: Select PO_VENDORS_S.NEXTVAL

578: -- Bug 6940256 End
579: --
580: --
581: debug_info := 'Select next sequence value from PO_VENDORS_S';
582: Select PO_VENDORS_S.NEXTVAL
583: into x_vendor_id
584: from sys.dual;
585: --
586: --

Line 1041: debug_info := 'Update PO_VENDORS';

1037: ap_vendors_pkg.Check_Duplicate_Employee(p_rowid => x_rowid,
1038: p_employee_id => x_employee_id,
1039: X_calling_sequence => current_calling_sequence);
1040:
1041: debug_info := 'Update PO_VENDORS';
1042: UPDATE ap_suppliers
1043: SET
1044: vendor_id = x_Vendor_Id,
1045: last_update_date = x_Last_Update_Date,

Line 1972: FROM po_vendors

1968:
1969: debug_info := 'Count vendors with same name';
1970: SELECT count(1)
1971: INTO L_overlap_count
1972: FROM po_vendors
1973: WHERE (p_vendor_id is null OR vendor_id <> p_vendor_id)
1974: AND (vendor_name like UPPER(SUBSTR(p_vendor_name,1,2))||'%'
1975: OR vendor_name like LOWER(SUBSTR(p_vendor_name,1,2))||'%'
1976: OR vendor_name like INITCAP(SUBSTR(p_vendor_name,1,2))||'%'

Line 2072: from po_vendors

2068: --
2069: debug_info := 'Count overlap for vendor number';
2070: select count(1)
2071: into l_overlap_count
2072: from po_vendors
2073: where segment1 = p_vendor_number
2074: and ( p_vendor_id IS NULL or vendor_id <> p_vendor_id );
2075: --
2076: --

Line 2165: FROM PO_VENDORS

2161:
2162: debug_info := 'Count for same employee_id';
2163: SELECT count(1)
2164: INTO L_Duplicate_Count
2165: FROM PO_VENDORS
2166: WHERE (p_rowid IS NULL OR rowid <> p_rowid)
2167: AND employee_id = p_employee_id;
2168:
2169: if (L_Duplicate_count > 0 ) then