[Home] [Help]
979: -- And rownum = 1;
980: --Bug no : 6215810 -Commented the above line
981: -- Debug
982: IF (DEBUG_Var = 'Y') THEN
983: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('AWT Defaulting Exist No Override - Returning');
984: END IF;
985: -- End Debug
986: --Bug no : 6159617 - Changed the IF Condition
987: -- IF DistWithholdings = 1 Then
1007: -- Copy the tax names from the parent distribution line
1008: ----------------------------------------------------------
1009: -- Debug
1010: IF (DEBUG_Var = 'Y') THEN
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 (...');
1063: -- Bug 4559472
1064: -- Revert changes for R12 - Bug 4674638
1065: -- Debug
1066: IF (DEBUG_Var = 'Y') THEN
1067: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('AWT Defaulting From Param Inv Dist ID');
1068: END IF;
1069: -- End Debug
1070:
1071: SELECT apid.global_attribute2 -- Taxpayer Id for Colombia
1100: -- Loop for each Invoice Distribution Line.
1101: -------------------------------------------------------------
1102: -- Debug
1103: IF (DEBUG_Var = 'Y') THEN
1104: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('AWT Defaulting for distributions');
1105: END IF;
1106: -- End Debug
1107: FOR db_reg IN Invoice_Distrib LOOP
1108: -------------------------------------------------------------------
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');
1132: END IF;
1133:
1134: IF DistWithholdings <> 0 THEN
1135: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN