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.EDR_RULE_TEMP dependencies on EDR_RULE_CONDITION_TEMP

Line 131: insert into edr_rule_condition_temp ( session_id, transaction_type_id, rule_id,

127: ( l_ssnid, p_trans_id, l_rule_ids(ith), l_rule_desc, l_rule_type, l_appr_type,
128: l_appr_desc, l_deft_use, l_date_0s(ith), l_date_1s(ith) );
129:
130: FOR jth IN 1..l_cond_ids.count LOOP
131: insert into edr_rule_condition_temp ( session_id, transaction_type_id, rule_id,
132: condition_id, condition_desc ) values ( l_ssnid, p_trans_id, l_rule_ids(ith),
133: l_cond_ids(jth), l_cond_desc(jth) );
134: END LOOP;
135:

Line 143: /* insert into edr_rule_condition_temp ( session_id, transaction_type_id, rule_id,

139:
140: insert into edr_rule_detail_temp ( session_id, transaction_type_id, rule_id, rule_name,
141: default_var, start_date, end_date) values ( l_ssnid, p_trans_id, l_rule_ids(ith),
142: l_rule_name, l_deft_use, l_date_0s(ith), l_date_1s(ith) );
143: /* insert into edr_rule_condition_temp ( session_id, transaction_type_id, rule_id,
144: condition_id, condition_desc )
145: values ( l_ssnid, p_trans_id, l_rule_ids(ith), null, null ); */
146: END;
147:

Line 229: insert into edr_rule_condition_temp ( session_id, transaction_type_id, rule_id, condition_id,

225: ( l_ssnid, l_trans_id, l_rule_id, l_rule_desc, l_rule_type, l_appr_type,
226: l_appr_desc, 'N', l_date_frm, l_date_end );
227:
228: FOR jth IN 1..l_cond_ids.count LOOP
229: insert into edr_rule_condition_temp ( session_id, transaction_type_id, rule_id, condition_id,
230: condition_desc ) values ( l_ssnid, l_trans_id, l_rule_id, l_cond_ids(jth), l_cond_desc(jth) );
231: END LOOP;
232:
233: EXCEPTION

Line 257: delete edr_rule_condition_temp where transaction_type_id = p_trans_id and SESSION_ID = l_ssnid;

253: select USERENV('SESSIONID') into l_ssnid from dual;
254:
255: delete edr_rule_detail_temp where transaction_type_id = p_trans_id and SESSION_ID = l_ssnid;
256:
257: delete edr_rule_condition_temp where transaction_type_id = p_trans_id and SESSION_ID = l_ssnid;
258:
259: END CLEAR_DETAILS_TRANS;
260:
261:

Line 273: delete edr_rule_condition_temp where transaction_type_id = p_trans_id

269:
270: delete edr_rule_detail_temp where transaction_type_id = p_trans_id
271: and RULE_ID = p_rule_id and SESSION_ID = l_ssnid;
272:
273: delete edr_rule_condition_temp where transaction_type_id = p_trans_id
274: and RULE_ID = p_rule_id and SESSION_ID = l_ssnid;
275:
276: END CLEAR_DETAILS_RULE;
277:

Line 358: insert into edr_rule_condition_temp ( session_id, transaction_type_id, rule_id, condition_id,

354: ( l_ssnid, p_trans_id, l_rule_ids(ith), l_rule_desc, l_rule_type, l_appr_type,
355: l_appr_desc, l_deft_use, l_date_0s(ith), l_date_1s(ith) );
356:
357: FOR jth IN 1..l_cond_ids.count LOOP
358: insert into edr_rule_condition_temp ( session_id, transaction_type_id, rule_id, condition_id,
359: condition_desc ) values
360: ( l_ssnid, p_trans_id, l_rule_ids(ith), l_cond_ids(jth), l_cond_desc(jth) );
361: END LOOP;
362:

Line 369: /* insert into edr_rule_condition_temp ( session_id, transaction_type_id, rule_id, condition_id,

365: select distinct description into l_rule_name from ame_rules where rule_id = l_rule_ids(ith);
366: insert into edr_rule_detail_temp ( session_id, transaction_type_id, rule_id, rule_name, default_var,
367: start_date, end_date) values ( l_ssnid, p_trans_id, l_rule_ids(ith),
368: l_rule_name, l_deft_use, l_date_0s(ith), l_date_1s(ith) );
369: /* insert into edr_rule_condition_temp ( session_id, transaction_type_id, rule_id, condition_id,
370: condition_desc ) values ( l_ssnid, p_trans_id, l_rule_ids(ith), null, null ); */
371: END;
372:
373: END LOOP;

Line 461: insert into edr_rule_condition_temp ( session_id, transaction_type_id, rule_id, condition_id,

457: ( l_ssnid, l_trans_id, l_rule_id, l_rule_desc, l_rule_type, l_appr_type,
458: l_appr_desc, 'N', l_date_frm, l_date_end );
459:
460: FOR jth IN 1..l_cond_ids.count LOOP
461: insert into edr_rule_condition_temp ( session_id, transaction_type_id, rule_id, condition_id,
462: condition_desc ) values ( l_ssnid, l_trans_id, l_rule_id, l_cond_ids(jth), l_cond_desc(jth) );
463: END LOOP;
464:
465: EXCEPTION

Line 566: insert into edr_rule_condition_temp ( session_id, transaction_type_id, rule_id, condition_id,

562: ( l_ssnid, p_trans_id, l_rule_ids(ith), l_rule_desc, l_rule_type, l_appr_type,
563: l_appr_desc, l_deft_use, l_date_0s(ith), l_date_1s(ith) );
564:
565: FOR jth IN 1..l_cond_ids.count LOOP
566: insert into edr_rule_condition_temp ( session_id, transaction_type_id, rule_id, condition_id,
567: condition_desc ) values
568: ( l_ssnid, p_trans_id, l_rule_ids(ith), l_cond_ids(jth), l_cond_desc(jth) );
569: END LOOP;
570:

Line 580: /* insert into edr_rule_condition_temp ( session_id, transaction_type_id, rule_id, condition_id,

576: -- 3171627 end: add end_date constraint to prevent multiple matches
577: insert into edr_rule_detail_temp ( session_id, transaction_type_id, rule_id, rule_name, default_var,
578: start_date, end_date) values ( l_ssnid, p_trans_id, l_rule_ids(ith),
579: l_rule_name, l_deft_use, l_date_0s(ith), l_date_1s(ith) );
580: /* insert into edr_rule_condition_temp ( session_id, transaction_type_id, rule_id, condition_id,
581: condition_desc ) values ( l_ssnid, p_trans_id, l_rule_ids(ith), null, null ); */
582: END;
583:
584: END LOOP;

Line 669: insert into edr_rule_condition_temp ( session_id, transaction_type_id, rule_id, condition_id,

665: ( l_ssnid, l_trans_id, l_rule_id, l_rule_desc, l_rule_type, l_appr_type,
666: l_appr_desc, 'N', l_date_frm, l_date_end );
667:
668: FOR jth IN 1..l_cond_ids.count LOOP
669: insert into edr_rule_condition_temp ( session_id, transaction_type_id, rule_id, condition_id,
670: condition_desc ) values ( l_ssnid, l_trans_id, l_rule_id, l_cond_ids(jth), l_cond_desc(jth) );
671: END LOOP;
672:
673: EXCEPTION

Line 776: INSERT INTO EDR_RULE_CONDITION_TEMP( SESSION_ID, TRANSACTION_TYPE_ID, RULE_ID, CONDITION_ID,CONDITION_DESC )

772: VALUES (L_SSNID, P_TRANSACTION_ID, L_RULE_IDS(ith), L_RULE_DESC, L_RULE_TYPE, L_APPR_TYPE,
773: L_APPR_DESC, L_DEFT_USE, L_DATE_0S(ith), L_DATE_1S(ith) );
774:
775: FOR jth IN 1..l_cond_ids.count LOOP
776: INSERT INTO EDR_RULE_CONDITION_TEMP( SESSION_ID, TRANSACTION_TYPE_ID, RULE_ID, CONDITION_ID,CONDITION_DESC )
777: VALUES ( L_SSNID, P_TRANSACTION_ID, L_RULE_IDS(ith), L_COND_IDS(jth), L_COND_DESC(jth) );
778: END LOOP;
779:
780: EXCEPTION

Line 869: INSERT INTO EDR_RULE_CONDITION_TEMP ( SESSION_ID, TRANSACTION_TYPE_ID,

865: VALUES (L_SSNID, P_TRANSACTION_ID, P_RULE_ID, L_RULE_DESC, L_RULE_TYPE, L_APPR_TYPE,
866: L_APPR_DESC, 'N', L_DATE_FRM, L_DATE_END );
867:
868: FOR JTH IN 1..L_COND_IDS.COUNT LOOP
869: INSERT INTO EDR_RULE_CONDITION_TEMP ( SESSION_ID, TRANSACTION_TYPE_ID,
870: RULE_ID, CONDITION_ID,CONDITION_DESC)
871: VALUES (L_SSNID, P_TRANSACTION_ID, P_RULE_ID, L_COND_IDS(JTH), L_COND_DESC(JTH) );
872:
873: END LOOP;