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.

APPS.AHL_UC_INSTANCE_PVT dependencies on FND_GLOBAL

Line 579: last_updated_by = FND_GLOBAL.user_id,

575: SET unit_config_status_code = 'INCOMPLETE',
576: active_uc_status_code = 'UNAPPROVED',
577: object_version_number = object_version_number + 1,
578: last_update_date = SYSDATE,
579: last_updated_by = FND_GLOBAL.user_id,
580: last_update_login = FND_GLOBAL.login_id
581: WHERE unit_config_header_id = l_root_uc_header_id
582: AND object_version_number = l_root_uc_ovn;
583: IF SQL%ROWCOUNT = 0 THEN

Line 580: last_update_login = FND_GLOBAL.login_id

576: active_uc_status_code = 'UNAPPROVED',
577: object_version_number = object_version_number + 1,
578: last_update_date = SYSDATE,
579: last_updated_by = FND_GLOBAL.user_id,
580: last_update_login = FND_GLOBAL.login_id
581: WHERE unit_config_header_id = l_root_uc_header_id
582: AND object_version_number = l_root_uc_ovn;
583: IF SQL%ROWCOUNT = 0 THEN
584: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

Line 595: last_updated_by = FND_GLOBAL.user_id,

591: UPDATE ahl_unit_config_headers
592: SET active_uc_status_code = 'UNAPPROVED',
593: object_version_number = object_version_number + 1,
594: last_update_date = SYSDATE,
595: last_updated_by = FND_GLOBAL.user_id,
596: last_update_login = FND_GLOBAL.login_id
597: WHERE unit_config_header_id = l_root_uc_header_id
598: AND object_version_number = l_root_uc_ovn;
599: IF SQL%ROWCOUNT = 0 THEN

Line 596: last_update_login = FND_GLOBAL.login_id

592: SET active_uc_status_code = 'UNAPPROVED',
593: object_version_number = object_version_number + 1,
594: last_update_date = SYSDATE,
595: last_updated_by = FND_GLOBAL.user_id,
596: last_update_login = FND_GLOBAL.login_id
597: WHERE unit_config_header_id = l_root_uc_header_id
598: AND object_version_number = l_root_uc_ovn;
599: IF SQL%ROWCOUNT = 0 THEN
600: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

Line 609: last_updated_by = FND_GLOBAL.user_id,

605: UPDATE ahl_unit_config_headers
606: SET unit_config_status_code = 'DRAFT',
607: object_version_number = object_version_number + 1,
608: last_update_date = SYSDATE,
609: last_updated_by = FND_GLOBAL.user_id,
610: last_update_login = FND_GLOBAL.login_id
611: WHERE unit_config_header_id = l_root_uc_header_id
612: AND object_version_number = l_root_uc_ovn;
613: IF SQL%ROWCOUNT = 0 THEN

Line 610: last_update_login = FND_GLOBAL.login_id

606: SET unit_config_status_code = 'DRAFT',
607: object_version_number = object_version_number + 1,
608: last_update_date = SYSDATE,
609: last_updated_by = FND_GLOBAL.user_id,
610: last_update_login = FND_GLOBAL.login_id
611: WHERE unit_config_header_id = l_root_uc_header_id
612: AND object_version_number = l_root_uc_ovn;
613: IF SQL%ROWCOUNT = 0 THEN
614: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

Line 625: last_updated_by = FND_GLOBAL.user_id,

621: UPDATE ahl_unit_config_headers
622: SET unit_config_status_code = 'INCOMPLETE',
623: object_version_number = object_version_number + 1,
624: last_update_date = SYSDATE,
625: last_updated_by = FND_GLOBAL.user_id,
626: last_update_login = FND_GLOBAL.login_id
627: WHERE unit_config_header_id = l_root_uc_header_id
628: AND object_version_number = l_root_uc_ovn;
629: IF SQL%ROWCOUNT = 0 THEN

Line 626: last_update_login = FND_GLOBAL.login_id

622: SET unit_config_status_code = 'INCOMPLETE',
623: object_version_number = object_version_number + 1,
624: last_update_date = SYSDATE,
625: last_updated_by = FND_GLOBAL.user_id,
626: last_update_login = FND_GLOBAL.login_id
627: WHERE unit_config_header_id = l_root_uc_header_id
628: AND object_version_number = l_root_uc_ovn;
629: IF SQL%ROWCOUNT = 0 THEN
630: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

Line 1079: last_updated_by = FND_GLOBAL.user_id,

1075: unit_config_status_code = l_uc_status_code,
1076: active_uc_status_code = l_active_uc_status_code,
1077: object_version_number = object_version_number + 1,
1078: last_update_date = SYSDATE,
1079: last_updated_by = FND_GLOBAL.user_id,
1080: last_update_login = FND_GLOBAL.login_id
1081: WHERE unit_config_header_id = l_sub_uc_header_id;
1082: --Not necessary to check the object_version_number here
1083:

Line 1080: last_update_login = FND_GLOBAL.login_id

1076: active_uc_status_code = l_active_uc_status_code,
1077: object_version_number = object_version_number + 1,
1078: last_update_date = SYSDATE,
1079: last_updated_by = FND_GLOBAL.user_id,
1080: last_update_login = FND_GLOBAL.login_id
1081: WHERE unit_config_header_id = l_sub_uc_header_id;
1082: --Not necessary to check the object_version_number here
1083:
1084: --Copy the change to UC history table

Line 1112: last_updated_by = FND_GLOBAL.user_id,

1108: unit_config_status_code = l_uc_status_code,
1109: active_uc_status_code = l_active_uc_status_code,
1110: object_version_number = object_version_number + 1,
1111: last_update_date = SYSDATE,
1112: last_updated_by = FND_GLOBAL.user_id,
1113: last_update_login = FND_GLOBAL.login_id
1114: WHERE unit_config_header_id = l_sub_uc_header_id;
1115: --csi_item_instance_id = l_get_1st_level_subunit.subject_id
1116: --AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);

Line 1113: last_update_login = FND_GLOBAL.login_id

1109: active_uc_status_code = l_active_uc_status_code,
1110: object_version_number = object_version_number + 1,
1111: last_update_date = SYSDATE,
1112: last_updated_by = FND_GLOBAL.user_id,
1113: last_update_login = FND_GLOBAL.login_id
1114: WHERE unit_config_header_id = l_sub_uc_header_id;
1115: --csi_item_instance_id = l_get_1st_level_subunit.subject_id
1116: --AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
1117: --Not necessary to check the object_version_number here

Line 1158: last_updated_by = FND_GLOBAL.user_id,

1154: SET unit_config_status_code = 'INCOMPLETE',
1155: active_uc_status_code = 'UNAPPROVED',
1156: object_version_number = object_version_number + 1,
1157: last_update_date = SYSDATE,
1158: last_updated_by = FND_GLOBAL.user_id,
1159: last_update_login = FND_GLOBAL.login_id
1160: WHERE unit_config_header_id = l_root_uc_header_id
1161: AND object_version_number = l_root_uc_ovn;
1162: IF SQL%ROWCOUNT = 0 THEN

Line 1159: last_update_login = FND_GLOBAL.login_id

1155: active_uc_status_code = 'UNAPPROVED',
1156: object_version_number = object_version_number + 1,
1157: last_update_date = SYSDATE,
1158: last_updated_by = FND_GLOBAL.user_id,
1159: last_update_login = FND_GLOBAL.login_id
1160: WHERE unit_config_header_id = l_root_uc_header_id
1161: AND object_version_number = l_root_uc_ovn;
1162: IF SQL%ROWCOUNT = 0 THEN
1163: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

Line 1176: last_updated_by = FND_GLOBAL.user_id,

1172: UPDATE ahl_unit_config_headers
1173: SET active_uc_status_code = 'UNAPPROVED',
1174: object_version_number = object_version_number + 1,
1175: last_update_date = SYSDATE,
1176: last_updated_by = FND_GLOBAL.user_id,
1177: last_update_login = FND_GLOBAL.login_id
1178: WHERE unit_config_header_id = l_root_uc_header_id
1179: AND object_version_number = l_root_uc_ovn;
1180: IF SQL%ROWCOUNT = 0 THEN

Line 1177: last_update_login = FND_GLOBAL.login_id

1173: SET active_uc_status_code = 'UNAPPROVED',
1174: object_version_number = object_version_number + 1,
1175: last_update_date = SYSDATE,
1176: last_updated_by = FND_GLOBAL.user_id,
1177: last_update_login = FND_GLOBAL.login_id
1178: WHERE unit_config_header_id = l_root_uc_header_id
1179: AND object_version_number = l_root_uc_ovn;
1180: IF SQL%ROWCOUNT = 0 THEN
1181: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

Line 1192: last_updated_by = FND_GLOBAL.user_id,

1188: UPDATE ahl_unit_config_headers
1189: SET unit_config_status_code = 'DRAFT',
1190: object_version_number = object_version_number + 1,
1191: last_update_date = SYSDATE,
1192: last_updated_by = FND_GLOBAL.user_id,
1193: last_update_login = FND_GLOBAL.login_id
1194: WHERE unit_config_header_id = l_root_uc_header_id
1195: AND object_version_number = l_root_uc_ovn;
1196: IF SQL%ROWCOUNT = 0 THEN

Line 1193: last_update_login = FND_GLOBAL.login_id

1189: SET unit_config_status_code = 'DRAFT',
1190: object_version_number = object_version_number + 1,
1191: last_update_date = SYSDATE,
1192: last_updated_by = FND_GLOBAL.user_id,
1193: last_update_login = FND_GLOBAL.login_id
1194: WHERE unit_config_header_id = l_root_uc_header_id
1195: AND object_version_number = l_root_uc_ovn;
1196: IF SQL%ROWCOUNT = 0 THEN
1197: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

Line 1208: last_updated_by = FND_GLOBAL.user_id,

1204: UPDATE ahl_unit_config_headers
1205: SET unit_config_status_code = 'INCOMPLETE',
1206: object_version_number = object_version_number + 1,
1207: last_update_date = SYSDATE,
1208: last_updated_by = FND_GLOBAL.user_id,
1209: last_update_login = FND_GLOBAL.login_id
1210: WHERE unit_config_header_id = l_root_uc_header_id
1211: AND object_version_number = l_root_uc_ovn;
1212: IF SQL%ROWCOUNT = 0 THEN

Line 1209: last_update_login = FND_GLOBAL.login_id

1205: SET unit_config_status_code = 'INCOMPLETE',
1206: object_version_number = object_version_number + 1,
1207: last_update_date = SYSDATE,
1208: last_updated_by = FND_GLOBAL.user_id,
1209: last_update_login = FND_GLOBAL.login_id
1210: WHERE unit_config_header_id = l_root_uc_header_id
1211: AND object_version_number = l_root_uc_ovn;
1212: IF SQL%ROWCOUNT = 0 THEN
1213: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

Line 2113: last_updated_by = FND_GLOBAL.user_id,

2109: SET unit_config_status_code = 'INCOMPLETE',
2110: active_uc_status_code = 'UNAPPROVED',
2111: object_version_number = object_version_number + 1,
2112: last_update_date = SYSDATE,
2113: last_updated_by = FND_GLOBAL.user_id,
2114: last_update_login = FND_GLOBAL.login_id
2115: WHERE unit_config_header_id = l_root_uc_header_id
2116: AND object_version_number = l_root_uc_ovn;
2117: IF SQL%ROWCOUNT = 0 THEN

Line 2114: last_update_login = FND_GLOBAL.login_id

2110: active_uc_status_code = 'UNAPPROVED',
2111: object_version_number = object_version_number + 1,
2112: last_update_date = SYSDATE,
2113: last_updated_by = FND_GLOBAL.user_id,
2114: last_update_login = FND_GLOBAL.login_id
2115: WHERE unit_config_header_id = l_root_uc_header_id
2116: AND object_version_number = l_root_uc_ovn;
2117: IF SQL%ROWCOUNT = 0 THEN
2118: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

Line 2130: last_updated_by = FND_GLOBAL.user_id,

2126: SET unit_config_status_code = 'INCOMPLETE',
2127: active_uc_status_code = 'UNAPPROVED',
2128: object_version_number = object_version_number + 1,
2129: last_update_date = SYSDATE,
2130: last_updated_by = FND_GLOBAL.user_id,
2131: last_update_login = FND_GLOBAL.login_id
2132: WHERE unit_config_header_id = l_root_uc_header_id
2133: AND object_version_number = l_root_uc_ovn;
2134: IF SQL%ROWCOUNT = 0 THEN

Line 2131: last_update_login = FND_GLOBAL.login_id

2127: active_uc_status_code = 'UNAPPROVED',
2128: object_version_number = object_version_number + 1,
2129: last_update_date = SYSDATE,
2130: last_updated_by = FND_GLOBAL.user_id,
2131: last_update_login = FND_GLOBAL.login_id
2132: WHERE unit_config_header_id = l_root_uc_header_id
2133: AND object_version_number = l_root_uc_ovn;
2134: IF SQL%ROWCOUNT = 0 THEN
2135: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

Line 2146: last_updated_by = FND_GLOBAL.user_id,

2142: UPDATE ahl_unit_config_headers
2143: SET unit_config_status_code = 'DRAFT',
2144: object_version_number = object_version_number + 1,
2145: last_update_date = SYSDATE,
2146: last_updated_by = FND_GLOBAL.user_id,
2147: last_update_login = FND_GLOBAL.login_id
2148: WHERE unit_config_header_id = l_root_uc_header_id
2149: AND object_version_number = l_root_uc_ovn;
2150: IF SQL%ROWCOUNT = 0 THEN

Line 2147: last_update_login = FND_GLOBAL.login_id

2143: SET unit_config_status_code = 'DRAFT',
2144: object_version_number = object_version_number + 1,
2145: last_update_date = SYSDATE,
2146: last_updated_by = FND_GLOBAL.user_id,
2147: last_update_login = FND_GLOBAL.login_id
2148: WHERE unit_config_header_id = l_root_uc_header_id
2149: AND object_version_number = l_root_uc_ovn;
2150: IF SQL%ROWCOUNT = 0 THEN
2151: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

Line 3170: last_updated_by = FND_GLOBAL.user_id,

3166: SET unit_config_status_code = 'INCOMPLETE',
3167: active_uc_status_code = 'UNAPPROVED',
3168: object_version_number = object_version_number + 1,
3169: last_update_date = SYSDATE,
3170: last_updated_by = FND_GLOBAL.user_id,
3171: last_update_login = FND_GLOBAL.login_id
3172: WHERE unit_config_header_id = l_root_uc_header_id
3173: AND object_version_number = l_root_uc_ovn;
3174: IF SQL%ROWCOUNT = 0 THEN

Line 3171: last_update_login = FND_GLOBAL.login_id

3167: active_uc_status_code = 'UNAPPROVED',
3168: object_version_number = object_version_number + 1,
3169: last_update_date = SYSDATE,
3170: last_updated_by = FND_GLOBAL.user_id,
3171: last_update_login = FND_GLOBAL.login_id
3172: WHERE unit_config_header_id = l_root_uc_header_id
3173: AND object_version_number = l_root_uc_ovn;
3174: IF SQL%ROWCOUNT = 0 THEN
3175: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

Line 3188: last_updated_by = FND_GLOBAL.user_id,

3184: UPDATE ahl_unit_config_headers
3185: SET active_uc_status_code = 'UNAPPROVED',
3186: object_version_number = object_version_number + 1,
3187: last_update_date = SYSDATE,
3188: last_updated_by = FND_GLOBAL.user_id,
3189: last_update_login = FND_GLOBAL.login_id
3190: WHERE unit_config_header_id = l_root_uc_header_id
3191: AND object_version_number = l_root_uc_ovn;
3192: IF SQL%ROWCOUNT = 0 THEN

Line 3189: last_update_login = FND_GLOBAL.login_id

3185: SET active_uc_status_code = 'UNAPPROVED',
3186: object_version_number = object_version_number + 1,
3187: last_update_date = SYSDATE,
3188: last_updated_by = FND_GLOBAL.user_id,
3189: last_update_login = FND_GLOBAL.login_id
3190: WHERE unit_config_header_id = l_root_uc_header_id
3191: AND object_version_number = l_root_uc_ovn;
3192: IF SQL%ROWCOUNT = 0 THEN
3193: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

Line 3210: last_updated_by = FND_GLOBAL.user_id,

3206: UPDATE ahl_unit_config_headers
3207: SET unit_config_status_code = 'DRAFT',
3208: object_version_number = object_version_number + 1,
3209: last_update_date = SYSDATE,
3210: last_updated_by = FND_GLOBAL.user_id,
3211: last_update_login = FND_GLOBAL.login_id
3212: WHERE unit_config_header_id = l_root_uc_header_id
3213: AND object_version_number = l_root_uc_ovn;
3214: IF SQL%ROWCOUNT = 0 THEN

Line 3211: last_update_login = FND_GLOBAL.login_id

3207: SET unit_config_status_code = 'DRAFT',
3208: object_version_number = object_version_number + 1,
3209: last_update_date = SYSDATE,
3210: last_updated_by = FND_GLOBAL.user_id,
3211: last_update_login = FND_GLOBAL.login_id
3212: WHERE unit_config_header_id = l_root_uc_header_id
3213: AND object_version_number = l_root_uc_ovn;
3214: IF SQL%ROWCOUNT = 0 THEN
3215: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

Line 3227: last_updated_by = FND_GLOBAL.user_id,

3223: UPDATE ahl_unit_config_headers
3224: SET unit_config_status_code = 'INCOMPLETE',
3225: object_version_number = object_version_number + 1,
3226: last_update_date = SYSDATE,
3227: last_updated_by = FND_GLOBAL.user_id,
3228: last_update_login = FND_GLOBAL.login_id
3229: WHERE unit_config_header_id = l_root_uc_header_id
3230: AND object_version_number = l_root_uc_ovn;
3231: IF SQL%ROWCOUNT = 0 THEN

Line 3228: last_update_login = FND_GLOBAL.login_id

3224: SET unit_config_status_code = 'INCOMPLETE',
3225: object_version_number = object_version_number + 1,
3226: last_update_date = SYSDATE,
3227: last_updated_by = FND_GLOBAL.user_id,
3228: last_update_login = FND_GLOBAL.login_id
3229: WHERE unit_config_header_id = l_root_uc_header_id
3230: AND object_version_number = l_root_uc_ovn;
3231: IF SQL%ROWCOUNT = 0 THEN
3232: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

Line 4186: last_updated_by = FND_GLOBAL.user_id,

4182: --installed instance.
4183: SET parent_uc_header_id = l_parent_uc_header_id,
4184: object_version_number = object_version_number + 1,
4185: last_update_date = SYSDATE,
4186: last_updated_by = FND_GLOBAL.user_id,
4187: last_update_login = FND_GLOBAL.login_id
4188: WHERE csi_item_instance_id = p_instance_id
4189: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
4190: --Not necessary to check the object_version_number here

Line 4187: last_update_login = FND_GLOBAL.login_id

4183: SET parent_uc_header_id = l_parent_uc_header_id,
4184: object_version_number = object_version_number + 1,
4185: last_update_date = SYSDATE,
4186: last_updated_by = FND_GLOBAL.user_id,
4187: last_update_login = FND_GLOBAL.login_id
4188: WHERE csi_item_instance_id = p_instance_id
4189: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
4190: --Not necessary to check the object_version_number here
4191: --Copy the change to history table

Line 4207: last_updated_by = FND_GLOBAL.user_id,

4203: UPDATE ahl_unit_config_headers
4204: SET parent_uc_header_id = l_parent_uc_header_id,
4205: object_version_number = object_version_number + 1,
4206: last_update_date = SYSDATE,
4207: last_updated_by = FND_GLOBAL.user_id,
4208: last_update_login = FND_GLOBAL.login_id
4209: WHERE csi_item_instance_id = l_get_1st_level_subunit.subject_id
4210: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
4211: --Not necessary to check the object_version_number here

Line 4208: last_update_login = FND_GLOBAL.login_id

4204: SET parent_uc_header_id = l_parent_uc_header_id,
4205: object_version_number = object_version_number + 1,
4206: last_update_date = SYSDATE,
4207: last_updated_by = FND_GLOBAL.user_id,
4208: last_update_login = FND_GLOBAL.login_id
4209: WHERE csi_item_instance_id = l_get_1st_level_subunit.subject_id
4210: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
4211: --Not necessary to check the object_version_number here
4212:

Line 4295: last_updated_by = FND_GLOBAL.user_id,

4291: SET unit_config_status_code = 'INCOMPLETE',
4292: active_uc_status_code = 'UNAPPROVED',
4293: object_version_number = object_version_number + 1,
4294: last_update_date = SYSDATE,
4295: last_updated_by = FND_GLOBAL.user_id,
4296: last_update_login = FND_GLOBAL.login_id
4297: WHERE unit_config_header_id = l_root_uc_header_id
4298: AND object_version_number = l_root_uc_ovn;
4299: IF SQL%ROWCOUNT = 0 THEN

Line 4296: last_update_login = FND_GLOBAL.login_id

4292: active_uc_status_code = 'UNAPPROVED',
4293: object_version_number = object_version_number + 1,
4294: last_update_date = SYSDATE,
4295: last_updated_by = FND_GLOBAL.user_id,
4296: last_update_login = FND_GLOBAL.login_id
4297: WHERE unit_config_header_id = l_root_uc_header_id
4298: AND object_version_number = l_root_uc_ovn;
4299: IF SQL%ROWCOUNT = 0 THEN
4300: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

Line 4313: last_updated_by = FND_GLOBAL.user_id,

4309: UPDATE ahl_unit_config_headers
4310: SET active_uc_status_code = 'UNAPPROVED',
4311: object_version_number = object_version_number + 1,
4312: last_update_date = SYSDATE,
4313: last_updated_by = FND_GLOBAL.user_id,
4314: last_update_login = FND_GLOBAL.login_id
4315: WHERE unit_config_header_id = l_root_uc_header_id
4316: AND object_version_number = l_root_uc_ovn;
4317: IF SQL%ROWCOUNT = 0 THEN

Line 4314: last_update_login = FND_GLOBAL.login_id

4310: SET active_uc_status_code = 'UNAPPROVED',
4311: object_version_number = object_version_number + 1,
4312: last_update_date = SYSDATE,
4313: last_updated_by = FND_GLOBAL.user_id,
4314: last_update_login = FND_GLOBAL.login_id
4315: WHERE unit_config_header_id = l_root_uc_header_id
4316: AND object_version_number = l_root_uc_ovn;
4317: IF SQL%ROWCOUNT = 0 THEN
4318: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

Line 4335: last_updated_by = FND_GLOBAL.user_id,

4331: UPDATE ahl_unit_config_headers
4332: SET unit_config_status_code = 'DRAFT',
4333: object_version_number = object_version_number + 1,
4334: last_update_date = SYSDATE,
4335: last_updated_by = FND_GLOBAL.user_id,
4336: last_update_login = FND_GLOBAL.login_id
4337: WHERE unit_config_header_id = l_root_uc_header_id
4338: AND object_version_number = l_root_uc_ovn;
4339: IF SQL%ROWCOUNT = 0 THEN

Line 4336: last_update_login = FND_GLOBAL.login_id

4332: SET unit_config_status_code = 'DRAFT',
4333: object_version_number = object_version_number + 1,
4334: last_update_date = SYSDATE,
4335: last_updated_by = FND_GLOBAL.user_id,
4336: last_update_login = FND_GLOBAL.login_id
4337: WHERE unit_config_header_id = l_root_uc_header_id
4338: AND object_version_number = l_root_uc_ovn;
4339: IF SQL%ROWCOUNT = 0 THEN
4340: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

Line 4352: last_updated_by = FND_GLOBAL.user_id,

4348: UPDATE ahl_unit_config_headers
4349: SET unit_config_status_code = 'INCOMPLETE',
4350: object_version_number = object_version_number + 1,
4351: last_update_date = SYSDATE,
4352: last_updated_by = FND_GLOBAL.user_id,
4353: last_update_login = FND_GLOBAL.login_id
4354: WHERE unit_config_header_id = l_root_uc_header_id
4355: AND object_version_number = l_root_uc_ovn;
4356: IF SQL%ROWCOUNT = 0 THEN

Line 4353: last_update_login = FND_GLOBAL.login_id

4349: SET unit_config_status_code = 'INCOMPLETE',
4350: object_version_number = object_version_number + 1,
4351: last_update_date = SYSDATE,
4352: last_updated_by = FND_GLOBAL.user_id,
4353: last_update_login = FND_GLOBAL.login_id
4354: WHERE unit_config_header_id = l_root_uc_header_id
4355: AND object_version_number = l_root_uc_ovn;
4356: IF SQL%ROWCOUNT = 0 THEN
4357: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );