Line 40: message_table.RESOURCE_TYPE = 'RS_INDIVIDUAL' AND
36: SELECT *
37: FROM
38: IEU_MSG_MESSAGES message_table
39: WHERE 40: message_table.RESOURCE_TYPE = 'RS_INDIVIDUAL' AND 41: message_table.RESOURCE_ID = P_RESOURCE_ID AND
42: message_table.STATUS_ID <= P_STATUS_ID;
43: BEGIN
44:
Line 193: SELECT userenv('LANGUAGE') INTO X_EXISTING_LANG FROM DUAL;
189: X_EXISTING_LANG OUT NOCOPY VARCHAR2
190: )
191: AS
192: BEGIN 193: SELECT userenv('LANGUAGE') INTO X_EXISTING_LANG FROM DUAL; 194:
195: SET_LANG_INFO( P_USER_LANG );
196:
197: END SET_LANG_INFO_X;