APPS.PJI_PJ_PROJ_CLASS_EXTR dependencies on PJI_CLASS_CATEGORIES

Line 23: -- PJI_CLASS_CODES and PJI_CLASS_CATEGORIES. Data extraction is

19:
20: -- This is a private procedure.
21: --
22: -- Procedure updates project classification dimension tables
23: -- PJI_CLASS_CODES and PJI_CLASS_CATEGORIES. Data extraction is
24: -- always incremental.
25: --
26: -- Procedure runs unconditionally, i.e. without a call to
27: -- PJI_PROCESS_UTIL.NEED_TO_RUN_STEP. First of all, data extraction

Line 40: LOCK TABLE pji_class_categories IN EXCLUSIVE MODE;

36: -- below.
37:
38: Pji_Utils.write2log('Entering PJI_PJ_PROJ_CLASS_EXTR.EXTR_CLASS_CODES_PVT',TRUE,2);
39:
40: LOCK TABLE pji_class_categories IN EXCLUSIVE MODE;
41:
42: Pji_Utils.write2log('Locked table PJI_CLASS_CATEGORIES in exclusive mode',TRUE,2);
43:
44: select USERENV('LANG') into l_current_run_lang from dual ;

Line 42: Pji_Utils.write2log('Locked table PJI_CLASS_CATEGORIES in exclusive mode',TRUE,2);

38: Pji_Utils.write2log('Entering PJI_PJ_PROJ_CLASS_EXTR.EXTR_CLASS_CODES_PVT',TRUE,2);
39:
40: LOCK TABLE pji_class_categories IN EXCLUSIVE MODE;
41:
42: Pji_Utils.write2log('Locked table PJI_CLASS_CATEGORIES in exclusive mode',TRUE,2);
43:
44: select USERENV('LANG') into l_current_run_lang from dual ;
45: l_last_run_lang := PJI_UTILS.GET_PARAMETER('LAST_REQUEST_LANG');
46: if(nvl(l_last_run_lang,'-99') <> nvl(l_current_run_lang,'-99')) then

Line 47: delete from pji_class_categories;

43:
44: select USERENV('LANG') into l_current_run_lang from dual ;
45: l_last_run_lang := PJI_UTILS.GET_PARAMETER('LAST_REQUEST_LANG');
46: if(nvl(l_last_run_lang,'-99') <> nvl(l_current_run_lang,'-99')) then
47: delete from pji_class_categories;
48: PJI_UTILS.SET_PARAMETER('LAST_REQUEST_LANG',l_current_run_lang); -- Bug 4736331 : set the value of LAST_REQUEST_LANG in pji_system_parameters.
49: end if;
50: -- Extract class categories
51:

Line 63: -- project type categories in pji_class_categories. For example, a

59: -- project types.
60: --
61: -- We use value "A" to provide a workaround for a many-to-many
62: -- relationship between project types in pji_class_codes and
63: -- project type categories in pji_class_categories. For example, a
64: -- contract project type belongs to both "Contract Project Types"
65: -- class category and "All Project Types". pji_class_codes will
66: -- store only one relationship with "Contract Project Types". For
67: -- reporting purposes the list of project types for classification

Line 71: insert into PJI_CLASS_CATEGORIES

67: -- reporting purposes the list of project types for classification
68: -- "All Project Types" will be derived by PJI code that parses
69: -- PMV parameters based on record_type column.
70:
71: insert into PJI_CLASS_CATEGORIES
72: (
73: CLASS_CATEGORY,
74: NAME,
75: RECORD_TYPE,

Line 111: PJI_CLASS_CATEGORIES old

107: PJI_LOOKUPS
108: where
109: LOOKUP_TYPE = 'PJI_PROJ_TYPE_CATEGORIES'
110: ) new,
111: PJI_CLASS_CATEGORIES old
112: where
113: new.CLASS_CATEGORY = old.CLASS_CATEGORY (+) and
114: old.CLASS_CATEGORY is null;
115:

Line 117: 'into PJI_CLASS_CATEGORIES',TRUE,2);

113: new.CLASS_CATEGORY = old.CLASS_CATEGORY (+) and
114: old.CLASS_CATEGORY is null;
115:
116: Pji_Utils.write2log('Inserted ' || SQL%ROWCOUNT || ' record(s) ' ||
117: 'into PJI_CLASS_CATEGORIES',TRUE,2);
118:
119: -- Extract class codes
120:
121: INSERT INTO pji_class_codes

Line 156: FROM pji_class_categories

152: WHERE
153: class_category IN
154: (
155: SELECT class_category
156: FROM pji_class_categories
157: WHERE record_type = 'C'
158: )
159: UNION ALL
160: SELECT