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 6108: ,p_CREATED_BY => FND_GLOBAL.USER_ID

6104: ,p_ATTRIBUTE12 => p_instance_rec.ATTRIBUTE12
6105: ,p_ATTRIBUTE13 => p_instance_rec.ATTRIBUTE13
6106: ,p_ATTRIBUTE14 => p_instance_rec.ATTRIBUTE14
6107: ,p_ATTRIBUTE15 => p_instance_rec.ATTRIBUTE15
6108: ,p_CREATED_BY => FND_GLOBAL.USER_ID
6109: ,p_CREATION_DATE => SYSDATE
6110: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
6111: ,p_LAST_UPDATE_DATE => SYSDATE
6112: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

Line 6110: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

6106: ,p_ATTRIBUTE14 => p_instance_rec.ATTRIBUTE14
6107: ,p_ATTRIBUTE15 => p_instance_rec.ATTRIBUTE15
6108: ,p_CREATED_BY => FND_GLOBAL.USER_ID
6109: ,p_CREATION_DATE => SYSDATE
6110: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
6111: ,p_LAST_UPDATE_DATE => SYSDATE
6112: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
6113: ,p_OBJECT_VERSION_NUMBER => 1
6114: ,p_LAST_TXN_LINE_DETAIL_ID => p_instance_rec.LAST_TXN_LINE_DETAIL_ID

Line 6112: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

6108: ,p_CREATED_BY => FND_GLOBAL.USER_ID
6109: ,p_CREATION_DATE => SYSDATE
6110: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
6111: ,p_LAST_UPDATE_DATE => SYSDATE
6112: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
6113: ,p_OBJECT_VERSION_NUMBER => 1
6114: ,p_LAST_TXN_LINE_DETAIL_ID => p_instance_rec.LAST_TXN_LINE_DETAIL_ID
6115: ,p_INSTALL_LOCATION_TYPE_CODE => p_instance_rec.INSTALL_LOCATION_TYPE_CODE
6116: ,p_INSTALL_LOCATION_ID => p_instance_rec.INSTALL_LOCATION_ID

Line 6454: ,p_CREATED_BY => FND_GLOBAL.USER_ID

6450: ,p_NEW_ATTRIBUTE14 => p_instance_rec.ATTRIBUTE14
6451: ,p_OLD_ATTRIBUTE14 => NULL
6452: ,p_NEW_ATTRIBUTE15 => p_instance_rec.ATTRIBUTE15
6453: ,p_OLD_ATTRIBUTE15 => NULL
6454: ,p_CREATED_BY => FND_GLOBAL.USER_ID
6455: ,p_CREATION_DATE => SYSDATE
6456: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
6457: ,p_LAST_UPDATE_DATE => SYSDATE
6458: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

Line 6456: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

6452: ,p_NEW_ATTRIBUTE15 => p_instance_rec.ATTRIBUTE15
6453: ,p_OLD_ATTRIBUTE15 => NULL
6454: ,p_CREATED_BY => FND_GLOBAL.USER_ID
6455: ,p_CREATION_DATE => SYSDATE
6456: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
6457: ,p_LAST_UPDATE_DATE => SYSDATE
6458: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
6459: ,p_OBJECT_VERSION_NUMBER => 1
6460: ,p_OLD_INST_LOC_TYPE_CODE => NULL

Line 6458: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

6454: ,p_CREATED_BY => FND_GLOBAL.USER_ID
6455: ,p_CREATION_DATE => SYSDATE
6456: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
6457: ,p_LAST_UPDATE_DATE => SYSDATE
6458: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
6459: ,p_OBJECT_VERSION_NUMBER => 1
6460: ,p_OLD_INST_LOC_TYPE_CODE => NULL
6461: ,p_NEW_INST_LOC_TYPE_CODE => p_instance_rec.INSTALL_LOCATION_TYPE_CODE
6462: ,p_OLD_INST_LOC_ID => NULL

Line 7117: l_user_id NUMBER := FND_GLOBAL.USER_ID;

7113: --Start of:Added for bug 5615169
7114: l_inst_hist_tbl_blk_ins csi_datastructures_pub.instance_history_tbl; -- used for bulk insert
7115: l_inst_hist_rec_tab csi_item_instance_grp.instance_history_rec_tab; -- used for column table
7116: l_ciih_blk_ins_cnt NUMBER := 0;
7117: l_user_id NUMBER := FND_GLOBAL.USER_ID;
7118: l_login_id NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
7119: --End of:Added for bug 5615169
7120:
7121: --Added for bug 7708851, base bug 7239642

Line 7118: l_login_id NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

7114: l_inst_hist_tbl_blk_ins csi_datastructures_pub.instance_history_tbl; -- used for bulk insert
7115: l_inst_hist_rec_tab csi_item_instance_grp.instance_history_rec_tab; -- used for column table
7116: l_ciih_blk_ins_cnt NUMBER := 0;
7117: l_user_id NUMBER := FND_GLOBAL.USER_ID;
7118: l_login_id NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
7119: --End of:Added for bug 5615169
7120:
7121: --Added for bug 7708851, base bug 7239642
7122: l_raise_bes_event VARCHAR2(1) := nvl(fnd_profile.value('CSI_RAISE_BES_CUST_OWNED_INSTANCES'),'N');

Line 7838: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

7834: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
7835: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
7836: p_CREATED_BY => fnd_api.g_miss_num,
7837: p_CREATION_DATE => fnd_api.g_miss_date,
7838: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
7839: p_LAST_UPDATE_DATE => SYSDATE,
7840: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
7841: p_OBJECT_VERSION_NUMBER => p_instance_rec.OBJECT_VERSION_NUMBER,
7842: p_LAST_TXN_LINE_DETAIL_ID => FND_API.G_MISS_NUM,

Line 7840: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,

7836: p_CREATED_BY => fnd_api.g_miss_num,
7837: p_CREATION_DATE => fnd_api.g_miss_date,
7838: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
7839: p_LAST_UPDATE_DATE => SYSDATE,
7840: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
7841: p_OBJECT_VERSION_NUMBER => p_instance_rec.OBJECT_VERSION_NUMBER,
7842: p_LAST_TXN_LINE_DETAIL_ID => FND_API.G_MISS_NUM,
7843: p_INSTALL_LOCATION_TYPE_CODE => p_instance_rec.INSTALL_LOCATION_TYPE_CODE,
7844: p_INSTALL_LOCATION_ID => p_instance_rec.INSTALL_LOCATION_ID,

Line 8132: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

8128: ,p_NEW_ATTRIBUTE15 => fnd_api.g_miss_char
8129: ,p_OLD_ATTRIBUTE15 => fnd_api.g_miss_char
8130: ,p_CREATED_BY => fnd_api.g_miss_num
8131: ,p_CREATION_DATE => fnd_api.g_miss_date
8132: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
8133: ,p_LAST_UPDATE_DATE => SYSDATE
8134: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
8135: ,p_OBJECT_VERSION_NUMBER => fnd_api.g_miss_num
8136: ,p_OLD_INST_LOC_TYPE_CODE => fnd_api.g_miss_char

Line 8134: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

8130: ,p_CREATED_BY => fnd_api.g_miss_num
8131: ,p_CREATION_DATE => fnd_api.g_miss_date
8132: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
8133: ,p_LAST_UPDATE_DATE => SYSDATE
8134: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
8135: ,p_OBJECT_VERSION_NUMBER => fnd_api.g_miss_num
8136: ,p_OLD_INST_LOC_TYPE_CODE => fnd_api.g_miss_char
8137: ,p_NEW_INST_LOC_TYPE_CODE => p_instance_rec.INSTALL_LOCATION_TYPE_CODE
8138: ,p_OLD_INST_LOC_ID => fnd_api.g_miss_num

Line 8760: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

8756: ,p_NEW_ATTRIBUTE15 => fnd_api.g_miss_char
8757: ,p_OLD_ATTRIBUTE15 => fnd_api.g_miss_char
8758: ,p_CREATED_BY => fnd_api.g_miss_num
8759: ,p_CREATION_DATE => fnd_api.g_miss_date
8760: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
8761: ,p_LAST_UPDATE_DATE => SYSDATE
8762: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
8763: ,p_OBJECT_VERSION_NUMBER => fnd_api.g_miss_num
8764: ,p_OLD_INST_LOC_TYPE_CODE => l_ins_hist_csr.OLD_INST_LOC_TYPE_CODE

Line 8762: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

8758: ,p_CREATED_BY => fnd_api.g_miss_num
8759: ,p_CREATION_DATE => fnd_api.g_miss_date
8760: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
8761: ,p_LAST_UPDATE_DATE => SYSDATE
8762: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
8763: ,p_OBJECT_VERSION_NUMBER => fnd_api.g_miss_num
8764: ,p_OLD_INST_LOC_TYPE_CODE => l_ins_hist_csr.OLD_INST_LOC_TYPE_CODE
8765: ,p_NEW_INST_LOC_TYPE_CODE => l_ins_hist_csr.NEW_INST_LOC_TYPE_CODE
8766: ,p_OLD_INST_LOC_ID => l_ins_hist_csr.OLD_INST_LOC_ID

Line 9155: ,p_CREATED_BY => FND_GLOBAL.USER_ID

9151: ,p_NEW_ATTRIBUTE14 => p_instance_rec.ATTRIBUTE14
9152: ,p_OLD_ATTRIBUTE14 => l_curr_instance_rec.ATTRIBUTE14
9153: ,p_NEW_ATTRIBUTE15 => p_instance_rec.ATTRIBUTE15
9154: ,p_OLD_ATTRIBUTE15 => l_curr_instance_rec.ATTRIBUTE15
9155: ,p_CREATED_BY => FND_GLOBAL.USER_ID
9156: ,p_CREATION_DATE => SYSDATE
9157: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
9158: ,p_LAST_UPDATE_DATE => SYSDATE
9159: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

Line 9157: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

9153: ,p_NEW_ATTRIBUTE15 => p_instance_rec.ATTRIBUTE15
9154: ,p_OLD_ATTRIBUTE15 => l_curr_instance_rec.ATTRIBUTE15
9155: ,p_CREATED_BY => FND_GLOBAL.USER_ID
9156: ,p_CREATION_DATE => SYSDATE
9157: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
9158: ,p_LAST_UPDATE_DATE => SYSDATE
9159: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
9160: ,p_OBJECT_VERSION_NUMBER => 1
9161: ,p_OLD_INST_LOC_TYPE_CODE => l_curr_instance_rec.INSTALL_LOCATION_TYPE_CODE

Line 9159: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

9155: ,p_CREATED_BY => FND_GLOBAL.USER_ID
9156: ,p_CREATION_DATE => SYSDATE
9157: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
9158: ,p_LAST_UPDATE_DATE => SYSDATE
9159: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
9160: ,p_OBJECT_VERSION_NUMBER => 1
9161: ,p_OLD_INST_LOC_TYPE_CODE => l_curr_instance_rec.INSTALL_LOCATION_TYPE_CODE
9162: ,p_NEW_INST_LOC_TYPE_CODE => p_instance_rec.INSTALL_LOCATION_TYPE_CODE
9163: ,p_OLD_INST_LOC_ID => l_curr_instance_rec.INSTALL_LOCATION_ID

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

9369: l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).new_attribute14 := p_instance_rec.ATTRIBUTE14;
9370: l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).old_attribute14 := l_curr_instance_rec.ATTRIBUTE14;
9371: l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).new_attribute15 := p_instance_rec.ATTRIBUTE15;
9372: l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).old_attribute15 := l_curr_instance_rec.ATTRIBUTE15;
9373: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).created_by := FND_GLOBAL.USER_ID;
9374: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).creation_date := SYSDATE;
9375: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).last_updated_by := FND_GLOBAL.USER_ID;
9376: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).last_update_date := SYSDATE;
9377: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).last_update_login := FND_GLOBAL.CONC_LOGIN_ID;

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

9371: l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).new_attribute15 := p_instance_rec.ATTRIBUTE15;
9372: l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).old_attribute15 := l_curr_instance_rec.ATTRIBUTE15;
9373: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).created_by := FND_GLOBAL.USER_ID;
9374: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).creation_date := SYSDATE;
9375: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).last_updated_by := FND_GLOBAL.USER_ID;
9376: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).last_update_date := SYSDATE;
9377: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
9378: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).object_version_number := 1;
9379: 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 9377: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).last_update_login := FND_GLOBAL.CONC_LOGIN_ID;

9373: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).created_by := FND_GLOBAL.USER_ID;
9374: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).creation_date := SYSDATE;
9375: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).last_updated_by := FND_GLOBAL.USER_ID;
9376: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).last_update_date := SYSDATE;
9377: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
9378: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).object_version_number := 1;
9379: l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).old_install_location_type_code := l_curr_instance_rec.INSTALL_LOCATION_TYPE_CODE;
9380: l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).new_install_location_type_code := p_instance_rec.INSTALL_LOCATION_TYPE_CODE;
9381: l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).old_install_location_id := l_curr_instance_rec.INSTALL_LOCATION_ID;

Line 9869: ,p_CREATED_BY => FND_GLOBAL.USER_ID

9865: ,p_NEW_ATTRIBUTE14 => FND_API.G_MISS_CHAR
9866: ,p_OLD_ATTRIBUTE14 => FND_API.G_MISS_CHAR
9867: ,p_NEW_ATTRIBUTE15 => FND_API.G_MISS_CHAR
9868: ,p_OLD_ATTRIBUTE15 => FND_API.G_MISS_CHAR
9869: ,p_CREATED_BY => FND_GLOBAL.USER_ID
9870: ,p_CREATION_DATE => SYSDATE
9871: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
9872: ,p_LAST_UPDATE_DATE => SYSDATE
9873: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

Line 9871: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

9867: ,p_NEW_ATTRIBUTE15 => FND_API.G_MISS_CHAR
9868: ,p_OLD_ATTRIBUTE15 => FND_API.G_MISS_CHAR
9869: ,p_CREATED_BY => FND_GLOBAL.USER_ID
9870: ,p_CREATION_DATE => SYSDATE
9871: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
9872: ,p_LAST_UPDATE_DATE => SYSDATE
9873: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
9874: ,p_OBJECT_VERSION_NUMBER => 1
9875: ,p_OLD_INST_LOC_TYPE_CODE => l_instance_hist_rec.OLD_INSTALL_LOCATION_TYPE_CODE

Line 9873: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

9869: ,p_CREATED_BY => FND_GLOBAL.USER_ID
9870: ,p_CREATION_DATE => SYSDATE
9871: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
9872: ,p_LAST_UPDATE_DATE => SYSDATE
9873: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
9874: ,p_OBJECT_VERSION_NUMBER => 1
9875: ,p_OLD_INST_LOC_TYPE_CODE => l_instance_hist_rec.OLD_INSTALL_LOCATION_TYPE_CODE
9876: ,p_NEW_INST_LOC_TYPE_CODE => l_instance_hist_rec.NEW_INSTALL_LOCATION_TYPE_CODE
9877: ,p_OLD_INST_LOC_ID => l_instance_hist_rec.OLD_INSTALL_LOCATION_ID

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

10088: l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).new_attribute14 := p_instance_rec.ATTRIBUTE14;
10089: l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).old_attribute14 := l_curr_instance_rec.ATTRIBUTE14;
10090: l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).new_attribute15 := p_instance_rec.ATTRIBUTE15;
10091: l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).old_attribute15 := l_curr_instance_rec.ATTRIBUTE15;
10092: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).created_by := FND_GLOBAL.USER_ID;
10093: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).creation_date := SYSDATE;
10094: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).last_updated_by := FND_GLOBAL.USER_ID;
10095: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).last_update_date := SYSDATE;
10096: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).last_update_login := FND_GLOBAL.CONC_LOGIN_ID;

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

10090: l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).new_attribute15 := p_instance_rec.ATTRIBUTE15;
10091: l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).old_attribute15 := l_curr_instance_rec.ATTRIBUTE15;
10092: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).created_by := FND_GLOBAL.USER_ID;
10093: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).creation_date := SYSDATE;
10094: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).last_updated_by := FND_GLOBAL.USER_ID;
10095: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).last_update_date := SYSDATE;
10096: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
10097: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).object_version_number := 1;
10098: 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 10096: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).last_update_login := FND_GLOBAL.CONC_LOGIN_ID;

10092: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).created_by := FND_GLOBAL.USER_ID;
10093: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).creation_date := SYSDATE;
10094: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).last_updated_by := FND_GLOBAL.USER_ID;
10095: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).last_update_date := SYSDATE;
10096: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
10097: -- l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).object_version_number := 1;
10098: l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).old_install_location_type_code := l_curr_instance_rec.INSTALL_LOCATION_TYPE_CODE;
10099: l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).new_install_location_type_code := p_instance_rec.INSTALL_LOCATION_TYPE_CODE;
10100: l_inst_hist_tbl_blk_ins(l_ciih_blk_ins_cnt).old_install_location_id := l_curr_instance_rec.INSTALL_LOCATION_ID;

Line 14709: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

14705: p_ATTRIBUTE14 => p_instance_rec.ATTRIBUTE14,
14706: p_ATTRIBUTE15 => p_instance_rec.ATTRIBUTE15,
14707: p_CREATED_BY => fnd_api.g_miss_num,
14708: p_CREATION_DATE => fnd_api.g_miss_date,
14709: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
14710: p_LAST_UPDATE_DATE => SYSDATE,
14711: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
14712: p_OBJECT_VERSION_NUMBER => p_instance_rec.OBJECT_VERSION_NUMBER,
14713: p_LAST_TXN_LINE_DETAIL_ID => p_instance_rec.LAST_TXN_LINE_DETAIL_ID,

Line 14711: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,

14707: p_CREATED_BY => fnd_api.g_miss_num,
14708: p_CREATION_DATE => fnd_api.g_miss_date,
14709: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
14710: p_LAST_UPDATE_DATE => SYSDATE,
14711: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
14712: p_OBJECT_VERSION_NUMBER => p_instance_rec.OBJECT_VERSION_NUMBER,
14713: p_LAST_TXN_LINE_DETAIL_ID => p_instance_rec.LAST_TXN_LINE_DETAIL_ID,
14714: p_INSTALL_LOCATION_TYPE_CODE => p_instance_rec.INSTALL_LOCATION_TYPE_CODE,
14715: p_INSTALL_LOCATION_ID => p_instance_rec.INSTALL_LOCATION_ID,

Line 15232: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

15228: ,p_NEW_ATTRIBUTE15 => p_instance_rec.ATTRIBUTE15
15229: ,p_OLD_ATTRIBUTE15 => fnd_api.g_miss_char
15230: ,p_CREATED_BY => fnd_api.g_miss_num
15231: ,p_CREATION_DATE => fnd_api.g_miss_date
15232: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
15233: ,p_LAST_UPDATE_DATE => SYSDATE
15234: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
15235: ,p_OBJECT_VERSION_NUMBER => fnd_api.g_miss_num
15236: ,p_OLD_INST_LOC_TYPE_CODE => fnd_api.g_miss_char

Line 15234: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

15230: ,p_CREATED_BY => fnd_api.g_miss_num
15231: ,p_CREATION_DATE => fnd_api.g_miss_date
15232: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
15233: ,p_LAST_UPDATE_DATE => SYSDATE
15234: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
15235: ,p_OBJECT_VERSION_NUMBER => fnd_api.g_miss_num
15236: ,p_OLD_INST_LOC_TYPE_CODE => fnd_api.g_miss_char
15237: ,p_NEW_INST_LOC_TYPE_CODE => p_instance_rec.INSTALL_LOCATION_TYPE_CODE
15238: ,p_OLD_INST_LOC_ID => fnd_api.g_miss_num

Line 16963: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

16959: ,p_NEW_ATTRIBUTE15 => l_ins_hist_csr.NEW_ATTRIBUTE15
16960: ,p_OLD_ATTRIBUTE15 => l_ins_hist_csr.OLD_ATTRIBUTE15
16961: ,p_CREATED_BY => fnd_api.g_miss_num
16962: ,p_CREATION_DATE => fnd_api.g_miss_date
16963: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
16964: ,p_LAST_UPDATE_DATE => SYSDATE
16965: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
16966: ,p_OBJECT_VERSION_NUMBER => fnd_api.g_miss_num
16967: ,p_OLD_INST_LOC_TYPE_CODE => l_ins_hist_csr.OLD_INST_LOC_TYPE_CODE

Line 16965: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

16961: ,p_CREATED_BY => fnd_api.g_miss_num
16962: ,p_CREATION_DATE => fnd_api.g_miss_date
16963: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
16964: ,p_LAST_UPDATE_DATE => SYSDATE
16965: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
16966: ,p_OBJECT_VERSION_NUMBER => fnd_api.g_miss_num
16967: ,p_OLD_INST_LOC_TYPE_CODE => l_ins_hist_csr.OLD_INST_LOC_TYPE_CODE
16968: ,p_NEW_INST_LOC_TYPE_CODE => l_ins_hist_csr.NEW_INST_LOC_TYPE_CODE
16969: ,p_OLD_INST_LOC_ID => l_ins_hist_csr.OLD_INST_LOC_ID

Line 17511: ,p_CREATED_BY => FND_GLOBAL.USER_ID

17507: ,p_NEW_ATTRIBUTE14 => p_instance_rec.ATTRIBUTE14
17508: ,p_OLD_ATTRIBUTE14 => l_curr_instance_rec.ATTRIBUTE14
17509: ,p_NEW_ATTRIBUTE15 => p_instance_rec.ATTRIBUTE15
17510: ,p_OLD_ATTRIBUTE15 => l_curr_instance_rec.ATTRIBUTE15
17511: ,p_CREATED_BY => FND_GLOBAL.USER_ID
17512: ,p_CREATION_DATE => SYSDATE
17513: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
17514: ,p_LAST_UPDATE_DATE => SYSDATE
17515: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

Line 17513: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

17509: ,p_NEW_ATTRIBUTE15 => p_instance_rec.ATTRIBUTE15
17510: ,p_OLD_ATTRIBUTE15 => l_curr_instance_rec.ATTRIBUTE15
17511: ,p_CREATED_BY => FND_GLOBAL.USER_ID
17512: ,p_CREATION_DATE => SYSDATE
17513: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
17514: ,p_LAST_UPDATE_DATE => SYSDATE
17515: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
17516: ,p_OBJECT_VERSION_NUMBER => 1
17517: ,p_OLD_INST_LOC_TYPE_CODE => l_curr_instance_rec.INSTALL_LOCATION_TYPE_CODE

Line 17515: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

17511: ,p_CREATED_BY => FND_GLOBAL.USER_ID
17512: ,p_CREATION_DATE => SYSDATE
17513: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
17514: ,p_LAST_UPDATE_DATE => SYSDATE
17515: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
17516: ,p_OBJECT_VERSION_NUMBER => 1
17517: ,p_OLD_INST_LOC_TYPE_CODE => l_curr_instance_rec.INSTALL_LOCATION_TYPE_CODE
17518: ,p_NEW_INST_LOC_TYPE_CODE => p_instance_rec.INSTALL_LOCATION_TYPE_CODE
17519: ,p_OLD_INST_LOC_ID => l_curr_instance_rec.INSTALL_LOCATION_ID

Line 18822: ,p_CREATED_BY => FND_GLOBAL.USER_ID

18818: ,p_NEW_ATTRIBUTE14 => l_instance_hist_rec.NEW_ATTRIBUTE14
18819: ,p_OLD_ATTRIBUTE14 => l_instance_hist_rec.OLD_ATTRIBUTE14
18820: ,p_NEW_ATTRIBUTE15 => l_instance_hist_rec.NEW_ATTRIBUTE15
18821: ,p_OLD_ATTRIBUTE15 => l_instance_hist_rec.OLD_ATTRIBUTE15
18822: ,p_CREATED_BY => FND_GLOBAL.USER_ID
18823: ,p_CREATION_DATE => SYSDATE
18824: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
18825: ,p_LAST_UPDATE_DATE => SYSDATE
18826: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

Line 18824: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

18820: ,p_NEW_ATTRIBUTE15 => l_instance_hist_rec.NEW_ATTRIBUTE15
18821: ,p_OLD_ATTRIBUTE15 => l_instance_hist_rec.OLD_ATTRIBUTE15
18822: ,p_CREATED_BY => FND_GLOBAL.USER_ID
18823: ,p_CREATION_DATE => SYSDATE
18824: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
18825: ,p_LAST_UPDATE_DATE => SYSDATE
18826: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
18827: ,p_OBJECT_VERSION_NUMBER => 1
18828: ,p_OLD_INST_LOC_TYPE_CODE => l_instance_hist_rec.OLD_INSTALL_LOCATION_TYPE_CODE

Line 18826: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

18822: ,p_CREATED_BY => FND_GLOBAL.USER_ID
18823: ,p_CREATION_DATE => SYSDATE
18824: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
18825: ,p_LAST_UPDATE_DATE => SYSDATE
18826: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
18827: ,p_OBJECT_VERSION_NUMBER => 1
18828: ,p_OLD_INST_LOC_TYPE_CODE => l_instance_hist_rec.OLD_INSTALL_LOCATION_TYPE_CODE
18829: ,p_NEW_INST_LOC_TYPE_CODE => l_instance_hist_rec.NEW_INSTALL_LOCATION_TYPE_CODE
18830: ,p_OLD_INST_LOC_ID => l_instance_hist_rec.OLD_INSTALL_LOCATION_ID

Line 19756: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

19752: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
19753: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
19754: p_CREATED_BY => fnd_api.g_miss_num,
19755: p_CREATION_DATE => fnd_api.g_miss_date,
19756: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
19757: p_LAST_UPDATE_DATE => SYSDATE,
19758: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
19759: p_OBJECT_VERSION_NUMBER => l_instance_rec.OBJECT_VERSION_NUMBER,
19760: p_LAST_TXN_LINE_DETAIL_ID => FND_API.G_MISS_NUM,

Line 19758: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,

19754: p_CREATED_BY => fnd_api.g_miss_num,
19755: p_CREATION_DATE => fnd_api.g_miss_date,
19756: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
19757: p_LAST_UPDATE_DATE => SYSDATE,
19758: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
19759: p_OBJECT_VERSION_NUMBER => l_instance_rec.OBJECT_VERSION_NUMBER,
19760: p_LAST_TXN_LINE_DETAIL_ID => FND_API.G_MISS_NUM,
19761: p_INSTALL_LOCATION_TYPE_CODE => FND_API.G_MISS_CHAR,
19762: p_INSTALL_LOCATION_ID => FND_API.G_MISS_NUM,

Line 19960: ,p_CREATED_BY => FND_GLOBAL.USER_ID

19956: ,p_NEW_ATTRIBUTE14 => l_curr_instance_rec.ATTRIBUTE14
19957: ,p_OLD_ATTRIBUTE14 => l_curr_instance_rec.ATTRIBUTE14
19958: ,p_NEW_ATTRIBUTE15 => l_curr_instance_rec.ATTRIBUTE15
19959: ,p_OLD_ATTRIBUTE15 => l_curr_instance_rec.ATTRIBUTE15
19960: ,p_CREATED_BY => FND_GLOBAL.USER_ID
19961: ,p_CREATION_DATE => SYSDATE
19962: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
19963: ,p_LAST_UPDATE_DATE => SYSDATE
19964: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

Line 19962: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

19958: ,p_NEW_ATTRIBUTE15 => l_curr_instance_rec.ATTRIBUTE15
19959: ,p_OLD_ATTRIBUTE15 => l_curr_instance_rec.ATTRIBUTE15
19960: ,p_CREATED_BY => FND_GLOBAL.USER_ID
19961: ,p_CREATION_DATE => SYSDATE
19962: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
19963: ,p_LAST_UPDATE_DATE => SYSDATE
19964: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
19965: ,p_OBJECT_VERSION_NUMBER => 1
19966: ,p_OLD_INST_LOC_TYPE_CODE => l_curr_instance_rec.INSTALL_LOCATION_TYPE_CODE

Line 19964: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

19960: ,p_CREATED_BY => FND_GLOBAL.USER_ID
19961: ,p_CREATION_DATE => SYSDATE
19962: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
19963: ,p_LAST_UPDATE_DATE => SYSDATE
19964: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
19965: ,p_OBJECT_VERSION_NUMBER => 1
19966: ,p_OLD_INST_LOC_TYPE_CODE => l_curr_instance_rec.INSTALL_LOCATION_TYPE_CODE
19967: ,p_NEW_INST_LOC_TYPE_CODE => l_curr_instance_rec.INSTALL_LOCATION_TYPE_CODE
19968: ,p_OLD_INST_LOC_ID => l_curr_instance_rec.INSTALL_LOCATION_ID

Line 20181: ,p_CREATED_BY => FND_GLOBAL.USER_ID

20177: ,p_NEW_ATTRIBUTE14 => FND_API.G_MISS_CHAR
20178: ,p_OLD_ATTRIBUTE14 => FND_API.G_MISS_CHAR
20179: ,p_NEW_ATTRIBUTE15 => FND_API.G_MISS_CHAR
20180: ,p_OLD_ATTRIBUTE15 => FND_API.G_MISS_CHAR
20181: ,p_CREATED_BY => FND_GLOBAL.USER_ID
20182: ,p_CREATION_DATE => SYSDATE
20183: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
20184: ,p_LAST_UPDATE_DATE => SYSDATE
20185: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

Line 20183: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

20179: ,p_NEW_ATTRIBUTE15 => FND_API.G_MISS_CHAR
20180: ,p_OLD_ATTRIBUTE15 => FND_API.G_MISS_CHAR
20181: ,p_CREATED_BY => FND_GLOBAL.USER_ID
20182: ,p_CREATION_DATE => SYSDATE
20183: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
20184: ,p_LAST_UPDATE_DATE => SYSDATE
20185: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
20186: ,p_OBJECT_VERSION_NUMBER => 1
20187: ,p_OLD_INST_LOC_TYPE_CODE => FND_API.G_MISS_CHAR

Line 20185: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

20181: ,p_CREATED_BY => FND_GLOBAL.USER_ID
20182: ,p_CREATION_DATE => SYSDATE
20183: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
20184: ,p_LAST_UPDATE_DATE => SYSDATE
20185: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
20186: ,p_OBJECT_VERSION_NUMBER => 1
20187: ,p_OLD_INST_LOC_TYPE_CODE => FND_API.G_MISS_CHAR
20188: ,p_NEW_INST_LOC_TYPE_CODE => FND_API.G_MISS_CHAR
20189: ,p_OLD_INST_LOC_ID => FND_API.G_MISS_NUM

Line 21042: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

21038: p_ATTRIBUTE14 => l_instance_rec.ATTRIBUTE14,
21039: p_ATTRIBUTE15 => l_instance_rec.ATTRIBUTE15,
21040: p_CREATED_BY => fnd_api.g_miss_num,
21041: p_CREATION_DATE => fnd_api.g_miss_date,
21042: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
21043: p_LAST_UPDATE_DATE => SYSDATE,
21044: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
21045: p_OBJECT_VERSION_NUMBER => l_instance_rec.OBJECT_VERSION_NUMBER,
21046: p_LAST_TXN_LINE_DETAIL_ID => l_instance_rec.LAST_TXN_LINE_DETAIL_ID,

Line 21044: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,

21040: p_CREATED_BY => fnd_api.g_miss_num,
21041: p_CREATION_DATE => fnd_api.g_miss_date,
21042: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
21043: p_LAST_UPDATE_DATE => SYSDATE,
21044: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
21045: p_OBJECT_VERSION_NUMBER => l_instance_rec.OBJECT_VERSION_NUMBER,
21046: p_LAST_TXN_LINE_DETAIL_ID => l_instance_rec.LAST_TXN_LINE_DETAIL_ID,
21047: p_INSTALL_LOCATION_TYPE_CODE => l_instance_rec.INSTALL_LOCATION_TYPE_CODE,
21048: p_INSTALL_LOCATION_ID => l_instance_rec.INSTALL_LOCATION_ID,

Line 21257: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

21253: ,p_NEW_ATTRIBUTE15 => p_instance_rec.ATTRIBUTE15
21254: ,p_OLD_ATTRIBUTE15 => fnd_api.g_miss_char
21255: ,p_CREATED_BY => fnd_api.g_miss_num
21256: ,p_CREATION_DATE => fnd_api.g_miss_date
21257: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
21258: ,p_LAST_UPDATE_DATE => SYSDATE
21259: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
21260: ,p_OBJECT_VERSION_NUMBER => fnd_api.g_miss_num
21261: ,p_OLD_INST_LOC_TYPE_CODE => fnd_api.g_miss_char

Line 21259: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

21255: ,p_CREATED_BY => fnd_api.g_miss_num
21256: ,p_CREATION_DATE => fnd_api.g_miss_date
21257: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
21258: ,p_LAST_UPDATE_DATE => SYSDATE
21259: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
21260: ,p_OBJECT_VERSION_NUMBER => fnd_api.g_miss_num
21261: ,p_OLD_INST_LOC_TYPE_CODE => fnd_api.g_miss_char
21262: ,p_NEW_INST_LOC_TYPE_CODE => p_instance_rec.INSTALL_LOCATION_TYPE_CODE
21263: ,p_OLD_INST_LOC_ID => fnd_api.g_miss_num

Line 21482: ,p_CREATED_BY => FND_GLOBAL.USER_ID

21478: ,p_NEW_ATTRIBUTE14 => l_curr_instance_rec.ATTRIBUTE14
21479: ,p_OLD_ATTRIBUTE14 => l_curr_instance_rec.ATTRIBUTE14
21480: ,p_NEW_ATTRIBUTE15 => l_curr_instance_rec.ATTRIBUTE15
21481: ,p_OLD_ATTRIBUTE15 => l_curr_instance_rec.ATTRIBUTE15
21482: ,p_CREATED_BY => FND_GLOBAL.USER_ID
21483: ,p_CREATION_DATE => SYSDATE
21484: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
21485: ,p_LAST_UPDATE_DATE => SYSDATE
21486: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

Line 21484: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

21480: ,p_NEW_ATTRIBUTE15 => l_curr_instance_rec.ATTRIBUTE15
21481: ,p_OLD_ATTRIBUTE15 => l_curr_instance_rec.ATTRIBUTE15
21482: ,p_CREATED_BY => FND_GLOBAL.USER_ID
21483: ,p_CREATION_DATE => SYSDATE
21484: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
21485: ,p_LAST_UPDATE_DATE => SYSDATE
21486: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
21487: ,p_OBJECT_VERSION_NUMBER => 1
21488: ,p_OLD_INST_LOC_TYPE_CODE => l_curr_instance_rec.INSTALL_LOCATION_TYPE_CODE

Line 21486: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

21482: ,p_CREATED_BY => FND_GLOBAL.USER_ID
21483: ,p_CREATION_DATE => SYSDATE
21484: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
21485: ,p_LAST_UPDATE_DATE => SYSDATE
21486: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
21487: ,p_OBJECT_VERSION_NUMBER => 1
21488: ,p_OLD_INST_LOC_TYPE_CODE => l_curr_instance_rec.INSTALL_LOCATION_TYPE_CODE
21489: ,p_NEW_INST_LOC_TYPE_CODE => l_curr_instance_rec.INSTALL_LOCATION_TYPE_CODE
21490: ,p_OLD_INST_LOC_ID => l_curr_instance_rec.INSTALL_LOCATION_ID

Line 21704: ,p_CREATED_BY => FND_GLOBAL.USER_ID

21700: ,p_NEW_ATTRIBUTE14 => l_instance_rec.ATTRIBUTE14
21701: ,p_OLD_ATTRIBUTE14 => l_instance_rec.ATTRIBUTE14
21702: ,p_NEW_ATTRIBUTE15 => l_instance_rec.ATTRIBUTE15
21703: ,p_OLD_ATTRIBUTE15 => l_instance_rec.ATTRIBUTE15
21704: ,p_CREATED_BY => FND_GLOBAL.USER_ID
21705: ,p_CREATION_DATE => SYSDATE
21706: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
21707: ,p_LAST_UPDATE_DATE => SYSDATE
21708: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

Line 21706: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

21702: ,p_NEW_ATTRIBUTE15 => l_instance_rec.ATTRIBUTE15
21703: ,p_OLD_ATTRIBUTE15 => l_instance_rec.ATTRIBUTE15
21704: ,p_CREATED_BY => FND_GLOBAL.USER_ID
21705: ,p_CREATION_DATE => SYSDATE
21706: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
21707: ,p_LAST_UPDATE_DATE => SYSDATE
21708: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
21709: ,p_OBJECT_VERSION_NUMBER => 1
21710: ,p_OLD_INST_LOC_TYPE_CODE => l_instance_rec.INSTALL_LOCATION_TYPE_CODE

Line 21708: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

21704: ,p_CREATED_BY => FND_GLOBAL.USER_ID
21705: ,p_CREATION_DATE => SYSDATE
21706: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
21707: ,p_LAST_UPDATE_DATE => SYSDATE
21708: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
21709: ,p_OBJECT_VERSION_NUMBER => 1
21710: ,p_OLD_INST_LOC_TYPE_CODE => l_instance_rec.INSTALL_LOCATION_TYPE_CODE
21711: ,p_NEW_INST_LOC_TYPE_CODE => l_instance_rec.INSTALL_LOCATION_TYPE_CODE
21712: ,p_OLD_INST_LOC_ID => l_instance_rec.INSTALL_LOCATION_ID

Line 23750: p_CREATED_BY => FND_GLOBAL.USER_ID ,

23746: p_ATTRIBUTE12 => p_version_label_rec.attribute12,
23747: p_ATTRIBUTE13 => p_version_label_rec.attribute13,
23748: p_ATTRIBUTE14 => p_version_label_rec.attribute14,
23749: p_ATTRIBUTE15 => p_version_label_rec.attribute15,
23750: p_CREATED_BY => FND_GLOBAL.USER_ID ,
23751: p_CREATION_DATE => SYSDATE ,
23752: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
23753: p_LAST_UPDATE_DATE => SYSDATE ,
23754: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,

Line 23752: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,

23748: p_ATTRIBUTE14 => p_version_label_rec.attribute14,
23749: p_ATTRIBUTE15 => p_version_label_rec.attribute15,
23750: p_CREATED_BY => FND_GLOBAL.USER_ID ,
23751: p_CREATION_DATE => SYSDATE ,
23752: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
23753: p_LAST_UPDATE_DATE => SYSDATE ,
23754: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,
23755: p_OBJECT_VERSION_NUMBER => 1 );
23756:

Line 23754: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,

23750: p_CREATED_BY => FND_GLOBAL.USER_ID ,
23751: p_CREATION_DATE => SYSDATE ,
23752: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
23753: p_LAST_UPDATE_DATE => SYSDATE ,
23754: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,
23755: p_OBJECT_VERSION_NUMBER => 1 );
23756:
23757:
23758: -- Call create_transaction to create txn log

Line 23837: p_CREATED_BY => FND_GLOBAL.USER_ID ,

23833: p_NEW_ATTRIBUTE14 => p_version_label_rec.ATTRIBUTE14,
23834: p_OLD_ATTRIBUTE15 => NULL ,
23835: p_NEW_ATTRIBUTE15 => p_version_label_rec.ATTRIBUTE15,
23836: p_FULL_DUMP_FLAG => 'N' ,
23837: p_CREATED_BY => FND_GLOBAL.USER_ID ,
23838: p_CREATION_DATE => SYSDATE ,
23839: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
23840: p_LAST_UPDATE_DATE => SYSDATE ,
23841: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,

Line 23839: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,

23835: p_NEW_ATTRIBUTE15 => p_version_label_rec.ATTRIBUTE15,
23836: p_FULL_DUMP_FLAG => 'N' ,
23837: p_CREATED_BY => FND_GLOBAL.USER_ID ,
23838: p_CREATION_DATE => SYSDATE ,
23839: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
23840: p_LAST_UPDATE_DATE => SYSDATE ,
23841: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,
23842: p_OBJECT_VERSION_NUMBER => 1 );
23843:

Line 23841: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,

23837: p_CREATED_BY => FND_GLOBAL.USER_ID ,
23838: p_CREATION_DATE => SYSDATE ,
23839: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
23840: p_LAST_UPDATE_DATE => SYSDATE ,
23841: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,
23842: p_OBJECT_VERSION_NUMBER => 1 );
23843:
23844:
23845: --

Line 24077: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,

24073: p_ATTRIBUTE14 => p_version_label_rec.ATTRIBUTE14,
24074: p_ATTRIBUTE15 => p_version_label_rec.ATTRIBUTE15,
24075: p_CREATED_BY => fnd_api.g_miss_num ,
24076: p_CREATION_DATE => fnd_api.g_miss_date ,
24077: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
24078: p_LAST_UPDATE_DATE => sysdate ,
24079: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
24080: p_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER );
24081:

Line 24079: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,

24075: p_CREATED_BY => fnd_api.g_miss_num ,
24076: p_CREATION_DATE => fnd_api.g_miss_date ,
24077: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
24078: p_LAST_UPDATE_DATE => sysdate ,
24079: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
24080: p_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER );
24081:
24082:
24083: -- Call create_transaction to create txn log

Line 24194: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,

24190: p_NEW_ATTRIBUTE15 => p_version_label_rec.ATTRIBUTE15 ,
24191: p_FULL_DUMP_FLAG => fnd_api.g_miss_char ,
24192: p_CREATED_BY => fnd_api.g_miss_num ,
24193: p_CREATION_DATE => fnd_api.g_miss_date ,
24194: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
24195: p_LAST_UPDATE_DATE => SYSDATE ,
24196: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,
24197: p_OBJECT_VERSION_NUMBER => fnd_api.g_miss_num );
24198:

Line 24196: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,

24192: p_CREATED_BY => fnd_api.g_miss_num ,
24193: p_CREATION_DATE => fnd_api.g_miss_date ,
24194: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
24195: p_LAST_UPDATE_DATE => SYSDATE ,
24196: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,
24197: p_OBJECT_VERSION_NUMBER => fnd_api.g_miss_num );
24198:
24199: ELSE
24200: --

Line 24567: p_last_updated_by => fnd_global.user_id ,

24563: p_new_attribute15 => l_version_hist_csr.new_attribute15 ,
24564: p_full_dump_flag => fnd_api.g_miss_char ,
24565: p_created_by => fnd_api.g_miss_num ,
24566: p_creation_date => fnd_api.g_miss_date ,
24567: p_last_updated_by => fnd_global.user_id ,
24568: p_last_update_date => SYSDATE ,
24569: p_last_update_login => fnd_global.login_id ,
24570: p_object_version_number => fnd_api.g_miss_num );
24571: END IF;

Line 24569: p_last_update_login => fnd_global.login_id ,

24565: p_created_by => fnd_api.g_miss_num ,
24566: p_creation_date => fnd_api.g_miss_date ,
24567: p_last_updated_by => fnd_global.user_id ,
24568: p_last_update_date => SYSDATE ,
24569: p_last_update_login => fnd_global.login_id ,
24570: p_object_version_number => fnd_api.g_miss_num );
24571: END IF;
24572: EXCEPTION
24573: WHEN NO_DATA_FOUND THEN

Line 24694: p_CREATED_BY => FND_GLOBAL.USER_ID ,

24690: p_NEW_ATTRIBUTE14 => p_version_label_rec.ATTRIBUTE14,
24691: p_OLD_ATTRIBUTE15 => l_temp_ver_label_rec.ATTRIBUTE15 ,
24692: p_NEW_ATTRIBUTE15 => p_version_label_rec.ATTRIBUTE15,
24693: p_FULL_DUMP_FLAG => 'Y' ,
24694: p_CREATED_BY => FND_GLOBAL.USER_ID ,
24695: p_CREATION_DATE => SYSDATE ,
24696: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
24697: p_LAST_UPDATE_DATE => SYSDATE ,
24698: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,

Line 24696: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,

24692: p_NEW_ATTRIBUTE15 => p_version_label_rec.ATTRIBUTE15,
24693: p_FULL_DUMP_FLAG => 'Y' ,
24694: p_CREATED_BY => FND_GLOBAL.USER_ID ,
24695: p_CREATION_DATE => SYSDATE ,
24696: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
24697: p_LAST_UPDATE_DATE => SYSDATE ,
24698: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,
24699: p_OBJECT_VERSION_NUMBER => 1 );
24700:

