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.AP_APXT7CMT_XMLP_PKG dependencies on AP_1099_TAPE_DATA

Line 43: IF (DELETE_AP_1099_TAPE_DATA <> TRUE) THEN

39: IF (P_DEBUG_SWITCH in ('y','Y')) THEN
40: /*SRW.MESSAGE('8'
41: ,'After Get_combined_flag')*/NULL;
42: END IF;
43: IF (DELETE_AP_1099_TAPE_DATA <> TRUE) THEN
44: RETURN (FALSE);
45: END IF;
46: IF (P_DEBUG_SWITCH in ('y','Y')) THEN
47: /*SRW.MESSAGE('9'

Line 48: ,'After delete_ap_1099_tape_data')*/NULL;

44: RETURN (FALSE);
45: END IF;
46: IF (P_DEBUG_SWITCH in ('y','Y')) THEN
47: /*SRW.MESSAGE('9'
48: ,'After delete_ap_1099_tape_data')*/NULL;
49: END IF;
50: IF (INSERT_AP_1099_TAPE_DATA <> TRUE) THEN
51: RETURN (FALSE);
52: END IF;

Line 50: IF (INSERT_AP_1099_TAPE_DATA <> TRUE) THEN

46: IF (P_DEBUG_SWITCH in ('y','Y')) THEN
47: /*SRW.MESSAGE('9'
48: ,'After delete_ap_1099_tape_data')*/NULL;
49: END IF;
50: IF (INSERT_AP_1099_TAPE_DATA <> TRUE) THEN
51: RETURN (FALSE);
52: END IF;
53: IF (P_DEBUG_SWITCH in ('y','Y')) THEN
54: /*SRW.MESSAGE('10'

Line 55: ,'After insert_ap_1099_tape_data')*/NULL;

51: RETURN (FALSE);
52: END IF;
53: IF (P_DEBUG_SWITCH in ('y','Y')) THEN
54: /*SRW.MESSAGE('10'
55: ,'After insert_ap_1099_tape_data')*/NULL;
56: END IF;
57: IF (PERFORM_STATE_TESTS <> TRUE) THEN
58: RETURN (FALSE);
59: END IF;

Line 303: FUNCTION DELETE_AP_1099_TAPE_DATA RETURN BOOLEAN IS

299: WHEN OTHERS THEN
300: RETURN (FALSE);
301: END GET_TIN;
302:
303: FUNCTION DELETE_AP_1099_TAPE_DATA RETURN BOOLEAN IS
304: BEGIN
305: DELETE FROM AP_1099_TAPE_DATA;
306: RETURN (TRUE);
307: RETURN NULL;

Line 305: DELETE FROM AP_1099_TAPE_DATA;

301: END GET_TIN;
302:
303: FUNCTION DELETE_AP_1099_TAPE_DATA RETURN BOOLEAN IS
304: BEGIN
305: DELETE FROM AP_1099_TAPE_DATA;
306: RETURN (TRUE);
307: RETURN NULL;
308: EXCEPTION
309: WHEN OTHERS THEN

Line 311: END DELETE_AP_1099_TAPE_DATA;

307: RETURN NULL;
308: EXCEPTION
309: WHEN OTHERS THEN
310: RETURN (FALSE);
311: END DELETE_AP_1099_TAPE_DATA;
312:
313: FUNCTION INSERT_AP_1099_TAPE_DATA RETURN BOOLEAN IS
314: L_SOB_ID NUMBER;
315: L_TAX_ENTITY_ID NUMBER;

Line 313: FUNCTION INSERT_AP_1099_TAPE_DATA RETURN BOOLEAN IS

309: WHEN OTHERS THEN
310: RETURN (FALSE);
311: END DELETE_AP_1099_TAPE_DATA;
312:
313: FUNCTION INSERT_AP_1099_TAPE_DATA RETURN BOOLEAN IS
314: L_SOB_ID NUMBER;
315: L_TAX_ENTITY_ID NUMBER;
316: BEGIN
317: IF P_TAX_ENTITY_ID IS NOT NULL AND P_SET_OF_BOOKS_ID IS NOT NULL THEN

Line 335: AP_1099_TAPE_DATA;

331: SELECT
332: count(*)
333: INTO C_NUMBER_OF_B_RECS
334: FROM
335: AP_1099_TAPE_DATA;
336: RETURN (TRUE);
337: ELSE
338: RETURN (FALSE);
339: END IF;

Line 344: END INSERT_AP_1099_TAPE_DATA;

340: RETURN NULL;
341: EXCEPTION
342: WHEN OTHERS THEN
343: RETURN (FALSE);
344: END INSERT_AP_1099_TAPE_DATA;
345:
346: FUNCTION PERFORM_STATE_TESTS RETURN BOOLEAN IS
347: BEGIN
348: UPDATE

Line 349: AP_1099_TAPE_DATA

345:
346: FUNCTION PERFORM_STATE_TESTS RETURN BOOLEAN IS
347: BEGIN
348: UPDATE
349: AP_1099_TAPE_DATA
350: SET
351: REGION_CODE = ''
352: WHERE ROWID not in (
353: SELECT

Line 356: AP_1099_TAPE_DATA TD,

352: WHERE ROWID not in (
353: SELECT
354: TD.ROWID
355: FROM
356: AP_1099_TAPE_DATA TD,
357: AP_INCOME_TAX_REGIONS ITR
358: WHERE ITR.REGION_CODE = TD.REGION_CODE
359: AND NVL(ITR.INACTIVE_DATE
360: ,TO_DATE(P_END_YEAR_DATE

Line 510: AP_1099_TAPE_DATA

506: ( SUM(MISC15B) + SUM(MISC15AT) ),
507: count(*),
508: REGION_CODE
509: FROM
510: AP_1099_TAPE_DATA
511: GROUP BY
512: REGION_CODE;
513: BEGIN
514: OPEN DETERMINE_STATE_TOTALS;

Line 742: AP_1099_TAPE_DATA

738: ,0
739: ,0
740: ,152)
741: FROM
742: AP_1099_TAPE_DATA
743: GROUP BY
744: VENDOR_ID
745: HAVING SUM(NVL(MISC1
746: ,0)) + SUM(NVL(MISC3

Line 824: AP_1099_TAPE_DATA

820: ,0
821: ,0
822: ,152)
823: FROM
824: AP_1099_TAPE_DATA
825: WHERE REGION_CODE is not null
826: GROUP BY
827: VENDOR_ID;
828: BEGIN

Line 1326: AP_1099_TAPE_DATA

1322:
1323: FUNCTION PERFORM_FEDERAL_LIMIT_UPDATES RETURN BOOLEAN IS
1324: BEGIN
1325: UPDATE
1326: AP_1099_TAPE_DATA
1327: SET
1328: MISC2 = 0
1329: WHERE VENDOR_ID in (
1330: SELECT

Line 1333: AP_1099_TAPE_DATA

1329: WHERE VENDOR_ID in (
1330: SELECT
1331: VENDOR_ID
1332: FROM
1333: AP_1099_TAPE_DATA
1334: GROUP BY
1335: VENDOR_ID
1336: HAVING SUM(NVL(MISC2
1337: ,0)) < 10 );

Line 1339: AP_1099_TAPE_DATA

1335: VENDOR_ID
1336: HAVING SUM(NVL(MISC2
1337: ,0)) < 10 );
1338: UPDATE
1339: AP_1099_TAPE_DATA
1340: SET
1341: MISC8 = 0
1342: WHERE VENDOR_ID in (
1343: SELECT

Line 1346: AP_1099_TAPE_DATA

1342: WHERE VENDOR_ID in (
1343: SELECT
1344: VENDOR_ID
1345: FROM
1346: AP_1099_TAPE_DATA
1347: GROUP BY
1348: VENDOR_ID
1349: HAVING SUM(NVL(MISC8
1350: ,0)) < 10 );

Line 1352: AP_1099_TAPE_DATA

1348: VENDOR_ID
1349: HAVING SUM(NVL(MISC8
1350: ,0)) < 10 );
1351: UPDATE
1352: AP_1099_TAPE_DATA
1353: SET
1354: MISC15ANT = 0
1355: ,MISC15AT = 0
1356: WHERE VENDOR_ID in (

Line 1360: AP_1099_TAPE_DATA

1356: WHERE VENDOR_ID in (
1357: SELECT
1358: VENDOR_ID
1359: FROM
1360: AP_1099_TAPE_DATA
1361: GROUP BY
1362: VENDOR_ID
1363: HAVING SUM(NVL(MISC15ANT
1364: ,0) + NVL(MISC15AT

Line 1367: AP_1099_TAPE_DATA

1363: HAVING SUM(NVL(MISC15ANT
1364: ,0) + NVL(MISC15AT
1365: ,0)) < P_FEDERAL_REPORTING_LIMIT );
1366: UPDATE
1367: AP_1099_TAPE_DATA
1368: SET
1369: MISC7 = 0
1370: WHERE VENDOR_ID in (
1371: SELECT

Line 1374: AP_1099_TAPE_DATA

1370: WHERE VENDOR_ID in (
1371: SELECT
1372: VENDOR_ID
1373: FROM
1374: AP_1099_TAPE_DATA
1375: GROUP BY
1376: VENDOR_ID
1377: HAVING SUM(NVL(MISC7
1378: ,0)) < P_FEDERAL_REPORTING_LIMIT );

Line 1380: AP_1099_TAPE_DATA

1376: VENDOR_ID
1377: HAVING SUM(NVL(MISC7
1378: ,0)) < P_FEDERAL_REPORTING_LIMIT );
1379: UPDATE
1380: AP_1099_TAPE_DATA
1381: SET
1382: MISC1 = 0
1383: ,MISC3 = 0
1384: ,MISC6 = 0

Line 1392: AP_1099_TAPE_DATA

1388: WHERE VENDOR_ID in (
1389: SELECT
1390: VENDOR_ID
1391: FROM
1392: AP_1099_TAPE_DATA
1393: GROUP BY
1394: VENDOR_ID
1395: HAVING SUM(NVL(MISC1
1396: ,0)) + SUM(NVL(MISC3