APPS.AHL_DOC_TITLE_ASSOS_PKG dependencies on AHL_DOC_TITLE_ASSOS_B

Line 42: cursor C is select ROWID from AHL_DOC_TITLE_ASSOS_B

38: X_LAST_UPDATE_DATE in DATE,
39: X_LAST_UPDATED_BY in NUMBER,
40: X_LAST_UPDATE_LOGIN in NUMBER
41: ) is
42: cursor C is select ROWID from AHL_DOC_TITLE_ASSOS_B
43: where DOC_TITLE_ASSO_ID = X_DOC_TITLE_ASSO_ID
44: ;
45: begin
46: insert into AHL_DOC_TITLE_ASSOS_B (

Line 46: insert into AHL_DOC_TITLE_ASSOS_B (

42: cursor C is select ROWID from AHL_DOC_TITLE_ASSOS_B
43: where DOC_TITLE_ASSO_ID = X_DOC_TITLE_ASSO_ID
44: ;
45: begin
46: insert into AHL_DOC_TITLE_ASSOS_B (
47: SERIAL_NO,
48: ATTRIBUTE_CATEGORY,
49: ATTRIBUTE1,
50: ATTRIBUTE2,

Line 216: from AHL_DOC_TITLE_ASSOS_B

212: DOCUMENT_ID,
213: USE_LATEST_REV_FLAG,
214: DOC_REVISION_ID,
215: OBJECT_VERSION_NUMBER
216: from AHL_DOC_TITLE_ASSOS_B
217: where DOC_TITLE_ASSO_ID = X_DOC_TITLE_ASSO_ID
218: for update of DOC_TITLE_ASSO_ID nowait;
219: recinfo c%rowtype;
220:

Line 355: update AHL_DOC_TITLE_ASSOS_B set

351: X_LAST_UPDATED_BY in NUMBER,
352: X_LAST_UPDATE_LOGIN in NUMBER
353: ) is
354: begin
355: update AHL_DOC_TITLE_ASSOS_B set
356: SERIAL_NO = X_SERIAL_NO,
357: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
358: ATTRIBUTE1 = X_ATTRIBUTE1,
359: ATTRIBUTE2 = X_ATTRIBUTE2,

Line 419: delete from AHL_DOC_TITLE_ASSOS_B

415: if (sql%notfound) then
416: raise no_data_found;
417: end if;
418:
419: delete from AHL_DOC_TITLE_ASSOS_B
420: where DOC_TITLE_ASSO_ID = X_DOC_TITLE_ASSO_ID;
421:
422: if (sql%notfound) then
423: raise no_data_found;

Line 433: from AHL_DOC_TITLE_ASSOS_B B

429: begin
430: delete from AHL_DOC_TITLE_ASSOS_TL T
431: where not exists
432: (select NULL
433: from AHL_DOC_TITLE_ASSOS_B B
434: where B.DOC_TITLE_ASSO_ID = T.DOC_TITLE_ASSO_ID
435: );
436:
437: update AHL_DOC_TITLE_ASSOS_TL T set (

Line 566: from ahl_doc_title_assos_b

562: user_id := 1;
563: end if;
564:
565: select doc_title_asso_id into doc_title_id
566: from ahl_doc_title_assos_b
567: where doc_title_asso_id = X_DOC_TITLE_ASSO_ID;
568:
569: AHL_DOC_TITLE_ASSOS_PKG.UPDATE_ROW (
570: X_DOC_TITLE_ASSO_ID => doc_title_id,

Line 609: SELECT AHL_DOC_TITLE_ASSOS_B_S.Nextval INTO

605:
606: exception
607: when NO_DATA_FOUND then
608:
609: SELECT AHL_DOC_TITLE_ASSOS_B_S.Nextval INTO
610: doc_title_id from DUAL;
611:
612: AHL_DOC_TITLE_ASSOS_PKG.INSERT_ROW (
613: X_ROWID => row_id,

Line 677: from ahl_doc_title_assos_b

673: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),
674: last_update_login = 0
675: where doc_title_asso_id =
676: (select doc_title_asso_id
677: from ahl_doc_title_assos_b
678: where doc_title_asso_id = X_DOC_TITLE_ASSO_ID)
679: and userenv('LANG') in (language, source_lang);
680:
681: end TRANSLATE_ROW;