APPS.MSC_WS_SNO_PUBLISH dependencies on MSC_INT_SOURCE1

Line 1930: -- 1. and 2. drop, create, populate 2 temp tables msc_int_source1, msc_int_source2

1926: ) AS
1927: g_ErrorCode VARCHAR2(1000);
1928: BEGIN
1929: /* implementation starts here */
1930: -- 1. and 2. drop, create, populate 2 temp tables msc_int_source1, msc_int_source2
1931: BEGIN
1932: DELETE FROM msc_int_source1; -- where msc_int_ascp_prodcost_kpi.plan_id=PlanIdVar;
1933: EXCEPTION WHEN others THEN
1934: g_ErrorCode := 'ERROR_DELETE_msc_int_source1_001011';

Line 1932: DELETE FROM msc_int_source1; -- where msc_int_ascp_prodcost_kpi.plan_id=PlanIdVar;

1928: BEGIN
1929: /* implementation starts here */
1930: -- 1. and 2. drop, create, populate 2 temp tables msc_int_source1, msc_int_source2
1931: BEGIN
1932: DELETE FROM msc_int_source1; -- where msc_int_ascp_prodcost_kpi.plan_id=PlanIdVar;
1933: EXCEPTION WHEN others THEN
1934: g_ErrorCode := 'ERROR_DELETE_msc_int_source1_001011';
1935: raise;
1936: END;

Line 1934: g_ErrorCode := 'ERROR_DELETE_msc_int_source1_001011';

1930: -- 1. and 2. drop, create, populate 2 temp tables msc_int_source1, msc_int_source2
1931: BEGIN
1932: DELETE FROM msc_int_source1; -- where msc_int_ascp_prodcost_kpi.plan_id=PlanIdVar;
1933: EXCEPTION WHEN others THEN
1934: g_ErrorCode := 'ERROR_DELETE_msc_int_source1_001011';
1935: raise;
1936: END;
1937:
1938: BEGIN

Line 1947: INSERT into msc_int_source1 ( item_code, branch_code )

1943: END;
1944: BEGIN
1945: -- 1. SourceItem
1946:
1947: INSERT into msc_int_source1 ( item_code, branch_code )
1948: SELECT msc_int_src_recommend_detail.item_code,
1949: msc_int_src_recommend_detail.destination_code
1950: FROM msc_int_src_recommend_detail
1951: WHERE msc_int_src_recommend_detail.available = 'Yes';

Line 1953: g_ErrorCode := 'ERROR_INSERT_msc_int_source1_001021';

1949: msc_int_src_recommend_detail.destination_code
1950: FROM msc_int_src_recommend_detail
1951: WHERE msc_int_src_recommend_detail.available = 'Yes';
1952: EXCEPTION WHEN others THEN
1953: g_ErrorCode := 'ERROR_INSERT_msc_int_source1_001021';
1954: raise;
1955: END;
1956:
1957: BEGIN

Line 2040: substr(msc_int_source1.branch_code,instr(msc_int_source1.branch_code,':',1,1)+1),

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
2043: sysdate,
2044: '-1',

Line 2041: substr(msc_int_source1.item_code,1,instr(msc_int_source1.item_code,':',1,1)-1),

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
2043: sysdate,
2044: '-1',
2045: sysdate,

Line 2042: substr(msc_int_source1.item_code,instr(msc_int_source1.item_code,':',1,1)+1), -- CHANGE

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
2043: sysdate,
2044: '-1',
2045: sysdate,
2046: '-1'

Line 2047: FROM msc_int_source1;

2043: sysdate,
2044: '-1',
2045: sysdate,
2046: '-1'
2047: FROM msc_int_source1;
2048: EXCEPTION WHEN others THEN
2049: g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001005';
2050: raise;
2051: END;