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.JTY_TERR_ENGINE_GEN2_PVT dependencies on JTY_DEA_VALUES_IDX_DETAILS

Line 629: INSERT INTO jty_dea_values_idx_details (

625: ,'JTY_DEA_ATTR_VAL_' || abs(l_qual_type_usg_id) || '_RN' || i
626: ,'Y');
627:
628: IF (p_cp_tbl(i) IS NOT NULL) THEN
629: INSERT INTO jty_dea_values_idx_details (
630: dea_values_idx_details_id
631: ,dea_values_idx_header_id
632: ,last_update_date
633: ,last_updated_by

Line 641: jty_dea_values_idx_details_s.nextval

637: ,values_col_map
638: ,input_selectivity
639: ,input_ordinal_selectivity )
640: VALUES (
641: jty_dea_values_idx_details_s.nextval
642: ,l_header_seq
643: ,G_SYSDATE
644: ,G_USER_ID
645: ,G_SYSDATE

Line 654: INSERT INTO jty_dea_values_idx_details (

650: ,null);
651: END IF;
652:
653: IF (p_lvc_id_tbl(i) IS NOT NULL) THEN
654: INSERT INTO jty_dea_values_idx_details (
655: dea_values_idx_details_id
656: ,dea_values_idx_header_id
657: ,last_update_date
658: ,last_updated_by

Line 666: jty_dea_values_idx_details_s.nextval

662: ,values_col_map
663: ,input_selectivity
664: ,input_ordinal_selectivity )
665: VALUES (
666: jty_dea_values_idx_details_s.nextval
667: ,l_header_seq
668: ,G_SYSDATE
669: ,G_USER_ID
670: ,G_SYSDATE

Line 679: INSERT INTO jty_dea_values_idx_details (

675: ,null);
676: END IF;
677:
678: IF (p_lvc_tbl(i) IS NOT NULL) THEN
679: INSERT INTO jty_dea_values_idx_details (
680: dea_values_idx_details_id
681: ,dea_values_idx_header_id
682: ,last_update_date
683: ,last_updated_by

Line 691: jty_dea_values_idx_details_s.nextval

687: ,values_col_map
688: ,input_selectivity
689: ,input_ordinal_selectivity )
690: VALUES (
691: jty_dea_values_idx_details_s.nextval
692: ,l_header_seq
693: ,G_SYSDATE
694: ,G_USER_ID
695: ,G_SYSDATE

Line 704: INSERT INTO jty_dea_values_idx_details (

700: ,null);
701: END IF;
702:
703: IF (p_hvc_tbl(i) IS NOT NULL) THEN
704: INSERT INTO jty_dea_values_idx_details (
705: dea_values_idx_details_id
706: ,dea_values_idx_header_id
707: ,last_update_date
708: ,last_updated_by

Line 716: jty_dea_values_idx_details_s.nextval

712: ,values_col_map
713: ,input_selectivity
714: ,input_ordinal_selectivity )
715: VALUES (
716: jty_dea_values_idx_details_s.nextval
717: ,l_header_seq
718: ,G_SYSDATE
719: ,G_USER_ID
720: ,G_SYSDATE

Line 729: INSERT INTO jty_dea_values_idx_details (

725: ,null);
726: END IF;
727:
728: IF (p_lvn_tbl(i) IS NOT NULL) THEN
729: INSERT INTO jty_dea_values_idx_details (
730: dea_values_idx_details_id
731: ,dea_values_idx_header_id
732: ,last_update_date
733: ,last_updated_by

Line 741: jty_dea_values_idx_details_s.nextval

737: ,values_col_map
738: ,input_selectivity
739: ,input_ordinal_selectivity )
740: VALUES (
741: jty_dea_values_idx_details_s.nextval
742: ,l_header_seq
743: ,G_SYSDATE
744: ,G_USER_ID
745: ,G_SYSDATE

Line 754: INSERT INTO jty_dea_values_idx_details (

750: ,null);
751: END IF;
752:
753: IF (p_hvn_tbl(i) IS NOT NULL) THEN
754: INSERT INTO jty_dea_values_idx_details (
755: dea_values_idx_details_id
756: ,dea_values_idx_header_id
757: ,last_update_date
758: ,last_updated_by

Line 766: jty_dea_values_idx_details_s.nextval

762: ,values_col_map
763: ,input_selectivity
764: ,input_ordinal_selectivity )
765: VALUES (
766: jty_dea_values_idx_details_s.nextval
767: ,l_header_seq
768: ,G_SYSDATE
769: ,G_USER_ID
770: ,G_SYSDATE

Line 779: INSERT INTO jty_dea_values_idx_details (

775: ,null);
776: END IF;
777:
778: IF (p_it_id_tbl(i) IS NOT NULL) THEN
779: INSERT INTO jty_dea_values_idx_details (
780: dea_values_idx_details_id
781: ,dea_values_idx_header_id
782: ,last_update_date
783: ,last_updated_by

Line 791: jty_dea_values_idx_details_s.nextval

787: ,values_col_map
788: ,input_selectivity
789: ,input_ordinal_selectivity )
790: VALUES (
791: jty_dea_values_idx_details_s.nextval
792: ,l_header_seq
793: ,G_SYSDATE
794: ,G_USER_ID
795: ,G_SYSDATE

Line 804: INSERT INTO jty_dea_values_idx_details (

800: ,null);
801: END IF;
802:
803: IF (p_pic_id_tbl(i) IS NOT NULL) THEN
804: INSERT INTO jty_dea_values_idx_details (
805: dea_values_idx_details_id
806: ,dea_values_idx_header_id
807: ,last_update_date
808: ,last_updated_by

Line 816: jty_dea_values_idx_details_s.nextval

812: ,values_col_map
813: ,input_selectivity
814: ,input_ordinal_selectivity )
815: VALUES (
816: jty_dea_values_idx_details_s.nextval
817: ,l_header_seq
818: ,G_SYSDATE
819: ,G_USER_ID
820: ,G_SYSDATE

Line 829: INSERT INTO jty_dea_values_idx_details (

825: ,null);
826: END IF;
827:
828: IF (p_sic_id_tbl(i) IS NOT NULL) THEN
829: INSERT INTO jty_dea_values_idx_details (
830: dea_values_idx_details_id
831: ,dea_values_idx_header_id
832: ,last_update_date
833: ,last_updated_by

Line 841: jty_dea_values_idx_details_s.nextval

837: ,values_col_map
838: ,input_selectivity
839: ,input_ordinal_selectivity )
840: VALUES (
841: jty_dea_values_idx_details_s.nextval
842: ,l_header_seq
843: ,G_SYSDATE
844: ,G_USER_ID
845: ,G_SYSDATE

Line 854: INSERT INTO jty_dea_values_idx_details (

850: ,null);
851: END IF;
852:
853: IF (p_curr_tbl(i) IS NOT NULL) THEN
854: INSERT INTO jty_dea_values_idx_details (
855: dea_values_idx_details_id
856: ,dea_values_idx_header_id
857: ,last_update_date
858: ,last_updated_by

Line 866: jty_dea_values_idx_details_s.nextval

862: ,values_col_map
863: ,input_selectivity
864: ,input_ordinal_selectivity )
865: VALUES (
866: jty_dea_values_idx_details_s.nextval
867: ,l_header_seq
868: ,G_SYSDATE
869: ,G_USER_ID
870: ,G_SYSDATE

Line 879: INSERT INTO jty_dea_values_idx_details (

875: ,null);
876: END IF;
877:
878: IF (p_value1_id_tbl(i) IS NOT NULL) THEN
879: INSERT INTO jty_dea_values_idx_details (
880: dea_values_idx_details_id
881: ,dea_values_idx_header_id
882: ,last_update_date
883: ,last_updated_by

Line 891: jty_dea_values_idx_details_s.nextval

887: ,values_col_map
888: ,input_selectivity
889: ,input_ordinal_selectivity )
890: VALUES (
891: jty_dea_values_idx_details_s.nextval
892: ,l_header_seq
893: ,G_SYSDATE
894: ,G_USER_ID
895: ,G_SYSDATE

Line 904: INSERT INTO jty_dea_values_idx_details (

900: ,null);
901: END IF;
902:
903: IF (p_value2_id_tbl(i) IS NOT NULL) THEN
904: INSERT INTO jty_dea_values_idx_details (
905: dea_values_idx_details_id
906: ,dea_values_idx_header_id
907: ,last_update_date
908: ,last_updated_by

Line 916: jty_dea_values_idx_details_s.nextval

912: ,values_col_map
913: ,input_selectivity
914: ,input_ordinal_selectivity )
915: VALUES (
916: jty_dea_values_idx_details_s.nextval
917: ,l_header_seq
918: ,G_SYSDATE
919: ,G_USER_ID
920: ,G_SYSDATE

Line 929: INSERT INTO jty_dea_values_idx_details (

925: ,null);
926: END IF;
927:
928: IF (p_value3_id_tbl(i) IS NOT NULL) THEN
929: INSERT INTO jty_dea_values_idx_details (
930: dea_values_idx_details_id
931: ,dea_values_idx_header_id
932: ,last_update_date
933: ,last_updated_by

Line 941: jty_dea_values_idx_details_s.nextval

937: ,values_col_map
938: ,input_selectivity
939: ,input_ordinal_selectivity )
940: VALUES (
941: jty_dea_values_idx_details_s.nextval
942: ,l_header_seq
943: ,G_SYSDATE
944: ,G_USER_ID
945: ,G_SYSDATE

Line 954: INSERT INTO jty_dea_values_idx_details (

950: ,null);
951: END IF;
952:
953: IF (p_value4_id_tbl(i) IS NOT NULL) THEN
954: INSERT INTO jty_dea_values_idx_details (
955: dea_values_idx_details_id
956: ,dea_values_idx_header_id
957: ,last_update_date
958: ,last_updated_by

Line 966: jty_dea_values_idx_details_s.nextval

962: ,values_col_map
963: ,input_selectivity
964: ,input_ordinal_selectivity )
965: VALUES (
966: jty_dea_values_idx_details_s.nextval
967: ,l_header_seq
968: ,G_SYSDATE
969: ,G_USER_ID
970: ,G_SYSDATE

Line 979: INSERT INTO jty_dea_values_idx_details (

975: ,null);
976: END IF;
977:
978: IF (p_fc_tbl(i) IS NOT NULL) THEN
979: INSERT INTO jty_dea_values_idx_details (
980: dea_values_idx_details_id
981: ,dea_values_idx_header_id
982: ,last_update_date
983: ,last_updated_by

Line 991: jty_dea_values_idx_details_s.nextval

987: ,values_col_map
988: ,input_selectivity
989: ,input_ordinal_selectivity )
990: VALUES (
991: jty_dea_values_idx_details_s.nextval
992: ,l_header_seq
993: ,G_SYSDATE
994: ,G_USER_ID
995: ,G_SYSDATE