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_CREDIT_CARD_TRXNS

Line 445: V_BILLED_AMOUNT AP_CREDIT_CARD_TRXNS.BILLED_AMOUNT%TYPE;

441: END GETBASECURRDATA;
442:
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';

Line 446: V_BILLED_CURRENCY_CODE AP_CREDIT_CARD_TRXNS.BILLED_CURRENCY_CODE%TYPE;

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

Line 462: AP_CREDIT_CARD_TRXNS CCT,

458: CCT.BILLED_AMOUNT,
459: CCT.BILLED_CURRENCY_CODE,
460: CCT.TRX_ID
461: FROM
462: AP_CREDIT_CARD_TRXNS CCT,
463: AP_CARDS_ALL AC
464: WHERE CCT.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID
465: AND CCT.VALIDATE_CODE = 'Y'
466: AND CCT.PAYMENT_FLAG <> 'Y'

Line 505: AP_CREDIT_CARD_TRXNS CCT,

501: CCT.BILLED_AMOUNT,
502: CCT.BILLED_CURRENCY_CODE,
503: CCT.TRX_ID
504: FROM
505: AP_CREDIT_CARD_TRXNS CCT,
506: AP_CARDS_ALL AC
507: WHERE CCT.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID
508: AND CCT.VALIDATE_CODE = 'Y'
509: AND CCT.PAYMENT_FLAG <> 'Y'

Line 542: AP_CREDIT_CARD_TRXNS CCT,

538: CCT.BILLED_AMOUNT,
539: CCT.BILLED_CURRENCY_CODE,
540: CCT.TRX_ID
541: FROM
542: AP_CREDIT_CARD_TRXNS CCT,
543: AP_CARDS_ALL AC
544: WHERE CCT.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID
545: AND CCT.VALIDATE_CODE = 'Y'
546: AND CCT.PAYMENT_FLAG <> 'Y'

Line 579: AP_CREDIT_CARD_TRXNS CCT,

575: CCT.BILLED_AMOUNT,
576: CCT.BILLED_CURRENCY_CODE,
577: CCT.TRX_ID
578: FROM
579: AP_CREDIT_CARD_TRXNS CCT,
580: AP_CARDS_ALL AC,
581: AP_EXPENSE_REPORT_HEADERS ERH
582: WHERE CCT.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID
583: AND CCT.VALIDATE_CODE = 'Y'

Line 624: AP_CREDIT_CARD_TRXNS CCT,

620: CCT.BILLED_AMOUNT,
621: CCT.BILLED_CURRENCY_CODE,
622: CCT.TRX_ID
623: FROM
624: AP_CREDIT_CARD_TRXNS CCT,
625: AP_CARDS_ALL AC,
626: AP_EXPENSE_REPORT_HEADERS ERH
627: WHERE CCT.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID
628: AND CCT.VALIDATE_CODE = 'Y'

Line 661: AP_CREDIT_CARD_TRXNS CCT,

657: CCT.BILLED_AMOUNT,
658: CCT.BILLED_CURRENCY_CODE,
659: CCT.TRX_ID
660: FROM
661: AP_CREDIT_CARD_TRXNS CCT,
662: AP_CARDS_ALL AC,
663: AP_EXPENSE_REPORT_LINES ERL,
664: AP_EXPENSE_REPORT_HEADERS ERH
665: WHERE CCT.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID

Line 730: AP_CREDIT_CARD_TRXNS CCT,

726: DISTINCT
727: ERH.REPORT_HEADER_ID,
728: ERH.EXPENSE_CURRENT_APPROVER_ID
729: FROM
730: AP_CREDIT_CARD_TRXNS CCT,
731: AP_EXPENSE_REPORT_LINES ERL,
732: AP_EXPENSE_REPORT_HEADERS ERH
733: WHERE CCT.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID
734: AND CCT.VALIDATE_CODE = 'Y'

Line 775: AP_CREDIT_CARD_TRXNS CCT,

771: DISTINCT
772: ERH.REPORT_HEADER_ID,
773: ERH.EXPENSE_CURRENT_APPROVER_ID
774: FROM
775: AP_CREDIT_CARD_TRXNS CCT,
776: AP_EXPENSE_REPORT_LINES ERL,
777: AP_EXPENSE_REPORT_HEADERS ERH
778: WHERE CCT.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID
779: AND CCT.VALIDATE_CODE = 'Y'

Line 812: AP_CREDIT_CARD_TRXNS CCT,

808: DISTINCT
809: ERH.REPORT_HEADER_ID,
810: ERH.EXPENSE_CURRENT_APPROVER_ID
811: FROM
812: AP_CREDIT_CARD_TRXNS CCT,
813: AP_EXPENSE_REPORT_LINES ERL,
814: AP_EXPENSE_REPORT_HEADERS ERH
815: WHERE CCT.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID
816: AND CCT.VALIDATE_CODE = 'Y'

Line 865: AP_CREDIT_CARD_TRXNS CCT,

861: CURSOR DISPUTEDCHARGES IS
862: SELECT
863: AC.EMPLOYEE_ID
864: FROM
865: AP_CREDIT_CARD_TRXNS CCT,
866: AP_CARDS_ALL AC
867: WHERE CCT.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID
868: AND CCT.VALIDATE_CODE = 'Y'
869: AND CCT.PAYMENT_FLAG <> 'Y'

