DBA Data[Home] [Help]

APPS.IBY_FNDCPT_SETUP_PUB dependencies on FND_GLOBAL

Line 288: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,

284: p_payer.Party_Id, p_payer.Org_Type, p_payer.Org_Id,
285: p_payer.Cust_Account_Id, p_payer.Account_Site_Id,
286: p_payer_attributes.Bank_Charge_Bearer,
287: p_payer_attributes.DirectDebit_BankInstruction,
288: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
289: fnd_global.login_id, 1
290: );
291: ELSIF (NOT (p_payer_attributes.DirectDebit_BankInstruction IS NULL)
292: AND (p_payer_attributes.Bank_Charge_Bearer IS NULL)

Line 289: fnd_global.login_id, 1

285: p_payer.Cust_Account_Id, p_payer.Account_Site_Id,
286: p_payer_attributes.Bank_Charge_Bearer,
287: p_payer_attributes.DirectDebit_BankInstruction,
288: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
289: fnd_global.login_id, 1
290: );
291: ELSIF (NOT (p_payer_attributes.DirectDebit_BankInstruction IS NULL)
292: AND (p_payer_attributes.Bank_Charge_Bearer IS NULL)
293: )

Line 304: last_updated_by = fnd_global.user_id,

300: FND_API.G_MISS_CHAR,NULL, dirdeb_instruction_code),
301: bank_charge_bearer_code =
302: DECODE(p_payer_attributes.Bank_Charge_Bearer,
303: FND_API.G_MISS_CHAR,NULL, bank_charge_bearer_code),
304: last_updated_by = fnd_global.user_id,
305: last_update_date = SYSDATE,
306: last_update_login = fnd_global.login_id,
307: object_version_number = object_version_number + 1
308: WHERE (ext_payer_id = x_payer_attribs_id);

Line 306: last_update_login = fnd_global.login_id,

302: DECODE(p_payer_attributes.Bank_Charge_Bearer,
303: FND_API.G_MISS_CHAR,NULL, bank_charge_bearer_code),
304: last_updated_by = fnd_global.user_id,
305: last_update_date = SYSDATE,
306: last_update_login = fnd_global.login_id,
307: object_version_number = object_version_number + 1
308: WHERE (ext_payer_id = x_payer_attribs_id);
309: END IF;
310:

Line 694: p_channel_assignment.Inactive_Date, fnd_global.user_id, SYSDATE,

690: last_update_login, object_version_number)
691: VALUES
692: (x_assignment_id, p_channel_assignment.Pmt_Channel_Code,
693: G_PMT_FLOW_FNDCPT, l_payer_id, p_payer.Payment_Function, 'Y',
694: p_channel_assignment.Inactive_Date, fnd_global.user_id, SYSDATE,
695: fnd_global.user_id, SYSDATE, fnd_global.login_id, 1);
696:
697: ELSE
698:

Line 695: fnd_global.user_id, SYSDATE, fnd_global.login_id, 1);

691: VALUES
692: (x_assignment_id, p_channel_assignment.Pmt_Channel_Code,
693: G_PMT_FLOW_FNDCPT, l_payer_id, p_payer.Payment_Function, 'Y',
694: p_channel_assignment.Inactive_Date, fnd_global.user_id, SYSDATE,
695: fnd_global.user_id, SYSDATE, fnd_global.login_id, 1);
696:
697: ELSE
698:
699: UPDATE iby_ext_party_pmt_mthds

Line 703: last_updated_by = fnd_global.user_id,

699: UPDATE iby_ext_party_pmt_mthds
700: SET inactive_date = p_channel_assignment.Inactive_Date,
701: payment_method_code =
702: NVL(p_channel_assignment.Pmt_Channel_code,payment_method_code),
703: last_updated_by = fnd_global.user_id,
704: last_update_date = SYSDATE,
705: last_update_login = fnd_global.login_id,
706: object_version_number = object_version_number + 1
707: WHERE ext_party_pmt_mthd_id = x_assignment_id;

Line 705: last_update_login = fnd_global.login_id,

701: payment_method_code =
702: NVL(p_channel_assignment.Pmt_Channel_code,payment_method_code),
703: last_updated_by = fnd_global.user_id,
704: last_update_date = SYSDATE,
705: last_update_login = fnd_global.login_id,
706: object_version_number = object_version_number + 1
707: WHERE ext_party_pmt_mthd_id = x_assignment_id;
708:
709: END IF;

Line 1159: last_updated_by = fnd_global.user_id,

1155: THEN
1156:
1157: UPDATE iby_pmt_instr_uses_all
1158: SET order_of_preference = order_of_preference + 1,
1159: last_updated_by = fnd_global.user_id,
1160: last_update_date = SYSDATE,
1161: last_update_login = fnd_global.login_id,
1162: object_version_number = object_version_number + 1
1163: WHERE instrument_payment_use_id IN

Line 1161: last_update_login = fnd_global.login_id,

1157: UPDATE iby_pmt_instr_uses_all
1158: SET order_of_preference = order_of_preference + 1,
1159: last_updated_by = fnd_global.user_id,
1160: last_update_date = SYSDATE,
1161: last_update_login = fnd_global.login_id,
1162: object_version_number = object_version_number + 1
1163: WHERE instrument_payment_use_id IN
1164: (
1165: SELECT instrument_payment_use_id

Line 1201: fnd_global.user_id, SYSDATE, fnd_global.user_id, l_last_update,

1197: p_payer.Payment_Function, G_PMT_FLOW_FNDCPT, l_priority,
1198: null, null, null, null, null,
1199: NVL(p_assignment_attribs.Start_Date,SYSDATE),
1200: p_assignment_attribs.End_Date,
1201: fnd_global.user_id, SYSDATE, fnd_global.user_id, l_last_update,
1202: fnd_global.login_id, 1);
1203:
1204: l_op_type := 'I';
1205: ELSE

Line 1202: fnd_global.login_id, 1);

1198: null, null, null, null, null,
1199: NVL(p_assignment_attribs.Start_Date,SYSDATE),
1200: p_assignment_attribs.End_Date,
1201: fnd_global.user_id, SYSDATE, fnd_global.user_id, l_last_update,
1202: fnd_global.login_id, 1);
1203:
1204: l_op_type := 'I';
1205: ELSE
1206: UPDATE iby_pmt_instr_uses_all

Line 1212: last_updated_by = fnd_global.user_id,

1208: order_of_preference =
1209: NVL(p_assignment_attribs.Priority,order_of_preference),
1210: start_date = NVL(p_assignment_attribs.Start_Date,start_date),
1211: end_date = p_assignment_attribs.End_Date,
1212: last_updated_by = fnd_global.user_id,
1213: last_update_date = l_last_update,
1214: last_update_login = fnd_global.login_id,
1215: object_version_number = object_version_number + 1
1216: WHERE instrument_payment_use_id = x_assign_id;

Line 1214: last_update_login = fnd_global.login_id,

1210: start_date = NVL(p_assignment_attribs.Start_Date,start_date),
1211: end_date = p_assignment_attribs.End_Date,
1212: last_updated_by = fnd_global.user_id,
1213: last_update_date = l_last_update,
1214: last_update_login = fnd_global.login_id,
1215: object_version_number = object_version_number + 1
1216: WHERE instrument_payment_use_id = x_assign_id;
1217:
1218: l_op_type := 'U';