APPS.PA_AP_INTEGRATION dependencies on PO_VENDORS

Line 6: ( p_old_vendor_id IN po_vendors.vendor_id%type,

2: --$Header: PAAPINTB.pls 120.18.12020000.6 2013/03/28 06:01:04 arbandyo ship $
3: g_po_match_date DATE := NULL;
4:
5: PROCEDURE UPD_PA_DETAILS_SUPPLIER_MERGE
6: ( p_old_vendor_id IN po_vendors.vendor_id%type,
7: p_new_vendor_id IN po_vendors.vendor_id%type,
8: p_paid_inv_flag IN ap_invoices_all.PAYMENT_STATUS_FLAG%type,
9: p_invoice_id IN ap_invoices_all.invoice_id%TYPE DEFAULT NULL, /* Bug# 8845025 */
10: x_stage OUT NOCOPY VARCHAR2,

Line 7: p_new_vendor_id IN po_vendors.vendor_id%type,

3: g_po_match_date DATE := NULL;
4:
5: PROCEDURE UPD_PA_DETAILS_SUPPLIER_MERGE
6: ( p_old_vendor_id IN po_vendors.vendor_id%type,
7: p_new_vendor_id IN po_vendors.vendor_id%type,
8: p_paid_inv_flag IN ap_invoices_all.PAYMENT_STATUS_FLAG%type,
9: p_invoice_id IN ap_invoices_all.invoice_id%TYPE DEFAULT NULL, /* Bug# 8845025 */
10: x_stage OUT NOCOPY VARCHAR2,
11: x_status OUT NOCOPY VARCHAR2)

Line 219: l_new_vendor_name po_vendors.vendor_name%type;

215:
216: l_new_vendor_exists_member number := 0; /*Bug# 4029384*/
217: l_new_vendor_exists_resource number := 0; /*Bug# 4029384*/
218:
219: l_new_vendor_name po_vendors.vendor_name%type;
220:
221: l_expenditure_category pa_resource_list_members.expenditure_category%type;
222: l_parent_member_id pa_resource_list_members.resource_list_member_id%type;
223: l_resource_list_member_id pa_resource_list_members.resource_list_member_id%type;

Line 235: Select vendor_name into l_new_vendor_name from po_vendors where vendor_id = p_new_vendor_id;

231: x_stage := 'Start For Summarization';
232: for rec1 in c_resource_list loop
233:
234: x_stage := 'New Vendor Name';
235: Select vendor_name into l_new_vendor_name from po_vendors where vendor_id = p_new_vendor_id;
236:
237: Begin
238: x_stage:='See whether New vendor exists as resource in PA tables';
239:

Line 446: FUNCTION Allow_Supplier_Merge ( p_vendor_id IN po_vendors.vendor_id%type

442:
443: End UPD_PA_DETAILS_SUPPLIER_MERGE;
444:
445:
446: FUNCTION Allow_Supplier_Merge ( p_vendor_id IN po_vendors.vendor_id%type
447: )
448: RETURN varchar2
449: IS
450: l_budget_exists Varchar2(1);