APPS.AHL_DI_PRO_TYPE_ASO_PVT dependencies on FND_LOOKUPS

Line 22: -- Cursor to retrieve the doc type code from fnd lookups table

18: P_DOC_SUB_TYPE_CODE IN VARCHAR2 ,
19: P_DELETE_FLAG IN VARCHAR2 := 'N')
20: IS
21:
22: -- Cursor to retrieve the doc type code from fnd lookups table
23: CURSOR get_doc_type_code(c_doc_type_code VARCHAR2)
24: IS
25: SELECT lookup_code
26: FROM FND_LOOKUPS

Line 26: FROM FND_LOOKUPS

22: -- Cursor to retrieve the doc type code from fnd lookups table
23: CURSOR get_doc_type_code(c_doc_type_code VARCHAR2)
24: IS
25: SELECT lookup_code
26: FROM FND_LOOKUPS
27: WHERE lookup_code = c_doc_type_code
28: AND lookup_type = 'AHL_DOC_TYPE'
29: AND sysdate between start_date_active
30: AND nvl(end_date_active,sysdate);

Line 32: -- Cursor to retrieve the doc sub type code from fnd lookups

28: AND lookup_type = 'AHL_DOC_TYPE'
29: AND sysdate between start_date_active
30: AND nvl(end_date_active,sysdate);
31:
32: -- Cursor to retrieve the doc sub type code from fnd lookups
33: CURSOR get_doc_sub_type_code(c_doc_sub_type_code VARCHAR2)
34: IS
35: SELECT lookup_code,meaning
36: FROM FND_LOOKUP_VALUES_VL

Line 111: -- This condiiton checks for existence of Doc Type code in fnd lookups

107: THEN
108: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_SUB_TYPE_CODE_NULL');
109: FND_MSG_PUB.ADD;
110: END IF;
111: -- This condiiton checks for existence of Doc Type code in fnd lookups
112: IF p_doc_type_code IS NOT NULL
113: THEN
114: OPEN get_doc_type_code(p_doc_type_code);
115: FETCH get_doc_type_code INTO l_dummy;

Line 123: -- This condition checks for existence of Doc Sub Type code in fnd lookups

119: FND_MSG_PUB.ADD;
120: END IF;
121: CLOSE get_doc_type_code;
122: END IF;
123: -- This condition checks for existence of Doc Sub Type code in fnd lookups
124: IF p_doc_sub_type_code IS NOT NULL
125: THEN
126: OPEN get_doc_sub_type_code(p_doc_sub_type_code);
127: FETCH get_doc_sub_type_code INTO l_dummy,l_meaning;

Line 192: -- Cursor to retrieve the doc sub type code from fnd lookups

188: FROM AHL_DOCUMENTS_B
189: WHERE doc_type_code = c_doc_type_code
190: AND nvl(doc_sub_type_code,'x') = c_doc_sub_type_code;
191:
192: -- Cursor to retrieve the doc sub type code from fnd lookups
193: CURSOR get_doc_sub_type_code(c_doc_sub_type_code VARCHAR2)
194: IS
195: SELECT lookup_code,meaning
196: FROM FND_LOOKUP_VALUES_VL

Line 410: -- Cursor to retrieve the doc sub type code from fnd lookups

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
411: CURSOR get_doc_sub_type_code(c_doc_sub_type_code VARCHAR2)
412: IS
413: SELECT lookup_code,meaning
414: FROM FND_LOOKUP_VALUES_VL

Line 707: -- Cursor to retrieve the doc sub type code from fnd lookups

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
708: CURSOR get_doc_sub_type_code(c_doc_sub_type_code VARCHAR2)
709: IS
710: SELECT meaning
711: FROM FND_LOOKUP_VALUES_VL