[Home] [Help]
30: decode(cp.emp_notification_lookup_code, 'N', null, fl.employee_id),
31: decode(cp.emp_notification_lookup_code, 'Y',
32: fd.status_lookup_code, null)
33: FROM ap_expense_feed_lines fl,
34: ap_expense_feed_dists_all fd,
35: ap_cards_all c,
36: ap_card_profiles_all cp,
37: IBY_CREDITCARD IBY
38: WHERE fl.create_distribution_flag = 'Y' AND
63: decode(cp.emp_notification_lookup_code, 'N', null, fl.employee_id),
64: decode(cp.emp_notification_lookup_code, 'Y',
65: fd.status_lookup_code, null)
66: FROM ap_expense_feed_lines fl,
67: ap_expense_feed_dists_all fd,
68: ap_cards_all c,
69: ap_card_profiles_all cp,
70: IBY_CREDITCARD IBY
71: WHERE
142: WHERE (create_distribution_flag = 'N' OR
143: create_distribution_flag IS NULL)
144: AND employee_verification_id IS NULL
145: AND EXISTS (SELECT 'feed distribution falls in this workflow'
146: FROM ap_expense_feed_dists fd,
147: ap_cards c,
148: ap_card_profiles cp,
149: IBY_CREDITCARD IBY
150: WHERE fl.feed_line_id = fd.feed_line_id
163: (fl.employee_id = p_employee_id)) );
164: --bug5058949
165: --Performance fix
166:
167: UPDATE ap_expense_feed_dists fd
168: SET employee_verification_id = l_new_emp_verification_id
169: WHERE status_lookup_code in ('VALIDATED', 'HOLD', 'REJECTED')
170: AND employee_verification_id IS NULL
171: AND EXISTS (SELECT 'feed distribution falls in this workflow'
187: --------------------------------------------------------------------
188: SELECT count(*)
189: INTO l_num_records_updated
190: FROM ap_expense_feed_lines fl,
191: ap_expense_feed_dists fd
192: WHERE fl.employee_verification_id = l_new_emp_verification_id
193: OR fd.employee_verification_id = l_new_emp_verification_id;
194:
195: IF (l_num_records_updated > 0) THEN
355: SELECT cp.mgr_approval_lookup_code,
356: decode(cp.mgr_approval_lookup_code, 'N', null, hr.supervisor_id),
357: decode(cp.mgr_approval_lookup_code, 'N', null, fl.employee_id)
358: FROM ap_expense_feed_lines fl,
359: ap_expense_feed_dists_all fd,
360: ap_cards_all c,
361: ap_card_profiles_all cp,
362: per_employees_x hr,
363: IBY_CREDITCARD IBY
444:
445: --bug5058949
446: --Performance fix
447:
448: UPDATE ap_expense_feed_dists fd
449: SET manager_approval_id = l_new_manager_approval_id
450: WHERE status_lookup_code = 'VERIFIED'
451: AND manager_approval_id IS NULL
452: AND EXISTS (SELECT 'feed distribution falls in this workflow'
472: 'workflow process.';
473: -------------------------------------------------------------------------
474: SELECT count(*)
475: INTO l_num_records_updated
476: FROM ap_expense_feed_dists
477: WHERE manager_approval_id = l_new_manager_approval_id;
478:
479:
480: IF (l_num_records_updated > 0) THEN
725: BEGIN
726: SELECT distinct(nvl(fl.org_id,fd.org_id))
727: INTO l_org_id
728: FROM ap_expense_feed_lines_all fl,
729: ap_expense_feed_dists_all fd
730: WHERE fl.employee_verification_id = p_employee_verification_id
731: OR (fd.feed_line_id = fl.feed_line_id AND
732: fd.employee_verification_id = p_employee_verification_id);
733: if (l_org_id is not null) then
751: BEGIN
752:
753: SELECT distinct(org_id)
754: INTO l_org_id
755: FROM ap_expense_feed_dists_all fd
756: WHERE fd.manager_approval_id = p_manager_approval_id;
757:
758: if (l_org_id is not null) then
759: Mo_Global.set_policy_context('S', l_org_id);
857: -------------------------------------------
858: l_debug_info := 'Update Expense Feed Dists';
859: -------------------------------------------
860: BEGIN
861: UPDATE ap_expense_feed_dists
862: SET status_lookup_code = 'VERIFIED'
863: WHERE employee_verification_id = l_emp_verification_id
864: AND (status_lookup_code = l_status_lookup_code
865: OR l_status_lookup_code IS NULL);
914: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'ORG_ID',l_org_id);
915: BEGIN
916: --bug5058949
917: --Performance fix
918: UPDATE ap_expense_feed_dists fd
919: SET status_lookup_code = 'APPROVED'
920: WHERE employee_verification_id = l_emp_verification_id
921: AND status_lookup_code = 'VERIFIED'
922: AND exists (select 'no manager approval required'
991:
992:
993: SELECT count(*)
994: INTO l_num_dists_not_processed
995: FROM ap_expense_feed_dists
996: WHERE employee_verification_id = l_emp_verification_id
997: AND status_lookup_code = l_orig_status_lookup_code;
998:
999: IF (l_num_dists_not_processed > 0) THEN
1053: rpad(merchant_name,30),
1054: fl.amount,
1055: nvl(fl.posted_currency_code, cpr.card_program_currency_code),
1056: fd.description
1057: FROM ap_expense_feed_dists fd,
1058: ap_expense_feed_lines fl,
1059: ap_cards c,
1060: ap_card_profiles cp,
1061: ap_card_programs cpr,
1317: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'ORG_ID',l_org_id);
1318:
1319:
1320: BEGIN
1321: UPDATE ap_expense_feed_dists
1322: SET status_lookup_code = 'REJECTED'
1323: WHERE manager_approval_id = l_manager_approval_id;
1324: EXCEPTION
1325: WHEN OTHERS THEN
1374: Mo_Global.set_policy_context('S', l_org_id);
1375: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'ORG_ID',l_org_id);
1376:
1377: BEGIN
1378: UPDATE ap_expense_feed_dists
1379: SET status_lookup_code = 'APPROVED'
1380: WHERE manager_approval_id = l_manager_approval_id;
1381: EXCEPTION
1382: WHEN OTHERS THEN
1433: rpad(merchant_name,30),
1434: fl.amount,
1435: nvl(fl.posted_currency_code, cpr.card_program_currency_code),
1436: fd.description
1437: FROM ap_expense_feed_dists fd,
1438: ap_expense_feed_lines fl,
1439: ap_cards c,
1440: ap_card_profiles cp,
1441: ap_card_programs cpr,