9: begin
10:
11: -- Reset context values to null
12:
13: dbms_session.set_context('MSC', 'COMPANY_ID', null);
14: dbms_session.set_context('MSC', 'COMPANY_NAME', null);
15:
16: -- get the company id
17:
10:
11: -- Reset context values to null
12:
13: dbms_session.set_context('MSC', 'COMPANY_ID', null);
14: dbms_session.set_context('MSC', 'COMPANY_NAME', null);
15:
16: -- get the company id
17:
18: begin
36: end;
37:
38: -- set the context values
39:
40: dbms_session.set_context('MSC', 'COMPANY_ID', to_char(v_company_id));
41: dbms_session.set_context('MSC', 'COMPANY_NAME', v_company_name);
42:
43:
44: end set_context;
37:
38: -- set the context values
39:
40: dbms_session.set_context('MSC', 'COMPANY_ID', to_char(v_company_id));
41: dbms_session.set_context('MSC', 'COMPANY_NAME', v_company_name);
42:
43:
44: end set_context;
45: