APPS.AHL_SUBSCRIPTIONS_PKG dependencies on AHL_SUBSCRIPTIONS_B

Line 41: cursor C is select ROWID from AHL_SUBSCRIPTIONS_B

37: X_LAST_UPDATE_DATE in DATE,
38: X_LAST_UPDATED_BY in NUMBER,
39: X_LAST_UPDATE_LOGIN in NUMBER
40: ) is
41: cursor C is select ROWID from AHL_SUBSCRIPTIONS_B
42: where SUBSCRIPTION_ID = X_SUBSCRIPTION_ID
43: ;
44: begin
45: insert into AHL_SUBSCRIPTIONS_B (

Line 45: insert into AHL_SUBSCRIPTIONS_B (

41: cursor C is select ROWID from AHL_SUBSCRIPTIONS_B
42: where SUBSCRIPTION_ID = X_SUBSCRIPTION_ID
43: ;
44: begin
45: insert into AHL_SUBSCRIPTIONS_B (
46: ATTRIBUTE5,
47: SUBSCRIPTION_ID,
48: DOCUMENT_ID,
49: REQUESTED_BY_PARTY_ID,

Line 216: from AHL_SUBSCRIPTIONS_B

212: SUBSCRIPTION_TYPE_CODE,
213: MEDIA_TYPE_CODE,
214: START_DATE,
215: END_DATE
216: from AHL_SUBSCRIPTIONS_B
217: where SUBSCRIPTION_ID = X_SUBSCRIPTION_ID
218: for update of SUBSCRIPTION_ID nowait;
219: recinfo c%rowtype;
220:

Line 346: update AHL_SUBSCRIPTIONS_B set

342: X_LAST_UPDATED_BY in NUMBER,
343: X_LAST_UPDATE_LOGIN in NUMBER
344: ) is
345: begin
346: update AHL_SUBSCRIPTIONS_B set
347: ATTRIBUTE5 = X_ATTRIBUTE5,
348: DOCUMENT_ID = X_DOCUMENT_ID,
349: REQUESTED_BY_PARTY_ID = X_REQUESTED_BY_PARTY_ID,
350: ATTRIBUTE6 = X_ATTRIBUTE6,

Line 409: delete from AHL_SUBSCRIPTIONS_B

405: if (sql%notfound) then
406: raise no_data_found;
407: end if;
408:
409: delete from AHL_SUBSCRIPTIONS_B
410: where SUBSCRIPTION_ID = X_SUBSCRIPTION_ID;
411:
412: if (sql%notfound) then
413: raise no_data_found;

Line 423: from AHL_SUBSCRIPTIONS_B B

419: begin
420: delete from AHL_SUBSCRIPTIONS_TL T
421: where not exists
422: (select NULL
423: from AHL_SUBSCRIPTIONS_B B
424: where B.SUBSCRIPTION_ID = T.SUBSCRIPTION_ID
425: );
426:
427: update AHL_SUBSCRIPTIONS_TL T set (

Line 521: from AHL_SUBSCRIPTIONS_B

517:
518:
519: cursor c_obj_verno is
520: select object_version_number
521: from AHL_SUBSCRIPTIONS_B
522: where SUBSCRIPTION_ID = X_SUBSCRIPTION_ID;
523:
524: cursor c_chk_rec_exists is
525: select 'x'

Line 526: from AHL_SUBSCRIPTIONS_B

522: where SUBSCRIPTION_ID = X_SUBSCRIPTION_ID;
523:
524: cursor c_chk_rec_exists is
525: select 'x'
526: from AHL_SUBSCRIPTIONS_B
527: where SUBSCRIPTION_ID = X_SUBSCRIPTION_ID;
528:
529: cursor c_get_rec_id is
530: select AHL_SUBSCRIPTIONS_B_S.NEXTVAL

Line 530: select AHL_SUBSCRIPTIONS_B_S.NEXTVAL

526: from AHL_SUBSCRIPTIONS_B
527: where SUBSCRIPTION_ID = X_SUBSCRIPTION_ID;
528:
529: cursor c_get_rec_id is
530: select AHL_SUBSCRIPTIONS_B_S.NEXTVAL
531: from DUAL;
532:
533: BEGIN
534: