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_DI_SUBSCRIPTION_PVT dependencies on FND_GLOBAL

Line 660: X_CREATED_BY => fnd_global.user_id,

656: X_START_DATE => l_subscription_info.start_date,
657: X_END_DATE => l_subscription_info.end_date,
658: X_COMMENTS => l_subscription_info.comments,
659: X_CREATION_DATE => sysdate,
660: X_CREATED_BY => fnd_global.user_id,
661: X_LAST_UPDATE_DATE => sysdate,
662: X_LAST_UPDATED_BY => fnd_global.user_id,
663: X_LAST_UPDATE_LOGIN => fnd_global.login_id
664: ) ;

Line 662: X_LAST_UPDATED_BY => fnd_global.user_id,

658: X_COMMENTS => l_subscription_info.comments,
659: X_CREATION_DATE => sysdate,
660: X_CREATED_BY => fnd_global.user_id,
661: X_LAST_UPDATE_DATE => sysdate,
662: X_LAST_UPDATED_BY => fnd_global.user_id,
663: X_LAST_UPDATE_LOGIN => fnd_global.login_id
664: ) ;
665: /*
666: -- Insert the new record into subscriptions table

Line 663: X_LAST_UPDATE_LOGIN => fnd_global.login_id

659: X_CREATION_DATE => sysdate,
660: X_CREATED_BY => fnd_global.user_id,
661: X_LAST_UPDATE_DATE => sysdate,
662: X_LAST_UPDATED_BY => fnd_global.user_id,
663: X_LAST_UPDATE_LOGIN => fnd_global.login_id
664: ) ;
665: /*
666: -- Insert the new record into subscriptions table
667: INSERT INTO AHL_SUBSCRIPTIONS_B

Line 736: fnd_global.user_id,

732: l_subscription_info.attribute13,
733: l_subscription_info.attribute14,
734: l_subscription_info.attribute15,
735: sysdate,
736: fnd_global.user_id,
737: sysdate,
738: fnd_global.user_id,
739: fnd_global.login_id
740: );

Line 738: fnd_global.user_id,

734: l_subscription_info.attribute15,
735: sysdate,
736: fnd_global.user_id,
737: sysdate,
738: fnd_global.user_id,
739: fnd_global.login_id
740: );
741: p_x_subscription_tbl(i).subscription_id := l_subscription_id;
742: p_x_subscription_tbl(i).object_version_number := 1;

Line 739: fnd_global.login_id

735: sysdate,
736: fnd_global.user_id,
737: sysdate,
738: fnd_global.user_id,
739: fnd_global.login_id
740: );
741: p_x_subscription_tbl(i).subscription_id := l_subscription_id;
742: p_x_subscription_tbl(i).object_version_number := 1;
743: -- Insert the record into trans table

Line 758: fnd_global.user_id,

754: )
755: SELECT
756: l_subscription_id,
757: sysdate,
758: fnd_global.user_id,
759: sysdate,
760: fnd_global.user_id,
761: l_subscription_info.comments,
762: L.LANGUAGE_CODE,

Line 760: fnd_global.user_id,

756: l_subscription_id,
757: sysdate,
758: fnd_global.user_id,
759: sysdate,
760: fnd_global.user_id,
761: l_subscription_info.comments,
762: L.LANGUAGE_CODE,
763: userenv('LANG')
764: FROM FND_LANGUAGES L

Line 1261: X_LAST_UPDATED_BY => fnd_global.user_id,

1257: X_START_DATE => l_subscription_info.start_date,
1258: X_END_DATE => l_subscription_info.end_date,
1259: X_COMMENTS => l_comments,
1260: X_LAST_UPDATE_DATE => sysdate,
1261: X_LAST_UPDATED_BY => fnd_global.user_id,
1262: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1263: );
1264: /*
1265: -- Updates subscriptions record

Line 1262: X_LAST_UPDATE_LOGIN => fnd_global.login_id

1258: X_END_DATE => l_subscription_info.end_date,
1259: X_COMMENTS => l_comments,
1260: X_LAST_UPDATE_DATE => sysdate,
1261: X_LAST_UPDATED_BY => fnd_global.user_id,
1262: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1263: );
1264: /*
1265: -- Updates subscriptions record
1266:

Line 1298: last_updated_by = fnd_global.user_id,

1294: attribute13 = l_subscription_info.attribute13,
1295: attribute14 = l_subscription_info.attribute14,
1296: attribute15 = l_subscription_info.attribute15,
1297: last_update_date = sysdate,
1298: last_updated_by = fnd_global.user_id,
1299: last_update_login = fnd_global.login_id
1300: WHERE subscription_id = p_x_subscription_tbl(i).subscription_id;
1301: --Update the tranlation table
1302: UPDATE AHL_SUBSCRIPTIONS_TL

Line 1299: last_update_login = fnd_global.login_id

1295: attribute14 = l_subscription_info.attribute14,
1296: attribute15 = l_subscription_info.attribute15,
1297: last_update_date = sysdate,
1298: last_updated_by = fnd_global.user_id,
1299: last_update_login = fnd_global.login_id
1300: WHERE subscription_id = p_x_subscription_tbl(i).subscription_id;
1301: --Update the tranlation table
1302: UPDATE AHL_SUBSCRIPTIONS_TL
1303: SET comments = l_comments,

Line 1305: last_updated_by = fnd_global.user_id,

1301: --Update the tranlation table
1302: UPDATE AHL_SUBSCRIPTIONS_TL
1303: SET comments = l_comments,
1304: last_update_date = sysdate,
1305: last_updated_by = fnd_global.user_id,
1306: last_update_login = fnd_global.login_id
1307: WHERE SUBSCRIPTION_ID = p_x_subscription_tbl(i).subscription_id
1308: AND userenv('LANG') in (LANGUAGE, SOURCE_LANG);
1309:

Line 1306: last_update_login = fnd_global.login_id

1302: UPDATE AHL_SUBSCRIPTIONS_TL
1303: SET comments = l_comments,
1304: last_update_date = sysdate,
1305: last_updated_by = fnd_global.user_id,
1306: last_update_login = fnd_global.login_id
1307: WHERE SUBSCRIPTION_ID = p_x_subscription_tbl(i).subscription_id
1308: AND userenv('LANG') in (LANGUAGE, SOURCE_LANG);
1309:
1310: