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_WEB_DB_CCARD_PKG dependencies on AP_CREDIT_CARD_TRXNS

Line 14: FROM AP_CREDIT_CARD_TRXNS ACCT,

10: --------------------------------------------------------------------------------
11: BEGIN
12: OPEN p_category FOR
13: SELECT ACCT.CATEGORY
14: FROM AP_CREDIT_CARD_TRXNS ACCT,
15: AP_EXPENSE_REPORT_LINES AERL
16: WHERE AERL.REPORT_HEADER_ID = P_ReportHeaderID
17: AND ACCT.TRX_ID = AERL.CREDIT_CARD_TRX_ID;
18:

Line 58: FROM ap_credit_card_trxns cc,

54: posted_currency_code,
55: transaction_amount,
56: cc.card_id,
57: nvl(cc.category, c_business)
58: FROM ap_credit_card_trxns cc,
59: ap_cards card
60: WHERE cc.validate_code = 'Y'
61: AND cc.payment_flag <> 'Y'
62: AND cc.billed_amount is not null

Line 104: ap_credit_card_trxns trxn

100: card.card_id,
101: trxn.payment_due_from_code
102: FROM ap_card_programs cp,
103: ap_cards card,
104: ap_credit_card_trxns trxn
105: WHERE card.employee_id = p_user_id
106: AND card.card_program_id = cp.card_program_id
107: AND cp.card_type_lookup_code = p_card_type
108: AND trxn.CARD_PROGRAM_ID = card.CARD_PROGRAM_ID

Line 152: FROM AP_CREDIT_CARD_TRXNS cc,

148: BILLED_AMOUNT,
149: cc.CARD_ID THE_CARD_ID,
150: emp.full_name,
151: emp.person_id
152: FROM AP_CREDIT_CARD_TRXNS cc,
153: AP_CARDS card,
154: per_people_x emp
155: WHERE cc.CARD_PROGRAM_ID = p_card_prog_id
156: AND cc.VALIDATE_CODE = 'Y'

Line 197: ap_credit_card_trxns cct,

193: BEGIN
194: OPEN p_disputed_cursor FOR
195: SELECT transaction_date, merchant_name1, billed_amount, billed_currency_code
196: FROM
197: ap_credit_card_trxns cct,
198: ap_cards_all ac
199: WHERE
200: cct.card_program_id = p_cardProgramId
201: and cct.validate_code = 'Y'

Line 252: ap_credit_card_trxns cct,

248: (erh.source,erh.workflow_approved_flag,
249: erh.report_header_id), --2615448
250: cct.trx_id -- Bug 3241358
251: FROM
252: ap_credit_card_trxns cct,
253: ap_cards ac,
254: ap_expense_report_headers erh
255: WHERE
256: cct.card_program_id = p_cardProgramId

Line 285: ap_credit_card_trxns cct,

281: null,
282: 'UNUSED',
283: cct.trx_id -- Bug 3241358
284: FROM
285: ap_credit_card_trxns cct,
286: ap_cards ac
287: WHERE
288: cct.card_program_id = p_cardProgramId
289: and cct.validate_code = 'Y'

Line 314: ap_credit_card_trxns cct,

310: (erh.source,erh.workflow_approved_flag,
311: erh.report_header_id), --2615448
312: cct.trx_id -- Bug 3241358
313: FROM
314: ap_credit_card_trxns cct,
315: ap_cards ac,
316: ap_expense_report_headers erh
317: WHERE
318: cct.card_program_id = p_cardProgramId

Line 377: ap_credit_card_trxns cct,

373: (erh.source,erh.workflow_approved_flag,
374: erh.report_header_id), --2615448
375: cct.trx_id -- Bug 3241358
376: FROM
377: ap_credit_card_trxns cct,
378: ap_cards ac,
379: ap_expense_report_headers erh
380: WHERE
381: cct.card_program_id = p_cardProgramId

Line 408: ap_credit_card_trxns cct,

404: null,
405: 'UNUSED',
406: cct.trx_id -- Bug 3241358
407: FROM
408: ap_credit_card_trxns cct,
409: ap_cards ac
410: WHERE
411: cct.card_program_id = p_cardProgramId
412: and cct.validate_code = 'Y'

