DBA Data[Home] [Help]

APPS.JL_AR_APPLICABLE_TAXES dependencies on JL_AR_TURN_UPL_T

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 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 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 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 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 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 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 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 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 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 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: