APPS.MSD_CL_PRE_PROCESS dependencies on MSC_COMPANIES

Line 60: p_my_company msc_companies.company_name%TYPE;

56: | DESCRIPTION : This function returns OEM's company name |
57: +==========================================================================*/
58:
59: FUNCTION GET_MY_COMPANY return VARCHAR2 IS
60: p_my_company msc_companies.company_name%TYPE;
61: BEGIN
62:
63: /* Get the name of the own Company */
64: /* This name is seeded with company_is = 1 in msc_companies */

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

60: p_my_company msc_companies.company_name%TYPE;
61: BEGIN
62:
63: /* Get the name of the own Company */
64: /* This name is seeded with company_is = 1 in msc_companies */
65: BEGIN
66: select company_name into p_my_company
67: from msc_companies
68: where company_id = 1;

Line 67: from msc_companies

63: /* Get the name of the own Company */
64: /* This name is seeded with company_is = 1 in msc_companies */
65: BEGIN
66: select company_name into p_my_company
67: from msc_companies
68: where company_id = 1;
69: EXCEPTION
70: WHEN OTHERS THEN
71: return 'My Company';

Line 2110: lv_my_company msc_companies.company_name%TYPE := GET_MY_COMPANY;

2106: /* lb_rowid1 RowidTab; Bug3749959 */
2107: lv_sql_stmt VARCHAR2(4000);
2108: lv_batch_id msd_st_booking_data.batch_id%TYPE;
2109: lv_message_text msc_errors.error_text%TYPE;
2110: lv_my_company msc_companies.company_name%TYPE := GET_MY_COMPANY;
2111: lv_error_text VARCHAR2(250);
2112: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;
2113: lv_batch_size NUMBER := msc_cl_pre_process.v_batch_size;
2114: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;

Line 2999: lv_my_company msc_companies.company_name%TYPE := GET_MY_COMPANY;

2995: /* lb_rowid1 RowidTab; Bug3749959 */
2996: lv_sql_stmt VARCHAR2(4000);
2997: lv_batch_id msd_st_shipment_data.batch_id%TYPE;
2998: lv_message_text msc_errors.error_text%TYPE;
2999: lv_my_company msc_companies.company_name%TYPE := GET_MY_COMPANY;
3000: lv_error_text VARCHAR2(250);
3001: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;
3002: lv_batch_size NUMBER := msc_cl_pre_process.v_batch_size;
3003: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;

Line 3886: lv_my_company msc_companies.company_name%TYPE := GET_MY_COMPANY;

3882: lb_rowid RowidTab;
3883: /* lb_rowid1 RowidTab; Bug3749959 */
3884: lv_sql_stmt VARCHAR2(4000);
3885: lv_batch_id msd_st_mfg_forecast.batch_id%TYPE;
3886: lv_my_company msc_companies.company_name%TYPE := GET_MY_COMPANY;
3887: lv_message_text msc_errors.error_text%TYPE;
3888: lv_error_text VARCHAR2(250);
3889: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;
3890: lv_batch_size NUMBER := msc_cl_pre_process.v_batch_size;

Line 5881: lv_my_company msc_companies.company_name%TYPE := GET_MY_COMPANY;

5877: lb_rowid RowidTab;
5878: lv_sql_stmt VARCHAR2(4000);
5879: lv_batch_id msd_st_cs_data.batch_id%TYPE;
5880: lv_message_text msc_errors.error_text%TYPE;
5881: lv_my_company msc_companies.company_name%TYPE := GET_MY_COMPANY;
5882: lv_error_text VARCHAR2(250);
5883: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;
5884: lv_batch_size NUMBER := msc_cl_pre_process.v_batch_size;
5885: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;

Line 6799: lv_my_company msc_companies.company_name%TYPE := GET_MY_COMPANY;

6795: lb_rowid RowidTab;
6796: lv_sql_stmt VARCHAR2(4000);
6797: lv_batch_id msd_st_price_list.batch_id%TYPE;
6798: lv_message_text msc_errors.error_text%TYPE;
6799: lv_my_company msc_companies.company_name%TYPE := GET_MY_COMPANY;
6800: lv_error_text VARCHAR2(250);
6801: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;
6802: lv_batch_size NUMBER := msc_cl_pre_process.v_batch_size;
6803: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;