DBA Data[Home] [Help]

APPS.IBY_DISBURSEMENT_SETUP_PUB dependencies on FND_GLOBAL

Line 73: fnd_global.user_id,

69: ext_payee_id,
70: ext_payee_rec.Payee_Party_Id,
71: ext_payee_rec.Payment_Function,
72: ext_payee_rec.Exclusive_Pay_Flag,
73: fnd_global.user_id,
74: trunc(sysdate),
75: fnd_global.user_id,
76: trunc(sysdate),
77: fnd_global.user_id,

Line 75: fnd_global.user_id,

71: ext_payee_rec.Payment_Function,
72: ext_payee_rec.Exclusive_Pay_Flag,
73: fnd_global.user_id,
74: trunc(sysdate),
75: fnd_global.user_id,
76: trunc(sysdate),
77: fnd_global.user_id,
78: 1.0,
79: ext_payee_rec.Payee_Party_Site_Id,

Line 77: fnd_global.user_id,

73: fnd_global.user_id,
74: trunc(sysdate),
75: fnd_global.user_id,
76: trunc(sysdate),
77: fnd_global.user_id,
78: 1.0,
79: ext_payee_rec.Payee_Party_Site_Id,
80: ext_payee_rec.Supplier_Site_Id,
81: ext_payee_rec.Payer_Org_Id,

Line 539: fnd_global.user_id,

535: 'DISBURSEMENTS',
536: l_ext_payee_id,
537: p_ext_payee_tab(counter).Payment_function,
538: 'Y',
539: fnd_global.user_id,
540: trunc(sysdate),
541: fnd_global.user_id,
542: trunc(sysdate),
543: fnd_global.user_id,

Line 541: fnd_global.user_id,

537: p_ext_payee_tab(counter).Payment_function,
538: 'Y',
539: fnd_global.user_id,
540: trunc(sysdate),
541: fnd_global.user_id,
542: trunc(sysdate),
543: fnd_global.user_id,
544: 1.0
545: );

Line 543: fnd_global.user_id,

539: fnd_global.user_id,
540: trunc(sysdate),
541: fnd_global.user_id,
542: trunc(sysdate),
543: fnd_global.user_id,
544: 1.0
545: );
546: end if;
547: end if;

Line 777: last_updated_by = fnd_global.user_id,

773: --Per bug 6851476
774: --Eleminating the expensive CONNECT BY clause
775: UPDATE iby_pmt_instr_uses_all
776: SET order_of_preference = order_of_preference + 1,
777: last_updated_by = fnd_global.user_id,
778: last_update_date = trunc(SYSDATE),
779: last_update_login = fnd_global.login_id,
780: object_version_number = object_version_number + 1
781: WHERE ext_pmt_party_id = l_payee_id

Line 779: last_update_login = fnd_global.login_id,

775: UPDATE iby_pmt_instr_uses_all
776: SET order_of_preference = order_of_preference + 1,
777: last_updated_by = fnd_global.user_id,
778: last_update_date = trunc(SYSDATE),
779: last_update_login = fnd_global.login_id,
780: object_version_number = object_version_number + 1
781: WHERE ext_pmt_party_id = l_payee_id
782: AND payment_flow = G_PMT_FLOW_DISBURSE
783: AND order_of_preference >= l_priority;

Line 823: fnd_global.user_id,

819: l_priority,
820: null, null, null, null, null,
821: NVL(p_assignment_attribs.Start_Date,SYSDATE),
822: p_assignment_attribs.End_Date,
823: fnd_global.user_id,
824: trunc(SYSDATE),
825: fnd_global.user_id,
826: trunc(SYSDATE),
827: fnd_global.login_id,

Line 825: fnd_global.user_id,

821: NVL(p_assignment_attribs.Start_Date,SYSDATE),
822: p_assignment_attribs.End_Date,
823: fnd_global.user_id,
824: trunc(SYSDATE),
825: fnd_global.user_id,
826: trunc(SYSDATE),
827: fnd_global.login_id,
828: 1);
829: ELSE

Line 827: fnd_global.login_id,

823: fnd_global.user_id,
824: trunc(SYSDATE),
825: fnd_global.user_id,
826: trunc(SYSDATE),
827: fnd_global.login_id,
828: 1);
829: ELSE
830: UPDATE iby_pmt_instr_uses_all
831: SET

Line 836: last_updated_by = fnd_global.user_id,

832: order_of_preference =
833: NVL(p_assignment_attribs.Priority,order_of_preference),
834: start_date = NVL(p_assignment_attribs.Start_Date,start_date),
835: end_date = p_assignment_attribs.End_Date,
836: last_updated_by = fnd_global.user_id,
837: last_update_date = trunc(SYSDATE),
838: last_update_login = fnd_global.login_id,
839: object_version_number = object_version_number + 1
840: WHERE instrument_payment_use_id = x_assign_id;

Line 838: last_update_login = fnd_global.login_id,

