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_AR_TURN_UPL

Line 54: SELECT 'Y' INTO final_insert_check FROM JL_AR_TURN_UPL

50:
51: BEGIN
52:
53: BEGIN
54: SELECT 'Y' INTO final_insert_check FROM JL_AR_TURN_UPL
55: WHERE TAXPAYER_ID = l_TAXPAYER_ID
56: AND START_DATE = l_START_DATE
57: AND END_DATE = l_END_DATE;
58:

Line 70: INSERT INTO JL_AR_TURN_UPL (

66: END IF;
67:
68: IF final_insert_check = 'N' THEN
69:
70: INSERT INTO JL_AR_TURN_UPL (
71: ORG_ID,
72: PUBLISH_DATE,
73: START_DATE,
74: END_DATE,

Line 110: FND_FILE.put_line( FND_FILE.LOG, 'In Insert_Row, inserted record into JL_AR_TURN_UPL');

106: l_creation_DATE, --CREATION_DATE
107: l_created_by); --CREATED_BY
108:
109: IF p_debug_log = 'Y' THEN
110: FND_FILE.put_line( FND_FILE.LOG, 'In Insert_Row, inserted record into JL_AR_TURN_UPL');
111: END IF;
112:
113: ELSE
114:

Line 117: UPDATE JL_AR_TURN_UPL SET WHT_RATE = l_WHT_RATE, WHT_GROUP_NUM = l_WHT_GROUP_NUM, WHT_DEFAULT_FLAG = l_WHT_DEFAULT_FLAG

113: ELSE
114:
115: IF l_CALLING_RESP = 'AP' THEN
116:
117: UPDATE JL_AR_TURN_UPL SET WHT_RATE = l_WHT_RATE, WHT_GROUP_NUM = l_WHT_GROUP_NUM, WHT_DEFAULT_FLAG = l_WHT_DEFAULT_FLAG
118: WHERE TAXPAYER_ID = l_TAXPAYER_ID
119: AND START_DATE = l_START_DATE
120: AND END_DATE = l_END_DATE;
121:

Line 123: FND_FILE.put_line( FND_FILE.LOG, 'UPDATED record in JL_AR_TURN_UPL for Payables');

119: AND START_DATE = l_START_DATE
120: AND END_DATE = l_END_DATE;
121:
122: IF p_debug_log = 'Y' THEN
123: FND_FILE.put_line( FND_FILE.LOG, 'UPDATED record in JL_AR_TURN_UPL for Payables');
124: END IF;
125:
126:
127: ELSIF l_CALLING_RESP = 'AR' THEN

Line 129: UPDATE JL_AR_TURN_UPL SET PERCEPTION_RATE = l_PERCEPTION_RATE, PERCEPTION_GROUP_NUM = l_PERCEPTION_GROUP_NUM

125:
126:
127: ELSIF l_CALLING_RESP = 'AR' THEN
128:
129: UPDATE JL_AR_TURN_UPL SET PERCEPTION_RATE = l_PERCEPTION_RATE, PERCEPTION_GROUP_NUM = l_PERCEPTION_GROUP_NUM
130: WHERE TAXPAYER_ID = l_TAXPAYER_ID
131: AND START_DATE = l_START_DATE
132: AND END_DATE = l_END_DATE;
133:

Line 135: FND_FILE.put_line( FND_FILE.LOG, 'UPDATED record in JL_AR_TURN_UPL for Receivables');

131: AND START_DATE = l_START_DATE
132: AND END_DATE = l_END_DATE;
133:
134: IF p_debug_log = 'Y' THEN
135: FND_FILE.put_line( FND_FILE.LOG, 'UPDATED record in JL_AR_TURN_UPL for Receivables');
136: END IF;
137:
138: END IF;
139:

Line 198: FUNCTION BASIC_VALIDATION(P_TEMPREC IN JL_AR_TURN_UPL_T%ROWTYPE)

194:
195:
196:
197: -- Bug 14563117 Start
198: FUNCTION BASIC_VALIDATION(P_TEMPREC IN JL_AR_TURN_UPL_T%ROWTYPE)
199: -- Bug 14563117 Start
200: RETURN BOOLEAN
201: IS
202:

Line 219: --CURSOR C2 IS SELECT * FROM JL_AR_TURN_UPL_T WHERE TAXPAYER_ID = l_TAXPAYERID;

215: l_PUBLISHDATE_ALL DATE;
216: valid_flag VARCHAR2(1) := 'Y';
217:
218: -- Bug 14563117 Start
219: --CURSOR C2 IS SELECT * FROM JL_AR_TURN_UPL_T WHERE TAXPAYER_ID = l_TAXPAYERID;
220:
221: --V_TEMPREC C2%ROWTYPE;
222:
223: -- Bug 14563117 End

Line 251: SELECT MAX(PUBLISH_DATE) INTO l_PUBLISHDATE_ALL FROM JL_AR_TURN_UPL

247:
248:
249: BEGIN
250:
251: SELECT MAX(PUBLISH_DATE) INTO l_PUBLISHDATE_ALL FROM JL_AR_TURN_UPL
252: WHERE TAXPAYER_ID = l_TAXPAYER_ID;
253:
254: IF (l_PUBLISH_DATE < l_PUBLISHDATE_ALL) AND (l_START_DATE > l_END_DATE) THEN
255: valid_flag := 'N';

Line 264: FND_FILE.PUT_LINE( FND_FILE.LOG,'NO PREVIOUS RECORD IN JL_AR_TURN_UPL');

260:
261: EXCEPTION
262: WHEN OTHERS THEN
263: IF p_debug_log = 'Y' THEN
264: FND_FILE.PUT_LINE( FND_FILE.LOG,'NO PREVIOUS RECORD IN JL_AR_TURN_UPL');
265: END IF;
266: END;
267:
268: IF VALID_NUMBER(P_TEMPREC.TAXPAYER_ID) THEN

Line 559: SELECT * FROM JL_AR_TURN_UPL_T;

555:
556:
557:
558: CURSOR C3 IS
559: SELECT * FROM JL_AR_TURN_UPL_T;
560:
561: --WHERE start_DATE >= P_START_DATE and end_DATE <= P_END_DATE;
562:
563: V_TEMPREC C3%ROWTYPE;

Line 599: (SELECT DISTINCT PUBLISH_DATE, START_DATE, END_DATE FROM JL_AR_TURN_UPL_T) TMP;

595:
596: -- To ensure the single start_DATE/end_DATE in tmp table (9.4.A.2)
597:
598: SELECT COUNT(*) INTO duplicate_check_count FROM
599: (SELECT DISTINCT PUBLISH_DATE, START_DATE, END_DATE FROM JL_AR_TURN_UPL_T) TMP;
600:
601: IF duplicate_check_count > 1 THEN
602: duplicate_check_flag := 'Y';
603: IF p_debug_log = 'Y' THEN

Line 692: SELECT MAX(START_DATE) INTO l_START_DATE_SEC_MAX FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID AND

688: END IF;
689:
690: BEGIN
691:
692: SELECT MAX(START_DATE) INTO l_START_DATE_SEC_MAX FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID AND
693: START_DATE NOT IN (SELECT MAX(START_DATE) FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID);
694:
695: SELECT MAX(END_DATE) INTO l_END_DATE_SEC_MAX FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID AND
696: END_DATE NOT IN (SELECT MAX(END_DATE) FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID);

Line 693: START_DATE NOT IN (SELECT MAX(START_DATE) FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID);

689:
690: BEGIN
691:
692: SELECT MAX(START_DATE) INTO l_START_DATE_SEC_MAX FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID AND
693: START_DATE NOT IN (SELECT MAX(START_DATE) FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID);
694:
695: SELECT MAX(END_DATE) INTO l_END_DATE_SEC_MAX FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID AND
696: END_DATE NOT IN (SELECT MAX(END_DATE) FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID);
697:

Line 695: SELECT MAX(END_DATE) INTO l_END_DATE_SEC_MAX FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID AND

691:
692: SELECT MAX(START_DATE) INTO l_START_DATE_SEC_MAX FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID AND
693: START_DATE NOT IN (SELECT MAX(START_DATE) FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID);
694:
695: SELECT MAX(END_DATE) INTO l_END_DATE_SEC_MAX FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID AND
696: END_DATE NOT IN (SELECT MAX(END_DATE) FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID);
697:
698:
699: EXCEPTION

Line 696: END_DATE NOT IN (SELECT MAX(END_DATE) FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID);

692: SELECT MAX(START_DATE) INTO l_START_DATE_SEC_MAX FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID AND
693: START_DATE NOT IN (SELECT MAX(START_DATE) FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID);
694:
695: SELECT MAX(END_DATE) INTO l_END_DATE_SEC_MAX FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID AND
696: END_DATE NOT IN (SELECT MAX(END_DATE) FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID);
697:
698:
699: EXCEPTION
700:

Line 703: FND_FILE.PUT_LINE( FND_FILE.LOG,'4 .NO PREVIOUS RECORD AVAILABLE IN JL_AR_TURN_UPL TABLE');

699: EXCEPTION
700:
701: WHEN OTHERS THEN
702: IF p_debug_log = 'Y' THEN
703: FND_FILE.PUT_LINE( FND_FILE.LOG,'4 .NO PREVIOUS RECORD AVAILABLE IN JL_AR_TURN_UPL TABLE');
704: END IF;
705: END;
706:
707: l_START_DATE_SEC_MAX := NVL(l_START_DATE_SEC_MAX, l_START_DATE);

Line 719: FROM JL_AR_TURN_UPL_T

715: SELECT 'TURN_BSAS_GRP' || lpad(WHT_GROUP_NUM, 2, '0'),
716: WHT_RATE
717: INTO l_WHT_GROUP_NUM_ALL,
718: l_WHT_RATE_ALL
719: FROM JL_AR_TURN_UPL_T
720: WHERE TAXPAYER_ID = l_TAXPAYER_ID
721: GROUP BY WHT_RATE, WHT_GROUP_NUM;
722:
723: SELECT 'Y'

Line 767: -- To compare JL_AR_TURN_UPL_T Upload Table records with JL_AR_TURN_UPL (9.4.A.3)

763:
764: END IF;
765:
766: /*
767: -- To compare JL_AR_TURN_UPL_T Upload Table records with JL_AR_TURN_UPL (9.4.A.3)
768:
769: BEGIN
770:
771: same_prev_rec_flag := 'N'; --Intialising the value of same_prev_rec_flag everytime to check whether the record available already

Line 773: SELECT DISTINCT 'Y' INTO same_prev_rec_flag FROM JL_AR_TURN_UPL WHERE

769: BEGIN
770:
771: same_prev_rec_flag := 'N'; --Intialising the value of same_prev_rec_flag everytime to check whether the record available already
772:
773: SELECT DISTINCT 'Y' INTO same_prev_rec_flag FROM JL_AR_TURN_UPL WHERE
774: PUBLISH_DATE = l_PUBLISH_DATE
775: AND START_DATE = l_START_DATE
776: AND END_DATE = l_END_DATE
777: AND TAXPAYER_ID = l_TAXPAYER_ID

Line 794: FND_FILE.PUT_LINE( FND_FILE.LOG,'7A .NO CORRESPONDING DATA IN JL_AR_TURN_UPL');

790:
791: EXCEPTION
792: WHEN NO_DATA_FOUND THEN
793: IF p_debug_log = 'Y' THEN
794: FND_FILE.PUT_LINE( FND_FILE.LOG,'7A .NO CORRESPONDING DATA IN JL_AR_TURN_UPL');
795: END IF;
796: WHEN OTHERS THEN
797: IF p_debug_log = 'Y' THEN
798: FND_FILE.PUT_LINE( FND_FILE.LOG,'8 .FAILED WHILE CHECKING THE CORRESPONDING DATA IN JL_AR_TURN_UPL');

Line 798: FND_FILE.PUT_LINE( FND_FILE.LOG,'8 .FAILED WHILE CHECKING THE CORRESPONDING DATA IN JL_AR_TURN_UPL');

794: FND_FILE.PUT_LINE( FND_FILE.LOG,'7A .NO CORRESPONDING DATA IN JL_AR_TURN_UPL');
795: END IF;
796: WHEN OTHERS THEN
797: IF p_debug_log = 'Y' THEN
798: FND_FILE.PUT_LINE( FND_FILE.LOG,'8 .FAILED WHILE CHECKING THE CORRESPONDING DATA IN JL_AR_TURN_UPL');
799: END IF;
800: END;
801:
802: IF p_debug_log = 'Y' THEN

Line 832: --delete JL_AR_TURN_UPL_T WHERE TAXPAYER_ID = l_TAXPAYER_ID;

828: l_WHT_DEFAULT_FLAG,
829: 'AP');
830:
831:
832: --delete JL_AR_TURN_UPL_T WHERE TAXPAYER_ID = l_TAXPAYER_ID;
833:
834: IF p_debug_log = 'Y' THEN
835: FND_FILE.PUT_LINE( FND_FILE.LOG,'10 .INSERTED DATA IN JL_AR_TURN_UPL SAME_REC_FLAG IS Y AND DELETED FROM TMP TABLE');
836: END IF;

Line 835: FND_FILE.PUT_LINE( FND_FILE.LOG,'10 .INSERTED DATA IN JL_AR_TURN_UPL SAME_REC_FLAG IS Y AND DELETED FROM TMP TABLE');

831:
832: --delete JL_AR_TURN_UPL_T WHERE TAXPAYER_ID = l_TAXPAYER_ID;
833:
834: IF p_debug_log = 'Y' THEN
835: FND_FILE.PUT_LINE( FND_FILE.LOG,'10 .INSERTED DATA IN JL_AR_TURN_UPL SAME_REC_FLAG IS Y AND DELETED FROM TMP TABLE');
836: END IF;
837:
838: GOTO L3;
839: --fetching next record

Line 847: SELECT DISTINCT 'Y' INTO same_taxpayerid_flag FROM JL_AR_TURN_UPL WHERE

843: --To check whether TMP taxpayer id present already in previous months in ALL table (3.2)
844:
845: BEGIN
846:
847: SELECT DISTINCT 'Y' INTO same_taxpayerid_flag FROM JL_AR_TURN_UPL WHERE
848: PUBLISH_DATE <> l_PUBLISH_DATE
849: AND START_DATE <> l_START_DATE
850: AND END_DATE <> l_END_DATE
851: AND TAXPAYER_ID = l_TAXPAYER_ID;

Line 856: FND_FILE.PUT_LINE( FND_FILE.LOG,'12 .NO CORRESPONDING TAXPAYER_ID IN JL_AR_TURN_UPL');

852:
853: EXCEPTION
854: WHEN NO_DATA_FOUND THEN
855: IF p_debug_log = 'Y' THEN
856: FND_FILE.PUT_LINE( FND_FILE.LOG,'12 .NO CORRESPONDING TAXPAYER_ID IN JL_AR_TURN_UPL');
857: END IF;
858:
859: WHEN OTHERS THEN
860: IF p_debug_log = 'Y' THEN

Line 861: FND_FILE.PUT_LINE( FND_FILE.LOG,'13 .FAILED WHILE CHECKING THE CORRESPONDING TAXPAYER_ID IN JL_AR_TURN_UPL');

857: END IF;
858:
859: WHEN OTHERS THEN
860: IF p_debug_log = 'Y' THEN
861: FND_FILE.PUT_LINE( FND_FILE.LOG,'13 .FAILED WHILE CHECKING THE CORRESPONDING TAXPAYER_ID IN JL_AR_TURN_UPL');
862: END IF;
863:
864: END;
865:

Line 874: SELECT 'Y' INTO wht_check_flag FROM JL_AR_TURN_UPL WHERE

870: wht_check_flag := 'N';
871:
872: BEGIN
873:
874: SELECT 'Y' INTO wht_check_flag FROM JL_AR_TURN_UPL WHERE
875: TAXPAYER_ID = l_TAXPAYER_ID
876: AND WHT_GROUP_NUM = l_WHT_GROUP_NUM
877: AND WHT_RATE = l_WHT_RATE
878: AND START_DATE = l_START_DATE_SEC_MAX

Line 909: -- delete JL_AR_TURN_UPL_T WHERE TAXPAYER_ID = l_TAXPAYER_ID;

905: l_WHT_GROUP_NUM,
906: l_WHT_DEFAULT_FLAG,
907: 'AP');
908:
909: -- delete JL_AR_TURN_UPL_T WHERE TAXPAYER_ID = l_TAXPAYER_ID;
910:
911: IF p_debug_log = 'Y' THEN
912: FND_FILE.PUT_LINE( FND_FILE.LOG,'16 .INSERTED DATA IN TABLE JL_AR_TURN_UPL WHEN WHT_CHECK_FLAG IS Y ');
913: END IF;

Line 912: FND_FILE.PUT_LINE( FND_FILE.LOG,'16 .INSERTED DATA IN TABLE JL_AR_TURN_UPL WHEN WHT_CHECK_FLAG IS Y ');

908:
909: -- delete JL_AR_TURN_UPL_T WHERE TAXPAYER_ID = l_TAXPAYER_ID;
910:
911: IF p_debug_log = 'Y' THEN
912: FND_FILE.PUT_LINE( FND_FILE.LOG,'16 .INSERTED DATA IN TABLE JL_AR_TURN_UPL WHEN WHT_CHECK_FLAG IS Y ');
913: END IF;
914: GOTO L3;
915:
916: -- If the wht rate and wht group are different (3.2.1.2) then UPDATE the tax SETups

Line 1243: -- delete JL_AR_TURN_UPL_T WHERE TAXPAYER_ID = l_TAXPAYER_ID;

1239: l_WHT_GROUP_NUM,
1240: l_WHT_DEFAULT_FLAG,
1241: 'AP');
1242:
1243: -- delete JL_AR_TURN_UPL_T WHERE TAXPAYER_ID = l_TAXPAYER_ID;
1244:
1245: IF p_debug_log = 'Y' THEN
1246: FND_FILE.put_line( FND_FILE.LOG,'26 . Inserted data in JL_AR_TURN_UPL for All Records ');
1247: END IF;

Line 1246: FND_FILE.put_line( FND_FILE.LOG,'26 . Inserted data in JL_AR_TURN_UPL for All Records ');

1242:
1243: -- delete JL_AR_TURN_UPL_T WHERE TAXPAYER_ID = l_TAXPAYER_ID;
1244:
1245: IF p_debug_log = 'Y' THEN
1246: FND_FILE.put_line( FND_FILE.LOG,'26 . Inserted data in JL_AR_TURN_UPL for All Records ');
1247: END IF;
1248:
1249: END IF;
1250:

Line 1272: FND_FILE.put_line( FND_FILE.LOG,'28. Inserted data in JL_AR_TURN_UPL when same_rec_flag is N AND l_RATE_CHANGE_FLAG is N');

1268: l_WHT_DEFAULT_FLAG,
1269: 'AP');
1270:
1271: IF p_debug_log = 'Y' THEN
1272: FND_FILE.put_line( FND_FILE.LOG,'28. Inserted data in JL_AR_TURN_UPL when same_rec_flag is N AND l_RATE_CHANGE_FLAG is N');
1273: FND_FILE.put_line( FND_FILE.LOG,'Fetching Record Record after Taxpayer Id '|| l_TAXPAYER_ID);
1274: END IF;
1275: --delete JL_AR_TURN_UPL_T WHERE TAXPAYER_ID = l_TAXPAYER_ID;
1276: --GOTO L3;

Line 1275: --delete JL_AR_TURN_UPL_T WHERE TAXPAYER_ID = l_TAXPAYER_ID;

1271: IF p_debug_log = 'Y' THEN
1272: FND_FILE.put_line( FND_FILE.LOG,'28. Inserted data in JL_AR_TURN_UPL when same_rec_flag is N AND l_RATE_CHANGE_FLAG is N');
1273: FND_FILE.put_line( FND_FILE.LOG,'Fetching Record Record after Taxpayer Id '|| l_TAXPAYER_ID);
1274: END IF;
1275: --delete JL_AR_TURN_UPL_T WHERE TAXPAYER_ID = l_TAXPAYER_ID;
1276: --GOTO L3;
1277:
1278: END IF;
1279: -- To check the data EXIST in JL_AR_TURN_UPL_T, but DO NOT EXIST in JL_AR_TURN_UPL table (TDD 3.3)

Line 1279: -- To check the data EXIST in JL_AR_TURN_UPL_T, but DO NOT EXIST in JL_AR_TURN_UPL table (TDD 3.3)

1275: --delete JL_AR_TURN_UPL_T WHERE TAXPAYER_ID = l_TAXPAYER_ID;
1276: --GOTO L3;
1277:
1278: END IF;
1279: -- To check the data EXIST in JL_AR_TURN_UPL_T, but DO NOT EXIST in JL_AR_TURN_UPL table (TDD 3.3)
1280:
1281:
1282: BEGIN
1283:

Line 1284: SELECT 'Y' INTO exist_check_flag FROM JL_AR_TURN_UPL

1280:
1281:
1282: BEGIN
1283:
1284: SELECT 'Y' INTO exist_check_flag FROM JL_AR_TURN_UPL
1285: WHERE TAXPAYER_ID NOT IN (SELECT TAXPAYER_ID FROM JL_AR_TURN_UPL_T WHERE START_DATE = l_START_DATE
1286: AND END_DATE = l_END_DATE
1287: AND PUBLISH_DATE = l_PUBLISH_DATE
1288: AND TAXPAYER_ID = l_TAXPAYER_ID);

Line 1285: WHERE TAXPAYER_ID NOT IN (SELECT TAXPAYER_ID FROM JL_AR_TURN_UPL_T WHERE START_DATE = l_START_DATE

1281:
1282: BEGIN
1283:
1284: SELECT 'Y' INTO exist_check_flag FROM JL_AR_TURN_UPL
1285: WHERE TAXPAYER_ID NOT IN (SELECT TAXPAYER_ID FROM JL_AR_TURN_UPL_T WHERE START_DATE = l_START_DATE
1286: AND END_DATE = l_END_DATE
1287: AND PUBLISH_DATE = l_PUBLISH_DATE
1288: AND TAXPAYER_ID = l_TAXPAYER_ID);
1289:

Line 1309: SELECT MAX(START_DATE) INTO l_START_DATE_SEC_MAX FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID AND

1305: IF p_debug_log = 'Y' THEN
1306: FND_FILE.PUT_LINE( FND_FILE.LOG,' 31 . EXIST_CHECK_FLAG'|| EXIST_CHECK_FLAG);
1307: END IF;
1308:
1309: SELECT MAX(START_DATE) INTO l_START_DATE_SEC_MAX FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID AND
1310: START_DATE NOT IN (SELECT MAX(START_DATE) FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID);
1311:
1312: SELECT MAX(END_DATE) INTO l_END_DATE_SEC_MAX FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID AND
1313: END_DATE NOT IN (SELECT MAX(END_DATE) FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID);

Line 1310: START_DATE NOT IN (SELECT MAX(START_DATE) FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID);

1306: FND_FILE.PUT_LINE( FND_FILE.LOG,' 31 . EXIST_CHECK_FLAG'|| EXIST_CHECK_FLAG);
1307: END IF;
1308:
1309: SELECT MAX(START_DATE) INTO l_START_DATE_SEC_MAX FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID AND
1310: START_DATE NOT IN (SELECT MAX(START_DATE) FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID);
1311:
1312: SELECT MAX(END_DATE) INTO l_END_DATE_SEC_MAX FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID AND
1313: END_DATE NOT IN (SELECT MAX(END_DATE) FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID);
1314:

Line 1312: SELECT MAX(END_DATE) INTO l_END_DATE_SEC_MAX FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID AND

1308:
1309: SELECT MAX(START_DATE) INTO l_START_DATE_SEC_MAX FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID AND
1310: START_DATE NOT IN (SELECT MAX(START_DATE) FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID);
1311:
1312: SELECT MAX(END_DATE) INTO l_END_DATE_SEC_MAX FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID AND
1313: END_DATE NOT IN (SELECT MAX(END_DATE) FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID);
1314:
1315:
1316:

Line 1313: END_DATE NOT IN (SELECT MAX(END_DATE) FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID);

1309: SELECT MAX(START_DATE) INTO l_START_DATE_SEC_MAX FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID AND
1310: START_DATE NOT IN (SELECT MAX(START_DATE) FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID);
1311:
1312: SELECT MAX(END_DATE) INTO l_END_DATE_SEC_MAX FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID AND
1313: END_DATE NOT IN (SELECT MAX(END_DATE) FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID);
1314:
1315:
1316:
1317:

Line 1323: SELECT 'N' INTO wht_check_unique FROM JL_AR_TURN_UPL_T WHERE

1319: wht_check_unique := 'Y';
1320:
1321: BEGIN
1322:
1323: SELECT 'N' INTO wht_check_unique FROM JL_AR_TURN_UPL_T WHERE
1324: TAXPAYER_ID = l_TAXPAYER_ID
1325: AND WHT_GROUP_NUM = l_WHT_GROUP_NUM
1326: AND WHT_RATE = l_WHT_RATE;
1327:

Line 1334: FND_FILE.PUT_LINE( FND_FILE.LOG,' 32 .NO DATA IN WHT_CHECK_FLAG IN JL_AR_TURN_UPL');

1330: WHEN NO_DATA_FOUND THEN
1331: wht_check_unique := 'N';
1332:
1333: IF p_debug_log = 'Y' THEN
1334: FND_FILE.PUT_LINE( FND_FILE.LOG,' 32 .NO DATA IN WHT_CHECK_FLAG IN JL_AR_TURN_UPL');
1335: END IF;
1336:
1337: WHEN OTHERS THEN
1338: wht_check_unique := 'Y';

Line 1764: -- delete JL_AR_TURN_UPL_T WHERE TAXPAYER_ID = l_TAXPAYER_ID;

1760: l_WHT_GROUP_NUM,
1761: l_WHT_DEFAULT_FLAG,
1762: 'AP');
1763:
1764: -- delete JL_AR_TURN_UPL_T WHERE TAXPAYER_ID = l_TAXPAYER_ID;
1765:
1766: IF p_debug_log = 'Y' THEN
1767: FND_FILE.put_line( FND_FILE.LOG,'47 . Inserted data in JL_AR_TURN_UPL for All Records ');
1768: END IF;

Line 1767: FND_FILE.put_line( FND_FILE.LOG,'47 . Inserted data in JL_AR_TURN_UPL for All Records ');

1763:
1764: -- delete JL_AR_TURN_UPL_T WHERE TAXPAYER_ID = l_TAXPAYER_ID;
1765:
1766: IF p_debug_log = 'Y' THEN
1767: FND_FILE.put_line( FND_FILE.LOG,'47 . Inserted data in JL_AR_TURN_UPL for All Records ');
1768: END IF;
1769:
1770: END IF;
1771:

Line 1859: ALL_REC JL_AR_TURN_UPL%ROWTYPE;

1855:
1856: l_WHT_GROUP_NUM_DEF_ATC AP_TAX_CODES_ALL.NAME%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;

Line 1923: SELECT * FROM JL_AR_TURN_UPL WHERE START_DATE <> l_START_DATE_CURR_MAX;

1919:
1920: -- To get the datas (having the MAX start DATE- current) FROM ALL table
1921:
1922: CURSOR C4(l_START_DATE_CURR_MAX DATE) IS
1923: SELECT * FROM JL_AR_TURN_UPL WHERE START_DATE <> l_START_DATE_CURR_MAX;
1924:
1925: V_ALLREC C4%ROWTYPE;
1926:
1927:

Line 1933: SELECT MAX(START_DATE) INTO l_START_DATE_CURR_MAX FROM JL_AR_TURN_UPL;

1929:
1930: BEGIN
1931:
1932: BEGIN
1933: SELECT MAX(START_DATE) INTO l_START_DATE_CURR_MAX FROM JL_AR_TURN_UPL;
1934: SELECT MAX(END_DATE) INTO l_END_DATE_CURR_MAX FROM JL_AR_TURN_UPL;
1935: --SELECT MAX(PUBLISH_DATE) INTO l_PUBLISH_DATE_CURR_MAX FROM JL_AR_TURN_UPL;
1936: SELECT name
1937: INTO l_WHT_GROUP_NUM_DEF_ATC

Line 1934: SELECT MAX(END_DATE) INTO l_END_DATE_CURR_MAX FROM JL_AR_TURN_UPL;

1930: BEGIN
1931:
1932: BEGIN
1933: SELECT MAX(START_DATE) INTO l_START_DATE_CURR_MAX FROM JL_AR_TURN_UPL;
1934: SELECT MAX(END_DATE) INTO l_END_DATE_CURR_MAX FROM JL_AR_TURN_UPL;
1935: --SELECT MAX(PUBLISH_DATE) INTO l_PUBLISH_DATE_CURR_MAX FROM JL_AR_TURN_UPL;
1936: SELECT name
1937: INTO l_WHT_GROUP_NUM_DEF_ATC
1938: FROM AP_TAX_CODES ATC

Line 1935: --SELECT MAX(PUBLISH_DATE) INTO l_PUBLISH_DATE_CURR_MAX FROM JL_AR_TURN_UPL;

1931:
1932: BEGIN
1933: SELECT MAX(START_DATE) INTO l_START_DATE_CURR_MAX FROM JL_AR_TURN_UPL;
1934: SELECT MAX(END_DATE) INTO l_END_DATE_CURR_MAX FROM JL_AR_TURN_UPL;
1935: --SELECT MAX(PUBLISH_DATE) INTO l_PUBLISH_DATE_CURR_MAX FROM JL_AR_TURN_UPL;
1936: SELECT name
1937: INTO l_WHT_GROUP_NUM_DEF_ATC
1938: FROM AP_TAX_CODES ATC
1939: WHERE global_attribute1 = 'Y'

Line 2077: SELECT MAX(START_DATE) INTO l_START_DATE_SEC_MAX FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID;

2073:
2074: BEGIN -- To get the datas (having the Second MAX start DATE) FROM ALL table
2075:
2076:
2077: SELECT MAX(START_DATE) INTO l_START_DATE_SEC_MAX FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID;
2078:
2079: SELECT last_day(l_START_DATE_SEC_MAX) INTO l_END_DATE_SEC_MAX FROM dual;
2080:
2081: EXCEPTION

Line 2405: SELECT * INTO ALL_REC FROM JL_AR_TURN_UPL

2401:
2402:
2403: -- insert data in ALL table
2404:
2405: SELECT * INTO ALL_REC FROM JL_AR_TURN_UPL
2406: WHERE START_DATE = l_START_DATE_SEC_MAX AND TAXPAYER_ID = l_TAXPAYER_ID;
2407:
2408:
2409: Insert_Row (ALL_REC.PUBLISH_DATE, -- inserting the old original publish DATE FROM government

Line 2488: table_name := 'JL_AR_TURN_UPL_T'; -- will goto xml file and print the Temp Table Data output directly

2484: END IF;
2485: FND_FILE.put_line( FND_FILE.LOG,'ORG_ID :'|| l_org_id);
2486: IF (P_REV_TEMP_DATA = 'Y') AND (P_VALIDATION_DATA = 'N') AND (P_FINALIZE_DATA = 'N') THEN
2487:
2488: table_name := 'JL_AR_TURN_UPL_T'; -- will goto xml file and print the Temp Table Data output directly
2489:
2490:
2491: ELSIF (P_REV_TEMP_DATA = 'N') AND (P_VALIDATION_DATA = 'N') AND (P_FINALIZE_DATA = 'N') THEN
2492:

Line 2493: table_name := 'JL_AR_TURN_UPL'; -- will goto xml file and print the FINAL ALL Table Data output directly

2489:
2490:
2491: ELSIF (P_REV_TEMP_DATA = 'N') AND (P_VALIDATION_DATA = 'N') AND (P_FINALIZE_DATA = 'N') THEN
2492:
2493: table_name := 'JL_AR_TURN_UPL'; -- will goto xml file and print the FINAL ALL Table Data output directly
2494:
2495:
2496: ELSIF (P_REV_TEMP_DATA = 'Y') AND (P_VALIDATION_DATA = 'Y') AND (P_FINALIZE_DATA = 'N') THEN
2497:

Line 2498: table_name := 'JL_AR_TURN_UPL'; -- will do validation for the govt flat file data and shows the valid and invalid records

2494:
2495:
2496: ELSIF (P_REV_TEMP_DATA = 'Y') AND (P_VALIDATION_DATA = 'Y') AND (P_FINALIZE_DATA = 'N') THEN
2497:
2498: table_name := 'JL_AR_TURN_UPL'; -- will do validation for the govt flat file data and shows the valid and invalid records
2499:
2500:
2501: IF p_debug_log = 'Y' THEN
2502: FND_FILE.put_line( FND_FILE.LOG,'Starting the FINAL_VALIDATION procedure');

Line 2514: table_name := 'JL_AR_TURN_UPL'; -- will do final validation for the govt flat file data and defaulting will happens for missing taxpayerid

2510: END IF;
2511:
2512: ELSIF (P_FINALIZE_DATA = 'Y') AND (P_REV_TEMP_DATA = 'N') AND (P_VALIDATION_DATA = 'N') THEN
2513:
2514: table_name := 'JL_AR_TURN_UPL'; -- will do final validation for the govt flat file data and defaulting will happens for missing taxpayerid
2515:
2516: IF p_debug_log = 'Y' THEN
2517: FND_FILE.put_line( FND_FILE.LOG,'Starting the VALIDATE_AWT_SETUP procedure');
2518: END IF;

Line 2528: table_name := 'JL_AR_TURN_UPL';

2524: END IF;
2525:
2526: ELSE
2527:
2528: table_name := 'JL_AR_TURN_UPL';
2529:
2530: IF p_debug_log = 'Y' THEN
2531: FND_FILE.put_line( FND_FILE.LOG,' ');
2532: FND_FILE.put_line( FND_FILE.LOG,' ');

Line 2565: SELECT MAX(start_DATE) INTO P_START_DATE FROM JL_AR_TURN_UPL;

2561: FND_FILE.put_line( FND_FILE.LOG,'Closing the PKG JL_AR_APPLICABLE_TAXES.beforeReport');
2562: END IF;
2563:
2564: IF (P_START_DATE IS NULL) THEN
2565: SELECT MAX(start_DATE) INTO P_START_DATE FROM JL_AR_TURN_UPL;
2566: END IF;
2567:
2568: IF (P_END_DATE IS NULL) THEN
2569: SELECT MAX(end_DATE) INTO P_END_DATE FROM JL_AR_TURN_UPL;

Line 2569: SELECT MAX(end_DATE) INTO P_END_DATE FROM JL_AR_TURN_UPL;

2565: SELECT MAX(start_DATE) INTO P_START_DATE FROM JL_AR_TURN_UPL;
2566: END IF;
2567:
2568: IF (P_END_DATE IS NULL) THEN
2569: SELECT MAX(end_DATE) INTO P_END_DATE FROM JL_AR_TURN_UPL;
2570: END IF;
2571: IF p_debug_log = 'Y' THEN
2572: FND_FILE.put_line( FND_FILE.LOG,'Before Report P_START_DATE :'|| P_START_DATE ||'P_END_DATE :'|| P_END_DATE);
2573: FND_FILE.put_line( FND_FILE.LOG,' ');