APPS.AME_ENGINE dependencies on AME_TEMP_HANDLER_STATES

Line 1587: handlerName ame_temp_handler_states.handler_name%type;

1583: return(null);
1584: end getHandlerRuleType;
1585: function getHandlerState(handlerNameIn in varchar2,
1586: parameterIn in varchar2 default null) return varchar2 as
1587: handlerName ame_temp_handler_states.handler_name%type;
1588: tempState ame_temp_handler_states.state%type;
1589: begin
1590: handlerName := upper(handlerNameIn);
1591: select state

Line 1588: tempState ame_temp_handler_states.state%type;

1584: end getHandlerRuleType;
1585: function getHandlerState(handlerNameIn in varchar2,
1586: parameterIn in varchar2 default null) return varchar2 as
1587: handlerName ame_temp_handler_states.handler_name%type;
1588: tempState ame_temp_handler_states.state%type;
1589: begin
1590: handlerName := upper(handlerNameIn);
1591: select state
1592: into tempState

Line 1593: from ame_temp_handler_states

1589: begin
1590: handlerName := upper(handlerNameIn);
1591: select state
1592: into tempState
1593: from ame_temp_handler_states
1594: where
1595: handler_name = handlerName and
1596: ((application_id is null and engAmeApplicationId is null) or
1597: (application_id = engAmeApplicationId)) and

Line 2552: handlerName ame_temp_handler_states.handler_name%type;

2548: end checkApprover;
2549: --+
2550: procedure clearHandlerState(handlerNameIn in varchar2,
2551: parameterIn in varchar2 default null) as
2552: handlerName ame_temp_handler_states.handler_name%type;
2553: begin
2554: handlerName := upper(handlerNameIn);
2555: delete
2556: from ame_temp_handler_states

Line 2556: from ame_temp_handler_states

2552: handlerName ame_temp_handler_states.handler_name%type;
2553: begin
2554: handlerName := upper(handlerNameIn);
2555: delete
2556: from ame_temp_handler_states
2557: where
2558: handler_name = handlerName and
2559: application_id = engAmeApplicationId and
2560: ((parameter is null and parameterIn is null) or

Line 11420: handlerName ame_temp_handler_states.handler_name%type;

11416: stateIn in varchar2 default null) as
11417: argumentLengthException exception;
11418: errorCode integer;
11419: errorMessage ame_util.longestStringType;
11420: handlerName ame_temp_handler_states.handler_name%type;
11421: begin
11422: if(lengthb(stateIn) > 100 or
11423: lengthb(parameterIn) > 100) then
11424: raise argumentLengthException;

Line 11428: from ame_temp_handler_states

11424: raise argumentLengthException;
11425: end if;
11426: handlerName := upper(handlerNameIn);
11427: delete
11428: from ame_temp_handler_states
11429: where
11430: handler_name = handlerName and
11431: application_id = engAmeApplicationId and
11432: ((parameter is null and parameterIn is null) or

Line 11434: insert into ame_temp_handler_states(

11430: handler_name = handlerName and
11431: application_id = engAmeApplicationId and
11432: ((parameter is null and parameterIn is null) or
11433: (parameter = parameterIn));
11434: insert into ame_temp_handler_states(
11435: handler_name,
11436: row_timestamp,
11437: application_id,
11438: parameter,