APPS.QP_RQT_UTIL dependencies on QP_PTE_REQUEST_TYPES_TL

Line 849: UPDATE QP_PTE_REQUEST_TYPES_tl

845: , REQUEST_TYPE_CODE = p_RQT_rec.request_type_code
846: WHERE REQUEST_TYPE_CODE = p_RQT_rec.request_type_code ;
847:
848:
849: UPDATE QP_PTE_REQUEST_TYPES_tl
850: SET CREATED_BY = p_RQT_rec.created_by
851: , CREATION_DATE = p_RQT_rec.creation_date
852: , LAST_UPDATED_BY = p_RQT_rec.last_updated_by
853: , LAST_UPDATE_DATE = p_RQT_rec.last_update_date

Line 1063: INSERT INTO QP_PTE_REQUEST_TYPES_tl

1059: , p_RQT_rec.pte_code
1060: , p_RQT_rec.request_type_code);
1061:
1062:
1063: INSERT INTO QP_PTE_REQUEST_TYPES_tl
1064: ( CREATED_BY
1065: , CREATION_DATE
1066: , LAST_UPDATED_BY
1067: , LAST_UPDATE_DATE

Line 1087: from qp_pte_request_types_tl T

1083: from FND_LANGUAGES L
1084: where L.INSTALLED_FLAG in ('I', 'B')
1085: and not exists
1086: ( select NULL
1087: from qp_pte_request_types_tl T
1088: where T.request_type_code = p_RQT_rec.request_type_code
1089: and T.LANGUAGE = L.LANGUAGE_CODE );
1090:
1091: --[prarasto:Pricing Parameters]

Line 1119: DELETE FROM QP_PTE_REQUEST_TYPES_TL

1115: )
1116: IS
1117: BEGIN
1118:
1119: DELETE FROM QP_PTE_REQUEST_TYPES_TL
1120: WHERE REQUEST_TYPE_CODE = p_request_type_code;
1121: --
1122: DELETE FROM QP_PTE_REQUEST_TYPES_B
1123: WHERE REQUEST_TYPE_CODE = p_request_type_code;