Line 24698: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,

24694: p_CREATED_BY => FND_GLOBAL.USER_ID ,
24695: p_CREATION_DATE => SYSDATE ,
24696: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
24697: p_LAST_UPDATE_DATE => SYSDATE ,
24698: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,
24699: p_OBJECT_VERSION_NUMBER => 1 );
24700:
24701:
24702: ELSE

Line 24965: p_CREATED_BY => FND_GLOBAL.USER_ID ,

24961: p_NEW_ATTRIBUTE14 => l_ver_label_hist_rec.NEW_ATTRIBUTE14,
24962: p_OLD_ATTRIBUTE15 => l_ver_label_hist_rec.OLD_ATTRIBUTE15,
24963: p_NEW_ATTRIBUTE15 => l_ver_label_hist_rec.NEW_ATTRIBUTE15,
24964: p_FULL_DUMP_FLAG => 'N' ,
24965: p_CREATED_BY => FND_GLOBAL.USER_ID ,
24966: p_CREATION_DATE => SYSDATE ,
24967: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
24968: p_LAST_UPDATE_DATE => SYSDATE ,
24969: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,

Line 24967: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,

24963: p_NEW_ATTRIBUTE15 => l_ver_label_hist_rec.NEW_ATTRIBUTE15,
24964: p_FULL_DUMP_FLAG => 'N' ,
24965: p_CREATED_BY => FND_GLOBAL.USER_ID ,
24966: p_CREATION_DATE => SYSDATE ,
24967: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
24968: p_LAST_UPDATE_DATE => SYSDATE ,
24969: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,
24970: p_OBJECT_VERSION_NUMBER => 1 );
24971:

Line 24969: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,

24965: p_CREATED_BY => FND_GLOBAL.USER_ID ,
24966: p_CREATION_DATE => SYSDATE ,
24967: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
24968: p_LAST_UPDATE_DATE => SYSDATE ,
24969: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,
24970: p_OBJECT_VERSION_NUMBER => 1 );
24971:
24972:
24973: END IF;

Line 25195: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,

25191: p_ATTRIBUTE14 => l_version_label_rec.ATTRIBUTE14,
25192: p_ATTRIBUTE15 => l_version_label_rec.ATTRIBUTE15,
25193: p_CREATED_BY => fnd_api.g_miss_num ,
25194: p_CREATION_DATE => fnd_api.g_miss_date ,
25195: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
25196: p_LAST_UPDATE_DATE => sysdate ,
25197: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,
25198: p_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER );
25199:

Line 25197: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,

25193: p_CREATED_BY => fnd_api.g_miss_num ,
25194: p_CREATION_DATE => fnd_api.g_miss_date ,
25195: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
25196: p_LAST_UPDATE_DATE => sysdate ,
25197: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,
25198: p_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER );
25199:
25200:
25201: -- Call create_transaction to create txn log

Line 25299: p_CREATED_BY => FND_GLOBAL.USER_ID ,

25295: p_NEW_ATTRIBUTE14 => l_curr_ver_label_rec.ATTRIBUTE14,
25296: p_OLD_ATTRIBUTE15 => l_curr_ver_label_rec.ATTRIBUTE15,
25297: p_NEW_ATTRIBUTE15 => l_curr_ver_label_rec.ATTRIBUTE15,
25298: p_FULL_DUMP_FLAG => 'Y' ,
25299: p_CREATED_BY => FND_GLOBAL.USER_ID ,
25300: p_CREATION_DATE => SYSDATE ,
25301: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
25302: p_LAST_UPDATE_DATE => SYSDATE ,
25303: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,

Line 25301: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,

25297: p_NEW_ATTRIBUTE15 => l_curr_ver_label_rec.ATTRIBUTE15,
25298: p_FULL_DUMP_FLAG => 'Y' ,
25299: p_CREATED_BY => FND_GLOBAL.USER_ID ,
25300: p_CREATION_DATE => SYSDATE ,
25301: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
25302: p_LAST_UPDATE_DATE => SYSDATE ,
25303: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,
25304: p_OBJECT_VERSION_NUMBER => 1 );
25305:

Line 25303: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,

25299: p_CREATED_BY => FND_GLOBAL.USER_ID ,
25300: p_CREATION_DATE => SYSDATE ,
25301: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
25302: p_LAST_UPDATE_DATE => SYSDATE ,
25303: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,
25304: p_OBJECT_VERSION_NUMBER => 1 );
25305:
25306:
25307: ELSE

Line 25360: p_CREATED_BY => FND_GLOBAL.USER_ID ,

25356: p_NEW_ATTRIBUTE14 => l_version_label_rec.ATTRIBUTE14 ,
25357: p_OLD_ATTRIBUTE15 => l_version_label_rec.ATTRIBUTE15 ,
25358: p_NEW_ATTRIBUTE15 => l_version_label_rec.ATTRIBUTE15 ,
25359: p_FULL_DUMP_FLAG => 'N' ,
25360: p_CREATED_BY => FND_GLOBAL.USER_ID ,
25361: p_CREATION_DATE => SYSDATE ,
25362: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
25363: p_LAST_UPDATE_DATE => SYSDATE ,
25364: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,

Line 25362: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,

25358: p_NEW_ATTRIBUTE15 => l_version_label_rec.ATTRIBUTE15 ,
25359: p_FULL_DUMP_FLAG => 'N' ,
25360: p_CREATED_BY => FND_GLOBAL.USER_ID ,
25361: p_CREATION_DATE => SYSDATE ,
25362: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
25363: p_LAST_UPDATE_DATE => SYSDATE ,
25364: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,
25365: p_OBJECT_VERSION_NUMBER => 1 );
25366:

Line 25364: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,

25360: p_CREATED_BY => FND_GLOBAL.USER_ID ,
25361: p_CREATION_DATE => SYSDATE ,
25362: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID ,
25363: p_LAST_UPDATE_DATE => SYSDATE ,
25364: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID ,
25365: p_OBJECT_VERSION_NUMBER => 1 );
25366:
25367:
25368: END IF;

Line 26398: ,fnd_global.user_id

26394: ,p_ext_attrib_rec.attribute12
26395: ,p_ext_attrib_rec.attribute13
26396: ,p_ext_attrib_rec.attribute14
26397: ,p_ext_attrib_rec.attribute15
26398: ,fnd_global.user_id
26399: ,sysdate
26400: ,fnd_global.user_id
26401: ,sysdate
26402: ,fnd_global.user_id

Line 26400: ,fnd_global.user_id

26396: ,p_ext_attrib_rec.attribute14
26397: ,p_ext_attrib_rec.attribute15
26398: ,fnd_global.user_id
26399: ,sysdate
26400: ,fnd_global.user_id
26401: ,sysdate
26402: ,fnd_global.user_id
26403: ,1
26404: );

Line 26402: ,fnd_global.user_id

26398: ,fnd_global.user_id
26399: ,sysdate
26400: ,fnd_global.user_id
26401: ,sysdate
26402: ,fnd_global.user_id
26403: ,1
26404: );
26405:
26406:

Line 26486: ,fnd_global.user_id

26482: ,p_ext_attrib_rec.ATTRIBUTE14
26483: ,NULL
26484: ,p_ext_attrib_rec.ATTRIBUTE15
26485: ,l_dump_frequency_flag
26486: ,fnd_global.user_id
26487: ,sysdate
26488: ,fnd_global.user_id
26489: ,sysdate
26490: ,fnd_global.user_id

Line 26488: ,fnd_global.user_id

26484: ,p_ext_attrib_rec.ATTRIBUTE15
26485: ,l_dump_frequency_flag
26486: ,fnd_global.user_id
26487: ,sysdate
26488: ,fnd_global.user_id
26489: ,sysdate
26490: ,fnd_global.user_id
26491: ,1);
26492:

Line 26490: ,fnd_global.user_id

26486: ,fnd_global.user_id
26487: ,sysdate
26488: ,fnd_global.user_id
26489: ,sysdate
26490: ,fnd_global.user_id
26491: ,1);
26492:
26493:
26494: -- END IF;

Line 26764: ,fnd_global.user_id

26760: ,p_ext_attrib_rec.attribute14
26761: ,p_ext_attrib_rec.attribute15
26762: ,fnd_api.g_miss_num
26763: ,fnd_api.g_miss_date
26764: ,fnd_global.user_id
26765: ,sysdate
26766: ,fnd_global.user_id
26767: ,l_ext_attrib_rec.object_version_number
26768: );

Line 26766: ,fnd_global.user_id

26762: ,fnd_api.g_miss_num
26763: ,fnd_api.g_miss_date
26764: ,fnd_global.user_id
26765: ,sysdate
26766: ,fnd_global.user_id
26767: ,l_ext_attrib_rec.object_version_number
26768: );
26769:
26770:

Line 26874: p_last_updated_by => fnd_global.user_id ,

26870: p_new_attribute15 => l_temp_ext_attrib_rec.attribute15 ,
26871: p_full_dump_flag => fnd_api.g_miss_char ,
26872: p_created_by => fnd_api.g_miss_num ,
26873: p_creation_date => fnd_api.g_miss_date ,
26874: p_last_updated_by => fnd_global.user_id ,
26875: p_last_update_date => sysdate ,
26876: p_last_update_login => fnd_global.user_id ,
26877: p_object_version_number => fnd_api.g_miss_num);
26878:

Line 26876: p_last_update_login => fnd_global.user_id ,

26872: p_created_by => fnd_api.g_miss_num ,
26873: p_creation_date => fnd_api.g_miss_date ,
26874: p_last_updated_by => fnd_global.user_id ,
26875: p_last_update_date => sysdate ,
26876: p_last_update_login => fnd_global.user_id ,
26877: p_object_version_number => fnd_api.g_miss_num);
26878:
26879: ELSE
26880: --

Line 27212: p_last_updated_by => fnd_global.user_id ,

27208: p_new_attribute15 => l_temp_ext_attrib_rec.attribute15 ,
27209: p_full_dump_flag => fnd_api.g_miss_char ,
27210: p_created_by => fnd_api.g_miss_num ,
27211: p_creation_date => fnd_api.g_miss_date ,
27212: p_last_updated_by => fnd_global.user_id ,
27213: p_last_update_date => SYSDATE ,
27214: p_last_update_login => fnd_global.user_id ,
27215: p_object_version_number => fnd_api.g_miss_num);
27216: END IF;

Line 27214: p_last_update_login => fnd_global.user_id ,

27210: p_created_by => fnd_api.g_miss_num ,
27211: p_creation_date => fnd_api.g_miss_date ,
27212: p_last_updated_by => fnd_global.user_id ,
27213: p_last_update_date => SYSDATE ,
27214: p_last_update_login => fnd_global.user_id ,
27215: p_object_version_number => fnd_api.g_miss_num);
27216: END IF;
27217: EXCEPTION
27218: WHEN NO_DATA_FOUND THEN

Line 27336: ,fnd_global.user_id

27332: ,l_temp_ext_attrib_rec.ATTRIBUTE14
27333: ,l_ext_attrib_rec.ATTRIBUTE15
27334: ,l_temp_ext_attrib_rec.ATTRIBUTE15
27335: ,l_dump_frequency_flag
27336: ,fnd_global.user_id
27337: ,sysdate
27338: ,fnd_global.user_id
27339: ,sysdate
27340: ,fnd_global.user_id

Line 27338: ,fnd_global.user_id

27334: ,l_temp_ext_attrib_rec.ATTRIBUTE15
27335: ,l_dump_frequency_flag
27336: ,fnd_global.user_id
27337: ,sysdate
27338: ,fnd_global.user_id
27339: ,sysdate
27340: ,fnd_global.user_id
27341: ,1);
27342:

Line 27340: ,fnd_global.user_id

27336: ,fnd_global.user_id
27337: ,sysdate
27338: ,fnd_global.user_id
27339: ,sysdate
27340: ,fnd_global.user_id
27341: ,1);
27342:
27343: ELSE
27344: l_dump_frequency_flag := 'N';

Line 27584: ,fnd_global.user_id

27580: ,l_ext_att_hist_rec.new_attribute14
27581: ,l_ext_att_hist_rec.old_attribute15
27582: ,l_ext_att_hist_rec.new_attribute15
27583: ,l_dump_frequency_flag
27584: ,fnd_global.user_id
27585: ,sysdate
27586: ,fnd_global.user_id
27587: ,sysdate
27588: ,fnd_global.user_id

Line 27586: ,fnd_global.user_id

27582: ,l_ext_att_hist_rec.new_attribute15
27583: ,l_dump_frequency_flag
27584: ,fnd_global.user_id
27585: ,sysdate
27586: ,fnd_global.user_id
27587: ,sysdate
27588: ,fnd_global.user_id
27589: ,1);
27590:

Line 27588: ,fnd_global.user_id

27584: ,fnd_global.user_id
27585: ,sysdate
27586: ,fnd_global.user_id
27587: ,sysdate
27588: ,fnd_global.user_id
27589: ,1);
27590:
27591: END IF;
27592: END;

Line 35946: ,fnd_global.user_id

35942: ,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)
35943: ,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)
35944: ,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)
35945: ,SYSDATE --p_txn_rec.source_transaction_date
35946: ,fnd_global.user_id
35947: ,SYSDATE
35948: ,1
35949: ,fnd_global.user_id
35950: ,fnd_global.user_id

Line 35949: ,fnd_global.user_id

35945: ,SYSDATE --p_txn_rec.source_transaction_date
35946: ,fnd_global.user_id
35947: ,SYSDATE
35948: ,1
35949: ,fnd_global.user_id
35950: ,fnd_global.user_id
35951: ,SYSDATE
35952: );
35953: END IF;

Line 35950: ,fnd_global.user_id

35946: ,fnd_global.user_id
35947: ,SYSDATE
35948: ,1
35949: ,fnd_global.user_id
35950: ,fnd_global.user_id
35951: ,SYSDATE
35952: );
35953: END IF;
35954: END LOOP;

Line 36160: l_last_updated_by := fnd_global.user_id;

36156: l_last_update_login NUMBER;
36157: l_unlock_status NUMBER;
36158: BEGIN
36159: l_unlock_status := 0;
36160: l_last_updated_by := fnd_global.user_id;
36161: l_last_update_login := fnd_global.login_id;
36162:
36163: IF p_unlock_param = 'INSTANCE'
36164: THEN

Line 36161: l_last_update_login := fnd_global.login_id;

36157: l_unlock_status NUMBER;
36158: BEGIN
36159: l_unlock_status := 0;
36160: l_last_updated_by := fnd_global.user_id;
36161: l_last_update_login := fnd_global.login_id;
36162:
36163: IF p_unlock_param = 'INSTANCE'
36164: THEN
36165: IF p_unlock_tbl.COUNT>0