APPS.OE_COMMITMENT_PVT dependencies on DBMS_SQL

Line 180: v_CursorID := DBMS_SQL.OPEN_CURSOR;

176: oe_debug_pub.add( 'ENTERING GET_ALLOCATE_TAX_FREIGHT' , 1 ) ;
177: END IF;
178:
179: -- implementing dynamic SQL to avoid compilation error if AR Patch D is not installed.
180: v_CursorID := DBMS_SQL.OPEN_CURSOR;
181:
182: v_SelectStmt :=
183: 'SELECT allocate_tax_freight
184: INTO :allocate_fax_freight

Line 190: DBMS_SQL.PARSE(v_CursorID, v_SelectStmt, DBMS_SQL.V7);

186: ,ra_customer_trx_all rcta
187: WHERE rctt.cust_trx_type_id = rcta.cust_trx_type_id
188: AND rcta.customer_trx_id = :commitment_id';
189:
190: DBMS_SQL.PARSE(v_CursorID, v_SelectStmt, DBMS_SQL.V7);
191: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':commitment_id', p_line_rec.commitment_id);
192:
193: DBMS_SQL.DEFINE_COLUMN(v_CursorID, 1, v_allocate_tax_freight, 20);
194:

Line 191: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':commitment_id', p_line_rec.commitment_id);

187: WHERE rctt.cust_trx_type_id = rcta.cust_trx_type_id
188: AND rcta.customer_trx_id = :commitment_id';
189:
190: DBMS_SQL.PARSE(v_CursorID, v_SelectStmt, DBMS_SQL.V7);
191: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':commitment_id', p_line_rec.commitment_id);
192:
193: DBMS_SQL.DEFINE_COLUMN(v_CursorID, 1, v_allocate_tax_freight, 20);
194:
195: v_Dummy := DBMS_SQL.EXECUTE(v_CursorID);

Line 193: DBMS_SQL.DEFINE_COLUMN(v_CursorID, 1, v_allocate_tax_freight, 20);

189:
190: DBMS_SQL.PARSE(v_CursorID, v_SelectStmt, DBMS_SQL.V7);
191: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':commitment_id', p_line_rec.commitment_id);
192:
193: DBMS_SQL.DEFINE_COLUMN(v_CursorID, 1, v_allocate_tax_freight, 20);
194:
195: v_Dummy := DBMS_SQL.EXECUTE(v_CursorID);
196:
197: LOOP

Line 195: v_Dummy := DBMS_SQL.EXECUTE(v_CursorID);

191: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':commitment_id', p_line_rec.commitment_id);
192:
193: DBMS_SQL.DEFINE_COLUMN(v_CursorID, 1, v_allocate_tax_freight, 20);
194:
195: v_Dummy := DBMS_SQL.EXECUTE(v_CursorID);
196:
197: LOOP
198: IF DBMS_SQL.FETCH_ROWS(v_CursorID) = 0 THEN
199: EXIT;

Line 198: IF DBMS_SQL.FETCH_ROWS(v_CursorID) = 0 THEN

194:
195: v_Dummy := DBMS_SQL.EXECUTE(v_CursorID);
196:
197: LOOP
198: IF DBMS_SQL.FETCH_ROWS(v_CursorID) = 0 THEN
199: EXIT;
200: END IF;
201:
202: DBMS_SQL.COLUMN_VALUE(v_CursorID, 1, v_allocate_tax_freight);

Line 202: DBMS_SQL.COLUMN_VALUE(v_CursorID, 1, v_allocate_tax_freight);

198: IF DBMS_SQL.FETCH_ROWS(v_CursorID) = 0 THEN
199: EXIT;
200: END IF;
201:
202: DBMS_SQL.COLUMN_VALUE(v_CursorID, 1, v_allocate_tax_freight);
203:
204: END LOOP;
205:
206: DBMS_SQL.CLOSE_CURSOR(v_CursorID);

Line 206: DBMS_SQL.CLOSE_CURSOR(v_CursorID);

202: DBMS_SQL.COLUMN_VALUE(v_CursorID, 1, v_allocate_tax_freight);
203:
204: END LOOP;
205:
206: DBMS_SQL.CLOSE_CURSOR(v_CursorID);
207:
208: IF v_allocate_tax_freight IS NULL THEN
209: v_allocate_tax_freight := 'N';
210: END IF;

Line 232: DBMS_SQL.CLOSE_CURSOR(v_CursorID);

228:
229: EXCEPTION
230: WHEN OTHERS THEN
231: l_allocate_tax_freight := 'N';
232: DBMS_SQL.CLOSE_CURSOR(v_CursorID);
233: END Get_Allocate_Tax_Freight;
234:
235: -- get the total amount of an order line according to allocate_tax_freight flag.
236: FUNCTION Get_Line_Total