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 3237: l_cursor_id := DBMS_SQL.Open_Cursor;

3233: WHERE INVENTORY_ITEM_ID = i.inventory_item_id
3234: AND ORGANIZATION_ID = i.organization_id;
3235:
3236: IF l_cursor_id IS NULL THEN
3237: l_cursor_id := DBMS_SQL.Open_Cursor;
3238: l_dynamic_sql := 'select type_name from eng_change_order_types_vl '||
3239: 'where change_order_type_id = :type_id ';
3240: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3241: DBMS_SQL.define_column(l_cursor_id,1,l_type_name,1000);

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

3236: IF l_cursor_id IS NULL THEN
3237: l_cursor_id := DBMS_SQL.Open_Cursor;
3238: l_dynamic_sql := 'select type_name from eng_change_order_types_vl '||
3239: 'where change_order_type_id = :type_id ';
3240: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3241: DBMS_SQL.define_column(l_cursor_id,1,l_type_name,1000);
3242: END IF;
3243: DBMS_SQL.Bind_Variable(l_cursor_id, 'type_id', i.NEW_ITEM_REQ_CHANGE_TYPE_ID);
3244: l_dummy := DBMS_SQL.Execute(l_cursor_id);

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

3237: l_cursor_id := DBMS_SQL.Open_Cursor;
3238: l_dynamic_sql := 'select type_name from eng_change_order_types_vl '||
3239: 'where change_order_type_id = :type_id ';
3240: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3241: DBMS_SQL.define_column(l_cursor_id,1,l_type_name,1000);
3242: END IF;
3243: DBMS_SQL.Bind_Variable(l_cursor_id, 'type_id', i.NEW_ITEM_REQ_CHANGE_TYPE_ID);
3244: l_dummy := DBMS_SQL.Execute(l_cursor_id);
3245: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN

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

3239: 'where change_order_type_id = :type_id ';
3240: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3241: DBMS_SQL.define_column(l_cursor_id,1,l_type_name,1000);
3242: END IF;
3243: DBMS_SQL.Bind_Variable(l_cursor_id, 'type_id', i.NEW_ITEM_REQ_CHANGE_TYPE_ID);
3244: l_dummy := DBMS_SQL.Execute(l_cursor_id);
3245: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN
3246: dbms_sql.column_value(l_cursor_id,1,l_type_name);
3247: EXECUTE IMMEDIATE

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

3240: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3241: DBMS_SQL.define_column(l_cursor_id,1,l_type_name,1000);
3242: END IF;
3243: DBMS_SQL.Bind_Variable(l_cursor_id, 'type_id', i.NEW_ITEM_REQ_CHANGE_TYPE_ID);
3244: l_dummy := DBMS_SQL.Execute(l_cursor_id);
3245: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN
3246: dbms_sql.column_value(l_cursor_id,1,l_type_name);
3247: EXECUTE IMMEDIATE
3248: ' BEGIN '

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

3241: DBMS_SQL.define_column(l_cursor_id,1,l_type_name,1000);
3242: END IF;
3243: DBMS_SQL.Bind_Variable(l_cursor_id, 'type_id', i.NEW_ITEM_REQ_CHANGE_TYPE_ID);
3244: l_dummy := DBMS_SQL.Execute(l_cursor_id);
3245: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN
3246: dbms_sql.column_value(l_cursor_id,1,l_type_name);
3247: EXECUTE IMMEDIATE
3248: ' BEGIN '
3249: ||' ENG_NEW_ITEM_REQ_UTIL.Create_New_Item_Request( '

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

3242: END IF;
3243: DBMS_SQL.Bind_Variable(l_cursor_id, 'type_id', i.NEW_ITEM_REQ_CHANGE_TYPE_ID);
3244: l_dummy := DBMS_SQL.Execute(l_cursor_id);
3245: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN
3246: dbms_sql.column_value(l_cursor_id,1,l_type_name);
3247: EXECUTE IMMEDIATE
3248: ' BEGIN '
3249: ||' ENG_NEW_ITEM_REQ_UTIL.Create_New_Item_Request( '
3250: ||' change_number => :i.ITEM_NUMBER '

Line 3316: dbms_sql.close_cursor(l_cursor_id);

3312: WHERE rowid = i.rowid;
3313: END IF;
3314: END LOOP;
3315: IF l_cursor_id IS NOT NULL THEN
3316: dbms_sql.close_cursor(l_cursor_id);
3317: END IF;
3318: END IF;
3319:
3320: EXCEPTION

Line 3488: l_cursor_id := DBMS_SQL.Open_Cursor;

3484: l_raise_cancel_nir := FALSE;
3485: l_update_msb := FALSE;
3486:
3487: IF l_cursor_id IS NULL THEN
3488: l_cursor_id := DBMS_SQL.Open_Cursor;
3489:
3490: /* Bug 5253300 /5253294 Using Status Type Column from eng_change_statuses_vl corresponding to
3491: Status Code from eng_engineering_changes - Anmurali */
3492: l_dynamic_sql := 'SELECT st.status_type

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

3505: AND st.status_code = ch.status_code
3506: AND sb.pk1_value = :l_inv_item_id
3507: AND sb.pk2_value = :l_org_id';
3508:
3509: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3510: DBMS_SQL.define_column(l_cursor_id,1,l_nir_status_type);
3511: DBMS_SQL.define_column(l_cursor_id,2,l_nir_approval_status_type);
3512: DBMS_SQL.define_column(l_cursor_id,3,l_change_id);
3513: DBMS_SQL.define_column(l_cursor_id,4,l_change_notice,100);

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

3506: AND sb.pk1_value = :l_inv_item_id
3507: AND sb.pk2_value = :l_org_id';
3508:
3509: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3510: DBMS_SQL.define_column(l_cursor_id,1,l_nir_status_type);
3511: DBMS_SQL.define_column(l_cursor_id,2,l_nir_approval_status_type);
3512: DBMS_SQL.define_column(l_cursor_id,3,l_change_id);
3513: DBMS_SQL.define_column(l_cursor_id,4,l_change_notice,100);
3514: END IF;

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

3507: AND sb.pk2_value = :l_org_id';
3508:
3509: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3510: DBMS_SQL.define_column(l_cursor_id,1,l_nir_status_type);
3511: DBMS_SQL.define_column(l_cursor_id,2,l_nir_approval_status_type);
3512: DBMS_SQL.define_column(l_cursor_id,3,l_change_id);
3513: DBMS_SQL.define_column(l_cursor_id,4,l_change_notice,100);
3514: END IF;
3515:

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

3508:
3509: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3510: DBMS_SQL.define_column(l_cursor_id,1,l_nir_status_type);
3511: DBMS_SQL.define_column(l_cursor_id,2,l_nir_approval_status_type);
3512: DBMS_SQL.define_column(l_cursor_id,3,l_change_id);
3513: DBMS_SQL.define_column(l_cursor_id,4,l_change_notice,100);
3514: END IF;
3515:
3516: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_type_classification' , 'CATEGORY');

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

3509: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3510: DBMS_SQL.define_column(l_cursor_id,1,l_nir_status_type);
3511: DBMS_SQL.define_column(l_cursor_id,2,l_nir_approval_status_type);
3512: DBMS_SQL.define_column(l_cursor_id,3,l_change_id);
3513: DBMS_SQL.define_column(l_cursor_id,4,l_change_notice,100);
3514: END IF;
3515:
3516: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_type_classification' , 'CATEGORY');
3517: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_change_mgmt_type_code', 'NEW_ITEM_REQUEST');

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

3512: DBMS_SQL.define_column(l_cursor_id,3,l_change_id);
3513: DBMS_SQL.define_column(l_cursor_id,4,l_change_notice,100);
3514: END IF;
3515:
3516: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_type_classification' , 'CATEGORY');
3517: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_change_mgmt_type_code', 'NEW_ITEM_REQUEST');
3518: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_entity_name' , 'EGO_ITEM');
3519: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_inv_item_id' , p_inventory_item_id);
3520: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_org_id' , p_organization_id);

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

3513: DBMS_SQL.define_column(l_cursor_id,4,l_change_notice,100);
3514: END IF;
3515:
3516: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_type_classification' , 'CATEGORY');
3517: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_change_mgmt_type_code', 'NEW_ITEM_REQUEST');
3518: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_entity_name' , 'EGO_ITEM');
3519: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_inv_item_id' , p_inventory_item_id);
3520: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_org_id' , p_organization_id);
3521: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);

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

3514: END IF;
3515:
3516: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_type_classification' , 'CATEGORY');
3517: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_change_mgmt_type_code', 'NEW_ITEM_REQUEST');
3518: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_entity_name' , 'EGO_ITEM');
3519: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_inv_item_id' , p_inventory_item_id);
3520: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_org_id' , p_organization_id);
3521: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
3522:

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

3515:
3516: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_type_classification' , 'CATEGORY');
3517: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_change_mgmt_type_code', 'NEW_ITEM_REQUEST');
3518: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_entity_name' , 'EGO_ITEM');
3519: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_inv_item_id' , p_inventory_item_id);
3520: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_org_id' , p_organization_id);
3521: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
3522:
3523: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN

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

3516: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_type_classification' , 'CATEGORY');
3517: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_change_mgmt_type_code', 'NEW_ITEM_REQUEST');
3518: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_entity_name' , 'EGO_ITEM');
3519: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_inv_item_id' , p_inventory_item_id);
3520: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_org_id' , p_organization_id);
3521: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
3522:
3523: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN
3524: dbms_sql.column_value(l_cursor_id,1,l_nir_status_type);

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

3517: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_change_mgmt_type_code', 'NEW_ITEM_REQUEST');
3518: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_entity_name' , 'EGO_ITEM');
3519: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_inv_item_id' , p_inventory_item_id);
3520: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_org_id' , p_organization_id);
3521: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
3522:
3523: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN
3524: dbms_sql.column_value(l_cursor_id,1,l_nir_status_type);
3525: dbms_sql.column_value(l_cursor_id,2,l_nir_approval_status_type);

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

3519: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_inv_item_id' , p_inventory_item_id);
3520: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_org_id' , p_organization_id);
3521: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
3522:
3523: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN
3524: dbms_sql.column_value(l_cursor_id,1,l_nir_status_type);
3525: dbms_sql.column_value(l_cursor_id,2,l_nir_approval_status_type);
3526: dbms_sql.column_value(l_cursor_id,3,l_change_id);
3527: dbms_sql.column_value(l_cursor_id,4,l_change_notice);

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

3520: DBMS_SQL.Bind_Variable(l_cursor_id, 'l_org_id' , p_organization_id);
3521: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
3522:
3523: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN
3524: dbms_sql.column_value(l_cursor_id,1,l_nir_status_type);
3525: dbms_sql.column_value(l_cursor_id,2,l_nir_approval_status_type);
3526: dbms_sql.column_value(l_cursor_id,3,l_change_id);
3527: dbms_sql.column_value(l_cursor_id,4,l_change_notice);
3528: END IF;

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

3521: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
3522:
3523: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN
3524: dbms_sql.column_value(l_cursor_id,1,l_nir_status_type);
3525: dbms_sql.column_value(l_cursor_id,2,l_nir_approval_status_type);
3526: dbms_sql.column_value(l_cursor_id,3,l_change_id);
3527: dbms_sql.column_value(l_cursor_id,4,l_change_notice);
3528: END IF;
3529:

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

3522:
3523: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN
3524: dbms_sql.column_value(l_cursor_id,1,l_nir_status_type);
3525: dbms_sql.column_value(l_cursor_id,2,l_nir_approval_status_type);
3526: dbms_sql.column_value(l_cursor_id,3,l_change_id);
3527: dbms_sql.column_value(l_cursor_id,4,l_change_notice);
3528: END IF;
3529:
3530: OPEN c_get_nir_setup (p_new_item_cat_grp_id);

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

3523: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN
3524: dbms_sql.column_value(l_cursor_id,1,l_nir_status_type);
3525: dbms_sql.column_value(l_cursor_id,2,l_nir_approval_status_type);
3526: dbms_sql.column_value(l_cursor_id,3,l_change_id);
3527: dbms_sql.column_value(l_cursor_id,4,l_change_notice);
3528: END IF;
3529:
3530: OPEN c_get_nir_setup (p_new_item_cat_grp_id);
3531: FETCH c_get_nir_setup INTO l_new_nir_reqd;

Line 3722: dbms_sql.close_cursor(l_cursor_id);

3718: AND organization_id = p_organization_id;
3719: END IF;
3720:
3721: IF l_cursor_id IS NOT NULL THEN
3722: dbms_sql.close_cursor(l_cursor_id);
3723: END IF;
3724:
3725: RETURN (0);
3726:

Line 3730: dbms_sql.close_cursor(l_cursor_id);

3726:
3727: EXCEPTION
3728: WHEN OTHERS THEN
3729: IF l_cursor_id IS NOT NULL THEN
3730: dbms_sql.close_cursor(l_cursor_id);
3731: END IF;
3732: RETURN(SQLCODE);
3733: END mtl_catalog_group_update;
3734:

Line 3828: l_cursor_id := DBMS_SQL.Open_Cursor;

3824: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
3825: AND ORGANIZATION_ID = p_organization_id;
3826:
3827: IF l_cursor_id IS NULL THEN
3828: l_cursor_id := DBMS_SQL.Open_Cursor;
3829: l_dynamic_sql := 'select type_name from eng_change_order_types_vl '||
3830: 'where change_order_type_id = :type_id ';
3831: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3832: DBMS_SQL.define_column(l_cursor_id,1,l_type_name,1000);

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

3827: IF l_cursor_id IS NULL THEN
3828: l_cursor_id := DBMS_SQL.Open_Cursor;
3829: l_dynamic_sql := 'select type_name from eng_change_order_types_vl '||
3830: 'where change_order_type_id = :type_id ';
3831: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3832: DBMS_SQL.define_column(l_cursor_id,1,l_type_name,1000);
3833: END IF;
3834: DBMS_SQL.Bind_Variable(l_cursor_id, 'type_id', l_type_id);
3835: l_dummy := DBMS_SQL.Execute(l_cursor_id);

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

3828: l_cursor_id := DBMS_SQL.Open_Cursor;
3829: l_dynamic_sql := 'select type_name from eng_change_order_types_vl '||
3830: 'where change_order_type_id = :type_id ';
3831: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3832: DBMS_SQL.define_column(l_cursor_id,1,l_type_name,1000);
3833: END IF;
3834: DBMS_SQL.Bind_Variable(l_cursor_id, 'type_id', l_type_id);
3835: l_dummy := DBMS_SQL.Execute(l_cursor_id);
3836: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN

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

3830: 'where change_order_type_id = :type_id ';
3831: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3832: DBMS_SQL.define_column(l_cursor_id,1,l_type_name,1000);
3833: END IF;
3834: DBMS_SQL.Bind_Variable(l_cursor_id, 'type_id', l_type_id);
3835: l_dummy := DBMS_SQL.Execute(l_cursor_id);
3836: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN
3837: dbms_sql.column_value(l_cursor_id,1,l_type_name);
3838: EXECUTE IMMEDIATE

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

3831: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
3832: DBMS_SQL.define_column(l_cursor_id,1,l_type_name,1000);
3833: END IF;
3834: DBMS_SQL.Bind_Variable(l_cursor_id, 'type_id', l_type_id);
3835: l_dummy := DBMS_SQL.Execute(l_cursor_id);
3836: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN
3837: dbms_sql.column_value(l_cursor_id,1,l_type_name);
3838: EXECUTE IMMEDIATE
3839: ' BEGIN '

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

3832: DBMS_SQL.define_column(l_cursor_id,1,l_type_name,1000);
3833: END IF;
3834: DBMS_SQL.Bind_Variable(l_cursor_id, 'type_id', l_type_id);
3835: l_dummy := DBMS_SQL.Execute(l_cursor_id);
3836: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN
3837: dbms_sql.column_value(l_cursor_id,1,l_type_name);
3838: EXECUTE IMMEDIATE
3839: ' BEGIN '
3840: ||' ENG_NEW_ITEM_REQ_UTIL.Create_New_Item_Request( '

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

3833: END IF;
3834: DBMS_SQL.Bind_Variable(l_cursor_id, 'type_id', l_type_id);
3835: l_dummy := DBMS_SQL.Execute(l_cursor_id);
3836: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN
3837: dbms_sql.column_value(l_cursor_id,1,l_type_name);
3838: EXECUTE IMMEDIATE
3839: ' BEGIN '
3840: ||' ENG_NEW_ITEM_REQ_UTIL.Create_New_Item_Request( '
3841: ||' change_number => :p_item_number '

Line 3861: dbms_sql.close_cursor(l_cursor_id);

3857: l_return_status := FND_API.G_RET_STS_ERROR;
3858: END IF;
3859: x_return_status := l_return_status;
3860: IF l_cursor_id IS NOT NULL THEN
3861: dbms_sql.close_cursor(l_cursor_id);
3862: END IF;
3863: EXCEPTION
3864: WHEN others THEN
3865: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3867: dbms_sql.close_cursor(l_cursor_id);

3863: EXCEPTION
3864: WHEN others THEN
3865: x_return_status := FND_API.G_RET_STS_ERROR;
3866: IF l_cursor_id IS NOT NULL THEN
3867: dbms_sql.close_cursor(l_cursor_id);
3868: END IF;
3869: INVPUTLI.info('INV_EGO_REVISION_VALIDATE.Create_New_Item_Request: Exception'||substr(SQLERRM,1,200));
3870: END Create_New_Item_Req_Upd; */
3871: -- End : 5258295