APPS.IEM_EMAILPROC_HDL_PVT dependencies on IEM_ACCOUNT_EMAILPROCS

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 86: SELECT IEM_ACCOUNT_EMAILPROCS_s1.nextval

82:
83: x_return_status := FND_API.G_RET_STS_SUCCESS;
84:
85: --actual API begins here
86: SELECT IEM_ACCOUNT_EMAILPROCS_s1.nextval
87: INTO l_seq_id
88: FROM dual;
89:
90: INSERT INTO IEM_ACCOUNT_EMAILPROCS

Line 90: INSERT INTO IEM_ACCOUNT_EMAILPROCS

86: SELECT IEM_ACCOUNT_EMAILPROCS_s1.nextval
87: INTO l_seq_id
88: FROM dual;
89:
90: INSERT INTO IEM_ACCOUNT_EMAILPROCS
91: (
92: EMAILPROC_ID,
93: EMAIL_ACCOUNT_ID,
94: ACCOUNT_EMAILPROC_ID,

Line 617: update IEM_ACCOUNT_EMAILPROCS

613: APP_EXCEPTION.RAISE_EXCEPTION;
614: END IF;
615:
616: if (p_enabled_flag is null ) then
617: update IEM_ACCOUNT_EMAILPROCS
618: set
619: priority=decode(p_priority,null,priority,p_priority),
620: LAST_UPDATED_BY = decode(G_created_updated_by,null,-1,G_created_updated_by),
621: LAST_UPDATE_DATE = sysdate,

Line 625: update IEM_ACCOUNT_EMAILPROCS

621: LAST_UPDATE_DATE = sysdate,
622: LAST_UPDATE_LOGIN = decode(G_LAST_UPDATE_LOGIN,null,-1,G_LAST_UPDATE_LOGIN)
623: where emailproc_id = p_emailproc_id and email_account_id = p_email_account_id;
624: elsif(p_enabled_flag = FND_API.G_MISS_CHAR ) then
625: update IEM_ACCOUNT_EMAILPROCS
626: set
627: enabled_flag='N',
628: priority=decode(p_priority,null,priority,p_priority),
629: LAST_UPDATED_BY = decode(G_created_updated_by,null,-1,G_created_updated_by),

Line 634: update IEM_ACCOUNT_EMAILPROCS

630: LAST_UPDATE_DATE = sysdate,
631: LAST_UPDATE_LOGIN = decode(G_LAST_UPDATE_LOGIN,null,-1,G_LAST_UPDATE_LOGIN)
632: where emailproc_id = p_emailproc_id and email_account_id = p_email_account_id;
633: elsif (p_enabled_flag = 'Y' or p_enabled_flag = 'N' ) then
634: update IEM_ACCOUNT_EMAILPROCS
635: set
636: enabled_flag=p_enabled_flag,
637: priority=decode(p_priority,null,priority,p_priority),
638: LAST_UPDATED_BY = decode(G_created_updated_by,null,-1,G_created_updated_by),

Line 1471: Update iem_account_emailprocs set priority=priority-1

1467:
1468: FOR i IN p_emailproc_ids_tbl.FIRST..p_emailproc_ids_tbl.LAST LOOP
1469:
1470: -- update priority after delete an account_emailproc
1471: Update iem_account_emailprocs set priority=priority-1
1472: where email_account_id=p_account_id
1473: and priority >
1474: (Select priority from iem_account_emailprocs
1475: where emailproc_id=p_emailproc_ids_tbl(i)

Line 1474: (Select priority from iem_account_emailprocs

1470: -- update priority after delete an account_emailproc
1471: Update iem_account_emailprocs set priority=priority-1
1472: where email_account_id=p_account_id
1473: and priority >
1474: (Select priority from iem_account_emailprocs
1475: where emailproc_id=p_emailproc_ids_tbl(i)
1476: and email_account_id=p_account_id)
1477: and emailproc_id in
1478: ( select emailproc_id from iem_emailprocs

Line 1482: FROM IEM_ACCOUNT_EMAILPROCS

1478: ( select emailproc_id from iem_emailprocs
1479: where rule_type= p_rule_type);
1480:
1481: DELETE
1482: FROM IEM_ACCOUNT_EMAILPROCS
1483: WHERE emailproc_id = p_emailproc_ids_tbl(i) and email_account_id = p_account_id;
1484:
1485: END LOOP;
1486: end if;