2098: if(wjsi_row.load_type = wip_constants.create_job) then
2099: if(wjsi_row.project_id is null) then
2100: select 1
2101: into g_dummy
2102: from dual
2103: where exists(select 1
2104: from cst_cg_wip_acct_classes_v
2105: where class_code = wjsi_row.class_code
2106: and organization_id = wjsi_row.organization_id
2107: and class_type = wip_constants.discrete);
2108: else
2109: select 1
2110: into g_dummy
2111: from dual
2112: where exists(select 1
2113: from cst_cg_wip_acct_classes_v ccwac, mtl_parameters mp
2114: where ccwac.class_code = wjsi_row.class_code
2115: and ccwac.organization_id = wjsi_row.organization_id
2125: end if;
2126: elsif(wjsi_row.load_type = wip_constants.create_ns_job) then
2127: select 1
2128: into g_dummy
2129: from dual
2130: where exists(select 1
2131: from wip_non_standard_classes_val_v
2132: where class_code = wjsi_row.class_code
2133: and organization_id = wjsi_row.organization_id);
2135: elsif(wjsi_row.load_type = wip_constants.create_eam_job) then
2136: if(wjsi_row.project_id is null) then
2137: select 1
2138: into g_dummy
2139: from dual
2140: where exists(select 1
2141: from cst_cg_wip_acct_classes_v
2142: where class_code = wjsi_row.class_code
2143: and organization_id = wjsi_row.organization_id
2144: and class_type = wip_constants.eam);
2145: else
2146: select 1
2147: into g_dummy
2148: from dual
2149: where exists(select 1
2150: from cst_cg_wip_acct_classes_v ccwac, mtl_parameters mp
2151: where ccwac.class_code = wjsi_row.class_code
2152: and ccwac.organization_id = wjsi_row.organization_id