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_AR_APPLICABLE_TAXES dependencies on JL_ZZ_AP_SUP_AWT_CD

Line 502: l_SUPP_AWT_CODE_ID_CD JL_ZZ_AP_SUP_AWT_CD_ALL.SUPP_AWT_CODE_ID%TYPE;

498:
499: l_WHT_RATE_ALL AP_AWT_TAX_RATES_ALL.TAX_RATE%TYPE;
500: l_WHT_GROUP_NUM_ALL AP_AWT_TAX_RATES_ALL.TAX_NAME%TYPE;
501:
502: l_SUPP_AWT_CODE_ID_CD JL_ZZ_AP_SUP_AWT_CD_ALL.SUPP_AWT_CODE_ID%TYPE;
503: l_SUPP_AWT_TYPE_ID_CD JL_ZZ_AP_SUP_AWT_CD_ALL.SUPP_AWT_TYPE_ID%TYPE;
504: l_SUPP_AWT_CODE_ID_SEQ JL_ZZ_AP_SUP_AWT_CD_ALL.SUPP_AWT_CODE_ID%TYPE;
505: l_SUPP_AWT_TYPE_ID_SEQ JL_ZZ_AP_SUP_AWT_CD_ALL.SUPP_AWT_TYPE_ID%TYPE;
506: l_tax_id ap_tax_codes.tax_id%TYPE;

Line 503: l_SUPP_AWT_TYPE_ID_CD JL_ZZ_AP_SUP_AWT_CD_ALL.SUPP_AWT_TYPE_ID%TYPE;

499: l_WHT_RATE_ALL AP_AWT_TAX_RATES_ALL.TAX_RATE%TYPE;
500: l_WHT_GROUP_NUM_ALL AP_AWT_TAX_RATES_ALL.TAX_NAME%TYPE;
501:
502: l_SUPP_AWT_CODE_ID_CD JL_ZZ_AP_SUP_AWT_CD_ALL.SUPP_AWT_CODE_ID%TYPE;
503: l_SUPP_AWT_TYPE_ID_CD JL_ZZ_AP_SUP_AWT_CD_ALL.SUPP_AWT_TYPE_ID%TYPE;
504: l_SUPP_AWT_CODE_ID_SEQ JL_ZZ_AP_SUP_AWT_CD_ALL.SUPP_AWT_CODE_ID%TYPE;
505: l_SUPP_AWT_TYPE_ID_SEQ JL_ZZ_AP_SUP_AWT_CD_ALL.SUPP_AWT_TYPE_ID%TYPE;
506: l_tax_id ap_tax_codes.tax_id%TYPE;
507: l_SUPP_AWT_TYPE_ID_TYPES JL_ZZ_AP_SUPP_AWT_TYPES.SUPP_AWT_TYPE_ID%TYPE;

Line 504: l_SUPP_AWT_CODE_ID_SEQ JL_ZZ_AP_SUP_AWT_CD_ALL.SUPP_AWT_CODE_ID%TYPE;

500: l_WHT_GROUP_NUM_ALL AP_AWT_TAX_RATES_ALL.TAX_NAME%TYPE;
501:
502: l_SUPP_AWT_CODE_ID_CD JL_ZZ_AP_SUP_AWT_CD_ALL.SUPP_AWT_CODE_ID%TYPE;
503: l_SUPP_AWT_TYPE_ID_CD JL_ZZ_AP_SUP_AWT_CD_ALL.SUPP_AWT_TYPE_ID%TYPE;
504: l_SUPP_AWT_CODE_ID_SEQ JL_ZZ_AP_SUP_AWT_CD_ALL.SUPP_AWT_CODE_ID%TYPE;
505: l_SUPP_AWT_TYPE_ID_SEQ JL_ZZ_AP_SUP_AWT_CD_ALL.SUPP_AWT_TYPE_ID%TYPE;
506: l_tax_id ap_tax_codes.tax_id%TYPE;
507: l_SUPP_AWT_TYPE_ID_TYPES JL_ZZ_AP_SUPP_AWT_TYPES.SUPP_AWT_TYPE_ID%TYPE;
508: l_VENDOR_ID PO_VENDORS.VENDOR_ID%TYPE;

Line 505: l_SUPP_AWT_TYPE_ID_SEQ JL_ZZ_AP_SUP_AWT_CD_ALL.SUPP_AWT_TYPE_ID%TYPE;

501:
502: l_SUPP_AWT_CODE_ID_CD JL_ZZ_AP_SUP_AWT_CD_ALL.SUPP_AWT_CODE_ID%TYPE;
503: l_SUPP_AWT_TYPE_ID_CD JL_ZZ_AP_SUP_AWT_CD_ALL.SUPP_AWT_TYPE_ID%TYPE;
504: l_SUPP_AWT_CODE_ID_SEQ JL_ZZ_AP_SUP_AWT_CD_ALL.SUPP_AWT_CODE_ID%TYPE;
505: l_SUPP_AWT_TYPE_ID_SEQ JL_ZZ_AP_SUP_AWT_CD_ALL.SUPP_AWT_TYPE_ID%TYPE;
506: l_tax_id ap_tax_codes.tax_id%TYPE;
507: l_SUPP_AWT_TYPE_ID_TYPES JL_ZZ_AP_SUPP_AWT_TYPES.SUPP_AWT_TYPE_ID%TYPE;
508: l_VENDOR_ID PO_VENDORS.VENDOR_ID%TYPE;
509: l_INV_DISTRIB_AWT_ID_INV JL_ZZ_AP_INV_DIS_WH_ALL.INV_DISTRIB_AWT_ID%TYPE;

Line 949: SELECT jl_zz_ap_sup_awt_cd_s.nextval INTO l_SUPP_AWT_CODE_ID_SEQ FROM dual;

945: FND_FILE.put_line( FND_FILE.LOG,'17. l_tax_id : '|| l_tax_id || 'l_TAXPAYER_ID : '|| l_TAXPAYER_ID);
946: END IF;
947:
948:
949: SELECT jl_zz_ap_sup_awt_cd_s.nextval INTO l_SUPP_AWT_CODE_ID_SEQ FROM dual;
950:
951: IF p_debug_log = 'Y' THEN
952: FND_FILE.put_line( FND_FILE.LOG,'18. l_SUPP_AWT_CODE_ID_SEQ'|| l_SUPP_AWT_CODE_ID_SEQ);
953: FND_FILE.put_line( FND_FILE.LOG,'18. l_SUPP_AWT_TYPE_ID_CD'|| l_SUPP_AWT_TYPE_ID_CD);

Line 962: FROM JL_ZZ_AP_SUP_AWT_CD SAWTC

958: SELECT 'Y',
959: SAWTC.SUPP_AWT_CODE_ID
960: INTO taxtype_code_check,
961: l_SUPP_AWT_CODE_ID_CD
962: FROM JL_ZZ_AP_SUP_AWT_CD SAWTC
963: WHERE SAWTC.SUPP_AWT_TYPE_ID = l_SUPP_AWT_TYPE_ID_CD
964: AND SAWTC.TAX_ID = l_tax_id
965: AND (SAWTC.EFFECTIVE_START_DATE = l_START_DATE OR SAWTC.EFFECTIVE_END_DATE = l_END_DATE);
966:

Line 972: FND_FILE.PUT_LINE( FND_FILE.LOG,'21. Error occured while fetching data in JL_ZZ_AP_SUP_AWT_CD');

968: WHEN NO_DATA_FOUND THEN
969: taxtype_code_check := 'N';
970: WHEN OTHERS THEN
971: taxtype_code_check := 'N';
972: FND_FILE.PUT_LINE( FND_FILE.LOG,'21. Error occured while fetching data in JL_ZZ_AP_SUP_AWT_CD');
973: END;
974:
975: EXCEPTION
976: WHEN OTHERS THEN

Line 977: FND_FILE.PUT_LINE( FND_FILE.LOG,'21. No records fetched from JL_ZZ_AP_SUP_AWT_CD for Taxpayer Id :||l_TAXPAYER_ID');

973: END;
974:
975: EXCEPTION
976: WHEN OTHERS THEN
977: FND_FILE.PUT_LINE( FND_FILE.LOG,'21. No records fetched from JL_ZZ_AP_SUP_AWT_CD for Taxpayer Id :||l_TAXPAYER_ID');
978:
979: END;
980:
981:

Line 984: FND_FILE.PUT_LINE( FND_FILE.LOG,'21. Records already present in JL_ZZ_AP_SUP_AWT_CD table, no modifications');

980:
981:
982: IF taxtype_code_check = 'Y' THEN
983:
984: FND_FILE.PUT_LINE( FND_FILE.LOG,'21. Records already present in JL_ZZ_AP_SUP_AWT_CD table, no modifications');
985: FND_FILE.PUT_LINE( FND_FILE.LOG,'21 . L_TAX_ID'|| L_TAX_ID || 'l_SUPP_AWT_TYPE_ID_CD' || l_SUPP_AWT_TYPE_ID_CD);
986: FND_FILE.PUT_LINE( FND_FILE.LOG,'21 . L_EFFECTIVE_START_DATE'|| l_START_DATE || 'EFFECTIVE_END_DATE' || l_END_DATE);
987:
988: ELSE

Line 992: UPDATE JL_ZZ_AP_SUP_AWT_CD SAWTC SET SAWTC.EFFECTIVE_END_DATE = l_START_DATE - 1

988: ELSE
989:
990: BEGIN
991: -- CODE TO UPDATE THE EFFECTIVE_END_DATE FOR OTHER PRIMARY_TAX_FLAG = 'Y' AND OTHER L_TAX_ID
992: UPDATE JL_ZZ_AP_SUP_AWT_CD SAWTC SET SAWTC.EFFECTIVE_END_DATE = l_START_DATE - 1
993: WHERE SAWTC.primary_tax_flag = 'Y'
994: AND SAWTC.SUPP_AWT_CODE_ID <> l_SUPP_AWT_CODE_ID_SEQ
995: AND SAWTC.SUPP_AWT_TYPE_ID = l_SUPP_AWT_TYPE_ID_CD
996: --AND SAWTC.TAX_ID <> l_tax_id -- other l_tax_id

Line 1001: FND_FILE.PUT_LINE( FND_FILE.LOG,'19 .UPDATED DATA IN JL_ZZ_AP_SUP_AWT_CD FOR '|| SQL%ROWCOUNT || 'RECORDS');

997: AND SAWTC.EFFECTIVE_END_DATE IS NULL;
998:
999:
1000: IF p_debug_log = 'Y' THEN
1001: FND_FILE.PUT_LINE( FND_FILE.LOG,'19 .UPDATED DATA IN JL_ZZ_AP_SUP_AWT_CD FOR '|| SQL%ROWCOUNT || 'RECORDS');
1002: FND_FILE.PUT_LINE( FND_FILE.LOG,'19. EFFECTIVE_END_DATE (L_START_DATE-1) : '|| L_START_DATE);
1003: FND_FILE.PUT_LINE( FND_FILE.LOG,'19. L_TAX_ID : '|| L_TAX_ID || ' L_TAXPAYER_ID : '|| L_TAXPAYER_ID);
1004: END IF;
1005:

Line 1008: INSERT INTO JL_ZZ_AP_SUP_AWT_CD

1004: END IF;
1005:
1006:
1007:
1008: INSERT INTO JL_ZZ_AP_SUP_AWT_CD
1009: (SUPP_AWT_CODE_ID,
1010: SUPP_AWT_TYPE_ID,
1011: TAX_ID,
1012: PRIMARY_TAX_FLAG,

Line 1037: FND_FILE.PUT_LINE( FND_FILE.LOG,'21 . INSERTED DATA IN JL_ZZ_AP_SUP_AWT_CD FOR '|| SQL%ROWCOUNT || 'RECORDS');

1033: NULL); --EFFECTIVE_END_DATE
1034:
1035:
1036: IF p_debug_log = 'Y' THEN
1037: FND_FILE.PUT_LINE( FND_FILE.LOG,'21 . INSERTED DATA IN JL_ZZ_AP_SUP_AWT_CD FOR '|| SQL%ROWCOUNT || 'RECORDS');
1038: END IF;
1039:
1040:
1041: EXCEPTION

