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 7: FUNCTION contains(value NUMBER, collection DBMS_SQL.NUMBER_TABLE)

3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_SFP_SRP_UTIL_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnvsfsrb.pls';
6:
7: FUNCTION contains(value NUMBER, collection DBMS_SQL.NUMBER_TABLE)
8: RETURN BOOLEAN
9: IS
10: BEGIN
11: IF collection IS NULL THEN

Line 24: FUNCTION getString(prefix VARCHAR2,collection DBMS_SQL.NUMBER_TABLE, cond BOOLEAN)

20: END IF ;
21: RETURN FALSE ;
22: END ;
23:
24: FUNCTION getString(prefix VARCHAR2,collection DBMS_SQL.NUMBER_TABLE, cond BOOLEAN)
25: RETURN VARCHAR2
26: IS
27: l_ret_val VARCHAR2(2000) := NULL ;
28: l_count NUMBER := 0 ;

Line 51: PROCEDURE addBindVariables( csr NUMBER, prefix VARCHAR2, collection DBMS_SQL.NUMBER_TABLE)

47: END IF ;
48: RETURN l_ret_val ;
49: END ;
50:
51: PROCEDURE addBindVariables( csr NUMBER, prefix VARCHAR2, collection DBMS_SQL.NUMBER_TABLE)
52: IS
53: BEGIN
54: IF collection IS NULL OR collection.count < 1 THEN
55: return ;

Line 58: DBMS_SQL.bind_variable(csr, prefix || z ,collection(z)) ;

54: IF collection IS NULL OR collection.count < 1 THEN
55: return ;
56: END IF ;
57: FOR z IN collection.FIRST..collection.LAST LOOP
58: DBMS_SQL.bind_variable(csr, prefix || z ,collection(z)) ;
59: END LOOP ;
60: END ;
61:
62:

Line 65: p_include_array IN DBMS_SQL.NUMBER_TABLE ,

61:
62:
63: PROCEDURE Get_Groups_In_Hierarchy
64: (
65: p_include_array IN DBMS_SQL.NUMBER_TABLE ,
66: p_exclude_array IN DBMS_SQL.NUMBER_TABLE ,
67: p_date IN DATE := SYSDATE,
68: x_hierarchy_groups OUT NOCOPY DBMS_SQL.NUMBER_TABLE
69: )

Line 66: p_exclude_array IN DBMS_SQL.NUMBER_TABLE ,

62:
63: PROCEDURE Get_Groups_In_Hierarchy
64: (
65: p_include_array IN DBMS_SQL.NUMBER_TABLE ,
66: p_exclude_array IN DBMS_SQL.NUMBER_TABLE ,
67: p_date IN DATE := SYSDATE,
68: x_hierarchy_groups OUT NOCOPY DBMS_SQL.NUMBER_TABLE
69: )
70: IS

Line 68: x_hierarchy_groups OUT NOCOPY DBMS_SQL.NUMBER_TABLE

64: (
65: p_include_array IN DBMS_SQL.NUMBER_TABLE ,
66: p_exclude_array IN DBMS_SQL.NUMBER_TABLE ,
67: p_date IN DATE := SYSDATE,
68: x_hierarchy_groups OUT NOCOPY DBMS_SQL.NUMBER_TABLE
69: )
70: IS
71: l_ret_array DBMS_SQL.NUMBER_TABLE ;
72: l_include_string VARCHAR2(2000) := 'X' ;

Line 71: l_ret_array DBMS_SQL.NUMBER_TABLE ;

67: p_date IN DATE := SYSDATE,
68: x_hierarchy_groups OUT NOCOPY DBMS_SQL.NUMBER_TABLE
69: )
70: IS
71: l_ret_array DBMS_SQL.NUMBER_TABLE ;
72: l_include_string VARCHAR2(2000) := 'X' ;
73: l_exclude_string VARCHAR2(2000) := ' ' ;
74: l_exclude_string_2 VARCHAR2(2000) := ' ' ;
75: l_sql VARCHAR2(4000) := ' ' ;

Line 112: select_cursor := DBMS_SQL.OPEN_CURSOR;

108:
109: --insert into fam_temp(attr1,time)values(l_sql,sysdate) ;
110: --commit ;
111:
112: select_cursor := DBMS_SQL.OPEN_CURSOR;
113: DBMS_SQL.parse(select_cursor, l_sql, DBMS_SQL.NATIVE);
114: DBMS_SQL.define_array (select_cursor, 1, x_hierarchy_groups, 10, 1);
115:
116: DBMS_SQL.bind_variable(select_cursor, ':DATE1', l_date);

Line 113: DBMS_SQL.parse(select_cursor, l_sql, DBMS_SQL.NATIVE);

109: --insert into fam_temp(attr1,time)values(l_sql,sysdate) ;
110: --commit ;
111:
112: select_cursor := DBMS_SQL.OPEN_CURSOR;
113: DBMS_SQL.parse(select_cursor, l_sql, DBMS_SQL.NATIVE);
114: DBMS_SQL.define_array (select_cursor, 1, x_hierarchy_groups, 10, 1);
115:
116: DBMS_SQL.bind_variable(select_cursor, ':DATE1', l_date);
117: DBMS_SQL.bind_variable(select_cursor, ':DATE2', l_date);

Line 114: DBMS_SQL.define_array (select_cursor, 1, x_hierarchy_groups, 10, 1);

110: --commit ;
111:
112: select_cursor := DBMS_SQL.OPEN_CURSOR;
113: DBMS_SQL.parse(select_cursor, l_sql, DBMS_SQL.NATIVE);
114: DBMS_SQL.define_array (select_cursor, 1, x_hierarchy_groups, 10, 1);
115:
116: DBMS_SQL.bind_variable(select_cursor, ':DATE1', l_date);
117: DBMS_SQL.bind_variable(select_cursor, ':DATE2', l_date);
118: DBMS_SQL.bind_variable(select_cursor, ':DATE3', l_date);

Line 116: DBMS_SQL.bind_variable(select_cursor, ':DATE1', l_date);

112: select_cursor := DBMS_SQL.OPEN_CURSOR;
113: DBMS_SQL.parse(select_cursor, l_sql, DBMS_SQL.NATIVE);
114: DBMS_SQL.define_array (select_cursor, 1, x_hierarchy_groups, 10, 1);
115:
116: DBMS_SQL.bind_variable(select_cursor, ':DATE1', l_date);
117: DBMS_SQL.bind_variable(select_cursor, ':DATE2', l_date);
118: DBMS_SQL.bind_variable(select_cursor, ':DATE3', l_date);
119: DBMS_SQL.bind_variable(select_cursor, ':DATE4', l_date);
120: DBMS_SQL.bind_variable(select_cursor, ':DATE5', l_date);

Line 117: DBMS_SQL.bind_variable(select_cursor, ':DATE2', l_date);

113: DBMS_SQL.parse(select_cursor, l_sql, DBMS_SQL.NATIVE);
114: DBMS_SQL.define_array (select_cursor, 1, x_hierarchy_groups, 10, 1);
115:
116: DBMS_SQL.bind_variable(select_cursor, ':DATE1', l_date);
117: DBMS_SQL.bind_variable(select_cursor, ':DATE2', l_date);
118: DBMS_SQL.bind_variable(select_cursor, ':DATE3', l_date);
119: DBMS_SQL.bind_variable(select_cursor, ':DATE4', l_date);
120: DBMS_SQL.bind_variable(select_cursor, ':DATE5', l_date);
121: DBMS_SQL.bind_variable(select_cursor, ':DATE6', l_date);

Line 118: DBMS_SQL.bind_variable(select_cursor, ':DATE3', l_date);

114: DBMS_SQL.define_array (select_cursor, 1, x_hierarchy_groups, 10, 1);
115:
116: DBMS_SQL.bind_variable(select_cursor, ':DATE1', l_date);
117: DBMS_SQL.bind_variable(select_cursor, ':DATE2', l_date);
118: DBMS_SQL.bind_variable(select_cursor, ':DATE3', l_date);
119: DBMS_SQL.bind_variable(select_cursor, ':DATE4', l_date);
120: DBMS_SQL.bind_variable(select_cursor, ':DATE5', l_date);
121: DBMS_SQL.bind_variable(select_cursor, ':DATE6', l_date);
122:

Line 119: DBMS_SQL.bind_variable(select_cursor, ':DATE4', l_date);

115:
116: DBMS_SQL.bind_variable(select_cursor, ':DATE1', l_date);
117: DBMS_SQL.bind_variable(select_cursor, ':DATE2', l_date);
118: DBMS_SQL.bind_variable(select_cursor, ':DATE3', l_date);
119: DBMS_SQL.bind_variable(select_cursor, ':DATE4', l_date);
120: DBMS_SQL.bind_variable(select_cursor, ':DATE5', l_date);
121: DBMS_SQL.bind_variable(select_cursor, ':DATE6', l_date);
122:
123: addBindVariables(select_cursor,'INCBIND',p_include_array) ;

Line 120: DBMS_SQL.bind_variable(select_cursor, ':DATE5', l_date);

116: DBMS_SQL.bind_variable(select_cursor, ':DATE1', l_date);
117: DBMS_SQL.bind_variable(select_cursor, ':DATE2', l_date);
118: DBMS_SQL.bind_variable(select_cursor, ':DATE3', l_date);
119: DBMS_SQL.bind_variable(select_cursor, ':DATE4', l_date);
120: DBMS_SQL.bind_variable(select_cursor, ':DATE5', l_date);
121: DBMS_SQL.bind_variable(select_cursor, ':DATE6', l_date);
122:
123: addBindVariables(select_cursor,'INCBIND',p_include_array) ;
124: addBindVariables(select_cursor,'EXBIND', p_exclude_array) ;

Line 121: DBMS_SQL.bind_variable(select_cursor, ':DATE6', l_date);

117: DBMS_SQL.bind_variable(select_cursor, ':DATE2', l_date);
118: DBMS_SQL.bind_variable(select_cursor, ':DATE3', l_date);
119: DBMS_SQL.bind_variable(select_cursor, ':DATE4', l_date);
120: DBMS_SQL.bind_variable(select_cursor, ':DATE5', l_date);
121: DBMS_SQL.bind_variable(select_cursor, ':DATE6', l_date);
122:
123: addBindVariables(select_cursor,'INCBIND',p_include_array) ;
124: addBindVariables(select_cursor,'EXBIND', p_exclude_array) ;
125: addBindVariables(select_cursor,'EX2BIND',p_exclude_array) ;

Line 127: l_match_rows := DBMS_SQL.EXECUTE(select_cursor);

123: addBindVariables(select_cursor,'INCBIND',p_include_array) ;
124: addBindVariables(select_cursor,'EXBIND', p_exclude_array) ;
125: addBindVariables(select_cursor,'EX2BIND',p_exclude_array) ;
126: -- execute
127: l_match_rows := DBMS_SQL.EXECUTE(select_cursor);
128:
129: LOOP
130: l_match_rows := DBMS_SQL.fetch_rows(select_cursor);
131: DBMS_SQL.column_value (select_cursor, 1, x_hierarchy_groups);

Line 130: l_match_rows := DBMS_SQL.fetch_rows(select_cursor);

126: -- execute
127: l_match_rows := DBMS_SQL.EXECUTE(select_cursor);
128:
129: LOOP
130: l_match_rows := DBMS_SQL.fetch_rows(select_cursor);
131: DBMS_SQL.column_value (select_cursor, 1, x_hierarchy_groups);
132: EXIT WHEN l_match_rows <> 10 ;
133: END LOOP ;
134:

Line 131: DBMS_SQL.column_value (select_cursor, 1, x_hierarchy_groups);

127: l_match_rows := DBMS_SQL.EXECUTE(select_cursor);
128:
129: LOOP
130: l_match_rows := DBMS_SQL.fetch_rows(select_cursor);
131: DBMS_SQL.column_value (select_cursor, 1, x_hierarchy_groups);
132: EXIT WHEN l_match_rows <> 10 ;
133: END LOOP ;
134:
135: DBMS_SQL.close_cursor(select_cursor);

Line 135: DBMS_SQL.close_cursor(select_cursor);

131: DBMS_SQL.column_value (select_cursor, 1, x_hierarchy_groups);
132: EXIT WHEN l_match_rows <> 10 ;
133: END LOOP ;
134:
135: DBMS_SQL.close_cursor(select_cursor);
136: END IF ;
137:
138: EXCEPTION
139: WHEN OTHERS THEN

Line 140: IF (DBMS_SQL.is_open(select_cursor)) THEN

136: END IF ;
137:
138: EXCEPTION
139: WHEN OTHERS THEN
140: IF (DBMS_SQL.is_open(select_cursor)) THEN
141: DBMS_SQL.close_cursor(select_cursor);
142: END IF;
143: RAISE ;
144: END ;

Line 141: DBMS_SQL.close_cursor(select_cursor);

137:
138: EXCEPTION
139: WHEN OTHERS THEN
140: IF (DBMS_SQL.is_open(select_cursor)) THEN
141: DBMS_SQL.close_cursor(select_cursor);
142: END IF;
143: RAISE ;
144: END ;
145:

Line 344: -- x_update_groups OUT DBMS_SQL.NUMBER_TABLE,

340: -- p_commit IN VARCHAR2 Optional
341: -- Default = FND_API.G_FALSE
342: -- p_validation_level IN NUMBER Optional
343: -- Default = FND_API.G_VALID_LEVEL_FULL
344: -- x_update_groups OUT DBMS_SQL.NUMBER_TABLE,
345: -- x_view_groups OUT DBMS_SQL.NUMBER_TABLE,
346: -- OUT : x_return_status OUT VARCHAR2(1)
347: -- x_msg_count OUT NUMBER
348: -- x_msg_data OUT VARCHAR2(2000)

Line 345: -- x_view_groups OUT DBMS_SQL.NUMBER_TABLE,

341: -- Default = FND_API.G_FALSE
342: -- p_validation_level IN NUMBER Optional
343: -- Default = FND_API.G_VALID_LEVEL_FULL
344: -- x_update_groups OUT DBMS_SQL.NUMBER_TABLE,
345: -- x_view_groups OUT DBMS_SQL.NUMBER_TABLE,
346: -- OUT : x_return_status OUT VARCHAR2(1)
347: -- x_msg_count OUT NUMBER
348: -- x_msg_data OUT VARCHAR2(2000)
349: -- Version : Current version 1.0

Line 365: x_update_groups OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

361: p_commit IN VARCHAR2 := FND_API.G_FALSE,
362: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
363: p_org_code IN VARCHAR2 := NULL,
364: p_date IN VARCHAR2,
365: x_update_groups OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
366: x_view_groups OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
367: x_return_status OUT NOCOPY VARCHAR2,
368: x_msg_count OUT NOCOPY NUMBER,
369: x_msg_data OUT NOCOPY VARCHAR2

Line 366: x_view_groups OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

362: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
363: p_org_code IN VARCHAR2 := NULL,
364: p_date IN VARCHAR2,
365: x_update_groups OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
366: x_view_groups OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
367: x_return_status OUT NOCOPY VARCHAR2,
368: x_msg_count OUT NOCOPY NUMBER,
369: x_msg_data OUT NOCOPY VARCHAR2
370: )

Line 375: VIEW_ARRAY DBMS_SQL.NUMBER_TABLE;

371: IS
372: l_api_name CONSTANT VARCHAR2(30) := 'Get_All_Groups_Access';
373: l_api_version CONSTANT NUMBER := 1.0;
374:
375: VIEW_ARRAY DBMS_SQL.NUMBER_TABLE;
376: UPDATE_ARRAY DBMS_SQL.NUMBER_TABLE;
377: L_REG_GROUPS DBMS_SQL.NUMBER_TABLE ;
378: hier_update_groups DBMS_SQL.NUMBER_TABLE ;
379: hier_view_groups DBMS_SQL.NUMBER_TABLE ;

Line 376: UPDATE_ARRAY DBMS_SQL.NUMBER_TABLE;

372: l_api_name CONSTANT VARCHAR2(30) := 'Get_All_Groups_Access';
373: l_api_version CONSTANT NUMBER := 1.0;
374:
375: VIEW_ARRAY DBMS_SQL.NUMBER_TABLE;
376: UPDATE_ARRAY DBMS_SQL.NUMBER_TABLE;
377: L_REG_GROUPS DBMS_SQL.NUMBER_TABLE ;
378: hier_update_groups DBMS_SQL.NUMBER_TABLE ;
379: hier_view_groups DBMS_SQL.NUMBER_TABLE ;
380:

Line 377: L_REG_GROUPS DBMS_SQL.NUMBER_TABLE ;

373: l_api_version CONSTANT NUMBER := 1.0;
374:
375: VIEW_ARRAY DBMS_SQL.NUMBER_TABLE;
376: UPDATE_ARRAY DBMS_SQL.NUMBER_TABLE;
377: L_REG_GROUPS DBMS_SQL.NUMBER_TABLE ;
378: hier_update_groups DBMS_SQL.NUMBER_TABLE ;
379: hier_view_groups DBMS_SQL.NUMBER_TABLE ;
380:
381: select_cursor NUMBER ;

Line 378: hier_update_groups DBMS_SQL.NUMBER_TABLE ;

374:
375: VIEW_ARRAY DBMS_SQL.NUMBER_TABLE;
376: UPDATE_ARRAY DBMS_SQL.NUMBER_TABLE;
377: L_REG_GROUPS DBMS_SQL.NUMBER_TABLE ;
378: hier_update_groups DBMS_SQL.NUMBER_TABLE ;
379: hier_view_groups DBMS_SQL.NUMBER_TABLE ;
380:
381: select_cursor NUMBER ;
382: l_match_rows NUMBER := 0 ;

Line 379: hier_view_groups DBMS_SQL.NUMBER_TABLE ;

375: VIEW_ARRAY DBMS_SQL.NUMBER_TABLE;
376: UPDATE_ARRAY DBMS_SQL.NUMBER_TABLE;
377: L_REG_GROUPS DBMS_SQL.NUMBER_TABLE ;
378: hier_update_groups DBMS_SQL.NUMBER_TABLE ;
379: hier_view_groups DBMS_SQL.NUMBER_TABLE ;
380:
381: select_cursor NUMBER ;
382: l_match_rows NUMBER := 0 ;
383: l_sql VARCHAR2(4000) := '' ;

Line 528: -- p_update_groups IN DBMS_SQL.NUMBER_TABLE,

524: -- p_validation_level IN NUMBER Optional
525: -- Default = FND_API.G_VALID_LEVEL_FULL
526: -- p_default_all
527: -- p_group_id
528: -- p_update_groups IN DBMS_SQL.NUMBER_TABLE,
529: -- p_view_groups IN DBMS_SQL.NUMBER_TABLE,
530: -- OUT : x_return_status OUT VARCHAR2(1)
531: -- x_msg_count OUT NUMBER
532: -- x_msg_data OUT VARCHAR2(2000)

Line 529: -- p_view_groups IN DBMS_SQL.NUMBER_TABLE,

525: -- Default = FND_API.G_VALID_LEVEL_FULL
526: -- p_default_all
527: -- p_group_id
528: -- p_update_groups IN DBMS_SQL.NUMBER_TABLE,
529: -- p_view_groups IN DBMS_SQL.NUMBER_TABLE,
530: -- OUT : x_return_status OUT VARCHAR2(1)
531: -- x_msg_count OUT NUMBER
532: -- x_msg_data OUT VARCHAR2(2000)
533: -- x_privilege OUT VARCHAR2,

Line 547: p_update_groups IN DBMS_SQL.NUMBER_TABLE,

543: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
544: p_commit IN VARCHAR2 := FND_API.G_FALSE,
545: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
546: p_group_id IN NUMBER,
547: p_update_groups IN DBMS_SQL.NUMBER_TABLE,
548: p_view_groups IN DBMS_SQL.NUMBER_TABLE,
549: x_privilege OUT NOCOPY VARCHAR2,
550: x_return_status OUT NOCOPY VARCHAR2,
551: x_msg_count OUT NOCOPY NUMBER,

Line 548: p_view_groups IN DBMS_SQL.NUMBER_TABLE,

544: p_commit IN VARCHAR2 := FND_API.G_FALSE,
545: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
546: p_group_id IN NUMBER,
547: p_update_groups IN DBMS_SQL.NUMBER_TABLE,
548: p_view_groups IN DBMS_SQL.NUMBER_TABLE,
549: x_privilege OUT NOCOPY VARCHAR2,
550: x_return_status OUT NOCOPY VARCHAR2,
551: x_msg_count OUT NOCOPY NUMBER,
552: x_msg_data OUT NOCOPY VARCHAR2