APPS.AME_ENGINE dependencies on STANDARD

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

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

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

1596: ((application_id is null and engAmeApplicationId is null) or
1597: (application_id = engAmeApplicationId)) and
1598: ((parameter is null and parameterIn is null) or
1599: (parameter = parameterIn)) and
1600: rownum < 2; /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */
1601: return(tempState);
1602: exception
1603: when no_data_found then
1604: return(null);

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

3255: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3256: engEffectiveRuleDate between
3257: ame_condition_usages.start_date and
3258: nvl(ame_condition_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3259: /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */
3260: rownum < 2) and
3261: engEffectiveRuleDate between
3262: ame_rules.start_date and
3263: nvl(ame_rules.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

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

5233: /* Don't use engEffectiveRuleDate here. */
5234: sysdate between
5235: start_date and
5236: nvl(end_date - ame_util.oneSecond, sysdate) and
5237: rownum < 2; /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */
5238: exception
5239: when others then
5240: ame_util.runtimeException(packageNameIn => 'ame_engine',
5241: routineNameIn => 'fetchFndApplicationId',

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

7377: nvl(ame_conditions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
7378: engEffectiveRuleDate between
7379: ame_condition_usages.start_date and
7380: nvl(ame_condition_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
7381: rownum < 2; /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */
7382: /* Check for an invalid wf_roles.name value in parameter_two. */
7383: if(parameterTwo = ame_util.invalidApproverWfRolesName) then
7384: raise invalidNameException;
7385: end if;

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

8466: from ame_temp_transactions
8467: where
8468: application_id = ameApplicationIdIn and
8469: transaction_id = transactionIdIn and
8470: rownum < 2; /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */
8471: if(tempCount = 0) then
8472: insert into ame_temp_transactions(
8473: application_id,
8474: transaction_id,

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

9284: from ame_temp_transactions
9285: where
9286: application_id = engAmeApplicationId and
9287: transaction_id = engTransactionId and
9288: rownum < 2; /* Avoids second fetch otherwise required by ANSI standard to check for too many rows. */
9289: if(tempCount = 0) then
9290: select ame_temp_transactions_s.nextval into tempTransSeqId from dual;
9291: insert into ame_temp_transactions(
9292: application_id,