APPS.CN_SFP_GROUP_UTIL_PVT dependencies on DBMS_SQL

Line 97: -- p_selected_groups IN DBMS_SQL.NUMBER_TABLE,

93: -- p_commit IN VARCHAR2 Optional
94: -- Default = FND_API.G_FALSE
95: -- p_validation_level IN NUMBER Optional
96: -- Default = FND_API.G_VALID_LEVEL_FULL
97: -- p_selected_groups IN DBMS_SQL.NUMBER_TABLE,
98: -- p_effective_date
99: -- OUT : x_return_status OUT VARCHAR2(1)
100: -- x_msg_count OUT NUMBER
101: -- x_msg_data OUT VARCHAR2(2000)

Line 102: -- x_descendant_groups OUT DBMS_SQL.NUMBER_TABLE

98: -- p_effective_date
99: -- OUT : x_return_status OUT VARCHAR2(1)
100: -- x_msg_count OUT NUMBER
101: -- x_msg_data OUT VARCHAR2(2000)
102: -- x_descendant_groups OUT DBMS_SQL.NUMBER_TABLE
103: -- Version : Current version 1.0
104: --
105: --
106: --

Line 260: -- p_selected_groups IN DBMS_SQL.NUMBER_TABLE,

256: -- p_commit IN VARCHAR2 Optional
257: -- Default = FND_API.G_FALSE
258: -- p_validation_level IN NUMBER Optional
259: -- Default = FND_API.G_VALID_LEVEL_FULL
260: -- p_selected_groups IN DBMS_SQL.NUMBER_TABLE,
261: -- p_status IN VARCHAR2
262: -- p_effective_date IN DATE
263: -- OUT : x_return_status OUT VARCHAR2(1)
264: -- x_msg_count OUT NUMBER

Line 484: l_update_groups SYS.DBMS_SQL.NUMBER_TABLE;

480: l_updview_organization grporg_tbl_type;
481: l_upd_organization grporg_tbl_type;
482: l_view_organization grporg_tbl_type;
483: l_noview_organization grporg_tbl_type;
484: l_update_groups SYS.DBMS_SQL.NUMBER_TABLE;
485: l_view_groups SYS.DBMS_SQL.NUMBER_TABLE;
486: l_return_status VARCHAR2(10);
487: l_msg_count NUMBER;
488: l_msg_data VARCHAR2(300);

Line 485: l_view_groups SYS.DBMS_SQL.NUMBER_TABLE;

481: l_upd_organization grporg_tbl_type;
482: l_view_organization grporg_tbl_type;
483: l_noview_organization grporg_tbl_type;
484: l_update_groups SYS.DBMS_SQL.NUMBER_TABLE;
485: l_view_groups SYS.DBMS_SQL.NUMBER_TABLE;
486: l_return_status VARCHAR2(10);
487: l_msg_count NUMBER;
488: l_msg_data VARCHAR2(300);
489: l_privilege VARCHAR2(10);