APPS.WIP_RESOURCE_DEFAULT dependencies on WIP_JOB_DETAILS

Line 99: applied_resource_units = decode(p_substitution_type,WIP_JOB_DETAILS.WIP_ADD,0,applied_resource_units), /*Bug 3499921*/

95:
96: UPDATE WIP_JOB_DTLS_INTERFACE
97: SET scheduled_flag = nvl(scheduled_flag,l_scheduled_flag),
98: assigned_units = nvl(assigned_units,l_assigned_units),
99: applied_resource_units = decode(p_substitution_type,WIP_JOB_DETAILS.WIP_ADD,0,applied_resource_units), /*Bug 3499921*/
100: applied_resource_value = decode(p_substitution_type,WIP_JOB_DETAILS.WIP_ADD,0,applied_resource_value), /*Bug 3499921*/
101: usage_rate_or_amount = decode(usage_rate_or_amount,NULL,NULL,
102: inv_convert.inv_um_convert(0,WIP_CONSTANTS.MAX_DISPLAYED_PRECISION,usage_rate_or_amount,
103: nvl(uom_code,x_uom_code), x_uom_code,

Line 100: applied_resource_value = decode(p_substitution_type,WIP_JOB_DETAILS.WIP_ADD,0,applied_resource_value), /*Bug 3499921*/

96: UPDATE WIP_JOB_DTLS_INTERFACE
97: SET scheduled_flag = nvl(scheduled_flag,l_scheduled_flag),
98: assigned_units = nvl(assigned_units,l_assigned_units),
99: applied_resource_units = decode(p_substitution_type,WIP_JOB_DETAILS.WIP_ADD,0,applied_resource_units), /*Bug 3499921*/
100: applied_resource_value = decode(p_substitution_type,WIP_JOB_DETAILS.WIP_ADD,0,applied_resource_value), /*Bug 3499921*/
101: usage_rate_or_amount = decode(usage_rate_or_amount,NULL,NULL,
102: inv_convert.inv_um_convert(0,WIP_CONSTANTS.MAX_DISPLAYED_PRECISION,usage_rate_or_amount,
103: nvl(uom_code,x_uom_code), x_uom_code,
104: null,null)), /* fix for bug#2367650 +APS*/

Line 108: WIP_JOB_DETAILS.WIP_ADD,

104: null,null)), /* fix for bug#2367650 +APS*/
105: uom_code = x_uom_code,
106: basis_type = nvl(basis_type,x_basis_type),/*Fix for bug 2119945*/
107: activity_id = decode(p_substitution_type,
108: WIP_JOB_DETAILS.WIP_ADD,
109: nvl(activity_id,x_activity_id),
110: activity_id), /*Bug 2683271*/
111: autocharge_type = nvl(autocharge_type,x_autocharge_type), /*Fix for bug 6767640*/
112: standard_rate_flag = nvl(standard_rate_flag,x_standard_rate_flag), /*Fix for bug 6767640*/

Line 118: AND load_type in (WIP_JOB_DETAILS.WIP_RESOURCE,

114: completion_date = nvl(completion_date,x_completion_date)
115: WHERE group_id = p_group_id
116: AND wip_entity_id = p_wip_entity_id
117: AND organization_id = p_organization_id
118: AND load_type in (WIP_JOB_DETAILS.WIP_RESOURCE,
119: WIP_JOB_DETAILS.WIP_SUB_RES)
120: AND substitution_type = p_substitution_type
121: AND operation_seq_num = p_operation_seq_num
122: AND resource_seq_num = p_resource_seq_num

Line 119: WIP_JOB_DETAILS.WIP_SUB_RES)

115: WHERE group_id = p_group_id
116: AND wip_entity_id = p_wip_entity_id
117: AND organization_id = p_organization_id
118: AND load_type in (WIP_JOB_DETAILS.WIP_RESOURCE,
119: WIP_JOB_DETAILS.WIP_SUB_RES)
120: AND substitution_type = p_substitution_type
121: AND operation_seq_num = p_operation_seq_num
122: AND resource_seq_num = p_resource_seq_num
123: AND resource_id_new = p_resource_id_new

Line 125: AND not ( load_type = wip_job_details.wip_resource

121: AND operation_seq_num = p_operation_seq_num
122: AND resource_seq_num = p_resource_seq_num
123: AND resource_id_new = p_resource_id_new
124: -- jy: no need to default if doing res substitution
125: AND not ( load_type = wip_job_details.wip_resource
126: and substitution_type = wip_job_details.wip_change
127: and substitute_group_num is not null
128: and substitute_group_num is not null
129: );

Line 126: and substitution_type = wip_job_details.wip_change

122: AND resource_seq_num = p_resource_seq_num
123: AND resource_id_new = p_resource_id_new
124: -- jy: no need to default if doing res substitution
125: AND not ( load_type = wip_job_details.wip_resource
126: and substitution_type = wip_job_details.wip_change
127: and substitute_group_num is not null
128: and substitute_group_num is not null
129: );
130: