56: p_operation_seq_num,
57: p_resource_seq_num,
58: p_resource_id,
59: p_uom_code,
60: nvl(p_basis_type, WIP_CONSTANTS.PER_LOT),
61: p_activity_id,
62: p_standard_rate_flag,
63: 0, -- usage_rate_or_amount
64: WIP_CONSTANTS.NO, -- scheduled_flag
60: nvl(p_basis_type, WIP_CONSTANTS.PER_LOT),
61: p_activity_id,
62: p_standard_rate_flag,
63: 0, -- usage_rate_or_amount
64: WIP_CONSTANTS.NO, -- scheduled_flag
65: 1, -- assigned_units
66: WIP_CONSTANTS.MANUAL, -- autocharge_type
67: 0, -- applied_resource_units
68: 0, -- applied_resource_value
62: p_standard_rate_flag,
63: 0, -- usage_rate_or_amount
64: WIP_CONSTANTS.NO, -- scheduled_flag
65: 1, -- assigned_units
66: WIP_CONSTANTS.MANUAL, -- autocharge_type
67: 0, -- applied_resource_units
68: 0, -- applied_resource_value
69: p_start_date,
70: p_completion_date);
122: return;
123:
124: exception
125: when OTHERS then
126: wip_constants.get_ora_error(
127: application => 'WIP',
128: proc_name => 'WIP_OPERATION_RESOURCES_PKG.ADD_RESOURCE');
129: fnd_message.raise_error;
130: end add_resource;
196: wcti.operation_seq_num,
197: wcti.resource_seq_num,
198: wcti.resource_id,
199: wcti.primary_uom,
200: nvl(wcti.basis_type, WIP_CONSTANTS.PER_LOT),
201: nvl(wcti.activity_id , br.default_activity_id),
202: wcti.standard_rate_flag,
203: 0, -- usage_rate_or_amount
204: WIP_CONSTANTS.NO, -- scheduled_flag
200: nvl(wcti.basis_type, WIP_CONSTANTS.PER_LOT),
201: nvl(wcti.activity_id , br.default_activity_id),
202: wcti.standard_rate_flag,
203: 0, -- usage_rate_or_amount
204: WIP_CONSTANTS.NO, -- scheduled_flag
205: 1, -- assigned_units
206: WIP_CONSTANTS.MANUAL, -- autocharge_type
207: 0, -- applied_resource_units
208: 0, -- applied_resource_value
202: wcti.standard_rate_flag,
203: 0, -- usage_rate_or_amount
204: WIP_CONSTANTS.NO, -- scheduled_flag
205: 1, -- assigned_units
206: WIP_CONSTANTS.MANUAL, -- autocharge_type
207: 0, -- applied_resource_units
208: 0, -- applied_resource_value
209: wo.first_unit_start_date,
210: wo.last_unit_completion_date,