[Home] [Help]
298: -- Creates records in AP_EXPENSE_FEED_DISTS where CDF=Y.
299: -- CCID determined by looking at the BAFCF.
300: -- o If BAFCF=Y then use overlay account defined by CODE_ID on
301: -- top of DEFAULT_ACCT_TEMPLATE. Overlay resulting segments on
302: -- top of Employee Acct CCID (from HR_EMPLOYEES_CURRENT_V).
303: -- o If BAFCF=N overlay account segments defined in
304: -- DEFAULT_ACCT_TEMPLATE on top of Employee Acct CCID (from
305: -- HR_EMPLOYEES_CURRENT_V).
306: -- o If error results from operations above, use
301: -- top of DEFAULT_ACCT_TEMPLATE. Overlay resulting segments on
302: -- top of Employee Acct CCID (from HR_EMPLOYEES_CURRENT_V).
303: -- o If BAFCF=N overlay account segments defined in
304: -- DEFAULT_ACCT_TEMPLATE on top of Employee Acct CCID (from
305: -- HR_EMPLOYEES_CURRENT_V).
306: -- o If error results from operations above, use
307: -- AP_CARD_PROFILES.EXCEPTION_CLEARING_CCID. If CCID not defined at
308: -- profile, use AP_CARD_PROGRAMS.EXCEPTION_CLEARING_CCID.
309: -- o If CCID still cannot be determined, populate REJECT_CODE to flag
322: P_START_DATE IN DATE DEFAULT NULL,
323: P_END_DATE IN DATE DEFAULT NULL,
324: P_RETURN_ERROR_MESSAGE IN OUT NOCOPY VARCHAR2,
325: P_REQUEST_ID IN NUMBER) IS
326: l_default_emp_ccid HR_EMPLOYEES_CURRENT_V.default_code_combination_id%TYPE;
327: l_default_emp_segments FND_FLEX_EXT.SEGMENTARRAY;
328: l_final_segments FND_FLEX_EXT.SEGMENTARRAY;
329: l_def_acct_template_array FND_FLEX_EXT.SEGMENTARRAY;
330: l_exp_line_acct_segs_array FND_FLEX_EXT.SEGMENTARRAY;
393: from ap_expense_feed_lines efl,
394: ap_card_programs cpg,
395: ap_card_profiles cpr,
396: ap_cards c,
397: hr_employees_current_v hremp,
398: IBY_FNDCPT_PAYER_ALL_INSTRS_V IBY
399: where efl.card_id = c.card_id
400: and c.card_reference_id=IBY.instrument_id
401: and c.profile_id = cpr.profile_id