APPS.HR_ACCRUAL_PLAN_TL dependencies on PAY_ACCRUAL_PLANS

Line 4: (p_accrual_plan_id IN pay_accrual_plans_tl.accrual_plan_id%TYPE

1: PACKAGE BODY hr_accrual_plan_tl AS
2: /* $Header: perpaptl.pkb 120.0.12020000.2 2013/02/12 09:22:05 srannama noship $ */
3: PROCEDURE ins
4: (p_accrual_plan_id IN pay_accrual_plans_tl.accrual_plan_id%TYPE
5: ,p_accrual_plan_name IN pay_accrual_plans_tl.accrual_plan_name%TYPE
6: ,p_description IN pay_accrual_plans_tl.description%TYPE DEFAULT NULL) IS
7: BEGIN
8: INSERT

Line 5: ,p_accrual_plan_name IN pay_accrual_plans_tl.accrual_plan_name%TYPE

1: PACKAGE BODY hr_accrual_plan_tl AS
2: /* $Header: perpaptl.pkb 120.0.12020000.2 2013/02/12 09:22:05 srannama noship $ */
3: PROCEDURE ins
4: (p_accrual_plan_id IN pay_accrual_plans_tl.accrual_plan_id%TYPE
5: ,p_accrual_plan_name IN pay_accrual_plans_tl.accrual_plan_name%TYPE
6: ,p_description IN pay_accrual_plans_tl.description%TYPE DEFAULT NULL) IS
7: BEGIN
8: INSERT
9: INTO pay_accrual_plans_tl

Line 6: ,p_description IN pay_accrual_plans_tl.description%TYPE DEFAULT NULL) IS

2: /* $Header: perpaptl.pkb 120.0.12020000.2 2013/02/12 09:22:05 srannama noship $ */
3: PROCEDURE ins
4: (p_accrual_plan_id IN pay_accrual_plans_tl.accrual_plan_id%TYPE
5: ,p_accrual_plan_name IN pay_accrual_plans_tl.accrual_plan_name%TYPE
6: ,p_description IN pay_accrual_plans_tl.description%TYPE DEFAULT NULL) IS
7: BEGIN
8: INSERT
9: INTO pay_accrual_plans_tl
10: (accrual_plan_id

Line 9: INTO pay_accrual_plans_tl

5: ,p_accrual_plan_name IN pay_accrual_plans_tl.accrual_plan_name%TYPE
6: ,p_description IN pay_accrual_plans_tl.description%TYPE DEFAULT NULL) IS
7: BEGIN
8: INSERT
9: INTO pay_accrual_plans_tl
10: (accrual_plan_id
11: ,language
12: ,source_lang
13: ,accrual_plan_name

Line 25: FROM pay_accrual_plans_tl t

21: WHERE l.installed_flag IN ('I','B')
22: AND NOT EXISTS
23: (
24: SELECT NULL
25: FROM pay_accrual_plans_tl t
26: WHERE t.accrual_plan_id = p_accrual_plan_id
27: AND t.language = l.language_code
28: );
29: END ins;

Line 32: (p_accrual_plan_id IN pay_accrual_plans_tl.accrual_plan_id%TYPE

28: );
29: END ins;
30:
31: PROCEDURE upd
32: (p_accrual_plan_id IN pay_accrual_plans_tl.accrual_plan_id%TYPE
33: ,p_description IN pay_accrual_plans_tl.description%TYPE DEFAULT NULL) IS
34: BEGIN
35: UPDATE pay_accrual_plans_tl
36: SET description = p_description

Line 33: ,p_description IN pay_accrual_plans_tl.description%TYPE DEFAULT NULL) IS

29: END ins;
30:
31: PROCEDURE upd
32: (p_accrual_plan_id IN pay_accrual_plans_tl.accrual_plan_id%TYPE
33: ,p_description IN pay_accrual_plans_tl.description%TYPE DEFAULT NULL) IS
34: BEGIN
35: UPDATE pay_accrual_plans_tl
36: SET description = p_description
37: ,source_lang = userenv ('LANG')

Line 35: UPDATE pay_accrual_plans_tl

31: PROCEDURE upd
32: (p_accrual_plan_id IN pay_accrual_plans_tl.accrual_plan_id%TYPE
33: ,p_description IN pay_accrual_plans_tl.description%TYPE DEFAULT NULL) IS
34: BEGIN
35: UPDATE pay_accrual_plans_tl
36: SET description = p_description
37: ,source_lang = userenv ('LANG')
38: WHERE accrual_plan_id = p_accrual_plan_id
39: AND userenv ('LANG') IN (language,source_lang);

Line 43: (p_accrual_plan_id IN pay_accrual_plans_tl.accrual_plan_id%TYPE) IS

39: AND userenv ('LANG') IN (language,source_lang);
40: END upd;
41:
42: PROCEDURE del
43: (p_accrual_plan_id IN pay_accrual_plans_tl.accrual_plan_id%TYPE) IS
44: BEGIN
45: DELETE
46: FROM pay_accrual_plans_tl
47: WHERE accrual_plan_id = p_accrual_plan_id;

Line 46: FROM pay_accrual_plans_tl

42: PROCEDURE del
43: (p_accrual_plan_id IN pay_accrual_plans_tl.accrual_plan_id%TYPE) IS
44: BEGIN
45: DELETE
46: FROM pay_accrual_plans_tl
47: WHERE accrual_plan_id = p_accrual_plan_id;
48: END del;
49:
50: PROCEDURE add_language IS

Line 53: FROM pay_accrual_plans_tl t

49:
50: PROCEDURE add_language IS
51: BEGIN
52: DELETE
53: FROM pay_accrual_plans_tl t
54: WHERE NOT EXISTS
55: (
56: SELECT NULL
57: FROM pay_accrual_plans b

Line 57: FROM pay_accrual_plans b

53: FROM pay_accrual_plans_tl t
54: WHERE NOT EXISTS
55: (
56: SELECT NULL
57: FROM pay_accrual_plans b
58: WHERE b.accrual_plan_id = t.accrual_plan_id
59: );
60:
61: UPDATE pay_accrual_plans_tl t

Line 61: UPDATE pay_accrual_plans_tl t

57: FROM pay_accrual_plans b
58: WHERE b.accrual_plan_id = t.accrual_plan_id
59: );
60:
61: UPDATE pay_accrual_plans_tl t
62: SET (accrual_plan_name
63: ,description) =
64: (
65: SELECT b.accrual_plan_name

Line 67: FROM pay_accrual_plans_tl b

63: ,description) =
64: (
65: SELECT b.accrual_plan_name
66: ,b.description
67: FROM pay_accrual_plans_tl b
68: WHERE b.accrual_plan_id = t.accrual_plan_id
69: AND b.language = t.source_lang
70: )
71: WHERE (t.accrual_plan_id,t.language) IN

Line 75: FROM pay_accrual_plans_tl subb

71: WHERE (t.accrual_plan_id,t.language) IN
72: (
73: SELECT subt.accrual_plan_id
74: ,subt.language
75: FROM pay_accrual_plans_tl subb
76: ,pay_accrual_plans_tl subt
77: WHERE subb.accrual_plan_id = subt.accrual_plan_id
78: AND subb.language = subt.source_lang
79: AND (

Line 76: ,pay_accrual_plans_tl subt

72: (
73: SELECT subt.accrual_plan_id
74: ,subt.language
75: FROM pay_accrual_plans_tl subb
76: ,pay_accrual_plans_tl subt
77: WHERE subb.accrual_plan_id = subt.accrual_plan_id
78: AND subb.language = subt.source_lang
79: AND (
80: subb.accrual_plan_name <> subt.accrual_plan_name

Line 94: INTO pay_accrual_plans_tl

90: )
91: );
92:
93: INSERT
94: INTO pay_accrual_plans_tl
95: (accrual_plan_id
96: ,accrual_plan_name
97: ,description
98: ,language

Line 105: FROM pay_accrual_plans_tl b

101: ,b.accrual_plan_name
102: ,b.description
103: ,l.language_code
104: ,b.source_lang
105: FROM pay_accrual_plans_tl b
106: ,fnd_languages l
107: WHERE l.installed_flag IN ('I','B')
108: AND b.language = userenv ('LANG')
109: AND NOT EXISTS

Line 112: FROM pay_accrual_plans_tl t

108: AND b.language = userenv ('LANG')
109: AND NOT EXISTS
110: (
111: SELECT NULL
112: FROM pay_accrual_plans_tl t
113: WHERE t.accrual_plan_id = b.accrual_plan_id
114: AND t.language = l.language_code
115: );
116: END add_language;

Line 127: FROM pay_accrual_plans

123:
124: CURSOR check_dup
125: (p_business_group_id IN number) IS
126: SELECT 'Y'
127: FROM pay_accrual_plans
128: WHERE accrual_plan_name = p_accrual_plan_name
129: AND business_group_id = p_business_group_id
130: AND (
131: p_accrual_plan_id IS NULL

Line 138: FROM pay_accrual_plans

134:
135: CURSOR check_dup_tl
136: (p_business_group_id IN number) IS
137: SELECT 'Y'
138: FROM pay_accrual_plans
139: WHERE business_group_id = p_business_group_id
140: AND accrual_plan_id =
141: (
142: SELECT DISTINCT

Line 144: FROM pay_accrual_plans_tl

140: AND accrual_plan_id =
141: (
142: SELECT DISTINCT
143: accrual_plan_id
144: FROM pay_accrual_plans_tl
145: WHERE accrual_plan_name = p_accrual_plan_name
146: AND (
147: p_accrual_plan_id IS NULL
148: OR p_accrual_plan_id <> accrual_plan_id