APPS.AHL_DI_SUBSCRIPTION_PVT dependencies on AHL_SUBSCRIPTIONS_TL

Line 744: INSERT INTO AHL_SUBSCRIPTIONS_TL

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
744: INSERT INTO AHL_SUBSCRIPTIONS_TL
745: (
746: SUBSCRIPTION_ID,
747: LAST_UPDATE_DATE,
748: LAST_UPDATED_BY,

Line 768: FROM AHL_SUBSCRIPTIONS_TL T

764: FROM FND_LANGUAGES L
765: WHERE L.INSTALLED_FLAG IN ('I','B')
766: AND NOT EXISTS
767: (SELECT NULL
768: FROM AHL_SUBSCRIPTIONS_TL T
769: WHERE T.subscription_id = l_subscription_id
770: AND T.language = L.LANGUAGE_CODE);
771: */
772:

Line 950: FROM AHL_SUBSCRIPTIONS_TL

946: CURSOR get_sub_rec_tl_info(c_subscription_id NUMBER)
947: IS
948: SELECT ROWID,
949: comments
950: FROM AHL_SUBSCRIPTIONS_TL
951: WHERE subscription_id = c_subscription_id
952: FOR UPDATE OF subscription_id NOWAIT;
953:
954: -- modified the code for fixing Bug 2183529

Line 1302: UPDATE AHL_SUBSCRIPTIONS_TL

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,
1304: last_update_date = sysdate,
1305: last_updated_by = fnd_global.user_id,
1306: last_update_login = fnd_global.login_id