834: start_date = NVL(p_assignment_attribs.Start_Date,start_date),
835: end_date = p_assignment_attribs.End_Date,
836: last_updated_by = fnd_global.user_id,
837: last_update_date = trunc(SYSDATE),
838: last_update_login = fnd_global.login_id,
839: object_version_number = object_version_number + 1
840: WHERE instrument_payment_use_id = x_assign_id;
841: END IF;
842:

Line 2375: last_updated_by = fnd_global.user_id,

2371: ELSE
2372: -- update external payee
2373: UPDATE iby_external_payees_all
2374: SET exclusive_payment_flag = p_ext_payee_tab(counter).exclusive_pay_flag,
2375: last_updated_by = fnd_global.user_id,
2376: last_update_date = trunc(sysdate),
2377: last_update_login = fnd_global.user_id,
2378: object_version_number = object_version_number+1,
2379: default_payment_method_code = p_ext_payee_tab(counter).Default_Pmt_method,

Line 2377: last_update_login = fnd_global.user_id,

2373: UPDATE iby_external_payees_all
2374: SET exclusive_payment_flag = p_ext_payee_tab(counter).exclusive_pay_flag,
2375: last_updated_by = fnd_global.user_id,
2376: last_update_date = trunc(sysdate),
2377: last_update_login = fnd_global.user_id,
2378: object_version_number = object_version_number+1,
2379: default_payment_method_code = p_ext_payee_tab(counter).Default_Pmt_method,
2380: ece_tp_location_code = p_ext_payee_tab(counter).ece_tp_loc_code,
2381: bank_charge_bearer = p_ext_payee_tab(counter).Bank_Charge_Bearer,

Line 2402: last_updated_by = fnd_global.user_id,

2398: BEGIN
2399: UPDATE iby_ext_party_pmt_mthds
2400: SET primary_flag = 'N',
2401: last_update_date = trunc(sysdate),
2402: last_updated_by = fnd_global.user_id,
2403: last_update_login = fnd_global.user_id,
2404: object_version_number = object_version_number+1
2405: WHERE ext_pmt_party_id = p_ext_payee_id_tab(counter).ext_payee_id
2406: AND payment_function = p_ext_payee_tab(counter).payment_function

Line 2403: last_update_login = fnd_global.user_id,

2399: UPDATE iby_ext_party_pmt_mthds
2400: SET primary_flag = 'N',
2401: last_update_date = trunc(sysdate),
2402: last_updated_by = fnd_global.user_id,
2403: last_update_login = fnd_global.user_id,
2404: object_version_number = object_version_number+1
2405: WHERE ext_pmt_party_id = p_ext_payee_id_tab(counter).ext_payee_id
2406: AND payment_function = p_ext_payee_tab(counter).payment_function
2407: AND primary_flag = 'Y';

Line 2451: fnd_global.user_id,

2447: 'DISBURSEMENTS',
2448: p_ext_payee_id_tab(counter).ext_payee_id,
2449: p_ext_payee_tab(counter).Payment_function,
2450: 'Y',
2451: fnd_global.user_id,
2452: trunc(sysdate),
2453: fnd_global.user_id,
2454: trunc(sysdate),
2455: fnd_global.user_id,

Line 2453: fnd_global.user_id,

2449: p_ext_payee_tab(counter).Payment_function,
2450: 'Y',
2451: fnd_global.user_id,
2452: trunc(sysdate),
2453: fnd_global.user_id,
2454: trunc(sysdate),
2455: fnd_global.user_id,
2456: 1.0
2457: );

Line 2455: fnd_global.user_id,

2451: fnd_global.user_id,
2452: trunc(sysdate),
2453: fnd_global.user_id,
2454: trunc(sysdate),
2455: fnd_global.user_id,
2456: 1.0
2457: );
2458:
2459: END;

Line 2467: last_updated_by = fnd_global.user_id,

2463: UPDATE iby_ext_party_pmt_mthds
2464: SET primary_flag = DECODE(payment_method_code,
2465: p_ext_payee_tab(counter).Default_Pmt_method, 'Y', 'N'),
2466: last_update_date = trunc(sysdate),
2467: last_updated_by = fnd_global.user_id,
2468: last_update_login = fnd_global.user_id,
2469: object_version_number = object_version_number+1
2470: WHERE ext_pmt_party_id = p_ext_payee_id_tab(counter).ext_payee_id
2471: AND payment_function = p_ext_payee_tab(counter).payment_function;

Line 2468: last_update_login = fnd_global.user_id,

2464: SET primary_flag = DECODE(payment_method_code,
2465: p_ext_payee_tab(counter).Default_Pmt_method, 'Y', 'N'),
2466: last_update_date = trunc(sysdate),
2467: last_updated_by = fnd_global.user_id,
2468: last_update_login = fnd_global.user_id,
2469: object_version_number = object_version_number+1
2470: WHERE ext_pmt_party_id = p_ext_payee_id_tab(counter).ext_payee_id
2471: AND payment_function = p_ext_payee_tab(counter).payment_function;
2472: EXCEPTION