APPS.AME_ENGINE dependencies on STANDARD

Line 1041: rownum < 2; /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */

1037: /* Don't use engEffectiveRuleDate here. */
1038: sysdate between
1039: start_date and
1040: nvl(end_date - ame_util.oneSecond, sysdate) and
1041: rownum < 2; /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */
1042: return(ameApplicationId);
1043: exception
1044: when others then
1045: ame_util.runtimeException(packageNameIn => 'ame_engine',

Line 1640: rownum < 2; /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */

1636: ((application_id is null and engAmeApplicationId is null) or
1637: (application_id = engAmeApplicationId)) and
1638: ((parameter is null and parameterIn is null) or
1639: (parameter = parameterIn)) and
1640: rownum < 2; /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */
1641: return(tempState);
1642: exception
1643: when no_data_found then
1644: return(null);

Line 3299: /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */

3295: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3296: engEffectiveRuleDate between
3297: ame_condition_usages.start_date and
3298: nvl(ame_condition_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3299: /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */
3300: rownum < 2) and
3301: engEffectiveRuleDate between
3302: ame_rules.start_date and
3303: nvl(ame_rules.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

Line 5277: rownum < 2; /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */

5273: /* Don't use engEffectiveRuleDate here. */
5274: sysdate between
5275: start_date and
5276: nvl(end_date - ame_util.oneSecond, sysdate) and
5277: rownum < 2; /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */
5278: exception
5279: when others then
5280: ame_util.runtimeException(packageNameIn => 'ame_engine',
5281: routineNameIn => 'fetchFndApplicationId',

Line 7659: rownum < 2; /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */

7655: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
7656: engEffectiveRuleDate between
7657: ame_condition_usages.start_date and
7658: nvl(ame_condition_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
7659: rownum < 2; /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */
7660: /* Check for an invalid wf_roles.name value in parameter_two. */
7661: if(parameterTwo = ame_util.invalidApproverWfRolesName) then
7662: raise invalidNameException;
7663: end if;

Line 8749: rownum < 2; /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */

8745: from ame_temp_transactions
8746: where
8747: application_id = ameApplicationIdIn and
8748: transaction_id = transactionIdIn and
8749: rownum < 2; /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */
8750: if(tempCount = 0) then
8751: insert into ame_temp_transactions(
8752: application_id,
8753: transaction_id,

Line 9692: rownum < 2; /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */

9688: from ame_temp_transactions
9689: where
9690: application_id = engAmeApplicationId and
9691: transaction_id = engTransactionId and
9692: rownum < 2; /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */
9693: if(tempCount = 0) then
9694: select ame_temp_transactions_s.nextval into tempTransSeqId from dual;
9695: insert into ame_temp_transactions(
9696: application_id,