APPS.AP_CARD_VALIDATE_PKG dependencies on AP_EXPENSE_FEED_DISTS

Line 102: from ap_expense_feed_dists efd

98: and posted_date between nvl(P_START_DATE, posted_date - 1) and
99: nvl(P_END_DATE, posted_date + 1)
100: and not exists
101: (select 'A distribution exists for this expense feed line'
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';

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

396: ---------------------------------------------------------------------------
397: --
398: -- Procedure CREATE_DISTRIBUTIONS
399: --
400: -- Creates records in AP_EXPENSE_FEED_DISTS where CDF=Y.
401: -- CCID determined by looking at the BAFCF.
402: -- o If BAFCF=Y then use overlay account defined by CODE_ID on
403: -- top of DEFAULT_ACCT_TEMPLATE. Overlay resulting segments on
404: -- top of Employee Acct CCID (from HR_EMPLOYEES_CURRENT_V).

Line 451: l_distribution_status AP_EXPENSE_FEED_DISTS.status_lookup_code%TYPE;

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;
455: l_org_id NUMBER;

Line 452: l_cost_center AP_EXPENSE_FEED_DISTS.cost_center%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;
455: l_org_id NUMBER;
456: l_description VARCHAR2(240); -- Bug 977059

Line 453: l_account_segment_value AP_EXPENSE_FEED_DISTS.account_segment_value%TYPE;

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;
455: l_org_id NUMBER;
456: l_description VARCHAR2(240); -- Bug 977059
457:

Line 513: from ap_expense_feed_dists efd

509: and reject_code is NULL
510: AND iby.instrument_type='CREDITCARD' -- veramach added for bug 7196074
511: and not exists
512: (select 'A distribution exists for this expense feed line'
513: from ap_expense_feed_dists efd
514: where efd.feed_line_id = efl.feed_line_id)
515: and efl.card_program_id = P_CARD_PROGRAM_ID;
516:
517: BEGIN

Line 732: -- Insert record into AP_EXPENSE_FEED_DISTS

728: l_account_segment_value := l_final_segments(l_flex_segment_number);
729: l_cost_center := l_final_segments(l_cc_flex_segment_number);
730:
731: --
732: -- Insert record into AP_EXPENSE_FEED_DISTS
733: --
734: select org_id into l_org_id
735: from
736: ap_expense_feed_lines

Line 740: insert into AP_EXPENSE_FEED_DISTS_ALL

736: ap_expense_feed_lines
737: where
738: feed_line_id=l_feed_line_id;
739: Mo_Global.set_policy_context('S',l_org_id);
740: insert into AP_EXPENSE_FEED_DISTS_ALL
741: (FEED_LINE_ID,
742: FEED_DISTRIBUTION_ID,
743: AMOUNT,
744: DIST_CODE_COMBINATION_ID,

Line 758: ap_expense_feed_dists_s.nextval,

754: CREATION_DATE,
755: CREATED_BY,ORG_ID,
756: CONC_REQUEST_ID) VALUES
757: (l_feed_line_id,
758: ap_expense_feed_dists_s.nextval,
759: l_amount,
760: l_exp_line_ccid,
761: sysdate,
762: l_distribution_status,