DBA Data[Home] [Help]

APPS.IBY_DISBURSEMENT_SETUP_PUB dependencies on FND_GLOBAL

Line 136: fnd_global.user_id,

132: ext_payee_id,
133: ext_payee_rec.Payee_Party_Id,
134: ext_payee_rec.Payment_Function,
135: ext_payee_rec.Exclusive_Pay_Flag,
136: fnd_global.user_id,
137: SYSDATE, -- bug 13881024
138: fnd_global.user_id,
139: SYSDATE,
140: fnd_global.user_id,

Line 138: fnd_global.user_id,

134: ext_payee_rec.Payment_Function,
135: ext_payee_rec.Exclusive_Pay_Flag,
136: fnd_global.user_id,
137: SYSDATE, -- bug 13881024
138: fnd_global.user_id,
139: SYSDATE,
140: fnd_global.user_id,
141: 1.0,
142: ext_payee_rec.Payee_Party_Site_Id,

Line 140: fnd_global.user_id,

136: fnd_global.user_id,
137: SYSDATE, -- bug 13881024
138: fnd_global.user_id,
139: SYSDATE,
140: fnd_global.user_id,
141: 1.0,
142: ext_payee_rec.Payee_Party_Site_Id,
143: ext_payee_rec.Supplier_Site_Id,
144: ext_payee_rec.Payer_Org_Id,

Line 706: fnd_global.user_id,

702: 'DISBURSEMENTS',
703: l_ext_payee_id,
704: p_ext_payee_tab(counter).Payment_function,
705: 'Y',
706: fnd_global.user_id,
707: SYSDATE, -- bug 13881024
708: fnd_global.user_id,
709: SYSDATE,
710: fnd_global.user_id,

Line 708: fnd_global.user_id,

704: p_ext_payee_tab(counter).Payment_function,
705: 'Y',
706: fnd_global.user_id,
707: SYSDATE, -- bug 13881024
708: fnd_global.user_id,
709: SYSDATE,
710: fnd_global.user_id,
711: 1.0
712: );

Line 710: fnd_global.user_id,

706: fnd_global.user_id,
707: SYSDATE, -- bug 13881024
708: fnd_global.user_id,
709: SYSDATE,
710: fnd_global.user_id,
711: 1.0
712: );
713: end if;
714: end if;

Line 1008: last_updated_by = fnd_global.user_id,

1004: --Per bug 6851476
1005: --Eleminating the expensive CONNECT BY clause
1006: UPDATE iby_pmt_instr_uses_all
1007: SET order_of_preference = order_of_preference + 1,
1008: last_updated_by = fnd_global.user_id,
1009: last_update_date = SYSDATE,
1010: last_update_login = fnd_global.login_id,
1011: object_version_number = object_version_number + 1
1012: WHERE ext_pmt_party_id = l_payee_id

Line 1010: last_update_login = fnd_global.login_id,

1006: UPDATE iby_pmt_instr_uses_all
1007: SET order_of_preference = order_of_preference + 1,
1008: last_updated_by = fnd_global.user_id,
1009: last_update_date = SYSDATE,
1010: last_update_login = fnd_global.login_id,
1011: object_version_number = object_version_number + 1
1012: WHERE ext_pmt_party_id = l_payee_id
1013: AND payment_flow = G_PMT_FLOW_DISBURSE
1014: AND order_of_preference >= l_priority;

Line 1022: last_updated_by = fnd_global.user_id,

1018: IF(p_assignment_attribs.Priority IS NOT NULL) THEN --Bug 13827657
1019: IF(l_cur_op > l_giv_op) THEN
1020: UPDATE iby_pmt_instr_uses_all
1021: SET order_of_preference = order_of_preference + 1,
1022: last_updated_by = fnd_global.user_id,
1023: last_update_date = SYSDATE,
1024: last_update_login = fnd_global.login_id
1025: WHERE ext_pmt_party_id = l_payee_id
1026: AND payment_flow = G_PMT_FLOW_DISBURSE

Line 1024: last_update_login = fnd_global.login_id

1020: UPDATE iby_pmt_instr_uses_all
1021: SET order_of_preference = order_of_preference + 1,
1022: last_updated_by = fnd_global.user_id,
1023: last_update_date = SYSDATE,
1024: last_update_login = fnd_global.login_id
1025: WHERE ext_pmt_party_id = l_payee_id
1026: AND payment_flow = G_PMT_FLOW_DISBURSE
1027: AND order_of_preference < l_cur_op
1028: AND order_of_preference >= l_giv_op ;

Line 1032: last_updated_by = fnd_global.user_id,

1028: AND order_of_preference >= l_giv_op ;
1029: ELSIF(l_cur_op < l_giv_op) THEN
1030: UPDATE iby_pmt_instr_uses_all
1031: SET order_of_preference = order_of_preference - 1,
1032: last_updated_by = fnd_global.user_id,
1033: last_update_date = SYSDATE,
1034: last_update_login = fnd_global.login_id
1035: WHERE ext_pmt_party_id = l_payee_id
1036: AND payment_flow = G_PMT_FLOW_DISBURSE

Line 1034: last_update_login = fnd_global.login_id

1030: UPDATE iby_pmt_instr_uses_all
1031: SET order_of_preference = order_of_preference - 1,
1032: last_updated_by = fnd_global.user_id,
1033: last_update_date = SYSDATE,
1034: last_update_login = fnd_global.login_id
1035: WHERE ext_pmt_party_id = l_payee_id
1036: AND payment_flow = G_PMT_FLOW_DISBURSE
1037: AND order_of_preference > l_cur_op
1038: AND order_of_preference <= l_giv_op ;

Line 1080: fnd_global.user_id,

1076: l_priority,
1077: null, null, null, null, null,
1078: NVL(p_assignment_attribs.Start_Date,SYSDATE),
1079: p_assignment_attribs.End_Date,
1080: fnd_global.user_id,
1081: SYSDATE, -- bug 13881024
1082: fnd_global.user_id,
1083: SYSDATE,
1084: fnd_global.login_id,

Line 1082: fnd_global.user_id,

1078: NVL(p_assignment_attribs.Start_Date,SYSDATE),
1079: p_assignment_attribs.End_Date,
1080: fnd_global.user_id,
1081: SYSDATE, -- bug 13881024
1082: fnd_global.user_id,
1083: SYSDATE,
1084: fnd_global.login_id,
1085: 1);
1086: ELSE

Line 1084: fnd_global.login_id,

1080: fnd_global.user_id,
1081: SYSDATE, -- bug 13881024
1082: fnd_global.user_id,
1083: SYSDATE,
1084: fnd_global.login_id,
1085: 1);
1086: ELSE
1087: UPDATE iby_pmt_instr_uses_all
1088: SET

Line 1093: last_updated_by = fnd_global.user_id,

1089: order_of_preference =
1090: NVL(p_assignment_attribs.Priority,order_of_preference),
1091: start_date = NVL(p_assignment_attribs.Start_Date,start_date),
1092: end_date = p_assignment_attribs.End_Date,
1093: last_updated_by = fnd_global.user_id,
1094: last_update_date = SYSDATE,
1095: last_update_login = fnd_global.login_id,
1096: object_version_number = object_version_number + 1
1097: WHERE instrument_payment_use_id = x_assign_id;

Line 1095: last_update_login = fnd_global.login_id,

1091: start_date = NVL(p_assignment_attribs.Start_Date,start_date),
1092: end_date = p_assignment_attribs.End_Date,
1093: last_updated_by = fnd_global.user_id,
1094: last_update_date = SYSDATE,
1095: last_update_login = fnd_global.login_id,
1096: object_version_number = object_version_number + 1
1097: WHERE instrument_payment_use_id = x_assign_id;
1098: END IF;
1099:

Line 2905: last_updated_by = fnd_global.user_id,

2901: ELSE
2902: -- update external payee
2903: UPDATE iby_external_payees_all
2904: SET exclusive_payment_flag = p_ext_payee_tab(counter).exclusive_pay_flag,
2905: last_updated_by = fnd_global.user_id,
2906: last_update_date = SYSDATE, -- bug 13881024
2907: last_update_login = fnd_global.user_id,
2908: object_version_number = object_version_number+1,
2909: default_payment_method_code = p_ext_payee_tab(counter).Default_Pmt_method,

Line 2907: last_update_login = fnd_global.user_id,

2903: UPDATE iby_external_payees_all
2904: SET exclusive_payment_flag = p_ext_payee_tab(counter).exclusive_pay_flag,
2905: last_updated_by = fnd_global.user_id,
2906: last_update_date = SYSDATE, -- bug 13881024
2907: last_update_login = fnd_global.user_id,
2908: object_version_number = object_version_number+1,
2909: default_payment_method_code = p_ext_payee_tab(counter).Default_Pmt_method,
2910: ece_tp_location_code = p_ext_payee_tab(counter).ece_tp_loc_code,
2911: bank_charge_bearer = p_ext_payee_tab(counter).Bank_Charge_Bearer,

Line 2935: last_updated_by = fnd_global.user_id,

2931: BEGIN
2932: UPDATE iby_ext_party_pmt_mthds
2933: SET primary_flag = 'N',
2934: last_update_date = SYSDATE,
2935: last_updated_by = fnd_global.user_id,
2936: last_update_login = fnd_global.user_id,
2937: object_version_number = object_version_number+1
2938: WHERE ext_pmt_party_id = p_ext_payee_id_tab(counter).ext_payee_id
2939: AND payment_function = p_ext_payee_tab(counter).payment_function

Line 2936: last_update_login = fnd_global.user_id,

2932: UPDATE iby_ext_party_pmt_mthds
2933: SET primary_flag = 'N',
2934: last_update_date = SYSDATE,
2935: last_updated_by = fnd_global.user_id,
2936: last_update_login = fnd_global.user_id,
2937: object_version_number = object_version_number+1
2938: WHERE ext_pmt_party_id = p_ext_payee_id_tab(counter).ext_payee_id
2939: AND payment_function = p_ext_payee_tab(counter).payment_function
2940: AND primary_flag = 'Y';

Line 2984: fnd_global.user_id,

2980: 'DISBURSEMENTS',
2981: p_ext_payee_id_tab(counter).ext_payee_id,
2982: p_ext_payee_tab(counter).Payment_function,
2983: 'Y',
2984: fnd_global.user_id,
2985: SYSDATE, -- bug 13881024
2986: fnd_global.user_id,
2987: SYSDATE,
2988: fnd_global.user_id,

Line 2986: fnd_global.user_id,

2982: p_ext_payee_tab(counter).Payment_function,
2983: 'Y',
2984: fnd_global.user_id,
2985: SYSDATE, -- bug 13881024
2986: fnd_global.user_id,
2987: SYSDATE,
2988: fnd_global.user_id,
2989: 1.0
2990: );

Line 2988: fnd_global.user_id,

2984: fnd_global.user_id,
2985: SYSDATE, -- bug 13881024
2986: fnd_global.user_id,
2987: SYSDATE,
2988: fnd_global.user_id,
2989: 1.0
2990: );
2991:
2992: END;

Line 3000: last_updated_by = fnd_global.user_id,

2996: UPDATE iby_ext_party_pmt_mthds
2997: SET primary_flag = DECODE(payment_method_code,
2998: p_ext_payee_tab(counter).Default_Pmt_method, 'Y', 'N'),
2999: last_update_date = SYSDATE, -- bug 13881024
3000: last_updated_by = fnd_global.user_id,
3001: last_update_login = fnd_global.user_id,
3002: object_version_number = object_version_number+1
3003: WHERE ext_pmt_party_id = p_ext_payee_id_tab(counter).ext_payee_id
3004: AND payment_function = p_ext_payee_tab(counter).payment_function;

Line 3001: last_update_login = fnd_global.user_id,

2997: SET primary_flag = DECODE(payment_method_code,
2998: p_ext_payee_tab(counter).Default_Pmt_method, 'Y', 'N'),
2999: last_update_date = SYSDATE, -- bug 13881024
3000: last_updated_by = fnd_global.user_id,
3001: last_update_login = fnd_global.user_id,
3002: object_version_number = object_version_number+1
3003: WHERE ext_pmt_party_id = p_ext_payee_id_tab(counter).ext_payee_id
3004: AND payment_function = p_ext_payee_tab(counter).payment_function;
3005: EXCEPTION