APPS.PV_GQ_ELEMENTS_PVT dependencies on PV_GE_QSNR_ELEMENTS_B

Line 110: SELECT pv_ge_qsnr_elements_b_s.NEXTVAL

106: l_dummy NUMBER;
107: l_qsnr_element_rec qsnr_element_rec_type := p_qsnr_element_rec;
108:
109: CURSOR c_id IS
110: SELECT pv_ge_qsnr_elements_b_s.NEXTVAL
111: FROM dual;
112:
113: CURSOR c_id_exists (l_id IN NUMBER) IS
114: SELECT 1

Line 115: FROM PV_GE_QSNR_ELEMENTS_B

111: FROM dual;
112:
113: CURSOR c_id_exists (l_id IN NUMBER) IS
114: SELECT 1
115: FROM PV_GE_QSNR_ELEMENTS_B
116: WHERE qsnr_element_id = l_id;
117: BEGIN
118: -- Standard Start of API savepoint
119: SAVEPOINT create_gq_elements_pvt;

Line 335: FROM pv_ge_qsnr_elements_b

331: )
332: IS
333: CURSOR c_get_qsnr_element_rec (cv_program_id IN NUMBER) IS
334: SELECT qsnr_elmt_seq_num, qsnr_elmt_type, entity_attr_id, qsnr_elmt_page_num, is_required_flag
335: FROM pv_ge_qsnr_elements_b
336: WHERE arc_used_by_entity_code = 'PRGM' AND used_by_entity_id = cv_program_id
337: order by qsnr_element_id;
338:
339: CURSOR c_get_qsnr_element_tl_rec (cv_program_id IN NUMBER) IS

Line 341: FROM pv_ge_qsnr_elements_b b, pv_ge_qsnr_elements_tl tl

337: order by qsnr_element_id;
338:
339: CURSOR c_get_qsnr_element_tl_rec (cv_program_id IN NUMBER) IS
340: SELECT tl.qsnr_element_id, elmt_content, source_lang, language
341: FROM pv_ge_qsnr_elements_b b, pv_ge_qsnr_elements_tl tl
342: WHERE b.qsnr_element_id = tl.qsnr_element_id
343: AND b.arc_used_by_entity_code = 'PRGM'
344: AND b.used_by_entity_id = cv_program_id
345: order by tl.qsnr_element_id;

Line 348: SELECT pv_ge_qsnr_elements_b_s.NEXTVAL

344: AND b.used_by_entity_id = cv_program_id
345: order by tl.qsnr_element_id;
346:
347: CURSOR c_id IS
348: SELECT pv_ge_qsnr_elements_b_s.NEXTVAL
349: FROM dual;
350:
351: CURSOR c_id_exists (l_id IN NUMBER) IS
352: SELECT 1

Line 353: FROM PV_GE_QSNR_ELEMENTS_B

349: FROM dual;
350:
351: CURSOR c_id_exists (l_id IN NUMBER) IS
352: SELECT 1
353: FROM PV_GE_QSNR_ELEMENTS_B
354: WHERE qsnr_element_id = l_id;
355:
356: CURSOR c_get_additional_tl_info (cv_program_id IN NUMBER) IS
357: SELECT QSNR_TITLE, QSNR_HEADER, QSNR_FOOTER, language

Line 463: INSERT INTO pv_ge_qsnr_elements_b(

459:
460: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' : insert into b table');
461:
462: forall i in 1..qsnr_element_id_array.count
463: INSERT INTO pv_ge_qsnr_elements_b(
464: qsnr_element_id,
465: object_version_number,
466: arc_used_by_entity_code,
467: used_by_entity_id,

Line 686: FROM PV_GE_QSNR_ELEMENTS_B

682:
683:
684: CURSOR c_get_gq_elements(qsnr_element_id NUMBER) IS
685: SELECT *
686: FROM PV_GE_QSNR_ELEMENTS_B
687: WHERE qsnr_element_id = p_qsnr_element_rec.qsnr_element_id;
688: -- Hint: Developer need to provide Where clause
689:
690:

Line 1517: 'pv_ge_qsnr_elements_b',

1513: BEGIN
1514: x_return_status := FND_API.g_ret_sts_success;
1515: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1516: l_valid_flag := PVX_Utility_PVT.check_uniqueness(
1517: 'pv_ge_qsnr_elements_b',
1518: 'qsnr_element_id = ''' || p_qsnr_element_rec.qsnr_element_id ||''''
1519: );
1520:
1521: IF l_valid_flag = FND_API.g_false THEN

Line 1532: 'pv_ge_qsnr_elements_b',

1528: IF p_qsnr_element_rec.qsnr_elmt_type = 'QUESTION' and
1529: p_qsnr_element_rec.entity_attr_id is not null THEN
1530: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1531: l_valid_flag := PVX_Utility_PVT.check_uniqueness(
1532: 'pv_ge_qsnr_elements_b',
1533: 'used_by_entity_id = ''' || p_qsnr_element_rec.used_by_entity_id ||''' AND entity_attr_id = ''' || p_qsnr_element_rec.entity_attr_id || '''');
1534:
1535: IF l_valid_flag = FND_API.g_false THEN
1536: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_QSNR_PROFILE_ATTR_DUPLICATE');

Line 1541: 'pv_ge_qsnr_elements_b',

1537: x_return_status := FND_API.g_ret_sts_error;
1538: END IF;
1539: ELSIF p_validation_mode = JTF_PLSQL_API.g_update THEN
1540: l_valid_flag := PVX_Utility_PVT.check_uniqueness(
1541: 'pv_ge_qsnr_elements_b',
1542: 'used_by_entity_id = ''' || p_qsnr_element_rec.used_by_entity_id ||''' AND entity_attr_id = ''' || p_qsnr_element_rec.entity_attr_id || ''' AND QSNR_ELEMENT_ID <> ''' || p_qsnr_element_rec.QSNR_ELEMENT_ID || '''');
1543:
1544: IF l_valid_flag = FND_API.g_false THEN
1545: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_QSNR_PROFILE_ATTR_DUPLICATE');

Line 1845: FROM pv_ge_qsnr_elements_b

1841: l_return_status VARCHAR2(1);
1842:
1843: CURSOR c_complete IS
1844: SELECT *
1845: FROM pv_ge_qsnr_elements_b
1846: WHERE qsnr_element_id = p_qsnr_element_rec.qsnr_element_id;
1847: l_qsnr_element_rec c_complete%ROWTYPE;
1848: BEGIN
1849: x_complete_rec := p_qsnr_element_rec;