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.PER_SECURITY_PROFILES_PKG dependencies on DUAL

Line 36: X_Restrict_On_Individual_Asg VARCHAR2,

32: X_Custom_Restriction_Flag VARCHAR2,
33: X_Restriction_Text VARCHAR2,
34: X_Exclude_Business_Groups_Flag VARCHAR2,
35: X_Org_Security_Mode VARCHAR2,
36: X_Restrict_On_Individual_Asg VARCHAR2,
37: X_Top_Organization_Method VARCHAR2,
38: X_Top_Position_Method VARCHAR2,
39: X_Request_Id NUMBER,
40: X_Program_Application_Id NUMBER,

Line 47: CURSOR C2 IS SELECT per_security_profiles_s.nextval FROM sys.dual;

43: ) IS
44: CURSOR C IS SELECT rowid FROM per_security_profiles
45: WHERE security_profile_id = X_Security_Profile_Id;
46: --
47: CURSOR C2 IS SELECT per_security_profiles_s.nextval FROM sys.dual;
48: BEGIN
49:
50: if (X_Security_Profile_Id is NULL) then
51: OPEN C2;

Line 86: restrict_on_individual_asg,

82: custom_restriction_flag,
83: restriction_text,
84: exclude_business_groups_flag,
85: org_security_mode,
86: restrict_on_individual_asg,
87: top_organization_method,
88: top_position_method,
89: request_id,
90: program_application_id,

Line 124: X_Restrict_On_Individual_Asg,

120: X_Custom_Restriction_Flag,
121: X_Restriction_Text,
122: X_Exclude_Business_Groups_Flag,
123: X_Org_Security_Mode,
124: X_Restrict_On_Individual_Asg,
125: X_Top_Organization_Method,
126: X_Top_Position_Method,
127: X_Request_Id,
128: X_Program_Application_Id,

Line 176: X_Restrict_On_Individual_Asg VARCHAR2,

172: X_Custom_Restriction_Flag VARCHAR2,
173: X_Restriction_Text VARCHAR2,
174: X_Exclude_Business_Groups_Flag VARCHAR2,
175: X_Org_Security_Mode VARCHAR2,
176: X_Restrict_On_Individual_Asg VARCHAR2,
177: X_Top_Organization_Method VARCHAR2,
178: X_Top_Position_Method VARCHAR2
179: ) IS
180: CURSOR C IS

Line 221: recinfo.restrict_on_individual_asg:=rtrim(recinfo.restrict_on_individual_asg);

217: recinfo.custom_restriction_flag:=rtrim(recinfo.custom_restriction_flag);
218: recinfo.restriction_text:=rtrim(recinfo.restriction_text);
219: recinfo.exclude_business_groups_flag:=rtrim(recinfo.exclude_business_groups_flag);
220: recinfo.org_security_mode:=rtrim(recinfo.org_security_mode);
221: recinfo.restrict_on_individual_asg:=rtrim(recinfo.restrict_on_individual_asg);
222: recinfo.top_organization_method:=rtrim(recinfo.top_organization_method);
223: recinfo.top_position_method:=rtrim(recinfo.top_position_method);
224:
225: if (

Line 317: AND ( (Recinfo.restrict_on_individual_asg = X_Restrict_On_Individual_Asg)

313: AND (X_Exclude_Business_Groups_Flag IS NULL)))
314: AND ( (Recinfo.org_security_mode = X_Org_Security_Mode)
315: OR ( (Recinfo.org_security_mode IS NULL)
316: AND (X_Org_Security_Mode IS NULL)))
317: AND ( (Recinfo.restrict_on_individual_asg = X_Restrict_On_Individual_Asg)
318: OR ( (Recinfo.restrict_on_individual_asg IS NULL)
319: AND (X_Restrict_On_Individual_Asg IS NULL)))
320: AND ( (Recinfo.top_organization_method = X_Top_Organization_Method)
321: OR ( (Recinfo.top_organization_method IS NULL)

Line 318: OR ( (Recinfo.restrict_on_individual_asg IS NULL)

314: AND ( (Recinfo.org_security_mode = X_Org_Security_Mode)
315: OR ( (Recinfo.org_security_mode IS NULL)
316: AND (X_Org_Security_Mode IS NULL)))
317: AND ( (Recinfo.restrict_on_individual_asg = X_Restrict_On_Individual_Asg)
318: OR ( (Recinfo.restrict_on_individual_asg IS NULL)
319: AND (X_Restrict_On_Individual_Asg IS NULL)))
320: AND ( (Recinfo.top_organization_method = X_Top_Organization_Method)
321: OR ( (Recinfo.top_organization_method IS NULL)
322: AND (X_Top_Organization_Method IS NULL)))

Line 319: AND (X_Restrict_On_Individual_Asg IS NULL)))

315: OR ( (Recinfo.org_security_mode IS NULL)
316: AND (X_Org_Security_Mode IS NULL)))
317: AND ( (Recinfo.restrict_on_individual_asg = X_Restrict_On_Individual_Asg)
318: OR ( (Recinfo.restrict_on_individual_asg IS NULL)
319: AND (X_Restrict_On_Individual_Asg IS NULL)))
320: AND ( (Recinfo.top_organization_method = X_Top_Organization_Method)
321: OR ( (Recinfo.top_organization_method IS NULL)
322: AND (X_Top_Organization_Method IS NULL)))
323: AND ( (Recinfo.top_position_method = X_Top_Position_Method)

Line 365: X_Restrict_On_Individual_Asg VARCHAR2,

361: X_Custom_Restriction_Flag VARCHAR2,
362: X_Restriction_Text VARCHAR2,
363: X_Exclude_Business_Groups_Flag VARCHAR2,
364: X_Org_Security_Mode VARCHAR2,
365: X_Restrict_On_Individual_Asg VARCHAR2,
366: X_Top_Organization_Method VARCHAR2,
367: X_Top_Position_Method VARCHAR2,
368: X_Request_Id NUMBER,
369: X_Program_Application_Id NUMBER,

Line 406: restrict_on_individual_asg = X_Restrict_On_Individual_Asg,

402: custom_restriction_flag = X_Custom_Restriction_Flag,
403: restriction_text = X_Restriction_Text,
404: exclude_business_groups_flag = X_Exclude_Business_Groups_Flag,
405: org_security_mode = X_Org_Security_Mode,
406: restrict_on_individual_asg = X_Restrict_On_Individual_Asg,
407: top_organization_method = X_Top_Organization_Method,
408: top_position_method = X_Top_Position_Method,
409: request_id = X_Request_Id,
410: program_application_id = X_Program_Application_Id,