DBA Data[Home] [Help]

APPS.IEM_RT_PREPROC_EMAILS_PVT dependencies on STANDARD

Line 29: -- Standard call to check for call compatibility.

25: l_LAST_UPDATE_DATE DATE:=SYSDATE;
26: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
27:
28: BEGIN
29: -- Standard call to check for call compatibility.
30: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
31: p_api_version_number,
32: l_api_name,
33: G_PKG_NAME)

Line 62: -- Standard Check Of p_commit.

58: sysdate,
59: decode(l_LAST_UPDATE_LOGIN,null,-1,l_LAST_UPDATE_LOGIN)
60: );
61:
62: -- Standard Check Of p_commit.
63: IF p_commit='T' THEN
64: COMMIT WORK;
65: END IF;
66: -- Standard callto get message count and if count is 1, get message info.

Line 66: -- Standard callto get message count and if count is 1, get message info.

62: -- Standard Check Of p_commit.
63: IF p_commit='T' THEN
64: COMMIT WORK;
65: END IF;
66: -- Standard callto get message count and if count is 1, get message info.
67: FND_MSG_PUB.Count_And_Get
68: ( p_count => x_msg_count,
69: p_data => x_msg_data
70: );

Line 113: -- Standard call to check for call compatibility.

109: l_api_name VARCHAR2(255):='delete_item';
110: l_api_version_number NUMBER:=1.0;
111:
112: BEGIN
113: -- Standard call to check for call compatibility.
114: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
115: p_api_version_number,
116: l_api_name,
117: G_PKG_NAME)

Line 125: -- Standard Check Of p_commit.

121: x_return_status := FND_API.G_RET_STS_SUCCESS;
122: delete from IEM_RT_PREPROC_EMAILS
123: where message_id=p_message_id;
124:
125: -- Standard Check Of p_commit.
126: IF p_commit='T' THEN
127: COMMIT WORK;
128: END IF;
129: -- Standard callto get message count and if count is 1, get message info.

Line 129: -- Standard callto get message count and if count is 1, get message info.

125: -- Standard Check Of p_commit.
126: IF p_commit='T' THEN
127: COMMIT WORK;
128: END IF;
129: -- Standard callto get message count and if count is 1, get message info.
130: FND_MSG_PUB.Count_And_Get
131: ( p_count => x_msg_count,
132: p_data => x_msg_data
133: );