eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.CSI_ITEM_INSTANCE_PVT dependencies on FND_GLOBAL

Line 6044: ,p_CREATED_BY => FND_GLOBAL.USER_ID

6040: ,p_ATTRIBUTE12 => p_instance_rec.ATTRIBUTE12
6041: ,p_ATTRIBUTE13 => p_instance_rec.ATTRIBUTE13
6042: ,p_ATTRIBUTE14 => p_instance_rec.ATTRIBUTE14
6043: ,p_ATTRIBUTE15 => p_instance_rec.ATTRIBUTE15
6044: ,p_CREATED_BY => FND_GLOBAL.USER_ID
6045: ,p_CREATION_DATE => SYSDATE
6046: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
6047: ,p_LAST_UPDATE_DATE => SYSDATE
6048: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

Line 6046: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

6042: ,p_ATTRIBUTE14 => p_instance_rec.ATTRIBUTE14
6043: ,p_ATTRIBUTE15 => p_instance_rec.ATTRIBUTE15
6044: ,p_CREATED_BY => FND_GLOBAL.USER_ID
6045: ,p_CREATION_DATE => SYSDATE
6046: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
6047: ,p_LAST_UPDATE_DATE => SYSDATE
6048: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
6049: ,p_OBJECT_VERSION_NUMBER => 1
6050: ,p_LAST_TXN_LINE_DETAIL_ID => p_instance_rec.LAST_TXN_LINE_DETAIL_ID

Line 6048: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

6044: ,p_CREATED_BY => FND_GLOBAL.USER_ID
6045: ,p_CREATION_DATE => SYSDATE
6046: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
6047: ,p_LAST_UPDATE_DATE => SYSDATE
6048: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
6049: ,p_OBJECT_VERSION_NUMBER => 1
6050: ,p_LAST_TXN_LINE_DETAIL_ID => p_instance_rec.LAST_TXN_LINE_DETAIL_ID
6051: ,p_INSTALL_LOCATION_TYPE_CODE => p_instance_rec.INSTALL_LOCATION_TYPE_CODE
6052: ,p_INSTALL_LOCATION_ID => p_instance_rec.INSTALL_LOCATION_ID

Line 6381: ,p_CREATED_BY => FND_GLOBAL.USER_ID

6377: ,p_NEW_ATTRIBUTE14 => p_instance_rec.ATTRIBUTE14
6378: ,p_OLD_ATTRIBUTE14 => NULL
6379: ,p_NEW_ATTRIBUTE15 => p_instance_rec.ATTRIBUTE15
6380: ,p_OLD_ATTRIBUTE15 => NULL
6381: ,p_CREATED_BY => FND_GLOBAL.USER_ID
6382: ,p_CREATION_DATE => SYSDATE
6383: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
6384: ,p_LAST_UPDATE_DATE => SYSDATE
6385: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

Line 6383: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

6379: ,p_NEW_ATTRIBUTE15 => p_instance_rec.ATTRIBUTE15
6380: ,p_OLD_ATTRIBUTE15 => NULL
6381: ,p_CREATED_BY => FND_GLOBAL.USER_ID
6382: ,p_CREATION_DATE => SYSDATE
6383: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
6384: ,p_LAST_UPDATE_DATE => SYSDATE
6385: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
6386: ,p_OBJECT_VERSION_NUMBER => 1
6387: ,p_OLD_INST_LOC_TYPE_CODE => NULL

Line 6385: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

6381: ,p_CREATED_BY => FND_GLOBAL.USER_ID
6382: ,p_CREATION_DATE => SYSDATE
6383: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
6384: ,p_LAST_UPDATE_DATE => SYSDATE
6385: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
6386: ,p_OBJECT_VERSION_NUMBER => 1
6387: ,p_OLD_INST_LOC_TYPE_CODE => NULL
6388: ,p_NEW_INST_LOC_TYPE_CODE => p_instance_rec.INSTALL_LOCATION_TYPE_CODE
6389: ,p_OLD_INST_LOC_ID => NULL

Line 7036: l_user_id NUMBER := FND_GLOBAL.USER_ID;

7032: --Start of:Added for bug 5615169
7033: l_inst_hist_tbl_blk_ins csi_datastructures_pub.instance_history_tbl; -- used for bulk insert
7034: l_inst_hist_rec_tab csi_item_instance_grp.instance_history_rec_tab; -- used for column table
7035: l_ciih_blk_ins_cnt NUMBER := 0;
7036: l_user_id NUMBER := FND_GLOBAL.USER_ID;
7037: l_login_id NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
7038: --End of:Added for bug 5615169
7039:
7040: CURSOR curr_instance_rec(p_instance_id IN NUMBER) IS

Line 7037: l_login_id NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

7033: l_inst_hist_tbl_blk_ins csi_datastructures_pub.instance_history_tbl; -- used for bulk insert
7034: l_inst_hist_rec_tab csi_item_instance_grp.instance_history_rec_tab; -- used for column table
7035: l_ciih_blk_ins_cnt NUMBER := 0;
7036: l_user_id NUMBER := FND_GLOBAL.USER_ID;
7037: l_login_id NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
7038: --End of:Added for bug 5615169
7039:
7040: CURSOR curr_instance_rec(p_instance_id IN NUMBER) IS
7041: SELECT

Line 7722: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

7718: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
7719: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
7720: p_CREATED_BY => fnd_api.g_miss_num,
7721: p_CREATION_DATE => fnd_api.g_miss_date,
7722: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
7723: p_LAST_UPDATE_DATE => SYSDATE,
7724: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
7725: p_OBJECT_VERSION_NUMBER => p_instance_rec.OBJECT_VERSION_NUMBER,
7726: p_LAST_TXN_LINE_DETAIL_ID => FND_API.G_MISS_NUM,

Line 7724: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,

7720: p_CREATED_BY => fnd_api.g_miss_num,
7721: p_CREATION_DATE => fnd_api.g_miss_date,
7722: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
7723: p_LAST_UPDATE_DATE => SYSDATE,
7724: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
7725: p_OBJECT_VERSION_NUMBER => p_instance_rec.OBJECT_VERSION_NUMBER,
7726: p_LAST_TXN_LINE_DETAIL_ID => FND_API.G_MISS_NUM,
7727: p_INSTALL_LOCATION_TYPE_CODE => p_instance_rec.INSTALL_LOCATION_TYPE_CODE,
7728: p_INSTALL_LOCATION_ID => p_instance_rec.INSTALL_LOCATION_ID,

Line 7917: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

7913: ,p_NEW_ATTRIBUTE15 => fnd_api.g_miss_char
7914: ,p_OLD_ATTRIBUTE15 => fnd_api.g_miss_char
7915: ,p_CREATED_BY => fnd_api.g_miss_num
7916: ,p_CREATION_DATE => fnd_api.g_miss_date
7917: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
7918: ,p_LAST_UPDATE_DATE => SYSDATE
7919: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
7920: ,p_OBJECT_VERSION_NUMBER => fnd_api.g_miss_num
7921: ,p_OLD_INST_LOC_TYPE_CODE => fnd_api.g_miss_char

Line 7919: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

7915: ,p_CREATED_BY => fnd_api.g_miss_num
7916: ,p_CREATION_DATE => fnd_api.g_miss_date
7917: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
7918: ,p_LAST_UPDATE_DATE => SYSDATE
7919: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
7920: ,p_OBJECT_VERSION_NUMBER => fnd_api.g_miss_num
7921: ,p_OLD_INST_LOC_TYPE_CODE => fnd_api.g_miss_char
7922: ,p_NEW_INST_LOC_TYPE_CODE => p_instance_rec.INSTALL_LOCATION_TYPE_CODE
7923: ,p_OLD_INST_LOC_ID => fnd_api.g_miss_num

Line 8545: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

8541: ,p_NEW_ATTRIBUTE15 => fnd_api.g_miss_char
8542: ,p_OLD_ATTRIBUTE15 => fnd_api.g_miss_char
8543: ,p_CREATED_BY => fnd_api.g_miss_num
8544: ,p_CREATION_DATE => fnd_api.g_miss_date
8545: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
8546: ,p_LAST_UPDATE_DATE => SYSDATE
8547: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
8548: ,p_OBJECT_VERSION_NUMBER => fnd_api.g_miss_num
8549: ,p_OLD_INST_LOC_TYPE_CODE => l_ins_hist_csr.OLD_INST_LOC_TYPE_CODE

Line 8547: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

8543: ,p_CREATED_BY => fnd_api.g_miss_num
8544: ,p_CREATION_DATE => fnd_api.g_miss_date
8545: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
8546: ,p_LAST_UPDATE_DATE => SYSDATE
8547: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
8548: ,p_OBJECT_VERSION_NUMBER => fnd_api.g_miss_num
8549: ,p_OLD_INST_LOC_TYPE_CODE => l_ins_hist_csr.OLD_INST_LOC_TYPE_CODE
8550: ,p_NEW_INST_LOC_TYPE_CODE => l_ins_hist_csr.NEW_INST_LOC_TYPE_CODE
8551: ,p_OLD_INST_LOC_ID => l_ins_hist_csr.OLD_INST_LOC_ID

Line 8938: ,p_CREATED_BY => FND_GLOBAL.USER_ID

8934: ,p_NEW_ATTRIBUTE14 => p_instance_rec.ATTRIBUTE14
8935: ,p_OLD_ATTRIBUTE14 => l_curr_instance_rec.ATTRIBUTE14
8936: ,p_NEW_ATTRIBUTE15 => p_instance_rec.ATTRIBUTE15
8937: ,p_OLD_ATTRIBUTE15 => l_curr_instance_rec.ATTRIBUTE15
8938: ,p_CREATED_BY => FND_GLOBAL.USER_ID
8939: ,p_CREATION_DATE => SYSDATE
8940: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
8941: ,p_LAST_UPDATE_DATE => SYSDATE
8942: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

Line 8940: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

8936: ,p_NEW_ATTRIBUTE15 => p_instance_rec.ATTRIBUTE15
8937: ,p_OLD_ATTRIBUTE15 => l_curr_instance_rec.ATTRIBUTE15
8938: ,p_CREATED_BY => FND_GLOBAL.USER_ID
8939: ,p_CREATION_DATE => SYSDATE
8940: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
8941: ,p_LAST_UPDATE_DATE => SYSDATE
8942: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
8943: ,p_OBJECT_VERSION_NUMBER => 1
8944: ,p_OLD_INST_LOC_TYPE_CODE => l_curr_instance_rec.INSTALL_LOCATION_TYPE_CODE

Line 8942: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

8938: ,p_CREATED_BY => FND_GLOBAL.USER_ID
8939: ,p_CREATION_DATE => SYSDATE
8940: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
8941: ,p_LAST_UPDATE_DATE => SYSDATE
8942: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
8943: ,p_OBJECT_VERSION_NUMBER => 1
8944: ,p_OLD_INST_LOC_TYPE_CODE => l_curr_instance_rec.INSTALL_LOCATION_TYPE_CODE
8945: ,p_NEW_INST_LOC_TYPE_CODE => p_instance_rec.INSTALL_LOCATION_TYPE_CODE
8946: ,p_OLD_INST_LOC_ID => l_curr_instance_rec.INSTALL_LOCATION_ID

Line 9156: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).created_by := FND_GLOBAL.USER_ID;

9152: l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).new_attribute14 := p_instance_rec.ATTRIBUTE14;
9153: l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).old_attribute14 := l_curr_instance_rec.ATTRIBUTE14;
9154: l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).new_attribute15 := p_instance_rec.ATTRIBUTE15;
9155: l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).old_attribute15 := l_curr_instance_rec.ATTRIBUTE15;
9156: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).created_by := FND_GLOBAL.USER_ID;
9157: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).creation_date := SYSDATE;
9158: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).last_updated_by := FND_GLOBAL.USER_ID;
9159: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).last_update_date := SYSDATE;
9160: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).last_update_login := FND_GLOBAL.CONC_LOGIN_ID;

Line 9158: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).last_updated_by := FND_GLOBAL.USER_ID;

9154: l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).new_attribute15 := p_instance_rec.ATTRIBUTE15;
9155: l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).old_attribute15 := l_curr_instance_rec.ATTRIBUTE15;
9156: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).created_by := FND_GLOBAL.USER_ID;
9157: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).creation_date := SYSDATE;
9158: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).last_updated_by := FND_GLOBAL.USER_ID;
9159: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).last_update_date := SYSDATE;
9160: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
9161: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).object_version_number := 1;
9162: l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).old_install_location_type_code := l_curr_instance_rec.INSTALL_LOCATION_TYPE_CODE;

Line 9160: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).last_update_login := FND_GLOBAL.CONC_LOGIN_ID;

9156: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).created_by := FND_GLOBAL.USER_ID;
9157: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).creation_date := SYSDATE;
9158: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).last_updated_by := FND_GLOBAL.USER_ID;
9159: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).last_update_date := SYSDATE;
9160: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
9161: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).object_version_number := 1;
9162: l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).old_install_location_type_code := l_curr_instance_rec.INSTALL_LOCATION_TYPE_CODE;
9163: l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).new_install_location_type_code := p_instance_rec.INSTALL_LOCATION_TYPE_CODE;
9164: l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).old_install_location_id := l_curr_instance_rec.INSTALL_LOCATION_ID;

Line 9652: ,p_CREATED_BY => FND_GLOBAL.USER_ID

9648: ,p_NEW_ATTRIBUTE14 => FND_API.G_MISS_CHAR
9649: ,p_OLD_ATTRIBUTE14 => FND_API.G_MISS_CHAR
9650: ,p_NEW_ATTRIBUTE15 => FND_API.G_MISS_CHAR
9651: ,p_OLD_ATTRIBUTE15 => FND_API.G_MISS_CHAR
9652: ,p_CREATED_BY => FND_GLOBAL.USER_ID
9653: ,p_CREATION_DATE => SYSDATE
9654: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
9655: ,p_LAST_UPDATE_DATE => SYSDATE
9656: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

Line 9654: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

9650: ,p_NEW_ATTRIBUTE15 => FND_API.G_MISS_CHAR
9651: ,p_OLD_ATTRIBUTE15 => FND_API.G_MISS_CHAR
9652: ,p_CREATED_BY => FND_GLOBAL.USER_ID
9653: ,p_CREATION_DATE => SYSDATE
9654: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
9655: ,p_LAST_UPDATE_DATE => SYSDATE
9656: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
9657: ,p_OBJECT_VERSION_NUMBER => 1
9658: ,p_OLD_INST_LOC_TYPE_CODE => l_instance_hist_rec.OLD_INSTALL_LOCATION_TYPE_CODE

Line 9656: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

9652: ,p_CREATED_BY => FND_GLOBAL.USER_ID
9653: ,p_CREATION_DATE => SYSDATE
9654: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
9655: ,p_LAST_UPDATE_DATE => SYSDATE
9656: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
9657: ,p_OBJECT_VERSION_NUMBER => 1
9658: ,p_OLD_INST_LOC_TYPE_CODE => l_instance_hist_rec.OLD_INSTALL_LOCATION_TYPE_CODE
9659: ,p_NEW_INST_LOC_TYPE_CODE => l_instance_hist_rec.NEW_INSTALL_LOCATION_TYPE_CODE
9660: ,p_OLD_INST_LOC_ID => l_instance_hist_rec.OLD_INSTALL_LOCATION_ID

Line 9870: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).created_by := FND_GLOBAL.USER_ID;

9866: l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).new_attribute14 := p_instance_rec.ATTRIBUTE14;
9867: l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).old_attribute14 := l_curr_instance_rec.ATTRIBUTE14;
9868: l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).new_attribute15 := p_instance_rec.ATTRIBUTE15;
9869: l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).old_attribute15 := l_curr_instance_rec.ATTRIBUTE15;
9870: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).created_by := FND_GLOBAL.USER_ID;
9871: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).creation_date := SYSDATE;
9872: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).last_updated_by := FND_GLOBAL.USER_ID;
9873: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).last_update_date := SYSDATE;
9874: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).last_update_login := FND_GLOBAL.CONC_LOGIN_ID;

Line 9872: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).last_updated_by := FND_GLOBAL.USER_ID;

9868: l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).new_attribute15 := p_instance_rec.ATTRIBUTE15;
9869: l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).old_attribute15 := l_curr_instance_rec.ATTRIBUTE15;
9870: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).created_by := FND_GLOBAL.USER_ID;
9871: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).creation_date := SYSDATE;
9872: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).last_updated_by := FND_GLOBAL.USER_ID;
9873: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).last_update_date := SYSDATE;
9874: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
9875: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).object_version_number := 1;
9876: l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).old_install_location_type_code := l_curr_instance_rec.INSTALL_LOCATION_TYPE_CODE;

Line 9874: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).last_update_login := FND_GLOBAL.CONC_LOGIN_ID;

9870: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).created_by := FND_GLOBAL.USER_ID;
9871: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).creation_date := SYSDATE;
9872: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).last_updated_by := FND_GLOBAL.USER_ID;
9873: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).last_update_date := SYSDATE;
9874: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
9875: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).object_version_number := 1;
9876: l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).old_install_location_type_code := l_curr_instance_rec.INSTALL_LOCATION_TYPE_CODE;
9877: l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).new_install_location_type_code := p_instance_rec.INSTALL_LOCATION_TYPE_CODE;
9878: l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).old_install_location_id := l_curr_instance_rec.INSTALL_LOCATION_ID;

Line 14261: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

14257: p_ATTRIBUTE14 => p_instance_rec.ATTRIBUTE14,
14258: p_ATTRIBUTE15 => p_instance_rec.ATTRIBUTE15,
14259: p_CREATED_BY => fnd_api.g_miss_num,
14260: p_CREATION_DATE => fnd_api.g_miss_date,
14261: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
14262: p_LAST_UPDATE_DATE => SYSDATE,
14263: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
14264: p_OBJECT_VERSION_NUMBER => p_instance_rec.OBJECT_VERSION_NUMBER,
14265: p_LAST_TXN_LINE_DETAIL_ID => p_instance_rec.LAST_TXN_LINE_DETAIL_ID,

Line 14263: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,

14259: p_CREATED_BY => fnd_api.g_miss_num,
14260: p_CREATION_DATE => fnd_api.g_miss_date,
14261: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
14262: p_LAST_UPDATE_DATE => SYSDATE,
14263: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
14264: p_OBJECT_VERSION_NUMBER => p_instance_rec.OBJECT_VERSION_NUMBER,
14265: p_LAST_TXN_LINE_DETAIL_ID => p_instance_rec.LAST_TXN_LINE_DETAIL_ID,
14266: p_INSTALL_LOCATION_TYPE_CODE => p_instance_rec.INSTALL_LOCATION_TYPE_CODE,
14267: p_INSTALL_LOCATION_ID => p_instance_rec.INSTALL_LOCATION_ID,

Line 14776: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

14772: ,p_NEW_ATTRIBUTE15 => p_instance_rec.ATTRIBUTE15
14773: ,p_OLD_ATTRIBUTE15 => fnd_api.g_miss_char
14774: ,p_CREATED_BY => fnd_api.g_miss_num
14775: ,p_CREATION_DATE => fnd_api.g_miss_date
14776: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
14777: ,p_LAST_UPDATE_DATE => SYSDATE
14778: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
14779: ,p_OBJECT_VERSION_NUMBER => fnd_api.g_miss_num
14780: ,p_OLD_INST_LOC_TYPE_CODE => fnd_api.g_miss_char

Line 14778: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

14774: ,p_CREATED_BY => fnd_api.g_miss_num
14775: ,p_CREATION_DATE => fnd_api.g_miss_date
14776: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
14777: ,p_LAST_UPDATE_DATE => SYSDATE
14778: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
14779: ,p_OBJECT_VERSION_NUMBER => fnd_api.g_miss_num
14780: ,p_OLD_INST_LOC_TYPE_CODE => fnd_api.g_miss_char
14781: ,p_NEW_INST_LOC_TYPE_CODE => p_instance_rec.INSTALL_LOCATION_TYPE_CODE
14782: ,p_OLD_INST_LOC_ID => fnd_api.g_miss_num

Line 16507: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

16503: ,p_NEW_ATTRIBUTE15 => l_ins_hist_csr.NEW_ATTRIBUTE15
16504: ,p_OLD_ATTRIBUTE15 => l_ins_hist_csr.OLD_ATTRIBUTE15
16505: ,p_CREATED_BY => fnd_api.g_miss_num
16506: ,p_CREATION_DATE => fnd_api.g_miss_date
16507: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
16508: ,p_LAST_UPDATE_DATE => SYSDATE
16509: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
16510: ,p_OBJECT_VERSION_NUMBER => fnd_api.g_miss_num
16511: ,p_OLD_INST_LOC_TYPE_CODE => l_ins_hist_csr.OLD_INST_LOC_TYPE_CODE

Line 16509: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

16505: ,p_CREATED_BY => fnd_api.g_miss_num
16506: ,p_CREATION_DATE => fnd_api.g_miss_date
16507: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
16508: ,p_LAST_UPDATE_DATE => SYSDATE
16509: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
16510: ,p_OBJECT_VERSION_NUMBER => fnd_api.g_miss_num
16511: ,p_OLD_INST_LOC_TYPE_CODE => l_ins_hist_csr.OLD_INST_LOC_TYPE_CODE
16512: ,p_NEW_INST_LOC_TYPE_CODE => l_ins_hist_csr.NEW_INST_LOC_TYPE_CODE
16513: ,p_OLD_INST_LOC_ID => l_ins_hist_csr.OLD_INST_LOC_ID

Line 17055: ,p_CREATED_BY => FND_GLOBAL.USER_ID

17051: ,p_NEW_ATTRIBUTE14 => p_instance_rec.ATTRIBUTE14
17052: ,p_OLD_ATTRIBUTE14 => l_curr_instance_rec.ATTRIBUTE14
17053: ,p_NEW_ATTRIBUTE15 => p_instance_rec.ATTRIBUTE15
17054: ,p_OLD_ATTRIBUTE15 => l_curr_instance_rec.ATTRIBUTE15
17055: ,p_CREATED_BY => FND_GLOBAL.USER_ID
17056: ,p_CREATION_DATE => SYSDATE
17057: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
17058: ,p_LAST_UPDATE_DATE => SYSDATE
17059: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

Line 17057: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

17053: ,p_NEW_ATTRIBUTE15 => p_instance_rec.ATTRIBUTE15
17054: ,p_OLD_ATTRIBUTE15 => l_curr_instance_rec.ATTRIBUTE15
17055: ,p_CREATED_BY => FND_GLOBAL.USER_ID
17056: ,p_CREATION_DATE => SYSDATE
17057: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
17058: ,p_LAST_UPDATE_DATE => SYSDATE
17059: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
17060: ,p_OBJECT_VERSION_NUMBER => 1
17061: ,p_OLD_INST_LOC_TYPE_CODE => l_curr_instance_rec.INSTALL_LOCATION_TYPE_CODE

Line 17059: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

17055: ,p_CREATED_BY => FND_GLOBAL.USER_ID
17056: ,p_CREATION_DATE => SYSDATE
17057: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
17058: ,p_LAST_UPDATE_DATE => SYSDATE
17059: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
17060: ,p_OBJECT_VERSION_NUMBER => 1
17061: ,p_OLD_INST_LOC_TYPE_CODE => l_curr_instance_rec.INSTALL_LOCATION_TYPE_CODE
17062: ,p_NEW_INST_LOC_TYPE_CODE => p_instance_rec.INSTALL_LOCATION_TYPE_CODE
17063: ,p_OLD_INST_LOC_ID => l_curr_instance_rec.INSTALL_LOCATION_ID

Line 18366: ,p_CREATED_BY => FND_GLOBAL.USER_ID

18362: ,p_NEW_ATTRIBUTE14 => l_instance_hist_rec.NEW_ATTRIBUTE14
18363: ,p_OLD_ATTRIBUTE14 => l_instance_hist_rec.OLD_ATTRIBUTE14
18364: ,p_NEW_ATTRIBUTE15 => l_instance_hist_rec.NEW_ATTRIBUTE15
18365: ,p_OLD_ATTRIBUTE15 => l_instance_hist_rec.OLD_ATTRIBUTE15
18366: ,p_CREATED_BY => FND_GLOBAL.USER_ID
18367: ,p_CREATION_DATE => SYSDATE
18368: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
18369: ,p_LAST_UPDATE_DATE => SYSDATE
18370: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

Line 18368: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

18364: ,p_NEW_ATTRIBUTE15 => l_instance_hist_rec.NEW_ATTRIBUTE15
18365: ,p_OLD_ATTRIBUTE15 => l_instance_hist_rec.OLD_ATTRIBUTE15
18366: ,p_CREATED_BY => FND_GLOBAL.USER_ID
18367: ,p_CREATION_DATE => SYSDATE
18368: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
18369: ,p_LAST_UPDATE_DATE => SYSDATE
18370: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
18371: ,p_OBJECT_VERSION_NUMBER => 1
18372: ,p_OLD_INST_LOC_TYPE_CODE => l_instance_hist_rec.OLD_INSTALL_LOCATION_TYPE_CODE

Line 18370: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

18366: ,p_CREATED_BY => FND_GLOBAL.USER_ID
18367: ,p_CREATION_DATE => SYSDATE
18368: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
18369: ,p_LAST_UPDATE_DATE => SYSDATE
18370: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
18371: ,p_OBJECT_VERSION_NUMBER => 1
18372: ,p_OLD_INST_LOC_TYPE_CODE => l_instance_hist_rec.OLD_INSTALL_LOCATION_TYPE_CODE
18373: ,p_NEW_INST_LOC_TYPE_CODE => l_instance_hist_rec.NEW_INSTALL_LOCATION_TYPE_CODE
18374: ,p_OLD_INST_LOC_ID => l_instance_hist_rec.OLD_INSTALL_LOCATION_ID

Line 19259: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

19255: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
19256: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
19257: p_CREATED_BY => fnd_api.g_miss_num,
19258: p_CREATION_DATE => fnd_api.g_miss_date,
19259: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
19260: p_LAST_UPDATE_DATE => SYSDATE,
19261: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
19262: p_OBJECT_VERSION_NUMBER => l_instance_rec.OBJECT_VERSION_NUMBER,
19263: p_LAST_TXN_LINE_DETAIL_ID => FND_API.G_MISS_NUM,

Line 19261: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,

19257: p_CREATED_BY => fnd_api.g_miss_num,
19258: p_CREATION_DATE => fnd_api.g_miss_date,
19259: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
19260: p_LAST_UPDATE_DATE => SYSDATE,
19261: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
19262: p_OBJECT_VERSION_NUMBER => l_instance_rec.OBJECT_VERSION_NUMBER,
19263: p_LAST_TXN_LINE_DETAIL_ID => FND_API.G_MISS_NUM,
19264: p_INSTALL_LOCATION_TYPE_CODE => FND_API.G_MISS_CHAR,
19265: p_INSTALL_LOCATION_ID => FND_API.G_MISS_NUM,

Line 19463: ,p_CREATED_BY => FND_GLOBAL.USER_ID

19459: ,p_NEW_ATTRIBUTE14 => l_curr_instance_rec.ATTRIBUTE14
19460: ,p_OLD_ATTRIBUTE14 => l_curr_instance_rec.ATTRIBUTE14
19461: ,p_NEW_ATTRIBUTE15 => l_curr_instance_rec.ATTRIBUTE15
19462: ,p_OLD_ATTRIBUTE15 => l_curr_instance_rec.ATTRIBUTE15
19463: ,p_CREATED_BY => FND_GLOBAL.USER_ID
19464: ,p_CREATION_DATE => SYSDATE
19465: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
19466: ,p_LAST_UPDATE_DATE => SYSDATE
19467: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

Line 19465: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

19461: ,p_NEW_ATTRIBUTE15 => l_curr_instance_rec.ATTRIBUTE15
19462: ,p_OLD_ATTRIBUTE15 => l_curr_instance_rec.ATTRIBUTE15
19463: ,p_CREATED_BY => FND_GLOBAL.USER_ID
19464: ,p_CREATION_DATE => SYSDATE
19465: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
19466: ,p_LAST_UPDATE_DATE => SYSDATE
19467: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
19468: ,p_OBJECT_VERSION_NUMBER => 1
19469: ,p_OLD_INST_LOC_TYPE_CODE => l_curr_instance_rec.INSTALL_LOCATION_TYPE_CODE

Line 19467: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

19463: ,p_CREATED_BY => FND_GLOBAL.USER_ID
19464: ,p_CREATION_DATE => SYSDATE
19465: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
19466: ,p_LAST_UPDATE_DATE => SYSDATE
19467: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
19468: ,p_OBJECT_VERSION_NUMBER => 1
19469: ,p_OLD_INST_LOC_TYPE_CODE => l_curr_instance_rec.INSTALL_LOCATION_TYPE_CODE
19470: ,p_NEW_INST_LOC_TYPE_CODE => l_curr_instance_rec.INSTALL_LOCATION_TYPE_CODE
19471: ,p_OLD_INST_LOC_ID => l_curr_instance_rec.INSTALL_LOCATION_ID

Line 19684: ,p_CREATED_BY => FND_GLOBAL.USER_ID

19680: ,p_NEW_ATTRIBUTE14 => FND_API.G_MISS_CHAR
19681: ,p_OLD_ATTRIBUTE14 => FND_API.G_MISS_CHAR
19682: ,p_NEW_ATTRIBUTE15 => FND_API.G_MISS_CHAR
19683: ,p_OLD_ATTRIBUTE15 => FND_API.G_MISS_CHAR
19684: ,p_CREATED_BY => FND_GLOBAL.USER_ID
19685: ,p_CREATION_DATE => SYSDATE
19686: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
19687: ,p_LAST_UPDATE_DATE => SYSDATE
19688: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

Line 19686: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

