APPS.IEX_DUNNINGS_PKG dependencies on IEX_DUNNINGS

Line 1: PACKAGE BODY IEX_DUNNINGS_pkg AS

1: PACKAGE BODY IEX_DUNNINGS_pkg AS
2: /* $Header: iextdunb.pls 120.14 2011/06/14 06:36:19 snuthala ship $ */
3:
4: PG_DEBUG NUMBER(2) ;
5:

Line 50: FROM iex_dunnings

46: , p_as_of_date date
47: ) IS
48: CURSOR l_insert IS
49: SELECT ROWID
50: FROM iex_dunnings
51: WHERE dunning_id = px_dunning_id;
52: --
53: CURSOR get_seq_csr is
54: SELECT IEX_dunnings_s.nextval

Line 54: SELECT IEX_dunnings_s.nextval

50: FROM iex_dunnings
51: WHERE dunning_id = px_dunning_id;
52: --
53: CURSOR get_seq_csr is
54: SELECT IEX_dunnings_s.nextval
55: FROM sys.dual;
56: BEGIN
57: --
58: If (px_dunning_id IS NULL) OR (px_dunning_id = FND_API.G_MISS_NUM) then

Line 65: INSERT INTO IEX_DUNNINGS (

61: CLOSE get_seq_csr;
62: End If;
63: --Start adding for bug 8489610 by gnramasa 14-May-09
64: --
65: INSERT INTO IEX_DUNNINGS (
66: DUNNING_ID
67: , TEMPLATE_ID
68: , CALLBACK_YN
69: , CALLBACK_DATE

Line 161: DELETE FROM iex_dunnings

157: PROCEDURE delete_row(
158: p_dunning_id NUMBER
159: ) IS
160: BEGIN
161: DELETE FROM iex_dunnings
162: WHERE dunning_id = p_dunning_id;
163: IF (SQL%NOTFOUND) THEN
164: RAISE NO_DATA_FOUND;
165: END IF;

Line 210: UPDATE iex_dunnings

206: , p_addt_xml_template_id number --added for bug 9970624 gnramasa 4th Aug 10
207: , p_addt_delivery_status varchar2 --added for bug 9970624 gnramasa 4th Aug 10
208: ) IS
209: BEGIN
210: UPDATE iex_dunnings
211: SET
212: dunning_id = DECODE(p_dunning_id, FND_API.G_MISS_NUM, NULL, p_dunning_id)
213: , template_id = DECODE(p_template_id, FND_API.G_MISS_NUM, NULL, p_template_id)
214: , callback_yn = DECODE(p_callback_yn, FND_API.G_MISS_CHAR, NULL, p_callback_yn)

Line 291: FROM iex_dunnings

287: , p_contact_party_id NUMBER
288: ) IS
289: CURSOR l_lock IS
290: SELECT *
291: FROM iex_dunnings
292: WHERE rowid = p_rowid
293: FOR UPDATE OF dunning_id NOWAIT;
294: l_table_rec l_lock%ROWTYPE;
295: BEGIN

Line 504: UPDATE iex_dunnings

500: , p_confirmation_mode varchar2 -- added by gnramasa for bug 8489610 14-May-09
501: , p_dunning_plan_line_id number
502: ) IS
503: BEGIN
504: UPDATE iex_dunnings
505: SET
506: dunning_id = DECODE(p_dunning_id, FND_API.G_MISS_NUM, NULL, p_dunning_id)
507: , template_id = DECODE(p_template_id, FND_API.G_MISS_NUM, NULL, p_template_id)
508: , callback_yn = DECODE(p_callback_yn, FND_API.G_MISS_CHAR, NULL, p_callback_yn)

Line 551: END iex_dunnings_pkg;

547:
548: BEGIN
549: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
550:
551: END iex_dunnings_pkg;