APPS.IEX_AG_DN_PKG dependencies on IEX_AG_DN_XREF

Line 28: FROM iex_ag_dn_xref

24: , p_last_update_login NUMBER
25: ) IS
26: CURSOR l_insert IS
27: SELECT ROWID
28: FROM iex_ag_dn_xref
29: WHERE ag_dn_xref_id = px_ag_dn_xref_id;
30: --
31: CURSOR get_seq_csr is
32: SELECT IEX_AG_DN_XREF_S.nextval

Line 32: SELECT IEX_AG_DN_XREF_S.nextval

28: FROM iex_ag_dn_xref
29: WHERE ag_dn_xref_id = px_ag_dn_xref_id;
30: --
31: CURSOR get_seq_csr is
32: SELECT IEX_AG_DN_XREF_S.nextval
33: FROM sys.dual;
34: BEGIN
35: --
36: If (px_ag_dn_xref_ID IS NULL) OR (px_ag_dn_xref_ID = FND_API.G_MISS_NUM) then

Line 42: INSERT INTO IEX_AG_DN_XREF (

38: FETCH get_seq_csr INTO px_ag_dn_xref_ID;
39: CLOSE get_seq_csr;
40: End If;
41: --
42: INSERT INTO IEX_AG_DN_XREF (
43: AG_DN_XREF_ID
44: , AGING_BUCKET_ID
45: , AGING_BUCKET_LINE_ID
46: , CALLBACK_FLAG

Line 94: DELETE FROM iex_ag_dn_xref

90: PROCEDURE delete_row(
91: p_ag_dn_xref_id NUMBER
92: ) IS
93: BEGIN
94: DELETE FROM iex_ag_dn_xref
95: WHERE ag_dn_xref_id = p_ag_dn_xref_id;
96: IF (SQL%NOTFOUND) THEN
97: RAISE NO_DATA_FOUND;
98: END IF;

Line 123: UPDATE iex_ag_dn_xref

119: , p_created_by NUMBER
120: , p_last_update_login NUMBER
121: ) IS
122: BEGIN
123: UPDATE iex_ag_dn_xref
124: SET
125: ag_dn_xref_id = DECODE(p_ag_dn_xref_id, FND_API.G_MISS_NUM, NULL, p_ag_dn_xref_id)
126: , aging_bucket_id = DECODE(p_aging_bucket_id, FND_API.G_MISS_NUM, NULL, p_aging_bucket_id)
127: , aging_bucket_line_id = DECODE(p_aging_bucket_line_id, FND_API.G_MISS_NUM, NULL, p_aging_bucket_line_id)

Line 172: FROM iex_ag_dn_xref

168: , p_last_update_login NUMBER
169: ) IS
170: CURSOR l_lock IS
171: SELECT *
172: FROM iex_ag_dn_xref
173: WHERE rowid = p_rowid
174: FOR UPDATE OF ag_dn_xref_id NOWAIT;
175: l_table_rec l_lock%ROWTYPE;
176: BEGIN