APPS.MSD_COLLECT_ORGANIZATIONS dependencies on MSC_TRADING_PARTNERS

Line 38: delete from msc_trading_partners

34: where instance_id = p_instance_id;
35:
36: v_icode := v_icode || ':';
37:
38: delete from msc_trading_partners
39: where sr_instance_id = p_instance_id;
40:
41: v_sql_stmt:=
42: 'insert into MSC_TRADING_PARTNERS'

Line 42: 'insert into MSC_TRADING_PARTNERS'

38: delete from msc_trading_partners
39: where sr_instance_id = p_instance_id;
40:
41: v_sql_stmt:=
42: 'insert into MSC_TRADING_PARTNERS'
43: ||' ( PARTNER_ID,'
44: ||' ORGANIZATION_CODE,'
45: ||' ORGANIZATION_TYPE,'
46: ||' SR_TP_ID,'

Line 60: ||' msc_trading_partners_s.nextval,'

56: ||' LAST_UPDATED_BY,'
57: ||' CREATION_DATE,'
58: ||' CREATED_BY)'
59: ||' select'
60: ||' msc_trading_partners_s.nextval,'
61: ||' :v_icode||x.ORGANIZATION_CODE,'
62: ||' 1,' -- set to discrete as the default value.
63: ||' x.SR_TP_ID,'
64: ||' x.MASTER_ORGANIZATION,'