DBA Data[Home] [Help]

APPS.AMS_SCHEDULERULES_PVT dependencies on WF_PARAMETER_LIST_T

Line 2970: l_parameter_list WF_PARAMETER_LIST_T;

2966: l_obj_ver_num NUMBER;
2967: l_content_item_status VARCHAR2(20);
2968: l_def_flag VARCHAR2(1);
2969:
2970: l_parameter_list WF_PARAMETER_LIST_T;
2971: l_new_item_key VARCHAR2(30);
2972: l_owner_user_id NUMBER;
2973: l_campaign_id NUMBER;
2974:

Line 3040: l_parameter_list := WF_PARAMETER_LIST_T();

3036: THEN
3037: IF l_trig_repeat_flag = 'Y' AND l_orig_csch_id IS NULL -- repeating csch parent instance
3038: THEN
3039: l_new_item_key := p_schedule_id || 'RPT' || TO_CHAR(SYSDATE,'DDMMRRRRHH24MISS');
3040: l_parameter_list := WF_PARAMETER_LIST_T();
3041: wf_event.AddParameterToList(p_name => 'SCHEDULE_ID',
3042: p_value => p_schedule_id,
3043: p_parameterlist => l_parameter_list);
3044:

Line 3074: l_parameter_list := WF_PARAMETER_LIST_T();

3070: p_send_date => l_sys_start_time);
3071:
3072: ELSE -- not repeating csch parent instance
3073: l_new_item_key := p_schedule_id || TO_CHAR(SYSDATE,'DDMMRRRRHH24MISS');
3074: l_parameter_list := WF_PARAMETER_LIST_T();
3075:
3076: wf_event.AddParameterToList(p_name => 'SCHEDULE_ID',
3077: p_value => p_schedule_id,
3078: p_parameterlist => l_parameter_list);

Line 5827: l_parameter_list WF_PARAMETER_LIST_T;

5823: funcmode IN VARCHAR2,
5824: result OUT NOCOPY VARCHAR2) IS
5825:
5826: l_schedule_id NUMBER;
5827: l_parameter_list WF_PARAMETER_LIST_T;
5828: l_schedule_next_run_st_date DATE;
5829: l_temp_variable varchar2(50);
5830:
5831: l_sch_text VARCHAR2(100);

Line 5844: l_parameter_list := WF_PARAMETER_LIST_T();

5840: itemtype => itemtype,
5841: itemkey => itemkey ,
5842: aname => 'AMS_NEW_SCHEDULE_ID');
5843:
5844: l_parameter_list := WF_PARAMETER_LIST_T();
5845:
5846: wf_event.AddParameterToList(p_name => 'SCHEDULE_ID',
5847: p_value => l_schedule_id,
5848: p_parameterlist => l_parameter_list);

Line 5944: l_parameter_list WF_PARAMETER_LIST_T;

5940: l_old_status_code VARCHAR2(30);
5941: l_related_event_from VARCHAR2(30);
5942: l_related_event_id NUMBER;
5943: l_schedule_type VARCHAR2(4);
5944: l_parameter_list WF_PARAMETER_LIST_T;
5945: l_new_item_key VARCHAR2(100);
5946:
5947: BEGIN
5948:

Line 5979: l_parameter_list := WF_PARAMETER_LIST_T();

5975:
5976: IF ( p_old_status_code <> p_new_status_code )
5977: THEN
5978:
5979: l_parameter_list := WF_PARAMETER_LIST_T();
5980: l_new_item_key := p_obj_id || 'STATUS' || p_obj_type || TO_CHAR(SYSDATE,'DDMMRRRRHH24MISS');
5981:
5982:
5983: wf_event.AddParameterToList(p_name => 'OBJECT_TYPE',