APPS.PQH_SS_UTILITY dependencies on PQH_SS_UTILITY

Line 1: Package body pqh_ss_utility as

1: Package body pqh_ss_utility as
2: /* $Header: pqutlswi.pkb 120.0.12000000.2 2007/06/14 09:13:05 gpurohit noship $*/
3: --
4: CURSOR cur_asgn (c_assignmentId NUMBER, c_effectiveDate DATE) IS
5: SELECT to_char(object_version_number), effective_start_date

Line 231: pqh_ss_utility.check_edit_privilege (

227: p_personId IN NUMBER
228: ,p_businessGroupId IN NUMBER ) return VARCHAR2 is
229: l_editAllowed varchar2(10) := 'N';
230: begin
231: pqh_ss_utility.check_edit_privilege (
232: p_personId =>p_personId
233: ,p_businessGroupId =>p_businessGroupId
234: ,p_editAllowed =>l_editAllowed );
235: return l_editAllowed;

Line 356: PQH_SS_UTILITY.check_edit_privilege (

352: IF ( (INSTR(p_transaction_status,'S') > 0) OR ( p_transaction_status IN ('C','N','W','RI') )) THEN
353: p_edit_privilege := 'Y';
354: ELSE
355: IF ( NVL(fnd_profile.value('PQH_ALLOW_APPROVER_TO_EDIT_TXN'),'N') = 'Y' ) THEN
356: PQH_SS_UTILITY.check_edit_privilege (
357: p_personId => p_person_id
358: ,p_businessGroupId => p_business_group_id
359: ,p_editAllowed => p_edit_privilege);
360: ELSE

Line 580: execute immediate 'begin select '||p_function||'into pqh_ss_utility.l_description from dual; end;';

576: begin
577: if p_function is null then
578: return null;
579: else
580: execute immediate 'begin select '||p_function||'into pqh_ss_utility.l_description from dual; end;';
581: end if;
582: return pqh_ss_utility.l_description;
583: end get_desc;
584:

Line 582: return pqh_ss_utility.l_description;

578: return null;
579: else
580: execute immediate 'begin select '||p_function||'into pqh_ss_utility.l_description from dual; end;';
581: end if;
582: return pqh_ss_utility.l_description;
583: end get_desc;
584:
585: PROCEDURE set_datetrack_mode (
586: p_txnId IN VARCHAR2