Line 436: ap_credit_card_trxns cct,

432: (erh.source,erh.workflow_approved_flag,
433: erh.report_header_id), --2615448
434: cct.trx_id -- Bug 3241358
435: FROM
436: ap_credit_card_trxns cct,
437: ap_cards ac,
438: ap_expense_report_headers erh
439: WHERE
440: cct.card_program_id = p_cardProgramId

Line 503: ap_credit_card_trxns cct,

499: cct.transaction_amount,--Notification Esc
500: AP_WEB_DB_CCARD_PKG.GETLOCATION(cct.merchant_city , cct.merchant_province_state), --Notification Esc
501: cct.trx_id -- Bug 3241358
502: FROM
503: ap_credit_card_trxns cct,
504: ap_cards ac,
505: ap_expense_report_headers erh
506: WHERE
507: cct.card_program_id = p_cardProgramId

Line 538: ap_credit_card_trxns cct,

534: cct.transaction_amount,--Notification Esc
535: AP_WEB_DB_CCARD_PKG.GETLOCATION(cct.merchant_city , cct.merchant_province_state), --Notification Esc
536: cct.trx_id -- Bug 3241358
537: FROM
538: ap_credit_card_trxns cct,
539: ap_cards ac,
540: ap_expense_report_headers erh
541: WHERE
542: cct.card_program_id = p_cardProgramId

Line 570: ap_credit_card_trxns cct,

566: cct.transaction_amount,--Notification Esc
567: AP_WEB_DB_CCARD_PKG.GETLOCATION(cct.merchant_city , cct.merchant_province_state), --Notification Esc
568: cct.trx_id -- Bug 3241358
569: FROM
570: ap_credit_card_trxns cct,
571: ap_cards ac
572: WHERE
573: cct.card_program_id = p_cardProgramId
574: and cct.validate_code = 'Y'

Line 623: ap_credit_card_trxns cct,

619: erh.report_header_id),'UNUSED'), --2615505
620: nvl(cct.billed_date, cct.posted_date) billed_date,
621: cct.trx_id -- Bug 3241358
622: FROM
623: ap_credit_card_trxns cct,
624: ap_cards ac,
625: ap_expense_report_headers erh
626: WHERE
627: cct.card_program_id = p_cardProgramId

Line 654: ap_credit_card_trxns cct,

650: erh.report_header_id),
651: nvl(cct.billed_date, cct.posted_date) billed_date,
652: cct.trx_id
653: FROM
654: ap_credit_card_trxns cct,
655: ap_cards ac,
656: ap_expense_report_headers erh
657: WHERE
658: cct.card_program_id = p_cardProgramId

Line 681: ap_credit_card_trxns cct,

677: 'UNUSED',
678: nvl(cct.billed_date, cct.posted_date) billed_date,
679: cct.trx_id -- Bug 3241358
680: FROM
681: ap_credit_card_trxns cct,
682: ap_cards ac
683: WHERE
684: cct.card_program_id = p_cardProgramId
685: and cct.validate_code = 'Y'

Line 745: FROM ap_credit_card_trxns

741: -------------------------------------------------------------------
742: BEGIN
743: SELECT category
744: INTO p_category
745: FROM ap_credit_card_trxns
746: WHERE trx_id = p_trx_id;
747:
748: RETURN TRUE;
749:

Line 774: FROM ap_credit_card_trxns

770:
771: IF (p_trx_id IS NOT NULL) THEN
772: SELECT company_prepaid_invoice_id
773: INTO p_prepaid_invoice_id
774: FROM ap_credit_card_trxns
775: WHERE trx_id = p_trx_id;
776: END IF;
777:
778: RETURN TRUE;

Line 801: from ap_credit_card_trxns

797: --------------------------------------------------------------------------------
798: BEGIN
799: select expensed_amount
800: into p_amt
801: from ap_credit_card_trxns
802: where trx_id = p_id;
803:
804: return TRUE;
805:

Line 860: FROM ap_credit_card_trxns cc,

