APPS.CSTPSMUT dependencies on WIP_PERIOD_BALANCES

Line 4827: UPDATE wip_period_balances wpb

4823: l_stmt_num number;
4824: BEGIN
4825: p_err_num := 0;
4826: l_stmt_num := 10;
4827: UPDATE wip_period_balances wpb
4828: SET ( request_id, program_application_id, program_id,
4829: program_update_date, last_update_date, last_updated_by,
4830: last_update_login, pl_material_out, pl_material_overhead_out,
4831: pl_resource_out, pl_outside_processing_out,

Line 4864: -- 'in wip_period_balances for starting lot from mtl txn acct');

4860: WHERE transaction_id = p_sl_mtl_txn_id);
4861:
4862: l_rows_inserted := SQL%ROWCOUNT;
4863: -- dbms_output.put_line(to_char(l_rows_inserted) || 'row(s) updated ' ||
4864: -- 'in wip_period_balances for starting lot from mtl txn acct');
4865: l_rows_inserted := 0;
4866:
4867: l_stmt_num := 20;
4868: UPDATE wip_period_balances wpb

Line 4868: UPDATE wip_period_balances wpb

4864: -- 'in wip_period_balances for starting lot from mtl txn acct');
4865: l_rows_inserted := 0;
4866:
4867: l_stmt_num := 20;
4868: UPDATE wip_period_balances wpb
4869: SET ( request_id, program_application_id, program_id,
4870: program_update_date, last_update_date, last_updated_by,
4871: last_update_login, tl_material_out, tl_material_overhead_out,
4872: tl_resource_out, tl_outside_processing_out,

Line 4905: -- 'in wip_period_balances for starting lot from wip txn acct.');

4901: WHERE transaction_id = p_sl_wip_txn_id);
4902:
4903: l_rows_inserted := SQL%ROWCOUNT;
4904: -- dbms_output.put_line(to_char(l_rows_inserted) || 'row(s) updated ' ||
4905: -- 'in wip_period_balances for starting lot from wip txn acct.');
4906: l_rows_inserted := 0;
4907:
4908: EXCEPTION
4909: when others then

Line 4952: UPDATE wip_period_balances wpb

4948: l_stmt_num := 5;
4949:
4950: l_stmt_num := 10;
4951:
4952: UPDATE wip_period_balances wpb
4953: SET ( request_id, program_application_id, program_id,
4954: program_update_date, last_update_date, last_updated_by,
4955: last_update_login, pl_material_in, pl_material_overhead_in,
4956: pl_resource_in, pl_outside_processing_in,

Line 4990: || 'in wip_period_balances for mtl txn acct.');

4986: l_rows_inserted := SQL%ROWCOUNT;
4987: IF (p_debug = 'Y') and (l_rows_inserted > 0) THEN
4988: FND_FILE.put_line(FND_FILE.LOG,to_char(l_rows_inserted)
4989: || ' row(s) updated '
4990: || 'in wip_period_balances for mtl txn acct.');
4991: END IF;
4992: l_rows_inserted := 0;
4993:
4994: l_stmt_num := 20;

Line 4995: UPDATE wip_period_balances wpb

4991: END IF;
4992: l_rows_inserted := 0;
4993:
4994: l_stmt_num := 20;
4995: UPDATE wip_period_balances wpb
4996: SET ( request_id, program_application_id, program_id,
4997: program_update_date, last_update_date, last_updated_by,
4998: last_update_login,
4999: tl_resource_in, tl_outside_processing_in,

Line 5029: || 'in wip_period_balances for wip txn acct.');

5025:
5026: IF (p_debug = 'Y') and (l_rows_inserted > 0 ) THEN
5027: FND_FILE.put_line(FND_FILE.log,to_char(l_rows_inserted)
5028: || ' row(s) updated '
5029: || 'in wip_period_balances for wip txn acct.');
5030: END IF;
5031: l_rows_inserted := 0;
5032: EXCEPTION
5033: when others then