APPS.AHL_DOC_REVISIONS_PKG dependencies on AHL_DOC_REVISIONS_B

Line 46: cursor C is select ROWID from AHL_DOC_REVISIONS_B

42: X_LAST_UPDATE_DATE in DATE,
43: X_LAST_UPDATED_BY in NUMBER,
44: X_LAST_UPDATE_LOGIN in NUMBER
45: ) is
46: cursor C is select ROWID from AHL_DOC_REVISIONS_B
47: where DOC_REVISION_ID = X_DOC_REVISION_ID
48: ;
49: begin
50: insert into AHL_DOC_REVISIONS_B (

Line 50: insert into AHL_DOC_REVISIONS_B (

46: cursor C is select ROWID from AHL_DOC_REVISIONS_B
47: where DOC_REVISION_ID = X_DOC_REVISION_ID
48: ;
49: begin
50: insert into AHL_DOC_REVISIONS_B (
51: APPROVED_DATE,
52: EFFECTIVE_DATE,
53: OBSOLETE_DATE,
54: ISSUE_DATE,

Line 241: from AHL_DOC_REVISIONS_B

237: ATTRIBUTE6,
238: ATTRIBUTE7,
239: ATTRIBUTE8,
240: ATTRIBUTE14
241: from AHL_DOC_REVISIONS_B
242: where DOC_REVISION_ID = X_DOC_REVISION_ID
243: for update of DOC_REVISION_ID nowait;
244: recinfo c%rowtype;
245:

Line 386: update AHL_DOC_REVISIONS_B set

382: X_LAST_UPDATED_BY in NUMBER,
383: X_LAST_UPDATE_LOGIN in NUMBER
384: ) is
385: begin
386: update AHL_DOC_REVISIONS_B set
387: APPROVED_DATE = X_APPROVED_DATE,
388: EFFECTIVE_DATE = X_EFFECTIVE_DATE,
389: OBSOLETE_DATE = X_OBSOLETE_DATE,
390: ISSUE_DATE = X_ISSUE_DATE,

Line 454: delete from AHL_DOC_REVISIONS_B

450: if (sql%notfound) then
451: raise no_data_found;
452: end if;
453:
454: delete from AHL_DOC_REVISIONS_B
455: where DOC_REVISION_ID = X_DOC_REVISION_ID;
456:
457: if (sql%notfound) then
458: raise no_data_found;

Line 468: from AHL_DOC_REVISIONS_B B

464: begin
465: delete from AHL_DOC_REVISIONS_TL T
466: where not exists
467: (select NULL
468: from AHL_DOC_REVISIONS_B B
469: where B.DOC_REVISION_ID = T.DOC_REVISION_ID
470: );
471:
472: update AHL_DOC_REVISIONS_TL T set (

Line 570: from ahl_doc_revisions_b

566: user_id := 1;
567: end if;
568:
569: select doc_revision_id into doc_revision_id
570: from ahl_doc_revisions_b
571: where doc_revision_id = X_DOC_REVISION_ID;
572:
573: AHL_DOC_REVISIONS_PKG.UPDATE_ROW (
574:

Line 618: SELECT AHL_DOC_REVISIONS_B_S.Nextval INTO

614:
615: exception
616: when NO_DATA_FOUND then
617:
618: SELECT AHL_DOC_REVISIONS_B_S.Nextval INTO
619: doc_revision_id from DUAL;
620:
621: AHL_DOC_REVISIONS_PKG.INSERT_ROW (
622: X_ROWID => row_id,

Line 680: from ahl_doc_revisions_b

676: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),
677: last_update_login = 0
678: where doc_revision_id =
679: (select doc_revision_id
680: from ahl_doc_revisions_b
681: where doc_revision_id = X_DOC_REVISION_ID)
682: and userenv('LANG') in (language, source_lang);
683:
684: end TRANSLATE_ROW;