DBA Data[Home] [Help]

APPS.CSM_WF_PKG dependencies on CSM_SR_CONTACT_EVENT_PKG

Line 1686: csm_sr_contact_event_pkg.sr_cntact_mdirty_u_foreachuser

1682: IF g_sr_cont_points_post_upd_tbl(post).last_update_date > g_sr_cont_points_pre_upd_tbl(pre).last_update_date
1683: AND g_sr_cont_points_post_upd_tbl(post).creation_date = g_sr_cont_points_pre_upd_tbl(pre).creation_date THEN
1684: -- record has been updated
1685: -- SR_Contact_Pre_Upd(g_sr_cont_points_pre_upd_tbl(pre).sr_contact_point_id);
1686: csm_sr_contact_event_pkg.sr_cntact_mdirty_u_foreachuser
1687: (p_sr_contact_point_id=>g_sr_cont_points_pre_upd_tbl(pre).sr_contact_point_id);
1688: END IF;
1689: END IF;
1690: END LOOP; -- preupd

Line 1694: csm_sr_contact_event_pkg.spawn_userloop_sr_contact_ins

1690: END LOOP; -- preupd
1691:
1692: -- if record does not exist insert the new SR
1693: IF l_is_sr_contact_ins = 'Y' THEN
1694: csm_sr_contact_event_pkg.spawn_userloop_sr_contact_ins
1695: (p_sr_contact_point_id=>g_sr_cont_points_post_upd_tbl(post).sr_contact_point_id);
1696: -- SR_Contact_Post_Ins(g_sr_cont_points_post_upd_tbl(post).sr_contact_point_id);
1697: END IF;
1698: END LOOP; -- postupd

Line 1712: csm_sr_contact_event_pkg.spawn_userloop_sr_contact_del

1708: END LOOP;
1709:
1710: -- delete sr contact if not found
1711: IF l_is_sr_contact_del = 'Y' THEN
1712: csm_sr_contact_event_pkg.spawn_userloop_sr_contact_del
1713: (p_sr_contact_point_id=>g_sr_cont_points_pre_upd_tbl(pre).sr_contact_point_id);
1714: END IF;
1715: END LOOP;
1716: