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.BEN_COPY_EXTRACT dependencies on BEN_EXT_DATA_ELMT

Line 116: l_new_name ben_Ext_data_elmt.name%type ;

112: FUNCTION fix_name_length(p_curr_name IN VARCHAR2
113: ,p_name_maxlen IN NUMBER
114: ) RETURN VARCHAR2 IS
115:
116: l_new_name ben_Ext_data_elmt.name%type ;
117:
118: BEGIN
119:
120: if length(nvl(p_curr_name,0)) > p_name_maxlen then

Line 169: FROM ben_ext_data_elmt

165: ) RETURN NUMBER IS
166:
167: CURSOR c_new_data_elmt_id IS
168: SELECT ext_data_elmt_id
169: FROM ben_ext_data_elmt
170: WHERE (p_business_group_id is null
171: or p_business_group_id = business_group_id )
172: and name = (SELECT fix_name_length(p_new_extract_name||' '||name
173: ,c_ExtName_Maxlen)

Line 174: FROM ben_ext_data_elmt

170: WHERE (p_business_group_id is null
171: or p_business_group_id = business_group_id )
172: and name = (SELECT fix_name_length(p_new_extract_name||' '||name
173: ,c_ExtName_Maxlen)
174: FROM ben_ext_data_elmt
175: WHERE ext_data_elmt_id = p_curr_data_elmt_id);
176:
177: l_new_data_elmt_id NUMBER(15) := NULL;
178: l_proc VARCHAR2(72) := g_package||'get_new_data_elmt_id';

Line 204: FROM ben_ext_data_elmt_in_rcd

200: ,p_business_group_id in number
201: ) RETURN NUMBER IS
202: CURSOR c_new_data_elmt_in_rcd_id IS
203: SELECT ext_data_elmt_in_rcd_id
204: FROM ben_ext_data_elmt_in_rcd
205: WHERE ext_rcd_id = p_new_ext_rcd_id
206: AND ext_data_elmt_id = (SELECT ext_data_elmt_id
207: FROM ben_ext_data_elmt
208: WHERE (p_business_group_id is null or

Line 207: FROM ben_ext_data_elmt

203: SELECT ext_data_elmt_in_rcd_id
204: FROM ben_ext_data_elmt_in_rcd
205: WHERE ext_rcd_id = p_new_ext_rcd_id
206: AND ext_data_elmt_id = (SELECT ext_data_elmt_id
207: FROM ben_ext_data_elmt
208: WHERE (p_business_group_id is null or
209: p_business_group_id = business_group_id )
210: and name =
211: (SELECT fix_name_length(p_new_extract_name||' '||De.name

Line 213: FROM ben_ext_data_elmt De

209: p_business_group_id = business_group_id )
210: and name =
211: (SELECT fix_name_length(p_new_extract_name||' '||De.name
212: ,c_ExtName_Maxlen)
213: FROM ben_ext_data_elmt De
214: ,ben_ext_data_elmt_in_rcd DinR
215: WHERE DinR.ext_data_elmt_in_rcd_id = p_curr_cond_DinR_id
216: AND DinR.ext_data_elmt_id = De.ext_data_elmt_id
217: )

Line 214: ,ben_ext_data_elmt_in_rcd DinR

210: and name =
211: (SELECT fix_name_length(p_new_extract_name||' '||De.name
212: ,c_ExtName_Maxlen)
213: FROM ben_ext_data_elmt De
214: ,ben_ext_data_elmt_in_rcd DinR
215: WHERE DinR.ext_data_elmt_in_rcd_id = p_curr_cond_DinR_id
216: AND DinR.ext_data_elmt_id = De.ext_data_elmt_id
217: )
218: );

Line 248: FROM ben_ext_data_elmt_in_rcd

244: ) RETURN NUMBER IS
245:
246: CURSOR c_new_data_elmt_in_rcd_id IS
247: SELECT ext_data_elmt_in_rcd_id
248: FROM ben_ext_data_elmt_in_rcd
249: WHERE ext_rcd_id = (SELECT ext_rcd_id
250: FROM ben_ext_rcd_in_file
251: WHERE ext_rcd_in_file_id = p_new_rcd_in_file_id
252: )

Line 254: FROM ben_ext_data_elmt

250: FROM ben_ext_rcd_in_file
251: WHERE ext_rcd_in_file_id = p_new_rcd_in_file_id
252: )
253: AND ext_data_elmt_id = (SELECT ext_data_elmt_id
254: FROM ben_ext_data_elmt
255: WHERE name =
256: (SELECT fix_name_length(p_new_extract_name||' '||De.name
257: ,c_ExtName_Maxlen)
258: FROM ben_ext_data_elmt De

Line 258: FROM ben_ext_data_elmt De

254: FROM ben_ext_data_elmt
255: WHERE name =
256: (SELECT fix_name_length(p_new_extract_name||' '||De.name
257: ,c_ExtName_Maxlen)
258: FROM ben_ext_data_elmt De
259: ,ben_ext_data_elmt_in_rcd DinR
260: WHERE DinR.ext_data_elmt_in_rcd_id = p_curr_cond_DinR_id
261: AND DinR.ext_data_elmt_id = De.ext_data_elmt_id
262: )

Line 259: ,ben_ext_data_elmt_in_rcd DinR

255: WHERE name =
256: (SELECT fix_name_length(p_new_extract_name||' '||De.name
257: ,c_ExtName_Maxlen)
258: FROM ben_ext_data_elmt De
259: ,ben_ext_data_elmt_in_rcd DinR
260: WHERE DinR.ext_data_elmt_in_rcd_id = p_curr_cond_DinR_id
261: AND DinR.ext_data_elmt_id = De.ext_data_elmt_id
262: )
263: );

Line 735: FROM ben_ext_data_elmt_in_rcd DinR, ben_ext_data_elmt DElmt

731: );
732:
733: CURSOR c_ext_data_elmt_in_rcd(p_ext_rcd_id IN NUMBER) IS
734: SELECT DinR.*
735: FROM ben_ext_data_elmt_in_rcd DinR, ben_ext_data_elmt DElmt
736: WHERE DinR.ext_rcd_id = p_ext_rcd_id
737: AND Dinr.ext_data_elmt_id = DElmt.ext_data_elmt_id
738: AND ((DinR.business_group_id IS NULL AND DinR.legislation_code IS NULL)
739: OR (DinR.legislation_code IS NOT NULL

Line 748: FROM ben_ext_data_elmt

744: ORDER BY decode(DElmt.data_elmt_typ_cd,'T',1,'C',2,0), DinR.seq_num;
745:
746: CURSOR c_ext_data_elmt(p_ext_data_elmt_id IN NUMBER) IS
747: SELECT *
748: FROM ben_ext_data_elmt
749: WHERE ext_data_elmt_id = p_ext_data_elmt_id
750: AND ((business_group_id IS NULL AND legislation_code IS NULL)
751: OR (legislation_code IS NOT NULL
752: AND legislation_code = p_legislation_code)

Line 759: FROM ben_ext_data_elmt_decd

755: );
756:
757: CURSOR c_ext_data_elmt_decd(p_ext_data_elmt_id IN NUMBER) IS
758: SELECT *
759: FROM ben_ext_data_elmt_decd
760: WHERE ext_data_elmt_id = p_ext_data_elmt_id
761: AND ((business_group_id IS NULL AND legislation_code IS NULL)
762: OR (legislation_code IS NOT NULL
763: AND legislation_code = p_legislation_code)

Line 1042: BEGIN -- Insert new record in BEN_EXT_DATA_ELMT with New Extract Name Prefixed

1038: END IF; -- r_curr_data_elmt.ttl_sum_ext_data_elmt_id IS NOT NULL
1039:
1040: END IF; -- r_curr_data_elmt.data_elmt_typ_cd = 'T'
1041:
1042: BEGIN -- Insert new record in BEN_EXT_DATA_ELMT with New Extract Name Prefixed
1043: l_data_elmt_present := FALSE;
1044: ben_xel_ins.ins
1045: (
1046: p_ext_data_elmt_id => l_new_ext_data_elmt_id -- OUT

Line 1113: END; -- Insert into BEN_EXT_DATA_ELMT using Row Handler

1109: ,p_new_extract_name
1110: ,p_business_group_id
1111: );
1112: END IF;
1113: END; -- Insert into BEN_EXT_DATA_ELMT using Row Handler
1114:
1115: -- Insert new record in BEN_EXT_DATA_ELMT_IN_RCD using Row Handler
1116: ben_xer_ins.ins
1117: (

Line 1115: -- Insert new record in BEN_EXT_DATA_ELMT_IN_RCD using Row Handler

1111: );
1112: END IF;
1113: END; -- Insert into BEN_EXT_DATA_ELMT using Row Handler
1114:
1115: -- Insert new record in BEN_EXT_DATA_ELMT_IN_RCD using Row Handler
1116: ben_xer_ins.ins
1117: (
1118: p_ext_data_elmt_in_rcd_id => l_new_ext_data_elmt_in_rcd_id -- OUT
1119: ,p_seq_num => r_curr_data_elmt_in_rcd.seq_num

Line 1136: -- IF Data Element Type = DECODE then copy data in BEN_EXT_DATA_ELMT_DECD

1132: );
1133:
1134: IF NOT l_data_elmt_present THEN
1135:
1136: -- IF Data Element Type = DECODE then copy data in BEN_EXT_DATA_ELMT_DECD
1137: IF r_curr_data_elmt.data_elmt_typ_cd = 'D' THEN
1138:
1139: FOR r_curr_ext_data_elmt_decd IN c_ext_data_elmt_decd(r_curr_data_elmt.ext_data_elmt_id)
1140: LOOP -- 11 Get Data Element Decode data for current EXT_DATA_ELMT_ID

Line 1142: -- Insert new record in BEN_EXT_DATA_ELMT_DECD using Row Handler

1138:
1139: FOR r_curr_ext_data_elmt_decd IN c_ext_data_elmt_decd(r_curr_data_elmt.ext_data_elmt_id)
1140: LOOP -- 11 Get Data Element Decode data for current EXT_DATA_ELMT_ID
1141:
1142: -- Insert new record in BEN_EXT_DATA_ELMT_DECD using Row Handler
1143: ben_xdd_ins.ins
1144: (
1145: p_ext_data_elmt_decd_id => l_new_ext_data_elmt_decd_id -- OUT
1146: ,p_val => r_curr_ext_data_elmt_decd.val