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 9498: cur_handler := DBMS_SQL.OPEN_CURSOR;

9494: msc_util.msc_log(l_insert_stmt);
9495: msc_util.msc_log('After generating the SQL');
9496:
9497: -- Obtain cursor handler for sql_stmt
9498: cur_handler := DBMS_SQL.OPEN_CURSOR;
9499:
9500: DBMS_SQL.PARSE(cur_handler, l_insert_stmt, DBMS_SQL.NATIVE);
9501:
9502: msc_util.msc_log('After parsing the SQL');

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

9496:
9497: -- Obtain cursor handler for sql_stmt
9498: cur_handler := DBMS_SQL.OPEN_CURSOR;
9499:
9500: DBMS_SQL.PARSE(cur_handler, l_insert_stmt, DBMS_SQL.NATIVE);
9501:
9502: msc_util.msc_log('After parsing the SQL');
9503:
9504: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);

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

9500: DBMS_SQL.PARSE(cur_handler, l_insert_stmt, DBMS_SQL.NATIVE);
9501:
9502: msc_util.msc_log('After parsing the SQL');
9503:
9504: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9505: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9506:
9507: msc_util.msc_log('after binding the variables');
9508:

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

9501:
9502: msc_util.msc_log('After parsing the SQL');
9503:
9504: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9505: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9506:
9507: msc_util.msc_log('after binding the variables');
9508:
9509: -- Execute the cursor

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

9506:
9507: msc_util.msc_log('after binding the variables');
9508:
9509: -- Execute the cursor
9510: rows_processed := DBMS_SQL.EXECUTE(cur_handler);
9511:
9512: msc_util.msc_log('After executing the cursor');
9513:
9514: commit;

Line 9572: cur_handler := DBMS_SQL.OPEN_CURSOR;

9568: msc_util.msc_log('After generating Demands SQL1');
9569: msc_util.msc_log(l_sql_stmt_1);
9570:
9571: -- Obtain cursor handler for sql_stmt
9572: cur_handler := DBMS_SQL.OPEN_CURSOR;
9573:
9574: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);
9575: msc_util.msc_log('After parsing Demands SQL1');
9576:

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

9570:
9571: -- Obtain cursor handler for sql_stmt
9572: cur_handler := DBMS_SQL.OPEN_CURSOR;
9573:
9574: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);
9575: msc_util.msc_log('After parsing Demands SQL1');
9576:
9577: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
9578: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);

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

9573:
9574: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);
9575: msc_util.msc_log('After parsing Demands SQL1');
9576:
9577: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
9578: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
9579: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9580: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9581: IF p_demand_priority = 'Y' THEN

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

9574: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);
9575: msc_util.msc_log('After parsing Demands SQL1');
9576:
9577: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
9578: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
9579: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9580: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9581: IF p_demand_priority = 'Y' THEN
9582: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);

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

9575: msc_util.msc_log('After parsing Demands SQL1');
9576:
9577: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
9578: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
9579: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9580: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9581: IF p_demand_priority = 'Y' THEN
9582: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9583: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);

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

9576:
9577: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
9578: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
9579: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9580: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9581: IF p_demand_priority = 'Y' THEN
9582: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9583: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);
9584: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');

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

9578: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
9579: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9580: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9581: IF p_demand_priority = 'Y' THEN
9582: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9583: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);
9584: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
9585: END IF;
9586: msc_util.msc_log('after binding the variables');

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

9579: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9580: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9581: IF p_demand_priority = 'Y' THEN
9582: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9583: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);
9584: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
9585: END IF;
9586: msc_util.msc_log('after binding the variables');
9587:

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

9580: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9581: IF p_demand_priority = 'Y' THEN
9582: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9583: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);
9584: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
9585: END IF;
9586: msc_util.msc_log('after binding the variables');
9587:
9588: -- Execute the cursor

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

9585: END IF;
9586: msc_util.msc_log('after binding the variables');
9587:
9588: -- Execute the cursor
9589: rows_processed := DBMS_SQL.EXECUTE(cur_handler);
9590: msc_util.msc_log('After executing the cursor');
9591:
9592: msc_util.msc_log('rows processed: ' || rows_processed);
9593: msc_util.msc_log('after inserting item data into MSC_ALLOC_DEMANDS tables');

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

9611: msc_util.msc_log('After Generating Supplies SQL1');
9612:
9613: -- Parse cursor handler for sql_stmt: Don't open as its already opened
9614:
9615: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);
9616: msc_util.msc_log('After parsing Supplies SQL1');
9617:
9618: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
9619: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);

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

9614:
9615: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);
9616: msc_util.msc_log('After parsing Supplies SQL1');
9617:
9618: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
9619: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
9620: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9621: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9622: IF p_demand_priority = 'Y' THEN

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

9615: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);
9616: msc_util.msc_log('After parsing Supplies SQL1');
9617:
9618: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
9619: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
9620: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9621: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9622: IF p_demand_priority = 'Y' THEN
9623: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);

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

9616: msc_util.msc_log('After parsing Supplies SQL1');
9617:
9618: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
9619: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
9620: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9621: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9622: IF p_demand_priority = 'Y' THEN
9623: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9624: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);

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

9617:
9618: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
9619: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
9620: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9621: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9622: IF p_demand_priority = 'Y' THEN
9623: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9624: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);
9625: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');

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

9619: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
9620: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9621: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9622: IF p_demand_priority = 'Y' THEN
9623: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9624: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);
9625: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
9626: END IF;
9627: /* forecast at PF changes end*/

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

9620: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9621: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9622: IF p_demand_priority = 'Y' THEN
9623: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9624: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);
9625: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
9626: END IF;
9627: /* forecast at PF changes end*/
9628:

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

9621: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9622: IF p_demand_priority = 'Y' THEN
9623: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9624: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);
9625: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
9626: END IF;
9627: /* forecast at PF changes end*/
9628:
9629: msc_util.msc_log('after binding the variables');

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

9628:
9629: msc_util.msc_log('after binding the variables');
9630:
9631: -- Execute the cursor
9632: rows_processed := DBMS_SQL.EXECUTE(cur_handler);
9633: msc_util.msc_log('After executing first supplies cursor');
9634:
9635: msc_util.msc_log('rows processed: ' || rows_processed);
9636: msc_util.msc_log('after inserting item data into MSC_ALLOC_SUPPLIES tables');

Line 9767: cur_handler := DBMS_SQL.OPEN_CURSOR;

9763: msc_util.msc_log(l_sql_stmt_1);
9764: msc_util.msc_log('After generating Demands SQL1');
9765:
9766: -- Obtain cursor handler for sql_stmt
9767: cur_handler := DBMS_SQL.OPEN_CURSOR;
9768:
9769: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);
9770: msc_util.msc_log('After parsing Demands SQL1');
9771:

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

9765:
9766: -- Obtain cursor handler for sql_stmt
9767: cur_handler := DBMS_SQL.OPEN_CURSOR;
9768:
9769: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);
9770: msc_util.msc_log('After parsing Demands SQL1');
9771:
9772: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
9773: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);

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

9768:
9769: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);
9770: msc_util.msc_log('After parsing Demands SQL1');
9771:
9772: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
9773: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
9774: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9775: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9776: IF p_demand_priority = 'Y' THEN

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

9769: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);
9770: msc_util.msc_log('After parsing Demands SQL1');
9771:
9772: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
9773: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
9774: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9775: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9776: IF p_demand_priority = 'Y' THEN
9777: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);

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

9770: msc_util.msc_log('After parsing Demands SQL1');
9771:
9772: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
9773: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
9774: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9775: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9776: IF p_demand_priority = 'Y' THEN
9777: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9778: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);

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

9771:
9772: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
9773: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
9774: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9775: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9776: IF p_demand_priority = 'Y' THEN
9777: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9778: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);
9779: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');

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

9773: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
9774: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9775: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9776: IF p_demand_priority = 'Y' THEN
9777: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9778: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);
9779: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
9780: END IF;
9781: /* forecast at PF changes end*/

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

9774: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9775: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9776: IF p_demand_priority = 'Y' THEN
9777: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9778: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);
9779: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
9780: END IF;
9781: /* forecast at PF changes end*/
9782:

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

9775: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9776: IF p_demand_priority = 'Y' THEN
9777: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9778: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);
9779: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
9780: END IF;
9781: /* forecast at PF changes end*/
9782:
9783: msc_util.msc_log('after binding the variables');

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

9782:
9783: msc_util.msc_log('after binding the variables');
9784:
9785: -- Execute the cursor
9786: rows_processed := DBMS_SQL.EXECUTE(cur_handler);
9787: msc_util.msc_log('After executing the cursor');
9788: msc_util.msc_log('after inserting item data into MSC_TEMP_ALLOC_DEMANDS table');
9789:
9790: commit;

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

9949: msc_util.msc_log('After Generating Supplies SQL1');
9950:
9951: -- Parse cursor handler for sql_stmt: Don't open as its already opened
9952:
9953: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);
9954: msc_util.msc_log('After parsing Supplies SQL1');
9955:
9956: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
9957: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);

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

9952:
9953: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);
9954: msc_util.msc_log('After parsing Supplies SQL1');
9955:
9956: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
9957: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
9958: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9959: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9960: IF p_demand_priority = 'Y' THEN

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

9953: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);
9954: msc_util.msc_log('After parsing Supplies SQL1');
9955:
9956: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
9957: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
9958: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9959: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9960: IF p_demand_priority = 'Y' THEN
9961: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);

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

9954: msc_util.msc_log('After parsing Supplies SQL1');
9955:
9956: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
9957: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
9958: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9959: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9960: IF p_demand_priority = 'Y' THEN
9961: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9962: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);

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

9955:
9956: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
9957: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
9958: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9959: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9960: IF p_demand_priority = 'Y' THEN
9961: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9962: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);
9963: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');

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

9957: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
9958: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9959: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9960: IF p_demand_priority = 'Y' THEN
9961: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9962: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);
9963: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
9964: END IF;
9965: /* forecast at PF changes end*/

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

9958: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
9959: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9960: IF p_demand_priority = 'Y' THEN
9961: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9962: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);
9963: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
9964: END IF;
9965: /* forecast at PF changes end*/
9966:

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

9959: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_yes', l_yes);
9960: IF p_demand_priority = 'Y' THEN
9961: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_excess_dc', l_excess_dc);
9962: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_excess_supply_by_dc', l_excess_supply_by_dc);
9963: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
9964: END IF;
9965: /* forecast at PF changes end*/
9966:
9967: msc_util.msc_log('after binding the variables');

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

9966:
9967: msc_util.msc_log('after binding the variables');
9968:
9969: -- Execute the cursor
9970: rows_processed := DBMS_SQL.EXECUTE(cur_handler);
9971: msc_util.msc_log('After executing first supplies cursor');
9972: msc_util.msc_log('after inserting item data into MSC_TEMP_ALLOC_SUPPLIES table');
9973:
9974: commit;