DBA Data[Home] [Help]

APPS.CST_PL_IMPORT dependencies on CST_ITEM_CST_DTLS_INTERFACE

Line 221: from CST_ITEM_CST_DTLS_INTERFACE CICDI

217: AND FCR.argument14 = l_req_groupid;
218:
219: l_base_count := 0;
220: select count(*) into l_base_count
221: from CST_ITEM_CST_DTLS_INTERFACE CICDI
222: where CICDI.group_id = l_req_groupid;
223:
224: If ((NVL(l_min_reqid,FND_GLOBAL.CONC_REQUEST_ID) <> FND_GLOBAL.CONC_REQUEST_ID)OR (l_base_count <> 0)) then
225: fnd_file.put_line(fnd_file.log,fnd_message.get_string('BOM','CST_REQ_ERROR'));

Line 445: Insert into CST_ITEM_CST_DTLS_INTERFACE (

441: Fetch GET_ITEM_COST into l_item_cost,
442: l_item ;
443:
444: Exit when GET_ITEM_COST%NOTFOUND;
445: Insert into CST_ITEM_CST_DTLS_INTERFACE (
446: Inventory_item_ID ,
447: Organization_id ,
448: Last_update_date ,
449: Last_updated_by ,

Line 504: from CST_ITEM_CST_DTLS_INTERFACE

500: COMMIT ;
501:
502: l_stmt_num := 80 ;
503: select count(*) into l_num_rows
504: from CST_ITEM_CST_DTLS_INTERFACE
505: where group_id = p_group_id ;
506:
507: FND_FILE.put_line(fnd_file.log,
508: 'Sucessfully inserted ' || to_char(l_num_rows)|| ' rows into CST_ITEM_CST_DTLS_INTERFACE table');

Line 508: 'Sucessfully inserted ' || to_char(l_num_rows)|| ' rows into CST_ITEM_CST_DTLS_INTERFACE table');

504: from CST_ITEM_CST_DTLS_INTERFACE
505: where group_id = p_group_id ;
506:
507: FND_FILE.put_line(fnd_file.log,
508: 'Sucessfully inserted ' || to_char(l_num_rows)|| ' rows into CST_ITEM_CST_DTLS_INTERFACE table');
509:
510: EXCEPTION
511: When Others then
512: rollback ;