1: package body HR_QUESTIONNAIRE_BK2 as
2: /* $Header: hrqsnapi.pkb 120.1.12020000.2 2013/01/07 07:11:44 generated ship $ */
3: -- Code generated by the Oracle HRMS API Hook Pre-processor
4: -- Created on 2013/08/13 18:42:17 (YYYY/MM/DD HH24:MI:SS)
5: procedure UPDATE_QUESTIONNAIRE_A
12: ,P_QUEST_TYPE_CODE in VARCHAR2
13: ,P_EFFECTIVE_DATE in DATE
14: )is
15: begin
16: hr_utility.set_location('Entering: HR_QUESTIONNAIRE_BK2.UPDATE_QUESTIONNAIRE_A', 10);
17: hr_utility.set_location(' Leaving: HR_QUESTIONNAIRE_BK2.UPDATE_QUESTIONNAIRE_A', 20);
18: end UPDATE_QUESTIONNAIRE_A;
19: procedure UPDATE_QUESTIONNAIRE_B
20: (P_EFFECTIVE_DATE in DATE
13: ,P_EFFECTIVE_DATE in DATE
14: )is
15: begin
16: hr_utility.set_location('Entering: HR_QUESTIONNAIRE_BK2.UPDATE_QUESTIONNAIRE_A', 10);
17: hr_utility.set_location(' Leaving: HR_QUESTIONNAIRE_BK2.UPDATE_QUESTIONNAIRE_A', 20);
18: end UPDATE_QUESTIONNAIRE_A;
19: procedure UPDATE_QUESTIONNAIRE_B
20: (P_EFFECTIVE_DATE in DATE
21: ,P_QUESTIONNAIRE_TEMPLATE_ID in NUMBER
26: ,P_TEXT in VARCHAR2
27: ,P_QUEST_TYPE_CODE in VARCHAR2
28: )is
29: begin
30: hr_utility.set_location('Entering: HR_QUESTIONNAIRE_BK2.UPDATE_QUESTIONNAIRE_B', 10);
31: hr_utility.set_location(' Leaving: HR_QUESTIONNAIRE_BK2.UPDATE_QUESTIONNAIRE_B', 20);
32: end UPDATE_QUESTIONNAIRE_B;
33: end HR_QUESTIONNAIRE_BK2;
27: ,P_QUEST_TYPE_CODE in VARCHAR2
28: )is
29: begin
30: hr_utility.set_location('Entering: HR_QUESTIONNAIRE_BK2.UPDATE_QUESTIONNAIRE_B', 10);
31: hr_utility.set_location(' Leaving: HR_QUESTIONNAIRE_BK2.UPDATE_QUESTIONNAIRE_B', 20);
32: end UPDATE_QUESTIONNAIRE_B;
33: end HR_QUESTIONNAIRE_BK2;
29: begin
30: hr_utility.set_location('Entering: HR_QUESTIONNAIRE_BK2.UPDATE_QUESTIONNAIRE_B', 10);
31: hr_utility.set_location(' Leaving: HR_QUESTIONNAIRE_BK2.UPDATE_QUESTIONNAIRE_B', 20);
32: end UPDATE_QUESTIONNAIRE_B;
33: end HR_QUESTIONNAIRE_BK2;