[Home] [Help]
128:
129: x_return_status := FND_API.G_RET_STS_SUCCESS;
130:
131: /* In incremental mode mark all the qualifier combination present */
132: /* in jtf_tae_qual_products as being used by active territories */
133: IF (p_mode = 'INCREMENTAL') THEN
134: UPDATE jty_terr_values_idx_header a
135: SET a.delete_flag = 'N'
136: WHERE a.source_id = p_source_id
136: WHERE a.source_id = p_source_id
137: AND a.delete_flag = 'Y'
138: AND a.relation_product in (
139: SELECT relation_product
140: FROM jtf_tae_qual_products
141: WHERE source_id = p_source_id );
142: ELSIF (p_mode = 'DEA INCREMENTAL') THEN
143: UPDATE jty_dea_values_idx_header a
144: SET a.delete_flag = 'N'
2511: OR end_date < g_sysdate);
2512:
2513: /* mark all the records to be deleted */
2514: /* delete_flag will be updated to 'N' for qualifiers that are used by active territories while generating real time matching sql */
2515: /* delete_flag will be updated to 'N' for qualifier combinations used by active territories after updating jtf_tae_qual_products */
2516: UPDATE jty_terr_values_idx_header
2517: SET delete_flag = 'Y'
2518: WHERE source_id = p_source_id;
2519: ELSIF (p_mode = 'DEA INCREMENTAL') THEN
2540: OR end_date < l_dea_incr_end_date);
2541:
2542: /* mark all the records to be deleted */
2543: /* delete_flag will be updated to 'N' for qualifiers that are used by active territories while generating real time matching sql */
2544: /* delete_flag will be updated to 'N' for qualifier combinations used by active territories after updating jtf_tae_qual_products */
2545: UPDATE jty_dea_values_idx_header
2546: SET delete_flag = 'Y'
2547: WHERE source_id = p_source_id;
2548: END IF;