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 428: ame_conditions

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

Line 475: includeLowerLimit ame_conditions.include_lower_limit%type;

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

Line 479: from ame_conditions

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

Line 499: includeUpperLimit ame_conditions.include_upper_limit%type;

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

Line 503: from ame_conditions

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

Line 529: ame_conditions

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

Line 531: ame_conditions.condition_id = conditionIdIn and

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

Line 532: ame_attributes.attribute_id = ame_conditions.attribute_id and

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

Line 533: sysdate between ame_conditions.start_date and

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

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

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

Line 558: parameterOne ame_conditions.parameter_one%type;

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

Line 562: from ame_conditions

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

Line 582: parameterTwo ame_conditions.parameter_two%type;

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

Line 586: from ame_conditions

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

Line 606: parameterThree ame_conditions.parameter_three%type;

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

Line 610: from ame_conditions

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

Line 634: from ame_conditions

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

Line 654: conditionType ame_conditions.condition_type%type;

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

Line 658: from ame_conditions

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

Line 683: from ame_conditions

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

Line 813: ame_conditions

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

Line 815: ame_attributes.attribute_id = ame_conditions.attribute_id and

811: ame_attribute_usages,
812: ame_attributes,
813: ame_conditions
814: where
815: ame_attributes.attribute_id = ame_conditions.attribute_id and
816: ame_conditions.condition_type = conditionTypeIn and
817: ame_attributes.line_item = ame_util.booleanTrue and
818: ame_attribute_usages.attribute_id = ame_attributes.attribute_id and
819: ame_attribute_usages.application_id = applicationIdIn and

Line 816: ame_conditions.condition_type = conditionTypeIn and

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

Line 827: sysdate between ame_conditions.start_date and

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

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

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

Line 859: from ame_conditions

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

Line 944: from ame_conditions

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

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

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

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

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

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

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

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

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

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

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

Line 1002: from ame_conditions

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

Line 1011: from ame_conditions

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

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

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

Line 1026: from ame_conditions

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

Line 1036: insert into ame_conditions(condition_id,

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

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

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

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

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

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

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

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

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

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

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

Line 1454: from ame_conditions

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

Line 1472: from ame_conditions

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

Line 1482: conditionKey ame_conditions.condition_key%type;

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

Line 1483: conditionType ame_conditions.condition_type%type;

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

Line 1516: from ame_conditions

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

Line 1568: update ame_conditions

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

Line 1686: from ame_conditions

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

Line 1722: ame_conditions.condition_id id,

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

Line 1723: ame_conditions.condition_type,

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

Line 1727: from ame_conditions,

1723: ame_conditions.condition_type,
1724: ame_attributes.attribute_id,
1725: ame_attributes.name,
1726: ame_attributes.attribute_type
1727: from ame_conditions,
1728: ame_attributes,
1729: ame_attribute_usages,
1730: ame_item_class_usages
1731: where

Line 1735: ame_conditions.attribute_id = ame_attribute_usages.attribute_id and

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

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

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

Line 1739: sysdate between ame_conditions.start_date and

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

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

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

Line 1747: order by ame_conditions.condition_type,

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

Line 1752: conditionType ame_conditions.condition_type%type;

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

Line 1808: from ame_conditions,

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

Line 1811: ame_conditions.attribute_id = ame_attributes.attribute_id and

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

Line 1815: sysdate between ame_conditions.start_date and

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

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

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

Line 1856: ame_conditions.condition_id id,

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

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

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

Line 1858: from ame_conditions,

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

Line 1861: ame_conditions.attribute_id = ame_attributes.attribute_id and

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

Line 1865: sysdate between ame_conditions.start_date and

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

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

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

Line 1912: from ame_conditions,

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

Line 1915: ame_conditions.attribute_id = ame_attributes.attribute_id and

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

Line 1920: sysdate between ame_conditions.start_date and

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

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

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

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

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

Line 2066: from ame_conditions

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

Line 2100: ame_conditions

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

Line 2140: ame_conditions.condition_id condition_id,

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

Line 2141: ame_conditions.parameter_one parameter_one,

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

Line 2142: ame_conditions.parameter_two parameter_two

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

Line 2144: ame_conditions

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

Line 2146: ame_conditions.condition_type = ame_util.listModConditionType and

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

Line 2147: sysdate between ame_conditions.start_date and

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

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

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

Line 2187: ame_conditions.condition_id condition_id,

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

Line 2188: ame_conditions.parameter_two parameter_two

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

Line 2190: ame_conditions

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

Line 2192: ame_conditions.condition_type = ame_util.listModConditionType and

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

Line 2193: ame_conditions.parameter_one = lmApproverTypeIn and

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

Line 2194: sysdate between ame_conditions.start_date and

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

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

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

Line 2282: from ame_conditions

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

Line 2289: conditionType ame_conditions.condition_type%type;

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

Line 2329: update ame_conditions

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

Line 2485: from ame_conditions

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

Line 2491: attributeId ame_conditions.attribute_id%type;

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

Line 2492: conditionId ame_conditions.condition_id%type;

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

Line 2493: conditionKey ame_conditions.condition_key%type;

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

Line 2494: conditionType ame_conditions.condition_type%type;

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

Line 2498: includeLowerLimit ame_conditions.include_lower_limit%type;

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

Line 2499: includeUpperLimit ame_conditions.include_upper_limit%type;

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

Line 2501: parameterOne ame_conditions.parameter_one%type;

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

Line 2502: parameterTwo ame_conditions.parameter_two%type;

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

Line 2503: parameterThree ame_conditions.parameter_three%type;

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

Line 2542: update ame_conditions

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