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_CARD_VALIDATE_PKG dependencies on AP_CARD_PROFILES

Line 25: -- o EVM denotes AP_CARD_PROFILES.EMP_NOTIFICATION_LOOKUP_CODE

21: -- required (EVM=Y) but it is not specified that distributions be created
22: -- from lines (CDF=N or null).
23: --
24: -- Where
25: -- o EVM denotes AP_CARD_PROFILES.EMP_NOTIFICATION_LOOKUP_CODE
26: -- o MAM denotes AP_CARD_PROFILES.MGR_APPROVAL_LOOKUP_CODE
27: -- o CDF denotes AP_EXPENSE_FEED_LINES.CREATE_DISTRIBUTION_FLAG
28: -- o BAFCF denotes AP_CARD_PROFILES.BUILD_ACCT_FROM_CODE_FLAG
29: -- (AP_CARD_PROFILES is parent of AP_CARDS).

Line 26: -- o MAM denotes AP_CARD_PROFILES.MGR_APPROVAL_LOOKUP_CODE

22: -- from lines (CDF=N or null).
23: --
24: -- Where
25: -- o EVM denotes AP_CARD_PROFILES.EMP_NOTIFICATION_LOOKUP_CODE
26: -- o MAM denotes AP_CARD_PROFILES.MGR_APPROVAL_LOOKUP_CODE
27: -- o CDF denotes AP_EXPENSE_FEED_LINES.CREATE_DISTRIBUTION_FLAG
28: -- o BAFCF denotes AP_CARD_PROFILES.BUILD_ACCT_FROM_CODE_FLAG
29: -- (AP_CARD_PROFILES is parent of AP_CARDS).
30: --

Line 28: -- o BAFCF denotes AP_CARD_PROFILES.BUILD_ACCT_FROM_CODE_FLAG

24: -- Where
25: -- o EVM denotes AP_CARD_PROFILES.EMP_NOTIFICATION_LOOKUP_CODE
26: -- o MAM denotes AP_CARD_PROFILES.MGR_APPROVAL_LOOKUP_CODE
27: -- o CDF denotes AP_EXPENSE_FEED_LINES.CREATE_DISTRIBUTION_FLAG
28: -- o BAFCF denotes AP_CARD_PROFILES.BUILD_ACCT_FROM_CODE_FLAG
29: -- (AP_CARD_PROFILES is parent of AP_CARDS).
30: --
31: --
32: -- Assigned Exceptions. Exception code stored in

Line 29: -- (AP_CARD_PROFILES is parent of AP_CARDS).

25: -- o EVM denotes AP_CARD_PROFILES.EMP_NOTIFICATION_LOOKUP_CODE
26: -- o MAM denotes AP_CARD_PROFILES.MGR_APPROVAL_LOOKUP_CODE
27: -- o CDF denotes AP_EXPENSE_FEED_LINES.CREATE_DISTRIBUTION_FLAG
28: -- o BAFCF denotes AP_CARD_PROFILES.BUILD_ACCT_FROM_CODE_FLAG
29: -- (AP_CARD_PROFILES is parent of AP_CARDS).
30: --
31: --
32: -- Assigned Exceptions. Exception code stored in
33: -- AP_EXPENSE_FEED_LINES.REJECT_CODE

Line 284: from ap_card_profiles cp,

280: and cp.card_program_id = P_CARD_PROGRAM_ID)
281: and nvl(create_distribution_flag,'N') = 'Y'
282: and exists
283: (select 'Profile mandates building account from card code'
284: from ap_card_profiles cp,
285: ap_cards c
286: where cp.profile_id = c.profile_id
287: and c.card_id = efl.card_id
288: and nvl(cp.build_acct_from_code_flag,'N') = 'Y')

Line 298: from ap_card_profiles cp,

294: update ap_expense_feed_lines efl
295: set reject_code = 'DIST REQUIRED'
296: where exists
297: (select 'Employee verification or manager approval required'
298: from ap_card_profiles cp,
299: ap_cards c
300: where cp.profile_id = c.profile_id
301: and c.card_id = efl.card_id
302: and (cp.emp_notification_lookup_code = 'Y' OR

Line 357: from ap_card_profiles cp

353: update ap_expense_feed_lines efl
354: set reject_code = 'EMPLOYEE REQUIRED'
355: where not exists
356: (select 1
357: from ap_card_profiles cp
358: where efl.card_program_id = cp.card_program_id
359: and nvl(cp.emp_notification_lookup_code, 'N') = 'N'
360: and nvl(cp.mgr_approval_lookup_code, 'N') = 'N'
361: )

Line 409: -- AP_CARD_PROFILES.EXCEPTION_CLEARING_CCID. If CCID not defined at

405: -- o If BAFCF=N overlay account segments defined in
406: -- DEFAULT_ACCT_TEMPLATE on top of Employee Acct CCID (from
407: -- HR_EMPLOYEES_CURRENT_V).
408: -- o If error results from operations above, use
409: -- AP_CARD_PROFILES.EXCEPTION_CLEARING_CCID. If CCID not defined at
410: -- profile, use AP_CARD_PROGRAMS.EXCEPTION_CLEARING_CCID.
411: -- o If CCID still cannot be determined, populate REJECT_CODE to flag
412: -- as invalid account exception.
413: --

Line 415: -- o EVM denotes AP_CARD_PROFILES.EMP_NOTIFICATION_LOOKUP_CODE

411: -- o If CCID still cannot be determined, populate REJECT_CODE to flag
412: -- as invalid account exception.
413: --
414: -- Where
415: -- o EVM denotes AP_CARD_PROFILES.EMP_NOTIFICATION_LOOKUP_CODE
416: -- o MAM denotes AP_CARD_PROFILES.MGR_APPROVAL_LOOKUP_CODE
417: -- o CDF denotes AP_EXPENSE_FEED_LINES.CREATE_DISTRIBUTION_FLAG
418: -- o BAFCF denotes AP_CARD_PROFILES.BUILD_ACCT_FROM_CODE_FLAG
419: -- (AP_CARD_PROFILES is parent of AP_CARDS).

Line 416: -- o MAM denotes AP_CARD_PROFILES.MGR_APPROVAL_LOOKUP_CODE

412: -- as invalid account exception.
413: --
414: -- Where
415: -- o EVM denotes AP_CARD_PROFILES.EMP_NOTIFICATION_LOOKUP_CODE
416: -- o MAM denotes AP_CARD_PROFILES.MGR_APPROVAL_LOOKUP_CODE
417: -- o CDF denotes AP_EXPENSE_FEED_LINES.CREATE_DISTRIBUTION_FLAG
418: -- o BAFCF denotes AP_CARD_PROFILES.BUILD_ACCT_FROM_CODE_FLAG
419: -- (AP_CARD_PROFILES is parent of AP_CARDS).
420: --

Line 418: -- o BAFCF denotes AP_CARD_PROFILES.BUILD_ACCT_FROM_CODE_FLAG

414: -- Where
415: -- o EVM denotes AP_CARD_PROFILES.EMP_NOTIFICATION_LOOKUP_CODE
416: -- o MAM denotes AP_CARD_PROFILES.MGR_APPROVAL_LOOKUP_CODE
417: -- o CDF denotes AP_EXPENSE_FEED_LINES.CREATE_DISTRIBUTION_FLAG
418: -- o BAFCF denotes AP_CARD_PROFILES.BUILD_ACCT_FROM_CODE_FLAG
419: -- (AP_CARD_PROFILES is parent of AP_CARDS).
420: --
421: ---------------------------------------------------------------------------
422: PROCEDURE CREATE_DISTRIBUTIONS(

Line 419: -- (AP_CARD_PROFILES is parent of AP_CARDS).

415: -- o EVM denotes AP_CARD_PROFILES.EMP_NOTIFICATION_LOOKUP_CODE
416: -- o MAM denotes AP_CARD_PROFILES.MGR_APPROVAL_LOOKUP_CODE
417: -- o CDF denotes AP_EXPENSE_FEED_LINES.CREATE_DISTRIBUTION_FLAG
418: -- o BAFCF denotes AP_CARD_PROFILES.BUILD_ACCT_FROM_CODE_FLAG
419: -- (AP_CARD_PROFILES is parent of AP_CARDS).
420: --
421: ---------------------------------------------------------------------------
422: PROCEDURE CREATE_DISTRIBUTIONS(
423: P_CARD_PROGRAM_ID IN NUMBER,

Line 449: l_build_acct_from_code_flag AP_CARD_PROFILES.build_acct_from_code_flag%TYPE;

445: l_feed_line_id NUMBER;
446: l_amount NUMBER;
447: l_card_code_value AP_EXPENSE_FEED_LINES.card_code_value%TYPE;
448: l_exception_clearing_ccid NUMBER;
449: l_build_acct_from_code_flag AP_CARD_PROFILES.build_acct_from_code_flag%TYPE;
450: l_default_acct_template AP_CARD_PROFILES.default_acct_template%TYPE;
451: l_distribution_status AP_EXPENSE_FEED_DISTS.status_lookup_code%TYPE;
452: l_cost_center AP_EXPENSE_FEED_DISTS.cost_center%TYPE;
453: l_account_segment_value AP_EXPENSE_FEED_DISTS.account_segment_value%TYPE;

Line 450: l_default_acct_template AP_CARD_PROFILES.default_acct_template%TYPE;

446: l_amount NUMBER;
447: l_card_code_value AP_EXPENSE_FEED_LINES.card_code_value%TYPE;
448: l_exception_clearing_ccid NUMBER;
449: l_build_acct_from_code_flag AP_CARD_PROFILES.build_acct_from_code_flag%TYPE;
450: l_default_acct_template AP_CARD_PROFILES.default_acct_template%TYPE;
451: l_distribution_status AP_EXPENSE_FEED_DISTS.status_lookup_code%TYPE;
452: l_cost_center AP_EXPENSE_FEED_DISTS.cost_center%TYPE;
453: l_account_segment_value AP_EXPENSE_FEED_DISTS.account_segment_value%TYPE;
454: l_card_code_set_id NUMBER;

Line 461: -- Legend to AP_CARD_PROFILES lookup codes

457:
458: --
459: -- Cursor that loops through lines for which distributions should be created.
460: --
461: -- Legend to AP_CARD_PROFILES lookup codes
462: -- emp_notification_lookup_code = Employee Verification Method
463: -- Y = Verification Required
464: -- I = Notification Only
465: -- N = None

Line 497: ap_card_profiles cpr,

493: 'APPROVED')),
494: efl.description
495: from ap_expense_feed_lines efl,
496: ap_card_programs cpg,
497: ap_card_profiles cpr,
498: ap_cards c,
499: hr_employees_current_v hremp,
500: IBY_FNDCPT_PAYER_ALL_INSTRS_V IBY
501: where efl.card_id = c.card_id