APPS.FUN_RICH_MESSAGES_PKG dependencies on FUN_RULE_UTILITY_PKG

Line 30: FUN_RULE_UTILITY_PKG.CREATION_DATE,

26: X_APPLICATION_ID,
27: X_MESSAGE_NAME,
28: 1,
29: X_CREATED_BY_MODULE,
30: FUN_RULE_UTILITY_PKG.CREATION_DATE,
31: FUN_RULE_UTILITY_PKG.CREATED_BY,
32: FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,
33: FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY,
34: FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN

Line 31: FUN_RULE_UTILITY_PKG.CREATED_BY,

27: X_MESSAGE_NAME,
28: 1,
29: X_CREATED_BY_MODULE,
30: FUN_RULE_UTILITY_PKG.CREATION_DATE,
31: FUN_RULE_UTILITY_PKG.CREATED_BY,
32: FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,
33: FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY,
34: FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN
35: );

Line 32: FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,

28: 1,
29: X_CREATED_BY_MODULE,
30: FUN_RULE_UTILITY_PKG.CREATION_DATE,
31: FUN_RULE_UTILITY_PKG.CREATED_BY,
32: FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,
33: FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY,
34: FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN
35: );
36:

Line 33: FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY,

29: X_CREATED_BY_MODULE,
30: FUN_RULE_UTILITY_PKG.CREATION_DATE,
31: FUN_RULE_UTILITY_PKG.CREATED_BY,
32: FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,
33: FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY,
34: FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN
35: );
36:
37: insert into FUN_RICH_MESSAGES_TL (

Line 34: FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN

30: FUN_RULE_UTILITY_PKG.CREATION_DATE,
31: FUN_RULE_UTILITY_PKG.CREATED_BY,
32: FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,
33: FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY,
34: FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN
35: );
36:
37: insert into FUN_RICH_MESSAGES_TL (
38: APPLICATION_ID,

Line 52: FUN_RULE_UTILITY_PKG.CREATION_DATE,

48: ) select
49: X_APPLICATION_ID,
50: X_MESSAGE_NAME,
51: X_MESSAGE_TEXT,
52: FUN_RULE_UTILITY_PKG.CREATION_DATE,
53: FUN_RULE_UTILITY_PKG.CREATED_BY,
54: FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,
55: FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY,
56: FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN,

Line 53: FUN_RULE_UTILITY_PKG.CREATED_BY,

49: X_APPLICATION_ID,
50: X_MESSAGE_NAME,
51: X_MESSAGE_TEXT,
52: FUN_RULE_UTILITY_PKG.CREATION_DATE,
53: FUN_RULE_UTILITY_PKG.CREATED_BY,
54: FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,
55: FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY,
56: FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN,
57: L.LANGUAGE_CODE,

Line 54: FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,

50: X_MESSAGE_NAME,
51: X_MESSAGE_TEXT,
52: FUN_RULE_UTILITY_PKG.CREATION_DATE,
53: FUN_RULE_UTILITY_PKG.CREATED_BY,
54: FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,
55: FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY,
56: FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN,
57: L.LANGUAGE_CODE,
58: userenv('LANG')

Line 55: FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY,

51: X_MESSAGE_TEXT,
52: FUN_RULE_UTILITY_PKG.CREATION_DATE,
53: FUN_RULE_UTILITY_PKG.CREATED_BY,
54: FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,
55: FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY,
56: FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN,
57: L.LANGUAGE_CODE,
58: userenv('LANG')
59: from FND_LANGUAGES L

Line 56: FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN,

52: FUN_RULE_UTILITY_PKG.CREATION_DATE,
53: FUN_RULE_UTILITY_PKG.CREATED_BY,
54: FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,
55: FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY,
56: FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN,
57: L.LANGUAGE_CODE,
58: userenv('LANG')
59: from FND_LANGUAGES L
60: where L.INSTALLED_FLAG in ('I', 'B')

Line 123: LAST_UPDATE_DATE = FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,

119: begin
120: update FUN_RICH_MESSAGES_B set
121: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
122: CREATED_BY_MODULE = X_CREATED_BY_MODULE,
123: LAST_UPDATE_DATE = FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,
124: LAST_UPDATED_BY = FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY,
125: LAST_UPDATE_LOGIN = FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN
126: where APPLICATION_ID = X_APPLICATION_ID
127: and MESSAGE_NAME = X_MESSAGE_NAME;

Line 124: LAST_UPDATED_BY = FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY,

120: update FUN_RICH_MESSAGES_B set
121: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
122: CREATED_BY_MODULE = X_CREATED_BY_MODULE,
123: LAST_UPDATE_DATE = FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,
124: LAST_UPDATED_BY = FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY,
125: LAST_UPDATE_LOGIN = FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN
126: where APPLICATION_ID = X_APPLICATION_ID
127: and MESSAGE_NAME = X_MESSAGE_NAME;
128:

Line 125: LAST_UPDATE_LOGIN = FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN

121: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
122: CREATED_BY_MODULE = X_CREATED_BY_MODULE,
123: LAST_UPDATE_DATE = FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,
124: LAST_UPDATED_BY = FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY,
125: LAST_UPDATE_LOGIN = FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN
126: where APPLICATION_ID = X_APPLICATION_ID
127: and MESSAGE_NAME = X_MESSAGE_NAME;
128:
129: if (sql%notfound) then

Line 135: LAST_UPDATE_DATE = FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,

131: end if;
132:
133: update FUN_RICH_MESSAGES_TL set
134: MESSAGE_TEXT = X_MESSAGE_TEXT,
135: LAST_UPDATE_DATE = FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,
136: LAST_UPDATED_BY = FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY,
137: LAST_UPDATE_LOGIN = FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN,
138: SOURCE_LANG = userenv('LANG')
139: where APPLICATION_ID = X_APPLICATION_ID

Line 136: LAST_UPDATED_BY = FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY,

132:
133: update FUN_RICH_MESSAGES_TL set
134: MESSAGE_TEXT = X_MESSAGE_TEXT,
135: LAST_UPDATE_DATE = FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,
136: LAST_UPDATED_BY = FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY,
137: LAST_UPDATE_LOGIN = FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN,
138: SOURCE_LANG = userenv('LANG')
139: where APPLICATION_ID = X_APPLICATION_ID
140: and MESSAGE_NAME = X_MESSAGE_NAME

Line 137: LAST_UPDATE_LOGIN = FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN,

133: update FUN_RICH_MESSAGES_TL set
134: MESSAGE_TEXT = X_MESSAGE_TEXT,
135: LAST_UPDATE_DATE = FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,
136: LAST_UPDATED_BY = FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY,
137: LAST_UPDATE_LOGIN = FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN,
138: SOURCE_LANG = userenv('LANG')
139: where APPLICATION_ID = X_APPLICATION_ID
140: and MESSAGE_NAME = X_MESSAGE_NAME
141: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);