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_PROC_ORG_HIERARCHY_PVT dependencies on AMW_PROCESS

Line 83: select child_process_id,parent_process_id,parent_process_name,process_name from amw_process_hierarchy_v

79: l_msg_data varchar2(3000) := 'empty';
80:
81: /**
82: cursor c1 is
83: select child_process_id,parent_process_id,parent_process_name,process_name from amw_process_hierarchy_v
84: start with child_process_id=p_process_id
85: connect by prior child_process_id=parent_process_id;
86: **/
87:

Line 90: from amw_process_hierarchy_v

86: **/
87:
88: cursor c1 (l_cpid number) is
89: select parent_process_id,child_process_id,parent_process_name,process_name
90: from amw_process_hierarchy_v
91: where parent_process_id=l_cpid;
92:
93: cursor risk_ctrl is
94: select nvl(risk_count,0) as risk_count,

Line 96: from amw_process

92:
93: cursor risk_ctrl is
94: select nvl(risk_count,0) as risk_count,
95: nvl(control_count,0) as control_count
96: from amw_process
97: where process_id=p_process_id;
98: ---and organization_id=p_organization_id;
99:
100: l_risk_ctrl risk_ctrl%rowtype;

Line 171: ---select parent_process_id into l_ppid from amw_process_hierarchy_v

167:
168: if(p_level=0)then
169: l_top_process_id := p_process_id;
170:
171: ---select parent_process_id into l_ppid from amw_process_hierarchy_v
172: ---where child_process_id=p_process_id;
173:
174: l_ppid := get_parent_process_id(p_process_id,p_organization_id);
175: ----dbms_output.put_line('l_ppid: '||l_ppid);

Line 381: from amw_process where process_id=p_process_id;

377: security_group_id,object_version_number,
378: nvl(control_count,0) as control_count,
379: nvl(risk_count,0) as risk_count,nvl(org_count,0) as org_count,
380: finance_owner_id,application_owner_id
381: from amw_process where process_id=p_process_id;
382:
383: l_amwp_rowtype c1%rowtype;
384: l_amwp amw_process_organization%rowtype;
385: l_count number := 0;

Line 384: l_amwp amw_process_organization%rowtype;

380: finance_owner_id,application_owner_id
381: from amw_process where process_id=p_process_id;
382:
383: l_amwp_rowtype c1%rowtype;
384: l_amwp amw_process_organization%rowtype;
385: l_count number := 0;
386: l_do_insert varchar2(30) := 'INSERT';
387: l_org_count number := 0;
388: l_parent_process_end_date date := null;

Line 391: select count(*) row_count from amw_process_organization

387: l_org_count number := 0;
388: l_parent_process_end_date date := null;
389:
390: cursor cc1 is
391: select count(*) row_count from amw_process_organization
392: where process_id=p_process_id and organization_id=p_organization_id;
393:
394: cc1_row cc1%rowtype;
395:

Line 397: select count(*) row_count from amw_process_organization

393:
394: cc1_row cc1%rowtype;
395:
396: cursor cc2 is
397: select count(*) row_count from amw_process_organization
398: where process_id=p_parent_process_id and organization_id=p_organization_id;
399:
400: cc2_row cc2%rowtype;
401:

Line 403: select end_date from amw_process_organization

399:
400: cc2_row cc2%rowtype;
401:
402: cursor cc3 is
403: select end_date from amw_process_organization
404: where process_id=p_parent_process_id and organization_id=p_organization_id;
405:
406: cc3_row cc3%rowtype;
407:

Line 409: select count(*) row_count from amw_process_organization

405:
406: cc3_row cc3%rowtype;
407:
408: cursor cc4 is
409: select count(*) row_count from amw_process_organization
410: where process_id=p_parent_process_id and organization_id=p_organization_id;
411:
412: cc4_row cc4%rowtype;
413:

Line 415: select end_date from amw_process_organization

411:
412: cc4_row cc4%rowtype;
413:
414: cursor cc5 is
415: select end_date from amw_process_organization
416: where process_id=p_parent_process_id and organization_id=p_organization_id;
417:
418: cc5_row cc5%rowtype;
419:

Line 487: ---insert into amw_process_organization tbl this process for this organization

483: l_apo_type.security_group_id := l_amwp_rowtype.security_group_id;
484: l_apo_type.OBJECT_VERSION_NUMBER := 1;
485: l_apo_type.END_DATE := null; ---amwp_rowtype.END_DATE;
486:
487: ---insert into amw_process_organization tbl this process for this organization
488: if(p_mode = 'ASSOCIATE') then
489: --check to see if this process id exists in amw_process_organization
490:
491:

Line 489: --check to see if this process id exists in amw_process_organization

485: l_apo_type.END_DATE := null; ---amwp_rowtype.END_DATE;
486:
487: ---insert into amw_process_organization tbl this process for this organization
488: if(p_mode = 'ASSOCIATE') then
489: --check to see if this process id exists in amw_process_organization
490:
491:
492: select count(*) into l_count from amw_process_organization
493: where process_id=p_process_id and organization_id=p_organization_id;

Line 492: select count(*) into l_count from amw_process_organization

488: if(p_mode = 'ASSOCIATE') then
489: --check to see if this process id exists in amw_process_organization
490:
491:
492: select count(*) into l_count from amw_process_organization
493: where process_id=p_process_id and organization_id=p_organization_id;
494: ---DBMS_OUTPUT.PUT_LINE ( 'associate_process_heirarchy: top_process_id '|| p_top_process_id );
495: ---DBMS_OUTPUT.PUT_LINE ( 'l_count for checking if this child process_id '||p_process_id||' exists: '|| l_count);
496:

Line 499: --this means that this record exists in amw_process_organization table

495: ---DBMS_OUTPUT.PUT_LINE ( 'l_count for checking if this child process_id '||p_process_id||' exists: '|| l_count);
496:
497: -------------------dbms_output.put_line('cc1 l_count: '||l_count);
498: if l_count > 0 then
499: --this means that this record exists in amw_process_organization table
500: --so this row needs to be updated
501: l_do_insert := 'UPDATE';
502: l_apo_type.TOP_PROCESS_ID := p_process_id;
503:

Line 506: select count(*) into l_count from amw_process_organization

502: l_apo_type.TOP_PROCESS_ID := p_process_id;
503:
504: --so now we need to check if there is a parent process associated to this node
505:
506: select count(*) into l_count from amw_process_organization
507: where process_id=p_parent_process_id and organization_id=p_organization_id;
508:
509: -----------------dbms_output.put_line('cc2 l_count: '||l_count);
510: --if it does then, see if the parent process is associated or disassociated

Line 513: select end_date into l_parent_process_end_date from amw_process_organization

509: -----------------dbms_output.put_line('cc2 l_count: '||l_count);
510: --if it does then, see if the parent process is associated or disassociated
511: if l_count > 0 then
512:
513: select end_date into l_parent_process_end_date from amw_process_organization
514: where process_id=p_parent_process_id and organization_id=p_organization_id;
515:
516: ------------------dbms_output.put_line('cc3 l_parent_process_end_date: '||l_parent_process_end_date);
517: if l_parent_process_end_date is not null then

Line 518: --so this process row exists in amw_process_organization, so no new row insertion

514: where process_id=p_parent_process_id and organization_id=p_organization_id;
515:
516: ------------------dbms_output.put_line('cc3 l_parent_process_end_date: '||l_parent_process_end_date);
517: if l_parent_process_end_date is not null then
518: --so this process row exists in amw_process_organization, so no new row insertion
519: --this node has a parent process in amw_process_organization which is disassociated
520: --so this parent process needs to be updated with top_process_id set to this p_id
521: l_apo_type.TOP_PROCESS_ID := p_process_id;
522: ----l_apo_type.object_version_number := l_apo_type.object_version_number+1;

Line 519: --this node has a parent process in amw_process_organization which is disassociated

515:
516: ------------------dbms_output.put_line('cc3 l_parent_process_end_date: '||l_parent_process_end_date);
517: if l_parent_process_end_date is not null then
518: --so this process row exists in amw_process_organization, so no new row insertion
519: --this node has a parent process in amw_process_organization which is disassociated
520: --so this parent process needs to be updated with top_process_id set to this p_id
521: l_apo_type.TOP_PROCESS_ID := p_process_id;
522: ----l_apo_type.object_version_number := l_apo_type.object_version_number+1;
523: else

Line 529: --if the parent_process_id for this process exists in amw_process_organization,

525: end if;
526: end if;
527: else
528: --this means that this record does not exist, but we need to check
529: --if the parent_process_id for this process exists in amw_process_organization,
530: l_count := 0;
531:
532:
533: select count(*) into l_count from amw_process_organization

Line 533: select count(*) into l_count from amw_process_organization

529: --if the parent_process_id for this process exists in amw_process_organization,
530: l_count := 0;
531:
532:
533: select count(*) into l_count from amw_process_organization
534: where process_id=p_parent_process_id and organization_id=p_organization_id;
535:
536: ---------------dbms_output.put_line('cc4 l_count: '||l_count);
537: --if it does then

Line 543: select end_date into l_parent_process_end_date from amw_process_organization

539: if l_count > 0 then
540: l_do_insert := 'INSERT';
541:
542:
543: select end_date into l_parent_process_end_date from amw_process_organization
544: where process_id=p_parent_process_id and organization_id=p_organization_id;
545: ---------------------dbms_output.put_line('cc5 l_parent_process_end_date: '||l_parent_process_end_date);
546: if l_parent_process_end_date is null then
547: -- if parent_process' end_date is null (associated parent process,

Line 577: process_amw_process_org(

573: end if;
574:
575: ------------------DBMS_OUTPUT.PUT_LINE ( 'p_mode: '|| p_mode||', l_do_insert: '||l_do_insert);
576:
577: process_amw_process_org(
578: p_apo_type => l_apo_type,
579: p_do_insert => l_do_insert,
580: p_org_count => l_org_count,
581: p_rcm_assoc => p_rcm_assoc,

Line 639: -- Process_Amw_Process_Org

635: -- ==============================================================================
636: -- Start of Comments
637: -- ==============================================================================
638: -- API Name
639: -- Process_Amw_Process_Org
640: -- Type
641: -- Private
642: -- Pre-Req
643: --

Line 666: procedure process_amw_process_org(

662: -- End of Comments
663: -- ==============================================================================
664: --
665:
666: procedure process_amw_process_org(
667: p_apo_type in apo_type := g_miss_apo_type,
668: p_do_insert in varchar2 := 'INSERT',
669: p_org_count in number := 0,
670: p_rcm_assoc in varchar2 := 'N',

Line 694: SELECT AMW_PROCESS_organization_s.NEXTVAL FROM dual;

690: l_obj_num number := 0;
691: process_end_date date := sysdate;
692:
693: CURSOR c_proc_org_s IS
694: SELECT AMW_PROCESS_organization_s.NEXTVAL FROM dual;
695:
696: cursor get_counts is
697: select nvl(risk_count,0) as risk_count,
698: nvl(control_count,0) as control_count from amw_process

Line 698: nvl(control_count,0) as control_count from amw_process

694: SELECT AMW_PROCESS_organization_s.NEXTVAL FROM dual;
695:
696: cursor get_counts is
697: select nvl(risk_count,0) as risk_count,
698: nvl(control_count,0) as control_count from amw_process
699: where process_id=p_apo_type.process_id;
700:
701: l_risk_ctrl_count get_counts%rowtype;
702:

Line 722: insert into AMW_process_organization(

718: open c_proc_org_s;
719: fetch c_proc_org_s into l_process_organization_id;
720: close c_proc_org_s;
721:
722: insert into AMW_process_organization(
723: control_count,
724: risk_count,
725: top_process_id,
726: process_organization_id,

Line 821: --Amit's requirement to increment org_count in amw_process for every associate

817: 1,
818: null
819: );
820:
821: --Amit's requirement to increment org_count in amw_process for every associate
822: select nvl(object_version_number,1) into l_obj_num from amw_process where process_id=p_apo_type.process_id;
823: l_obj_num := l_obj_num+1;
824:
825: select nvl(org_count,0) into l_org_count from amw_process where process_id=p_apo_type.process_id;

Line 822: select nvl(object_version_number,1) into l_obj_num from amw_process where process_id=p_apo_type.process_id;

818: null
819: );
820:
821: --Amit's requirement to increment org_count in amw_process for every associate
822: select nvl(object_version_number,1) into l_obj_num from amw_process where process_id=p_apo_type.process_id;
823: l_obj_num := l_obj_num+1;
824:
825: select nvl(org_count,0) into l_org_count from amw_process where process_id=p_apo_type.process_id;
826: l_org_count := l_org_count+1;

Line 825: select nvl(org_count,0) into l_org_count from amw_process where process_id=p_apo_type.process_id;

821: --Amit's requirement to increment org_count in amw_process for every associate
822: select nvl(object_version_number,1) into l_obj_num from amw_process where process_id=p_apo_type.process_id;
823: l_obj_num := l_obj_num+1;
824:
825: select nvl(org_count,0) into l_org_count from amw_process where process_id=p_apo_type.process_id;
826: l_org_count := l_org_count+1;
827:
828: /* update amw_process set org_count=l_org_count,
829: object_version_number=l_obj_num,

Line 828: /* update amw_process set org_count=l_org_count,

824:
825: select nvl(org_count,0) into l_org_count from amw_process where process_id=p_apo_type.process_id;
826: l_org_count := l_org_count+1;
827:
828: /* update amw_process set org_count=l_org_count,
829: object_version_number=l_obj_num,
830: last_update_date=sysdate,last_updated_by=G_USER_ID,last_update_login=G_LOGIN_ID
831: where process_id=p_apo_type.process_id; */
832:

Line 833: ---DBMS_OUTPUT.PUT_LINE('update amw_process set org_count=decode('||l_org_count||',null,1,'||l_org_count||'),last_update_date='||sysdate||',last_updated_by='||G_USER_ID||' where process_id='||p_apo_type.process_id);

829: object_version_number=l_obj_num,
830: last_update_date=sysdate,last_updated_by=G_USER_ID,last_update_login=G_LOGIN_ID
831: where process_id=p_apo_type.process_id; */
832:
833: ---DBMS_OUTPUT.PUT_LINE('update amw_process set org_count=decode('||l_org_count||',null,1,'||l_org_count||'),last_update_date='||sysdate||',last_updated_by='||G_USER_ID||' where process_id='||p_apo_type.process_id);
834: elsif p_do_insert = 'UPDATE' then
835: --record already exists in some process hierarchy in amw_process_organization
836: --so, do not insert, just update with top_process_id,end_date set to null
837: select nvl(object_version_number,1) into l_obj_num from amw_process_organization

Line 835: --record already exists in some process hierarchy in amw_process_organization

831: where process_id=p_apo_type.process_id; */
832:
833: ---DBMS_OUTPUT.PUT_LINE('update amw_process set org_count=decode('||l_org_count||',null,1,'||l_org_count||'),last_update_date='||sysdate||',last_updated_by='||G_USER_ID||' where process_id='||p_apo_type.process_id);
834: elsif p_do_insert = 'UPDATE' then
835: --record already exists in some process hierarchy in amw_process_organization
836: --so, do not insert, just update with top_process_id,end_date set to null
837: select nvl(object_version_number,1) into l_obj_num from amw_process_organization
838: where process_id=p_apo_type.process_id and organization_id=p_apo_type.organization_id;
839:

Line 837: select nvl(object_version_number,1) into l_obj_num from amw_process_organization

833: ---DBMS_OUTPUT.PUT_LINE('update amw_process set org_count=decode('||l_org_count||',null,1,'||l_org_count||'),last_update_date='||sysdate||',last_updated_by='||G_USER_ID||' where process_id='||p_apo_type.process_id);
834: elsif p_do_insert = 'UPDATE' then
835: --record already exists in some process hierarchy in amw_process_organization
836: --so, do not insert, just update with top_process_id,end_date set to null
837: select nvl(object_version_number,1) into l_obj_num from amw_process_organization
838: where process_id=p_apo_type.process_id and organization_id=p_apo_type.organization_id;
839:
840: l_obj_num := l_obj_num+1;
841:

Line 842: select end_date into process_end_date from amw_process_organization

838: where process_id=p_apo_type.process_id and organization_id=p_apo_type.organization_id;
839:
840: l_obj_num := l_obj_num+1;
841:
842: select end_date into process_end_date from amw_process_organization
843: where process_id=p_apo_type.process_id
844: and organization_id=p_apo_type.organization_id;
845:
846: open get_counts;

Line 850: update amw_process_organization

846: open get_counts;
847: fetch get_counts into l_risk_ctrl_count;
848: close get_counts;
849:
850: update amw_process_organization
851: set top_process_id=p_apo_type.top_process_id,
852: risk_count=l_risk_ctrl_count.risk_count,
853: control_count=l_risk_ctrl_count.control_count,
854: object_version_number=l_obj_num,

Line 861: --Amit's requirement to increment org_count in amw_process for every associate

857: last_update_date=sysdate,
858: last_update_login=G_LOGIN_ID
859: where process_id=p_apo_type.process_id and organization_id=p_apo_type.organization_id;
860:
861: --Amit's requirement to increment org_count in amw_process for every associate
862: --check first to see if this process was already assigned to this org
863: --and is active
864:
865: if(process_end_date is not null)then

Line 868: select nvl(object_version_number,1) into l_obj_num from amw_process where process_id=p_apo_type.process_id;

864:
865: if(process_end_date is not null)then
866: --this means that tbis process may have not been assigned to this org,
867: --or, if assigned, may have been end-dated ....
868: select nvl(object_version_number,1) into l_obj_num from amw_process where process_id=p_apo_type.process_id;
869: l_obj_num := l_obj_num+1;
870:
871: select nvl(org_count,0) into l_org_count from amw_process where process_id=p_apo_type.process_id;
872: l_org_count := l_org_count+1;

Line 871: select nvl(org_count,0) into l_org_count from amw_process where process_id=p_apo_type.process_id;

867: --or, if assigned, may have been end-dated ....
868: select nvl(object_version_number,1) into l_obj_num from amw_process where process_id=p_apo_type.process_id;
869: l_obj_num := l_obj_num+1;
870:
871: select nvl(org_count,0) into l_org_count from amw_process where process_id=p_apo_type.process_id;
872: l_org_count := l_org_count+1;
873:
874: /* update amw_process
875: set org_count=l_org_count,

Line 874: /* update amw_process

870:
871: select nvl(org_count,0) into l_org_count from amw_process where process_id=p_apo_type.process_id;
872: l_org_count := l_org_count+1;
873:
874: /* update amw_process
875: set org_count=l_org_count,
876: object_version_number=l_obj_num,
877: last_update_date=sysdate,
878: last_updated_by=G_USER_ID,

Line 882: --------------------DBMS_OUTPUT.PUT_LINE ( 'updated amw_process_organization, p_org_id: '||l_process_organization_id ||', updated amw_process for process_id: '|| p_apo_type.process_id);

878: last_updated_by=G_USER_ID,
879: last_update_login=G_LOGIN_ID
880: where process_id=p_apo_type.process_id; */
881: end if;
882: --------------------DBMS_OUTPUT.PUT_LINE ( 'updated amw_process_organization, p_org_id: '||l_process_organization_id ||', updated amw_process for process_id: '|| p_apo_type.process_id);
883:
884: elsif p_do_insert = 'DELETE' then
885: l_org_count := p_org_count-1;
886: l_assoc_mode := 'DISASSOCIATE';

Line 888: select nvl(object_version_number,1) into l_obj_num from amw_process_organization

884: elsif p_do_insert = 'DELETE' then
885: l_org_count := p_org_count-1;
886: l_assoc_mode := 'DISASSOCIATE';
887:
888: select nvl(object_version_number,1) into l_obj_num from amw_process_organization
889: where process_id=p_apo_type.process_id and organization_id=p_apo_type.organization_id;
890:
891: l_obj_num := l_obj_num+1;
892:

Line 893: update amw_process_organization

889: where process_id=p_apo_type.process_id and organization_id=p_apo_type.organization_id;
890:
891: l_obj_num := l_obj_num+1;
892:
893: update amw_process_organization
894: set end_date=sysdate,
895: object_version_number=l_obj_num,
896: risk_count=0,
897: control_count=0,

Line 902: --Amit's requirement to increment org_count in amw_process for every associate

898: last_updated_by=G_USER_ID,
899: last_update_date=sysdate
900: where process_id=p_apo_type.process_id and organization_id=p_apo_type.organization_id;
901:
902: --Amit's requirement to increment org_count in amw_process for every associate
903: select nvl(object_version_number,1) into l_obj_num from amw_process where process_id=p_apo_type.process_id;
904: l_obj_num := l_obj_num+1;
905:
906: select nvl(org_count,0) into l_org_count from amw_process where process_id=p_apo_type.process_id;

Line 903: select nvl(object_version_number,1) into l_obj_num from amw_process where process_id=p_apo_type.process_id;

899: last_update_date=sysdate
900: where process_id=p_apo_type.process_id and organization_id=p_apo_type.organization_id;
901:
902: --Amit's requirement to increment org_count in amw_process for every associate
903: select nvl(object_version_number,1) into l_obj_num from amw_process where process_id=p_apo_type.process_id;
904: l_obj_num := l_obj_num+1;
905:
906: select nvl(org_count,0) into l_org_count from amw_process where process_id=p_apo_type.process_id;
907: if(l_org_count > 0)then

Line 906: select nvl(org_count,0) into l_org_count from amw_process where process_id=p_apo_type.process_id;

902: --Amit's requirement to increment org_count in amw_process for every associate
903: select nvl(object_version_number,1) into l_obj_num from amw_process where process_id=p_apo_type.process_id;
904: l_obj_num := l_obj_num+1;
905:
906: select nvl(org_count,0) into l_org_count from amw_process where process_id=p_apo_type.process_id;
907: if(l_org_count > 0)then
908: l_org_count := l_org_count-1;
909: end if;
910:

Line 911: /* update amw_process

907: if(l_org_count > 0)then
908: l_org_count := l_org_count-1;
909: end if;
910:
911: /* update amw_process
912: set org_count=l_org_count,
913: object_version_number=l_obj_num,
914: last_updated_by=G_USER_ID,
915: last_update_date=sysdate,

Line 930: select process_organization_id into l_process_organization_id from amw_process_organization

926:
927:
928: x_return_status := FND_API.G_RET_STS_SUCCESS;
929:
930: select process_organization_id into l_process_organization_id from amw_process_organization
931: where process_id=p_apo_type.process_id and organization_id=p_apo_type.organization_id;
932:
933: ---passing for the financial statements modification as required by Qingdi
934: process_amw_acct_assoc(

Line 945: fnd_file.put_line(fnd_file.LOG, 'INSIDE PROCESS_AMW_PROCESS_ORG');

941: x_msg_count => x_msg_count,
942: x_msg_data => x_msg_data
943: );
944:
945: fnd_file.put_line(fnd_file.LOG, 'INSIDE PROCESS_AMW_PROCESS_ORG');
946: fnd_file.put_line(fnd_file.LOG, 'p_rcm_assoc: '||p_rcm_assoc);
947: fnd_file.put_line(fnd_file.LOG, 'p_batch_id: '||p_batch_id);
948: fnd_file.put_line(fnd_file.LOG, 'p_risk_id: '||p_risk_id);
949: fnd_file.put_line(fnd_file.LOG, 'p_control_id: '||p_control_id);

Line 982: ----------------------dbms_output.put_line('Process_AMW_Process_Org x_return_status: '||x_return_status);

978: x_msg_count => x_msg_count,
979: x_msg_data => x_msg_data);
980: end if;
981:
982: ----------------------dbms_output.put_line('Process_AMW_Process_Org x_return_status: '||x_return_status);
983: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
984: RAISE FND_API.G_EXC_ERROR;
985: END IF;
986:

Line 1030: end process_amw_process_org;

1026: p_encoded => FND_API.G_FALSE,
1027: p_count => x_msg_count,
1028: p_data => x_msg_data
1029: );
1030: end process_amw_process_org;
1031:
1032: procedure process_amw_rcm_org(
1033: p_batch_id in number := null,
1034: p_rcm_org_intf_id in number := null,

Line 1968: from amw_process_organization apo, amw_risk_associations ara, amw_control_associations aca, amw_ap_associations apa

1964:
1965: --mpande added 11/14/2003
1966: cursor c2 is
1967: select ap_association_id,audit_procedure_id
1968: from amw_process_organization apo, amw_risk_associations ara, amw_control_associations aca, amw_ap_associations apa
1969: where apo.process_organization_id = ara.pk1
1970: and ara.risk_association_id = aca.pk1
1971: and aca.control_association_id = p_control_association_id
1972: and apa.pk1 = apo.organization_id

Line 2013: from amw_process_organization apo, amw_risk_associations ara, amw_control_associations aca

2009: exit when c1%notfound;
2010:
2011: select apo.process_id, apo.organization_id
2012: into l_process_id, l_org_id
2013: from amw_process_organization apo, amw_risk_associations ara, amw_control_associations aca
2014: where apo.process_organization_id = ara.pk1
2015: and ara.risk_association_id = aca.pk1
2016: and aca.control_association_id = p_control_association_id;
2017:

Line 2178: FROM amw_process_organization

2174: select process_id,
2175: nvl(risk_count,0) as risk_count,
2176: nvl(control_count,0) as control_count,
2177: process_organization_id,object_version_number
2178: FROM amw_process_organization
2179: WHERE organization_id = p_organization_id AND process_id IN (
2180: SELECT DISTINCT p2.process_id
2181: FROM amw_process p1,
2182: amw_process p2,

Line 2181: FROM amw_process p1,

2177: process_organization_id,object_version_number
2178: FROM amw_process_organization
2179: WHERE organization_id = p_organization_id AND process_id IN (
2180: SELECT DISTINCT p2.process_id
2181: FROM amw_process p1,
2182: amw_process p2,
2183: amw_process_organization apo1,
2184: amw_process_organization apo2,
2185: wf_activities wa

Line 2182: amw_process p2,

2178: FROM amw_process_organization
2179: WHERE organization_id = p_organization_id AND process_id IN (
2180: SELECT DISTINCT p2.process_id
2181: FROM amw_process p1,
2182: amw_process p2,
2183: amw_process_organization apo1,
2184: amw_process_organization apo2,
2185: wf_activities wa
2186: WHERE (p2.NAME, p2.item_type) IN (

Line 2183: amw_process_organization apo1,

2179: WHERE organization_id = p_organization_id AND process_id IN (
2180: SELECT DISTINCT p2.process_id
2181: FROM amw_process p1,
2182: amw_process p2,
2183: amw_process_organization apo1,
2184: amw_process_organization apo2,
2185: wf_activities wa
2186: WHERE (p2.NAME, p2.item_type) IN (
2187: SELECT activity_name,

Line 2184: amw_process_organization apo2,

2180: SELECT DISTINCT p2.process_id
2181: FROM amw_process p1,
2182: amw_process p2,
2183: amw_process_organization apo1,
2184: amw_process_organization apo2,
2185: wf_activities wa
2186: WHERE (p2.NAME, p2.item_type) IN (
2187: SELECT activity_name,
2188: activity_item_type

Line 2254: --update amw_process' risk_count

2250: if(p_process_id <> assoc_risk.process_id or p_mode='DISASSOCIATE')then
2251: ---if(p_process_id=assoc_risk.process_id)then
2252: ---dbms_output.put_line('process_id '||p_process_id||' p_mode: '||p_mode);
2253: ---end if;
2254: --update amw_process' risk_count
2255: UPDATE amw_process_organization
2256: SET risk_count = assoc_risk.risk_count,
2257: control_count = assoc_risk.control_count,
2258: object_version_number = assoc_risk.object_version_number,

Line 2255: UPDATE amw_process_organization

2251: ---if(p_process_id=assoc_risk.process_id)then
2252: ---dbms_output.put_line('process_id '||p_process_id||' p_mode: '||p_mode);
2253: ---end if;
2254: --update amw_process' risk_count
2255: UPDATE amw_process_organization
2256: SET risk_count = assoc_risk.risk_count,
2257: control_count = assoc_risk.control_count,
2258: object_version_number = assoc_risk.object_version_number,
2259: last_updated_by = g_user_id,

Line 2359: --l_process_rec AMW_Process_PVT.process_rec_type;

2355: IS
2356: L_API_NAME CONSTANT VARCHAR2(30) := 'Validate_Process';
2357: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
2358: l_object_version_number NUMBER;
2359: --l_process_rec AMW_Process_PVT.process_rec_type;
2360:
2361: BEGIN
2362: -- Standard Start of API savepoint
2363: SAVEPOINT validate_process_pvt;

Line 2482: AMW_Utility_PVT.Error_Message(p_message_name => 'AMW_process_organization_NO_organization_id');

2478: x_return_status := FND_API.g_ret_sts_success;
2479:
2480: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
2481: IF p_apo_type.organization_id = FND_API.g_miss_num OR p_apo_type.organization_id IS NULL THEN
2482: AMW_Utility_PVT.Error_Message(p_message_name => 'AMW_process_organization_NO_organization_id');
2483: x_return_status := FND_API.g_ret_sts_error;
2484: RETURN;
2485: END IF;
2486:

Line 2488: AMW_Utility_PVT.Error_Message(p_message_name => 'AMW_process_NO_process_id');

2484: RETURN;
2485: END IF;
2486:
2487: IF p_apo_type.process_id = FND_API.g_miss_num OR p_apo_type.process_id IS NULL THEN
2488: AMW_Utility_PVT.Error_Message(p_message_name => 'AMW_process_NO_process_id');
2489: x_return_status := FND_API.g_ret_sts_error;
2490: RETURN;
2491: END IF;
2492: END IF;

Line 2501: from amw_process_hierarchy_v aphv,amw_process_organization apo

2497:
2498:
2499: cursor c1 is
2500: select aphv.parent_process_id,apo.end_date
2501: from amw_process_hierarchy_v aphv,amw_process_organization apo
2502: where aphv.child_process_id=p_process_id
2503: and apo.process_id=p_process_id
2504: and apo.organization_id=p_organization_id;
2505: