APPS.IEM_ACT_CATG_PVT dependencies on IEM_ACCOUNT_CATEGORIES

Line 49: delete from iem_account_categories

45: THEN
46: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
47: END IF;
48: x_return_status := FND_API.G_RET_STS_SUCCESS;
49: delete from iem_account_categories
50: where email_account_id=p_email_account_id;
51: IF p_cat_tbl.count>0 THEN
52: FOR i in p_cat_tbl.FIRST..p_cat_tbl.LAST LOOP
53: l_cat_id:=to_number(p_cat_tbl(i));

Line 54: select IEM_ACCOUNT_CATEGORIES_S1.nextval into

50: where email_account_id=p_email_account_id;
51: IF p_cat_tbl.count>0 THEN
52: FOR i in p_cat_tbl.FIRST..p_cat_tbl.LAST LOOP
53: l_cat_id:=to_number(p_cat_tbl(i));
54: select IEM_ACCOUNT_CATEGORIES_S1.nextval into
55: l_acct_cat_seq
56: from dual;
57: INSERT INTO IEM_ACCOUNT_CATEGORIES (
58: ACCOUNT_CATEGORY_ID,

Line 57: INSERT INTO IEM_ACCOUNT_CATEGORIES (

53: l_cat_id:=to_number(p_cat_tbl(i));
54: select IEM_ACCOUNT_CATEGORIES_S1.nextval into
55: l_acct_cat_seq
56: from dual;
57: INSERT INTO IEM_ACCOUNT_CATEGORIES (
58: ACCOUNT_CATEGORY_ID,
59: EMAIL_ACCOUNT_ID ,
60: CATEGORY_ID ,
61: CREATED_BY ,

Line 160: cursor c1 is select category_id from iem_account_categories

156: x_msg_data OUT NOCOPY VARCHAR2
157: ) is
158: l_api_name VARCHAR2(255):='select_item';
159: l_api_version_number NUMBER:=1.0;
160: cursor c1 is select category_id from iem_account_categories
161: where email_account_id=p_email_account_id;
162: BEGIN
163: -- Standard call to check for call compatibility.
164: IF NOT FND_API.Compatible_API_Call (l_api_version_number,