Line 1102: V_CARD_PROGRAM_ID AP_CREDIT_CARD_TRXNS.CARD_PROGRAM_ID%TYPE;

1098: ,P_IN_SEND_NOTIFICATIONS IN VARCHAR2
1099: ,P_IN_ESC_LEVEL IN NUMBER
1100: ,P_IN_GRACE_DAYS IN NUMBER) IS
1101: V_EMPLOYEE_ID PER_PEOPLE_F.PERSON_ID%TYPE;
1102: V_CARD_PROGRAM_ID AP_CREDIT_CARD_TRXNS.CARD_PROGRAM_ID%TYPE;
1103: V_MIN_BUCKET NUMBER;
1104: V_MAX_BUCKET NUMBER;
1105: V_BILLED_AMOUNT AP_CREDIT_CARD_TRXNS.BILLED_AMOUNT%TYPE;
1106: V_BILLED_CURRENCY_CODE AP_CREDIT_CARD_TRXNS.BILLED_CURRENCY_CODE%TYPE;

Line 1105: V_BILLED_AMOUNT AP_CREDIT_CARD_TRXNS.BILLED_AMOUNT%TYPE;

1101: V_EMPLOYEE_ID PER_PEOPLE_F.PERSON_ID%TYPE;
1102: V_CARD_PROGRAM_ID AP_CREDIT_CARD_TRXNS.CARD_PROGRAM_ID%TYPE;
1103: V_MIN_BUCKET NUMBER;
1104: V_MAX_BUCKET NUMBER;
1105: V_BILLED_AMOUNT AP_CREDIT_CARD_TRXNS.BILLED_AMOUNT%TYPE;
1106: V_BILLED_CURRENCY_CODE AP_CREDIT_CARD_TRXNS.BILLED_CURRENCY_CODE%TYPE;
1107: V_DUNNING_NUMBER NUMBER;
1108: V_SEND_NOTIFICATIONS VARCHAR2(20);
1109: V_ESC_LEVEL NUMBER;

Line 1106: V_BILLED_CURRENCY_CODE AP_CREDIT_CARD_TRXNS.BILLED_CURRENCY_CODE%TYPE;

1102: V_CARD_PROGRAM_ID AP_CREDIT_CARD_TRXNS.CARD_PROGRAM_ID%TYPE;
1103: V_MIN_BUCKET NUMBER;
1104: V_MAX_BUCKET NUMBER;
1105: V_BILLED_AMOUNT AP_CREDIT_CARD_TRXNS.BILLED_AMOUNT%TYPE;
1106: V_BILLED_CURRENCY_CODE AP_CREDIT_CARD_TRXNS.BILLED_CURRENCY_CODE%TYPE;
1107: V_DUNNING_NUMBER NUMBER;
1108: V_SEND_NOTIFICATIONS VARCHAR2(20);
1109: V_ESC_LEVEL NUMBER;
1110: V_GRACE_DAYS NUMBER;

Line 1135: AP_CREDIT_CARD_TRXNS CCT,

1131: CCT.BILLED_AMOUNT,
1132: CCT.BILLED_CURRENCY_CODE,
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

Line 1195: AP_CREDIT_CARD_TRXNS CCT,

1191: CCT.BILLED_AMOUNT,
1192: CCT.BILLED_CURRENCY_CODE,
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

Line 1248: AP_CREDIT_CARD_TRXNS CCT,

1244: CCT.BILLED_AMOUNT,
1245: CCT.BILLED_CURRENCY_CODE,
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

Line 1411: AP_CREDIT_CARD_TRXNS CCT,

1407: AC.EMPLOYEE_ID INACT_EMPLOYEE_ID,
1408: CCT.BILLED_CURRENCY_CODE BILLED_CURRENCY_CODE,
1409: SUM(CCT.BILLED_AMOUNT) TOTAL_AMT_POSTED
1410: FROM
1411: AP_CREDIT_CARD_TRXNS CCT,
1412: AP_CARDS_ALL AC
1413: WHERE AC.CARD_PROGRAM_ID = CCT.CARD_PROGRAM_ID
1414: AND AC.CARD_ID = CCT.CARD_ID
1415: AND CCT.TRX_ID in (

Line 1419: AP_CREDIT_CARD_TRXNS CCT,

1415: AND CCT.TRX_ID in (
1416: SELECT
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,

Line 1458: AP_CREDIT_CARD_TRXNS CCT,

1454: UNION ALL
1455: SELECT
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,

Line 1506: AP_CREDIT_CARD_TRXNS CCT,

1502: SELECT
1503: DISTINCT
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,

Line 1546: AP_CREDIT_CARD_TRXNS CCT,

1542: SELECT
1543: DISTINCT
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,

Line 1615: AP_CREDIT_CARD_TRXNS

1611: FETCH C_CCTRX_UPDATE
1612: INTO R_CCTRX_UPDATE;
1613: EXIT WHEN C_CCTRX_UPDATE%NOTFOUND;
1614: UPDATE
1615: AP_CREDIT_CARD_TRXNS
1616: SET
1617: INACTIVE_EMP_WF_ITEM_KEY = L_WF_ITEM_KEY
1618: WHERE TRX_ID = R_CCTRX_UPDATE.TRX_ID;
1619: END LOOP;