APPS.IEU_MSG_PRODUCER_PUB dependencies on DUAL

Line 10: p_resource_type IN VARCHAR2 DEFAULT 'RS_INDIVIDUAL',

6: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
7: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
8: p_application_id IN NUMBER,
9: p_resource_id IN NUMBER,
10: p_resource_type IN VARCHAR2 DEFAULT 'RS_INDIVIDUAL',
11: p_title IN VARCHAR2,
12: p_body IN VARCHAR2,
13: p_workitem_obj_code IN VARCHAR2,
14: p_workitem_pk_id IN NUMBER,

Line 141: select IEU_MSG_MESSAGES_S1.NEXTVAL into x_message_id from dual;

137: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
138: raise FND_API.G_EXC_UNEXPECTED_ERROR;
139: END IF;
140:
141: select IEU_MSG_MESSAGES_S1.NEXTVAL into x_message_id from dual;
142: INSERT INTO
143: IEU_MSG_MESSAGES
144: (
145: MESSAGE_ID,

Line 171: 'RS_INDIVIDUAL',

167: FND_GLOBAL.USER_ID,
168: SYSDATE,
169: FND_GLOBAL.LOGIN_ID,
170: p_application_id,
171: 'RS_INDIVIDUAL',
172: p_resource_id,
173: 1, -- just assuming 1 for now...
174: p_title,
175: p_body,