APPS.PSP_AUTO_NA_BYPASS_PKG dependencies on PSP_AUTO_NA_BYPASS

Line 1: PACKAGE BODY psp_auto_na_bypass_pkg AS

1: PACKAGE BODY psp_auto_na_bypass_pkg AS
2: /* $Header: PSPAUTNB.pls 115.5 2002/11/19 11:05:37 ddubey ship $ */
3: PROCEDURE insert_row
4: (p_rowid IN OUT NOCOPY VARCHAR2,
5: p_natural_account IN VARCHAR2,

Line 12: FROM psp_auto_na_bypass

8: p_set_of_books_id IN NUMBER,
9: p_mode IN VARCHAR2 DEFAULT 'R') IS
10: CURSOR row_id_cur IS
11: SELECT rowid
12: FROM psp_auto_na_bypass
13: WHERE natural_account = p_natural_account
14: AND segment_num = p_segment_num;
15:
16: l_last_update_date DATE;

Line 38: INSERT INTO psp_auto_na_bypass

34: ELSE
35: fnd_message.set_name('FND', 'SYSTEM-INVALID ARGS');
36: app_exception.raise_exception;
37: END IF;
38: INSERT INTO psp_auto_na_bypass
39: (natural_account, segment_num, business_group_id, set_of_books_id,
40: creation_date, created_by, last_update_date, last_updated_by,
41: last_update_login)
42: VALUES (p_natural_account, p_segment_num, p_business_group_id, p_set_of_books_id,

Line 61: FROM psp_auto_na_bypass

57: (p_rowid IN OUT NOCOPY VARCHAR2,
58: p_natural_account IN VARCHAR2) IS
59: CURSOR natural_account_lock_cur IS
60: SELECT *
61: FROM psp_auto_na_bypass
62: WHERE rowid = p_rowid
63: FOR UPDATE OF natural_account NOWAIT;
64:
65: -- Becuase the primary key may be updated, so we lock the row

Line 120: UPDATE psp_auto_na_bypass

116: fnd_message.set_name('FND', 'SYSTEM-INVALID ARGS');
117: app_exception.raise_exception;
118: END IF;
119:
120: UPDATE psp_auto_na_bypass
121: SET natural_account = p_natural_account,
122: segment_num = p_segment_num,
123: last_update_date = l_last_update_date,
124: last_updated_by = l_last_updated_by,

Line 141: DELETE FROM psp_auto_na_bypass

137:
138: PROCEDURE delete_row
139: (p_rowid IN OUT NOCOPY VARCHAR2) IS
140: BEGIN
141: DELETE FROM psp_auto_na_bypass
142: WHERE rowid = p_rowid;
143:
144: -- Becuase the primary key may be updated, so we lock the row
145: -- based on rowid instead of these 2 primary keys.

Line 154: END psp_auto_na_bypass_pkg;

150: RAISE NO_DATA_FOUND;
151: END IF;
152: END delete_row;
153:
154: END psp_auto_na_bypass_pkg;