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.AMW_ORG_HIERARCHY_PKG dependencies on DUAL

Line 2489: select p_process_id from dual

2485: start with child_id = p_process_id and organization_id = p_org_id
2486: connect by prior parent_id = child_id
2487: and organization_id = p_org_id
2488: union all
2489: select p_process_id from dual
2490: )
2491: and end_date is null
2492: );
2493: --ko replacing the below clause for removing amw_org_hierarchy_denorm usage...

Line 2507: select p_process_id from dual);

2503: and hierarchy_type = 'L'
2504: )
2505: and end_date is null
2506: union
2507: select p_process_id from dual);
2508: */
2509: cursor c2 is
2510: select process_id
2511: from amw_process_organization

Line 2548: and hierarchy_type = 'L' ) union (select x(ctr) from dual) )

2544: from amw_org_hierarchy_denorm
2545: where process_id = x(ctr)
2546: and organization_id = p_org_id
2547: and up_down_ind = 'D'
2548: and hierarchy_type = 'L' ) union (select x(ctr) from dual) )
2549: */
2550: and deletion_date is null
2551: and object_type = 'PROCESS_ORG'
2552: ) ),last_update_date = sysdate

Line 2583: select p_process_id from dual

2579: start with child_id = p_process_id and organization_id = p_org_id
2580: connect by prior parent_id = child_id
2581: and organization_id = p_org_id
2582: union all
2583: select p_process_id from dual
2584: )
2585: and end_date is null;
2586: --ko replacing the below clause for removing amw_org_hierarchy_denorm usage...
2587: /*

Line 2600: select p_process_id from dual);

2596: and hierarchy_type = 'L'
2597: )
2598: and end_date is null
2599: union
2600: select p_process_id from dual);
2601: */
2602:
2603: cursor c2 is
2604: select process_id

Line 2641: and hierarchy_type = 'L' ) union (select x(ctr) from dual)

2637: from amw_org_hierarchy_denorm
2638: where process_id = x(ctr)
2639: and organization_id = p_org_id
2640: and up_down_ind = 'D'
2641: and hierarchy_type = 'L' ) union (select x(ctr) from dual)
2642: )
2643: */
2644: and deletion_date is null
2645: and object_type = 'RISK_ORG'

Line 2672: select p_process_id from dual

2668: and start_date is not null and end_date is null
2669: connect by prior parent_id = child_id and organization_id = p_org_id
2670: and start_date is not null and end_date is null
2671: union all
2672: select p_process_id from dual
2673: )
2674: and end_date is null;
2675: --ko replacing the below clause for removing amw_org_hierarchy_denorm usage...
2676: /*

Line 2689: select p_process_id from dual);

2685: and hierarchy_type = 'A'
2686: )
2687: and end_date is null
2688: union
2689: select p_process_id from dual);
2690: */
2691: cursor c2 is
2692: select process_id
2693: from amw_process_organization

Line 2732: and hierarchy_type = 'A' ) union (select x(ctr) from dual)

2728: from amw_org_hierarchy_denorm
2729: where process_id = x(ctr)
2730: and organization_id = p_org_id
2731: and up_down_ind = 'D'
2732: and hierarchy_type = 'A' ) union (select x(ctr) from dual)
2733: )
2734: */
2735: and approval_date is not null
2736: and deletion_approval_date is null

Line 2767: select p_process_id from dual

2763: and start_date is not null and end_date is null
2764: connect by prior parent_id = child_id and organization_id = p_org_id
2765: and start_date is not null and end_date is null
2766: union all
2767: select p_process_id from dual
2768: )
2769: and end_date is null;
2770: --ko replacing the below clause for removing amw_org_hierarchy_denorm usage...
2771: /*

Line 2784: select p_process_id from dual);

2780: and hierarchy_type = 'A'
2781: )
2782: and end_date is null
2783: union
2784: select p_process_id from dual);
2785: */
2786: cursor c2 is
2787: select process_id
2788: from amw_process_organization

Line 2828: and hierarchy_type = 'A' ) union (select x(ctr) from dual)

2824: from amw_org_hierarchy_denorm
2825: where process_id = x(ctr)
2826: and organization_id = p_org_id
2827: and up_down_ind = 'D'
2828: and hierarchy_type = 'A' ) union (select x(ctr) from dual)
2829: )
2830: */
2831: and approval_date is not null
2832: and deletion_approval_date is null

Line 2866: select pid process_to_count from dual;

2862: where process_id = pid
2863: and up_down_ind = 'D'
2864: and hierarchy_type = 'A'
2865: union
2866: select pid process_to_count from dual;
2867:
2868: cursor c2(pid number, orgName varchar2) is
2869: select aauv.organization_id,
2870: name

Line 2920: select pid process_to_count from dual;

2916: where process_id = pid
2917: and up_down_ind = 'D'
2918: and hierarchy_type = 'A'
2919: union
2920: select pid process_to_count from dual;
2921:
2922:
2923: type t_audit_unit_rec is record (organization_id amw_audit_units_v.organization_id%type,
2924: org_name amw_audit_units_v.name%type);

Line 3036: select p_process_id process_to_count from dual);

3032: where APHD.process_id = p_process_id
3033: and APHD.up_down_ind = 'D'
3034: and APHD.hierarchy_type = 'A'
3035: union
3036: select p_process_id process_to_count from dual);
3037:
3038: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3039: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3040: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.PUSH_PROC_ORG_SRS.Update_ORG_Counts','UPDATED');

Line 3064: and AOH.hierarchy_type = 'L' ) union all (select APO.PROCESS_ID from dual)

3060: from amw_org_hierarchy_denorm AOH
3061: where AOH.process_id = APO.PROCESS_ID
3062: and AOH.organization_id = APO.ORGANIZATION_ID
3063: and AOH.up_down_ind = 'D'
3064: and AOH.hierarchy_type = 'L' ) union all (select APO.PROCESS_ID from dual)
3065: )
3066: */
3067: and ARA.deletion_date is null
3068: and ARA.object_type = 'PROCESS_ORG'

Line 3084: and AOH.hierarchy_type = 'L' ) union all (select APO.PROCESS_ID from dual)

3080: from amw_org_hierarchy_denorm AOH
3081: where AOH.process_id = APO.PROCESS_ID
3082: and AOH.organization_id = APO.ORGANIZATION_ID
3083: and AOH.up_down_ind = 'D'
3084: and AOH.hierarchy_type = 'L' ) union all (select APO.PROCESS_ID from dual)
3085: )
3086: */
3087: and ACA.deletion_date is null
3088: and ACA.object_type = 'RISK_ORG'

Line 3117: and AOH.hierarchy_type = 'L' ) union all (select APO.PROCESS_ID from dual)

3113: from amw_org_hierarchy_denorm AOH
3114: where AOH.process_id = APO.PROCESS_ID
3115: and AOH.organization_id = APO.ORGANIZATION_ID
3116: and AOH.up_down_ind = 'D'
3117: and AOH.hierarchy_type = 'L' ) union all (select APO.PROCESS_ID from dual)
3118: )
3119: */
3120: and ARA.deletion_date is null
3121: and ARA.object_type = 'PROCESS_ORG'

Line 3138: and AOH.hierarchy_type = 'L' ) union all (select APO.PROCESS_ID from dual)

3134: from amw_org_hierarchy_denorm AOH
3135: where AOH.process_id = APO.PROCESS_ID
3136: and AOH.organization_id = APO.ORGANIZATION_ID
3137: and AOH.up_down_ind = 'D'
3138: and AOH.hierarchy_type = 'L' ) union all (select APO.PROCESS_ID from dual)
3139: )
3140: */
3141: and ACA.deletion_date is null
3142: and ACA.object_type = 'RISK_ORG'

Line 3186: and AOH.hierarchy_type = 'A' ) union all (select APO.PROCESS_ID from dual)

3182: from amw_org_hierarchy_denorm AOH
3183: where AOH.process_id = APO.PROCESS_ID
3184: and AOH.organization_id = APO.ORGANIZATION_ID
3185: and AOH.up_down_ind = 'D'
3186: and AOH.hierarchy_type = 'A' ) union all (select APO.PROCESS_ID from dual)
3187: )
3188: */
3189: and ARA.approval_date is not null
3190: and ARA.deletion_approval_date is null

Line 3210: and AOH.hierarchy_type = 'A' ) union all (select APO.PROCESS_ID from dual)

3206: from amw_org_hierarchy_denorm AOH
3207: where AOH.process_id = APO.PROCESS_ID
3208: and AOH.organization_id = APO.ORGANIZATION_ID
3209: and AOH.up_down_ind = 'D'
3210: and AOH.hierarchy_type = 'A' ) union all (select APO.PROCESS_ID from dual)
3211: )
3212: */
3213: and ACA.approval_date is not null
3214: and ACA.deletion_approval_date is null

Line 3247: and AOH.hierarchy_type = 'A' ) union all (select APO.PROCESS_ID from dual)

3243: from amw_org_hierarchy_denorm AOH
3244: where AOH.process_id = APO.PROCESS_ID
3245: and AOH.organization_id = APO.ORGANIZATION_ID
3246: and AOH.up_down_ind = 'D'
3247: and AOH.hierarchy_type = 'A' ) union all (select APO.PROCESS_ID from dual)
3248: )
3249: */
3250: and ARA.approval_date is not null
3251: and ARA.deletion_approval_date is null

Line 3271: and AOH.hierarchy_type = 'A' ) union all (select APO.PROCESS_ID from dual)

3267: from amw_org_hierarchy_denorm AOH
3268: where AOH.process_id = APO.PROCESS_ID
3269: and AOH.organization_id = APO.ORGANIZATION_ID
3270: and AOH.up_down_ind = 'D'
3271: and AOH.hierarchy_type = 'A' ) union all (select APO.PROCESS_ID from dual)
3272: )
3273: */
3274: and ACA.approval_date is not null
3275: and ACA.deletion_approval_date is null

Line 3445: select pid process_to_count from dual;

3441: where process_id = pid
3442: and up_down_ind = 'D'
3443: and hierarchy_type = 'A'
3444: union
3445: select pid process_to_count from dual;
3446:
3447: type t_tn is table of number;
3448:
3449: x_ptbl t_tn;

Line 3612: and hierarchy_type = 'L' ) union (select l_procs_tbl(ctr) from dual)

3608: from amw_org_hierarchy_denorm
3609: where process_id = l_procs_tbl(ctr)
3610: and organization_id = l_orgs_tbl(ctr)
3611: and up_down_ind = 'D'
3612: and hierarchy_type = 'L' ) union (select l_procs_tbl(ctr) from dual)
3613: )
3614: */
3615: and deletion_date is null
3616: and object_type = 'PROCESS_ORG'

Line 3633: and hierarchy_type = 'L' ) union (select l_procs_tbl(ctr) from dual)

3629: from amw_org_hierarchy_denorm
3630: where process_id = l_procs_tbl(ctr)
3631: and organization_id = l_orgs_tbl(ctr)
3632: and up_down_ind = 'D'
3633: and hierarchy_type = 'L' ) union (select l_procs_tbl(ctr) from dual)
3634: )
3635: */
3636: and deletion_date is null
3637: and object_type = 'RISK_ORG'

Line 3670: and hierarchy_type = 'A' ) union (select l_procs_tbl(ctr) from dual)

3666: from amw_org_hierarchy_denorm
3667: where process_id = l_procs_tbl(ctr)
3668: and organization_id = l_orgs_tbl(ctr)
3669: and up_down_ind = 'D'
3670: and hierarchy_type = 'A' ) union (select l_procs_tbl(ctr) from dual)
3671: )
3672: */
3673: and approval_date is not null
3674: and deletion_approval_date is null

Line 3694: and hierarchy_type = 'A' ) union (select l_procs_tbl(ctr) from dual)

3690: from amw_org_hierarchy_denorm
3691: where process_id = l_procs_tbl(ctr)
3692: and organization_id = l_orgs_tbl(ctr)
3693: and up_down_ind = 'D'
3694: and hierarchy_type = 'A' ) union (select l_procs_tbl(ctr) from dual)
3695: )
3696: */
3697: and approval_date is not null
3698: and deletion_approval_date is null

Line 3775: select pid process_to_count from dual;

3771: where process_id = pid
3772: and up_down_ind = 'D'
3773: and hierarchy_type = 'A'
3774: union
3775: select pid process_to_count from dual;
3776:
3777: L_API_NAME CONSTANT VARCHAR2(30) := 'push_proc_org';
3778: l_return_status varchar2(10);
3779: l_msg_count number;

Line 3802: select LTRIM(l_org_string, '1234567890') into str from dual;

3798:
3799:
3800: l_org_string := p_org_id_string;
3801: while LENGTH(l_org_string) <> 0 loop
3802: select LTRIM(l_org_string, '1234567890') into str from dual;
3803: diff := LENGTH(l_org_string) - LENGTH(str);
3804: if LENGTH(str) is null then diff := LENGTH(l_org_string); end if;
3805: select SUBSTR(l_org_string, 1, diff) into orgstr from dual;
3806: orgid := to_number(orgstr);

Line 3805: select SUBSTR(l_org_string, 1, diff) into orgstr from dual;

3801: while LENGTH(l_org_string) <> 0 loop
3802: select LTRIM(l_org_string, '1234567890') into str from dual;
3803: diff := LENGTH(l_org_string) - LENGTH(str);
3804: if LENGTH(str) is null then diff := LENGTH(l_org_string); end if;
3805: select SUBSTR(l_org_string, 1, diff) into orgstr from dual;
3806: orgid := to_number(orgstr);
3807:
3808: push_proc_per_org(
3809: p_parent_orgprocess_id => p_parent_orgprocess_id,

Line 3841: select LTRIM(str, 'x') into l_org_string from dual;

3837: AMW_PROC_ORG_APPROVAL_PKG.approve(p_process_id, orgid,p_update_count);
3838: end if;
3839:
3840:
3841: select LTRIM(str, 'x') into l_org_string from dual;
3842: end loop;
3843:
3844: IF (p_update_count = FND_API.G_TRUE) THEN
3845: -- update the org counts of the child process and its hierarchy....

Line 4038: select pid process_to_count from dual;

4034: where process_id = pid
4035: and up_down_ind = 'D'
4036: and hierarchy_type = 'A'
4037: union
4038: select pid process_to_count from dual;
4039:
4040: L_API_NAME CONSTANT VARCHAR2(30) := 'Add_organization_child';
4041: l_dummy NUMBER;
4042:

Line 7856: select LTRIM(l_org_string, '1234567890') into str from dual;

7852:
7853:
7854: l_org_string := p_org_id_string;
7855: while LENGTH(l_org_string) <> 0 loop
7856: select LTRIM(l_org_string, '1234567890') into str from dual;
7857: diff := LENGTH(l_org_string) - LENGTH(str);
7858: if LENGTH(str) is null then diff := LENGTH(l_org_string); end if;
7859: select SUBSTR(l_org_string, 1, diff) into orgstr from dual;
7860: orgid := to_number(orgstr);

Line 7859: select SUBSTR(l_org_string, 1, diff) into orgstr from dual;

7855: while LENGTH(l_org_string) <> 0 loop
7856: select LTRIM(l_org_string, '1234567890') into str from dual;
7857: diff := LENGTH(l_org_string) - LENGTH(str);
7858: if LENGTH(str) is null then diff := LENGTH(l_org_string); end if;
7859: select SUBSTR(l_org_string, 1, diff) into orgstr from dual;
7860: orgid := to_number(orgstr);
7861:
7862: synchronize_process(p_org_id => orgid,
7863: p_process_id => p_process_id,

Line 7882: select LTRIM(str, 'x') into l_org_string from dual;

7878:
7879:
7880:
7881:
7882: select LTRIM(str, 'x') into l_org_string from dual;
7883: end loop;
7884:
7885: -- update the org counts of the child process and its hierarchy....
7886: for descendents_rec in c1(p_process_id) loop

Line 8032: select LTRIM(l_child_string, '1234567890') into str from dual;

8028: end if;
8029:
8030: l_child_string := p_child_id_string;
8031: while LENGTH(l_child_string) <> 0 loop
8032: select LTRIM(l_child_string, '1234567890') into str from dual;
8033: diff := LENGTH(l_child_string) - LENGTH(str);
8034: if LENGTH(str) is null then
8035: diff := LENGTH(l_child_string);
8036: end if;

Line 8037: select SUBSTR(l_child_string, 1, diff) into childstr from dual;

8033: diff := LENGTH(l_child_string) - LENGTH(str);
8034: if LENGTH(str) is null then
8035: diff := LENGTH(l_child_string);
8036: end if;
8037: select SUBSTR(l_child_string, 1, diff) into childstr from dual;
8038: l_child_id := to_number(childstr);
8039:
8040: delete from amw_latest_hierarchies
8041: where parent_id = p_parent_process_id

Line 8045: select LTRIM(str, 'x') into l_child_string from dual;

8041: where parent_id = p_parent_process_id
8042: and child_id = l_child_id
8043: and organization_id = p_organization_id;
8044:
8045: select LTRIM(str, 'x') into l_child_string from dual;
8046: end loop;
8047: exception
8048: WHEN FND_API.G_EXC_ERROR THEN
8049: ROLLBACK;

Line 8101: select LTRIM(l_child_string, '1234567890') into str from dual;

8097: end if;
8098:
8099: l_child_string := p_child_id_string;
8100: while LENGTH(l_child_string) <> 0 loop
8101: select LTRIM(l_child_string, '1234567890') into str from dual;
8102: diff := LENGTH(l_child_string) - LENGTH(str);
8103: if LENGTH(str) is null then
8104: diff := LENGTH(l_child_string);
8105: end if;

Line 8106: select SUBSTR(l_child_string, 1, diff) into childstr from dual;

8102: diff := LENGTH(l_child_string) - LENGTH(str);
8103: if LENGTH(str) is null then
8104: diff := LENGTH(l_child_string);
8105: end if;
8106: select SUBSTR(l_child_string, 1, diff) into childstr from dual;
8107: l_child_id := to_number(childstr);
8108:
8109: produce_err_if_circular(
8110: p_org_id => p_organization_id,

Line 8128: select LTRIM(str, 'x') into l_child_string from dual;

8124: p_child_id => l_child_id,
8125: p_instance_id => l_child_order_num);
8126:
8127:
8128: select LTRIM(str, 'x') into l_child_string from dual;
8129: end loop;
8130: exception
8131: WHEN FND_API.G_EXC_ERROR THEN
8132: ROLLBACK;

Line 8175: select pid process_to_count from dual;

8171: where process_id = pid
8172: and up_down_ind = 'D'
8173: and hierarchy_type = 'A'
8174: union
8175: select pid process_to_count from dual;
8176: begin
8177:
8178: x_return_status := FND_API.G_RET_STS_SUCCESS;
8179: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 8359: select pid process_to_count from dual;

8355: where process_id = pid
8356: and up_down_ind = 'D'
8357: and hierarchy_type = 'A'
8358: union
8359: select pid process_to_count from dual;
8360:
8361: cursor c_processes (pid number) is
8362: select parent_child_id process_to_count
8363: from amw_proc_hierarchy_denorm

Line 8368: select pid process_to_count from dual;

8364: where process_id = pid
8365: and up_down_ind = 'D'
8366: and hierarchy_type = 'A'
8367: union
8368: select pid process_to_count from dual;
8369:
8370:
8371: BEGIN
8372:

Line 8528: select p_process_id process_to_count from dual

8524: where APHD.process_id = p_process_id
8525: and APHD.up_down_ind = 'D'
8526: and APHD.hierarchy_type = 'A'
8527: union
8528: select p_process_id process_to_count from dual
8529: );
8530: END IF;
8531: END IF;
8532: commit;

Line 8605: select pid process_to_count from dual;

8601: where process_id = pid
8602: and up_down_ind = 'D'
8603: and hierarchy_type = 'A'
8604: union
8605: select pid process_to_count from dual;
8606:
8607: cursor c2(pid number, orgName varchar2) is
8608: select aauv.organization_id,
8609: name

Line 8659: select pid process_to_count from dual;

8655: where process_id = pid
8656: and up_down_ind = 'D'
8657: and hierarchy_type = 'A'
8658: union
8659: select pid process_to_count from dual;
8660:
8661:
8662:
8663: type t_audit_unit_rec is record (organization_id amw_audit_units_v.organization_id%type,