[Home] [Help]
28: BEGIN
29:
30: SELECT to_char(amw_scope_event_s.nextval)
31: INTO l_item_key
32: FROM dual;
33:
34: wf_event.addParameterToList(
35: p_name => 'MODE',
36: p_value => p_mode,
284: p_org_new_tbl(each_rec).org_id,
285: 'SUBSIDIARY',
286: l_temp_sub_parent_id,
287: 1
288: FROM dual;
289:
290: l_lob_exists := 'N';
291: found_parent := false;
292:
328: p_org_new_tbl(each_rec).org_id,
329: 'LINEOFBUSINESS',
330: l_temp_parent_id,
331: 1
332: FROM dual;
333:
334: ELSE
335:
336: --Step 5(Condition B) : Populate table with object_type = ORGANIZATION and parent_object_type = DUMMYLOB
360: p_org_new_tbl(each_rec).org_id,
361: 'DUMMYLOB',
362: -999,
363: 1
364: FROM dual;
365: END IF;
366:
367: END LOOP; -- end of FOR each_rec IN p_org_new_tbl
368:
437: p_sub_new_tbl(each_sub).subsidiary_id,
438: 'SUBSIDIARY',
439: l_temp_sub_parent_id,
440: 1
441: FROM dual;
442: ELSE
443:
444: --Step 7 : Populate table with Subsidiary hierarchy
445: INSERT INTO AMW_ENTITY_HIERARCHIES
468: p_sub_new_tbl(each_sub).subsidiary_id,
469: 'ROOTNODE',
470: -1,
471: 1
472: FROM dual;
473:
474: END IF; --found_sub_parent = true = false
475:
476: END LOOP;-- end of FOR each_sub IN 1..p_sub_new_tbl
546: p_lob_new_tbl(each_lob).lob_id,
547: 'LINEOFBUSINESS',
548: l_temp_lob_parent_id,
549: 1
550: FROM dual;
551: ELSE
552:
553: --Step 9 : Populate table with LOB hierarchy
554: INSERT INTO AMW_ENTITY_HIERARCHIES
577: p_lob_new_tbl(each_lob).lob_id,
578: 'ROOTNODE',
579: -1,
580: 1
581: FROM dual;
582:
583: END IF; --found_lob_parent = true
584:
585: END LOOP;-- end of FOR each_lob IN 1..p_lob_new_tbl
777: p_org_tbl(each_rec).org_id,
778: 'ORG',
779: l_temp_parent_id,
780: 1
781: FROM dual;
782:
783: ELSE
784: --Step 11: Populate selected CustomORGS into table and build hierarchy
785: INSERT INTO AMW_ENTITY_HIERARCHIES
808: p_org_tbl(each_rec).org_id,
809: 'ROOTNODE',
810: -1,
811: 1
812: FROM dual;
813: END IF;
814:
815: END LOOP;
816:
1132: null,
1133: null,
1134: null,
1135: sysdate
1136: FROM DUAL
1137: WHERE not exists (SELECT 'Y'
1138: FROM AMW_EXECUTION_SCOPE
1139: WHERE entity_type=p_entity_type
1140: AND entity_id= p_entity_id
1195: null,
1196: null,
1197: null,
1198: SYSDATE
1199: FROM DUAL
1200: WHERE not exists (SELECT 'Y'
1201: FROM AMW_EXECUTION_SCOPE
1202: WHERE entity_type=p_entity_type
1203: AND entity_id= p_entity_id
1247: null,
1248: null,
1249: null,
1250: SYSDATE
1251: FROM DUAL
1252: WHERE NOT EXISTS (SELECT 'Y'
1253: FROM AMW_EXECUTION_SCOPE
1254: WHERE entity_type=p_entity_type
1255: AND entity_id= p_entity_id
1300: null,
1301: null,
1302: null,
1303: SYSDATE
1304: FROM DUAL
1305: WHERE not exists (SELECT 'Y'
1306: FROM AMW_EXECUTION_SCOPE
1307: WHERE entity_type=p_entity_type
1308: AND entity_id= p_entity_id
1353: null,
1354: null,
1355: null,
1356: SYSDATE
1357: FROM DUAL
1358: WHERE not exists (SELECT 'Y'
1359: FROM AMW_EXECUTION_SCOPE
1360: WHERE entity_type=p_entity_type
1361: AND entity_id= p_entity_id
1436: l_process_id,
1437: -1,
1438: l_process_org_rev_id,
1439: SYSDATE
1440: FROM DUAL
1441: WHERE not exists (SELECT 'Y'
1442: FROM AMW_EXECUTION_SCOPE
1443: WHERE entity_type=p_entity_type
1444: AND entity_id= p_entity_id
1543: p_top_process_id,
1544: p_parent_process_id,
1545: proc_rec.process_org_rev_id,
1546: SYSDATE
1547: FROM DUAL;
1548: END LOOP;
1549: END Insert_Process;
1550:
1551: PROCEDURE build_project_audit_task (
3377: p_proc_hier_tbl(i).top_process_id,
3378: p_proc_hier_tbl(i).parent_process_id,
3379: l_process_org_rev_id,
3380: SYSDATE
3381: FROM dual where not exists (select 'Y' from amw_execution_scope
3382: where entity_type = p_entity_type and entity_id = p_entity_id
3383: and organization_id = p_organization_id and process_id = p_proc_hier_tbl(i).process_id
3384: and top_process_id = p_proc_hier_tbl(i).top_process_id and parent_process_id = p_proc_hier_tbl(i).parent_process_id
3385: and level_id = p_proc_hier_tbl(i).level_id