APPS.MSC_WS_SNO_PUBLISH dependencies on MSC_SOURCING_RULES_S

Line 1999: MSC_SOURCING_RULES.SOURCING_RULE_ID in

1995: -- 5. clear msc_sourcing_rules
1996: BEGIN
1997: DELETE from MSC_SOURCING_RULES
1998: WHERE
1999: MSC_SOURCING_RULES.SOURCING_RULE_ID in
2000: ( select MSC_SR_ASSIGNMENTS.SOURCING_RULE_ID from MSC_SR_ASSIGNMENTS
2001: where MSC_SR_ASSIGNMENTS.ASSIGNMENT_SET_ID = assignmentSetOutIdVar );
2002: EXCEPTION WHEN others THEN
2003: g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001003';

Line 2038: MSC_SOURCING_RULES_S.NEXTVAL, -- //Cache these because we cannot look them up by name

2034: -1 * MSC_SR_ASSIGNMENTS_S.NEXTVAL, -- Part of unique key. Maybe should use current value.
2035: -1, -- // -1 until we figure out what goes here.
2036: assignmentSetOutIdVar,
2037: 6, -- // 6 is item-org assignment type
2038: MSC_SOURCING_RULES_S.NEXTVAL, -- //Cache these because we cannot look them up by name
2039: 1,
2040: substr(msc_int_source1.branch_code,instr(msc_int_source1.branch_code,':',1,1)+1),
2041: substr(msc_int_source1.item_code,1,instr(msc_int_source1.item_code,':',1,1)-1),
2042: substr(msc_int_source1.item_code,instr(msc_int_source1.item_code,':',1,1)+1), -- CHANGE