DBA Data[Home] [Help]

APPS.RRS_SITE_INFO dependencies on EGO_USER_ATTR_DATA_TABLE

Line 24: ,x_site_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

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

Line 26: ,x_loc_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

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

Line 28: ,x_tr_area_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

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

Line 460: ,x_site_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

456: Procedure Get_site_complete_attributes(
457: p_site_id_num IN varchar2
458: ,p_site_name IN varchar2 Default null
459: ,x_site_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
460: ,x_site_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
461: ,x_loc_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
462: ,x_loc_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
463: ,x_tr_area_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
464: ,x_tr_area_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

Line 462: ,x_loc_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

458: ,p_site_name IN varchar2 Default null
459: ,x_site_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
460: ,x_site_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
461: ,x_loc_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
462: ,x_loc_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
463: ,x_tr_area_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
464: ,x_tr_area_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
465: ) is
466:

Line 464: ,x_tr_area_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

460: ,x_site_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
461: ,x_loc_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
462: ,x_loc_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
463: ,x_tr_area_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
464: ,x_tr_area_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
465: ) is
466:
467: p_page_name varchar2(240);
468:

Line 503: ,x_site_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

499: p_site_id_num IN varchar2
500: ,p_site_name IN varchar2 Default null
501: ,p_page_name IN varchar2 Default null
502: ,x_site_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
503: ,x_site_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
504: ) is
505:
506:
507:

Line 518: x_attributes_data_table EGO_USER_ATTR_DATA_TABLE;

514: l_site_id NUMBER;
515: l_location_id NUMBER;
516:
517: x_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
518: x_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
519: -- x_site_attrib_row_table EGO_USER_ATTR_ROW_TABLE;
520: -- x_site_attrib_data_table EGO_USER_ATTR_DATA_TABLE;
521:
522: x_return_status VARCHAR2(1);

Line 520: -- x_site_attrib_data_table EGO_USER_ATTR_DATA_TABLE;

516:
517: x_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
518: x_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
519: -- x_site_attrib_row_table EGO_USER_ATTR_ROW_TABLE;
520: -- x_site_attrib_data_table EGO_USER_ATTR_DATA_TABLE;
521:
522: x_return_status VARCHAR2(1);
523: x_errorcode NUMBER;
524: x_msg_count NUMBER;

Line 670: x_site_attrib_data_table := EGO_USER_ATTR_DATA_TABLE();

666:
667:
668: if l_attr_grp_name.count > 0 Then
669: x_site_attrib_row_table := EGO_USER_ATTR_ROW_TABLE();
670: x_site_attrib_data_table := EGO_USER_ATTR_DATA_TABLE();
671:
672: for i in l_attr_grp_name.First..l_attr_grp_name.Last Loop
673:
674: l_request_table := EGO_ATTR_GROUP_REQUEST_TABLE();

Line 781: ,x_loc_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

777: p_site_id_num IN varchar2
778: ,p_site_name IN varchar2 Default null
779: ,p_page_name IN varchar2 Default null
780: ,x_loc_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
781: ,x_loc_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
782: ) is
783:
784:
785:

Line 796: x_attributes_data_table EGO_USER_ATTR_DATA_TABLE;

792: l_site_id NUMBER;
793: l_location_id NUMBER;
794:
795: x_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
796: x_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
797: x_return_status VARCHAR2(1);
798: x_errorcode NUMBER;
799: x_msg_count NUMBER;
800: x_msg_data VARCHAR2(1000);

Line 922: x_loc_attrib_data_table := EGO_USER_ATTR_DATA_TABLE();

918:
919:
920: if l_attr_grp_name.count > 0 Then
921: x_loc_attrib_row_table := EGO_USER_ATTR_ROW_TABLE();
922: x_loc_attrib_data_table := EGO_USER_ATTR_DATA_TABLE();
923:
924:
925: for i in l_attr_grp_name.First..l_attr_grp_name.Last Loop
926:

Line 1002: ,x_tr_area_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

998: p_site_id_num IN varchar2
999: ,p_site_name IN varchar2 Default null
1000: ,p_page_name IN varchar2 Default null
1001: ,x_tr_area_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
1002: ,x_tr_area_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
1003: ) is
1004:
1005:
1006:

Line 1017: x_attributes_data_table EGO_USER_ATTR_DATA_TABLE;

1013: l_site_id NUMBER;
1014: l_location_id NUMBER;
1015:
1016: x_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
1017: x_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
1018: x_return_status VARCHAR2(1);
1019: x_errorcode NUMBER;
1020: x_msg_count NUMBER;
1021: x_msg_data VARCHAR2(1000);

Line 1163: x_tr_area_attrib_data_table := EGO_USER_ATTR_DATA_TABLE();

1159:
1160: if l_attr_grp_name.count > 0 Then
1161:
1162: x_tr_area_attrib_row_table := EGO_USER_ATTR_ROW_TABLE();
1163: x_tr_area_attrib_data_table := EGO_USER_ATTR_DATA_TABLE();
1164:
1165: for i in l_attr_grp_name.First..l_attr_grp_name.Last Loop
1166: l_request_table := EGO_ATTR_GROUP_REQUEST_TABLE();
1167: l_request_table.EXTEND();