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_RESPS

Line 2778: p_ca_fl_resp_id OUT NOCOPY jtf_prefab_ca_fl_resps.ca_fl_resp_id%TYPE,

2774: p_api_version IN NUMBER,
2775: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2776: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2777:
2778: p_ca_fl_resp_id OUT NOCOPY jtf_prefab_ca_fl_resps.ca_fl_resp_id%TYPE,
2779: p_ca_filter_id IN jtf_prefab_ca_fl_resps.ca_filter_id%TYPE,
2780: p_responsibility_id IN jtf_prefab_ca_fl_resps.responsibility_id%TYPE,
2781:
2782: p_object_version_number OUT NOCOPY jtf_prefab_ca_fl_resps.object_version_number%TYPE,

Line 2779: p_ca_filter_id IN jtf_prefab_ca_fl_resps.ca_filter_id%TYPE,

2775: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2776: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2777:
2778: p_ca_fl_resp_id OUT NOCOPY jtf_prefab_ca_fl_resps.ca_fl_resp_id%TYPE,
2779: p_ca_filter_id IN jtf_prefab_ca_fl_resps.ca_filter_id%TYPE,
2780: p_responsibility_id IN jtf_prefab_ca_fl_resps.responsibility_id%TYPE,
2781:
2782: p_object_version_number OUT NOCOPY jtf_prefab_ca_fl_resps.object_version_number%TYPE,
2783:

Line 2780: p_responsibility_id IN jtf_prefab_ca_fl_resps.responsibility_id%TYPE,

2776: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2777:
2778: p_ca_fl_resp_id OUT NOCOPY jtf_prefab_ca_fl_resps.ca_fl_resp_id%TYPE,
2779: p_ca_filter_id IN jtf_prefab_ca_fl_resps.ca_filter_id%TYPE,
2780: p_responsibility_id IN jtf_prefab_ca_fl_resps.responsibility_id%TYPE,
2781:
2782: p_object_version_number OUT NOCOPY jtf_prefab_ca_fl_resps.object_version_number%TYPE,
2783:
2784: x_return_status OUT NOCOPY VARCHAR2,

Line 2782: p_object_version_number OUT NOCOPY jtf_prefab_ca_fl_resps.object_version_number%TYPE,

2778: p_ca_fl_resp_id OUT NOCOPY jtf_prefab_ca_fl_resps.ca_fl_resp_id%TYPE,
2779: p_ca_filter_id IN jtf_prefab_ca_fl_resps.ca_filter_id%TYPE,
2780: p_responsibility_id IN jtf_prefab_ca_fl_resps.responsibility_id%TYPE,
2781:
2782: p_object_version_number OUT NOCOPY jtf_prefab_ca_fl_resps.object_version_number%TYPE,
2783:
2784: x_return_status OUT NOCOPY VARCHAR2,
2785: x_msg_count OUT NOCOPY NUMBER,
2786: x_msg_data OUT NOCOPY VARCHAR2

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 2825: INSERT INTO jtf_prefab_ca_fl_resps(ca_fl_resp_id,

2821: FETCH sequence_cursor INTO p_ca_fl_resp_id;
2822: CLOSE sequence_cursor;
2823: p_object_version_number := 1;
2824:
2825: INSERT INTO jtf_prefab_ca_fl_resps(ca_fl_resp_id,
2826: object_version_number,
2827: created_by,
2828: creation_date,
2829: last_updated_by,

Line 2895: p_ca_filter_id IN jtf_prefab_ca_fl_resps.ca_filter_id%TYPE,

2891: p_api_version IN NUMBER,
2892: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2893: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2894:
2895: p_ca_filter_id IN jtf_prefab_ca_fl_resps.ca_filter_id%TYPE,
2896:
2897: p_object_version_number IN jtf_prefab_ca_fl_resps.object_version_number%TYPE,
2898:
2899: x_return_status OUT NOCOPY VARCHAR2,

Line 2897: p_object_version_number IN jtf_prefab_ca_fl_resps.object_version_number%TYPE,

2893: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2894:
2895: p_ca_filter_id IN jtf_prefab_ca_fl_resps.ca_filter_id%TYPE,
2896:
2897: p_object_version_number IN jtf_prefab_ca_fl_resps.object_version_number%TYPE,
2898:
2899: x_return_status OUT NOCOPY VARCHAR2,
2900: x_msg_count OUT NOCOPY NUMBER,
2901: x_msg_data OUT NOCOPY VARCHAR2

Line 2931: DELETE FROM jtf_prefab_ca_fl_resps

2927:
2928: -- real logic --
2929: ----------------
2930:
2931: DELETE FROM jtf_prefab_ca_fl_resps
2932: WHERE ca_filter_id = p_ca_filter_id;
2933:
2934: -----------------------
2935: -- end of real logic --

Line 2983: p_ca_filter_id IN jtf_prefab_ca_fl_resps.ca_filter_id%TYPE,

2979: p_api_version IN NUMBER,
2980: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2981: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2982:
2983: p_ca_filter_id IN jtf_prefab_ca_fl_resps.ca_filter_id%TYPE,
2984: p_responsibility_id IN jtf_prefab_ca_fl_resps.responsibility_id%TYPE,
2985:
2986: p_object_version_number IN jtf_prefab_ca_fl_resps.object_version_number%TYPE,
2987:

Line 2984: p_responsibility_id IN jtf_prefab_ca_fl_resps.responsibility_id%TYPE,

2980: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2981: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2982:
2983: p_ca_filter_id IN jtf_prefab_ca_fl_resps.ca_filter_id%TYPE,
2984: p_responsibility_id IN jtf_prefab_ca_fl_resps.responsibility_id%TYPE,
2985:
2986: p_object_version_number IN jtf_prefab_ca_fl_resps.object_version_number%TYPE,
2987:
2988: x_return_status OUT NOCOPY VARCHAR2,

Line 2986: p_object_version_number IN jtf_prefab_ca_fl_resps.object_version_number%TYPE,

2982:
2983: p_ca_filter_id IN jtf_prefab_ca_fl_resps.ca_filter_id%TYPE,
2984: p_responsibility_id IN jtf_prefab_ca_fl_resps.responsibility_id%TYPE,
2985:
2986: p_object_version_number IN jtf_prefab_ca_fl_resps.object_version_number%TYPE,
2987:
2988: x_return_status OUT NOCOPY VARCHAR2,
2989: x_msg_count OUT NOCOPY NUMBER,
2990: x_msg_data OUT NOCOPY VARCHAR2

Line 3020: DELETE FROM jtf_prefab_ca_fl_resps

3016:
3017: -- real logic --
3018: ----------------
3019:
3020: DELETE FROM jtf_prefab_ca_fl_resps
3021: WHERE ca_filter_id = p_ca_filter_id
3022: AND responsibility_id = p_responsibility_id;
3023:
3024: -----------------------