eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_PROCESS_SIT_SS dependencies on PER_ANALYSIS_CRITERIA

Line 9: ---- Declare a row of pereanalysis_criteria ----------------------------------

5: gv_wf_review_region_item constant wf_item_attributes.name%type
6: := 'HR_REVIEW_REGION_ITEM';
7:
8:
9: ---- Declare a row of pereanalysis_criteria ----------------------------------
10: TYPE per_analysis_criteria_rec IS RECORD(
11: segment1 per_analysis_criteria.segment1%TYPE,
12: segment2 per_analysis_criteria.segment2%TYPE,
13: segment3 per_analysis_criteria.segment3%TYPE,

Line 10: TYPE per_analysis_criteria_rec IS RECORD(

6: := 'HR_REVIEW_REGION_ITEM';
7:
8:
9: ---- Declare a row of pereanalysis_criteria ----------------------------------
10: TYPE per_analysis_criteria_rec IS RECORD(
11: segment1 per_analysis_criteria.segment1%TYPE,
12: segment2 per_analysis_criteria.segment2%TYPE,
13: segment3 per_analysis_criteria.segment3%TYPE,
14: segment4 per_analysis_criteria.segment4%TYPE,

Line 11: segment1 per_analysis_criteria.segment1%TYPE,

7:
8:
9: ---- Declare a row of pereanalysis_criteria ----------------------------------
10: TYPE per_analysis_criteria_rec IS RECORD(
11: segment1 per_analysis_criteria.segment1%TYPE,
12: segment2 per_analysis_criteria.segment2%TYPE,
13: segment3 per_analysis_criteria.segment3%TYPE,
14: segment4 per_analysis_criteria.segment4%TYPE,
15: segment5 per_analysis_criteria.segment5%TYPE,

Line 12: segment2 per_analysis_criteria.segment2%TYPE,

8:
9: ---- Declare a row of pereanalysis_criteria ----------------------------------
10: TYPE per_analysis_criteria_rec IS RECORD(
11: segment1 per_analysis_criteria.segment1%TYPE,
12: segment2 per_analysis_criteria.segment2%TYPE,
13: segment3 per_analysis_criteria.segment3%TYPE,
14: segment4 per_analysis_criteria.segment4%TYPE,
15: segment5 per_analysis_criteria.segment5%TYPE,
16: segment6 per_analysis_criteria.segment6%TYPE,

Line 13: segment3 per_analysis_criteria.segment3%TYPE,

9: ---- Declare a row of pereanalysis_criteria ----------------------------------
10: TYPE per_analysis_criteria_rec IS RECORD(
11: segment1 per_analysis_criteria.segment1%TYPE,
12: segment2 per_analysis_criteria.segment2%TYPE,
13: segment3 per_analysis_criteria.segment3%TYPE,
14: segment4 per_analysis_criteria.segment4%TYPE,
15: segment5 per_analysis_criteria.segment5%TYPE,
16: segment6 per_analysis_criteria.segment6%TYPE,
17: segment7 per_analysis_criteria.segment7%TYPE,

Line 14: segment4 per_analysis_criteria.segment4%TYPE,

10: TYPE per_analysis_criteria_rec IS RECORD(
11: segment1 per_analysis_criteria.segment1%TYPE,
12: segment2 per_analysis_criteria.segment2%TYPE,
13: segment3 per_analysis_criteria.segment3%TYPE,
14: segment4 per_analysis_criteria.segment4%TYPE,
15: segment5 per_analysis_criteria.segment5%TYPE,
16: segment6 per_analysis_criteria.segment6%TYPE,
17: segment7 per_analysis_criteria.segment7%TYPE,
18: segment8 per_analysis_criteria.segment8%TYPE,

Line 15: segment5 per_analysis_criteria.segment5%TYPE,

11: segment1 per_analysis_criteria.segment1%TYPE,
12: segment2 per_analysis_criteria.segment2%TYPE,
13: segment3 per_analysis_criteria.segment3%TYPE,
14: segment4 per_analysis_criteria.segment4%TYPE,
15: segment5 per_analysis_criteria.segment5%TYPE,
16: segment6 per_analysis_criteria.segment6%TYPE,
17: segment7 per_analysis_criteria.segment7%TYPE,
18: segment8 per_analysis_criteria.segment8%TYPE,
19: segment9 per_analysis_criteria.segment9%TYPE,

Line 16: segment6 per_analysis_criteria.segment6%TYPE,

12: segment2 per_analysis_criteria.segment2%TYPE,
13: segment3 per_analysis_criteria.segment3%TYPE,
14: segment4 per_analysis_criteria.segment4%TYPE,
15: segment5 per_analysis_criteria.segment5%TYPE,
16: segment6 per_analysis_criteria.segment6%TYPE,
17: segment7 per_analysis_criteria.segment7%TYPE,
18: segment8 per_analysis_criteria.segment8%TYPE,
19: segment9 per_analysis_criteria.segment9%TYPE,
20: segment10 per_analysis_criteria.segment10%TYPE,

Line 17: segment7 per_analysis_criteria.segment7%TYPE,

13: segment3 per_analysis_criteria.segment3%TYPE,
14: segment4 per_analysis_criteria.segment4%TYPE,
15: segment5 per_analysis_criteria.segment5%TYPE,
16: segment6 per_analysis_criteria.segment6%TYPE,
17: segment7 per_analysis_criteria.segment7%TYPE,
18: segment8 per_analysis_criteria.segment8%TYPE,
19: segment9 per_analysis_criteria.segment9%TYPE,
20: segment10 per_analysis_criteria.segment10%TYPE,
21: segment11 per_analysis_criteria.segment11%TYPE,

Line 18: segment8 per_analysis_criteria.segment8%TYPE,

14: segment4 per_analysis_criteria.segment4%TYPE,
15: segment5 per_analysis_criteria.segment5%TYPE,
16: segment6 per_analysis_criteria.segment6%TYPE,
17: segment7 per_analysis_criteria.segment7%TYPE,
18: segment8 per_analysis_criteria.segment8%TYPE,
19: segment9 per_analysis_criteria.segment9%TYPE,
20: segment10 per_analysis_criteria.segment10%TYPE,
21: segment11 per_analysis_criteria.segment11%TYPE,
22: segment12 per_analysis_criteria.segment12%TYPE,

Line 19: segment9 per_analysis_criteria.segment9%TYPE,

15: segment5 per_analysis_criteria.segment5%TYPE,
16: segment6 per_analysis_criteria.segment6%TYPE,
17: segment7 per_analysis_criteria.segment7%TYPE,
18: segment8 per_analysis_criteria.segment8%TYPE,
19: segment9 per_analysis_criteria.segment9%TYPE,
20: segment10 per_analysis_criteria.segment10%TYPE,
21: segment11 per_analysis_criteria.segment11%TYPE,
22: segment12 per_analysis_criteria.segment12%TYPE,
23: segment13 per_analysis_criteria.segment13%TYPE,

Line 20: segment10 per_analysis_criteria.segment10%TYPE,

16: segment6 per_analysis_criteria.segment6%TYPE,
17: segment7 per_analysis_criteria.segment7%TYPE,
18: segment8 per_analysis_criteria.segment8%TYPE,
19: segment9 per_analysis_criteria.segment9%TYPE,
20: segment10 per_analysis_criteria.segment10%TYPE,
21: segment11 per_analysis_criteria.segment11%TYPE,
22: segment12 per_analysis_criteria.segment12%TYPE,
23: segment13 per_analysis_criteria.segment13%TYPE,
24: segment14 per_analysis_criteria.segment14%TYPE,

Line 21: segment11 per_analysis_criteria.segment11%TYPE,

17: segment7 per_analysis_criteria.segment7%TYPE,
18: segment8 per_analysis_criteria.segment8%TYPE,
19: segment9 per_analysis_criteria.segment9%TYPE,
20: segment10 per_analysis_criteria.segment10%TYPE,
21: segment11 per_analysis_criteria.segment11%TYPE,
22: segment12 per_analysis_criteria.segment12%TYPE,
23: segment13 per_analysis_criteria.segment13%TYPE,
24: segment14 per_analysis_criteria.segment14%TYPE,
25: segment15 per_analysis_criteria.segment15%TYPE,

Line 22: segment12 per_analysis_criteria.segment12%TYPE,

18: segment8 per_analysis_criteria.segment8%TYPE,
19: segment9 per_analysis_criteria.segment9%TYPE,
20: segment10 per_analysis_criteria.segment10%TYPE,
21: segment11 per_analysis_criteria.segment11%TYPE,
22: segment12 per_analysis_criteria.segment12%TYPE,
23: segment13 per_analysis_criteria.segment13%TYPE,
24: segment14 per_analysis_criteria.segment14%TYPE,
25: segment15 per_analysis_criteria.segment15%TYPE,
26: segment16 per_analysis_criteria.segment16%TYPE,

Line 23: segment13 per_analysis_criteria.segment13%TYPE,

19: segment9 per_analysis_criteria.segment9%TYPE,
20: segment10 per_analysis_criteria.segment10%TYPE,
21: segment11 per_analysis_criteria.segment11%TYPE,
22: segment12 per_analysis_criteria.segment12%TYPE,
23: segment13 per_analysis_criteria.segment13%TYPE,
24: segment14 per_analysis_criteria.segment14%TYPE,
25: segment15 per_analysis_criteria.segment15%TYPE,
26: segment16 per_analysis_criteria.segment16%TYPE,
27: segment17 per_analysis_criteria.segment17%TYPE,

Line 24: segment14 per_analysis_criteria.segment14%TYPE,

20: segment10 per_analysis_criteria.segment10%TYPE,
21: segment11 per_analysis_criteria.segment11%TYPE,
22: segment12 per_analysis_criteria.segment12%TYPE,
23: segment13 per_analysis_criteria.segment13%TYPE,
24: segment14 per_analysis_criteria.segment14%TYPE,
25: segment15 per_analysis_criteria.segment15%TYPE,
26: segment16 per_analysis_criteria.segment16%TYPE,
27: segment17 per_analysis_criteria.segment17%TYPE,
28: segment18 per_analysis_criteria.segment18%TYPE,

Line 25: segment15 per_analysis_criteria.segment15%TYPE,

21: segment11 per_analysis_criteria.segment11%TYPE,
22: segment12 per_analysis_criteria.segment12%TYPE,
23: segment13 per_analysis_criteria.segment13%TYPE,
24: segment14 per_analysis_criteria.segment14%TYPE,
25: segment15 per_analysis_criteria.segment15%TYPE,
26: segment16 per_analysis_criteria.segment16%TYPE,
27: segment17 per_analysis_criteria.segment17%TYPE,
28: segment18 per_analysis_criteria.segment18%TYPE,
29: segment19 per_analysis_criteria.segment19%TYPE,

Line 26: segment16 per_analysis_criteria.segment16%TYPE,

22: segment12 per_analysis_criteria.segment12%TYPE,
23: segment13 per_analysis_criteria.segment13%TYPE,
24: segment14 per_analysis_criteria.segment14%TYPE,
25: segment15 per_analysis_criteria.segment15%TYPE,
26: segment16 per_analysis_criteria.segment16%TYPE,
27: segment17 per_analysis_criteria.segment17%TYPE,
28: segment18 per_analysis_criteria.segment18%TYPE,
29: segment19 per_analysis_criteria.segment19%TYPE,
30: segment20 per_analysis_criteria.segment20%TYPE,

Line 27: segment17 per_analysis_criteria.segment17%TYPE,

23: segment13 per_analysis_criteria.segment13%TYPE,
24: segment14 per_analysis_criteria.segment14%TYPE,
25: segment15 per_analysis_criteria.segment15%TYPE,
26: segment16 per_analysis_criteria.segment16%TYPE,
27: segment17 per_analysis_criteria.segment17%TYPE,
28: segment18 per_analysis_criteria.segment18%TYPE,
29: segment19 per_analysis_criteria.segment19%TYPE,
30: segment20 per_analysis_criteria.segment20%TYPE,
31: segment21 per_analysis_criteria.segment21%TYPE,

Line 28: segment18 per_analysis_criteria.segment18%TYPE,

24: segment14 per_analysis_criteria.segment14%TYPE,
25: segment15 per_analysis_criteria.segment15%TYPE,
26: segment16 per_analysis_criteria.segment16%TYPE,
27: segment17 per_analysis_criteria.segment17%TYPE,
28: segment18 per_analysis_criteria.segment18%TYPE,
29: segment19 per_analysis_criteria.segment19%TYPE,
30: segment20 per_analysis_criteria.segment20%TYPE,
31: segment21 per_analysis_criteria.segment21%TYPE,
32: segment22 per_analysis_criteria.segment22%TYPE,

Line 29: segment19 per_analysis_criteria.segment19%TYPE,

25: segment15 per_analysis_criteria.segment15%TYPE,
26: segment16 per_analysis_criteria.segment16%TYPE,
27: segment17 per_analysis_criteria.segment17%TYPE,
28: segment18 per_analysis_criteria.segment18%TYPE,
29: segment19 per_analysis_criteria.segment19%TYPE,
30: segment20 per_analysis_criteria.segment20%TYPE,
31: segment21 per_analysis_criteria.segment21%TYPE,
32: segment22 per_analysis_criteria.segment22%TYPE,
33: segment23 per_analysis_criteria.segment23%TYPE,

Line 30: segment20 per_analysis_criteria.segment20%TYPE,

26: segment16 per_analysis_criteria.segment16%TYPE,
27: segment17 per_analysis_criteria.segment17%TYPE,
28: segment18 per_analysis_criteria.segment18%TYPE,
29: segment19 per_analysis_criteria.segment19%TYPE,
30: segment20 per_analysis_criteria.segment20%TYPE,
31: segment21 per_analysis_criteria.segment21%TYPE,
32: segment22 per_analysis_criteria.segment22%TYPE,
33: segment23 per_analysis_criteria.segment23%TYPE,
34: segment24 per_analysis_criteria.segment24%TYPE,

Line 31: segment21 per_analysis_criteria.segment21%TYPE,

27: segment17 per_analysis_criteria.segment17%TYPE,
28: segment18 per_analysis_criteria.segment18%TYPE,
29: segment19 per_analysis_criteria.segment19%TYPE,
30: segment20 per_analysis_criteria.segment20%TYPE,
31: segment21 per_analysis_criteria.segment21%TYPE,
32: segment22 per_analysis_criteria.segment22%TYPE,
33: segment23 per_analysis_criteria.segment23%TYPE,
34: segment24 per_analysis_criteria.segment24%TYPE,
35: segment25 per_analysis_criteria.segment25%TYPE,

Line 32: segment22 per_analysis_criteria.segment22%TYPE,

28: segment18 per_analysis_criteria.segment18%TYPE,
29: segment19 per_analysis_criteria.segment19%TYPE,
30: segment20 per_analysis_criteria.segment20%TYPE,
31: segment21 per_analysis_criteria.segment21%TYPE,
32: segment22 per_analysis_criteria.segment22%TYPE,
33: segment23 per_analysis_criteria.segment23%TYPE,
34: segment24 per_analysis_criteria.segment24%TYPE,
35: segment25 per_analysis_criteria.segment25%TYPE,
36: segment26 per_analysis_criteria.segment26%TYPE,

Line 33: segment23 per_analysis_criteria.segment23%TYPE,

29: segment19 per_analysis_criteria.segment19%TYPE,
30: segment20 per_analysis_criteria.segment20%TYPE,
31: segment21 per_analysis_criteria.segment21%TYPE,
32: segment22 per_analysis_criteria.segment22%TYPE,
33: segment23 per_analysis_criteria.segment23%TYPE,
34: segment24 per_analysis_criteria.segment24%TYPE,
35: segment25 per_analysis_criteria.segment25%TYPE,
36: segment26 per_analysis_criteria.segment26%TYPE,
37: segment27 per_analysis_criteria.segment27%TYPE,

Line 34: segment24 per_analysis_criteria.segment24%TYPE,

30: segment20 per_analysis_criteria.segment20%TYPE,
31: segment21 per_analysis_criteria.segment21%TYPE,
32: segment22 per_analysis_criteria.segment22%TYPE,
33: segment23 per_analysis_criteria.segment23%TYPE,
34: segment24 per_analysis_criteria.segment24%TYPE,
35: segment25 per_analysis_criteria.segment25%TYPE,
36: segment26 per_analysis_criteria.segment26%TYPE,
37: segment27 per_analysis_criteria.segment27%TYPE,
38: segment28 per_analysis_criteria.segment28%TYPE,

Line 35: segment25 per_analysis_criteria.segment25%TYPE,

31: segment21 per_analysis_criteria.segment21%TYPE,
32: segment22 per_analysis_criteria.segment22%TYPE,
33: segment23 per_analysis_criteria.segment23%TYPE,
34: segment24 per_analysis_criteria.segment24%TYPE,
35: segment25 per_analysis_criteria.segment25%TYPE,
36: segment26 per_analysis_criteria.segment26%TYPE,
37: segment27 per_analysis_criteria.segment27%TYPE,
38: segment28 per_analysis_criteria.segment28%TYPE,
39: segment29 per_analysis_criteria.segment29%TYPE,

Line 36: segment26 per_analysis_criteria.segment26%TYPE,

32: segment22 per_analysis_criteria.segment22%TYPE,
33: segment23 per_analysis_criteria.segment23%TYPE,
34: segment24 per_analysis_criteria.segment24%TYPE,
35: segment25 per_analysis_criteria.segment25%TYPE,
36: segment26 per_analysis_criteria.segment26%TYPE,
37: segment27 per_analysis_criteria.segment27%TYPE,
38: segment28 per_analysis_criteria.segment28%TYPE,
39: segment29 per_analysis_criteria.segment29%TYPE,
40: segment30 per_analysis_criteria.segment30%TYPE);

Line 37: segment27 per_analysis_criteria.segment27%TYPE,

33: segment23 per_analysis_criteria.segment23%TYPE,
34: segment24 per_analysis_criteria.segment24%TYPE,
35: segment25 per_analysis_criteria.segment25%TYPE,
36: segment26 per_analysis_criteria.segment26%TYPE,
37: segment27 per_analysis_criteria.segment27%TYPE,
38: segment28 per_analysis_criteria.segment28%TYPE,
39: segment29 per_analysis_criteria.segment29%TYPE,
40: segment30 per_analysis_criteria.segment30%TYPE);
41: --

Line 38: segment28 per_analysis_criteria.segment28%TYPE,

34: segment24 per_analysis_criteria.segment24%TYPE,
35: segment25 per_analysis_criteria.segment25%TYPE,
36: segment26 per_analysis_criteria.segment26%TYPE,
37: segment27 per_analysis_criteria.segment27%TYPE,
38: segment28 per_analysis_criteria.segment28%TYPE,
39: segment29 per_analysis_criteria.segment29%TYPE,
40: segment30 per_analysis_criteria.segment30%TYPE);
41: --
42: -- ----------------------------------------------------------------------------

Line 39: segment29 per_analysis_criteria.segment29%TYPE,

35: segment25 per_analysis_criteria.segment25%TYPE,
36: segment26 per_analysis_criteria.segment26%TYPE,
37: segment27 per_analysis_criteria.segment27%TYPE,
38: segment28 per_analysis_criteria.segment28%TYPE,
39: segment29 per_analysis_criteria.segment29%TYPE,
40: segment30 per_analysis_criteria.segment30%TYPE);
41: --
42: -- ----------------------------------------------------------------------------
43: -- |----------------------------< insert_sit >--------------------------------|

Line 40: segment30 per_analysis_criteria.segment30%TYPE);

36: segment26 per_analysis_criteria.segment26%TYPE,
37: segment27 per_analysis_criteria.segment27%TYPE,
38: segment28 per_analysis_criteria.segment28%TYPE,
39: segment29 per_analysis_criteria.segment29%TYPE,
40: segment30 per_analysis_criteria.segment30%TYPE);
41: --
42: -- ----------------------------------------------------------------------------
43: -- |----------------------------< insert_sit >--------------------------------|
44: -- ----------------------------------------------------------------------------

Line 297: -- not that of PER_ANALYSIS_CRITERIA

293: -- be deleted from the database.
294: -- p_person_analysis_id Y number Person Analysis id.
295: -- p_pea_object_version_number Y number Version number of the SIT
296: -- record on PER_PERSON_ANALYSES
297: -- not that of PER_ANALYSIS_CRITERIA
298: -- Post Success:
299: -- The API deletes the SIT record.
300: --
301: -- Post Failure:

Line 335: -- per_analysis_criteria table and returns as record type.

331: -- Wrapper Package for API hr_process_sit_ss.
332: --
333: -- Description:
334: -- This Function gets the segments info for the given per_anlaysis_criteria_id from
335: -- per_analysis_criteria table and returns as record type.
336: --
337: --
338: -- Prerequisites:
339: -- A person identified by person_id must exist in per_people_f.

Line 348: -- per_analysis_criteria_rec of per_analysis_criteria rec type.

344: -- Name Reqd Type Description
345: -- p_analysis_criteria_id Yes number anlaysis_criteria_id
346: --
347: -- Returns:
348: -- per_analysis_criteria_rec of per_analysis_criteria rec type.
349: -- --------------------------------------------------------------------------
350:
351: FUNCTION get_segments_from_ccid(p_analysis_criteria_id IN NUMBER)
352: RETURN per_analysis_criteria_rec ;

Line 352: RETURN per_analysis_criteria_rec ;

348: -- per_analysis_criteria_rec of per_analysis_criteria rec type.
349: -- --------------------------------------------------------------------------
350:
351: FUNCTION get_segments_from_ccid(p_analysis_criteria_id IN NUMBER)
352: RETURN per_analysis_criteria_rec ;
353: --
354: -- ----------------------------------------------------------------------------
355: -- |-----------------------< get_transaction_data >---------------------------|
356: -- Wrapper Package for API hr_process_sit_ss.