APPS.CSI_ORGANIZATION_UNIT_PUB dependencies on DBMS_SQL

Line 116: l_cur_get_ou := dbms_sql.open_cursor;

112: l_select_stmt := l_select_stmt || ' where '||l_where_clause;
113:
114:
115: -- Open the cursor
116: l_cur_get_ou := dbms_sql.open_cursor;
117:
118:
119: --Parse the select statement
120: dbms_sql.parse(l_cur_get_ou, l_select_stmt , dbms_sql.native);

Line 120: dbms_sql.parse(l_cur_get_ou, l_select_stmt , dbms_sql.native);

116: l_cur_get_ou := dbms_sql.open_cursor;
117:
118:
119: --Parse the select statement
120: dbms_sql.parse(l_cur_get_ou, l_select_stmt , dbms_sql.native);
121:
122:
123: -- Bind the variables
124: csi_organization_unit_pvt.Bind_ou_variable

Line 133: l_rows_processed := dbms_sql.execute(l_cur_get_ou);

129: -- Define output variables
130: csi_organization_unit_pvt.Define_ou_Columns(l_cur_get_ou);
131:
132: -- execute the select statement
133: l_rows_processed := dbms_sql.execute(l_cur_get_ou);
134:
135:
136: LOOP
137: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_cur_get_ou) = 0;

Line 137: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_cur_get_ou) = 0;

133: l_rows_processed := dbms_sql.execute(l_cur_get_ou);
134:
135:
136: LOOP
137: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_cur_get_ou) = 0;
138: csi_organization_unit_pvt.Get_ou_Column_Values(l_cur_get_ou, l_ou_rec);
139: l_count := l_count + 1;
140: x_org_unit_tbl(l_count) := l_ou_rec;
141: END LOOP;

Line 144: DBMS_SQL.CLOSE_CURSOR(l_cur_get_ou);

140: x_org_unit_tbl(l_count) := l_ou_rec;
141: END LOOP;
142:
143: -- Close the cursor
144: DBMS_SQL.CLOSE_CURSOR(l_cur_get_ou);
145:
146: IF (p_time_stamp IS NOT NULL) AND (p_time_stamp <> FND_API.G_MISS_DATE) THEN
147: IF p_time_stamp <= sysdate THEN
148: csi_organization_unit_pvt.Construct_ou_From_Hist(x_org_unit_tbl, p_time_stamp);

Line 209: IF DBMS_SQL.IS_OPEN(l_cur_get_ou) THEN

205: p_data => x_msg_data
206: );
207:
208: WHEN OTHERS THEN
209: IF DBMS_SQL.IS_OPEN(l_cur_get_ou) THEN
210: DBMS_SQL.CLOSE_CURSOR(l_cur_get_ou);
211: END IF;
212: -- ROLLBACK TO get_organization_unit;
213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 210: DBMS_SQL.CLOSE_CURSOR(l_cur_get_ou);

206: );
207:
208: WHEN OTHERS THEN
209: IF DBMS_SQL.IS_OPEN(l_cur_get_ou) THEN
210: DBMS_SQL.CLOSE_CURSOR(l_cur_get_ou);
211: END IF;
212: -- ROLLBACK TO get_organization_unit;
213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
214: