APPS.WIP_MOVPROC_PRIV dependencies on WIP_MOVE_TRANSACTIONS

Line 2891: * WIP_MOVE_TRANSACTIONS.

2887:
2888: /*****************************************************************************
2889: * This procedure is equivalent to witpsth_txn_history in wiltps5.ppc
2890: * This procedure is used to insert history move records into
2891: * WIP_MOVE_TRANSACTIONS.
2892: ****************************************************************************/
2893: PROCEDURE insert_txn_history(p_gib IN group_rec_t,
2894: x_returnStatus OUT NOCOPY VARCHAR2) IS
2895:

Line 2965: -- insert history move record into WIP_MOVE_TRANSACTIONS

2961: wip_logger.log(p_msg => l_msg,
2962: x_returnStatus => l_returnStatus);
2963: END IF;
2964:
2965: -- insert history move record into WIP_MOVE_TRANSACTIONS
2966: -- Discrete/OSFM
2967: INSERT INTO wip_move_transactions
2968: (transaction_id,
2969: last_updated_by,

Line 2967: INSERT INTO wip_move_transactions

2963: END IF;
2964:
2965: -- insert history move record into WIP_MOVE_TRANSACTIONS
2966: -- Discrete/OSFM
2967: INSERT INTO wip_move_transactions
2968: (transaction_id,
2969: last_updated_by,
2970: last_update_date,
2971: last_update_login,

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

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

Line 3109: INSERT INTO wip_move_transactions

3105: x_returnStatus => l_returnStatus);
3106: END IF;
3107:
3108: -- Repetitive Schedule
3109: INSERT INTO wip_move_transactions
3110: (transaction_id,
3111: last_updated_by,
3112: last_update_date,
3113: last_update_login,

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

3228: -- IF debug message level = 2, write statement below to log file
3229: IF (l_logLevel <= wip_constants.full_logging) THEN
3230: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
3231: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
3232: fnd_message.set_token('ENTITY2', 'WIP_MOVE_TRANSACTIONS');
3233: l_msg := fnd_message.get;
3234: wip_logger.log(p_msg => l_msg,
3235: x_returnStatus => l_returnStatus);
3236: END IF;

Line 7017: UPDATE wip_move_transactions

7013: p_primary_uom => l_wmti_txn.pri_uom,
7014: p_op_seq_num => l_wmti_txn.op_seq_num);
7015:
7016: IF l_itemkey IS NOT NULL THEN
7017: UPDATE wip_move_transactions
7018: SET wf_itemtype = 'WIPISHPW',
7019: wf_itemkey = l_itemkey
7020: WHERE transaction_id = l_wmti_txn.txn_id;
7021: END IF;

Line 9692: -- Record move transactions history in WIP_MOVE_TRANSACTIONS

9688: l_errMsg := 'wip_movProc_priv.update_wro failed';
9689: raise fnd_api.g_exc_unexpected_error;
9690: END IF; -- check return status
9691:
9692: -- Record move transactions history in WIP_MOVE_TRANSACTIONS
9693: insert_txn_history(p_gib => p_gib,
9694: x_returnStatus => x_returnStatus);
9695:
9696: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN

Line 11335: FROM wip_move_transactions wmt

11331: CURSOR c_move_records IS
11332: SELECT wmt.wip_entity_id wip_id,
11333: wmt.fm_operation_seq_num fm_op,
11334: wmt.to_operation_seq_num to_op
11335: FROM wip_move_transactions wmt
11336: WHERE wmt.transaction_id = p_group_id;
11337:
11338: l_log_level NUMBER := fnd_log.g_current_runtime_level;
11339: l_error_msg VARCHAR2(1000);