[Home] [Help]
1475: from bom_departments
1476: where department_code = wjsi_row.owning_department_code
1477: and organization_id = wjsi_row.organization_id;
1478: elsif(wjsi_row.owning_department is null and wjsi_row.owning_department_code is null) then
1479: wip_eamworkorder_pvt.get_eam_owning_dept_default(p_api_version => 1.0,
1480: p_init_msg_list => null,
1481: p_commit => null,
1482: p_validation_level => null,
1483: p_primary_item_id => wjsi_row.primary_item_id,
1513: wjsi_row.notification_required is not null) then
1514: wip_jsi_utils.record_ignored_column_warning('NOTIFICATION_REQUIRED');
1515: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1516: wjsi_row.notification_required is null) then
1517: wip_eamworkorder_pvt.get_eam_notification_default(p_api_version => 1.0,
1518: p_init_msg_list => null,
1519: p_commit => null,
1520: p_validation_level => null,
1521: p_primary_item_id => wjsi_row.primary_item_id,
1549: wjsi_row.shutdown_type is not null) then
1550: wip_jsi_utils.record_ignored_column_warning('SHUTDOWN_TYPE');
1551: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1552: wjsi_row.shutdown_type is null) then
1553: wip_eamworkorder_pvt.get_eam_shutdown_default(p_api_version => 1.0,
1554: p_init_msg_list => null,
1555: p_commit => null,
1556: p_validation_level => null,
1557: p_primary_item_id => wjsi_row.primary_item_id,
1592: wjsi_row.tagout_required is not null) then
1593: wip_jsi_utils.record_ignored_column_warning('TAGOUT_REQUIRED');
1594: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1595: wjsi_row.tagout_required is null) then
1596: wip_eamworkorder_pvt.get_eam_tagout_default(p_api_version => 1.0,
1597: p_init_msg_list => null,
1598: p_commit => null,
1599: p_validation_level => null,
1600: p_primary_item_id => wjsi_row.primary_item_id,
1637: wjsi_row.activity_type is not null) then
1638: wip_jsi_utils.record_ignored_column_warning('ACTIVITY_TYPE');
1639: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1640: wjsi_row.activity_type is null) then
1641: wip_eamworkorder_pvt.get_eam_act_type_default(p_api_version => 1.0,
1642: p_init_msg_list => null,
1643: p_commit => null,
1644: p_validation_level => null,
1645: p_primary_item_id => wjsi_row.primary_item_id,
1673: wjsi_row.activity_cause is not null) then
1674: wip_jsi_utils.record_ignored_column_warning('ACTIVITY_CAUSE');
1675: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1676: wjsi_row.activity_cause is null) then
1677: wip_eamworkorder_pvt.get_eam_act_cause_default(p_api_version => 1.0,
1678: p_init_msg_list => null,
1679: p_commit => null,
1680: p_validation_level => null,
1681: p_primary_item_id => wjsi_row.primary_item_id,
1837: wjsi_row.activity_source is not null) then
1838: wip_jsi_utils.record_ignored_column_warning('ACTIVITY_SOURCE');
1839: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1840: wjsi_row.activity_source is null) then
1841: wip_eamworkorder_pvt.get_eam_act_source_default(p_api_version => 1.0,
1842: p_init_msg_list => null,
1843: p_commit => null,
1844: p_validation_level => null,
1845: p_primary_item_id => wjsi_row.primary_item_id,