APPS.MSC_CL_PRE_PROCESS dependencies on MSC_COMPANIES

Line 514: p_my_company msc_companies.company_name%TYPE;

510: END LAUNCH_DELETE_DUPLICATES ;
511:
512: -- =====Local Procedures =========
513: FUNCTION GET_MY_COMPANY return VARCHAR2 IS
514: p_my_company msc_companies.company_name%TYPE;
515: BEGIN
516:
517: /* Get the name of the own Company */
518: /* This name is seeded with company_is = 1 in msc_companies */

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

514: p_my_company msc_companies.company_name%TYPE;
515: BEGIN
516:
517: /* Get the name of the own Company */
518: /* This name is seeded with company_is = 1 in msc_companies */
519: BEGIN
520: select company_name into p_my_company
521: from msc_companies
522: where company_id = 1;

Line 521: from msc_companies

517: /* Get the name of the own Company */
518: /* This name is seeded with company_is = 1 in msc_companies */
519: BEGIN
520: select company_name into p_my_company
521: from msc_companies
522: where company_id = 1;
523: EXCEPTION
524: WHEN OTHERS THEN
525: return 'My Company';

Line 6225: lv_my_company msc_companies.company_name%TYPE;

6221: lv_where_str VARCHAR2(5000);
6222: lv_sql_stmt VARCHAR2(5000);
6223: lv_column_names VARCHAR2(5000); --stores concatenated column names
6224: lv_message_text msc_errors.error_text%TYPE;
6225: lv_my_company msc_companies.company_name%TYPE;
6226: lv_user_id NUMBER;
6227:
6228: TYPE CharTblTyp IS TABLE OF VARCHAR2(240);
6229: TYPE NumTblTyp IS TABLE OF NUMBER;

Line 7240: FROM msc_companies mc

7236:
7237: UPDATE msc_st_trading_partners mscu
7238: SET company_id = -1
7239: WHERE exists( SELECT 1
7240: FROM msc_companies mc
7241: WHERE mc.company_name = nvl(mscu.company_name,lv_my_company)
7242: AND mc.company_id = 1
7243: AND NVL(mc.disable_date,sysdate+1) > sysdate)
7244: AND mscu.process_flag = G_IN_PROCESS

Line 10916: ||' FROM msc_companies mc '

10912: v_sql_stmt := 77;
10913: lv_sql_stmt :=
10914: 'UPDATE msc_st_group_companies msg '
10915: ||' SET company_id = ( SELECT mc.company_id '
10916: ||' FROM msc_companies mc '
10917: ||' WHERE mc.company_name = msg.company_name '
10918: ||' AND NVL(mc.disable_date,sysdate+1) > sysdate) '
10919: ||' WHERE msg.sr_instance_code = :v_instance_code'
10920: ||' AND msg.batch_id = :lv_batch_id'

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

25570: /*
25571: lv_sql_stmt :=
25572: ' UPDATE MSC_ST_ITEM_SUPPLIERS mic '
25573: ||' SET company_id = '
25574: ||' (select company_id from msc_companies mc'
25575: ||' where mic.company_name = mc.company_name) '
25576: ||' WHERE NVL(COMPANY_NAME,''-1'') <> ''-1'''
25577: ||' AND batch_id = :lv_batch_id'
25578: ||' AND process_flag = '||G_IN_PROCESS

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

55210: /* Calling derive_company_id
55211: lv_sql_stmt :=
55212: ' UPDATE MSC_ST_ITEM_CUSTOMERS mic '
55213: ||' SET company_id = '
55214: ||' (select company_id from msc_companies mc'
55215: ||' where mic.company_name = mc.company_name) '
55216: ||' WHERE NVL(COMPANY_NAME,''-1'') <> ''-1'''
55217: ||' AND batch_id = :lv_batch_id'
55218: ||' AND process_flag = '||G_IN_PROCESS