APPS.MSC_CL_PRE_PROCESS dependencies on MSC_COMPANIES

Line 506: p_my_company msc_companies.company_name%TYPE;

502: END LAUNCH_DELETE_DUPLICATES ;
503:
504: -- =====Local Procedures =========
505: FUNCTION GET_MY_COMPANY return VARCHAR2 IS
506: p_my_company msc_companies.company_name%TYPE;
507: BEGIN
508:
509: /* Get the name of the own Company */
510: /* This name is seeded with company_is = 1 in msc_companies */

Line 510: /* This name is seeded with company_is = 1 in msc_companies */

506: p_my_company msc_companies.company_name%TYPE;
507: BEGIN
508:
509: /* Get the name of the own Company */
510: /* This name is seeded with company_is = 1 in msc_companies */
511: BEGIN
512: select company_name into p_my_company
513: from msc_companies
514: where company_id = 1;

Line 513: from msc_companies

509: /* Get the name of the own Company */
510: /* This name is seeded with company_is = 1 in msc_companies */
511: BEGIN
512: select company_name into p_my_company
513: from msc_companies
514: where company_id = 1;
515: EXCEPTION
516: WHEN OTHERS THEN
517: return 'My Company';

Line 6218: lv_my_company msc_companies.company_name%TYPE;

6214: lv_where_str VARCHAR2(5000);
6215: lv_sql_stmt VARCHAR2(5000);
6216: lv_column_names VARCHAR2(5000); --stores concatenated column names
6217: lv_message_text msc_errors.error_text%TYPE;
6218: lv_my_company msc_companies.company_name%TYPE;
6219: lv_user_id NUMBER;
6220:
6221: TYPE CharTblTyp IS TABLE OF VARCHAR2(240);
6222: TYPE NumTblTyp IS TABLE OF NUMBER;

Line 7220: FROM msc_companies mc

7216:
7217: UPDATE msc_st_trading_partners mscu
7218: SET company_id = -1
7219: WHERE exists( SELECT 1
7220: FROM msc_companies mc
7221: WHERE mc.company_name = nvl(mscu.company_name,lv_my_company)
7222: AND mc.company_id = 1
7223: AND NVL(mc.disable_date,sysdate+1) > sysdate)
7224: AND mscu.process_flag = G_IN_PROCESS

Line 10790: ||' FROM msc_companies mc '

10786: v_sql_stmt := 77;
10787: lv_sql_stmt :=
10788: 'UPDATE msc_st_group_companies msg '
10789: ||' SET company_id = ( SELECT mc.company_id '
10790: ||' FROM msc_companies mc '
10791: ||' WHERE mc.company_name = msg.company_name '
10792: ||' AND NVL(mc.disable_date,sysdate+1) > sysdate) '
10793: ||' WHERE msg.sr_instance_code = :v_instance_code'
10794: ||' AND msg.batch_id = :lv_batch_id'

Line 22085: ||' (select company_id from msc_companies mc'

22081: /*
22082: lv_sql_stmt :=
22083: ' UPDATE MSC_ST_ITEM_SUPPLIERS mic '
22084: ||' SET company_id = '
22085: ||' (select company_id from msc_companies mc'
22086: ||' where mic.company_name = mc.company_name) '
22087: ||' WHERE NVL(COMPANY_NAME,''-1'') <> ''-1'''
22088: ||' AND batch_id = :lv_batch_id'
22089: ||' AND process_flag = '||G_IN_PROCESS

Line 50300: ||' (select company_id from msc_companies mc'

50296: /* Calling derive_company_id
50297: lv_sql_stmt :=
50298: ' UPDATE MSC_ST_ITEM_CUSTOMERS mic '
50299: ||' SET company_id = '
50300: ||' (select company_id from msc_companies mc'
50301: ||' where mic.company_name = mc.company_name) '
50302: ||' WHERE NVL(COMPANY_NAME,''-1'') <> ''-1'''
50303: ||' AND batch_id = :lv_batch_id'
50304: ||' AND process_flag = '||G_IN_PROCESS