APPS.HR_TEMPLATE_ITEM_CONTEXTS_API dependencies on HR_ITEM_CONTEXTS

Line 28: ,segment1 hr_item_contexts.segment1%TYPE

24: -- Declare cursors and local variables
25: --
26: Type l_rec_type Is Record (
27: context_type hr_template_item_contexts.context_type%TYPE
28: ,segment1 hr_item_contexts.segment1%TYPE
29: ,segment2 hr_item_contexts.segment2%TYPE
30: ,segment3 hr_item_contexts.segment3%TYPE
31: ,segment4 hr_item_contexts.segment4%TYPE
32: ,segment5 hr_item_contexts.segment5%TYPE

Line 29: ,segment2 hr_item_contexts.segment2%TYPE

25: --
26: Type l_rec_type Is Record (
27: context_type hr_template_item_contexts.context_type%TYPE
28: ,segment1 hr_item_contexts.segment1%TYPE
29: ,segment2 hr_item_contexts.segment2%TYPE
30: ,segment3 hr_item_contexts.segment3%TYPE
31: ,segment4 hr_item_contexts.segment4%TYPE
32: ,segment5 hr_item_contexts.segment5%TYPE
33: ,segment6 hr_item_contexts.segment6%TYPE

Line 30: ,segment3 hr_item_contexts.segment3%TYPE

26: Type l_rec_type Is Record (
27: context_type hr_template_item_contexts.context_type%TYPE
28: ,segment1 hr_item_contexts.segment1%TYPE
29: ,segment2 hr_item_contexts.segment2%TYPE
30: ,segment3 hr_item_contexts.segment3%TYPE
31: ,segment4 hr_item_contexts.segment4%TYPE
32: ,segment5 hr_item_contexts.segment5%TYPE
33: ,segment6 hr_item_contexts.segment6%TYPE
34: ,segment7 hr_item_contexts.segment7%TYPE

Line 31: ,segment4 hr_item_contexts.segment4%TYPE

27: context_type hr_template_item_contexts.context_type%TYPE
28: ,segment1 hr_item_contexts.segment1%TYPE
29: ,segment2 hr_item_contexts.segment2%TYPE
30: ,segment3 hr_item_contexts.segment3%TYPE
31: ,segment4 hr_item_contexts.segment4%TYPE
32: ,segment5 hr_item_contexts.segment5%TYPE
33: ,segment6 hr_item_contexts.segment6%TYPE
34: ,segment7 hr_item_contexts.segment7%TYPE
35: ,segment8 hr_item_contexts.segment8%TYPE

Line 32: ,segment5 hr_item_contexts.segment5%TYPE

28: ,segment1 hr_item_contexts.segment1%TYPE
29: ,segment2 hr_item_contexts.segment2%TYPE
30: ,segment3 hr_item_contexts.segment3%TYPE
31: ,segment4 hr_item_contexts.segment4%TYPE
32: ,segment5 hr_item_contexts.segment5%TYPE
33: ,segment6 hr_item_contexts.segment6%TYPE
34: ,segment7 hr_item_contexts.segment7%TYPE
35: ,segment8 hr_item_contexts.segment8%TYPE
36: ,segment9 hr_item_contexts.segment9%TYPE

Line 33: ,segment6 hr_item_contexts.segment6%TYPE

29: ,segment2 hr_item_contexts.segment2%TYPE
30: ,segment3 hr_item_contexts.segment3%TYPE
31: ,segment4 hr_item_contexts.segment4%TYPE
32: ,segment5 hr_item_contexts.segment5%TYPE
33: ,segment6 hr_item_contexts.segment6%TYPE
34: ,segment7 hr_item_contexts.segment7%TYPE
35: ,segment8 hr_item_contexts.segment8%TYPE
36: ,segment9 hr_item_contexts.segment9%TYPE
37: ,segment10 hr_item_contexts.segment10%TYPE

Line 34: ,segment7 hr_item_contexts.segment7%TYPE

30: ,segment3 hr_item_contexts.segment3%TYPE
31: ,segment4 hr_item_contexts.segment4%TYPE
32: ,segment5 hr_item_contexts.segment5%TYPE
33: ,segment6 hr_item_contexts.segment6%TYPE
34: ,segment7 hr_item_contexts.segment7%TYPE
35: ,segment8 hr_item_contexts.segment8%TYPE
36: ,segment9 hr_item_contexts.segment9%TYPE
37: ,segment10 hr_item_contexts.segment10%TYPE
38: ,segment11 hr_item_contexts.segment11%TYPE

Line 35: ,segment8 hr_item_contexts.segment8%TYPE

31: ,segment4 hr_item_contexts.segment4%TYPE
32: ,segment5 hr_item_contexts.segment5%TYPE
33: ,segment6 hr_item_contexts.segment6%TYPE
34: ,segment7 hr_item_contexts.segment7%TYPE
35: ,segment8 hr_item_contexts.segment8%TYPE
36: ,segment9 hr_item_contexts.segment9%TYPE
37: ,segment10 hr_item_contexts.segment10%TYPE
38: ,segment11 hr_item_contexts.segment11%TYPE
39: ,segment12 hr_item_contexts.segment12%TYPE

Line 36: ,segment9 hr_item_contexts.segment9%TYPE

32: ,segment5 hr_item_contexts.segment5%TYPE
33: ,segment6 hr_item_contexts.segment6%TYPE
34: ,segment7 hr_item_contexts.segment7%TYPE
35: ,segment8 hr_item_contexts.segment8%TYPE
36: ,segment9 hr_item_contexts.segment9%TYPE
37: ,segment10 hr_item_contexts.segment10%TYPE
38: ,segment11 hr_item_contexts.segment11%TYPE
39: ,segment12 hr_item_contexts.segment12%TYPE
40: ,segment13 hr_item_contexts.segment13%TYPE

Line 37: ,segment10 hr_item_contexts.segment10%TYPE

33: ,segment6 hr_item_contexts.segment6%TYPE
34: ,segment7 hr_item_contexts.segment7%TYPE
35: ,segment8 hr_item_contexts.segment8%TYPE
36: ,segment9 hr_item_contexts.segment9%TYPE
37: ,segment10 hr_item_contexts.segment10%TYPE
38: ,segment11 hr_item_contexts.segment11%TYPE
39: ,segment12 hr_item_contexts.segment12%TYPE
40: ,segment13 hr_item_contexts.segment13%TYPE
41: ,segment14 hr_item_contexts.segment14%TYPE

Line 38: ,segment11 hr_item_contexts.segment11%TYPE

34: ,segment7 hr_item_contexts.segment7%TYPE
35: ,segment8 hr_item_contexts.segment8%TYPE
36: ,segment9 hr_item_contexts.segment9%TYPE
37: ,segment10 hr_item_contexts.segment10%TYPE
38: ,segment11 hr_item_contexts.segment11%TYPE
39: ,segment12 hr_item_contexts.segment12%TYPE
40: ,segment13 hr_item_contexts.segment13%TYPE
41: ,segment14 hr_item_contexts.segment14%TYPE
42: ,segment15 hr_item_contexts.segment15%TYPE

Line 39: ,segment12 hr_item_contexts.segment12%TYPE

35: ,segment8 hr_item_contexts.segment8%TYPE
36: ,segment9 hr_item_contexts.segment9%TYPE
37: ,segment10 hr_item_contexts.segment10%TYPE
38: ,segment11 hr_item_contexts.segment11%TYPE
39: ,segment12 hr_item_contexts.segment12%TYPE
40: ,segment13 hr_item_contexts.segment13%TYPE
41: ,segment14 hr_item_contexts.segment14%TYPE
42: ,segment15 hr_item_contexts.segment15%TYPE
43: ,segment16 hr_item_contexts.segment16%TYPE

Line 40: ,segment13 hr_item_contexts.segment13%TYPE

36: ,segment9 hr_item_contexts.segment9%TYPE
37: ,segment10 hr_item_contexts.segment10%TYPE
38: ,segment11 hr_item_contexts.segment11%TYPE
39: ,segment12 hr_item_contexts.segment12%TYPE
40: ,segment13 hr_item_contexts.segment13%TYPE
41: ,segment14 hr_item_contexts.segment14%TYPE
42: ,segment15 hr_item_contexts.segment15%TYPE
43: ,segment16 hr_item_contexts.segment16%TYPE
44: ,segment17 hr_item_contexts.segment17%TYPE

Line 41: ,segment14 hr_item_contexts.segment14%TYPE

37: ,segment10 hr_item_contexts.segment10%TYPE
38: ,segment11 hr_item_contexts.segment11%TYPE
39: ,segment12 hr_item_contexts.segment12%TYPE
40: ,segment13 hr_item_contexts.segment13%TYPE
41: ,segment14 hr_item_contexts.segment14%TYPE
42: ,segment15 hr_item_contexts.segment15%TYPE
43: ,segment16 hr_item_contexts.segment16%TYPE
44: ,segment17 hr_item_contexts.segment17%TYPE
45: ,segment18 hr_item_contexts.segment18%TYPE

Line 42: ,segment15 hr_item_contexts.segment15%TYPE

38: ,segment11 hr_item_contexts.segment11%TYPE
39: ,segment12 hr_item_contexts.segment12%TYPE
40: ,segment13 hr_item_contexts.segment13%TYPE
41: ,segment14 hr_item_contexts.segment14%TYPE
42: ,segment15 hr_item_contexts.segment15%TYPE
43: ,segment16 hr_item_contexts.segment16%TYPE
44: ,segment17 hr_item_contexts.segment17%TYPE
45: ,segment18 hr_item_contexts.segment18%TYPE
46: ,segment19 hr_item_contexts.segment19%TYPE

Line 43: ,segment16 hr_item_contexts.segment16%TYPE

39: ,segment12 hr_item_contexts.segment12%TYPE
40: ,segment13 hr_item_contexts.segment13%TYPE
41: ,segment14 hr_item_contexts.segment14%TYPE
42: ,segment15 hr_item_contexts.segment15%TYPE
43: ,segment16 hr_item_contexts.segment16%TYPE
44: ,segment17 hr_item_contexts.segment17%TYPE
45: ,segment18 hr_item_contexts.segment18%TYPE
46: ,segment19 hr_item_contexts.segment19%TYPE
47: ,segment20 hr_item_contexts.segment20%TYPE

Line 44: ,segment17 hr_item_contexts.segment17%TYPE

40: ,segment13 hr_item_contexts.segment13%TYPE
41: ,segment14 hr_item_contexts.segment14%TYPE
42: ,segment15 hr_item_contexts.segment15%TYPE
43: ,segment16 hr_item_contexts.segment16%TYPE
44: ,segment17 hr_item_contexts.segment17%TYPE
45: ,segment18 hr_item_contexts.segment18%TYPE
46: ,segment19 hr_item_contexts.segment19%TYPE
47: ,segment20 hr_item_contexts.segment20%TYPE
48: ,segment21 hr_item_contexts.segment21%TYPE

Line 45: ,segment18 hr_item_contexts.segment18%TYPE

41: ,segment14 hr_item_contexts.segment14%TYPE
42: ,segment15 hr_item_contexts.segment15%TYPE
43: ,segment16 hr_item_contexts.segment16%TYPE
44: ,segment17 hr_item_contexts.segment17%TYPE
45: ,segment18 hr_item_contexts.segment18%TYPE
46: ,segment19 hr_item_contexts.segment19%TYPE
47: ,segment20 hr_item_contexts.segment20%TYPE
48: ,segment21 hr_item_contexts.segment21%TYPE
49: ,segment22 hr_item_contexts.segment22%TYPE

Line 46: ,segment19 hr_item_contexts.segment19%TYPE

42: ,segment15 hr_item_contexts.segment15%TYPE
43: ,segment16 hr_item_contexts.segment16%TYPE
44: ,segment17 hr_item_contexts.segment17%TYPE
45: ,segment18 hr_item_contexts.segment18%TYPE
46: ,segment19 hr_item_contexts.segment19%TYPE
47: ,segment20 hr_item_contexts.segment20%TYPE
48: ,segment21 hr_item_contexts.segment21%TYPE
49: ,segment22 hr_item_contexts.segment22%TYPE
50: ,segment23 hr_item_contexts.segment23%TYPE

Line 47: ,segment20 hr_item_contexts.segment20%TYPE

43: ,segment16 hr_item_contexts.segment16%TYPE
44: ,segment17 hr_item_contexts.segment17%TYPE
45: ,segment18 hr_item_contexts.segment18%TYPE
46: ,segment19 hr_item_contexts.segment19%TYPE
47: ,segment20 hr_item_contexts.segment20%TYPE
48: ,segment21 hr_item_contexts.segment21%TYPE
49: ,segment22 hr_item_contexts.segment22%TYPE
50: ,segment23 hr_item_contexts.segment23%TYPE
51: ,segment24 hr_item_contexts.segment24%TYPE

Line 48: ,segment21 hr_item_contexts.segment21%TYPE

44: ,segment17 hr_item_contexts.segment17%TYPE
45: ,segment18 hr_item_contexts.segment18%TYPE
46: ,segment19 hr_item_contexts.segment19%TYPE
47: ,segment20 hr_item_contexts.segment20%TYPE
48: ,segment21 hr_item_contexts.segment21%TYPE
49: ,segment22 hr_item_contexts.segment22%TYPE
50: ,segment23 hr_item_contexts.segment23%TYPE
51: ,segment24 hr_item_contexts.segment24%TYPE
52: ,segment25 hr_item_contexts.segment25%TYPE

Line 49: ,segment22 hr_item_contexts.segment22%TYPE

45: ,segment18 hr_item_contexts.segment18%TYPE
46: ,segment19 hr_item_contexts.segment19%TYPE
47: ,segment20 hr_item_contexts.segment20%TYPE
48: ,segment21 hr_item_contexts.segment21%TYPE
49: ,segment22 hr_item_contexts.segment22%TYPE
50: ,segment23 hr_item_contexts.segment23%TYPE
51: ,segment24 hr_item_contexts.segment24%TYPE
52: ,segment25 hr_item_contexts.segment25%TYPE
53: ,segment26 hr_item_contexts.segment26%TYPE

Line 50: ,segment23 hr_item_contexts.segment23%TYPE

46: ,segment19 hr_item_contexts.segment19%TYPE
47: ,segment20 hr_item_contexts.segment20%TYPE
48: ,segment21 hr_item_contexts.segment21%TYPE
49: ,segment22 hr_item_contexts.segment22%TYPE
50: ,segment23 hr_item_contexts.segment23%TYPE
51: ,segment24 hr_item_contexts.segment24%TYPE
52: ,segment25 hr_item_contexts.segment25%TYPE
53: ,segment26 hr_item_contexts.segment26%TYPE
54: ,segment27 hr_item_contexts.segment27%TYPE

Line 51: ,segment24 hr_item_contexts.segment24%TYPE

47: ,segment20 hr_item_contexts.segment20%TYPE
48: ,segment21 hr_item_contexts.segment21%TYPE
49: ,segment22 hr_item_contexts.segment22%TYPE
50: ,segment23 hr_item_contexts.segment23%TYPE
51: ,segment24 hr_item_contexts.segment24%TYPE
52: ,segment25 hr_item_contexts.segment25%TYPE
53: ,segment26 hr_item_contexts.segment26%TYPE
54: ,segment27 hr_item_contexts.segment27%TYPE
55: ,segment28 hr_item_contexts.segment28%TYPE

Line 52: ,segment25 hr_item_contexts.segment25%TYPE

48: ,segment21 hr_item_contexts.segment21%TYPE
49: ,segment22 hr_item_contexts.segment22%TYPE
50: ,segment23 hr_item_contexts.segment23%TYPE
51: ,segment24 hr_item_contexts.segment24%TYPE
52: ,segment25 hr_item_contexts.segment25%TYPE
53: ,segment26 hr_item_contexts.segment26%TYPE
54: ,segment27 hr_item_contexts.segment27%TYPE
55: ,segment28 hr_item_contexts.segment28%TYPE
56: ,segment29 hr_item_contexts.segment29%TYPE

Line 53: ,segment26 hr_item_contexts.segment26%TYPE

49: ,segment22 hr_item_contexts.segment22%TYPE
50: ,segment23 hr_item_contexts.segment23%TYPE
51: ,segment24 hr_item_contexts.segment24%TYPE
52: ,segment25 hr_item_contexts.segment25%TYPE
53: ,segment26 hr_item_contexts.segment26%TYPE
54: ,segment27 hr_item_contexts.segment27%TYPE
55: ,segment28 hr_item_contexts.segment28%TYPE
56: ,segment29 hr_item_contexts.segment29%TYPE
57: ,segment30 hr_item_contexts.segment30%TYPE);

Line 54: ,segment27 hr_item_contexts.segment27%TYPE

50: ,segment23 hr_item_contexts.segment23%TYPE
51: ,segment24 hr_item_contexts.segment24%TYPE
52: ,segment25 hr_item_contexts.segment25%TYPE
53: ,segment26 hr_item_contexts.segment26%TYPE
54: ,segment27 hr_item_contexts.segment27%TYPE
55: ,segment28 hr_item_contexts.segment28%TYPE
56: ,segment29 hr_item_contexts.segment29%TYPE
57: ,segment30 hr_item_contexts.segment30%TYPE);
58:

Line 55: ,segment28 hr_item_contexts.segment28%TYPE

51: ,segment24 hr_item_contexts.segment24%TYPE
52: ,segment25 hr_item_contexts.segment25%TYPE
53: ,segment26 hr_item_contexts.segment26%TYPE
54: ,segment27 hr_item_contexts.segment27%TYPE
55: ,segment28 hr_item_contexts.segment28%TYPE
56: ,segment29 hr_item_contexts.segment29%TYPE
57: ,segment30 hr_item_contexts.segment30%TYPE);
58:
59: l_rec l_rec_type;

Line 56: ,segment29 hr_item_contexts.segment29%TYPE

52: ,segment25 hr_item_contexts.segment25%TYPE
53: ,segment26 hr_item_contexts.segment26%TYPE
54: ,segment27 hr_item_contexts.segment27%TYPE
55: ,segment28 hr_item_contexts.segment28%TYPE
56: ,segment29 hr_item_contexts.segment29%TYPE
57: ,segment30 hr_item_contexts.segment30%TYPE);
58:
59: l_rec l_rec_type;
60:

Line 57: ,segment30 hr_item_contexts.segment30%TYPE);

53: ,segment26 hr_item_contexts.segment26%TYPE
54: ,segment27 hr_item_contexts.segment27%TYPE
55: ,segment28 hr_item_contexts.segment28%TYPE
56: ,segment29 hr_item_contexts.segment29%TYPE
57: ,segment30 hr_item_contexts.segment30%TYPE);
58:
59: l_rec l_rec_type;
60:
61: CURSOR cur_item_contexts

Line 94: FROM hr_item_contexts icx

90: ,icx.segment27
91: ,icx.segment28
92: ,icx.segment29
93: ,icx.segment30
94: FROM hr_item_contexts icx
95: ,hr_template_item_contexts tic
96: WHERE icx.item_context_id = tic.item_context_id
97: AND tic.template_item_context_id = p_template_item_context_id_frm;
98: