41: ,P_ATTRIBUTE20 in VARCHAR2
42: ,P_COMMENTS in VARCHAR2
43: )is
44: begin
45: hr_utility.set_location('Entering: PQH_TXN_JOB_REQUIREMENTS_BK2.UPDATE_TXN_JOB_REQUIREMENT_A', 10);
46: hr_utility.set_location(' Leaving: PQH_TXN_JOB_REQUIREMENTS_BK2.UPDATE_TXN_JOB_REQUIREMENT_A', 20);
47: end UPDATE_TXN_JOB_REQUIREMENT_A;
48: procedure UPDATE_TXN_JOB_REQUIREMENT_B
49: (P_EFFECTIVE_DATE in DATE
42: ,P_COMMENTS in VARCHAR2
43: )is
44: begin
45: hr_utility.set_location('Entering: PQH_TXN_JOB_REQUIREMENTS_BK2.UPDATE_TXN_JOB_REQUIREMENT_A', 10);
46: hr_utility.set_location(' Leaving: PQH_TXN_JOB_REQUIREMENTS_BK2.UPDATE_TXN_JOB_REQUIREMENT_A', 20);
47: end UPDATE_TXN_JOB_REQUIREMENT_A;
48: procedure UPDATE_TXN_JOB_REQUIREMENT_B
49: (P_EFFECTIVE_DATE in DATE
50: ,P_TXN_JOB_REQUIREMENT_ID in NUMBER
84: ,P_ATTRIBUTE20 in VARCHAR2
85: ,P_COMMENTS in VARCHAR2
86: )is
87: begin
88: hr_utility.set_location('Entering: PQH_TXN_JOB_REQUIREMENTS_BK2.UPDATE_TXN_JOB_REQUIREMENT_B', 10);
89: hr_utility.set_location(' Leaving: PQH_TXN_JOB_REQUIREMENTS_BK2.UPDATE_TXN_JOB_REQUIREMENT_B', 20);
90: end UPDATE_TXN_JOB_REQUIREMENT_B;
91: end PQH_TXN_JOB_REQUIREMENTS_BK2;
85: ,P_COMMENTS in VARCHAR2
86: )is
87: begin
88: hr_utility.set_location('Entering: PQH_TXN_JOB_REQUIREMENTS_BK2.UPDATE_TXN_JOB_REQUIREMENT_B', 10);
89: hr_utility.set_location(' Leaving: PQH_TXN_JOB_REQUIREMENTS_BK2.UPDATE_TXN_JOB_REQUIREMENT_B', 20);
90: end UPDATE_TXN_JOB_REQUIREMENT_B;
91: end PQH_TXN_JOB_REQUIREMENTS_BK2;