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_CONDITION_PKG dependencies on AME_CONDITIONS

Line 8: from ame_conditions

4: attributeId integer;
5: begin
6: select attribute_id
7: into attributeId
8: from ame_conditions
9: where
10: condition_id = conditionIdIn and
11: sysdate between start_date and
12: nvl(end_date - ame_util.oneSecond, sysdate);

Line 34: ame_conditions

30: select ame_attributes.name
31: into attributeName
32: from
33: ame_attributes,
34: ame_conditions
35: where
36: ame_conditions.condition_id = conditionIdIn and
37: ame_conditions.attribute_id = ame_attributes.attribute_id and
38: sysdate between ame_attributes.start_date and

Line 36: ame_conditions.condition_id = conditionIdIn and

32: from
33: ame_attributes,
34: ame_conditions
35: where
36: ame_conditions.condition_id = conditionIdIn and
37: ame_conditions.attribute_id = ame_attributes.attribute_id and
38: sysdate between ame_attributes.start_date and
39: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
40: sysdate between ame_conditions.start_date and

Line 37: ame_conditions.attribute_id = ame_attributes.attribute_id and

33: ame_attributes,
34: ame_conditions
35: where
36: ame_conditions.condition_id = conditionIdIn and
37: ame_conditions.attribute_id = ame_attributes.attribute_id and
38: sysdate between ame_attributes.start_date and
39: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
40: sysdate between ame_conditions.start_date and
41: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);

Line 40: sysdate between ame_conditions.start_date and

36: ame_conditions.condition_id = conditionIdIn and
37: ame_conditions.attribute_id = ame_attributes.attribute_id and
38: sysdate between ame_attributes.start_date and
39: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
40: sysdate between ame_conditions.start_date and
41: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);
42: return(attributeName);
43: exception
44: when others then

Line 41: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);

37: ame_conditions.attribute_id = ame_attributes.attribute_id and
38: sysdate between ame_attributes.start_date and
39: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
40: sysdate between ame_conditions.start_date and
41: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);
42: return(attributeName);
43: exception
44: when others then
45: rollback;

Line 63: ame_conditions

59: select attribute_type
60: into attributeType
61: from
62: ame_attributes,
63: ame_conditions
64: where
65: ame_conditions.condition_id = conditionIdIn and
66: ame_attributes.attribute_id = ame_conditions.attribute_id and
67: sysdate between ame_attributes.start_date and

Line 65: ame_conditions.condition_id = conditionIdIn and

61: from
62: ame_attributes,
63: ame_conditions
64: where
65: ame_conditions.condition_id = conditionIdIn and
66: ame_attributes.attribute_id = ame_conditions.attribute_id and
67: sysdate between ame_attributes.start_date and
68: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
69: sysdate between ame_conditions.start_date and

Line 66: ame_attributes.attribute_id = ame_conditions.attribute_id and

62: ame_attributes,
63: ame_conditions
64: where
65: ame_conditions.condition_id = conditionIdIn and
66: ame_attributes.attribute_id = ame_conditions.attribute_id and
67: sysdate between ame_attributes.start_date and
68: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
69: sysdate between ame_conditions.start_date and
70: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);

Line 69: sysdate between ame_conditions.start_date and

65: ame_conditions.condition_id = conditionIdIn and
66: ame_attributes.attribute_id = ame_conditions.attribute_id and
67: sysdate between ame_attributes.start_date and
68: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
69: sysdate between ame_conditions.start_date and
70: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);
71: return(attributeType);
72: exception
73: when others then

Line 70: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);

66: ame_attributes.attribute_id = ame_conditions.attribute_id and
67: sysdate between ame_attributes.start_date and
68: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
69: sysdate between ame_conditions.start_date and
70: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);
71: return(attributeType);
72: exception
73: when others then
74: rollback;

Line 86: conditionType ame_conditions.condition_type%type;

82: raise;
83: return(null);
84: end getAttributeType;
85: function getConditionType(conditionIdIn in integer) return varchar2 as
86: conditionType ame_conditions.condition_type%type;
87: begin
88: select condition_type
89: into conditionType
90: from

Line 91: ame_conditions

87: begin
88: select condition_type
89: into conditionType
90: from
91: ame_conditions
92: where
93: ame_conditions.condition_id = conditionIdIn and
94: sysdate between start_date and
95: nvl(end_date - ame_util.oneSecond, sysdate);

Line 93: ame_conditions.condition_id = conditionIdIn and

89: into conditionType
90: from
91: ame_conditions
92: where
93: ame_conditions.condition_id = conditionIdIn and
94: sysdate between start_date and
95: nvl(end_date - ame_util.oneSecond, sysdate);
96: return(conditionType);
97: exception

Line 112: conditionKey ame_conditions.condition_key%type;

108: return(null);
109: end getConditionType;
110: function getConditionKey(conditionIdIn in integer,
111: processingDateIn in date default null) return varchar2 as
112: conditionKey ame_conditions.condition_key%type;
113: begin
114: if processingDateIn is null then
115: select condition_key
116: into conditionKey

Line 117: from ame_conditions

113: begin
114: if processingDateIn is null then
115: select condition_key
116: into conditionKey
117: from ame_conditions
118: where
119: condition_id = conditionIdIn and
120: ((sysdate between start_date and
121: nvl(end_date - ame_util.oneSecond, sysdate)) or

Line 127: from ame_conditions

123: start_date < nvl(end_date,start_date +ame_util.oneSecond)));
124: else
125: select condition_key
126: into conditionKey
127: from ame_conditions
128: where
129: condition_id = conditionIdIn and
130: (processingDateIn between start_date and
131: nvl(end_date - ame_util.oneSecond, processingDateIn)) ;

Line 152: from ame_conditions

148: conditionCount integer;
149: begin
150: select count(*)
151: into conditionCount
152: from ame_conditions
153: where upper(condition_key) = upper(conditionKeyIn) and
154: rownum < 2;
155: if conditionCount > 0 then
156: return(true);

Line 179: newConditionKey ame_conditions.condition_key%type;

175: select to_char(db.dbid)
176: from v$database db, v$instance instance
177: where upper(db.name) = upper(instance.instance_name);
178: databaseId varchar2(50);
179: newConditionKey ame_conditions.condition_key%type;
180: newConditionKey1 ame_conditions.condition_key%type;
181: conditionKeyId number;
182: seededKeyPrefix varchar2(4);
183: begin

Line 180: newConditionKey1 ame_conditions.condition_key%type;

176: from v$database db, v$instance instance
177: where upper(db.name) = upper(instance.instance_name);
178: databaseId varchar2(50);
179: newConditionKey ame_conditions.condition_key%type;
180: newConditionKey1 ame_conditions.condition_key%type;
181: conditionKeyId number;
182: seededKeyPrefix varchar2(4);
183: begin
184: open get_dbid_cursor;

Line 234: approverName ame_conditions.parameter_two%type;

230: nvl(end_date - ame_util.oneSecond, sysdate)
231: order by string_value;
232: description varchar2(500);
233: approverDescription ame_util.longStringType;
234: approverName ame_conditions.parameter_two%type;
235: approverType ame_conditions.parameter_one%type;
236: approverTypeId ame_attributes.approver_type_id%type;
237: attributeId ame_attributes.attribute_id%type;
238: attributeName ame_attributes.name%type;

Line 235: approverType ame_conditions.parameter_one%type;

231: order by string_value;
232: description varchar2(500);
233: approverDescription ame_util.longStringType;
234: approverName ame_conditions.parameter_two%type;
235: approverType ame_conditions.parameter_one%type;
236: approverTypeId ame_attributes.approver_type_id%type;
237: attributeId ame_attributes.attribute_id%type;
238: attributeName ame_attributes.name%type;
239: attributeType ame_attributes.attribute_type%type;

Line 240: conditionType ame_conditions.condition_type%type;

236: approverTypeId ame_attributes.approver_type_id%type;
237: attributeId ame_attributes.attribute_id%type;
238: attributeName ame_attributes.name%type;
239: attributeType ame_attributes.attribute_type%type;
240: conditionType ame_conditions.condition_type%type;
241: includeLowerLimit ame_conditions.include_lower_limit%type;
242: includeUpperLimit ame_conditions.include_upper_limit%type;
243: lastName per_all_people_f.last_name%type;
244: lineItem ame_attributes.line_item%type;

Line 241: includeLowerLimit ame_conditions.include_lower_limit%type;

237: attributeId ame_attributes.attribute_id%type;
238: attributeName ame_attributes.name%type;
239: attributeType ame_attributes.attribute_type%type;
240: conditionType ame_conditions.condition_type%type;
241: includeLowerLimit ame_conditions.include_lower_limit%type;
242: includeUpperLimit ame_conditions.include_upper_limit%type;
243: lastName per_all_people_f.last_name%type;
244: lineItem ame_attributes.line_item%type;
245: lineItemLabel varchar2(15);

Line 242: includeUpperLimit ame_conditions.include_upper_limit%type;

238: attributeName ame_attributes.name%type;
239: attributeType ame_attributes.attribute_type%type;
240: conditionType ame_conditions.condition_type%type;
241: includeLowerLimit ame_conditions.include_lower_limit%type;
242: includeUpperLimit ame_conditions.include_upper_limit%type;
243: lastName per_all_people_f.last_name%type;
244: lineItem ame_attributes.line_item%type;
245: lineItemLabel varchar2(15);
246: origSystem wf_roles.orig_system%type;

Line 247: parameterOne ame_conditions.parameter_one%type;

243: lastName per_all_people_f.last_name%type;
244: lineItem ame_attributes.line_item%type;
245: lineItemLabel varchar2(15);
246: origSystem wf_roles.orig_system%type;
247: parameterOne ame_conditions.parameter_one%type;
248: parameterOneDateString varchar2(500);
249: parameterOneNumberString varchar2(500);
250: parameterTwo ame_conditions.parameter_two%type;
251: parameterTwoDateString varchar2(500);

Line 250: parameterTwo ame_conditions.parameter_two%type;

246: origSystem wf_roles.orig_system%type;
247: parameterOne ame_conditions.parameter_one%type;
248: parameterOneDateString varchar2(500);
249: parameterOneNumberString varchar2(500);
250: parameterTwo ame_conditions.parameter_two%type;
251: parameterTwoDateString varchar2(500);
252: parameterTwoNumberString varchar2(500);
253: parameterThree ame_conditions.parameter_three%type;
254: tempIndex integer;

Line 253: parameterThree ame_conditions.parameter_three%type;

249: parameterOneNumberString varchar2(500);
250: parameterTwo ame_conditions.parameter_two%type;
251: parameterTwoDateString varchar2(500);
252: parameterTwoNumberString varchar2(500);
253: parameterThree ame_conditions.parameter_three%type;
254: tempIndex integer;
255: tempValue ame_string_values.string_value%type;
256: wfRolesName wf_roles.name%type;
257: begin

Line 283: from ame_conditions

279: attributeType := getAttributeType(conditionIdIn => conditionIdIn);
280: if(attributeType = ame_util.booleanAttributeType) then
281: select parameter_one
282: into parameterOne
283: from ame_conditions
284: where
285: condition_id = conditionIdIn and
286: sysdate between start_date and
287: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 320: ame_conditions

316: parameterTwo,
317: includeLowerLimit,
318: includeUpperLimit
319: from
320: ame_conditions
321: where
322: condition_id = conditionIdIn and
323: sysdate between start_date and
324: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 425: ame_conditions

421: parameterThree,
422: includeLowerLimit,
423: includeUpperLimit
424: from
425: ame_conditions
426: where
427: condition_id = conditionIdIn and
428: sysdate between start_date and
429: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 472: includeLowerLimit ame_conditions.include_lower_limit%type;

468: raise;
469: return(null);
470: end getDescription;
471: function getIncludeLowerLimit(conditionIdIn in integer) return varchar as
472: includeLowerLimit ame_conditions.include_lower_limit%type;
473: begin
474: select include_lower_limit
475: into includeLowerLimit
476: from ame_conditions

Line 476: from ame_conditions

472: includeLowerLimit ame_conditions.include_lower_limit%type;
473: begin
474: select include_lower_limit
475: into includeLowerLimit
476: from ame_conditions
477: where
478: condition_id = conditionIdIn and
479: sysdate between start_date and
480: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 496: includeUpperLimit ame_conditions.include_upper_limit%type;

492: raise;
493: return(null);
494: end getIncludeLowerLimit;
495: function getIncludeUpperLimit(conditionIdIn in integer) return varchar as
496: includeUpperLimit ame_conditions.include_upper_limit%type;
497: begin
498: select include_upper_limit
499: into includeUpperLimit
500: from ame_conditions

Line 500: from ame_conditions

496: includeUpperLimit ame_conditions.include_upper_limit%type;
497: begin
498: select include_upper_limit
499: into includeUpperLimit
500: from ame_conditions
501: where
502: condition_id = conditionIdIn and
503: sysdate between start_date and
504: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 526: ame_conditions

522: select attribute_type
523: into attributeType
524: from
525: ame_attributes,
526: ame_conditions
527: where
528: ame_conditions.condition_id = conditionIdIn and
529: ame_attributes.attribute_id = ame_conditions.attribute_id and
530: sysdate between ame_conditions.start_date and

Line 528: ame_conditions.condition_id = conditionIdIn and

524: from
525: ame_attributes,
526: ame_conditions
527: where
528: ame_conditions.condition_id = conditionIdIn and
529: ame_attributes.attribute_id = ame_conditions.attribute_id and
530: sysdate between ame_conditions.start_date and
531: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
532: sysdate between ame_attributes.start_date and

Line 529: ame_attributes.attribute_id = ame_conditions.attribute_id and

525: ame_attributes,
526: ame_conditions
527: where
528: ame_conditions.condition_id = conditionIdIn and
529: ame_attributes.attribute_id = ame_conditions.attribute_id and
530: sysdate between ame_conditions.start_date and
531: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
532: sysdate between ame_attributes.start_date and
533: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) ;

Line 530: sysdate between ame_conditions.start_date and

526: ame_conditions
527: where
528: ame_conditions.condition_id = conditionIdIn and
529: ame_attributes.attribute_id = ame_conditions.attribute_id and
530: sysdate between ame_conditions.start_date and
531: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
532: sysdate between ame_attributes.start_date and
533: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) ;
534: if attributeType = ame_util.stringAttributeType then

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

527: where
528: ame_conditions.condition_id = conditionIdIn and
529: ame_attributes.attribute_id = ame_conditions.attribute_id and
530: sysdate between ame_conditions.start_date and
531: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
532: sysdate between ame_attributes.start_date and
533: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) ;
534: if attributeType = ame_util.stringAttributeType then
535: return(true);

Line 555: parameterOne ame_conditions.parameter_one%type;

551: raise;
552: return(false);
553: end isStringAttributeType;
554: function getParameterOne(conditionIdIn in integer) return varchar as
555: parameterOne ame_conditions.parameter_one%type;
556: begin
557: select parameter_one
558: into parameterOne
559: from ame_conditions

Line 559: from ame_conditions

555: parameterOne ame_conditions.parameter_one%type;
556: begin
557: select parameter_one
558: into parameterOne
559: from ame_conditions
560: where
561: condition_id = conditionIdIn and
562: sysdate between start_date and
563: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 579: parameterTwo ame_conditions.parameter_two%type;

575: raise;
576: return(null);
577: end getParameterOne;
578: function getParameterTwo(conditionIdIn in integer) return varchar as
579: parameterTwo ame_conditions.parameter_two%type;
580: begin
581: select parameter_two
582: into parameterTwo
583: from ame_conditions

Line 583: from ame_conditions

579: parameterTwo ame_conditions.parameter_two%type;
580: begin
581: select parameter_two
582: into parameterTwo
583: from ame_conditions
584: where
585: condition_id = conditionIdIn and
586: sysdate between start_date and
587: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 603: parameterThree ame_conditions.parameter_three%type;

599: raise;
600: return(null);
601: end getParameterTwo;
602: function getParameterThree(conditionIdIn in integer) return varchar as
603: parameterThree ame_conditions.parameter_three%type;
604: begin
605: select parameter_three
606: into parameterThree
607: from ame_conditions

Line 607: from ame_conditions

603: parameterThree ame_conditions.parameter_three%type;
604: begin
605: select parameter_three
606: into parameterThree
607: from ame_conditions
608: where
609: condition_id = conditionIdIn and
610: sysdate between start_date and
611: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 631: from ame_conditions

627: startDate date;
628: begin
629: select start_date
630: into startDate
631: from ame_conditions
632: where
633: condition_id = conditionIdIn and
634: sysdate between start_date and
635: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 651: conditionType ame_conditions.condition_type%type;

647: raise;
648: return(null);
649: end getStartDate;
650: function getType(conditionIdIn in integer) return varchar2 as
651: conditionType ame_conditions.condition_type%type;
652: begin
653: select condition_type
654: into conditionType
655: from ame_conditions

Line 655: from ame_conditions

651: conditionType ame_conditions.condition_type%type;
652: begin
653: select condition_type
654: into conditionType
655: from ame_conditions
656: where
657: condition_id = conditionIdIn and
658: sysdate between start_date and
659: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 680: from ame_conditions

676: stringStartDate varchar2(50);
677: begin
678: select start_date
679: into startDate
680: from ame_conditions
681: where
682: condition_id = conditionIdIn and
683: sysdate between start_date and
684: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 810: ame_conditions

806: into lineItemCount
807: from
808: ame_attribute_usages,
809: ame_attributes,
810: ame_conditions
811: where
812: ame_attributes.attribute_id = ame_conditions.attribute_id and
813: ame_conditions.condition_type = conditionTypeIn and
814: ame_attributes.line_item = ame_util.booleanTrue and

Line 812: ame_attributes.attribute_id = ame_conditions.attribute_id and

808: ame_attribute_usages,
809: ame_attributes,
810: ame_conditions
811: where
812: ame_attributes.attribute_id = ame_conditions.attribute_id and
813: ame_conditions.condition_type = conditionTypeIn and
814: ame_attributes.line_item = ame_util.booleanTrue and
815: ame_attribute_usages.attribute_id = ame_attributes.attribute_id and
816: ame_attribute_usages.application_id = applicationIdIn and

Line 813: ame_conditions.condition_type = conditionTypeIn and

809: ame_attributes,
810: ame_conditions
811: where
812: ame_attributes.attribute_id = ame_conditions.attribute_id and
813: ame_conditions.condition_type = conditionTypeIn and
814: ame_attributes.line_item = ame_util.booleanTrue and
815: ame_attribute_usages.attribute_id = ame_attributes.attribute_id and
816: ame_attribute_usages.application_id = applicationIdIn and
817: ((sysdate between ame_attribute_usages.start_date and

Line 824: sysdate between ame_conditions.start_date and

820: ame_attribute_usages.start_date < nvl(ame_attribute_usages.end_date,
821: ame_attribute_usages.start_date + ame_util.oneSecond))) and
822: sysdate between ame_attributes.start_date and
823: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
824: sysdate between ame_conditions.start_date and
825: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) ;
826: if(lineItemCount > 0) then
827: return(true);
828: end if;

Line 825: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) ;

821: ame_attribute_usages.start_date + ame_util.oneSecond))) and
822: sysdate between ame_attributes.start_date and
823: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
824: sysdate between ame_conditions.start_date and
825: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) ;
826: if(lineItemCount > 0) then
827: return(true);
828: end if;
829: return(false);

Line 856: from ame_conditions

852: commitIn in boolean default true,
853: processingDateIn in date default null) return integer as
854: cursor conditionCursor(attributeIdIn in integer) is
855: select condition_id
856: from ame_conditions
857: where
858: attribute_id = attributeIdIn and
859: sysdate between start_date and
860: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 941: from ame_conditions

937: end loop;
938: else
939: select count(*)
940: into tempCount
941: from ame_conditions
942: where
943: condition_type = typeIn and
944: attribute_id = attributeIdIn and
945: ((parameterOneIn is null and parameter_one is null) or

Line 961: if(ame_util.isArgumentTooLong(tableNameIn => 'ame_conditions',

957: if tempCount > 0 then
958: raise conditionExistsException;
959: end if;
960: end if;
961: if(ame_util.isArgumentTooLong(tableNameIn => 'ame_conditions',
962: columnNameIn => 'parameter_one',
963: argumentIn => parameterOneIn)) then
964: raise parameterOneLengthException;
965: end if;

Line 966: if(ame_util.isArgumentTooLong(tableNameIn => 'ame_conditions',

962: columnNameIn => 'parameter_one',
963: argumentIn => parameterOneIn)) then
964: raise parameterOneLengthException;
965: end if;
966: if(ame_util.isArgumentTooLong(tableNameIn => 'ame_conditions',
967: columnNameIn => 'parameter_two',
968: argumentIn => parameterTwoIn)) then
969: raise parameterTwoLengthException;
970: end if;

Line 971: if(ame_util.isArgumentTooLong(tableNameIn => 'ame_conditions',

967: columnNameIn => 'parameter_two',
968: argumentIn => parameterTwoIn)) then
969: raise parameterTwoLengthException;
970: end if;
971: if(ame_util.isArgumentTooLong(tableNameIn => 'ame_conditions',
972: columnNameIn => 'parameter_three',
973: argumentIn => parameterThreeIn)) then
974: raise parameterThreeLengthException;
975: end if;

Line 976: if(ame_util.isArgumentTooLong(tableNameIn => 'ame_conditions',

972: columnNameIn => 'parameter_three',
973: argumentIn => parameterThreeIn)) then
974: raise parameterThreeLengthException;
975: end if;
976: if(ame_util.isArgumentTooLong(tableNameIn => 'ame_conditions',
977: columnNameIn => 'include_lower_limit',
978: argumentIn => includeLowerLimitIn)) then
979: raise lowerlimitLengthException;
980: end if;

Line 981: if(ame_util.isArgumentTooLong(tableNameIn => 'ame_conditions',

977: columnNameIn => 'include_lower_limit',
978: argumentIn => includeLowerLimitIn)) then
979: raise lowerlimitLengthException;
980: end if;
981: if(ame_util.isArgumentTooLong(tableNameIn => 'ame_conditions',
982: columnNameIn => 'include_upper_limit',
983: argumentIn => includeUpperLimitIn)) then
984: raise upperlimitLengthException;
985: end if;

Line 999: from ame_conditions

995: if (ame_util.getHighestResponsibility = ame_util.developerResponsibility) then
996: /* Use negative condition IDs for developer-seeded conditions. */
997: select count(*)
998: into conditionCount
999: from ame_conditions
1000: where
1001: processingDate between start_date and
1002: nvl(end_date - ame_util.oneSecond, processingDate) ;
1003: if conditionCount = 0 then

Line 1008: from ame_conditions

1004: conditionId := -1;
1005: else
1006: select min(condition_id) - 1
1007: into conditionId
1008: from ame_conditions
1009: where
1010: processingDate between start_date and
1011: nvl(end_date - ame_util.oneSecond, processingDate);
1012: if(conditionId > -1) then

Line 1017: select ame_conditions_s.nextval into conditionId from dual;

1013: conditionId := -1;
1014: end if;
1015: end if;
1016: else
1017: select ame_conditions_s.nextval into conditionId from dual;
1018: end if;
1019: else
1020: conditionId := conditionIdIn;
1021: select count(*)

Line 1023: from ame_conditions

1019: else
1020: conditionId := conditionIdIn;
1021: select count(*)
1022: into tempCount2
1023: from ame_conditions
1024: where
1025: condition_id = conditionId and
1026: created_by = ame_util.seededDataCreatedById;
1027: if(tempCount2 > 0) then

Line 1033: insert into ame_conditions(condition_id,

1029: else
1030: createdBy := currentUserId;
1031: end if;
1032: end if;
1033: insert into ame_conditions(condition_id,
1034: condition_key,
1035: condition_type,
1036: attribute_id,
1037: parameter_one,

Line 1139: tokenValueOneIn => ame_util.getColumnLength(tableNameIn => 'ame_conditions',

1135: errorCode := -20001;
1136: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
1137: messageNameIn => 'AME_400184_CON_LWR_LMT_LONG',
1138: tokenNameOneIn => 'COLUMN_LENGTH',
1139: tokenValueOneIn => ame_util.getColumnLength(tableNameIn => 'ame_conditions',
1140: columnNameIn => 'parameter_one'));
1141: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
1142: routineNameIn => 'new',
1143: exceptionNumberIn => errorCode,

Line 1155: tokenValueOneIn => ame_util.getColumnLength(tableNameIn => 'ame_conditions',

1151: errorMessage :=
1152: ame_util.getMessage(applicationShortNameIn => 'PER',
1153: messageNameIn => 'AME_400185_CON_UPP_LMT_LONG',
1154: tokenNameOneIn => 'COLUMN_LENGTH',
1155: tokenValueOneIn => ame_util.getColumnLength(tableNameIn => 'ame_conditions',
1156: columnNameIn => 'parameter_two'));
1157: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
1158: routineNameIn => 'new',
1159: exceptionNumberIn => errorCode,

Line 1171: tokenValueOneIn => ame_util.getColumnLength(tableNameIn => 'ame_conditions',

1167: errorMessage :=
1168: ame_util.getMessage(applicationShortNameIn => 'PER',
1169: messageNameIn => 'AME_400185_CON_UPP_LMT_LONG',
1170: tokenNameOneIn => 'COLUMN_LENGTH',
1171: tokenValueOneIn => ame_util.getColumnLength(tableNameIn => 'ame_conditions',
1172: columnNameIn => 'parameter_three'));
1173: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
1174: routineNameIn => 'new',
1175: exceptionNumberIn => errorCode,

Line 1187: tokenValueOneIn => ame_util.getColumnLength(tableNameIn => 'ame_conditions',

1183: errorMessage :=
1184: ame_util.getMessage(applicationShortNameIn => 'PER',
1185: messageNameIn => 'AME_400184_CON_LWR_LMT_LONG',
1186: tokenNameOneIn => 'COLUMN_LENGTH',
1187: tokenValueOneIn => ame_util.getColumnLength(tableNameIn => 'ame_conditions',
1188: columnNameIn => 'include_lower_limit'));
1189: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
1190: routineNameIn => 'new',
1191: exceptionNumberIn => errorCode,

Line 1203: tokenValueOneIn => ame_util.getColumnLength(tableNameIn => 'ame_conditions',

1199: errorMessage :=
1200: ame_util.getMessage(applicationShortNameIn => 'PER',
1201: messageNameIn => 'AME_400185_CON_UPP_LMT_LONG',
1202: tokenNameOneIn => 'COLUMN_LENGTH',
1203: tokenValueOneIn => ame_util.getColumnLength(tableNameIn => 'ame_conditions',
1204: columnNameIn => 'include_upper_limit'));
1205: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
1206: routineNameIn => 'new',
1207: exceptionNumberIn => errorCode,

Line 1451: from ame_conditions

1447: parameterThreeIn in varchar2,
1448: includeLowerLimitIn in varchar2,
1449: includeUpperLimitIn in varchar2) is
1450: select condition_id
1451: from ame_conditions
1452: where
1453: attribute_id = attributeIdIn and
1454: condition_type = typeIn and
1455: ((parameter_one is null and parameterOneIn is null) or

Line 1469: from ame_conditions

1465: sysdate between start_date and
1466: nvl(end_date - ame_util.oneSecond, sysdate) ;
1467: cursor startDateCursor is
1468: select start_date
1469: from ame_conditions
1470: where
1471: condition_id = conditionIdIn and
1472: sysdate between start_date and
1473: nvl(end_date - ame_util.oneSecond, sysdate)

Line 1479: conditionKey ame_conditions.condition_key%type;

1475: attributeId integer;
1476: attributeType ame_attributes.attribute_type%type;
1477: conditionId integer;
1478: conditionsExistsException exception;
1479: conditionKey ame_conditions.condition_key%type;
1480: conditionType ame_conditions.condition_type%type;
1481: currentUserId integer;
1482: endDate date;
1483: errorCode integer;

Line 1480: conditionType ame_conditions.condition_type%type;

1476: attributeType ame_attributes.attribute_type%type;
1477: conditionId integer;
1478: conditionsExistsException exception;
1479: conditionKey ame_conditions.condition_key%type;
1480: conditionType ame_conditions.condition_type%type;
1481: currentUserId integer;
1482: endDate date;
1483: errorCode integer;
1484: errorMessage ame_util.longestStringType;

Line 1513: from ame_conditions

1509: end if;
1510: conditionKey := getConditionKey(conditionIdIn => conditionIdIn);
1511: select count(*)
1512: into tempCount
1513: from ame_conditions
1514: where
1515: condition_type = typeIn and
1516: attribute_id = attributeIdIn and
1517: ((parameter_one is null and parameterOneIn is null) or

Line 1565: update ame_conditions

1561: currentUserId := ame_util.getCurrentUserId;
1562: if versionStartDateIn = startDate then
1563: endDate := processingDate ;
1564: newStartDate := processingDate;
1565: update ame_conditions
1566: set
1567: last_updated_by = currentUserId,
1568: last_update_date = endDate,
1569: last_update_login = currentUserId,

Line 1683: from ame_conditions

1679: parameterTwoOut,
1680: parameterThreeOut,
1681: includeLowerLimitOut,
1682: includeUpperLimitOut
1683: from ame_conditions
1684: where
1685: condition_id = conditionIdIn and
1686: sysdate between start_date and
1687: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 1719: ame_conditions.condition_id id,

1715: conditionDescriptionsOut out nocopy ame_util.longStringList) as
1716: cursor conditionCursor(applicationIdIn in integer,
1717: itemClassIdIn in integer) is
1718: select
1719: ame_conditions.condition_id id,
1720: ame_conditions.condition_type,
1721: ame_attributes.attribute_id,
1722: ame_attributes.name,
1723: ame_attributes.attribute_type

Line 1720: ame_conditions.condition_type,

1716: cursor conditionCursor(applicationIdIn in integer,
1717: itemClassIdIn in integer) is
1718: select
1719: ame_conditions.condition_id id,
1720: ame_conditions.condition_type,
1721: ame_attributes.attribute_id,
1722: ame_attributes.name,
1723: ame_attributes.attribute_type
1724: from ame_conditions,

Line 1724: from ame_conditions,

1720: ame_conditions.condition_type,
1721: ame_attributes.attribute_id,
1722: ame_attributes.name,
1723: ame_attributes.attribute_type
1724: from ame_conditions,
1725: ame_attributes,
1726: ame_attribute_usages,
1727: ame_item_class_usages
1728: where

Line 1732: ame_conditions.attribute_id = ame_attribute_usages.attribute_id and

1728: where
1729: ame_attribute_usages.application_id = ame_item_class_usages.application_id and
1730: ame_item_class_usages.application_id = applicationIdIn and
1731: ame_item_class_usages.item_class_id = itemClassIdIn and
1732: ame_conditions.attribute_id = ame_attribute_usages.attribute_id and
1733: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
1734: ame_attributes.item_class_id = itemClassIdIn and
1735: ame_conditions.condition_type in (ame_util.ordinaryConditionType,ame_util.exceptionConditionType) and
1736: sysdate between ame_conditions.start_date and

Line 1735: ame_conditions.condition_type in (ame_util.ordinaryConditionType,ame_util.exceptionConditionType) and

1731: ame_item_class_usages.item_class_id = itemClassIdIn and
1732: ame_conditions.attribute_id = ame_attribute_usages.attribute_id and
1733: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
1734: ame_attributes.item_class_id = itemClassIdIn and
1735: ame_conditions.condition_type in (ame_util.ordinaryConditionType,ame_util.exceptionConditionType) and
1736: sysdate between ame_conditions.start_date and
1737: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
1738: sysdate between ame_attributes.start_date and
1739: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

Line 1736: sysdate between ame_conditions.start_date and

1732: ame_conditions.attribute_id = ame_attribute_usages.attribute_id and
1733: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
1734: ame_attributes.item_class_id = itemClassIdIn and
1735: ame_conditions.condition_type in (ame_util.ordinaryConditionType,ame_util.exceptionConditionType) and
1736: sysdate between ame_conditions.start_date and
1737: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
1738: sysdate between ame_attributes.start_date and
1739: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
1740: sysdate between ame_attribute_usages.start_date and

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

1733: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
1734: ame_attributes.item_class_id = itemClassIdIn and
1735: ame_conditions.condition_type in (ame_util.ordinaryConditionType,ame_util.exceptionConditionType) and
1736: sysdate between ame_conditions.start_date and
1737: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
1738: sysdate between ame_attributes.start_date and
1739: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
1740: sysdate between ame_attribute_usages.start_date and
1741: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and

Line 1744: order by ame_conditions.condition_type,

1740: sysdate between ame_attribute_usages.start_date and
1741: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
1742: sysdate between ame_item_class_usages.start_date and
1743: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate)
1744: order by ame_conditions.condition_type,
1745: ame_attributes.attribute_type,
1746: ame_attributes.name;
1747: tempOutputIndex integer;
1748: conditionId integer;

Line 1749: conditionType ame_conditions.condition_type%type;

1745: ame_attributes.attribute_type,
1746: ame_attributes.name;
1747: tempOutputIndex integer;
1748: conditionId integer;
1749: conditionType ame_conditions.condition_type%type;
1750: attributeId integer;
1751: attributeName ame_attributes.name%type;
1752: attributeType ame_attributes.attribute_type%type;
1753: begin

Line 1805: from ame_conditions,

1801: lineItemIn in varchar2) is
1802: select
1803: condition_id id,
1804: ame_condition_pkg.getDescription(condition_id) description
1805: from ame_conditions,
1806: ame_attributes
1807: where
1808: ame_conditions.attribute_id = ame_attributes.attribute_id and
1809: nvl(ame_attributes.line_item, ame_util.booleanFalse) = lineItemIn and

Line 1808: ame_conditions.attribute_id = ame_attributes.attribute_id and

1804: ame_condition_pkg.getDescription(condition_id) description
1805: from ame_conditions,
1806: ame_attributes
1807: where
1808: ame_conditions.attribute_id = ame_attributes.attribute_id and
1809: nvl(ame_attributes.line_item, ame_util.booleanFalse) = lineItemIn and
1810: ame_attributes.attribute_id = attributeIdIn and
1811: condition_type = conditionTypeIn and
1812: sysdate between ame_conditions.start_date and

Line 1812: sysdate between ame_conditions.start_date and

1808: ame_conditions.attribute_id = ame_attributes.attribute_id and
1809: nvl(ame_attributes.line_item, ame_util.booleanFalse) = lineItemIn and
1810: ame_attributes.attribute_id = attributeIdIn and
1811: condition_type = conditionTypeIn and
1812: sysdate between ame_conditions.start_date and
1813: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
1814: sysdate between ame_attributes.start_date and
1815: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate)
1816: order by description;

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

1809: nvl(ame_attributes.line_item, ame_util.booleanFalse) = lineItemIn and
1810: ame_attributes.attribute_id = attributeIdIn and
1811: condition_type = conditionTypeIn and
1812: sysdate between ame_conditions.start_date and
1813: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
1814: sysdate between ame_attributes.start_date and
1815: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate)
1816: order by description;
1817: tempOutputIndex integer;

Line 1853: ame_conditions.condition_id id,

1849: cursor conditionCursor(attributeIdIn in integer,
1850: conditionTypeIn in varchar2,
1851: itemClassIdIn in integer) is
1852: select
1853: ame_conditions.condition_id id,
1854: ame_condition_pkg.getDescription(ame_conditions.condition_id) description
1855: from ame_conditions,
1856: ame_attributes
1857: where

Line 1854: ame_condition_pkg.getDescription(ame_conditions.condition_id) description

1850: conditionTypeIn in varchar2,
1851: itemClassIdIn in integer) is
1852: select
1853: ame_conditions.condition_id id,
1854: ame_condition_pkg.getDescription(ame_conditions.condition_id) description
1855: from ame_conditions,
1856: ame_attributes
1857: where
1858: ame_conditions.attribute_id = ame_attributes.attribute_id and

Line 1855: from ame_conditions,

1851: itemClassIdIn in integer) is
1852: select
1853: ame_conditions.condition_id id,
1854: ame_condition_pkg.getDescription(ame_conditions.condition_id) description
1855: from ame_conditions,
1856: ame_attributes
1857: where
1858: ame_conditions.attribute_id = ame_attributes.attribute_id and
1859: ame_attributes.attribute_id = attributeIdIn and

Line 1858: ame_conditions.attribute_id = ame_attributes.attribute_id and

1854: ame_condition_pkg.getDescription(ame_conditions.condition_id) description
1855: from ame_conditions,
1856: ame_attributes
1857: where
1858: ame_conditions.attribute_id = ame_attributes.attribute_id and
1859: ame_attributes.attribute_id = attributeIdIn and
1860: condition_type = conditionTypeIn and
1861: ame_attributes.item_class_id = itemClassIdIn and
1862: sysdate between ame_conditions.start_date and

Line 1862: sysdate between ame_conditions.start_date and

1858: ame_conditions.attribute_id = ame_attributes.attribute_id and
1859: ame_attributes.attribute_id = attributeIdIn and
1860: condition_type = conditionTypeIn and
1861: ame_attributes.item_class_id = itemClassIdIn and
1862: sysdate between ame_conditions.start_date and
1863: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
1864: sysdate between ame_attributes.start_date and
1865: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate)
1866: order by description;

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

1859: ame_attributes.attribute_id = attributeIdIn and
1860: condition_type = conditionTypeIn and
1861: ame_attributes.item_class_id = itemClassIdIn and
1862: sysdate between ame_conditions.start_date and
1863: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
1864: sysdate between ame_attributes.start_date and
1865: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate)
1866: order by description;
1867: tempOutputIndex integer;

Line 1909: from ame_conditions,

1905: itemClassIdIn in integer) is
1906: select
1907: condition_id id,
1908: ame_condition_pkg.getDescription(condition_id) description
1909: from ame_conditions,
1910: ame_attributes
1911: where
1912: ame_conditions.attribute_id = ame_attributes.attribute_id and
1913: nvl(ame_attributes.line_item, ame_util.booleanFalse) = lineItemIn and

