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_DETAIL_TEMP

Line 125: insert into edr_rule_detail_temp ( session_id, transaction_type_id, rule_id, rule_name,

121: CONDITIONIDSOUT => l_cond_ids, CONDITIONDESCRIPTIONSOUT => l_cond_desc,
122: CONDITIONHASLOVSOUT => l_cond_lov, APPROVALTYPENAMEOUT => l_appr_name,
123: APPROVALTYPEDESCRIPTIONOUT => l_appr_type, APPROVALDESCRIPTIONOUT => l_appr_desc );
124: -- Bug 5167817 : end
125: insert into edr_rule_detail_temp ( session_id, transaction_type_id, rule_id, rule_name,
126: rule_type, appr_type, appr_desc, default_var, start_date, end_date ) values
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:

Line 140: insert into edr_rule_detail_temp ( session_id, transaction_type_id, rule_id, rule_name,

136: EXCEPTION
137: WHEN NO_DATA_FOUND THEN
138: select distinct description into l_rule_name from ame_rules where rule_id = l_rule_ids(ith);
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 )

Line 223: insert into edr_rule_detail_temp ( session_id, transaction_type_id, rule_id, rule_name,

219: APPROVALTYPEDESCRIPTIONOUT => l_appr_type,
220: APPROVALDESCRIPTIONOUT => l_appr_desc );
221: -- Bug 5167817 : end
222:
223: insert into edr_rule_detail_temp ( session_id, transaction_type_id, rule_id, rule_name,
224: rule_type, appr_type, appr_desc, default_var, start_date, end_date ) values
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:

Line 235: insert into edr_rule_detail_temp ( session_id, transaction_type_id, rule_id, rule_name, default_var,

231: END LOOP;
232:
233: EXCEPTION
234: WHEN NO_DATA_FOUND THEN
235: insert into edr_rule_detail_temp ( session_id, transaction_type_id, rule_id, rule_name, default_var,
236: start_date, end_date) values
237: ( l_ssnid, l_trans_id, l_rule_id, p_rule_name, 'N', l_date_frm, l_date_end );
238: END;
239:

Line 255: delete edr_rule_detail_temp where transaction_type_id = p_trans_id and SESSION_ID = l_ssnid;

251: l_ssnid NUMBER;
252: BEGIN
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;

Line 270: delete edr_rule_detail_temp where transaction_type_id = p_trans_id

266: l_apps_id NUMBER;
267: BEGIN
268: select USERENV('SESSIONID') into l_ssnid from dual;
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;

Line 352: insert into edr_rule_detail_temp ( session_id, transaction_type_id, rule_id, rule_name,

348: CONDITIONIDSOUT => l_cond_ids, CONDITIONDESCRIPTIONSOUT => l_cond_desc,
349: CONDITIONHASLOVSOUT => l_cond_lov, APPROVALTYPENAMEOUT => l_appr_name,
350: APPROVALTYPEDESCRIPTIONOUT => l_appr_type, APPROVALDESCRIPTIONOUT => l_appr_desc );
351: -- Bug 5167817 : end
352: insert into edr_rule_detail_temp ( session_id, transaction_type_id, rule_id, rule_name,
353: rule_type, appr_type, appr_desc, default_var, start_date, end_date ) values
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:

Line 366: insert into edr_rule_detail_temp ( session_id, transaction_type_id, rule_id, rule_name, default_var,

362:
363: EXCEPTION
364: WHEN NO_DATA_FOUND THEN
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 ); */

Line 455: insert into edr_rule_detail_temp ( session_id, transaction_type_id, rule_id, rule_name,

451: CONDITIONHASLOVSOUT => l_cond_lov, APPROVALTYPENAMEOUT => l_appr_name,
452: APPROVALTYPEDESCRIPTIONOUT => l_appr_type,
453: APPROVALDESCRIPTIONOUT => l_appr_desc );
454: -- Bug 5167817 : end
455: insert into edr_rule_detail_temp ( session_id, transaction_type_id, rule_id, rule_name,
456: rule_type, appr_type, appr_desc, default_var, start_date, end_date ) values
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:

Line 467: insert into edr_rule_detail_temp ( session_id, transaction_type_id, rule_id, rule_name,

463: END LOOP;
464:
465: EXCEPTION
466: WHEN NO_DATA_FOUND THEN
467: insert into edr_rule_detail_temp ( session_id, transaction_type_id, rule_id, rule_name,
468: default_var, start_date, end_date) values
469: ( l_ssnid, l_trans_id, l_rule_id, p_rule_name, 'N', l_date_frm, l_date_end );
470: END;
471:

Line 560: insert into edr_rule_detail_temp ( session_id, transaction_type_id, rule_id, rule_name,

556: CONDITIONIDSOUT => l_cond_ids, CONDITIONDESCRIPTIONSOUT => l_cond_desc,
557: CONDITIONHASLOVSOUT => l_cond_lov, APPROVALTYPENAMEOUT => l_appr_name,
558: APPROVALTYPEDESCRIPTIONOUT => l_appr_type, APPROVALDESCRIPTIONOUT => l_appr_desc );
559: -- Bug 5167817 : end
560: insert into edr_rule_detail_temp ( session_id, transaction_type_id, rule_id, rule_name,
561: rule_type, appr_type, appr_desc, default_var, start_date, end_date ) values
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:

Line 577: insert into edr_rule_detail_temp ( session_id, transaction_type_id, rule_id, rule_name, default_var,

573: -- 3171627 start: rule description can be changed in AME, rule_usages validation doesn't help here
574: select distinct description into l_rule_name from ame_rules
575: where rule_id = l_rule_ids(ith) and (end_date is null or end_date > sysdate);
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 ); */

Line 663: insert into edr_rule_detail_temp ( session_id, transaction_type_id, rule_id, rule_name,

659: CONDITIONHASLOVSOUT => l_cond_lov, APPROVALTYPENAMEOUT => l_appr_name,
660: APPROVALTYPEDESCRIPTIONOUT => l_appr_type,
661: APPROVALDESCRIPTIONOUT => l_appr_desc );
662: -- Bug 5167817 : end
663: insert into edr_rule_detail_temp ( session_id, transaction_type_id, rule_id, rule_name,
664: rule_type, appr_type, appr_desc, default_var, start_date, end_date ) values
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:

Line 675: insert into edr_rule_detail_temp ( session_id, transaction_type_id, rule_id, rule_name,

671: END LOOP;
672:
673: EXCEPTION
674: WHEN NO_DATA_FOUND THEN
675: insert into edr_rule_detail_temp ( session_id, transaction_type_id, rule_id, rule_name,
676: default_var, start_date, end_date) values
677: ( l_ssnid, l_trans_id, l_rule_id, p_rule_name, 'N', l_date_frm, l_date_end );
678: END;
679:

Line 770: INSERT INTO EDR_RULE_DETAIL_TEMP (SESSION_ID, TRANSACTION_TYPE_ID, RULE_ID, RULE_NAME,

766: APPROVALTYPENAMEOUT => L_APPR_NAME,
767: APPROVALTYPEDESCRIPTIONOUT => L_APPR_TYPE,
768: APPROVALDESCRIPTIONOUT => L_APPR_DESC );
769: -- Bug 5167817 : end
770: INSERT INTO EDR_RULE_DETAIL_TEMP (SESSION_ID, TRANSACTION_TYPE_ID, RULE_ID, RULE_NAME,
771: RULE_TYPE, APPR_TYPE, APPR_DESC, DEFAULT_VAR, START_DATE, END_DATE )
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:

Line 787: INSERT INTO EDR_RULE_DETAIL_TEMP ( SESSION_ID, TRANSACTION_TYPE_ID, RULE_ID, RULE_NAME,

783: SELECT DISTINCT DESCRIPTION
784: INTO L_RULE_NAME FROM AME_RULES_VL
785: WHERE RULE_ID = L_RULE_IDS(ith) AND (END_DATE IS NULL OR END_DATE > SYSDATE);
786:
787: INSERT INTO EDR_RULE_DETAIL_TEMP ( SESSION_ID, TRANSACTION_TYPE_ID, RULE_ID, RULE_NAME,
788: DEFAULT_VAR, START_DATE, END_DATE)
789: VALUES ( L_SSNID, P_TRANSACTION_ID, L_RULE_IDS(ith),L_RULE_NAME, L_DEFT_USE, L_DATE_0S(ith), L_DATE_1S(ith));
790: END;
791: END LOOP;

Line 863: INSERT INTO EDR_RULE_DETAIL_TEMP (SESSION_ID, TRANSACTION_TYPE_ID, RULE_ID, RULE_NAME, RULE_TYPE, APPR_TYPE,

859: APPROVALTYPENAMEOUT => L_APPR_NAME,
860: APPROVALTYPEDESCRIPTIONOUT => L_APPR_TYPE,
861: APPROVALDESCRIPTIONOUT => L_APPR_DESC );
862: -- Bug 5167817 : end
863: INSERT INTO EDR_RULE_DETAIL_TEMP (SESSION_ID, TRANSACTION_TYPE_ID, RULE_ID, RULE_NAME, RULE_TYPE, APPR_TYPE,
864: APPR_DESC, DEFAULT_VAR, START_DATE, END_DATE )
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:

Line 877: INSERT INTO EDR_RULE_DETAIL_TEMP (SESSION_ID, TRANSACTION_TYPE_ID, RULE_ID, RULE_NAME,

873: END LOOP;
874:
875: EXCEPTION
876: WHEN NO_DATA_FOUND THEN
877: INSERT INTO EDR_RULE_DETAIL_TEMP (SESSION_ID, TRANSACTION_TYPE_ID, RULE_ID, RULE_NAME,
878: DEFAULT_VAR, START_DATE, END_DATE)
879: VALUES(L_SSNID, P_TRANSACTION_ID, P_RULE_ID, L_RULE_NAME, 'N', L_DATE_FRM, L_DATE_END );
880: END;
881: