DBA Data[Home] [Help]

APPS.RRS_ATTR_PANE dependencies on RRS_PRIMARY_ATTRIBUTE_REC

Line 9: x_primary_attributes OUT NOCOPY rrs_primary_attribute_rec,

5: PROCEDURE Get_Primary_Attributes
6: (
7: p_object_type IN VARCHAR2,
8: p_object_id IN VARCHAR2,
9: x_primary_attributes OUT NOCOPY rrs_primary_attribute_rec,
10: x_error_messages OUT NOCOPY rrs_error_msg_tab
11: ) IS
12:
13: l_object_table_name VARCHAR2(30);

Line 28: SELECT RRS_PRIMARY_ATTRIBUTE_REC(

24: /* decide which object type we are processing*/
25: --Add RBAC on Site Object View
26: IF UPPER(p_object_type) = 'SITE' AND RRS_SECURITY_PUB.Check_Object_View_Privilege(1.0, 'RRS_SITE', p_object_id) = 'T' THEN
27: BEGIN
28: SELECT RRS_PRIMARY_ATTRIBUTE_REC(
29: SITE_ID,
30: SITE_IDENTIFICATION_NUMBER,
31: NAME,
32: (SELECT MEANING

Line 63: SELECT RRS_PRIMARY_ATTRIBUTE_REC(

59: END;
60:
61: ELSIF UPPER(p_object_type) = 'LOCATION' THEN
62: BEGIN
63: SELECT RRS_PRIMARY_ATTRIBUTE_REC(
64: LOCATION_ID,
65: NULL,
66: NULL,
67: COUNTRY,

Line 91: SELECT RRS_PRIMARY_ATTRIBUTE_REC(

87: END;
88:
89: ELSIF UPPER(p_object_type) = 'NODE' THEN
90: BEGIN
91: SELECT RRS_PRIMARY_ATTRIBUTE_REC(
92: SITE_GROUP_NODE_ID,
93: NODE_IDENTIFICATION_NUMBER,
94: NAME,
95: (SELECT MEANING

Line 121: SELECT RRS_PRIMARY_ATTRIBUTE_REC(

117: Record_Error('Get_Primary_Attributes: ' || dbms_utility.format_error_backtrace, x_error_messages);
118: END;
119:
120: /*ELSIF UPPER(p_object_type) = 'TRADE AREA' THEN
121: SELECT RRS_PRIMARY_ATTRIBUTE_REC(
122: GROUP_ID,
123: SITE_IDENTIFICATION_NUMBER,
124: NAME,
125: (SELECT MEANING

Line 149: SELECT RRS_PRIMARY_ATTRIBUTE_REC(

145: */
146: --Add RBAC on Hierarchy object VIEW
147: ELSIF UPPER(p_object_type) = 'HIERARCHY' AND RRS_SECURITY_PUB.Check_Object_View_Privilege(1.0, 'RRS_HIERARCHY', p_object_id) = 'T' THEN
148: BEGIN
149: SELECT RRS_PRIMARY_ATTRIBUTE_REC(
150: SITE_GROUP_ID,
151: NULL,
152: NAME,
153: (SELECT MEANING

Line 197: x_primary_attributes OUT NOCOPY rrs_primary_attribute_rec,

193: p_object1 IN VARCHAR2,
194: p_classification_code1 IN VARCHAR2,
195: p_object2 IN VARCHAR2,
196: p_classification_code2 IN VARCHAR2,
197: x_primary_attributes OUT NOCOPY rrs_primary_attribute_rec,
198: x_ag_page_tab OUT NOCOPY rrs_attr_group_page_tab,
199: x_attr_group_tab OUT NOCOPY rrs_attribute_group_tab,
200: x_attribute_tab OUT NOCOPY rrs_attribute_tab,
201: x_error_messages OUT NOCOPY rrs_error_msg_tab

Line 1363: x_primary_attributes rrs_primary_attribute_rec;

1359: x_ag_page_tab rrs_attr_group_page_tab;
1360: x_attr_group_tab rrs_attribute_group_tab;
1361: x_attribute_tab rrs_attribute_tab;
1362:
1363: x_primary_attributes rrs_primary_attribute_rec;
1364: x_error_data VARCHAR2(1000);
1365: x_error_messages rrs_error_msg_tab;
1366:
1367: BEGIN