1: PACKAGE FUN_RULE_MSG_HANDLER_PKG AUTHID CURRENT_USER AS
2: /* $Header: FUNXTMRULMSGHNS.pls 120.0 2005/06/20 04:29:55 ammishra noship $ */
3:
4: PROCEDURE DoesMessageExist(p_applicationid IN FND_NEW_MESSAGES.APPLICATION_ID%TYPE,
5: p_messagetext IN FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE,
6: p_languagecode IN FND_NEW_MESSAGES.LANGUAGE_CODE%TYPE,
7: p_messagename OUT NOCOPY FND_NEW_MESSAGES.MESSAGE_NAME%TYPE);
8:
1: PACKAGE FUN_RULE_MSG_HANDLER_PKG AUTHID CURRENT_USER AS
2: /* $Header: FUNXTMRULMSGHNS.pls 120.0 2005/06/20 04:29:55 ammishra noship $ */
3:
4: PROCEDURE DoesMessageExist(p_applicationid IN FND_NEW_MESSAGES.APPLICATION_ID%TYPE,
5: p_messagetext IN FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE,
6: p_languagecode IN FND_NEW_MESSAGES.LANGUAGE_CODE%TYPE,
7: p_messagename OUT NOCOPY FND_NEW_MESSAGES.MESSAGE_NAME%TYPE);
8:
9:
2: /* $Header: FUNXTMRULMSGHNS.pls 120.0 2005/06/20 04:29:55 ammishra noship $ */
3:
4: PROCEDURE DoesMessageExist(p_applicationid IN FND_NEW_MESSAGES.APPLICATION_ID%TYPE,
5: p_messagetext IN FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE,
6: p_languagecode IN FND_NEW_MESSAGES.LANGUAGE_CODE%TYPE,
7: p_messagename OUT NOCOPY FND_NEW_MESSAGES.MESSAGE_NAME%TYPE);
8:
9:
10: PROCEDURE CreateNewMessage(p_applicationid IN FND_NEW_MESSAGES.APPLICATION_ID%TYPE,
3:
4: PROCEDURE DoesMessageExist(p_applicationid IN FND_NEW_MESSAGES.APPLICATION_ID%TYPE,
5: p_messagetext IN FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE,
6: p_languagecode IN FND_NEW_MESSAGES.LANGUAGE_CODE%TYPE,
7: p_messagename OUT NOCOPY FND_NEW_MESSAGES.MESSAGE_NAME%TYPE);
8:
9:
10: PROCEDURE CreateNewMessage(p_applicationid IN FND_NEW_MESSAGES.APPLICATION_ID%TYPE,
11: p_ruledetailid IN FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE,
6: p_languagecode IN FND_NEW_MESSAGES.LANGUAGE_CODE%TYPE,
7: p_messagename OUT NOCOPY FND_NEW_MESSAGES.MESSAGE_NAME%TYPE);
8:
9:
10: PROCEDURE CreateNewMessage(p_applicationid IN FND_NEW_MESSAGES.APPLICATION_ID%TYPE,
11: p_ruledetailid IN FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE,
12: p_messagetext IN FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE,
13: p_languagecode IN FND_NEW_MESSAGES.LANGUAGE_CODE%TYPE,
14: p_messagename OUT NOCOPY FND_NEW_MESSAGES.MESSAGE_NAME%TYPE);
8:
9:
10: PROCEDURE CreateNewMessage(p_applicationid IN FND_NEW_MESSAGES.APPLICATION_ID%TYPE,
11: p_ruledetailid IN FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE,
12: p_messagetext IN FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE,
13: p_languagecode IN FND_NEW_MESSAGES.LANGUAGE_CODE%TYPE,
14: p_messagename OUT NOCOPY FND_NEW_MESSAGES.MESSAGE_NAME%TYPE);
15:
16: PROCEDURE GetMessageFromRuleDetail(p_ruledetailid IN FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE,
9:
10: PROCEDURE CreateNewMessage(p_applicationid IN FND_NEW_MESSAGES.APPLICATION_ID%TYPE,
11: p_ruledetailid IN FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE,
12: p_messagetext IN FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE,
13: p_languagecode IN FND_NEW_MESSAGES.LANGUAGE_CODE%TYPE,
14: p_messagename OUT NOCOPY FND_NEW_MESSAGES.MESSAGE_NAME%TYPE);
15:
16: PROCEDURE GetMessageFromRuleDetail(p_ruledetailid IN FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE,
17: p_messagename OUT NOCOPY FND_NEW_MESSAGES.MESSAGE_NAME%TYPE);
10: PROCEDURE CreateNewMessage(p_applicationid IN FND_NEW_MESSAGES.APPLICATION_ID%TYPE,
11: p_ruledetailid IN FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE,
12: p_messagetext IN FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE,
13: p_languagecode IN FND_NEW_MESSAGES.LANGUAGE_CODE%TYPE,
14: p_messagename OUT NOCOPY FND_NEW_MESSAGES.MESSAGE_NAME%TYPE);
15:
16: PROCEDURE GetMessageFromRuleDetail(p_ruledetailid IN FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE,
17: p_messagename OUT NOCOPY FND_NEW_MESSAGES.MESSAGE_NAME%TYPE);
18:
13: p_languagecode IN FND_NEW_MESSAGES.LANGUAGE_CODE%TYPE,
14: p_messagename OUT NOCOPY FND_NEW_MESSAGES.MESSAGE_NAME%TYPE);
15:
16: PROCEDURE GetMessageFromRuleDetail(p_ruledetailid IN FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE,
17: p_messagename OUT NOCOPY FND_NEW_MESSAGES.MESSAGE_NAME%TYPE);
18:
19:
20: PROCEDURE DoUpdateRuleTables(p_ruleobjectid IN FUN_RULE_OBJECTS_B.RULE_OBJECT_ID%TYPE,
21: p_ruledetailid IN FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE,
18:
19:
20: PROCEDURE DoUpdateRuleTables(p_ruleobjectid IN FUN_RULE_OBJECTS_B.RULE_OBJECT_ID%TYPE,
21: p_ruledetailid IN FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE,
22: p_applicationid IN FND_NEW_MESSAGES.APPLICATION_ID%TYPE,
23: p_messagename IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE);
24:
25: PROCEDURE updateExistingMessage(p_ruledetailid IN FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE,
26: p_languagecode IN FND_NEW_MESSAGES.LANGUAGE_CODE%TYPE,
19:
20: PROCEDURE DoUpdateRuleTables(p_ruleobjectid IN FUN_RULE_OBJECTS_B.RULE_OBJECT_ID%TYPE,
21: p_ruledetailid IN FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE,
22: p_applicationid IN FND_NEW_MESSAGES.APPLICATION_ID%TYPE,
23: p_messagename IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE);
24:
25: PROCEDURE updateExistingMessage(p_ruledetailid IN FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE,
26: p_languagecode IN FND_NEW_MESSAGES.LANGUAGE_CODE%TYPE,
27: p_messagetext IN FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE);
22: p_applicationid IN FND_NEW_MESSAGES.APPLICATION_ID%TYPE,
23: p_messagename IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE);
24:
25: PROCEDURE updateExistingMessage(p_ruledetailid IN FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE,
26: p_languagecode IN FND_NEW_MESSAGES.LANGUAGE_CODE%TYPE,
27: p_messagetext IN FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE);
28:
29:
30:
23: p_messagename IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE);
24:
25: PROCEDURE updateExistingMessage(p_ruledetailid IN FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE,
26: p_languagecode IN FND_NEW_MESSAGES.LANGUAGE_CODE%TYPE,
27: p_messagetext IN FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE);
28:
29:
30:
31: