APPS.MSC_WS_SNO_PUBLISH dependencies on MSC_SOURCING_RULES

Line 1995: -- 5. clear msc_sourcing_rules

1991: EXCEPTION WHEN others THEN
1992: g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001002';
1993: NULL;
1994: END;
1995: -- 5. clear msc_sourcing_rules
1996: BEGIN
1997: DELETE from MSC_SOURCING_RULES
1998: WHERE
1999: MSC_SOURCING_RULES.SOURCING_RULE_ID in

Line 1997: DELETE from MSC_SOURCING_RULES

1993: NULL;
1994: END;
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 );

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

Line 2052: -- 8. INSERT into MSC_SOURCING_RULES

2048: EXCEPTION WHEN others THEN
2049: g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001005';
2050: raise;
2051: END;
2052: -- 8. INSERT into MSC_SOURCING_RULES
2053:
2054: BEGIN
2055: INSERT into MSC_SOURCING_RULES (
2056: SOURCING_RULE_ID,

Line 2055: INSERT into MSC_SOURCING_RULES (

2051: END;
2052: -- 8. INSERT into MSC_SOURCING_RULES
2053:
2054: BEGIN
2055: INSERT into MSC_SOURCING_RULES (
2056: SOURCING_RULE_ID,
2057: SR_SOURCING_RULE_ID,
2058: SR_INSTANCE_ID,
2059: ORGANIZATION_ID,