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.7.12010000.2 2008/09/29 17:29:32 jcgeorge ship $ */
3:
4: -- Start CC Change
5:

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

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

Line 378: pa_org_utils.CREATE_ORG_HIERARCHY_DENORM(p_parent_organization_id=> l_parent_org_id

374: end ;
375:
376: if proj_org_true = 'YES' then
377:
378: pa_org_utils.CREATE_ORG_HIERARCHY_DENORM(p_parent_organization_id=> l_parent_org_id
379: , p_child_organization_id => l_child_org_id
380: , p_org_hierarchy_version_id=> x_new_proj_org_version_id
381: , p_pa_org_use_type => 'PROJECTS'
382: , x_err_code => x_err_code

Line 486: pa_org_utils.CREATE_ORG_HIERARCHY_DENORM(p_parent_organization_id=> l_parent_org_id

482: end ;
483:
484: if exp_org_true = 'YES' then
485:
486: pa_org_utils.CREATE_ORG_HIERARCHY_DENORM(p_parent_organization_id=> l_parent_org_id
487: , p_child_organization_id => l_child_org_id
488: , p_org_hierarchy_version_id=> x_new_exp_org_version_id
489: , p_pa_org_use_type => 'EXPENDITURES'
490: , x_err_code => x_err_code

Line 513: pa_org_utils.populate_hierarchy_denorm2

509:
510: /* Bug 2976953 - Changed populate_hierarchy_denorm to populate_hierarchy_denorm2 and also added
511: the parameter p_org_id for that call */
512:
513: pa_org_utils.populate_hierarchy_denorm2
514: ( p_org_version_id => x_new_org_structure_version_id
515: ,p_organization_id_parent=> x_new_start_organization_id
516: ,p_organization_id_child => 1
517: ,p_org_id => x_org_id /* Added this condition for bug 2976953 */

Line 697: pa_org_utils.Create_org_hier_denorm_levels

693: exit when c_get_sub_orgs_sch%notfound;
694:
695: l_clevel := l_child_level + l_parent_level +1 ;
696:
697: pa_org_utils.Create_org_hier_denorm_levels
698: (p_parent_organization_id=> l_tmp_parent_org_id
699: , p_child_organization_id => l_tmp_child_org_id
700: , p_org_hierarchy_version_id=> p_org_version_id
701: , p_pa_org_use_type => 'TP_SCHEDULE'

Line 943: pa_org_utils.CREATE_ORG_HIERARCHY_DENORM(p_parent_organization_id => l_parent_org_id

939: l_proj_org_true := 'N';
940: end;
941:
942: if l_proj_org_true = 'Y' then
943: pa_org_utils.CREATE_ORG_HIERARCHY_DENORM(p_parent_organization_id => l_parent_org_id
944: ,p_child_organization_id =>x_organization_id_child
945: ,p_org_hierarchy_version_id => x_org_version_id
946: ,p_pa_org_use_type => 'PROJECTS'
947: , x_err_code => x_err_code

Line 1051: pa_org_utils.CREATE_ORG_HIERARCHY_DENORM(p_parent_organization_id => l_parent_org_id

1047: exception when no_data_found then
1048: l_exp_org_true := 'N';
1049: end;
1050: if l_exp_org_true = 'Y' then
1051: pa_org_utils.CREATE_ORG_HIERARCHY_DENORM(p_parent_organization_id => l_parent_org_id
1052: ,p_child_organization_id =>x_organization_id_child
1053: ,p_org_hierarchy_version_id => x_org_version_id
1054: ,p_pa_org_use_type => 'EXPENDITURES'
1055: , x_err_code => x_err_code

Line 1101: pa_org_utils.Create_org_hier_denorm_levels

1097: p_child_parent_org_id => l_parent_org_id,
1098: p_start_org_id => l_start_org_id );
1099: end if;
1100:
1101: pa_org_utils.Create_org_hier_denorm_levels
1102: (p_parent_organization_id=> l_parent_org_id
1103: , p_child_organization_id => x_organization_id_child
1104: , p_org_hierarchy_version_id=> x_org_version_id
1105: , p_pa_org_use_type => 'TP_SCHEDULE'

Line 1123: pa_org_utils.populate_reporting_orgs(x_org_version_id ,

1119: /*End bug# 2247737*/
1120:
1121: /* Bug#2643047 - Call to populate reporting orgs in pa_org_hierarchy_denorm table */
1122:
1123: pa_org_utils.populate_reporting_orgs(x_org_version_id ,
1124: x_organization_id_child ,
1125: x_organization_id_parent,
1126: x_err_code ,
1127: x_err_stage,

Line 1200: pa_org_utils.restructure_rpt_orgs_denorm(

1196: close c_get_all_orgs;
1197:
1198: /* Bug#2643047 - call to restructure levels from pa_org_hierarchy_denorm table*/
1199:
1200: pa_org_utils.restructure_rpt_orgs_denorm(
1201: x_org_version_id,
1202: x_err_code ,
1203: x_err_stage,
1204: x_err_stack

Line 1341: pa_org_utils.CREATE_ORG_HIERARCHY_DENORM(p_parent_organization_id => l_parent_org_id

1337: open get_all_orgs;
1338: loop
1339: fetch get_all_orgs into l_parent_org_id;
1340: exit when get_all_orgs%notfound;
1341: pa_org_utils.CREATE_ORG_HIERARCHY_DENORM(p_parent_organization_id => l_parent_org_id
1342: , p_child_organization_id => x_organization_id
1343: , p_org_hierarchy_version_id => v_org_structure_version_id
1344: , p_pa_org_use_type => 'PROJECTS'
1345: , x_err_code => x_err_code

Line 1378: pa_org_utils.CREATE_ORG_HIERARCHY_DENORM ( p_parent_organization_id => v_start_org_id

1374: and org_id = imp_rec.org_id --MOAC Changes: Bug 4363092: Removed nvl usage with org_id
1375: and pa_org_use_type = 'PROJECTS' ;
1376: end if;
1377:
1378: pa_org_utils.CREATE_ORG_HIERARCHY_DENORM ( p_parent_organization_id => v_start_org_id
1379: , p_child_organization_id => x_organization_id
1380: , p_org_hierarchy_version_id => v_org_structure_version_id
1381: , p_pa_org_use_type => 'PROJECTS'
1382: , x_err_code => x_err_code

Line 1461: pa_org_utils.CREATE_ORG_HIERARCHY_DENORM(p_parent_organization_id => l_parent_org_id

1457: open get_all_orgs;
1458: loop
1459: fetch get_all_orgs into l_parent_org_id;
1460: exit when get_all_orgs%notfound;
1461: pa_org_utils.CREATE_ORG_HIERARCHY_DENORM(p_parent_organization_id => l_parent_org_id
1462: , p_child_organization_id => x_organization_id
1463: , p_org_hierarchy_version_id => v_org_structure_version_id
1464: , p_pa_org_use_type => 'EXPENDITURES'
1465: , x_err_code => x_err_code

Line 1498: pa_org_utils.CREATE_ORG_HIERARCHY_DENORM ( p_parent_organization_id => v_start_org_id

1494: and org_id = imp_rec.org_id--MOAC Changes: Bug 4363092: Removed nvl usage with org_id
1495: and pa_org_use_type = 'EXPENDITURES' ;
1496: end if;
1497:
1498: pa_org_utils.CREATE_ORG_HIERARCHY_DENORM ( p_parent_organization_id => v_start_org_id
1499: , p_child_organization_id => x_organization_id
1500: , p_org_hierarchy_version_id => v_org_structure_version_id
1501: , p_pa_org_use_type => 'EXPENDITURES'
1502: , x_err_code => x_err_code

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

2359: l_exist VARCHAR2(1):= null;
2360:
2361: BEGIN
2362:
2363: pa_debug.init_err_stack ('pa_org_utils.Check_Org_In_OrgHierarchy');
2364:
2365: select 'X' into l_exist
2366: from pa_org_hierarchy_denorm
2367: where parent_organization_id = p_organization_id

Line 2382: (p_pkg_name => 'PA_ORG_UTILS',

2378: x_error_message_code := 'PA_ORG_NOT_IN_ORGHIER';
2379:
2380: WHEN OTHERS THEN
2381: fnd_msg_pub.add_exc_msg
2382: (p_pkg_name => 'PA_ORG_UTILS',
2383: p_procedure_name => pa_debug.g_err_stack );
2384: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2385: RAISE;
2386: END Check_Org_In_OrgHierarchy;

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

2395: l_exist VARCHAR2(1):= null;
2396:
2397: BEGIN
2398:
2399: pa_debug.init_err_stack ('pa_org_utils.Check_Org_Type');
2400:
2401: select 'X' into l_exist
2402: from pa_org_hierarchy_denorm
2403: where parent_organization_id = p_organization_id

Line 2421: (p_pkg_name => 'PA_ORG_UTILS',

2417: END IF;
2418:
2419: WHEN OTHERS THEN
2420: fnd_msg_pub.add_exc_msg
2421: (p_pkg_name => 'PA_ORG_UTILS',
2422: p_procedure_name => pa_debug.g_err_stack );
2423: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2424: RAISE;
2425: END Check_Org_Type;

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

2435: l_exist VARCHAR2(1):= null;
2436:
2437: BEGIN
2438:
2439: pa_debug.init_err_stack ('pa_org_utils.Check_OrgHierarchy_Type');
2440:
2441: select 'X' into l_exist
2442: from pa_org_hierarchy_denorm
2443: where org_hierarchy_version_id = p_org_structure_version_id

Line 2461: (p_pkg_name => 'PA_ORG_UTILS',

2457: END IF;
2458:
2459: WHEN OTHERS THEN
2460: fnd_msg_pub.add_exc_msg
2461: (p_pkg_name => 'PA_ORG_UTILS',
2462: p_procedure_name => pa_debug.g_err_stack );
2463: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2464: RAISE;
2465: END Check_OrgHierarchy_Type;

Line 2499: pa_org_utils.populate_hierarchy_denorm(

2495: v_org_version_id := i.version_id;
2496: v_organization_id_parent := i.start_org_id;
2497: v_organization_id_child := 1;
2498:
2499: pa_org_utils.populate_hierarchy_denorm(
2500: p_org_version_id => v_org_version_id
2501: ,p_organization_id_parent => v_organization_id_parent
2502: ,p_organization_id_child => v_organization_id_child
2503: ,x_err_code => v_err_code

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

3061: BEGIN
3062: --Start 5934849
3063: --Get the org_structure_version_id into L_STR_VERSION_ID_TMP tab
3064: --for the rowids in newRows tab
3065: FOR k in pa_org_utils.newRows.first..pa_org_utils.newRows.last Loop
3066: select distinct org_structure_version_id
3067: into L_STR_VERSION_ID_TMP(L_STR_VERSION_ID_TMP.count+1)
3068: from per_org_structure_elements
3069: where

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

3066: select distinct org_structure_version_id
3067: into L_STR_VERSION_ID_TMP(L_STR_VERSION_ID_TMP.count+1)
3068: from per_org_structure_elements
3069: where
3070: ROWID = pa_org_utils.newRows(k);
3071: End loop;
3072:
3073: --Get the distinct rowids into L_STR_VERSION_ID tab
3074: --from L_STR_VERSION_ID_TMP tab

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

3091: l_version_id := L_STR_VERSION_ID(i);
3092: --End 5934849
3093:
3094:
3095: /*FOR i IN 1 .. pa_org_utils.newRows.COUNT LOOP commented for bug 5934849 */
3096:
3097:
3098: /* Fetching the Organization Hierarchy version id, the new parent organization id and child organization id
3099:

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

3099:
3100: SELECT org_structure_version_id, organization_id_parent, organization_id_child
3101: INTO l_version_id, l_new_parent_org_id, l_new_child_org_id
3102: FROM per_org_structure_elements
3103: WHERE ROWID = pa_org_utils.newRows(i); */
3104: maintain_pa_all_org( x_org_version_id => l_version_id,
3105: x_err_code => x_err_code,
3106: x_err_stage => x_err_stage,
3107: x_err_stack => x_err_stack);

Line 3509: pa_org_utils.CREATE_ORG_HIERARCHY_DENORM(p_parent_organization_id=> l_parent_org_id

3505: class_org_true := 'NO';
3506: END ;
3507:
3508: IF class_org_true = 'YES' THEN
3509: pa_org_utils.CREATE_ORG_HIERARCHY_DENORM(p_parent_organization_id=> l_parent_org_id
3510: , p_child_organization_id => l_child_org_id
3511: , p_org_hierarchy_version_id=> p_version_id
3512: , p_pa_org_use_type => p_org_use_type
3513: , x_err_code => x_err_code