DBA Data[Home] [Help]

APPS.CSM_PROFILE_EVENT_PKG dependencies on ASG_DOWNLOAD

Line 7: RETURN asg_download.user_list

3:
4: g_pub_item VARCHAR2(30) := 'CSF_M_PROFILES';
5:
6: FUNCTION get_all_omfs_resp_palm_users(p_responsibility_id IN NUMBER)
7: RETURN asg_download.user_list
8: IS
9: i NUMBER;
10: l_all_omfs_palm_users_list asg_download.user_list;
11:

Line 10: l_all_omfs_palm_users_list asg_download.user_list;

6: FUNCTION get_all_omfs_resp_palm_users(p_responsibility_id IN NUMBER)
7: RETURN asg_download.user_list
8: IS
9: i NUMBER;
10: l_all_omfs_palm_users_list asg_download.user_list;
11:
12: CURSOR l_omfs_resp_palm_users_csr(p_resp_id IN number)
13: IS
14: SELECT au.user_id

Line 90: l_all_omfs_palm_user_list asg_download.user_list;

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;
90: l_all_omfs_palm_user_list asg_download.user_list;
91: l_null_user_list asg_download.user_list;
92: l_single_access_id_list asg_download.access_list;
93: --a null list
94: l_null_access_list asg_download.access_list;

Line 91: l_null_user_list asg_download.user_list;

87: l_resp_id fnd_responsibility.responsibility_id%TYPE;
88: l_app_id fnd_application.application_id%TYPE;
89: l_markdirty boolean;
90: l_all_omfs_palm_user_list asg_download.user_list;
91: l_null_user_list asg_download.user_list;
92: l_single_access_id_list asg_download.access_list;
93: --a null list
94: l_null_access_list asg_download.access_list;
95: l_run_date date;

Line 92: l_single_access_id_list asg_download.access_list;

88: l_app_id fnd_application.application_id%TYPE;
89: l_markdirty boolean;
90: l_all_omfs_palm_user_list asg_download.user_list;
91: l_null_user_list asg_download.user_list;
92: l_single_access_id_list asg_download.access_list;
93: --a null list
94: l_null_access_list asg_download.access_list;
95: l_run_date date;
96: l_sqlerrno varchar2(20);

Line 94: l_null_access_list asg_download.access_list;

90: l_all_omfs_palm_user_list asg_download.user_list;
91: l_null_user_list asg_download.user_list;
92: l_single_access_id_list asg_download.access_list;
93: --a null list
94: l_null_access_list asg_download.access_list;
95: l_run_date date;
96: l_sqlerrno varchar2(20);
97: l_sqlerrmsg varchar2(2000);
98:

Line 633: r_profiles_ins_rec.access_id, r_profiles_ins_rec.user_id, ASG_DOWNLOAD.INS, SYSDATE);

629: NULL,l_run_date);
630:
631: --mark dirty the SDQ for the user
632: l_markdirty := CSM_UTIL_PKG.MakeDirtyForUser(g_pub_item,
633: r_profiles_ins_rec.access_id, r_profiles_ins_rec.user_id, ASG_DOWNLOAD.INS, SYSDATE);
634:
635: END LOOP; -- process profile wovalue inserts
636:
637: COMMIT;

Line 692: r_profiles_del_rec.access_id, l_user_id, ASG_DOWNLOAD.UPD, SYSDATE);

688: WHERE CURRENT OF l_profiles_del_csr;
689:
690: --mark dirty the SDQ for the user
691: l_markdirty := CSM_UTIL_PKG.MakeDirtyForUser(g_pub_item,
692: r_profiles_del_rec.access_id, l_user_id, ASG_DOWNLOAD.UPD, SYSDATE);
693: ELSE
694: --No value set for this profile at any level and hence set back to site level with value null
695: UPDATE csm_profile_option_values_acc
696: SET profile_option_value = NULL,

Line 704: r_profiles_del_rec.access_id, l_user_id, ASG_DOWNLOAD.UPD, SYSDATE);

700: last_update_date = l_run_date
701: WHERE CURRENT OF l_profiles_del_csr;
702: --mark dirty the SDQ for the user
703: l_markdirty := CSM_UTIL_PKG.MakeDirtyForUser(g_pub_item,
704: r_profiles_del_rec.access_id, l_user_id, ASG_DOWNLOAD.UPD, SYSDATE);
705:
706: END IF;
707: CLOSE c_profiles_csr;
708: ELSE

Line 731: r_profiles_upd_rec.access_id, r_profiles_upd_rec.user_id, ASG_DOWNLOAD.UPD, SYSDATE);

727: AND level_value = r_profiles_upd_rec.level_value;
728:
729: --mark dirty the SDQ for the user
730: l_markdirty := CSM_UTIL_PKG.MakeDirtyForUser(g_pub_item,
731: r_profiles_upd_rec.access_id, r_profiles_upd_rec.user_id, ASG_DOWNLOAD.UPD, SYSDATE);
732: END LOOP;
733: COMMIT;
734: --process updates ENDS
735:

Line 780: l_access_id, l_user_id, ASG_DOWNLOAD.UPD, SYSDATE);

776:
777: IF is_mfs_profile(p_profile_option_name=>r_profiles_ins_rec.profile_option_name) THEN
778: --mark dirty the SDQ for the user
779: l_markdirty := CSM_UTIL_PKG.MakeDirtyForUser(g_pub_item,
780: l_access_id, l_user_id, ASG_DOWNLOAD.UPD, SYSDATE);
781: END IF;
782: END IF;
783:
784: ELSE -- not found so insert the record(mostly this case is not used as the record is already available)

Line 802: l_access_id, l_user_id, ASG_DOWNLOAD.INS, SYSDATE);

798: r_profiles_ins_rec.profile_option_value,l_run_date);
799:
800: --mark dirty the SDQ for the user
801: l_markdirty := CSM_UTIL_PKG.MakeDirtyForUser(g_pub_item,
802: l_access_id, l_user_id, ASG_DOWNLOAD.INS, SYSDATE);
803:
804: END IF;
805: END IF;
806: CLOSE l_get_old_profile_csr;

Line 1016: l_access_id, p_user_id, ASG_DOWNLOAD.UPD, SYSDATE);

1012:
1013: IF is_mfs_profile(p_profile_option_name=>r_profiles_ins_rec.profile_option_name) THEN
1014: --mark dirty the SDQ for the user
1015: l_markdirty := CSM_UTIL_PKG.MakeDirtyForUser(g_pub_item,
1016: l_access_id, p_user_id, ASG_DOWNLOAD.UPD, SYSDATE);
1017: END IF;
1018:
1019: -- start the profile_option_value_upd WF
1020: -- start_profile_upd_wf(l_access_id, r_profiles_ins_rec.profile_option_name,r_profiles_ins_rec.profile_option_value,

Line 1041: l_access_id, p_user_id, ASG_DOWNLOAD.INS, SYSDATE);

1037:
1038: IF is_mfs_profile(p_profile_option_name=>r_profiles_ins_rec.profile_option_name) THEN
1039: --mark dirty the SDQ for the user
1040: l_markdirty := CSM_UTIL_PKG.MakeDirtyForUser(g_pub_item,
1041: l_access_id, p_user_id, ASG_DOWNLOAD.INS, SYSDATE);
1042: END IF;
1043:
1044: -- start the profile_option_value_upd WF using null for the old profle option value
1045: -- start_profile_upd_wf(l_access_id, r_profiles_ins_rec.profile_option_name,r_profiles_ins_rec.profile_option_value,