eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JL_ZZ_AP_AWT_DEFAULT_PKG dependencies on AP_INVOICES

Line 41: P_Invoice_Id IN ap_invoices_all.invoice_id%TYPE,

37: -- R12 KI
38: --
39:
40: PROCEDURE Insert_AWT_Default(
41: P_Invoice_Id IN ap_invoices_all.invoice_id%TYPE,
42: P_Inv_Dist_Id IN ap_invoice_distributions_all.invoice_distribution_id%TYPE,
43: P_Supp_Awt_Code_Id IN jl_zz_ap_sup_awt_cd.supp_awt_code_id%TYPE,
44: p_calling_sequence IN VARCHAR2,
45: P_Org_Id IN jl_zz_ap_sup_awt_cd.org_id%TYPE) IS

Line 213: , P_Invoice_Id ap_invoices_all.invoice_id%TYPE

209: If tax_payerid is not null find the vendor_id for this tax_payerid Else
210: return the vendor id from the invoice.
211: ------------------------------------------------------------------------------------------------*/
212: FUNCTION Get_Vendor_Id ( P_Tax_Payer_Id ap_invoice_distributions_all.global_attribute2%TYPE
213: , P_Invoice_Id ap_invoices_all.invoice_id%TYPE
214: )
215: return number is
216: --------------------------------------------------------------------
217: -- Get the information from po_vendors when tax_payerid is not null

Line 225: -- Get the information from ap_invoices_all when tax_payerid is null.

221: FROM po_vendors
222: WHERE segment1 = P_Tax_Payer_Id; -- R12 KI : Need to uptake PTP?
223:
224: --------------------------------------------------------------------
225: -- Get the information from ap_invoices_all when tax_payerid is null.
226: --------------------------------------------------------------------
227: CURSOR Invoice_Vendor IS
228: SELECT Vendor_Id
229: FROM ap_invoices

Line 229: FROM ap_invoices

225: -- Get the information from ap_invoices_all when tax_payerid is null.
226: --------------------------------------------------------------------
227: CURSOR Invoice_Vendor IS
228: SELECT Vendor_Id
229: FROM ap_invoices
230: WHERE invoice_id = P_Invoice_Id;
231:
232: v_vendor_id po_vendors.vendor_id%TYPE;
233:

Line 284: P_Invoice_Id ap_invoices_all.invoice_id%TYPE)

280: The function receive the Supplier Withholding Type as parameter.
281: ------------------------------------------------------------------------------------------------*/
282:
283: FUNCTION Company_Agent (P_Awt_Type_Code jl_zz_ap_awt_types.awt_type_code%TYPE,
284: P_Invoice_Id ap_invoices_all.invoice_id%TYPE)
285: return boolean is
286: /* bug 16010780
287: Cursor Company_Awt_Types (PC_Legal_Entity_ID xle_entity_profiles.legal_entity_id%TYPE)
288: IS

Line 297: FROM ap_invoices

293: AND wh_agent_flag = 'Y';
294:
295: Cursor legal_entity IS
296: SELECT legal_entity_id
297: FROM ap_invoices
298: WHERE invoice_id = P_Invoice_ID;
299:
300: l_legal_entity_id xle_entity_profiles.legal_entity_id%TYPE;
301: */

Line 324: FROM ap_invoices

320: ----------------------------------------------------------
321: -- v_location := jg_zz_company_info.get_location_id; -- LE
322: SELECT legal_entity_id
323: INTO l_legal_entity_id
324: FROM ap_invoices
325: WHERE invoice_id = P_Invoice_ID;
326: ----------------------------------------------------------
327: -- Loop verify the withholding type.
328: ----------------------------------------------------------

Line 347: from ap_invoices AP

343: */
344: --New code due to performance issues: bug 16010780
345:
346: select decode((select 'TRUE'
347: from ap_invoices AP
348: where AP.invoice_id = P_Invoice_ID
349: and EXISTS (select /*+ NO_UNNEST */ 'x'
350: from jl_zz_ap_comp_awt_types
351: where legal_entity_id = AP.legal_entity_id

Line 852: ( P_Invoice_Id ap_invoices_all.invoice_id%TYPE

848: -- R12 KI
849: --
850:
851: PROCEDURE Supp_Wh_Def
852: ( P_Invoice_Id ap_invoices_all.invoice_id%TYPE
853: , P_Inv_Line_Num ap_invoice_lines_all.line_number%TYPE
854: , P_Inv_Dist_Id ap_invoice_distributions_all.invoice_distribution_id%TYPE
855: , P_Calling_Module VARCHAR2
856: , P_Parent_Dist_ID IN Number Default null

Line 1363: ( P_Invoice_Id ap_invoices_all.invoice_id%TYPE

1359: Supp_Wh_ReDef receive as parameters the P_Invoice_Id and P_Vendor_ID
1360: Bug 3609925
1361: ------------------------------------------------------------------------------------------------*/
1362: PROCEDURE Supp_Wh_ReDefault
1363: ( P_Invoice_Id ap_invoices_all.invoice_id%TYPE
1364: , P_Vendor_ID po_vendors.vendor_id%TYPE
1365: ) IS
1366:
1367: CURSOR Invoice_Distrib IS

Line 1431: Procedure Upd_Dist_Gdf( P_Invoice_Id ap_invoices.invoice_id%Type

1427: END IF;
1428: END Supp_Wh_ReDefault;
1429:
1430: -- Bug12944204 Start
1431: Procedure Upd_Dist_Gdf( P_Invoice_Id ap_invoices.invoice_id%Type
1432: ,P_Inv_Line_Num ap_invoice_lines.line_number%Type
1433: ,P_Inv_Dist_Id ap_invoice_distributions.invoice_distribution_id%Type) Is
1434: l_org_id ap_invoices.org_id%Type;
1435: l_invoice_type_lookup_code ap_invoices.invoice_type_lookup_code%Type;

Line 1434: l_org_id ap_invoices.org_id%Type;

1430: -- Bug12944204 Start
1431: Procedure Upd_Dist_Gdf( P_Invoice_Id ap_invoices.invoice_id%Type
1432: ,P_Inv_Line_Num ap_invoice_lines.line_number%Type
1433: ,P_Inv_Dist_Id ap_invoice_distributions.invoice_distribution_id%Type) Is
1434: l_org_id ap_invoices.org_id%Type;
1435: l_invoice_type_lookup_code ap_invoices.invoice_type_lookup_code%Type;
1436: l_country_code Varchar2(30);
1437: l_gdf_category ap_invoice_distributions.global_attribute_category%Type;
1438: l_ship_to_location ap_invoice_lines.ship_to_location_id%Type;

Line 1435: l_invoice_type_lookup_code ap_invoices.invoice_type_lookup_code%Type;

1431: Procedure Upd_Dist_Gdf( P_Invoice_Id ap_invoices.invoice_id%Type
1432: ,P_Inv_Line_Num ap_invoice_lines.line_number%Type
1433: ,P_Inv_Dist_Id ap_invoice_distributions.invoice_distribution_id%Type) Is
1434: l_org_id ap_invoices.org_id%Type;
1435: l_invoice_type_lookup_code ap_invoices.invoice_type_lookup_code%Type;
1436: l_country_code Varchar2(30);
1437: l_gdf_category ap_invoice_distributions.global_attribute_category%Type;
1438: l_ship_to_location ap_invoice_lines.ship_to_location_id%Type;
1439: l_line_type_code ap_invoice_lines.line_type_lookup_code%Type;

Line 1441: Cursor C_Inv (x_invoice_id In ap_invoices.invoice_id%Type) Is

1437: l_gdf_category ap_invoice_distributions.global_attribute_category%Type;
1438: l_ship_to_location ap_invoice_lines.ship_to_location_id%Type;
1439: l_line_type_code ap_invoice_lines.line_type_lookup_code%Type;
1440:
1441: Cursor C_Inv (x_invoice_id In ap_invoices.invoice_id%Type) Is
1442: Select org_id, invoice_type_lookup_code
1443: From ap_invoices
1444: Where invoice_id = x_invoice_Id;
1445:

Line 1443: From ap_invoices

1439: l_line_type_code ap_invoice_lines.line_type_lookup_code%Type;
1440:
1441: Cursor C_Inv (x_invoice_id In ap_invoices.invoice_id%Type) Is
1442: Select org_id, invoice_type_lookup_code
1443: From ap_invoices
1444: Where invoice_id = x_invoice_Id;
1445:
1446: Cursor C_Ship_To_Location ( x_invoice_id in ap_invoices.invoice_id%Type
1447: ,x_inv_line_num in ap_invoice_lines.line_number%Type) Is

Line 1446: Cursor C_Ship_To_Location ( x_invoice_id in ap_invoices.invoice_id%Type

1442: Select org_id, invoice_type_lookup_code
1443: From ap_invoices
1444: Where invoice_id = x_invoice_Id;
1445:
1446: Cursor C_Ship_To_Location ( x_invoice_id in ap_invoices.invoice_id%Type
1447: ,x_inv_line_num in ap_invoice_lines.line_number%Type) Is
1448: Select ship_to_location_id, line_type_lookup_code
1449: From ap_invoice_lines
1450: Where invoice_id = x_invoice_id