APPS.AHL_DI_PRO_TYPE_ASO_PVT dependencies on AHL_DOCUMENT_SUB_TYPES

Line 47: FROM AHL_DOCUMENT_SUB_TYPES

43: CURSOR get_doc_sub_type_rec_info (c_document_sub_type_id NUMBER)
44: IS
45: SELECT doc_type_code,
46: doc_sub_type_code
47: FROM AHL_DOCUMENT_SUB_TYPES
48: WHERE document_sub_type_id = c_document_sub_type_id;
49:
50: -- Cursor is used to check for duplicate record
51: CURSOR dup_rec(c_doc_type_code VARCHAR2,

Line 56: FROM AHL_DOCUMENT_SUB_TYPES

52: c_doc_sub_type_code VARCHAR2)
53:
54: IS
55: SELECT 'X'
56: FROM AHL_DOCUMENT_SUB_TYPES
57: WHERE doc_type_code = c_doc_type_code
58: AND doc_sub_type_code = c_doc_sub_type_code;
59:
60:

Line 180: FROM AHL_DOCUMENT_SUB_TYPES

176: SELECT ROWID,
177: doc_type_code,
178: doc_sub_type_code,
179: object_version_number
180: FROM AHL_DOCUMENT_SUB_TYPES
181: WHERE document_sub_type_id = c_document_sub_type_id
182: FOR UPDATE OF object_version_number NOWAIT;
183: -- Used to check the associate type exists
184: CURSOR Check_Doc_Record(c_doc_type_code VARCHAR2,

Line 295: DELETE FROM AHL_DOCUMENT_SUB_TYPES

291: END IF;
292:
293:
294: -- Delete the record from document subtypes table
295: DELETE FROM AHL_DOCUMENT_SUB_TYPES
296: WHERE ROWID = l_rowid;
297: END IF;
298: END LOOP;
299:

Line 406: FROM AHL_DOCUMENT_SUB_TYPES

402: CURSOR dup_rec(c_doc_type_code VARCHAR2,
403: c_doc_sub_type_code VARCHAR2)
404: IS
405: SELECT 'x'
406: FROM AHL_DOCUMENT_SUB_TYPES
407: WHERE doc_type_code = c_doc_type_code
408: AND doc_sub_type_code = c_doc_sub_type_code;
409:
410: -- Cursor to retrieve the doc sub type code from fnd lookups

Line 516: SELECT AHL_DOCUMENT_SUB_TYPES_S.Nextval INTO

512: END IF;
513: CLOSE dup_rec;
514: --
515: -- Gets the sequence number
516: SELECT AHL_DOCUMENT_SUB_TYPES_S.Nextval INTO
517: l_document_sub_type_id from DUAL;
518: -- Insert the new record into subscriptions table
519: INSERT INTO AHL_DOCUMENT_SUB_TYPES
520: (

Line 519: INSERT INTO AHL_DOCUMENT_SUB_TYPES

515: -- Gets the sequence number
516: SELECT AHL_DOCUMENT_SUB_TYPES_S.Nextval INTO
517: l_document_sub_type_id from DUAL;
518: -- Insert the new record into subscriptions table
519: INSERT INTO AHL_DOCUMENT_SUB_TYPES
520: (
521: DOCUMENT_SUB_TYPE_ID,
522: DOC_TYPE_CODE,
523: DOC_SUB_TYPE_CODE,

Line 703: FROM AHL_DOCUMENT_SUB_TYPES

699: attribute12,
700: attribute13,
701: attribute14,
702: attribute15
703: FROM AHL_DOCUMENT_SUB_TYPES
704: WHERE document_sub_type_id = c_document_sub_type_id
705: FOR UPDATE OF object_version_number NOWAIT;
706:
707: -- Cursor to retrieve the doc sub type code from fnd lookups

Line 725: FROM AHL_DOCUMENT_SUB_TYPES

721: SELECT ROWID,
722: doc_type_code,
723: doc_sub_type_code,
724: object_version_number
725: FROM AHL_DOCUMENT_SUB_TYPES
726: WHERE document_sub_type_id = c_document_sub_type_id
727: FOR UPDATE OF object_version_number NOWAIT;
728: */
729: -- Used to check the associate type exists

Line 872: UPDATE AHL_DOCUMENT_SUB_TYPES

868: l_doc_type_assoc_info.attribute15 := p_x_doc_type_assoc_tbl(i).attribute15;
869:
870: BEGIN
871: --Updates document sub types table
872: UPDATE AHL_DOCUMENT_SUB_TYPES
873: SET doc_type_code = l_doc_type_assoc_info.doc_type_code,
874: doc_sub_type_code = l_doc_type_assoc_info.doc_sub_type_code,
875: object_version_number = l_doc_type_assoc_info.object_version_number+1,
876: attribute_category = l_doc_type_assoc_info.attribute_category,

Line 967: DELETE FROM AHL_DOCUMENT_SUB_TYPES

963:
964: END IF;
965: IF (NVL(FND_MSG_PUB.count_msg,0) = 0) THEN
966: -- Delete the record from document subtypes table
967: DELETE FROM AHL_DOCUMENT_SUB_TYPES
968: WHERE ROWID = l_doc_type_assoc_info.ROW_ID;
969: END IF;
970:
971: