DBA Data[Home] [Help]

APPS.RRS_SITE_INFO dependencies on EGO_USER_ATTR_ROW_TABLE

Line 24: ,x_site_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

20: ,x_site_url_tab OUT NOCOPY rrs_site_url_tab
21: ,x_site_person_tab OUT NOCOPY rrs_site_person_tab
22: ,x_site_attachment_tab OUT NOCOPY rrs_site_attachment_tab
23: ,x_site_asset_tab OUT NOCOPY rrs_site_asset_tab
24: ,x_site_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
25: ,x_site_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
26: ,x_loc_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
27: ,x_loc_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
28: ,x_tr_area_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

Line 26: ,x_loc_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

22: ,x_site_attachment_tab OUT NOCOPY rrs_site_attachment_tab
23: ,x_site_asset_tab OUT NOCOPY rrs_site_asset_tab
24: ,x_site_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
25: ,x_site_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
26: ,x_loc_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
27: ,x_loc_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
28: ,x_tr_area_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
29: ,x_tr_area_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
30: ) is

Line 28: ,x_tr_area_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

24: ,x_site_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
25: ,x_site_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
26: ,x_loc_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
27: ,x_loc_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
28: ,x_tr_area_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
29: ,x_tr_area_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
30: ) is
31: /*
32: x_site_header_tab rrs_site_header_tab;

Line 477: ,x_site_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

473:
474: Procedure Get_site_complete_attributes(
475: p_site_id_num IN varchar2
476: ,p_site_name IN varchar2 Default null
477: ,x_site_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
478: ,x_site_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
479: ,x_loc_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
480: ,x_loc_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
481: ,x_tr_area_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

Line 479: ,x_loc_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

475: p_site_id_num IN varchar2
476: ,p_site_name IN varchar2 Default null
477: ,x_site_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
478: ,x_site_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
479: ,x_loc_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
480: ,x_loc_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
481: ,x_tr_area_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
482: ,x_tr_area_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
483: ) is

Line 481: ,x_tr_area_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

477: ,x_site_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
478: ,x_site_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
479: ,x_loc_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
480: ,x_loc_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
481: ,x_tr_area_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
482: ,x_tr_area_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
483: ) is
484:
485: p_page_name varchar2(240);

Line 520: ,x_site_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

516: Procedure Get_site_attributes(
517: p_site_id_num IN varchar2
518: ,p_site_name IN varchar2 Default null
519: ,p_page_name IN varchar2 Default null
520: ,x_site_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
521: ,x_site_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
522: ) is
523:
524:

Line 535: x_attributes_row_table EGO_USER_ATTR_ROW_TABLE;

531: l_user_privileges_on_object EGO_VARCHAR_TBL_TYPE;
532: l_site_id NUMBER;
533: l_location_id NUMBER;
534:
535: x_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
536: x_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
537: -- x_site_attrib_row_table EGO_USER_ATTR_ROW_TABLE;
538: -- x_site_attrib_data_table EGO_USER_ATTR_DATA_TABLE;
539:

Line 537: -- x_site_attrib_row_table EGO_USER_ATTR_ROW_TABLE;

533: l_location_id NUMBER;
534:
535: x_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
536: x_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
537: -- x_site_attrib_row_table EGO_USER_ATTR_ROW_TABLE;
538: -- x_site_attrib_data_table EGO_USER_ATTR_DATA_TABLE;
539:
540: x_return_status VARCHAR2(1);
541: x_errorcode NUMBER;

Line 687: x_site_attrib_row_table := EGO_USER_ATTR_ROW_TABLE();

683: l_data_level_name := 'SITE_LEVEL';
684:
685:
686: if l_attr_grp_name.count > 0 Then
687: x_site_attrib_row_table := EGO_USER_ATTR_ROW_TABLE();
688: x_site_attrib_data_table := EGO_USER_ATTR_DATA_TABLE();
689:
690: for i in l_attr_grp_name.First..l_attr_grp_name.Last Loop
691:

Line 798: ,x_loc_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

794: Procedure Get_location_attributes(
795: p_site_id_num IN varchar2
796: ,p_site_name IN varchar2 Default null
797: ,p_page_name IN varchar2 Default null
798: ,x_loc_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
799: ,x_loc_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
800: ) is
801:
802:

Line 813: x_attributes_row_table EGO_USER_ATTR_ROW_TABLE;

809: l_user_privileges_on_object EGO_VARCHAR_TBL_TYPE;
810: l_site_id NUMBER;
811: l_location_id NUMBER;
812:
813: x_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
814: x_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
815: x_return_status VARCHAR2(1);
816: x_errorcode NUMBER;
817: x_msg_count NUMBER;

Line 939: x_loc_attrib_row_table := EGO_USER_ATTR_ROW_TABLE();

935: l_data_level_name := 'LOCATION_LEVEL';
936:
937:
938: if l_attr_grp_name.count > 0 Then
939: x_loc_attrib_row_table := EGO_USER_ATTR_ROW_TABLE();
940: x_loc_attrib_data_table := EGO_USER_ATTR_DATA_TABLE();
941:
942:
943: for i in l_attr_grp_name.First..l_attr_grp_name.Last Loop

Line 1019: ,x_tr_area_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

1015: Procedure Get_trade_area_attributes(
1016: p_site_id_num IN varchar2
1017: ,p_site_name IN varchar2 Default null
1018: ,p_page_name IN varchar2 Default null
1019: ,x_tr_area_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
1020: ,x_tr_area_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
1021: ) is
1022:
1023:

Line 1034: x_attributes_row_table EGO_USER_ATTR_ROW_TABLE;

1030: l_user_privileges_on_object EGO_VARCHAR_TBL_TYPE;
1031: l_site_id NUMBER;
1032: l_location_id NUMBER;
1033:
1034: x_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
1035: x_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
1036: x_return_status VARCHAR2(1);
1037: x_errorcode NUMBER;
1038: x_msg_count NUMBER;

Line 1180: x_tr_area_attrib_row_table := EGO_USER_ATTR_ROW_TABLE();

1176:
1177:
1178: if l_attr_grp_name.count > 0 Then
1179:
1180: x_tr_area_attrib_row_table := EGO_USER_ATTR_ROW_TABLE();
1181: x_tr_area_attrib_data_table := EGO_USER_ATTR_DATA_TABLE();
1182:
1183: for i in l_attr_grp_name.First..l_attr_grp_name.Last Loop
1184: l_request_table := EGO_ATTR_GROUP_REQUEST_TABLE();