19682: ,p_NEW_ATTRIBUTE15 => FND_API.G_MISS_CHAR
19683: ,p_OLD_ATTRIBUTE15 => FND_API.G_MISS_CHAR
19684: ,p_CREATED_BY => FND_GLOBAL.USER_ID
19685: ,p_CREATION_DATE => SYSDATE
19686: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
19687: ,p_LAST_UPDATE_DATE => SYSDATE
19688: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
19689: ,p_OBJECT_VERSION_NUMBER => 1
19690: ,p_OLD_INST_LOC_TYPE_CODE => FND_API.G_MISS_CHAR

Line 19688: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

19684: ,p_CREATED_BY => FND_GLOBAL.USER_ID
19685: ,p_CREATION_DATE => SYSDATE
19686: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
19687: ,p_LAST_UPDATE_DATE => SYSDATE
19688: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
19689: ,p_OBJECT_VERSION_NUMBER => 1
19690: ,p_OLD_INST_LOC_TYPE_CODE => FND_API.G_MISS_CHAR
19691: ,p_NEW_INST_LOC_TYPE_CODE => FND_API.G_MISS_CHAR
19692: ,p_OLD_INST_LOC_ID => FND_API.G_MISS_NUM

Line 20505: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

20501: p_ATTRIBUTE14 => l_instance_rec.ATTRIBUTE14,
20502: p_ATTRIBUTE15 => l_instance_rec.ATTRIBUTE15,
20503: p_CREATED_BY => fnd_api.g_miss_num,
20504: p_CREATION_DATE => fnd_api.g_miss_date,
20505: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
20506: p_LAST_UPDATE_DATE => SYSDATE,
20507: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
20508: p_OBJECT_VERSION_NUMBER => l_instance_rec.OBJECT_VERSION_NUMBER,
20509: p_LAST_TXN_LINE_DETAIL_ID => l_instance_rec.LAST_TXN_LINE_DETAIL_ID,

Line 20507: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,

20503: p_CREATED_BY => fnd_api.g_miss_num,
20504: p_CREATION_DATE => fnd_api.g_miss_date,
20505: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
20506: p_LAST_UPDATE_DATE => SYSDATE,
20507: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
20508: p_OBJECT_VERSION_NUMBER => l_instance_rec.OBJECT_VERSION_NUMBER,
20509: p_LAST_TXN_LINE_DETAIL_ID => l_instance_rec.LAST_TXN_LINE_DETAIL_ID,
20510: p_INSTALL_LOCATION_TYPE_CODE => l_instance_rec.INSTALL_LOCATION_TYPE_CODE,
20511: p_INSTALL_LOCATION_ID => l_instance_rec.INSTALL_LOCATION_ID,

Line 20720: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

20716: ,p_NEW_ATTRIBUTE15 => p_instance_rec.ATTRIBUTE15
20717: ,p_OLD_ATTRIBUTE15 => fnd_api.g_miss_char
20718: ,p_CREATED_BY => fnd_api.g_miss_num
20719: ,p_CREATION_DATE => fnd_api.g_miss_date
20720: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
20721: ,p_LAST_UPDATE_DATE => SYSDATE
20722: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
20723: ,p_OBJECT_VERSION_NUMBER => fnd_api.g_miss_num
20724: ,p_OLD_INST_LOC_TYPE_CODE => fnd_api.g_miss_char

Line 20722: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

20718: ,p_CREATED_BY => fnd_api.g_miss_num
20719: ,p_CREATION_DATE => fnd_api.g_miss_date
20720: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
20721: ,p_LAST_UPDATE_DATE => SYSDATE
20722: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
20723: ,p_OBJECT_VERSION_NUMBER => fnd_api.g_miss_num
20724: ,p_OLD_INST_LOC_TYPE_CODE => fnd_api.g_miss_char
20725: ,p_NEW_INST_LOC_TYPE_CODE => p_instance_rec.INSTALL_LOCATION_TYPE_CODE
20726: ,p_OLD_INST_LOC_ID => fnd_api.g_miss_num

Line 20945: ,p_CREATED_BY => FND_GLOBAL.USER_ID

20941: ,p_NEW_ATTRIBUTE14 => l_curr_instance_rec.ATTRIBUTE14
20942: ,p_OLD_ATTRIBUTE14 => l_curr_instance_rec.ATTRIBUTE14
20943: ,p_NEW_ATTRIBUTE15 => l_curr_instance_rec.ATTRIBUTE15
20944: ,p_OLD_ATTRIBUTE15 => l_curr_instance_rec.ATTRIBUTE15
20945: ,p_CREATED_BY => FND_GLOBAL.USER_ID
20946: ,p_CREATION_DATE => SYSDATE
20947: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
20948: ,p_LAST_UPDATE_DATE => SYSDATE
20949: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

Line 20947: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

20943: ,p_NEW_ATTRIBUTE15 => l_curr_instance_rec.ATTRIBUTE15
20944: ,p_OLD_ATTRIBUTE15 => l_curr_instance_rec.ATTRIBUTE15
20945: ,p_CREATED_BY => FND_GLOBAL.USER_ID
20946: ,p_CREATION_DATE => SYSDATE
20947: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
20948: ,p_LAST_UPDATE_DATE => SYSDATE
20949: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
20950: ,p_OBJECT_VERSION_NUMBER => 1
20951: ,p_OLD_INST_LOC_TYPE_CODE => l_curr_instance_rec.INSTALL_LOCATION_TYPE_CODE

Line 20949: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

20945: ,p_CREATED_BY => FND_GLOBAL.USER_ID
20946: ,p_CREATION_DATE => SYSDATE
20947: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
20948: ,p_LAST_UPDATE_DATE => SYSDATE
20949: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
20950: ,p_OBJECT_VERSION_NUMBER => 1
20951: ,p_OLD_INST_LOC_TYPE_CODE => l_curr_instance_rec.INSTALL_LOCATION_TYPE_CODE
20952: ,p_NEW_INST_LOC_TYPE_CODE => l_curr_instance_rec.INSTALL_LOCATION_TYPE_CODE
20953: ,p_OLD_INST_LOC_ID => l_curr_instance_rec.INSTALL_LOCATION_ID

Line 21167: ,p_CREATED_BY => FND_GLOBAL.USER_ID

21163: ,p_NEW_ATTRIBUTE14 => l_instance_rec.ATTRIBUTE14
21164: ,p_OLD_ATTRIBUTE14 => l_instance_rec.ATTRIBUTE14
21165: ,p_NEW_ATTRIBUTE15 => l_instance_rec.ATTRIBUTE15
21166: ,p_OLD_ATTRIBUTE15 => l_instance_rec.ATTRIBUTE15
21167: ,p_CREATED_BY => FND_GLOBAL.USER_ID
21168: ,p_CREATION_DATE => SYSDATE
21169: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
21170: ,p_LAST_UPDATE_DATE => SYSDATE
21171: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

Line 21169: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

21165: ,p_NEW_ATTRIBUTE15 => l_instance_rec.ATTRIBUTE15
21166: ,p_OLD_ATTRIBUTE15 => l_instance_rec.ATTRIBUTE15
21167: ,p_CREATED_BY => FND_GLOBAL.USER_ID
21168: ,p_CREATION_DATE => SYSDATE
21169: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
21170: ,p_LAST_UPDATE_DATE => SYSDATE
21171: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
21172: ,p_OBJECT_VERSION_NUMBER => 1
21173: ,p_OLD_INST_LOC_TYPE_CODE => l_instance_rec.INSTALL_LOCATION_TYPE_CODE

Line 21171: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

