APPS.HZ_MATCH_RULE_58 dependencies on HZ_STAGE_MAP_TRANSFORM

Line 2444: l_TX35_new:=(CASE l_TX35_new WHEN 'SYNC' THEN HZ_STAGE_MAP_TRANSFORM.den_acc_number (l_party_id) ELSE l_TX35_new END);

2440: l_party_id , l_TX34, l_TX35, l_TX40, l_TX39, l_TX45;
2441: EXIT WHEN l_party_cur%NOTFOUND;
2442: l_index := map_id(l_party_id);
2443: l_TX35_new:=RTRIM(LTRIM(l_TX35));
2444: l_TX35_new:=(CASE l_TX35_new WHEN 'SYNC' THEN HZ_STAGE_MAP_TRANSFORM.den_acc_number (l_party_id) ELSE l_TX35_new END);
2445: l_score := GET_PARTY_SCORE(l_TX34,l_TX35_new,l_TX40,l_TX39,l_TX45);
2446: IF NOT H_SCORES.EXISTS(l_index) THEN
2447: H_SCORES(l_index) := get_new_score_rec(l_score,l_score,defps,defct,defcpt, l_party_id, null, null,null);
2448: ELSE

Line 3421: l_TX35_new:=(CASE l_TX35_new WHEN 'SYNC' THEN HZ_STAGE_MAP_TRANSFORM.den_acc_number (l_party_id) ELSE l_TX35_new END);

3417: l_party_id , l_TX34, l_TX35, l_TX40, l_TX39, l_TX45;
3418: EXIT WHEN l_party_cur%NOTFOUND;
3419: l_index := map_id(l_party_id);
3420: l_TX35_new:=RTRIM(LTRIM(l_TX35));
3421: l_TX35_new:=(CASE l_TX35_new WHEN 'SYNC' THEN HZ_STAGE_MAP_TRANSFORM.den_acc_number (l_party_id) ELSE l_TX35_new END);
3422: l_score := GET_PARTY_SCORE(l_TX34,l_TX35_new,l_TX40,l_TX39,l_TX45);
3423: IF NOT H_SCORES.EXISTS(l_index) THEN
3424: H_SCORES(l_index) := get_new_score_rec(l_score,l_score,defps,defct,defcpt, l_party_id, null, null,null);
3425: ELSE

Line 5538: l_TX35_new:=(CASE l_TX35_new WHEN 'SYNC' THEN HZ_STAGE_MAP_TRANSFORM.den_acc_number (l_party_id) ELSE l_TX35_new END);

5534: FETCH l_party_cur INTO
5535: l_party_id , l_TX34, l_TX35, l_TX40, l_TX39, l_TX45;
5536: EXIT WHEN l_party_cur%NOTFOUND;
5537: l_TX35_new:=RTRIM(LTRIM(l_TX35));
5538: l_TX35_new:=(CASE l_TX35_new WHEN 'SYNC' THEN HZ_STAGE_MAP_TRANSFORM.den_acc_number (l_party_id) ELSE l_TX35_new END);
5539: INSERT_PARTY_SCORE(p_party_id, p_party_id, l_search_ctx_id, p_party_search_rec, g_party_stage_rec, l_TX34,l_TX35_new,l_TX40,l_TX39,l_TX45,1);
5540: END LOOP;
5541: CLOSE l_party_cur;
5542: