APPS.PA_AP_INTEGRATION dependencies on PO_VENDORS

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

1: PACKAGE BODY pa_ap_integration AS
2: --$Header: PAAPINTB.pls 120.9.12010000.3 2008/11/27 06:34:54 svivaram ship $
3:
4: PROCEDURE UPD_PA_DETAILS_SUPPLIER_MERGE
5: ( p_old_vendor_id IN po_vendors.vendor_id%type,
6: p_new_vendor_id IN po_vendors.vendor_id%type,
7: p_paid_inv_flag IN ap_invoices_all.PAYMENT_STATUS_FLAG%type,
8: x_stage OUT NOCOPY VARCHAR2,
9: x_status OUT NOCOPY VARCHAR2)

Line 6: p_new_vendor_id IN po_vendors.vendor_id%type,

2: --$Header: PAAPINTB.pls 120.9.12010000.3 2008/11/27 06:34:54 svivaram ship $
3:
4: PROCEDURE UPD_PA_DETAILS_SUPPLIER_MERGE
5: ( p_old_vendor_id IN po_vendors.vendor_id%type,
6: p_new_vendor_id IN po_vendors.vendor_id%type,
7: p_paid_inv_flag IN ap_invoices_all.PAYMENT_STATUS_FLAG%type,
8: x_stage OUT NOCOPY VARCHAR2,
9: x_status OUT NOCOPY VARCHAR2)
10:

Line 155: l_new_vendor_name po_vendors.vendor_name%type;

151:
152: l_new_vendor_exists_member number := 0; /*Bug# 4029384*/
153: l_new_vendor_exists_resource number := 0; /*Bug# 4029384*/
154:
155: l_new_vendor_name po_vendors.vendor_name%type;
156:
157: l_expenditure_category pa_resource_list_members.expenditure_category%type;
158: l_parent_member_id pa_resource_list_members.resource_list_member_id%type;
159: l_resource_list_member_id pa_resource_list_members.resource_list_member_id%type;

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

167: x_stage := 'Start For Summarization';
168: for rec1 in c_resource_list loop
169:
170: x_stage := 'New Vendor Name';
171: Select vendor_name into l_new_vendor_name from po_vendors where vendor_id = p_new_vendor_id;
172:
173: Begin
174: x_stage:='See whether New vendor exists as resource in PA tables';
175:

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

378:
379: End UPD_PA_DETAILS_SUPPLIER_MERGE;
380:
381:
382: FUNCTION Allow_Supplier_Merge ( p_vendor_id IN po_vendors.vendor_id%type
383: )
384: RETURN varchar2
385: IS
386: l_budget_exists Varchar2(1);