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 JL_ZZ_AP_INV_DIS_WH

Line 25: -- Insert_AWT_Default insert in jl_zz_ap_inv_dis_wh_all the withholdings after the validation.

21: -- =====================================================================
22: -- P R I V A T E O B J E C T S
23: -- =====================================================================
24: --
25: -- Insert_AWT_Default insert in jl_zz_ap_inv_dis_wh_all the withholdings after the validation.
26: --
27: -- Define Package Level Debug Variable and Assign the Profile
28: DEBUG_Var varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
29: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 83: SELECT jl_zz_ap_inv_dis_wh_s.nextval

79: v_last_update_by := FND_GLOBAL.User_ID;
80: v_last_update_login := FND_GLOBAL.Login_Id;
81:
82: -- Select next value from the sequence.
83: SELECT jl_zz_ap_inv_dis_wh_s.nextval
84: INTO Seq_Inv_Dis_Awt_Id
85: FROM dual;
86:
87: --

Line 88: -- Insert into JL_ZZ_AP_INV_DIS_WH_ALL

84: INTO Seq_Inv_Dis_Awt_Id
85: FROM dual;
86:
87: --
88: -- Insert into JL_ZZ_AP_INV_DIS_WH_ALL
89: --
90: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
91: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_ZZ_AP_AWT_DEFAULT_PKG.Insert_AWT_Default','Inserting this record to JL_ZZ_AP_INV_DIS_WH_ALL with inv_distrib_awt_id='||Seq_Inv_Dis_Awt_Id);
92: END IF;

Line 91: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_ZZ_AP_AWT_DEFAULT_PKG.Insert_AWT_Default','Inserting this record to JL_ZZ_AP_INV_DIS_WH_ALL with inv_distrib_awt_id='||Seq_Inv_Dis_Awt_Id);

87: --
88: -- Insert into JL_ZZ_AP_INV_DIS_WH_ALL
89: --
90: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
91: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_ZZ_AP_AWT_DEFAULT_PKG.Insert_AWT_Default','Inserting this record to JL_ZZ_AP_INV_DIS_WH_ALL with inv_distrib_awt_id='||Seq_Inv_Dis_Awt_Id);
92: END IF;
93:
94: INSERT INTO jl_zz_ap_inv_dis_wh (
95: inv_distrib_awt_id

Line 94: INSERT INTO jl_zz_ap_inv_dis_wh (

90: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
91: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_ZZ_AP_AWT_DEFAULT_PKG.Insert_AWT_Default','Inserting this record to JL_ZZ_AP_INV_DIS_WH_ALL with inv_distrib_awt_id='||Seq_Inv_Dis_Awt_Id);
92: END IF;
93:
94: INSERT INTO jl_zz_ap_inv_dis_wh (
95: inv_distrib_awt_id
96: ,invoice_id
97: -- Bug 4559472
98: ,distribution_line_number

Line 114: -- as it is NOT NULL column in jl_zz_ap_inv_dis_wh_all

110: ,P_Invoice_Id
111: -- Bug 4559472
112: --,P_Dis_Line_Number
113: -- Populate distribution_line_number with -99 for R12 records
114: -- as it is NOT NULL column in jl_zz_ap_inv_dis_wh_all
115: ,-99
116: , P_Inv_Dist_Id
117: ,P_Supp_Awt_Code_Id
118: ,v_last_update_by

Line 478: The Procedure Del_Wh_Def Delete the records in JL_ZZ_AP_INV_DIS_WH

474: END IF;
475: END;
476:
477: /*-----------------------------------------------------------------
478: The Procedure Del_Wh_Def Delete the records in JL_ZZ_AP_INV_DIS_WH
479: for the Invoice_ID Parameter and the Dis_Lin_Number.
480: -------------------------------------------------------------------*/
481: --
482: -- R12 KI

Line 490: DELETE JL_ZZ_AP_INV_DIS_WH

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
491: WHERE invoice_id = P_Invoice_Id
492: AND invoice_distribution_id = P_Dis_Lin_Num;
493: */
494: -- Bug 4559472

Line 500: DELETE jl_zz_ap_inv_dis_wh

496: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JL_ZZ_AP_AWT_DEFAULT_PKG.Del_Wh_Def','Start PROCEDURE Del_Wh_Def');
497: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JL_ZZ_AP_AWT_DEFAULT_PKG.Del_Wh_Def','Parameters are :');
498: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JL_ZZ_AP_AWT_DEFAULT_PKG.Del_Wh_Def',' p_inv_dist_id='||p_inv_dist_id);
499: END IF;
500: DELETE jl_zz_ap_inv_dis_wh
501: WHERE invoice_distribution_id = p_inv_dist_id;
502: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
503: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JL_ZZ_AP_AWT_DEFAULT_PKG.Del_Wh_Def','End PROCEDURE Del_Wh_Def');
504: END IF;

Line 814: FROM jl_zz_ap_inv_dis_wh

810: -- Added Cursor for bug 6869263
811: CURSOR c_default_wh_dist (p_related_dist_id number) IS
812: SELECT Supp_Awt_Code_Id,
813: org_id
814: FROM jl_zz_ap_inv_dis_wh
815: WHERE invoice_id = p_invoice_id
816: AND invoice_distribution_id = p_related_dist_id;
817:
818: -- The following variables are used to get the information from the invoice

Line 914: From jl_zz_ap_inv_dis_wh

910: --Bug no : 6215810 - Changed the query
911: -- Select 1
912: SELECT COUNT(*)
913: INTO DistWithholdings
914: From jl_zz_ap_inv_dis_wh
915: Where invoice_id = P_Invoice_ID
916: And invoice_distribution_id = P_Inv_Dist_Id;
917: -- And rownum = 1;
918: --Bug no : 6215810 -Commented the above line

Line 953: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_ZZ_AP_AWT_DEFAULT_PKG.Supp_Wh_Def','INSERT INTO jl_zz_ap_inv_dis_wh (...');

949: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('AWT Defaulting from Parent Dist ID');
950: END IF;
951: -- End Debug
952: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
953: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_ZZ_AP_AWT_DEFAULT_PKG.Supp_Wh_Def','INSERT INTO jl_zz_ap_inv_dis_wh (...');
954: END IF;
955: INSERT INTO jl_zz_ap_inv_dis_wh (
956: inv_distrib_awt_id
957: ,invoice_id

Line 955: INSERT INTO jl_zz_ap_inv_dis_wh (

951: -- End Debug
952: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
953: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_ZZ_AP_AWT_DEFAULT_PKG.Supp_Wh_Def','INSERT INTO jl_zz_ap_inv_dis_wh (...');
954: END IF;
955: INSERT INTO jl_zz_ap_inv_dis_wh (
956: inv_distrib_awt_id
957: ,invoice_id
958: -- Bug 4559478
959: ,invoice_distribution_id

Line 969: jl_zz_ap_inv_dis_wh_s.nextval

965: ,last_update_date
966: ,last_update_login
967: )
968: SELECT
969: jl_zz_ap_inv_dis_wh_s.nextval
970: ,P_Invoice_Id
971: ,P_Inv_Dist_Id
972: -- Bug 4559478 : -99 for distribution_line_number
973: ,-99

Line 981: jl_zz_ap_inv_dis_wh jlid

977: ,v_last_update_by
978: ,sysdate
979: ,v_last_update_login
980: FROM
981: jl_zz_ap_inv_dis_wh jlid
982: WHERE jlid.invoice_distribution_id = P_Parent_Dist_ID
983: AND jlid.invoice_id = P_Invoice_Id;
984: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
985: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JL_ZZ_AP_AWT_DEFAULT_PKG.Supp_Wh_Def','End PROCEDURE Supp_Wh_Def - 2');

Line 1063: FROM jl_zz_ap_inv_dis_wh

1059: AND apid.invoice_id = apil.invoice_id;
1060: --bug 6346106 changes - The following code is added
1061: SELECT COUNT(*)
1062: INTO DistWithholdings
1063: FROM jl_zz_ap_inv_dis_wh
1064: WHERE invoice_id = P_Invoice_ID
1065: AND invoice_distribution_id = db_reg.invoice_distribution_id;
1066: IF (DEBUG_Var = 'Y') THEN
1067: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('AWT Defaulting Exist No Override - Returning');

Line 1103: INSERT INTO jl_zz_ap_inv_dis_wh (

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
1102:
1103: INSERT INTO jl_zz_ap_inv_dis_wh (
1104: inv_distrib_awt_id
1105: ,invoice_id
1106: ,distribution_line_number
1107: ,invoice_distribution_id

Line 1117: jl_zz_ap_inv_dis_wh_s.nextval

1113: ,last_update_login
1114: ,org_id -- Add org_id for MOAC
1115: )
1116: VALUES (
1117: jl_zz_ap_inv_dis_wh_s.nextval
1118: ,P_Invoice_Id
1119: ,-99
1120: , db_reg.invoice_distribution_id
1121: ,l_def_wh_dist.Supp_Awt_Code_Id

Line 1133: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_ZZ_AP_AWT_DEFAULT_PKG.Supp_Wh_Def','Inside call to ap_approval_pkg and Distwith =0 and line type in variance, inserted record into jl_zz_ap_inv_dis_wh table ');

1129:
1130: END LOOP;
1131:
1132: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1133: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_ZZ_AP_AWT_DEFAULT_PKG.Supp_Wh_Def','Inside call to ap_approval_pkg and Distwith =0 and line type in variance, inserted record into jl_zz_ap_inv_dis_wh table ');
1134: END IF;
1135:
1136: ELSE
1137: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1224: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_ZZ_AP_AWT_DEFAULT_PKG.Carry_Withholdings_Prepay','INSERT INTO jl_zz_ap_inv_dis_wh ...');

1220: -- Copy the withholdings to the new PREPAY line.
1221: -- Insert Withholdings in the table.
1222: ----------------------------------------------------------------------
1223: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1224: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_ZZ_AP_AWT_DEFAULT_PKG.Carry_Withholdings_Prepay','INSERT INTO jl_zz_ap_inv_dis_wh ...');
1225: END IF;
1226: INSERT INTO jl_zz_ap_inv_dis_wh
1227: (INV_DISTRIB_AWT_ID,
1228: INVOICE_ID,

Line 1226: INSERT INTO jl_zz_ap_inv_dis_wh

1222: ----------------------------------------------------------------------
1223: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1224: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_ZZ_AP_AWT_DEFAULT_PKG.Carry_Withholdings_Prepay','INSERT INTO jl_zz_ap_inv_dis_wh ...');
1225: END IF;
1226: INSERT INTO jl_zz_ap_inv_dis_wh
1227: (INV_DISTRIB_AWT_ID,
1228: INVOICE_ID,
1229: distribution_line_number, -- Bug 4559474
1230: invoice_distribution_id, -- Bug 4559474

Line 1255: JL_ZZ_AP_INV_DIS_WH_S.nextval,

1251: ATTRIBUTE13,
1252: ATTRIBUTE14,
1253: ATTRIBUTE15)
1254: SELECT
1255: JL_ZZ_AP_INV_DIS_WH_S.nextval,
1256: P_Invoice_Id,
1257: -99, -- Bug 4559474
1258: p_inv_dist_id, -- Bug 4559474
1259: idw.supp_awt_code_id,

Line 1282: FROM jl_zz_ap_inv_dis_wh idw

1278: idw.ATTRIBUTE12,
1279: idw.ATTRIBUTE13,
1280: idw.ATTRIBUTE14,
1281: idw.ATTRIBUTE15
1282: FROM jl_zz_ap_inv_dis_wh idw
1283: WHERE idw.invoice_distribution_id = p_prepay_dist_id; -- Bug 4559474
1284: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1285: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JL_ZZ_AP_AWT_DEFAULT_PKG.Carry_Withholdings_Prepay','End PROCEDURE Carry_Withholdings_Prepay');
1286: END IF;