Line 1045: FND_FILE.PUT_LINE( FND_FILE.LOG,'21. INSERT NOT DONE IN JL_ZZ_AP_SUP_AWT_CD '|| SQLCODE ||' -ERROR- '|| SQLERRM);

1041: EXCEPTION
1042: WHEN OTHERS THEN
1043:
1044: IF p_debug_log = 'Y' THEN
1045: FND_FILE.PUT_LINE( FND_FILE.LOG,'21. INSERT NOT DONE IN JL_ZZ_AP_SUP_AWT_CD '|| SQLCODE ||' -ERROR- '|| SQLERRM);
1046: END IF;
1047: END;
1048:
1049: END IF;

Line 1057: FROM JL_ZZ_AP_SUP_AWT_CD SAWTC,

1053: BEGIN
1054: -- TO GET THE CURRENT MONTH SUPP_AWT_CODE_ID FOR THE PRESENT TAX_ID
1055:
1056: SELECT SAWTC.SUPP_AWT_CODE_ID INTO l_SUPP_AWT_CODE_ID_CD
1057: FROM JL_ZZ_AP_SUP_AWT_CD SAWTC,
1058: PO_VENDORS PV, JL_ZZ_AP_SUPP_AWT_TYPES SAWT, PER_ALL_PEOPLE_F PAPF
1059: WHERE SAWT.VENDOR_ID = PV.VENDOR_ID
1060: AND NVL(pv.employee_id, - 99) = papf.person_id (+)
1061: AND NVL(papf.EFFECTIVE_START_DATE, SYSDATE) <= SYSDATE

Line 1108: /*(SELECT SUPP_AWT_CODE_ID FROM JL_ZZ_AP_SUP_AWT_CD SAWTC, JL_ZZ_AP_SUPP_AWT_TYPES SAWT

1104: WHERE INVOICE_ID = INV_REC.INVOICE_ID
1105: AND DISTRIBUTION_LINE_NUMBER = INV_REC.DISTRIBUTION_LINE_NUMBER
1106: AND INVOICE_DISTRIBUTION_ID = INV_REC.INVOICE_DISTRIBUTION_ID
1107: AND SUPP_AWT_CODE_ID = l_SUPP_AWT_CODE_ID_CD;
1108: /*(SELECT SUPP_AWT_CODE_ID FROM JL_ZZ_AP_SUP_AWT_CD SAWTC, JL_ZZ_AP_SUPP_AWT_TYPES SAWT
1109: WHERE SAWT.SUPP_AWT_TYPE_ID = SAWTC.SUPP_AWT_TYPE_ID
1110: -- AND SAWTC.EFFECTIVE_START_DATE = l_START_DATE
1111: AND SAWTC.TAX_ID IN (SELECT TAX_ID FROM AP_TAX_CODES WHERE name LIKE 'TURN_BSAS_GRP%')); */
1112:

