APPS.QP_RQT_UTIL dependencies on QP_PTE_REQUEST_TYPES_V

Line 861: UPDATE QP_PTE_REQUEST_TYPES_V

857: WHERE REQUEST_TYPE_CODE = p_RQT_rec.request_type_code and
858: userenv('LANG') in (LANGUAGE, SOURCE_LANG);
859:
860: /*
861: UPDATE QP_PTE_REQUEST_TYPES_V
862: SET ATTRIBUTE1 = p_RQT_rec.attribute1
863: , ATTRIBUTE10 = p_RQT_rec.attribute10
864: , ATTRIBUTE11 = p_RQT_rec.attribute11
865: , ATTRIBUTE12 = p_RQT_rec.attribute12

Line 924: INSERT INTO QP_PTE_REQUEST_TYPES_V

920: IS
921: BEGIN
922:
923: /*
924: INSERT INTO QP_PTE_REQUEST_TYPES_V
925: ( ATTRIBUTE1
926: , ATTRIBUTE10
927: , ATTRIBUTE11
928: , ATTRIBUTE12

Line 1207: FROM QP_PTE_REQUEST_TYPES_V

1203: , PTE_CODE
1204: , REQUEST_TYPE_CODE
1205: , REQUEST_TYPE_DESC
1206: --**, ROW_ID
1207: FROM QP_PTE_REQUEST_TYPES_V
1208: WHERE ( REQUEST_TYPE_CODE = p_request_type_code
1209: )
1210: --**OR ( LOOKUP_CODE = p_lookup_code
1211: OR ( pte_code = p_lookup_code

Line 1397: FROM QP_PTE_REQUEST_TYPES_V

1393: , l_RQT_rec.pte_code
1394: , l_RQT_rec.request_type_code
1395: , l_RQT_rec.request_type_desc
1396: --**, l_RQT_rec.row_id
1397: FROM QP_PTE_REQUEST_TYPES_V
1398: WHERE REQUEST_TYPE_CODE = p_RQT_rec.request_type_code
1399: FOR UPDATE NOWAIT;
1400:
1401: -- Row locked. Compare IN attributes to DB attributes.