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_POST_PRO dependencies on DBMS_SQL

Line 4475: cur_handler := DBMS_SQL.OPEN_CURSOR;

4471: -- UNION ALL
4472: msc_util.msc_log('After Generating the sql');
4473:
4474: -- Obtain cursor handler for sql_stmt
4475: cur_handler := DBMS_SQL.OPEN_CURSOR;
4476:
4477: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);
4478: msc_util.msc_log('After parsing the sql');
4479:

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

4473:
4474: -- Obtain cursor handler for sql_stmt
4475: cur_handler := DBMS_SQL.OPEN_CURSOR;
4476:
4477: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);
4478: msc_util.msc_log('After parsing the sql');
4479:
4480: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
4481: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);

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

4476:
4477: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);
4478: msc_util.msc_log('After parsing the sql');
4479:
4480: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
4481: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
4482: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
4483: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
4484: msc_util.msc_log('after binding the variables');

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

4477: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);
4478: msc_util.msc_log('After parsing the sql');
4479:
4480: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
4481: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
4482: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
4483: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
4484: msc_util.msc_log('after binding the variables');
4485:

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

4478: msc_util.msc_log('After parsing the sql');
4479:
4480: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
4481: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
4482: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
4483: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
4484: msc_util.msc_log('after binding the variables');
4485:
4486: -- Execute the cursor

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

4479:
4480: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
4481: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
4482: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
4483: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
4484: msc_util.msc_log('after binding the variables');
4485:
4486: -- Execute the cursor
4487: rows_processed := DBMS_SQL.EXECUTE(cur_handler);

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

4483: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
4484: msc_util.msc_log('after binding the variables');
4485:
4486: -- Execute the cursor
4487: rows_processed := DBMS_SQL.EXECUTE(cur_handler);
4488: msc_util.msc_log('After executing the cursor');
4489:
4490: msc_util.msc_log('rows processed: ' || rows_processed);
4491: msc_util.msc_log('After inserting in msc_alloc_demands part 1');

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

4723: msc_util.msc_log('After Generating the sql');
4724:
4725: -- Parse cursor handler for sql_stmt: Don't open as its already opened
4726:
4727: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);
4728: msc_util.msc_log('After parsing the sql');
4729:
4730: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
4731: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);

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

4726:
4727: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);
4728: msc_util.msc_log('After parsing the sql');
4729:
4730: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
4731: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
4732: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
4733: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
4734: msc_util.msc_log('after binding the variables');

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

4727: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);
4728: msc_util.msc_log('After parsing the sql');
4729:
4730: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
4731: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
4732: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
4733: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
4734: msc_util.msc_log('after binding the variables');
4735:

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

4728: msc_util.msc_log('After parsing the sql');
4729:
4730: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
4731: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
4732: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
4733: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
4734: msc_util.msc_log('after binding the variables');
4735:
4736: -- Execute the cursor

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

4729:
4730: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
4731: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
4732: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
4733: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
4734: msc_util.msc_log('after binding the variables');
4735:
4736: -- Execute the cursor
4737: rows_processed := DBMS_SQL.EXECUTE(cur_handler);

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

4733: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
4734: msc_util.msc_log('after binding the variables');
4735:
4736: -- Execute the cursor
4737: rows_processed := DBMS_SQL.EXECUTE(cur_handler);
4738: msc_util.msc_log('After executing the cursor');
4739:
4740: msc_util.msc_log('rows processed: ' || rows_processed);
4741: msc_util.msc_log('after inserting item data into MSC_ALLOC_DEMANDS tables');

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

4853: msc_util.msc_log('After Generating first supplies sql');
4854:
4855: -- Parse cursor handler for sql_stmt: Don't open as its already opened
4856:
4857: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);
4858: msc_util.msc_log('After parsing first supplies sql');
4859:
4860: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
4861: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);

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

4856:
4857: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);
4858: msc_util.msc_log('After parsing first supplies sql');
4859:
4860: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
4861: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
4862: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
4863: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
4864: msc_util.msc_log('after binding the variables');

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

4857: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);
4858: msc_util.msc_log('After parsing first supplies sql');
4859:
4860: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
4861: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
4862: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
4863: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
4864: msc_util.msc_log('after binding the variables');
4865:

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

4858: msc_util.msc_log('After parsing first supplies sql');
4859:
4860: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
4861: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
4862: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
4863: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
4864: msc_util.msc_log('after binding the variables');
4865:
4866: -- Execute the cursor

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

4859:
4860: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
4861: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
4862: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
4863: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
4864: msc_util.msc_log('after binding the variables');
4865:
4866: -- Execute the cursor
4867: rows_processed := DBMS_SQL.EXECUTE(cur_handler);

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

4863: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
4864: msc_util.msc_log('after binding the variables');
4865:
4866: -- Execute the cursor
4867: rows_processed := DBMS_SQL.EXECUTE(cur_handler);
4868: msc_util.msc_log('After executing first supplies cursor');
4869:
4870: msc_util.msc_log('rows processed: ' || rows_processed);
4871:

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

5056: msc_util.msc_log('After Generating second supplies sql');
5057:
5058: -- Parse cursor handler for sql_stmt: Don't open as its already opened
5059:
5060: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);
5061: msc_util.msc_log('After parsing second supplies sql');
5062:
5063: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
5064: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);

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

5059:
5060: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);
5061: msc_util.msc_log('After parsing second supplies sql');
5062:
5063: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
5064: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
5065: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
5066: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
5067: msc_util.msc_log('after binding the variables');

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

5060: DBMS_SQL.PARSE(cur_handler, l_sql_stmt_1, DBMS_SQL.NATIVE);
5061: msc_util.msc_log('After parsing second supplies sql');
5062:
5063: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
5064: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
5065: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
5066: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
5067: msc_util.msc_log('after binding the variables');
5068:

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

5061: msc_util.msc_log('After parsing second supplies sql');
5062:
5063: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
5064: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
5065: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
5066: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
5067: msc_util.msc_log('after binding the variables');
5068:
5069: -- Execute the cursor

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

5062:
5063: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
5064: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
5065: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
5066: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
5067: msc_util.msc_log('after binding the variables');
5068:
5069: -- Execute the cursor
5070: rows_processed := DBMS_SQL.EXECUTE(cur_handler);

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

5066: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
5067: msc_util.msc_log('after binding the variables');
5068:
5069: -- Execute the cursor
5070: rows_processed := DBMS_SQL.EXECUTE(cur_handler);
5071: msc_util.msc_log('After executing second supplies cursor');
5072:
5073: msc_util.msc_log('rows processed: ' || rows_processed);
5074: msc_util.msc_log('After inserting in msc_alloc_supplies part 2');

Line 5336: cur_handler := DBMS_SQL.OPEN_CURSOR;

5332:
5333: msc_util.msc_log('After Generating the sql');
5334:
5335: -- Obtain cursor handler for sql_stmt
5336: cur_handler := DBMS_SQL.OPEN_CURSOR;
5337:
5338: DBMS_SQL.PARSE(cur_handler, l_insert_stmt, DBMS_SQL.NATIVE);
5339: msc_util.msc_log('After parsing the sql');
5340:

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

5334:
5335: -- Obtain cursor handler for sql_stmt
5336: cur_handler := DBMS_SQL.OPEN_CURSOR;
5337:
5338: DBMS_SQL.PARSE(cur_handler, l_insert_stmt, DBMS_SQL.NATIVE);
5339: msc_util.msc_log('After parsing the sql');
5340:
5341: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
5342: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);

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

5337:
5338: DBMS_SQL.PARSE(cur_handler, l_insert_stmt, DBMS_SQL.NATIVE);
5339: msc_util.msc_log('After parsing the sql');
5340:
5341: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
5342: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
5343: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
5344: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
5345:

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

5338: DBMS_SQL.PARSE(cur_handler, l_insert_stmt, DBMS_SQL.NATIVE);
5339: msc_util.msc_log('After parsing the sql');
5340:
5341: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
5342: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
5343: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
5344: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
5345:
5346: msc_util.msc_log('after binding the variables');

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

5339: msc_util.msc_log('After parsing the sql');
5340:
5341: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
5342: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
5343: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
5344: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
5345:
5346: msc_util.msc_log('after binding the variables');
5347:

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

5340:
5341: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
5342: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
5343: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
5344: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
5345:
5346: msc_util.msc_log('after binding the variables');
5347:
5348: -- Execute the cursor

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

5345:
5346: msc_util.msc_log('after binding the variables');
5347:
5348: -- Execute the cursor
5349: rows_processed := DBMS_SQL.EXECUTE(cur_handler);
5350: msc_util.msc_log('After executing the cursor');
5351:
5352: -- parallel hint can't be used with union all. Use two query instead */
5353:

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

5574: msc_util.msc_log('After Generating the sql');
5575:
5576: -- Parse cursor handler for sql_stmt: Don't open as its already opened
5577:
5578: DBMS_SQL.PARSE(cur_handler, l_insert_stmt, DBMS_SQL.NATIVE);
5579: msc_util.msc_log('After parsing the sql');
5580:
5581: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
5582: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);

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

5577:
5578: DBMS_SQL.PARSE(cur_handler, l_insert_stmt, DBMS_SQL.NATIVE);
5579: msc_util.msc_log('After parsing the sql');
5580:
5581: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
5582: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
5583: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
5584: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
5585: msc_util.msc_log('after binding the variables');

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

5578: DBMS_SQL.PARSE(cur_handler, l_insert_stmt, DBMS_SQL.NATIVE);
5579: msc_util.msc_log('After parsing the sql');
5580:
5581: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
5582: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
5583: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
5584: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
5585: msc_util.msc_log('after binding the variables');
5586:

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

5579: msc_util.msc_log('After parsing the sql');
5580:
5581: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
5582: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
5583: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
5584: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
5585: msc_util.msc_log('after binding the variables');
5586:
5587: -- Execute the cursor

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

5580:
5581: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
5582: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
5583: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
5584: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
5585: msc_util.msc_log('after binding the variables');
5586:
5587: -- Execute the cursor
5588: rows_processed := DBMS_SQL.EXECUTE(cur_handler);

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

5584: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
5585: msc_util.msc_log('after binding the variables');
5586:
5587: -- Execute the cursor
5588: rows_processed := DBMS_SQL.EXECUTE(cur_handler);
5589: msc_util.msc_log('After executing the cursor');
5590:
5591: msc_util.msc_log('after inserting item data into MSC_TEMP_ALLOC_DEMANDS table');
5592:

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

5850: msc_util.msc_log('After Generating first supplies sql');
5851:
5852: -- Parse cursor handler for sql_stmt: Don't open as its already opened
5853:
5854: DBMS_SQL.PARSE(cur_handler, l_insert_stmt, DBMS_SQL.NATIVE);
5855: msc_util.msc_log('After parsing first supplies sql');
5856:
5857: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
5858: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);

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

5853:
5854: DBMS_SQL.PARSE(cur_handler, l_insert_stmt, DBMS_SQL.NATIVE);
5855: msc_util.msc_log('After parsing first supplies sql');
5856:
5857: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
5858: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
5859: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
5860: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
5861: msc_util.msc_log('after binding the variables');

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

5854: DBMS_SQL.PARSE(cur_handler, l_insert_stmt, DBMS_SQL.NATIVE);
5855: msc_util.msc_log('After parsing first supplies sql');
5856:
5857: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
5858: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
5859: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
5860: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
5861: msc_util.msc_log('after binding the variables');
5862:

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

5855: msc_util.msc_log('After parsing first supplies sql');
5856:
5857: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
5858: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
5859: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
5860: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
5861: msc_util.msc_log('after binding the variables');
5862:
5863: -- Execute the cursor

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

5856:
5857: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
5858: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
5859: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
5860: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
5861: msc_util.msc_log('after binding the variables');
5862:
5863: -- Execute the cursor
5864: rows_processed := DBMS_SQL.EXECUTE(cur_handler);

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

5860: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
5861: msc_util.msc_log('after binding the variables');
5862:
5863: -- Execute the cursor
5864: rows_processed := DBMS_SQL.EXECUTE(cur_handler);
5865: msc_util.msc_log('After executing first supplies cursor');
5866:
5867: msc_util.msc_log('After inserting in msc_alloc_supplies part 1');
5868:

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

6053: msc_util.msc_log('After Generating second supplies sql');
6054:
6055: -- Parse cursor handler for sql_stmt: Don't open as its already opened
6056:
6057: DBMS_SQL.PARSE(cur_handler, l_insert_stmt, DBMS_SQL.NATIVE);
6058: msc_util.msc_log('After parsing second supplies sql');
6059:
6060: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
6061: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);

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

6056:
6057: DBMS_SQL.PARSE(cur_handler, l_insert_stmt, DBMS_SQL.NATIVE);
6058: msc_util.msc_log('After parsing second supplies sql');
6059:
6060: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
6061: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
6062: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
6063: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
6064: msc_util.msc_log('after binding the variables');

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

6057: DBMS_SQL.PARSE(cur_handler, l_insert_stmt, DBMS_SQL.NATIVE);
6058: msc_util.msc_log('After parsing second supplies sql');
6059:
6060: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
6061: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
6062: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
6063: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
6064: msc_util.msc_log('after binding the variables');
6065:

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

6058: msc_util.msc_log('After parsing second supplies sql');
6059:
6060: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
6061: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
6062: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
6063: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
6064: msc_util.msc_log('after binding the variables');
6065:
6066: -- Execute the cursor

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

6059:
6060: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_user_id', l_user_id);
6061: DBMS_SQL.BIND_VARIABLE(cur_handler, ':l_sysdate', l_sysdate);
6062: DBMS_SQL.BIND_VARIABLE(cur_handler, ':p_plan_id', p_plan_id);
6063: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
6064: msc_util.msc_log('after binding the variables');
6065:
6066: -- Execute the cursor
6067: rows_processed := DBMS_SQL.EXECUTE(cur_handler);

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

6063: DBMS_SQL.BIND_VARIABLE(cur_handler, ':def_num', '-1');
6064: msc_util.msc_log('after binding the variables');
6065:
6066: -- Execute the cursor
6067: rows_processed := DBMS_SQL.EXECUTE(cur_handler);
6068: msc_util.msc_log('After executing second supplies cursor');
6069:
6070: msc_util.msc_log('After inserting in msc_alloc_supplies part 2');
6071: commit;