APPS.PV_GE_CHKLST_PVT dependencies on PV_GE_CHKLST_ITEMS_B

Line 101: SELECT pv_ge_chklst_items_b_s.NEXTVAL

97: l_dummy NUMBER;
98: l_ge_chklst_rec ge_chklst_rec_type := p_ge_chklst_rec;
99: l_sequence_num NUMBER :=0;
100: CURSOR c_id IS
101: SELECT pv_ge_chklst_items_b_s.NEXTVAL
102: FROM dual;
103:
104: CURSOR c_id_exists (l_id IN NUMBER) IS
105: SELECT 1

Line 106: FROM PV_GE_CHKLST_ITEMS_B

102: FROM dual;
103:
104: CURSOR c_id_exists (l_id IN NUMBER) IS
105: SELECT 1
106: FROM PV_GE_CHKLST_ITEMS_B
107: WHERE checklist_item_id = l_id;
108: BEGIN
109: -- Standard Start of API savepoint
110: SAVEPOINT create_ge_chklst_pvt;

Line 336: FROM pv_ge_chklst_items_b

332:
333:
334: CURSOR c_get_chklst_rec (cv_program_id IN NUMBER) IS
335: SELECT sequence_num, is_required_flag, enabled_flag
336: FROM pv_ge_chklst_items_b
337: WHERE arc_used_by_entity_code = 'PRGM' AND used_by_entity_id = cv_program_id
338: order by checklist_item_id;
339:
340: CURSOR c_get_chklst_tl_rec (cv_program_id IN NUMBER) IS

Line 342: FROM pv_ge_chklst_items_b b, pv_ge_chklst_items_tl tl

338: order by checklist_item_id;
339:
340: CURSOR c_get_chklst_tl_rec (cv_program_id IN NUMBER) IS
341: SELECT tl.checklist_item_id, checklist_item_name, source_lang, language
342: FROM pv_ge_chklst_items_b b, pv_ge_chklst_items_tl tl
343: WHERE b.checklist_item_id = tl.checklist_item_id
344: AND b.arc_used_by_entity_code = 'PRGM'
345: AND b.used_by_entity_id = cv_program_id
346: order by tl.checklist_item_id;

Line 349: SELECT pv_ge_chklst_items_b_s.NEXTVAL

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

Line 354: FROM pv_ge_chklst_items_b

350: FROM dual;
351:
352: CURSOR c_id_exists (l_id IN NUMBER) IS
353: SELECT 1
354: FROM pv_ge_chklst_items_b
355: WHERE checklist_item_id = l_id;
356:
357: l_checklist_item_id NUMBER;
358: l_object_version_number NUMBER;

Line 438: INSERT INTO pv_ge_chklst_items_b(

434:
435: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' : insert into b table');
436:
437: forall i in 1..checklist_item_id_array.count
438: INSERT INTO pv_ge_chklst_items_b(
439: checklist_item_id,
440: object_version_number,
441: arc_used_by_entity_code,
442: used_by_entity_id,

Line 624: FROM PV_GE_CHKLST_ITEMS_B

620:
621:
622: CURSOR c_get_ge_chklst(checklist_item_id NUMBER) IS
623: SELECT *
624: FROM PV_GE_CHKLST_ITEMS_B
625: WHERE checklist_item_id = p_ge_chklst_rec.checklist_item_id;
626: -- Hint: Developer need to provide Where clause
627:
628:

Line 1135: 'pv_ge_chklst_items_b',

1131: IF p_validation_mode = JTF_PLSQL_API.g_create
1132: AND p_ge_chklst_rec.checklist_item_id IS NOT NULL
1133: THEN
1134: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
1135: 'pv_ge_chklst_items_b',
1136: 'checklist_item_id = ''' || p_ge_chklst_rec.checklist_item_id ||''''
1137: );
1138: END IF;
1139:

Line 1342: FROM pv_ge_chklst_items_b

1338: l_return_status VARCHAR2(1);
1339:
1340: CURSOR c_complete IS
1341: SELECT *
1342: FROM pv_ge_chklst_items_b
1343: WHERE checklist_item_id = p_ge_chklst_rec.checklist_item_id;
1344: l_ge_chklst_rec c_complete%ROWTYPE;
1345: BEGIN
1346: x_complete_rec := p_ge_chklst_rec;