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 1079: l_party_role_code cs_party_role_group_maps.party_role_code%TYPE;

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

Line 1081: l_party_role_group_code cs_party_role_group_maps.party_role_group_code%TYPE;

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

Line 7965: l_party_role_group_code cs_party_role_group_maps.party_role_group_code%TYPE;

7961: p_action_code IN VARCHAR2,
7962: p_role_group_type IN VARCHAR2,
7963: p_role_group_code IN VARCHAR2) IS
7964:
7965: l_party_role_group_code cs_party_role_group_maps.party_role_group_code%TYPE;
7966: l_part_role_code cs_party_role_group_maps.party_role_code%TYPE;
7967: l_notify_party_role_list varchar2(4000);
7968: l_notify_party_role_relsr_list varchar2(4000);
7969:

Line 7966: l_part_role_code cs_party_role_group_maps.party_role_code%TYPE;

7962: p_role_group_type IN VARCHAR2,
7963: p_role_group_code IN VARCHAR2) IS
7964:
7965: l_party_role_group_code cs_party_role_group_maps.party_role_group_code%TYPE;
7966: l_part_role_code cs_party_role_group_maps.party_role_code%TYPE;
7967: l_notify_party_role_list varchar2(4000);
7968: l_notify_party_role_relsr_list varchar2(4000);
7969:
7970: CURSOR sel_party_role_csr IS

Line 7972: FROM cs_party_role_group_maps

7968: l_notify_party_role_relsr_list varchar2(4000);
7969:
7970: CURSOR sel_party_role_csr IS
7971: SELECT party_role_code
7972: FROM cs_party_role_group_maps
7973: WHERE party_role_group_code = l_party_role_group_code
7974: AND trunc(sysdate) between trunc(nvl(start_date_active,sysdate))
7975: and trunc(nvl(end_date_active,sysdate));
7976: