APPS.JTF_RS_RESOURCE_VALUES_PVT dependencies on JTF_RS_RESOURCE_PARAMS

Line 100: from jtf_rs_resource_params

96: AND value_type = l_value_type;
97:
98: CURSOR c_get_type(c_resource_param_id number) IS
99: select type
100: from jtf_rs_resource_params
101: where resource_param_id = c_resource_param_id;
102:
103: l_type jtf_rs_resource_params.type%TYPE;
104: l_value1 jtf_rs_resource_values.value%TYPE;

Line 103: l_type jtf_rs_resource_params.type%TYPE;

99: select type
100: from jtf_rs_resource_params
101: where resource_param_id = c_resource_param_id;
102:
103: l_type jtf_rs_resource_params.type%TYPE;
104: l_value1 jtf_rs_resource_values.value%TYPE;
105:
106: BEGIN
107:

Line 272: SELECT jtf_rs_resource_params_s.nextval

268: l_value1 := p_value;
269: END IF;
270:
271: --Get the next value of the Resource_Param_Value_Id from the sequence
272: SELECT jtf_rs_resource_params_s.nextval
273: INTO l_resource_param_value_id
274: FROM dual;
275:
276: --Call the Table Handler to Insert Values

Line 536: from jtf_rs_resource_params

532: resource_param_value_rec c_resource_param_value_update%ROWTYPE;
533:
534: CURSOR c_get_type(c_resource_param_id number) IS
535: select type
536: from jtf_rs_resource_params
537: where resource_param_id = c_resource_param_id;
538:
539: l_type jtf_rs_resource_params.type%TYPE;
540: l_value1 jtf_rs_resource_values.value%TYPE;

Line 539: l_type jtf_rs_resource_params.type%TYPE;

535: select type
536: from jtf_rs_resource_params
537: where resource_param_id = c_resource_param_id;
538:
539: l_type jtf_rs_resource_params.type%TYPE;
540: l_value1 jtf_rs_resource_values.value%TYPE;
541:
542: BEGIN
543:

Line 1124: FROM jtf_rs_resource_values jrv, jtf_rs_resource_params jrp

1120: l_resource_id_out NUMBER;
1121:
1122: CURSOR c_resource_param_value_id (l_resource_id IN NUMBER ) IS
1123: SELECT jrv.resource_param_value_id, jrv.object_version_number
1124: FROM jtf_rs_resource_values jrv, jtf_rs_resource_params jrp
1125: WHERE jrv.resource_param_id = jrp.resource_param_id
1126: AND jrp.application_id in ( 680, 172 )
1127: AND jrv.resource_id = l_resource_id;
1128:

Line 1475: FROM jtf_rs_resource_params jrspm, fnd_lookups fnl

1471: l_APPLICATION_ID NUMBER := P_APPLICATION_ID;
1472:
1473: CURSOR c_rs_resource_param_list IS
1474: SELECT jrspm.resource_param_id, fnl.meaning, jrspm.type, jrspm.domain_lookup_type
1475: FROM jtf_rs_resource_params jrspm, fnd_lookups fnl
1476: WHERE jrspm.application_id = l_application_id
1477: AND jrspm.name = fnl.lookup_code
1478: AND fnl.lookup_type = 'IEM_AGENT_PARAMS';
1479: BEGIN