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

Line 3027: l_cursor_id := DBMS_SQL.Open_Cursor;

3023: WHERE INVENTORY_ITEM_ID = i.inventory_item_id
3024: AND ORGANIZATION_ID = i.organization_id;
3025:
3026: IF l_cursor_id IS NULL THEN
3027: l_cursor_id := DBMS_SQL.Open_Cursor;
3028: l_dynamic_sql := 'select type_name from eng_change_order_types_vl '||
3029: 'where change_order_type_id = :type_id ';
3030: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3031: DBMS_SQL.define_column(l_cursor_id,1,l_type_name,1000);

Line 3030: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);

3026: IF l_cursor_id IS NULL THEN
3027: l_cursor_id := DBMS_SQL.Open_Cursor;
3028: l_dynamic_sql := 'select type_name from eng_change_order_types_vl '||
3029: 'where change_order_type_id = :type_id ';
3030: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3031: DBMS_SQL.define_column(l_cursor_id,1,l_type_name,1000);
3032: END IF;
3033: DBMS_SQL.Bind_Variable(l_cursor_id, 'type_id', i.NEW_ITEM_REQ_CHANGE_TYPE_ID);
3034: l_dummy := DBMS_SQL.Execute(l_cursor_id);

Line 3031: DBMS_SQL.define_column(l_cursor_id,1,l_type_name,1000);

3027: l_cursor_id := DBMS_SQL.Open_Cursor;
3028: l_dynamic_sql := 'select type_name from eng_change_order_types_vl '||
3029: 'where change_order_type_id = :type_id ';
3030: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3031: DBMS_SQL.define_column(l_cursor_id,1,l_type_name,1000);
3032: END IF;
3033: DBMS_SQL.Bind_Variable(l_cursor_id, 'type_id', i.NEW_ITEM_REQ_CHANGE_TYPE_ID);
3034: l_dummy := DBMS_SQL.Execute(l_cursor_id);
3035: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN

Line 3033: DBMS_SQL.Bind_Variable(l_cursor_id, 'type_id', i.NEW_ITEM_REQ_CHANGE_TYPE_ID);

3029: 'where change_order_type_id = :type_id ';
3030: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3031: DBMS_SQL.define_column(l_cursor_id,1,l_type_name,1000);
3032: END IF;
3033: DBMS_SQL.Bind_Variable(l_cursor_id, 'type_id', i.NEW_ITEM_REQ_CHANGE_TYPE_ID);
3034: l_dummy := DBMS_SQL.Execute(l_cursor_id);
3035: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN
3036: dbms_sql.column_value(l_cursor_id,1,l_type_name);
3037: EXECUTE IMMEDIATE

Line 3034: l_dummy := DBMS_SQL.Execute(l_cursor_id);

3030: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3031: DBMS_SQL.define_column(l_cursor_id,1,l_type_name,1000);
3032: END IF;
3033: DBMS_SQL.Bind_Variable(l_cursor_id, 'type_id', i.NEW_ITEM_REQ_CHANGE_TYPE_ID);
3034: l_dummy := DBMS_SQL.Execute(l_cursor_id);
3035: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN
3036: dbms_sql.column_value(l_cursor_id,1,l_type_name);
3037: EXECUTE IMMEDIATE
3038: ' BEGIN '

Line 3035: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN

3031: DBMS_SQL.define_column(l_cursor_id,1,l_type_name,1000);
3032: END IF;
3033: DBMS_SQL.Bind_Variable(l_cursor_id, 'type_id', i.NEW_ITEM_REQ_CHANGE_TYPE_ID);
3034: l_dummy := DBMS_SQL.Execute(l_cursor_id);
3035: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN
3036: dbms_sql.column_value(l_cursor_id,1,l_type_name);
3037: EXECUTE IMMEDIATE
3038: ' BEGIN '
3039: ||' ENG_NEW_ITEM_REQ_UTIL.Create_New_Item_Request( '

Line 3036: dbms_sql.column_value(l_cursor_id,1,l_type_name);

3032: END IF;
3033: DBMS_SQL.Bind_Variable(l_cursor_id, 'type_id', i.NEW_ITEM_REQ_CHANGE_TYPE_ID);
3034: l_dummy := DBMS_SQL.Execute(l_cursor_id);
3035: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN
3036: dbms_sql.column_value(l_cursor_id,1,l_type_name);
3037: EXECUTE IMMEDIATE
3038: ' BEGIN '
3039: ||' ENG_NEW_ITEM_REQ_UTIL.Create_New_Item_Request( '
3040: ||' change_number => :i.ITEM_NUMBER '

Line 3106: dbms_sql.close_cursor(l_cursor_id);

3102: WHERE rowid = i.rowid;
3103: END IF;
3104: END LOOP;
3105: IF l_cursor_id IS NOT NULL THEN
3106: dbms_sql.close_cursor(l_cursor_id);
3107: END IF;
3108: END IF;
3109:
3110: EXCEPTION

Line 3267: l_cursor_id := DBMS_SQL.Open_Cursor;

3263: l_raise_cancel_nir := FALSE;
3264: l_update_msb := FALSE;
3265:
3266: IF l_cursor_id IS NULL THEN
3267: l_cursor_id := DBMS_SQL.Open_Cursor;
3268:
3269: /* Bug 5253300 /5253294 Using Status Type Column from eng_change_statuses_vl corresponding to
3270: Status Code from eng_engineering_changes - Anmurali */
3271: l_dynamic_sql := 'SELECT st.status_type

Line 3288: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);

3284: AND st.status_code = ch.status_code
3285: AND sb.pk1_value = :l_inv_item_id
3286: AND sb.pk2_value = :l_org_id';
3287:
3288: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3289: DBMS_SQL.define_column(l_cursor_id,1,l_nir_status_type);
3290: DBMS_SQL.define_column(l_cursor_id,2,l_nir_approval_status_type);
3291: DBMS_SQL.define_column(l_cursor_id,3,l_change_id);
3292: DBMS_SQL.define_column(l_cursor_id,4,l_change_notice,100);

Line 3289: DBMS_SQL.define_column(l_cursor_id,1,l_nir_status_type);

3285: AND sb.pk1_value = :l_inv_item_id
3286: AND sb.pk2_value = :l_org_id';
3287:
3288: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3289: DBMS_SQL.define_column(l_cursor_id,1,l_nir_status_type);
3290: DBMS_SQL.define_column(l_cursor_id,2,l_nir_approval_status_type);
3291: DBMS_SQL.define_column(l_cursor_id,3,l_change_id);
3292: DBMS_SQL.define_column(l_cursor_id,4,l_change_notice,100);
3293: END IF;

Line 3290: DBMS_SQL.define_column(l_cursor_id,2,l_nir_approval_status_type);

3286: AND sb.pk2_value = :l_org_id';
3287:
3288: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3289: DBMS_SQL.define_column(l_cursor_id,1,l_nir_status_type);
3290: DBMS_SQL.define_column(l_cursor_id,2,l_nir_approval_status_type);
3291: DBMS_SQL.define_column(l_cursor_id,3,l_change_id);
3292: DBMS_SQL.define_column(l_cursor_id,4,l_change_notice,100);
3293: END IF;
3294:

Line 3291: DBMS_SQL.define_column(l_cursor_id,3,l_change_id);

3287:
3288: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3289: DBMS_SQL.define_column(l_cursor_id,1,l_nir_status_type);
3290: DBMS_SQL.define_column(l_cursor_id,2,l_nir_approval_status_type);
3291: DBMS_SQL.define_column(l_cursor_id,3,l_change_id);
3292: DBMS_SQL.define_column(l_cursor_id,4,l_change_notice,100);
3293: END IF;
3294:
3295: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_type_classification' , 'CATEGORY');

Line 3292: DBMS_SQL.define_column(l_cursor_id,4,l_change_notice,100);

3288: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3289: DBMS_SQL.define_column(l_cursor_id,1,l_nir_status_type);
3290: DBMS_SQL.define_column(l_cursor_id,2,l_nir_approval_status_type);
3291: DBMS_SQL.define_column(l_cursor_id,3,l_change_id);
3292: DBMS_SQL.define_column(l_cursor_id,4,l_change_notice,100);
3293: END IF;
3294:
3295: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_type_classification' , 'CATEGORY');
3296: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_change_mgmt_type_code', 'NEW_ITEM_REQUEST');

Line 3295: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_type_classification' , 'CATEGORY');

3291: DBMS_SQL.define_column(l_cursor_id,3,l_change_id);
3292: DBMS_SQL.define_column(l_cursor_id,4,l_change_notice,100);
3293: END IF;
3294:
3295: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_type_classification' , 'CATEGORY');
3296: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_change_mgmt_type_code', 'NEW_ITEM_REQUEST');
3297: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_entity_name' , 'EGO_ITEM');
3298: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_inv_item_id' , p_inventory_item_id);
3299: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_org_id' , p_organization_id);

Line 3296: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_change_mgmt_type_code', 'NEW_ITEM_REQUEST');

3292: DBMS_SQL.define_column(l_cursor_id,4,l_change_notice,100);
3293: END IF;
3294:
3295: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_type_classification' , 'CATEGORY');
3296: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_change_mgmt_type_code', 'NEW_ITEM_REQUEST');
3297: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_entity_name' , 'EGO_ITEM');
3298: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_inv_item_id' , p_inventory_item_id);
3299: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_org_id' , p_organization_id);
3300: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);

Line 3297: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_entity_name' , 'EGO_ITEM');

3293: END IF;
3294:
3295: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_type_classification' , 'CATEGORY');
3296: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_change_mgmt_type_code', 'NEW_ITEM_REQUEST');
3297: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_entity_name' , 'EGO_ITEM');
3298: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_inv_item_id' , p_inventory_item_id);
3299: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_org_id' , p_organization_id);
3300: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
3301:

Line 3298: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_inv_item_id' , p_inventory_item_id);

3294:
3295: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_type_classification' , 'CATEGORY');
3296: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_change_mgmt_type_code', 'NEW_ITEM_REQUEST');
3297: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_entity_name' , 'EGO_ITEM');
3298: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_inv_item_id' , p_inventory_item_id);
3299: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_org_id' , p_organization_id);
3300: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
3301:
3302: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN

Line 3299: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_org_id' , p_organization_id);

3295: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_type_classification' , 'CATEGORY');
3296: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_change_mgmt_type_code', 'NEW_ITEM_REQUEST');
3297: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_entity_name' , 'EGO_ITEM');
3298: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_inv_item_id' , p_inventory_item_id);
3299: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_org_id' , p_organization_id);
3300: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
3301:
3302: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN
3303: dbms_sql.column_value(l_cursor_id,1,l_nir_status_type);

Line 3300: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);

3296: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_change_mgmt_type_code', 'NEW_ITEM_REQUEST');
3297: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_entity_name' , 'EGO_ITEM');
3298: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_inv_item_id' , p_inventory_item_id);
3299: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_org_id' , p_organization_id);
3300: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
3301:
3302: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN
3303: dbms_sql.column_value(l_cursor_id,1,l_nir_status_type);
3304: dbms_sql.column_value(l_cursor_id,2,l_nir_approval_status_type);

Line 3302: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN

3298: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_inv_item_id' , p_inventory_item_id);
3299: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_org_id' , p_organization_id);
3300: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
3301:
3302: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN
3303: dbms_sql.column_value(l_cursor_id,1,l_nir_status_type);
3304: dbms_sql.column_value(l_cursor_id,2,l_nir_approval_status_type);
3305: dbms_sql.column_value(l_cursor_id,3,l_change_id);
3306: dbms_sql.column_value(l_cursor_id,4,l_change_notice);

Line 3303: dbms_sql.column_value(l_cursor_id,1,l_nir_status_type);

3299: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_org_id' , p_organization_id);
3300: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
3301:
3302: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN
3303: dbms_sql.column_value(l_cursor_id,1,l_nir_status_type);
3304: dbms_sql.column_value(l_cursor_id,2,l_nir_approval_status_type);
3305: dbms_sql.column_value(l_cursor_id,3,l_change_id);
3306: dbms_sql.column_value(l_cursor_id,4,l_change_notice);
3307: END IF;

Line 3304: dbms_sql.column_value(l_cursor_id,2,l_nir_approval_status_type);

3300: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
3301:
3302: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN
3303: dbms_sql.column_value(l_cursor_id,1,l_nir_status_type);
3304: dbms_sql.column_value(l_cursor_id,2,l_nir_approval_status_type);
3305: dbms_sql.column_value(l_cursor_id,3,l_change_id);
3306: dbms_sql.column_value(l_cursor_id,4,l_change_notice);
3307: END IF;
3308:

Line 3305: dbms_sql.column_value(l_cursor_id,3,l_change_id);

3301:
3302: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN
3303: dbms_sql.column_value(l_cursor_id,1,l_nir_status_type);
3304: dbms_sql.column_value(l_cursor_id,2,l_nir_approval_status_type);
3305: dbms_sql.column_value(l_cursor_id,3,l_change_id);
3306: dbms_sql.column_value(l_cursor_id,4,l_change_notice);
3307: END IF;
3308:
3309: OPEN c_get_nir_setup (p_new_item_cat_grp_id);

Line 3306: dbms_sql.column_value(l_cursor_id,4,l_change_notice);

3302: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN
3303: dbms_sql.column_value(l_cursor_id,1,l_nir_status_type);
3304: dbms_sql.column_value(l_cursor_id,2,l_nir_approval_status_type);
3305: dbms_sql.column_value(l_cursor_id,3,l_change_id);
3306: dbms_sql.column_value(l_cursor_id,4,l_change_notice);
3307: END IF;
3308:
3309: OPEN c_get_nir_setup (p_new_item_cat_grp_id);
3310: FETCH c_get_nir_setup INTO l_new_nir_reqd;

Line 3501: dbms_sql.close_cursor(l_cursor_id);

3497: AND organization_id = p_organization_id;
3498: END IF;
3499:
3500: IF l_cursor_id IS NOT NULL THEN
3501: dbms_sql.close_cursor(l_cursor_id);
3502: END IF;
3503:
3504: RETURN (0);
3505:

Line 3509: dbms_sql.close_cursor(l_cursor_id);

3505:
3506: EXCEPTION
3507: WHEN OTHERS THEN
3508: IF l_cursor_id IS NOT NULL THEN
3509: dbms_sql.close_cursor(l_cursor_id);
3510: END IF;
3511: RETURN(SQLCODE);
3512: END mtl_catalog_group_update;
3513:

Line 3607: l_cursor_id := DBMS_SQL.Open_Cursor;

3603: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
3604: AND ORGANIZATION_ID = p_organization_id;
3605:
3606: IF l_cursor_id IS NULL THEN
3607: l_cursor_id := DBMS_SQL.Open_Cursor;
3608: l_dynamic_sql := 'select type_name from eng_change_order_types_vl '||
3609: 'where change_order_type_id = :type_id ';
3610: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3611: DBMS_SQL.define_column(l_cursor_id,1,l_type_name,1000);

Line 3610: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);

3606: IF l_cursor_id IS NULL THEN
3607: l_cursor_id := DBMS_SQL.Open_Cursor;
3608: l_dynamic_sql := 'select type_name from eng_change_order_types_vl '||
3609: 'where change_order_type_id = :type_id ';
3610: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3611: DBMS_SQL.define_column(l_cursor_id,1,l_type_name,1000);
3612: END IF;
3613: DBMS_SQL.Bind_Variable(l_cursor_id, 'type_id', l_type_id);
3614: l_dummy := DBMS_SQL.Execute(l_cursor_id);

Line 3611: DBMS_SQL.define_column(l_cursor_id,1,l_type_name,1000);

3607: l_cursor_id := DBMS_SQL.Open_Cursor;
3608: l_dynamic_sql := 'select type_name from eng_change_order_types_vl '||
3609: 'where change_order_type_id = :type_id ';
3610: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3611: DBMS_SQL.define_column(l_cursor_id,1,l_type_name,1000);
3612: END IF;
3613: DBMS_SQL.Bind_Variable(l_cursor_id, 'type_id', l_type_id);
3614: l_dummy := DBMS_SQL.Execute(l_cursor_id);
3615: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN

Line 3613: DBMS_SQL.Bind_Variable(l_cursor_id, 'type_id', l_type_id);

3609: 'where change_order_type_id = :type_id ';
3610: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3611: DBMS_SQL.define_column(l_cursor_id,1,l_type_name,1000);
3612: END IF;
3613: DBMS_SQL.Bind_Variable(l_cursor_id, 'type_id', l_type_id);
3614: l_dummy := DBMS_SQL.Execute(l_cursor_id);
3615: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN
3616: dbms_sql.column_value(l_cursor_id,1,l_type_name);
3617: EXECUTE IMMEDIATE

Line 3614: l_dummy := DBMS_SQL.Execute(l_cursor_id);

3610: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3611: DBMS_SQL.define_column(l_cursor_id,1,l_type_name,1000);
3612: END IF;
3613: DBMS_SQL.Bind_Variable(l_cursor_id, 'type_id', l_type_id);
3614: l_dummy := DBMS_SQL.Execute(l_cursor_id);
3615: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN
3616: dbms_sql.column_value(l_cursor_id,1,l_type_name);
3617: EXECUTE IMMEDIATE
3618: ' BEGIN '

Line 3615: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN

3611: DBMS_SQL.define_column(l_cursor_id,1,l_type_name,1000);
3612: END IF;
3613: DBMS_SQL.Bind_Variable(l_cursor_id, 'type_id', l_type_id);
3614: l_dummy := DBMS_SQL.Execute(l_cursor_id);
3615: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN
3616: dbms_sql.column_value(l_cursor_id,1,l_type_name);
3617: EXECUTE IMMEDIATE
3618: ' BEGIN '
3619: ||' ENG_NEW_ITEM_REQ_UTIL.Create_New_Item_Request( '

Line 3616: dbms_sql.column_value(l_cursor_id,1,l_type_name);

3612: END IF;
3613: DBMS_SQL.Bind_Variable(l_cursor_id, 'type_id', l_type_id);
3614: l_dummy := DBMS_SQL.Execute(l_cursor_id);
3615: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN
3616: dbms_sql.column_value(l_cursor_id,1,l_type_name);
3617: EXECUTE IMMEDIATE
3618: ' BEGIN '
3619: ||' ENG_NEW_ITEM_REQ_UTIL.Create_New_Item_Request( '
3620: ||' change_number => :p_item_number '

Line 3640: dbms_sql.close_cursor(l_cursor_id);

3636: l_return_status := FND_API.G_RET_STS_ERROR;
3637: END IF;
3638: x_return_status := l_return_status;
3639: IF l_cursor_id IS NOT NULL THEN
3640: dbms_sql.close_cursor(l_cursor_id);
3641: END IF;
3642: EXCEPTION
3643: WHEN others THEN
3644: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3646: dbms_sql.close_cursor(l_cursor_id);

3642: EXCEPTION
3643: WHEN others THEN
3644: x_return_status := FND_API.G_RET_STS_ERROR;
3645: IF l_cursor_id IS NOT NULL THEN
3646: dbms_sql.close_cursor(l_cursor_id);
3647: END IF;
3648: INVPUTLI.info('INV_EGO_REVISION_VALIDATE.Create_New_Item_Request: Exception'||substr(SQLERRM,1,200));
3649: END Create_New_Item_Req_Upd; */
3650: -- End : 5258295