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_EXPENSE_REPORT_HEADERS

Line 7: P_ReportHeaderID IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,

3: /* Credit Cards */
4:
5: --------------------------------------------------------------------------------
6: FUNCTION GetExpRptCCTrxnCategoryCursor(
7: P_ReportHeaderID IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,
8: p_category OUT NOCOPY CreditCardCategoryCursor
9: ) RETURN BOOLEAN IS
10: --------------------------------------------------------------------------------
11: BEGIN

Line 254: ap_expense_report_headers erh

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
257: and cct.validate_code = 'Y'
258: and cct.payment_flag <> 'Y'

Line 316: ap_expense_report_headers erh

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
319: and cct.validate_code = 'Y'
320: and cct.payment_flag <> 'Y'

Line 379: ap_expense_report_headers erh

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
382: and cct.validate_code = 'Y'
383: and cct.payment_flag <> 'Y'

Line 438: ap_expense_report_headers erh

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
441: and cct.validate_code = 'Y'
442: and cct.payment_flag <> 'Y'

Line 505: ap_expense_report_headers erh

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
508: and cct.validate_code = 'Y'
509: and cct.payment_flag <> 'Y'

Line 540: ap_expense_report_headers erh

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
543: and cct.validate_code = 'Y'
544: and cct.payment_flag <> 'Y'

Line 625: ap_expense_report_headers erh

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
628: and cct.validate_code = 'Y'
629: and cct.payment_flag <> 'Y'

Line 656: ap_expense_report_headers erh

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
659: and cct.validate_code = 'Y'
660: and cct.payment_flag <> 'Y'

Line 1031: p_orig_expense_report_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,

1027: END SetCCTrxnReportHeaderID;
1028:
1029: --------------------------------------------------------------------------------
1030: FUNCTION SetCCPolicyShortpaidReportID(
1031: p_orig_expense_report_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,
1032: p_new_expense_report_id IN ccTrxn_headerID )
1033: RETURN BOOLEAN IS
1034: --------------------------------------------------------------------------------
1035: BEGIN

Line 1058: p_orig_expense_report_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,

1054:
1055:
1056: --------------------------------------------------------------------------------
1057: FUNCTION SetCCReceiptShortpaidReportID(
1058: p_orig_expense_report_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,
1059: p_new_expense_report_id IN ccTrxn_headerID
1060: ) RETURN BOOLEAN IS
1061: --------------------------------------------------------------------------------
1062: BEGIN

Line 1116: p_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE)

1112: END UpdateExpensedAmount;
1113:
1114: --------------------------------------------------------------------------------
1115: FUNCTION ResetCCLines(
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

Line 1166: p_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE

1162:
1163:
1164: --------------------------------------------------------------------------------
1165: FUNCTION ResetCCMgrRejectedCCLines(
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

Line 1174: FROM ap_expense_report_headers

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
1175: WHERE report_header_id = p_report_header_id
1176: AND workflow_approved_flag in
1177: (AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_REJECTED,
1178: AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_RETURNED,

Line 1223: p_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE

1219: END ResetPersonalTrxns;
1220:
1221: --------------------------------------------------------------------------------
1222: FUNCTION ResetMgrRejectPersonalTrxns(
1223: p_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE
1224: ) RETURN BOOLEAN IS
1225: --------------------------------------------------------------------------------
1226: BEGIN
1227:

Line 1232: FROM ap_expense_report_headers

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
1233: WHERE report_header_id = p_report_header_id
1234: AND workflow_approved_flag in
1235: (AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_REJECTED,
1236: AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_RETURNED,

Line 1929: ap_expense_report_headers_all erh

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
1932: and cct.validate_code = 'Y'
1933: and cct.payment_flag <> 'Y'

Line 2000: ap_expense_report_headers erh

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
2003: and cct.validate_code = 'Y'
2004: and cct.payment_flag <> 'Y'

Line 2076: ap_expense_report_headers erh

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
2079: and cct.validate_code = 'Y'
2080: and cct.payment_flag <> 'Y'