DBA Data[Home] [Help]

APPS.PV_GE_HL_PARAM_PVT dependencies on PV_GE_HISTORY_LOG_PARAMS

Line 97: SELECT pv_ge_history_log_params_s.NEXTVAL

93: l_org_id NUMBER := FND_API.G_MISS_NUM;
94: l_history_log_param_id NUMBER;
95: l_dummy NUMBER;
96: CURSOR c_id IS
97: SELECT pv_ge_history_log_params_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_PARAMS

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

Line 333: FROM PV_GE_HISTORY_LOG_PARAMS

329:
330:
331: CURSOR c_get_ge_hl_param(history_log_param_id NUMBER) IS
332: SELECT *
333: FROM PV_GE_HISTORY_LOG_PARAMS
334: WHERE history_log_param_id = p_ge_hl_param_rec.history_log_param_id;
335: -- Hint: Developer need to provide Where clause
336:
337:

Line 846: 'pv_ge_history_log_params',

842: IF p_validation_mode = JTF_PLSQL_API.g_create
843: AND p_ge_hl_param_rec.history_log_param_id IS NOT NULL
844: THEN
845: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
846: 'pv_ge_history_log_params',
847: 'history_log_param_id = ''' || p_ge_hl_param_rec.history_log_param_id ||''''
848: );
849: END IF;
850:

Line 1017: FROM pv_ge_history_log_params

1013: l_return_status VARCHAR2(1);
1014:
1015: CURSOR c_complete IS
1016: SELECT *
1017: FROM pv_ge_history_log_params
1018: WHERE history_log_param_id = p_ge_hl_param_rec.history_log_param_id;
1019: l_ge_hl_param_rec c_complete%ROWTYPE;
1020: BEGIN
1021: x_complete_rec := p_ge_hl_param_rec;