Line 1195: (SELECT SUPP_AWT_CODE_ID FROM JL_ZZ_AP_SUP_AWT_CD SAWTC, JL_ZZ_AP_SUPP_AWT_TYPES SAWT

1191: WHERE INVOICE_ID = INV_REC.INVOICE_ID
1192: AND DISTRIBUTION_LINE_NUMBER = INV_REC.DISTRIBUTION_LINE_NUMBER
1193: AND INVOICE_DISTRIBUTION_ID = INV_REC.INVOICE_DISTRIBUTION_ID
1194: AND SUPP_AWT_CODE_ID IN
1195: (SELECT SUPP_AWT_CODE_ID FROM JL_ZZ_AP_SUP_AWT_CD SAWTC, JL_ZZ_AP_SUPP_AWT_TYPES SAWT
1196: WHERE SAWT.SUPP_AWT_TYPE_ID = SAWTC.SUPP_AWT_TYPE_ID
1197: AND SAWTC.primary_tax_flag = 'Y'
1198: AND SAWTC.TAX_ID IN (SELECT TAX_ID FROM AP_TAX_CODES WHERE name LIKE 'TURN_BSAS_GRP%')
1199: AND sawtc.effective_end_DATE IS NULL);*/

Line 1427: --- TO INSERT INTO JL_ZZ_AP_SUP_AWT_CD (3.3.2)

1423:
1424:
1425:
1426: BEGIN
1427: --- TO INSERT INTO JL_ZZ_AP_SUP_AWT_CD (3.3.2)
1428:
1429: SELECT SAWT.SUPP_AWT_TYPE_ID
1430: INTO l_SUPP_AWT_TYPE_ID_CD
1431: FROM PO_VENDORS PV,

Line 1457: SELECT jl_zz_ap_sup_awt_cd_s.nextval INTO l_SUPP_AWT_CODE_ID_SEQ FROM dual;

1453: FND_FILE.put_line( FND_FILE.LOG,'36. l_tax_id : '|| l_tax_id || 'l_TAXPAYER_ID : '|| l_TAXPAYER_ID);
1454: END IF;
1455:
1456:
1457: SELECT jl_zz_ap_sup_awt_cd_s.nextval INTO l_SUPP_AWT_CODE_ID_SEQ FROM dual;
1458:
1459: IF p_debug_log = 'Y' THEN
1460: FND_FILE.put_line( FND_FILE.LOG,'37. l_SUPP_AWT_CODE_ID_SEQ'|| l_SUPP_AWT_CODE_ID_SEQ);
1461: FND_FILE.put_line( FND_FILE.LOG,'37. l_SUPP_AWT_TYPE_ID_CD'|| l_SUPP_AWT_TYPE_ID_CD);

Line 1465: UPDATE JL_ZZ_AP_SUP_AWT_CD SAWTC SET SAWTC.EFFECTIVE_END_DATE = l_START_DATE - 1

1461: FND_FILE.put_line( FND_FILE.LOG,'37. l_SUPP_AWT_TYPE_ID_CD'|| l_SUPP_AWT_TYPE_ID_CD);
1462: END IF;
1463: -- code to UPDATE the EFFECTIVE_END_DATE for other primary_tax_flag = 'Y' and other l_tax_id
1464:
1465: UPDATE JL_ZZ_AP_SUP_AWT_CD SAWTC SET SAWTC.EFFECTIVE_END_DATE = l_START_DATE - 1
1466: WHERE SAWTC.primary_tax_flag = 'Y'
1467: AND SAWTC.SUPP_AWT_CODE_ID <> l_SUPP_AWT_CODE_ID_SEQ
1468: AND SAWTC.SUPP_AWT_TYPE_ID = l_SUPP_AWT_TYPE_ID_CD
1469: --AND SAWTC.TAX_ID <> l_tax_id -- other l_tax_id

Line 1473: FND_FILE.PUT_LINE( FND_FILE.LOG,'38 .UPDATED DATA IN JL_ZZ_AP_SUP_AWT_CD FOR '|| SQL%ROWCOUNT || 'RECORDS');

1469: --AND SAWTC.TAX_ID <> l_tax_id -- other l_tax_id
1470: AND SAWTC.EFFECTIVE_END_DATE IS NULL;
1471:
1472: IF p_debug_log = 'Y' THEN
1473: FND_FILE.PUT_LINE( FND_FILE.LOG,'38 .UPDATED DATA IN JL_ZZ_AP_SUP_AWT_CD FOR '|| SQL%ROWCOUNT || 'RECORDS');
1474: FND_FILE.PUT_LINE( FND_FILE.LOG,'38. EFFECTIVE_END_DATE (L_START_DATE-1) : '|| L_START_DATE);
1475: FND_FILE.PUT_LINE( FND_FILE.LOG,'38. L_TAX_ID : '|| L_TAX_ID || 'for L_TAXPAYER_ID : '|| L_TAXPAYER_ID);
1476:
1477: END IF;

Line 1480: INSERT INTO JL_ZZ_AP_SUP_AWT_CD

1476:
1477: END IF;
1478:
1479:
1480: INSERT INTO JL_ZZ_AP_SUP_AWT_CD
1481: (SUPP_AWT_CODE_ID,
1482: SUPP_AWT_TYPE_ID,
1483: TAX_ID,
1484: PRIMARY_TAX_FLAG,

Line 1509: FND_FILE.put_line( FND_FILE.LOG,'38 . Inserted data in JL_ZZ_AP_SUP_AWT_CD for '|| SQL%ROWCOUNT ||' Records and code id is :'|| l_SUPP_AWT_TYPE_ID_CD);

1505: NULL); --EFFECTIVE_END_DATE
1506:
1507:
1508: IF p_debug_log = 'Y' THEN
1509: FND_FILE.put_line( FND_FILE.LOG,'38 . Inserted data in JL_ZZ_AP_SUP_AWT_CD for '|| SQL%ROWCOUNT ||' Records and code id is :'|| l_SUPP_AWT_TYPE_ID_CD);
1510: END IF;
1511:
1512: COMMIT;
1513:

Line 1519: FND_FILE.put_line( FND_FILE.LOG,'39 . Failed to INSERT into JL_ZZ_AP_SUP_AWT_CD Insert not done '|| SQLCODE || 'ERROR' || SQLERRM);

1515: EXCEPTION
1516: WHEN OTHERS THEN
1517:
1518: IF p_debug_log = 'Y' THEN
1519: FND_FILE.put_line( FND_FILE.LOG,'39 . Failed to INSERT into JL_ZZ_AP_SUP_AWT_CD Insert not done '|| SQLCODE || 'ERROR' || SQLERRM);
1520: END IF;
1521:
1522:
1523: IF p_debug_log = 'Y' THEN

Line 1529: FROM JL_ZZ_AP_SUP_AWT_CD SAWTC

1525: END IF;
1526:
1527: BEGIN
1528: SELECT 'Y', SAWTC.SUPP_AWT_CODE_ID INTO taxtype_code_check, l_SUPP_AWT_CODE_ID_CD
1529: FROM JL_ZZ_AP_SUP_AWT_CD SAWTC
1530: WHERE SAWTC.SUPP_AWT_TYPE_ID = l_SUPP_AWT_TYPE_ID_CD
1531: AND SAWTC.TAX_ID = l_tax_id;
1532: --AND (SAWTC.EFFECTIVE_START_DATE = l_START_DATE OR SAWTC.EFFECTIVE_END_DATE = l_END_DATE);
1533:

Line 1542: UPDATE JL_ZZ_AP_SUP_AWT_CD SET EFFECTIVE_END_DATE = NULL

1538: END;
1539:
1540: IF taxtype_code_check = 'Y' THEN
1541:
1542: UPDATE JL_ZZ_AP_SUP_AWT_CD SET EFFECTIVE_END_DATE = NULL
1543: WHERE SUPP_AWT_CODE_ID = l_SUPP_AWT_CODE_ID_CD;
1544: FND_FILE.PUT_LINE( FND_FILE.LOG,'40 Records already present in JL_ZZ_AP_SUP_AWT_CD table TYPE ID'|| l_SUPP_AWT_TYPE_ID_CD);
1545: FND_FILE.PUT_LINE( FND_FILE.LOG,'40. l_tax_id'|| l_tax_id || 'L_EFFECTIVE_START_DATE' || L_START_DATE);
1546:

Line 1544: FND_FILE.PUT_LINE( FND_FILE.LOG,'40 Records already present in JL_ZZ_AP_SUP_AWT_CD table TYPE ID'|| l_SUPP_AWT_TYPE_ID_CD);

1540: IF taxtype_code_check = 'Y' THEN
1541:
1542: UPDATE JL_ZZ_AP_SUP_AWT_CD SET EFFECTIVE_END_DATE = NULL
1543: WHERE SUPP_AWT_CODE_ID = l_SUPP_AWT_CODE_ID_CD;
1544: FND_FILE.PUT_LINE( FND_FILE.LOG,'40 Records already present in JL_ZZ_AP_SUP_AWT_CD table TYPE ID'|| l_SUPP_AWT_TYPE_ID_CD);
1545: FND_FILE.PUT_LINE( FND_FILE.LOG,'40. l_tax_id'|| l_tax_id || 'L_EFFECTIVE_START_DATE' || L_START_DATE);
1546:
1547:
1548: NULL;

Line 1551: UPDATE JL_ZZ_AP_SUP_AWT_CD SET

1547:
1548: NULL;
1549: ELSE
1550: ----If insertion fails, then will do the UPDATE in awt_cd_all
1551: UPDATE JL_ZZ_AP_SUP_AWT_CD SET
1552: TAX_ID = l_tax_id,
1553: PRIMARY_TAX_FLAG = 'Y',
1554: EFFECTIVE_START_DATE = l_START_DATE,
1555: EFFECTIVE_END_DATE = NULL

Line 1562: FND_FILE.PUT_LINE( FND_FILE.LOG,'41 . UPDATED DATA IN JL_ZZ_AP_SUP_AWT_CD for '|| SQL%ROWCOUNT ||' Records and code id is :'|| l_SUPP_AWT_TYPE_ID_CD);

1558: END IF;
1559:
1560: IF p_debug_log = 'Y' THEN
1561: FND_FILE.put_line( FND_FILE.LOG,'41 . l_tax_id'|| l_tax_id || 'l_EFFECTIVE_START_DATE' || l_START_DATE);
1562: FND_FILE.PUT_LINE( FND_FILE.LOG,'41 . UPDATED DATA IN JL_ZZ_AP_SUP_AWT_CD for '|| SQL%ROWCOUNT ||' Records and code id is :'|| l_SUPP_AWT_TYPE_ID_CD);
1563: END IF;
1564:
1565: END;
1566:

Line 1570: FND_FILE.PUT_LINE( FND_FILE.LOG,'42 . UPDATED DATA IN JL_ZZ_AP_SUP_AWT_CD FOR PRIMARY_TAX_FLAG AS N AND EFFECTIVE_START_DATE FOR '|| SQL%ROWCOUNT ||' RECORDS');

1566:
1567:
1568: IF p_debug_log = 'Y' THEN
1569: FND_FILE.put_line( FND_FILE.LOG,'42 . l_tax_id'|| l_tax_id || 'l_SUPP_AWT_CODE_ID_CD' || l_SUPP_AWT_CODE_ID_CD || 'l_EFFECTIVE_START_DATE-1' || l_START_DATE);
1570: FND_FILE.PUT_LINE( FND_FILE.LOG,'42 . UPDATED DATA IN JL_ZZ_AP_SUP_AWT_CD FOR PRIMARY_TAX_FLAG AS N AND EFFECTIVE_START_DATE FOR '|| SQL%ROWCOUNT ||' RECORDS');
1571: END IF;
1572:
1573: -- Code to insert/UPDATE JL_ZZ_AP_INV_DIS_WH (TDD 3.3.2)
1574:

Line 1581: FROM JL_ZZ_AP_SUP_AWT_CD SAWTC,

1577: -- To get the current month Supp_Awt_Code_id for the present tax_id
1578:
1579: SELECT SAWTC.SUPP_AWT_CODE_ID
1580: INTO l_SUPP_AWT_CODE_ID_CD
1581: FROM JL_ZZ_AP_SUP_AWT_CD SAWTC,
1582: PO_VENDORS PV,
1583: JL_ZZ_AP_SUPP_AWT_TYPES SAWT,
1584: PER_ALL_PEOPLE_F PAPF
1585: WHERE SAWT.VENDOR_ID = PV.VENDOR_ID

Line 1633: /*(SELECT SUPP_AWT_CODE_ID FROM JL_ZZ_AP_SUP_AWT_CD SAWTC, JL_ZZ_AP_SUPP_AWT_TYPES SAWT

1629: WHERE INVOICE_ID = INV_REC.INVOICE_ID
1630: AND DISTRIBUTION_LINE_NUMBER = INV_REC.DISTRIBUTION_LINE_NUMBER
1631: AND INVOICE_DISTRIBUTION_ID = INV_REC.INVOICE_DISTRIBUTION_ID
1632: AND SUPP_AWT_CODE_ID = l_SUPP_AWT_CODE_ID_CD;
1633: /*(SELECT SUPP_AWT_CODE_ID FROM JL_ZZ_AP_SUP_AWT_CD SAWTC, JL_ZZ_AP_SUPP_AWT_TYPES SAWT
1634: WHERE SAWT.SUPP_AWT_TYPE_ID = SAWTC.SUPP_AWT_TYPE_ID
1635: AND SAWTC.TAX_ID IN (SELECT TAX_ID FROM AP_TAX_CODES WHERE name LIKE 'TURN_BSAS_GRP%')); */
1636:
1637: EXCEPTION

Line 1716: (SELECT SUPP_AWT_CODE_ID FROM JL_ZZ_AP_SUP_AWT_CD SAWTC, JL_ZZ_AP_SUPP_AWT_TYPES SAWT

1712: WHERE INVOICE_ID = INV_REC.INVOICE_ID
1713: AND DISTRIBUTION_LINE_NUMBER = INV_REC.DISTRIBUTION_LINE_NUMBER
1714: AND INVOICE_DISTRIBUTION_ID = INV_REC.INVOICE_DISTRIBUTION_ID
1715: AND SUPP_AWT_CODE_ID IN
1716: (SELECT SUPP_AWT_CODE_ID FROM JL_ZZ_AP_SUP_AWT_CD SAWTC, JL_ZZ_AP_SUPP_AWT_TYPES SAWT
1717: WHERE SAWT.SUPP_AWT_TYPE_ID = SAWTC.SUPP_AWT_TYPE_ID
1718: AND SAWTC.primary_tax_flag = 'Y'
1719: AND SAWTC.TAX_ID IN (SELECT TAX_ID FROM AP_TAX_CODES WHERE name LIKE 'TURN_BSAS_GRP%')
1720: AND sawtc.effective_end_DATE IS NULL);*/

Line 1861: l_SUPP_AWT_CODE_ID_CD JL_ZZ_AP_SUP_AWT_CD_ALL.SUPP_AWT_CODE_ID%TYPE;

1857: l_TAX_ID_DEF_ATC AP_TAX_CODES_ALL.TAX_ID%TYPE;
1858: l_WHT_RATE_DEF_ATR AP_AWT_TAX_RATES_ALL.TAX_RATE%TYPE;
1859: ALL_REC JL_AR_TURN_UPL%ROWTYPE;
1860:
1861: l_SUPP_AWT_CODE_ID_CD JL_ZZ_AP_SUP_AWT_CD_ALL.SUPP_AWT_CODE_ID%TYPE;
1862: l_SUPP_AWT_TYPE_ID_CD JL_ZZ_AP_SUP_AWT_CD_ALL.SUPP_AWT_TYPE_ID%TYPE;
1863: l_tax_id ap_tax_codes.tax_id%TYPE;
1864: l_SUPP_AWT_TYPE_ID_TYPES JL_ZZ_AP_SUPP_AWT_TYPES.SUPP_AWT_TYPE_ID%TYPE;
1865: l_VENDOR_ID PO_VENDORS.VENDOR_ID%TYPE;

Line 1862: l_SUPP_AWT_TYPE_ID_CD JL_ZZ_AP_SUP_AWT_CD_ALL.SUPP_AWT_TYPE_ID%TYPE;

1858: l_WHT_RATE_DEF_ATR AP_AWT_TAX_RATES_ALL.TAX_RATE%TYPE;
1859: ALL_REC JL_AR_TURN_UPL%ROWTYPE;
1860:
1861: l_SUPP_AWT_CODE_ID_CD JL_ZZ_AP_SUP_AWT_CD_ALL.SUPP_AWT_CODE_ID%TYPE;
1862: l_SUPP_AWT_TYPE_ID_CD JL_ZZ_AP_SUP_AWT_CD_ALL.SUPP_AWT_TYPE_ID%TYPE;
1863: l_tax_id ap_tax_codes.tax_id%TYPE;
1864: l_SUPP_AWT_TYPE_ID_TYPES JL_ZZ_AP_SUPP_AWT_TYPES.SUPP_AWT_TYPE_ID%TYPE;
1865: l_VENDOR_ID PO_VENDORS.VENDOR_ID%TYPE;
1866: l_INV_DISTRIB_AWT_ID_INV JL_ZZ_AP_INV_DIS_WH_ALL.INV_DISTRIB_AWT_ID%TYPE;

Line 1871: l_SUPP_AWT_CODE_ID_SEQ JL_ZZ_AP_SUP_AWT_CD_ALL.SUPP_AWT_CODE_ID%TYPE;

1867: l_INVOICE_ID_INA AP_INVOICES_ALL.INVOICE_ID%TYPE;
1868: l_DISTRIBUTION_LINE_NUMBER_IND AP_INVOICE_DISTRIBUTIONS_ALL.DISTRIBUTION_LINE_NUMBER%TYPE;
1869: l_INVOICE_DISTRIBUTION_ID_IND AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE;
1870: l_INV_DISTRIB_AWT_ID_DIS JL_ZZ_AP_INV_DIS_WH_ALL.INV_DISTRIB_AWT_ID%TYPE;
1871: l_SUPP_AWT_CODE_ID_SEQ JL_ZZ_AP_SUP_AWT_CD_ALL.SUPP_AWT_CODE_ID%TYPE;
1872:
1873:
1874: --WHO COLUMNS:
1875: -----------------

Line 2104: --- code to UPDATE awt_cd jl_zz_ap_sup_awt_cd_all (9.4 B)

2100:
2101:
2102: --- To process only the last month data and to avoid the current month taxpayer id if any
2103: IF l_START_DATE_SEC_MAX < l_START_DATE_CURR_MAX THEN
2104: --- code to UPDATE awt_cd jl_zz_ap_sup_awt_cd_all (9.4 B)
2105: BEGIN
2106:
2107: SELECT SAWTC.SUPP_AWT_TYPE_ID,
2108: SAWTC.SUPP_AWT_CODE_ID

Line 2111: FROM JL_ZZ_AP_SUP_AWT_CD SAWTC,

2107: SELECT SAWTC.SUPP_AWT_TYPE_ID,
2108: SAWTC.SUPP_AWT_CODE_ID
2109: INTO l_SUPP_AWT_TYPE_ID_CD,
2110: l_SUPP_AWT_CODE_ID_CD
2111: FROM JL_ZZ_AP_SUP_AWT_CD SAWTC,
2112: PO_VENDORS PV,
2113: JL_ZZ_AP_SUPP_AWT_TYPES SAWT,
2114: PER_ALL_PEOPLE_F PAPF
2115: WHERE SAWT.VENDOR_ID = PV.VENDOR_ID

Line 2138: --code to UPDATE/insert JL_ZZ_AP_SUP_AWT_CD

2134: ) ||
2135: substr(pv.global_attribute12,1,1) = TO_CHAR(l_TAXPAYER_ID);
2136:
2137:
2138: --code to UPDATE/insert JL_ZZ_AP_SUP_AWT_CD
2139:
2140: UPDATE JL_ZZ_AP_SUP_AWT_CD SET EFFECTIVE_END_DATE = l_END_DATE_SEC_MAX
2141: WHERE SUPP_AWT_CODE_ID = l_SUPP_AWT_CODE_ID_CD;
2142:

Line 2140: UPDATE JL_ZZ_AP_SUP_AWT_CD SET EFFECTIVE_END_DATE = l_END_DATE_SEC_MAX

2136:
2137:
2138: --code to UPDATE/insert JL_ZZ_AP_SUP_AWT_CD
2139:
2140: UPDATE JL_ZZ_AP_SUP_AWT_CD SET EFFECTIVE_END_DATE = l_END_DATE_SEC_MAX
2141: WHERE SUPP_AWT_CODE_ID = l_SUPP_AWT_CODE_ID_CD;
2142:
2143: IF p_debug_log = 'Y' THEN
2144: FND_FILE.PUT_LINE( FND_FILE.LOG,'52 .UPDATED DATA IN JL_ZZ_AP_SUP_AWT_CD FOR '|| SQL%ROWCOUNT || 'RECORDS');

Line 2144: FND_FILE.PUT_LINE( FND_FILE.LOG,'52 .UPDATED DATA IN JL_ZZ_AP_SUP_AWT_CD FOR '|| SQL%ROWCOUNT || 'RECORDS');

2140: UPDATE JL_ZZ_AP_SUP_AWT_CD SET EFFECTIVE_END_DATE = l_END_DATE_SEC_MAX
2141: WHERE SUPP_AWT_CODE_ID = l_SUPP_AWT_CODE_ID_CD;
2142:
2143: IF p_debug_log = 'Y' THEN
2144: FND_FILE.PUT_LINE( FND_FILE.LOG,'52 .UPDATED DATA IN JL_ZZ_AP_SUP_AWT_CD FOR '|| SQL%ROWCOUNT || 'RECORDS');
2145: FND_FILE.PUT_LINE( FND_FILE.LOG,'52. EFFECTIVE_END_DATE (l_END_DATE_SEC_MAX-1) :'||l_END_DATE_SEC_MAX||' FOR CODE_ID :'||l_SUPP_AWT_CODE_ID_CD);
2146: FND_FILE.PUT_LINE( FND_FILE.LOG,'52 l_TAX_ID_DEF_ATC : '|| l_TAX_ID_DEF_ATC || ' l_TAXPAYER_ID : '|| l_TAXPAYER_ID);
2147: END IF;
2148:

Line 2150: SELECT jl_zz_ap_sup_awt_cd_s.nextval INTO l_SUPP_AWT_CODE_ID_SEQ FROM dual;

2146: FND_FILE.PUT_LINE( FND_FILE.LOG,'52 l_TAX_ID_DEF_ATC : '|| l_TAX_ID_DEF_ATC || ' l_TAXPAYER_ID : '|| l_TAXPAYER_ID);
2147: END IF;
2148:
2149:
2150: SELECT jl_zz_ap_sup_awt_cd_s.nextval INTO l_SUPP_AWT_CODE_ID_SEQ FROM dual;
2151:
2152:
2153: INSERT INTO JL_ZZ_AP_SUP_AWT_CD
2154: (SUPP_AWT_CODE_ID,

Line 2153: INSERT INTO JL_ZZ_AP_SUP_AWT_CD

2149:
2150: SELECT jl_zz_ap_sup_awt_cd_s.nextval INTO l_SUPP_AWT_CODE_ID_SEQ FROM dual;
2151:
2152:
2153: INSERT INTO JL_ZZ_AP_SUP_AWT_CD
2154: (SUPP_AWT_CODE_ID,
2155: SUPP_AWT_TYPE_ID,
2156: TAX_ID,
2157: PRIMARY_TAX_FLAG,

Line 2182: FND_FILE.PUT_LINE( FND_FILE.LOG,'53 .INSERTED DATA IN JL_ZZ_AP_SUP_AWT_CD FOR SUPP_AWT_CODE_ID '|| L_SUPP_AWT_CODE_ID_SEQ);

2178: NULL); --EFFECTIVE_END_DATE
2179:
2180:
2181: IF p_debug_log = 'Y' THEN
2182: FND_FILE.PUT_LINE( FND_FILE.LOG,'53 .INSERTED DATA IN JL_ZZ_AP_SUP_AWT_CD FOR SUPP_AWT_CODE_ID '|| L_SUPP_AWT_CODE_ID_SEQ);
2183: END IF;
2184:
2185: EXCEPTION
2186: WHEN OTHERS THEN

Line 2189: FND_FILE.PUT_LINE( FND_FILE.LOG,'53. INSERTED NOT DONE FOR JL_ZZ_AP_SUP_AWT_CD '|| SQLCODE ||' -ERROR- '|| SQLERRM);

2185: EXCEPTION
2186: WHEN OTHERS THEN
2187:
2188: IF p_debug_log = 'Y' THEN
2189: FND_FILE.PUT_LINE( FND_FILE.LOG,'53. INSERTED NOT DONE FOR JL_ZZ_AP_SUP_AWT_CD '|| SQLCODE ||' -ERROR- '|| SQLERRM);
2190: END IF;
2191: --If insertion fails, then will check already present in JL_ZZ_AP_SUP_AWT_CD
2192:
2193: BEGIN

Line 2191: --If insertion fails, then will check already present in JL_ZZ_AP_SUP_AWT_CD

2187:
2188: IF p_debug_log = 'Y' THEN
2189: FND_FILE.PUT_LINE( FND_FILE.LOG,'53. INSERTED NOT DONE FOR JL_ZZ_AP_SUP_AWT_CD '|| SQLCODE ||' -ERROR- '|| SQLERRM);
2190: END IF;
2191: --If insertion fails, then will check already present in JL_ZZ_AP_SUP_AWT_CD
2192:
2193: BEGIN
2194: SELECT 'Y', SAWTC.SUPP_AWT_CODE_ID INTO def_taxtype_code_check, l_SUPP_AWT_CODE_ID_CD
2195: FROM JL_ZZ_AP_SUP_AWT_CD SAWTC

Line 2195: FROM JL_ZZ_AP_SUP_AWT_CD SAWTC

2191: --If insertion fails, then will check already present in JL_ZZ_AP_SUP_AWT_CD
2192:
2193: BEGIN
2194: SELECT 'Y', SAWTC.SUPP_AWT_CODE_ID INTO def_taxtype_code_check, l_SUPP_AWT_CODE_ID_CD
2195: FROM JL_ZZ_AP_SUP_AWT_CD SAWTC
2196: WHERE SAWTC.SUPP_AWT_TYPE_ID = l_SUPP_AWT_TYPE_ID_CD
2197: AND SAWTC.TAX_ID = l_TAX_ID_DEF_ATC;
2198:
2199: EXCEPTION

Line 2205: UPDATE JL_ZZ_AP_SUP_AWT_CD SET EFFECTIVE_END_DATE = NULL

2201: def_taxtype_code_check := 'N';
2202: END;
2203:
2204: IF def_taxtype_code_check = 'Y' THEN
2205: UPDATE JL_ZZ_AP_SUP_AWT_CD SET EFFECTIVE_END_DATE = NULL
2206: WHERE SUPP_AWT_CODE_ID = l_SUPP_AWT_CODE_ID_CD;
2207:
2208: FND_FILE.PUT_LINE( FND_FILE.LOG,'53 Records already present in JL_ZZ_AP_SUP_AWT_CD table TYPE ID'|| l_SUPP_AWT_TYPE_ID_CD);
2209: FND_FILE.PUT_LINE( FND_FILE.LOG,'53. l_TAX_ID_DEF_ATC'|| l_TAX_ID_DEF_ATC || 'L_EFFECTIVE_START_DATE' || L_START_DATE);

Line 2208: FND_FILE.PUT_LINE( FND_FILE.LOG,'53 Records already present in JL_ZZ_AP_SUP_AWT_CD table TYPE ID'|| l_SUPP_AWT_TYPE_ID_CD);

2204: IF def_taxtype_code_check = 'Y' THEN
2205: UPDATE JL_ZZ_AP_SUP_AWT_CD SET EFFECTIVE_END_DATE = NULL
2206: WHERE SUPP_AWT_CODE_ID = l_SUPP_AWT_CODE_ID_CD;
2207:
2208: FND_FILE.PUT_LINE( FND_FILE.LOG,'53 Records already present in JL_ZZ_AP_SUP_AWT_CD table TYPE ID'|| l_SUPP_AWT_TYPE_ID_CD);
2209: FND_FILE.PUT_LINE( FND_FILE.LOG,'53. l_TAX_ID_DEF_ATC'|| l_TAX_ID_DEF_ATC || 'L_EFFECTIVE_START_DATE' || L_START_DATE);
2210:
2211: ELSE
2212: ----If insertion fails, then will do the UPDATE in awt_cd_all

Line 2213: UPDATE JL_ZZ_AP_SUP_AWT_CD SET

2209: FND_FILE.PUT_LINE( FND_FILE.LOG,'53. l_TAX_ID_DEF_ATC'|| l_TAX_ID_DEF_ATC || 'L_EFFECTIVE_START_DATE' || L_START_DATE);
2210:
2211: ELSE
2212: ----If insertion fails, then will do the UPDATE in awt_cd_all
2213: UPDATE JL_ZZ_AP_SUP_AWT_CD SET
2214: TAX_ID = l_TAX_ID_DEF_ATC, --- default tax code id
2215: PRIMARY_TAX_FLAG = 'Y',
2216: EFFECTIVE_START_DATE = l_START_DATE_CURR_MAX,
2217: EFFECTIVE_END_DATE = NULL

Line 2221: FND_FILE.PUT_LINE( FND_FILE.LOG,'54 .UPDATED DATA IN JL_ZZ_AP_SUP_AWT_CD FOR SUPP_AWT_CODE_ID WITH OLD TAX_ID for CODE ID'|| l_SUPP_AWT_CODE_ID_CD);

2217: EFFECTIVE_END_DATE = NULL
2218: WHERE SUPP_AWT_CODE_ID = l_SUPP_AWT_CODE_ID_CD;
2219:
2220: IF p_debug_log = 'Y' THEN
2221: FND_FILE.PUT_LINE( FND_FILE.LOG,'54 .UPDATED DATA IN JL_ZZ_AP_SUP_AWT_CD FOR SUPP_AWT_CODE_ID WITH OLD TAX_ID for CODE ID'|| l_SUPP_AWT_CODE_ID_CD);
2222: END IF;
2223: END IF;
2224:
2225: END;

Line 2235: FROM JL_ZZ_AP_SUP_AWT_CD SAWTC,

2231: -- To get the current month Supp_Awt_Code_id for the present tax_id
2232:
2233: SELECT SAWTC.SUPP_AWT_CODE_ID
2234: INTO l_SUPP_AWT_CODE_ID_CD
2235: FROM JL_ZZ_AP_SUP_AWT_CD SAWTC,
2236: PO_VENDORS PV,
2237: JL_ZZ_AP_SUPP_AWT_TYPES SAWT,
2238: PER_ALL_PEOPLE_F PAPF
2239: WHERE SAWT.VENDOR_ID = PV.VENDOR_ID

Line 2287: /*(SELECT SUPP_AWT_CODE_ID FROM JL_ZZ_AP_SUP_AWT_CD SAWTC, JL_ZZ_AP_SUPP_AWT_TYPES SAWT

2283: WHERE INVOICE_ID = INV_REC.INVOICE_ID
2284: AND DISTRIBUTION_LINE_NUMBER = INV_REC.DISTRIBUTION_LINE_NUMBER
2285: AND INVOICE_DISTRIBUTION_ID = INV_REC.INVOICE_DISTRIBUTION_ID
2286: AND SUPP_AWT_CODE_ID = l_SUPP_AWT_CODE_ID_CD;
2287: /*(SELECT SUPP_AWT_CODE_ID FROM JL_ZZ_AP_SUP_AWT_CD SAWTC, JL_ZZ_AP_SUPP_AWT_TYPES SAWT
2288: WHERE SAWT.SUPP_AWT_TYPE_ID = SAWTC.SUPP_AWT_TYPE_ID
2289: AND SAWTC.TAX_ID IN (SELECT TAX_ID FROM AP_TAX_CODES WHERE name LIKE 'TURN_BSAS_GRP%')); */
2290:
2291: EXCEPTION

Line 2370: (SELECT SUPP_AWT_CODE_ID FROM JL_ZZ_AP_SUP_AWT_CD SAWTC, JL_ZZ_AP_SUPP_AWT_TYPES SAWT

2366: WHERE INVOICE_ID = INV_REC.INVOICE_ID
2367: AND DISTRIBUTION_LINE_NUMBER = INV_REC.DISTRIBUTION_LINE_NUMBER
2368: AND INVOICE_DISTRIBUTION_ID = INV_REC.INVOICE_DISTRIBUTION_ID
2369: AND SUPP_AWT_CODE_ID IN
2370: (SELECT SUPP_AWT_CODE_ID FROM JL_ZZ_AP_SUP_AWT_CD SAWTC, JL_ZZ_AP_SUPP_AWT_TYPES SAWT
2371: WHERE SAWT.SUPP_AWT_TYPE_ID = SAWTC.SUPP_AWT_TYPE_ID
2372: AND SAWTC.primary_tax_flag = 'Y'
2373: AND SAWTC.TAX_ID IN (SELECT TAX_ID FROM AP_TAX_CODES WHERE name LIKE 'TURN_BSAS_GRP%')
2374: AND sawtc.effective_end_DATE IS NULL);*/