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.CN_SFP_SRP_UTIL_PVT dependencies on DBMS_SQL

Line 58: -- p_include_array IN DBMS_SQL.NUMBER_TABLE ,

54: -- Function :
55: -- Pre-reqs : None.
56: -- Parameters :
57: -- IN :
58: -- p_include_array IN DBMS_SQL.NUMBER_TABLE ,
59: -- p_exclude_array IN DBMS_SQL.NUMBER_TABLE ,
60: -- p_date IN DATE := SYSDATE,
61: -- p_type
62: -- OUT : x_hierarchy_groups OUT NOCOPY DBMS_SQL.NUMBER_TABLE

Line 59: -- p_exclude_array IN DBMS_SQL.NUMBER_TABLE ,

55: -- Pre-reqs : None.
56: -- Parameters :
57: -- IN :
58: -- p_include_array IN DBMS_SQL.NUMBER_TABLE ,
59: -- p_exclude_array IN DBMS_SQL.NUMBER_TABLE ,
60: -- p_date IN DATE := SYSDATE,
61: -- p_type
62: -- OUT : x_hierarchy_groups OUT NOCOPY DBMS_SQL.NUMBER_TABLE
63: -- Version : Current version 1.0

Line 62: -- OUT : x_hierarchy_groups OUT NOCOPY DBMS_SQL.NUMBER_TABLE

58: -- p_include_array IN DBMS_SQL.NUMBER_TABLE ,
59: -- p_exclude_array IN DBMS_SQL.NUMBER_TABLE ,
60: -- p_date IN DATE := SYSDATE,
61: -- p_type
62: -- OUT : x_hierarchy_groups OUT NOCOPY DBMS_SQL.NUMBER_TABLE
63: -- Version : Current version 1.0
64:
65: --
66: -- Notes : Given certain root groups, this procedure gets all groups under their heirarchies but

Line 72: p_include_array IN DBMS_SQL.NUMBER_TABLE ,

68: --
69: -- End of comments
70: PROCEDURE Get_Groups_In_Hierarchy
71: (
72: p_include_array IN DBMS_SQL.NUMBER_TABLE ,
73: p_exclude_array IN DBMS_SQL.NUMBER_TABLE ,
74: p_date IN DATE := SYSDATE,
75: x_hierarchy_groups OUT NOCOPY DBMS_SQL.NUMBER_TABLE
76: ) ;

Line 73: p_exclude_array IN DBMS_SQL.NUMBER_TABLE ,

69: -- End of comments
70: PROCEDURE Get_Groups_In_Hierarchy
71: (
72: p_include_array IN DBMS_SQL.NUMBER_TABLE ,
73: p_exclude_array IN DBMS_SQL.NUMBER_TABLE ,
74: p_date IN DATE := SYSDATE,
75: x_hierarchy_groups OUT NOCOPY DBMS_SQL.NUMBER_TABLE
76: ) ;
77:

Line 75: x_hierarchy_groups OUT NOCOPY DBMS_SQL.NUMBER_TABLE

71: (
72: p_include_array IN DBMS_SQL.NUMBER_TABLE ,
73: p_exclude_array IN DBMS_SQL.NUMBER_TABLE ,
74: p_date IN DATE := SYSDATE,
75: x_hierarchy_groups OUT NOCOPY DBMS_SQL.NUMBER_TABLE
76: ) ;
77:
78:
79: -- Start of comments

Line 94: -- x_update_groups OUT DBMS_SQL.NUMBER_TABLE,

90: -- p_validation_level IN NUMBER Optional
91: -- Default = FND_API.G_VALID_LEVEL_FULL
92: -- p_org_code IN VARCHAR2 := NULL,
93: -- p_date IN VARCHAR2,
94: -- x_update_groups OUT DBMS_SQL.NUMBER_TABLE,
95: -- x_view_groups OUT DBMS_SQL.NUMBER_TABLE,
96: -- OUT : x_return_status OUT VARCHAR2(1)
97: -- x_msg_count OUT NUMBER
98: -- x_msg_data OUT VARCHAR2(2000)

Line 95: -- x_view_groups OUT DBMS_SQL.NUMBER_TABLE,

91: -- Default = FND_API.G_VALID_LEVEL_FULL
92: -- p_org_code IN VARCHAR2 := NULL,
93: -- p_date IN VARCHAR2,
94: -- x_update_groups OUT DBMS_SQL.NUMBER_TABLE,
95: -- x_view_groups OUT DBMS_SQL.NUMBER_TABLE,
96: -- OUT : x_return_status OUT VARCHAR2(1)
97: -- x_msg_count OUT NUMBER
98: -- x_msg_data OUT VARCHAR2(2000)
99: -- Version : Current version 1.0

Line 115: x_update_groups OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

111: p_commit IN VARCHAR2 := FND_API.G_FALSE,
112: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
113: p_org_code IN VARCHAR2 := NULL,
114: p_date IN VARCHAR2,
115: x_update_groups OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
116: x_view_groups OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
117: x_return_status OUT NOCOPY VARCHAR2,
118: x_msg_count OUT NOCOPY NUMBER,
119: x_msg_data OUT NOCOPY VARCHAR2

Line 116: x_view_groups OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

112: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
113: p_org_code IN VARCHAR2 := NULL,
114: p_date IN VARCHAR2,
115: x_update_groups OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
116: x_view_groups OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
117: x_return_status OUT NOCOPY VARCHAR2,
118: x_msg_count OUT NOCOPY NUMBER,
119: x_msg_data OUT NOCOPY VARCHAR2
120: ) ;

Line 137: -- p_update_groups IN DBMS_SQL.NUMBER_TABLE,

133: -- p_validation_level IN NUMBER Optional
134: -- Default = FND_API.G_VALID_LEVEL_FULL
135: -- p_default_all
136: -- p_group_id
137: -- p_update_groups IN DBMS_SQL.NUMBER_TABLE,
138: -- p_view_groups IN DBMS_SQL.NUMBER_TABLE,
139: -- OUT : x_return_status OUT VARCHAR2(1)
140: -- x_msg_count OUT NUMBER
141: -- x_msg_data OUT VARCHAR2(2000)

Line 138: -- p_view_groups IN DBMS_SQL.NUMBER_TABLE,

134: -- Default = FND_API.G_VALID_LEVEL_FULL
135: -- p_default_all
136: -- p_group_id
137: -- p_update_groups IN DBMS_SQL.NUMBER_TABLE,
138: -- p_view_groups IN DBMS_SQL.NUMBER_TABLE,
139: -- OUT : x_return_status OUT VARCHAR2(1)
140: -- x_msg_count OUT NUMBER
141: -- x_msg_data OUT VARCHAR2(2000)
142: -- x_privilege OUT VARCHAR2,

Line 158: p_update_groups IN DBMS_SQL.NUMBER_TABLE,

154: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
155: p_commit IN VARCHAR2 := FND_API.G_FALSE,
156: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
157: p_group_id IN NUMBER,
158: p_update_groups IN DBMS_SQL.NUMBER_TABLE,
159: p_view_groups IN DBMS_SQL.NUMBER_TABLE,
160: x_privilege OUT NOCOPY VARCHAR2,
161: x_return_status OUT NOCOPY VARCHAR2,
162: x_msg_count OUT NOCOPY NUMBER,

Line 159: p_view_groups IN DBMS_SQL.NUMBER_TABLE,

155: p_commit IN VARCHAR2 := FND_API.G_FALSE,
156: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
157: p_group_id IN NUMBER,
158: p_update_groups IN DBMS_SQL.NUMBER_TABLE,
159: p_view_groups IN DBMS_SQL.NUMBER_TABLE,
160: x_privilege OUT NOCOPY VARCHAR2,
161: x_return_status OUT NOCOPY VARCHAR2,
162: x_msg_count OUT NOCOPY NUMBER,
163: x_msg_data OUT NOCOPY VARCHAR2