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.IGI_SLS_SECURITY_PKG dependencies on IGI_SLS_OBJECTS_PKG

Line 365: igi_sls_objects_pkg.create_sls_tab

361: -- Call Procedure to create SLS Table
362: write_to_log (l_state_level, 'create_drop_sls_objects', 'Create_Drop_SLS_Objects, Creating SLS Table ' ||
363: rt_c_get_sectab.sls_table_name);
364:
365: igi_sls_objects_pkg.create_sls_tab
366: (sls_tab => rt_c_get_sectab.sls_table_name,
367: schema_name => l_schema_name,
368: errbuf => errbuf,
369: retcode => retcode);

Line 375: igi_sls_objects_pkg.create_sls_col

371: ELSE
372: -- Call Procedure to create SLS Colmn
373: write_to_log (l_state_level, 'create_drop_sls_objects', 'Create_Drop_SLS_Objects, Creating SLS Col ');
374:
375: igi_sls_objects_pkg.create_sls_col
376: (sec_tab => rt_c_get_sectab.table_name,
377: schema_name => rt_c_get_sectab.owner,
378: errbuf => errbuf,
379: retcode => retcode);

Line 391: igi_sls_objects_pkg.create_sls_inx

387: -- Call Procedure to create SLS Table
388: write_to_log (l_state_level, 'create_drop_sls_objects', 'Create_Drop_SLS_Objects, Creating index for SLS Table ' ||
389: rt_c_get_sectab.sls_table_name);
390:
391: igi_sls_objects_pkg.create_sls_inx
392: (sls_tab => rt_c_get_sectab.sls_table_name,
393: errbuf => errbuf,
394: retcode => retcode);
395:

Line 397: igi_sls_objects_pkg.create_sls_core_inx

393: errbuf => errbuf,
394: retcode => retcode);
395:
396: ELSE
397: igi_sls_objects_pkg.create_sls_core_inx
398: (sec_tab => rt_c_get_sectab.table_name,
399: sls_tab => rt_c_get_sectab.sls_table_name,
400: schema_name => rt_c_get_sectab.owner,
401: errbuf => errbuf,

Line 412: igi_sls_objects_pkg.create_sls_apps_syn

408: THEN
409: write_to_log ( l_state_level, 'create_drop_sls_objects', 'Create_Drop_SLS_Objects, Creating synonym for SLS Table ' ||
410: rt_c_get_sectab.sls_table_name );
411:
412: igi_sls_objects_pkg.create_sls_apps_syn
413: (sls_tab => rt_c_get_sectab.sls_table_name,
414: schema_name => l_schema_name,
415: errbuf => errbuf,
416: retcode => retcode);

Line 427: igi_sls_objects_pkg.create_sls_mls_syn

423: THEN
424: write_to_log (l_state_level, 'create_drop_sls_objects', 'Create_Drop_SLS_Objects, Creating synonym for SLS Table ' ||
425: rt_c_get_sectab.sls_table_name || ' in '|| p_mls_schema_name);
426:
427: igi_sls_objects_pkg.create_sls_mls_syn
428: (sls_tab => rt_c_get_sectab.sls_table_name,
429: mls_schemaname => p_mls_schema_name,
430: errbuf => errbuf,
431: retcode => retcode);

Line 441: igi_sls_objects_pkg.create_sls_mrc_syn

437: THEN
438: write_to_log (l_state_level, 'create_drop_sls_objects', 'Create_Drop_SLS_Objects, Creating synonym for SLS Table ' ||
439: rt_c_get_sectab.sls_table_name || ' in '|| p_mrc_schema_name);
440:
441: igi_sls_objects_pkg.create_sls_mrc_syn
442: (sls_tab => rt_c_get_sectab.sls_table_name,
443: mrc_schemaname => p_mrc_schema_name,
444: errbuf => errbuf,
445: retcode => retcode);

Line 461: igi_sls_objects_pkg.create_sls_trg

457: IF rt_c_get_sectab.optimise_sql = 'N'
458: THEN
459: write_to_log(l_state_level, 'create_drop_sls_objects', 'New table created, Please run Maintain APPS_MRC,APPS_MLS,if any, and any other customer schema');
460: -- Call Procedure to create SLS Table
461: igi_sls_objects_pkg.create_sls_trg
462: (sls_tab => rt_c_get_sectab.sls_table_name,
463: sec_tab => rt_c_get_sectab.table_name,
464: errbuf => errbuf,
465: retcode => retcode);

Line 468: igi_sls_objects_pkg.create_sls_col_trg

464: errbuf => errbuf,
465: retcode => retcode);
466:
467: ELSE
468: igi_sls_objects_pkg.create_sls_col_trg
469: (sls_tab => rt_c_get_sectab.sls_table_name,
470: sec_tab => rt_c_get_sectab.table_name,
471: errbuf => errbuf,
472: retcode => retcode);

Line 485: igi_sls_objects_pkg.cre_pol_function

481:
482: IF rt_c_get_sectab.optimise_sql = 'N'
483: THEN
484: -- Call Procedure to create SLS Table
485: igi_sls_objects_pkg.cre_pol_function
486: (sec_tab => rt_c_get_sectab.table_name,
487: sls_tab => rt_c_get_sectab.sls_table_name,
488: errbuf => errbuf,
489: retcode => retcode);

Line 491: igi_sls_objects_pkg.cre_ext_col_pol_func

487: sls_tab => rt_c_get_sectab.sls_table_name,
488: errbuf => errbuf,
489: retcode => retcode);
490: ELSE
491: igi_sls_objects_pkg.cre_ext_col_pol_func
492: (sec_tab => rt_c_get_sectab.table_name,
493: sls_tab => rt_c_get_sectab.sls_table_name,
494: errbuf => errbuf,
495: retcode => retcode);

Line 508: igi_sls_objects_pkg.sls_add_pol

504: write_to_log (l_state_level, 'create_drop_sls_objects', 'Create_Drop_SLS_Objects, Creating policy'||
505: ' on table ' || rt_c_get_sectab.table_name);
506:
507: -- Call Procedure to create Policy
508: igi_sls_objects_pkg.sls_add_pol
509: (object_schema => rt_c_get_sectab.owner,
510: table_name => rt_c_get_sectab.table_name,
511: policy_name => l_policy_name,
512: function_owner => l_schema_name,

Line 547: igi_sls_objects_pkg.sls_drop_pol

543: IF retcode = 0
544: THEN
545: -- CALL Procedure to drop Policy
546: write_to_log (l_state_level, 'create_drop_sls_objects', 'Create_Drop_SLS_Objects, Dropping policy '||l_policy_name);
547: igi_sls_objects_pkg.sls_drop_pol
548: (object_schema => rt_c_get_sectab.owner,
549: table_name => rt_c_get_sectab.table_name,
550: policy_name => l_policy_name,
551: errbuf => errbuf,

Line 561: igi_sls_objects_pkg.sls_add_pol

557: write_to_log (l_state_level, 'create_drop_sls_objects', 'Refresh_SLS_Objects, Creating policy ' ||l_policy_name ||
558: ' on table ' || rt_c_get_sectab.table_name);
559:
560: -- Call Procedure to create Policy
561: igi_sls_objects_pkg.sls_add_pol
562: (object_schema => rt_c_get_sectab.owner,
563: table_name => rt_c_get_sectab.table_name,
564: policy_name => l_policy_name,
565: function_owner => l_schema_name,

Line 584: igi_sls_objects_pkg.sls_disable_pol

580: AND rt_c_get_sectab.date_removed IS NULL
581: THEN
582: -- Security has been disabled
583: write_to_log (l_state_level, 'create_drop_sls_objects', 'Create_Drop_SLS_Objects, Disabling policy '||l_policy_name);
584: igi_sls_objects_pkg.sls_disable_pol
585: (object_schema => rt_c_get_sectab.owner,
586: table_name => rt_c_get_sectab.table_name,
587: policy_name => l_policy_name,
588: enable => FALSE,

Line 605: igi_sls_objects_pkg.sls_drop_pol

601: THEN
602: -- Security has been deleted
603: write_to_log (l_state_level, 'create_drop_sls_objects', 'Create_Drop_SLS_Objects, Dropping policy '||l_policy_name);
604:
605: igi_sls_objects_pkg.sls_drop_pol
606: (object_schema => rt_c_get_sectab.owner,
607: table_name => rt_c_get_sectab.table_name,
608: policy_name => l_policy_name,
609: errbuf => errbuf,

Line 617: igi_sls_objects_pkg.drop_pol_function

613: THEN
614: -- CALL Procedure to drop Policy Function
615: write_to_log (l_state_level, 'create_drop_sls_objects', 'Create_Drop_SLS_Objects, Dropping policy function '||l_policy_function);
616:
617: igi_sls_objects_pkg.drop_pol_function
618: (sls_tab => rt_c_get_sectab.sls_table_name,
619: errbuf => errbuf,
620: retcode => retcode);
621:

Line 629: igi_sls_objects_pkg.drop_sls_trg

625: THEN
626: -- CALL Procedure to drop DB Trigger
627: write_to_log ( l_state_level, 'create_drop_sls_objects', 'Create_Drop_SLS_Objects, Dropping trigger on table '||
628: rt_c_get_sectab.table_name);
629: igi_sls_objects_pkg.drop_sls_trg
630: (sls_tab => rt_c_get_sectab.sls_table_name,
631: errbuf => errbuf,
632: retcode => retcode);
633: END IF;

Line 642: igi_sls_objects_pkg.drop_sls_tab

638: THEN
639: -- CALL Procedure to drop SLS Table
640: write_to_log (l_state_level, 'create_drop_sls_objects', 'Create_Drop_SLS_Objects, Dropping table '||
641: rt_c_get_sectab.sls_table_name);
642: igi_sls_objects_pkg.drop_sls_tab
643: (sls_tab => rt_c_get_sectab.sls_table_name,
644: errbuf => errbuf,
645: retcode => retcode);
646:

Line 648: igi_sls_objects_pkg.drop_sls_col

644: errbuf => errbuf,
645: retcode => retcode);
646:
647: ELSE
648: igi_sls_objects_pkg.drop_sls_col
649: (sec_tab => rt_c_get_sectab.table_name,
650: schema_name => rt_c_get_sectab.owner,
651: errbuf => errbuf,
652: retcode => retcode);

Line 655: igi_sls_objects_pkg.drop_sls_tab

651: errbuf => errbuf,
652: retcode => retcode);
653:
654: -- The table should also be dropped.
655: igi_sls_objects_pkg.drop_sls_tab
656: (sls_tab => rt_c_get_sectab.sls_table_name,
657: errbuf => errbuf,
658: retcode => retcode);
659:

Line 670: igi_sls_objects_pkg.drop_sls_apps_syn

666: -- Drop the synonym even though the optimise sql = 'Y'
667: -- CALL Procedure to drop SLS APPS Synonyms
668: write_to_log (l_state_level, 'create_drop_sls_objects', 'Create_Drop_SLS_Objects, Dropping synonym table '||
669: rt_c_get_sectab.sls_table_name );
670: igi_sls_objects_pkg.drop_sls_apps_syn
671: (sls_tab => rt_c_get_sectab.sls_table_name,
672: schema_name => l_schema_name,
673: errbuf => errbuf,
674: retcode => retcode);

Line 684: igi_sls_objects_pkg.drop_sls_mls_syn

680: THEn
681: -- CALL Procedure to drop SLS MLS Synonyms
682: write_to_log (l_state_level, 'create_drop_sls_objects', 'Create_Drop_SLS_Objects, Dropping synonym table '||
683: rt_c_get_sectab.sls_table_name || ' in '||p_mls_schema_name);
684: igi_sls_objects_pkg.drop_sls_mls_syn
685: (sls_tab => rt_c_get_sectab.sls_table_name,
686: mls_schemaname => p_mls_schema_name,
687: errbuf => errbuf,
688: retcode => retcode);

Line 697: igi_sls_objects_pkg.drop_sls_mrc_syn

693: THEN
694: -- CALL Procedure to drop SLS MRC Synonyms
695: write_to_log (l_state_level, 'create_drop_sls_objects', 'Create_Drop_SLS_Objects, Dropping synonym on table '||
696: rt_c_get_sectab.sls_table_name || ' in '||p_mrc_schema_name);
697: igi_sls_objects_pkg.drop_sls_mrc_syn
698: (sls_tab => rt_c_get_sectab.sls_table_name,
699: mrc_schemaname => p_mrc_schema_name,
700: errbuf => errbuf,
701: retcode => retcode);

Line 826: igi_sls_objects_pkg.create_sls_col

822:
823: IF rt_c_get_enab_sectab.optimise_sql = 'Y'
824: THEN
825: -- Call procedure to create additional column
826: igi_sls_objects_pkg.create_sls_col
827: (sec_tab => rt_c_get_enab_sectab.table_name,
828: schema_name => rt_c_get_enab_sectab.owner,
829: errbuf => errbuf,
830: retcode => retcode);

Line 845: igi_sls_objects_pkg.create_sls_trg

841: IF retcode = 0
842: THEN
843: IF rt_c_get_enab_sectab.optimise_sql = 'N'
844: THEN
845: igi_sls_objects_pkg.create_sls_trg
846: (sls_tab => rt_c_get_enab_sectab.sls_table_name,
847: sec_tab => rt_c_get_enab_sectab.table_name,
848: errbuf => errbuf,
849: retcode => retcode);

Line 852: igi_sls_objects_pkg.create_sls_col_trg

848: errbuf => errbuf,
849: retcode => retcode);
850:
851: ELSE
852: igi_sls_objects_pkg.create_sls_col_trg
853: (sls_tab => rt_c_get_enab_sectab.sls_table_name,
854: sec_tab => rt_c_get_enab_sectab.table_name,
855: errbuf => errbuf,
856: retcode => retcode);

Line 867: igi_sls_objects_pkg.cre_pol_function

863: write_to_log (l_state_level, 'refresh_sls_objects', 'Refresh_SLS_Objects, Re-Creating policy function ' ||l_policy_function);
864:
865: IF rt_c_get_enab_sectab.optimise_sql = 'N'
866: THEN
867: igi_sls_objects_pkg.cre_pol_function
868: (sec_tab => rt_c_get_enab_sectab.table_name,
869: sls_tab => rt_c_get_enab_sectab.sls_table_name,
870: errbuf => errbuf,
871: retcode => retcode);

Line 873: igi_sls_objects_pkg.cre_ext_col_pol_func

869: sls_tab => rt_c_get_enab_sectab.sls_table_name,
870: errbuf => errbuf,
871: retcode => retcode);
872: ELSE
873: igi_sls_objects_pkg.cre_ext_col_pol_func
874: (sec_tab => rt_c_get_enab_sectab.table_name,
875: sls_tab => rt_c_get_enab_sectab.sls_table_name,
876: errbuf => errbuf,
877: retcode => retcode);

Line 888: igi_sls_objects_pkg.sls_drop_pol

884: IF retcode = 0
885: THEN
886: -- CALL Procedure to drop Policy
887: write_to_log (l_state_level, 'refresh_sls_objects', 'Create_Drop_SLS_Objects, Dropping policy '||l_policy_name);
888: igi_sls_objects_pkg.sls_drop_pol
889: (object_schema => rt_c_get_enab_sectab.owner,
890: table_name => rt_c_get_enab_sectab.table_name,
891: policy_name => l_policy_name,
892: errbuf => errbuf,

Line 902: igi_sls_objects_pkg.sls_add_pol

898: write_to_log (l_state_level, 'refresh_sls_objects', 'Refresh_SLS_Objects, Creating policy ' ||l_policy_name ||
899: ' on table ' || rt_c_get_enab_sectab.table_name);
900:
901: -- Call Procedure to create Policy
902: igi_sls_objects_pkg.sls_add_pol
903: (object_schema => rt_c_get_enab_sectab.owner,
904: table_name => rt_c_get_enab_sectab.table_name,
905: policy_name => l_policy_name,
906: function_owner => l_schema_name,

Line 919: igi_sls_objects_pkg.sls_disable_pol

915: ELSIF rt_c_get_enab_sectab.date_disabled IS NOT NULL
916: THEN
917: -- Security has been disabled
918: write_to_log ( l_state_level, 'refresh_sls_objects','Refresh_SLS_Objects, Disabling policy '||l_policy_name);
919: igi_sls_objects_pkg.sls_disable_pol
920: (object_schema => rt_c_get_enab_sectab.owner,
921: table_name => rt_c_get_enab_sectab.table_name,
922: policy_name => l_policy_name,
923: enable => FALSE,

Line 935: igi_sls_objects_pkg.create_sls_trg

931: ' on table ' || rt_c_get_enab_sectab.table_name);
932:
933: IF rt_c_get_enab_sectab.optimise_sql = 'N'
934: THEN
935: igi_sls_objects_pkg.create_sls_trg
936: (sls_tab => rt_c_get_enab_sectab.sls_table_name,
937: sec_tab => rt_c_get_enab_sectab.table_name,
938: errbuf => errbuf,
939: retcode => retcode);

Line 942: igi_sls_objects_pkg.create_sls_col_trg

938: errbuf => errbuf,
939: retcode => retcode);
940:
941: ELSE
942: igi_sls_objects_pkg.create_sls_col_trg
943: (sls_tab => rt_c_get_enab_sectab.sls_table_name,
944: sec_tab => rt_c_get_enab_sectab.table_name,
945: errbuf => errbuf,
946: retcode => retcode);

Line 957: igi_sls_objects_pkg.cre_pol_function

953: write_to_log ( l_state_level, 'refresh_sls_objects','Refresh_SLS_Objects, Re-Creating policy function ' ||l_policy_function);
954:
955: IF rt_c_get_enab_sectab.optimise_sql = 'N'
956: THEN
957: igi_sls_objects_pkg.cre_pol_function
958: (sec_tab => rt_c_get_enab_sectab.table_name,
959: sls_tab => rt_c_get_enab_sectab.sls_table_name,
960: errbuf => errbuf,
961: retcode => retcode);

Line 963: igi_sls_objects_pkg.cre_ext_col_pol_func

959: sls_tab => rt_c_get_enab_sectab.sls_table_name,
960: errbuf => errbuf,
961: retcode => retcode);
962: ELSE
963: igi_sls_objects_pkg.cre_ext_col_pol_func
964: (sec_tab => rt_c_get_enab_sectab.table_name,
965: sls_tab => rt_c_get_enab_sectab.sls_table_name,
966: errbuf => errbuf,
967: retcode => retcode);

Line 980: igi_sls_objects_pkg.create_sls_inx

976:
977: IF rt_c_get_enab_sectab.optimise_sql = 'N'
978: THEN
979: -- Recreate the index if absent
980: igi_sls_objects_pkg.create_sls_inx
981: (sls_tab => rt_c_get_enab_sectab.sls_table_name,
982: errbuf => errbuf,
983: retcode => retcode);
984: ELSE

Line 985: igi_sls_objects_pkg.create_sls_core_inx

981: (sls_tab => rt_c_get_enab_sectab.sls_table_name,
982: errbuf => errbuf,
983: retcode => retcode);
984: ELSE
985: igi_sls_objects_pkg.create_sls_core_inx
986: (sec_tab => rt_c_get_enab_sectab.table_name,
987: sls_tab => rt_c_get_enab_sectab.sls_table_name,
988: schema_name => rt_c_get_enab_sectab.owner,
989: errbuf => errbuf,

Line 2024: igi_sls_objects_pkg.create_sls_inx

2020: IF l_sec_dat.optimise_sql = 'N'
2021: THEN
2022: -- Create Index, as they might not be present if User had already
2023: -- installed SLS
2024: igi_sls_objects_pkg.create_sls_inx
2025: (sls_tab => l_sec_dat.sls_table_name,
2026: errbuf => errbuf,
2027: retcode => retcode);
2028: ELSE

Line 2029: igi_sls_objects_pkg.create_sls_core_inx

2025: (sls_tab => l_sec_dat.sls_table_name,
2026: errbuf => errbuf,
2027: retcode => retcode);
2028: ELSE
2029: igi_sls_objects_pkg.create_sls_core_inx
2030: (sec_tab => l_sec_dat.table_name,
2031: sls_tab => l_sec_dat.sls_table_name,
2032: schema_name => l_sec_dat.owner,
2033: errbuf => errbuf,