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 PQH_BUDGET_POOLS

Line 13: p_entity_type IN pqh_budget_pools.entity_type%TYPE

9:
10: FUNCTION get_entity_name
11: (
12: p_entity_id IN pqh_bdgt_pool_realloctions.entity_id%TYPE,
13: p_entity_type IN pqh_budget_pools.entity_type%TYPE
14: )
15: RETURN VARCHAR IS
16: /*
17: This function will return the Entity Name.

Line 72: FROM pqh_budget_pools fld,

68: l_reserved_amt NUMBER := 0;
69: /*for donors amount to be picked based on budget period_id */
70: CURSOR csr_donor_amt(p_approval_status IN Varchar2) IS
71: SELECT NVL(sum(trnxamt.reallocation_amt),0), NVL(sum(trnxamt.reserved_amt),0)
72: FROM pqh_budget_pools fld,
73: pqh_budget_pools trnx,
74: pqh_bdgt_pool_realloctions trnxdtl,
75: pqh_bdgt_pool_realloctions trnxamt
76: WHERE fld.pool_id = trnx.parent_pool_id

Line 73: pqh_budget_pools trnx,

69: /*for donors amount to be picked based on budget period_id */
70: CURSOR csr_donor_amt(p_approval_status IN Varchar2) IS
71: SELECT NVL(sum(trnxamt.reallocation_amt),0), NVL(sum(trnxamt.reserved_amt),0)
72: FROM pqh_budget_pools fld,
73: pqh_budget_pools trnx,
74: pqh_bdgt_pool_realloctions trnxdtl,
75: pqh_bdgt_pool_realloctions trnxamt
76: WHERE fld.pool_id = trnx.parent_pool_id
77: AND fld.approval_status=p_approval_status

Line 88: FROM pqh_budget_pools fld,

84:
85: /* for receivers the amount to be picked up based on entity/start date/end date */
86: CURSOR csr_receiver_amt(p_approval_status IN varchar2) IS
87: SELECT NVL(sum(trnxamt.reallocation_amt),0), NVL(sum(trnxamt.reserved_amt),0)
88: FROM pqh_budget_pools fld,
89: pqh_budget_pools trnx,
90: pqh_bdgt_pool_realloctions trnxdtl,
91: pqh_bdgt_pool_realloctions trnxamt
92: WHERE fld.pool_id = trnx.parent_pool_id

Line 89: pqh_budget_pools trnx,

85: /* for receivers the amount to be picked up based on entity/start date/end date */
86: CURSOR csr_receiver_amt(p_approval_status IN varchar2) IS
87: SELECT NVL(sum(trnxamt.reallocation_amt),0), NVL(sum(trnxamt.reserved_amt),0)
88: FROM pqh_budget_pools fld,
89: pqh_budget_pools trnx,
90: pqh_bdgt_pool_realloctions trnxdtl,
91: pqh_bdgt_pool_realloctions trnxamt
92: WHERE fld.pool_id = trnx.parent_pool_id
93: AND fld.budget_unit_id = p_budget_unit_id

Line 184: FROM pqh_budget_pools fld,

180:
181:
182: CURSOR csr_donor_amt(p_approval_status in varchar2) IS
183: SELECT NVL(SUM(trnxamt.reallocation_amt),0), NVL(SUM(trnxamt.reserved_amt),0)
184: FROM pqh_budget_pools fld,
185: pqh_budget_pools trnx,
186: pqh_bdgt_pool_realloctions trnxdtl,
187: pqh_bdgt_pool_realloctions trnxamt
188: WHERE fld.budget_unit_id = p_budget_unit_id

Line 185: pqh_budget_pools trnx,

181:
182: CURSOR csr_donor_amt(p_approval_status in varchar2) IS
183: SELECT NVL(SUM(trnxamt.reallocation_amt),0), NVL(SUM(trnxamt.reserved_amt),0)
184: FROM pqh_budget_pools fld,
185: pqh_budget_pools trnx,
186: pqh_bdgt_pool_realloctions trnxdtl,
187: pqh_bdgt_pool_realloctions trnxamt
188: WHERE fld.budget_unit_id = p_budget_unit_id
189: AND fld.entity_type = p_entity_type

Line 199: FROM pqh_budget_pools fld,

195: AND trnxdtl.reallocation_id = trnxamt.txn_detail_id;
196:
197: CURSOR csr_receiver_amt(p_approval_status in varchar2) IS
198: SELECT NVL(SUM(trnxamt.reallocation_amt),0), NVL(SUM(trnxamt.reserved_amt),0)
199: FROM pqh_budget_pools fld,
200: pqh_budget_pools trnx,
201: pqh_bdgt_pool_realloctions trnxdtl,
202: pqh_bdgt_pool_realloctions trnxamt
203: WHERE fld.budget_unit_id = p_budget_unit_id

Line 200: pqh_budget_pools trnx,

196:
197: CURSOR csr_receiver_amt(p_approval_status in varchar2) IS
198: SELECT NVL(SUM(trnxamt.reallocation_amt),0), NVL(SUM(trnxamt.reserved_amt),0)
199: FROM pqh_budget_pools fld,
200: pqh_budget_pools trnx,
201: pqh_bdgt_pool_realloctions trnxdtl,
202: pqh_bdgt_pool_realloctions trnxamt
203: WHERE fld.budget_unit_id = p_budget_unit_id
204: AND fld.entity_type = p_entity_type

Line 321: p_folder_id IN pqh_budget_pools.pool_id%TYPE

317: --
318:
319: FUNCTION GET_FOLDER_LEVEL_TRANS_AMT
320: (
321: p_folder_id IN pqh_budget_pools.pool_id%TYPE
322: ) RETURN NUMBER IS
323:
324: /* This function returns Transaction Amount for a given Folder Id */
325:

Line 329: From pqh_budget_pools

325:
326: CURSOR csr_transaction_ids
327: IS
328: Select pool_id
329: From pqh_budget_pools
330: Where parent_pool_id= p_folder_id;
331:
332: l_transaction_id number;
333: l_trans_amt number :=0;

Line 443: p_budget_version_id IN pqh_budget_pools.budget_version_id%TYPE,

439: --
440:
441: FUNCTION CHK_APPROVED_FOLDER
442: (
443: p_budget_version_id IN pqh_budget_pools.budget_version_id%TYPE,
444: p_budget_unit_id IN pqh_budget_pools.budget_unit_id%TYPE,
445: p_entity_type IN pqh_budget_pools.entity_type%TYPE,
446: p_approval_status IN pqh_budget_pools.approval_status%Type) RETURN NUMBER IS
447:

Line 444: p_budget_unit_id IN pqh_budget_pools.budget_unit_id%TYPE,

440:
441: FUNCTION CHK_APPROVED_FOLDER
442: (
443: p_budget_version_id IN pqh_budget_pools.budget_version_id%TYPE,
444: p_budget_unit_id IN pqh_budget_pools.budget_unit_id%TYPE,
445: p_entity_type IN pqh_budget_pools.entity_type%TYPE,
446: p_approval_status IN pqh_budget_pools.approval_status%Type) RETURN NUMBER IS
447:
448: /*

Line 445: p_entity_type IN pqh_budget_pools.entity_type%TYPE,

441: FUNCTION CHK_APPROVED_FOLDER
442: (
443: p_budget_version_id IN pqh_budget_pools.budget_version_id%TYPE,
444: p_budget_unit_id IN pqh_budget_pools.budget_unit_id%TYPE,
445: p_entity_type IN pqh_budget_pools.entity_type%TYPE,
446: p_approval_status IN pqh_budget_pools.approval_status%Type) RETURN NUMBER IS
447:
448: /*
449: Approval Status :

Line 446: p_approval_status IN pqh_budget_pools.approval_status%Type) RETURN NUMBER IS

442: (
443: p_budget_version_id IN pqh_budget_pools.budget_version_id%TYPE,
444: p_budget_unit_id IN pqh_budget_pools.budget_unit_id%TYPE,
445: p_entity_type IN pqh_budget_pools.entity_type%TYPE,
446: p_approval_status IN pqh_budget_pools.approval_status%Type) RETURN NUMBER IS
447:
448: /*
449: Approval Status :
450: ================

Line 460: From pqh_budget_pools

456:
457: CURSOR csr_approved_folder
458: IS
459: Select count(pool_id)
460: From pqh_budget_pools
461: Where budget_version_id = p_budget_version_id
462: And budget_unit_id = p_budget_unit_id
463: And entity_type = p_entity_type
464: And approval_status = p_approval_status;

Line 804: FROM pqh_budget_pools

800: l_transaction_category_id NUMBER;
801:
802: Cursor csr_pool_dtls
803: IS SELECT *
804: FROM pqh_budget_pools
805: WHERE pool_id = p_transaction_id;
806: l_pool_rec csr_pool_dtls%ROWTYPE;
807: BEGIN
808: hr_utility.set_location('Entering '||l_proc,10);

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 928: from pqh_budget_pools

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);
932: open csr_pool_dtls;

Line 957: FROM pqh_budget_pools

953: l_url varchar2(1000);
954: l_status varchar2(30) := 'P';
955: Cursor csr_folder_status IS
956: SELECT business_group_id, NVL(approval_status,'P')
957: FROM pqh_budget_pools
958: WHERE pool_id = p_transaction_id;
959: l_business_group_id Number(15);
960: l_proc varchar2(80) := g_package||'url_builder';
961: BEGIN

Line 984: from pqh_budget_pools

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);
988: open csr_pool_dtls;

Line 1019: from pqh_budget_pools

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);
1023: open csr_pool_dtls;

Line 1054: from pqh_budget_pools

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);
1058: open csr_pool_dtls;

Line 1091: FROM pqh_budget_pools

1087: l_validate boolean :=false;
1088: --
1089: Cursor csr_pool_dtls
1090: IS SELECT *
1091: FROM pqh_budget_pools
1092: WHERE pool_id = p_transaction_id;
1093: l_pool_rec csr_pool_dtls%ROWTYPE;
1094: BEGIN
1095: 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 1166: From pqh_budget_pools

1162:
1163: CURSOR csr_bg_id
1164: IS
1165: Select business_group_id
1166: From pqh_budget_pools
1167: Where pool_id = p_transaction_id;
1168:
1169: Cursor csr_seq_no (l_transaction_category_id IN number) IS
1170: Select max(substr(item_key,(length(l_transaction_category_id||'-'||p_transaction_id))+2,6) )

Line 1248: from pqh_budget_pools

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);
1252: open c0;

Line 1280: From pqh_budget_pools

1276: */
1277:
1278: Cursor csr_pool_dtls IS
1279: Select *
1280: From pqh_budget_pools
1281: Where pool_id = p_transaction_id;
1282:
1283: l_pool_rec csr_pool_dtls%ROWTYPE;
1284: l_proc varchar2(72) := g_package||'update_folder_approval_status';

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 1321: From pqh_budget_pools

1317: i.e the folders which are created but not routed.
1318: */
1319: Cursor csr_approval_status_T_folders IS
1320: Select pool_id
1321: From pqh_budget_pools
1322: Where approval_status = 'T'
1323: And business_group_id = p_business_group_id
1324: AND creation_date < sysdate - 2;
1325:

Line 1326: l_folder_id pqh_budget_pools.pool_id%type;

1322: Where approval_status = 'T'
1323: And business_group_id = p_business_group_id
1324: AND creation_date < sysdate - 2;
1325:
1326: l_folder_id pqh_budget_pools.pool_id%type;
1327: l_proc varchar2(72) := g_package ||'bgt_dummy_folder_delete';
1328:
1329: BEGIN
1330:

Line 1341: /* In the procedure pqh_budget_pools_swi.bgt_realloc_delete

1337: hr_utility.set_location('Folder Id :' || l_folder_id ,20);
1338: fetch csr_approval_status_T_folders into l_folder_id;
1339: exit when csr_approval_status_T_folders%NOTFOUND;
1340: If l_folder_id is Not Null Then
1341: /* In the procedure pqh_budget_pools_swi.bgt_realloc_delete
1342: node_type T is marked as Transaction.
1343: So here passed TCF (Tempory Created Folder) as node type
1344: to distinguish with Transaction
1345: */

Line 1347: pqh_budget_pools_swi.bgt_realloc_delete(p_node_type => 'TCF'

1343: So here passed TCF (Tempory Created Folder) as node type
1344: to distinguish with Transaction
1345: */
1346: BEGIN
1347: pqh_budget_pools_swi.bgt_realloc_delete(p_node_type => 'TCF'
1348: ,p_node_id =>l_folder_id);
1349: EXCEPTION
1350: When Others Then
1351: Null;

Line 1417: pqh_budget_pools fld

1413: CURSOR csr_get_bdgt_start_dt IS
1414: select bgt.budget_start_date
1415: from pqh_budgets bgt,
1416: pqh_budget_versions bvr,
1417: pqh_budget_pools fld
1418: where fld.pool_id = p_transaction_id
1419: and fld.budget_version_id = bvr.budget_version_id
1420: and bvr.budget_id = bgt.budget_id;
1421: