APPS.AHL_DOC_REVISIONS_PKG dependencies on AHL_DOC_REVISIONS_B

Line 50: cursor C is select ROWID from AHL_DOC_REVISIONS_B

46: X_LAST_UPDATE_DATE in DATE,
47: X_LAST_UPDATED_BY in NUMBER,
48: X_LAST_UPDATE_LOGIN in NUMBER
49: ) is
50: cursor C is select ROWID from AHL_DOC_REVISIONS_B
51: where DOC_REVISION_ID = X_DOC_REVISION_ID
52: ;
53: begin
54: insert into AHL_DOC_REVISIONS_B (

Line 54: insert into AHL_DOC_REVISIONS_B (

50: cursor C is select ROWID from AHL_DOC_REVISIONS_B
51: where DOC_REVISION_ID = X_DOC_REVISION_ID
52: ;
53: begin
54: insert into AHL_DOC_REVISIONS_B (
55: APPROVED_DATE,
56: EFFECTIVE_DATE,
57: OBSOLETE_DATE,
58: ISSUE_DATE,

Line 261: from AHL_DOC_REVISIONS_B

257: ATTRIBUTE6,
258: ATTRIBUTE7,
259: ATTRIBUTE8,
260: ATTRIBUTE14
261: from AHL_DOC_REVISIONS_B
262: where DOC_REVISION_ID = X_DOC_REVISION_ID
263: for update of DOC_REVISION_ID nowait;
264: recinfo c%rowtype;
265:

Line 416: update AHL_DOC_REVISIONS_B set

412: X_LAST_UPDATED_BY in NUMBER,
413: X_LAST_UPDATE_LOGIN in NUMBER
414: ) is
415: begin
416: update AHL_DOC_REVISIONS_B set
417: APPROVED_DATE = X_APPROVED_DATE,
418: EFFECTIVE_DATE = X_EFFECTIVE_DATE,
419: OBSOLETE_DATE = X_OBSOLETE_DATE,
420: ISSUE_DATE = X_ISSUE_DATE,

Line 488: delete from AHL_DOC_REVISIONS_B

484: if (sql%notfound) then
485: raise no_data_found;
486: end if;
487:
488: delete from AHL_DOC_REVISIONS_B
489: where DOC_REVISION_ID = X_DOC_REVISION_ID;
490:
491: if (sql%notfound) then
492: raise no_data_found;

Line 502: from AHL_DOC_REVISIONS_B B

498: begin
499: delete from AHL_DOC_REVISIONS_TL T
500: where not exists
501: (select NULL
502: from AHL_DOC_REVISIONS_B B
503: where B.DOC_REVISION_ID = T.DOC_REVISION_ID
504: );
505:
506: update AHL_DOC_REVISIONS_TL T set (

Line 608: from ahl_doc_revisions_b

604: user_id := 1;
605: end if;
606:
607: select doc_revision_id into doc_revision_id
608: from ahl_doc_revisions_b
609: where doc_revision_id = X_DOC_REVISION_ID;
610:
611: AHL_DOC_REVISIONS_PKG.UPDATE_ROW (
612:

Line 660: SELECT AHL_DOC_REVISIONS_B_S.Nextval INTO

656:
657: exception
658: when NO_DATA_FOUND then
659:
660: SELECT AHL_DOC_REVISIONS_B_S.Nextval INTO
661: doc_revision_id from DUAL;
662:
663: AHL_DOC_REVISIONS_PKG.INSERT_ROW (
664: X_ROWID => row_id,

Line 726: from ahl_doc_revisions_b

722: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),
723: last_update_login = 0
724: where doc_revision_id =
725: (select doc_revision_id
726: from ahl_doc_revisions_b
727: where doc_revision_id = X_DOC_REVISION_ID)
728: and userenv('LANG') in (language, source_lang);
729:
730: end TRANSLATE_ROW;