APPS.WIP_MOVPROC_PRIV dependencies on WIP_MOVE_TRANSACTIONS

Line 2762: * WIP_MOVE_TRANSACTIONS.

2758:
2759: /*****************************************************************************
2760: * This procedure is equivalent to witpsth_txn_history in wiltps5.ppc
2761: * This procedure is used to insert history move records into
2762: * WIP_MOVE_TRANSACTIONS.
2763: ****************************************************************************/
2764: PROCEDURE insert_txn_history(p_gib IN group_rec_t,
2765: x_returnStatus OUT NOCOPY VARCHAR2) IS
2766:

Line 2836: -- insert history move record into WIP_MOVE_TRANSACTIONS

2832: wip_logger.log(p_msg => l_msg,
2833: x_returnStatus => l_returnStatus);
2834: END IF;
2835:
2836: -- insert history move record into WIP_MOVE_TRANSACTIONS
2837: -- Discrete/OSFM
2838: INSERT INTO wip_move_transactions
2839: (transaction_id,
2840: last_updated_by,

Line 2838: INSERT INTO wip_move_transactions

2834: END IF;
2835:
2836: -- insert history move record into WIP_MOVE_TRANSACTIONS
2837: -- Discrete/OSFM
2838: INSERT INTO wip_move_transactions
2839: (transaction_id,
2840: last_updated_by,
2841: last_update_date,
2842: last_update_login,

Line 2973: fnd_message.set_token('ENTITY2', 'WIP_MOVE_TRANSACTIONS');

2969: -- IF debug message level = 2, write statement below to log file
2970: IF (l_logLevel <= wip_constants.full_logging) THEN
2971: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
2972: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
2973: fnd_message.set_token('ENTITY2', 'WIP_MOVE_TRANSACTIONS');
2974: l_msg := fnd_message.get;
2975: wip_logger.log(p_msg => l_msg,
2976: x_returnStatus => l_returnStatus);
2977: END IF;

Line 2980: INSERT INTO wip_move_transactions

2976: x_returnStatus => l_returnStatus);
2977: END IF;
2978:
2979: -- Repetitive Schedule
2980: INSERT INTO wip_move_transactions
2981: (transaction_id,
2982: last_updated_by,
2983: last_update_date,
2984: last_update_login,

Line 3103: fnd_message.set_token('ENTITY2', 'WIP_MOVE_TRANSACTIONS');

3099: -- IF debug message level = 2, write statement below to log file
3100: IF (l_logLevel <= wip_constants.full_logging) THEN
3101: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
3102: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
3103: fnd_message.set_token('ENTITY2', 'WIP_MOVE_TRANSACTIONS');
3104: l_msg := fnd_message.get;
3105: wip_logger.log(p_msg => l_msg,
3106: x_returnStatus => l_returnStatus);
3107: END IF;

Line 6856: UPDATE wip_move_transactions

6852: p_primary_uom => l_wmti_txn.pri_uom,
6853: p_op_seq_num => l_wmti_txn.op_seq_num);
6854:
6855: IF l_itemkey IS NOT NULL THEN
6856: UPDATE wip_move_transactions
6857: SET wf_itemtype = 'WIPISHPW',
6858: wf_itemkey = l_itemkey
6859: WHERE transaction_id = l_wmti_txn.txn_id;
6860: END IF;

Line 9419: -- Record move transactions history in WIP_MOVE_TRANSACTIONS

9415: l_errMsg := 'wip_movProc_priv.update_wro failed';
9416: raise fnd_api.g_exc_unexpected_error;
9417: END IF; -- check return status
9418:
9419: -- Record move transactions history in WIP_MOVE_TRANSACTIONS
9420: insert_txn_history(p_gib => p_gib,
9421: x_returnStatus => x_returnStatus);
9422:
9423: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN

Line 10977: FROM wip_move_transactions wmt

10973: CURSOR c_move_records IS
10974: SELECT wmt.wip_entity_id wip_id,
10975: wmt.fm_operation_seq_num fm_op,
10976: wmt.to_operation_seq_num to_op
10977: FROM wip_move_transactions wmt
10978: WHERE wmt.transaction_id = p_group_id;
10979:
10980: l_log_level NUMBER := fnd_log.g_current_runtime_level;
10981: l_error_msg VARCHAR2(1000);