[Home] [Help]
73: p_wlt_upd_qty_txn IN NUMBER DEFAULT NULL,
74: p_operation_seq_num IN NUMBER DEFAULT NULL,
75: p_intraoperation_step IN NUMBER DEFAULT NULL,
76: -- This PL/SQL table parameter would return the serial numbers added/generated and added..
77: -- We need this information to insert into WSM_SERIAL_TRANSACTIONS
78: x_serial_tbl OUT NOCOPY t_varchar2,
79: x_return_status OUT NOCOPY VARCHAR2,
80: x_error_msg OUT NOCOPY VARCHAR2,
81: x_error_count OUT NOCOPY NUMBER
840: p_wlt_upd_qty_txn IN NUMBER DEFAULT NULL,
841: p_operation_seq_num IN NUMBER DEFAULT NULL,
842: p_intraoperation_step IN NUMBER DEFAULT NULL,
843: -- This PL/SQL table parameter would return the serial numbers added/generated and added..
844: -- We need this information to insert into WSM_SERIAL_TRANSACTIONS
845: x_serial_tbl OUT NOCOPY t_varchar2,
846: x_return_status OUT NOCOPY VARCHAR2,
847: x_error_msg OUT NOCOPY VARCHAR2,
848: x_error_count OUT NOCOPY NUMBER
5519: );
5520:
5521: END fetch_wlt_serials;
5522:
5523: -- Insert records into WSM_SERIAL_TRANSACTIONS for WIP Lot Transactions...
5524: -- This procedure will be called for all wip lot transactions other than split and merge...
5525: Procedure Insert_into_WST ( p_transaction_id IN NUMBER ,
5526: p_transaction_type_id IN NUMBER ,
5527: p_old_wip_entity_name IN VARCHAR2 ,
5573: END IF;
5574:
5575: l_stmt_num := 20;
5576: -- Check for the transaction type...
5577: insert into wsm_serial_transactions
5578: (transaction_id ,
5579: transaction_type_id ,
5580: serial_number ,
5581: gen_object_id ,
6733:
6734: end loop;
6735:
6736: l_stmt_num := 157;
6737: -- Insert all the serial numbers present to the WSM_SERIAL_TRANSACTIONS table...
6738: insert into wsm_serial_transactions
6739: (transaction_id ,
6740: transaction_type_id ,
6741: serial_number ,
6734: end loop;
6735:
6736: l_stmt_num := 157;
6737: -- Insert all the serial numbers present to the WSM_SERIAL_TRANSACTIONS table...
6738: insert into wsm_serial_transactions
6739: (transaction_id ,
6740: transaction_type_id ,
6741: serial_number ,
6742: gen_object_id ,
6834: END IF;
6835:
6836: l_stmt_num := 170;
6837: -- Insert into the WSM table here itself....
6838: insert into wsm_serial_transactions
6839: (transaction_id ,
6840: transaction_type_id ,
6841: serial_number ,
6842: gen_object_id ,
7349:
7350: IF l_serial_tbl.count > 0 THEN
7351: -- Insert the new serial numbers...
7352: forall l_cntr IN l_serial_tbl.first..l_serial_tbl.last
7353: insert into wsm_serial_transactions
7354: (transaction_id ,
7355: transaction_type_id ,
7356: serial_number ,
7357: gen_object_id ,
7397:
7398: -- Insert the old serial numbers...
7399: IF l_serial_num_count > 0 THEN
7400: -- Insert...
7401: insert into wsm_serial_transactions
7402: (transaction_id ,
7403: transaction_type_id ,
7404: serial_number ,
7405: gen_object_id ,
7442: and current_organization_id = p_organization_id
7443: and wip_entity_id = l_wip_entity_id
7444: and nvl(intraoperation_step_type,-1) <> 5
7445: and serial_number NOT IN (select serial_number
7446: from wsm_serial_transactions
7447: where transaction_type_id = 3
7448: and transaction_id = p_txn_id);
7449: END IF;
7450: