APPS.JL_ZZ_AP_AWT_DEFAULT_PKG dependencies on AP_INVOICE_LINES

Line 853: , P_Inv_Line_Num ap_invoice_lines_all.line_number%TYPE

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
857: ) IS

Line 1079: AP_Invoice_Lines apil

1075: INTO v_tax_payer_id,
1076: v_ship_to_loc,
1077: v_line_type
1078: FROM AP_Invoice_Distributions apid,
1079: AP_Invoice_Lines apil
1080: WHERE apid.invoice_id = p_invoice_id
1081: AND apid.invoice_distribution_id = p_inv_dist_id
1082: AND apid.invoice_line_number = apil.line_number
1083: AND apid.invoice_id = apil.invoice_id;

Line 1119: AP_Invoice_Lines apil

1115: INTO v_tax_payer_id,
1116: v_ship_to_loc,
1117: v_line_type
1118: FROM AP_Invoice_Distributions apid,
1119: AP_Invoice_Lines apil
1120: WHERE apid.invoice_id = P_Invoice_Id
1121: AND apid.invoice_distribution_id = db_reg.invoice_distribution_id
1122: AND apid.invoice_line_number = apil.line_number
1123: AND apid.invoice_id = apil.invoice_id;

Line 1402: AP_Invoice_Lines apil

1398: INTO v_tax_payer_id,
1399: v_ship_to_loc,
1400: v_line_type
1401: FROM AP_Invoice_Distributions apid,
1402: AP_Invoice_Lines apil
1403: WHERE apid.invoice_id = P_Invoice_Id
1404: AND apid.invoice_distribution_id = db_reg.invoice_distribution_id
1405: AND apil.line_number = apid.invoice_line_number
1406: AND apid.invoice_id = apil.invoice_id;

Line 1432: ,P_Inv_Line_Num ap_invoice_lines.line_number%Type

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;
1436: l_country_code Varchar2(30);

Line 1438: l_ship_to_location ap_invoice_lines.ship_to_location_id%Type;

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;
1440:
1441: Cursor C_Inv (x_invoice_id In ap_invoices.invoice_id%Type) Is
1442: Select org_id, invoice_type_lookup_code

Line 1439: l_line_type_code ap_invoice_lines.line_type_lookup_code%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;
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

Line 1447: ,x_inv_line_num in ap_invoice_lines.line_number%Type) Is

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
1451: And line_number = x_inv_line_num;

Line 1449: From ap_invoice_lines

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
1451: And line_number = x_inv_line_num;
1452:
1453: Begin