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_APXCCOUT_XMLP_PKG dependencies on AP_CARD_PROGRAMS

Line 447: V_CARD_PROGRAM_NAME AP_CARD_PROGRAMS.CARD_PROGRAM_NAME%TYPE;

443: PROCEDURE SENDUNSUBMITTED IS
444: V_EMPLOYEE_ID AP_CARDS.EMPLOYEE_ID%TYPE;
445: V_BILLED_AMOUNT AP_CREDIT_CARD_TRXNS.BILLED_AMOUNT%TYPE;
446: V_BILLED_CURRENCY_CODE AP_CREDIT_CARD_TRXNS.BILLED_CURRENCY_CODE%TYPE;
447: V_CARD_PROGRAM_NAME AP_CARD_PROGRAMS.CARD_PROGRAM_NAME%TYPE;
448: V_SAVED_CHARGE_TYPE VARCHAR2(20);
449: V_UNSUBMITTED_CHARGE_TYPE VARCHAR2(20) := 'UNUSED';
450: CURSOR UNSUBMITTEDCHARGES IS
451: SELECT

Line 700: AP_CARD_PROGRAMS

696: SELECT
697: CARD_PROGRAM_NAME
698: INTO V_CARD_PROGRAM_NAME
699: FROM
700: AP_CARD_PROGRAMS
701: WHERE CARD_PROGRAM_ID = P_CARD_PROGRAM_ID;
702: OPEN UNSUBMITTEDCHARGES;
703: LOOP
704: FETCH UNSUBMITTEDCHARGES

Line 910: AP_CARD_PROGRAMS_ALL CP

906: SELECT
907: CARD_PROGRAM_NAME
908: INTO CP_CARD_PROGRAM_NAME
909: FROM
910: AP_CARD_PROGRAMS_ALL CP
911: WHERE CP.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID;
912: RETURN (TRUE);
913: RETURN NULL;
914: EXCEPTION

Line 1137: AP_CARD_PROGRAMS CP,

1133: CCT.TRX_ID
1134: FROM
1135: AP_CREDIT_CARD_TRXNS CCT,
1136: AP_CARDS AC,
1137: AP_CARD_PROGRAMS CP,
1138: AP_EXPENSE_REPORT_LINES ERL,
1139: AP_EXPENSE_REPORT_HEADERS ERH
1140: WHERE CCT.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID
1141: AND CCT.VALIDATE_CODE = 'Y'

Line 1197: AP_CARD_PROGRAMS CP,

1193: CCT.TRX_ID
1194: FROM
1195: AP_CREDIT_CARD_TRXNS CCT,
1196: AP_CARDS AC,
1197: AP_CARD_PROGRAMS CP,
1198: AP_EXPENSE_REPORT_LINES ERL,
1199: AP_EXPENSE_REPORT_HEADERS ERH
1200: WHERE CCT.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID
1201: AND CCT.VALIDATE_CODE = 'Y'

Line 1250: AP_CARD_PROGRAMS CP,

1246: CCT.TRX_ID
1247: FROM
1248: AP_CREDIT_CARD_TRXNS CCT,
1249: AP_CARDS AC,
1250: AP_CARD_PROGRAMS CP,
1251: AP_EXPENSE_REPORT_LINES ERL,
1252: AP_EXPENSE_REPORT_HEADERS ERH
1253: WHERE CCT.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID
1254: AND CCT.VALIDATE_CODE = 'Y'

Line 1421: AP_CARD_PROGRAMS_ALL CP,

1417: CCT.TRX_ID
1418: FROM
1419: AP_CREDIT_CARD_TRXNS CCT,
1420: AP_CARDS_ALL AC,
1421: AP_CARD_PROGRAMS_ALL CP,
1422: PER_PEOPLE_F PERF,
1423: PER_ASSIGNMENTS_F PERA,
1424: PER_ASSIGNMENT_STATUS_TYPES PERAS
1425: WHERE CCT.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID

Line 1460: AP_CARD_PROGRAMS_ALL CP,

1456: CCT.TRX_ID
1457: FROM
1458: AP_CREDIT_CARD_TRXNS CCT,
1459: AP_CARDS_ALL AC,
1460: AP_CARD_PROGRAMS_ALL CP,
1461: PER_PEOPLE_F PERF,
1462: PER_ASSIGNMENTS_F PERA,
1463: PER_ASSIGNMENT_STATUS_TYPES PERAS,
1464: AP_EXPENSE_REPORT_HEADERS ERH

Line 1508: AP_CARD_PROGRAMS_ALL CP,

1504: CCT.TRX_ID
1505: FROM
1506: AP_CREDIT_CARD_TRXNS CCT,
1507: AP_CARDS_ALL AC,
1508: AP_CARD_PROGRAMS_ALL CP,
1509: PER_PEOPLE_F PERF,
1510: PER_ASSIGNMENTS_F PERA,
1511: PER_ASSIGNMENT_STATUS_TYPES PERAS
1512: WHERE CCT.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID

Line 1548: AP_CARD_PROGRAMS_ALL CP,

1544: CCT.TRX_ID
1545: FROM
1546: AP_CREDIT_CARD_TRXNS CCT,
1547: AP_CARDS_ALL AC,
1548: AP_CARD_PROGRAMS_ALL CP,
1549: PER_PEOPLE_F PERF,
1550: PER_ASSIGNMENTS_F PERA,
1551: PER_ASSIGNMENT_STATUS_TYPES PERAS,
1552: AP_EXPENSE_REPORT_HEADERS ERH