DBA Data[Home] [Help]

APPS.IEM_CLASSIFICATIONS_PVT dependencies on IEM_CLASSIFICATIONS_PVT

Line 1: PACKAGE BODY IEM_CLASSIFICATIONS_PVT as

1: PACKAGE BODY IEM_CLASSIFICATIONS_PVT as
2: /* $Header: iemvclab.pls 115.16 2003/08/26 23:42:12 sboorela shipped $*/
3:
4: /* Fixed Bug 1339176 rtripath on 11/27/00 Do the cascading delete */
5: /* 08/14/01 chtang added create_item_wrap_sss() for 11.5.6 */

Line 9: G_PKG_NAME CONSTANT varchar2(30) :='IEM_CLASSIFICATIONS_PVT';

5: /* 08/14/01 chtang added create_item_wrap_sss() for 11.5.6 */
6: /* 06/05/02 chtang fixed 2403484
7: /* 11/20/02 chtang removed SQL%NOTFOUND in delete_item_wrap_sss
8: /*****************************************************************/
9: G_PKG_NAME CONSTANT varchar2(30) :='IEM_CLASSIFICATIONS_PVT';
10:
11: -- Start of Comments
12: -- API name : create_item
13: -- Type : Private

Line 527: IEM_CLASSIFICATIONS_PVT.create_item(

523:
524: l_classification2 := rtrim(ltrim(l_classification, ' '), ' ');
525:
526:
527: IEM_CLASSIFICATIONS_PVT.create_item(
528: p_api_version_number =>p_api_version_number,
529: p_init_msg_list => p_init_msg_list,
530: p_commit => p_commit,
531: p_email_account_id =>p_email_account_id,

Line 666: IEM_CLASSIFICATIONS_PVT.create_item(

662:
663: l_classification2 := rtrim(ltrim(l_classification, ' '), ' ');
664:
665:
666: IEM_CLASSIFICATIONS_PVT.create_item(
667: p_api_version_number =>p_api_version_number,
668: p_init_msg_list => p_init_msg_list,
669: p_commit => p_commit,
670: p_email_account_id =>p_email_account_id,

Line 1004: IEM_CLASSIFICATIONS_PVT.update_item(

1000: APP_EXCEPTION.RAISE_EXCEPTION;
1001: end if;
1002:
1003:
1004: IEM_CLASSIFICATIONS_PVT.update_item(
1005: p_api_version_number =>p_api_version_number,
1006: p_init_msg_list => p_init_msg_list,
1007: p_commit => p_commit,
1008: p_classification_id =>p_classification_id,

Line 1132: IEM_CLASSIFICATIONS_PVT.update_item(

1128: select email_account_id into l_email_account_id
1129: from iem_classifications
1130: where classification_id=p_classification_id;
1131:
1132: IEM_CLASSIFICATIONS_PVT.update_item(
1133: p_api_version_number =>p_api_version_number,
1134: p_init_msg_list => p_init_msg_list,
1135: p_commit => p_commit,
1136: p_classification_id =>p_classification_id,

Line 1314: END IEM_CLASSIFICATIONS_PVT;

1310: x_return_Status:='E';
1311:
1312: END;
1313:
1314: END IEM_CLASSIFICATIONS_PVT;