eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_PREFAB_CACHE_PUB dependencies on JTF_PREFAB_CA_FL_LANGS

Line 3073: p_ca_fl_lang_id OUT NOCOPY jtf_prefab_ca_fl_langs.ca_fl_lang_id%TYPE,

3069: p_api_version IN NUMBER,
3070: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3071: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3072:
3073: p_ca_fl_lang_id OUT NOCOPY jtf_prefab_ca_fl_langs.ca_fl_lang_id%TYPE,
3074: p_ca_filter_id IN jtf_prefab_ca_fl_langs.ca_filter_id%TYPE,
3075: p_language_code IN jtf_prefab_ca_fl_langs.language_code%TYPE,
3076:
3077: p_object_version_number OUT NOCOPY jtf_prefab_ca_fl_langs.object_version_number%TYPE,

Line 3074: p_ca_filter_id IN jtf_prefab_ca_fl_langs.ca_filter_id%TYPE,

3070: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3071: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3072:
3073: p_ca_fl_lang_id OUT NOCOPY jtf_prefab_ca_fl_langs.ca_fl_lang_id%TYPE,
3074: p_ca_filter_id IN jtf_prefab_ca_fl_langs.ca_filter_id%TYPE,
3075: p_language_code IN jtf_prefab_ca_fl_langs.language_code%TYPE,
3076:
3077: p_object_version_number OUT NOCOPY jtf_prefab_ca_fl_langs.object_version_number%TYPE,
3078:

Line 3075: p_language_code IN jtf_prefab_ca_fl_langs.language_code%TYPE,

3071: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3072:
3073: p_ca_fl_lang_id OUT NOCOPY jtf_prefab_ca_fl_langs.ca_fl_lang_id%TYPE,
3074: p_ca_filter_id IN jtf_prefab_ca_fl_langs.ca_filter_id%TYPE,
3075: p_language_code IN jtf_prefab_ca_fl_langs.language_code%TYPE,
3076:
3077: p_object_version_number OUT NOCOPY jtf_prefab_ca_fl_langs.object_version_number%TYPE,
3078:
3079: x_return_status OUT NOCOPY VARCHAR2,

Line 3077: p_object_version_number OUT NOCOPY jtf_prefab_ca_fl_langs.object_version_number%TYPE,

3073: p_ca_fl_lang_id OUT NOCOPY jtf_prefab_ca_fl_langs.ca_fl_lang_id%TYPE,
3074: p_ca_filter_id IN jtf_prefab_ca_fl_langs.ca_filter_id%TYPE,
3075: p_language_code IN jtf_prefab_ca_fl_langs.language_code%TYPE,
3076:
3077: p_object_version_number OUT NOCOPY jtf_prefab_ca_fl_langs.object_version_number%TYPE,
3078:
3079: x_return_status OUT NOCOPY VARCHAR2,
3080: x_msg_count OUT NOCOPY NUMBER,
3081: x_msg_data OUT NOCOPY VARCHAR2

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:

Line 3120: INSERT INTO jtf_prefab_ca_fl_langs(ca_fl_lang_id,

3116: FETCH sequence_cursor INTO p_ca_fl_lang_id;
3117: CLOSE sequence_cursor;
3118: p_object_version_number := 1;
3119:
3120: INSERT INTO jtf_prefab_ca_fl_langs(ca_fl_lang_id,
3121: object_version_number,
3122: created_by,
3123: creation_date,
3124: last_updated_by,

Line 3190: p_ca_filter_id IN jtf_prefab_ca_fl_langs.ca_filter_id%TYPE,

3186: p_api_version IN NUMBER,
3187: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3188: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3189:
3190: p_ca_filter_id IN jtf_prefab_ca_fl_langs.ca_filter_id%TYPE,
3191:
3192: p_object_version_number IN jtf_prefab_ca_fl_langs.object_version_number%TYPE,
3193:
3194: x_return_status OUT NOCOPY VARCHAR2,

Line 3192: p_object_version_number IN jtf_prefab_ca_fl_langs.object_version_number%TYPE,

3188: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3189:
3190: p_ca_filter_id IN jtf_prefab_ca_fl_langs.ca_filter_id%TYPE,
3191:
3192: p_object_version_number IN jtf_prefab_ca_fl_langs.object_version_number%TYPE,
3193:
3194: x_return_status OUT NOCOPY VARCHAR2,
3195: x_msg_count OUT NOCOPY NUMBER,
3196: x_msg_data OUT NOCOPY VARCHAR2

Line 3226: DELETE FROM jtf_prefab_ca_fl_langs

3222:
3223: -- real logic --
3224: ----------------
3225:
3226: DELETE FROM jtf_prefab_ca_fl_langs
3227: WHERE ca_filter_id = p_ca_filter_id;
3228:
3229: -----------------------
3230: -- end of real logic --

Line 3278: p_ca_filter_id IN jtf_prefab_ca_fl_langs.ca_filter_id%TYPE,

3274: p_api_version IN NUMBER,
3275: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3276: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3277:
3278: p_ca_filter_id IN jtf_prefab_ca_fl_langs.ca_filter_id%TYPE,
3279: p_language_code IN jtf_prefab_ca_fl_langs.language_code%TYPE,
3280:
3281: p_object_version_number IN jtf_prefab_ca_fl_langs.object_version_number%TYPE,
3282:

Line 3279: p_language_code IN jtf_prefab_ca_fl_langs.language_code%TYPE,

3275: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3276: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3277:
3278: p_ca_filter_id IN jtf_prefab_ca_fl_langs.ca_filter_id%TYPE,
3279: p_language_code IN jtf_prefab_ca_fl_langs.language_code%TYPE,
3280:
3281: p_object_version_number IN jtf_prefab_ca_fl_langs.object_version_number%TYPE,
3282:
3283: x_return_status OUT NOCOPY VARCHAR2,

Line 3281: p_object_version_number IN jtf_prefab_ca_fl_langs.object_version_number%TYPE,

3277:
3278: p_ca_filter_id IN jtf_prefab_ca_fl_langs.ca_filter_id%TYPE,
3279: p_language_code IN jtf_prefab_ca_fl_langs.language_code%TYPE,
3280:
3281: p_object_version_number IN jtf_prefab_ca_fl_langs.object_version_number%TYPE,
3282:
3283: x_return_status OUT NOCOPY VARCHAR2,
3284: x_msg_count OUT NOCOPY NUMBER,
3285: x_msg_data OUT NOCOPY VARCHAR2

Line 3315: DELETE FROM jtf_prefab_ca_fl_langs

3311:
3312: -- real logic --
3313: ----------------
3314:
3315: DELETE FROM jtf_prefab_ca_fl_langs
3316: WHERE ca_filter_id = p_ca_filter_id
3317: AND language_code = p_language_code;
3318:
3319: -----------------------