DBA Data[Home] [Help]

APPS.RRS_SITE_INFO dependencies on EGO_USER_ATTR_ROW_TABLE

Line 23: ,x_site_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

19: ,x_site_url_tab OUT NOCOPY rrs_site_url_tab
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

Line 25: ,x_loc_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

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
29: ) is

Line 27: ,x_tr_area_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

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

Line 459: ,x_site_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

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

Line 461: ,x_loc_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

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
465: ) is

Line 463: ,x_tr_area_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

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:
467: p_page_name varchar2(240);

Line 502: ,x_site_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

498: Procedure Get_site_attributes(
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:

Line 517: x_attributes_row_table EGO_USER_ATTR_ROW_TABLE;

513: l_user_privileges_on_object EGO_VARCHAR_TBL_TYPE;
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:

Line 519: -- x_site_attrib_row_table EGO_USER_ATTR_ROW_TABLE;

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);
523: x_errorcode NUMBER;

Line 669: x_site_attrib_row_table := EGO_USER_ATTR_ROW_TABLE();

665: l_data_level_name := 'SITE_LEVEL';
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:

Line 780: ,x_loc_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

776: Procedure Get_location_attributes(
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:

Line 795: x_attributes_row_table EGO_USER_ATTR_ROW_TABLE;

791: l_user_privileges_on_object EGO_VARCHAR_TBL_TYPE;
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;

Line 921: x_loc_attrib_row_table := EGO_USER_ATTR_ROW_TABLE();

917: l_data_level_name := 'LOCATION_LEVEL';
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

Line 1001: ,x_tr_area_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

997: Procedure Get_trade_area_attributes(
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:

Line 1016: x_attributes_row_table EGO_USER_ATTR_ROW_TABLE;

1012: l_user_privileges_on_object EGO_VARCHAR_TBL_TYPE;
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;

Line 1162: x_tr_area_attrib_row_table := EGO_USER_ATTR_ROW_TABLE();

1158:
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();