Line 1912: ame_conditions.attribute_id = ame_attributes.attribute_id and

1908: ame_condition_pkg.getDescription(condition_id) description
1909: from ame_conditions,
1910: ame_attributes
1911: where
1912: ame_conditions.attribute_id = ame_attributes.attribute_id and
1913: nvl(ame_attributes.line_item, ame_util.booleanFalse) = lineItemIn and
1914: ame_attributes.attribute_id = attributeIdIn and
1915: ame_attributes.item_class_id = itemClassIdIn and
1916: condition_type = conditionTypeIn and

Line 1917: sysdate between ame_conditions.start_date and

1913: nvl(ame_attributes.line_item, ame_util.booleanFalse) = lineItemIn and
1914: ame_attributes.attribute_id = attributeIdIn and
1915: ame_attributes.item_class_id = itemClassIdIn and
1916: condition_type = conditionTypeIn and
1917: sysdate between ame_conditions.start_date and
1918: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
1919: sysdate between ame_attributes.start_date and
1920: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate)
1921: order by description;

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

1914: ame_attributes.attribute_id = attributeIdIn and
1915: ame_attributes.item_class_id = itemClassIdIn and
1916: condition_type = conditionTypeIn and
1917: sysdate between ame_conditions.start_date and
1918: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
1919: sysdate between ame_attributes.start_date and
1920: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate)
1921: order by description;
1922: tempOutputIndex integer;

Line 2036: 'ame_conditions_ui.getDetails?conditionIdIn=' ||

2032: detailUrlsOut(i) := null;
2033: else
2034: if ame_condition_pkg.getAttributeType(conditionIdIn => conditionIdsIn(i)) = ame_util.stringAttributeType then
2035: detailUrlsOut(i) := (ame_util.getPlsqlDadPath ||
2036: 'ame_conditions_ui.getDetails?conditionIdIn=' ||
2037: conditionIdsIn(i) ||
2038: '&applicationIdIn=' ||
2039: applicationIdIn);
2040: else

Line 2063: from ame_conditions

2059: select
2060: condition_id,
2061: parameter_one,
2062: parameter_two
2063: from ame_conditions
2064: where
2065: condition_type = ame_util.listModConditionType and
2066: sysdate between start_date and
2067: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 2097: ame_conditions

2093: condition_id,
2094: parameter_one,
2095: parameter_two
2096: from
2097: ame_conditions
2098: where
2099: condition_type = ame_util.listModConditionType and
2100: sysdate between start_date and
2101: nvl(end_date - ame_util.oneSecond, sysdate);

Line 2137: ame_conditions.condition_id condition_id,

2133: procedure getLMDescriptions2(conditionIdsOut out nocopy ame_util.stringList,
2134: descriptionsOut out nocopy ame_util.longStringList) as
2135: cursor LMConditionCursor is
2136: select
2137: ame_conditions.condition_id condition_id,
2138: ame_conditions.parameter_one parameter_one,
2139: ame_conditions.parameter_two parameter_two
2140: from
2141: ame_conditions

Line 2138: ame_conditions.parameter_one parameter_one,

2134: descriptionsOut out nocopy ame_util.longStringList) as
2135: cursor LMConditionCursor is
2136: select
2137: ame_conditions.condition_id condition_id,
2138: ame_conditions.parameter_one parameter_one,
2139: ame_conditions.parameter_two parameter_two
2140: from
2141: ame_conditions
2142: where

Line 2139: ame_conditions.parameter_two parameter_two

2135: cursor LMConditionCursor is
2136: select
2137: ame_conditions.condition_id condition_id,
2138: ame_conditions.parameter_one parameter_one,
2139: ame_conditions.parameter_two parameter_two
2140: from
2141: ame_conditions
2142: where
2143: ame_conditions.condition_type = ame_util.listModConditionType and

Line 2141: ame_conditions

2137: ame_conditions.condition_id condition_id,
2138: ame_conditions.parameter_one parameter_one,
2139: ame_conditions.parameter_two parameter_two
2140: from
2141: ame_conditions
2142: where
2143: ame_conditions.condition_type = ame_util.listModConditionType and
2144: sysdate between ame_conditions.start_date and
2145: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);

Line 2143: ame_conditions.condition_type = ame_util.listModConditionType and

2139: ame_conditions.parameter_two parameter_two
2140: from
2141: ame_conditions
2142: where
2143: ame_conditions.condition_type = ame_util.listModConditionType and
2144: sysdate between ame_conditions.start_date and
2145: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);
2146: isApproverValid boolean;
2147: tempDescription ame_util.longStringType;

Line 2144: sysdate between ame_conditions.start_date and

2140: from
2141: ame_conditions
2142: where
2143: ame_conditions.condition_type = ame_util.listModConditionType and
2144: sysdate between ame_conditions.start_date and
2145: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);
2146: isApproverValid boolean;
2147: tempDescription ame_util.longStringType;
2148: tempIndex integer;

Line 2145: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);

2141: ame_conditions
2142: where
2143: ame_conditions.condition_type = ame_util.listModConditionType and
2144: sysdate between ame_conditions.start_date and
2145: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);
2146: isApproverValid boolean;
2147: tempDescription ame_util.longStringType;
2148: tempIndex integer;
2149: begin

Line 2184: ame_conditions.condition_id condition_id,

2180: conditionIdsOut out nocopy ame_util.stringList,
2181: descriptionsOut out nocopy ame_util.longStringList) as
2182: cursor LMConditionCursor(lmApproverTypeIn in varchar2) is
2183: select
2184: ame_conditions.condition_id condition_id,
2185: ame_conditions.parameter_two parameter_two
2186: from
2187: ame_conditions
2188: where

Line 2185: ame_conditions.parameter_two parameter_two

2181: descriptionsOut out nocopy ame_util.longStringList) as
2182: cursor LMConditionCursor(lmApproverTypeIn in varchar2) is
2183: select
2184: ame_conditions.condition_id condition_id,
2185: ame_conditions.parameter_two parameter_two
2186: from
2187: ame_conditions
2188: where
2189: ame_conditions.condition_type = ame_util.listModConditionType and

Line 2187: ame_conditions

2183: select
2184: ame_conditions.condition_id condition_id,
2185: ame_conditions.parameter_two parameter_two
2186: from
2187: ame_conditions
2188: where
2189: ame_conditions.condition_type = ame_util.listModConditionType and
2190: ame_conditions.parameter_one = lmApproverTypeIn and
2191: sysdate between ame_conditions.start_date and

Line 2189: ame_conditions.condition_type = ame_util.listModConditionType and

2185: ame_conditions.parameter_two parameter_two
2186: from
2187: ame_conditions
2188: where
2189: ame_conditions.condition_type = ame_util.listModConditionType and
2190: ame_conditions.parameter_one = lmApproverTypeIn and
2191: sysdate between ame_conditions.start_date and
2192: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);
2193: isApproverValid boolean;

Line 2190: ame_conditions.parameter_one = lmApproverTypeIn and

2186: from
2187: ame_conditions
2188: where
2189: ame_conditions.condition_type = ame_util.listModConditionType and
2190: ame_conditions.parameter_one = lmApproverTypeIn and
2191: sysdate between ame_conditions.start_date and
2192: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);
2193: isApproverValid boolean;
2194: tempDescription ame_util.longStringType;

Line 2191: sysdate between ame_conditions.start_date and

2187: ame_conditions
2188: where
2189: ame_conditions.condition_type = ame_util.listModConditionType and
2190: ame_conditions.parameter_one = lmApproverTypeIn and
2191: sysdate between ame_conditions.start_date and
2192: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);
2193: isApproverValid boolean;
2194: tempDescription ame_util.longStringType;
2195: tempIndex integer;

Line 2192: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);

2188: where
2189: ame_conditions.condition_type = ame_util.listModConditionType and
2190: ame_conditions.parameter_one = lmApproverTypeIn and
2191: sysdate between ame_conditions.start_date and
2192: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);
2193: isApproverValid boolean;
2194: tempDescription ame_util.longStringType;
2195: tempIndex integer;
2196: begin

Line 2279: from ame_conditions

2275: versionStartDateIn in date,
2276: processingDateIn in date default null) as
2277: cursor startDateCursor is
2278: select start_date
2279: from ame_conditions
2280: where
2281: condition_id = conditionIdIn and
2282: sysdate between start_date and
2283: nvl(end_date - ame_util.oneSecond, sysdate)

Line 2286: conditionType ame_conditions.condition_type%type;

2282: sysdate between start_date and
2283: nvl(end_date - ame_util.oneSecond, sysdate)
2284: for update;
2285: attributeType ame_attributes.attribute_type%type;
2286: conditionType ame_conditions.condition_type%type;
2287: currentUserId integer;
2288: errorCode integer;
2289: errorMessage ame_util.longestStringType;
2290: inUseException exception;

Line 2326: update ame_conditions

2322: processingDate between start_date and
2323: nvl(end_date - ame_util.oneSecond, processingDate) ;
2324: end if;
2325: end if;
2326: update ame_conditions
2327: set
2328: last_updated_by = currentUserId,
2329: last_update_date = processingDate,
2330: last_update_login = currentUserId,

Line 2482: from ame_conditions

2478: stringValueListIn in ame_util.longestStringList,
2479: processingDateIn in date default null) as
2480: cursor startDateCursor is
2481: select start_date
2482: from ame_conditions
2483: where
2484: condition_id = conditionIdIn and
2485: sysdate between start_date and
2486: nvl(end_date - ame_util.oneSecond, sysdate)

Line 2488: attributeId ame_conditions.attribute_id%type;

2484: condition_id = conditionIdIn and
2485: sysdate between start_date and
2486: nvl(end_date - ame_util.oneSecond, sysdate)
2487: for update;
2488: attributeId ame_conditions.attribute_id%type;
2489: conditionId ame_conditions.condition_id%type;
2490: conditionKey ame_conditions.condition_key%type;
2491: conditionType ame_conditions.condition_type%type;
2492: currentUserId integer;

Line 2489: conditionId ame_conditions.condition_id%type;

2485: sysdate between start_date and
2486: nvl(end_date - ame_util.oneSecond, sysdate)
2487: for update;
2488: attributeId ame_conditions.attribute_id%type;
2489: conditionId ame_conditions.condition_id%type;
2490: conditionKey ame_conditions.condition_key%type;
2491: conditionType ame_conditions.condition_type%type;
2492: currentUserId integer;
2493: errorCode integer;

Line 2490: conditionKey ame_conditions.condition_key%type;

2486: nvl(end_date - ame_util.oneSecond, sysdate)
2487: for update;
2488: attributeId ame_conditions.attribute_id%type;
2489: conditionId ame_conditions.condition_id%type;
2490: conditionKey ame_conditions.condition_key%type;
2491: conditionType ame_conditions.condition_type%type;
2492: currentUserId integer;
2493: errorCode integer;
2494: errorMessage ame_util.longestStringType;

Line 2491: conditionType ame_conditions.condition_type%type;

2487: for update;
2488: attributeId ame_conditions.attribute_id%type;
2489: conditionId ame_conditions.condition_id%type;
2490: conditionKey ame_conditions.condition_key%type;
2491: conditionType ame_conditions.condition_type%type;
2492: currentUserId integer;
2493: errorCode integer;
2494: errorMessage ame_util.longestStringType;
2495: includeLowerLimit ame_conditions.include_lower_limit%type;

Line 2495: includeLowerLimit ame_conditions.include_lower_limit%type;

2491: conditionType ame_conditions.condition_type%type;
2492: currentUserId integer;
2493: errorCode integer;
2494: errorMessage ame_util.longestStringType;
2495: includeLowerLimit ame_conditions.include_lower_limit%type;
2496: includeUpperLimit ame_conditions.include_upper_limit%type;
2497: objectVersionNoDataException exception;
2498: parameterOne ame_conditions.parameter_one%type;
2499: parameterTwo ame_conditions.parameter_two%type;

Line 2496: includeUpperLimit ame_conditions.include_upper_limit%type;

2492: currentUserId integer;
2493: errorCode integer;
2494: errorMessage ame_util.longestStringType;
2495: includeLowerLimit ame_conditions.include_lower_limit%type;
2496: includeUpperLimit ame_conditions.include_upper_limit%type;
2497: objectVersionNoDataException exception;
2498: parameterOne ame_conditions.parameter_one%type;
2499: parameterTwo ame_conditions.parameter_two%type;
2500: parameterThree ame_conditions.parameter_three%type;

Line 2498: parameterOne ame_conditions.parameter_one%type;

2494: errorMessage ame_util.longestStringType;
2495: includeLowerLimit ame_conditions.include_lower_limit%type;
2496: includeUpperLimit ame_conditions.include_upper_limit%type;
2497: objectVersionNoDataException exception;
2498: parameterOne ame_conditions.parameter_one%type;
2499: parameterTwo ame_conditions.parameter_two%type;
2500: parameterThree ame_conditions.parameter_three%type;
2501: startDate date;
2502: stringCount integer;

Line 2499: parameterTwo ame_conditions.parameter_two%type;

2495: includeLowerLimit ame_conditions.include_lower_limit%type;
2496: includeUpperLimit ame_conditions.include_upper_limit%type;
2497: objectVersionNoDataException exception;
2498: parameterOne ame_conditions.parameter_one%type;
2499: parameterTwo ame_conditions.parameter_two%type;
2500: parameterThree ame_conditions.parameter_three%type;
2501: startDate date;
2502: stringCount integer;
2503: processingDate date;

Line 2500: parameterThree ame_conditions.parameter_three%type;

2496: includeUpperLimit ame_conditions.include_upper_limit%type;
2497: objectVersionNoDataException exception;
2498: parameterOne ame_conditions.parameter_one%type;
2499: parameterTwo ame_conditions.parameter_two%type;
2500: parameterThree ame_conditions.parameter_three%type;
2501: startDate date;
2502: stringCount integer;
2503: processingDate date;
2504: begin

Line 2539: update ame_conditions

2535: parameterTwo := ame_condition_pkg.getParameterTwo(conditionIdIn => conditionIdIn);
2536: parameterThree := ame_condition_pkg.getParameterThree(conditionIdIn => conditionIdIn);
2537: includeLowerLimit := ame_condition_pkg.getIncludeLowerLimit(conditionIdIn => conditionIdIn);
2538: includeUpperLimit := ame_condition_pkg.getIncludeUpperLimit(conditionIdIn => conditionIdIn);
2539: update ame_conditions
2540: set
2541: last_updated_by = currentUserId,
2542: last_update_date = processingDate,
2543: last_update_login = currentUserId,