804: p_result OUT NOCOPY VARCHAR2) IS
805: ------------------------------------------------------------------------
806: l_debug_info VARCHAR2(200);
807:
808: l_status wf_item_activity_statuses.ACTIVITY_STATUS%TYPE;
809: l_result wf_item_activity_statuses.ACTIVITY_RESULT_CODE%TYPE;
810:
811: l_item_key wf_items.item_key%TYPE;
812: l_found_item_key wf_items.item_key%TYPE;
805: ------------------------------------------------------------------------
806: l_debug_info VARCHAR2(200);
807:
808: l_status wf_item_activity_statuses.ACTIVITY_STATUS%TYPE;
809: l_result wf_item_activity_statuses.ACTIVITY_RESULT_CODE%TYPE;
810:
811: l_item_key wf_items.item_key%TYPE;
812: l_found_item_key wf_items.item_key%TYPE;
813:
873: p_result OUT NOCOPY VARCHAR2) IS
874: ------------------------------------------------------------------------
875: l_debug_info VARCHAR2(200);
876:
877: l_status wf_item_activity_statuses.ACTIVITY_STATUS%TYPE;
878: l_result wf_item_activity_statuses.ACTIVITY_RESULT_CODE%TYPE;
879:
880: l_item_key wf_items.item_key%TYPE;
881: l_found_item_key wf_items.item_key%TYPE;
874: ------------------------------------------------------------------------
875: l_debug_info VARCHAR2(200);
876:
877: l_status wf_item_activity_statuses.ACTIVITY_STATUS%TYPE;
878: l_result wf_item_activity_statuses.ACTIVITY_RESULT_CODE%TYPE;
879:
880: l_item_key wf_items.item_key%TYPE;
881: l_found_item_key wf_items.item_key%TYPE;
882:
1009:
1010: l_item_key wf_items.item_key%type;
1011: l_found_item_key wf_items.item_key%type;
1012:
1013: l_status wf_item_activity_statuses.ACTIVITY_STATUS%TYPE;
1014: l_result wf_item_activity_statuses.ACTIVITY_RESULT_CODE%TYPE;
1015:
1016: -- cursor for receipt events
1017: CURSOR c_receipt_events is
1010: l_item_key wf_items.item_key%type;
1011: l_found_item_key wf_items.item_key%type;
1012:
1013: l_status wf_item_activity_statuses.ACTIVITY_STATUS%TYPE;
1014: l_result wf_item_activity_statuses.ACTIVITY_RESULT_CODE%TYPE;
1015:
1016: -- cursor for receipt events
1017: CURSOR c_receipt_events is
1018: select item_key