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 637: INSERT INTO jty_dea_values_idx_details (

633: ,'Y'
634: ,'N');
635:
636: IF (p_cp_tbl(i) IS NOT NULL) THEN
637: INSERT INTO jty_dea_values_idx_details (
638: dea_values_idx_details_id
639: ,dea_values_idx_header_id
640: ,last_update_date
641: ,last_updated_by

Line 649: jty_dea_values_idx_details_s.nextval

645: ,values_col_map
646: ,input_selectivity
647: ,input_ordinal_selectivity )
648: VALUES (
649: jty_dea_values_idx_details_s.nextval
650: ,l_header_seq
651: ,G_SYSDATE
652: ,G_USER_ID
653: ,G_SYSDATE

Line 662: INSERT INTO jty_dea_values_idx_details (

658: ,null);
659: END IF;
660:
661: IF (p_lvc_id_tbl(i) IS NOT NULL) THEN
662: INSERT INTO jty_dea_values_idx_details (
663: dea_values_idx_details_id
664: ,dea_values_idx_header_id
665: ,last_update_date
666: ,last_updated_by

Line 674: jty_dea_values_idx_details_s.nextval

670: ,values_col_map
671: ,input_selectivity
672: ,input_ordinal_selectivity )
673: VALUES (
674: jty_dea_values_idx_details_s.nextval
675: ,l_header_seq
676: ,G_SYSDATE
677: ,G_USER_ID
678: ,G_SYSDATE

Line 687: INSERT INTO jty_dea_values_idx_details (

683: ,null);
684: END IF;
685:
686: IF (p_lvc_tbl(i) IS NOT NULL) THEN
687: INSERT INTO jty_dea_values_idx_details (
688: dea_values_idx_details_id
689: ,dea_values_idx_header_id
690: ,last_update_date
691: ,last_updated_by

Line 699: jty_dea_values_idx_details_s.nextval

695: ,values_col_map
696: ,input_selectivity
697: ,input_ordinal_selectivity )
698: VALUES (
699: jty_dea_values_idx_details_s.nextval
700: ,l_header_seq
701: ,G_SYSDATE
702: ,G_USER_ID
703: ,G_SYSDATE

Line 712: INSERT INTO jty_dea_values_idx_details (

708: ,null);
709: END IF;
710:
711: IF (p_hvc_tbl(i) IS NOT NULL) THEN
712: INSERT INTO jty_dea_values_idx_details (
713: dea_values_idx_details_id
714: ,dea_values_idx_header_id
715: ,last_update_date
716: ,last_updated_by

Line 724: jty_dea_values_idx_details_s.nextval

720: ,values_col_map
721: ,input_selectivity
722: ,input_ordinal_selectivity )
723: VALUES (
724: jty_dea_values_idx_details_s.nextval
725: ,l_header_seq
726: ,G_SYSDATE
727: ,G_USER_ID
728: ,G_SYSDATE

Line 737: INSERT INTO jty_dea_values_idx_details (

733: ,null);
734: END IF;
735:
736: IF (p_lvn_tbl(i) IS NOT NULL) THEN
737: INSERT INTO jty_dea_values_idx_details (
738: dea_values_idx_details_id
739: ,dea_values_idx_header_id
740: ,last_update_date
741: ,last_updated_by

Line 749: jty_dea_values_idx_details_s.nextval

745: ,values_col_map
746: ,input_selectivity
747: ,input_ordinal_selectivity )
748: VALUES (
749: jty_dea_values_idx_details_s.nextval
750: ,l_header_seq
751: ,G_SYSDATE
752: ,G_USER_ID
753: ,G_SYSDATE

Line 762: INSERT INTO jty_dea_values_idx_details (

758: ,null);
759: END IF;
760:
761: IF (p_hvn_tbl(i) IS NOT NULL) THEN
762: INSERT INTO jty_dea_values_idx_details (
763: dea_values_idx_details_id
764: ,dea_values_idx_header_id
765: ,last_update_date
766: ,last_updated_by

Line 774: jty_dea_values_idx_details_s.nextval

770: ,values_col_map
771: ,input_selectivity
772: ,input_ordinal_selectivity )
773: VALUES (
774: jty_dea_values_idx_details_s.nextval
775: ,l_header_seq
776: ,G_SYSDATE
777: ,G_USER_ID
778: ,G_SYSDATE

Line 787: INSERT INTO jty_dea_values_idx_details (

783: ,null);
784: END IF;
785:
786: IF (p_it_id_tbl(i) IS NOT NULL) THEN
787: INSERT INTO jty_dea_values_idx_details (
788: dea_values_idx_details_id
789: ,dea_values_idx_header_id
790: ,last_update_date
791: ,last_updated_by

Line 799: jty_dea_values_idx_details_s.nextval

795: ,values_col_map
796: ,input_selectivity
797: ,input_ordinal_selectivity )
798: VALUES (
799: jty_dea_values_idx_details_s.nextval
800: ,l_header_seq
801: ,G_SYSDATE
802: ,G_USER_ID
803: ,G_SYSDATE

Line 812: INSERT INTO jty_dea_values_idx_details (

808: ,null);
809: END IF;
810:
811: IF (p_pic_id_tbl(i) IS NOT NULL) THEN
812: INSERT INTO jty_dea_values_idx_details (
813: dea_values_idx_details_id
814: ,dea_values_idx_header_id
815: ,last_update_date
816: ,last_updated_by

Line 824: jty_dea_values_idx_details_s.nextval

820: ,values_col_map
821: ,input_selectivity
822: ,input_ordinal_selectivity )
823: VALUES (
824: jty_dea_values_idx_details_s.nextval
825: ,l_header_seq
826: ,G_SYSDATE
827: ,G_USER_ID
828: ,G_SYSDATE

Line 837: INSERT INTO jty_dea_values_idx_details (

833: ,null);
834: END IF;
835:
836: IF (p_sic_id_tbl(i) IS NOT NULL) THEN
837: INSERT INTO jty_dea_values_idx_details (
838: dea_values_idx_details_id
839: ,dea_values_idx_header_id
840: ,last_update_date
841: ,last_updated_by

Line 849: jty_dea_values_idx_details_s.nextval

845: ,values_col_map
846: ,input_selectivity
847: ,input_ordinal_selectivity )
848: VALUES (
849: jty_dea_values_idx_details_s.nextval
850: ,l_header_seq
851: ,G_SYSDATE
852: ,G_USER_ID
853: ,G_SYSDATE

Line 862: INSERT INTO jty_dea_values_idx_details (

858: ,null);
859: END IF;
860:
861: IF (p_curr_tbl(i) IS NOT NULL) THEN
862: INSERT INTO jty_dea_values_idx_details (
863: dea_values_idx_details_id
864: ,dea_values_idx_header_id
865: ,last_update_date
866: ,last_updated_by

Line 874: jty_dea_values_idx_details_s.nextval

870: ,values_col_map
871: ,input_selectivity
872: ,input_ordinal_selectivity )
873: VALUES (
874: jty_dea_values_idx_details_s.nextval
875: ,l_header_seq
876: ,G_SYSDATE
877: ,G_USER_ID
878: ,G_SYSDATE

Line 887: INSERT INTO jty_dea_values_idx_details (

883: ,null);
884: END IF;
885:
886: IF (p_value1_id_tbl(i) IS NOT NULL) THEN
887: INSERT INTO jty_dea_values_idx_details (
888: dea_values_idx_details_id
889: ,dea_values_idx_header_id
890: ,last_update_date
891: ,last_updated_by

Line 899: jty_dea_values_idx_details_s.nextval

895: ,values_col_map
896: ,input_selectivity
897: ,input_ordinal_selectivity )
898: VALUES (
899: jty_dea_values_idx_details_s.nextval
900: ,l_header_seq
901: ,G_SYSDATE
902: ,G_USER_ID
903: ,G_SYSDATE

Line 912: INSERT INTO jty_dea_values_idx_details (

908: ,null);
909: END IF;
910:
911: IF (p_value2_id_tbl(i) IS NOT NULL) THEN
912: INSERT INTO jty_dea_values_idx_details (
913: dea_values_idx_details_id
914: ,dea_values_idx_header_id
915: ,last_update_date
916: ,last_updated_by

Line 924: jty_dea_values_idx_details_s.nextval

920: ,values_col_map
921: ,input_selectivity
922: ,input_ordinal_selectivity )
923: VALUES (
924: jty_dea_values_idx_details_s.nextval
925: ,l_header_seq
926: ,G_SYSDATE
927: ,G_USER_ID
928: ,G_SYSDATE

Line 937: INSERT INTO jty_dea_values_idx_details (

933: ,null);
934: END IF;
935:
936: IF (p_value3_id_tbl(i) IS NOT NULL) THEN
937: INSERT INTO jty_dea_values_idx_details (
938: dea_values_idx_details_id
939: ,dea_values_idx_header_id
940: ,last_update_date
941: ,last_updated_by

Line 949: jty_dea_values_idx_details_s.nextval

945: ,values_col_map
946: ,input_selectivity
947: ,input_ordinal_selectivity )
948: VALUES (
949: jty_dea_values_idx_details_s.nextval
950: ,l_header_seq
951: ,G_SYSDATE
952: ,G_USER_ID
953: ,G_SYSDATE

Line 962: INSERT INTO jty_dea_values_idx_details (

958: ,null);
959: END IF;
960:
961: IF (p_value4_id_tbl(i) IS NOT NULL) THEN
962: INSERT INTO jty_dea_values_idx_details (
963: dea_values_idx_details_id
964: ,dea_values_idx_header_id
965: ,last_update_date
966: ,last_updated_by

Line 974: jty_dea_values_idx_details_s.nextval

970: ,values_col_map
971: ,input_selectivity
972: ,input_ordinal_selectivity )
973: VALUES (
974: jty_dea_values_idx_details_s.nextval
975: ,l_header_seq
976: ,G_SYSDATE
977: ,G_USER_ID
978: ,G_SYSDATE

Line 987: INSERT INTO jty_dea_values_idx_details (

983: ,null);
984: END IF;
985:
986: IF (p_fc_tbl(i) IS NOT NULL) THEN
987: INSERT INTO jty_dea_values_idx_details (
988: dea_values_idx_details_id
989: ,dea_values_idx_header_id
990: ,last_update_date
991: ,last_updated_by

Line 999: jty_dea_values_idx_details_s.nextval

995: ,values_col_map
996: ,input_selectivity
997: ,input_ordinal_selectivity )
998: VALUES (
999: jty_dea_values_idx_details_s.nextval
1000: ,l_header_seq
1001: ,G_SYSDATE
1002: ,G_USER_ID
1003: ,G_SYSDATE