DBA Data[Home] [Help]

APPS.CSM_PROFILE_EVENT_PKG dependencies on JTM_FND_LOOKUPS_ACC

Line 85: l_access_id jtm_fnd_lookups_acc.access_id%TYPE;

81: IS
82: PRAGMA AUTONOMOUS_TRANSACTION;
83: l_pub_item varchar2(30) := 'CSF_M_PROFILES';
84: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
85: l_access_id jtm_fnd_lookups_acc.access_id%TYPE;
86: l_user_id fnd_user.user_id%TYPE;
87: l_resp_id fnd_responsibility.responsibility_id%TYPE;
88: l_app_id fnd_application.application_id%TYPE;
89: l_markdirty boolean;

Line 848: l_access_id jtm_fnd_lookups_acc.access_id%TYPE;

844: l_error_msg VARCHAR2(4000);
845: l_return_status VARCHAR2(2000);
846:
847: l_run_date DATE;
848: l_access_id jtm_fnd_lookups_acc.access_id%TYPE;
849: l_markdirty BOOLEAN;
850:
851: -- get the profiles to be inserted for the new user
852: CURSOR l_profiles_ins_csr(p_user_id IN number,