APPS.AMS_TCOP_PREVIEW dependencies on WF_EVENT

Line 2397: p_event IN OUT NOCOPY WF_EVENT_T

2393: -- Purpose
2394: -- This function is called from Business Event raised through UI
2395: -- ===============================================================
2396: FUNCTION REFRESH(p_subscription_guid IN RAW,
2397: p_event IN OUT NOCOPY WF_EVENT_T
2398: ) RETURN VARCHAR2
2399: IS
2400: --Local Variables
2401: l_list_header_id NUMBER;

Line 2430: WF_EVENT.setErrorInfo(p_event, 'ERROR');

2426: WHEN OTHERS THEN
2427:
2428: WF_CORE.CONTEXT('AMS_TCOP_PREVIEW','REFRESH',
2429: p_event.getEventName( ), p_subscription_guid);
2430: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2431:
2432: -- First Update the Status to ERROR
2433: UPDATE AMS_TCOP_PRVW_REQUESTS
2434: SET STATUS='ERROR',

Line 2454: p_event IN OUT NOCOPY WF_EVENT_T

2450: -- This function is called from Business Event raised through
2451: -- Post Target Group Generation Business Event
2452: -- ===============================================================
2453: FUNCTION FORCE_REFRESH(p_subscription_guid IN RAW,
2454: p_event IN OUT NOCOPY WF_EVENT_T
2455: ) RETURN VARCHAR2
2456: IS
2457:
2458: CURSOR C_PREVIEW_SIZE (p_list_header_id NUMBER)

Line 2501: WF_EVENT.setErrorInfo(p_event, 'ERROR');

2497: WHEN OTHERS THEN
2498:
2499: WF_CORE.CONTEXT('AMS_TCOP_PREVIEW','REFRESH',
2500: p_event.getEventName( ), p_subscription_guid);
2501: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2502:
2503: -- First Update the Status to ERROR
2504: UPDATE AMS_TCOP_PRVW_REQUESTS
2505: SET STATUS='ERROR',

Line 2593: wf_event.AddParameterToList(p_name => 'LIST_HEADER_ID',

2589: -- Create Preview Request
2590: CREATE_PREVIEW_REQUEST(p_list_header_id,l_total_preview_count);
2591:
2592:
2593: wf_event.AddParameterToList(p_name => 'LIST_HEADER_ID',
2594: p_value => to_char(p_list_header_id),
2595: p_parameterlist => l_parameter_list);
2596:
2597: wf_event.AddParameterToList(p_name => 'PREVIEW_REQUEST_ID',

Line 2597: wf_event.AddParameterToList(p_name => 'PREVIEW_REQUEST_ID',

2593: wf_event.AddParameterToList(p_name => 'LIST_HEADER_ID',
2594: p_value => to_char(p_list_header_id),
2595: p_parameterlist => l_parameter_list);
2596:
2597: wf_event.AddParameterToList(p_name => 'PREVIEW_REQUEST_ID',
2598: p_value => to_char(G_PRVW_REQUEST_ID),
2599: p_parameterlist => l_parameter_list);
2600:
2601:

Line 2606: wf_event.raise( p_event_name => 'oracle.apps.ams.tcop.RefreshPreview',

2602: select to_char(sysdate, 'YYYYMMDDHH24MISS') into l_event_key from dual;
2603:
2604: l_event_key := to_char(p_list_header_id) || '_' || l_event_key;
2605:
2606: wf_event.raise( p_event_name => 'oracle.apps.ams.tcop.RefreshPreview',
2607: p_event_key => l_event_key,
2608: p_parameters => l_parameter_list);
2609:
2610: l_parameter_list.DELETE;

Line 2707: wf_event.AddParameterToList(p_name => 'LIST_HEADER_ID',

2703:
2704: CREATE_PREVIEW_REQUEST(p_list_header_id,l_total_preview_count);
2705:
2706:
2707: wf_event.AddParameterToList(p_name => 'LIST_HEADER_ID',
2708: p_value => to_char(p_list_header_id),
2709: p_parameterlist => l_parameter_list);
2710:
2711: wf_event.AddParameterToList(p_name => 'PREVIEW_REQUEST_ID',

Line 2711: wf_event.AddParameterToList(p_name => 'PREVIEW_REQUEST_ID',

2707: wf_event.AddParameterToList(p_name => 'LIST_HEADER_ID',
2708: p_value => to_char(p_list_header_id),
2709: p_parameterlist => l_parameter_list);
2710:
2711: wf_event.AddParameterToList(p_name => 'PREVIEW_REQUEST_ID',
2712: p_value => to_char(G_PRVW_REQUEST_ID),
2713: p_parameterlist => l_parameter_list);
2714:
2715: wf_event.AddParameterToList(p_name => 'GLOBAL_NO_OF_PERIOD',

Line 2715: wf_event.AddParameterToList(p_name => 'GLOBAL_NO_OF_PERIOD',

2711: wf_event.AddParameterToList(p_name => 'PREVIEW_REQUEST_ID',
2712: p_value => to_char(G_PRVW_REQUEST_ID),
2713: p_parameterlist => l_parameter_list);
2714:
2715: wf_event.AddParameterToList(p_name => 'GLOBAL_NO_OF_PERIOD',
2716: p_value => to_char(G_GLOBAL_NO_OF_PERIOD),
2717: p_parameterlist => l_parameter_list);
2718:
2719: select to_char(sysdate, 'YYYYMMDDHH24MISS') into l_event_key from dual;

Line 2723: wf_event.raise( p_event_name => 'oracle.apps.ams.tcop.RefreshPreview',

2719: select to_char(sysdate, 'YYYYMMDDHH24MISS') into l_event_key from dual;
2720:
2721: l_event_key := to_char(p_list_header_id) || '_' || l_event_key;
2722:
2723: wf_event.raise( p_event_name => 'oracle.apps.ams.tcop.RefreshPreview',
2724: p_event_key => l_event_key,
2725: p_parameters => l_parameter_list);
2726:
2727: l_parameter_list.DELETE;