179: i_adminurl, i_login, i_logout,
180: i_leadtime, i_srvrIdImmed, i_holidayfile,
181: i_fileSupport, i_activeStatus,
182: l_instrtype, i_securityscheme, i_partyid,
183: sysdate, fnd_global.user_id,
184: sysdate, fnd_global.user_id,
185: fnd_global.login_id, 1);
186:
187: close c_bepid;
180: i_leadtime, i_srvrIdImmed, i_holidayfile,
181: i_fileSupport, i_activeStatus,
182: l_instrtype, i_securityscheme, i_partyid,
183: sysdate, fnd_global.user_id,
184: sysdate, fnd_global.user_id,
185: fnd_global.login_id, 1);
186:
187: close c_bepid;
188:
181: i_fileSupport, i_activeStatus,
182: l_instrtype, i_securityscheme, i_partyid,
183: sysdate, fnd_global.user_id,
184: sysdate, fnd_global.user_id,
185: fnd_global.login_id, 1);
186:
187: close c_bepid;
188:
189: -- create pmt scheme info
496: instrtype = l_instrtype,
497: securityscheme = i_securityscheme,
498: party_id = i_partyid,
499: last_update_date = sysdate,
500: last_updated_by = fnd_global.user_id,
501: last_update_login = fnd_global.login_id,
502: object_version_number = object_version_number + 1
503: WHERE bepid = i_bepid
504: AND object_version_number = i_object_version;
497: securityscheme = i_securityscheme,
498: party_id = i_partyid,
499: last_update_date = sysdate,
500: last_updated_by = fnd_global.user_id,
501: last_update_login = fnd_global.login_id,
502: object_version_number = object_version_number + 1
503: WHERE bepid = i_bepid
504: AND object_version_number = i_object_version;
505:
659: -- instrtype = DECODE(p_instr_type, NULL, instrtype, FND_API.G_MISS_CHAR, NULL, p_instr_type),
660: securityscheme = DECODE(i_securityscheme, NULL, securityscheme, FND_API.G_MISS_NUM, NULL, i_securityscheme),
661: party_id = DECODE(i_partyid, NULL, party_id, FND_API.G_MISS_CHAR, NULL, i_partyid),
662: last_update_date = SYSDATE,
663: last_updated_by = fnd_global.user_id,
664: last_update_login = fnd_global.login_id,
665: object_version_number = object_version_number + 1
666: WHERE bepid = i_bepid
667: AND object_version_number = i_object_version;
660: securityscheme = DECODE(i_securityscheme, NULL, securityscheme, FND_API.G_MISS_NUM, NULL, i_securityscheme),
661: party_id = DECODE(i_partyid, NULL, party_id, FND_API.G_MISS_CHAR, NULL, i_partyid),
662: last_update_date = SYSDATE,
663: last_updated_by = fnd_global.user_id,
664: last_update_login = fnd_global.login_id,
665: object_version_number = object_version_number + 1
666: WHERE bepid = i_bepid
667: AND object_version_number = i_object_version;
668:
826:
827: UPDATE iby_bepinfo
828: SET activestatus = i_status,
829: last_update_date = sysdate,
830: last_updated_by = fnd_global.user_id,
831: last_update_login = fnd_global.login_id,
832: object_version_number = object_version_number + 1
833: WHERE bepid = i_bepid;
834: -- can't check object version here, as old API didn't ask for
827: UPDATE iby_bepinfo
828: SET activestatus = i_status,
829: last_update_date = sysdate,
830: last_updated_by = fnd_global.user_id,
831: last_update_login = fnd_global.login_id,
832: object_version_number = object_version_number + 1
833: WHERE bepid = i_bepid;
834: -- can't check object version here, as old API didn't ask for
835: -- object_version, simply increment it