856: SELECT distinct acp.vendor_id,
857: acp.vendor_site_id
858: INTO p_vendor_id,
859: p_vendor_site_id
860: FROM ap_credit_card_trxns cc,
861: ap_card_programs acp
862: WHERE cc.report_header_id = p_report_header_id
863: AND cc.card_program_id = acp.card_program_id;
864:

Line 973: FROM AP_CREDIT_CARD_TRXNS_all

969: FROM AP_CARD_PROGRAMS_all CP ,
970: AP_CARDS_all CARD ,
971: AP_LOOKUP_CODES ALC,
972: ( SELECT CARD_PROGRAM_ID,CARD_ID, PAYMENT_DUE_FROM_CODE
973: FROM AP_CREDIT_CARD_TRXNS_all
974: WHERE VALIDATE_CODE = 'Y'
975: AND PAYMENT_FLAG <> 'Y'
976: AND BILLED_AMOUNT IS NOT NULL
977: AND NVL ( CATEGORY , 'BUSINESS' ) <> 'DEACTIVATED' ) TRXN

Line 1010: UPDATE ap_credit_card_trxns

1006: p_new_report_id IN NUMBER
1007: ) RETURN BOOLEAN IS
1008: -------------------------------------------------------------------
1009: BEGIN
1010: UPDATE ap_credit_card_trxns
1011: SET report_header_id = p_new_report_id
1012: WHERE report_header_id = p_report_header_id;
1013: -- Bug 2178676
1014: -- AND category <> c_personal;

Line 1036: UPDATE ap_credit_card_trxns

1032: p_new_expense_report_id IN ccTrxn_headerID )
1033: RETURN BOOLEAN IS
1034: --------------------------------------------------------------------------------
1035: BEGIN
1036: UPDATE ap_credit_card_trxns
1037: SET report_header_id = p_new_expense_report_id
1038: WHERE trx_id IN (SELECT credit_card_trx_id
1039: FROM ap_expense_report_lines
1040: WHERE report_header_id = p_new_expense_report_id

Line 1063: UPDATE ap_credit_card_trxns

1059: p_new_expense_report_id IN ccTrxn_headerID
1060: ) RETURN BOOLEAN IS
1061: --------------------------------------------------------------------------------
1062: BEGIN
1063: UPDATE ap_credit_card_trxns
1064: SET report_header_id = p_new_expense_report_id
1065: WHERE trx_id IN (SELECT credit_card_trx_id
1066: FROM ap_expense_report_lines
1067: WHERE report_header_id = p_new_expense_report_id

Line 1095: UPDATE ap_credit_card_trxns

1091: p_expensed_amount IN ccTrxn_expensedAmt
1092: ) RETURN BOOLEAN IS
1093: --------------------------------------------------------------------------------
1094: BEGIN
1095: UPDATE ap_credit_card_trxns
1096: SET expensed_amount = p_expensed_amount,
1097: report_header_id = p_report_id,
1098: category = null
1099: WHERE trx_id = p_trxn_id;

Line 1120: UPDATE ap_credit_card_trxns cc

1116: p_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE)
1117: RETURN BOOLEAN IS
1118: --------------------------------------------------------------------------------
1119: BEGIN
1120: UPDATE ap_credit_card_trxns cc
1121: SET expensed_amount = 0,
1122: report_header_id = null,
1123: category = null
1124: WHERE report_header_id = p_report_header_id;

Line 1145: UPDATE ap_credit_card_trxns

1141: p_status IN ccTrxn_expenseStatus
1142: ) RETURN BOOLEAN IS
1143: --------------------------------------------------------------------------------
1144: BEGIN
1145: UPDATE ap_credit_card_trxns
1146: SET expense_status = p_status
1147: where report_header_id = p_report_header_id;
1148:
1149: RETURN TRUE;

Line 1170: UPDATE ap_credit_card_trxns

