DBA Data[Home] [Help]

APPS.IEM_EMAILPROC_HDL_PVT dependencies on IEM_ACTION_DTLS

Line 5: -- Purpose: Mantain IEM_EMAILPROCS, IEM_EMAILPROC_RULES, IEM_ACCOUNT_EMAILPROCS, IEM_ACTIONS, IEM_ACTION_DTLS

1: PACKAGE BODY IEM_EMAILPROC_HDL_PVT AS
2: /* $Header: iemvprob.pls 120.0.12010000.2 2009/07/11 16:52:07 lkullamb ship $ */
3: --
4: --
5: -- Purpose: Mantain IEM_EMAILPROCS, IEM_EMAILPROC_RULES, IEM_ACCOUNT_EMAILPROCS, IEM_ACTIONS, IEM_ACTION_DTLS
6: -- related operations
7: --
8: -- MODIFICATION HISTORY
9: -- Person Date Comments

Line 1304: SELECT IEM_ACTION_DTLS_s1.nextval

1300:
1301: x_return_status := FND_API.G_RET_STS_SUCCESS;
1302:
1303: --actual API begins here
1304: SELECT IEM_ACTION_DTLS_s1.nextval
1305: INTO l_seq_id
1306: FROM dual;
1307:
1308: INSERT INTO IEM_ACTION_DTLS

Line 1308: INSERT INTO IEM_ACTION_DTLS

1304: SELECT IEM_ACTION_DTLS_s1.nextval
1305: INTO l_seq_id
1306: FROM dual;
1307:
1308: INSERT INTO IEM_ACTION_DTLS
1309: (
1310: ACTION_DTL_ID,
1311: ACTION_ID,
1312: PARAMETER1,