DBA Data[Home] [Help]

APPS.RRS_SITE_INFO dependencies on EGO_USER_ATTR_DATA_TABLE

Line 25: ,x_site_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

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
29: ,x_tr_area_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

Line 27: ,x_loc_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

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
31: /*

Line 29: ,x_tr_area_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_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;
33: x_site_address_tab rrs_site_address_tab;

Line 478: ,x_site_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

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
482: ,x_tr_area_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

Line 480: ,x_loc_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

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
484:

Line 482: ,x_tr_area_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_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);
486:

Line 521: ,x_site_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

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:
525:

Line 536: x_attributes_data_table EGO_USER_ATTR_DATA_TABLE;

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:
540: x_return_status VARCHAR2(1);

Line 538: -- x_site_attrib_data_table EGO_USER_ATTR_DATA_TABLE;

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;
542: x_msg_count NUMBER;

Line 688: x_site_attrib_data_table := EGO_USER_ATTR_DATA_TABLE();

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:
692: l_request_table := EGO_ATTR_GROUP_REQUEST_TABLE();

Line 799: ,x_loc_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

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:
803:

Line 814: x_attributes_data_table EGO_USER_ATTR_DATA_TABLE;

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;
818: x_msg_data VARCHAR2(1000);

Line 940: x_loc_attrib_data_table := EGO_USER_ATTR_DATA_TABLE();

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
944:

Line 1020: ,x_tr_area_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

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:
1024:

Line 1035: x_attributes_data_table EGO_USER_ATTR_DATA_TABLE;

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;
1039: x_msg_data VARCHAR2(1000);

Line 1181: x_tr_area_attrib_data_table := EGO_USER_ATTR_DATA_TABLE();

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();
1185: l_request_table.EXTEND();