eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_WF_AUTO_NTFY_UPDATE_PKG dependencies on CS_PARTY_ROLE_GROUP_MAPS

Line 699: l_party_role_group_code cs_party_role_group_maps.party_role_group_code%TYPE;

695: SELECT resource_id from jtf_rs_resource_extns emp WHERE
696: source_id = l_prev_owner_id;
697:
698:
699: l_party_role_group_code cs_party_role_group_maps.party_role_group_code%TYPE;
700: l_part_role_code cs_party_role_group_maps.party_role_code%TYPE;
701: l_notify_party_role_list varchar2(4000);
702: l_notify_party_role_relsr_list varchar2(4000);
703:

Line 700: l_part_role_code cs_party_role_group_maps.party_role_code%TYPE;

696: source_id = l_prev_owner_id;
697:
698:
699: l_party_role_group_code cs_party_role_group_maps.party_role_group_code%TYPE;
700: l_part_role_code cs_party_role_group_maps.party_role_code%TYPE;
701: l_notify_party_role_list varchar2(4000);
702: l_notify_party_role_relsr_list varchar2(4000);
703:
704: CURSOR sel_party_role_csr IS

Line 706: FROM cs_party_role_group_maps

702: l_notify_party_role_relsr_list varchar2(4000);
703:
704: CURSOR sel_party_role_csr IS
705: SELECT party_role_code
706: FROM cs_party_role_group_maps
707: WHERE party_role_group_code = l_party_role_group_code
708: AND trunc(sysdate) between trunc(nvl(start_date_active,sysdate))
709: and trunc(nvl(end_date_active,sysdate));
710:

Line 1080: l_party_role_code cs_party_role_group_maps.party_role_code%TYPE;

1076: l_contact_point_id NUMBER;
1077: l_contact_point_id_list VARCHAR2(2000);
1078: l_notify_subject_id NUMBER;
1079:
1080: l_party_role_code cs_party_role_group_maps.party_role_code%TYPE;
1081: l_party_role_name cs_party_roles_tl.name%TYPE;
1082: l_party_role_group_code cs_party_role_group_maps.party_role_group_code%TYPE;
1083:
1084: l_notify_party_role_list VARCHAR2(2000);

Line 1082: l_party_role_group_code cs_party_role_group_maps.party_role_group_code%TYPE;

1078: l_notify_subject_id NUMBER;
1079:
1080: l_party_role_code cs_party_role_group_maps.party_role_code%TYPE;
1081: l_party_role_name cs_party_roles_tl.name%TYPE;
1082: l_party_role_group_code cs_party_role_group_maps.party_role_group_code%TYPE;
1083:
1084: l_notify_party_role_list VARCHAR2(2000);
1085: l_notify_relsr_party_role_list VARCHAR2(2000);
1086:

Line 8029: l_party_role_group_code cs_party_role_group_maps.party_role_group_code%TYPE;

8025: p_action_code IN VARCHAR2,
8026: p_role_group_type IN VARCHAR2,
8027: p_role_group_code IN VARCHAR2) IS
8028:
8029: l_party_role_group_code cs_party_role_group_maps.party_role_group_code%TYPE;
8030: l_part_role_code cs_party_role_group_maps.party_role_code%TYPE;
8031: l_notify_party_role_list varchar2(4000);
8032: l_notify_party_role_relsr_list varchar2(4000);
8033:

Line 8030: l_part_role_code cs_party_role_group_maps.party_role_code%TYPE;

8026: p_role_group_type IN VARCHAR2,
8027: p_role_group_code IN VARCHAR2) IS
8028:
8029: l_party_role_group_code cs_party_role_group_maps.party_role_group_code%TYPE;
8030: l_part_role_code cs_party_role_group_maps.party_role_code%TYPE;
8031: l_notify_party_role_list varchar2(4000);
8032: l_notify_party_role_relsr_list varchar2(4000);
8033:
8034: CURSOR sel_party_role_csr IS

Line 8036: FROM cs_party_role_group_maps

8032: l_notify_party_role_relsr_list varchar2(4000);
8033:
8034: CURSOR sel_party_role_csr IS
8035: SELECT party_role_code
8036: FROM cs_party_role_group_maps
8037: WHERE party_role_group_code = l_party_role_group_code
8038: AND trunc(sysdate) between trunc(nvl(start_date_active,sysdate))
8039: and trunc(nvl(end_date_active,sysdate));
8040: