APPS.JTY_TERR_ENGINE_GEN2_PVT dependencies on JTY_TERR_VALUES_IDX_HEADER

Line 93: FROM jty_terr_values_idx_header

89: l_no_of_records := 0;
90:
91: SELECT count(*)
92: INTO l_no_of_records
93: FROM jty_terr_values_idx_header
94: WHERE source_id = p_source_id
95: AND qual_usg_id = p_qual_usg_id_tbl(i);
96:
97: IF (l_no_of_records = 0) THEN

Line 99: SELECT jty_terr_values_idx_header_s.nextval

95: AND qual_usg_id = p_qual_usg_id_tbl(i);
96:
97: IF (l_no_of_records = 0) THEN
98:
99: SELECT jty_terr_values_idx_header_s.nextval
100: INTO l_header_seq
101: FROM dual;
102:
103: SELECT 'JTY_DNM_ATTR_VAL_' || abs(l_qual_type_usg_id) || '_RN' ||

Line 106: FROM jty_terr_values_idx_header

102:
103: SELECT 'JTY_DNM_ATTR_VAL_' || abs(l_qual_type_usg_id) || '_RN' ||
104: (nvl(max(to_number(substr(index_name, instr(index_name, '_RN')+3))), 0) + 1)
105: INTO l_index_name
106: FROM jty_terr_values_idx_header
107: WHERE index_name like 'JTY_DNM_ATTR_VAL_' || abs(l_qual_type_usg_id) || '_RN%';
108:
109: INSERT INTO jty_terr_values_idx_header (
110: terr_values_idx_header_id

Line 109: INSERT INTO jty_terr_values_idx_header (

105: INTO l_index_name
106: FROM jty_terr_values_idx_header
107: WHERE index_name like 'JTY_DNM_ATTR_VAL_' || abs(l_qual_type_usg_id) || '_RN%';
108:
109: INSERT INTO jty_terr_values_idx_header (
110: terr_values_idx_header_id
111: ,source_id
112: ,last_update_date
113: ,last_updated_by

Line 514: UPDATE jty_terr_values_idx_header

510:
511: /* in incremental mode , if the qualifier is alreday present */
512: /* then mark it as being used by active territory */
513: IF (p_mode = 'INCREMENTAL') THEN
514: UPDATE jty_terr_values_idx_header
515: SET delete_flag = 'N'
516: WHERE source_id = p_source_id
517: AND qual_usg_id = p_qual_usg_id_tbl(i);
518: END IF; -- END IF (p_mode = 'INCREMENTAL')