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 3932: l_query_handle := DBMS_SQL.open_cursor;

3928: || l_select_generic
3929: || l_from_generic
3930: || l_where_generic;
3931: -- Parse, Bind and Execute the dynamic query
3932: l_query_handle := DBMS_SQL.open_cursor;
3933: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
3934:
3935: IF p_from_task_quantity IS NOT NULL
3936: THEN

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

3929: || l_from_generic
3930: || l_where_generic;
3931: -- Parse, Bind and Execute the dynamic query
3932: l_query_handle := DBMS_SQL.open_cursor;
3933: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
3934:
3935: IF p_from_task_quantity IS NOT NULL
3936: THEN
3937: DBMS_SQL.bind_variable (l_query_handle,

Line 3937: DBMS_SQL.bind_variable (l_query_handle,

3933: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
3934:
3935: IF p_from_task_quantity IS NOT NULL
3936: THEN
3937: DBMS_SQL.bind_variable (l_query_handle,
3938: 'from_task_quantity',
3939: p_from_task_quantity
3940: );
3941: END IF;

Line 3945: DBMS_SQL.bind_variable (l_query_handle,

3941: END IF;
3942:
3943: IF p_to_task_quantity IS NOT NULL
3944: THEN
3945: DBMS_SQL.bind_variable (l_query_handle,
3946: 'to_task_quantity',
3947: p_to_task_quantity
3948: );
3949: END IF;

Line 3953: DBMS_SQL.bind_variable (l_query_handle,

3949: END IF;
3950:
3951: /* Bug 5446146 */
3952: IF p_person_id IS NOT NULL THEN
3953: DBMS_SQL.bind_variable (l_query_handle,
3954: 'person_id',
3955: p_person_id);
3956: END IF;
3957:

Line 3959: DBMS_SQL.bind_variable (l_query_handle,

3955: p_person_id);
3956: END IF;
3957:
3958: IF p_person_resource_id IS NOT NULL THEN
3959: DBMS_SQL.bind_variable (l_query_handle,
3960: 'person_resource_id',
3961: p_person_resource_id);
3962: END IF;
3963:

Line 3965: DBMS_SQL.bind_variable (l_query_handle,

3961: p_person_resource_id);
3962: END IF;
3963:
3964: IF p_equipment_type_id IS NOT NULL THEN
3965: DBMS_SQL.bind_variable (l_query_handle,
3966: 'equipment_type_id',
3967: p_equipment_type_id
3968: );
3969: END IF;

Line 3972: DBMS_SQL.bind_variable (l_query_handle,

3968: );
3969: END IF;
3970:
3971: IF p_machine_resource_id IS NOT NULL THEN
3972: DBMS_SQL.bind_variable (l_query_handle,
3973: 'machine_resource_id',
3974: p_machine_resource_id
3975: );
3976: END IF;

Line 3979: DBMS_SQL.bind_variable (l_query_handle,

3975: );
3976: END IF;
3977:
3978: IF p_machine_instance IS NOT NULL THEN
3979: DBMS_SQL.bind_variable (l_query_handle,
3980: 'machine_instance',
3981: p_machine_instance
3982: );
3983: END IF;

Line 3987: DBMS_SQL.bind_variable (l_query_handle,

3983: END IF;
3984:
3985: IF p_user_task_type_id IS NOT NULL
3986: THEN
3987: DBMS_SQL.bind_variable (l_query_handle,
3988: 'user_task_type_id',
3989: p_user_task_type_id
3990: );
3991: END IF;

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

3990: );
3991: END IF;
3992: /* End of Bug 5446146 */
3993:
3994: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);
3995: g_record_count := g_record_count + l_query_count;
3996: x_non_complete_parent := l_query_count;
3997: DBMS_SQL.close_cursor(l_query_handle);
3998:

Line 3997: DBMS_SQL.close_cursor(l_query_handle);

3993:
3994: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);
3995: g_record_count := g_record_count + l_query_count;
3996: x_non_complete_parent := l_query_count;
3997: DBMS_SQL.close_cursor(l_query_handle);
3998:
3999: -- Delete the child tasks from the temp table
4000: --Bulk Picking Enhancement:
4001: --Added the condition status_id <> 6 because we want to show

Line 4161: l_query_handle := DBMS_SQL.open_cursor;

4157: || l_select_generic
4158: || l_from_generic
4159: || l_where_generic;
4160: -- Parse, Bind and Execute the dynamic query
4161: l_query_handle := DBMS_SQL.open_cursor;
4162: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
4163: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);
4164: g_record_count := g_record_count + l_query_count;
4165: DBMS_SQL.close_cursor(l_query_handle);

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

4158: || l_from_generic
4159: || l_where_generic;
4160: -- Parse, Bind and Execute the dynamic query
4161: l_query_handle := DBMS_SQL.open_cursor;
4162: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
4163: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);
4164: g_record_count := g_record_count + l_query_count;
4165: DBMS_SQL.close_cursor(l_query_handle);
4166: END IF;

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

4159: || l_where_generic;
4160: -- Parse, Bind and Execute the dynamic query
4161: l_query_handle := DBMS_SQL.open_cursor;
4162: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
4163: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);
4164: g_record_count := g_record_count + l_query_count;
4165: DBMS_SQL.close_cursor(l_query_handle);
4166: END IF;
4167: EXCEPTION

Line 4165: DBMS_SQL.close_cursor(l_query_handle);

4161: l_query_handle := DBMS_SQL.open_cursor;
4162: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
4163: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);
4164: g_record_count := g_record_count + l_query_count;
4165: DBMS_SQL.close_cursor(l_query_handle);
4166: END IF;
4167: EXCEPTION
4168: WHEN OTHERS THEN -- Bug 4150145
4169: IF dbms_sql.is_open(l_query_handle) THEN

Line 4169: IF dbms_sql.is_open(l_query_handle) THEN

4165: DBMS_SQL.close_cursor(l_query_handle);
4166: END IF;
4167: EXCEPTION
4168: WHEN OTHERS THEN -- Bug 4150145
4169: IF dbms_sql.is_open(l_query_handle) THEN
4170: DBMS_SQL.close_cursor(l_query_handle);
4171: END IF;
4172: debug(Sqlerrm, 'Task_planning.populate_merged_tasks');
4173: END populate_merged_tasks;

Line 4170: DBMS_SQL.close_cursor(l_query_handle);

4166: END IF;
4167: EXCEPTION
4168: WHEN OTHERS THEN -- Bug 4150145
4169: IF dbms_sql.is_open(l_query_handle) THEN
4170: DBMS_SQL.close_cursor(l_query_handle);
4171: END IF;
4172: debug(Sqlerrm, 'Task_planning.populate_merged_tasks');
4173: END populate_merged_tasks;
4174:

Line 5347: l_query_handle := DBMS_SQL.open_cursor;

5343: IF l_debug = 1 then
5344: debug('l_query ' || l_query,'query_outbound_tasks');
5345: END IF;
5346:
5347: l_query_handle := DBMS_SQL.open_cursor;
5348: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
5349:
5350: IF p_organization_id IS NOT NULL
5351: THEN

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

5344: debug('l_query ' || l_query,'query_outbound_tasks');
5345: END IF;
5346:
5347: l_query_handle := DBMS_SQL.open_cursor;
5348: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
5349:
5350: IF p_organization_id IS NOT NULL
5351: THEN
5352: DBMS_SQL.bind_variable (l_query_handle,

Line 5352: DBMS_SQL.bind_variable (l_query_handle,

5348: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
5349:
5350: IF p_organization_id IS NOT NULL
5351: THEN
5352: DBMS_SQL.bind_variable (l_query_handle,
5353: 'org_id',
5354: p_organization_id
5355: );
5356: END IF;

Line 5360: DBMS_SQL.bind_variable (l_query_handle,

5356: END IF;
5357:
5358: IF p_subinventory_code IS NOT NULL
5359: THEN
5360: DBMS_SQL.bind_variable (l_query_handle,
5361: 'sub_code',
5362: p_subinventory_code
5363: );
5364: END IF;

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

5364: END IF;
5365:
5366: IF p_locator_id IS NOT NULL
5367: THEN
5368: DBMS_SQL.bind_variable (l_query_handle, 'loc_id', p_locator_id);
5369: END IF;
5370:
5371: IF p_to_subinventory_code IS NOT NULL
5372: THEN

Line 5373: DBMS_SQL.bind_variable (l_query_handle,

5369: END IF;
5370:
5371: IF p_to_subinventory_code IS NOT NULL
5372: THEN
5373: DBMS_SQL.bind_variable (l_query_handle,
5374: 'to_sub_code',
5375: p_to_subinventory_code
5376: );
5377: END IF;

Line 5381: DBMS_SQL.bind_variable (l_query_handle,

5377: END IF;
5378:
5379: IF p_to_locator_id IS NOT NULL
5380: THEN
5381: DBMS_SQL.bind_variable (l_query_handle,
5382: 'to_loc_id',
5383: p_to_locator_id
5384: );
5385: END IF;

Line 5389: DBMS_SQL.bind_variable (l_query_handle,

5385: END IF;
5386:
5387: IF p_inventory_item_id IS NOT NULL
5388: THEN
5389: DBMS_SQL.bind_variable (l_query_handle,
5390: 'item_id',
5391: p_inventory_item_id
5392: );
5393: END IF;

Line 5398: DBMS_SQL.bind_variable (l_query_handle,

5394:
5395: -- R12 : Additional Query Criteria using item type
5396: IF p_item_type_code IS NOT NULL
5397: THEN
5398: DBMS_SQL.bind_variable (l_query_handle,
5399: 'item_type_code',
5400: p_item_type_code
5401: );
5402: END IF;

Line 5406: DBMS_SQL.bind_variable (l_query_handle,

5402: END IF;
5403:
5404: IF p_category_set_id IS NOT NULL
5405: THEN
5406: DBMS_SQL.bind_variable (l_query_handle,
5407: 'category_set_id',
5408: p_category_set_id
5409: );
5410: END IF;

Line 5414: DBMS_SQL.bind_variable (l_query_handle,

5410: END IF;
5411:
5412: IF p_item_category_id IS NOT NULL
5413: THEN
5414: DBMS_SQL.bind_variable (l_query_handle,
5415: 'item_category_id',
5416: p_item_category_id
5417: );
5418: END IF;

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

5427: THEN
5428:
5429: IF p_person_id IS NOT NULL
5430: THEN
5431: DBMS_SQL.bind_variable (l_query_handle, 'person_id', p_person_id);
5432: END IF;
5433:
5434: IF p_person_resource_id IS NOT NULL
5435: THEN

Line 5436: DBMS_SQL.bind_variable (l_query_handle,

5432: END IF;
5433:
5434: IF p_person_resource_id IS NOT NULL
5435: THEN
5436: DBMS_SQL.bind_variable (l_query_handle,
5437: 'person_resource_id',
5438: p_person_resource_id
5439: );
5440: END IF;

Line 5444: DBMS_SQL.bind_variable (l_query_handle,

5440: END IF;
5441:
5442: IF p_equipment_type_id IS NOT NULL
5443: THEN
5444: DBMS_SQL.bind_variable (l_query_handle,
5445: 'equipment_type_id',
5446: p_equipment_type_id
5447: );
5448: END IF;

Line 5452: DBMS_SQL.bind_variable (l_query_handle,

5448: END IF;
5449:
5450: IF p_machine_resource_id IS NOT NULL
5451: THEN
5452: DBMS_SQL.bind_variable (l_query_handle,
5453: 'machine_resource_id',
5454: p_machine_resource_id
5455: );
5456: END IF;

Line 5460: DBMS_SQL.bind_variable (l_query_handle,

5456: END IF;
5457:
5458: IF p_machine_instance IS NOT NULL
5459: THEN
5460: DBMS_SQL.bind_variable (l_query_handle,
5461: 'machine_instance',
5462: p_machine_instance
5463: );
5464: END IF;

Line 5469: DBMS_SQL.bind_variable (l_query_handle,

5465: END IF;--4459382
5466:
5467: IF p_user_task_type_id IS NOT NULL
5468: THEN
5469: DBMS_SQL.bind_variable (l_query_handle,
5470: 'user_task_type_id',
5471: p_user_task_type_id
5472: );
5473: END IF;

Line 5477: DBMS_SQL.bind_variable (l_query_handle,

5473: END IF;
5474:
5475: IF p_from_task_quantity IS NOT NULL
5476: THEN
5477: DBMS_SQL.bind_variable (l_query_handle,
5478: 'from_task_quantity',
5479: p_from_task_quantity
5480: );
5481: END IF;

Line 5485: DBMS_SQL.bind_variable (l_query_handle,

5481: END IF;
5482:
5483: IF p_to_task_quantity IS NOT NULL
5484: THEN
5485: DBMS_SQL.bind_variable (l_query_handle,
5486: 'to_task_quantity',
5487: p_to_task_quantity
5488: );
5489: END IF;

Line 5493: DBMS_SQL.bind_variable (l_query_handle,

5489: END IF;
5490:
5491: IF p_from_task_priority IS NOT NULL
5492: THEN
5493: DBMS_SQL.bind_variable (l_query_handle,
5494: 'from_task_priority',
5495: p_from_task_priority
5496: );
5497: END IF;

Line 5501: DBMS_SQL.bind_variable (l_query_handle,

5497: END IF;
5498:
5499: IF p_to_task_priority IS NOT NULL
5500: THEN
5501: DBMS_SQL.bind_variable (l_query_handle,
5502: 'to_task_priority',
5503: p_to_task_priority
5504: );
5505: END IF;

Line 5510: DBMS_SQL.bind_variable (l_query_handle,

5506:
5507: IF p_from_creation_date IS NOT NULL
5508: THEN
5509: IF g_is_api_call THEN --Bug 13594691
5510: DBMS_SQL.bind_variable (l_query_handle,
5511: 'from_creation_date',
5512: -- p_from_creation_date --commented in 6868286
5513: TRUNC(p_from_creation_date) --added in 6868286
5514: );

Line 5516: DBMS_SQL.bind_variable (l_query_handle,

5512: -- p_from_creation_date --commented in 6868286
5513: TRUNC(p_from_creation_date) --added in 6868286
5514: );
5515: ELSE --Bug 13594691
5516: DBMS_SQL.bind_variable (l_query_handle,
5517: 'from_creation_date',
5518: p_from_creation_date
5519: );
5520: END IF;

Line 5526: DBMS_SQL.bind_variable (l_query_handle,

5522:
5523: IF p_to_creation_date IS NOT NULL
5524: THEN
5525: IF g_is_api_call THEN --Bug 13594691
5526: DBMS_SQL.bind_variable (l_query_handle,
5527: 'to_creation_date',
5528: --p_to_creation_date --commented in 6868286
5529: TRUNC(p_to_creation_date) --added in 6868286
5530: );

Line 5532: DBMS_SQL.bind_variable (l_query_handle,

5528: --p_to_creation_date --commented in 6868286
5529: TRUNC(p_to_creation_date) --added in 6868286
5530: );
5531: ELSE --Bug 13594691
5532: DBMS_SQL.bind_variable (l_query_handle,
5533: 'to_creation_date',
5534: p_to_creation_date
5535: );
5536: END IF;

Line 5546: DBMS_SQL.bind_variable (l_query_handle,

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

Line 5554: DBMS_SQL.bind_variable (l_query_handle,

5550: END IF;
5551:
5552: IF p_age_max IS NOT NULL
5553: THEN
5554: DBMS_SQL.bind_variable (l_query_handle,
5555: 'age_max',
5556: p_age_max
5557: );
5558:

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

5560: END IF;
5561:
5562: IF p_include_internal_orders AND NOT p_include_sales_orders
5563: THEN
5564: DBMS_SQL.bind_variable (l_query_handle, 'source_type_id', 8);
5565: ELSIF NOT p_include_internal_orders AND p_include_sales_orders
5566: THEN
5567: DBMS_SQL.bind_variable (l_query_handle, 'source_type_id', 2);
5568: END IF;

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

5563: THEN
5564: DBMS_SQL.bind_variable (l_query_handle, 'source_type_id', 8);
5565: ELSIF NOT p_include_internal_orders AND p_include_sales_orders
5566: THEN
5567: DBMS_SQL.bind_variable (l_query_handle, 'source_type_id', 2);
5568: END IF;
5569:
5570: /*added if else for 3455109 since we are changing the query also need to change binds if its for completed task*/
5571: IF (i=1 OR i=3) /*old code*/ then --ER13869750

Line 5575: DBMS_SQL.bind_variable (l_query_handle,

5571: IF (i=1 OR i=3) /*old code*/ then --ER13869750
5572:
5573: IF p_from_sales_order_id IS NOT NULL
5574: THEN
5575: DBMS_SQL.bind_variable (l_query_handle,
5576: 'from_sales_order_id',
5577: p_from_sales_order_id
5578: );
5579: END IF;

Line 5583: DBMS_SQL.bind_variable (l_query_handle,

5579: END IF;
5580:
5581: IF p_to_sales_order_id IS NOT NULL
5582: THEN
5583: DBMS_SQL.bind_variable (l_query_handle,
5584: 'to_sales_order_id',
5585: p_to_sales_order_id
5586: );
5587: END IF;

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

5587: END IF;
5588: ELSE --completed tasks
5589: IF(l_is_range_so) then
5590: IF p_from_sales_order_id IS NOT NULL THEN
5591: --3240261 dbms_sql.bind_variable(l_query_handle, 'from_sales_order_id', p_from_sales_order_id);
5592: dbms_sql.bind_variable(l_query_handle,'l_from_tonum_mso_seg1',l_from_tonum_mso_seg1);--added for 3455109
5593: dbms_sql.bind_variable(l_query_handle,'l_from_mso_seg2',l_from_mso_seg2);--3455109
5594: END IF;
5595:

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

5588: ELSE --completed tasks
5589: IF(l_is_range_so) then
5590: IF p_from_sales_order_id IS NOT NULL THEN
5591: --3240261 dbms_sql.bind_variable(l_query_handle, 'from_sales_order_id', p_from_sales_order_id);
5592: dbms_sql.bind_variable(l_query_handle,'l_from_tonum_mso_seg1',l_from_tonum_mso_seg1);--added for 3455109
5593: dbms_sql.bind_variable(l_query_handle,'l_from_mso_seg2',l_from_mso_seg2);--3455109
5594: END IF;
5595:
5596: IF p_to_sales_order_id IS NOT NULL THEN

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

5589: IF(l_is_range_so) then
5590: IF p_from_sales_order_id IS NOT NULL THEN
5591: --3240261 dbms_sql.bind_variable(l_query_handle, 'from_sales_order_id', p_from_sales_order_id);
5592: dbms_sql.bind_variable(l_query_handle,'l_from_tonum_mso_seg1',l_from_tonum_mso_seg1);--added for 3455109
5593: dbms_sql.bind_variable(l_query_handle,'l_from_mso_seg2',l_from_mso_seg2);--3455109
5594: END IF;
5595:
5596: IF p_to_sales_order_id IS NOT NULL THEN
5597: --3420261 dbms_sql.bind_variable(l_query_handle, 'to_sales_order_id', p_to_sales_order_id);

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

5593: dbms_sql.bind_variable(l_query_handle,'l_from_mso_seg2',l_from_mso_seg2);--3455109
5594: END IF;
5595:
5596: IF p_to_sales_order_id IS NOT NULL THEN
5597: --3420261 dbms_sql.bind_variable(l_query_handle, 'to_sales_order_id', p_to_sales_order_id);
5598: dbms_sql.bind_variable(l_query_handle,'l_to_tonum_mso_seg1',l_to_tonum_mso_seg1);
5599: dbms_sql.bind_variable(l_query_handle,'l_to_mso_seg2',l_to_mso_seg2);
5600: END IF;
5601: ELSE

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

5594: END IF;
5595:
5596: IF p_to_sales_order_id IS NOT NULL THEN
5597: --3420261 dbms_sql.bind_variable(l_query_handle, 'to_sales_order_id', p_to_sales_order_id);
5598: dbms_sql.bind_variable(l_query_handle,'l_to_tonum_mso_seg1',l_to_tonum_mso_seg1);
5599: dbms_sql.bind_variable(l_query_handle,'l_to_mso_seg2',l_to_mso_seg2);
5600: END IF;
5601: ELSE
5602: dbms_sql.bind_variable(l_query_handle,'l_from_mso_seg1',l_from_mso_seg1);

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

5595:
5596: IF p_to_sales_order_id IS NOT NULL THEN
5597: --3420261 dbms_sql.bind_variable(l_query_handle, 'to_sales_order_id', p_to_sales_order_id);
5598: dbms_sql.bind_variable(l_query_handle,'l_to_tonum_mso_seg1',l_to_tonum_mso_seg1);
5599: dbms_sql.bind_variable(l_query_handle,'l_to_mso_seg2',l_to_mso_seg2);
5600: END IF;
5601: ELSE
5602: dbms_sql.bind_variable(l_query_handle,'l_from_mso_seg1',l_from_mso_seg1);
5603: dbms_sql.bind_variable(l_query_handle,'l_from_mso_seg2',l_from_mso_seg2);

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

5598: dbms_sql.bind_variable(l_query_handle,'l_to_tonum_mso_seg1',l_to_tonum_mso_seg1);
5599: dbms_sql.bind_variable(l_query_handle,'l_to_mso_seg2',l_to_mso_seg2);
5600: END IF;
5601: ELSE
5602: dbms_sql.bind_variable(l_query_handle,'l_from_mso_seg1',l_from_mso_seg1);
5603: dbms_sql.bind_variable(l_query_handle,'l_from_mso_seg2',l_from_mso_seg2);
5604: END IF;--end of range or not range so
5605: END IF;--end of copleted or not completed task 3455109
5606:

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

5599: dbms_sql.bind_variable(l_query_handle,'l_to_mso_seg2',l_to_mso_seg2);
5600: END IF;
5601: ELSE
5602: dbms_sql.bind_variable(l_query_handle,'l_from_mso_seg1',l_from_mso_seg1);
5603: dbms_sql.bind_variable(l_query_handle,'l_from_mso_seg2',l_from_mso_seg2);
5604: END IF;--end of range or not range so
5605: END IF;--end of copleted or not completed task 3455109
5606:
5607: IF p_from_pick_slip_number IS NOT NULL

Line 5609: DBMS_SQL.bind_variable (l_query_handle,

5605: END IF;--end of copleted or not completed task 3455109
5606:
5607: IF p_from_pick_slip_number IS NOT NULL
5608: THEN
5609: DBMS_SQL.bind_variable (l_query_handle,
5610: 'from_pick_slip_number',
5611: p_from_pick_slip_number
5612: );
5613: END IF;

Line 5617: DBMS_SQL.bind_variable (l_query_handle,

5613: END IF;
5614:
5615: IF p_to_pick_slip_number IS NOT NULL
5616: THEN
5617: DBMS_SQL.bind_variable (l_query_handle,
5618: 'to_pick_slip_number',
5619: p_to_pick_slip_number
5620: );
5621: END IF;

Line 5625: DBMS_SQL.bind_variable (l_query_handle,

5621: END IF;
5622:
5623: IF p_wave_header_id IS NOT NULL
5624: THEN
5625: DBMS_SQL.bind_variable (l_query_handle,
5626: 'wave_header_id',
5627: p_wave_header_id
5628: );
5629: END IF;

Line 5633: DBMS_SQL.bind_variable (l_query_handle,

5629: END IF;
5630:
5631: IF p_customer_id IS NOT NULL
5632: THEN
5633: DBMS_SQL.bind_variable (l_query_handle,
5634: 'customer_id',
5635: p_customer_id
5636: );
5637: END IF;

Line 5641: DBMS_SQL.bind_variable (l_query_handle,

5637: END IF;
5638:
5639: IF p_customer_category IS NOT NULL
5640: THEN
5641: DBMS_SQL.bind_variable (l_query_handle,
5642: 'customer_category',
5643: p_customer_category
5644: );
5645: END IF;

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

5645: END IF;
5646:
5647: IF p_trip_id IS NOT NULL
5648: THEN
5649: DBMS_SQL.bind_variable (l_query_handle, 'trip_id', p_trip_id);
5650: END IF;
5651:
5652: IF p_delivery_id IS NOT NULL
5653: THEN

Line 5654: DBMS_SQL.bind_variable (l_query_handle,

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

Line 5662: DBMS_SQL.bind_variable (l_query_handle,

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

Line 5670: DBMS_SQL.bind_variable (l_query_handle,

5666: END IF;
5667:
5668: IF p_ship_method IS NOT NULL
5669: THEN
5670: DBMS_SQL.bind_variable (l_query_handle,
5671: 'ship_method',
5672: p_ship_method
5673: );
5674: END IF;

Line 5678: DBMS_SQL.bind_variable (l_query_handle,

5674: END IF;
5675:
5676: IF p_order_type_id IS NOT NULL
5677: THEN
5678: DBMS_SQL.bind_variable (l_query_handle,
5679: 'p_order_type_id',
5680: p_order_type_id
5681: );
5682: END IF;

Line 5686: DBMS_SQL.bind_variable (l_query_handle,

5682: END IF;
5683:
5684: IF p_shipment_priority IS NOT NULL
5685: THEN
5686: DBMS_SQL.bind_variable (l_query_handle,
5687: 'shipment_priority',
5688: p_shipment_priority
5689: );
5690: END IF;

Line 5694: DBMS_SQL.bind_variable (l_query_handle,

5690: END IF;
5691:
5692: IF p_from_shipment_date IS NOT NULL
5693: THEN
5694: DBMS_SQL.bind_variable (l_query_handle,
5695: 'from_shipment_date',
5696: p_from_shipment_date
5697: );
5698: END IF;

Line 5702: DBMS_SQL.bind_variable (l_query_handle,

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

Line 5710: DBMS_SQL.bind_variable (l_query_handle,

5706: END IF;
5707:
5708: IF p_time_till_shipment IS NOT NULL AND p_time_till_shipment_uom_code IS NOT NULL
5709: THEN
5710: DBMS_SQL.bind_variable (l_query_handle,
5711: 'p_time_till_shipment',
5712: p_time_till_shipment
5713: );
5714: END IF;

Line 5718: DBMS_SQL.bind_variable (l_query_handle,

5714: END IF;
5715:
5716: IF p_time_till_appt IS NOT NULL AND p_time_till_appt_uom_code IS NOT NULL
5717: THEN
5718: DBMS_SQL.bind_variable (l_query_handle,
5719: 'p_time_till_appt',
5720: p_time_till_appt
5721: );
5722: END IF;

Line 5727: DBMS_SQL.bind_variable (l_query_handle,

5723:
5724:
5725: IF p_ship_to_state IS NOT NULL
5726: THEN
5727: DBMS_SQL.bind_variable (l_query_handle,
5728: 'ship_to_state',
5729: p_ship_to_state
5730: );
5731: END IF;

Line 5735: DBMS_SQL.bind_variable (l_query_handle,

5731: END IF;
5732:
5733: IF p_ship_to_country IS NOT NULL
5734: THEN
5735: DBMS_SQL.bind_variable (l_query_handle,
5736: 'ship_to_country',
5737: p_ship_to_country
5738: );
5739: END IF;

Line 5743: DBMS_SQL.bind_variable (l_query_handle,

5739: END IF;
5740:
5741: IF p_ship_to_postal_code IS NOT NULL
5742: THEN
5743: DBMS_SQL.bind_variable (l_query_handle,
5744: 'ship_to_postal_code',
5745: p_ship_to_postal_code
5746: );
5747: END IF;

Line 5751: DBMS_SQL.bind_variable (l_query_handle,

5747: END IF;
5748:
5749: IF p_from_number_of_order_lines IS NOT NULL
5750: THEN
5751: DBMS_SQL.bind_variable (l_query_handle,
5752: 'from_number_of_order_lines',
5753: p_from_number_of_order_lines
5754: );
5755: END IF;

Line 5759: DBMS_SQL.bind_variable (l_query_handle,

5755: END IF;
5756:
5757: IF p_to_number_of_order_lines IS NOT NULL
5758: THEN
5759: DBMS_SQL.bind_variable (l_query_handle,
5760: 'to_number_of_order_lines',
5761: p_to_number_of_order_lines
5762: );
5763: END IF;

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

5762: );
5763: END IF;
5764:
5765: IF p_summary_mode = 1 THEN
5766: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 1, l_wms_task_type);
5767: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 2, l_task_count);
5768: END IF;
5769:
5770: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);

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

5763: END IF;
5764:
5765: IF p_summary_mode = 1 THEN
5766: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 1, l_wms_task_type);
5767: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 2, l_task_count);
5768: END IF;
5769:
5770: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);
5771: g_record_count := g_record_count + l_query_count;

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

5766: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 1, l_wms_task_type);
5767: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 2, l_task_count);
5768: END IF;
5769:
5770: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);
5771: g_record_count := g_record_count + l_query_count;
5772:
5773: IF p_summary_mode = 1 THEN -- fetch the rows and put them into the global tables
5774: LOOP

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

5771: g_record_count := g_record_count + l_query_count;
5772:
5773: IF p_summary_mode = 1 THEN -- fetch the rows and put them into the global tables
5774: LOOP
5775: IF DBMS_SQL.FETCH_ROWS(l_query_handle)>0 THEN
5776: DBMS_SQL.COLUMN_VALUE(l_query_handle, 1, l_wms_task_type);
5777: DBMS_SQL.COLUMN_VALUE(l_query_handle, 2, l_task_count);
5778: g_wms_task_summary_tbl(l_wms_task_type).wms_task_type := l_wms_task_type;
5779: 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 5776: DBMS_SQL.COLUMN_VALUE(l_query_handle, 1, l_wms_task_type);

5772:
5773: IF p_summary_mode = 1 THEN -- fetch the rows and put them into the global tables
5774: LOOP
5775: IF DBMS_SQL.FETCH_ROWS(l_query_handle)>0 THEN
5776: DBMS_SQL.COLUMN_VALUE(l_query_handle, 1, l_wms_task_type);
5777: DBMS_SQL.COLUMN_VALUE(l_query_handle, 2, l_task_count);
5778: g_wms_task_summary_tbl(l_wms_task_type).wms_task_type := l_wms_task_type;
5779: 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;
5780: IF l_debug = 1 then

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

5773: IF p_summary_mode = 1 THEN -- fetch the rows and put them into the global tables
5774: LOOP
5775: IF DBMS_SQL.FETCH_ROWS(l_query_handle)>0 THEN
5776: DBMS_SQL.COLUMN_VALUE(l_query_handle, 1, l_wms_task_type);
5777: DBMS_SQL.COLUMN_VALUE(l_query_handle, 2, l_task_count);
5778: g_wms_task_summary_tbl(l_wms_task_type).wms_task_type := l_wms_task_type;
5779: 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;
5780: IF l_debug = 1 then
5781: debug('Task Type :' || g_wms_task_summary_tbl(l_wms_task_type).wms_task_type, 'query_outbound_tasks');

Line 5789: DBMS_SQL.close_cursor(l_query_handle);

5785: EXIT; -- no more rows returned from dynamic SQL
5786: END IF;
5787: END LOOP;
5788: END IF;
5789: DBMS_SQL.close_cursor(l_query_handle);
5790: IF l_debug = 1 then
5791: debug('l_query end '); --ER13869750
5792: END IF;
5793: END IF; --atleast one status --ER13869750

Line 5797: IF dbms_sql.is_open(l_query_handle) THEN

5793: END IF; --atleast one status --ER13869750
5794: END LOOP;
5795: EXCEPTION
5796: WHEN OTHERS THEN -- Bug 4150145
5797: IF dbms_sql.is_open(l_query_handle) THEN
5798: DBMS_SQL.close_cursor(l_query_handle);
5799: END IF;
5800: DEBUG (SQLERRM, 'Task_planning.query_outbound_tasks');
5801: END query_outbound_tasks;

Line 5798: DBMS_SQL.close_cursor(l_query_handle);

5794: END LOOP;
5795: EXCEPTION
5796: WHEN OTHERS THEN -- Bug 4150145
5797: IF dbms_sql.is_open(l_query_handle) THEN
5798: DBMS_SQL.close_cursor(l_query_handle);
5799: END IF;
5800: DEBUG (SQLERRM, 'Task_planning.query_outbound_tasks');
5801: END query_outbound_tasks;
5802:

Line 6312: l_query_handle := DBMS_SQL.open_cursor;

6308: || l_from_inbound
6309: || l_where_generic
6310: || l_where_inbound;
6311: -- Parse, Bind and Execute the dynamic query
6312: l_query_handle := DBMS_SQL.open_cursor;
6313: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
6314:
6315: --generic bind variables
6316: IF p_organization_id IS NOT NULL

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

6309: || l_where_generic
6310: || l_where_inbound;
6311: -- Parse, Bind and Execute the dynamic query
6312: l_query_handle := DBMS_SQL.open_cursor;
6313: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
6314:
6315: --generic bind variables
6316: IF p_organization_id IS NOT NULL
6317: THEN

Line 6318: DBMS_SQL.bind_variable (l_query_handle,

6314:
6315: --generic bind variables
6316: IF p_organization_id IS NOT NULL
6317: THEN
6318: DBMS_SQL.bind_variable (l_query_handle,
6319: 'org_id',
6320: p_organization_id
6321: );
6322: END IF;

Line 6326: DBMS_SQL.bind_variable (l_query_handle,

6322: END IF;
6323:
6324: IF p_subinventory_code IS NOT NULL
6325: THEN
6326: DBMS_SQL.bind_variable (l_query_handle,
6327: 'sub_code',
6328: p_subinventory_code
6329: );
6330: END IF;

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

6330: END IF;
6331:
6332: IF p_locator_id IS NOT NULL
6333: THEN
6334: DBMS_SQL.bind_variable (l_query_handle, 'loc_id', p_locator_id);
6335: END IF;
6336:
6337: IF p_to_subinventory_code IS NOT NULL
6338: THEN

Line 6339: DBMS_SQL.bind_variable (l_query_handle,

6335: END IF;
6336:
6337: IF p_to_subinventory_code IS NOT NULL
6338: THEN
6339: DBMS_SQL.bind_variable (l_query_handle,
6340: 'to_sub_code',
6341: p_to_subinventory_code
6342: );
6343: END IF;

Line 6347: DBMS_SQL.bind_variable (l_query_handle,

6343: END IF;
6344:
6345: IF p_to_locator_id IS NOT NULL
6346: THEN
6347: DBMS_SQL.bind_variable (l_query_handle,
6348: 'to_loc_id',
6349: p_to_locator_id
6350: );
6351: END IF;

Line 6355: DBMS_SQL.bind_variable (l_query_handle,

6351: END IF;
6352:
6353: IF p_inventory_item_id IS NOT NULL
6354: THEN
6355: DBMS_SQL.bind_variable (l_query_handle,
6356: 'item_id',
6357: p_inventory_item_id
6358: );
6359: END IF;

Line 6364: DBMS_SQL.bind_variable (l_query_handle,

6360:
6361: -- R12 : Additional Query Criteria using item type
6362: IF p_item_type_code IS NOT NULL
6363: THEN
6364: DBMS_SQL.bind_variable (l_query_handle,
6365: 'item_type_code',
6366: p_item_type_code
6367: );
6368: END IF;

Line 6373: DBMS_SQL.bind_variable (l_query_handle,

6369:
6370:
6371: IF p_category_set_id IS NOT NULL
6372: THEN
6373: DBMS_SQL.bind_variable (l_query_handle,
6374: 'category_set_id',
6375: p_category_set_id
6376: );
6377: END IF;

Line 6381: DBMS_SQL.bind_variable (l_query_handle,

6377: END IF;
6378:
6379: IF p_item_category_id IS NOT NULL
6380: THEN
6381: DBMS_SQL.bind_variable (l_query_handle,
6382: 'item_category_id',
6383: p_item_category_id
6384: );
6385: END IF;

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

6385: END IF;
6386:
6387: IF p_person_id IS NOT NULL
6388: THEN
6389: DBMS_SQL.bind_variable (l_query_handle, 'person_id', p_person_id);
6390: END IF;
6391:
6392: IF p_person_resource_id IS NOT NULL
6393: THEN

Line 6394: DBMS_SQL.bind_variable (l_query_handle,

6390: END IF;
6391:
6392: IF p_person_resource_id IS NOT NULL
6393: THEN
6394: DBMS_SQL.bind_variable (l_query_handle,
6395: 'person_resource_id',
6396: p_person_resource_id
6397: );
6398: END IF;

Line 6402: DBMS_SQL.bind_variable (l_query_handle,

6398: END IF;
6399:
6400: IF p_equipment_type_id IS NOT NULL
6401: THEN
6402: DBMS_SQL.bind_variable (l_query_handle,
6403: 'equipment_type_id',
6404: p_equipment_type_id
6405: );
6406: END IF;

Line 6410: DBMS_SQL.bind_variable (l_query_handle,

6406: END IF;
6407:
6408: IF p_machine_resource_id IS NOT NULL
6409: THEN
6410: DBMS_SQL.bind_variable (l_query_handle,
6411: 'machine_resource_id',
6412: p_machine_resource_id
6413: );
6414: END IF;

Line 6418: DBMS_SQL.bind_variable (l_query_handle,

6414: END IF;
6415:
6416: IF p_machine_instance IS NOT NULL
6417: THEN
6418: DBMS_SQL.bind_variable (l_query_handle,
6419: 'machine_instance',
6420: p_machine_instance
6421: );
6422: END IF;

Line 6426: DBMS_SQL.bind_variable (l_query_handle,

6422: END IF;
6423:
6424: IF p_from_task_quantity IS NOT NULL
6425: THEN
6426: DBMS_SQL.bind_variable (l_query_handle,
6427: 'from_task_quantity',
6428: p_from_task_quantity
6429: );
6430: END IF;

Line 6434: DBMS_SQL.bind_variable (l_query_handle,

6430: END IF;
6431:
6432: IF p_to_task_quantity IS NOT NULL
6433: THEN
6434: DBMS_SQL.bind_variable (l_query_handle,
6435: 'to_task_quantity',
6436: p_to_task_quantity
6437: );
6438: END IF;

Line 6442: DBMS_SQL.bind_variable (l_query_handle,

6438: END IF;
6439:
6440: IF p_from_creation_date IS NOT NULL
6441: THEN
6442: DBMS_SQL.bind_variable (l_query_handle,
6443: 'from_creation_date',
6444: p_from_creation_date
6445: );
6446: END IF;

Line 6450: DBMS_SQL.bind_variable (l_query_handle,

6446: END IF;
6447:
6448: IF p_to_creation_date IS NOT NULL
6449: THEN
6450: DBMS_SQL.bind_variable (l_query_handle,
6451: 'to_creation_date',
6452: p_to_creation_date
6453: );
6454: END IF;

Line 6462: DBMS_SQL.bind_variable (l_query_handle,

6458: THEN
6459:
6460: IF p_age_min IS NOT NULL
6461: THEN
6462: DBMS_SQL.bind_variable (l_query_handle,
6463: 'age_min',
6464: p_age_min
6465: );
6466: END IF;

Line 6470: DBMS_SQL.bind_variable (l_query_handle,

6466: END IF;
6467:
6468: IF p_age_max IS NOT NULL
6469: THEN
6470: DBMS_SQL.bind_variable (l_query_handle,
6471: 'age_max',
6472: p_age_max
6473: );
6474:

Line 6481: DBMS_SQL.bind_variable (l_query_handle,

6477:
6478: --Inbound specifc bind variables
6479: IF p_from_po_header_id IS NOT NULL
6480: THEN
6481: DBMS_SQL.bind_variable (l_query_handle,
6482: 'from_po_header_id',
6483: p_from_po_header_id
6484: );
6485: END IF;

Line 6489: DBMS_SQL.bind_variable (l_query_handle,

6485: END IF;
6486:
6487: IF p_to_po_header_id IS NOT NULL
6488: THEN
6489: DBMS_SQL.bind_variable (l_query_handle,
6490: 'to_po_header_id',
6491: p_to_po_header_id
6492: );
6493: END IF;

Line 6497: DBMS_SQL.bind_variable (l_query_handle,

6493: END IF;
6494:
6495: IF p_from_rma_header_id IS NOT NULL
6496: THEN
6497: DBMS_SQL.bind_variable (l_query_handle,
6498: 'from_rma_header_id',
6499: p_from_rma_header_id
6500: );
6501: END IF;

Line 6505: DBMS_SQL.bind_variable (l_query_handle,

6501: END IF;
6502:
6503: IF p_to_rma_header_id IS NOT NULL
6504: THEN
6505: DBMS_SQL.bind_variable (l_query_handle,
6506: 'to_rma_header_id',
6507: p_to_rma_header_id
6508: );
6509: END IF;

Line 6513: DBMS_SQL.bind_variable (l_query_handle,

6509: END IF;
6510:
6511: IF p_from_requisition_header_id IS NOT NULL
6512: THEN
6513: DBMS_SQL.bind_variable (l_query_handle,
6514: 'from_requisition_header_id',
6515: p_from_requisition_header_id
6516: );
6517: END IF;

Line 6521: DBMS_SQL.bind_variable (l_query_handle,

6517: END IF;
6518:
6519: IF p_to_requisition_header_id IS NOT NULL
6520: THEN
6521: DBMS_SQL.bind_variable (l_query_handle,
6522: 'to_requisition_header_id',
6523: p_to_requisition_header_id
6524: );
6525: END IF;

Line 6529: DBMS_SQL.bind_variable (l_query_handle,

6525: END IF;
6526:
6527: IF p_from_shipment_number IS NOT NULL
6528: THEN
6529: DBMS_SQL.bind_variable (l_query_handle,
6530: 'from_shipment_number',
6531: p_from_shipment_number
6532: );
6533: END IF;

Line 6537: DBMS_SQL.bind_variable (l_query_handle,

6533: END IF;
6534:
6535: IF p_to_shipment_number IS NOT NULL
6536: THEN
6537: DBMS_SQL.bind_variable (l_query_handle,
6538: 'to_shipment_number',
6539: p_to_shipment_number
6540: );
6541: END IF;

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

6540: );
6541: END IF;
6542:
6543: IF p_summary_mode = 1 THEN
6544: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 1, l_wms_task_type);
6545: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 2, l_task_count);
6546: END IF;
6547:
6548: --execute the query

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

6541: END IF;
6542:
6543: IF p_summary_mode = 1 THEN
6544: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 1, l_wms_task_type);
6545: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 2, l_task_count);
6546: END IF;
6547:
6548: --execute the query
6549: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);

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

6545: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 2, l_task_count);
6546: END IF;
6547:
6548: --execute the query
6549: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);
6550: g_record_count := g_record_count + l_query_count;
6551:
6552: IF p_summary_mode = 1 THEN -- fetch the rows and put them into the global tables
6553: LOOP

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

6550: g_record_count := g_record_count + l_query_count;
6551:
6552: IF p_summary_mode = 1 THEN -- fetch the rows and put them into the global tables
6553: LOOP
6554: IF DBMS_SQL.FETCH_ROWS(l_query_handle)>0 THEN
6555: DBMS_SQL.COLUMN_VALUE(l_query_handle, 1, l_wms_task_type);
6556: DBMS_SQL.COLUMN_VALUE(l_query_handle, 2, l_task_count);
6557: g_wms_task_summary_tbl(l_wms_task_type).wms_task_type := l_wms_task_type;
6558: 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 6555: DBMS_SQL.COLUMN_VALUE(l_query_handle, 1, l_wms_task_type);

6551:
6552: IF p_summary_mode = 1 THEN -- fetch the rows and put them into the global tables
6553: LOOP
6554: IF DBMS_SQL.FETCH_ROWS(l_query_handle)>0 THEN
6555: DBMS_SQL.COLUMN_VALUE(l_query_handle, 1, l_wms_task_type);
6556: DBMS_SQL.COLUMN_VALUE(l_query_handle, 2, l_task_count);
6557: g_wms_task_summary_tbl(l_wms_task_type).wms_task_type := l_wms_task_type;
6558: 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;
6559: ELSE

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

6552: IF p_summary_mode = 1 THEN -- fetch the rows and put them into the global tables
6553: LOOP
6554: IF DBMS_SQL.FETCH_ROWS(l_query_handle)>0 THEN
6555: DBMS_SQL.COLUMN_VALUE(l_query_handle, 1, l_wms_task_type);
6556: DBMS_SQL.COLUMN_VALUE(l_query_handle, 2, l_task_count);
6557: g_wms_task_summary_tbl(l_wms_task_type).wms_task_type := l_wms_task_type;
6558: 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;
6559: ELSE
6560: EXIT; -- no more rows returned from dynamic SQL

Line 6565: DBMS_SQL.close_cursor(l_query_handle);

6561: END IF;
6562: END LOOP;
6563: END IF;
6564:
6565: DBMS_SQL.close_cursor(l_query_handle);
6566: END LOOP;
6567:
6568: IF (g_source_header_visible = 'T' OR g_line_number_visible = 'T')
6569: AND p_from_po_header_id IS NULL

Line 6580: IF dbms_sql.is_open(l_query_handle) THEN

6576: set_inbound_source_header_line;
6577: END IF;
6578: EXCEPTION
6579: WHEN OTHERS THEN -- Bug 4150145
6580: IF dbms_sql.is_open(l_query_handle) THEN
6581: dbms_sql.close_cursor(l_query_handle);
6582: END IF;
6583: DEBUG (SQLERRM, 'Task_planning.query_inbound_tasks');
6584: END query_inbound_tasks;

Line 6581: dbms_sql.close_cursor(l_query_handle);

6577: END IF;
6578: EXCEPTION
6579: WHEN OTHERS THEN -- Bug 4150145
6580: IF dbms_sql.is_open(l_query_handle) THEN
6581: dbms_sql.close_cursor(l_query_handle);
6582: END IF;
6583: DEBUG (SQLERRM, 'Task_planning.query_inbound_tasks');
6584: END query_inbound_tasks;
6585:

Line 7662: l_query_handle := DBMS_SQL.open_cursor;

7658: -- Parse, Bind and Execute the dynamic query
7659: IF l_debug = 1 THEN
7660: debug('l_query: ' || l_query,'query_manufacturing_tasks');
7661: END IF;
7662: l_query_handle := DBMS_SQL.open_cursor;
7663: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
7664:
7665: --generic bind variables
7666: IF p_organization_id IS NOT NULL

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

7659: IF l_debug = 1 THEN
7660: debug('l_query: ' || l_query,'query_manufacturing_tasks');
7661: END IF;
7662: l_query_handle := DBMS_SQL.open_cursor;
7663: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
7664:
7665: --generic bind variables
7666: IF p_organization_id IS NOT NULL
7667: THEN

Line 7668: DBMS_SQL.bind_variable (l_query_handle,

7664:
7665: --generic bind variables
7666: IF p_organization_id IS NOT NULL
7667: THEN
7668: DBMS_SQL.bind_variable (l_query_handle,
7669: 'org_id',
7670: p_organization_id
7671: );
7672: END IF;

Line 7676: DBMS_SQL.bind_variable (l_query_handle,

7672: END IF;
7673:
7674: IF p_subinventory_code IS NOT NULL
7675: THEN
7676: DBMS_SQL.bind_variable (l_query_handle,
7677: 'sub_code',
7678: p_subinventory_code
7679: );
7680: END IF;

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

7680: END IF;
7681:
7682: IF p_locator_id IS NOT NULL
7683: THEN
7684: DBMS_SQL.bind_variable (l_query_handle, 'loc_id', p_locator_id);
7685: END IF;
7686:
7687: IF p_to_subinventory_code IS NOT NULL
7688: THEN

Line 7689: DBMS_SQL.bind_variable (l_query_handle,

7685: END IF;
7686:
7687: IF p_to_subinventory_code IS NOT NULL
7688: THEN
7689: DBMS_SQL.bind_variable (l_query_handle,
7690: 'to_sub_code',
7691: p_to_subinventory_code
7692: );
7693: END IF;

Line 7697: DBMS_SQL.bind_variable (l_query_handle,

7693: END IF;
7694:
7695: IF p_to_locator_id IS NOT NULL
7696: THEN
7697: DBMS_SQL.bind_variable (l_query_handle,
7698: 'to_loc_id',
7699: p_to_locator_id
7700: );
7701: END IF;

Line 7705: DBMS_SQL.bind_variable (l_query_handle,

7701: END IF;
7702:
7703: IF p_inventory_item_id IS NOT NULL
7704: THEN
7705: DBMS_SQL.bind_variable (l_query_handle,
7706: 'item_id',
7707: p_inventory_item_id
7708: );
7709: END IF;

Line 7714: DBMS_SQL.bind_variable (l_query_handle,

7710:
7711: -- R12 : Additional Query Criteria using item type
7712: IF p_item_type_code IS NOT NULL
7713: THEN
7714: DBMS_SQL.bind_variable (l_query_handle,
7715: 'item_type_code',
7716: p_item_type_code
7717: );
7718: END IF;

Line 7723: DBMS_SQL.bind_variable (l_query_handle,

7719:
7720:
7721: IF p_category_set_id IS NOT NULL
7722: THEN
7723: DBMS_SQL.bind_variable (l_query_handle,
7724: 'category_set_id',
7725: p_category_set_id
7726: );
7727: END IF;

Line 7731: DBMS_SQL.bind_variable (l_query_handle,

7727: END IF;
7728:
7729: IF p_item_category_id IS NOT NULL
7730: THEN
7731: DBMS_SQL.bind_variable (l_query_handle,
7732: 'item_category_id',
7733: p_item_category_id
7734: );
7735: END IF;

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

7735: END IF;
7736:
7737: IF p_person_id IS NOT NULL
7738: THEN
7739: DBMS_SQL.bind_variable (l_query_handle, 'person_id', p_person_id);
7740: END IF;
7741:
7742: IF p_person_resource_id IS NOT NULL
7743: THEN

Line 7744: DBMS_SQL.bind_variable (l_query_handle,

7740: END IF;
7741:
7742: IF p_person_resource_id IS NOT NULL
7743: THEN
7744: DBMS_SQL.bind_variable (l_query_handle,
7745: 'person_resource_id',
7746: p_person_resource_id
7747: );
7748: END IF;

Line 7752: DBMS_SQL.bind_variable (l_query_handle,

7748: END IF;
7749:
7750: IF p_equipment_type_id IS NOT NULL
7751: THEN
7752: DBMS_SQL.bind_variable (l_query_handle,
7753: 'equipment_type_id',
7754: p_equipment_type_id
7755: );
7756: END IF;

Line 7760: DBMS_SQL.bind_variable (l_query_handle,

7756: END IF;
7757:
7758: IF p_machine_resource_id IS NOT NULL
7759: THEN
7760: DBMS_SQL.bind_variable (l_query_handle,
7761: 'machine_resource_id',
7762: p_machine_resource_id
7763: );
7764: END IF;

Line 7768: DBMS_SQL.bind_variable (l_query_handle,

7764: END IF;
7765:
7766: IF p_machine_instance IS NOT NULL
7767: THEN
7768: DBMS_SQL.bind_variable (l_query_handle,
7769: 'machine_instance',
7770: p_machine_instance
7771: );
7772: END IF;

Line 7776: DBMS_SQL.bind_variable (l_query_handle,

7772: END IF;
7773:
7774: IF p_user_task_type_id IS NOT NULL
7775: THEN
7776: DBMS_SQL.bind_variable (l_query_handle,
7777: 'user_task_type_id',
7778: p_user_task_type_id
7779: );
7780: END IF;

Line 7784: DBMS_SQL.bind_variable (l_query_handle,

7780: END IF;
7781:
7782: IF p_from_task_quantity IS NOT NULL
7783: THEN
7784: DBMS_SQL.bind_variable (l_query_handle,
7785: 'from_task_quantity',
7786: p_from_task_quantity
7787: );
7788: END IF;

Line 7792: DBMS_SQL.bind_variable (l_query_handle,

7788: END IF;
7789:
7790: IF p_to_task_quantity IS NOT NULL
7791: THEN
7792: DBMS_SQL.bind_variable (l_query_handle,
7793: 'to_task_quantity',
7794: p_to_task_quantity
7795: );
7796: END IF;

Line 7800: DBMS_SQL.bind_variable (l_query_handle,

7796: END IF;
7797:
7798: IF p_from_task_priority IS NOT NULL
7799: THEN
7800: DBMS_SQL.bind_variable (l_query_handle,
7801: 'from_task_priority',
7802: p_from_task_priority
7803: );
7804: END IF;

Line 7808: DBMS_SQL.bind_variable (l_query_handle,

7804: END IF;
7805:
7806: IF p_to_task_priority IS NOT NULL
7807: THEN
7808: DBMS_SQL.bind_variable (l_query_handle,
7809: 'to_task_priority',
7810: p_to_task_priority
7811: );
7812: END IF;

Line 7816: DBMS_SQL.bind_variable (l_query_handle,

7812: END IF;
7813:
7814: IF p_from_creation_date IS NOT NULL
7815: THEN
7816: DBMS_SQL.bind_variable (l_query_handle,
7817: 'from_creation_date',
7818: p_from_creation_date
7819: );
7820: END IF;

Line 7824: DBMS_SQL.bind_variable (l_query_handle,

7820: END IF;
7821:
7822: IF p_to_creation_date IS NOT NULL
7823: THEN
7824: DBMS_SQL.bind_variable (l_query_handle,
7825: 'to_creation_date',
7826: p_to_creation_date
7827: );
7828: END IF;

Line 7836: DBMS_SQL.bind_variable (l_query_handle,

7832: THEN
7833:
7834: IF p_age_min IS NOT NULL
7835: THEN
7836: DBMS_SQL.bind_variable (l_query_handle,
7837: 'age_min',
7838: p_age_min
7839: );
7840: END IF;

Line 7844: DBMS_SQL.bind_variable (l_query_handle,

7840: END IF;
7841:
7842: IF p_age_max IS NOT NULL
7843: THEN
7844: DBMS_SQL.bind_variable (l_query_handle,
7845: 'age_max',
7846: p_age_max
7847: );
7848:

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

7851:
7852: -- Manufacturing query specific bind variables
7853: IF p_from_job IS NOT NULL
7854: THEN
7855: DBMS_SQL.bind_variable (l_query_handle, 'from_job', p_from_job);
7856: END IF;
7857:
7858: IF p_to_job IS NOT NULL
7859: THEN

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

7856: END IF;
7857:
7858: IF p_to_job IS NOT NULL
7859: THEN
7860: DBMS_SQL.bind_variable (l_query_handle, 'to_job', p_to_job);
7861: END IF;
7862:
7863: IF p_assembly_id IS NOT NULL
7864: THEN

Line 7865: DBMS_SQL.bind_variable (l_query_handle,

7861: END IF;
7862:
7863: IF p_assembly_id IS NOT NULL
7864: THEN
7865: DBMS_SQL.bind_variable (l_query_handle,
7866: 'assembly_id',
7867: p_assembly_id
7868: );
7869: END IF;

Line 7873: DBMS_SQL.bind_variable (l_query_handle,

7869: END IF;
7870:
7871: IF p_from_start_date IS NOT NULL
7872: THEN
7873: DBMS_SQL.bind_variable (l_query_handle,
7874: 'from_start_date',
7875: p_from_start_date
7876: );
7877: END IF;

Line 7881: DBMS_SQL.bind_variable (l_query_handle,

7877: END IF;
7878:
7879: IF p_to_start_date IS NOT NULL
7880: THEN
7881: DBMS_SQL.bind_variable (l_query_handle,
7882: 'to_start_date',
7883: p_to_start_date
7884: );
7885: END IF;

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

7885: END IF;
7886:
7887: IF p_from_line IS NOT NULL
7888: THEN
7889: DBMS_SQL.bind_variable (l_query_handle, 'from_line', p_from_line);
7890: END IF;
7891:
7892: IF p_to_line IS NOT NULL
7893: THEN

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

7890: END IF;
7891:
7892: IF p_to_line IS NOT NULL
7893: THEN
7894: DBMS_SQL.bind_variable (l_query_handle, 'to_line', p_to_line);
7895: END IF;
7896:
7897: IF p_department_id IS NOT NULL
7898: THEN

Line 7899: DBMS_SQL.bind_variable (l_query_handle,

7895: END IF;
7896:
7897: IF p_department_id IS NOT NULL
7898: THEN
7899: DBMS_SQL.bind_variable (l_query_handle,
7900: 'dept_id',
7901: p_department_id
7902: );
7903: END IF;

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

7902: );
7903: END IF;
7904:
7905: IF p_summary_mode = 1 THEN
7906: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 1, l_wms_task_type);
7907: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 2, l_task_count);
7908: END IF;
7909:
7910: --mfg_query

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

7903: END IF;
7904:
7905: IF p_summary_mode = 1 THEN
7906: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 1, l_wms_task_type);
7907: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 2, l_task_count);
7908: END IF;
7909:
7910: --mfg_query
7911: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);

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

7907: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 2, l_task_count);
7908: END IF;
7909:
7910: --mfg_query
7911: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);
7912:
7913: IF p_summary_mode = 1 THEN -- fetch the rows and put them into the global tables
7914: LOOP
7915: IF DBMS_SQL.FETCH_ROWS(l_query_handle)>0 THEN

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

7911: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);
7912:
7913: IF p_summary_mode = 1 THEN -- fetch the rows and put them into the global tables
7914: LOOP
7915: IF DBMS_SQL.FETCH_ROWS(l_query_handle)>0 THEN
7916: DBMS_SQL.COLUMN_VALUE(l_query_handle, 1, l_wms_task_type);
7917: DBMS_SQL.COLUMN_VALUE(l_query_handle, 2, l_task_count);
7918: g_wms_task_summary_tbl(l_wms_task_type).wms_task_type := l_wms_task_type;
7919: 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 7916: DBMS_SQL.COLUMN_VALUE(l_query_handle, 1, l_wms_task_type);

7912:
7913: IF p_summary_mode = 1 THEN -- fetch the rows and put them into the global tables
7914: LOOP
7915: IF DBMS_SQL.FETCH_ROWS(l_query_handle)>0 THEN
7916: DBMS_SQL.COLUMN_VALUE(l_query_handle, 1, l_wms_task_type);
7917: DBMS_SQL.COLUMN_VALUE(l_query_handle, 2, l_task_count);
7918: g_wms_task_summary_tbl(l_wms_task_type).wms_task_type := l_wms_task_type;
7919: 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;
7920: IF l_debug = 1 then

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

7913: IF p_summary_mode = 1 THEN -- fetch the rows and put them into the global tables
7914: LOOP
7915: IF DBMS_SQL.FETCH_ROWS(l_query_handle)>0 THEN
7916: DBMS_SQL.COLUMN_VALUE(l_query_handle, 1, l_wms_task_type);
7917: DBMS_SQL.COLUMN_VALUE(l_query_handle, 2, l_task_count);
7918: g_wms_task_summary_tbl(l_wms_task_type).wms_task_type := l_wms_task_type;
7919: 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;
7920: IF l_debug = 1 then
7921: debug('Task Type :' || g_wms_task_summary_tbl(l_wms_task_type).wms_task_type, 'query_manufacturing_tasks');

Line 7930: DBMS_SQL.close_cursor(l_query_handle);

7926: END IF;
7927: END LOOP;
7928: END IF;
7929: g_record_count := g_record_count + l_query_count;
7930: DBMS_SQL.close_cursor(l_query_handle);
7931: END IF; --atleast one status --ER13869750
7932: END LOOP;
7933: EXCEPTION
7934: WHEN OTHERS THEN -- Bug 4150145

Line 7935: IF dbms_sql.is_open(l_query_handle) THEN

7931: END IF; --atleast one status --ER13869750
7932: END LOOP;
7933: EXCEPTION
7934: WHEN OTHERS THEN -- Bug 4150145
7935: IF dbms_sql.is_open(l_query_handle) THEN
7936: dbms_sql.close_cursor(l_query_handle);
7937: END IF;
7938: DEBUG (SQLERRM, 'Task_planning.query_manufacturing_tasks');
7939: END query_manufacturing_tasks;

Line 7936: dbms_sql.close_cursor(l_query_handle);

7932: END LOOP;
7933: EXCEPTION
7934: WHEN OTHERS THEN -- Bug 4150145
7935: IF dbms_sql.is_open(l_query_handle) THEN
7936: dbms_sql.close_cursor(l_query_handle);
7937: END IF;
7938: DEBUG (SQLERRM, 'Task_planning.query_manufacturing_tasks');
7939: END query_manufacturing_tasks;
7940:

Line 8803: l_query_handle := DBMS_SQL.open_cursor;

8799: l_query := l_select_cc || l_from_cc || l_where_cc ;
8800: END IF;
8801:
8802: -- Parse, Bind and Execute the dynamic query
8803: l_query_handle := DBMS_SQL.open_cursor;
8804: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
8805:
8806: --generic bind variables
8807: IF p_organization_id IS NOT NULL

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

8800: END IF;
8801:
8802: -- Parse, Bind and Execute the dynamic query
8803: l_query_handle := DBMS_SQL.open_cursor;
8804: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
8805:
8806: --generic bind variables
8807: IF p_organization_id IS NOT NULL
8808: THEN

Line 8809: DBMS_SQL.bind_variable (l_query_handle,

8805:
8806: --generic bind variables
8807: IF p_organization_id IS NOT NULL
8808: THEN
8809: DBMS_SQL.bind_variable (l_query_handle,
8810: 'org_id',
8811: p_organization_id
8812: );
8813: END IF;

Line 8817: DBMS_SQL.bind_variable (l_query_handle,

8813: END IF;
8814:
8815: IF p_subinventory_code IS NOT NULL
8816: THEN
8817: DBMS_SQL.bind_variable (l_query_handle,
8818: 'sub_code',
8819: p_subinventory_code
8820: );
8821: END IF;

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

8821: END IF;
8822:
8823: IF p_locator_id IS NOT NULL
8824: THEN
8825: DBMS_SQL.bind_variable (l_query_handle, 'loc_id', p_locator_id);
8826: END IF;
8827:
8828: IF p_inventory_item_id IS NOT NULL
8829: THEN

Line 8830: DBMS_SQL.bind_variable (l_query_handle,

8826: END IF;
8827:
8828: IF p_inventory_item_id IS NOT NULL
8829: THEN
8830: DBMS_SQL.bind_variable (l_query_handle,
8831: 'item_id',
8832: p_inventory_item_id
8833: );
8834: END IF;

Line 8839: DBMS_SQL.bind_variable (l_query_handle,

8835:
8836: -- R12 : Additional Query Criteria using item type
8837: IF p_item_type_code IS NOT NULL
8838: THEN
8839: DBMS_SQL.bind_variable (l_query_handle,
8840: 'item_type_code',
8841: p_item_type_code
8842: );
8843: END IF;

Line 8848: DBMS_SQL.bind_variable (l_query_handle,

8844:
8845:
8846: IF p_category_set_id IS NOT NULL
8847: THEN
8848: DBMS_SQL.bind_variable (l_query_handle,
8849: 'category_set_id',
8850: p_category_set_id
8851: );
8852: END IF;

Line 8856: DBMS_SQL.bind_variable (l_query_handle,

8852: END IF;
8853:
8854: IF p_item_category_id IS NOT NULL
8855: THEN
8856: DBMS_SQL.bind_variable (l_query_handle,
8857: 'item_category_id',
8858: p_item_category_id
8859: );
8860: END IF;

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

8860: END IF;
8861:
8862: IF p_person_id IS NOT NULL
8863: THEN
8864: DBMS_SQL.bind_variable (l_query_handle, 'person_id', p_person_id);
8865: END IF;
8866:
8867: IF p_person_resource_id IS NOT NULL
8868: THEN

Line 8869: DBMS_SQL.bind_variable (l_query_handle,

8865: END IF;
8866:
8867: IF p_person_resource_id IS NOT NULL
8868: THEN
8869: DBMS_SQL.bind_variable (l_query_handle,
8870: 'person_resource_id',
8871: p_person_resource_id
8872: );
8873: END IF;

Line 8877: DBMS_SQL.bind_variable (l_query_handle,

8873: END IF;
8874:
8875: IF p_equipment_type_id IS NOT NULL
8876: THEN
8877: DBMS_SQL.bind_variable (l_query_handle,
8878: 'equipment_type_id',
8879: p_equipment_type_id
8880: );
8881: END IF;

Line 8885: DBMS_SQL.bind_variable (l_query_handle,

8881: END IF;
8882:
8883: IF p_machine_resource_id IS NOT NULL
8884: THEN
8885: DBMS_SQL.bind_variable (l_query_handle,
8886: 'machine_resource_id',
8887: p_machine_resource_id
8888: );
8889: END IF;

Line 8893: DBMS_SQL.bind_variable (l_query_handle,

8889: END IF;
8890:
8891: IF p_machine_instance IS NOT NULL
8892: THEN
8893: DBMS_SQL.bind_variable (l_query_handle,
8894: 'machine_instance',
8895: p_machine_instance
8896: );
8897: END IF;

Line 8901: DBMS_SQL.bind_variable (l_query_handle,

8897: END IF;
8898:
8899: IF p_user_task_type_id IS NOT NULL
8900: THEN
8901: DBMS_SQL.bind_variable (l_query_handle,
8902: 'user_task_type_id',
8903: p_user_task_type_id
8904: );
8905: END IF;

Line 8909: DBMS_SQL.bind_variable (l_query_handle,

8905: END IF;
8906:
8907: IF p_from_task_priority IS NOT NULL
8908: THEN
8909: DBMS_SQL.bind_variable (l_query_handle,
8910: 'from_task_priority',
8911: p_from_task_priority
8912: );
8913: END IF;

Line 8917: DBMS_SQL.bind_variable (l_query_handle,

8913: END IF;
8914:
8915: IF p_to_task_priority IS NOT NULL
8916: THEN
8917: DBMS_SQL.bind_variable (l_query_handle,
8918: 'to_task_priority',
8919: p_to_task_priority
8920: );
8921: END IF;

Line 8925: DBMS_SQL.bind_variable (l_query_handle,

8921: END IF;
8922:
8923: IF p_from_creation_date IS NOT NULL
8924: THEN
8925: DBMS_SQL.bind_variable (l_query_handle,
8926: 'from_creation_date',
8927: p_from_creation_date
8928: );
8929: END IF;

Line 8933: DBMS_SQL.bind_variable (l_query_handle,

8929: END IF;
8930:
8931: IF p_to_creation_date IS NOT NULL
8932: THEN
8933: DBMS_SQL.bind_variable (l_query_handle,
8934: 'to_creation_date',
8935: p_to_creation_date
8936: );
8937: END IF;

Line 8945: DBMS_SQL.bind_variable (l_query_handle,

8941: THEN
8942:
8943: IF p_age_min IS NOT NULL
8944: THEN
8945: DBMS_SQL.bind_variable (l_query_handle,
8946: 'age_min',
8947: p_age_min
8948: );
8949: END IF;

Line 8953: DBMS_SQL.bind_variable (l_query_handle,

8949: END IF;
8950:
8951: IF p_age_max IS NOT NULL
8952: THEN
8953: DBMS_SQL.bind_variable (l_query_handle,
8954: 'age_max',
8955: p_age_max
8956: );
8957:

Line 8964: DBMS_SQL.bind_variable (l_query_handle,

8960:
8961: --Cycle count specifc bind variables
8962: IF p_cycle_count_name IS NOT NULL
8963: THEN
8964: DBMS_SQL.bind_variable (l_query_handle,
8965: 'cc_header_name',
8966: p_cycle_count_name
8967: );
8968: END IF;

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

8968: END IF;
8969:
8970:
8971: --execute the query
8972: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);
8973: g_record_count := g_record_count + l_query_count;
8974:
8975: IF p_summary_mode = 1 THEN
8976: LOOP

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

8973: g_record_count := g_record_count + l_query_count;
8974:
8975: IF p_summary_mode = 1 THEN
8976: LOOP
8977: IF DBMS_SQL.FETCH_ROWS(l_query_handle) = 0 THEN
8978: EXIT;
8979: END IF;
8980: END LOOP;
8981: 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 8982: 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;

8978: EXIT;
8979: END IF;
8980: END LOOP;
8981: 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;
8982: 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;
8983: IF l_debug = 1 THEN
8984: debug(' Query :' || l_query , 'query_cc_tasks');
8985: debug('Task Type :' || g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_cycle_count).wms_task_type, 'query_cycle_count_tasks');
8986: debug('TaskCount :' || g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_cycle_count).task_count, 'query_cycle_count_tasks');

Line 8990: DBMS_SQL.close_cursor(l_query_handle);

8986: debug('TaskCount :' || g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_cycle_count).task_count, 'query_cycle_count_tasks');
8987: END IF;
8988: END IF;
8989:
8990: DBMS_SQL.close_cursor(l_query_handle);
8991: END LOOP;
8992: EXCEPTION
8993: WHEN OTHERS THEN -- Bug 4150145
8994: IF dbms_sql.is_open(l_query_handle) THEN

Line 8994: IF dbms_sql.is_open(l_query_handle) THEN

8990: DBMS_SQL.close_cursor(l_query_handle);
8991: END LOOP;
8992: EXCEPTION
8993: WHEN OTHERS THEN -- Bug 4150145
8994: IF dbms_sql.is_open(l_query_handle) THEN
8995: dbms_sql.close_cursor(l_query_handle);
8996: END IF;
8997: DEBUG (SQLERRM, 'Task_planning.query_cycle_count_tasks');
8998: END query_cycle_count_tasks;

Line 8995: dbms_sql.close_cursor(l_query_handle);

8991: END LOOP;
8992: EXCEPTION
8993: WHEN OTHERS THEN -- Bug 4150145
8994: IF dbms_sql.is_open(l_query_handle) THEN
8995: dbms_sql.close_cursor(l_query_handle);
8996: END IF;
8997: DEBUG (SQLERRM, 'Task_planning.query_cycle_count_tasks');
8998: END query_cycle_count_tasks;
8999:

Line 9410: l_query_handle := DBMS_SQL.open_cursor;

9406: -- Parse, Bind and Execute the dynamic query
9407: if l_debug = 1 then
9408: debug('MO Tasks Query ' || l_query,'query_mo_tasks');
9409: end if;
9410: l_query_handle := DBMS_SQL.open_cursor;
9411: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
9412:
9413: --generic bind variables
9414: IF p_organization_id IS NOT NULL

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

9407: if l_debug = 1 then
9408: debug('MO Tasks Query ' || l_query,'query_mo_tasks');
9409: end if;
9410: l_query_handle := DBMS_SQL.open_cursor;
9411: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
9412:
9413: --generic bind variables
9414: IF p_organization_id IS NOT NULL
9415: THEN

Line 9416: DBMS_SQL.bind_variable (l_query_handle,

9412:
9413: --generic bind variables
9414: IF p_organization_id IS NOT NULL
9415: THEN
9416: DBMS_SQL.bind_variable (l_query_handle,
9417: 'org_id',
9418: p_organization_id
9419: );
9420: END IF;

Line 9424: DBMS_SQL.bind_variable (l_query_handle,

9420: END IF;
9421:
9422: IF p_subinventory_code IS NOT NULL
9423: THEN
9424: DBMS_SQL.bind_variable (l_query_handle,
9425: 'sub_code',
9426: p_subinventory_code
9427: );
9428: END IF;

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

9428: END IF;
9429:
9430: IF p_locator_id IS NOT NULL
9431: THEN
9432: DBMS_SQL.bind_variable (l_query_handle, 'loc_id', p_locator_id);
9433: END IF;
9434:
9435: IF p_to_subinventory_code IS NOT NULL
9436: THEN

Line 9437: DBMS_SQL.bind_variable (l_query_handle,

9433: END IF;
9434:
9435: IF p_to_subinventory_code IS NOT NULL
9436: THEN
9437: DBMS_SQL.bind_variable (l_query_handle,
9438: 'to_sub_code',
9439: p_to_subinventory_code
9440: );
9441: END IF;

Line 9445: DBMS_SQL.bind_variable (l_query_handle,

9441: END IF;
9442:
9443: IF p_to_locator_id IS NOT NULL
9444: THEN
9445: DBMS_SQL.bind_variable (l_query_handle,
9446: 'to_loc_id',
9447: p_to_locator_id
9448: );
9449: END IF;

Line 9453: DBMS_SQL.bind_variable (l_query_handle,

9449: END IF;
9450:
9451: IF p_category_set_id IS NOT NULL
9452: THEN
9453: DBMS_SQL.bind_variable (l_query_handle,
9454: 'category_set_id',
9455: p_category_set_id
9456: );
9457: END IF;

Line 9461: DBMS_SQL.bind_variable (l_query_handle,

9457: END IF;
9458:
9459: IF p_inventory_item_id IS NOT NULL
9460: THEN
9461: DBMS_SQL.bind_variable (l_query_handle,
9462: 'item_id',
9463: p_inventory_item_id
9464: );
9465: END IF;

Line 9470: DBMS_SQL.bind_variable (l_query_handle,

9466:
9467: -- R12 : Additional Query Criteria using item type
9468: IF p_item_type_code IS NOT NULL
9469: THEN
9470: DBMS_SQL.bind_variable (l_query_handle,
9471: 'item_type_code',
9472: p_item_type_code
9473: );
9474: END IF;

Line 9479: DBMS_SQL.bind_variable (l_query_handle,

9475:
9476:
9477: IF p_item_category_id IS NOT NULL
9478: THEN
9479: DBMS_SQL.bind_variable (l_query_handle,
9480: 'item_category_id',
9481: p_item_category_id
9482: );
9483: END IF;

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

9483: END IF;
9484:
9485: IF p_person_id IS NOT NULL
9486: THEN
9487: DBMS_SQL.bind_variable (l_query_handle, 'person_id', p_person_id);
9488: END IF;
9489:
9490: IF p_person_resource_id IS NOT NULL
9491: THEN

Line 9492: DBMS_SQL.bind_variable (l_query_handle,

9488: END IF;
9489:
9490: IF p_person_resource_id IS NOT NULL
9491: THEN
9492: DBMS_SQL.bind_variable (l_query_handle,
9493: 'person_resource_id',
9494: p_person_resource_id
9495: );
9496: END IF;

Line 9500: DBMS_SQL.bind_variable (l_query_handle,

9496: END IF;
9497:
9498: IF p_equipment_type_id IS NOT NULL
9499: THEN
9500: DBMS_SQL.bind_variable (l_query_handle,
9501: 'equipment_type_id',
9502: p_equipment_type_id
9503: );
9504: END IF;

Line 9508: DBMS_SQL.bind_variable (l_query_handle,

9504: END IF;
9505:
9506: IF p_machine_resource_id IS NOT NULL
9507: THEN
9508: DBMS_SQL.bind_variable (l_query_handle,
9509: 'machine_resource_id',
9510: p_machine_resource_id
9511: );
9512: END IF;

Line 9516: DBMS_SQL.bind_variable (l_query_handle,

9512: END IF;
9513:
9514: IF p_machine_instance IS NOT NULL
9515: THEN
9516: DBMS_SQL.bind_variable (l_query_handle,
9517: 'machine_instance',
9518: p_machine_instance
9519: );
9520: END IF;

Line 9524: DBMS_SQL.bind_variable (l_query_handle,

9520: END IF;
9521:
9522: IF p_user_task_type_id IS NOT NULL
9523: THEN
9524: DBMS_SQL.bind_variable (l_query_handle,
9525: 'user_task_type_id',
9526: p_user_task_type_id
9527: );
9528: END IF;

Line 9532: DBMS_SQL.bind_variable (l_query_handle,

9528: END IF;
9529:
9530: IF p_from_task_quantity IS NOT NULL
9531: THEN
9532: DBMS_SQL.bind_variable (l_query_handle,
9533: 'from_task_quantity',
9534: p_from_task_quantity
9535: );
9536: END IF;

Line 9540: DBMS_SQL.bind_variable (l_query_handle,

9536: END IF;
9537:
9538: IF p_to_task_quantity IS NOT NULL
9539: THEN
9540: DBMS_SQL.bind_variable (l_query_handle,
9541: 'to_task_quantity',
9542: p_to_task_quantity
9543: );
9544: END IF;

Line 9548: DBMS_SQL.bind_variable (l_query_handle,

9544: END IF;
9545:
9546: IF p_from_task_priority IS NOT NULL
9547: THEN
9548: DBMS_SQL.bind_variable (l_query_handle,
9549: 'from_task_priority',
9550: p_from_task_priority
9551: );
9552: END IF;

Line 9556: DBMS_SQL.bind_variable (l_query_handle,

9552: END IF;
9553:
9554: IF p_to_task_priority IS NOT NULL
9555: THEN
9556: DBMS_SQL.bind_variable (l_query_handle,
9557: 'to_task_priority',
9558: p_to_task_priority
9559: );
9560: END IF;

Line 9564: DBMS_SQL.bind_variable (l_query_handle,

9560: END IF;
9561:
9562: IF p_from_creation_date IS NOT NULL
9563: THEN
9564: DBMS_SQL.bind_variable (l_query_handle,
9565: 'from_creation_date',
9566: p_from_creation_date
9567: );
9568: END IF;

Line 9572: DBMS_SQL.bind_variable (l_query_handle,

9568: END IF;
9569:
9570: IF p_to_creation_date IS NOT NULL
9571: THEN
9572: DBMS_SQL.bind_variable (l_query_handle,
9573: 'to_creation_date',
9574: p_to_creation_date
9575: );
9576: END IF;

Line 9584: DBMS_SQL.bind_variable (l_query_handle,

9580: THEN
9581:
9582: IF p_age_min IS NOT NULL
9583: THEN
9584: DBMS_SQL.bind_variable (l_query_handle,
9585: 'age_min',
9586: p_age_min
9587: );
9588: END IF;

Line 9592: DBMS_SQL.bind_variable (l_query_handle,

9588: END IF;
9589:
9590: IF p_age_max IS NOT NULL
9591: THEN
9592: DBMS_SQL.bind_variable (l_query_handle,
9593: 'age_max',
9594: p_age_max
9595: );
9596:

Line 9602: DBMS_SQL.bind_variable (l_query_handle,

9598: END IF;
9599:
9600: IF p_from_replenishment_mo IS NOT NULL
9601: THEN
9602: DBMS_SQL.bind_variable (l_query_handle,
9603: 'from_replenishment_mo',
9604: p_from_replenishment_mo
9605: );
9606: END IF;

Line 9610: DBMS_SQL.bind_variable (l_query_handle,

9606: END IF;
9607:
9608: IF p_to_replenishment_mo IS NOT NULL
9609: THEN
9610: DBMS_SQL.bind_variable (l_query_handle,
9611: 'to_replenishment_mo',
9612: p_to_replenishment_mo
9613: );
9614: END IF;

Line 9618: DBMS_SQL.bind_variable (l_query_handle,

9614: END IF;
9615:
9616: IF p_from_transfer_issue_mo IS NOT NULL
9617: THEN
9618: DBMS_SQL.bind_variable (l_query_handle,
9619: 'from_transfer_issue_mo',
9620: p_from_transfer_issue_mo
9621: );
9622: END IF;

Line 9626: DBMS_SQL.bind_variable (l_query_handle,

9622: END IF;
9623:
9624: IF p_to_transfer_issue_mo IS NOT NULL
9625: THEN
9626: DBMS_SQL.bind_variable (l_query_handle,
9627: 'to_transfer_issue_mo',
9628: p_to_transfer_issue_mo
9629: );
9630: END IF;

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

9629: );
9630: END IF;
9631:
9632: IF p_summary_mode = 1 THEN
9633: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 1, l_wms_task_type);
9634: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 2, l_task_count);
9635: END IF;
9636:
9637: --execute the replenishment query

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

9630: END IF;
9631:
9632: IF p_summary_mode = 1 THEN
9633: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 1, l_wms_task_type);
9634: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 2, l_task_count);
9635: END IF;
9636:
9637: --execute the replenishment query
9638: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);

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

9634: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 2, l_task_count);
9635: END IF;
9636:
9637: --execute the replenishment query
9638: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);
9639: g_record_count := g_record_count + l_query_count;
9640:
9641: IF p_summary_mode = 1 THEN -- fetch the rows and put them into the global tables
9642: LOOP

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

9639: g_record_count := g_record_count + l_query_count;
9640:
9641: IF p_summary_mode = 1 THEN -- fetch the rows and put them into the global tables
9642: LOOP
9643: IF DBMS_SQL.FETCH_ROWS(l_query_handle)>0 THEN
9644: DBMS_SQL.COLUMN_VALUE(l_query_handle, 1, l_wms_task_type);
9645: DBMS_SQL.COLUMN_VALUE(l_query_handle, 2, l_task_count);
9646: g_wms_task_summary_tbl(l_wms_task_type).wms_task_type := l_wms_task_type;
9647: 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 9644: DBMS_SQL.COLUMN_VALUE(l_query_handle, 1, l_wms_task_type);

9640:
9641: IF p_summary_mode = 1 THEN -- fetch the rows and put them into the global tables
9642: LOOP
9643: IF DBMS_SQL.FETCH_ROWS(l_query_handle)>0 THEN
9644: DBMS_SQL.COLUMN_VALUE(l_query_handle, 1, l_wms_task_type);
9645: DBMS_SQL.COLUMN_VALUE(l_query_handle, 2, l_task_count);
9646: g_wms_task_summary_tbl(l_wms_task_type).wms_task_type := l_wms_task_type;
9647: 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;
9648: IF l_debug = 1 THEN

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

9641: IF p_summary_mode = 1 THEN -- fetch the rows and put them into the global tables
9642: LOOP
9643: IF DBMS_SQL.FETCH_ROWS(l_query_handle)>0 THEN
9644: DBMS_SQL.COLUMN_VALUE(l_query_handle, 1, l_wms_task_type);
9645: DBMS_SQL.COLUMN_VALUE(l_query_handle, 2, l_task_count);
9646: g_wms_task_summary_tbl(l_wms_task_type).wms_task_type := l_wms_task_type;
9647: 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;
9648: IF l_debug = 1 THEN
9649: debug('Task Type :' || g_wms_task_summary_tbl(l_wms_task_type).wms_task_type, 'query_mo_tasks');

Line 9657: DBMS_SQL.close_cursor(l_query_handle);

9653: EXIT; -- no more rows returned from dynamic SQL
9654: END IF;
9655: END LOOP;
9656: END IF;
9657: DBMS_SQL.close_cursor(l_query_handle);
9658: END IF; --atleast onestatus --ER13869750
9659: END LOOP;
9660: EXCEPTION
9661: WHEN OTHERS THEN -- Bug 4150145

Line 9662: IF dbms_sql.is_open(l_query_handle) THEN

9658: END IF; --atleast onestatus --ER13869750
9659: END LOOP;
9660: EXCEPTION
9661: WHEN OTHERS THEN -- Bug 4150145
9662: IF dbms_sql.is_open(l_query_handle) THEN
9663: dbms_sql.close_cursor(l_query_handle);
9664: END IF;
9665: DEBUG (SQLERRM, 'Task_planning.query_mo_tasks');
9666: END query_mo_tasks;

Line 9663: dbms_sql.close_cursor(l_query_handle);

9659: END LOOP;
9660: EXCEPTION
9661: WHEN OTHERS THEN -- Bug 4150145
9662: IF dbms_sql.is_open(l_query_handle) THEN
9663: dbms_sql.close_cursor(l_query_handle);
9664: END IF;
9665: DEBUG (SQLERRM, 'Task_planning.query_mo_tasks');
9666: END query_mo_tasks;
9667:

Line 9960: l_query_handle := DBMS_SQL.open_cursor;

9956: -- Parse, Bind and Execute the dynamic query
9957: if l_debug = 1 then
9958: debug('MO Tasks Query ' || l_query,'query_move_tasks');
9959: end if;
9960: l_query_handle := DBMS_SQL.open_cursor;
9961: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
9962:
9963: --generic bind variables
9964: IF p_organization_id IS NOT NULL

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

9957: if l_debug = 1 then
9958: debug('MO Tasks Query ' || l_query,'query_move_tasks');
9959: end if;
9960: l_query_handle := DBMS_SQL.open_cursor;
9961: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
9962:
9963: --generic bind variables
9964: IF p_organization_id IS NOT NULL
9965: THEN

Line 9966: DBMS_SQL.bind_variable (l_query_handle,

9962:
9963: --generic bind variables
9964: IF p_organization_id IS NOT NULL
9965: THEN
9966: DBMS_SQL.bind_variable (l_query_handle,
9967: 'org_id',
9968: p_organization_id
9969: );
9970: END IF;

Line 9974: DBMS_SQL.bind_variable (l_query_handle,

9970: END IF;
9971:
9972: IF p_subinventory_code IS NOT NULL
9973: THEN
9974: DBMS_SQL.bind_variable (l_query_handle,
9975: 'sub_code',
9976: p_subinventory_code
9977: );
9978: END IF;

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

9978: END IF;
9979:
9980: IF p_locator_id IS NOT NULL
9981: THEN
9982: DBMS_SQL.bind_variable (l_query_handle, 'loc_id', p_locator_id);
9983: END IF;
9984:
9985: IF p_to_subinventory_code IS NOT NULL
9986: THEN

Line 9987: DBMS_SQL.bind_variable (l_query_handle,

9983: END IF;
9984:
9985: IF p_to_subinventory_code IS NOT NULL
9986: THEN
9987: DBMS_SQL.bind_variable (l_query_handle,
9988: 'to_sub_code',
9989: p_to_subinventory_code
9990: );
9991: END IF;

Line 9995: DBMS_SQL.bind_variable (l_query_handle,

9991: END IF;
9992:
9993: IF p_to_locator_id IS NOT NULL
9994: THEN
9995: DBMS_SQL.bind_variable (l_query_handle,
9996: 'to_loc_id',
9997: p_to_locator_id
9998: );
9999: END IF;

Line 10003: DBMS_SQL.bind_variable (l_query_handle,

9999: END IF;
10000:
10001: IF p_category_set_id IS NOT NULL
10002: THEN
10003: DBMS_SQL.bind_variable (l_query_handle,
10004: 'category_set_id',
10005: p_category_set_id
10006: );
10007: END IF;

Line 10011: DBMS_SQL.bind_variable (l_query_handle,

10007: END IF;
10008:
10009: IF p_inventory_item_id IS NOT NULL
10010: THEN
10011: DBMS_SQL.bind_variable (l_query_handle,
10012: 'item_id',
10013: p_inventory_item_id
10014: );
10015: END IF;

Line 10020: DBMS_SQL.bind_variable (l_query_handle,

10016:
10017: -- R12 : Additional Query Criteria using item type
10018: IF p_item_type_code IS NOT NULL
10019: THEN
10020: DBMS_SQL.bind_variable (l_query_handle,
10021: 'item_type_code',
10022: p_item_type_code
10023: );
10024: END IF;

Line 10029: DBMS_SQL.bind_variable (l_query_handle,

10025:
10026:
10027: IF p_item_category_id IS NOT NULL
10028: THEN
10029: DBMS_SQL.bind_variable (l_query_handle,
10030: 'item_category_id',
10031: p_item_category_id
10032: );
10033: END IF;

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

10033: END IF;
10034:
10035: IF p_person_id IS NOT NULL
10036: THEN
10037: DBMS_SQL.bind_variable (l_query_handle, 'person_id', p_person_id);
10038: END IF;
10039:
10040: IF p_person_resource_id IS NOT NULL
10041: THEN

Line 10042: DBMS_SQL.bind_variable (l_query_handle,

10038: END IF;
10039:
10040: IF p_person_resource_id IS NOT NULL
10041: THEN
10042: DBMS_SQL.bind_variable (l_query_handle,
10043: 'person_resource_id',
10044: p_person_resource_id
10045: );
10046: END IF;

Line 10050: DBMS_SQL.bind_variable (l_query_handle,

10046: END IF;
10047:
10048: IF p_equipment_type_id IS NOT NULL
10049: THEN
10050: DBMS_SQL.bind_variable (l_query_handle,
10051: 'equipment_type_id',
10052: p_equipment_type_id
10053: );
10054: END IF;

Line 10058: DBMS_SQL.bind_variable (l_query_handle,

10054: END IF;
10055:
10056: IF p_machine_resource_id IS NOT NULL
10057: THEN
10058: DBMS_SQL.bind_variable (l_query_handle,
10059: 'machine_resource_id',
10060: p_machine_resource_id
10061: );
10062: END IF;

Line 10066: DBMS_SQL.bind_variable (l_query_handle,

10062: END IF;
10063:
10064: IF p_machine_instance IS NOT NULL
10065: THEN
10066: DBMS_SQL.bind_variable (l_query_handle,
10067: 'machine_instance',
10068: p_machine_instance
10069: );
10070: END IF;

Line 10074: DBMS_SQL.bind_variable (l_query_handle,

10070: END IF;
10071:
10072: IF p_user_task_type_id IS NOT NULL
10073: THEN
10074: DBMS_SQL.bind_variable (l_query_handle,
10075: 'user_task_type_id',
10076: p_user_task_type_id
10077: );
10078: END IF;

Line 10082: DBMS_SQL.bind_variable (l_query_handle,

10078: END IF;
10079:
10080: IF p_from_task_quantity IS NOT NULL
10081: THEN
10082: DBMS_SQL.bind_variable (l_query_handle,
10083: 'from_task_quantity',
10084: p_from_task_quantity
10085: );
10086: END IF;

Line 10090: DBMS_SQL.bind_variable (l_query_handle,

10086: END IF;
10087:
10088: IF p_to_task_quantity IS NOT NULL
10089: THEN
10090: DBMS_SQL.bind_variable (l_query_handle,
10091: 'to_task_quantity',
10092: p_to_task_quantity
10093: );
10094: END IF;

Line 10098: DBMS_SQL.bind_variable (l_query_handle,

10094: END IF;
10095:
10096: IF p_from_task_priority IS NOT NULL
10097: THEN
10098: DBMS_SQL.bind_variable (l_query_handle,
10099: 'from_task_priority',
10100: p_from_task_priority
10101: );
10102: END IF;

Line 10106: DBMS_SQL.bind_variable (l_query_handle,

10102: END IF;
10103:
10104: IF p_to_task_priority IS NOT NULL
10105: THEN
10106: DBMS_SQL.bind_variable (l_query_handle,
10107: 'to_task_priority',
10108: p_to_task_priority
10109: );
10110: END IF;

Line 10114: DBMS_SQL.bind_variable (l_query_handle,

10110: END IF;
10111:
10112: IF p_from_creation_date IS NOT NULL
10113: THEN
10114: DBMS_SQL.bind_variable (l_query_handle,
10115: 'from_creation_date',
10116: p_from_creation_date
10117: );
10118: END IF;

Line 10122: DBMS_SQL.bind_variable (l_query_handle,

10118: END IF;
10119:
10120: IF p_to_creation_date IS NOT NULL
10121: THEN
10122: DBMS_SQL.bind_variable (l_query_handle,
10123: 'to_creation_date',
10124: p_to_creation_date
10125: );
10126: END IF;

Line 10134: DBMS_SQL.bind_variable (l_query_handle,

10130: THEN
10131:
10132: IF p_age_min IS NOT NULL
10133: THEN
10134: DBMS_SQL.bind_variable (l_query_handle,
10135: 'age_min',
10136: p_age_min
10137: );
10138: END IF;

Line 10142: DBMS_SQL.bind_variable (l_query_handle,

10138: END IF;
10139:
10140: IF p_age_max IS NOT NULL
10141: THEN
10142: DBMS_SQL.bind_variable (l_query_handle,
10143: 'age_max',
10144: p_age_max
10145: );
10146:

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

10147: END IF;
10148: END IF;
10149:
10150: --execute the replenishment query
10151: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);
10152: g_record_count := g_record_count + l_query_count;
10153: DBMS_SQL.close_cursor(l_query_handle);
10154: END IF; --atleast one status --ER13869750
10155: END LOOP;

Line 10153: DBMS_SQL.close_cursor(l_query_handle);

10149:
10150: --execute the replenishment query
10151: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);
10152: g_record_count := g_record_count + l_query_count;
10153: DBMS_SQL.close_cursor(l_query_handle);
10154: END IF; --atleast one status --ER13869750
10155: END LOOP;
10156: EXCEPTION
10157: WHEN OTHERS THEN -- Bug 4150145

Line 10158: IF dbms_sql.is_open(l_query_handle) THEN

10154: END IF; --atleast one status --ER13869750
10155: END LOOP;
10156: EXCEPTION
10157: WHEN OTHERS THEN -- Bug 4150145
10158: IF dbms_sql.is_open(l_query_handle) THEN
10159: dbms_sql.close_cursor(l_query_handle);
10160: END IF;
10161: DEBUG (SQLERRM, 'Task_planning.query_mo_tasks');
10162: END query_move_tasks;

Line 10159: dbms_sql.close_cursor(l_query_handle);

10155: END LOOP;
10156: EXCEPTION
10157: WHEN OTHERS THEN -- Bug 4150145
10158: IF dbms_sql.is_open(l_query_handle) THEN
10159: dbms_sql.close_cursor(l_query_handle);
10160: END IF;
10161: DEBUG (SQLERRM, 'Task_planning.query_mo_tasks');
10162: END query_move_tasks;
10163:

Line 13224: l_query_handle := DBMS_SQL.open_cursor;

13220: END IF;
13221: l_query := l_insert_query || l_select_generic || l_from_generic || l_where_generic ;
13222: -- Parse, Bind and Execute the dynamic query
13223: DEBUG('l_query_afterchanges for bulk'||l_query);
13224: l_query_handle := DBMS_SQL.open_cursor;
13225: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
13226:
13227: IF p_organization_id IS NOT NULL THEN
13228: DBMS_SQL.bind_variable (l_query_handle, 'org_id', p_organization_id );

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

13221: l_query := l_insert_query || l_select_generic || l_from_generic || l_where_generic ;
13222: -- Parse, Bind and Execute the dynamic query
13223: DEBUG('l_query_afterchanges for bulk'||l_query);
13224: l_query_handle := DBMS_SQL.open_cursor;
13225: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
13226:
13227: IF p_organization_id IS NOT NULL THEN
13228: DBMS_SQL.bind_variable (l_query_handle, 'org_id', p_organization_id );
13229: END IF;

Line 13228: DBMS_SQL.bind_variable (l_query_handle, 'org_id', p_organization_id );

13224: l_query_handle := DBMS_SQL.open_cursor;
13225: DBMS_SQL.parse (l_query_handle, l_query, DBMS_SQL.native);
13226:
13227: IF p_organization_id IS NOT NULL THEN
13228: DBMS_SQL.bind_variable (l_query_handle, 'org_id', p_organization_id );
13229: END IF;
13230: IF p_subinventory_code IS NOT NULL THEN
13231: DBMS_SQL.bind_variable (l_query_handle, 'sub_code', p_subinventory_code );
13232: END IF;

Line 13231: DBMS_SQL.bind_variable (l_query_handle, 'sub_code', p_subinventory_code );

13227: IF p_organization_id IS NOT NULL THEN
13228: DBMS_SQL.bind_variable (l_query_handle, 'org_id', p_organization_id );
13229: END IF;
13230: IF p_subinventory_code IS NOT NULL THEN
13231: DBMS_SQL.bind_variable (l_query_handle, 'sub_code', p_subinventory_code );
13232: END IF;
13233: IF p_locator_id IS NOT NULL THEN
13234: DBMS_SQL.bind_variable (l_query_handle, 'loc_id', p_locator_id);
13235: END IF;

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

13230: IF p_subinventory_code IS NOT NULL THEN
13231: DBMS_SQL.bind_variable (l_query_handle, 'sub_code', p_subinventory_code );
13232: END IF;
13233: IF p_locator_id IS NOT NULL THEN
13234: DBMS_SQL.bind_variable (l_query_handle, 'loc_id', p_locator_id);
13235: END IF;
13236: IF p_inventory_item_id IS NOT NULL THEN
13237: DBMS_SQL.bind_variable (l_query_handle, 'item_id', p_inventory_item_id );
13238: END IF;

Line 13237: DBMS_SQL.bind_variable (l_query_handle, 'item_id', p_inventory_item_id );

13233: IF p_locator_id IS NOT NULL THEN
13234: DBMS_SQL.bind_variable (l_query_handle, 'loc_id', p_locator_id);
13235: END IF;
13236: IF p_inventory_item_id IS NOT NULL THEN
13237: DBMS_SQL.bind_variable (l_query_handle, 'item_id', p_inventory_item_id );
13238: END IF;
13239: IF p_category_set_id IS NOT NULL THEN
13240: DBMS_SQL.bind_variable (l_query_handle, 'category_set_id', p_category_set_id );
13241: END IF;

Line 13240: DBMS_SQL.bind_variable (l_query_handle, 'category_set_id', p_category_set_id );

13236: IF p_inventory_item_id IS NOT NULL THEN
13237: DBMS_SQL.bind_variable (l_query_handle, 'item_id', p_inventory_item_id );
13238: END IF;
13239: IF p_category_set_id IS NOT NULL THEN
13240: DBMS_SQL.bind_variable (l_query_handle, 'category_set_id', p_category_set_id );
13241: END IF;
13242:
13243:
13244: IF p_item_category_id IS NOT NULL THEN

Line 13245: DBMS_SQL.bind_variable (l_query_handle, 'item_category_id', p_item_category_id );

13241: END IF;
13242:
13243:
13244: IF p_item_category_id IS NOT NULL THEN
13245: DBMS_SQL.bind_variable (l_query_handle, 'item_category_id', p_item_category_id );
13246: END IF;
13247: IF p_person_id IS NOT NULL THEN
13248: DBMS_SQL.bind_variable (l_query_handle, 'person_id', p_person_id);
13249: END IF;

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

13244: IF p_item_category_id IS NOT NULL THEN
13245: DBMS_SQL.bind_variable (l_query_handle, 'item_category_id', p_item_category_id );
13246: END IF;
13247: IF p_person_id IS NOT NULL THEN
13248: DBMS_SQL.bind_variable (l_query_handle, 'person_id', p_person_id);
13249: END IF;
13250: IF p_person_resource_id IS NOT NULL THEN
13251: DBMS_SQL.bind_variable (l_query_handle, 'person_resource_id', p_person_resource_id );
13252: END IF;

Line 13251: DBMS_SQL.bind_variable (l_query_handle, 'person_resource_id', p_person_resource_id );

13247: IF p_person_id IS NOT NULL THEN
13248: DBMS_SQL.bind_variable (l_query_handle, 'person_id', p_person_id);
13249: END IF;
13250: IF p_person_resource_id IS NOT NULL THEN
13251: DBMS_SQL.bind_variable (l_query_handle, 'person_resource_id', p_person_resource_id );
13252: END IF;
13253: IF p_equipment_type_id IS NOT NULL THEN
13254: DBMS_SQL.bind_variable (l_query_handle, 'equipment_type_id', p_equipment_type_id );
13255: END IF;

Line 13254: DBMS_SQL.bind_variable (l_query_handle, 'equipment_type_id', p_equipment_type_id );

13250: IF p_person_resource_id IS NOT NULL THEN
13251: DBMS_SQL.bind_variable (l_query_handle, 'person_resource_id', p_person_resource_id );
13252: END IF;
13253: IF p_equipment_type_id IS NOT NULL THEN
13254: DBMS_SQL.bind_variable (l_query_handle, 'equipment_type_id', p_equipment_type_id );
13255: END IF;
13256: IF p_machine_resource_id IS NOT NULL THEN
13257: DBMS_SQL.bind_variable (l_query_handle, 'machine_resource_id', p_machine_resource_id );
13258: END IF;

Line 13257: DBMS_SQL.bind_variable (l_query_handle, 'machine_resource_id', p_machine_resource_id );

13253: IF p_equipment_type_id IS NOT NULL THEN
13254: DBMS_SQL.bind_variable (l_query_handle, 'equipment_type_id', p_equipment_type_id );
13255: END IF;
13256: IF p_machine_resource_id IS NOT NULL THEN
13257: DBMS_SQL.bind_variable (l_query_handle, 'machine_resource_id', p_machine_resource_id );
13258: END IF;
13259:
13260: IF p_machine_instance IS NOT NULL THEN
13261: DBMS_SQL.bind_variable (l_query_handle, 'machine_instance', p_machine_instance );

Line 13261: DBMS_SQL.bind_variable (l_query_handle, 'machine_instance', p_machine_instance );

13257: DBMS_SQL.bind_variable (l_query_handle, 'machine_resource_id', p_machine_resource_id );
13258: END IF;
13259:
13260: IF p_machine_instance IS NOT NULL THEN
13261: DBMS_SQL.bind_variable (l_query_handle, 'machine_instance', p_machine_instance );
13262: END IF;
13263: IF p_from_task_quantity IS NOT NULL THEN
13264: DBMS_SQL.bind_variable (l_query_handle, 'from_task_quantity', p_from_task_quantity );
13265: END IF;

Line 13264: DBMS_SQL.bind_variable (l_query_handle, 'from_task_quantity', p_from_task_quantity );

13260: IF p_machine_instance IS NOT NULL THEN
13261: DBMS_SQL.bind_variable (l_query_handle, 'machine_instance', p_machine_instance );
13262: END IF;
13263: IF p_from_task_quantity IS NOT NULL THEN
13264: DBMS_SQL.bind_variable (l_query_handle, 'from_task_quantity', p_from_task_quantity );
13265: END IF;
13266: IF p_to_task_quantity IS NOT NULL THEN
13267: DBMS_SQL.bind_variable (l_query_handle, 'to_task_quantity', p_to_task_quantity );
13268: END IF;

Line 13267: DBMS_SQL.bind_variable (l_query_handle, 'to_task_quantity', p_to_task_quantity );

13263: IF p_from_task_quantity IS NOT NULL THEN
13264: DBMS_SQL.bind_variable (l_query_handle, 'from_task_quantity', p_from_task_quantity );
13265: END IF;
13266: IF p_to_task_quantity IS NOT NULL THEN
13267: DBMS_SQL.bind_variable (l_query_handle, 'to_task_quantity', p_to_task_quantity );
13268: END IF;
13269: IF p_from_task_priority IS NOT NULL THEN
13270: DBMS_SQL.bind_variable (l_query_handle, 'from_task_priority', p_from_task_priority );
13271: END IF;

Line 13270: DBMS_SQL.bind_variable (l_query_handle, 'from_task_priority', p_from_task_priority );

13266: IF p_to_task_quantity IS NOT NULL THEN
13267: DBMS_SQL.bind_variable (l_query_handle, 'to_task_quantity', p_to_task_quantity );
13268: END IF;
13269: IF p_from_task_priority IS NOT NULL THEN
13270: DBMS_SQL.bind_variable (l_query_handle, 'from_task_priority', p_from_task_priority );
13271: END IF;
13272: IF p_to_task_priority IS NOT NULL THEN
13273: DBMS_SQL.bind_variable (l_query_handle, 'to_task_priority', p_to_task_priority );
13274: END IF;

Line 13273: DBMS_SQL.bind_variable (l_query_handle, 'to_task_priority', p_to_task_priority );

13269: IF p_from_task_priority IS NOT NULL THEN
13270: DBMS_SQL.bind_variable (l_query_handle, 'from_task_priority', p_from_task_priority );
13271: END IF;
13272: IF p_to_task_priority IS NOT NULL THEN
13273: DBMS_SQL.bind_variable (l_query_handle, 'to_task_priority', p_to_task_priority );
13274: END IF;
13275: IF p_from_creation_date IS NOT NULL
13276: THEN
13277: IF g_is_api_call THEN --Bug 13594691

Line 13278: DBMS_SQL.bind_variable (l_query_handle,

13274: END IF;
13275: IF p_from_creation_date IS NOT NULL
13276: THEN
13277: IF g_is_api_call THEN --Bug 13594691
13278: DBMS_SQL.bind_variable (l_query_handle,
13279: 'from_creation_date',
13280: -- p_from_creation_date --commented in 6868286
13281: TRUNC(p_from_creation_date) --added in 6868286
13282: );

Line 13284: DBMS_SQL.bind_variable (l_query_handle,

13280: -- p_from_creation_date --commented in 6868286
13281: TRUNC(p_from_creation_date) --added in 6868286
13282: );
13283: ELSE --Bug 13594691
13284: DBMS_SQL.bind_variable (l_query_handle,
13285: 'from_creation_date',
13286: p_from_creation_date
13287: );
13288: END IF;

Line 13294: DBMS_SQL.bind_variable (l_query_handle,

13290:
13291: IF p_to_creation_date IS NOT NULL
13292: THEN
13293: IF g_is_api_call THEN --Bug 13594691
13294: DBMS_SQL.bind_variable (l_query_handle,
13295: 'to_creation_date',
13296: --p_to_creation_date --commented in 6868286
13297: TRUNC(p_to_creation_date) --added in 6868286
13298: );

Line 13300: DBMS_SQL.bind_variable (l_query_handle,

13296: --p_to_creation_date --commented in 6868286
13297: TRUNC(p_to_creation_date) --added in 6868286
13298: );
13299: ELSE --Bug 13594691
13300: DBMS_SQL.bind_variable (l_query_handle,
13301: 'to_creation_date',
13302: p_to_creation_date
13303: );
13304: END IF;

Line 13310: DBMS_SQL.bind_variable (l_query_handle, 'item_type_code', p_item_type_code );

13306: END IF;
13307:
13308:
13309: IF p_item_type_code IS NOT NULL THEN
13310: DBMS_SQL.bind_variable (l_query_handle, 'item_type_code', p_item_type_code );
13311: END IF;
13312: IF p_user_task_type_id IS NOT NULL THEN
13313: DBMS_SQL.bind_variable (l_query_handle, 'user_task_type_id', p_user_task_type_id );
13314: END IF;

Line 13313: DBMS_SQL.bind_variable (l_query_handle, 'user_task_type_id', p_user_task_type_id );

13309: IF p_item_type_code IS NOT NULL THEN
13310: DBMS_SQL.bind_variable (l_query_handle, 'item_type_code', p_item_type_code );
13311: END IF;
13312: IF p_user_task_type_id IS NOT NULL THEN
13313: DBMS_SQL.bind_variable (l_query_handle, 'user_task_type_id', p_user_task_type_id );
13314: END IF;
13315: IF p_age_uom_code IS NOT NULL THEN
13316: IF p_age_min IS NOT NULL THEN
13317: DBMS_SQL.bind_variable (l_query_handle, 'age_min', p_age_min );

Line 13317: DBMS_SQL.bind_variable (l_query_handle, 'age_min', p_age_min );

13313: DBMS_SQL.bind_variable (l_query_handle, 'user_task_type_id', p_user_task_type_id );
13314: END IF;
13315: IF p_age_uom_code IS NOT NULL THEN
13316: IF p_age_min IS NOT NULL THEN
13317: DBMS_SQL.bind_variable (l_query_handle, 'age_min', p_age_min );
13318: END IF;
13319: IF p_age_max IS NOT NULL THEN
13320: DBMS_SQL.bind_variable (l_query_handle, 'age_max', p_age_max );
13321: END IF;

Line 13320: DBMS_SQL.bind_variable (l_query_handle, 'age_max', p_age_max );

13316: IF p_age_min IS NOT NULL THEN
13317: DBMS_SQL.bind_variable (l_query_handle, 'age_min', p_age_min );
13318: END IF;
13319: IF p_age_max IS NOT NULL THEN
13320: DBMS_SQL.bind_variable (l_query_handle, 'age_max', p_age_max );
13321: END IF;
13322: END IF;
13323: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);
13324: DBMS_SQL.close_cursor(l_query_handle);

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

13319: IF p_age_max IS NOT NULL THEN
13320: DBMS_SQL.bind_variable (l_query_handle, 'age_max', p_age_max );
13321: END IF;
13322: END IF;
13323: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);
13324: DBMS_SQL.close_cursor(l_query_handle);
13325: EXCEPTION
13326: WHEN OTHERS THEN -- Bug 4150145
13327: DEBUG('ENTERED INTOEXCEPTION123'||SQLERRM);

Line 13324: DBMS_SQL.close_cursor(l_query_handle);

13320: DBMS_SQL.bind_variable (l_query_handle, 'age_max', p_age_max );
13321: END IF;
13322: END IF;
13323: l_query_count := DBMS_SQL.EXECUTE (l_query_handle);
13324: DBMS_SQL.close_cursor(l_query_handle);
13325: EXCEPTION
13326: WHEN OTHERS THEN -- Bug 4150145
13327: DEBUG('ENTERED INTOEXCEPTION123'||SQLERRM);
13328: IF dbms_sql.is_open(l_query_handle) THEN

Line 13328: IF dbms_sql.is_open(l_query_handle) THEN

13324: DBMS_SQL.close_cursor(l_query_handle);
13325: EXCEPTION
13326: WHEN OTHERS THEN -- Bug 4150145
13327: DEBUG('ENTERED INTOEXCEPTION123'||SQLERRM);
13328: IF dbms_sql.is_open(l_query_handle) THEN
13329: DBMS_SQL.close_cursor(l_query_handle);
13330: END IF;
13331: END;
13332: end if;

Line 13329: DBMS_SQL.close_cursor(l_query_handle);

13325: EXCEPTION
13326: WHEN OTHERS THEN -- Bug 4150145
13327: DEBUG('ENTERED INTOEXCEPTION123'||SQLERRM);
13328: IF dbms_sql.is_open(l_query_handle) THEN
13329: DBMS_SQL.close_cursor(l_query_handle);
13330: END IF;
13331: END;
13332: end if;
13333: EXCEPTION