[Home] [Help]
917: -- And rownum = 1;
918: --Bug no : 6215810 -Commented the above line
919: -- Debug
920: IF (DEBUG_Var = 'Y') THEN
921: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('AWT Defaulting Exist No Override - Returning');
922: END IF;
923: -- End Debug
924: --Bug no : 6159617 - Changed the IF Condition
925: -- IF DistWithholdings = 1 Then
945: -- Copy the tax names from the parent distribution line
946: ----------------------------------------------------------
947: -- Debug
948: IF (DEBUG_Var = 'Y') THEN
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 (...');
999: -- Bug 4559472
1000: -- Revert changes for R12 - Bug 4674638
1001: -- Debug
1002: IF (DEBUG_Var = 'Y') THEN
1003: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('AWT Defaulting From Param Inv Dist ID');
1004: END IF;
1005: -- End Debug
1006:
1007: SELECT apid.global_attribute2 -- Taxpayer Id for Colombia
1036: -- Loop for each Invoice Distribution Line.
1037: -------------------------------------------------------------
1038: -- Debug
1039: IF (DEBUG_Var = 'Y') THEN
1040: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('AWT Defaulting for distributions');
1041: END IF;
1042: -- End Debug
1043: FOR db_reg IN Invoice_Distrib LOOP
1044: -------------------------------------------------------------------
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');
1068: END IF;
1069:
1070: IF DistWithholdings <> 0 THEN
1071: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN