APPS.RRS_SITE_INFO dependencies on RRS_TRADE_AREA_GRP_TAB

Line 16: ,x_trade_area_grp_tab OUT NOCOPY rrs_trade_area_grp_tab

12: ,x_party_site_address_tab OUT NOCOPY rrs_site_address_tab
13: ,x_property_tab OUT NOCOPY rrs_property_tab
14: ,x_site_cluster_tab OUT NOCOPY rrs_site_cluster_tab
15: ,x_site_hierar_tab OUT NOCOPY rrs_site_hierar_tab
16: ,x_trade_area_grp_tab OUT NOCOPY rrs_trade_area_grp_tab
17: ,x_relationship_tab OUT NOCOPY rrs_relationship_tab
18: ,x_site_phone_tab OUT NOCOPY rrs_site_phone_tab
19: ,x_site_email_tab OUT NOCOPY rrs_site_email_tab
20: ,x_site_url_tab OUT NOCOPY rrs_site_url_tab

Line 1273: ,x_trade_area_grp_tab OUT NOCOPY rrs_trade_area_grp_tab

1269: ,p_site_name IN varchar2 Default null
1270: ,x_property_tab OUT NOCOPY rrs_property_tab
1271: ,x_site_cluster_tab OUT NOCOPY rrs_site_cluster_tab
1272: ,x_site_hierar_tab OUT NOCOPY rrs_site_hierar_tab
1273: ,x_trade_area_grp_tab OUT NOCOPY rrs_trade_area_grp_tab
1274: ,x_relationship_tab OUT NOCOPY rrs_relationship_tab
1275: ) is
1276:
1277: TYPE local_rrs_site_cluster_rec is RECORD (

Line 1303: TYPE local_rrs_trade_area_grp_tab IS TABLE OF local_rrs_trade_area_grp_rec;

1299: group_desc rrs_trade_area_groups_tl.description%TYPE,
1300: is_primary_flag rrs_loc_trade_area_grps.is_primary_flag%TYPE,
1301: status_code rrs_loc_trade_area_grps.status_code%TYPE
1302: );
1303: TYPE local_rrs_trade_area_grp_tab IS TABLE OF local_rrs_trade_area_grp_rec;
1304: l_trade_area_groups_details local_rrs_trade_area_grp_tab;
1305:
1306: TYPE local_rrs_relationship_rec is RECORD (
1307: start_date hz_relationships.start_date%Type,

Line 1304: l_trade_area_groups_details local_rrs_trade_area_grp_tab;

1300: is_primary_flag rrs_loc_trade_area_grps.is_primary_flag%TYPE,
1301: status_code rrs_loc_trade_area_grps.status_code%TYPE
1302: );
1303: TYPE local_rrs_trade_area_grp_tab IS TABLE OF local_rrs_trade_area_grp_rec;
1304: l_trade_area_groups_details local_rrs_trade_area_grp_tab;
1305:
1306: TYPE local_rrs_relationship_rec is RECORD (
1307: start_date hz_relationships.start_date%Type,
1308: end_date hz_relationships.end_date%Type,

Line 1393: x_trade_area_grp_tab := rrs_trade_area_grp_tab();

1389: AND LOCATION_ID = l_location_id
1390: ORDER BY NAME;
1391:
1392:
1393: x_trade_area_grp_tab := rrs_trade_area_grp_tab();
1394: if l_trade_area_groups_details.count > 0 then
1395: FOR i in l_trade_area_groups_details.First..l_trade_area_groups_details.Last LOOP
1396: x_trade_area_grp_tab.Extend();
1397: x_trade_area_grp_tab(i) := rrs_trade_area_grp_rec(l_trade_area_groups_details(i).group_id