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 486: p_inv_dist_id ap_invoice_distributions_all.invoice_distribution_id%TYPE

482: -- R12 KI
483: --
484: PROCEDURE Del_Wh_Def
485: (
486: p_inv_dist_id ap_invoice_distributions_all.invoice_distribution_id%TYPE
487: ) IS
488: Begin
489: /*
490: DELETE JL_ZZ_AP_INV_DIS_WH

Line 796: , P_Inv_Dist_Id ap_invoice_distributions_all.invoice_distribution_id%TYPE

792:
793: PROCEDURE Supp_Wh_Def
794: ( P_Invoice_Id ap_invoices_all.invoice_id%TYPE
795: , P_Inv_Line_Num ap_invoice_lines_all.line_number%TYPE
796: , P_Inv_Dist_Id ap_invoice_distributions_all.invoice_distribution_id%TYPE
797: , P_Calling_Module VARCHAR2
798: , P_Parent_Dist_ID IN Number Default null
799: ) IS
800:

Line 806: FROM ap_invoice_distributions

802: -- R12 KI Changes : 4559472
803: --
804: CURSOR Invoice_Distrib IS
805: SELECT invoice_distribution_id
806: FROM ap_invoice_distributions
807: WHERE invoice_id = P_Invoice_ID
808: AND invoice_line_number = P_Inv_Line_Num;
809:
810: -- Added Cursor for bug 6869263

Line 820: v_tax_payer_id ap_invoice_distributions_all.global_attribute2%TYPE;

816: AND invoice_distribution_id = p_related_dist_id;
817:
818: -- The following variables are used to get the information from the invoice
819: -- ditribution lines.
820: v_tax_payer_id ap_invoice_distributions_all.global_attribute2%TYPE;
821: v_ship_to_loc ap_invoice_distributions_all.global_attribute3%TYPE;
822: v_line_type ap_invoice_distributions_all.line_type_lookup_code %TYPE;
823: v_last_update_login number := FND_GLOBAL.Login_Id;
824: v_last_update_by number := FND_GLOBAL.User_ID;

Line 821: v_ship_to_loc ap_invoice_distributions_all.global_attribute3%TYPE;

817:
818: -- The following variables are used to get the information from the invoice
819: -- ditribution lines.
820: v_tax_payer_id ap_invoice_distributions_all.global_attribute2%TYPE;
821: v_ship_to_loc ap_invoice_distributions_all.global_attribute3%TYPE;
822: v_line_type ap_invoice_distributions_all.line_type_lookup_code %TYPE;
823: v_last_update_login number := FND_GLOBAL.Login_Id;
824: v_last_update_by number := FND_GLOBAL.User_ID;
825: DistWithholdings Number := 0;

Line 822: v_line_type ap_invoice_distributions_all.line_type_lookup_code %TYPE;

818: -- The following variables are used to get the information from the invoice
819: -- ditribution lines.
820: v_tax_payer_id ap_invoice_distributions_all.global_attribute2%TYPE;
821: v_ship_to_loc ap_invoice_distributions_all.global_attribute3%TYPE;
822: v_line_type ap_invoice_distributions_all.line_type_lookup_code %TYPE;
823: v_last_update_login number := FND_GLOBAL.Login_Id;
824: v_last_update_by number := FND_GLOBAL.User_ID;
825: DistWithholdings Number := 0;
826: -- Variable added for bug 6869263

Line 827: v_related_dist_id ap_invoice_distributions_all.related_id%TYPE;

823: v_last_update_login number := FND_GLOBAL.Login_Id;
824: v_last_update_by number := FND_GLOBAL.User_ID;
825: DistWithholdings Number := 0;
826: -- Variable added for bug 6869263
827: v_related_dist_id ap_invoice_distributions_all.related_id%TYPE;
828:
829: Begin
830: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
831: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JL_ZZ_AP_AWT_DEFAULT_PKG.Supp_Wh_Def','Start PROCEDURE Supp_Wh_Def');

Line 1014: FROM AP_Invoice_Distributions apid,

1010: , apid.line_type_lookup_code -- Line Type
1011: INTO v_tax_payer_id,
1012: v_ship_to_loc,
1013: v_line_type
1014: FROM AP_Invoice_Distributions apid,
1015: AP_Invoice_Lines apil
1016: WHERE apid.invoice_id = p_invoice_id
1017: AND apid.invoice_distribution_id = p_inv_dist_id
1018: AND apid.invoice_line_number = apil.line_number

Line 1054: FROM AP_Invoice_Distributions apid,

1050: , apid.line_type_lookup_code -- Line Type
1051: INTO v_tax_payer_id,
1052: v_ship_to_loc,
1053: v_line_type
1054: FROM AP_Invoice_Distributions apid,
1055: AP_Invoice_Lines apil
1056: WHERE apid.invoice_id = P_Invoice_Id
1057: AND apid.invoice_distribution_id = db_reg.invoice_distribution_id
1058: AND apid.invoice_line_number = apil.line_number

Line 1097: FROM ap_invoice_distributions

1093: END IF;
1094:
1095: SELECT related_id
1096: INTO v_related_dist_id
1097: FROM ap_invoice_distributions
1098: WHERE invoice_id = P_Invoice_Id
1099: AND invoice_distribution_id = db_reg.invoice_distribution_id;
1100:
1101: FOR l_def_wh_dist IN c_default_wh_dist(v_related_dist_id) LOOP

Line 1215: FROM ap_invoice_distributions

1211: SELECT invoice_id,
1212: invoice_distribution_id
1213: INTO l_prepay_id,
1214: l_prepay_dist_line_num
1215: FROM ap_invoice_distributions
1216: WHERE invoice_distribution_id = P_prepay_dist_id;
1217: */
1218:
1219: -----------------------------------------------------------------------

Line 1305: FROM ap_invoice_distributions

1301: ) IS
1302:
1303: CURSOR Invoice_Distrib IS
1304: SELECT invoice_distribution_id
1305: FROM ap_invoice_distributions
1306: WHERE invoice_id = P_Invoice_ID;
1307: -- The following variables are used to get the information from the invoice
1308: -- ditribution lines.
1309: v_tax_payer_id ap_invoice_distributions_all.global_attribute2%TYPE;

Line 1309: v_tax_payer_id ap_invoice_distributions_all.global_attribute2%TYPE;

1305: FROM ap_invoice_distributions
1306: WHERE invoice_id = P_Invoice_ID;
1307: -- The following variables are used to get the information from the invoice
1308: -- ditribution lines.
1309: v_tax_payer_id ap_invoice_distributions_all.global_attribute2%TYPE;
1310: v_ship_to_loc ap_invoice_distributions_all.global_attribute3%TYPE;
1311: v_line_type ap_invoice_distributions_all. line_type_lookup_code%TYPE;
1312:
1313: Begin

Line 1310: v_ship_to_loc ap_invoice_distributions_all.global_attribute3%TYPE;

1306: WHERE invoice_id = P_Invoice_ID;
1307: -- The following variables are used to get the information from the invoice
1308: -- ditribution lines.
1309: v_tax_payer_id ap_invoice_distributions_all.global_attribute2%TYPE;
1310: v_ship_to_loc ap_invoice_distributions_all.global_attribute3%TYPE;
1311: v_line_type ap_invoice_distributions_all. line_type_lookup_code%TYPE;
1312:
1313: Begin
1314: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1311: v_line_type ap_invoice_distributions_all. line_type_lookup_code%TYPE;

1307: -- The following variables are used to get the information from the invoice
1308: -- ditribution lines.
1309: v_tax_payer_id ap_invoice_distributions_all.global_attribute2%TYPE;
1310: v_ship_to_loc ap_invoice_distributions_all.global_attribute3%TYPE;
1311: v_line_type ap_invoice_distributions_all. line_type_lookup_code%TYPE;
1312:
1313: Begin
1314: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1315: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JL_ZZ_AP_AWT_DEFAULT_PKG.Supp_Wh_ReDefault','Start PROCEDURE Supp_Wh_ReDefault');

Line 1337: FROM AP_Invoice_Distributions apid,

1333: ,apid.line_type_lookup_code -- Line Type
1334: INTO v_tax_payer_id,
1335: v_ship_to_loc,
1336: v_line_type
1337: FROM AP_Invoice_Distributions apid,
1338: AP_Invoice_Lines apil
1339: WHERE apid.invoice_id = P_Invoice_Id
1340: AND apid.invoice_distribution_id = db_reg.invoice_distribution_id
1341: AND apil.line_number = apid.invoice_line_number