DBA Data[Home] [Help]

APPS.CSM_WF_PKG dependencies on CSM_SR_CONTACT_EVENT_PKG

Line 1676: csm_sr_contact_event_pkg.sr_cntact_mdirty_u_foreachuser

1672: IF g_sr_cont_points_post_upd_tbl(post).last_update_date > g_sr_cont_points_pre_upd_tbl(pre).last_update_date
1673: AND g_sr_cont_points_post_upd_tbl(post).creation_date = g_sr_cont_points_pre_upd_tbl(pre).creation_date THEN
1674: -- record has been updated
1675: -- SR_Contact_Pre_Upd(g_sr_cont_points_pre_upd_tbl(pre).sr_contact_point_id);
1676: csm_sr_contact_event_pkg.sr_cntact_mdirty_u_foreachuser
1677: (p_sr_contact_point_id=>g_sr_cont_points_pre_upd_tbl(pre).sr_contact_point_id);
1678: END IF;
1679: END IF;
1680: END LOOP; -- preupd

Line 1684: csm_sr_contact_event_pkg.spawn_userloop_sr_contact_ins

1680: END LOOP; -- preupd
1681:
1682: -- if record does not exist insert the new SR
1683: IF l_is_sr_contact_ins = 'Y' THEN
1684: csm_sr_contact_event_pkg.spawn_userloop_sr_contact_ins
1685: (p_sr_contact_point_id=>g_sr_cont_points_post_upd_tbl(post).sr_contact_point_id);
1686: -- SR_Contact_Post_Ins(g_sr_cont_points_post_upd_tbl(post).sr_contact_point_id);
1687: END IF;
1688: END LOOP; -- postupd

Line 1702: csm_sr_contact_event_pkg.spawn_userloop_sr_contact_del

1698: END LOOP;
1699:
1700: -- delete sr contact if not found
1701: IF l_is_sr_contact_del = 'Y' THEN
1702: csm_sr_contact_event_pkg.spawn_userloop_sr_contact_del
1703: (p_sr_contact_point_id=>g_sr_cont_points_pre_upd_tbl(pre).sr_contact_point_id);
1704: END IF;
1705: END LOOP;
1706: