APPS.PER_LETTER_REQUESTS_PKG dependencies on PER_LETTER_REQUESTS

Line 1: PACKAGE BODY PER_LETTER_REQUESTS_PKG as

1: PACKAGE BODY PER_LETTER_REQUESTS_PKG as
2: /* $Header: peltr01t.pkb 115.3 2003/01/22 12:24:59 asahay ship $ */
3: --
4: PROCEDURE check_request_unique(X_letter_request_id in number,
5: X_business_group_id in number,

Line 15: from per_letter_requests

11: --
12: is
13:
14: cursor csr_request is select null
15: from per_letter_requests
16: where (X_letter_request_id is null
17: or (letter_request_id <> X_letter_request_id
18: and X_letter_request_id is not null))
19: and business_group_id + 0 = X_business_group_id

Line 70: hr_utility.set_location('PER_LETTER_REQUESTS_PKG.check_request_lines', 1);

66: hr_utility.set_message (801,'PER_7351_OUT_LETTER_NO_LINES');
67: hr_utility.raise_error;
68: end if;
69: --
70: hr_utility.set_location('PER_LETTER_REQUESTS_PKG.check_request_lines', 1);
71: --
72: end check_request_lines;
73: --
74: PROCEDURE confirm_delete_lines (X_letter_request_id in NUMBER,

Line 96: hr_utility.set_location('PER_LETTER_REQUESTS_PKG.confirm_delete_lines', 1);

92: X_request_lines_exist := TRUE;
93: end if;
94: close c;
95: --
96: hr_utility.set_location('PER_LETTER_REQUESTS_PKG.confirm_delete_lines', 1);
97: --
98: end confirm_delete_lines;
99: --
100: PROCEDURE Insert_Row(X_Rowid IN OUT nocopy VARCHAR2,

Line 110: CURSOR C IS SELECT rowid FROM per_letter_requests

106: X_Auto_Or_Manual VARCHAR2,
107: X_VACANCY_ID NUMBER,
108: X_EVENT_ID NUMBER
109: ) IS
110: CURSOR C IS SELECT rowid FROM per_letter_requests
111: WHERE letter_request_id = X_Letter_Request_Id;
112: --
113: CURSOR C2 IS SELECT per_letter_requests_s.nextval FROM sys.dual;
114: BEGIN

Line 113: CURSOR C2 IS SELECT per_letter_requests_s.nextval FROM sys.dual;

109: ) IS
110: CURSOR C IS SELECT rowid FROM per_letter_requests
111: WHERE letter_request_id = X_Letter_Request_Id;
112: --
113: CURSOR C2 IS SELECT per_letter_requests_s.nextval FROM sys.dual;
114: BEGIN
115: if (X_Letter_Request_Id is NULL) then
116: OPEN C2;
117: FETCH C2 INTO X_Letter_Request_Id;

Line 121: INSERT INTO per_letter_requests(

117: FETCH C2 INTO X_Letter_Request_Id;
118: CLOSE C2;
119: end if;
120: --
121: INSERT INTO per_letter_requests(
122: letter_request_id,
123: business_group_id,
124: letter_type_id,
125: date_from,

Line 165: FROM per_letter_requests

161: ) IS
162: --
163: CURSOR C IS
164: SELECT *
165: FROM per_letter_requests
166: WHERE rowid = X_Rowid
167: FOR UPDATE of letter_request_id NOWAIT;
168: Recinfo C%ROWTYPE;
169: --

Line 224: UPDATE per_letter_requests

220: X_EVENT_ID NUMBER
221: ) IS
222: BEGIN
223: --
224: UPDATE per_letter_requests
225: SET
226: letter_request_id = X_Letter_Request_Id,
227: business_group_id = X_Business_Group_Id,
228: letter_type_id = X_Letter_Type_Id,

Line 276: DELETE FROM per_letter_requests

272: end if;
273: --
274: end if;
275: --
276: DELETE FROM per_letter_requests
277: WHERE rowid = X_Rowid;
278: --
279: if (SQL%NOTFOUND) then
280: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

Line 309: END PER_LETTER_REQUESTS_PKG;

305: p_argument2);
306: --
307: end concurrent_program_call;
308: --
309: END PER_LETTER_REQUESTS_PKG;