eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RRS_ATTR_PANE dependencies on DBMS_OUTPUT

Line 503: --DBMS_OUTPUT.PUT_LINE('p_attr_group_type: ' || x_attr_group_tab(j).ATTR_GROUP_TYPE);

499: FOR k in 1 .. l_ext_id_array.COUNT
500: LOOP
501: FOR p in 1 .. l_attribute_tab.COUNT
502: LOOP
503: --DBMS_OUTPUT.PUT_LINE('p_attr_group_type: ' || x_attr_group_tab(j).ATTR_GROUP_TYPE);
504: Get_Display_Value(p_object_type,
505: p_object_id,
506: x_attr_group_tab(j).ATTR_GROUP_TYPE,
507: x_attr_group_tab(j).ATTR_GROUP_NAME,

Line 562: DBMS_OUTPUT.PUT_LINE('No availabe attributes for attribute group ' || x_attr_group_tab(j).ATTR_GROUP_NAME);

558: END LOOP;
559: END IF;
560: EXCEPTION
561: WHEN e_no_attribute_found THEN
562: DBMS_OUTPUT.PUT_LINE('No availabe attributes for attribute group ' || x_attr_group_tab(j).ATTR_GROUP_NAME);
563: END;
564: END LOOP; --AG LOOP
565: END LOOP; -- PAGE LOOP
566:

Line 583: --DBMS_OUTPUT.PUT_LINE('Other exceptions in Get_Attribute_Page');

579: WHEN e_no_attribute_found THEN
580: Record_Error('e_no_attribute_found', x_error_messages);
581: WHEN OTHERS THEN
582: Record_Error('Get_Attribute_Group_Page: ' || dbms_utility.format_error_backtrace, x_error_messages);
583: --DBMS_OUTPUT.PUT_LINE('Other exceptions in Get_Attribute_Page');
584: --dbms_output.put_line(dbms_utility.format_error_backtrace);
585: END;
586:
587:

Line 584: --dbms_output.put_line(dbms_utility.format_error_backtrace);

580: Record_Error('e_no_attribute_found', x_error_messages);
581: WHEN OTHERS THEN
582: Record_Error('Get_Attribute_Group_Page: ' || dbms_utility.format_error_backtrace, x_error_messages);
583: --DBMS_OUTPUT.PUT_LINE('Other exceptions in Get_Attribute_Page');
584: --dbms_output.put_line(dbms_utility.format_error_backtrace);
585: END;
586:
587:
588: PROCEDURE Get_Display_Value

Line 647: --DBMS_OUTPUT.PUT_LINE('p_object_type: ' || p_object_type);

643: l_dep_date_value DATE;
644:
645: BEGIN
646:
647: --DBMS_OUTPUT.PUT_LINE('p_object_type: ' || p_object_type);
648: /* decide which object type we are processing*/
649: IF UPPER(p_object_type) = 'SITE' THEN
650: l_ext_table_name := 'RRS_SITES_EXT_VL';
651: l_pk_name := 'SITE_ID';

Line 663: --DBMS_OUTPUT.PUT_LINE('l_ext_table_name: ' || l_ext_table_name);

659: l_ext_table_name := 'RRS_HIERARCHIES_EXT_VL';
660: l_pk_name := 'SITE_GROUP_VERSION_ID';
661: END IF;
662:
663: --DBMS_OUTPUT.PUT_LINE('l_ext_table_name: ' || l_ext_table_name);
664: --DBMS_OUTPUT.PUT_LINE('l_attr_group_name: ' || p_attr_group_type);
665:
666: /* query for database column set up for the attribute*/
667: BEGIN

Line 664: --DBMS_OUTPUT.PUT_LINE('l_attr_group_name: ' || p_attr_group_type);

660: l_pk_name := 'SITE_GROUP_VERSION_ID';
661: END IF;
662:
663: --DBMS_OUTPUT.PUT_LINE('l_ext_table_name: ' || l_ext_table_name);
664: --DBMS_OUTPUT.PUT_LINE('l_attr_group_name: ' || p_attr_group_type);
665:
666: /* query for database column set up for the attribute*/
667: BEGIN
668: --DBMS_OUTPUT.PUT_LINE('p_attr_group_type: ' || p_attr_group_type);

Line 668: --DBMS_OUTPUT.PUT_LINE('p_attr_group_type: ' || p_attr_group_type);

664: --DBMS_OUTPUT.PUT_LINE('l_attr_group_name: ' || p_attr_group_type);
665:
666: /* query for database column set up for the attribute*/
667: BEGIN
668: --DBMS_OUTPUT.PUT_LINE('p_attr_group_type: ' || p_attr_group_type);
669: --DBMS_OUTPUT.PUT_LINE('p_attr_group_name: ' || p_attr_group_name);
670: --DBMS_OUTPUT.PUT_LINE('p_attr_name: ' || p_attr_name);
671:
672: --Bug Fix 8989777 - jijiao 10/12/2009

Line 669: --DBMS_OUTPUT.PUT_LINE('p_attr_group_name: ' || p_attr_group_name);

665:
666: /* query for database column set up for the attribute*/
667: BEGIN
668: --DBMS_OUTPUT.PUT_LINE('p_attr_group_type: ' || p_attr_group_type);
669: --DBMS_OUTPUT.PUT_LINE('p_attr_group_name: ' || p_attr_group_name);
670: --DBMS_OUTPUT.PUT_LINE('p_attr_name: ' || p_attr_name);
671:
672: --Bug Fix 8989777 - jijiao 10/12/2009
673: --Need add Attribute Group Type to the where clause to handle the Same Attribute Group Names for the different Attribute Group Types

Line 670: --DBMS_OUTPUT.PUT_LINE('p_attr_name: ' || p_attr_name);

666: /* query for database column set up for the attribute*/
667: BEGIN
668: --DBMS_OUTPUT.PUT_LINE('p_attr_group_type: ' || p_attr_group_type);
669: --DBMS_OUTPUT.PUT_LINE('p_attr_group_name: ' || p_attr_group_name);
670: --DBMS_OUTPUT.PUT_LINE('p_attr_name: ' || p_attr_name);
671:
672: --Bug Fix 8989777 - jijiao 10/12/2009
673: --Need add Attribute Group Type to the where clause to handle the Same Attribute Group Names for the different Attribute Group Types
674: BEGIN

Line 688: --DBMS_OUTPUT.PUT_LINE('l_database_column: ' || l_attr_info.value_set_id);

684: Record_Error('Get_Display_Value: No Display Value is found.', x_error_messages);
685: WHEN OTHERS THEN
686: Record_Error('Get_Display_Value: When getting display value, get '|| sqlcode ||': '||sqlerrm, x_error_messages);
687: END;
688: --DBMS_OUTPUT.PUT_LINE('l_database_column: ' || l_attr_info.value_set_id);
689:
690: EXCEPTION
691: WHEN NO_DATA_FOUND THEN
692: Record_Error('Get_Display_Value: No attribute was found for ' || p_attr_group_type || ' ' || p_attr_group_name || '.', x_error_messages);

Line 705: --DBMS_OUTPUT.PUT_LINE('l_attr_group_id: ' || l_attr_group_id);

701: FROM EGO_ATTR_GROUPS_V
702: WHERE APPLICATION_ID = 718
703: AND ATTR_GROUP_TYPE = p_attr_group_type
704: AND ATTR_GROUP_NAME = p_attr_group_name;
705: --DBMS_OUTPUT.PUT_LINE('l_attr_group_id: ' || l_attr_group_id);
706:
707: EXCEPTION
708: WHEN NO_DATA_FOUND THEN
709: Record_Error('Get_Display_Value: No attribute group was found for attribute group name ' || p_attr_group_name || '.', x_error_messages);

Line 732: --DBMS_OUTPUT.PUT_LINE(l_attr_info.database_column);

728: ' WHERE ' || l_pk_name || ' = :1' ||
729: ' AND ATTR_GROUP_ID = :2' ||
730: ' AND EXTENSION_ID = :3';
731: EXECUTE IMMEDIATE l_query INTO l_code_value, l_uom_code USING p_object_id, l_attr_group_id, p_ext_id;
732: --DBMS_OUTPUT.PUT_LINE(l_attr_info.database_column);
733: --DBMS_OUTPUT.PUT_LINE(l_code_value || ' ' || l_uom_code);
734:
735: ELSE
736: l_query := 'SELECT ' || l_attr_info.database_column ||

Line 733: --DBMS_OUTPUT.PUT_LINE(l_code_value || ' ' || l_uom_code);

729: ' AND ATTR_GROUP_ID = :2' ||
730: ' AND EXTENSION_ID = :3';
731: EXECUTE IMMEDIATE l_query INTO l_code_value, l_uom_code USING p_object_id, l_attr_group_id, p_ext_id;
732: --DBMS_OUTPUT.PUT_LINE(l_attr_info.database_column);
733: --DBMS_OUTPUT.PUT_LINE(l_code_value || ' ' || l_uom_code);
734:
735: ELSE
736: l_query := 'SELECT ' || l_attr_info.database_column ||
737: ' FROM ' || l_ext_table_name ||

Line 741: --DBMS_OUTPUT.PUT_LINE(l_query);

737: ' FROM ' || l_ext_table_name ||
738: ' WHERE ' || l_pk_name || ' = :1' ||
739: ' AND ATTR_GROUP_ID = :2' ||
740: ' AND EXTENSION_ID = :3';
741: --DBMS_OUTPUT.PUT_LINE(l_query);
742: EXECUTE IMMEDIATE l_query INTO l_code_value USING p_object_id, l_attr_group_id, p_ext_id;
743: END IF;
744:
745: EXCEPTION

Line 769: --DBMS_OUTPUT.PUT_LINE(l_uom_conversion_rate);

765: INTO l_uom_conversion_rate
766: FROM MTL_UOM_CONVERSIONS
767: WHERE UOM_CODE = l_uom_code;
768:
769: --DBMS_OUTPUT.PUT_LINE(l_uom_conversion_rate);
770:
771: /* construct the display value at the proper uom*/
772: SELECT ((l_code_value / l_uom_conversion_rate) || ' ' || l_uom)
773: INTO x_display_value

Line 778: --DBMS_OUTPUT.PUT_LINE(x_display_value || ' is displayed as ' || x_display_type);

774: FROM DUAL;
775: --Bug 9247705: Use display_code rather than display_meaning.
776: x_display_type := l_attr_info.display_code || ' of ' || l_attr_info.data_type_code || ' with UOM';
777:
778: --DBMS_OUTPUT.PUT_LINE(x_display_value || ' is displayed as ' || x_display_type);
779: EXCEPTION
780: WHEN NO_DATA_FOUND THEN
781: Record_Error('Get_Display_Value: No Unit Of Measure was found for the UOM Code ' || l_uom_code || '.', x_error_messages);
782: RAISE e_no_uom_found;

Line 805: --DBMS_OUTPUT.PUT_LINE(l_url_tokens(l_url_tokens.LAST));

801: l_url_tokens.EXTEND;
802: l_url_tokens(l_url_tokens.LAST) := SUBSTR(l_dynamic_url, INSTR(l_dynamic_url, '$', 1, l_index-1) + 1,
803: INSTR(l_dynamic_url, '$', 1, l_index) - INSTR(l_dynamic_url, '$', 1, l_index-1) -1
804: );
805: --DBMS_OUTPUT.PUT_LINE(l_url_tokens(l_url_tokens.LAST));
806:
807: Get_Display_Value(p_object_type,
808: p_object_id,
809: p_attr_group_type,

Line 818: --DBMS_OUTPUT.PUT_LINE(l_x_display_value);

814: l_x_display_type,
815: l_x_dynamic_url,
816: x_error_messages);
817:
818: --DBMS_OUTPUT.PUT_LINE(l_x_display_value);
819: /*if there is UOM with the Numeric value, then we need get rid of the UOM, because in the Dynamic URL, we only use the EXT_ATTR value to take place of the token*/
820: IF INSTR(l_x_display_type, 'N with UOM') > 0 THEN
821: l_dynamic_url := REPLACE(l_dynamic_url, '$'||(l_url_tokens(l_url_tokens.LAST))||'$', SUBSTR(l_x_display_value, 1, INSTR(l_x_display_value, ' ')-1));
822: ELSE

Line 834: --DBMS_OUTPUT.PUT_LINE('x_display_value: ' || x_display_value);

830: --Bug 9247705: Use display_code rather than display_meaning.
831: x_display_type := l_attr_info.display_code || ' of ' || l_attr_info.data_type_code;
832: x_dynamic_url := l_dynamic_url;
833:
834: --DBMS_OUTPUT.PUT_LINE('x_display_value: ' || x_display_value);
835: --DBMS_OUTPUT.PUT_LINE('x_display_type: ' || x_display_type);
836: --DBMS_OUTPUT.PUT_LINE('x_dynamic_url: ' || x_dynamic_url);
837: END;
838:

Line 835: --DBMS_OUTPUT.PUT_LINE('x_display_type: ' || x_display_type);

831: x_display_type := l_attr_info.display_code || ' of ' || l_attr_info.data_type_code;
832: x_dynamic_url := l_dynamic_url;
833:
834: --DBMS_OUTPUT.PUT_LINE('x_display_value: ' || x_display_value);
835: --DBMS_OUTPUT.PUT_LINE('x_display_type: ' || x_display_type);
836: --DBMS_OUTPUT.PUT_LINE('x_dynamic_url: ' || x_dynamic_url);
837: END;
838:
839: /*The attribute with value set*/

Line 836: --DBMS_OUTPUT.PUT_LINE('x_dynamic_url: ' || x_dynamic_url);

832: x_dynamic_url := l_dynamic_url;
833:
834: --DBMS_OUTPUT.PUT_LINE('x_display_value: ' || x_display_value);
835: --DBMS_OUTPUT.PUT_LINE('x_display_type: ' || x_display_type);
836: --DBMS_OUTPUT.PUT_LINE('x_dynamic_url: ' || x_dynamic_url);
837: END;
838:
839: /*The attribute with value set*/
840: ELSIF l_attr_info.value_set_id IS NOT NULL THEN

Line 922: --DBMS_OUTPUT.PUT_LINE(l_add_where_clause);

918: l_add_where_clause := SUBSTR(l_add_where_clause, INSTR(l_add_where_clause_holder, 'WHERE') + 6);
919: -- keep consistency between original l_add_where_clause and index ruler l_add_where_clause_holder
920: l_add_where_clause_holder := SUBSTR(l_add_where_clause_holder, INSTR(l_add_where_clause_holder, 'WHERE') + 6);
921: END IF;
922: --DBMS_OUTPUT.PUT_LINE(l_add_where_clause);
923: --DBMS_OUTPUT.PUT_LINE(l_add_where_clause_holder);
924: --Bug Fix for Bug 9029322 - jijiao 10/15/2009
925: --Need handle the DEPENDENT value set, which is depends on another attributes in the same attribute group
926: IF INSTR(l_add_where_clause, ':$ATTRIBUTEGROUP$') > 0 THEN

Line 923: --DBMS_OUTPUT.PUT_LINE(l_add_where_clause_holder);

919: -- keep consistency between original l_add_where_clause and index ruler l_add_where_clause_holder
920: l_add_where_clause_holder := SUBSTR(l_add_where_clause_holder, INSTR(l_add_where_clause_holder, 'WHERE') + 6);
921: END IF;
922: --DBMS_OUTPUT.PUT_LINE(l_add_where_clause);
923: --DBMS_OUTPUT.PUT_LINE(l_add_where_clause_holder);
924: --Bug Fix for Bug 9029322 - jijiao 10/15/2009
925: --Need handle the DEPENDENT value set, which is depends on another attributes in the same attribute group
926: IF INSTR(l_add_where_clause, ':$ATTRIBUTEGROUP$') > 0 THEN
927: l_start_index := INSTR(l_add_where_clause, ':$ATTRIBUTEGROUP$.') + 18;

Line 936: --DBMS_OUTPUT.PUT_LINE('l_next_space_index: ' || l_next_space_index);

932: ELSE
933: --if the dependent value is written at the end of the Where Clause
934: l_dep_attr_name := SUBSTR(l_add_where_clause, l_start_index, LENGTH(l_add_where_clause) - l_start_index + 1);
935: END IF;
936: --DBMS_OUTPUT.PUT_LINE('l_next_space_index: ' || l_next_space_index);
937: --DBMS_OUTPUT.PUT_LINE('l_dep_attr_name: ' || l_dep_attr_name);
938:
939: BEGIN
940: SELECT DATABASE_COLUMN, DATA_TYPE_CODE

Line 937: --DBMS_OUTPUT.PUT_LINE('l_dep_attr_name: ' || l_dep_attr_name);

933: --if the dependent value is written at the end of the Where Clause
934: l_dep_attr_name := SUBSTR(l_add_where_clause, l_start_index, LENGTH(l_add_where_clause) - l_start_index + 1);
935: END IF;
936: --DBMS_OUTPUT.PUT_LINE('l_next_space_index: ' || l_next_space_index);
937: --DBMS_OUTPUT.PUT_LINE('l_dep_attr_name: ' || l_dep_attr_name);
938:
939: BEGIN
940: SELECT DATABASE_COLUMN, DATA_TYPE_CODE
941: INTO l_dep_column, l_dep_data_type

Line 959: --DBMS_OUTPUT.PUT_LINE(l_query);

955: ' FROM ' || l_ext_table_name ||
956: ' WHERE ' || l_pk_name || ' = :1' ||
957: ' AND ATTR_GROUP_ID = :2' ||
958: ' AND EXTENSION_ID = :3';
959: --DBMS_OUTPUT.PUT_LINE(l_query);
960: IF l_dep_data_type = 'X' OR l_dep_data_type = 'Y' THEN
961: EXECUTE IMMEDIATE l_query INTO l_dep_date_value USING p_object_id, l_attr_group_id, p_ext_id;
962: IF l_dep_date_value IS NOT NULL THEN
963: -- For the dependent value set that depends on a Date type value set, in the query, we need explictly convert the CHAR type of date value TO DATE.

Line 988: --DBMS_OUTPUT.PUT_LINE('l_add_where_clause: ' || l_add_where_clause);

984: END IF;
985: END IF;
986:
987: END IF;
988: --DBMS_OUTPUT.PUT_LINE('l_add_where_clause: ' || l_add_where_clause);
989:
990: END IF;
991:
992: -- Bug Fix 9029322, Need handle the case where user does not define ID COLUMN for the value set.

Line 1003: --DBMS_OUTPUT.PUT_LINE(l_add_where_clause);

999: l_query := 'SELECT ' || l_value_column_name ||
1000: ' FROM ' || l_app_table_name ||
1001: ' WHERE ' || l_add_where_clause;
1002: END IF;
1003: --DBMS_OUTPUT.PUT_LINE(l_add_where_clause);
1004: --DBMS_OUTPUT.PUT_LINE(l_query);
1005: -- Bug Fix for Bug 9012596 - jijiao 10/12/2009
1006: -- Need handle the case there is no Additional Where Clause
1007: -- ALSO NEED HANDLE NO ID COLUMN - THE POPLIST VALUE SET CASE! - jijiao 10/16/2009

Line 1004: --DBMS_OUTPUT.PUT_LINE(l_query);

1000: ' FROM ' || l_app_table_name ||
1001: ' WHERE ' || l_add_where_clause;
1002: END IF;
1003: --DBMS_OUTPUT.PUT_LINE(l_add_where_clause);
1004: --DBMS_OUTPUT.PUT_LINE(l_query);
1005: -- Bug Fix for Bug 9012596 - jijiao 10/12/2009
1006: -- Need handle the case there is no Additional Where Clause
1007: -- ALSO NEED HANDLE NO ID COLUMN - THE POPLIST VALUE SET CASE! - jijiao 10/16/2009
1008: ELSIF l_id_column_name IS NOT NULL THEN

Line 1042: --DBMS_OUTPUT.PUT_LINE(l_query);

1038: -- Bug Fix for Bug 9012630 - jijiao 10/12/2009
1039: -- Need handle the l_code_value is NULL case, which means there is no value for this Value Set attribute
1040: ELSIF l_code_value IS NOT NULL THEN
1041: BEGIN
1042: --DBMS_OUTPUT.PUT_LINE(l_query);
1043:
1044: -- Bug Fix for Bug 9012596
1045: -- ALSO NEED HANDLE NO ID COLUMN - THE POPLIST VALUE SET CASE! - jijiao 10/16/2009
1046: IF l_id_column_name IS NOT NULL THEN

Line 1111: --DBMS_OUTPUT.PUT_LINE(l_date_format_mask);

1107: --Bug Fix 9709269
1108: l_date_value := To_Client_Timezone(l_date_value);
1109: --End Bug Fix 9709269
1110:
1111: --DBMS_OUTPUT.PUT_LINE(l_date_format_mask);
1112: --DBMS_OUTPUT.PUT_LINE(l_code_value);
1113: x_display_value := TO_CHAR(l_date_value, l_date_format_mask);
1114: --DBMS_OUTPUT.PUT_LINE(x_display_value);
1115: --Bug 9247705: Use display_code rather than display_meaning.

Line 1112: --DBMS_OUTPUT.PUT_LINE(l_code_value);

1108: l_date_value := To_Client_Timezone(l_date_value);
1109: --End Bug Fix 9709269
1110:
1111: --DBMS_OUTPUT.PUT_LINE(l_date_format_mask);
1112: --DBMS_OUTPUT.PUT_LINE(l_code_value);
1113: x_display_value := TO_CHAR(l_date_value, l_date_format_mask);
1114: --DBMS_OUTPUT.PUT_LINE(x_display_value);
1115: --Bug 9247705: Use display_code rather than display_meaning.
1116: x_display_type := l_attr_info.display_code || ' of ' || l_attr_info.data_type_code;

Line 1114: --DBMS_OUTPUT.PUT_LINE(x_display_value);

1110:
1111: --DBMS_OUTPUT.PUT_LINE(l_date_format_mask);
1112: --DBMS_OUTPUT.PUT_LINE(l_code_value);
1113: x_display_value := TO_CHAR(l_date_value, l_date_format_mask);
1114: --DBMS_OUTPUT.PUT_LINE(x_display_value);
1115: --Bug 9247705: Use display_code rather than display_meaning.
1116: x_display_type := l_attr_info.display_code || ' of ' || l_attr_info.data_type_code;
1117:
1118: /*For the rest cases, we just display as the value is in EXT table*/

Line 1126: --DBMS_OUTPUT.PUT_LINE('x_display_value: ' || x_display_value);

1122: x_display_type := l_attr_info.display_code || ' of ' || l_attr_info.data_type_code;
1123:
1124: END IF;
1125:
1126: --DBMS_OUTPUT.PUT_LINE('x_display_value: ' || x_display_value);
1127: --DBMS_OUTPUT.PUT_LINE('x_display_type: ' || x_display_type);
1128: --DBMS_OUTPUT.PUT_LINE('x_dynamic_url: ' || x_dynamic_url);
1129:
1130:

Line 1127: --DBMS_OUTPUT.PUT_LINE('x_display_type: ' || x_display_type);

1123:
1124: END IF;
1125:
1126: --DBMS_OUTPUT.PUT_LINE('x_display_value: ' || x_display_value);
1127: --DBMS_OUTPUT.PUT_LINE('x_display_type: ' || x_display_type);
1128: --DBMS_OUTPUT.PUT_LINE('x_dynamic_url: ' || x_dynamic_url);
1129:
1130:
1131:

Line 1128: --DBMS_OUTPUT.PUT_LINE('x_dynamic_url: ' || x_dynamic_url);

1124: END IF;
1125:
1126: --DBMS_OUTPUT.PUT_LINE('x_display_value: ' || x_display_value);
1127: --DBMS_OUTPUT.PUT_LINE('x_display_type: ' || x_display_type);
1128: --DBMS_OUTPUT.PUT_LINE('x_dynamic_url: ' || x_dynamic_url);
1129:
1130:
1131:
1132: EXCEPTION

Line 1313: --DBMS_OUTPUT.PUT_LINE('p_date is null at beginning');

1309:
1310: BEGIN
1311:
1312: --IF p_date IS NULL THEN
1313: --DBMS_OUTPUT.PUT_LINE('p_date is null at beginning');
1314: --END IF;
1315:
1316: SELECT FROM_TZ(CAST(p_date AS TIMESTAMP), FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE) AT TIME ZONE FND_TIMEZONES.GET_CLIENT_TIMEZONE_CODE
1317: INTO l_timestamp

Line 1325: --DBMS_OUTPUT.PUT_LINE('p_date is null');

1321: -- INTO l_timestamp
1322: -- FROM DUAL;
1323:
1324: --IF p_date IS NULL THEN
1325: --DBMS_OUTPUT.PUT_LINE('p_date is null');
1326: --ELSIF l_timestamp IS NULL THEN
1327: --DBMS_OUTPUT.PUT_LINE('l_timestamp is null');
1328: --END IF;
1329:

Line 1327: --DBMS_OUTPUT.PUT_LINE('l_timestamp is null');

1323:
1324: --IF p_date IS NULL THEN
1325: --DBMS_OUTPUT.PUT_LINE('p_date is null');
1326: --ELSIF l_timestamp IS NULL THEN
1327: --DBMS_OUTPUT.PUT_LINE('l_timestamp is null');
1328: --END IF;
1329:
1330: --DBMS_OUTPUT.PUT_LINE('p_date: ' || TO_CHAR(TO_DATE(p_date, 'YYYY-MM-DD HH24:MI:SS'), 'YYYY-MM-DD HH24:MI:SS'));
1331: --DBMS_OUTPUT.PUT_LINE('l_timestamp: ' || TO_CHAR(l_timestamp, 'YYYY-MM-DD HH24:MI:SS'));

Line 1330: --DBMS_OUTPUT.PUT_LINE('p_date: ' || TO_CHAR(TO_DATE(p_date, 'YYYY-MM-DD HH24:MI:SS'), 'YYYY-MM-DD HH24:MI:SS'));

1326: --ELSIF l_timestamp IS NULL THEN
1327: --DBMS_OUTPUT.PUT_LINE('l_timestamp is null');
1328: --END IF;
1329:
1330: --DBMS_OUTPUT.PUT_LINE('p_date: ' || TO_CHAR(TO_DATE(p_date, 'YYYY-MM-DD HH24:MI:SS'), 'YYYY-MM-DD HH24:MI:SS'));
1331: --DBMS_OUTPUT.PUT_LINE('l_timestamp: ' || TO_CHAR(l_timestamp, 'YYYY-MM-DD HH24:MI:SS'));
1332:
1333: RETURN l_timestamp;
1334: END To_Client_Timezone;

Line 1331: --DBMS_OUTPUT.PUT_LINE('l_timestamp: ' || TO_CHAR(l_timestamp, 'YYYY-MM-DD HH24:MI:SS'));

1327: --DBMS_OUTPUT.PUT_LINE('l_timestamp is null');
1328: --END IF;
1329:
1330: --DBMS_OUTPUT.PUT_LINE('p_date: ' || TO_CHAR(TO_DATE(p_date, 'YYYY-MM-DD HH24:MI:SS'), 'YYYY-MM-DD HH24:MI:SS'));
1331: --DBMS_OUTPUT.PUT_LINE('l_timestamp: ' || TO_CHAR(l_timestamp, 'YYYY-MM-DD HH24:MI:SS'));
1332:
1333: RETURN l_timestamp;
1334: END To_Client_Timezone;
1335:

Line 1376: DBMS_OUTPUT.PUT_LINE('x_display_value: ' || x_display_value);

1372: 66754,
1373: 'N_EXT_ATTR2',
1374: x_display_value,
1375: x_error_data);
1376: DBMS_OUTPUT.PUT_LINE('x_display_value: ' || x_display_value);
1377: DBMS_OUTPUT.PUT_LINE('x_error_data: ' || x_error_data);
1378:
1379:
1380: Get_Display_Value('SITE',

Line 1377: DBMS_OUTPUT.PUT_LINE('x_error_data: ' || x_error_data);

1373: 'N_EXT_ATTR2',
1374: x_display_value,
1375: x_error_data);
1376: DBMS_OUTPUT.PUT_LINE('x_display_value: ' || x_display_value);
1377: DBMS_OUTPUT.PUT_LINE('x_error_data: ' || x_error_data);
1378:
1379:
1380: Get_Display_Value('SITE',
1381: 62142,

Line 1392: DBMS_OUTPUT.PUT_LINE('x_display_value: ' || x_display_value);

1388: x_dynamic_url,
1389: x_error_messages);
1390:
1391:
1392: DBMS_OUTPUT.PUT_LINE('x_display_value: ' || x_display_value);
1393: DBMS_OUTPUT.PUT_LINE('x_display_type: ' || x_display_type);
1394: IF x_error_messages IS NOT NULL AND x_error_messages.COUNT > 0 THEN
1395: DBMS_OUTPUT.PUT_LINE(x_error_messages.COUNT);
1396: FOR i in 1 .. x_error_messages.COUNT

Line 1393: DBMS_OUTPUT.PUT_LINE('x_display_type: ' || x_display_type);

1389: x_error_messages);
1390:
1391:
1392: DBMS_OUTPUT.PUT_LINE('x_display_value: ' || x_display_value);
1393: DBMS_OUTPUT.PUT_LINE('x_display_type: ' || x_display_type);
1394: IF x_error_messages IS NOT NULL AND x_error_messages.COUNT > 0 THEN
1395: DBMS_OUTPUT.PUT_LINE(x_error_messages.COUNT);
1396: FOR i in 1 .. x_error_messages.COUNT
1397: LOOP

Line 1395: DBMS_OUTPUT.PUT_LINE(x_error_messages.COUNT);

1391:
1392: DBMS_OUTPUT.PUT_LINE('x_display_value: ' || x_display_value);
1393: DBMS_OUTPUT.PUT_LINE('x_display_type: ' || x_display_type);
1394: IF x_error_messages IS NOT NULL AND x_error_messages.COUNT > 0 THEN
1395: DBMS_OUTPUT.PUT_LINE(x_error_messages.COUNT);
1396: FOR i in 1 .. x_error_messages.COUNT
1397: LOOP
1398: DBMS_OUTPUT.PUT_LINE(x_error_messages(i));
1399: END LOOP;

Line 1398: DBMS_OUTPUT.PUT_LINE(x_error_messages(i));

1394: IF x_error_messages IS NOT NULL AND x_error_messages.COUNT > 0 THEN
1395: DBMS_OUTPUT.PUT_LINE(x_error_messages.COUNT);
1396: FOR i in 1 .. x_error_messages.COUNT
1397: LOOP
1398: DBMS_OUTPUT.PUT_LINE(x_error_messages(i));
1399: END LOOP;
1400: END IF;
1401:
1402: Get_Attribute_Page('HIERARCHY',

Line 1416: DBMS_OUTPUT.PUT_LINE('Primary Attributes');

1412: x_attribute_tab,
1413: x_error_messages);
1414:
1415:
1416: DBMS_OUTPUT.PUT_LINE('Primary Attributes');
1417: DBMS_OUTPUT.PUT_LINE('============================');
1418: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.OBJECT_ID);
1419: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.OBJECT_IDENTIFICATION_NUMBER);
1420: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.OBJECT_NAME);

Line 1417: DBMS_OUTPUT.PUT_LINE('============================');

1413: x_error_messages);
1414:
1415:
1416: DBMS_OUTPUT.PUT_LINE('Primary Attributes');
1417: DBMS_OUTPUT.PUT_LINE('============================');
1418: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.OBJECT_ID);
1419: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.OBJECT_IDENTIFICATION_NUMBER);
1420: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.OBJECT_NAME);
1421: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.CLASSIFICATION);

Line 1418: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.OBJECT_ID);

1414:
1415:
1416: DBMS_OUTPUT.PUT_LINE('Primary Attributes');
1417: DBMS_OUTPUT.PUT_LINE('============================');
1418: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.OBJECT_ID);
1419: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.OBJECT_IDENTIFICATION_NUMBER);
1420: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.OBJECT_NAME);
1421: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.CLASSIFICATION);
1422: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.DESCRIPTION);

Line 1419: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.OBJECT_IDENTIFICATION_NUMBER);

1415:
1416: DBMS_OUTPUT.PUT_LINE('Primary Attributes');
1417: DBMS_OUTPUT.PUT_LINE('============================');
1418: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.OBJECT_ID);
1419: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.OBJECT_IDENTIFICATION_NUMBER);
1420: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.OBJECT_NAME);
1421: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.CLASSIFICATION);
1422: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.DESCRIPTION);
1423: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.SITE_TYPE);

Line 1420: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.OBJECT_NAME);

1416: DBMS_OUTPUT.PUT_LINE('Primary Attributes');
1417: DBMS_OUTPUT.PUT_LINE('============================');
1418: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.OBJECT_ID);
1419: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.OBJECT_IDENTIFICATION_NUMBER);
1420: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.OBJECT_NAME);
1421: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.CLASSIFICATION);
1422: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.DESCRIPTION);
1423: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.SITE_TYPE);
1424: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.STATUS);

Line 1421: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.CLASSIFICATION);

1417: DBMS_OUTPUT.PUT_LINE('============================');
1418: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.OBJECT_ID);
1419: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.OBJECT_IDENTIFICATION_NUMBER);
1420: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.OBJECT_NAME);
1421: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.CLASSIFICATION);
1422: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.DESCRIPTION);
1423: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.SITE_TYPE);
1424: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.STATUS);
1425: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.START_DATE);

Line 1422: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.DESCRIPTION);

1418: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.OBJECT_ID);
1419: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.OBJECT_IDENTIFICATION_NUMBER);
1420: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.OBJECT_NAME);
1421: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.CLASSIFICATION);
1422: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.DESCRIPTION);
1423: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.SITE_TYPE);
1424: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.STATUS);
1425: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.START_DATE);
1426: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.END_DATE);

Line 1423: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.SITE_TYPE);

1419: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.OBJECT_IDENTIFICATION_NUMBER);
1420: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.OBJECT_NAME);
1421: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.CLASSIFICATION);
1422: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.DESCRIPTION);
1423: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.SITE_TYPE);
1424: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.STATUS);
1425: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.START_DATE);
1426: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.END_DATE);
1427: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.ADDRESS);

Line 1424: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.STATUS);

1420: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.OBJECT_NAME);
1421: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.CLASSIFICATION);
1422: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.DESCRIPTION);
1423: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.SITE_TYPE);
1424: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.STATUS);
1425: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.START_DATE);
1426: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.END_DATE);
1427: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.ADDRESS);
1428: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.COUNTRY);

Line 1425: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.START_DATE);

1421: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.CLASSIFICATION);
1422: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.DESCRIPTION);
1423: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.SITE_TYPE);
1424: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.STATUS);
1425: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.START_DATE);
1426: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.END_DATE);
1427: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.ADDRESS);
1428: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.COUNTRY);
1429: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.GROUP_TYPE);

Line 1426: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.END_DATE);

1422: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.DESCRIPTION);
1423: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.SITE_TYPE);
1424: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.STATUS);
1425: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.START_DATE);
1426: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.END_DATE);
1427: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.ADDRESS);
1428: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.COUNTRY);
1429: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.GROUP_TYPE);
1430: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.UNIT_OF_MEASURE);

Line 1427: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.ADDRESS);

1423: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.SITE_TYPE);
1424: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.STATUS);
1425: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.START_DATE);
1426: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.END_DATE);
1427: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.ADDRESS);
1428: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.COUNTRY);
1429: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.GROUP_TYPE);
1430: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.UNIT_OF_MEASURE);
1431: DBMS_OUTPUT.PUT_LINE('----------------------------');

Line 1428: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.COUNTRY);

1424: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.STATUS);
1425: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.START_DATE);
1426: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.END_DATE);
1427: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.ADDRESS);
1428: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.COUNTRY);
1429: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.GROUP_TYPE);
1430: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.UNIT_OF_MEASURE);
1431: DBMS_OUTPUT.PUT_LINE('----------------------------');
1432:

Line 1429: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.GROUP_TYPE);

1425: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.START_DATE);
1426: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.END_DATE);
1427: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.ADDRESS);
1428: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.COUNTRY);
1429: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.GROUP_TYPE);
1430: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.UNIT_OF_MEASURE);
1431: DBMS_OUTPUT.PUT_LINE('----------------------------');
1432:
1433: DBMS_OUTPUT.PUT_LINE('Page Information');

Line 1430: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.UNIT_OF_MEASURE);

1426: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.END_DATE);
1427: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.ADDRESS);
1428: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.COUNTRY);
1429: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.GROUP_TYPE);
1430: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.UNIT_OF_MEASURE);
1431: DBMS_OUTPUT.PUT_LINE('----------------------------');
1432:
1433: DBMS_OUTPUT.PUT_LINE('Page Information');
1434: DBMS_OUTPUT.PUT_LINE('====================================');

Line 1431: DBMS_OUTPUT.PUT_LINE('----------------------------');

1427: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.ADDRESS);
1428: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.COUNTRY);
1429: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.GROUP_TYPE);
1430: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.UNIT_OF_MEASURE);
1431: DBMS_OUTPUT.PUT_LINE('----------------------------');
1432:
1433: DBMS_OUTPUT.PUT_LINE('Page Information');
1434: DBMS_OUTPUT.PUT_LINE('====================================');
1435:

Line 1433: DBMS_OUTPUT.PUT_LINE('Page Information');

1429: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.GROUP_TYPE);
1430: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.UNIT_OF_MEASURE);
1431: DBMS_OUTPUT.PUT_LINE('----------------------------');
1432:
1433: DBMS_OUTPUT.PUT_LINE('Page Information');
1434: DBMS_OUTPUT.PUT_LINE('====================================');
1435:
1436: IF x_ag_page_tab IS NOT NULL AND x_ag_page_tab.COUNT > 0 THEN
1437: FOR i in 1 .. x_ag_page_tab.COUNT

Line 1434: DBMS_OUTPUT.PUT_LINE('====================================');

1430: DBMS_OUTPUT.PUT_LINE(x_primary_attributes.UNIT_OF_MEASURE);
1431: DBMS_OUTPUT.PUT_LINE('----------------------------');
1432:
1433: DBMS_OUTPUT.PUT_LINE('Page Information');
1434: DBMS_OUTPUT.PUT_LINE('====================================');
1435:
1436: IF x_ag_page_tab IS NOT NULL AND x_ag_page_tab.COUNT > 0 THEN
1437: FOR i in 1 .. x_ag_page_tab.COUNT
1438: LOOP

Line 1439: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).PAGE_ID);

1435:
1436: IF x_ag_page_tab IS NOT NULL AND x_ag_page_tab.COUNT > 0 THEN
1437: FOR i in 1 .. x_ag_page_tab.COUNT
1438: LOOP
1439: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).PAGE_ID);
1440: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).OBJECT_NAME);
1441: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).CLASSIFICATION_CODE);
1442: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).DATA_LEVEL_INT_NAME);
1443: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).INTERNAL_NAME);

Line 1440: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).OBJECT_NAME);

1436: IF x_ag_page_tab IS NOT NULL AND x_ag_page_tab.COUNT > 0 THEN
1437: FOR i in 1 .. x_ag_page_tab.COUNT
1438: LOOP
1439: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).PAGE_ID);
1440: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).OBJECT_NAME);
1441: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).CLASSIFICATION_CODE);
1442: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).DATA_LEVEL_INT_NAME);
1443: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).INTERNAL_NAME);
1444: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).DISPLAY_NAME);

Line 1441: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).CLASSIFICATION_CODE);

1437: FOR i in 1 .. x_ag_page_tab.COUNT
1438: LOOP
1439: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).PAGE_ID);
1440: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).OBJECT_NAME);
1441: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).CLASSIFICATION_CODE);
1442: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).DATA_LEVEL_INT_NAME);
1443: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).INTERNAL_NAME);
1444: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).DISPLAY_NAME);
1445: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).DESCRIPTION);

Line 1442: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).DATA_LEVEL_INT_NAME);

1438: LOOP
1439: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).PAGE_ID);
1440: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).OBJECT_NAME);
1441: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).CLASSIFICATION_CODE);
1442: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).DATA_LEVEL_INT_NAME);
1443: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).INTERNAL_NAME);
1444: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).DISPLAY_NAME);
1445: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).DESCRIPTION);
1446: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).SEQUENCE);

Line 1443: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).INTERNAL_NAME);

1439: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).PAGE_ID);
1440: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).OBJECT_NAME);
1441: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).CLASSIFICATION_CODE);
1442: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).DATA_LEVEL_INT_NAME);
1443: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).INTERNAL_NAME);
1444: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).DISPLAY_NAME);
1445: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).DESCRIPTION);
1446: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).SEQUENCE);
1447: DBMS_OUTPUT.PUT_LINE('--------------------------------');

Line 1444: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).DISPLAY_NAME);

1440: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).OBJECT_NAME);
1441: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).CLASSIFICATION_CODE);
1442: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).DATA_LEVEL_INT_NAME);
1443: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).INTERNAL_NAME);
1444: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).DISPLAY_NAME);
1445: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).DESCRIPTION);
1446: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).SEQUENCE);
1447: DBMS_OUTPUT.PUT_LINE('--------------------------------');
1448: END LOOP;

Line 1445: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).DESCRIPTION);

1441: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).CLASSIFICATION_CODE);
1442: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).DATA_LEVEL_INT_NAME);
1443: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).INTERNAL_NAME);
1444: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).DISPLAY_NAME);
1445: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).DESCRIPTION);
1446: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).SEQUENCE);
1447: DBMS_OUTPUT.PUT_LINE('--------------------------------');
1448: END LOOP;
1449: END IF;

Line 1446: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).SEQUENCE);

1442: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).DATA_LEVEL_INT_NAME);
1443: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).INTERNAL_NAME);
1444: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).DISPLAY_NAME);
1445: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).DESCRIPTION);
1446: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).SEQUENCE);
1447: DBMS_OUTPUT.PUT_LINE('--------------------------------');
1448: END LOOP;
1449: END IF;
1450:

Line 1447: DBMS_OUTPUT.PUT_LINE('--------------------------------');

1443: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).INTERNAL_NAME);
1444: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).DISPLAY_NAME);
1445: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).DESCRIPTION);
1446: DBMS_OUTPUT.PUT_LINE(x_ag_page_tab(i).SEQUENCE);
1447: DBMS_OUTPUT.PUT_LINE('--------------------------------');
1448: END LOOP;
1449: END IF;
1450:
1451: DBMS_OUTPUT.PUT_LINE('Attribute Group Information');

Line 1451: DBMS_OUTPUT.PUT_LINE('Attribute Group Information');

1447: DBMS_OUTPUT.PUT_LINE('--------------------------------');
1448: END LOOP;
1449: END IF;
1450:
1451: DBMS_OUTPUT.PUT_LINE('Attribute Group Information');
1452: DBMS_OUTPUT.PUT_LINE('====================================');
1453:
1454: IF x_attr_group_tab IS NOT NULL AND x_attr_group_tab.COUNT > 0 THEN
1455: FOR j in 1 .. x_attr_group_tab.COUNT

Line 1452: DBMS_OUTPUT.PUT_LINE('====================================');

1448: END LOOP;
1449: END IF;
1450:
1451: DBMS_OUTPUT.PUT_LINE('Attribute Group Information');
1452: DBMS_OUTPUT.PUT_LINE('====================================');
1453:
1454: IF x_attr_group_tab IS NOT NULL AND x_attr_group_tab.COUNT > 0 THEN
1455: FOR j in 1 .. x_attr_group_tab.COUNT
1456: LOOP

Line 1457: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).PAGE_ID);

1453:
1454: IF x_attr_group_tab IS NOT NULL AND x_attr_group_tab.COUNT > 0 THEN
1455: FOR j in 1 .. x_attr_group_tab.COUNT
1456: LOOP
1457: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).PAGE_ID);
1458: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).ATTR_GROUP_ID);
1459: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).ATTR_GROUP_TYPE);
1460: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).ATTR_GROUP_NAME);
1461: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).ATTR_GROUP_DISP_NAME);

Line 1458: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).ATTR_GROUP_ID);

1454: IF x_attr_group_tab IS NOT NULL AND x_attr_group_tab.COUNT > 0 THEN
1455: FOR j in 1 .. x_attr_group_tab.COUNT
1456: LOOP
1457: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).PAGE_ID);
1458: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).ATTR_GROUP_ID);
1459: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).ATTR_GROUP_TYPE);
1460: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).ATTR_GROUP_NAME);
1461: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).ATTR_GROUP_DISP_NAME);
1462: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).DESCRIPTION);

Line 1459: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).ATTR_GROUP_TYPE);

1455: FOR j in 1 .. x_attr_group_tab.COUNT
1456: LOOP
1457: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).PAGE_ID);
1458: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).ATTR_GROUP_ID);
1459: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).ATTR_GROUP_TYPE);
1460: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).ATTR_GROUP_NAME);
1461: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).ATTR_GROUP_DISP_NAME);
1462: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).DESCRIPTION);
1463: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).MULTI_ROW_CODE);

Line 1460: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).ATTR_GROUP_NAME);

1456: LOOP
1457: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).PAGE_ID);
1458: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).ATTR_GROUP_ID);
1459: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).ATTR_GROUP_TYPE);
1460: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).ATTR_GROUP_NAME);
1461: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).ATTR_GROUP_DISP_NAME);
1462: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).DESCRIPTION);
1463: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).MULTI_ROW_CODE);
1464: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).SECURITY_CODE);

Line 1461: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).ATTR_GROUP_DISP_NAME);

1457: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).PAGE_ID);
1458: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).ATTR_GROUP_ID);
1459: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).ATTR_GROUP_TYPE);
1460: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).ATTR_GROUP_NAME);
1461: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).ATTR_GROUP_DISP_NAME);
1462: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).DESCRIPTION);
1463: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).MULTI_ROW_CODE);
1464: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).SECURITY_CODE);
1465: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).NUM_OF_COLS);

Line 1462: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).DESCRIPTION);

1458: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).ATTR_GROUP_ID);
1459: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).ATTR_GROUP_TYPE);
1460: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).ATTR_GROUP_NAME);
1461: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).ATTR_GROUP_DISP_NAME);
1462: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).DESCRIPTION);
1463: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).MULTI_ROW_CODE);
1464: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).SECURITY_CODE);
1465: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).NUM_OF_COLS);
1466: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).NUM_OF_ROWS);

Line 1463: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).MULTI_ROW_CODE);

1459: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).ATTR_GROUP_TYPE);
1460: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).ATTR_GROUP_NAME);
1461: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).ATTR_GROUP_DISP_NAME);
1462: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).DESCRIPTION);
1463: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).MULTI_ROW_CODE);
1464: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).SECURITY_CODE);
1465: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).NUM_OF_COLS);
1466: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).NUM_OF_ROWS);
1467: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).SEQUENCE);

Line 1464: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).SECURITY_CODE);

1460: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).ATTR_GROUP_NAME);
1461: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).ATTR_GROUP_DISP_NAME);
1462: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).DESCRIPTION);
1463: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).MULTI_ROW_CODE);
1464: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).SECURITY_CODE);
1465: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).NUM_OF_COLS);
1466: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).NUM_OF_ROWS);
1467: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).SEQUENCE);
1468: DBMS_OUTPUT.PUT_LINE('--------------------------------');

Line 1465: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).NUM_OF_COLS);

1461: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).ATTR_GROUP_DISP_NAME);
1462: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).DESCRIPTION);
1463: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).MULTI_ROW_CODE);
1464: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).SECURITY_CODE);
1465: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).NUM_OF_COLS);
1466: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).NUM_OF_ROWS);
1467: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).SEQUENCE);
1468: DBMS_OUTPUT.PUT_LINE('--------------------------------');
1469: END LOOP;

Line 1466: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).NUM_OF_ROWS);

1462: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).DESCRIPTION);
1463: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).MULTI_ROW_CODE);
1464: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).SECURITY_CODE);
1465: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).NUM_OF_COLS);
1466: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).NUM_OF_ROWS);
1467: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).SEQUENCE);
1468: DBMS_OUTPUT.PUT_LINE('--------------------------------');
1469: END LOOP;
1470: END IF;

Line 1467: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).SEQUENCE);

1463: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).MULTI_ROW_CODE);
1464: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).SECURITY_CODE);
1465: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).NUM_OF_COLS);
1466: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).NUM_OF_ROWS);
1467: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).SEQUENCE);
1468: DBMS_OUTPUT.PUT_LINE('--------------------------------');
1469: END LOOP;
1470: END IF;
1471:

Line 1468: DBMS_OUTPUT.PUT_LINE('--------------------------------');

1464: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).SECURITY_CODE);
1465: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).NUM_OF_COLS);
1466: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).NUM_OF_ROWS);
1467: DBMS_OUTPUT.PUT_LINE(x_attR_group_tab(j).SEQUENCE);
1468: DBMS_OUTPUT.PUT_LINE('--------------------------------');
1469: END LOOP;
1470: END IF;
1471:
1472: IF x_attribute_tab IS NOT NULL AND x_attribute_tab.COUNT > 0 THEN

Line 1473: DBMS_OUTPUT.PUT_LINE('Attribute Information');

1469: END LOOP;
1470: END IF;
1471:
1472: IF x_attribute_tab IS NOT NULL AND x_attribute_tab.COUNT > 0 THEN
1473: DBMS_OUTPUT.PUT_LINE('Attribute Information');
1474: DBMS_OUTPUT.PUT_LINE('====================================');
1475: FOR i in 1 .. x_attribute_tab.COUNT
1476: LOOP
1477: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).ATTR_GROUP_TYPE);

Line 1474: DBMS_OUTPUT.PUT_LINE('====================================');

1470: END IF;
1471:
1472: IF x_attribute_tab IS NOT NULL AND x_attribute_tab.COUNT > 0 THEN
1473: DBMS_OUTPUT.PUT_LINE('Attribute Information');
1474: DBMS_OUTPUT.PUT_LINE('====================================');
1475: FOR i in 1 .. x_attribute_tab.COUNT
1476: LOOP
1477: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).ATTR_GROUP_TYPE);
1478: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).ATTR_GROUP_NAME);

Line 1477: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).ATTR_GROUP_TYPE);

1473: DBMS_OUTPUT.PUT_LINE('Attribute Information');
1474: DBMS_OUTPUT.PUT_LINE('====================================');
1475: FOR i in 1 .. x_attribute_tab.COUNT
1476: LOOP
1477: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).ATTR_GROUP_TYPE);
1478: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).ATTR_GROUP_NAME);
1479: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).EXTENSION_ID);
1480: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).ATTR_NAME);
1481: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).ATTR_DISPLAY_NAME);

Line 1478: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).ATTR_GROUP_NAME);

1474: DBMS_OUTPUT.PUT_LINE('====================================');
1475: FOR i in 1 .. x_attribute_tab.COUNT
1476: LOOP
1477: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).ATTR_GROUP_TYPE);
1478: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).ATTR_GROUP_NAME);
1479: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).EXTENSION_ID);
1480: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).ATTR_NAME);
1481: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).ATTR_DISPLAY_NAME);
1482: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).DESCRIPTION);

Line 1479: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).EXTENSION_ID);

1475: FOR i in 1 .. x_attribute_tab.COUNT
1476: LOOP
1477: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).ATTR_GROUP_TYPE);
1478: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).ATTR_GROUP_NAME);
1479: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).EXTENSION_ID);
1480: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).ATTR_NAME);
1481: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).ATTR_DISPLAY_NAME);
1482: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).DESCRIPTION);
1483: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).DISPLAY_VALUE);

Line 1480: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).ATTR_NAME);

1476: LOOP
1477: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).ATTR_GROUP_TYPE);
1478: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).ATTR_GROUP_NAME);
1479: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).EXTENSION_ID);
1480: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).ATTR_NAME);
1481: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).ATTR_DISPLAY_NAME);
1482: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).DESCRIPTION);
1483: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).DISPLAY_VALUE);
1484: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).DISPLAY_TYPE);

Line 1481: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).ATTR_DISPLAY_NAME);

1477: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).ATTR_GROUP_TYPE);
1478: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).ATTR_GROUP_NAME);
1479: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).EXTENSION_ID);
1480: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).ATTR_NAME);
1481: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).ATTR_DISPLAY_NAME);
1482: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).DESCRIPTION);
1483: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).DISPLAY_VALUE);
1484: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).DISPLAY_TYPE);
1485: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).DYNAMIC_URL);

Line 1482: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).DESCRIPTION);

1478: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).ATTR_GROUP_NAME);
1479: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).EXTENSION_ID);
1480: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).ATTR_NAME);
1481: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).ATTR_DISPLAY_NAME);
1482: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).DESCRIPTION);
1483: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).DISPLAY_VALUE);
1484: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).DISPLAY_TYPE);
1485: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).DYNAMIC_URL);
1486: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).SEQUENCE);

Line 1483: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).DISPLAY_VALUE);

1479: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).EXTENSION_ID);
1480: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).ATTR_NAME);
1481: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).ATTR_DISPLAY_NAME);
1482: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).DESCRIPTION);
1483: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).DISPLAY_VALUE);
1484: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).DISPLAY_TYPE);
1485: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).DYNAMIC_URL);
1486: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).SEQUENCE);
1487: DBMS_OUTPUT.PUT_LINE('--------------------------------');

Line 1484: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).DISPLAY_TYPE);

1480: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).ATTR_NAME);
1481: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).ATTR_DISPLAY_NAME);
1482: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).DESCRIPTION);
1483: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).DISPLAY_VALUE);
1484: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).DISPLAY_TYPE);
1485: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).DYNAMIC_URL);
1486: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).SEQUENCE);
1487: DBMS_OUTPUT.PUT_LINE('--------------------------------');
1488: END LOOP;

Line 1485: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).DYNAMIC_URL);

1481: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).ATTR_DISPLAY_NAME);
1482: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).DESCRIPTION);
1483: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).DISPLAY_VALUE);
1484: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).DISPLAY_TYPE);
1485: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).DYNAMIC_URL);
1486: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).SEQUENCE);
1487: DBMS_OUTPUT.PUT_LINE('--------------------------------');
1488: END LOOP;
1489: END IF;

Line 1486: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).SEQUENCE);

1482: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).DESCRIPTION);
1483: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).DISPLAY_VALUE);
1484: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).DISPLAY_TYPE);
1485: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).DYNAMIC_URL);
1486: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).SEQUENCE);
1487: DBMS_OUTPUT.PUT_LINE('--------------------------------');
1488: END LOOP;
1489: END IF;
1490:

Line 1487: DBMS_OUTPUT.PUT_LINE('--------------------------------');

1483: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).DISPLAY_VALUE);
1484: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).DISPLAY_TYPE);
1485: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).DYNAMIC_URL);
1486: DBMS_OUTPUT.PUT_LINE(x_attribute_tab(i).SEQUENCE);
1487: DBMS_OUTPUT.PUT_LINE('--------------------------------');
1488: END LOOP;
1489: END IF;
1490:
1491: IF x_error_messages IS NOT NULL AND x_error_messages.COUNT > 0 THEN

Line 1492: DBMS_OUTPUT.PUT_LINE(x_error_messages.COUNT);

1488: END LOOP;
1489: END IF;
1490:
1491: IF x_error_messages IS NOT NULL AND x_error_messages.COUNT > 0 THEN
1492: DBMS_OUTPUT.PUT_LINE(x_error_messages.COUNT);
1493: FOR i in 1 .. x_error_messages.COUNT
1494: LOOP
1495: DBMS_OUTPUT.PUT_LINE(x_error_messages(i));
1496: END LOOP;

Line 1495: DBMS_OUTPUT.PUT_LINE(x_error_messages(i));

1491: IF x_error_messages IS NOT NULL AND x_error_messages.COUNT > 0 THEN
1492: DBMS_OUTPUT.PUT_LINE(x_error_messages.COUNT);
1493: FOR i in 1 .. x_error_messages.COUNT
1494: LOOP
1495: DBMS_OUTPUT.PUT_LINE(x_error_messages(i));
1496: END LOOP;
1497: END IF;
1498:
1499: Get_Primary_Attributes('HIERARCHY',