APPS.AP_CARD_VALIDATE_PKG dependencies on AP_EXPENSE_FEED_DISTS

Line 88: from ap_expense_feed_dists efd

84: and posted_date between nvl(P_START_DATE, posted_date - 1) and
85: nvl(P_END_DATE, posted_date + 1)
86: and not exists
87: (select 'A distribution exists for this expense feed line'
88: from ap_expense_feed_dists efd
89: where efd.feed_line_id = efl.feed_line_id);
90:
91: --------------------------------------------------------------------
92: l_debug_info := 'Find the matching card number in AP_CARDS';

Line 298: -- Creates records in AP_EXPENSE_FEED_DISTS where CDF=Y.

294: ---------------------------------------------------------------------------
295: --
296: -- Procedure CREATE_DISTRIBUTIONS
297: --
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).

Line 349: l_distribution_status AP_EXPENSE_FEED_DISTS.status_lookup_code%TYPE;

345: l_card_code_value AP_EXPENSE_FEED_LINES.card_code_value%TYPE;
346: l_exception_clearing_ccid NUMBER;
347: l_build_acct_from_code_flag AP_CARD_PROFILES.build_acct_from_code_flag%TYPE;
348: l_default_acct_template AP_CARD_PROFILES.default_acct_template%TYPE;
349: l_distribution_status AP_EXPENSE_FEED_DISTS.status_lookup_code%TYPE;
350: l_cost_center AP_EXPENSE_FEED_DISTS.cost_center%TYPE;
351: l_account_segment_value AP_EXPENSE_FEED_DISTS.account_segment_value%TYPE;
352: l_card_code_set_id NUMBER;
353: l_org_id NUMBER;

Line 350: l_cost_center AP_EXPENSE_FEED_DISTS.cost_center%TYPE;

346: l_exception_clearing_ccid NUMBER;
347: l_build_acct_from_code_flag AP_CARD_PROFILES.build_acct_from_code_flag%TYPE;
348: l_default_acct_template AP_CARD_PROFILES.default_acct_template%TYPE;
349: l_distribution_status AP_EXPENSE_FEED_DISTS.status_lookup_code%TYPE;
350: l_cost_center AP_EXPENSE_FEED_DISTS.cost_center%TYPE;
351: l_account_segment_value AP_EXPENSE_FEED_DISTS.account_segment_value%TYPE;
352: l_card_code_set_id NUMBER;
353: l_org_id NUMBER;
354: l_description VARCHAR2(240); -- Bug 977059

Line 351: l_account_segment_value AP_EXPENSE_FEED_DISTS.account_segment_value%TYPE;

347: l_build_acct_from_code_flag AP_CARD_PROFILES.build_acct_from_code_flag%TYPE;
348: l_default_acct_template AP_CARD_PROFILES.default_acct_template%TYPE;
349: l_distribution_status AP_EXPENSE_FEED_DISTS.status_lookup_code%TYPE;
350: l_cost_center AP_EXPENSE_FEED_DISTS.cost_center%TYPE;
351: l_account_segment_value AP_EXPENSE_FEED_DISTS.account_segment_value%TYPE;
352: l_card_code_set_id NUMBER;
353: l_org_id NUMBER;
354: l_description VARCHAR2(240); -- Bug 977059
355:

Line 411: from ap_expense_feed_dists efd

407: and reject_code is NULL
408: AND iby.instrument_type='CREDITCARD' -- veramach added for bug 7196074
409: and not exists
410: (select 'A distribution exists for this expense feed line'
411: from ap_expense_feed_dists efd
412: where efd.feed_line_id = efl.feed_line_id)
413: and efl.card_program_id = P_CARD_PROGRAM_ID;
414:
415: BEGIN

Line 616: -- Insert record into AP_EXPENSE_FEED_DISTS

612: l_account_segment_value := l_final_segments(l_flex_segment_number);
613: l_cost_center := l_final_segments(l_cc_flex_segment_number);
614:
615: --
616: -- Insert record into AP_EXPENSE_FEED_DISTS
617: --
618: select org_id into l_org_id
619: from
620: ap_expense_feed_lines

Line 624: insert into AP_EXPENSE_FEED_DISTS_ALL

620: ap_expense_feed_lines
621: where
622: feed_line_id=l_feed_line_id;
623: Mo_Global.set_policy_context('S',l_org_id);
624: insert into AP_EXPENSE_FEED_DISTS_ALL
625: (FEED_LINE_ID,
626: FEED_DISTRIBUTION_ID,
627: AMOUNT,
628: DIST_CODE_COMBINATION_ID,

Line 642: ap_expense_feed_dists_s.nextval,

638: CREATION_DATE,
639: CREATED_BY,ORG_ID,
640: CONC_REQUEST_ID) VALUES
641: (l_feed_line_id,
642: ap_expense_feed_dists_s.nextval,
643: l_amount,
644: l_exp_line_ccid,
645: sysdate,
646: l_distribution_status,