21167: ,p_CREATED_BY => FND_GLOBAL.USER_ID
21168: ,p_CREATION_DATE => SYSDATE
21169: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
21170: ,p_LAST_UPDATE_DATE => SYSDATE
21171: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
21172: ,p_OBJECT_VERSION_NUMBER => 1
21173: ,p_OLD_INST_LOC_TYPE_CODE => l_instance_rec.INSTALL_LOCATION_TYPE_CODE
21174: ,p_NEW_INST_LOC_TYPE_CODE => l_instance_rec.INSTALL_LOCATION_TYPE_CODE
21175: ,p_OLD_INST_LOC_ID => l_instance_rec.INSTALL_LOCATION_ID

Line 23197: p_CREATED_BY => FND_GLOBAL.USER_ID ,

23193: p_ATTRIBUTE12 => p_version_label_rec.attribute12,
23194: p_ATTRIBUTE13 => p_version_label_rec.attribute13,
23195: p_ATTRIBUTE14 => p_version_label_rec.attribute14,
23196: p_ATTRIBUTE15 => p_version_label_rec.attribute15,
23197: p_CREATED_BY => FND_GLOBAL.USER_ID ,
23198: p_CREATION_DATE => SYSDATE ,
23199: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
23200: p_LAST_UPDATE_DATE => SYSDATE ,
23201: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,

Line 23199: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,

23195: p_ATTRIBUTE14 => p_version_label_rec.attribute14,
23196: p_ATTRIBUTE15 => p_version_label_rec.attribute15,
23197: p_CREATED_BY => FND_GLOBAL.USER_ID ,
23198: p_CREATION_DATE => SYSDATE ,
23199: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
23200: p_LAST_UPDATE_DATE => SYSDATE ,
23201: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,
23202: p_OBJECT_VERSION_NUMBER => 1 );
23203:

Line 23201: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,

23197: p_CREATED_BY => FND_GLOBAL.USER_ID ,
23198: p_CREATION_DATE => SYSDATE ,
23199: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
23200: p_LAST_UPDATE_DATE => SYSDATE ,
23201: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,
23202: p_OBJECT_VERSION_NUMBER => 1 );
23203:
23204:
23205: -- Call create_transaction to create txn log

Line 23284: p_CREATED_BY => FND_GLOBAL.USER_ID ,

23280: p_NEW_ATTRIBUTE14 => p_version_label_rec.ATTRIBUTE14,
23281: p_OLD_ATTRIBUTE15 => NULL ,
23282: p_NEW_ATTRIBUTE15 => p_version_label_rec.ATTRIBUTE15,
23283: p_FULL_DUMP_FLAG => 'N' ,
23284: p_CREATED_BY => FND_GLOBAL.USER_ID ,
23285: p_CREATION_DATE => SYSDATE ,
23286: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
23287: p_LAST_UPDATE_DATE => SYSDATE ,
23288: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,

Line 23286: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,

23282: p_NEW_ATTRIBUTE15 => p_version_label_rec.ATTRIBUTE15,
23283: p_FULL_DUMP_FLAG => 'N' ,
23284: p_CREATED_BY => FND_GLOBAL.USER_ID ,
23285: p_CREATION_DATE => SYSDATE ,
23286: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
23287: p_LAST_UPDATE_DATE => SYSDATE ,
23288: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,
23289: p_OBJECT_VERSION_NUMBER => 1 );
23290:

Line 23288: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,

23284: p_CREATED_BY => FND_GLOBAL.USER_ID ,
23285: p_CREATION_DATE => SYSDATE ,
23286: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
23287: p_LAST_UPDATE_DATE => SYSDATE ,
23288: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,
23289: p_OBJECT_VERSION_NUMBER => 1 );
23290:
23291:
23292: --

Line 23520: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,

23516: p_ATTRIBUTE14 => p_version_label_rec.ATTRIBUTE14,
23517: p_ATTRIBUTE15 => p_version_label_rec.ATTRIBUTE15,
23518: p_CREATED_BY => fnd_api.g_miss_num ,
23519: p_CREATION_DATE => fnd_api.g_miss_date ,
23520: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
23521: p_LAST_UPDATE_DATE => sysdate ,
23522: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
23523: p_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER );
23524:

Line 23522: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,

23518: p_CREATED_BY => fnd_api.g_miss_num ,
23519: p_CREATION_DATE => fnd_api.g_miss_date ,
23520: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
23521: p_LAST_UPDATE_DATE => sysdate ,
23522: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
23523: p_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER );
23524:
23525:
23526: -- Call create_transaction to create txn log

Line 23637: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,

23633: p_NEW_ATTRIBUTE15 => p_version_label_rec.ATTRIBUTE15 ,
23634: p_FULL_DUMP_FLAG => fnd_api.g_miss_char ,
23635: p_CREATED_BY => fnd_api.g_miss_num ,
23636: p_CREATION_DATE => fnd_api.g_miss_date ,
23637: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
23638: p_LAST_UPDATE_DATE => SYSDATE ,
23639: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,
23640: p_OBJECT_VERSION_NUMBER => fnd_api.g_miss_num );
23641:

Line 23639: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,

23635: p_CREATED_BY => fnd_api.g_miss_num ,
23636: p_CREATION_DATE => fnd_api.g_miss_date ,
23637: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
23638: p_LAST_UPDATE_DATE => SYSDATE ,
23639: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,
23640: p_OBJECT_VERSION_NUMBER => fnd_api.g_miss_num );
23641:
23642: ELSE
23643: --

Line 24010: p_last_updated_by => fnd_global.user_id ,

24006: p_new_attribute15 => l_version_hist_csr.new_attribute15 ,
24007: p_full_dump_flag => fnd_api.g_miss_char ,
24008: p_created_by => fnd_api.g_miss_num ,
24009: p_creation_date => fnd_api.g_miss_date ,
24010: p_last_updated_by => fnd_global.user_id ,
24011: p_last_update_date => SYSDATE ,
24012: p_last_update_login => fnd_global.login_id ,
24013: p_object_version_number => fnd_api.g_miss_num );
24014: END IF;

Line 24012: p_last_update_login => fnd_global.login_id ,

24008: p_created_by => fnd_api.g_miss_num ,
24009: p_creation_date => fnd_api.g_miss_date ,
24010: p_last_updated_by => fnd_global.user_id ,
24011: p_last_update_date => SYSDATE ,
24012: p_last_update_login => fnd_global.login_id ,
24013: p_object_version_number => fnd_api.g_miss_num );
24014: END IF;
24015: EXCEPTION
24016: WHEN NO_DATA_FOUND THEN

Line 24137: p_CREATED_BY => FND_GLOBAL.USER_ID ,

24133: p_NEW_ATTRIBUTE14 => p_version_label_rec.ATTRIBUTE14,
24134: p_OLD_ATTRIBUTE15 => l_temp_ver_label_rec.ATTRIBUTE15 ,
24135: p_NEW_ATTRIBUTE15 => p_version_label_rec.ATTRIBUTE15,
24136: p_FULL_DUMP_FLAG => 'Y' ,
24137: p_CREATED_BY => FND_GLOBAL.USER_ID ,
24138: p_CREATION_DATE => SYSDATE ,
24139: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
24140: p_LAST_UPDATE_DATE => SYSDATE ,
24141: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,

Line 24139: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,

24135: p_NEW_ATTRIBUTE15 => p_version_label_rec.ATTRIBUTE15,
24136: p_FULL_DUMP_FLAG => 'Y' ,
24137: p_CREATED_BY => FND_GLOBAL.USER_ID ,
24138: p_CREATION_DATE => SYSDATE ,
24139: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
24140: p_LAST_UPDATE_DATE => SYSDATE ,
24141: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,
24142: p_OBJECT_VERSION_NUMBER => 1 );
24143:

Line 24141: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,

24137: p_CREATED_BY => FND_GLOBAL.USER_ID ,
24138: p_CREATION_DATE => SYSDATE ,
24139: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
24140: p_LAST_UPDATE_DATE => SYSDATE ,
24141: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,
24142: p_OBJECT_VERSION_NUMBER => 1 );
24143:
24144:
24145: ELSE

Line 24408: p_CREATED_BY => FND_GLOBAL.USER_ID ,

24404: p_NEW_ATTRIBUTE14 => l_ver_label_hist_rec.NEW_ATTRIBUTE14,
24405: p_OLD_ATTRIBUTE15 => l_ver_label_hist_rec.OLD_ATTRIBUTE15,
24406: p_NEW_ATTRIBUTE15 => l_ver_label_hist_rec.NEW_ATTRIBUTE15,
24407: p_FULL_DUMP_FLAG => 'N' ,
24408: p_CREATED_BY => FND_GLOBAL.USER_ID ,
24409: p_CREATION_DATE => SYSDATE ,
24410: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
24411: p_LAST_UPDATE_DATE => SYSDATE ,
24412: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,

Line 24410: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,

24406: p_NEW_ATTRIBUTE15 => l_ver_label_hist_rec.NEW_ATTRIBUTE15,
24407: p_FULL_DUMP_FLAG => 'N' ,
24408: p_CREATED_BY => FND_GLOBAL.USER_ID ,
24409: p_CREATION_DATE => SYSDATE ,
24410: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
24411: p_LAST_UPDATE_DATE => SYSDATE ,
24412: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,
24413: p_OBJECT_VERSION_NUMBER => 1 );
24414:

Line 24412: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,

24408: p_CREATED_BY => FND_GLOBAL.USER_ID ,
24409: p_CREATION_DATE => SYSDATE ,
24410: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
24411: p_LAST_UPDATE_DATE => SYSDATE ,
24412: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,
24413: p_OBJECT_VERSION_NUMBER => 1 );
24414:
24415:
24416: END IF;

Line 24634: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,

24630: p_ATTRIBUTE14 => l_version_label_rec.ATTRIBUTE14,
24631: p_ATTRIBUTE15 => l_version_label_rec.ATTRIBUTE15,
24632: p_CREATED_BY => fnd_api.g_miss_num ,
24633: p_CREATION_DATE => fnd_api.g_miss_date ,
24634: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
24635: p_LAST_UPDATE_DATE => sysdate ,
24636: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,
24637: p_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER );
24638:

Line 24636: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,

24632: p_CREATED_BY => fnd_api.g_miss_num ,
24633: p_CREATION_DATE => fnd_api.g_miss_date ,
24634: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
24635: p_LAST_UPDATE_DATE => sysdate ,
24636: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,
24637: p_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER );
24638:
24639:
24640: -- Call create_transaction to create txn log

Line 24738: p_CREATED_BY => FND_GLOBAL.USER_ID ,

24734: p_NEW_ATTRIBUTE14 => l_curr_ver_label_rec.ATTRIBUTE14,
24735: p_OLD_ATTRIBUTE15 => l_curr_ver_label_rec.ATTRIBUTE15,
24736: p_NEW_ATTRIBUTE15 => l_curr_ver_label_rec.ATTRIBUTE15,
24737: p_FULL_DUMP_FLAG => 'Y' ,
24738: p_CREATED_BY => FND_GLOBAL.USER_ID ,
24739: p_CREATION_DATE => SYSDATE ,
24740: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
24741: p_LAST_UPDATE_DATE => SYSDATE ,
24742: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,

Line 24740: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,

24736: p_NEW_ATTRIBUTE15 => l_curr_ver_label_rec.ATTRIBUTE15,
24737: p_FULL_DUMP_FLAG => 'Y' ,
24738: p_CREATED_BY => FND_GLOBAL.USER_ID ,
24739: p_CREATION_DATE => SYSDATE ,
24740: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
24741: p_LAST_UPDATE_DATE => SYSDATE ,
24742: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,
24743: p_OBJECT_VERSION_NUMBER => 1 );
24744:

Line 24742: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,

24738: p_CREATED_BY => FND_GLOBAL.USER_ID ,
24739: p_CREATION_DATE => SYSDATE ,
24740: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
24741: p_LAST_UPDATE_DATE => SYSDATE ,
24742: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,
24743: p_OBJECT_VERSION_NUMBER => 1 );
24744:
24745:
24746: ELSE

Line 24799: p_CREATED_BY => FND_GLOBAL.USER_ID ,

24795: p_NEW_ATTRIBUTE14 => l_version_label_rec.ATTRIBUTE14 ,
24796: p_OLD_ATTRIBUTE15 => l_version_label_rec.ATTRIBUTE15 ,
24797: p_NEW_ATTRIBUTE15 => l_version_label_rec.ATTRIBUTE15 ,
24798: p_FULL_DUMP_FLAG => 'N' ,
24799: p_CREATED_BY => FND_GLOBAL.USER_ID ,
24800: p_CREATION_DATE => SYSDATE ,
24801: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
24802: p_LAST_UPDATE_DATE => SYSDATE ,
24803: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,

Line 24801: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,

24797: p_NEW_ATTRIBUTE15 => l_version_label_rec.ATTRIBUTE15 ,
24798: p_FULL_DUMP_FLAG => 'N' ,
24799: p_CREATED_BY => FND_GLOBAL.USER_ID ,
24800: p_CREATION_DATE => SYSDATE ,
24801: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
24802: p_LAST_UPDATE_DATE => SYSDATE ,
24803: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,
24804: p_OBJECT_VERSION_NUMBER => 1 );
24805:

Line 24803: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,

24799: p_CREATED_BY => FND_GLOBAL.USER_ID ,
24800: p_CREATION_DATE => SYSDATE ,
24801: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
24802: p_LAST_UPDATE_DATE => SYSDATE ,
24803: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,
24804: p_OBJECT_VERSION_NUMBER => 1 );
24805:
24806:
24807: END IF;

Line 25833: ,fnd_global.user_id

25829: ,p_ext_attrib_rec.attribute12
25830: ,p_ext_attrib_rec.attribute13
25831: ,p_ext_attrib_rec.attribute14
25832: ,p_ext_attrib_rec.attribute15
25833: ,fnd_global.user_id
25834: ,sysdate
25835: ,fnd_global.user_id
25836: ,sysdate
25837: ,fnd_global.user_id

Line 25835: ,fnd_global.user_id

25831: ,p_ext_attrib_rec.attribute14
25832: ,p_ext_attrib_rec.attribute15
25833: ,fnd_global.user_id
25834: ,sysdate
25835: ,fnd_global.user_id
25836: ,sysdate
25837: ,fnd_global.user_id
25838: ,1
25839: );

Line 25837: ,fnd_global.user_id

25833: ,fnd_global.user_id
25834: ,sysdate
25835: ,fnd_global.user_id
25836: ,sysdate
25837: ,fnd_global.user_id
25838: ,1
25839: );
25840:
25841:

Line 25921: ,fnd_global.user_id

25917: ,p_ext_attrib_rec.ATTRIBUTE14
25918: ,NULL
25919: ,p_ext_attrib_rec.ATTRIBUTE15
25920: ,l_dump_frequency_flag
25921: ,fnd_global.user_id
25922: ,sysdate
25923: ,fnd_global.user_id
25924: ,sysdate
25925: ,fnd_global.user_id

Line 25923: ,fnd_global.user_id

25919: ,p_ext_attrib_rec.ATTRIBUTE15
25920: ,l_dump_frequency_flag
25921: ,fnd_global.user_id
25922: ,sysdate
25923: ,fnd_global.user_id
25924: ,sysdate
25925: ,fnd_global.user_id
25926: ,1);
25927:

Line 25925: ,fnd_global.user_id

25921: ,fnd_global.user_id
25922: ,sysdate
25923: ,fnd_global.user_id
25924: ,sysdate
25925: ,fnd_global.user_id
25926: ,1);
25927:
25928:
25929: -- END IF;

Line 26195: ,fnd_global.user_id

26191: ,p_ext_attrib_rec.attribute14
26192: ,p_ext_attrib_rec.attribute15
26193: ,fnd_api.g_miss_num
26194: ,fnd_api.g_miss_date
26195: ,fnd_global.user_id
26196: ,sysdate
26197: ,fnd_global.user_id
26198: ,l_ext_attrib_rec.object_version_number
26199: );

Line 26197: ,fnd_global.user_id

26193: ,fnd_api.g_miss_num
26194: ,fnd_api.g_miss_date
26195: ,fnd_global.user_id
26196: ,sysdate
26197: ,fnd_global.user_id
26198: ,l_ext_attrib_rec.object_version_number
26199: );
26200:
26201:

Line 26305: p_last_updated_by => fnd_global.user_id ,

26301: p_new_attribute15 => l_temp_ext_attrib_rec.attribute15 ,
26302: p_full_dump_flag => fnd_api.g_miss_char ,
26303: p_created_by => fnd_api.g_miss_num ,
26304: p_creation_date => fnd_api.g_miss_date ,
26305: p_last_updated_by => fnd_global.user_id ,
26306: p_last_update_date => sysdate ,
26307: p_last_update_login => fnd_global.user_id ,
26308: p_object_version_number => fnd_api.g_miss_num);
26309:

Line 26307: p_last_update_login => fnd_global.user_id ,

26303: p_created_by => fnd_api.g_miss_num ,
26304: p_creation_date => fnd_api.g_miss_date ,
26305: p_last_updated_by => fnd_global.user_id ,
26306: p_last_update_date => sysdate ,
26307: p_last_update_login => fnd_global.user_id ,
26308: p_object_version_number => fnd_api.g_miss_num);
26309:
26310: ELSE
26311: --

Line 26643: p_last_updated_by => fnd_global.user_id ,

26639: p_new_attribute15 => l_temp_ext_attrib_rec.attribute15 ,
26640: p_full_dump_flag => fnd_api.g_miss_char ,
26641: p_created_by => fnd_api.g_miss_num ,
26642: p_creation_date => fnd_api.g_miss_date ,
26643: p_last_updated_by => fnd_global.user_id ,
26644: p_last_update_date => SYSDATE ,
26645: p_last_update_login => fnd_global.user_id ,
26646: p_object_version_number => fnd_api.g_miss_num);
26647: END IF;

Line 26645: p_last_update_login => fnd_global.user_id ,

26641: p_created_by => fnd_api.g_miss_num ,
26642: p_creation_date => fnd_api.g_miss_date ,
26643: p_last_updated_by => fnd_global.user_id ,
26644: p_last_update_date => SYSDATE ,
26645: p_last_update_login => fnd_global.user_id ,
26646: p_object_version_number => fnd_api.g_miss_num);
26647: END IF;
26648: EXCEPTION
26649: WHEN NO_DATA_FOUND THEN

Line 26767: ,fnd_global.user_id

26763: ,l_temp_ext_attrib_rec.ATTRIBUTE14
26764: ,l_ext_attrib_rec.ATTRIBUTE15
26765: ,l_temp_ext_attrib_rec.ATTRIBUTE15
26766: ,l_dump_frequency_flag
26767: ,fnd_global.user_id
26768: ,sysdate
26769: ,fnd_global.user_id
26770: ,sysdate
26771: ,fnd_global.user_id

Line 26769: ,fnd_global.user_id

26765: ,l_temp_ext_attrib_rec.ATTRIBUTE15
26766: ,l_dump_frequency_flag
26767: ,fnd_global.user_id
26768: ,sysdate
26769: ,fnd_global.user_id
26770: ,sysdate
26771: ,fnd_global.user_id
26772: ,1);
26773:

Line 26771: ,fnd_global.user_id

26767: ,fnd_global.user_id
26768: ,sysdate
26769: ,fnd_global.user_id
26770: ,sysdate
26771: ,fnd_global.user_id
26772: ,1);
26773:
26774: ELSE
26775: l_dump_frequency_flag := 'N';

Line 27015: ,fnd_global.user_id

27011: ,l_ext_att_hist_rec.new_attribute14
27012: ,l_ext_att_hist_rec.old_attribute15
27013: ,l_ext_att_hist_rec.new_attribute15
27014: ,l_dump_frequency_flag
27015: ,fnd_global.user_id
27016: ,sysdate
27017: ,fnd_global.user_id
27018: ,sysdate
27019: ,fnd_global.user_id

Line 27017: ,fnd_global.user_id

27013: ,l_ext_att_hist_rec.new_attribute15
27014: ,l_dump_frequency_flag
27015: ,fnd_global.user_id
27016: ,sysdate
27017: ,fnd_global.user_id
27018: ,sysdate
27019: ,fnd_global.user_id
27020: ,1);
27021:

Line 27019: ,fnd_global.user_id

27015: ,fnd_global.user_id
27016: ,sysdate
27017: ,fnd_global.user_id
27018: ,sysdate
27019: ,fnd_global.user_id
27020: ,1);
27021:
27022: END IF;
27023: END;

Line 35289: ,fnd_global.user_id

35285: ,decode(l_lock_tbl(l_insert_csr).source_txn_line_ref1,fnd_api.g_miss_char,NULL,l_lock_tbl(l_insert_csr).source_txn_line_ref1)
35286: ,decode(l_lock_tbl(l_insert_csr).source_txn_line_ref2,fnd_api.g_miss_char,NULL,l_lock_tbl(l_insert_csr).source_txn_line_ref2)
35287: ,decode(l_lock_tbl(l_insert_csr).source_txn_line_ref3,fnd_api.g_miss_char,NULL,l_lock_tbl(l_insert_csr).source_txn_line_ref3)
35288: ,SYSDATE --p_txn_rec.source_transaction_date
35289: ,fnd_global.user_id
35290: ,SYSDATE
35291: ,1
35292: ,fnd_global.user_id
35293: ,fnd_global.user_id

Line 35292: ,fnd_global.user_id

35288: ,SYSDATE --p_txn_rec.source_transaction_date
35289: ,fnd_global.user_id
35290: ,SYSDATE
35291: ,1
35292: ,fnd_global.user_id
35293: ,fnd_global.user_id
35294: ,SYSDATE
35295: );
35296: END IF;

Line 35293: ,fnd_global.user_id

35289: ,fnd_global.user_id
35290: ,SYSDATE
35291: ,1
35292: ,fnd_global.user_id
35293: ,fnd_global.user_id
35294: ,SYSDATE
35295: );
35296: END IF;
35297: END LOOP;

Line 35499: l_last_updated_by := fnd_global.user_id;

35495: l_last_update_login NUMBER;
35496: l_unlock_status NUMBER;
35497: BEGIN
35498: l_unlock_status := 0;
35499: l_last_updated_by := fnd_global.user_id;
35500: l_last_update_login := fnd_global.login_id;
35501:
35502: IF p_unlock_param = 'INSTANCE'
35503: THEN

Line 35500: l_last_update_login := fnd_global.login_id;

35496: l_unlock_status NUMBER;
35497: BEGIN
35498: l_unlock_status := 0;
35499: l_last_updated_by := fnd_global.user_id;
35500: l_last_update_login := fnd_global.login_id;
35501:
35502: IF p_unlock_param = 'INSTANCE'
35503: THEN
35504: IF p_unlock_tbl.COUNT>0