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

Line 9472: cur_handler := DBMS_SQL.OPEN_CURSOR;

9468: msc_util.msc_log(l_insert_stmt);
9469: msc_util.msc_log('After generating the SQL');
9470:
9471: -- Obtain cursor handler for sql_stmt
9472: cur_handler := DBMS_SQL.OPEN_CURSOR;
9473:
9474: DBMS_SQL.PARSE(cur_handler, l_insert_stmt, DBMS_SQL.NATIVE);
9475:
9476: msc_util.msc_log('After parsing the SQL');

Line 9474: DBMS_SQL.PARSE(cur_handler, l_insert_stmt, DBMS_SQL.NATIVE);

9470:
9471: -- Obtain cursor handler for sql_stmt
9472: cur_handler := DBMS_SQL.OPEN_CURSOR;
9473:
9474: DBMS_SQL.PARSE(cur_handler, l_insert_stmt, DBMS_SQL.NATIVE);
9475:
9476: msc_util.msc_log('After parsing the SQL');
9477:
9478: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);

Line 9478: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);

9474: DBMS_SQL.PARSE(cur_handler, l_insert_stmt, DBMS_SQL.NATIVE);
9475:
9476: msc_util.msc_log('After parsing the SQL');
9477:
9478: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9479: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9480:
9481: msc_util.msc_log('after binding the variables');
9482:

Line 9479: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);

9475:
9476: msc_util.msc_log('After parsing the SQL');
9477:
9478: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9479: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9480:
9481: msc_util.msc_log('after binding the variables');
9482:
9483: -- Execute the cursor

Line 9484: rows_processed := DBMS_SQL.EXECUTE(cur_handler);

9480:
9481: msc_util.msc_log('after binding the variables');
9482:
9483: -- Execute the cursor
9484: rows_processed := DBMS_SQL.EXECUTE(cur_handler);
9485:
9486: msc_util.msc_log('After executing the cursor');
9487:
9488: commit;

Line 9546: cur_handler := DBMS_SQL.OPEN_CURSOR;

9542: msc_util.msc_log('After generating Demands SQL1');
9543: msc_util.msc_log(l_sql_stmt_1);
9544:
9545: -- Obtain cursor handler for sql_stmt
9546: cur_handler := DBMS_SQL.OPEN_CURSOR;
9547:
9548: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);
9549: msc_util.msc_log('After parsing Demands SQL1');
9550:

Line 9548: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);

9544:
9545: -- Obtain cursor handler for sql_stmt
9546: cur_handler := DBMS_SQL.OPEN_CURSOR;
9547:
9548: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);
9549: msc_util.msc_log('After parsing Demands SQL1');
9550:
9551: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
9552: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);

Line 9551: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);

9547:
9548: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);
9549: msc_util.msc_log('After parsing Demands SQL1');
9550:
9551: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
9552: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
9553: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9554: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9555: IF p_demand_priority = 'Y' THEN

Line 9552: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);

9548: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);
9549: msc_util.msc_log('After parsing Demands SQL1');
9550:
9551: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
9552: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
9553: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9554: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9555: IF p_demand_priority = 'Y' THEN
9556: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);

Line 9553: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);

9549: msc_util.msc_log('After parsing Demands SQL1');
9550:
9551: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
9552: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
9553: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9554: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9555: IF p_demand_priority = 'Y' THEN
9556: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9557: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);

Line 9554: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);

9550:
9551: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
9552: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
9553: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9554: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9555: IF p_demand_priority = 'Y' THEN
9556: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9557: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);
9558: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');

Line 9556: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);

9552: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
9553: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9554: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9555: IF p_demand_priority = 'Y' THEN
9556: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9557: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);
9558: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
9559: END IF;
9560: msc_util.msc_log('after binding the variables');

Line 9557: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);

9553: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9554: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9555: IF p_demand_priority = 'Y' THEN
9556: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9557: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);
9558: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
9559: END IF;
9560: msc_util.msc_log('after binding the variables');
9561:

Line 9558: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');

9554: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9555: IF p_demand_priority = 'Y' THEN
9556: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9557: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);
9558: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
9559: END IF;
9560: msc_util.msc_log('after binding the variables');
9561:
9562: -- Execute the cursor

Line 9563: rows_processed := DBMS_SQL.EXECUTE(cur_handler);

9559: END IF;
9560: msc_util.msc_log('after binding the variables');
9561:
9562: -- Execute the cursor
9563: rows_processed := DBMS_SQL.EXECUTE(cur_handler);
9564: msc_util.msc_log('After executing the cursor');
9565:
9566: msc_util.msc_log('rows processed: ' || rows_processed);
9567: msc_util.msc_log('after inserting item data into MSC_ALLOC_DEMANDS tables');

Line 9589: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);

9585: msc_util.msc_log('After Generating Supplies SQL1');
9586:
9587: -- Parse cursor handler for sql_stmt: Don't open as its already opened
9588:
9589: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);
9590: msc_util.msc_log('After parsing Supplies SQL1');
9591:
9592: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
9593: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);

Line 9592: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);

9588:
9589: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);
9590: msc_util.msc_log('After parsing Supplies SQL1');
9591:
9592: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
9593: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
9594: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9595: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9596: IF p_demand_priority = 'Y' THEN

Line 9593: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);

9589: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);
9590: msc_util.msc_log('After parsing Supplies SQL1');
9591:
9592: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
9593: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
9594: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9595: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9596: IF p_demand_priority = 'Y' THEN
9597: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);

Line 9594: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);

9590: msc_util.msc_log('After parsing Supplies SQL1');
9591:
9592: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
9593: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
9594: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9595: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9596: IF p_demand_priority = 'Y' THEN
9597: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9598: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);

Line 9595: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);

9591:
9592: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
9593: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
9594: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9595: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9596: IF p_demand_priority = 'Y' THEN
9597: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9598: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);
9599: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');

Line 9597: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);

9593: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
9594: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9595: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9596: IF p_demand_priority = 'Y' THEN
9597: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9598: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);
9599: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
9600: END IF;
9601: /* forecast at PF changes end*/

Line 9598: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);

9594: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9595: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9596: IF p_demand_priority = 'Y' THEN
9597: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9598: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);
9599: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
9600: END IF;
9601: /* forecast at PF changes end*/
9602:

Line 9599: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');

9595: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9596: IF p_demand_priority = 'Y' THEN
9597: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9598: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);
9599: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
9600: END IF;
9601: /* forecast at PF changes end*/
9602:
9603: msc_util.msc_log('after binding the variables');

Line 9606: rows_processed := DBMS_SQL.EXECUTE(cur_handler);

9602:
9603: msc_util.msc_log('after binding the variables');
9604:
9605: -- Execute the cursor
9606: rows_processed := DBMS_SQL.EXECUTE(cur_handler);
9607: msc_util.msc_log('After executing first supplies cursor');
9608:
9609: msc_util.msc_log('rows processed: ' || rows_processed);
9610: msc_util.msc_log('after inserting item data into MSC_ALLOC_SUPPLIES tables');

Line 9741: cur_handler := DBMS_SQL.OPEN_CURSOR;

9737: msc_util.msc_log(l_sql_stmt_1);
9738: msc_util.msc_log('After generating Demands SQL1');
9739:
9740: -- Obtain cursor handler for sql_stmt
9741: cur_handler := DBMS_SQL.OPEN_CURSOR;
9742:
9743: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);
9744: msc_util.msc_log('After parsing Demands SQL1');
9745:

Line 9743: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);

9739:
9740: -- Obtain cursor handler for sql_stmt
9741: cur_handler := DBMS_SQL.OPEN_CURSOR;
9742:
9743: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);
9744: msc_util.msc_log('After parsing Demands SQL1');
9745:
9746: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
9747: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);

Line 9746: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);

9742:
9743: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);
9744: msc_util.msc_log('After parsing Demands SQL1');
9745:
9746: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
9747: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
9748: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9749: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9750: IF p_demand_priority = 'Y' THEN

Line 9747: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);

9743: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);
9744: msc_util.msc_log('After parsing Demands SQL1');
9745:
9746: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
9747: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
9748: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9749: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9750: IF p_demand_priority = 'Y' THEN
9751: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);

Line 9748: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);

9744: msc_util.msc_log('After parsing Demands SQL1');
9745:
9746: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
9747: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
9748: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9749: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9750: IF p_demand_priority = 'Y' THEN
9751: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9752: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);

Line 9749: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);

9745:
9746: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
9747: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
9748: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9749: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9750: IF p_demand_priority = 'Y' THEN
9751: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9752: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);
9753: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');

Line 9751: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);

9747: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
9748: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9749: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9750: IF p_demand_priority = 'Y' THEN
9751: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9752: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);
9753: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
9754: END IF;
9755: /* forecast at PF changes end*/

Line 9752: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);

9748: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9749: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9750: IF p_demand_priority = 'Y' THEN
9751: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9752: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);
9753: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
9754: END IF;
9755: /* forecast at PF changes end*/
9756:

Line 9753: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');

9749: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9750: IF p_demand_priority = 'Y' THEN
9751: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9752: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);
9753: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
9754: END IF;
9755: /* forecast at PF changes end*/
9756:
9757: msc_util.msc_log('after binding the variables');

Line 9760: rows_processed := DBMS_SQL.EXECUTE(cur_handler);

9756:
9757: msc_util.msc_log('after binding the variables');
9758:
9759: -- Execute the cursor
9760: rows_processed := DBMS_SQL.EXECUTE(cur_handler);
9761: msc_util.msc_log('After executing the cursor');
9762: msc_util.msc_log('after inserting item data into MSC_TEMP_ALLOC_DEMANDS table');
9763:
9764: commit;

Line 9927: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);

9923: msc_util.msc_log('After Generating Supplies SQL1');
9924:
9925: -- Parse cursor handler for sql_stmt: Don't open as its already opened
9926:
9927: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);
9928: msc_util.msc_log('After parsing Supplies SQL1');
9929:
9930: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
9931: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);

Line 9930: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);

9926:
9927: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);
9928: msc_util.msc_log('After parsing Supplies SQL1');
9929:
9930: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
9931: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
9932: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9933: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9934: IF p_demand_priority = 'Y' THEN

Line 9931: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);

9927: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);
9928: msc_util.msc_log('After parsing Supplies SQL1');
9929:
9930: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
9931: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
9932: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9933: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9934: IF p_demand_priority = 'Y' THEN
9935: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);

Line 9932: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);

9928: msc_util.msc_log('After parsing Supplies SQL1');
9929:
9930: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
9931: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
9932: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9933: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9934: IF p_demand_priority = 'Y' THEN
9935: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9936: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);

Line 9933: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);

9929:
9930: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
9931: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
9932: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9933: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9934: IF p_demand_priority = 'Y' THEN
9935: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9936: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);
9937: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');

Line 9935: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);

9931: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
9932: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9933: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9934: IF p_demand_priority = 'Y' THEN
9935: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9936: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);
9937: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
9938: END IF;
9939: /* forecast at PF changes end*/

Line 9936: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);

9932: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9933: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9934: IF p_demand_priority = 'Y' THEN
9935: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9936: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);
9937: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
9938: END IF;
9939: /* forecast at PF changes end*/
9940:

Line 9937: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');

9933: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9934: IF p_demand_priority = 'Y' THEN
9935: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9936: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);
9937: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
9938: END IF;
9939: /* forecast at PF changes end*/
9940:
9941: msc_util.msc_log('after binding the variables');

Line 9944: rows_processed := DBMS_SQL.EXECUTE(cur_handler);

9940:
9941: msc_util.msc_log('after binding the variables');
9942:
9943: -- Execute the cursor
9944: rows_processed := DBMS_SQL.EXECUTE(cur_handler);
9945: msc_util.msc_log('After executing first supplies cursor');
9946: msc_util.msc_log('after inserting item data into MSC_TEMP_ALLOC_SUPPLIES table');
9947:
9948: commit;