APPS.PV_GE_HIST_LOG_PVT dependencies on PV_GE_HISTORY_LOG_B

Line 97: SELECT pv_ge_history_log_b_s.NEXTVAL

93: l_org_id NUMBER := FND_API.G_MISS_NUM;
94: l_entity_history_log_id NUMBER;
95: l_dummy NUMBER;
96: CURSOR c_id IS
97: SELECT pv_ge_history_log_b_s.NEXTVAL
98: FROM dual;
99:
100: CURSOR c_id_exists (l_id IN NUMBER) IS
101: SELECT 1

Line 102: FROM PV_GE_HISTORY_LOG_B

98: FROM dual;
99:
100: CURSOR c_id_exists (l_id IN NUMBER) IS
101: SELECT 1
102: FROM PV_GE_HISTORY_LOG_B
103: WHERE entity_history_log_id = l_id;
104: BEGIN
105: -- Standard Start of API savepoint
106: SAVEPOINT create_ge_hist_log_pvt;

Line 336: FROM PV_GE_HISTORY_LOG_B

332:
333:
334: CURSOR c_get_ge_hist_log(entity_history_log_id NUMBER) IS
335: SELECT *
336: FROM PV_GE_HISTORY_LOG_B
337: WHERE entity_history_log_id = p_ge_hist_log_rec.entity_history_log_id;
338: -- Hint: Developer need to provide Where clause
339:
340:

Line 852: 'pv_ge_history_log_b',

848: IF p_validation_mode = JTF_PLSQL_API.g_create
849: AND p_ge_hist_log_rec.entity_history_log_id IS NOT NULL
850: THEN
851: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
852: 'pv_ge_history_log_b',
853: 'entity_history_log_id = ''' || p_ge_hist_log_rec.entity_history_log_id ||''''
854: );
855: END IF;
856:

Line 1068: FROM pv_ge_history_log_b

1064: l_return_status VARCHAR2(1);
1065:
1066: CURSOR c_complete IS
1067: SELECT *
1068: FROM pv_ge_history_log_b
1069: WHERE entity_history_log_id = p_ge_hist_log_rec.entity_history_log_id;
1070: l_ge_hist_log_rec c_complete%ROWTYPE;
1071: BEGIN
1072: x_complete_rec := p_ge_hist_log_rec;