APPS.RRS_SITE_INFO dependencies on RRS_TRADE_AREA_GRP_REC

Line 1277: TYPE local_rrs_trade_area_grp_rec is RECORD (

1273: l_site_id NUMBER;
1274: l_location_id NUMBER;
1275: l_site_party_id NUMBER;
1276:
1277: TYPE local_rrs_trade_area_grp_rec is RECORD (
1278: group_id rrs_loc_trade_area_grps.group_id%TYPE,
1279: group_name rrs_trade_area_groups_tl.name%TYPE,
1280: group_desc rrs_trade_area_groups_tl.description%TYPE,
1281: is_primary_flag rrs_loc_trade_area_grps.is_primary_flag%TYPE,

Line 1284: TYPE local_rrs_trade_area_grp_tab IS TABLE OF local_rrs_trade_area_grp_rec;

1280: group_desc rrs_trade_area_groups_tl.description%TYPE,
1281: is_primary_flag rrs_loc_trade_area_grps.is_primary_flag%TYPE,
1282: status_code rrs_loc_trade_area_grps.status_code%TYPE
1283: );
1284: TYPE local_rrs_trade_area_grp_tab IS TABLE OF local_rrs_trade_area_grp_rec;
1285: l_trade_area_groups_details local_rrs_trade_area_grp_tab;
1286:
1287: TYPE local_rrs_relationship_rec is RECORD (
1288: start_date hz_relationships.start_date%Type,

Line 1378: x_trade_area_grp_tab(i) := rrs_trade_area_grp_rec(l_trade_area_groups_details(i).group_id

1374: x_trade_area_grp_tab := rrs_trade_area_grp_tab();
1375: if l_trade_area_groups_details.count > 0 then
1376: FOR i in l_trade_area_groups_details.First..l_trade_area_groups_details.Last LOOP
1377: x_trade_area_grp_tab.Extend();
1378: x_trade_area_grp_tab(i) := rrs_trade_area_grp_rec(l_trade_area_groups_details(i).group_id
1379: ,l_trade_area_groups_details(i).group_name
1380: ,l_trade_area_groups_details(i).group_desc
1381: ,l_trade_area_groups_details(i).is_primary_flag
1382: ,l_trade_area_groups_details(i).status_code