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.

[Home] [Help]

APPS.AP_CARD_VALIDATE_PKG dependencies on AP_CARDS

Line 10: -- o CARD_ID - FK to AP_CARDS. Match on CARD_NUMBER

6: -- Procedure VALIDATE
7: --
8: -- Populates foreign keys and validates user-provided FKs.
9: -- Determines exceptions, populates REJECT_CODE
10: -- o CARD_ID - FK to AP_CARDS. Match on CARD_NUMBER
11: -- o CODE_ID - FK to AP_CARD_CODES.
12: -- Match on CODE_VALUE for CARD_CODE_SET defined for this card program
13: -- (CARD_PROGRAM_ID)
14: -- o EMPLOYEE_ID - denormalized from AP_CARDS.

Line 14: -- o EMPLOYEE_ID - denormalized from AP_CARDS.

10: -- o CARD_ID - FK to AP_CARDS. Match on CARD_NUMBER
11: -- o CODE_ID - FK to AP_CARD_CODES.
12: -- Match on CODE_VALUE for CARD_CODE_SET defined for this card program
13: -- (CARD_PROGRAM_ID)
14: -- o EMPLOYEE_ID - denormalized from AP_CARDS.
15: -- o Validates Currency Codes, CARD_PROGRAM_ID
16: -- o Insures no duplicate reference numbers for this card program
17: -- o Exception raised if card profile is such that account is built from
18: -- code (BAFCF=Y) and distributions are created from line (CDF=Y) and

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 84: l_card_reference_id ap_cards_all.card_reference_id%type ;

80: l_card number;
81: /*x_response APPS.IBY_FNDCPT_COMMON_PUB.RESULT_REC_TYPE; Bug9789870 */
82: x_response IBY_FNDCPT_COMMON_PUB.RESULT_REC_TYPE;
83: l_card_id NUMBER;
84: l_card_reference_id ap_cards_all.card_reference_id%type ;
85: BEGIN
86:
87: --------------------------------------------------------------------
88: l_debug_info :=

Line 106: l_debug_info := 'Find the matching card number in AP_CARDS';

102: from ap_expense_feed_dists efd
103: where efd.feed_line_id = efl.feed_line_id);
104:
105: --------------------------------------------------------------------
106: l_debug_info := 'Find the matching card number in AP_CARDS';
107: --------------------------------------------------------------------
108: /* update ap_expense_feed_lines efl
109: set card_id =
110: (select c.card_id

Line 111: from ap_cards c

107: --------------------------------------------------------------------
108: /* update ap_expense_feed_lines efl
109: set card_id =
110: (select c.card_id
111: from ap_cards c
112: where c.card_number = efl.card_number)
113: where card_id is null
114: and reject_code = 'UNTESTED';*/
115:

Line 132: from ap_cards aca

128: BEGIN
129:
130: select aca.card_reference_id
131: into l_card_reference_id
132: from ap_cards aca
133: where aca.card_id = i.card_id
134: and aca.card_reference_id is not null ;
135:
136:

Line 146: null ,trim(i.card_number), -- party id is null as we reference cards through ap_cards_all.employee_id

142: END ;
143:
144: /* iby_fndcpt_setup_pub.card_exists(1.0,NULL,
145: x_return_status, x_msg_count, x_msg_data,
146: null ,trim(i.card_number), -- party id is null as we reference cards through ap_cards_all.employee_id
147: p_card_instrument, x_response);
148:
149: if (x_return_status = 'S') then
150: x_instr_id := p_card_instrument.card_id;

Line 162: ap_cards where card_reference_id=x_instr_id and rownum=1;

158: where feed_line_id=i.feed_line_id;
159: else
160: begin
161: select card_id into l_card from
162: ap_cards where card_reference_id=x_instr_id and rownum=1;
163: update ap_expense_feed_lines
164: set
165: card_id=l_card
166: where

Line 204: from ap_cards c

200:
201: update ap_expense_feed_lines efl
202: set employee_id =
203: (select c.employee_id
204: from ap_cards c
205: where c.card_id = efl.card_id)
206: where card_id is not null
207: and NOT EXISTS (select 1 from ap_card_programs cp
208: where cp.card_program_id = efl.card_program_id

Line 285: ap_cards c

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')
289: and reject_code = 'UNTESTED';

Line 299: ap_cards c

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
303: cp.mgr_approval_lookup_code = 'Y'))

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 498: ap_cards c,

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
502: and c.card_reference_id=IBY.instrument_id