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: ) ;
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
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
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: );
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;
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
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,
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
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
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:
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
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,
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:
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: