APPS.CSI_PRICING_ATTRIBS_PUB dependencies on DBMS_SQL

Line 113: l_cur_get_pri := dbms_sql.open_cursor;

109: -- Build the select statement
110: l_select_stmt := l_select_stmt || ' where '||l_where_clause;
111:
112: -- Open the cursor
113: l_cur_get_pri := dbms_sql.open_cursor;
114:
115: --Parse the select statement
116: dbms_sql.parse(l_cur_get_pri, l_select_stmt , dbms_sql.native);
117:

Line 116: dbms_sql.parse(l_cur_get_pri, l_select_stmt , dbms_sql.native);

112: -- Open the cursor
113: l_cur_get_pri := dbms_sql.open_cursor;
114:
115: --Parse the select statement
116: dbms_sql.parse(l_cur_get_pri, l_select_stmt , dbms_sql.native);
117:
118: -- Bind the variables
119: csi_pricing_attribs_pvt.Bind_pri_variable
120: (p_pricing_attribs_query_rec,

Line 127: l_rows_processed := dbms_sql.execute(l_cur_get_pri);

123: -- Define output variables
124: csi_pricing_attribs_pvt.Define_pri_Columns(l_cur_get_pri);
125:
126: -- execute the select statement
127: l_rows_processed := dbms_sql.execute(l_cur_get_pri);
128:
129:
130: LOOP
131: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_cur_get_pri) = 0;

Line 131: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_cur_get_pri) = 0;

127: l_rows_processed := dbms_sql.execute(l_cur_get_pri);
128:
129:
130: LOOP
131: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_cur_get_pri) = 0;
132: csi_pricing_attribs_pvt.Get_pri_Column_Values(l_cur_get_pri, l_pri_rec);
133: l_count := l_count + 1;
134: x_pricing_attribs_tbl(l_count) := l_pri_rec;
135: END LOOP;

Line 138: DBMS_SQL.CLOSE_CURSOR(l_cur_get_pri);

134: x_pricing_attribs_tbl(l_count) := l_pri_rec;
135: END LOOP;
136:
137: -- Close the cursor
138: DBMS_SQL.CLOSE_CURSOR(l_cur_get_pri);
139:
140: IF (p_time_stamp IS NOT NULL) AND (p_time_stamp <> FND_API.G_MISS_DATE) THEN
141: IF p_time_stamp <= sysdate THEN
142: csi_pricing_attribs_pvt.Construct_pri_From_Hist(x_pricing_attribs_tbl, p_time_stamp);

Line 194: IF DBMS_SQL.IS_OPEN(l_cur_get_pri) THEN

190: p_data => x_msg_data
191: );
192:
193: WHEN OTHERS THEN
194: IF DBMS_SQL.IS_OPEN(l_cur_get_pri) THEN
195: DBMS_SQL.CLOSE_CURSOR(l_cur_get_pri);
196: END IF;
197:
198: -- ROLLBACK TO get_pricing_attribs;

Line 195: DBMS_SQL.CLOSE_CURSOR(l_cur_get_pri);

191: );
192:
193: WHEN OTHERS THEN
194: IF DBMS_SQL.IS_OPEN(l_cur_get_pri) THEN
195: DBMS_SQL.CLOSE_CURSOR(l_cur_get_pri);
196: END IF;
197:
198: -- ROLLBACK TO get_pricing_attribs;
199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;