[Home] [Help]
1499: from bom_departments
1500: where department_code = wjsi_row.owning_department_code
1501: and organization_id = wjsi_row.organization_id;
1502: elsif(wjsi_row.owning_department is null and wjsi_row.owning_department_code is null) then
1503: wip_eamworkorder_pvt.get_eam_owning_dept_default(p_api_version => 1.0,
1504: p_init_msg_list => null,
1505: p_commit => null,
1506: p_validation_level => null,
1507: p_primary_item_id => wjsi_row.primary_item_id,
1537: wjsi_row.notification_required is not null) then
1538: wip_jsi_utils.record_ignored_column_warning('NOTIFICATION_REQUIRED');
1539: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1540: wjsi_row.notification_required is null) then
1541: wip_eamworkorder_pvt.get_eam_notification_default(p_api_version => 1.0,
1542: p_init_msg_list => null,
1543: p_commit => null,
1544: p_validation_level => null,
1545: p_primary_item_id => wjsi_row.primary_item_id,
1573: wjsi_row.shutdown_type is not null) then
1574: wip_jsi_utils.record_ignored_column_warning('SHUTDOWN_TYPE');
1575: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1576: wjsi_row.shutdown_type is null) then
1577: wip_eamworkorder_pvt.get_eam_shutdown_default(p_api_version => 1.0,
1578: p_init_msg_list => null,
1579: p_commit => null,
1580: p_validation_level => null,
1581: p_primary_item_id => wjsi_row.primary_item_id,
1616: wjsi_row.tagout_required is not null) then
1617: wip_jsi_utils.record_ignored_column_warning('TAGOUT_REQUIRED');
1618: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1619: wjsi_row.tagout_required is null) then
1620: wip_eamworkorder_pvt.get_eam_tagout_default(p_api_version => 1.0,
1621: p_init_msg_list => null,
1622: p_commit => null,
1623: p_validation_level => null,
1624: p_primary_item_id => wjsi_row.primary_item_id,
1661: wjsi_row.activity_type is not null) then
1662: wip_jsi_utils.record_ignored_column_warning('ACTIVITY_TYPE');
1663: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1664: wjsi_row.activity_type is null) then
1665: wip_eamworkorder_pvt.get_eam_act_type_default(p_api_version => 1.0,
1666: p_init_msg_list => null,
1667: p_commit => null,
1668: p_validation_level => null,
1669: p_primary_item_id => wjsi_row.primary_item_id,
1697: wjsi_row.activity_cause is not null) then
1698: wip_jsi_utils.record_ignored_column_warning('ACTIVITY_CAUSE');
1699: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1700: wjsi_row.activity_cause is null) then
1701: wip_eamworkorder_pvt.get_eam_act_cause_default(p_api_version => 1.0,
1702: p_init_msg_list => null,
1703: p_commit => null,
1704: p_validation_level => null,
1705: p_primary_item_id => wjsi_row.primary_item_id,
1861: wjsi_row.activity_source is not null) then
1862: wip_jsi_utils.record_ignored_column_warning('ACTIVITY_SOURCE');
1863: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1864: wjsi_row.activity_source is null) then
1865: wip_eamworkorder_pvt.get_eam_act_source_default(p_api_version => 1.0,
1866: p_init_msg_list => null,
1867: p_commit => null,
1868: p_validation_level => null,
1869: p_primary_item_id => wjsi_row.primary_item_id,