APPS.AHL_DI_SUBSCRIPTION_PVT dependencies on AHL_SUBSCRIPTIONS_B

Line 106: FROM AHL_SUBSCRIPTIONS_B

102: subscribed_frm_party_id,
103: start_date,
104: end_date,
105: media_type_code
106: FROM AHL_SUBSCRIPTIONS_B
107: WHERE subscription_id = c_subscription_id;
108: -- Cursor is used to check for duplicate record
109: CURSOR dup_rec(c_document_id NUMBER,
110: c_requested_by_party_id NUMBER)

Line 113: FROM AHL_SUBSCRIPTIONS_B

109: CURSOR dup_rec(c_document_id NUMBER,
110: c_requested_by_party_id NUMBER)
111: IS
112: SELECT 'X'
113: FROM AHL_SUBSCRIPTIONS_B
114: WHERE document_id = c_document_id
115: AND requested_by_party_id = c_requested_by_party_id;
116: --
117:

Line 619: Select AHL_SUBSCRIPTIONS_B_S.Nextval Into

615: l_subscription_info.attribute13 := p_x_subscription_tbl(i).attribute13;
616: l_subscription_info.attribute14 := p_x_subscription_tbl(i).attribute14;
617: l_subscription_info.attribute15 := p_x_subscription_tbl(i).attribute15;
618: -- Retrive the subscription id from sequence
619: Select AHL_SUBSCRIPTIONS_B_S.Nextval Into
620: l_subscription_id from dual;
621: /*-------------------------------------------------------- */
622: /* procedure name: AHL_SUBSCRIPTIONS_PKG.INSERT_ROW */
623: /* description : Added by Senthil to call Table Handler */

Line 667: INSERT INTO AHL_SUBSCRIPTIONS_B

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
668: (
669: SUBSCRIPTION_ID,
670: DOCUMENT_ID,
671: STATUS_CODE,

Line 942: FROM AHL_SUBSCRIPTIONS_B

938: attribute12,
939: attribute13,
940: attribute14,
941: attribute15
942: FROM AHL_SUBSCRIPTIONS_B
943: WHERE subscription_id = c_subscription_id
944: FOR UPDATE OF object_version_number NOWAIT;
945: -- Cursor to retrieve the record from trans table
946: CURSOR get_sub_rec_tl_info(c_subscription_id NUMBER)

Line 960: FROM AHL_SUBSCRIPTIONS_B

956: CURSOR get_old_sub ( c_document_id NUMBER,
957: c_requested_by_party_id NUMBER)
958: IS
959: SELECT subscription_id
960: FROM AHL_SUBSCRIPTIONS_B
961: WHERE document_id = c_document_id AND
962: requested_by_party_id = c_requested_by_party_id;
963:
964: --

Line 970: FROM AHL_SUBSCRIPTIONS_B

966: --Cursor to get maximum end_date for subscriptions for the document
967: CURSOR get_max_end_date(c_document_id NUMBER)
968: IS
969: SELECT MAX(NVL(end_date,SYSDATE))
970: FROM AHL_SUBSCRIPTIONS_B
971: WHERE document_id = c_document_id;
972:
973: --
974: -- Cursor is used to get requested by name given requested id

Line 1268: UPDATE AHL_SUBSCRIPTIONS_B

1264: /*
1265: -- Updates subscriptions record
1266:
1267:
1268: UPDATE AHL_SUBSCRIPTIONS_B
1269: SET document_id = l_subscription_info.document_id,
1270: status_code = l_subscription_info.status_code,
1271: requested_by_party_id = l_subscription_info.requested_by_party_id,
1272: quantity = l_subscription_info.quantity,

Line 1491: FROM AHL_SUBSCRIPTIONS_B

1487: SELECT ROWID,
1488: start_date,
1489: end_date,
1490: object_version_number
1491: FROM AHL_SUBSCRIPTIONS_B
1492: WHERE subscription_id = c_subscription_id
1493: FOR UPDATE OF object_version_number NOWAIT;
1494:
1495: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_SUBSCRIPTION';

Line 1578: UPDATE AHL_SUBSCRIPTIONS_B

1574: X_SUBSCRIPTION_ID => p_x_subscription_tbl(i).subscription_id);
1575:
1576:
1577: /*
1578: UPDATE AHL_SUBSCRIPTIONS_B
1579: SET END_DATE = sysdate
1580: WHERE ROWID = l_rowid;
1581: */
1582: