APPS.CTO_AUTO_PROCURE_PK dependencies on BOM_CTO_ORDER_LINES_TEMP

Line 124: | from oe_order_lines_all into bom_cto_order_lines_temp. Loop

120: |Jul 29 2004 Kaza
121: | Forward ported ct bugs 3590305 and 3599860.Significant changes
122: | to auto_create_purchase_req_cr. Please refer to the bug texts
123: | for details. In short, take a snapshot of eligible order lines
124: | from oe_order_lines_all into bom_cto_order_lines_temp. Loop
125: | thru the temp 1000 records at a time, lock each line
126: | individually, process and commit.
127: |
128: |Oct 26,2004 Kkonada

Line 517: from bom_cto_order_lines_temp

513: --
514: /*
515: cursor eligible_lines_cur is
516: select line_id
517: from bom_cto_order_lines_temp
518: where status = 1
519: order by org_id;*/
520:
521: cursor eligible_lines_cur is

Line 525: from bom_cto_order_lines_temp bcolt, po_requisitions_interface_all pria

521: cursor eligible_lines_cur is
522: select bcolt.line_id line_id,
523: bcolt.org_id org_id,
524: Nvl(Sum(quantity),0) qty
525: from bom_cto_order_lines_temp bcolt, po_requisitions_interface_all pria
526: where bcolt.status = 1
527: and pria.interface_source_line_id(+) = bcolt.line_id
528: and pria.process_flag is null
529: group by bcolt.org_id, bcolt.line_id

Line 691: oe_debug_pub.add('auto_create_pur_req_cr: going to load eligible lines into bom_cto_order_lines_temp ' ,1);

687:
688: savepoint begin_line;
689:
690: IF PG_DEBUG <> 0 THEN
691: oe_debug_pub.add('auto_create_pur_req_cr: going to load eligible lines into bom_cto_order_lines_temp ' ,1);
692: END IF;
693:
694: -- load eligible lines into bcolt
695: load_lines_into_bcolt(p_sales_order_line_id,

Line 1195: update bom_cto_order_lines_temp

1191:
1192: close oe_lines_cur; -- Done processing the line. We will reopen cursor with new line_id.
1193:
1194: begin
1195: update bom_cto_order_lines_temp
1196: set status = 2 -- set status to completed
1197: where line_id = line_id_tab(tab_index).line_id --7559710
1198: and status = 1;
1199: exception

Line 1236: from bom_cto_order_lines_temp bcolt, po_requisitions_interface_all pria

1232: err_line_id number;
1233:
1234: cursor error_lines_cur is
1235: select bcolt.line_id
1236: from bom_cto_order_lines_temp bcolt, po_requisitions_interface_all pria
1237: where bcolt.status = 1
1238: and pria.interface_source_line_id(+) = bcolt.line_id
1239: and pria.process_flag = 'ERROR';
1240: begin

Line 5200: sql_stmt := 'INSERT INTO bom_cto_order_lines_temp (line_id, org_id, status, inventory_item_id)'||

5196: -- rkaza. ireq project. 05/06/2005.
5197: -- Do not select lines that are in INTERNAL_REQ_REQUESTED status.
5198: -- Added it to the where clause along with PO_REQ_REQUESTED clause
5199: drive_mark := 0;
5200: sql_stmt := 'INSERT INTO bom_cto_order_lines_temp (line_id, org_id, status, inventory_item_id)'||
5201: 'select oel.line_id, oel.org_id, 1, 0 '||
5202: 'from oe_order_lines_all oel,'||
5203: ' mtl_system_items msi,'||
5204: ' wf_item_activity_statuses was,'||

Line 5416: update bom_cto_order_lines_temp

5412: BEGIN
5413:
5414: x_return_status := FND_API.G_RET_STS_SUCCESS ;
5415:
5416: update bom_cto_order_lines_temp
5417: set status = p_status
5418: where line_id = p_line_id;
5419:
5420: EXCEPTION