1166: p_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE
1167: ) RETURN BOOLEAN IS
1168: --------------------------------------------------------------------------------
1169: BEGIN
1170: UPDATE ap_credit_card_trxns
1171: SET expensed_amount = 0,
1172: report_header_id = NULL
1173: WHERE report_header_id IN (SELECT report_header_id
1174: FROM ap_expense_report_headers

Line 1202: update ap_credit_card_trxns

1198: p_reportID IN ccTrxn_headerID
1199: ) RETURN BOOLEAN IS
1200: --------------------------------------------------------------------------------
1201: BEGIN
1202: update ap_credit_card_trxns
1203: set expensed_amount = 0,
1204: report_header_id = null
1205: where (report_header_id = p_reportID)
1206: and (category = c_personal);

Line 1228: UPDATE ap_credit_card_trxns cc

1224: ) RETURN BOOLEAN IS
1225: --------------------------------------------------------------------------------
1226: BEGIN
1227:
1228: UPDATE ap_credit_card_trxns cc
1229: SET expensed_amount = 0,
1230: report_header_id = null
1231: WHERE cc.report_header_id IN (SELECT report_header_id erh_headerID
1232: FROM ap_expense_report_headers

Line 1263: UPDATE ap_credit_card_trxns_all

1259: p_invoice_id IN ccTrxn_companyPrepaidInvID
1260: ) RETURN BOOLEAN IS
1261: --------------------------------------------------------------------------------
1262: BEGIN
1263: UPDATE ap_credit_card_trxns_all
1264: SET company_prepaid_invoice_id = p_invoice_id
1265: WHERE trx_id = p_card_trxn_id;
1266:
1267: RETURN TRUE;

Line 1306: FROM ap_credit_card_trxns cc

1302: p_trxn_info_rec.merchant_city, p_trxn_info_rec.merchant_prov,
1303: p_trxn_info_rec.billed_amount, p_trxn_info_rec.posted_curr_code,
1304: p_trxn_info_rec.trxn_amount, p_trxn_info_rec.card_id,
1305: p_trxn_info_rec.category, p_trxn_info_rec.card_prog_id
1306: FROM ap_credit_card_trxns cc
1307: WHERE trx_id = p_trxn_id;
1308:
1309: RETURN TRUE;
1310:

Line 1329: UPDATE ap_credit_card_trxns

1325: p_category IN ccTrxn_category
1326: ) RETURN BOOLEAN IS
1327: ------------------------------------------------------------------------------
1328: BEGIN
1329: UPDATE ap_credit_card_trxns
1330: SET category = p_category
1331: WHERE trx_id = p_trxn_id;
1332:
1333: RETURN TRUE;

Line 1354: FROM ap_credit_card_trxns

1350: ------------------------------------------------------------------------------
1351: BEGIN
1352: SELECT expensed_amount
1353: INTO p_exp_amount
1354: FROM ap_credit_card_trxns
1355: WHERE trx_id = p_trxn_id;
1356:
1357: RETURN TRUE;
1358:

Line 1384: from ap_credit_card_trxns

1380: BEGIN
1381: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_DB_CCARD_PKG', 'start isMultPayments');
1382: select count(distinct payment_due_from_code)
1383: into paymentMethodCount
1384: from ap_credit_card_trxns
1385: where card_program_id = p_cardProgramID
1386: and card_id = p_card_id;
1387:
1388: IF (paymentMethodCount > 1) THEN

Line 1405: AP_CREDIT_CARD_TRXNS_ALL table.

1401: END isMultPayments;
1402: -------------------------------------------------------------------------------
1403: /*Written By :Amulya Mishra
1404: Purpose :Returns the UNIQUE PAYMENT_DUE_FROM_CODE from
1405: AP_CREDIT_CARD_TRXNS_ALL table.
1406: */
1407:
1408: FUNCTION getPaymentDueCodeFromTrxn(
1409: p_trxn_id IN ccTrxn_trxID)

Line 1420: FROM ap_credit_card_trxns trx

1416: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_DB_CCARD_PKG', 'start getPaymentDueCodeFromTrxn');
1417:
1418: SELECT DISTINCT payment_due_from_code
1419: INTO p_paymentDueCode
1420: FROM ap_credit_card_trxns trx
1421: WHERE trx.trx_id = p_trxn_id;
1422:
1423: RETURN p_paymentDueCode;
1424:

Line 1616: ap_credit_card_trxns trxns

1612: select count(1)
1613: into p_num_old
1614: from ap_card_programs cp,
1615: ap_cards card,
1616: ap_credit_card_trxns trxns
1617: where card.employee_id = p_employee_id
1618: and card.card_program_id = cp.card_program_id
1619: and cp.card_type_lookup_code = 'TRAVEL'
1620: and trxns.card_program_id = card.card_program_id

Line 1658: ap_credit_card_trxns trxns

1654: select count(1)
1655: into p_num_disputed
1656: from ap_card_programs cp,
1657: ap_cards card,
1658: ap_credit_card_trxns trxns
1659: where card.employee_id = p_employee_id
1660: and card.card_program_id = cp.card_program_id
1661: and cp.card_type_lookup_code = 'TRAVEL'
1662: and trxns.card_program_id = card.card_program_id

Line 1697: ap_credit_card_trxns trxns

1693: select count(1)
1694: into p_num_credits
1695: from ap_card_programs cp,
1696: ap_cards card,
1697: ap_credit_card_trxns trxns
1698: where card.employee_id = p_employee_id
1699: and card.card_program_id = cp.card_program_id
1700: and cp.card_type_lookup_code = 'TRAVEL'
1701: and trxns.card_program_id = card.card_program_id

Line 1879: ap_credit_card_trxns cct,

1875: cct.posted_date, --Notification Esc
1876: cct.transaction_amount,--Notification Esc
1877: AP_WEB_DB_CCARD_PKG.GETLOCATION(cct.merchant_city , cct.merchant_province_state) --Notification Esc
1878: from
1879: ap_credit_card_trxns cct,
1880: ap_cards_all ac
1881: where
1882: cct.card_program_id = p_cardProgramId
1883: and cct.validate_code = 'Y'

Line 1927: ap_credit_card_trxns_all cct,

1923: FROM
1924: (
1925: SELECT DISTINCT cct.trx_id, cct.billed_amount amount
1926: FROM
1927: ap_credit_card_trxns_all cct,
1928: ap_cards_all ac,
1929: ap_expense_report_headers_all erh
1930: WHERE
1931: cct.card_program_id = p_cardProgramId

Line 1948: ap_credit_card_trxns_all cct,

1944: and ac.employee_id = p_employeeId
1945: UNION ALL
1946: SELECT DISTINCT cct.trx_id, cct.billed_amount amount
1947: FROM
1948: ap_credit_card_trxns_all cct,
1949: ap_cards_all ac
1950: WHERE
1951: cct.card_program_id = p_cardProgramId
1952: and cct.validate_code = 'Y'

Line 1998: ap_credit_card_trxns cct,

1994: p_total_amt_outstanding
1995: FROM
1996: ( SELECT DISTINCT trx_id, cct.billed_amount amount
1997: FROM
1998: ap_credit_card_trxns cct,
1999: ap_cards ac,
2000: ap_expense_report_headers erh
2001: WHERE
2002: cct.card_program_id = p_cardProgramId

Line 2020: ap_credit_card_trxns cct,

2016: and ac.employee_id = p_employeeId
2017: UNION ALL
2018: SELECT DISTINCT trx_id, cct.billed_amount amount
2019: FROM
2020: ap_credit_card_trxns cct,
2021: ap_cards ac
2022: WHERE
2023: cct.card_program_id = p_cardProgramId
2024: and cct.validate_code = 'Y'

Line 2074: ap_credit_card_trxns cct,

2070: p_total_amt_dispute
2071: FROM
2072: ( SELECT DISTINCT trx_id, cct.billed_amount amount
2073: FROM
2074: ap_credit_card_trxns cct,
2075: ap_cards ac,
2076: ap_expense_report_headers erh
2077: WHERE
2078: cct.card_program_id = p_cardProgramId

Line 2132: from ap_credit_card_trxns cct

2128: BEGIN
2129:
2130: select nvl(min(posted_date), sysdate)
2131: into l_oldest_posted_date
2132: from ap_credit_card_trxns cct
2133: where cct.card_program_id = p_cardProgramId
2134: and cct.card_id = p_cardId
2135: and cct.payment_due_from_code = p_paymentDueFromCode
2136: and cct.billed_currency_code = p_reimb_curr_code