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_INVOICE_DISTRIBUTIONS

Line 42: P_Inv_Dist_Id IN ap_invoice_distributions_all.invoice_distribution_id%TYPE,

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
46:

Line 212: FUNCTION Get_Vendor_Id ( P_Tax_Payer_Id ap_invoice_distributions_all.global_attribute2%TYPE

208: The Following function return the vendor_id for the Distribution Line.
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: --------------------------------------------------------------------

Line 513: p_inv_dist_id ap_invoice_distributions_all.invoice_distribution_id%TYPE

509: -- R12 KI
510: --
511: PROCEDURE Del_Wh_Def
512: (
513: p_inv_dist_id ap_invoice_distributions_all.invoice_distribution_id%TYPE
514: ) IS
515: Begin
516: /*
517: DELETE JL_ZZ_AP_INV_DIS_WH

Line 854: , P_Inv_Dist_Id ap_invoice_distributions_all.invoice_distribution_id%TYPE

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
858:

Line 864: FROM ap_invoice_distributions

860: -- R12 KI Changes : 4559472
861: --
862: CURSOR Invoice_Distrib IS
863: SELECT invoice_distribution_id
864: FROM ap_invoice_distributions
865: WHERE invoice_id = P_Invoice_ID
866: AND invoice_line_number = P_Inv_Line_Num;
867:
868: -- Added Cursor for bug 6869263

Line 878: v_tax_payer_id ap_invoice_distributions_all.global_attribute2%TYPE;

874: AND invoice_distribution_id = p_related_dist_id;
875:
876: -- The following variables are used to get the information from the invoice
877: -- ditribution lines.
878: v_tax_payer_id ap_invoice_distributions_all.global_attribute2%TYPE;
879: v_ship_to_loc ap_invoice_distributions_all.global_attribute3%TYPE;
880: v_line_type ap_invoice_distributions_all.line_type_lookup_code %TYPE;
881: v_last_update_login number := FND_GLOBAL.Login_Id;
882: v_last_update_by number := FND_GLOBAL.User_ID;

Line 879: v_ship_to_loc ap_invoice_distributions_all.global_attribute3%TYPE;

875:
876: -- The following variables are used to get the information from the invoice
877: -- ditribution lines.
878: v_tax_payer_id ap_invoice_distributions_all.global_attribute2%TYPE;
879: v_ship_to_loc ap_invoice_distributions_all.global_attribute3%TYPE;
880: v_line_type ap_invoice_distributions_all.line_type_lookup_code %TYPE;
881: v_last_update_login number := FND_GLOBAL.Login_Id;
882: v_last_update_by number := FND_GLOBAL.User_ID;
883: DistWithholdings Number := 0;

Line 880: v_line_type ap_invoice_distributions_all.line_type_lookup_code %TYPE;

876: -- The following variables are used to get the information from the invoice
877: -- ditribution lines.
878: v_tax_payer_id ap_invoice_distributions_all.global_attribute2%TYPE;
879: v_ship_to_loc ap_invoice_distributions_all.global_attribute3%TYPE;
880: v_line_type ap_invoice_distributions_all.line_type_lookup_code %TYPE;
881: v_last_update_login number := FND_GLOBAL.Login_Id;
882: v_last_update_by number := FND_GLOBAL.User_ID;
883: DistWithholdings Number := 0;
884: -- Variable added for bug 6869263

Line 885: v_related_dist_id ap_invoice_distributions_all.related_id%TYPE;

881: v_last_update_login number := FND_GLOBAL.Login_Id;
882: v_last_update_by number := FND_GLOBAL.User_ID;
883: DistWithholdings Number := 0;
884: -- Variable added for bug 6869263
885: v_related_dist_id ap_invoice_distributions_all.related_id%TYPE;
886:
887: Begin
888: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
889: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JL_ZZ_AP_AWT_DEFAULT_PKG.Supp_Wh_Def','Start PROCEDURE Supp_Wh_Def');

Line 1078: FROM AP_Invoice_Distributions apid,

1074: , apid.line_type_lookup_code -- Line Type
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

Line 1118: FROM AP_Invoice_Distributions apid,

1114: , apid.line_type_lookup_code -- Line Type
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

Line 1161: FROM ap_invoice_distributions

1157: END IF;
1158:
1159: SELECT related_id
1160: INTO v_related_dist_id
1161: FROM ap_invoice_distributions
1162: WHERE invoice_id = P_Invoice_Id
1163: AND invoice_distribution_id = db_reg.invoice_distribution_id;
1164:
1165: FOR l_def_wh_dist IN c_default_wh_dist(v_related_dist_id) LOOP

Line 1279: FROM ap_invoice_distributions

1275: SELECT invoice_id,
1276: invoice_distribution_id
1277: INTO l_prepay_id,
1278: l_prepay_dist_line_num
1279: FROM ap_invoice_distributions
1280: WHERE invoice_distribution_id = P_prepay_dist_id;
1281: */
1282:
1283: -----------------------------------------------------------------------

Line 1369: FROM ap_invoice_distributions

1365: ) IS
1366:
1367: CURSOR Invoice_Distrib IS
1368: SELECT invoice_distribution_id
1369: FROM ap_invoice_distributions
1370: WHERE invoice_id = P_Invoice_ID;
1371: -- The following variables are used to get the information from the invoice
1372: -- ditribution lines.
1373: v_tax_payer_id ap_invoice_distributions_all.global_attribute2%TYPE;

Line 1373: v_tax_payer_id ap_invoice_distributions_all.global_attribute2%TYPE;

1369: FROM ap_invoice_distributions
1370: WHERE invoice_id = P_Invoice_ID;
1371: -- The following variables are used to get the information from the invoice
1372: -- ditribution lines.
1373: v_tax_payer_id ap_invoice_distributions_all.global_attribute2%TYPE;
1374: v_ship_to_loc ap_invoice_distributions_all.global_attribute3%TYPE;
1375: v_line_type ap_invoice_distributions_all. line_type_lookup_code%TYPE;
1376:
1377: Begin

Line 1374: v_ship_to_loc ap_invoice_distributions_all.global_attribute3%TYPE;

1370: WHERE invoice_id = P_Invoice_ID;
1371: -- The following variables are used to get the information from the invoice
1372: -- ditribution lines.
1373: v_tax_payer_id ap_invoice_distributions_all.global_attribute2%TYPE;
1374: v_ship_to_loc ap_invoice_distributions_all.global_attribute3%TYPE;
1375: v_line_type ap_invoice_distributions_all. line_type_lookup_code%TYPE;
1376:
1377: Begin
1378: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1375: v_line_type ap_invoice_distributions_all. line_type_lookup_code%TYPE;

1371: -- The following variables are used to get the information from the invoice
1372: -- ditribution lines.
1373: v_tax_payer_id ap_invoice_distributions_all.global_attribute2%TYPE;
1374: v_ship_to_loc ap_invoice_distributions_all.global_attribute3%TYPE;
1375: v_line_type ap_invoice_distributions_all. line_type_lookup_code%TYPE;
1376:
1377: Begin
1378: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1379: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JL_ZZ_AP_AWT_DEFAULT_PKG.Supp_Wh_ReDefault','Start PROCEDURE Supp_Wh_ReDefault');

Line 1401: FROM AP_Invoice_Distributions apid,

1397: ,apid.line_type_lookup_code -- Line Type
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

Line 1433: ,P_Inv_Dist_Id ap_invoice_distributions.invoice_distribution_id%Type) Is

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);
1437: l_gdf_category ap_invoice_distributions.global_attribute_category%Type;

Line 1437: l_gdf_category ap_invoice_distributions.global_attribute_category%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;
1440:
1441: Cursor C_Inv (x_invoice_id In ap_invoices.invoice_id%Type) Is

Line 1490: Update ap_invoice_distributions

1486: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_ZZ_AP_AWT_DEFAULT_PKG.Upd_Dist_Gdf','l_gdf category : ' || l_gdf_category );
1487: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_ZZ_AP_AWT_DEFAULT_PKG.Upd_Dist_Gdf','Ship to Location Id : ' || l_ship_to_location );
1488: End If;
1489: If upper(l_line_type_code) = 'ITEM' Then
1490: Update ap_invoice_distributions
1491: Set global_attribute3 = l_ship_to_location,
1492: global_attribute_category = l_gdf_category
1493: Where invoice_id = P_Invoice_Id
1494: -- Bug 13960680 Start