DBA Data[Home] [Help]

APPS.HZ_MATCH_RULE_33 dependencies on HZ_STAGE_MAP_TRANSFORM

Line 2879: 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);

2875: l_party_id , l_TX32, l_TX33, l_TX34, l_TX35, l_TX40, l_TX39;
2876: EXIT WHEN l_party_cur%NOTFOUND;
2877: l_index := map_id(l_party_id);
2878: l_TX35_new:=RTRIM(LTRIM(l_TX35));
2879: 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);
2880: l_score := GET_PARTY_SCORE(l_TX32,l_TX33,l_TX34,l_TX35_new,l_TX40,l_TX39);
2881: IF NOT H_SCORES.EXISTS(l_index) THEN
2882: H_SCORES(l_index) := get_new_score_rec(l_score,l_score,defps,defct,defcpt, l_party_id, null, null,null);
2883: ELSE

Line 3865: 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);

3861: l_party_id , l_TX32, l_TX33, l_TX34, l_TX35, l_TX40, l_TX39;
3862: EXIT WHEN l_party_cur%NOTFOUND;
3863: l_index := map_id(l_party_id);
3864: l_TX35_new:=RTRIM(LTRIM(l_TX35));
3865: 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);
3866: l_score := GET_PARTY_SCORE(l_TX32,l_TX33,l_TX34,l_TX35_new,l_TX40,l_TX39);
3867: IF NOT H_SCORES.EXISTS(l_index) THEN
3868: H_SCORES(l_index) := get_new_score_rec(l_score,l_score,defps,defct,defcpt, l_party_id, null, null,null);
3869: ELSE

Line 6050: 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);

6046: FETCH l_party_cur INTO
6047: l_party_id , l_TX32, l_TX33, l_TX34, l_TX35, l_TX40, l_TX39;
6048: EXIT WHEN l_party_cur%NOTFOUND;
6049: l_TX35_new:=RTRIM(LTRIM(l_TX35));
6050: 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);
6051: INSERT_PARTY_SCORE(p_party_id, p_party_id, l_search_ctx_id, p_party_search_rec, g_party_stage_rec, l_TX32,l_TX33,l_TX34,l_TX35_new,l_TX40,l_TX39,1);
6052: END LOOP;
6053: CLOSE l_party_cur;
6054: