APPS.JTF_PREFAB_CACHE_PUB dependencies on DUAL

Line 35: SELECT jtf_prefab_host_apps_s.NEXTVAL from dual;

31: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_HOST_APP';
32: l_api_version NUMBER := p_api_version;
33:
34: CURSOR sequence_cursor IS
35: SELECT jtf_prefab_host_apps_s.NEXTVAL from dual;
36: CURSOR cache_comps_cursor IS
37: SELECT ca_comp_id
38: FROM jtf_prefab_ca_comps_vl
39: WHERE application_id = p_application_id and cache_generic_flag='f';

Line 651: SELECT jtf_prefab_ca_comps_b_s.NEXTVAL from dual;

647: l_api_version NUMBER := p_api_version;
648: l_row_id VARCHAR2(255) := NULL;
649:
650: CURSOR sequence_cursor IS
651: SELECT jtf_prefab_ca_comps_b_s.NEXTVAL from dual;
652: CURSOR host_apps_cursor IS
653: SELECT host_app_id
654: FROM jtf_prefab_host_apps
655: WHERE application_id = p_application_id;

Line 1206: SELECT jtf_prefab_ha_comps_s.NEXTVAL from dual;

1202: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_HA_COMP';
1203: l_api_version NUMBER := p_api_version;
1204:
1205: CURSOR sequence_cursor IS
1206: SELECT jtf_prefab_ha_comps_s.NEXTVAL from dual;
1207: BEGIN
1208: -- Standard Start of API savepoint
1209: SAVEPOINT INSERT_HA_COMP;
1210:

Line 1614: SELECT jtf_prefab_cache_stats_s.NEXTVAL from dual;

1610: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_CACHE_STAT';
1611: l_api_version NUMBER := p_api_version;
1612:
1613: CURSOR sequence_cursor IS
1614: SELECT jtf_prefab_cache_stats_s.NEXTVAL from dual;
1615: BEGIN
1616: -- Standard Start of API savepoint
1617: SAVEPOINT INSERT_CACHE_STAT;
1618:

Line 2056: SELECT jtf_prefab_ca_filters_b_s.NEXTVAL from dual;

2052: l_api_version NUMBER := p_api_version;
2053: l_row_id VARCHAR2(255) := NULL;
2054:
2055: CURSOR sequence_cursor IS
2056: SELECT jtf_prefab_ca_filters_b_s.NEXTVAL from dual;
2057: CURSOR host_apps_cursor IS
2058: SELECT host_app_id
2059: FROM jtf_prefab_host_apps
2060: WHERE application_id = p_application_id;

Line 2404: SELECT jtf_prefab_ha_filters_s.NEXTVAL from dual;

2400: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_HA_FILTER';
2401: l_api_version NUMBER := p_api_version;
2402:
2403: CURSOR sequence_cursor IS
2404: SELECT jtf_prefab_ha_filters_s.NEXTVAL from dual;
2405: BEGIN
2406: -- Standard Start of API savepoint
2407: SAVEPOINT INSERT_HA_FILTER;
2408:

Line 2794: SELECT jtf_prefab_ca_fl_resps_s.NEXTVAL from dual;

2790: l_api_version NUMBER := p_api_version;
2791: l_row_id VARCHAR2(255) := NULL;
2792:
2793: CURSOR sequence_cursor IS
2794: SELECT jtf_prefab_ca_fl_resps_s.NEXTVAL from dual;
2795: BEGIN
2796: -- Standard Start of API savepoint
2797: SAVEPOINT INSERT_CA_FL_RESP;
2798:

Line 3089: SELECT jtf_prefab_ca_fl_langs_s.NEXTVAL from dual;

3085: l_api_version NUMBER := p_api_version;
3086: l_row_id VARCHAR2(255) := NULL;
3087:
3088: CURSOR sequence_cursor IS
3089: SELECT jtf_prefab_ca_fl_langs_s.NEXTVAL from dual;
3090: BEGIN
3091: -- Standard Start of API savepoint
3092: SAVEPOINT INSERT_CA_FL_LANG;
3093: