eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_BDGT_REALLOC_UTILITY dependencies on HR_GENERAL

Line 23: return(hr_general. DECODE_POSITION_LATEST_NAME (p_entity_id ));

19:
20: BEGIN
21:
22: If p_entity_type = 'POSITION' then
23: return(hr_general. DECODE_POSITION_LATEST_NAME (p_entity_id ));
24: elsif p_entity_type = 'JOB' then
25: return(hr_general.DECODE_JOB(p_entity_id));
26: elsif p_entity_type = 'ORGANIZATION' then
27: return(hr_general.DECODE_ORGANIZATION(p_entity_id ));

Line 25: return(hr_general.DECODE_JOB(p_entity_id));

21:
22: If p_entity_type = 'POSITION' then
23: return(hr_general. DECODE_POSITION_LATEST_NAME (p_entity_id ));
24: elsif p_entity_type = 'JOB' then
25: return(hr_general.DECODE_JOB(p_entity_id));
26: elsif p_entity_type = 'ORGANIZATION' then
27: return(hr_general.DECODE_ORGANIZATION(p_entity_id ));
28: elsif p_entity_type = 'GRADE' then
29: return(hr_general.DECODE_GRADE(p_entity_id ));

Line 27: return(hr_general.DECODE_ORGANIZATION(p_entity_id ));

23: return(hr_general. DECODE_POSITION_LATEST_NAME (p_entity_id ));
24: elsif p_entity_type = 'JOB' then
25: return(hr_general.DECODE_JOB(p_entity_id));
26: elsif p_entity_type = 'ORGANIZATION' then
27: return(hr_general.DECODE_ORGANIZATION(p_entity_id ));
28: elsif p_entity_type = 'GRADE' then
29: return(hr_general.DECODE_GRADE(p_entity_id ));
30: end if;
31: END get_entity_name;

Line 29: return(hr_general.DECODE_GRADE(p_entity_id ));

25: return(hr_general.DECODE_JOB(p_entity_id));
26: elsif p_entity_type = 'ORGANIZATION' then
27: return(hr_general.DECODE_ORGANIZATION(p_entity_id ));
28: elsif p_entity_type = 'GRADE' then
29: return(hr_general.DECODE_GRADE(p_entity_id ));
30: end if;
31: END get_entity_name;
32: --
33: ---------------------------GET_PRD_REALLOC_RESERVED_AMT-----------------------------

Line 729: l_next_name := hr_general.decode_lookup(p_lookup_type => 'PQH_BPR_ROUTING',

725: into p_next_name
726: from fnd_user
727: where user_id=p_member_user_id;
728: hr_utility.set_location('user_name is '||p_next_name,10);
729: l_next_name := hr_general.decode_lookup(p_lookup_type => 'PQH_BPR_ROUTING',
730: p_lookup_code => 'USER');
731: hr_utility.set_location('prefix is '||l_next_name,20);
732: p_next_name_display := l_next_name ||':'||p_next_name ;
733: hr_utility.set_location('name is '||p_next_name_display,30);

Line 740: l_next_name := hr_general.decode_lookup(p_lookup_type => 'PQH_BPR_ROUTING',

736: into p_next_name
737: from pqh_roles
738: where role_id= p_member_role_id;
739: hr_utility.set_location('user_name is '||p_next_name,40);
740: l_next_name := hr_general.decode_lookup(p_lookup_type => 'PQH_BPR_ROUTING',
741: p_lookup_code => 'ROLE');
742: hr_utility.set_location('prefix is '||l_next_name,50);
743: p_next_name_display := l_next_name ||':'||p_next_name ;
744: p_next_name := 'PQH_ROLE:'||p_member_role_id;

Line 752: select hr_general.DECODE_POSITION_LATEST_NAME (p_position_id)

748: p_next_name := null;
749: p_next_name_display := null;
750: END IF;
751: ELSIF (p_member_cd = 'P') THEN
752: select hr_general.DECODE_POSITION_LATEST_NAME (p_position_id)
753: into p_next_name from dual;
754: hr_utility.set_location('user_name is '||p_next_name,80);
755: l_next_name := hr_general.decode_lookup(p_lookup_type => 'PQH_BPR_ROUTING',
756: p_lookup_code => 'POSITION');

Line 755: l_next_name := hr_general.decode_lookup(p_lookup_type => 'PQH_BPR_ROUTING',

751: ELSIF (p_member_cd = 'P') THEN
752: select hr_general.DECODE_POSITION_LATEST_NAME (p_position_id)
753: into p_next_name from dual;
754: hr_utility.set_location('user_name is '||p_next_name,80);
755: l_next_name := hr_general.decode_lookup(p_lookup_type => 'PQH_BPR_ROUTING',
756: p_lookup_code => 'POSITION');
757: hr_utility.set_location('prefix is '||l_next_name,90);
758: p_next_name_display := l_next_name ||':'||p_next_name ;
759: p_next_name := 'POS:'||p_position_id;

Line 771: l_next_name := hr_general.decode_lookup(p_lookup_type => 'PQH_BPR_ROUTING',

767: into p_next_name
768: from fnd_user
769: where employee_id=l_person_id;
770: hr_utility.set_location('user_name is '||p_next_name,120);
771: l_next_name := hr_general.decode_lookup(p_lookup_type => 'PQH_BPR_ROUTING',
772: p_lookup_code => 'USER');
773: hr_utility.set_location('prefix is '||l_next_name,130);
774: p_next_name_display := l_next_name ||':'||p_next_name ;
775: hr_utility.set_location('name is '||p_next_name_display,140);

Line 823: ,p_effective_date => hr_general.effective_date

819: --Before Applying a Budget Reallocation Transaction, apply all the Business Rules
820: pqh_cbr_engine.apply_rules(p_transaction_type => 'REALLOCATION'
821: ,p_transaction_id => p_transaction_id
822: ,p_business_group_id => l_pool_rec.business_group_id
823: ,p_effective_date => hr_general.effective_date
824: ,p_status_flag => l_status);
825: hr_utility.set_location('status returned is '||l_status||l_proc,20);
826:
827: IF NVL(l_status,'S') <> 'E'and p_validate_only = 'NO' THEN

Line 829: pqh_budget_pools_api.update_reallocation_folder(p_effective_date=> hr_general.effective_date

825: hr_utility.set_location('status returned is '||l_status||l_proc,20);
826:
827: IF NVL(l_status,'S') <> 'E'and p_validate_only = 'NO' THEN
828: hr_utility.set_location('for folder approval '||l_proc,22);
829: pqh_budget_pools_api.update_reallocation_folder(p_effective_date=> hr_general.effective_date
830: ,p_folder_id => p_transaction_id
831: ,p_object_version_number=>l_pool_rec.object_version_number
832: ,p_business_group_id => l_pool_rec.business_group_id
833: ,p_approval_status=> 'A'

Line 925: hr_general.decode_lookup('PQH_BUDGET_ENTITY',ENTITY_TYPE),

921: l_unit varchar2(80);
922: l_entity_desc varchar2(80);
923: l_transaction_status varchar2(100);
924: cursor csr_pool_dtls is select name,
925: hr_general.decode_lookup('PQH_BUDGET_ENTITY',ENTITY_TYPE),
926: hr_general.decode_shared_type(budget_unit_id),
927: hr_general.decode_lookup('PQH_REALLOC_TXN_STATUS',approval_status)
928: from pqh_budget_pools
929: where pool_id = p_transaction_id;

Line 926: hr_general.decode_shared_type(budget_unit_id),

922: l_entity_desc varchar2(80);
923: l_transaction_status varchar2(100);
924: cursor csr_pool_dtls is select name,
925: hr_general.decode_lookup('PQH_BUDGET_ENTITY',ENTITY_TYPE),
926: hr_general.decode_shared_type(budget_unit_id),
927: hr_general.decode_lookup('PQH_REALLOC_TXN_STATUS',approval_status)
928: from pqh_budget_pools
929: where pool_id = p_transaction_id;
930: BEGIN

Line 927: hr_general.decode_lookup('PQH_REALLOC_TXN_STATUS',approval_status)

923: l_transaction_status varchar2(100);
924: cursor csr_pool_dtls is select name,
925: hr_general.decode_lookup('PQH_BUDGET_ENTITY',ENTITY_TYPE),
926: hr_general.decode_shared_type(budget_unit_id),
927: hr_general.decode_lookup('PQH_REALLOC_TXN_STATUS',approval_status)
928: from pqh_budget_pools
929: where pool_id = p_transaction_id;
930: BEGIN
931: hr_utility.set_location('inside respond notification'||l_proc,10);

Line 981: hr_general.decode_lookup('PQH_BUDGET_ENTITY',ENTITY_TYPE),

977: l_unit varchar2(80);
978: l_entity_desc varchar2(80);
979: l_transaction_status varchar2(100);
980: cursor csr_pool_dtls is select name,
981: hr_general.decode_lookup('PQH_BUDGET_ENTITY',ENTITY_TYPE),
982: hr_general.decode_shared_type(budget_unit_id),
983: hr_general.decode_lookup('PQH_REALLOC_TXN_STATUS',approval_status)
984: from pqh_budget_pools
985: where pool_id = p_transaction_id;

Line 982: hr_general.decode_shared_type(budget_unit_id),

978: l_entity_desc varchar2(80);
979: l_transaction_status varchar2(100);
980: cursor csr_pool_dtls is select name,
981: hr_general.decode_lookup('PQH_BUDGET_ENTITY',ENTITY_TYPE),
982: hr_general.decode_shared_type(budget_unit_id),
983: hr_general.decode_lookup('PQH_REALLOC_TXN_STATUS',approval_status)
984: from pqh_budget_pools
985: where pool_id = p_transaction_id;
986: BEGIN

Line 983: hr_general.decode_lookup('PQH_REALLOC_TXN_STATUS',approval_status)

979: l_transaction_status varchar2(100);
980: cursor csr_pool_dtls is select name,
981: hr_general.decode_lookup('PQH_BUDGET_ENTITY',ENTITY_TYPE),
982: hr_general.decode_shared_type(budget_unit_id),
983: hr_general.decode_lookup('PQH_REALLOC_TXN_STATUS',approval_status)
984: from pqh_budget_pools
985: where pool_id = p_transaction_id;
986: BEGIN
987: hr_utility.set_location('inside warning notification'||l_proc,10);

Line 1016: hr_general.decode_lookup('PQH_BUDGET_ENTITY',ENTITY_TYPE),

1012: l_unit varchar2(80);
1013: l_entity_desc varchar2(80);
1014: l_transaction_status varchar2(100);
1015: cursor csr_pool_dtls is select name,
1016: hr_general.decode_lookup('PQH_BUDGET_ENTITY',ENTITY_TYPE),
1017: hr_general.decode_shared_type(budget_unit_id),
1018: hr_general.decode_lookup('PQH_REALLOC_TXN_STATUS',approval_status)
1019: from pqh_budget_pools
1020: where pool_id = p_transaction_id;

Line 1017: hr_general.decode_shared_type(budget_unit_id),

1013: l_entity_desc varchar2(80);
1014: l_transaction_status varchar2(100);
1015: cursor csr_pool_dtls is select name,
1016: hr_general.decode_lookup('PQH_BUDGET_ENTITY',ENTITY_TYPE),
1017: hr_general.decode_shared_type(budget_unit_id),
1018: hr_general.decode_lookup('PQH_REALLOC_TXN_STATUS',approval_status)
1019: from pqh_budget_pools
1020: where pool_id = p_transaction_id;
1021: BEGIN

Line 1018: hr_general.decode_lookup('PQH_REALLOC_TXN_STATUS',approval_status)

1014: l_transaction_status varchar2(100);
1015: cursor csr_pool_dtls is select name,
1016: hr_general.decode_lookup('PQH_BUDGET_ENTITY',ENTITY_TYPE),
1017: hr_general.decode_shared_type(budget_unit_id),
1018: hr_general.decode_lookup('PQH_REALLOC_TXN_STATUS',approval_status)
1019: from pqh_budget_pools
1020: where pool_id = p_transaction_id;
1021: BEGIN
1022: hr_utility.set_location('Entering'||l_proc,10);

Line 1051: hr_general.decode_lookup('PQH_BUDGET_ENTITY',ENTITY_TYPE),

1047: l_unit varchar2(80);
1048: l_entity_desc varchar2(80);
1049: l_transaction_status varchar2(100);
1050: cursor csr_pool_dtls is select name,
1051: hr_general.decode_lookup('PQH_BUDGET_ENTITY',ENTITY_TYPE),
1052: hr_general.decode_shared_type(budget_unit_id),
1053: hr_general.decode_lookup('PQH_REALLOC_TXN_STATUS',approval_status)
1054: from pqh_budget_pools
1055: where pool_id = p_transaction_id;

Line 1052: hr_general.decode_shared_type(budget_unit_id),

1048: l_entity_desc varchar2(80);
1049: l_transaction_status varchar2(100);
1050: cursor csr_pool_dtls is select name,
1051: hr_general.decode_lookup('PQH_BUDGET_ENTITY',ENTITY_TYPE),
1052: hr_general.decode_shared_type(budget_unit_id),
1053: hr_general.decode_lookup('PQH_REALLOC_TXN_STATUS',approval_status)
1054: from pqh_budget_pools
1055: where pool_id = p_transaction_id;
1056: BEGIN

Line 1053: hr_general.decode_lookup('PQH_REALLOC_TXN_STATUS',approval_status)

1049: l_transaction_status varchar2(100);
1050: cursor csr_pool_dtls is select name,
1051: hr_general.decode_lookup('PQH_BUDGET_ENTITY',ENTITY_TYPE),
1052: hr_general.decode_shared_type(budget_unit_id),
1053: hr_general.decode_lookup('PQH_REALLOC_TXN_STATUS',approval_status)
1054: from pqh_budget_pools
1055: where pool_id = p_transaction_id;
1056: BEGIN
1057: hr_utility.set_location('Entering'||l_proc,10);

Line 1107: pqh_budget_pools_api.update_reallocation_folder(p_effective_date=> hr_general.effective_date

1103: if (p_validate_only = 'YES') then
1104: l_validate := true;
1105: end if;
1106: --
1107: pqh_budget_pools_api.update_reallocation_folder(p_effective_date=> hr_general.effective_date
1108: ,p_folder_id => p_transaction_id
1109: ,p_object_version_number=>l_pool_rec.object_version_number
1110: ,p_business_group_id => l_pool_rec.business_group_id
1111: ,p_approval_status=> 'R'

Line 1245: hr_general.decode_lookup('PQH_BUDGET_ENTITY',ENTITY_TYPE),

1241: l_entity_type varchar2(80);
1242: l_budget_unit varchar2(80);
1243: l_approval_status varchar2(100);
1244: cursor c0 is select name,
1245: hr_general.decode_lookup('PQH_BUDGET_ENTITY',ENTITY_TYPE),
1246: hr_general.decode_shared_type(budget_unit_id),
1247: hr_general.decode_lookup('PQH_REALLOC_TXN_STATUS',approval_status)
1248: from pqh_budget_pools
1249: where pool_id = p_transaction_id;

Line 1246: hr_general.decode_shared_type(budget_unit_id),

1242: l_budget_unit varchar2(80);
1243: l_approval_status varchar2(100);
1244: cursor c0 is select name,
1245: hr_general.decode_lookup('PQH_BUDGET_ENTITY',ENTITY_TYPE),
1246: hr_general.decode_shared_type(budget_unit_id),
1247: hr_general.decode_lookup('PQH_REALLOC_TXN_STATUS',approval_status)
1248: from pqh_budget_pools
1249: where pool_id = p_transaction_id;
1250: BEGIN

Line 1247: hr_general.decode_lookup('PQH_REALLOC_TXN_STATUS',approval_status)

1243: l_approval_status varchar2(100);
1244: cursor c0 is select name,
1245: hr_general.decode_lookup('PQH_BUDGET_ENTITY',ENTITY_TYPE),
1246: hr_general.decode_shared_type(budget_unit_id),
1247: hr_general.decode_lookup('PQH_REALLOC_TXN_STATUS',approval_status)
1248: from pqh_budget_pools
1249: where pool_id = p_transaction_id;
1250: BEGIN
1251: hr_utility.set_location('inside fyi notification'||l_proc,10);

Line 1300: pqh_budget_pools_api.update_reallocation_folder(p_effective_date=> hr_general.effective_date

1296:
1297: if ( l_pool_rec.approval_status = 'T' and (p_action_flag = 'I' OR
1298: p_action_flag = 'F' ))
1299: then
1300: pqh_budget_pools_api.update_reallocation_folder(p_effective_date=> hr_general.effective_date
1301: ,p_folder_id => p_transaction_id
1302: ,p_object_version_number=>l_pool_rec.object_version_number
1303: ,p_business_group_id => l_pool_rec.business_group_id
1304: ,p_approval_status=> 'P'

Line 1554: AND(st.business_group_id = HR_GENERAL.get_business_group_id OR

1550: CURSOR csr_folder_unit_desc IS
1551: SELECT stt.shared_type_name
1552: FROM per_shared_types st, per_shared_types_tl stt
1553: WHERE st.lookup_type = 'BUDGET_MEASUREMENT_TYPE'
1554: AND(st.business_group_id = HR_GENERAL.get_business_group_id OR
1555: st.business_group_id IS NULL)
1556: AND st.shared_type_id = p_budget_unit_id
1557: AND stt.shared_type_id = st.shared_type_id
1558: AND stt.language = USERENV('LANG');