APPS.AP_AUTOMATIC_PROPAGATION_PKG dependencies on AP_SUPPLIER_SITES

Line 7: P_vendor_site_id ap_supplier_sites.vendor_site_id%TYPE DEFAULT NULL,

3:
4: FUNCTION Get_Affected_Invoices_Count(
5: P_external_bank_account_id iby_ext_bank_accounts.ext_bank_account_id%TYPE,
6: P_vendor_id ap_suppliers.vendor_id%TYPE,
7: P_vendor_site_id ap_supplier_sites.vendor_site_id%TYPE DEFAULT NULL,
8: P_party_Site_Id ap_supplier_sites.party_site_id%TYPE DEFAULT NULL,
9: P_org_id ap_invoices.org_id%TYPE DEFAULT NULL
10: ) RETURN NUMBER IS
11: l_affected_invoices NUMBER := 0;

Line 8: P_party_Site_Id ap_supplier_sites.party_site_id%TYPE DEFAULT NULL,

4: FUNCTION Get_Affected_Invoices_Count(
5: P_external_bank_account_id iby_ext_bank_accounts.ext_bank_account_id%TYPE,
6: P_vendor_id ap_suppliers.vendor_id%TYPE,
7: P_vendor_site_id ap_supplier_sites.vendor_site_id%TYPE DEFAULT NULL,
8: P_party_Site_Id ap_supplier_sites.party_site_id%TYPE DEFAULT NULL,
9: P_org_id ap_invoices.org_id%TYPE DEFAULT NULL
10: ) RETURN NUMBER IS
11: l_affected_invoices NUMBER := 0;
12: BEGIN

Line 29: from ap_supplier_sites ass

25: AND ai.org_id = p_org_id
26: AND (ai.party_site_id = p_party_site_id
27: or ( ai.party_site_id is null
28: and ai.vendor_site_id in (select vendor_site_id
29: from ap_supplier_sites ass
30: where ass.party_site_id = p_party_site_id
31: and ass.vendor_id = p_vendor_id)
32: )
33: )

Line 50: from ap_supplier_sites ass

46: AND ai.vendor_id = p_vendor_id
47: AND (ai.party_site_id = p_party_site_id
48: or ( ai.party_site_id is null
49: and ai.vendor_site_id in (select vendor_site_id
50: from ap_supplier_sites ass
51: where ass.party_site_id = p_party_site_id
52: and ass.vendor_id = p_vendor_id)
53: )
54: )

Line 95: P_vendor_site_id ap_supplier_sites.vendor_site_id%TYPE DEFAULT NULL,

91: /* Bug 10634847 Added API to return selected invoices for payments count */
92: FUNCTION Get_Selected_Invoices_Count(
93: P_external_bank_account_id iby_ext_bank_accounts.ext_bank_account_id%TYPE,
94: P_vendor_id ap_suppliers.vendor_id%TYPE,
95: P_vendor_site_id ap_supplier_sites.vendor_site_id%TYPE DEFAULT NULL,
96: P_party_Site_Id ap_supplier_sites.party_site_id%TYPE DEFAULT NULL,
97: P_org_id ap_invoices.org_id%TYPE DEFAULT NULL
98: ) RETURN NUMBER IS
99: l_affected_invoices NUMBER := 0;

Line 96: P_party_Site_Id ap_supplier_sites.party_site_id%TYPE DEFAULT NULL,

92: FUNCTION Get_Selected_Invoices_Count(
93: P_external_bank_account_id iby_ext_bank_accounts.ext_bank_account_id%TYPE,
94: P_vendor_id ap_suppliers.vendor_id%TYPE,
95: P_vendor_site_id ap_supplier_sites.vendor_site_id%TYPE DEFAULT NULL,
96: P_party_Site_Id ap_supplier_sites.party_site_id%TYPE DEFAULT NULL,
97: P_org_id ap_invoices.org_id%TYPE DEFAULT NULL
98: ) RETURN NUMBER IS
99: l_affected_invoices NUMBER := 0;
100:

Line 146: from ap_supplier_sites ass

142: AND ai.org_id = p_org_id
143: AND (ai.party_site_id = p_party_site_id
144: or ( ai.party_site_id is null
145: and ai.vendor_site_id in (select vendor_site_id
146: from ap_supplier_sites ass
147: where ass.party_site_id = p_party_site_id
148: and ass.vendor_id = p_vendor_id)
149: )
150: )

Line 166: from ap_supplier_sites ass

162: AND ai.vendor_id = p_vendor_id
163: AND (ai.party_site_id = p_party_site_id
164: or ( ai.party_site_id is null
165: and ai.vendor_site_id in (select vendor_site_id
166: from ap_supplier_sites ass
167: where ass.party_site_id = p_party_site_id
168: and ass.vendor_id = p_vendor_id)
169: )
170: )

Line 213: P_vendor_site_id ap_supplier_sites.vendor_site_id%TYPE DEFAULT NULL,

209: PROCEDURE Update_Payment_Schedules (
210: p_from_bank_account_id iby_ext_bank_accounts.ext_bank_account_id%TYPE,
211: p_to_bank_account_id iby_ext_bank_accounts.ext_bank_account_id%TYPE,
212: p_vendor_id ap_suppliers.vendor_id%TYPE,
213: P_vendor_site_id ap_supplier_sites.vendor_site_id%TYPE DEFAULT NULL,
214: P_party_Site_Id ap_supplier_sites.party_site_id%TYPE DEFAULT NULL,
215: P_org_id ap_invoices.org_id%TYPE DEFAULT NULL,
216: P_party_id ap_suppliers.party_id%TYPE DEFAULT NULL -- Added for bug 9410719
217: ) IS

Line 214: P_party_Site_Id ap_supplier_sites.party_site_id%TYPE DEFAULT NULL,

210: p_from_bank_account_id iby_ext_bank_accounts.ext_bank_account_id%TYPE,
211: p_to_bank_account_id iby_ext_bank_accounts.ext_bank_account_id%TYPE,
212: p_vendor_id ap_suppliers.vendor_id%TYPE,
213: P_vendor_site_id ap_supplier_sites.vendor_site_id%TYPE DEFAULT NULL,
214: P_party_Site_Id ap_supplier_sites.party_site_id%TYPE DEFAULT NULL,
215: P_org_id ap_invoices.org_id%TYPE DEFAULT NULL,
216: P_party_id ap_suppliers.party_id%TYPE DEFAULT NULL -- Added for bug 9410719
217: ) IS
218:

Line 286: FROM ap_supplier_sites ass

282: AND ai.org_id = p_org_id
283: AND (ai.party_site_id = p_party_site_id
284: OR (ai.party_site_id is NULL
285: AND ai.vendor_site_id in (SELECT vendor_site_id
286: FROM ap_supplier_sites ass
287: WHERE ass.party_site_id = p_party_site_id
288: AND ass.vendor_id = p_vendor_id)
289: )
290: )

Line 340: from ap_supplier_sites ass

336: AND ai.org_id = p_org_id
337: AND (ai.party_site_id = p_party_site_id
338: or ( ai.party_site_id is null
339: and ai.vendor_site_id in (select vendor_site_id
340: from ap_supplier_sites ass
341: where ass.party_site_id = p_party_site_id
342: and ass.vendor_id = p_vendor_id)
343: )
344: )

Line 372: FROM ap_supplier_sites ass

368: AND ai.vendor_id = p_vendor_id
369: AND (ai.party_site_id = p_party_site_id
370: OR (ai.party_site_id IS NULL
371: AND ai.vendor_site_id IN (SELECT vendor_site_id
372: FROM ap_supplier_sites ass
373: WHERE ass.party_site_id = p_party_site_id
374: AND ass.vendor_id = p_vendor_id)
375: )
376: )

Line 424: from ap_supplier_sites ass

420: AND ai.vendor_id = p_vendor_id
421: AND (ai.party_site_id = p_party_site_id
422: or ( ai.party_site_id is null
423: and ai.vendor_site_id in (select vendor_site_id
424: from ap_supplier_sites ass
425: where ass.party_site_id = p_party_site_id
426: and ass.vendor_id = p_vendor_id)
427: )
428: )