24:
25: PROCEDURE select_resource_info(
26: p_delinquency_id IN NUMBER);
27:
28: p_wf_item_NUMBER_NAME wf_engine.NameTabTyp ;
29: p_wf_item_NUMBER_VALUE wf_engine.NumTabTyp ;
30: p_wf_item_TEXT_NAME wf_engine.NameTabTyp ;
31: p_wf_item_TEXT_VALUE wf_engine.TextTabTyp ;
32:
25: PROCEDURE select_resource_info(
26: p_delinquency_id IN NUMBER);
27:
28: p_wf_item_NUMBER_NAME wf_engine.NameTabTyp ;
29: p_wf_item_NUMBER_VALUE wf_engine.NumTabTyp ;
30: p_wf_item_TEXT_NAME wf_engine.NameTabTyp ;
31: p_wf_item_TEXT_VALUE wf_engine.TextTabTyp ;
32:
33: TYPE DEL_NOTIFICATION_CUR IS REF CURSOR ;
26: p_delinquency_id IN NUMBER);
27:
28: p_wf_item_NUMBER_NAME wf_engine.NameTabTyp ;
29: p_wf_item_NUMBER_VALUE wf_engine.NumTabTyp ;
30: p_wf_item_TEXT_NAME wf_engine.NameTabTyp ;
31: p_wf_item_TEXT_VALUE wf_engine.TextTabTyp ;
32:
33: TYPE DEL_NOTIFICATION_CUR IS REF CURSOR ;
34:
27:
28: p_wf_item_NUMBER_NAME wf_engine.NameTabTyp ;
29: p_wf_item_NUMBER_VALUE wf_engine.NumTabTyp ;
30: p_wf_item_TEXT_NAME wf_engine.NameTabTyp ;
31: p_wf_item_TEXT_VALUE wf_engine.TextTabTyp ;
32:
33: TYPE DEL_NOTIFICATION_CUR IS REF CURSOR ;
34:
35: PROCEDURE SEND_NOTIFICATION( p_itemtype varchar2 ,
33: TYPE DEL_NOTIFICATION_CUR IS REF CURSOR ;
34:
35: PROCEDURE SEND_NOTIFICATION( p_itemtype varchar2 ,
36: p_itemkey varchar2 ,
37: p_wf_item_NUMBER_NAME wf_engine.NameTabTyp ,
38: p_wf_item_NUMBER_VALUE wf_engine.NumTabTyp ,
39: p_wf_item_TEXT_NAME wf_engine.NameTabTyp ,
40: p_wf_item_TEXT_VALUE wf_engine.TextTabTyp ,
41: l_return_status OUT NOCOPY varchar2 ,
34:
35: PROCEDURE SEND_NOTIFICATION( p_itemtype varchar2 ,
36: p_itemkey varchar2 ,
37: p_wf_item_NUMBER_NAME wf_engine.NameTabTyp ,
38: p_wf_item_NUMBER_VALUE wf_engine.NumTabTyp ,
39: p_wf_item_TEXT_NAME wf_engine.NameTabTyp ,
40: p_wf_item_TEXT_VALUE wf_engine.TextTabTyp ,
41: l_return_status OUT NOCOPY varchar2 ,
42: l_result OUT NOCOPY varchar2 ) ;
35: PROCEDURE SEND_NOTIFICATION( p_itemtype varchar2 ,
36: p_itemkey varchar2 ,
37: p_wf_item_NUMBER_NAME wf_engine.NameTabTyp ,
38: p_wf_item_NUMBER_VALUE wf_engine.NumTabTyp ,
39: p_wf_item_TEXT_NAME wf_engine.NameTabTyp ,
40: p_wf_item_TEXT_VALUE wf_engine.TextTabTyp ,
41: l_return_status OUT NOCOPY varchar2 ,
42: l_result OUT NOCOPY varchar2 ) ;
43:
36: p_itemkey varchar2 ,
37: p_wf_item_NUMBER_NAME wf_engine.NameTabTyp ,
38: p_wf_item_NUMBER_VALUE wf_engine.NumTabTyp ,
39: p_wf_item_TEXT_NAME wf_engine.NameTabTyp ,
40: p_wf_item_TEXT_VALUE wf_engine.TextTabTyp ,
41: l_return_status OUT NOCOPY varchar2 ,
42: l_result OUT NOCOPY varchar2 ) ;
43:
44: