DBA Data[Home] [Help]

APPS.IEM_EMAILPROC_HDL_PVT dependencies on IEM_ACTIONS

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 1148: SELECT IEM_ACTIONS_s1.nextval

1144:
1145: x_return_status := FND_API.G_RET_STS_SUCCESS;
1146:
1147: --actual API begins here
1148: SELECT IEM_ACTIONS_s1.nextval
1149: INTO l_seq_id
1150: FROM dual;
1151:
1152: INSERT INTO IEM_ACTIONS

Line 1152: INSERT INTO IEM_ACTIONS

1148: SELECT IEM_ACTIONS_s1.nextval
1149: INTO l_seq_id
1150: FROM dual;
1151:
1152: INSERT INTO IEM_ACTIONS
1153: (
1154: ACTION_ID,
1155: EMAILPROC_ID,
1156: ACTION,