APPS.PV_GE_CHKLST_RESP_PVT dependencies on PV_GE_CHKLST_RESPONSES

Line 104: SELECT pv_ge_chklst_responses_s.NEXTVAL

100: l_ge_chklst_resp_rec ge_chklst_resp_rec_type := p_ge_chklst_resp_rec;
101: --ends
102:
103: CURSOR c_id IS
104: SELECT pv_ge_chklst_responses_s.NEXTVAL
105: FROM dual;
106:
107: CURSOR c_id_exists (l_id IN NUMBER) IS
108: SELECT 1

Line 109: FROM PV_GE_CHKLST_RESPONSES

105: FROM dual;
106:
107: CURSOR c_id_exists (l_id IN NUMBER) IS
108: SELECT 1
109: FROM PV_GE_CHKLST_RESPONSES
110: WHERE chklst_response_id = l_id;
111: BEGIN
112: -- Standard Start of API savepoint
113: SAVEPOINT create_ge_chklst_resp_pvt;

Line 356: FROM PV_GE_CHKLST_RESPONSES

352:
353:
354: CURSOR c_get_ge_chklst_resp(chklst_response_id NUMBER) IS
355: SELECT *
356: FROM PV_GE_CHKLST_RESPONSES
357: WHERE chklst_response_id = p_ge_chklst_resp_rec.chklst_response_id;
358: -- Hint: Developer need to provide Where clause
359:
360:

Line 865: 'pv_ge_chklst_responses',

861: IF p_validation_mode = JTF_PLSQL_API.g_create
862: AND p_ge_chklst_resp_rec.chklst_response_id IS NOT NULL
863: THEN
864: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
865: 'pv_ge_chklst_responses',
866: 'chklst_response_id = ''' || p_ge_chklst_resp_rec.chklst_response_id ||''''
867: );
868: END IF;
869:

Line 1060: FROM pv_ge_chklst_responses

1056: l_return_status VARCHAR2(1);
1057:
1058: CURSOR c_complete IS
1059: SELECT *
1060: FROM pv_ge_chklst_responses
1061: WHERE chklst_response_id = p_ge_chklst_resp_rec.chklst_response_id;
1062: l_ge_chklst_resp_rec c_complete%ROWTYPE;
1063: BEGIN
1064: x_complete_rec := p_ge_chklst_resp_rec;