APPS.CAC_SYNC_TASK_CATEGORY dependencies on JTF_PERZ_DATA

Line 43: FROM JTF_PERZ_DATA

39: ) RETURN NUMBER
40: IS
41: CURSOR c_category_id (b_category_name VARCHAR2) IS -- Fix bug 2418798
42: SELECT perz_data_id
43: FROM JTF_PERZ_DATA
44: WHERE perz_data_desc = b_category_name
45: AND profile_id = p_profile_id;
46:
47: l_category_id NUMBER;

Line 63: FROM JTF_PERZ_DATA

59: )
60: IS
61: CURSOR c_categories (b_profile_id NUMBER) IS
62: SELECT perz_data_id
63: FROM JTF_PERZ_DATA
64: WHERE profile_id = b_profile_id;
65:
66: l_category_id NUMBER;
67: l_category_name VARCHAR2(240) := truncate_category_name(p_category_name); --Fix bug 2418798, Fix bug 2540722

Line 103: jtf_perz_data_pub.create_perz_data

99: SELECT jtf_task_category_s.nextval
100: INTO category_seq
101: FROM sys.dual;
102:
103: jtf_perz_data_pub.create_perz_data
104: (p_api_version_number => 1.0,
105: p_application_id => 690,
106: p_profile_id => l_profile_id,
107: p_profile_name => NULL,