APPS.PER_LETTER_REQUESTS_PKG dependencies on PER_LETTER_REQUEST_LINES

Line 50: from per_letter_request_lines

46: --
47: PROCEDURE check_request_lines (X_letter_request_id in NUMBER)
48: --
49: is cursor c is select null
50: from per_letter_request_lines
51: where letter_request_id = X_letter_request_id;
52: --
53: g_dummy_number number;
54: request_lines_not_exist boolean := FALSE;

Line 79: from per_letter_request_lines

75: X_business_group_id in NUMBER,
76: X_request_lines_exist in out nocopy BOOLEAN) is
77: --
78: cursor c is select null
79: from per_letter_request_lines
80: where letter_request_id = X_letter_request_id;
81: --
82: g_dummy_number number;
83: --

Line 249: from per_letter_request_lines

245: PROCEDURE Delete_Row(X_Rowid VARCHAR2,
246: X_Letter_Request_Id NUMBER) is
247: --
248: cursor csr_lines is select null
249: from per_letter_request_lines
250: where letter_request_id = X_letter_request_id;
251: --
252: g_dummy_number number;
253: v_lines_exist boolean := FALSE;

Line 264: DELETE FROM per_letter_request_lines

260: close csr_lines;
261: --
262: if v_lines_exist then
263: --
264: DELETE FROM per_letter_request_lines
265: WHERE letter_Request_Id = X_letter_request_id;
266: --
267: if (SQL%NOTFOUND) then
268: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');