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.PA_ORG_UTILS dependencies on PA_ORG_UTILS

Line 1: PACKAGE BODY pa_org_utils AS

1: PACKAGE BODY pa_org_utils AS
2: /* $Header: PAXORUTB.pls 120.17 2011/11/14 10:41:11 djambhek ship $ */
3:
4: -- Start CC Change
5:

Line 286: x_err_stack := x_err_stack || '->Pa_org_utils.maintain_org_history';

282:
283: Begin
284: x_err_code := 0;
285: old_stack := x_err_stack;
286: x_err_stack := x_err_stack || '->Pa_org_utils.maintain_org_history';
287:
288: /* Project Orgs */
289: if ( (nvl(x_old_proj_org_version_id,x_new_proj_org_version_id +1) <> x_new_proj_org_version_id )
290: or

Line 383: pa_org_utils.CREATE_ORG_HIERARCHY_DENORM(p_parent_organization_id=> l_parent_org_id

379: end ;
380:
381: if proj_org_true = 'YES' then
382:
383: pa_org_utils.CREATE_ORG_HIERARCHY_DENORM(p_parent_organization_id=> l_parent_org_id
384: , p_child_organization_id => l_child_org_id
385: , p_org_hierarchy_version_id=> x_new_proj_org_version_id
386: , p_pa_org_use_type => 'PROJECTS'
387: , x_err_code => x_err_code

Line 530: pa_org_utils.CREATE_ORG_HIERARCHY_DENORM(p_parent_organization_id=> l_parent_org_id

526: end ;
527:
528: if exp_org_true = 'YES' then
529:
530: pa_org_utils.CREATE_ORG_HIERARCHY_DENORM(p_parent_organization_id=> l_parent_org_id
531: , p_child_organization_id => l_child_org_id
532: , p_org_hierarchy_version_id=> x_new_exp_org_version_id
533: , p_pa_org_use_type => 'EXPENDITURES'
534: , x_err_code => x_err_code

Line 595: pa_org_utils.populate_hierarchy_denorm2

591:
592: /* Bug 2976953 - Changed populate_hierarchy_denorm to populate_hierarchy_denorm2 and also added
593: the parameter p_org_id for that call */
594:
595: pa_org_utils.populate_hierarchy_denorm2
596: ( p_org_version_id => x_new_org_structure_version_id
597: ,p_organization_id_parent=> x_new_start_organization_id
598: ,p_organization_id_child => 1
599: ,p_org_id => x_org_id /* Added this condition for bug 2976953 */

Line 783: /*pa_org_utils.Create_org_hier_denorm_levels

779: exit when l_child_level_var.count = 0;--8915976
780: close c_get_sub_orgs_sch;
781: -- l_clevel := l_child_level + l_parent_level +1 ;
782:
783: /*pa_org_utils.Create_org_hier_denorm_levels
784: (p_parent_organization_id=> l_tmp_parent_org_id
785: , p_child_organization_id => l_tmp_child_org_id
786: , p_org_hierarchy_version_id=> p_org_version_id
787: , p_pa_org_use_type => 'TP_SCHEDULE'

Line 1074: /* pa_org_utils.CREATE_ORG_HIERARCHY_DENORM(p_parent_organization_id => l_parent_org_id

1070: loop
1071: fetch get_all_orgs BULK COLLECT into l_parent_org_id_var LIMIT 10000;
1072: exit when l_parent_org_id_var.count = 0;--8915976
1073: if l_proj_org_true = 'Y' then
1074: /* pa_org_utils.CREATE_ORG_HIERARCHY_DENORM(p_parent_organization_id => l_parent_org_id
1075: ,p_child_organization_id =>x_organization_id_child
1076: ,p_org_hierarchy_version_id => x_org_version_id
1077: ,p_pa_org_use_type => 'PROJECTS'
1078: , x_err_code => x_err_code

Line 1218: /*pa_org_utils.CREATE_ORG_HIERARCHY_DENORM(p_parent_organization_id => l_parent_org_id

1214: loop
1215: fetch get_all_orgs BULK COLLECT into l_parent_org_id_var LIMIT 10000;
1216: exit when l_parent_org_id_var.count = 0;--8915976
1217: if l_exp_org_true = 'Y' then
1218: /*pa_org_utils.CREATE_ORG_HIERARCHY_DENORM(p_parent_organization_id => l_parent_org_id
1219: ,p_child_organization_id =>x_organization_id_child
1220: ,p_org_hierarchy_version_id => x_org_version_id
1221: ,p_pa_org_use_type => 'EXPENDITURES'
1222: , x_err_code => x_err_code

Line 1307: pa_org_utils.Create_org_hier_denorm_levels

1303: p_child_parent_org_id => l_parent_org_id,
1304: p_start_org_id => l_start_org_id );
1305: end if;
1306:
1307: pa_org_utils.Create_org_hier_denorm_levels
1308: (p_parent_organization_id=> l_parent_org_id
1309: , p_child_organization_id => x_organization_id_child
1310: , p_org_hierarchy_version_id=> x_org_version_id
1311: , p_pa_org_use_type => 'TP_SCHEDULE'

Line 1329: pa_org_utils.populate_reporting_orgs(x_org_version_id ,

1325: /*End bug# 2247737*/
1326:
1327: /* Bug#2643047 - Call to populate reporting orgs in pa_org_hierarchy_denorm table */
1328:
1329: pa_org_utils.populate_reporting_orgs(x_org_version_id ,
1330: x_organization_id_child ,
1331: x_organization_id_parent,
1332: x_err_code ,
1333: x_err_stage,

Line 1406: pa_org_utils.restructure_rpt_orgs_denorm(

1402: close c_get_all_orgs;
1403:
1404: /* Bug#2643047 - call to restructure levels from pa_org_hierarchy_denorm table*/
1405:
1406: pa_org_utils.restructure_rpt_orgs_denorm(
1407: x_org_version_id,
1408: x_err_code ,
1409: x_err_stage,
1410: x_err_stack

Line 1547: pa_org_utils.CREATE_ORG_HIERARCHY_DENORM(p_parent_organization_id => l_parent_org_id

1543: open get_all_orgs;
1544: loop
1545: fetch get_all_orgs into l_parent_org_id;
1546: exit when get_all_orgs%notfound;
1547: pa_org_utils.CREATE_ORG_HIERARCHY_DENORM(p_parent_organization_id => l_parent_org_id
1548: , p_child_organization_id => x_organization_id
1549: , p_org_hierarchy_version_id => v_org_structure_version_id
1550: , p_pa_org_use_type => 'PROJECTS'
1551: , x_err_code => x_err_code

Line 1584: pa_org_utils.CREATE_ORG_HIERARCHY_DENORM ( p_parent_organization_id => v_start_org_id

1580: and org_id = imp_rec.org_id --MOAC Changes: Bug 4363092: Removed nvl usage with org_id
1581: and pa_org_use_type = 'PROJECTS' ;
1582: end if;
1583:
1584: pa_org_utils.CREATE_ORG_HIERARCHY_DENORM ( p_parent_organization_id => v_start_org_id
1585: , p_child_organization_id => x_organization_id
1586: , p_org_hierarchy_version_id => v_org_structure_version_id
1587: , p_pa_org_use_type => 'PROJECTS'
1588: , x_err_code => x_err_code

Line 1667: pa_org_utils.CREATE_ORG_HIERARCHY_DENORM(p_parent_organization_id => l_parent_org_id

1663: open get_all_orgs;
1664: loop
1665: fetch get_all_orgs into l_parent_org_id;
1666: exit when get_all_orgs%notfound;
1667: pa_org_utils.CREATE_ORG_HIERARCHY_DENORM(p_parent_organization_id => l_parent_org_id
1668: , p_child_organization_id => x_organization_id
1669: , p_org_hierarchy_version_id => v_org_structure_version_id
1670: , p_pa_org_use_type => 'EXPENDITURES'
1671: , x_err_code => x_err_code

Line 1704: pa_org_utils.CREATE_ORG_HIERARCHY_DENORM ( p_parent_organization_id => v_start_org_id

1700: and org_id = imp_rec.org_id--MOAC Changes: Bug 4363092: Removed nvl usage with org_id
1701: and pa_org_use_type = 'EXPENDITURES' ;
1702: end if;
1703:
1704: pa_org_utils.CREATE_ORG_HIERARCHY_DENORM ( p_parent_organization_id => v_start_org_id
1705: , p_child_organization_id => x_organization_id
1706: , p_org_hierarchy_version_id => v_org_structure_version_id
1707: , p_pa_org_use_type => 'EXPENDITURES'
1708: , x_err_code => x_err_code

Line 2570: pa_debug.init_err_stack ('pa_org_utils.Check_Org_In_OrgHierarchy');

2566: l_exist VARCHAR2(1):= null;
2567:
2568: BEGIN
2569:
2570: pa_debug.init_err_stack ('pa_org_utils.Check_Org_In_OrgHierarchy');
2571:
2572: select 'X' into l_exist
2573: from pa_org_hierarchy_denorm
2574: where parent_organization_id = p_organization_id

Line 2589: (p_pkg_name => 'PA_ORG_UTILS',

2585: x_error_message_code := 'PA_ORG_NOT_IN_ORGHIER';
2586:
2587: WHEN OTHERS THEN
2588: fnd_msg_pub.add_exc_msg
2589: (p_pkg_name => 'PA_ORG_UTILS',
2590: p_procedure_name => pa_debug.g_err_stack );
2591: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2592: RAISE;
2593: END Check_Org_In_OrgHierarchy;

Line 2606: pa_debug.init_err_stack ('pa_org_utils.Check_Org_Type');

2602: l_exist VARCHAR2(1):= null;
2603:
2604: BEGIN
2605:
2606: pa_debug.init_err_stack ('pa_org_utils.Check_Org_Type');
2607:
2608: select 'X' into l_exist
2609: from pa_org_hierarchy_denorm
2610: where parent_organization_id = p_organization_id

Line 2628: (p_pkg_name => 'PA_ORG_UTILS',

2624: END IF;
2625:
2626: WHEN OTHERS THEN
2627: fnd_msg_pub.add_exc_msg
2628: (p_pkg_name => 'PA_ORG_UTILS',
2629: p_procedure_name => pa_debug.g_err_stack );
2630: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2631: RAISE;
2632: END Check_Org_Type;

Line 2646: pa_debug.init_err_stack ('pa_org_utils.Check_OrgHierarchy_Type');

2642: l_exist VARCHAR2(1):= null;
2643:
2644: BEGIN
2645:
2646: pa_debug.init_err_stack ('pa_org_utils.Check_OrgHierarchy_Type');
2647:
2648: select 'X' into l_exist
2649: from pa_org_hierarchy_denorm
2650: where org_hierarchy_version_id = p_org_structure_version_id

Line 2668: (p_pkg_name => 'PA_ORG_UTILS',

2664: END IF;
2665:
2666: WHEN OTHERS THEN
2667: fnd_msg_pub.add_exc_msg
2668: (p_pkg_name => 'PA_ORG_UTILS',
2669: p_procedure_name => pa_debug.g_err_stack );
2670: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2671: RAISE;
2672: END Check_OrgHierarchy_Type;

Line 2706: pa_org_utils.populate_hierarchy_denorm(

2702: v_org_version_id := i.version_id;
2703: v_organization_id_parent := i.start_org_id;
2704: v_organization_id_child := 1;
2705:
2706: pa_org_utils.populate_hierarchy_denorm(
2707: p_org_version_id => v_org_version_id
2708: ,p_organization_id_parent => v_organization_id_parent
2709: ,p_organization_id_child => v_organization_id_child
2710: ,x_err_code => v_err_code

Line 3272: FOR k in pa_org_utils.newRows.first..pa_org_utils.newRows.last Loop

3268: BEGIN
3269: --Start 5934849
3270: --Get the org_structure_version_id into L_STR_VERSION_ID_TMP tab
3271: --for the rowids in newRows tab
3272: FOR k in pa_org_utils.newRows.first..pa_org_utils.newRows.last Loop
3273: select distinct org_structure_version_id
3274: into L_STR_VERSION_ID_TMP(L_STR_VERSION_ID_TMP.count+1)
3275: from per_org_structure_elements
3276: where

Line 3277: ROWID = pa_org_utils.newRows(k);

3273: select distinct org_structure_version_id
3274: into L_STR_VERSION_ID_TMP(L_STR_VERSION_ID_TMP.count+1)
3275: from per_org_structure_elements
3276: where
3277: ROWID = pa_org_utils.newRows(k);
3278: End loop;
3279:
3280: --Get the distinct rowids into L_STR_VERSION_ID tab
3281: --from L_STR_VERSION_ID_TMP tab

Line 3302: /FOR i IN 1 .. pa_org_utils.newRows.COUNT LOOP commented for bug 5934849 /

3298: l_version_id := L_STR_VERSION_ID(i);
3299: --End 5934849
3300:
3301:
3302: /*FOR i IN 1 .. pa_org_utils.newRows.COUNT LOOP commented for bug 5934849 */
3303:
3304:
3305: /* Fetching the Organization Hierarchy version id, the new parent organization id and child organization id
3306:

Line 3310: WHERE ROWID = pa_org_utils.newRows(i); */

3306:
3307: SELECT org_structure_version_id, organization_id_parent, organization_id_child
3308: INTO l_version_id, l_new_parent_org_id, l_new_child_org_id
3309: FROM per_org_structure_elements
3310: WHERE ROWID = pa_org_utils.newRows(i); */
3311: maintain_pa_all_org( x_org_version_id => l_version_id,
3312: x_err_code => x_err_code,
3313: x_err_stage => x_err_stage,
3314: x_err_stack => x_err_stack);

Line 3722: pa_org_utils.CREATE_ORG_HIERARCHY_DENORM(p_parent_organization_id=> l_parent_org_id

3718: class_org_true := 'NO';
3719: END ;
3720:
3721: IF class_org_true = 'YES' THEN
3722: pa_org_utils.CREATE_ORG_HIERARCHY_DENORM(p_parent_organization_id=> l_parent_org_id
3723: , p_child_organization_id => l_child_org_id
3724: , p_org_hierarchy_version_id=> p_version_id
3725: , p_pa_org_use_type => p_org_use_type
3726: , x_err_code => x_err_code