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

Line 3407: l_query_handle := DBMS_SQL.open_cursor;

3403: || l_select_generic
3404: || l_from_generic
3405: || l_where_generic;
3406: -- Parse, Bind and Execute the dynamic query
3407: l_query_handle := DBMS_SQL.open_cursor;
3408: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
3409:
3410: IF p_from_task_quantity IS NOT NULL
3411: THEN

Line 3408: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);

3404: || l_from_generic
3405: || l_where_generic;
3406: -- Parse, Bind and Execute the dynamic query
3407: l_query_handle := DBMS_SQL.open_cursor;
3408: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
3409:
3410: IF p_from_task_quantity IS NOT NULL
3411: THEN
3412: DBMS_SQL.bind_variable (l_query_handle,

Line 3412: DBMS_SQL.bind_variable (l_query_handle,

3408: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
3409:
3410: IF p_from_task_quantity IS NOT NULL
3411: THEN
3412: DBMS_SQL.bind_variable (l_query_handle,
3413: 'from_task_quantity',
3414: p_from_task_quantity
3415: );
3416: END IF;

Line 3420: DBMS_SQL.bind_variable (l_query_handle,

3416: END IF;
3417:
3418: IF p_to_task_quantity IS NOT NULL
3419: THEN
3420: DBMS_SQL.bind_variable (l_query_handle,
3421: 'to_task_quantity',
3422: p_to_task_quantity
3423: );
3424: END IF;

Line 3428: DBMS_SQL.bind_variable (l_query_handle,

3424: END IF;
3425:
3426: /* Bug 5446146 */
3427: IF p_person_id IS NOT NULL THEN
3428: DBMS_SQL.bind_variable (l_query_handle,
3429: 'person_id',
3430: p_person_id);
3431: END IF;
3432:

Line 3434: DBMS_SQL.bind_variable (l_query_handle,

3430: p_person_id);
3431: END IF;
3432:
3433: IF p_person_resource_id IS NOT NULL THEN
3434: DBMS_SQL.bind_variable (l_query_handle,
3435: 'person_resource_id',
3436: p_person_resource_id);
3437: END IF;
3438:

Line 3440: DBMS_SQL.bind_variable (l_query_handle,

3436: p_person_resource_id);
3437: END IF;
3438:
3439: IF p_equipment_type_id IS NOT NULL THEN
3440: DBMS_SQL.bind_variable (l_query_handle,
3441: 'equipment_type_id',
3442: p_equipment_type_id
3443: );
3444: END IF;

Line 3447: DBMS_SQL.bind_variable (l_query_handle,

3443: );
3444: END IF;
3445:
3446: IF p_machine_resource_id IS NOT NULL THEN
3447: DBMS_SQL.bind_variable (l_query_handle,
3448: 'machine_resource_id',
3449: p_machine_resource_id
3450: );
3451: END IF;

Line 3454: DBMS_SQL.bind_variable (l_query_handle,

3450: );
3451: END IF;
3452:
3453: IF p_machine_instance IS NOT NULL THEN
3454: DBMS_SQL.bind_variable (l_query_handle,
3455: 'machine_instance',
3456: p_machine_instance
3457: );
3458: END IF;

Line 3462: DBMS_SQL.bind_variable (l_query_handle,

3458: END IF;
3459:
3460: IF p_user_task_type_id IS NOT NULL
3461: THEN
3462: DBMS_SQL.bind_variable (l_query_handle,
3463: 'user_task_type_id',
3464: p_user_task_type_id
3465: );
3466: END IF;

Line 3469: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);

3465: );
3466: END IF;
3467: /* End of Bug 5446146 */
3468:
3469: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);
3470: g_record_count := g_record_count + l_query_count;
3471: x_non_complete_parent := l_query_count;
3472: DBMS_SQL.close_cursor(l_query_handle);
3473:

Line 3472: DBMS_SQL.close_cursor(l_query_handle);

3468:
3469: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);
3470: g_record_count := g_record_count + l_query_count;
3471: x_non_complete_parent := l_query_count;
3472: DBMS_SQL.close_cursor(l_query_handle);
3473:
3474: -- Delete the child tasks from the temp table
3475: --Bulk Picking Enhancement:
3476: --Added the condition status_id <> 6 because we want to show

Line 3634: l_query_handle := DBMS_SQL.open_cursor;

3630: || l_select_generic
3631: || l_from_generic
3632: || l_where_generic;
3633: -- Parse, Bind and Execute the dynamic query
3634: l_query_handle := DBMS_SQL.open_cursor;
3635: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
3636: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);
3637: g_record_count := g_record_count + l_query_count;
3638: DBMS_SQL.close_cursor(l_query_handle);

Line 3635: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);

3631: || l_from_generic
3632: || l_where_generic;
3633: -- Parse, Bind and Execute the dynamic query
3634: l_query_handle := DBMS_SQL.open_cursor;
3635: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
3636: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);
3637: g_record_count := g_record_count + l_query_count;
3638: DBMS_SQL.close_cursor(l_query_handle);
3639: END IF;

Line 3636: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);

3632: || l_where_generic;
3633: -- Parse, Bind and Execute the dynamic query
3634: l_query_handle := DBMS_SQL.open_cursor;
3635: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
3636: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);
3637: g_record_count := g_record_count + l_query_count;
3638: DBMS_SQL.close_cursor(l_query_handle);
3639: END IF;
3640: EXCEPTION

Line 3638: DBMS_SQL.close_cursor(l_query_handle);

3634: l_query_handle := DBMS_SQL.open_cursor;
3635: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
3636: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);
3637: g_record_count := g_record_count + l_query_count;
3638: DBMS_SQL.close_cursor(l_query_handle);
3639: END IF;
3640: EXCEPTION
3641: WHEN OTHERS THEN -- Bug 4150145
3642: IF dbms_sql.is_open(l_query_handle) THEN

Line 3642: IF dbms_sql.is_open(l_query_handle) THEN

3638: DBMS_SQL.close_cursor(l_query_handle);
3639: END IF;
3640: EXCEPTION
3641: WHEN OTHERS THEN -- Bug 4150145
3642: IF dbms_sql.is_open(l_query_handle) THEN
3643: DBMS_SQL.close_cursor(l_query_handle);
3644: END IF;
3645: debug(Sqlerrm, 'Task_planning.populate_merged_tasks');
3646: END populate_merged_tasks;

Line 3643: DBMS_SQL.close_cursor(l_query_handle);

3639: END IF;
3640: EXCEPTION
3641: WHEN OTHERS THEN -- Bug 4150145
3642: IF dbms_sql.is_open(l_query_handle) THEN
3643: DBMS_SQL.close_cursor(l_query_handle);
3644: END IF;
3645: debug(Sqlerrm, 'Task_planning.populate_merged_tasks');
3646: END populate_merged_tasks;
3647:

Line 4588: l_query_handle := DBMS_SQL.open_cursor;

4584: IF l_debug = 1 then
4585: debug('l_query ' || l_query,'query_outbound_tasks');
4586: END IF;
4587:
4588: l_query_handle := DBMS_SQL.open_cursor;
4589: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
4590:
4591: IF p_organization_id IS NOT NULL
4592: THEN

Line 4589: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);

4585: debug('l_query ' || l_query,'query_outbound_tasks');
4586: END IF;
4587:
4588: l_query_handle := DBMS_SQL.open_cursor;
4589: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
4590:
4591: IF p_organization_id IS NOT NULL
4592: THEN
4593: DBMS_SQL.bind_variable (l_query_handle,

Line 4593: DBMS_SQL.bind_variable (l_query_handle,

4589: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
4590:
4591: IF p_organization_id IS NOT NULL
4592: THEN
4593: DBMS_SQL.bind_variable (l_query_handle,
4594: 'org_id',
4595: p_organization_id
4596: );
4597: END IF;

Line 4601: DBMS_SQL.bind_variable (l_query_handle,

4597: END IF;
4598:
4599: IF p_subinventory_code IS NOT NULL
4600: THEN
4601: DBMS_SQL.bind_variable (l_query_handle,
4602: 'sub_code',
4603: p_subinventory_code
4604: );
4605: END IF;

Line 4609: DBMS_SQL.bind_variable (l_query_handle, 'loc_id', p_locator_id);

4605: END IF;
4606:
4607: IF p_locator_id IS NOT NULL
4608: THEN
4609: DBMS_SQL.bind_variable (l_query_handle, 'loc_id', p_locator_id);
4610: END IF;
4611:
4612: IF p_to_subinventory_code IS NOT NULL
4613: THEN

Line 4614: DBMS_SQL.bind_variable (l_query_handle,

4610: END IF;
4611:
4612: IF p_to_subinventory_code IS NOT NULL
4613: THEN
4614: DBMS_SQL.bind_variable (l_query_handle,
4615: 'to_sub_code',
4616: p_to_subinventory_code
4617: );
4618: END IF;

Line 4622: DBMS_SQL.bind_variable (l_query_handle,

4618: END IF;
4619:
4620: IF p_to_locator_id IS NOT NULL
4621: THEN
4622: DBMS_SQL.bind_variable (l_query_handle,
4623: 'to_loc_id',
4624: p_to_locator_id
4625: );
4626: END IF;

Line 4630: DBMS_SQL.bind_variable (l_query_handle,

4626: END IF;
4627:
4628: IF p_inventory_item_id IS NOT NULL
4629: THEN
4630: DBMS_SQL.bind_variable (l_query_handle,
4631: 'item_id',
4632: p_inventory_item_id
4633: );
4634: END IF;

Line 4639: DBMS_SQL.bind_variable (l_query_handle,

4635:
4636: -- R12 : Additional Query Criteria using item type
4637: IF p_item_type_code IS NOT NULL
4638: THEN
4639: DBMS_SQL.bind_variable (l_query_handle,
4640: 'item_type_code',
4641: p_item_type_code
4642: );
4643: END IF;

Line 4647: DBMS_SQL.bind_variable (l_query_handle,

4643: END IF;
4644:
4645: IF p_category_set_id IS NOT NULL
4646: THEN
4647: DBMS_SQL.bind_variable (l_query_handle,
4648: 'category_set_id',
4649: p_category_set_id
4650: );
4651: END IF;

Line 4655: DBMS_SQL.bind_variable (l_query_handle,

4651: END IF;
4652:
4653: IF p_item_category_id IS NOT NULL
4654: THEN
4655: DBMS_SQL.bind_variable (l_query_handle,
4656: 'item_category_id',
4657: p_item_category_id
4658: );
4659: END IF;

Line 4670: DBMS_SQL.bind_variable (l_query_handle, 'person_id', p_person_id);

4666: THEN
4667:
4668: IF p_person_id IS NOT NULL
4669: THEN
4670: DBMS_SQL.bind_variable (l_query_handle, 'person_id', p_person_id);
4671: END IF;
4672:
4673: IF p_person_resource_id IS NOT NULL
4674: THEN

Line 4675: DBMS_SQL.bind_variable (l_query_handle,

4671: END IF;
4672:
4673: IF p_person_resource_id IS NOT NULL
4674: THEN
4675: DBMS_SQL.bind_variable (l_query_handle,
4676: 'person_resource_id',
4677: p_person_resource_id
4678: );
4679: END IF;

Line 4683: DBMS_SQL.bind_variable (l_query_handle,

4679: END IF;
4680:
4681: IF p_equipment_type_id IS NOT NULL
4682: THEN
4683: DBMS_SQL.bind_variable (l_query_handle,
4684: 'equipment_type_id',
4685: p_equipment_type_id
4686: );
4687: END IF;

Line 4691: DBMS_SQL.bind_variable (l_query_handle,

4687: END IF;
4688:
4689: IF p_machine_resource_id IS NOT NULL
4690: THEN
4691: DBMS_SQL.bind_variable (l_query_handle,
4692: 'machine_resource_id',
4693: p_machine_resource_id
4694: );
4695: END IF;

Line 4699: DBMS_SQL.bind_variable (l_query_handle,

4695: END IF;
4696:
4697: IF p_machine_instance IS NOT NULL
4698: THEN
4699: DBMS_SQL.bind_variable (l_query_handle,
4700: 'machine_instance',
4701: p_machine_instance
4702: );
4703: END IF;

Line 4708: DBMS_SQL.bind_variable (l_query_handle,

4704: END IF;--4459382
4705:
4706: IF p_user_task_type_id IS NOT NULL
4707: THEN
4708: DBMS_SQL.bind_variable (l_query_handle,
4709: 'user_task_type_id',
4710: p_user_task_type_id
4711: );
4712: END IF;

Line 4716: DBMS_SQL.bind_variable (l_query_handle,

4712: END IF;
4713:
4714: IF p_from_task_quantity IS NOT NULL
4715: THEN
4716: DBMS_SQL.bind_variable (l_query_handle,
4717: 'from_task_quantity',
4718: p_from_task_quantity
4719: );
4720: END IF;

Line 4724: DBMS_SQL.bind_variable (l_query_handle,

4720: END IF;
4721:
4722: IF p_to_task_quantity IS NOT NULL
4723: THEN
4724: DBMS_SQL.bind_variable (l_query_handle,
4725: 'to_task_quantity',
4726: p_to_task_quantity
4727: );
4728: END IF;

Line 4732: DBMS_SQL.bind_variable (l_query_handle,

4728: END IF;
4729:
4730: IF p_from_task_priority IS NOT NULL
4731: THEN
4732: DBMS_SQL.bind_variable (l_query_handle,
4733: 'from_task_priority',
4734: p_from_task_priority
4735: );
4736: END IF;

Line 4740: DBMS_SQL.bind_variable (l_query_handle,

4736: END IF;
4737:
4738: IF p_to_task_priority IS NOT NULL
4739: THEN
4740: DBMS_SQL.bind_variable (l_query_handle,
4741: 'to_task_priority',
4742: p_to_task_priority
4743: );
4744: END IF;

Line 4748: DBMS_SQL.bind_variable (l_query_handle,

4744: END IF;
4745:
4746: IF p_from_creation_date IS NOT NULL
4747: THEN
4748: DBMS_SQL.bind_variable (l_query_handle,
4749: 'from_creation_date',
4750: -- p_from_creation_date --commented in 6868286
4751: TRUNC(p_from_creation_date) --added in 6868286
4752: );

Line 4757: DBMS_SQL.bind_variable (l_query_handle,

4753: END IF;
4754:
4755: IF p_to_creation_date IS NOT NULL
4756: THEN
4757: DBMS_SQL.bind_variable (l_query_handle,
4758: 'to_creation_date',
4759: --p_to_creation_date --commented in 6868286
4760: TRUNC(p_to_creation_date) --added in 6868286
4761: );

Line 4770: DBMS_SQL.bind_variable (l_query_handle,

4766: THEN
4767:
4768: IF p_age_min IS NOT NULL
4769: THEN
4770: DBMS_SQL.bind_variable (l_query_handle,
4771: 'age_min',
4772: p_age_min
4773: );
4774: END IF;

Line 4778: DBMS_SQL.bind_variable (l_query_handle,

4774: END IF;
4775:
4776: IF p_age_max IS NOT NULL
4777: THEN
4778: DBMS_SQL.bind_variable (l_query_handle,
4779: 'age_max',
4780: p_age_max
4781: );
4782:

Line 4788: DBMS_SQL.bind_variable (l_query_handle, 'source_type_id', 8);

4784: END IF;
4785:
4786: IF p_include_internal_orders AND NOT p_include_sales_orders
4787: THEN
4788: DBMS_SQL.bind_variable (l_query_handle, 'source_type_id', 8);
4789: ELSIF NOT p_include_internal_orders AND p_include_sales_orders
4790: THEN
4791: DBMS_SQL.bind_variable (l_query_handle, 'source_type_id', 2);
4792: END IF;

Line 4791: DBMS_SQL.bind_variable (l_query_handle, 'source_type_id', 2);

4787: THEN
4788: DBMS_SQL.bind_variable (l_query_handle, 'source_type_id', 8);
4789: ELSIF NOT p_include_internal_orders AND p_include_sales_orders
4790: THEN
4791: DBMS_SQL.bind_variable (l_query_handle, 'source_type_id', 2);
4792: END IF;
4793:
4794: /*added if else for 3455109 since we are changing the query also need to change binds if its for completed task*/
4795: IF (i=1) /*old code*/ then

Line 4799: DBMS_SQL.bind_variable (l_query_handle,

4795: IF (i=1) /*old code*/ then
4796:
4797: IF p_from_sales_order_id IS NOT NULL
4798: THEN
4799: DBMS_SQL.bind_variable (l_query_handle,
4800: 'from_sales_order_id',
4801: p_from_sales_order_id
4802: );
4803: END IF;

Line 4807: DBMS_SQL.bind_variable (l_query_handle,

4803: END IF;
4804:
4805: IF p_to_sales_order_id IS NOT NULL
4806: THEN
4807: DBMS_SQL.bind_variable (l_query_handle,
4808: 'to_sales_order_id',
4809: p_to_sales_order_id
4810: );
4811: END IF;

Line 4815: --3240261 dbms_sql.bind_variable(l_query_handle, 'from_sales_order_id', p_from_sales_order_id);

4811: END IF;
4812: ELSE --completed tasks
4813: IF(l_is_range_so) then
4814: IF p_from_sales_order_id IS NOT NULL THEN
4815: --3240261 dbms_sql.bind_variable(l_query_handle, 'from_sales_order_id', p_from_sales_order_id);
4816: dbms_sql.bind_variable(l_query_handle,'l_from_tonum_mso_seg1',l_from_tonum_mso_seg1);--added for 3455109
4817: dbms_sql.bind_variable(l_query_handle,'l_from_mso_seg2',l_from_mso_seg2);--3455109
4818: END IF;
4819:

Line 4816: dbms_sql.bind_variable(l_query_handle,'l_from_tonum_mso_seg1',l_from_tonum_mso_seg1);--added for 3455109

4812: ELSE --completed tasks
4813: IF(l_is_range_so) then
4814: IF p_from_sales_order_id IS NOT NULL THEN
4815: --3240261 dbms_sql.bind_variable(l_query_handle, 'from_sales_order_id', p_from_sales_order_id);
4816: dbms_sql.bind_variable(l_query_handle,'l_from_tonum_mso_seg1',l_from_tonum_mso_seg1);--added for 3455109
4817: dbms_sql.bind_variable(l_query_handle,'l_from_mso_seg2',l_from_mso_seg2);--3455109
4818: END IF;
4819:
4820: IF p_to_sales_order_id IS NOT NULL THEN

Line 4817: dbms_sql.bind_variable(l_query_handle,'l_from_mso_seg2',l_from_mso_seg2);--3455109

4813: IF(l_is_range_so) then
4814: IF p_from_sales_order_id IS NOT NULL THEN
4815: --3240261 dbms_sql.bind_variable(l_query_handle, 'from_sales_order_id', p_from_sales_order_id);
4816: dbms_sql.bind_variable(l_query_handle,'l_from_tonum_mso_seg1',l_from_tonum_mso_seg1);--added for 3455109
4817: dbms_sql.bind_variable(l_query_handle,'l_from_mso_seg2',l_from_mso_seg2);--3455109
4818: END IF;
4819:
4820: IF p_to_sales_order_id IS NOT NULL THEN
4821: --3420261 dbms_sql.bind_variable(l_query_handle, 'to_sales_order_id', p_to_sales_order_id);

Line 4821: --3420261 dbms_sql.bind_variable(l_query_handle, 'to_sales_order_id', p_to_sales_order_id);

4817: dbms_sql.bind_variable(l_query_handle,'l_from_mso_seg2',l_from_mso_seg2);--3455109
4818: END IF;
4819:
4820: IF p_to_sales_order_id IS NOT NULL THEN
4821: --3420261 dbms_sql.bind_variable(l_query_handle, 'to_sales_order_id', p_to_sales_order_id);
4822: dbms_sql.bind_variable(l_query_handle,'l_to_tonum_mso_seg1',l_to_tonum_mso_seg1);
4823: dbms_sql.bind_variable(l_query_handle,'l_to_mso_seg2',l_to_mso_seg2);
4824: END IF;
4825: ELSE

Line 4822: dbms_sql.bind_variable(l_query_handle,'l_to_tonum_mso_seg1',l_to_tonum_mso_seg1);

4818: END IF;
4819:
4820: IF p_to_sales_order_id IS NOT NULL THEN
4821: --3420261 dbms_sql.bind_variable(l_query_handle, 'to_sales_order_id', p_to_sales_order_id);
4822: dbms_sql.bind_variable(l_query_handle,'l_to_tonum_mso_seg1',l_to_tonum_mso_seg1);
4823: dbms_sql.bind_variable(l_query_handle,'l_to_mso_seg2',l_to_mso_seg2);
4824: END IF;
4825: ELSE
4826: dbms_sql.bind_variable(l_query_handle,'l_from_mso_seg1',l_from_mso_seg1);

Line 4823: dbms_sql.bind_variable(l_query_handle,'l_to_mso_seg2',l_to_mso_seg2);

4819:
4820: IF p_to_sales_order_id IS NOT NULL THEN
4821: --3420261 dbms_sql.bind_variable(l_query_handle, 'to_sales_order_id', p_to_sales_order_id);
4822: dbms_sql.bind_variable(l_query_handle,'l_to_tonum_mso_seg1',l_to_tonum_mso_seg1);
4823: dbms_sql.bind_variable(l_query_handle,'l_to_mso_seg2',l_to_mso_seg2);
4824: END IF;
4825: ELSE
4826: dbms_sql.bind_variable(l_query_handle,'l_from_mso_seg1',l_from_mso_seg1);
4827: dbms_sql.bind_variable(l_query_handle,'l_from_mso_seg2',l_from_mso_seg2);

Line 4826: dbms_sql.bind_variable(l_query_handle,'l_from_mso_seg1',l_from_mso_seg1);

4822: dbms_sql.bind_variable(l_query_handle,'l_to_tonum_mso_seg1',l_to_tonum_mso_seg1);
4823: dbms_sql.bind_variable(l_query_handle,'l_to_mso_seg2',l_to_mso_seg2);
4824: END IF;
4825: ELSE
4826: dbms_sql.bind_variable(l_query_handle,'l_from_mso_seg1',l_from_mso_seg1);
4827: dbms_sql.bind_variable(l_query_handle,'l_from_mso_seg2',l_from_mso_seg2);
4828: END IF;--end of range or not range so
4829: END IF;--end of copleted or not completed task 3455109
4830:

Line 4827: dbms_sql.bind_variable(l_query_handle,'l_from_mso_seg2',l_from_mso_seg2);

4823: dbms_sql.bind_variable(l_query_handle,'l_to_mso_seg2',l_to_mso_seg2);
4824: END IF;
4825: ELSE
4826: dbms_sql.bind_variable(l_query_handle,'l_from_mso_seg1',l_from_mso_seg1);
4827: dbms_sql.bind_variable(l_query_handle,'l_from_mso_seg2',l_from_mso_seg2);
4828: END IF;--end of range or not range so
4829: END IF;--end of copleted or not completed task 3455109
4830:
4831: IF p_from_pick_slip_number IS NOT NULL

Line 4833: DBMS_SQL.bind_variable (l_query_handle,

4829: END IF;--end of copleted or not completed task 3455109
4830:
4831: IF p_from_pick_slip_number IS NOT NULL
4832: THEN
4833: DBMS_SQL.bind_variable (l_query_handle,
4834: 'from_pick_slip_number',
4835: p_from_pick_slip_number
4836: );
4837: END IF;

Line 4841: DBMS_SQL.bind_variable (l_query_handle,

4837: END IF;
4838:
4839: IF p_to_pick_slip_number IS NOT NULL
4840: THEN
4841: DBMS_SQL.bind_variable (l_query_handle,
4842: 'to_pick_slip_number',
4843: p_to_pick_slip_number
4844: );
4845: END IF;

Line 4849: DBMS_SQL.bind_variable (l_query_handle,

4845: END IF;
4846:
4847: IF p_customer_id IS NOT NULL
4848: THEN
4849: DBMS_SQL.bind_variable (l_query_handle,
4850: 'customer_id',
4851: p_customer_id
4852: );
4853: END IF;

Line 4857: DBMS_SQL.bind_variable (l_query_handle,

4853: END IF;
4854:
4855: IF p_customer_category IS NOT NULL
4856: THEN
4857: DBMS_SQL.bind_variable (l_query_handle,
4858: 'customer_category',
4859: p_customer_category
4860: );
4861: END IF;

Line 4865: DBMS_SQL.bind_variable (l_query_handle, 'trip_id', p_trip_id);

4861: END IF;
4862:
4863: IF p_trip_id IS NOT NULL
4864: THEN
4865: DBMS_SQL.bind_variable (l_query_handle, 'trip_id', p_trip_id);
4866: END IF;
4867:
4868: IF p_delivery_id IS NOT NULL
4869: THEN

Line 4870: DBMS_SQL.bind_variable (l_query_handle,

4866: END IF;
4867:
4868: IF p_delivery_id IS NOT NULL
4869: THEN
4870: DBMS_SQL.bind_variable (l_query_handle,
4871: 'delivery_id',
4872: p_delivery_id
4873: );
4874: END IF;

Line 4878: DBMS_SQL.bind_variable (l_query_handle,

4874: END IF;
4875:
4876: IF p_carrier_id IS NOT NULL
4877: THEN
4878: DBMS_SQL.bind_variable (l_query_handle,
4879: 'carrier_id',
4880: p_carrier_id
4881: );
4882: END IF;

Line 4886: DBMS_SQL.bind_variable (l_query_handle,

4882: END IF;
4883:
4884: IF p_ship_method IS NOT NULL
4885: THEN
4886: DBMS_SQL.bind_variable (l_query_handle,
4887: 'ship_method',
4888: p_ship_method
4889: );
4890: END IF;

Line 4894: DBMS_SQL.bind_variable (l_query_handle,

4890: END IF;
4891:
4892: IF p_order_type_id IS NOT NULL
4893: THEN
4894: DBMS_SQL.bind_variable (l_query_handle,
4895: 'p_order_type_id',
4896: p_order_type_id
4897: );
4898: END IF;

Line 4902: DBMS_SQL.bind_variable (l_query_handle,

4898: END IF;
4899:
4900: IF p_shipment_priority IS NOT NULL
4901: THEN
4902: DBMS_SQL.bind_variable (l_query_handle,
4903: 'shipment_priority',
4904: p_shipment_priority
4905: );
4906: END IF;

Line 4910: DBMS_SQL.bind_variable (l_query_handle,

4906: END IF;
4907:
4908: IF p_from_shipment_date IS NOT NULL
4909: THEN
4910: DBMS_SQL.bind_variable (l_query_handle,
4911: 'from_shipment_date',
4912: p_from_shipment_date
4913: );
4914: END IF;

Line 4918: DBMS_SQL.bind_variable (l_query_handle,

4914: END IF;
4915:
4916: IF p_to_shipment_date IS NOT NULL
4917: THEN
4918: DBMS_SQL.bind_variable (l_query_handle,
4919: 'to_shipment_date',
4920: p_to_shipment_date
4921: );
4922: END IF;

Line 4926: DBMS_SQL.bind_variable (l_query_handle,

4922: END IF;
4923:
4924: IF p_time_till_shipment IS NOT NULL AND p_time_till_shipment_uom_code IS NOT NULL
4925: THEN
4926: DBMS_SQL.bind_variable (l_query_handle,
4927: 'p_time_till_shipment',
4928: p_time_till_shipment
4929: );
4930: END IF;

Line 4934: DBMS_SQL.bind_variable (l_query_handle,

4930: END IF;
4931:
4932: IF p_time_till_appt IS NOT NULL AND p_time_till_appt_uom_code IS NOT NULL
4933: THEN
4934: DBMS_SQL.bind_variable (l_query_handle,
4935: 'p_time_till_appt',
4936: p_time_till_appt
4937: );
4938: END IF;

Line 4943: DBMS_SQL.bind_variable (l_query_handle,

4939:
4940:
4941: IF p_ship_to_state IS NOT NULL
4942: THEN
4943: DBMS_SQL.bind_variable (l_query_handle,
4944: 'ship_to_state',
4945: p_ship_to_state
4946: );
4947: END IF;

Line 4951: DBMS_SQL.bind_variable (l_query_handle,

4947: END IF;
4948:
4949: IF p_ship_to_country IS NOT NULL
4950: THEN
4951: DBMS_SQL.bind_variable (l_query_handle,
4952: 'ship_to_country',
4953: p_ship_to_country
4954: );
4955: END IF;

Line 4959: DBMS_SQL.bind_variable (l_query_handle,

4955: END IF;
4956:
4957: IF p_ship_to_postal_code IS NOT NULL
4958: THEN
4959: DBMS_SQL.bind_variable (l_query_handle,
4960: 'ship_to_postal_code',
4961: p_ship_to_postal_code
4962: );
4963: END IF;

Line 4967: DBMS_SQL.bind_variable (l_query_handle,

4963: END IF;
4964:
4965: IF p_from_number_of_order_lines IS NOT NULL
4966: THEN
4967: DBMS_SQL.bind_variable (l_query_handle,
4968: 'from_number_of_order_lines',
4969: p_from_number_of_order_lines
4970: );
4971: END IF;

Line 4975: DBMS_SQL.bind_variable (l_query_handle,

4971: END IF;
4972:
4973: IF p_to_number_of_order_lines IS NOT NULL
4974: THEN
4975: DBMS_SQL.bind_variable (l_query_handle,
4976: 'to_number_of_order_lines',
4977: p_to_number_of_order_lines
4978: );
4979: END IF;

Line 4982: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 1, l_wms_task_type);

4978: );
4979: END IF;
4980:
4981: IF p_summary_mode = 1 THEN
4982: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 1, l_wms_task_type);
4983: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 2, l_task_count);
4984: END IF;
4985:
4986: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);

Line 4983: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 2, l_task_count);

4979: END IF;
4980:
4981: IF p_summary_mode = 1 THEN
4982: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 1, l_wms_task_type);
4983: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 2, l_task_count);
4984: END IF;
4985:
4986: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);
4987: g_record_count := g_record_count + l_query_count;

Line 4986: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);

4982: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 1, l_wms_task_type);
4983: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 2, l_task_count);
4984: END IF;
4985:
4986: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);
4987: g_record_count := g_record_count + l_query_count;
4988:
4989: IF p_summary_mode = 1 THEN -- fetch the rows and put them into the global tables
4990: LOOP

Line 4991: IF DBMS_SQL.FETCH_ROWS(l_query_handle)>0 THEN

4987: g_record_count := g_record_count + l_query_count;
4988:
4989: IF p_summary_mode = 1 THEN -- fetch the rows and put them into the global tables
4990: LOOP
4991: IF DBMS_SQL.FETCH_ROWS(l_query_handle)>0 THEN
4992: DBMS_SQL.COLUMN_VALUE(l_query_handle, 1, l_wms_task_type);
4993: DBMS_SQL.COLUMN_VALUE(l_query_handle, 2, l_task_count);
4994: g_wms_task_summary_tbl(l_wms_task_type).wms_task_type := l_wms_task_type;
4995: g_wms_task_summary_tbl(l_wms_task_type).task_count := g_wms_task_summary_tbl(l_wms_task_type).task_count + l_task_count;

Line 4992: DBMS_SQL.COLUMN_VALUE(l_query_handle, 1, l_wms_task_type);

4988:
4989: IF p_summary_mode = 1 THEN -- fetch the rows and put them into the global tables
4990: LOOP
4991: IF DBMS_SQL.FETCH_ROWS(l_query_handle)>0 THEN
4992: DBMS_SQL.COLUMN_VALUE(l_query_handle, 1, l_wms_task_type);
4993: DBMS_SQL.COLUMN_VALUE(l_query_handle, 2, l_task_count);
4994: g_wms_task_summary_tbl(l_wms_task_type).wms_task_type := l_wms_task_type;
4995: g_wms_task_summary_tbl(l_wms_task_type).task_count := g_wms_task_summary_tbl(l_wms_task_type).task_count + l_task_count;
4996: IF l_debug = 1 then

Line 4993: DBMS_SQL.COLUMN_VALUE(l_query_handle, 2, l_task_count);

4989: IF p_summary_mode = 1 THEN -- fetch the rows and put them into the global tables
4990: LOOP
4991: IF DBMS_SQL.FETCH_ROWS(l_query_handle)>0 THEN
4992: DBMS_SQL.COLUMN_VALUE(l_query_handle, 1, l_wms_task_type);
4993: DBMS_SQL.COLUMN_VALUE(l_query_handle, 2, l_task_count);
4994: g_wms_task_summary_tbl(l_wms_task_type).wms_task_type := l_wms_task_type;
4995: g_wms_task_summary_tbl(l_wms_task_type).task_count := g_wms_task_summary_tbl(l_wms_task_type).task_count + l_task_count;
4996: IF l_debug = 1 then
4997: debug('Task Type :' || g_wms_task_summary_tbl(l_wms_task_type).wms_task_type, 'query_outbound_tasks');

Line 5005: DBMS_SQL.close_cursor(l_query_handle);

5001: EXIT; -- no more rows returned from dynamic SQL
5002: END IF;
5003: END LOOP;
5004: END IF;
5005: DBMS_SQL.close_cursor(l_query_handle);
5006: END LOOP;
5007: EXCEPTION
5008: WHEN OTHERS THEN -- Bug 4150145
5009: IF dbms_sql.is_open(l_query_handle) THEN

Line 5009: IF dbms_sql.is_open(l_query_handle) THEN

5005: DBMS_SQL.close_cursor(l_query_handle);
5006: END LOOP;
5007: EXCEPTION
5008: WHEN OTHERS THEN -- Bug 4150145
5009: IF dbms_sql.is_open(l_query_handle) THEN
5010: DBMS_SQL.close_cursor(l_query_handle);
5011: END IF;
5012: DEBUG (SQLERRM, 'Task_planning.query_outbound_tasks');
5013: END query_outbound_tasks;

Line 5010: DBMS_SQL.close_cursor(l_query_handle);

5006: END LOOP;
5007: EXCEPTION
5008: WHEN OTHERS THEN -- Bug 4150145
5009: IF dbms_sql.is_open(l_query_handle) THEN
5010: DBMS_SQL.close_cursor(l_query_handle);
5011: END IF;
5012: DEBUG (SQLERRM, 'Task_planning.query_outbound_tasks');
5013: END query_outbound_tasks;
5014:

Line 5524: l_query_handle := DBMS_SQL.open_cursor;

5520: || l_from_inbound
5521: || l_where_generic
5522: || l_where_inbound;
5523: -- Parse, Bind and Execute the dynamic query
5524: l_query_handle := DBMS_SQL.open_cursor;
5525: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
5526:
5527: --generic bind variables
5528: IF p_organization_id IS NOT NULL

Line 5525: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);

5521: || l_where_generic
5522: || l_where_inbound;
5523: -- Parse, Bind and Execute the dynamic query
5524: l_query_handle := DBMS_SQL.open_cursor;
5525: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
5526:
5527: --generic bind variables
5528: IF p_organization_id IS NOT NULL
5529: THEN

Line 5530: DBMS_SQL.bind_variable (l_query_handle,

5526:
5527: --generic bind variables
5528: IF p_organization_id IS NOT NULL
5529: THEN
5530: DBMS_SQL.bind_variable (l_query_handle,
5531: 'org_id',
5532: p_organization_id
5533: );
5534: END IF;

Line 5538: DBMS_SQL.bind_variable (l_query_handle,

5534: END IF;
5535:
5536: IF p_subinventory_code IS NOT NULL
5537: THEN
5538: DBMS_SQL.bind_variable (l_query_handle,
5539: 'sub_code',
5540: p_subinventory_code
5541: );
5542: END IF;

Line 5546: DBMS_SQL.bind_variable (l_query_handle, 'loc_id', p_locator_id);

5542: END IF;
5543:
5544: IF p_locator_id IS NOT NULL
5545: THEN
5546: DBMS_SQL.bind_variable (l_query_handle, 'loc_id', p_locator_id);
5547: END IF;
5548:
5549: IF p_to_subinventory_code IS NOT NULL
5550: THEN

Line 5551: DBMS_SQL.bind_variable (l_query_handle,

5547: END IF;
5548:
5549: IF p_to_subinventory_code IS NOT NULL
5550: THEN
5551: DBMS_SQL.bind_variable (l_query_handle,
5552: 'to_sub_code',
5553: p_to_subinventory_code
5554: );
5555: END IF;

Line 5559: DBMS_SQL.bind_variable (l_query_handle,

5555: END IF;
5556:
5557: IF p_to_locator_id IS NOT NULL
5558: THEN
5559: DBMS_SQL.bind_variable (l_query_handle,
5560: 'to_loc_id',
5561: p_to_locator_id
5562: );
5563: END IF;

Line 5567: DBMS_SQL.bind_variable (l_query_handle,

5563: END IF;
5564:
5565: IF p_inventory_item_id IS NOT NULL
5566: THEN
5567: DBMS_SQL.bind_variable (l_query_handle,
5568: 'item_id',
5569: p_inventory_item_id
5570: );
5571: END IF;

Line 5576: DBMS_SQL.bind_variable (l_query_handle,

5572:
5573: -- R12 : Additional Query Criteria using item type
5574: IF p_item_type_code IS NOT NULL
5575: THEN
5576: DBMS_SQL.bind_variable (l_query_handle,
5577: 'item_type_code',
5578: p_item_type_code
5579: );
5580: END IF;

Line 5585: DBMS_SQL.bind_variable (l_query_handle,

5581:
5582:
5583: IF p_category_set_id IS NOT NULL
5584: THEN
5585: DBMS_SQL.bind_variable (l_query_handle,
5586: 'category_set_id',
5587: p_category_set_id
5588: );
5589: END IF;

Line 5593: DBMS_SQL.bind_variable (l_query_handle,

5589: END IF;
5590:
5591: IF p_item_category_id IS NOT NULL
5592: THEN
5593: DBMS_SQL.bind_variable (l_query_handle,
5594: 'item_category_id',
5595: p_item_category_id
5596: );
5597: END IF;

Line 5601: DBMS_SQL.bind_variable (l_query_handle, 'person_id', p_person_id);

5597: END IF;
5598:
5599: IF p_person_id IS NOT NULL
5600: THEN
5601: DBMS_SQL.bind_variable (l_query_handle, 'person_id', p_person_id);
5602: END IF;
5603:
5604: IF p_person_resource_id IS NOT NULL
5605: THEN

Line 5606: DBMS_SQL.bind_variable (l_query_handle,

5602: END IF;
5603:
5604: IF p_person_resource_id IS NOT NULL
5605: THEN
5606: DBMS_SQL.bind_variable (l_query_handle,
5607: 'person_resource_id',
5608: p_person_resource_id
5609: );
5610: END IF;

Line 5614: DBMS_SQL.bind_variable (l_query_handle,

5610: END IF;
5611:
5612: IF p_equipment_type_id IS NOT NULL
5613: THEN
5614: DBMS_SQL.bind_variable (l_query_handle,
5615: 'equipment_type_id',
5616: p_equipment_type_id
5617: );
5618: END IF;

Line 5622: DBMS_SQL.bind_variable (l_query_handle,

5618: END IF;
5619:
5620: IF p_machine_resource_id IS NOT NULL
5621: THEN
5622: DBMS_SQL.bind_variable (l_query_handle,
5623: 'machine_resource_id',
5624: p_machine_resource_id
5625: );
5626: END IF;

Line 5630: DBMS_SQL.bind_variable (l_query_handle,

5626: END IF;
5627:
5628: IF p_machine_instance IS NOT NULL
5629: THEN
5630: DBMS_SQL.bind_variable (l_query_handle,
5631: 'machine_instance',
5632: p_machine_instance
5633: );
5634: END IF;

Line 5638: DBMS_SQL.bind_variable (l_query_handle,

5634: END IF;
5635:
5636: IF p_from_task_quantity IS NOT NULL
5637: THEN
5638: DBMS_SQL.bind_variable (l_query_handle,
5639: 'from_task_quantity',
5640: p_from_task_quantity
5641: );
5642: END IF;

Line 5646: DBMS_SQL.bind_variable (l_query_handle,

5642: END IF;
5643:
5644: IF p_to_task_quantity IS NOT NULL
5645: THEN
5646: DBMS_SQL.bind_variable (l_query_handle,
5647: 'to_task_quantity',
5648: p_to_task_quantity
5649: );
5650: END IF;

Line 5654: DBMS_SQL.bind_variable (l_query_handle,

5650: END IF;
5651:
5652: IF p_from_creation_date IS NOT NULL
5653: THEN
5654: DBMS_SQL.bind_variable (l_query_handle,
5655: 'from_creation_date',
5656: p_from_creation_date
5657: );
5658: END IF;

Line 5662: DBMS_SQL.bind_variable (l_query_handle,

5658: END IF;
5659:
5660: IF p_to_creation_date IS NOT NULL
5661: THEN
5662: DBMS_SQL.bind_variable (l_query_handle,
5663: 'to_creation_date',
5664: p_to_creation_date
5665: );
5666: END IF;

Line 5674: DBMS_SQL.bind_variable (l_query_handle,

5670: THEN
5671:
5672: IF p_age_min IS NOT NULL
5673: THEN
5674: DBMS_SQL.bind_variable (l_query_handle,
5675: 'age_min',
5676: p_age_min
5677: );
5678: END IF;

Line 5682: DBMS_SQL.bind_variable (l_query_handle,

5678: END IF;
5679:
5680: IF p_age_max IS NOT NULL
5681: THEN
5682: DBMS_SQL.bind_variable (l_query_handle,
5683: 'age_max',
5684: p_age_max
5685: );
5686:

Line 5693: DBMS_SQL.bind_variable (l_query_handle,

5689:
5690: --Inbound specifc bind variables
5691: IF p_from_po_header_id IS NOT NULL
5692: THEN
5693: DBMS_SQL.bind_variable (l_query_handle,
5694: 'from_po_header_id',
5695: p_from_po_header_id
5696: );
5697: END IF;

Line 5701: DBMS_SQL.bind_variable (l_query_handle,

5697: END IF;
5698:
5699: IF p_to_po_header_id IS NOT NULL
5700: THEN
5701: DBMS_SQL.bind_variable (l_query_handle,
5702: 'to_po_header_id',
5703: p_to_po_header_id
5704: );
5705: END IF;

Line 5709: DBMS_SQL.bind_variable (l_query_handle,

5705: END IF;
5706:
5707: IF p_from_rma_header_id IS NOT NULL
5708: THEN
5709: DBMS_SQL.bind_variable (l_query_handle,
5710: 'from_rma_header_id',
5711: p_from_rma_header_id
5712: );
5713: END IF;

Line 5717: DBMS_SQL.bind_variable (l_query_handle,

5713: END IF;
5714:
5715: IF p_to_rma_header_id IS NOT NULL
5716: THEN
5717: DBMS_SQL.bind_variable (l_query_handle,
5718: 'to_rma_header_id',
5719: p_to_rma_header_id
5720: );
5721: END IF;

Line 5725: DBMS_SQL.bind_variable (l_query_handle,

5721: END IF;
5722:
5723: IF p_from_requisition_header_id IS NOT NULL
5724: THEN
5725: DBMS_SQL.bind_variable (l_query_handle,
5726: 'from_requisition_header_id',
5727: p_from_requisition_header_id
5728: );
5729: END IF;

Line 5733: DBMS_SQL.bind_variable (l_query_handle,

5729: END IF;
5730:
5731: IF p_to_requisition_header_id IS NOT NULL
5732: THEN
5733: DBMS_SQL.bind_variable (l_query_handle,
5734: 'to_requisition_header_id',
5735: p_to_requisition_header_id
5736: );
5737: END IF;

Line 5741: DBMS_SQL.bind_variable (l_query_handle,

5737: END IF;
5738:
5739: IF p_from_shipment_number IS NOT NULL
5740: THEN
5741: DBMS_SQL.bind_variable (l_query_handle,
5742: 'from_shipment_number',
5743: p_from_shipment_number
5744: );
5745: END IF;

Line 5749: DBMS_SQL.bind_variable (l_query_handle,

5745: END IF;
5746:
5747: IF p_to_shipment_number IS NOT NULL
5748: THEN
5749: DBMS_SQL.bind_variable (l_query_handle,
5750: 'to_shipment_number',
5751: p_to_shipment_number
5752: );
5753: END IF;

Line 5756: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 1, l_wms_task_type);

5752: );
5753: END IF;
5754:
5755: IF p_summary_mode = 1 THEN
5756: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 1, l_wms_task_type);
5757: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 2, l_task_count);
5758: END IF;
5759:
5760: --execute the query

Line 5757: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 2, l_task_count);

5753: END IF;
5754:
5755: IF p_summary_mode = 1 THEN
5756: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 1, l_wms_task_type);
5757: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 2, l_task_count);
5758: END IF;
5759:
5760: --execute the query
5761: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);

Line 5761: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);

5757: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 2, l_task_count);
5758: END IF;
5759:
5760: --execute the query
5761: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);
5762: g_record_count := g_record_count + l_query_count;
5763:
5764: IF p_summary_mode = 1 THEN -- fetch the rows and put them into the global tables
5765: LOOP

Line 5766: IF DBMS_SQL.FETCH_ROWS(l_query_handle)>0 THEN

5762: g_record_count := g_record_count + l_query_count;
5763:
5764: IF p_summary_mode = 1 THEN -- fetch the rows and put them into the global tables
5765: LOOP
5766: IF DBMS_SQL.FETCH_ROWS(l_query_handle)>0 THEN
5767: DBMS_SQL.COLUMN_VALUE(l_query_handle, 1, l_wms_task_type);
5768: DBMS_SQL.COLUMN_VALUE(l_query_handle, 2, l_task_count);
5769: g_wms_task_summary_tbl(l_wms_task_type).wms_task_type := l_wms_task_type;
5770: g_wms_task_summary_tbl(l_wms_task_type).task_count := g_wms_task_summary_tbl(l_wms_task_type).task_count + l_task_count;

Line 5767: DBMS_SQL.COLUMN_VALUE(l_query_handle, 1, l_wms_task_type);

5763:
5764: IF p_summary_mode = 1 THEN -- fetch the rows and put them into the global tables
5765: LOOP
5766: IF DBMS_SQL.FETCH_ROWS(l_query_handle)>0 THEN
5767: DBMS_SQL.COLUMN_VALUE(l_query_handle, 1, l_wms_task_type);
5768: DBMS_SQL.COLUMN_VALUE(l_query_handle, 2, l_task_count);
5769: g_wms_task_summary_tbl(l_wms_task_type).wms_task_type := l_wms_task_type;
5770: g_wms_task_summary_tbl(l_wms_task_type).task_count := g_wms_task_summary_tbl(l_wms_task_type).task_count + l_task_count;
5771: ELSE

Line 5768: DBMS_SQL.COLUMN_VALUE(l_query_handle, 2, l_task_count);

5764: IF p_summary_mode = 1 THEN -- fetch the rows and put them into the global tables
5765: LOOP
5766: IF DBMS_SQL.FETCH_ROWS(l_query_handle)>0 THEN
5767: DBMS_SQL.COLUMN_VALUE(l_query_handle, 1, l_wms_task_type);
5768: DBMS_SQL.COLUMN_VALUE(l_query_handle, 2, l_task_count);
5769: g_wms_task_summary_tbl(l_wms_task_type).wms_task_type := l_wms_task_type;
5770: g_wms_task_summary_tbl(l_wms_task_type).task_count := g_wms_task_summary_tbl(l_wms_task_type).task_count + l_task_count;
5771: ELSE
5772: EXIT; -- no more rows returned from dynamic SQL

Line 5777: DBMS_SQL.close_cursor(l_query_handle);

5773: END IF;
5774: END LOOP;
5775: END IF;
5776:
5777: DBMS_SQL.close_cursor(l_query_handle);
5778: END LOOP;
5779:
5780: IF (g_source_header_visible = 'T' OR g_line_number_visible = 'T')
5781: AND p_from_po_header_id IS NULL

Line 5792: IF dbms_sql.is_open(l_query_handle) THEN

5788: set_inbound_source_header_line;
5789: END IF;
5790: EXCEPTION
5791: WHEN OTHERS THEN -- Bug 4150145
5792: IF dbms_sql.is_open(l_query_handle) THEN
5793: dbms_sql.close_cursor(l_query_handle);
5794: END IF;
5795: DEBUG (SQLERRM, 'Task_planning.query_inbound_tasks');
5796: END query_inbound_tasks;

Line 5793: dbms_sql.close_cursor(l_query_handle);

5789: END IF;
5790: EXCEPTION
5791: WHEN OTHERS THEN -- Bug 4150145
5792: IF dbms_sql.is_open(l_query_handle) THEN
5793: dbms_sql.close_cursor(l_query_handle);
5794: END IF;
5795: DEBUG (SQLERRM, 'Task_planning.query_inbound_tasks');
5796: END query_inbound_tasks;
5797:

Line 6825: l_query_handle := DBMS_SQL.open_cursor;

6821: || l_where_generic
6822: || l_where_manufacturing;
6823: -- Parse, Bind and Execute the dynamic query
6824: debug('l_query: ' || l_query,'query_manufacturing_tasks');
6825: l_query_handle := DBMS_SQL.open_cursor;
6826: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
6827:
6828: --generic bind variables
6829: IF p_organization_id IS NOT NULL

Line 6826: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);

6822: || l_where_manufacturing;
6823: -- Parse, Bind and Execute the dynamic query
6824: debug('l_query: ' || l_query,'query_manufacturing_tasks');
6825: l_query_handle := DBMS_SQL.open_cursor;
6826: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
6827:
6828: --generic bind variables
6829: IF p_organization_id IS NOT NULL
6830: THEN

Line 6831: DBMS_SQL.bind_variable (l_query_handle,

6827:
6828: --generic bind variables
6829: IF p_organization_id IS NOT NULL
6830: THEN
6831: DBMS_SQL.bind_variable (l_query_handle,
6832: 'org_id',
6833: p_organization_id
6834: );
6835: END IF;

Line 6839: DBMS_SQL.bind_variable (l_query_handle,

6835: END IF;
6836:
6837: IF p_subinventory_code IS NOT NULL
6838: THEN
6839: DBMS_SQL.bind_variable (l_query_handle,
6840: 'sub_code',
6841: p_subinventory_code
6842: );
6843: END IF;

Line 6847: DBMS_SQL.bind_variable (l_query_handle, 'loc_id', p_locator_id);

6843: END IF;
6844:
6845: IF p_locator_id IS NOT NULL
6846: THEN
6847: DBMS_SQL.bind_variable (l_query_handle, 'loc_id', p_locator_id);
6848: END IF;
6849:
6850: IF p_to_subinventory_code IS NOT NULL
6851: THEN

Line 6852: DBMS_SQL.bind_variable (l_query_handle,

6848: END IF;
6849:
6850: IF p_to_subinventory_code IS NOT NULL
6851: THEN
6852: DBMS_SQL.bind_variable (l_query_handle,
6853: 'to_sub_code',
6854: p_to_subinventory_code
6855: );
6856: END IF;

Line 6860: DBMS_SQL.bind_variable (l_query_handle,

6856: END IF;
6857:
6858: IF p_to_locator_id IS NOT NULL
6859: THEN
6860: DBMS_SQL.bind_variable (l_query_handle,
6861: 'to_loc_id',
6862: p_to_locator_id
6863: );
6864: END IF;

Line 6868: DBMS_SQL.bind_variable (l_query_handle,

6864: END IF;
6865:
6866: IF p_inventory_item_id IS NOT NULL
6867: THEN
6868: DBMS_SQL.bind_variable (l_query_handle,
6869: 'item_id',
6870: p_inventory_item_id
6871: );
6872: END IF;

Line 6877: DBMS_SQL.bind_variable (l_query_handle,

6873:
6874: -- R12 : Additional Query Criteria using item type
6875: IF p_item_type_code IS NOT NULL
6876: THEN
6877: DBMS_SQL.bind_variable (l_query_handle,
6878: 'item_type_code',
6879: p_item_type_code
6880: );
6881: END IF;

Line 6886: DBMS_SQL.bind_variable (l_query_handle,

6882:
6883:
6884: IF p_category_set_id IS NOT NULL
6885: THEN
6886: DBMS_SQL.bind_variable (l_query_handle,
6887: 'category_set_id',
6888: p_category_set_id
6889: );
6890: END IF;

Line 6894: DBMS_SQL.bind_variable (l_query_handle,

6890: END IF;
6891:
6892: IF p_item_category_id IS NOT NULL
6893: THEN
6894: DBMS_SQL.bind_variable (l_query_handle,
6895: 'item_category_id',
6896: p_item_category_id
6897: );
6898: END IF;

Line 6902: DBMS_SQL.bind_variable (l_query_handle, 'person_id', p_person_id);

6898: END IF;
6899:
6900: IF p_person_id IS NOT NULL
6901: THEN
6902: DBMS_SQL.bind_variable (l_query_handle, 'person_id', p_person_id);
6903: END IF;
6904:
6905: IF p_person_resource_id IS NOT NULL
6906: THEN

Line 6907: DBMS_SQL.bind_variable (l_query_handle,

6903: END IF;
6904:
6905: IF p_person_resource_id IS NOT NULL
6906: THEN
6907: DBMS_SQL.bind_variable (l_query_handle,
6908: 'person_resource_id',
6909: p_person_resource_id
6910: );
6911: END IF;

Line 6915: DBMS_SQL.bind_variable (l_query_handle,

6911: END IF;
6912:
6913: IF p_equipment_type_id IS NOT NULL
6914: THEN
6915: DBMS_SQL.bind_variable (l_query_handle,
6916: 'equipment_type_id',
6917: p_equipment_type_id
6918: );
6919: END IF;

Line 6923: DBMS_SQL.bind_variable (l_query_handle,

6919: END IF;
6920:
6921: IF p_machine_resource_id IS NOT NULL
6922: THEN
6923: DBMS_SQL.bind_variable (l_query_handle,
6924: 'machine_resource_id',
6925: p_machine_resource_id
6926: );
6927: END IF;

Line 6931: DBMS_SQL.bind_variable (l_query_handle,

6927: END IF;
6928:
6929: IF p_machine_instance IS NOT NULL
6930: THEN
6931: DBMS_SQL.bind_variable (l_query_handle,
6932: 'machine_instance',
6933: p_machine_instance
6934: );
6935: END IF;

Line 6939: DBMS_SQL.bind_variable (l_query_handle,

6935: END IF;
6936:
6937: IF p_user_task_type_id IS NOT NULL
6938: THEN
6939: DBMS_SQL.bind_variable (l_query_handle,
6940: 'user_task_type_id',
6941: p_user_task_type_id
6942: );
6943: END IF;

Line 6947: DBMS_SQL.bind_variable (l_query_handle,

6943: END IF;
6944:
6945: IF p_from_task_quantity IS NOT NULL
6946: THEN
6947: DBMS_SQL.bind_variable (l_query_handle,
6948: 'from_task_quantity',
6949: p_from_task_quantity
6950: );
6951: END IF;

Line 6955: DBMS_SQL.bind_variable (l_query_handle,

6951: END IF;
6952:
6953: IF p_to_task_quantity IS NOT NULL
6954: THEN
6955: DBMS_SQL.bind_variable (l_query_handle,
6956: 'to_task_quantity',
6957: p_to_task_quantity
6958: );
6959: END IF;

Line 6963: DBMS_SQL.bind_variable (l_query_handle,

6959: END IF;
6960:
6961: IF p_from_task_priority IS NOT NULL
6962: THEN
6963: DBMS_SQL.bind_variable (l_query_handle,
6964: 'from_task_priority',
6965: p_from_task_priority
6966: );
6967: END IF;

Line 6971: DBMS_SQL.bind_variable (l_query_handle,

6967: END IF;
6968:
6969: IF p_to_task_priority IS NOT NULL
6970: THEN
6971: DBMS_SQL.bind_variable (l_query_handle,
6972: 'to_task_priority',
6973: p_to_task_priority
6974: );
6975: END IF;

Line 6979: DBMS_SQL.bind_variable (l_query_handle,

6975: END IF;
6976:
6977: IF p_from_creation_date IS NOT NULL
6978: THEN
6979: DBMS_SQL.bind_variable (l_query_handle,
6980: 'from_creation_date',
6981: p_from_creation_date
6982: );
6983: END IF;

Line 6987: DBMS_SQL.bind_variable (l_query_handle,

6983: END IF;
6984:
6985: IF p_to_creation_date IS NOT NULL
6986: THEN
6987: DBMS_SQL.bind_variable (l_query_handle,
6988: 'to_creation_date',
6989: p_to_creation_date
6990: );
6991: END IF;

Line 6999: DBMS_SQL.bind_variable (l_query_handle,

6995: THEN
6996:
6997: IF p_age_min IS NOT NULL
6998: THEN
6999: DBMS_SQL.bind_variable (l_query_handle,
7000: 'age_min',
7001: p_age_min
7002: );
7003: END IF;

Line 7007: DBMS_SQL.bind_variable (l_query_handle,

7003: END IF;
7004:
7005: IF p_age_max IS NOT NULL
7006: THEN
7007: DBMS_SQL.bind_variable (l_query_handle,
7008: 'age_max',
7009: p_age_max
7010: );
7011:

Line 7018: DBMS_SQL.bind_variable (l_query_handle, 'from_job', p_from_job);

7014:
7015: -- Manufacturing query specific bind variables
7016: IF p_from_job IS NOT NULL
7017: THEN
7018: DBMS_SQL.bind_variable (l_query_handle, 'from_job', p_from_job);
7019: END IF;
7020:
7021: IF p_to_job IS NOT NULL
7022: THEN

Line 7023: DBMS_SQL.bind_variable (l_query_handle, 'to_job', p_to_job);

7019: END IF;
7020:
7021: IF p_to_job IS NOT NULL
7022: THEN
7023: DBMS_SQL.bind_variable (l_query_handle, 'to_job', p_to_job);
7024: END IF;
7025:
7026: IF p_assembly_id IS NOT NULL
7027: THEN

Line 7028: DBMS_SQL.bind_variable (l_query_handle,

7024: END IF;
7025:
7026: IF p_assembly_id IS NOT NULL
7027: THEN
7028: DBMS_SQL.bind_variable (l_query_handle,
7029: 'assembly_id',
7030: p_assembly_id
7031: );
7032: END IF;

Line 7036: DBMS_SQL.bind_variable (l_query_handle,

7032: END IF;
7033:
7034: IF p_from_start_date IS NOT NULL
7035: THEN
7036: DBMS_SQL.bind_variable (l_query_handle,
7037: 'from_start_date',
7038: p_from_start_date
7039: );
7040: END IF;

Line 7044: DBMS_SQL.bind_variable (l_query_handle,

7040: END IF;
7041:
7042: IF p_to_start_date IS NOT NULL
7043: THEN
7044: DBMS_SQL.bind_variable (l_query_handle,
7045: 'to_start_date',
7046: p_to_start_date
7047: );
7048: END IF;

Line 7052: DBMS_SQL.bind_variable (l_query_handle, 'from_line', p_from_line);

7048: END IF;
7049:
7050: IF p_from_line IS NOT NULL
7051: THEN
7052: DBMS_SQL.bind_variable (l_query_handle, 'from_line', p_from_line);
7053: END IF;
7054:
7055: IF p_to_line IS NOT NULL
7056: THEN

Line 7057: DBMS_SQL.bind_variable (l_query_handle, 'to_line', p_to_line);

7053: END IF;
7054:
7055: IF p_to_line IS NOT NULL
7056: THEN
7057: DBMS_SQL.bind_variable (l_query_handle, 'to_line', p_to_line);
7058: END IF;
7059:
7060: IF p_department_id IS NOT NULL
7061: THEN

Line 7062: DBMS_SQL.bind_variable (l_query_handle,

7058: END IF;
7059:
7060: IF p_department_id IS NOT NULL
7061: THEN
7062: DBMS_SQL.bind_variable (l_query_handle,
7063: 'dept_id',
7064: p_department_id
7065: );
7066: END IF;

Line 7069: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 1, l_wms_task_type);

7065: );
7066: END IF;
7067:
7068: IF p_summary_mode = 1 THEN
7069: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 1, l_wms_task_type);
7070: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 2, l_task_count);
7071: END IF;
7072:
7073: --mfg_query

Line 7070: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 2, l_task_count);

7066: END IF;
7067:
7068: IF p_summary_mode = 1 THEN
7069: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 1, l_wms_task_type);
7070: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 2, l_task_count);
7071: END IF;
7072:
7073: --mfg_query
7074: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);

Line 7074: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);

7070: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 2, l_task_count);
7071: END IF;
7072:
7073: --mfg_query
7074: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);
7075:
7076: IF p_summary_mode = 1 THEN -- fetch the rows and put them into the global tables
7077: LOOP
7078: IF DBMS_SQL.FETCH_ROWS(l_query_handle)>0 THEN

Line 7078: IF DBMS_SQL.FETCH_ROWS(l_query_handle)>0 THEN

7074: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);
7075:
7076: IF p_summary_mode = 1 THEN -- fetch the rows and put them into the global tables
7077: LOOP
7078: IF DBMS_SQL.FETCH_ROWS(l_query_handle)>0 THEN
7079: DBMS_SQL.COLUMN_VALUE(l_query_handle, 1, l_wms_task_type);
7080: DBMS_SQL.COLUMN_VALUE(l_query_handle, 2, l_task_count);
7081: g_wms_task_summary_tbl(l_wms_task_type).wms_task_type := l_wms_task_type;
7082: g_wms_task_summary_tbl(l_wms_task_type).task_count := g_wms_task_summary_tbl(l_wms_task_type).task_count + l_task_count;

Line 7079: DBMS_SQL.COLUMN_VALUE(l_query_handle, 1, l_wms_task_type);

7075:
7076: IF p_summary_mode = 1 THEN -- fetch the rows and put them into the global tables
7077: LOOP
7078: IF DBMS_SQL.FETCH_ROWS(l_query_handle)>0 THEN
7079: DBMS_SQL.COLUMN_VALUE(l_query_handle, 1, l_wms_task_type);
7080: DBMS_SQL.COLUMN_VALUE(l_query_handle, 2, l_task_count);
7081: g_wms_task_summary_tbl(l_wms_task_type).wms_task_type := l_wms_task_type;
7082: g_wms_task_summary_tbl(l_wms_task_type).task_count := g_wms_task_summary_tbl(l_wms_task_type).task_count + l_task_count;
7083: IF l_debug = 1 then

Line 7080: DBMS_SQL.COLUMN_VALUE(l_query_handle, 2, l_task_count);

7076: IF p_summary_mode = 1 THEN -- fetch the rows and put them into the global tables
7077: LOOP
7078: IF DBMS_SQL.FETCH_ROWS(l_query_handle)>0 THEN
7079: DBMS_SQL.COLUMN_VALUE(l_query_handle, 1, l_wms_task_type);
7080: DBMS_SQL.COLUMN_VALUE(l_query_handle, 2, l_task_count);
7081: g_wms_task_summary_tbl(l_wms_task_type).wms_task_type := l_wms_task_type;
7082: g_wms_task_summary_tbl(l_wms_task_type).task_count := g_wms_task_summary_tbl(l_wms_task_type).task_count + l_task_count;
7083: IF l_debug = 1 then
7084: debug('Task Type :' || g_wms_task_summary_tbl(l_wms_task_type).wms_task_type, 'query_manufacturing_tasks');

Line 7093: DBMS_SQL.close_cursor(l_query_handle);

7089: END IF;
7090: END LOOP;
7091: END IF;
7092: g_record_count := g_record_count + l_query_count;
7093: DBMS_SQL.close_cursor(l_query_handle);
7094: END LOOP;
7095: EXCEPTION
7096: WHEN OTHERS THEN -- Bug 4150145
7097: IF dbms_sql.is_open(l_query_handle) THEN

Line 7097: IF dbms_sql.is_open(l_query_handle) THEN

7093: DBMS_SQL.close_cursor(l_query_handle);
7094: END LOOP;
7095: EXCEPTION
7096: WHEN OTHERS THEN -- Bug 4150145
7097: IF dbms_sql.is_open(l_query_handle) THEN
7098: dbms_sql.close_cursor(l_query_handle);
7099: END IF;
7100: DEBUG (SQLERRM, 'Task_planning.query_manufacturing_tasks');
7101: END query_manufacturing_tasks;

Line 7098: dbms_sql.close_cursor(l_query_handle);

7094: END LOOP;
7095: EXCEPTION
7096: WHEN OTHERS THEN -- Bug 4150145
7097: IF dbms_sql.is_open(l_query_handle) THEN
7098: dbms_sql.close_cursor(l_query_handle);
7099: END IF;
7100: DEBUG (SQLERRM, 'Task_planning.query_manufacturing_tasks');
7101: END query_manufacturing_tasks;
7102:

Line 8016: l_query_handle := DBMS_SQL.open_cursor;

8012: l_query := l_select_cc || l_from_cc || l_where_cc || l_group_by_cc ;
8013: END IF;
8014:
8015: -- Parse, Bind and Execute the dynamic query
8016: l_query_handle := DBMS_SQL.open_cursor;
8017: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
8018:
8019: --generic bind variables
8020: IF p_organization_id IS NOT NULL

Line 8017: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);

8013: END IF;
8014:
8015: -- Parse, Bind and Execute the dynamic query
8016: l_query_handle := DBMS_SQL.open_cursor;
8017: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
8018:
8019: --generic bind variables
8020: IF p_organization_id IS NOT NULL
8021: THEN

Line 8022: DBMS_SQL.bind_variable (l_query_handle,

8018:
8019: --generic bind variables
8020: IF p_organization_id IS NOT NULL
8021: THEN
8022: DBMS_SQL.bind_variable (l_query_handle,
8023: 'org_id',
8024: p_organization_id
8025: );
8026: END IF;

Line 8030: DBMS_SQL.bind_variable (l_query_handle,

8026: END IF;
8027:
8028: IF p_subinventory_code IS NOT NULL
8029: THEN
8030: DBMS_SQL.bind_variable (l_query_handle,
8031: 'sub_code',
8032: p_subinventory_code
8033: );
8034: END IF;

Line 8038: DBMS_SQL.bind_variable (l_query_handle, 'loc_id', p_locator_id);

8034: END IF;
8035:
8036: IF p_locator_id IS NOT NULL
8037: THEN
8038: DBMS_SQL.bind_variable (l_query_handle, 'loc_id', p_locator_id);
8039: END IF;
8040:
8041: IF p_inventory_item_id IS NOT NULL
8042: THEN

Line 8043: DBMS_SQL.bind_variable (l_query_handle,

8039: END IF;
8040:
8041: IF p_inventory_item_id IS NOT NULL
8042: THEN
8043: DBMS_SQL.bind_variable (l_query_handle,
8044: 'item_id',
8045: p_inventory_item_id
8046: );
8047: END IF;

Line 8052: DBMS_SQL.bind_variable (l_query_handle,

8048:
8049: -- R12 : Additional Query Criteria using item type
8050: IF p_item_type_code IS NOT NULL
8051: THEN
8052: DBMS_SQL.bind_variable (l_query_handle,
8053: 'item_type_code',
8054: p_item_type_code
8055: );
8056: END IF;

Line 8061: DBMS_SQL.bind_variable (l_query_handle,

8057:
8058:
8059: IF p_category_set_id IS NOT NULL
8060: THEN
8061: DBMS_SQL.bind_variable (l_query_handle,
8062: 'category_set_id',
8063: p_category_set_id
8064: );
8065: END IF;

Line 8069: DBMS_SQL.bind_variable (l_query_handle,

8065: END IF;
8066:
8067: IF p_item_category_id IS NOT NULL
8068: THEN
8069: DBMS_SQL.bind_variable (l_query_handle,
8070: 'item_category_id',
8071: p_item_category_id
8072: );
8073: END IF;

Line 8077: DBMS_SQL.bind_variable (l_query_handle, 'person_id', p_person_id);

8073: END IF;
8074:
8075: IF p_person_id IS NOT NULL
8076: THEN
8077: DBMS_SQL.bind_variable (l_query_handle, 'person_id', p_person_id);
8078: END IF;
8079:
8080: IF p_person_resource_id IS NOT NULL
8081: THEN

Line 8082: DBMS_SQL.bind_variable (l_query_handle,

8078: END IF;
8079:
8080: IF p_person_resource_id IS NOT NULL
8081: THEN
8082: DBMS_SQL.bind_variable (l_query_handle,
8083: 'person_resource_id',
8084: p_person_resource_id
8085: );
8086: END IF;

Line 8090: DBMS_SQL.bind_variable (l_query_handle,

8086: END IF;
8087:
8088: IF p_equipment_type_id IS NOT NULL
8089: THEN
8090: DBMS_SQL.bind_variable (l_query_handle,
8091: 'equipment_type_id',
8092: p_equipment_type_id
8093: );
8094: END IF;

Line 8098: DBMS_SQL.bind_variable (l_query_handle,

8094: END IF;
8095:
8096: IF p_machine_resource_id IS NOT NULL
8097: THEN
8098: DBMS_SQL.bind_variable (l_query_handle,
8099: 'machine_resource_id',
8100: p_machine_resource_id
8101: );
8102: END IF;

Line 8106: DBMS_SQL.bind_variable (l_query_handle,

8102: END IF;
8103:
8104: IF p_machine_instance IS NOT NULL
8105: THEN
8106: DBMS_SQL.bind_variable (l_query_handle,
8107: 'machine_instance',
8108: p_machine_instance
8109: );
8110: END IF;

Line 8114: DBMS_SQL.bind_variable (l_query_handle,

8110: END IF;
8111:
8112: IF p_user_task_type_id IS NOT NULL
8113: THEN
8114: DBMS_SQL.bind_variable (l_query_handle,
8115: 'user_task_type_id',
8116: p_user_task_type_id
8117: );
8118: END IF;

Line 8122: DBMS_SQL.bind_variable (l_query_handle,

8118: END IF;
8119:
8120: IF p_from_task_priority IS NOT NULL
8121: THEN
8122: DBMS_SQL.bind_variable (l_query_handle,
8123: 'from_task_priority',
8124: p_from_task_priority
8125: );
8126: END IF;

Line 8130: DBMS_SQL.bind_variable (l_query_handle,

8126: END IF;
8127:
8128: IF p_to_task_priority IS NOT NULL
8129: THEN
8130: DBMS_SQL.bind_variable (l_query_handle,
8131: 'to_task_priority',
8132: p_to_task_priority
8133: );
8134: END IF;

Line 8138: DBMS_SQL.bind_variable (l_query_handle,

8134: END IF;
8135:
8136: IF p_from_creation_date IS NOT NULL
8137: THEN
8138: DBMS_SQL.bind_variable (l_query_handle,
8139: 'from_creation_date',
8140: p_from_creation_date
8141: );
8142: END IF;

Line 8146: DBMS_SQL.bind_variable (l_query_handle,

8142: END IF;
8143:
8144: IF p_to_creation_date IS NOT NULL
8145: THEN
8146: DBMS_SQL.bind_variable (l_query_handle,
8147: 'to_creation_date',
8148: p_to_creation_date
8149: );
8150: END IF;

Line 8158: DBMS_SQL.bind_variable (l_query_handle,

8154: THEN
8155:
8156: IF p_age_min IS NOT NULL
8157: THEN
8158: DBMS_SQL.bind_variable (l_query_handle,
8159: 'age_min',
8160: p_age_min
8161: );
8162: END IF;

Line 8166: DBMS_SQL.bind_variable (l_query_handle,

8162: END IF;
8163:
8164: IF p_age_max IS NOT NULL
8165: THEN
8166: DBMS_SQL.bind_variable (l_query_handle,
8167: 'age_max',
8168: p_age_max
8169: );
8170:

Line 8177: DBMS_SQL.bind_variable (l_query_handle,

8173:
8174: --Cycle count specifc bind variables
8175: IF p_cycle_count_name IS NOT NULL
8176: THEN
8177: DBMS_SQL.bind_variable (l_query_handle,
8178: 'cc_header_name',
8179: p_cycle_count_name
8180: );
8181: END IF;

Line 8185: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);

8181: END IF;
8182:
8183:
8184: --execute the query
8185: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);
8186: g_record_count := g_record_count + l_query_count;
8187:
8188: IF p_summary_mode = 1 THEN
8189: LOOP

Line 8190: IF DBMS_SQL.FETCH_ROWS(l_query_handle) = 0 THEN

8186: g_record_count := g_record_count + l_query_count;
8187:
8188: IF p_summary_mode = 1 THEN
8189: LOOP
8190: IF DBMS_SQL.FETCH_ROWS(l_query_handle) = 0 THEN
8191: EXIT;
8192: END IF;
8193: END LOOP;
8194: g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_cycle_count).wms_task_type := wms_waveplan_tasks_pvt.g_task_type_cycle_count;

Line 8195: g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_cycle_count).task_count := g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_cycle_count).task_count + dbms_sql.last_row_count;

8191: EXIT;
8192: END IF;
8193: END LOOP;
8194: g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_cycle_count).wms_task_type := wms_waveplan_tasks_pvt.g_task_type_cycle_count;
8195: g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_cycle_count).task_count := g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_cycle_count).task_count + dbms_sql.last_row_count;
8196: IF l_debug = 1 THEN
8197: debug(' Query :' || l_query , 'query_cc_tasks');
8198: debug('Task Type :' || g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_cycle_count).wms_task_type, 'query_cycle_count_tasks');
8199: debug('TaskCount :' || g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_cycle_count).task_count, 'query_cycle_count_tasks');

Line 8203: DBMS_SQL.close_cursor(l_query_handle);

8199: debug('TaskCount :' || g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_cycle_count).task_count, 'query_cycle_count_tasks');
8200: END IF;
8201: END IF;
8202:
8203: DBMS_SQL.close_cursor(l_query_handle);
8204: END LOOP;
8205: EXCEPTION
8206: WHEN OTHERS THEN -- Bug 4150145
8207: IF dbms_sql.is_open(l_query_handle) THEN

Line 8207: IF dbms_sql.is_open(l_query_handle) THEN

8203: DBMS_SQL.close_cursor(l_query_handle);
8204: END LOOP;
8205: EXCEPTION
8206: WHEN OTHERS THEN -- Bug 4150145
8207: IF dbms_sql.is_open(l_query_handle) THEN
8208: dbms_sql.close_cursor(l_query_handle);
8209: END IF;
8210: DEBUG (SQLERRM, 'Task_planning.query_cycle_count_tasks');
8211: END query_cycle_count_tasks;

Line 8208: dbms_sql.close_cursor(l_query_handle);

8204: END LOOP;
8205: EXCEPTION
8206: WHEN OTHERS THEN -- Bug 4150145
8207: IF dbms_sql.is_open(l_query_handle) THEN
8208: dbms_sql.close_cursor(l_query_handle);
8209: END IF;
8210: DEBUG (SQLERRM, 'Task_planning.query_cycle_count_tasks');
8211: END query_cycle_count_tasks;
8212:

Line 8575: l_query_handle := DBMS_SQL.open_cursor;

8571: -- Parse, Bind and Execute the dynamic query
8572: if l_debug = 1 then
8573: debug('MO Tasks Query ' || l_query,'query_mo_tasks');
8574: end if;
8575: l_query_handle := DBMS_SQL.open_cursor;
8576: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
8577:
8578: --generic bind variables
8579: IF p_organization_id IS NOT NULL

Line 8576: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);

8572: if l_debug = 1 then
8573: debug('MO Tasks Query ' || l_query,'query_mo_tasks');
8574: end if;
8575: l_query_handle := DBMS_SQL.open_cursor;
8576: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
8577:
8578: --generic bind variables
8579: IF p_organization_id IS NOT NULL
8580: THEN

Line 8581: DBMS_SQL.bind_variable (l_query_handle,

8577:
8578: --generic bind variables
8579: IF p_organization_id IS NOT NULL
8580: THEN
8581: DBMS_SQL.bind_variable (l_query_handle,
8582: 'org_id',
8583: p_organization_id
8584: );
8585: END IF;

Line 8589: DBMS_SQL.bind_variable (l_query_handle,

8585: END IF;
8586:
8587: IF p_subinventory_code IS NOT NULL
8588: THEN
8589: DBMS_SQL.bind_variable (l_query_handle,
8590: 'sub_code',
8591: p_subinventory_code
8592: );
8593: END IF;

Line 8597: DBMS_SQL.bind_variable (l_query_handle, 'loc_id', p_locator_id);

8593: END IF;
8594:
8595: IF p_locator_id IS NOT NULL
8596: THEN
8597: DBMS_SQL.bind_variable (l_query_handle, 'loc_id', p_locator_id);
8598: END IF;
8599:
8600: IF p_to_subinventory_code IS NOT NULL
8601: THEN

Line 8602: DBMS_SQL.bind_variable (l_query_handle,

8598: END IF;
8599:
8600: IF p_to_subinventory_code IS NOT NULL
8601: THEN
8602: DBMS_SQL.bind_variable (l_query_handle,
8603: 'to_sub_code',
8604: p_to_subinventory_code
8605: );
8606: END IF;

Line 8610: DBMS_SQL.bind_variable (l_query_handle,

8606: END IF;
8607:
8608: IF p_to_locator_id IS NOT NULL
8609: THEN
8610: DBMS_SQL.bind_variable (l_query_handle,
8611: 'to_loc_id',
8612: p_to_locator_id
8613: );
8614: END IF;

Line 8618: DBMS_SQL.bind_variable (l_query_handle,

8614: END IF;
8615:
8616: IF p_category_set_id IS NOT NULL
8617: THEN
8618: DBMS_SQL.bind_variable (l_query_handle,
8619: 'category_set_id',
8620: p_category_set_id
8621: );
8622: END IF;

Line 8626: DBMS_SQL.bind_variable (l_query_handle,

8622: END IF;
8623:
8624: IF p_inventory_item_id IS NOT NULL
8625: THEN
8626: DBMS_SQL.bind_variable (l_query_handle,
8627: 'item_id',
8628: p_inventory_item_id
8629: );
8630: END IF;

Line 8635: DBMS_SQL.bind_variable (l_query_handle,

8631:
8632: -- R12 : Additional Query Criteria using item type
8633: IF p_item_type_code IS NOT NULL
8634: THEN
8635: DBMS_SQL.bind_variable (l_query_handle,
8636: 'item_type_code',
8637: p_item_type_code
8638: );
8639: END IF;

Line 8644: DBMS_SQL.bind_variable (l_query_handle,

8640:
8641:
8642: IF p_item_category_id IS NOT NULL
8643: THEN
8644: DBMS_SQL.bind_variable (l_query_handle,
8645: 'item_category_id',
8646: p_item_category_id
8647: );
8648: END IF;

Line 8652: DBMS_SQL.bind_variable (l_query_handle, 'person_id', p_person_id);

8648: END IF;
8649:
8650: IF p_person_id IS NOT NULL
8651: THEN
8652: DBMS_SQL.bind_variable (l_query_handle, 'person_id', p_person_id);
8653: END IF;
8654:
8655: IF p_person_resource_id IS NOT NULL
8656: THEN

Line 8657: DBMS_SQL.bind_variable (l_query_handle,

8653: END IF;
8654:
8655: IF p_person_resource_id IS NOT NULL
8656: THEN
8657: DBMS_SQL.bind_variable (l_query_handle,
8658: 'person_resource_id',
8659: p_person_resource_id
8660: );
8661: END IF;

Line 8665: DBMS_SQL.bind_variable (l_query_handle,

8661: END IF;
8662:
8663: IF p_equipment_type_id IS NOT NULL
8664: THEN
8665: DBMS_SQL.bind_variable (l_query_handle,
8666: 'equipment_type_id',
8667: p_equipment_type_id
8668: );
8669: END IF;

Line 8673: DBMS_SQL.bind_variable (l_query_handle,

8669: END IF;
8670:
8671: IF p_machine_resource_id IS NOT NULL
8672: THEN
8673: DBMS_SQL.bind_variable (l_query_handle,
8674: 'machine_resource_id',
8675: p_machine_resource_id
8676: );
8677: END IF;

Line 8681: DBMS_SQL.bind_variable (l_query_handle,

8677: END IF;
8678:
8679: IF p_machine_instance IS NOT NULL
8680: THEN
8681: DBMS_SQL.bind_variable (l_query_handle,
8682: 'machine_instance',
8683: p_machine_instance
8684: );
8685: END IF;

Line 8689: DBMS_SQL.bind_variable (l_query_handle,

8685: END IF;
8686:
8687: IF p_user_task_type_id IS NOT NULL
8688: THEN
8689: DBMS_SQL.bind_variable (l_query_handle,
8690: 'user_task_type_id',
8691: p_user_task_type_id
8692: );
8693: END IF;

Line 8697: DBMS_SQL.bind_variable (l_query_handle,

8693: END IF;
8694:
8695: IF p_from_task_quantity IS NOT NULL
8696: THEN
8697: DBMS_SQL.bind_variable (l_query_handle,
8698: 'from_task_quantity',
8699: p_from_task_quantity
8700: );
8701: END IF;

Line 8705: DBMS_SQL.bind_variable (l_query_handle,

8701: END IF;
8702:
8703: IF p_to_task_quantity IS NOT NULL
8704: THEN
8705: DBMS_SQL.bind_variable (l_query_handle,
8706: 'to_task_quantity',
8707: p_to_task_quantity
8708: );
8709: END IF;

Line 8713: DBMS_SQL.bind_variable (l_query_handle,

8709: END IF;
8710:
8711: IF p_from_task_priority IS NOT NULL
8712: THEN
8713: DBMS_SQL.bind_variable (l_query_handle,
8714: 'from_task_priority',
8715: p_from_task_priority
8716: );
8717: END IF;

Line 8721: DBMS_SQL.bind_variable (l_query_handle,

8717: END IF;
8718:
8719: IF p_to_task_priority IS NOT NULL
8720: THEN
8721: DBMS_SQL.bind_variable (l_query_handle,
8722: 'to_task_priority',
8723: p_to_task_priority
8724: );
8725: END IF;

Line 8729: DBMS_SQL.bind_variable (l_query_handle,

8725: END IF;
8726:
8727: IF p_from_creation_date IS NOT NULL
8728: THEN
8729: DBMS_SQL.bind_variable (l_query_handle,
8730: 'from_creation_date',
8731: p_from_creation_date
8732: );
8733: END IF;

Line 8737: DBMS_SQL.bind_variable (l_query_handle,

8733: END IF;
8734:
8735: IF p_to_creation_date IS NOT NULL
8736: THEN
8737: DBMS_SQL.bind_variable (l_query_handle,
8738: 'to_creation_date',
8739: p_to_creation_date
8740: );
8741: END IF;

Line 8749: DBMS_SQL.bind_variable (l_query_handle,

8745: THEN
8746:
8747: IF p_age_min IS NOT NULL
8748: THEN
8749: DBMS_SQL.bind_variable (l_query_handle,
8750: 'age_min',
8751: p_age_min
8752: );
8753: END IF;

Line 8757: DBMS_SQL.bind_variable (l_query_handle,

8753: END IF;
8754:
8755: IF p_age_max IS NOT NULL
8756: THEN
8757: DBMS_SQL.bind_variable (l_query_handle,
8758: 'age_max',
8759: p_age_max
8760: );
8761:

Line 8767: DBMS_SQL.bind_variable (l_query_handle,

8763: END IF;
8764:
8765: IF p_from_replenishment_mo IS NOT NULL
8766: THEN
8767: DBMS_SQL.bind_variable (l_query_handle,
8768: 'from_replenishment_mo',
8769: p_from_replenishment_mo
8770: );
8771: END IF;

Line 8775: DBMS_SQL.bind_variable (l_query_handle,

8771: END IF;
8772:
8773: IF p_to_replenishment_mo IS NOT NULL
8774: THEN
8775: DBMS_SQL.bind_variable (l_query_handle,
8776: 'to_replenishment_mo',
8777: p_to_replenishment_mo
8778: );
8779: END IF;

Line 8783: DBMS_SQL.bind_variable (l_query_handle,

8779: END IF;
8780:
8781: IF p_from_transfer_issue_mo IS NOT NULL
8782: THEN
8783: DBMS_SQL.bind_variable (l_query_handle,
8784: 'from_transfer_issue_mo',
8785: p_from_transfer_issue_mo
8786: );
8787: END IF;

Line 8791: DBMS_SQL.bind_variable (l_query_handle,

8787: END IF;
8788:
8789: IF p_to_transfer_issue_mo IS NOT NULL
8790: THEN
8791: DBMS_SQL.bind_variable (l_query_handle,
8792: 'to_transfer_issue_mo',
8793: p_to_transfer_issue_mo
8794: );
8795: END IF;

Line 8798: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 1, l_wms_task_type);

8794: );
8795: END IF;
8796:
8797: IF p_summary_mode = 1 THEN
8798: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 1, l_wms_task_type);
8799: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 2, l_task_count);
8800: END IF;
8801:
8802: --execute the replenishment query

Line 8799: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 2, l_task_count);

8795: END IF;
8796:
8797: IF p_summary_mode = 1 THEN
8798: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 1, l_wms_task_type);
8799: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 2, l_task_count);
8800: END IF;
8801:
8802: --execute the replenishment query
8803: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);

Line 8803: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);

8799: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 2, l_task_count);
8800: END IF;
8801:
8802: --execute the replenishment query
8803: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);
8804: g_record_count := g_record_count + l_query_count;
8805:
8806: IF p_summary_mode = 1 THEN -- fetch the rows and put them into the global tables
8807: LOOP

Line 8808: IF DBMS_SQL.FETCH_ROWS(l_query_handle)>0 THEN

8804: g_record_count := g_record_count + l_query_count;
8805:
8806: IF p_summary_mode = 1 THEN -- fetch the rows and put them into the global tables
8807: LOOP
8808: IF DBMS_SQL.FETCH_ROWS(l_query_handle)>0 THEN
8809: DBMS_SQL.COLUMN_VALUE(l_query_handle, 1, l_wms_task_type);
8810: DBMS_SQL.COLUMN_VALUE(l_query_handle, 2, l_task_count);
8811: g_wms_task_summary_tbl(l_wms_task_type).wms_task_type := l_wms_task_type;
8812: g_wms_task_summary_tbl(l_wms_task_type).task_count := g_wms_task_summary_tbl(l_wms_task_type).task_count + l_task_count;

Line 8809: DBMS_SQL.COLUMN_VALUE(l_query_handle, 1, l_wms_task_type);

8805:
8806: IF p_summary_mode = 1 THEN -- fetch the rows and put them into the global tables
8807: LOOP
8808: IF DBMS_SQL.FETCH_ROWS(l_query_handle)>0 THEN
8809: DBMS_SQL.COLUMN_VALUE(l_query_handle, 1, l_wms_task_type);
8810: DBMS_SQL.COLUMN_VALUE(l_query_handle, 2, l_task_count);
8811: g_wms_task_summary_tbl(l_wms_task_type).wms_task_type := l_wms_task_type;
8812: g_wms_task_summary_tbl(l_wms_task_type).task_count := g_wms_task_summary_tbl(l_wms_task_type).task_count + l_task_count;
8813: IF l_debug = 1 THEN

Line 8810: DBMS_SQL.COLUMN_VALUE(l_query_handle, 2, l_task_count);

8806: IF p_summary_mode = 1 THEN -- fetch the rows and put them into the global tables
8807: LOOP
8808: IF DBMS_SQL.FETCH_ROWS(l_query_handle)>0 THEN
8809: DBMS_SQL.COLUMN_VALUE(l_query_handle, 1, l_wms_task_type);
8810: DBMS_SQL.COLUMN_VALUE(l_query_handle, 2, l_task_count);
8811: g_wms_task_summary_tbl(l_wms_task_type).wms_task_type := l_wms_task_type;
8812: g_wms_task_summary_tbl(l_wms_task_type).task_count := g_wms_task_summary_tbl(l_wms_task_type).task_count + l_task_count;
8813: IF l_debug = 1 THEN
8814: debug('Task Type :' || g_wms_task_summary_tbl(l_wms_task_type).wms_task_type, 'query_mo_tasks');

Line 8822: DBMS_SQL.close_cursor(l_query_handle);

8818: EXIT; -- no more rows returned from dynamic SQL
8819: END IF;
8820: END LOOP;
8821: END IF;
8822: DBMS_SQL.close_cursor(l_query_handle);
8823: END LOOP;
8824: EXCEPTION
8825: WHEN OTHERS THEN -- Bug 4150145
8826: IF dbms_sql.is_open(l_query_handle) THEN

Line 8826: IF dbms_sql.is_open(l_query_handle) THEN

8822: DBMS_SQL.close_cursor(l_query_handle);
8823: END LOOP;
8824: EXCEPTION
8825: WHEN OTHERS THEN -- Bug 4150145
8826: IF dbms_sql.is_open(l_query_handle) THEN
8827: dbms_sql.close_cursor(l_query_handle);
8828: END IF;
8829: DEBUG (SQLERRM, 'Task_planning.query_mo_tasks');
8830: END query_mo_tasks;

Line 8827: dbms_sql.close_cursor(l_query_handle);

8823: END LOOP;
8824: EXCEPTION
8825: WHEN OTHERS THEN -- Bug 4150145
8826: IF dbms_sql.is_open(l_query_handle) THEN
8827: dbms_sql.close_cursor(l_query_handle);
8828: END IF;
8829: DEBUG (SQLERRM, 'Task_planning.query_mo_tasks');
8830: END query_mo_tasks;
8831:

Line 9067: l_query_handle := DBMS_SQL.open_cursor;

9063: -- Parse, Bind and Execute the dynamic query
9064: if l_debug = 1 then
9065: debug('MO Tasks Query ' || l_query,'query_move_tasks');
9066: end if;
9067: l_query_handle := DBMS_SQL.open_cursor;
9068: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
9069:
9070: --generic bind variables
9071: IF p_organization_id IS NOT NULL

Line 9068: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);

9064: if l_debug = 1 then
9065: debug('MO Tasks Query ' || l_query,'query_move_tasks');
9066: end if;
9067: l_query_handle := DBMS_SQL.open_cursor;
9068: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
9069:
9070: --generic bind variables
9071: IF p_organization_id IS NOT NULL
9072: THEN

Line 9073: DBMS_SQL.bind_variable (l_query_handle,

9069:
9070: --generic bind variables
9071: IF p_organization_id IS NOT NULL
9072: THEN
9073: DBMS_SQL.bind_variable (l_query_handle,
9074: 'org_id',
9075: p_organization_id
9076: );
9077: END IF;

Line 9081: DBMS_SQL.bind_variable (l_query_handle,

9077: END IF;
9078:
9079: IF p_subinventory_code IS NOT NULL
9080: THEN
9081: DBMS_SQL.bind_variable (l_query_handle,
9082: 'sub_code',
9083: p_subinventory_code
9084: );
9085: END IF;

Line 9089: DBMS_SQL.bind_variable (l_query_handle, 'loc_id', p_locator_id);

9085: END IF;
9086:
9087: IF p_locator_id IS NOT NULL
9088: THEN
9089: DBMS_SQL.bind_variable (l_query_handle, 'loc_id', p_locator_id);
9090: END IF;
9091:
9092: IF p_to_subinventory_code IS NOT NULL
9093: THEN

Line 9094: DBMS_SQL.bind_variable (l_query_handle,

9090: END IF;
9091:
9092: IF p_to_subinventory_code IS NOT NULL
9093: THEN
9094: DBMS_SQL.bind_variable (l_query_handle,
9095: 'to_sub_code',
9096: p_to_subinventory_code
9097: );
9098: END IF;

Line 9102: DBMS_SQL.bind_variable (l_query_handle,

9098: END IF;
9099:
9100: IF p_to_locator_id IS NOT NULL
9101: THEN
9102: DBMS_SQL.bind_variable (l_query_handle,
9103: 'to_loc_id',
9104: p_to_locator_id
9105: );
9106: END IF;

Line 9110: DBMS_SQL.bind_variable (l_query_handle,

9106: END IF;
9107:
9108: IF p_category_set_id IS NOT NULL
9109: THEN
9110: DBMS_SQL.bind_variable (l_query_handle,
9111: 'category_set_id',
9112: p_category_set_id
9113: );
9114: END IF;

Line 9118: DBMS_SQL.bind_variable (l_query_handle,

9114: END IF;
9115:
9116: IF p_inventory_item_id IS NOT NULL
9117: THEN
9118: DBMS_SQL.bind_variable (l_query_handle,
9119: 'item_id',
9120: p_inventory_item_id
9121: );
9122: END IF;

Line 9127: DBMS_SQL.bind_variable (l_query_handle,

9123:
9124: -- R12 : Additional Query Criteria using item type
9125: IF p_item_type_code IS NOT NULL
9126: THEN
9127: DBMS_SQL.bind_variable (l_query_handle,
9128: 'item_type_code',
9129: p_item_type_code
9130: );
9131: END IF;

Line 9136: DBMS_SQL.bind_variable (l_query_handle,

9132:
9133:
9134: IF p_item_category_id IS NOT NULL
9135: THEN
9136: DBMS_SQL.bind_variable (l_query_handle,
9137: 'item_category_id',
9138: p_item_category_id
9139: );
9140: END IF;

Line 9144: DBMS_SQL.bind_variable (l_query_handle, 'person_id', p_person_id);

9140: END IF;
9141:
9142: IF p_person_id IS NOT NULL
9143: THEN
9144: DBMS_SQL.bind_variable (l_query_handle, 'person_id', p_person_id);
9145: END IF;
9146:
9147: IF p_person_resource_id IS NOT NULL
9148: THEN

Line 9149: DBMS_SQL.bind_variable (l_query_handle,

9145: END IF;
9146:
9147: IF p_person_resource_id IS NOT NULL
9148: THEN
9149: DBMS_SQL.bind_variable (l_query_handle,
9150: 'person_resource_id',
9151: p_person_resource_id
9152: );
9153: END IF;

Line 9157: DBMS_SQL.bind_variable (l_query_handle,

9153: END IF;
9154:
9155: IF p_equipment_type_id IS NOT NULL
9156: THEN
9157: DBMS_SQL.bind_variable (l_query_handle,
9158: 'equipment_type_id',
9159: p_equipment_type_id
9160: );
9161: END IF;

Line 9165: DBMS_SQL.bind_variable (l_query_handle,

9161: END IF;
9162:
9163: IF p_machine_resource_id IS NOT NULL
9164: THEN
9165: DBMS_SQL.bind_variable (l_query_handle,
9166: 'machine_resource_id',
9167: p_machine_resource_id
9168: );
9169: END IF;

Line 9173: DBMS_SQL.bind_variable (l_query_handle,

9169: END IF;
9170:
9171: IF p_machine_instance IS NOT NULL
9172: THEN
9173: DBMS_SQL.bind_variable (l_query_handle,
9174: 'machine_instance',
9175: p_machine_instance
9176: );
9177: END IF;

Line 9181: DBMS_SQL.bind_variable (l_query_handle,

9177: END IF;
9178:
9179: IF p_user_task_type_id IS NOT NULL
9180: THEN
9181: DBMS_SQL.bind_variable (l_query_handle,
9182: 'user_task_type_id',
9183: p_user_task_type_id
9184: );
9185: END IF;

Line 9189: DBMS_SQL.bind_variable (l_query_handle,

9185: END IF;
9186:
9187: IF p_from_task_quantity IS NOT NULL
9188: THEN
9189: DBMS_SQL.bind_variable (l_query_handle,
9190: 'from_task_quantity',
9191: p_from_task_quantity
9192: );
9193: END IF;

Line 9197: DBMS_SQL.bind_variable (l_query_handle,

9193: END IF;
9194:
9195: IF p_to_task_quantity IS NOT NULL
9196: THEN
9197: DBMS_SQL.bind_variable (l_query_handle,
9198: 'to_task_quantity',
9199: p_to_task_quantity
9200: );
9201: END IF;

Line 9205: DBMS_SQL.bind_variable (l_query_handle,

9201: END IF;
9202:
9203: IF p_from_task_priority IS NOT NULL
9204: THEN
9205: DBMS_SQL.bind_variable (l_query_handle,
9206: 'from_task_priority',
9207: p_from_task_priority
9208: );
9209: END IF;

Line 9213: DBMS_SQL.bind_variable (l_query_handle,

9209: END IF;
9210:
9211: IF p_to_task_priority IS NOT NULL
9212: THEN
9213: DBMS_SQL.bind_variable (l_query_handle,
9214: 'to_task_priority',
9215: p_to_task_priority
9216: );
9217: END IF;

Line 9221: DBMS_SQL.bind_variable (l_query_handle,

9217: END IF;
9218:
9219: IF p_from_creation_date IS NOT NULL
9220: THEN
9221: DBMS_SQL.bind_variable (l_query_handle,
9222: 'from_creation_date',
9223: p_from_creation_date
9224: );
9225: END IF;

Line 9229: DBMS_SQL.bind_variable (l_query_handle,

9225: END IF;
9226:
9227: IF p_to_creation_date IS NOT NULL
9228: THEN
9229: DBMS_SQL.bind_variable (l_query_handle,
9230: 'to_creation_date',
9231: p_to_creation_date
9232: );
9233: END IF;

Line 9241: DBMS_SQL.bind_variable (l_query_handle,

9237: THEN
9238:
9239: IF p_age_min IS NOT NULL
9240: THEN
9241: DBMS_SQL.bind_variable (l_query_handle,
9242: 'age_min',
9243: p_age_min
9244: );
9245: END IF;

Line 9249: DBMS_SQL.bind_variable (l_query_handle,

9245: END IF;
9246:
9247: IF p_age_max IS NOT NULL
9248: THEN
9249: DBMS_SQL.bind_variable (l_query_handle,
9250: 'age_max',
9251: p_age_max
9252: );
9253:

Line 9258: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);

9254: END IF;
9255: END IF;
9256:
9257: --execute the replenishment query
9258: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);
9259: g_record_count := g_record_count + l_query_count;
9260: DBMS_SQL.close_cursor(l_query_handle);
9261: END LOOP;
9262: EXCEPTION

Line 9260: DBMS_SQL.close_cursor(l_query_handle);

9256:
9257: --execute the replenishment query
9258: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);
9259: g_record_count := g_record_count + l_query_count;
9260: DBMS_SQL.close_cursor(l_query_handle);
9261: END LOOP;
9262: EXCEPTION
9263: WHEN OTHERS THEN -- Bug 4150145
9264: IF dbms_sql.is_open(l_query_handle) THEN

Line 9264: IF dbms_sql.is_open(l_query_handle) THEN

9260: DBMS_SQL.close_cursor(l_query_handle);
9261: END LOOP;
9262: EXCEPTION
9263: WHEN OTHERS THEN -- Bug 4150145
9264: IF dbms_sql.is_open(l_query_handle) THEN
9265: dbms_sql.close_cursor(l_query_handle);
9266: END IF;
9267: DEBUG (SQLERRM, 'Task_planning.query_mo_tasks');
9268: END query_move_tasks;

Line 9265: dbms_sql.close_cursor(l_query_handle);

9261: END LOOP;
9262: EXCEPTION
9263: WHEN OTHERS THEN -- Bug 4150145
9264: IF dbms_sql.is_open(l_query_handle) THEN
9265: dbms_sql.close_cursor(l_query_handle);
9266: END IF;
9267: DEBUG (SQLERRM, 'Task_planning.query_mo_tasks');
9268: END query_move_tasks;
9269: