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 505: The Procedure Del_Wh_Def Delete the records in JL_ZZ_AP_INV_DIS_WH

501: END IF;
502: END;
503:
504: /*-----------------------------------------------------------------
505: The Procedure Del_Wh_Def Delete the records in JL_ZZ_AP_INV_DIS_WH
506: for the Invoice_ID Parameter and the Dis_Lin_Number.
507: -------------------------------------------------------------------*/
508: --
509: -- R12 KI

Line 517: DELETE JL_ZZ_AP_INV_DIS_WH

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
518: WHERE invoice_id = P_Invoice_Id
519: AND invoice_distribution_id = P_Dis_Lin_Num;
520: */
521: -- Bug 4559472

Line 527: DELETE jl_zz_ap_inv_dis_wh

523: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JL_ZZ_AP_AWT_DEFAULT_PKG.Del_Wh_Def','Start PROCEDURE Del_Wh_Def');
524: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JL_ZZ_AP_AWT_DEFAULT_PKG.Del_Wh_Def','Parameters are :');
525: 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);
526: END IF;
527: DELETE jl_zz_ap_inv_dis_wh
528: WHERE invoice_distribution_id = p_inv_dist_id;
529: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
530: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JL_ZZ_AP_AWT_DEFAULT_PKG.Del_Wh_Def','End PROCEDURE Del_Wh_Def');
531: END IF;

Line 872: FROM jl_zz_ap_inv_dis_wh

868: -- Added Cursor for bug 6869263
869: CURSOR c_default_wh_dist (p_related_dist_id number) IS
870: SELECT Supp_Awt_Code_Id,
871: org_id
872: FROM jl_zz_ap_inv_dis_wh
873: WHERE invoice_id = p_invoice_id
874: AND invoice_distribution_id = p_related_dist_id;
875:
876: -- The following variables are used to get the information from the invoice

Line 976: From jl_zz_ap_inv_dis_wh

972: --Bug no : 6215810 - Changed the query
973: -- Select 1
974: SELECT COUNT(*)
975: INTO DistWithholdings
976: From jl_zz_ap_inv_dis_wh
977: Where invoice_id = P_Invoice_ID
978: And invoice_distribution_id = P_Inv_Dist_Id;
979: -- And rownum = 1;
980: --Bug no : 6215810 -Commented the above line

Line 1015: 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 (...');

1011: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('AWT Defaulting from Parent Dist ID');
1012: END IF;
1013: -- End Debug
1014: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1015: 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 (...');
1016: END IF;
1017: INSERT INTO jl_zz_ap_inv_dis_wh (
1018: inv_distrib_awt_id
1019: ,invoice_id

Line 1017: INSERT INTO jl_zz_ap_inv_dis_wh (

1013: -- End Debug
1014: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1015: 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 (...');
1016: END IF;
1017: INSERT INTO jl_zz_ap_inv_dis_wh (
1018: inv_distrib_awt_id
1019: ,invoice_id
1020: -- Bug 4559478
1021: ,invoice_distribution_id

Line 1032: jl_zz_ap_inv_dis_wh_s.nextval

1028: ,last_update_login
1029: ,org_id
1030: )
1031: SELECT
1032: jl_zz_ap_inv_dis_wh_s.nextval
1033: ,P_Invoice_Id
1034: ,P_Inv_Dist_Id
1035: -- Bug 4559478 : -99 for distribution_line_number
1036: ,-99

Line 1045: jl_zz_ap_inv_dis_wh jlid

1041: ,sysdate
1042: ,v_last_update_login
1043: ,jlid.org_id
1044: FROM
1045: jl_zz_ap_inv_dis_wh jlid
1046: WHERE jlid.invoice_distribution_id = P_Parent_Dist_ID
1047: AND jlid.invoice_id = P_Invoice_Id;
1048: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1049: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JL_ZZ_AP_AWT_DEFAULT_PKG.Supp_Wh_Def','End PROCEDURE Supp_Wh_Def - 2');

Line 1127: FROM jl_zz_ap_inv_dis_wh

1123: AND apid.invoice_id = apil.invoice_id;
1124: --bug 6346106 changes - The following code is added
1125: SELECT COUNT(*)
1126: INTO DistWithholdings
1127: FROM jl_zz_ap_inv_dis_wh
1128: WHERE invoice_id = P_Invoice_ID
1129: AND invoice_distribution_id = db_reg.invoice_distribution_id;
1130: IF (DEBUG_Var = 'Y') THEN
1131: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('AWT Defaulting Exist No Override - Returning');

Line 1167: INSERT INTO jl_zz_ap_inv_dis_wh (

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
1166:
1167: INSERT INTO jl_zz_ap_inv_dis_wh (
1168: inv_distrib_awt_id
1169: ,invoice_id
1170: ,distribution_line_number
1171: ,invoice_distribution_id

Line 1181: jl_zz_ap_inv_dis_wh_s.nextval

1177: ,last_update_login
1178: ,org_id -- Add org_id for MOAC
1179: )
1180: VALUES (
1181: jl_zz_ap_inv_dis_wh_s.nextval
1182: ,P_Invoice_Id
1183: ,-99
1184: , db_reg.invoice_distribution_id
1185: ,l_def_wh_dist.Supp_Awt_Code_Id

Line 1197: 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 ');

1193:
1194: END LOOP;
1195:
1196: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1197: 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 ');
1198: END IF;
1199:
1200: ELSE
1201: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1288: 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 ...');

1284: -- Copy the withholdings to the new PREPAY line.
1285: -- Insert Withholdings in the table.
1286: ----------------------------------------------------------------------
1287: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1288: 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 ...');
1289: END IF;
1290: INSERT INTO jl_zz_ap_inv_dis_wh
1291: (INV_DISTRIB_AWT_ID,
1292: INVOICE_ID,

Line 1290: INSERT INTO jl_zz_ap_inv_dis_wh

1286: ----------------------------------------------------------------------
1287: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1288: 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 ...');
1289: END IF;
1290: INSERT INTO jl_zz_ap_inv_dis_wh
1291: (INV_DISTRIB_AWT_ID,
1292: INVOICE_ID,
1293: distribution_line_number, -- Bug 4559474
1294: invoice_distribution_id, -- Bug 4559474

Line 1319: JL_ZZ_AP_INV_DIS_WH_S.nextval,

1315: ATTRIBUTE13,
1316: ATTRIBUTE14,
1317: ATTRIBUTE15)
1318: SELECT
1319: JL_ZZ_AP_INV_DIS_WH_S.nextval,
1320: P_Invoice_Id,
1321: -99, -- Bug 4559474
1322: p_inv_dist_id, -- Bug 4559474
1323: idw.supp_awt_code_id,

Line 1346: FROM jl_zz_ap_inv_dis_wh idw

1342: idw.ATTRIBUTE12,
1343: idw.ATTRIBUTE13,
1344: idw.ATTRIBUTE14,
1345: idw.ATTRIBUTE15
1346: FROM jl_zz_ap_inv_dis_wh idw
1347: WHERE idw.invoice_distribution_id = p_prepay_dist_id; -- Bug 4559474
1348: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1349: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JL_ZZ_AP_AWT_DEFAULT_PKG.Carry_Withholdings_Prepay','End PROCEDURE Carry_Withholdings_Prepay');
1350: END IF;