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.AME_RULE_UTILITY_PKG dependencies on AME_UTIL

Line 163: and cond.condition_type <> ame_util.listModConditionType

159: where cond.attribute_id = atr.attribute_id
160: and condu.condition_id = cond.condition_id
161: and condu.rule_id = rules.rule_id
162: and rules.rule_id = ruleIdIn
163: and cond.condition_type <> ame_util.listModConditionType
164: and atr.attribute_id not in (select attribute_id
165: from ame_attribute_usages
166: where application_id = applicationIdIn
167: and sysdate between start_date

Line 225: and itc.name <> ame_util.headerItemClassName

221: from ame_rules rul
222: ,ame_item_classes itc
223: where rul.rule_id = ruleIdIn
224: and rul.item_class_id = itc.item_class_id
225: and itc.name <> ame_util.headerItemClassName
226: and sysdate between itc.start_date and nvl(itc.end_date - (1/86400), sysdate)
227: and rul.end_date = endDateIn;
228: --+
229: cursor checkActionTypes(ruleIdIn in integer

Line 291: and con.condition_type = ame_util.listModConditionType

287: ,ame_condition_usages cnu
288: ,wf_roles wf
289: where rul.rule_id = ruleIdIn
290: and con.condition_id = cnu.condition_id
291: and con.condition_type = ame_util.listModConditionType
292: and cnu.rule_id = rul.rule_id
293: and con.parameter_two = wf.name
294: and wf.orig_system = 'POS'
295: and wf.status = 'ACTIVE'

Line 301: attributeIdList ame_util.idList;

297: and cnu.end_date = rul.end_date;
298: --+
299: dummy varchar2(1);
300: errorExists boolean;
301: attributeIdList ame_util.idList;
302: attributeNamesList ame_util.stringList;
303: itemClassName ame_item_classes.name%type;
304: applicationName ame_calling_apps.application_name%type;
305: tempValue ame_config_vars.variable_value%type;

Line 302: attributeNamesList ame_util.stringList;

298: --+
299: dummy varchar2(1);
300: errorExists boolean;
301: attributeIdList ame_util.idList;
302: attributeNamesList ame_util.stringList;
303: itemClassName ame_item_classes.name%type;
304: applicationName ame_calling_apps.application_name%type;
305: tempValue ame_config_vars.variable_value%type;
306: actionTypeIdList ame_util.idList;

Line 306: actionTypeIdList ame_util.idList;

302: attributeNamesList ame_util.stringList;
303: itemClassName ame_item_classes.name%type;
304: applicationName ame_calling_apps.application_name%type;
305: tempValue ame_config_vars.variable_value%type;
306: actionTypeIdList ame_util.idList;
307: actionTypeNameList ame_util.stringList;
308: endDate date;
309: --+
310: begin

Line 307: actionTypeNameList ame_util.stringList;

303: itemClassName ame_item_classes.name%type;
304: applicationName ame_calling_apps.application_name%type;
305: tempValue ame_config_vars.variable_value%type;
306: actionTypeIdList ame_util.idList;
307: actionTypeNameList ame_util.stringList;
308: endDate date;
309: --+
310: begin
311: errorExists := false;

Line 324: tempValue := ame_util.getConfigVar

320: close getApplicationName;
321: --+
322: --+
323: --+
324: tempValue := ame_util.getConfigVar
325: (variableNameIn => ame_util.allowAllICRulesConfigVar
326: ,applicationIdIn => applicationIdIn);
327: if(tempValue = ame_util.no) then
328: open getItemClass(ruleIdIn => ruleIdIn

Line 325: (variableNameIn => ame_util.allowAllICRulesConfigVar

321: --+
322: --+
323: --+
324: tempValue := ame_util.getConfigVar
325: (variableNameIn => ame_util.allowAllICRulesConfigVar
326: ,applicationIdIn => applicationIdIn);
327: if(tempValue = ame_util.no) then
328: open getItemClass(ruleIdIn => ruleIdIn
329: ,endDateIn => endDate);

Line 327: if(tempValue = ame_util.no) then

323: --+
324: tempValue := ame_util.getConfigVar
325: (variableNameIn => ame_util.allowAllICRulesConfigVar
326: ,applicationIdIn => applicationIdIn);
327: if(tempValue = ame_util.no) then
328: open getItemClass(ruleIdIn => ruleIdIn
329: ,endDateIn => endDate);
330: fetch getItemClass into dummy;
331: if(getItemClass%found) then

Line 345: tempValue := ame_util.getConfigVar

341: end if;
342: --+
343: --+
344: --+
345: tempValue := ame_util.getConfigVar
346: (variableNameIn => ame_util.allowAllApproverTypesConfigVar
347: ,applicationIdIn => applicationIdIn);
348: if(tempValue = ame_util.no) then
349: open checkLMConditions(ruleIdIn => ruleIdIn

Line 346: (variableNameIn => ame_util.allowAllApproverTypesConfigVar

342: --+
343: --+
344: --+
345: tempValue := ame_util.getConfigVar
346: (variableNameIn => ame_util.allowAllApproverTypesConfigVar
347: ,applicationIdIn => applicationIdIn);
348: if(tempValue = ame_util.no) then
349: open checkLMConditions(ruleIdIn => ruleIdIn
350: ,endDateIn => endDate);

Line 348: if(tempValue = ame_util.no) then

344: --+
345: tempValue := ame_util.getConfigVar
346: (variableNameIn => ame_util.allowAllApproverTypesConfigVar
347: ,applicationIdIn => applicationIdIn);
348: if(tempValue = ame_util.no) then
349: open checkLMConditions(ruleIdIn => ruleIdIn
350: ,endDateIn => endDate);
351: fetch checkLMConditions into dummy;
352: if(checkLMConditions%found) then

Line 366: tempValue := ame_util.getConfigVar

362: end if;
363: --+
364: --+ check prodution functionality
365: --+
366: tempValue := ame_util.getConfigVar
367: (variableNameIn => ame_util.productionConfigVar
368: ,applicationIdIn => applicationIdIn);
369:
370: if(tempValue <> ame_util.allProductions) then

Line 367: (variableNameIn => ame_util.productionConfigVar

363: --+
364: --+ check prodution functionality
365: --+
366: tempValue := ame_util.getConfigVar
367: (variableNameIn => ame_util.productionConfigVar
368: ,applicationIdIn => applicationIdIn);
369:
370: if(tempValue <> ame_util.allProductions) then
371: if(tempValue <> ame_util.perTransactionProductions and isProdRule(ruleIdIn)) then

Line 370: if(tempValue <> ame_util.allProductions) then

366: tempValue := ame_util.getConfigVar
367: (variableNameIn => ame_util.productionConfigVar
368: ,applicationIdIn => applicationIdIn);
369:
370: if(tempValue <> ame_util.allProductions) then
371: if(tempValue <> ame_util.perTransactionProductions and isProdRule(ruleIdIn)) then
372: fnd_message.set_name('PER','AME_400639_TTY_NO_PROD_RULES');
373: fnd_message.set_token('TXTYPENAME',applicationName);
374: hr_multi_message.add (p_associated_column1 => 'RULE_ID');

Line 371: if(tempValue <> ame_util.perTransactionProductions and isProdRule(ruleIdIn)) then

367: (variableNameIn => ame_util.productionConfigVar
368: ,applicationIdIn => applicationIdIn);
369:
370: if(tempValue <> ame_util.allProductions) then
371: if(tempValue <> ame_util.perTransactionProductions and isProdRule(ruleIdIn)) then
372: fnd_message.set_name('PER','AME_400639_TTY_NO_PROD_RULES');
373: fnd_message.set_token('TXTYPENAME',applicationName);
374: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
375: resultOut := 'N';

Line 378: elsif(tempValue <> ame_util.perApproverProductions and hasProductionActions(ruleIdIn,endDate) and not isProdRule(ruleIdIn)) then

374: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
375: resultOut := 'N';
376: fnd_message.raise_error;
377: return;
378: elsif(tempValue <> ame_util.perApproverProductions and hasProductionActions(ruleIdIn,endDate) and not isProdRule(ruleIdIn)) then
379: fnd_message.set_name('PER','AME_400640_TTY_NO_PROD_ACTIONS');
380: fnd_message.set_token('TXTYPENAME',applicationName);
381: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
382: resultOut := 'N';

Line 499: and cond.condition_type <> ame_util.listModConditionType

495: where cond.attribute_id = atr.attribute_id
496: and condu.condition_id = cond.condition_id
497: and condu.rule_id = rules.rule_id
498: and rules.rule_id = ruleIdIn
499: and cond.condition_type <> ame_util.listModConditionType
500: and atr.attribute_id not in (select attribute_id
501: from ame_attribute_usages
502: where application_id = applicationIdIn
503: and sysdate between start_date

Line 575: and itc.name <> ame_util.headerItemClassName

571: from ame_rules rul
572: ,ame_item_classes itc
573: where rul.rule_id = ruleIdIn
574: and rul.item_class_id = itc.item_class_id
575: and itc.name <> ame_util.headerItemClassName
576: and sysdate between itc.start_date and nvl(itc.end_date - (1/86400), sysdate)
577: and ((sysdate between rul.start_date and nvl(rul.end_date - (1/86400),sysdate))
578: or
579: (sysdate < rul.start_date and rul.start_date < nvl(rul.end_date, rul.start_date + (1/86400)))

Line 666: attributeIdList ame_util.idList;

662: );
663: --+
664: dummy varchar2(1);
665: errorExists boolean;
666: attributeIdList ame_util.idList;
667: attributeNamesList ame_util.stringList;
668: itemClassName ame_item_classes.name%type;
669: applicationName ame_calling_apps.application_name%type;
670: tempValue ame_config_vars.variable_value%type;

Line 667: attributeNamesList ame_util.stringList;

663: --+
664: dummy varchar2(1);
665: errorExists boolean;
666: attributeIdList ame_util.idList;
667: attributeNamesList ame_util.stringList;
668: itemClassName ame_item_classes.name%type;
669: applicationName ame_calling_apps.application_name%type;
670: tempValue ame_config_vars.variable_value%type;
671: actionTypeIdList ame_util.idList;

Line 671: actionTypeIdList ame_util.idList;

667: attributeNamesList ame_util.stringList;
668: itemClassName ame_item_classes.name%type;
669: applicationName ame_calling_apps.application_name%type;
670: tempValue ame_config_vars.variable_value%type;
671: actionTypeIdList ame_util.idList;
672: actionTypeNameList ame_util.stringList;
673: endDate date;
674: --+
675: begin

Line 672: actionTypeNameList ame_util.stringList;

668: itemClassName ame_item_classes.name%type;
669: applicationName ame_calling_apps.application_name%type;
670: tempValue ame_config_vars.variable_value%type;
671: actionTypeIdList ame_util.idList;
672: actionTypeNameList ame_util.stringList;
673: endDate date;
674: --+
675: begin
676: errorExists := false;

Line 710: tempValue := ame_util.getConfigVar

706: close getApplicationName;
707: --+
708: --+
709: --+
710: tempValue := ame_util.getConfigVar
711: (variableNameIn => ame_util.allowAllICRulesConfigVar
712: ,applicationIdIn => applicationIdIn);
713: if(tempValue = ame_util.no) then
714: open getItemClass(ruleIdIn => ruleIdIn);

Line 711: (variableNameIn => ame_util.allowAllICRulesConfigVar

707: --+
708: --+
709: --+
710: tempValue := ame_util.getConfigVar
711: (variableNameIn => ame_util.allowAllICRulesConfigVar
712: ,applicationIdIn => applicationIdIn);
713: if(tempValue = ame_util.no) then
714: open getItemClass(ruleIdIn => ruleIdIn);
715: fetch getItemClass into dummy;

Line 713: if(tempValue = ame_util.no) then

709: --+
710: tempValue := ame_util.getConfigVar
711: (variableNameIn => ame_util.allowAllICRulesConfigVar
712: ,applicationIdIn => applicationIdIn);
713: if(tempValue = ame_util.no) then
714: open getItemClass(ruleIdIn => ruleIdIn);
715: fetch getItemClass into dummy;
716: if(getItemClass%found) then
717: fnd_message.set_name('PER','AME_400633_SUBITC_TTY_NO_USAGE');

Line 730: tempValue := ame_util.getConfigVar

726: end if;
727: --+
728: --+ check LM Conditions
729: --+
730: tempValue := ame_util.getConfigVar
731: (variableNameIn => ame_util.allowAllApproverTypesConfigVar
732: ,applicationIdIn => applicationIdIn);
733: if(tempValue = ame_util.no) then
734: open checkLMConditions(ruleIdIn => ruleIdIn);

Line 731: (variableNameIn => ame_util.allowAllApproverTypesConfigVar

727: --+
728: --+ check LM Conditions
729: --+
730: tempValue := ame_util.getConfigVar
731: (variableNameIn => ame_util.allowAllApproverTypesConfigVar
732: ,applicationIdIn => applicationIdIn);
733: if(tempValue = ame_util.no) then
734: open checkLMConditions(ruleIdIn => ruleIdIn);
735: fetch checkLMConditions into dummy;

Line 733: if(tempValue = ame_util.no) then

729: --+
730: tempValue := ame_util.getConfigVar
731: (variableNameIn => ame_util.allowAllApproverTypesConfigVar
732: ,applicationIdIn => applicationIdIn);
733: if(tempValue = ame_util.no) then
734: open checkLMConditions(ruleIdIn => ruleIdIn);
735: fetch checkLMConditions into dummy;
736: if(checkLMConditions%found) then
737: fnd_message.set_name('PER','AME_400641_TTY_INV_APPR_TYPE');

Line 750: tempValue := ame_util.getConfigVar

746: end if;
747: --+
748: --+ check prodution functionality
749: --+
750: tempValue := ame_util.getConfigVar
751: (variableNameIn => ame_util.productionConfigVar
752: ,applicationIdIn => applicationIdIn);
753: if(tempValue <> ame_util.allProductions) then
754: if(tempValue <> ame_util.perTransactionProductions and isProdRule(ruleIdIn)) then

Line 751: (variableNameIn => ame_util.productionConfigVar

747: --+
748: --+ check prodution functionality
749: --+
750: tempValue := ame_util.getConfigVar
751: (variableNameIn => ame_util.productionConfigVar
752: ,applicationIdIn => applicationIdIn);
753: if(tempValue <> ame_util.allProductions) then
754: if(tempValue <> ame_util.perTransactionProductions and isProdRule(ruleIdIn)) then
755: fnd_message.set_name('PER','AME_400639_TTY_NO_PROD_RULES');

Line 753: if(tempValue <> ame_util.allProductions) then

749: --+
750: tempValue := ame_util.getConfigVar
751: (variableNameIn => ame_util.productionConfigVar
752: ,applicationIdIn => applicationIdIn);
753: if(tempValue <> ame_util.allProductions) then
754: if(tempValue <> ame_util.perTransactionProductions and isProdRule(ruleIdIn)) then
755: fnd_message.set_name('PER','AME_400639_TTY_NO_PROD_RULES');
756: fnd_message.set_token('TXTYPENAME',applicationName);
757: hr_multi_message.add (p_associated_column1 => 'RULE_ID');

Line 754: if(tempValue <> ame_util.perTransactionProductions and isProdRule(ruleIdIn)) then

750: tempValue := ame_util.getConfigVar
751: (variableNameIn => ame_util.productionConfigVar
752: ,applicationIdIn => applicationIdIn);
753: if(tempValue <> ame_util.allProductions) then
754: if(tempValue <> ame_util.perTransactionProductions and isProdRule(ruleIdIn)) then
755: fnd_message.set_name('PER','AME_400639_TTY_NO_PROD_RULES');
756: fnd_message.set_token('TXTYPENAME',applicationName);
757: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
758: resultOut := 'N';

Line 761: elsif(tempValue <> ame_util.perApproverProductions and hasProductionActions(ruleIdIn,endDate) and not isProdRule(ruleIdIn)) then

757: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
758: resultOut := 'N';
759: fnd_message.raise_error;
760: return;
761: elsif(tempValue <> ame_util.perApproverProductions and hasProductionActions(ruleIdIn,endDate) and not isProdRule(ruleIdIn)) then
762: fnd_message.set_name('PER','AME_400640_TTY_NO_PROD_ACTIONS');
763: fnd_message.set_token('TXTYPENAME',applicationName);
764: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
765: resultOut := 'N';

Line 1111: and nvl(rlu.end_date - ame_util.oneSecond, sysdate) or

1107: where rlu.rule_id = ruleIdIn
1108: and aca.application_id = rlu.item_id
1109: and sysdate between aca.start_date and nvl(aca.end_date - (1/86400), sysdate)
1110: and (sysdate between rlu.start_date
1111: and nvl(rlu.end_date - ame_util.oneSecond, sysdate) or
1112: (sysdate < rlu.start_date
1113: and rlu.start_date < nvl(rlu.end_date, rlu.start_date + ame_util.oneSecond)));
1114: --+
1115: cursor getInvalidAttributes(applicationIdIn in integer

Line 1113: and rlu.start_date < nvl(rlu.end_date, rlu.start_date + ame_util.oneSecond)));

1109: and sysdate between aca.start_date and nvl(aca.end_date - (1/86400), sysdate)
1110: and (sysdate between rlu.start_date
1111: and nvl(rlu.end_date - ame_util.oneSecond, sysdate) or
1112: (sysdate < rlu.start_date
1113: and rlu.start_date < nvl(rlu.end_date, rlu.start_date + ame_util.oneSecond)));
1114: --+
1115: cursor getInvalidAttributes(applicationIdIn in integer
1116: ,conditionIdIn in integer) is
1117: select atr.attribute_id, atr.name

Line 1122: and con.condition_type <> ame_util.listModConditionType

1118: from ame_attributes atr
1119: ,ame_conditions con
1120: where atr.attribute_id = con.attribute_id
1121: and con.condition_id = conditionIdIn
1122: and con.condition_type <> ame_util.listModConditionType
1123: and sysdate between atr.start_date and nvl(atr.end_date - (1/86400), sysdate)
1124: and sysdate between con.start_date and nvl(con.end_date - (1/86400), sysdate)
1125: and not exists (select attribute_id
1126: from ame_attribute_usages atu

Line 1137: and con.condition_type = ame_util.listModConditionType

1133: select 'Y'
1134: from ame_conditions con
1135: ,wf_roles wf
1136: where con.condition_id = conditionIdIn
1137: and con.condition_type = ame_util.listModConditionType
1138: and con.parameter_two = wf.name
1139: and wf.orig_system = 'POS'
1140: and wf.status = 'ACTIVE'
1141: and sysdate between con.start_date and nvl(con.end_date - (1/86400), sysdate);

Line 1143: attributeIdList ame_util.idList;

1139: and wf.orig_system = 'POS'
1140: and wf.status = 'ACTIVE'
1141: and sysdate between con.start_date and nvl(con.end_date - (1/86400), sysdate);
1142: --+
1143: attributeIdList ame_util.idList;
1144: attributeNameList ame_util.stringList;
1145: tempValue ame_config_vars.variable_value%type;
1146: dummy varchar2(1);
1147: errorExists boolean;

Line 1144: attributeNameList ame_util.stringList;

1140: and wf.status = 'ACTIVE'
1141: and sysdate between con.start_date and nvl(con.end_date - (1/86400), sysdate);
1142: --+
1143: attributeIdList ame_util.idList;
1144: attributeNameList ame_util.stringList;
1145: tempValue ame_config_vars.variable_value%type;
1146: dummy varchar2(1);
1147: errorExists boolean;
1148: begin

Line 1168: tempValue := ame_util.getConfigVar

1164: close getInvalidAttributes;
1165: end loop;
1166: --+
1167: for rec in getApplications loop
1168: tempValue := ame_util.getConfigVar
1169: (variableNameIn => ame_util.allowAllApproverTypesConfigVar
1170: ,applicationIdIn => rec.application_id);
1171: if(tempValue = ame_util.no) then
1172: open checkLMCondition(conditionIdIn => conditionIdIn);

Line 1169: (variableNameIn => ame_util.allowAllApproverTypesConfigVar

1165: end loop;
1166: --+
1167: for rec in getApplications loop
1168: tempValue := ame_util.getConfigVar
1169: (variableNameIn => ame_util.allowAllApproverTypesConfigVar
1170: ,applicationIdIn => rec.application_id);
1171: if(tempValue = ame_util.no) then
1172: open checkLMCondition(conditionIdIn => conditionIdIn);
1173: fetch checkLMCondition into dummy;

Line 1171: if(tempValue = ame_util.no) then

1167: for rec in getApplications loop
1168: tempValue := ame_util.getConfigVar
1169: (variableNameIn => ame_util.allowAllApproverTypesConfigVar
1170: ,applicationIdIn => rec.application_id);
1171: if(tempValue = ame_util.no) then
1172: open checkLMCondition(conditionIdIn => conditionIdIn);
1173: fetch checkLMCondition into dummy;
1174: if(checkLMCondition%found) then
1175: fnd_message.set_name('PER','AME_400641_TTY_INV_APPR_TYPE');

Line 1198: and nvl(rlu.end_date - ame_util.oneSecond, sysdate) or

1194: where rlu.rule_id = ruleIdIn
1195: and aca.application_id = rlu.item_id
1196: and sysdate between aca.start_date and nvl(aca.end_date - (1/86400), sysdate)
1197: and (sysdate between rlu.start_date
1198: and nvl(rlu.end_date - ame_util.oneSecond, sysdate) or
1199: (sysdate < rlu.start_date
1200: and rlu.start_date < nvl(rlu.end_date, rlu.start_date + ame_util.oneSecond)));
1201: --+
1202: cursor getInvalidActionTypes(applicationIdIn in integer

Line 1200: and rlu.start_date < nvl(rlu.end_date, rlu.start_date + ame_util.oneSecond)));

1196: and sysdate between aca.start_date and nvl(aca.end_date - (1/86400), sysdate)
1197: and (sysdate between rlu.start_date
1198: and nvl(rlu.end_date - ame_util.oneSecond, sysdate) or
1199: (sysdate < rlu.start_date
1200: and rlu.start_date < nvl(rlu.end_date, rlu.start_date + ame_util.oneSecond)));
1201: --+
1202: cursor getInvalidActionTypes(applicationIdIn in integer
1203: ,actionIdIn in integer) is
1204: select aty.action_type_id, aty.name

Line 1249: and aty.name in (ame_util.preApprovalTypeName

1245: from ame_approval_group_config agf
1246: where agf.application_id = applicationIdIn
1247: and sysdate between agf.start_date
1248: and nvl(agf.end_date - (1/86400), sysdate))
1249: and aty.name in (ame_util.preApprovalTypeName
1250: ,ame_util.postApprovalTypeName
1251: ,ame_util.groupChainApprovalTypeName)
1252: and sysdate between aty.start_date and nvl(aty.end_date - (1/86400), sysdate)
1253: and sysdate between act.start_date and nvl(act.end_date - (1/86400), sysdate)

Line 1250: ,ame_util.postApprovalTypeName

1246: where agf.application_id = applicationIdIn
1247: and sysdate between agf.start_date
1248: and nvl(agf.end_date - (1/86400), sysdate))
1249: and aty.name in (ame_util.preApprovalTypeName
1250: ,ame_util.postApprovalTypeName
1251: ,ame_util.groupChainApprovalTypeName)
1252: and sysdate between aty.start_date and nvl(aty.end_date - (1/86400), sysdate)
1253: and sysdate between act.start_date and nvl(act.end_date - (1/86400), sysdate)
1254: and sysdate between apg.start_date and nvl(apg.end_date - (1/86400), sysdate);

Line 1251: ,ame_util.groupChainApprovalTypeName)

1247: and sysdate between agf.start_date
1248: and nvl(agf.end_date - (1/86400), sysdate))
1249: and aty.name in (ame_util.preApprovalTypeName
1250: ,ame_util.postApprovalTypeName
1251: ,ame_util.groupChainApprovalTypeName)
1252: and sysdate between aty.start_date and nvl(aty.end_date - (1/86400), sysdate)
1253: and sysdate between act.start_date and nvl(act.end_date - (1/86400), sysdate)
1254: and sysdate between apg.start_date and nvl(apg.end_date - (1/86400), sysdate);
1255: --+

Line 1256: actionTypeIdList ame_util.idList;

1252: and sysdate between aty.start_date and nvl(aty.end_date - (1/86400), sysdate)
1253: and sysdate between act.start_date and nvl(act.end_date - (1/86400), sysdate)
1254: and sysdate between apg.start_date and nvl(apg.end_date - (1/86400), sysdate);
1255: --+
1256: actionTypeIdList ame_util.idList;
1257: actionTypeNameList ame_util.stringList;
1258: attributeIdList ame_util.idList;
1259: attributeNameList ame_util.stringList;
1260: tempValue ame_config_vars.variable_value%type;

Line 1257: actionTypeNameList ame_util.stringList;

1253: and sysdate between act.start_date and nvl(act.end_date - (1/86400), sysdate)
1254: and sysdate between apg.start_date and nvl(apg.end_date - (1/86400), sysdate);
1255: --+
1256: actionTypeIdList ame_util.idList;
1257: actionTypeNameList ame_util.stringList;
1258: attributeIdList ame_util.idList;
1259: attributeNameList ame_util.stringList;
1260: tempValue ame_config_vars.variable_value%type;
1261: errorExists boolean;

Line 1258: attributeIdList ame_util.idList;

1254: and sysdate between apg.start_date and nvl(apg.end_date - (1/86400), sysdate);
1255: --+
1256: actionTypeIdList ame_util.idList;
1257: actionTypeNameList ame_util.stringList;
1258: attributeIdList ame_util.idList;
1259: attributeNameList ame_util.stringList;
1260: tempValue ame_config_vars.variable_value%type;
1261: errorExists boolean;
1262: begin

Line 1259: attributeNameList ame_util.stringList;

1255: --+
1256: actionTypeIdList ame_util.idList;
1257: actionTypeNameList ame_util.stringList;
1258: attributeIdList ame_util.idList;
1259: attributeNameList ame_util.stringList;
1260: tempValue ame_config_vars.variable_value%type;
1261: errorExists boolean;
1262: begin
1263: errorExists := false;

Line 1306: tempValue := ame_util.getConfigVar

1302: return;
1303: end if;
1304: --+
1305: for rec in getApplications loop
1306: tempValue := ame_util.getConfigVar
1307: (variableNameIn => ame_util.productionConfigVar
1308: ,applicationIdIn => rec.application_id);
1309: if(tempValue = ame_util.noProductions and isProductionAction(actionIdIn)) then
1310: fnd_message.set_name('PER','AME_400640_TTY_NO_PROD_ACTIONS');

Line 1307: (variableNameIn => ame_util.productionConfigVar

1303: end if;
1304: --+
1305: for rec in getApplications loop
1306: tempValue := ame_util.getConfigVar
1307: (variableNameIn => ame_util.productionConfigVar
1308: ,applicationIdIn => rec.application_id);
1309: if(tempValue = ame_util.noProductions and isProductionAction(actionIdIn)) then
1310: fnd_message.set_name('PER','AME_400640_TTY_NO_PROD_ACTIONS');
1311: fnd_message.set_token('TXTYPENAME',rec.application_name);

Line 1309: if(tempValue = ame_util.noProductions and isProductionAction(actionIdIn)) then

1305: for rec in getApplications loop
1306: tempValue := ame_util.getConfigVar
1307: (variableNameIn => ame_util.productionConfigVar
1308: ,applicationIdIn => rec.application_id);
1309: if(tempValue = ame_util.noProductions and isProductionAction(actionIdIn)) then
1310: fnd_message.set_name('PER','AME_400640_TTY_NO_PROD_ACTIONS');
1311: fnd_message.set_token('TXTYPENAME',rec.application_name);
1312: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
1313: end if;

Line 1345: and nvl(end_date - ame_util.oneSecond, sysdate )

1341: into p_rul_start_date
1342: from ame_rule_usages
1343: where rule_id = p_rule_id
1344: and (sysdate between start_date
1345: and nvl(end_date - ame_util.oneSecond, sysdate )
1346: or
1347: (sysdate < start_date
1348: and start_date < nvl(end_date, start_date + ame_util.oneSecond)));
1349: select max(end_date)

Line 1348: and start_date < nvl(end_date, start_date + ame_util.oneSecond)));

1344: and (sysdate between start_date
1345: and nvl(end_date - ame_util.oneSecond, sysdate )
1346: or
1347: (sysdate < start_date
1348: and start_date < nvl(end_date, start_date + ame_util.oneSecond)));
1349: select max(end_date)
1350: into p_rul_end_date
1351: from ame_rule_usages
1352: where rule_id = p_rule_id

Line 1354: and nvl(end_date - ame_util.oneSecond, sysdate )

1350: into p_rul_end_date
1351: from ame_rule_usages
1352: where rule_id = p_rule_id
1353: and (sysdate between start_date
1354: and nvl(end_date - ame_util.oneSecond, sysdate )
1355: or
1356: (sysdate < start_date
1357: and start_date < nvl(end_date, start_date + ame_util.oneSecond)));
1358: end fetchNewRuleDates2;

Line 1357: and start_date < nvl(end_date, start_date + ame_util.oneSecond)));

1353: and (sysdate between start_date
1354: and nvl(end_date - ame_util.oneSecond, sysdate )
1355: or
1356: (sysdate < start_date
1357: and start_date < nvl(end_date, start_date + ame_util.oneSecond)));
1358: end fetchNewRuleDates2;
1359:
1360: --+
1361: procedure syncRuleObjects(p_rule_id in number

Line 1386: and nvl(end_date - ame_util.oneSecond, l_effective_date))

1382: ,object_version_number
1383: from ame_action_usages
1384: where rule_id = p_rule_id
1385: and ((l_effective_date between start_date
1386: and nvl(end_date - ame_util.oneSecond, l_effective_date))
1387: or
1388: (l_effective_date < start_date
1389: and start_date < nvl(end_date, start_date + ame_util.oneSecond)));
1390: --+

Line 1389: and start_date < nvl(end_date, start_date + ame_util.oneSecond)));

1385: and ((l_effective_date between start_date
1386: and nvl(end_date - ame_util.oneSecond, l_effective_date))
1387: or
1388: (l_effective_date < start_date
1389: and start_date < nvl(end_date, start_date + ame_util.oneSecond)));
1390: --+
1391: cursor getConditions(l_effective_date in date) is
1392: select condition_id
1393: ,start_date

Line 1399: and nvl(end_date - ame_util.oneSecond, l_effective_date))

1395: ,object_version_number
1396: from ame_condition_usages
1397: where rule_id = p_rule_id
1398: and ((l_effective_date between start_date
1399: and nvl(end_date - ame_util.oneSecond, l_effective_date))
1400: or
1401: (l_effective_date < start_date
1402: and start_date < nvl(end_date, start_date + ame_util.oneSecond)));
1403: --+

Line 1402: and start_date < nvl(end_date, start_date + ame_util.oneSecond)));

1398: and ((l_effective_date between start_date
1399: and nvl(end_date - ame_util.oneSecond, l_effective_date))
1400: or
1401: (l_effective_date < start_date
1402: and start_date < nvl(end_date, start_date + ame_util.oneSecond)));
1403: --+
1404:
1405: cursor getRuleDetails(l_effective_date in date) is
1406: select start_date

Line 1411: and ((l_effective_date between start_date and nvl(end_date - ame_util.oneSecond, l_effective_date))

1407: ,end_date
1408: ,object_version_number
1409: from ame_rules
1410: where rule_id = p_rule_id
1411: and ((l_effective_date between start_date and nvl(end_date - ame_util.oneSecond, l_effective_date))
1412: or
1413: (l_effective_date < start_date and start_date < nvl(end_date,start_date + ame_util.oneSecond)));
1414: --+
1415:

Line 1413: (l_effective_date < start_date and start_date < nvl(end_date,start_date + ame_util.oneSecond)));

1409: from ame_rules
1410: where rule_id = p_rule_id
1411: and ((l_effective_date between start_date and nvl(end_date - ame_util.oneSecond, l_effective_date))
1412: or
1413: (l_effective_date < start_date and start_date < nvl(end_date,start_date + ame_util.oneSecond)));
1414: --+
1415:
1416: begin
1417:

Line 1773: actionIdList ame_util.idList;

1769: or
1770: (sysdate < acu.start_date and acu.start_date < nvl(acu.end_date, acu.start_date + (1/86400)))
1771: );
1772: --+
1773: actionIdList ame_util.idList;
1774: l_result number(2);
1775: begin
1776: --+
1777: open getRuleActions(p_rule_id => p_rule_id);

Line 1824: conditionIdList ame_util.idList;

1820: or
1821: (sysdate < cnu.start_date and cnu.start_date < nvl(cnu.end_date, cnu.start_date + (1/86400)))
1822: );
1823: --+
1824: conditionIdList ame_util.idList;
1825: begin
1826: --+
1827: open getRuleConditions(p_rule_id => p_rule_id);
1828: fetch getRuleConditions

Line 1917: temp := ame_util.getConfigVar

1913: function is_prod_action_allowed(p_application_id in integer) return boolean is
1914: temp ame_config_vars.variable_value%type;
1915: begin
1916: --+
1917: temp := ame_util.getConfigVar
1918: (variableNameIn => ame_util.productionConfigVar
1919: ,applicationIdIn => p_application_id);
1920: --+
1921: if temp = 'all' or temp = 'approver' then

Line 1918: (variableNameIn => ame_util.productionConfigVar

1914: temp ame_config_vars.variable_value%type;
1915: begin
1916: --+
1917: temp := ame_util.getConfigVar
1918: (variableNameIn => ame_util.productionConfigVar
1919: ,applicationIdIn => p_application_id);
1920: --+
1921: if temp = 'all' or temp = 'approver' then
1922: return true;

Line 1942: and cnd.condition_type = ame_util.listModConditionType

1938: ,ame_conditions cnd
1939: where rul.rule_id = p_rule_id
1940: and cnu.rule_id = rul.rule_id
1941: and cnd.condition_id = cnu.condition_id
1942: and cnd.condition_type = ame_util.listModConditionType
1943: and rul.rule_type = 0
1944: and sysdate between cnd.start_date and nvl(cnd.end_date - (1/86400),sysdate)
1945: and ((sysdate between rul.start_date and nvl(rul.end_date - (1/86400),sysdate))
1946: or

Line 1981: and cnd.condition_type <> ame_util.listModConditionType

1977: select count(*)
1978: from ame_conditions cnd
1979: ,ame_attribute_usages atu
1980: where cnd.condition_id = p_condition_id
1981: and cnd.condition_type <> ame_util.listModConditionType
1982: and atu.application_id = p_application_id
1983: and cnd.attribute_id = atu.attribute_id
1984: and sysdate between cnd.start_date and nvl(cnd.end_date - (1/86400),sysdate)
1985: and sysdate between atu.start_date and nvl(atu.end_date - (1/86400),sysdate);

Line 1995: where condition_type = ame_util.listModConditionType

1991: --+
1992: select count(*)
1993: into lm_count
1994: from ame_conditions
1995: where condition_type = ame_util.listModConditionType
1996: and condition_id = p_condition_id
1997: and sysdate between start_date and nvl(end_date - (1/86400),sysdate);
1998: --+
1999: if lm_count = 0 then

Line 2057: and (atyu.rule_type <> ame_util.productionRuleType

2053: and rul.rule_id = p_rule_id
2054: and rul.rule_id = acu.rule_id
2055: and acu.action_id = act.action_id
2056: and act.action_type_id = atyu.action_type_id
2057: and (atyu.rule_type <> ame_util.productionRuleType
2058: or rul.rule_type <> ame_util.productionRuleType)
2059: and ((sysdate between rul.start_date and nvl(rul.end_date - (1/86400),sysdate))
2060: or
2061: (sysdate < rul.start_date and rul.start_date < nvl(rul.end_date, rul.start_date + (1/86400)))

Line 2058: or rul.rule_type <> ame_util.productionRuleType)

2054: and rul.rule_id = acu.rule_id
2055: and acu.action_id = act.action_id
2056: and act.action_type_id = atyu.action_type_id
2057: and (atyu.rule_type <> ame_util.productionRuleType
2058: or rul.rule_type <> ame_util.productionRuleType)
2059: and ((sysdate between rul.start_date and nvl(rul.end_date - (1/86400),sysdate))
2060: or
2061: (sysdate < rul.start_date and rul.start_date < nvl(rul.end_date, rul.start_date + (1/86400)))
2062: )

Line 2178: tempValue := ame_util.getConfigVar

2174: function is_all_approver_types_allowed(p_application_id in integer) return boolean is
2175: tempValue ame_config_vars.variable_value%type;
2176: begin
2177: --+
2178: tempValue := ame_util.getConfigVar
2179: (variableNameIn => ame_util.allowAllApproverTypesConfigVar
2180: ,applicationIdIn => p_application_id);
2181: --+
2182: if(tempValue = ame_util.no) then

Line 2179: (variableNameIn => ame_util.allowAllApproverTypesConfigVar

2175: tempValue ame_config_vars.variable_value%type;
2176: begin
2177: --+
2178: tempValue := ame_util.getConfigVar
2179: (variableNameIn => ame_util.allowAllApproverTypesConfigVar
2180: ,applicationIdIn => p_application_id);
2181: --+
2182: if(tempValue = ame_util.no) then
2183: return false;

Line 2182: if(tempValue = ame_util.no) then

2178: tempValue := ame_util.getConfigVar
2179: (variableNameIn => ame_util.allowAllApproverTypesConfigVar
2180: ,applicationIdIn => p_application_id);
2181: --+
2182: if(tempValue = ame_util.no) then
2183: return false;
2184: else
2185: return true;
2186: end if;

Line 2262: and itc.name <> ame_util.headerItemClassName

2258: and rul.rule_id = cnu.rule_id
2259: and cnu.condition_id = con.condition_id
2260: and con.attribute_id = atr.attribute_id
2261: and atr.item_class_id = itc.item_class_id
2262: and itc.name <> ame_util.headerItemClassName
2263: and ((sysdate between rul.start_date and nvl(rul.end_date - (1/86400),sysdate))
2264: or
2265: (sysdate < rul.start_date and rul.start_date < nvl(rul.end_date, rul.start_date + (1/86400)))
2266: )

Line 2277: l_sub_ic_cond_list ame_util.idList;

2273: and sysdate between itc.start_date and nvl(itc.end_date - (1/86400),sysdate);
2274: --+
2275: l_item_class_id ame_rules.item_class_id%type;
2276: l_header_item_class_id ame_rules.item_class_id%type;
2277: l_sub_ic_cond_list ame_util.idList;
2278: l_con_item_class_id ame_rules.item_class_id%type;
2279: l_con_type ame_conditions.condition_type%type;
2280: begin
2281: --+

Line 2287: if l_con_type = ame_util.listModConditionType then

2283: into l_con_type
2284: from ame_conditions
2285: where condition_id = p_condition_id
2286: and sysdate between start_date and nvl(end_date - (1/84600),sysdate);
2287: if l_con_type = ame_util.listModConditionType then
2288: return;
2289: end if;
2290: --+
2291: select item_class_id

Line 2294: where name = ame_util.headerItemClassName

2290: --+
2291: select item_class_id
2292: into l_header_item_class_id
2293: from ame_item_classes
2294: where name = ame_util.headerItemClassName
2295: and sysdate between start_date and nvl(end_date - (1/84600),sysdate);
2296: --+
2297: select atr.item_class_id
2298: into l_con_item_class_id