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 2005/06/02 14:08:12 appldev noship $ */
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 1303: SELECT IEM_ACTION_DTLS_s1.nextval

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

Line 1307: INSERT INTO IEM_ACTION_DTLS

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