APPS.AHL_DI_SUBSCRIPTION_PVT dependencies on AHL_SUBSCRIPTIONS_PKG

Line 622: /* procedure name: AHL_SUBSCRIPTIONS_PKG.INSERT_ROW */

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 */
624: /* Date : Dec 31 2001 */
625: /*---------------------------------------------------------*/
626: -- Insert the new record into subscriptions table and trans table

Line 627: AHL_SUBSCRIPTIONS_PKG.INSERT_ROW (

623: /* description : Added by Senthil to call Table Handler */
624: /* Date : Dec 31 2001 */
625: /*---------------------------------------------------------*/
626: -- Insert the new record into subscriptions table and trans table
627: AHL_SUBSCRIPTIONS_PKG.INSERT_ROW (
628: X_ROWID => l_rowid,
629: X_SUBSCRIPTION_ID => l_subscription_id,
630: X_ATTRIBUTE5 => l_subscription_info.attribute5,
631: X_DOCUMENT_ID => p_x_subscription_tbl(i).document_id,

Line 1220: /* procedure name: AHL_SUBSCRIPTIONS_PKG.UPDATE_ROW */

1216: l_subscription_info.attribute14 := p_x_subscription_tbl(i).attribute14;
1217: l_subscription_info.attribute15 := p_x_subscription_tbl(i).attribute15;
1218:
1219: /*-------------------------------------------------------- */
1220: /* procedure name: AHL_SUBSCRIPTIONS_PKG.UPDATE_ROW */
1221: /* description : Added by Senthil to call Table Handler */
1222: /* Date : Dec 31 2001 */
1223: /*---------------------------------------------------------*/
1224: -- Updates subscriptions record and tranlation table

Line 1229: AHL_SUBSCRIPTIONS_PKG.UPDATE_ROW (

1225: --Enhancement nos #2034767 and #2205830: pbarman : April 2003
1226: IF (p_x_subscription_tbl(i).subscription_id IS NOT NULL AND
1227: NVL(p_x_subscription_tbl(i).delete_flag, 'N') = 'N' )
1228: THEN
1229: AHL_SUBSCRIPTIONS_PKG.UPDATE_ROW (
1230: X_SUBSCRIPTION_ID => p_x_subscription_tbl(i).subscription_id,
1231: X_ATTRIBUTE5 => l_subscription_info.attribute5,
1232: X_DOCUMENT_ID => l_subscription_info.document_id,
1233: X_REQUESTED_BY_PARTY_ID => l_subscription_info.requested_by_party_id,

Line 1573: AHL_SUBSCRIPTIONS_PKG.DELETE_ROW(

1569: -- Modified pjha 15-May-2002 for modifying 'subscribed to' Begin
1570:
1571:
1572: -- Modified pjha 14-Jun-2002 for deleting the row: Begin
1573: AHL_SUBSCRIPTIONS_PKG.DELETE_ROW(
1574: X_SUBSCRIPTION_ID => p_x_subscription_tbl(i).subscription_id);
1575:
1576:
1577: /*