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.OZF_CLAIM_ACCRUAL_PVT dependencies on DBMS_SQL

Line 3578: l_funds_util_csr := DBMS_SQL.open_cursor;

3574: RAISE FND_API.g_exc_unexpected_error;
3575: END IF;
3576:
3577: -- use FND_DSQL package for dynamic sql and bind variables
3578: l_funds_util_csr := DBMS_SQL.open_cursor;
3579: FND_DSQL.set_cursor(l_funds_util_csr);
3580: DBMS_SQL.parse(l_funds_util_csr, l_funds_util_sql, DBMS_SQL.native);
3581: DBMS_SQL.define_column(l_funds_util_csr, 1, l_lu_line_util_id);
3582: DBMS_SQL.define_column(l_funds_util_csr, 2, l_lu_utilization_id);

Line 3580: DBMS_SQL.parse(l_funds_util_csr, l_funds_util_sql, DBMS_SQL.native);

3576:
3577: -- use FND_DSQL package for dynamic sql and bind variables
3578: l_funds_util_csr := DBMS_SQL.open_cursor;
3579: FND_DSQL.set_cursor(l_funds_util_csr);
3580: DBMS_SQL.parse(l_funds_util_csr, l_funds_util_sql, DBMS_SQL.native);
3581: DBMS_SQL.define_column(l_funds_util_csr, 1, l_lu_line_util_id);
3582: DBMS_SQL.define_column(l_funds_util_csr, 2, l_lu_utilization_id);
3583: DBMS_SQL.define_column(l_funds_util_csr, 3, l_lu_amt);
3584: DBMS_SQL.define_column(l_funds_util_csr, 4, l_lu_scan_unit);

Line 3581: DBMS_SQL.define_column(l_funds_util_csr, 1, l_lu_line_util_id);

3577: -- use FND_DSQL package for dynamic sql and bind variables
3578: l_funds_util_csr := DBMS_SQL.open_cursor;
3579: FND_DSQL.set_cursor(l_funds_util_csr);
3580: DBMS_SQL.parse(l_funds_util_csr, l_funds_util_sql, DBMS_SQL.native);
3581: DBMS_SQL.define_column(l_funds_util_csr, 1, l_lu_line_util_id);
3582: DBMS_SQL.define_column(l_funds_util_csr, 2, l_lu_utilization_id);
3583: DBMS_SQL.define_column(l_funds_util_csr, 3, l_lu_amt);
3584: DBMS_SQL.define_column(l_funds_util_csr, 4, l_lu_scan_unit);
3585: DBMS_SQL.define_column(l_funds_util_csr, 5, l_lu_currency_code, 15);

Line 3582: DBMS_SQL.define_column(l_funds_util_csr, 2, l_lu_utilization_id);

3578: l_funds_util_csr := DBMS_SQL.open_cursor;
3579: FND_DSQL.set_cursor(l_funds_util_csr);
3580: DBMS_SQL.parse(l_funds_util_csr, l_funds_util_sql, DBMS_SQL.native);
3581: DBMS_SQL.define_column(l_funds_util_csr, 1, l_lu_line_util_id);
3582: DBMS_SQL.define_column(l_funds_util_csr, 2, l_lu_utilization_id);
3583: DBMS_SQL.define_column(l_funds_util_csr, 3, l_lu_amt);
3584: DBMS_SQL.define_column(l_funds_util_csr, 4, l_lu_scan_unit);
3585: DBMS_SQL.define_column(l_funds_util_csr, 5, l_lu_currency_code, 15);
3586: -- DBMS_SQL.define_column(l_funds_util_csr, 5, l_utiz_amount);

Line 3583: DBMS_SQL.define_column(l_funds_util_csr, 3, l_lu_amt);

3579: FND_DSQL.set_cursor(l_funds_util_csr);
3580: DBMS_SQL.parse(l_funds_util_csr, l_funds_util_sql, DBMS_SQL.native);
3581: DBMS_SQL.define_column(l_funds_util_csr, 1, l_lu_line_util_id);
3582: DBMS_SQL.define_column(l_funds_util_csr, 2, l_lu_utilization_id);
3583: DBMS_SQL.define_column(l_funds_util_csr, 3, l_lu_amt);
3584: DBMS_SQL.define_column(l_funds_util_csr, 4, l_lu_scan_unit);
3585: DBMS_SQL.define_column(l_funds_util_csr, 5, l_lu_currency_code, 15);
3586: -- DBMS_SQL.define_column(l_funds_util_csr, 5, l_utiz_amount);
3587: FND_DSQL.do_binds;

Line 3584: DBMS_SQL.define_column(l_funds_util_csr, 4, l_lu_scan_unit);

3580: DBMS_SQL.parse(l_funds_util_csr, l_funds_util_sql, DBMS_SQL.native);
3581: DBMS_SQL.define_column(l_funds_util_csr, 1, l_lu_line_util_id);
3582: DBMS_SQL.define_column(l_funds_util_csr, 2, l_lu_utilization_id);
3583: DBMS_SQL.define_column(l_funds_util_csr, 3, l_lu_amt);
3584: DBMS_SQL.define_column(l_funds_util_csr, 4, l_lu_scan_unit);
3585: DBMS_SQL.define_column(l_funds_util_csr, 5, l_lu_currency_code, 15);
3586: -- DBMS_SQL.define_column(l_funds_util_csr, 5, l_utiz_amount);
3587: FND_DSQL.do_binds;
3588:

Line 3585: DBMS_SQL.define_column(l_funds_util_csr, 5, l_lu_currency_code, 15);

3581: DBMS_SQL.define_column(l_funds_util_csr, 1, l_lu_line_util_id);
3582: DBMS_SQL.define_column(l_funds_util_csr, 2, l_lu_utilization_id);
3583: DBMS_SQL.define_column(l_funds_util_csr, 3, l_lu_amt);
3584: DBMS_SQL.define_column(l_funds_util_csr, 4, l_lu_scan_unit);
3585: DBMS_SQL.define_column(l_funds_util_csr, 5, l_lu_currency_code, 15);
3586: -- DBMS_SQL.define_column(l_funds_util_csr, 5, l_utiz_amount);
3587: FND_DSQL.do_binds;
3588:
3589: l_ignore := DBMS_SQL.execute(l_funds_util_csr);

Line 3586: -- DBMS_SQL.define_column(l_funds_util_csr, 5, l_utiz_amount);

3582: DBMS_SQL.define_column(l_funds_util_csr, 2, l_lu_utilization_id);
3583: DBMS_SQL.define_column(l_funds_util_csr, 3, l_lu_amt);
3584: DBMS_SQL.define_column(l_funds_util_csr, 4, l_lu_scan_unit);
3585: DBMS_SQL.define_column(l_funds_util_csr, 5, l_lu_currency_code, 15);
3586: -- DBMS_SQL.define_column(l_funds_util_csr, 5, l_utiz_amount);
3587: FND_DSQL.do_binds;
3588:
3589: l_ignore := DBMS_SQL.execute(l_funds_util_csr);
3590: LOOP

Line 3589: l_ignore := DBMS_SQL.execute(l_funds_util_csr);

3585: DBMS_SQL.define_column(l_funds_util_csr, 5, l_lu_currency_code, 15);
3586: -- DBMS_SQL.define_column(l_funds_util_csr, 5, l_utiz_amount);
3587: FND_DSQL.do_binds;
3588:
3589: l_ignore := DBMS_SQL.execute(l_funds_util_csr);
3590: LOOP
3591: IF DBMS_SQL.fetch_rows(l_funds_util_csr) > 0 THEN
3592: DBMS_SQL.column_value(l_funds_util_csr, 1, l_lu_line_util_id);
3593: DBMS_SQL.column_value(l_funds_util_csr, 2, l_lu_utilization_id);

Line 3591: IF DBMS_SQL.fetch_rows(l_funds_util_csr) > 0 THEN

3587: FND_DSQL.do_binds;
3588:
3589: l_ignore := DBMS_SQL.execute(l_funds_util_csr);
3590: LOOP
3591: IF DBMS_SQL.fetch_rows(l_funds_util_csr) > 0 THEN
3592: DBMS_SQL.column_value(l_funds_util_csr, 1, l_lu_line_util_id);
3593: DBMS_SQL.column_value(l_funds_util_csr, 2, l_lu_utilization_id);
3594: DBMS_SQL.column_value(l_funds_util_csr, 3, l_lu_amt);
3595: DBMS_SQL.column_value(l_funds_util_csr, 4, l_lu_scan_unit);

Line 3592: DBMS_SQL.column_value(l_funds_util_csr, 1, l_lu_line_util_id);

3588:
3589: l_ignore := DBMS_SQL.execute(l_funds_util_csr);
3590: LOOP
3591: IF DBMS_SQL.fetch_rows(l_funds_util_csr) > 0 THEN
3592: DBMS_SQL.column_value(l_funds_util_csr, 1, l_lu_line_util_id);
3593: DBMS_SQL.column_value(l_funds_util_csr, 2, l_lu_utilization_id);
3594: DBMS_SQL.column_value(l_funds_util_csr, 3, l_lu_amt);
3595: DBMS_SQL.column_value(l_funds_util_csr, 4, l_lu_scan_unit);
3596: DBMS_SQL.column_value(l_funds_util_csr, 5, l_lu_currency_code);

Line 3593: DBMS_SQL.column_value(l_funds_util_csr, 2, l_lu_utilization_id);

3589: l_ignore := DBMS_SQL.execute(l_funds_util_csr);
3590: LOOP
3591: IF DBMS_SQL.fetch_rows(l_funds_util_csr) > 0 THEN
3592: DBMS_SQL.column_value(l_funds_util_csr, 1, l_lu_line_util_id);
3593: DBMS_SQL.column_value(l_funds_util_csr, 2, l_lu_utilization_id);
3594: DBMS_SQL.column_value(l_funds_util_csr, 3, l_lu_amt);
3595: DBMS_SQL.column_value(l_funds_util_csr, 4, l_lu_scan_unit);
3596: DBMS_SQL.column_value(l_funds_util_csr, 5, l_lu_currency_code);
3597: -- DBMS_SQL.define_column(l_funds_util_csr, 5, l_utiz_amount);

Line 3594: DBMS_SQL.column_value(l_funds_util_csr, 3, l_lu_amt);

3590: LOOP
3591: IF DBMS_SQL.fetch_rows(l_funds_util_csr) > 0 THEN
3592: DBMS_SQL.column_value(l_funds_util_csr, 1, l_lu_line_util_id);
3593: DBMS_SQL.column_value(l_funds_util_csr, 2, l_lu_utilization_id);
3594: DBMS_SQL.column_value(l_funds_util_csr, 3, l_lu_amt);
3595: DBMS_SQL.column_value(l_funds_util_csr, 4, l_lu_scan_unit);
3596: DBMS_SQL.column_value(l_funds_util_csr, 5, l_lu_currency_code);
3597: -- DBMS_SQL.define_column(l_funds_util_csr, 5, l_utiz_amount);
3598:

Line 3595: DBMS_SQL.column_value(l_funds_util_csr, 4, l_lu_scan_unit);

3591: IF DBMS_SQL.fetch_rows(l_funds_util_csr) > 0 THEN
3592: DBMS_SQL.column_value(l_funds_util_csr, 1, l_lu_line_util_id);
3593: DBMS_SQL.column_value(l_funds_util_csr, 2, l_lu_utilization_id);
3594: DBMS_SQL.column_value(l_funds_util_csr, 3, l_lu_amt);
3595: DBMS_SQL.column_value(l_funds_util_csr, 4, l_lu_scan_unit);
3596: DBMS_SQL.column_value(l_funds_util_csr, 5, l_lu_currency_code);
3597: -- DBMS_SQL.define_column(l_funds_util_csr, 5, l_utiz_amount);
3598:
3599: OPEN csr_util_obj_ver(l_lu_line_util_id);

Line 3596: DBMS_SQL.column_value(l_funds_util_csr, 5, l_lu_currency_code);

3592: DBMS_SQL.column_value(l_funds_util_csr, 1, l_lu_line_util_id);
3593: DBMS_SQL.column_value(l_funds_util_csr, 2, l_lu_utilization_id);
3594: DBMS_SQL.column_value(l_funds_util_csr, 3, l_lu_amt);
3595: DBMS_SQL.column_value(l_funds_util_csr, 4, l_lu_scan_unit);
3596: DBMS_SQL.column_value(l_funds_util_csr, 5, l_lu_currency_code);
3597: -- DBMS_SQL.define_column(l_funds_util_csr, 5, l_utiz_amount);
3598:
3599: OPEN csr_util_obj_ver(l_lu_line_util_id);
3600: FETCH csr_util_obj_ver INTO l_object_version_number;

Line 3597: -- DBMS_SQL.define_column(l_funds_util_csr, 5, l_utiz_amount);

3593: DBMS_SQL.column_value(l_funds_util_csr, 2, l_lu_utilization_id);
3594: DBMS_SQL.column_value(l_funds_util_csr, 3, l_lu_amt);
3595: DBMS_SQL.column_value(l_funds_util_csr, 4, l_lu_scan_unit);
3596: DBMS_SQL.column_value(l_funds_util_csr, 5, l_lu_currency_code);
3597: -- DBMS_SQL.define_column(l_funds_util_csr, 5, l_utiz_amount);
3598:
3599: OPEN csr_util_obj_ver(l_lu_line_util_id);
3600: FETCH csr_util_obj_ver INTO l_object_version_number;
3601: CLOSE csr_util_obj_ver;

Line 3652: DBMS_SQL.close_cursor(l_funds_util_csr);

3648:
3649: EXIT;
3650: END IF;
3651: END LOOP;
3652: DBMS_SQL.close_cursor(l_funds_util_csr);
3653:
3654: -- Check for commit
3655: IF FND_API.to_boolean(p_commit) THEN
3656: COMMIT;

Line 4474: l_emp_csr := DBMS_SQL.open_cursor;

4470: OZF_Utility_PVT.debug_message(SUBSTR(l_temp_sql, 509, 254));
4471: OZF_Utility_PVT.debug_message('---------------------------------------');
4472: END IF;
4473:
4474: l_emp_csr := DBMS_SQL.open_cursor;
4475: FND_DSQL.set_cursor(l_emp_csr);
4476: DBMS_SQL.parse(l_emp_csr, FND_DSQL.get_text(FALSE), DBMS_SQL.native);
4477: DBMS_SQL.define_column(l_emp_csr, 1, l_common_quantity);
4478: DBMS_SQL.define_column(l_emp_csr, 2, l_common_amount);

Line 4476: DBMS_SQL.parse(l_emp_csr, FND_DSQL.get_text(FALSE), DBMS_SQL.native);

4472: END IF;
4473:
4474: l_emp_csr := DBMS_SQL.open_cursor;
4475: FND_DSQL.set_cursor(l_emp_csr);
4476: DBMS_SQL.parse(l_emp_csr, FND_DSQL.get_text(FALSE), DBMS_SQL.native);
4477: DBMS_SQL.define_column(l_emp_csr, 1, l_common_quantity);
4478: DBMS_SQL.define_column(l_emp_csr, 2, l_common_amount);
4479: DBMS_SQL.define_column(l_emp_csr, 3, l_common_uom_code, 3);
4480: DBMS_SQL.define_column(l_emp_csr, 4, l_common_curr_code, 15);

Line 4477: DBMS_SQL.define_column(l_emp_csr, 1, l_common_quantity);

4473:
4474: l_emp_csr := DBMS_SQL.open_cursor;
4475: FND_DSQL.set_cursor(l_emp_csr);
4476: DBMS_SQL.parse(l_emp_csr, FND_DSQL.get_text(FALSE), DBMS_SQL.native);
4477: DBMS_SQL.define_column(l_emp_csr, 1, l_common_quantity);
4478: DBMS_SQL.define_column(l_emp_csr, 2, l_common_amount);
4479: DBMS_SQL.define_column(l_emp_csr, 3, l_common_uom_code, 3);
4480: DBMS_SQL.define_column(l_emp_csr, 4, l_common_curr_code, 15);
4481: FND_DSQL.do_binds;

Line 4478: DBMS_SQL.define_column(l_emp_csr, 2, l_common_amount);

4474: l_emp_csr := DBMS_SQL.open_cursor;
4475: FND_DSQL.set_cursor(l_emp_csr);
4476: DBMS_SQL.parse(l_emp_csr, FND_DSQL.get_text(FALSE), DBMS_SQL.native);
4477: DBMS_SQL.define_column(l_emp_csr, 1, l_common_quantity);
4478: DBMS_SQL.define_column(l_emp_csr, 2, l_common_amount);
4479: DBMS_SQL.define_column(l_emp_csr, 3, l_common_uom_code, 3);
4480: DBMS_SQL.define_column(l_emp_csr, 4, l_common_curr_code, 15);
4481: FND_DSQL.do_binds;
4482:

Line 4479: DBMS_SQL.define_column(l_emp_csr, 3, l_common_uom_code, 3);

4475: FND_DSQL.set_cursor(l_emp_csr);
4476: DBMS_SQL.parse(l_emp_csr, FND_DSQL.get_text(FALSE), DBMS_SQL.native);
4477: DBMS_SQL.define_column(l_emp_csr, 1, l_common_quantity);
4478: DBMS_SQL.define_column(l_emp_csr, 2, l_common_amount);
4479: DBMS_SQL.define_column(l_emp_csr, 3, l_common_uom_code, 3);
4480: DBMS_SQL.define_column(l_emp_csr, 4, l_common_curr_code, 15);
4481: FND_DSQL.do_binds;
4482:
4483: l_ignore := DBMS_SQL.execute(l_emp_csr);

Line 4480: DBMS_SQL.define_column(l_emp_csr, 4, l_common_curr_code, 15);

4476: DBMS_SQL.parse(l_emp_csr, FND_DSQL.get_text(FALSE), DBMS_SQL.native);
4477: DBMS_SQL.define_column(l_emp_csr, 1, l_common_quantity);
4478: DBMS_SQL.define_column(l_emp_csr, 2, l_common_amount);
4479: DBMS_SQL.define_column(l_emp_csr, 3, l_common_uom_code, 3);
4480: DBMS_SQL.define_column(l_emp_csr, 4, l_common_curr_code, 15);
4481: FND_DSQL.do_binds;
4482:
4483: l_ignore := DBMS_SQL.execute(l_emp_csr);
4484: IF DBMS_SQL.fetch_rows(l_emp_csr) > 0 THEN

Line 4483: l_ignore := DBMS_SQL.execute(l_emp_csr);

4479: DBMS_SQL.define_column(l_emp_csr, 3, l_common_uom_code, 3);
4480: DBMS_SQL.define_column(l_emp_csr, 4, l_common_curr_code, 15);
4481: FND_DSQL.do_binds;
4482:
4483: l_ignore := DBMS_SQL.execute(l_emp_csr);
4484: IF DBMS_SQL.fetch_rows(l_emp_csr) > 0 THEN
4485: DBMS_SQL.column_value(l_emp_csr, 1, l_common_quantity);
4486: DBMS_SQL.column_value(l_emp_csr, 2, l_common_amount);
4487: DBMS_SQL.column_value(l_emp_csr, 3, l_common_uom_code);

Line 4484: IF DBMS_SQL.fetch_rows(l_emp_csr) > 0 THEN

4480: DBMS_SQL.define_column(l_emp_csr, 4, l_common_curr_code, 15);
4481: FND_DSQL.do_binds;
4482:
4483: l_ignore := DBMS_SQL.execute(l_emp_csr);
4484: IF DBMS_SQL.fetch_rows(l_emp_csr) > 0 THEN
4485: DBMS_SQL.column_value(l_emp_csr, 1, l_common_quantity);
4486: DBMS_SQL.column_value(l_emp_csr, 2, l_common_amount);
4487: DBMS_SQL.column_value(l_emp_csr, 3, l_common_uom_code);
4488: DBMS_SQL.column_value(l_emp_csr, 4, l_common_curr_code);

Line 4485: DBMS_SQL.column_value(l_emp_csr, 1, l_common_quantity);

4481: FND_DSQL.do_binds;
4482:
4483: l_ignore := DBMS_SQL.execute(l_emp_csr);
4484: IF DBMS_SQL.fetch_rows(l_emp_csr) > 0 THEN
4485: DBMS_SQL.column_value(l_emp_csr, 1, l_common_quantity);
4486: DBMS_SQL.column_value(l_emp_csr, 2, l_common_amount);
4487: DBMS_SQL.column_value(l_emp_csr, 3, l_common_uom_code);
4488: DBMS_SQL.column_value(l_emp_csr, 4, l_common_curr_code);
4489:

Line 4486: DBMS_SQL.column_value(l_emp_csr, 2, l_common_amount);

4482:
4483: l_ignore := DBMS_SQL.execute(l_emp_csr);
4484: IF DBMS_SQL.fetch_rows(l_emp_csr) > 0 THEN
4485: DBMS_SQL.column_value(l_emp_csr, 1, l_common_quantity);
4486: DBMS_SQL.column_value(l_emp_csr, 2, l_common_amount);
4487: DBMS_SQL.column_value(l_emp_csr, 3, l_common_uom_code);
4488: DBMS_SQL.column_value(l_emp_csr, 4, l_common_curr_code);
4489:
4490: IF l_requirement_type = 'VOLUME' THEN

Line 4487: DBMS_SQL.column_value(l_emp_csr, 3, l_common_uom_code);

4483: l_ignore := DBMS_SQL.execute(l_emp_csr);
4484: IF DBMS_SQL.fetch_rows(l_emp_csr) > 0 THEN
4485: DBMS_SQL.column_value(l_emp_csr, 1, l_common_quantity);
4486: DBMS_SQL.column_value(l_emp_csr, 2, l_common_amount);
4487: DBMS_SQL.column_value(l_emp_csr, 3, l_common_uom_code);
4488: DBMS_SQL.column_value(l_emp_csr, 4, l_common_curr_code);
4489:
4490: IF l_requirement_type = 'VOLUME' THEN
4491: IF l_uom_code = l_common_uom_code THEN

Line 4488: DBMS_SQL.column_value(l_emp_csr, 4, l_common_curr_code);

4484: IF DBMS_SQL.fetch_rows(l_emp_csr) > 0 THEN
4485: DBMS_SQL.column_value(l_emp_csr, 1, l_common_quantity);
4486: DBMS_SQL.column_value(l_emp_csr, 2, l_common_amount);
4487: DBMS_SQL.column_value(l_emp_csr, 3, l_common_uom_code);
4488: DBMS_SQL.column_value(l_emp_csr, 4, l_common_curr_code);
4489:
4490: IF l_requirement_type = 'VOLUME' THEN
4491: IF l_uom_code = l_common_uom_code THEN
4492: IF l_common_quantity < l_requirement_value THEN

Line 4560: DBMS_SQL.close_cursor(l_emp_csr);

4556: OZF_Utility_PVT.debug_message('No sales transactions found');
4557: END IF;
4558: l_performance_flag := FND_API.g_false;
4559: END IF;
4560: DBMS_SQL.close_cursor(l_emp_csr);
4561:
4562: ELSE
4563: /********** Check resale data ***********/
4564: FND_DSQL.init;

Line 4595: l_emp_csr := DBMS_SQL.open_cursor;

4591: OZF_Utility_PVT.debug_message(SUBSTR(l_temp_sql, 509, 254));
4592: OZF_Utility_PVT.debug_message('---------------------------------------');
4593: END IF;
4594:
4595: l_emp_csr := DBMS_SQL.open_cursor;
4596: FND_DSQL.set_cursor(l_emp_csr);
4597: DBMS_SQL.parse(l_emp_csr, FND_DSQL.get_text(FALSE), DBMS_SQL.native);
4598: DBMS_SQL.define_column(l_emp_csr, 1, l_common_quantity);
4599: DBMS_SQL.define_column(l_emp_csr, 2, l_common_amount);

Line 4597: DBMS_SQL.parse(l_emp_csr, FND_DSQL.get_text(FALSE), DBMS_SQL.native);

4593: END IF;
4594:
4595: l_emp_csr := DBMS_SQL.open_cursor;
4596: FND_DSQL.set_cursor(l_emp_csr);
4597: DBMS_SQL.parse(l_emp_csr, FND_DSQL.get_text(FALSE), DBMS_SQL.native);
4598: DBMS_SQL.define_column(l_emp_csr, 1, l_common_quantity);
4599: DBMS_SQL.define_column(l_emp_csr, 2, l_common_amount);
4600: DBMS_SQL.define_column(l_emp_csr, 3, l_common_uom_code, 3);
4601: FND_DSQL.do_binds;

Line 4598: DBMS_SQL.define_column(l_emp_csr, 1, l_common_quantity);

4594:
4595: l_emp_csr := DBMS_SQL.open_cursor;
4596: FND_DSQL.set_cursor(l_emp_csr);
4597: DBMS_SQL.parse(l_emp_csr, FND_DSQL.get_text(FALSE), DBMS_SQL.native);
4598: DBMS_SQL.define_column(l_emp_csr, 1, l_common_quantity);
4599: DBMS_SQL.define_column(l_emp_csr, 2, l_common_amount);
4600: DBMS_SQL.define_column(l_emp_csr, 3, l_common_uom_code, 3);
4601: FND_DSQL.do_binds;
4602:

Line 4599: DBMS_SQL.define_column(l_emp_csr, 2, l_common_amount);

4595: l_emp_csr := DBMS_SQL.open_cursor;
4596: FND_DSQL.set_cursor(l_emp_csr);
4597: DBMS_SQL.parse(l_emp_csr, FND_DSQL.get_text(FALSE), DBMS_SQL.native);
4598: DBMS_SQL.define_column(l_emp_csr, 1, l_common_quantity);
4599: DBMS_SQL.define_column(l_emp_csr, 2, l_common_amount);
4600: DBMS_SQL.define_column(l_emp_csr, 3, l_common_uom_code, 3);
4601: FND_DSQL.do_binds;
4602:
4603: l_ignore := DBMS_SQL.execute(l_emp_csr);

Line 4600: DBMS_SQL.define_column(l_emp_csr, 3, l_common_uom_code, 3);

4596: FND_DSQL.set_cursor(l_emp_csr);
4597: DBMS_SQL.parse(l_emp_csr, FND_DSQL.get_text(FALSE), DBMS_SQL.native);
4598: DBMS_SQL.define_column(l_emp_csr, 1, l_common_quantity);
4599: DBMS_SQL.define_column(l_emp_csr, 2, l_common_amount);
4600: DBMS_SQL.define_column(l_emp_csr, 3, l_common_uom_code, 3);
4601: FND_DSQL.do_binds;
4602:
4603: l_ignore := DBMS_SQL.execute(l_emp_csr);
4604: IF DBMS_SQL.fetch_rows(l_emp_csr) > 0 THEN

Line 4603: l_ignore := DBMS_SQL.execute(l_emp_csr);

4599: DBMS_SQL.define_column(l_emp_csr, 2, l_common_amount);
4600: DBMS_SQL.define_column(l_emp_csr, 3, l_common_uom_code, 3);
4601: FND_DSQL.do_binds;
4602:
4603: l_ignore := DBMS_SQL.execute(l_emp_csr);
4604: IF DBMS_SQL.fetch_rows(l_emp_csr) > 0 THEN
4605: DBMS_SQL.column_value(l_emp_csr, 1, l_common_quantity);
4606: DBMS_SQL.column_value(l_emp_csr, 2, l_common_amount);
4607: DBMS_SQL.column_value(l_emp_csr, 3, l_common_uom_code);

Line 4604: IF DBMS_SQL.fetch_rows(l_emp_csr) > 0 THEN

4600: DBMS_SQL.define_column(l_emp_csr, 3, l_common_uom_code, 3);
4601: FND_DSQL.do_binds;
4602:
4603: l_ignore := DBMS_SQL.execute(l_emp_csr);
4604: IF DBMS_SQL.fetch_rows(l_emp_csr) > 0 THEN
4605: DBMS_SQL.column_value(l_emp_csr, 1, l_common_quantity);
4606: DBMS_SQL.column_value(l_emp_csr, 2, l_common_amount);
4607: DBMS_SQL.column_value(l_emp_csr, 3, l_common_uom_code);
4608:

Line 4605: DBMS_SQL.column_value(l_emp_csr, 1, l_common_quantity);

4601: FND_DSQL.do_binds;
4602:
4603: l_ignore := DBMS_SQL.execute(l_emp_csr);
4604: IF DBMS_SQL.fetch_rows(l_emp_csr) > 0 THEN
4605: DBMS_SQL.column_value(l_emp_csr, 1, l_common_quantity);
4606: DBMS_SQL.column_value(l_emp_csr, 2, l_common_amount);
4607: DBMS_SQL.column_value(l_emp_csr, 3, l_common_uom_code);
4608:
4609: IF l_requirement_type = 'VOLUME' THEN

Line 4606: DBMS_SQL.column_value(l_emp_csr, 2, l_common_amount);

4602:
4603: l_ignore := DBMS_SQL.execute(l_emp_csr);
4604: IF DBMS_SQL.fetch_rows(l_emp_csr) > 0 THEN
4605: DBMS_SQL.column_value(l_emp_csr, 1, l_common_quantity);
4606: DBMS_SQL.column_value(l_emp_csr, 2, l_common_amount);
4607: DBMS_SQL.column_value(l_emp_csr, 3, l_common_uom_code);
4608:
4609: IF l_requirement_type = 'VOLUME' THEN
4610: IF l_uom_code = l_common_uom_code THEN

Line 4607: DBMS_SQL.column_value(l_emp_csr, 3, l_common_uom_code);

4603: l_ignore := DBMS_SQL.execute(l_emp_csr);
4604: IF DBMS_SQL.fetch_rows(l_emp_csr) > 0 THEN
4605: DBMS_SQL.column_value(l_emp_csr, 1, l_common_quantity);
4606: DBMS_SQL.column_value(l_emp_csr, 2, l_common_amount);
4607: DBMS_SQL.column_value(l_emp_csr, 3, l_common_uom_code);
4608:
4609: IF l_requirement_type = 'VOLUME' THEN
4610: IF l_uom_code = l_common_uom_code THEN
4611: IF l_common_quantity < l_requirement_value THEN

Line 4683: DBMS_SQL.close_cursor(l_emp_csr);

4679: OZF_Utility_PVT.debug_message('No sales transactions found');
4680: END IF;
4681: l_performance_flag := FND_API.g_false;
4682: END IF;
4683: DBMS_SQL.close_cursor(l_emp_csr);
4684:
4685: END IF;
4686:
4687: IF l_performance_flag = 'F' THEN

Line 5031: l_emp_csr := DBMS_SQL.open_cursor;

5027: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
5028: RAISE FND_API.g_exc_error;
5029: END IF;
5030:
5031: l_emp_csr := DBMS_SQL.open_cursor;
5032: FND_DSQL.set_cursor(l_emp_csr);
5033: DBMS_SQL.parse(l_emp_csr, l_stmt, DBMS_SQL.native);
5034: DBMS_SQL.define_column(l_emp_csr, 1, l_cust_account_id);
5035: DBMS_SQL.define_column(l_emp_csr, 2, l_plan_type, 30);

Line 5033: DBMS_SQL.parse(l_emp_csr, l_stmt, DBMS_SQL.native);

5029: END IF;
5030:
5031: l_emp_csr := DBMS_SQL.open_cursor;
5032: FND_DSQL.set_cursor(l_emp_csr);
5033: DBMS_SQL.parse(l_emp_csr, l_stmt, DBMS_SQL.native);
5034: DBMS_SQL.define_column(l_emp_csr, 1, l_cust_account_id);
5035: DBMS_SQL.define_column(l_emp_csr, 2, l_plan_type, 30);
5036: DBMS_SQL.define_column(l_emp_csr, 3, l_plan_id);
5037: DBMS_SQL.define_column(l_emp_csr, 4, l_bill_to_site_id); --R12.1 enhancements

Line 5034: DBMS_SQL.define_column(l_emp_csr, 1, l_cust_account_id);

5030:
5031: l_emp_csr := DBMS_SQL.open_cursor;
5032: FND_DSQL.set_cursor(l_emp_csr);
5033: DBMS_SQL.parse(l_emp_csr, l_stmt, DBMS_SQL.native);
5034: DBMS_SQL.define_column(l_emp_csr, 1, l_cust_account_id);
5035: DBMS_SQL.define_column(l_emp_csr, 2, l_plan_type, 30);
5036: DBMS_SQL.define_column(l_emp_csr, 3, l_plan_id);
5037: DBMS_SQL.define_column(l_emp_csr, 4, l_bill_to_site_id); --R12.1 enhancements
5038: DBMS_SQL.define_column(l_emp_csr, 5, l_product_level_type, 30);

Line 5035: DBMS_SQL.define_column(l_emp_csr, 2, l_plan_type, 30);

5031: l_emp_csr := DBMS_SQL.open_cursor;
5032: FND_DSQL.set_cursor(l_emp_csr);
5033: DBMS_SQL.parse(l_emp_csr, l_stmt, DBMS_SQL.native);
5034: DBMS_SQL.define_column(l_emp_csr, 1, l_cust_account_id);
5035: DBMS_SQL.define_column(l_emp_csr, 2, l_plan_type, 30);
5036: DBMS_SQL.define_column(l_emp_csr, 3, l_plan_id);
5037: DBMS_SQL.define_column(l_emp_csr, 4, l_bill_to_site_id); --R12.1 enhancements
5038: DBMS_SQL.define_column(l_emp_csr, 5, l_product_level_type, 30);
5039: DBMS_SQL.define_column(l_emp_csr, 6, l_product_id);

Line 5036: DBMS_SQL.define_column(l_emp_csr, 3, l_plan_id);

5032: FND_DSQL.set_cursor(l_emp_csr);
5033: DBMS_SQL.parse(l_emp_csr, l_stmt, DBMS_SQL.native);
5034: DBMS_SQL.define_column(l_emp_csr, 1, l_cust_account_id);
5035: DBMS_SQL.define_column(l_emp_csr, 2, l_plan_type, 30);
5036: DBMS_SQL.define_column(l_emp_csr, 3, l_plan_id);
5037: DBMS_SQL.define_column(l_emp_csr, 4, l_bill_to_site_id); --R12.1 enhancements
5038: DBMS_SQL.define_column(l_emp_csr, 5, l_product_level_type, 30);
5039: DBMS_SQL.define_column(l_emp_csr, 6, l_product_id);
5040: DBMS_SQL.define_column(l_emp_csr, 7, l_amount);

Line 5037: DBMS_SQL.define_column(l_emp_csr, 4, l_bill_to_site_id); --R12.1 enhancements

5033: DBMS_SQL.parse(l_emp_csr, l_stmt, DBMS_SQL.native);
5034: DBMS_SQL.define_column(l_emp_csr, 1, l_cust_account_id);
5035: DBMS_SQL.define_column(l_emp_csr, 2, l_plan_type, 30);
5036: DBMS_SQL.define_column(l_emp_csr, 3, l_plan_id);
5037: DBMS_SQL.define_column(l_emp_csr, 4, l_bill_to_site_id); --R12.1 enhancements
5038: DBMS_SQL.define_column(l_emp_csr, 5, l_product_level_type, 30);
5039: DBMS_SQL.define_column(l_emp_csr, 6, l_product_id);
5040: DBMS_SQL.define_column(l_emp_csr, 7, l_amount);
5041: DBMS_SQL.define_column(l_emp_csr, 8, l_currency_code, 15);

Line 5038: DBMS_SQL.define_column(l_emp_csr, 5, l_product_level_type, 30);

5034: DBMS_SQL.define_column(l_emp_csr, 1, l_cust_account_id);
5035: DBMS_SQL.define_column(l_emp_csr, 2, l_plan_type, 30);
5036: DBMS_SQL.define_column(l_emp_csr, 3, l_plan_id);
5037: DBMS_SQL.define_column(l_emp_csr, 4, l_bill_to_site_id); --R12.1 enhancements
5038: DBMS_SQL.define_column(l_emp_csr, 5, l_product_level_type, 30);
5039: DBMS_SQL.define_column(l_emp_csr, 6, l_product_id);
5040: DBMS_SQL.define_column(l_emp_csr, 7, l_amount);
5041: DBMS_SQL.define_column(l_emp_csr, 8, l_currency_code, 15);
5042: FND_DSQL.do_binds;

Line 5039: DBMS_SQL.define_column(l_emp_csr, 6, l_product_id);

5035: DBMS_SQL.define_column(l_emp_csr, 2, l_plan_type, 30);
5036: DBMS_SQL.define_column(l_emp_csr, 3, l_plan_id);
5037: DBMS_SQL.define_column(l_emp_csr, 4, l_bill_to_site_id); --R12.1 enhancements
5038: DBMS_SQL.define_column(l_emp_csr, 5, l_product_level_type, 30);
5039: DBMS_SQL.define_column(l_emp_csr, 6, l_product_id);
5040: DBMS_SQL.define_column(l_emp_csr, 7, l_amount);
5041: DBMS_SQL.define_column(l_emp_csr, 8, l_currency_code, 15);
5042: FND_DSQL.do_binds;
5043:

Line 5040: DBMS_SQL.define_column(l_emp_csr, 7, l_amount);

5036: DBMS_SQL.define_column(l_emp_csr, 3, l_plan_id);
5037: DBMS_SQL.define_column(l_emp_csr, 4, l_bill_to_site_id); --R12.1 enhancements
5038: DBMS_SQL.define_column(l_emp_csr, 5, l_product_level_type, 30);
5039: DBMS_SQL.define_column(l_emp_csr, 6, l_product_id);
5040: DBMS_SQL.define_column(l_emp_csr, 7, l_amount);
5041: DBMS_SQL.define_column(l_emp_csr, 8, l_currency_code, 15);
5042: FND_DSQL.do_binds;
5043:
5044: l_ignore := DBMS_SQL.execute(l_emp_csr);

Line 5041: DBMS_SQL.define_column(l_emp_csr, 8, l_currency_code, 15);

5037: DBMS_SQL.define_column(l_emp_csr, 4, l_bill_to_site_id); --R12.1 enhancements
5038: DBMS_SQL.define_column(l_emp_csr, 5, l_product_level_type, 30);
5039: DBMS_SQL.define_column(l_emp_csr, 6, l_product_id);
5040: DBMS_SQL.define_column(l_emp_csr, 7, l_amount);
5041: DBMS_SQL.define_column(l_emp_csr, 8, l_currency_code, 15);
5042: FND_DSQL.do_binds;
5043:
5044: l_ignore := DBMS_SQL.execute(l_emp_csr);
5045: LOOP

Line 5044: l_ignore := DBMS_SQL.execute(l_emp_csr);

5040: DBMS_SQL.define_column(l_emp_csr, 7, l_amount);
5041: DBMS_SQL.define_column(l_emp_csr, 8, l_currency_code, 15);
5042: FND_DSQL.do_binds;
5043:
5044: l_ignore := DBMS_SQL.execute(l_emp_csr);
5045: LOOP
5046: IF DBMS_SQL.fetch_rows(l_emp_csr) > 0 THEN
5047: DBMS_SQL.column_value(l_emp_csr, 1, l_cust_account_id);
5048: DBMS_SQL.column_value(l_emp_csr, 2, l_plan_type);

Line 5046: IF DBMS_SQL.fetch_rows(l_emp_csr) > 0 THEN

5042: FND_DSQL.do_binds;
5043:
5044: l_ignore := DBMS_SQL.execute(l_emp_csr);
5045: LOOP
5046: IF DBMS_SQL.fetch_rows(l_emp_csr) > 0 THEN
5047: DBMS_SQL.column_value(l_emp_csr, 1, l_cust_account_id);
5048: DBMS_SQL.column_value(l_emp_csr, 2, l_plan_type);
5049: DBMS_SQL.column_value(l_emp_csr, 3, l_plan_id);
5050: DBMS_SQL.column_value(l_emp_csr, 4, l_bill_to_site_id); --R12.1 enhancements

Line 5047: DBMS_SQL.column_value(l_emp_csr, 1, l_cust_account_id);

5043:
5044: l_ignore := DBMS_SQL.execute(l_emp_csr);
5045: LOOP
5046: IF DBMS_SQL.fetch_rows(l_emp_csr) > 0 THEN
5047: DBMS_SQL.column_value(l_emp_csr, 1, l_cust_account_id);
5048: DBMS_SQL.column_value(l_emp_csr, 2, l_plan_type);
5049: DBMS_SQL.column_value(l_emp_csr, 3, l_plan_id);
5050: DBMS_SQL.column_value(l_emp_csr, 4, l_bill_to_site_id); --R12.1 enhancements
5051: DBMS_SQL.column_value(l_emp_csr, 5, l_product_level_type);

Line 5048: DBMS_SQL.column_value(l_emp_csr, 2, l_plan_type);

5044: l_ignore := DBMS_SQL.execute(l_emp_csr);
5045: LOOP
5046: IF DBMS_SQL.fetch_rows(l_emp_csr) > 0 THEN
5047: DBMS_SQL.column_value(l_emp_csr, 1, l_cust_account_id);
5048: DBMS_SQL.column_value(l_emp_csr, 2, l_plan_type);
5049: DBMS_SQL.column_value(l_emp_csr, 3, l_plan_id);
5050: DBMS_SQL.column_value(l_emp_csr, 4, l_bill_to_site_id); --R12.1 enhancements
5051: DBMS_SQL.column_value(l_emp_csr, 5, l_product_level_type);
5052: DBMS_SQL.column_value(l_emp_csr, 6, l_product_id);

Line 5049: DBMS_SQL.column_value(l_emp_csr, 3, l_plan_id);

5045: LOOP
5046: IF DBMS_SQL.fetch_rows(l_emp_csr) > 0 THEN
5047: DBMS_SQL.column_value(l_emp_csr, 1, l_cust_account_id);
5048: DBMS_SQL.column_value(l_emp_csr, 2, l_plan_type);
5049: DBMS_SQL.column_value(l_emp_csr, 3, l_plan_id);
5050: DBMS_SQL.column_value(l_emp_csr, 4, l_bill_to_site_id); --R12.1 enhancements
5051: DBMS_SQL.column_value(l_emp_csr, 5, l_product_level_type);
5052: DBMS_SQL.column_value(l_emp_csr, 6, l_product_id);
5053: DBMS_SQL.column_value(l_emp_csr, 7, l_amount);

Line 5050: DBMS_SQL.column_value(l_emp_csr, 4, l_bill_to_site_id); --R12.1 enhancements

5046: IF DBMS_SQL.fetch_rows(l_emp_csr) > 0 THEN
5047: DBMS_SQL.column_value(l_emp_csr, 1, l_cust_account_id);
5048: DBMS_SQL.column_value(l_emp_csr, 2, l_plan_type);
5049: DBMS_SQL.column_value(l_emp_csr, 3, l_plan_id);
5050: DBMS_SQL.column_value(l_emp_csr, 4, l_bill_to_site_id); --R12.1 enhancements
5051: DBMS_SQL.column_value(l_emp_csr, 5, l_product_level_type);
5052: DBMS_SQL.column_value(l_emp_csr, 6, l_product_id);
5053: DBMS_SQL.column_value(l_emp_csr, 7, l_amount);
5054: DBMS_SQL.column_value(l_emp_csr, 8, l_currency_code);

Line 5051: DBMS_SQL.column_value(l_emp_csr, 5, l_product_level_type);

5047: DBMS_SQL.column_value(l_emp_csr, 1, l_cust_account_id);
5048: DBMS_SQL.column_value(l_emp_csr, 2, l_plan_type);
5049: DBMS_SQL.column_value(l_emp_csr, 3, l_plan_id);
5050: DBMS_SQL.column_value(l_emp_csr, 4, l_bill_to_site_id); --R12.1 enhancements
5051: DBMS_SQL.column_value(l_emp_csr, 5, l_product_level_type);
5052: DBMS_SQL.column_value(l_emp_csr, 6, l_product_id);
5053: DBMS_SQL.column_value(l_emp_csr, 7, l_amount);
5054: DBMS_SQL.column_value(l_emp_csr, 8, l_currency_code);
5055:

Line 5052: DBMS_SQL.column_value(l_emp_csr, 6, l_product_id);

5048: DBMS_SQL.column_value(l_emp_csr, 2, l_plan_type);
5049: DBMS_SQL.column_value(l_emp_csr, 3, l_plan_id);
5050: DBMS_SQL.column_value(l_emp_csr, 4, l_bill_to_site_id); --R12.1 enhancements
5051: DBMS_SQL.column_value(l_emp_csr, 5, l_product_level_type);
5052: DBMS_SQL.column_value(l_emp_csr, 6, l_product_id);
5053: DBMS_SQL.column_value(l_emp_csr, 7, l_amount);
5054: DBMS_SQL.column_value(l_emp_csr, 8, l_currency_code);
5055:
5056: IF l_currency_code <> l_claim_rec.currency_code THEN

Line 5053: DBMS_SQL.column_value(l_emp_csr, 7, l_amount);

5049: DBMS_SQL.column_value(l_emp_csr, 3, l_plan_id);
5050: DBMS_SQL.column_value(l_emp_csr, 4, l_bill_to_site_id); --R12.1 enhancements
5051: DBMS_SQL.column_value(l_emp_csr, 5, l_product_level_type);
5052: DBMS_SQL.column_value(l_emp_csr, 6, l_product_id);
5053: DBMS_SQL.column_value(l_emp_csr, 7, l_amount);
5054: DBMS_SQL.column_value(l_emp_csr, 8, l_currency_code);
5055:
5056: IF l_currency_code <> l_claim_rec.currency_code THEN
5057: l_amount_ut_curr := l_amount;

Line 5054: DBMS_SQL.column_value(l_emp_csr, 8, l_currency_code);

5050: DBMS_SQL.column_value(l_emp_csr, 4, l_bill_to_site_id); --R12.1 enhancements
5051: DBMS_SQL.column_value(l_emp_csr, 5, l_product_level_type);
5052: DBMS_SQL.column_value(l_emp_csr, 6, l_product_id);
5053: DBMS_SQL.column_value(l_emp_csr, 7, l_amount);
5054: DBMS_SQL.column_value(l_emp_csr, 8, l_currency_code);
5055:
5056: IF l_currency_code <> l_claim_rec.currency_code THEN
5057: l_amount_ut_curr := l_amount;
5058:

Line 5262: DBMS_SQL.close_cursor(l_emp_csr);

5258: ELSE
5259: EXIT;
5260: END IF;
5261: END LOOP;
5262: DBMS_SQL.close_cursor(l_emp_csr);
5263:
5264: IF OZF_DEBUG_HIGH_ON THEN
5265: OZF_Utility_PVT.debug_message('l_total_acctd_amount_rem: ' || l_total_acctd_amount_rem);
5266: END IF;

Line 6389: l_emp_csr := DBMS_SQL.open_cursor;

6385: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
6386: RAISE FND_API.g_exc_error;
6387: END IF;
6388:
6389: l_emp_csr := DBMS_SQL.open_cursor;
6390: FND_DSQL.set_cursor(l_emp_csr);
6391: DBMS_SQL.parse(l_emp_csr, l_stmt, DBMS_SQL.native);
6392: DBMS_SQL.define_column(l_emp_csr, 1, l_cust_account_id);
6393: DBMS_SQL.define_column(l_emp_csr, 2, l_plan_type, 30);

Line 6391: DBMS_SQL.parse(l_emp_csr, l_stmt, DBMS_SQL.native);

6387: END IF;
6388:
6389: l_emp_csr := DBMS_SQL.open_cursor;
6390: FND_DSQL.set_cursor(l_emp_csr);
6391: DBMS_SQL.parse(l_emp_csr, l_stmt, DBMS_SQL.native);
6392: DBMS_SQL.define_column(l_emp_csr, 1, l_cust_account_id);
6393: DBMS_SQL.define_column(l_emp_csr, 2, l_plan_type, 30);
6394: DBMS_SQL.define_column(l_emp_csr, 3, l_plan_id);
6395: DBMS_SQL.define_column(l_emp_csr, 4, l_bill_to_site_id); --Fix for Bug 7605745

Line 6392: DBMS_SQL.define_column(l_emp_csr, 1, l_cust_account_id);

6388:
6389: l_emp_csr := DBMS_SQL.open_cursor;
6390: FND_DSQL.set_cursor(l_emp_csr);
6391: DBMS_SQL.parse(l_emp_csr, l_stmt, DBMS_SQL.native);
6392: DBMS_SQL.define_column(l_emp_csr, 1, l_cust_account_id);
6393: DBMS_SQL.define_column(l_emp_csr, 2, l_plan_type, 30);
6394: DBMS_SQL.define_column(l_emp_csr, 3, l_plan_id);
6395: DBMS_SQL.define_column(l_emp_csr, 4, l_bill_to_site_id); --Fix for Bug 7605745
6396: DBMS_SQL.define_column(l_emp_csr, 5, l_product_level_type, 30);

Line 6393: DBMS_SQL.define_column(l_emp_csr, 2, l_plan_type, 30);

6389: l_emp_csr := DBMS_SQL.open_cursor;
6390: FND_DSQL.set_cursor(l_emp_csr);
6391: DBMS_SQL.parse(l_emp_csr, l_stmt, DBMS_SQL.native);
6392: DBMS_SQL.define_column(l_emp_csr, 1, l_cust_account_id);
6393: DBMS_SQL.define_column(l_emp_csr, 2, l_plan_type, 30);
6394: DBMS_SQL.define_column(l_emp_csr, 3, l_plan_id);
6395: DBMS_SQL.define_column(l_emp_csr, 4, l_bill_to_site_id); --Fix for Bug 7605745
6396: DBMS_SQL.define_column(l_emp_csr, 5, l_product_level_type, 30);
6397: DBMS_SQL.define_column(l_emp_csr, 6, l_product_id);

Line 6394: DBMS_SQL.define_column(l_emp_csr, 3, l_plan_id);

6390: FND_DSQL.set_cursor(l_emp_csr);
6391: DBMS_SQL.parse(l_emp_csr, l_stmt, DBMS_SQL.native);
6392: DBMS_SQL.define_column(l_emp_csr, 1, l_cust_account_id);
6393: DBMS_SQL.define_column(l_emp_csr, 2, l_plan_type, 30);
6394: DBMS_SQL.define_column(l_emp_csr, 3, l_plan_id);
6395: DBMS_SQL.define_column(l_emp_csr, 4, l_bill_to_site_id); --Fix for Bug 7605745
6396: DBMS_SQL.define_column(l_emp_csr, 5, l_product_level_type, 30);
6397: DBMS_SQL.define_column(l_emp_csr, 6, l_product_id);
6398: DBMS_SQL.define_column(l_emp_csr, 7, l_amount);

Line 6395: DBMS_SQL.define_column(l_emp_csr, 4, l_bill_to_site_id); --Fix for Bug 7605745

6391: DBMS_SQL.parse(l_emp_csr, l_stmt, DBMS_SQL.native);
6392: DBMS_SQL.define_column(l_emp_csr, 1, l_cust_account_id);
6393: DBMS_SQL.define_column(l_emp_csr, 2, l_plan_type, 30);
6394: DBMS_SQL.define_column(l_emp_csr, 3, l_plan_id);
6395: DBMS_SQL.define_column(l_emp_csr, 4, l_bill_to_site_id); --Fix for Bug 7605745
6396: DBMS_SQL.define_column(l_emp_csr, 5, l_product_level_type, 30);
6397: DBMS_SQL.define_column(l_emp_csr, 6, l_product_id);
6398: DBMS_SQL.define_column(l_emp_csr, 7, l_amount);
6399: DBMS_SQL.define_column(l_emp_csr, 8, l_currency_code, 15);

Line 6396: DBMS_SQL.define_column(l_emp_csr, 5, l_product_level_type, 30);

6392: DBMS_SQL.define_column(l_emp_csr, 1, l_cust_account_id);
6393: DBMS_SQL.define_column(l_emp_csr, 2, l_plan_type, 30);
6394: DBMS_SQL.define_column(l_emp_csr, 3, l_plan_id);
6395: DBMS_SQL.define_column(l_emp_csr, 4, l_bill_to_site_id); --Fix for Bug 7605745
6396: DBMS_SQL.define_column(l_emp_csr, 5, l_product_level_type, 30);
6397: DBMS_SQL.define_column(l_emp_csr, 6, l_product_id);
6398: DBMS_SQL.define_column(l_emp_csr, 7, l_amount);
6399: DBMS_SQL.define_column(l_emp_csr, 8, l_currency_code, 15);
6400: FND_DSQL.do_binds;

Line 6397: DBMS_SQL.define_column(l_emp_csr, 6, l_product_id);

6393: DBMS_SQL.define_column(l_emp_csr, 2, l_plan_type, 30);
6394: DBMS_SQL.define_column(l_emp_csr, 3, l_plan_id);
6395: DBMS_SQL.define_column(l_emp_csr, 4, l_bill_to_site_id); --Fix for Bug 7605745
6396: DBMS_SQL.define_column(l_emp_csr, 5, l_product_level_type, 30);
6397: DBMS_SQL.define_column(l_emp_csr, 6, l_product_id);
6398: DBMS_SQL.define_column(l_emp_csr, 7, l_amount);
6399: DBMS_SQL.define_column(l_emp_csr, 8, l_currency_code, 15);
6400: FND_DSQL.do_binds;
6401:

Line 6398: DBMS_SQL.define_column(l_emp_csr, 7, l_amount);

6394: DBMS_SQL.define_column(l_emp_csr, 3, l_plan_id);
6395: DBMS_SQL.define_column(l_emp_csr, 4, l_bill_to_site_id); --Fix for Bug 7605745
6396: DBMS_SQL.define_column(l_emp_csr, 5, l_product_level_type, 30);
6397: DBMS_SQL.define_column(l_emp_csr, 6, l_product_id);
6398: DBMS_SQL.define_column(l_emp_csr, 7, l_amount);
6399: DBMS_SQL.define_column(l_emp_csr, 8, l_currency_code, 15);
6400: FND_DSQL.do_binds;
6401:
6402: l_ignore := DBMS_SQL.execute(l_emp_csr);

Line 6399: DBMS_SQL.define_column(l_emp_csr, 8, l_currency_code, 15);

6395: DBMS_SQL.define_column(l_emp_csr, 4, l_bill_to_site_id); --Fix for Bug 7605745
6396: DBMS_SQL.define_column(l_emp_csr, 5, l_product_level_type, 30);
6397: DBMS_SQL.define_column(l_emp_csr, 6, l_product_id);
6398: DBMS_SQL.define_column(l_emp_csr, 7, l_amount);
6399: DBMS_SQL.define_column(l_emp_csr, 8, l_currency_code, 15);
6400: FND_DSQL.do_binds;
6401:
6402: l_ignore := DBMS_SQL.execute(l_emp_csr);
6403: LOOP

Line 6402: l_ignore := DBMS_SQL.execute(l_emp_csr);

6398: DBMS_SQL.define_column(l_emp_csr, 7, l_amount);
6399: DBMS_SQL.define_column(l_emp_csr, 8, l_currency_code, 15);
6400: FND_DSQL.do_binds;
6401:
6402: l_ignore := DBMS_SQL.execute(l_emp_csr);
6403: LOOP
6404: IF DBMS_SQL.fetch_rows(l_emp_csr) > 0 AND l_total_amount <> 0 THEN
6405: DBMS_SQL.column_value(l_emp_csr, 1, l_cust_account_id);
6406: DBMS_SQL.column_value(l_emp_csr, 2, l_plan_type);

Line 6404: IF DBMS_SQL.fetch_rows(l_emp_csr) > 0 AND l_total_amount <> 0 THEN

6400: FND_DSQL.do_binds;
6401:
6402: l_ignore := DBMS_SQL.execute(l_emp_csr);
6403: LOOP
6404: IF DBMS_SQL.fetch_rows(l_emp_csr) > 0 AND l_total_amount <> 0 THEN
6405: DBMS_SQL.column_value(l_emp_csr, 1, l_cust_account_id);
6406: DBMS_SQL.column_value(l_emp_csr, 2, l_plan_type);
6407: DBMS_SQL.column_value(l_emp_csr, 3, l_plan_id);
6408: DBMS_SQL.column_value(l_emp_csr, 4, l_bill_to_site_id); --Fix for Bug 7605745

Line 6405: DBMS_SQL.column_value(l_emp_csr, 1, l_cust_account_id);

6401:
6402: l_ignore := DBMS_SQL.execute(l_emp_csr);
6403: LOOP
6404: IF DBMS_SQL.fetch_rows(l_emp_csr) > 0 AND l_total_amount <> 0 THEN
6405: DBMS_SQL.column_value(l_emp_csr, 1, l_cust_account_id);
6406: DBMS_SQL.column_value(l_emp_csr, 2, l_plan_type);
6407: DBMS_SQL.column_value(l_emp_csr, 3, l_plan_id);
6408: DBMS_SQL.column_value(l_emp_csr, 4, l_bill_to_site_id); --Fix for Bug 7605745
6409: DBMS_SQL.column_value(l_emp_csr, 5, l_product_level_type);

Line 6406: DBMS_SQL.column_value(l_emp_csr, 2, l_plan_type);

6402: l_ignore := DBMS_SQL.execute(l_emp_csr);
6403: LOOP
6404: IF DBMS_SQL.fetch_rows(l_emp_csr) > 0 AND l_total_amount <> 0 THEN
6405: DBMS_SQL.column_value(l_emp_csr, 1, l_cust_account_id);
6406: DBMS_SQL.column_value(l_emp_csr, 2, l_plan_type);
6407: DBMS_SQL.column_value(l_emp_csr, 3, l_plan_id);
6408: DBMS_SQL.column_value(l_emp_csr, 4, l_bill_to_site_id); --Fix for Bug 7605745
6409: DBMS_SQL.column_value(l_emp_csr, 5, l_product_level_type);
6410: DBMS_SQL.column_value(l_emp_csr, 6, l_product_id);

Line 6407: DBMS_SQL.column_value(l_emp_csr, 3, l_plan_id);

6403: LOOP
6404: IF DBMS_SQL.fetch_rows(l_emp_csr) > 0 AND l_total_amount <> 0 THEN
6405: DBMS_SQL.column_value(l_emp_csr, 1, l_cust_account_id);
6406: DBMS_SQL.column_value(l_emp_csr, 2, l_plan_type);
6407: DBMS_SQL.column_value(l_emp_csr, 3, l_plan_id);
6408: DBMS_SQL.column_value(l_emp_csr, 4, l_bill_to_site_id); --Fix for Bug 7605745
6409: DBMS_SQL.column_value(l_emp_csr, 5, l_product_level_type);
6410: DBMS_SQL.column_value(l_emp_csr, 6, l_product_id);
6411: DBMS_SQL.column_value(l_emp_csr, 7, l_amount);

Line 6408: DBMS_SQL.column_value(l_emp_csr, 4, l_bill_to_site_id); --Fix for Bug 7605745

6404: IF DBMS_SQL.fetch_rows(l_emp_csr) > 0 AND l_total_amount <> 0 THEN
6405: DBMS_SQL.column_value(l_emp_csr, 1, l_cust_account_id);
6406: DBMS_SQL.column_value(l_emp_csr, 2, l_plan_type);
6407: DBMS_SQL.column_value(l_emp_csr, 3, l_plan_id);
6408: DBMS_SQL.column_value(l_emp_csr, 4, l_bill_to_site_id); --Fix for Bug 7605745
6409: DBMS_SQL.column_value(l_emp_csr, 5, l_product_level_type);
6410: DBMS_SQL.column_value(l_emp_csr, 6, l_product_id);
6411: DBMS_SQL.column_value(l_emp_csr, 7, l_amount);
6412: DBMS_SQL.column_value(l_emp_csr, 8, l_currency_code);

Line 6409: DBMS_SQL.column_value(l_emp_csr, 5, l_product_level_type);

6405: DBMS_SQL.column_value(l_emp_csr, 1, l_cust_account_id);
6406: DBMS_SQL.column_value(l_emp_csr, 2, l_plan_type);
6407: DBMS_SQL.column_value(l_emp_csr, 3, l_plan_id);
6408: DBMS_SQL.column_value(l_emp_csr, 4, l_bill_to_site_id); --Fix for Bug 7605745
6409: DBMS_SQL.column_value(l_emp_csr, 5, l_product_level_type);
6410: DBMS_SQL.column_value(l_emp_csr, 6, l_product_id);
6411: DBMS_SQL.column_value(l_emp_csr, 7, l_amount);
6412: DBMS_SQL.column_value(l_emp_csr, 8, l_currency_code);
6413:

Line 6410: DBMS_SQL.column_value(l_emp_csr, 6, l_product_id);

6406: DBMS_SQL.column_value(l_emp_csr, 2, l_plan_type);
6407: DBMS_SQL.column_value(l_emp_csr, 3, l_plan_id);
6408: DBMS_SQL.column_value(l_emp_csr, 4, l_bill_to_site_id); --Fix for Bug 7605745
6409: DBMS_SQL.column_value(l_emp_csr, 5, l_product_level_type);
6410: DBMS_SQL.column_value(l_emp_csr, 6, l_product_id);
6411: DBMS_SQL.column_value(l_emp_csr, 7, l_amount);
6412: DBMS_SQL.column_value(l_emp_csr, 8, l_currency_code);
6413:
6414: IF l_amount IS NOT NULL AND l_amount <> 0 THEN

Line 6411: DBMS_SQL.column_value(l_emp_csr, 7, l_amount);

6407: DBMS_SQL.column_value(l_emp_csr, 3, l_plan_id);
6408: DBMS_SQL.column_value(l_emp_csr, 4, l_bill_to_site_id); --Fix for Bug 7605745
6409: DBMS_SQL.column_value(l_emp_csr, 5, l_product_level_type);
6410: DBMS_SQL.column_value(l_emp_csr, 6, l_product_id);
6411: DBMS_SQL.column_value(l_emp_csr, 7, l_amount);
6412: DBMS_SQL.column_value(l_emp_csr, 8, l_currency_code);
6413:
6414: IF l_amount IS NOT NULL AND l_amount <> 0 THEN
6415: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line ' || l_counter || ': Amount='||l_amount);

Line 6412: DBMS_SQL.column_value(l_emp_csr, 8, l_currency_code);

6408: DBMS_SQL.column_value(l_emp_csr, 4, l_bill_to_site_id); --Fix for Bug 7605745
6409: DBMS_SQL.column_value(l_emp_csr, 5, l_product_level_type);
6410: DBMS_SQL.column_value(l_emp_csr, 6, l_product_id);
6411: DBMS_SQL.column_value(l_emp_csr, 7, l_amount);
6412: DBMS_SQL.column_value(l_emp_csr, 8, l_currency_code);
6413:
6414: IF l_amount IS NOT NULL AND l_amount <> 0 THEN
6415: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line ' || l_counter || ': Amount='||l_amount);
6416: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Type : ' || l_plan_type);

Line 6487: DBMS_SQL.close_cursor(l_emp_csr);

6483: ELSE
6484: EXIT;
6485: END IF;
6486: END LOOP;
6487: DBMS_SQL.close_cursor(l_emp_csr);
6488:
6489: -- if earnings are found
6490: IF l_counter > 1 THEN
6491: OZF_CLAIM_LINE_PVT.Create_Claim_Line_Tbl(

Line 8846: l_funds_util_csr := DBMS_SQL.open_cursor;

8842: RAISE FND_API.g_exc_error;
8843: END IF;
8844:
8845: j := 0;
8846: l_funds_util_csr := DBMS_SQL.open_cursor;
8847: FND_DSQL.set_cursor(l_funds_util_csr);
8848: DBMS_SQL.parse(l_funds_util_csr, l_funds_util_sql, DBMS_SQL.native);
8849: DBMS_SQL.define_column(l_funds_util_csr, 1, l_util_id);
8850: DBMS_SQL.define_column(l_funds_util_csr, 2, l_fu_amt_rem);

Line 8848: DBMS_SQL.parse(l_funds_util_csr, l_funds_util_sql, DBMS_SQL.native);

8844:
8845: j := 0;
8846: l_funds_util_csr := DBMS_SQL.open_cursor;
8847: FND_DSQL.set_cursor(l_funds_util_csr);
8848: DBMS_SQL.parse(l_funds_util_csr, l_funds_util_sql, DBMS_SQL.native);
8849: DBMS_SQL.define_column(l_funds_util_csr, 1, l_util_id);
8850: DBMS_SQL.define_column(l_funds_util_csr, 2, l_fu_amt_rem);
8851: DBMS_SQL.define_column(l_funds_util_csr, 3, l_fu_scan_unit_rem);
8852: DBMS_SQL.define_column(l_funds_util_csr, 4, l_fu_currency_code, 15);

Line 8849: DBMS_SQL.define_column(l_funds_util_csr, 1, l_util_id);

8845: j := 0;
8846: l_funds_util_csr := DBMS_SQL.open_cursor;
8847: FND_DSQL.set_cursor(l_funds_util_csr);
8848: DBMS_SQL.parse(l_funds_util_csr, l_funds_util_sql, DBMS_SQL.native);
8849: DBMS_SQL.define_column(l_funds_util_csr, 1, l_util_id);
8850: DBMS_SQL.define_column(l_funds_util_csr, 2, l_fu_amt_rem);
8851: DBMS_SQL.define_column(l_funds_util_csr, 3, l_fu_scan_unit_rem);
8852: DBMS_SQL.define_column(l_funds_util_csr, 4, l_fu_currency_code, 15);
8853: DBMS_SQL.define_column(l_funds_util_csr, 5, l_plan_currency_code, 15);

Line 8850: DBMS_SQL.define_column(l_funds_util_csr, 2, l_fu_amt_rem);

8846: l_funds_util_csr := DBMS_SQL.open_cursor;
8847: FND_DSQL.set_cursor(l_funds_util_csr);
8848: DBMS_SQL.parse(l_funds_util_csr, l_funds_util_sql, DBMS_SQL.native);
8849: DBMS_SQL.define_column(l_funds_util_csr, 1, l_util_id);
8850: DBMS_SQL.define_column(l_funds_util_csr, 2, l_fu_amt_rem);
8851: DBMS_SQL.define_column(l_funds_util_csr, 3, l_fu_scan_unit_rem);
8852: DBMS_SQL.define_column(l_funds_util_csr, 4, l_fu_currency_code, 15);
8853: DBMS_SQL.define_column(l_funds_util_csr, 5, l_plan_currency_code, 15);
8854: DBMS_SQL.define_column(l_funds_util_csr, 6, l_plan_curr_amount_remaining);

Line 8851: DBMS_SQL.define_column(l_funds_util_csr, 3, l_fu_scan_unit_rem);

8847: FND_DSQL.set_cursor(l_funds_util_csr);
8848: DBMS_SQL.parse(l_funds_util_csr, l_funds_util_sql, DBMS_SQL.native);
8849: DBMS_SQL.define_column(l_funds_util_csr, 1, l_util_id);
8850: DBMS_SQL.define_column(l_funds_util_csr, 2, l_fu_amt_rem);
8851: DBMS_SQL.define_column(l_funds_util_csr, 3, l_fu_scan_unit_rem);
8852: DBMS_SQL.define_column(l_funds_util_csr, 4, l_fu_currency_code, 15);
8853: DBMS_SQL.define_column(l_funds_util_csr, 5, l_plan_currency_code, 15);
8854: DBMS_SQL.define_column(l_funds_util_csr, 6, l_plan_curr_amount_remaining);
8855: DBMS_SQL.define_column(l_funds_util_csr, 7, l_plan_curr_amount);

Line 8852: DBMS_SQL.define_column(l_funds_util_csr, 4, l_fu_currency_code, 15);

8848: DBMS_SQL.parse(l_funds_util_csr, l_funds_util_sql, DBMS_SQL.native);
8849: DBMS_SQL.define_column(l_funds_util_csr, 1, l_util_id);
8850: DBMS_SQL.define_column(l_funds_util_csr, 2, l_fu_amt_rem);
8851: DBMS_SQL.define_column(l_funds_util_csr, 3, l_fu_scan_unit_rem);
8852: DBMS_SQL.define_column(l_funds_util_csr, 4, l_fu_currency_code, 15);
8853: DBMS_SQL.define_column(l_funds_util_csr, 5, l_plan_currency_code, 15);
8854: DBMS_SQL.define_column(l_funds_util_csr, 6, l_plan_curr_amount_remaining);
8855: DBMS_SQL.define_column(l_funds_util_csr, 7, l_plan_curr_amount);
8856: DBMS_SQL.define_column(l_funds_util_csr, 8, l_acctd_amount_remaining);

Line 8853: DBMS_SQL.define_column(l_funds_util_csr, 5, l_plan_currency_code, 15);

8849: DBMS_SQL.define_column(l_funds_util_csr, 1, l_util_id);
8850: DBMS_SQL.define_column(l_funds_util_csr, 2, l_fu_amt_rem);
8851: DBMS_SQL.define_column(l_funds_util_csr, 3, l_fu_scan_unit_rem);
8852: DBMS_SQL.define_column(l_funds_util_csr, 4, l_fu_currency_code, 15);
8853: DBMS_SQL.define_column(l_funds_util_csr, 5, l_plan_currency_code, 15);
8854: DBMS_SQL.define_column(l_funds_util_csr, 6, l_plan_curr_amount_remaining);
8855: DBMS_SQL.define_column(l_funds_util_csr, 7, l_plan_curr_amount);
8856: DBMS_SQL.define_column(l_funds_util_csr, 8, l_acctd_amount_remaining);
8857: FND_DSQL.do_binds;

Line 8854: DBMS_SQL.define_column(l_funds_util_csr, 6, l_plan_curr_amount_remaining);

8850: DBMS_SQL.define_column(l_funds_util_csr, 2, l_fu_amt_rem);
8851: DBMS_SQL.define_column(l_funds_util_csr, 3, l_fu_scan_unit_rem);
8852: DBMS_SQL.define_column(l_funds_util_csr, 4, l_fu_currency_code, 15);
8853: DBMS_SQL.define_column(l_funds_util_csr, 5, l_plan_currency_code, 15);
8854: DBMS_SQL.define_column(l_funds_util_csr, 6, l_plan_curr_amount_remaining);
8855: DBMS_SQL.define_column(l_funds_util_csr, 7, l_plan_curr_amount);
8856: DBMS_SQL.define_column(l_funds_util_csr, 8, l_acctd_amount_remaining);
8857: FND_DSQL.do_binds;
8858:

Line 8855: DBMS_SQL.define_column(l_funds_util_csr, 7, l_plan_curr_amount);

8851: DBMS_SQL.define_column(l_funds_util_csr, 3, l_fu_scan_unit_rem);
8852: DBMS_SQL.define_column(l_funds_util_csr, 4, l_fu_currency_code, 15);
8853: DBMS_SQL.define_column(l_funds_util_csr, 5, l_plan_currency_code, 15);
8854: DBMS_SQL.define_column(l_funds_util_csr, 6, l_plan_curr_amount_remaining);
8855: DBMS_SQL.define_column(l_funds_util_csr, 7, l_plan_curr_amount);
8856: DBMS_SQL.define_column(l_funds_util_csr, 8, l_acctd_amount_remaining);
8857: FND_DSQL.do_binds;
8858:
8859: l_ignore := DBMS_SQL.execute(l_funds_util_csr);

Line 8856: DBMS_SQL.define_column(l_funds_util_csr, 8, l_acctd_amount_remaining);

8852: DBMS_SQL.define_column(l_funds_util_csr, 4, l_fu_currency_code, 15);
8853: DBMS_SQL.define_column(l_funds_util_csr, 5, l_plan_currency_code, 15);
8854: DBMS_SQL.define_column(l_funds_util_csr, 6, l_plan_curr_amount_remaining);
8855: DBMS_SQL.define_column(l_funds_util_csr, 7, l_plan_curr_amount);
8856: DBMS_SQL.define_column(l_funds_util_csr, 8, l_acctd_amount_remaining);
8857: FND_DSQL.do_binds;
8858:
8859: l_ignore := DBMS_SQL.execute(l_funds_util_csr);
8860: LOOP

Line 8859: l_ignore := DBMS_SQL.execute(l_funds_util_csr);

8855: DBMS_SQL.define_column(l_funds_util_csr, 7, l_plan_curr_amount);
8856: DBMS_SQL.define_column(l_funds_util_csr, 8, l_acctd_amount_remaining);
8857: FND_DSQL.do_binds;
8858:
8859: l_ignore := DBMS_SQL.execute(l_funds_util_csr);
8860: LOOP
8861: IF DBMS_SQL.fetch_rows(l_funds_util_csr) > 0 THEN
8862: DBMS_SQL.column_value(l_funds_util_csr, 1, l_util_id);
8863: DBMS_SQL.column_value(l_funds_util_csr, 2, l_fu_amt_rem);

Line 8861: IF DBMS_SQL.fetch_rows(l_funds_util_csr) > 0 THEN

8857: FND_DSQL.do_binds;
8858:
8859: l_ignore := DBMS_SQL.execute(l_funds_util_csr);
8860: LOOP
8861: IF DBMS_SQL.fetch_rows(l_funds_util_csr) > 0 THEN
8862: DBMS_SQL.column_value(l_funds_util_csr, 1, l_util_id);
8863: DBMS_SQL.column_value(l_funds_util_csr, 2, l_fu_amt_rem);
8864: DBMS_SQL.column_value(l_funds_util_csr, 3, l_fu_scan_unit_rem);
8865: DBMS_SQL.column_value(l_funds_util_csr, 4, l_fu_currency_code);

Line 8862: DBMS_SQL.column_value(l_funds_util_csr, 1, l_util_id);

8858:
8859: l_ignore := DBMS_SQL.execute(l_funds_util_csr);
8860: LOOP
8861: IF DBMS_SQL.fetch_rows(l_funds_util_csr) > 0 THEN
8862: DBMS_SQL.column_value(l_funds_util_csr, 1, l_util_id);
8863: DBMS_SQL.column_value(l_funds_util_csr, 2, l_fu_amt_rem);
8864: DBMS_SQL.column_value(l_funds_util_csr, 3, l_fu_scan_unit_rem);
8865: DBMS_SQL.column_value(l_funds_util_csr, 4, l_fu_currency_code);
8866: DBMS_SQL.column_value(l_funds_util_csr, 5, l_plan_currency_code);

Line 8863: DBMS_SQL.column_value(l_funds_util_csr, 2, l_fu_amt_rem);

8859: l_ignore := DBMS_SQL.execute(l_funds_util_csr);
8860: LOOP
8861: IF DBMS_SQL.fetch_rows(l_funds_util_csr) > 0 THEN
8862: DBMS_SQL.column_value(l_funds_util_csr, 1, l_util_id);
8863: DBMS_SQL.column_value(l_funds_util_csr, 2, l_fu_amt_rem);
8864: DBMS_SQL.column_value(l_funds_util_csr, 3, l_fu_scan_unit_rem);
8865: DBMS_SQL.column_value(l_funds_util_csr, 4, l_fu_currency_code);
8866: DBMS_SQL.column_value(l_funds_util_csr, 5, l_plan_currency_code);
8867: DBMS_SQL.column_value(l_funds_util_csr, 6, l_plan_curr_amount_remaining);

Line 8864: DBMS_SQL.column_value(l_funds_util_csr, 3, l_fu_scan_unit_rem);

8860: LOOP
8861: IF DBMS_SQL.fetch_rows(l_funds_util_csr) > 0 THEN
8862: DBMS_SQL.column_value(l_funds_util_csr, 1, l_util_id);
8863: DBMS_SQL.column_value(l_funds_util_csr, 2, l_fu_amt_rem);
8864: DBMS_SQL.column_value(l_funds_util_csr, 3, l_fu_scan_unit_rem);
8865: DBMS_SQL.column_value(l_funds_util_csr, 4, l_fu_currency_code);
8866: DBMS_SQL.column_value(l_funds_util_csr, 5, l_plan_currency_code);
8867: DBMS_SQL.column_value(l_funds_util_csr, 6, l_plan_curr_amount_remaining);
8868: DBMS_SQL.column_value(l_funds_util_csr, 7, l_plan_curr_amount);

Line 8865: DBMS_SQL.column_value(l_funds_util_csr, 4, l_fu_currency_code);

8861: IF DBMS_SQL.fetch_rows(l_funds_util_csr) > 0 THEN
8862: DBMS_SQL.column_value(l_funds_util_csr, 1, l_util_id);
8863: DBMS_SQL.column_value(l_funds_util_csr, 2, l_fu_amt_rem);
8864: DBMS_SQL.column_value(l_funds_util_csr, 3, l_fu_scan_unit_rem);
8865: DBMS_SQL.column_value(l_funds_util_csr, 4, l_fu_currency_code);
8866: DBMS_SQL.column_value(l_funds_util_csr, 5, l_plan_currency_code);
8867: DBMS_SQL.column_value(l_funds_util_csr, 6, l_plan_curr_amount_remaining);
8868: DBMS_SQL.column_value(l_funds_util_csr, 7, l_plan_curr_amount);
8869: DBMS_SQL.column_value(l_funds_util_csr, 8, l_acctd_amount_remaining);

Line 8866: DBMS_SQL.column_value(l_funds_util_csr, 5, l_plan_currency_code);

8862: DBMS_SQL.column_value(l_funds_util_csr, 1, l_util_id);
8863: DBMS_SQL.column_value(l_funds_util_csr, 2, l_fu_amt_rem);
8864: DBMS_SQL.column_value(l_funds_util_csr, 3, l_fu_scan_unit_rem);
8865: DBMS_SQL.column_value(l_funds_util_csr, 4, l_fu_currency_code);
8866: DBMS_SQL.column_value(l_funds_util_csr, 5, l_plan_currency_code);
8867: DBMS_SQL.column_value(l_funds_util_csr, 6, l_plan_curr_amount_remaining);
8868: DBMS_SQL.column_value(l_funds_util_csr, 7, l_plan_curr_amount);
8869: DBMS_SQL.column_value(l_funds_util_csr, 8, l_acctd_amount_remaining);
8870:

Line 8867: DBMS_SQL.column_value(l_funds_util_csr, 6, l_plan_curr_amount_remaining);

8863: DBMS_SQL.column_value(l_funds_util_csr, 2, l_fu_amt_rem);
8864: DBMS_SQL.column_value(l_funds_util_csr, 3, l_fu_scan_unit_rem);
8865: DBMS_SQL.column_value(l_funds_util_csr, 4, l_fu_currency_code);
8866: DBMS_SQL.column_value(l_funds_util_csr, 5, l_plan_currency_code);
8867: DBMS_SQL.column_value(l_funds_util_csr, 6, l_plan_curr_amount_remaining);
8868: DBMS_SQL.column_value(l_funds_util_csr, 7, l_plan_curr_amount);
8869: DBMS_SQL.column_value(l_funds_util_csr, 8, l_acctd_amount_remaining);
8870:
8871:

Line 8868: DBMS_SQL.column_value(l_funds_util_csr, 7, l_plan_curr_amount);

8864: DBMS_SQL.column_value(l_funds_util_csr, 3, l_fu_scan_unit_rem);
8865: DBMS_SQL.column_value(l_funds_util_csr, 4, l_fu_currency_code);
8866: DBMS_SQL.column_value(l_funds_util_csr, 5, l_plan_currency_code);
8867: DBMS_SQL.column_value(l_funds_util_csr, 6, l_plan_curr_amount_remaining);
8868: DBMS_SQL.column_value(l_funds_util_csr, 7, l_plan_curr_amount);
8869: DBMS_SQL.column_value(l_funds_util_csr, 8, l_acctd_amount_remaining);
8870:
8871:
8872: /*OPEN csr_funds_used_units(p_funds_util_flt.activity_product_id); --ninarasi fix for bug 13530939

Line 8869: DBMS_SQL.column_value(l_funds_util_csr, 8, l_acctd_amount_remaining);

8865: DBMS_SQL.column_value(l_funds_util_csr, 4, l_fu_currency_code);
8866: DBMS_SQL.column_value(l_funds_util_csr, 5, l_plan_currency_code);
8867: DBMS_SQL.column_value(l_funds_util_csr, 6, l_plan_curr_amount_remaining);
8868: DBMS_SQL.column_value(l_funds_util_csr, 7, l_plan_curr_amount);
8869: DBMS_SQL.column_value(l_funds_util_csr, 8, l_acctd_amount_remaining);
8870:
8871:
8872: /*OPEN csr_funds_used_units(p_funds_util_flt.activity_product_id); --ninarasi fix for bug 13530939
8873: FETCH csr_funds_used_units INTO l_funds_used_units;

Line 8892: DBMS_SQL.close_cursor(l_funds_util_csr);

8888: ELSE
8889: EXIT;
8890: END IF;
8891: END LOOP;
8892: DBMS_SQL.close_cursor(l_funds_util_csr);
8893:
8894: --If total amount remaining for all the qualified adjustments is zero, then raise warning.
8895: --Raise error, if negative assocation is taking place for positive amount remaining.
8896: IF l_total_amt_rem = 0 AND

Line 10623: l_funds_util_csr := DBMS_SQL.open_cursor;

10619: RAISE FND_API.g_exc_unexpected_error;
10620: END IF;
10621:
10622: -- use FND_DSQL package for dynamic sql and bind variables
10623: l_funds_util_csr := DBMS_SQL.open_cursor;
10624: FND_DSQL.set_cursor(l_funds_util_csr);
10625: DBMS_SQL.parse(l_funds_util_csr, l_funds_util_sql, DBMS_SQL.native);
10626: DBMS_SQL.define_column(l_funds_util_csr, 1, l_lu_line_util_id);
10627: DBMS_SQL.define_column(l_funds_util_csr, 2, l_lu_utilization_id);

Line 10625: DBMS_SQL.parse(l_funds_util_csr, l_funds_util_sql, DBMS_SQL.native);

10621:
10622: -- use FND_DSQL package for dynamic sql and bind variables
10623: l_funds_util_csr := DBMS_SQL.open_cursor;
10624: FND_DSQL.set_cursor(l_funds_util_csr);
10625: DBMS_SQL.parse(l_funds_util_csr, l_funds_util_sql, DBMS_SQL.native);
10626: DBMS_SQL.define_column(l_funds_util_csr, 1, l_lu_line_util_id);
10627: DBMS_SQL.define_column(l_funds_util_csr, 2, l_lu_utilization_id);
10628: DBMS_SQL.define_column(l_funds_util_csr, 3, l_lu_amt);
10629: DBMS_SQL.define_column(l_funds_util_csr, 4, l_lu_scan_unit);

Line 10626: DBMS_SQL.define_column(l_funds_util_csr, 1, l_lu_line_util_id);

10622: -- use FND_DSQL package for dynamic sql and bind variables
10623: l_funds_util_csr := DBMS_SQL.open_cursor;
10624: FND_DSQL.set_cursor(l_funds_util_csr);
10625: DBMS_SQL.parse(l_funds_util_csr, l_funds_util_sql, DBMS_SQL.native);
10626: DBMS_SQL.define_column(l_funds_util_csr, 1, l_lu_line_util_id);
10627: DBMS_SQL.define_column(l_funds_util_csr, 2, l_lu_utilization_id);
10628: DBMS_SQL.define_column(l_funds_util_csr, 3, l_lu_amt);
10629: DBMS_SQL.define_column(l_funds_util_csr, 4, l_lu_scan_unit);
10630: DBMS_SQL.define_column(l_funds_util_csr, 5, l_lu_currency_code, 15);

Line 10627: DBMS_SQL.define_column(l_funds_util_csr, 2, l_lu_utilization_id);

10623: l_funds_util_csr := DBMS_SQL.open_cursor;
10624: FND_DSQL.set_cursor(l_funds_util_csr);
10625: DBMS_SQL.parse(l_funds_util_csr, l_funds_util_sql, DBMS_SQL.native);
10626: DBMS_SQL.define_column(l_funds_util_csr, 1, l_lu_line_util_id);
10627: DBMS_SQL.define_column(l_funds_util_csr, 2, l_lu_utilization_id);
10628: DBMS_SQL.define_column(l_funds_util_csr, 3, l_lu_amt);
10629: DBMS_SQL.define_column(l_funds_util_csr, 4, l_lu_scan_unit);
10630: DBMS_SQL.define_column(l_funds_util_csr, 5, l_lu_currency_code, 15);
10631: -- DBMS_SQL.define_column(l_funds_util_csr, 5, l_utiz_amount);

Line 10628: DBMS_SQL.define_column(l_funds_util_csr, 3, l_lu_amt);

10624: FND_DSQL.set_cursor(l_funds_util_csr);
10625: DBMS_SQL.parse(l_funds_util_csr, l_funds_util_sql, DBMS_SQL.native);
10626: DBMS_SQL.define_column(l_funds_util_csr, 1, l_lu_line_util_id);
10627: DBMS_SQL.define_column(l_funds_util_csr, 2, l_lu_utilization_id);
10628: DBMS_SQL.define_column(l_funds_util_csr, 3, l_lu_amt);
10629: DBMS_SQL.define_column(l_funds_util_csr, 4, l_lu_scan_unit);
10630: DBMS_SQL.define_column(l_funds_util_csr, 5, l_lu_currency_code, 15);
10631: -- DBMS_SQL.define_column(l_funds_util_csr, 5, l_utiz_amount);
10632: FND_DSQL.do_binds;

Line 10629: DBMS_SQL.define_column(l_funds_util_csr, 4, l_lu_scan_unit);

10625: DBMS_SQL.parse(l_funds_util_csr, l_funds_util_sql, DBMS_SQL.native);
10626: DBMS_SQL.define_column(l_funds_util_csr, 1, l_lu_line_util_id);
10627: DBMS_SQL.define_column(l_funds_util_csr, 2, l_lu_utilization_id);
10628: DBMS_SQL.define_column(l_funds_util_csr, 3, l_lu_amt);
10629: DBMS_SQL.define_column(l_funds_util_csr, 4, l_lu_scan_unit);
10630: DBMS_SQL.define_column(l_funds_util_csr, 5, l_lu_currency_code, 15);
10631: -- DBMS_SQL.define_column(l_funds_util_csr, 5, l_utiz_amount);
10632: FND_DSQL.do_binds;
10633:

Line 10630: DBMS_SQL.define_column(l_funds_util_csr, 5, l_lu_currency_code, 15);

10626: DBMS_SQL.define_column(l_funds_util_csr, 1, l_lu_line_util_id);
10627: DBMS_SQL.define_column(l_funds_util_csr, 2, l_lu_utilization_id);
10628: DBMS_SQL.define_column(l_funds_util_csr, 3, l_lu_amt);
10629: DBMS_SQL.define_column(l_funds_util_csr, 4, l_lu_scan_unit);
10630: DBMS_SQL.define_column(l_funds_util_csr, 5, l_lu_currency_code, 15);
10631: -- DBMS_SQL.define_column(l_funds_util_csr, 5, l_utiz_amount);
10632: FND_DSQL.do_binds;
10633:
10634: l_ignore := DBMS_SQL.execute(l_funds_util_csr);

Line 10631: -- DBMS_SQL.define_column(l_funds_util_csr, 5, l_utiz_amount);

10627: DBMS_SQL.define_column(l_funds_util_csr, 2, l_lu_utilization_id);
10628: DBMS_SQL.define_column(l_funds_util_csr, 3, l_lu_amt);
10629: DBMS_SQL.define_column(l_funds_util_csr, 4, l_lu_scan_unit);
10630: DBMS_SQL.define_column(l_funds_util_csr, 5, l_lu_currency_code, 15);
10631: -- DBMS_SQL.define_column(l_funds_util_csr, 5, l_utiz_amount);
10632: FND_DSQL.do_binds;
10633:
10634: l_ignore := DBMS_SQL.execute(l_funds_util_csr);
10635: --OPEN l_funds_util_csr FOR l_funds_util_sql;

Line 10634: l_ignore := DBMS_SQL.execute(l_funds_util_csr);

10630: DBMS_SQL.define_column(l_funds_util_csr, 5, l_lu_currency_code, 15);
10631: -- DBMS_SQL.define_column(l_funds_util_csr, 5, l_utiz_amount);
10632: FND_DSQL.do_binds;
10633:
10634: l_ignore := DBMS_SQL.execute(l_funds_util_csr);
10635: --OPEN l_funds_util_csr FOR l_funds_util_sql;
10636: LOOP
10637: /*
10638: FETCH l_funds_util_csr INTO l_lu_line_util_id

Line 10645: IF DBMS_SQL.fetch_rows(l_funds_util_csr) > 0 THEN

10641: , l_lu_scan_unit;
10642: EXIT WHEN l_funds_util_csr%NOTFOUND;
10643: */
10644:
10645: IF DBMS_SQL.fetch_rows(l_funds_util_csr) > 0 THEN
10646: DBMS_SQL.column_value(l_funds_util_csr, 1, l_lu_line_util_id);
10647: DBMS_SQL.column_value(l_funds_util_csr, 2, l_lu_utilization_id);
10648: DBMS_SQL.column_value(l_funds_util_csr, 3, l_lu_amt);
10649: DBMS_SQL.column_value(l_funds_util_csr, 4, l_lu_scan_unit);

Line 10646: DBMS_SQL.column_value(l_funds_util_csr, 1, l_lu_line_util_id);

10642: EXIT WHEN l_funds_util_csr%NOTFOUND;
10643: */
10644:
10645: IF DBMS_SQL.fetch_rows(l_funds_util_csr) > 0 THEN
10646: DBMS_SQL.column_value(l_funds_util_csr, 1, l_lu_line_util_id);
10647: DBMS_SQL.column_value(l_funds_util_csr, 2, l_lu_utilization_id);
10648: DBMS_SQL.column_value(l_funds_util_csr, 3, l_lu_amt);
10649: DBMS_SQL.column_value(l_funds_util_csr, 4, l_lu_scan_unit);
10650: DBMS_SQL.column_value(l_funds_util_csr, 5, l_lu_currency_code);

Line 10647: DBMS_SQL.column_value(l_funds_util_csr, 2, l_lu_utilization_id);

10643: */
10644:
10645: IF DBMS_SQL.fetch_rows(l_funds_util_csr) > 0 THEN
10646: DBMS_SQL.column_value(l_funds_util_csr, 1, l_lu_line_util_id);
10647: DBMS_SQL.column_value(l_funds_util_csr, 2, l_lu_utilization_id);
10648: DBMS_SQL.column_value(l_funds_util_csr, 3, l_lu_amt);
10649: DBMS_SQL.column_value(l_funds_util_csr, 4, l_lu_scan_unit);
10650: DBMS_SQL.column_value(l_funds_util_csr, 5, l_lu_currency_code);
10651: -- DBMS_SQL.define_column(l_funds_util_csr, 5, l_utiz_amount);

Line 10648: DBMS_SQL.column_value(l_funds_util_csr, 3, l_lu_amt);

10644:
10645: IF DBMS_SQL.fetch_rows(l_funds_util_csr) > 0 THEN
10646: DBMS_SQL.column_value(l_funds_util_csr, 1, l_lu_line_util_id);
10647: DBMS_SQL.column_value(l_funds_util_csr, 2, l_lu_utilization_id);
10648: DBMS_SQL.column_value(l_funds_util_csr, 3, l_lu_amt);
10649: DBMS_SQL.column_value(l_funds_util_csr, 4, l_lu_scan_unit);
10650: DBMS_SQL.column_value(l_funds_util_csr, 5, l_lu_currency_code);
10651: -- DBMS_SQL.define_column(l_funds_util_csr, 5, l_utiz_amount);
10652:

Line 10649: DBMS_SQL.column_value(l_funds_util_csr, 4, l_lu_scan_unit);

10645: IF DBMS_SQL.fetch_rows(l_funds_util_csr) > 0 THEN
10646: DBMS_SQL.column_value(l_funds_util_csr, 1, l_lu_line_util_id);
10647: DBMS_SQL.column_value(l_funds_util_csr, 2, l_lu_utilization_id);
10648: DBMS_SQL.column_value(l_funds_util_csr, 3, l_lu_amt);
10649: DBMS_SQL.column_value(l_funds_util_csr, 4, l_lu_scan_unit);
10650: DBMS_SQL.column_value(l_funds_util_csr, 5, l_lu_currency_code);
10651: -- DBMS_SQL.define_column(l_funds_util_csr, 5, l_utiz_amount);
10652:
10653: --If CLAIM and TRANSACTIONAL currencies are same, then l_utiz_amount will be

Line 10650: DBMS_SQL.column_value(l_funds_util_csr, 5, l_lu_currency_code);

10646: DBMS_SQL.column_value(l_funds_util_csr, 1, l_lu_line_util_id);
10647: DBMS_SQL.column_value(l_funds_util_csr, 2, l_lu_utilization_id);
10648: DBMS_SQL.column_value(l_funds_util_csr, 3, l_lu_amt);
10649: DBMS_SQL.column_value(l_funds_util_csr, 4, l_lu_scan_unit);
10650: DBMS_SQL.column_value(l_funds_util_csr, 5, l_lu_currency_code);
10651: -- DBMS_SQL.define_column(l_funds_util_csr, 5, l_utiz_amount);
10652:
10653: --If CLAIM and TRANSACTIONAL currencies are same, then l_utiz_amount will be
10654: --in TRANSACTIONAL currency otherwise it will be in FUNCTIONAL currency.

Line 10651: -- DBMS_SQL.define_column(l_funds_util_csr, 5, l_utiz_amount);

10647: DBMS_SQL.column_value(l_funds_util_csr, 2, l_lu_utilization_id);
10648: DBMS_SQL.column_value(l_funds_util_csr, 3, l_lu_amt);
10649: DBMS_SQL.column_value(l_funds_util_csr, 4, l_lu_scan_unit);
10650: DBMS_SQL.column_value(l_funds_util_csr, 5, l_lu_currency_code);
10651: -- DBMS_SQL.define_column(l_funds_util_csr, 5, l_utiz_amount);
10652:
10653: --If CLAIM and TRANSACTIONAL currencies are same, then l_utiz_amount will be
10654: --in TRANSACTIONAL currency otherwise it will be in FUNCTIONAL currency.
10655: --Changed for Claims Multicurrency ER.

Line 10716: DBMS_SQL.close_cursor(l_funds_util_csr);

10712: EXIT;
10713: END IF;
10714: END LOOP;
10715: --CLOSE l_funds_util_csr;
10716: DBMS_SQL.close_cursor(l_funds_util_csr);
10717: END IF; -- l_del_total_amount <> 0
10718:
10719: --------------------- 1. delete -----------------------
10720: i := l_line_util_tbl.FIRST;