APPS.AHL_DI_SUBSCRIPTION_PVT dependencies on AHL_DOCUMENTS_B

Line 92: FROM AHL_DOCUMENTS_B

88: -- Used to validate the document id
89: CURSOR check_doc_info(c_document_id NUMBER)
90: IS
91: SELECT 'X'
92: FROM AHL_DOCUMENTS_B
93: WHERE document_id = c_document_id;
94: -- Cursor to retrieve the exisiting subscription record from base table
95: CURSOR get_sub_rec_b_info (c_subscription_id NUMBER)
96: IS

Line 775: --Check whether Subscribed To is Yes or No in AHL_DOCUMENTS_B

771: */
772:
773: -- Added pjha 15-May-2002 for modifying 'subscribed to' Begin
774:
775: --Check whether Subscribed To is Yes or No in AHL_DOCUMENTS_B
776: SELECT subscribe_to_flag
777: INTO l_subscribe_to_flag
778: FROM AHL_DOCUMENTS_B
779: WHERE document_id = p_x_subscription_tbl(i).document_id;

Line 778: FROM AHL_DOCUMENTS_B

774:
775: --Check whether Subscribed To is Yes or No in AHL_DOCUMENTS_B
776: SELECT subscribe_to_flag
777: INTO l_subscribe_to_flag
778: FROM AHL_DOCUMENTS_B
779: WHERE document_id = p_x_subscription_tbl(i).document_id;
780:
781: --If Subscribed To is no, then make it yes
782: IF l_subscribe_to_flag = 'N' THEN

Line 783: UPDATE AHL_DOCUMENTS_B

779: WHERE document_id = p_x_subscription_tbl(i).document_id;
780:
781: --If Subscribed To is no, then make it yes
782: IF l_subscribe_to_flag = 'N' THEN
783: UPDATE AHL_DOCUMENTS_B
784: SET subscribe_to_flag = 'Y'
785: WHERE document_id = p_x_subscription_tbl(i).document_id;
786: END IF;
787:

Line 1324: UPDATE AHL_DOCUMENTS_B

1320: --Modified pjha 09-Jul-2002 for fixing bug#2452714: Begin
1321: IF (l_end_date IS NULL OR get_max_end_date%NOTFOUND OR l_end_date < TRUNC(sysdate)) THEN
1322: --IF (get_max_end_date%NOTFOUND OR l_end_date < TRUNC(sysdate)) THEN
1323: --Modified pjha 09-Jul-2002 for fixing bug#2452714: End
1324: UPDATE AHL_DOCUMENTS_B
1325: SET subscribe_to_flag = 'N'
1326: WHERE document_id = p_x_subscription_tbl(i).document_id;
1327: ELSE
1328: UPDATE AHL_DOCUMENTS_B

Line 1328: UPDATE AHL_DOCUMENTS_B

1324: UPDATE AHL_DOCUMENTS_B
1325: SET subscribe_to_flag = 'N'
1326: WHERE document_id = p_x_subscription_tbl(i).document_id;
1327: ELSE
1328: UPDATE AHL_DOCUMENTS_B
1329: SET subscribe_to_flag = 'Y'
1330: WHERE document_id = p_x_subscription_tbl(i).document_id;
1331: END IF;
1332: CLOSE get_max_end_date;

Line 1370: UPDATE AHL_DOCUMENTS_B

1366: --Modified pjha 09-Jul-2002 for fixing bug#2452714: Begin
1367: IF (l_end_date IS NULL OR get_max_end_date%NOTFOUND OR l_end_date < TRUNC(sysdate)) THEN
1368: --IF (get_max_end_date%NOTFOUND OR l_end_date < TRUNC(sysdate)) THEN
1369: --Modified pjha 09-Jul-2002 for fixing bug#2452714: End
1370: UPDATE AHL_DOCUMENTS_B
1371: SET subscribe_to_flag = 'N'
1372: WHERE document_id = p_x_subscription_tbl(i).document_id;
1373: ELSE
1374: UPDATE AHL_DOCUMENTS_B

Line 1374: UPDATE AHL_DOCUMENTS_B

1370: UPDATE AHL_DOCUMENTS_B
1371: SET subscribe_to_flag = 'N'
1372: WHERE document_id = p_x_subscription_tbl(i).document_id;
1373: ELSE
1374: UPDATE AHL_DOCUMENTS_B
1375: SET subscribe_to_flag = 'Y'
1376: WHERE document_id = p_x_subscription_tbl(i).document_id;
1377: END IF;
1378: CLOSE get_max_end_date;