DBA Data[Home] [Help]

APPS.AHL_DOCUMENTS_PKG dependencies on AHL_DOCUMENTS_B_S

Line 321: update AHL_DOCUMENTS_B set

317: X_LAST_UPDATED_BY in NUMBER,
318: X_LAST_UPDATE_LOGIN in NUMBER
319: ) is
320: begin
321: update AHL_DOCUMENTS_B set
322: SUBSCRIBE_AVAIL_FLAG = X_SUBSCRIBE_AVAIL_FLAG,
323: SUBSCRIBE_TO_FLAG = X_SUBSCRIBE_TO_FLAG,
324: DOC_TYPE_CODE = X_DOC_TYPE_CODE,
325: DOC_SUB_TYPE_CODE = X_DOC_SUB_TYPE_CODE,

Line 527: SELECT AHL_DOCUMENTS_B_S.Nextval INTO

523:
524: exception
525: when NO_DATA_FOUND then
526:
527: SELECT AHL_DOCUMENTS_B_S.Nextval INTO
528: doc_id from DUAL;
529:
530: AHL_DOCUMENTS_PKG.INSERT_ROW (
531: X_ROWID => row_id,