APPS.AHL_DI_DOC_REVISION_PUB dependencies on AHL_DI_DOC_INDEX_PVT

Line 85: AND AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PER') IN ('N','L')

81: -- changes for performance pbarman 7.5.2003
82: SELECT party_id
83: FROM hz_parties
84: WHERE upper(PARTY_NAME) = upper(c_approved_by_pty_name)
85: AND AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PER') IN ('N','L')
86: AND party_type = 'PERSON'
87: UNION
88: SELECT person_id
89: FROM per_people_f ppf,per_person_types ppt

Line 95: AND AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PER') IN ('I','S');

91: AND trunc(sysdate) BETWEEN effective_start_date AND effective_end_date
92: AND nvl(current_employee_flag, 'X') = 'Y'
93: AND ppf.person_type_id = ppt.person_type_id
94: AND system_person_type = 'EMP'
95: AND AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PER') IN ('I','S');
96:
97: -- Check for ID
98: CURSOR approved_by_party_id(c_approved_by_pty_id IN NUMBER)
99: IS

Line 191: IF ahl_di_doc_index_pvt.get_product_install_status('PER') in ('N','L')

187:
188:
189:
190:
191: IF ahl_di_doc_index_pvt.get_product_install_status('PER') in ('N','L')
192: THEN
193:
194: OPEN approved_by_party_desc(p_x_revision_tbl(i).approved_by_pty_name);
195: FETCH approved_by_party_desc INTO l_approved_by_party_id;

Line 205: ELSIF ahl_di_doc_index_pvt.get_product_install_status('PER') in ('I','S')

201: FND_MESSAGE.SET_NAME('AHL','AHL_DI_APP_BY_PTY_ID_NOT_EXIST');
202: FND_MSG_PUB.ADD;
203: END IF;
204: CLOSE approved_by_party_desc;
205: ELSIF ahl_di_doc_index_pvt.get_product_install_status('PER') in ('I','S')
206: THEN
207: -- modified for bugfix 2193744
208:
209: OPEN get_party_name_id (p_x_revision_tbl(i).approved_by_pty_name, p_x_revision_tbl(i).approved_by_party_id);

Line 818: AND AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PER') IN ('N','L')

814: --changes due to performance pbarman 7.5.2003
815: SELECT party_id
816: FROM hz_parties
817: WHERE upper(PARTY_NAME) = upper(c_approved_by_pty_name)
818: AND AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PER') IN ('N','L')
819: AND party_type = 'PERSON'
820: UNION
821: SELECT person_id
822: FROM per_people_f ppf,per_person_types ppt

Line 828: AND AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PER') IN ('I','S');

824: AND trunc(sysdate) BETWEEN effective_start_date AND effective_end_date
825: AND nvl(current_employee_flag, 'X') = 'Y'
826: AND ppf.person_type_id = ppt.person_type_id
827: AND system_person_type = 'EMP'
828: AND AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PER') IN ('I','S');
829:
830: -- Check for ID
831: CURSOR approved_by_party_id(c_approved_by_pty_id IN NUMBER)
832: IS

Line 928: IF ahl_di_doc_index_pvt.get_product_install_status('PER') in ('N','L')

924: --For Approved by Party Id, Party Name is present
925: IF (p_x_revision_tbl(i).approved_by_pty_name IS NOT NULL)
926: THEN
927:
928: IF ahl_di_doc_index_pvt.get_product_install_status('PER') in ('N','L')
929: THEN
930: OPEN approved_by_party_desc(p_x_revision_tbl(i).approved_by_pty_name);
931: FETCH approved_by_party_desc INTO l_approved_by_party_id;
932: IF approved_by_party_desc%FOUND

Line 942: ELSIF ahl_di_doc_index_pvt.get_product_install_status('PER') in ('I','S')

938: END IF;
939: CLOSE approved_by_party_desc;
940:
941:
942: ELSIF ahl_di_doc_index_pvt.get_product_install_status('PER') in ('I','S')
943: THEN
944:
945: -- modified for bugfix 2193744
946: