DBA Data[Home] [Help]

APPS.AMS_SCHEDULERULES_PVT dependencies on WF_PARAMETER_LIST_T

Line 2958: l_parameter_list WF_PARAMETER_LIST_T;

2954: l_obj_ver_num NUMBER;
2955: l_content_item_status VARCHAR2(20);
2956: l_def_flag VARCHAR2(1);
2957:
2958: l_parameter_list WF_PARAMETER_LIST_T;
2959: l_new_item_key VARCHAR2(30);
2960: l_owner_user_id NUMBER;
2961: l_campaign_id NUMBER;
2962:

Line 3028: l_parameter_list := WF_PARAMETER_LIST_T();

3024: THEN
3025: IF l_trig_repeat_flag = 'Y' AND l_orig_csch_id IS NULL -- repeating csch parent instance
3026: THEN
3027: l_new_item_key := p_schedule_id || 'RPT' || TO_CHAR(SYSDATE,'DDMMRRRRHH24MISS');
3028: l_parameter_list := WF_PARAMETER_LIST_T();
3029: wf_event.AddParameterToList(p_name => 'SCHEDULE_ID',
3030: p_value => p_schedule_id,
3031: p_parameterlist => l_parameter_list);
3032:

Line 3062: l_parameter_list := WF_PARAMETER_LIST_T();

3058: p_send_date => l_sys_start_time);
3059:
3060: ELSE -- not repeating csch parent instance
3061: l_new_item_key := p_schedule_id || TO_CHAR(SYSDATE,'DDMMRRRRHH24MISS');
3062: l_parameter_list := WF_PARAMETER_LIST_T();
3063:
3064: wf_event.AddParameterToList(p_name => 'SCHEDULE_ID',
3065: p_value => p_schedule_id,
3066: p_parameterlist => l_parameter_list);

Line 5797: l_parameter_list WF_PARAMETER_LIST_T;

5793: funcmode IN VARCHAR2,
5794: result OUT NOCOPY VARCHAR2) IS
5795:
5796: l_schedule_id NUMBER;
5797: l_parameter_list WF_PARAMETER_LIST_T;
5798: l_schedule_next_run_st_date DATE;
5799: l_temp_variable varchar2(50);
5800:
5801: l_sch_text VARCHAR2(100);

Line 5814: l_parameter_list := WF_PARAMETER_LIST_T();

5810: itemtype => itemtype,
5811: itemkey => itemkey ,
5812: aname => 'AMS_NEW_SCHEDULE_ID');
5813:
5814: l_parameter_list := WF_PARAMETER_LIST_T();
5815:
5816: wf_event.AddParameterToList(p_name => 'SCHEDULE_ID',
5817: p_value => l_schedule_id,
5818: p_parameterlist => l_parameter_list);

Line 5914: l_parameter_list WF_PARAMETER_LIST_T;

5910: l_old_status_code VARCHAR2(30);
5911: l_related_event_from VARCHAR2(30);
5912: l_related_event_id NUMBER;
5913: l_schedule_type VARCHAR2(4);
5914: l_parameter_list WF_PARAMETER_LIST_T;
5915: l_new_item_key VARCHAR2(100);
5916:
5917: BEGIN
5918:

Line 5949: l_parameter_list := WF_PARAMETER_LIST_T();

5945:
5946: IF ( p_old_status_code <> p_new_status_code )
5947: THEN
5948:
5949: l_parameter_list := WF_PARAMETER_LIST_T();
5950: l_new_item_key := p_obj_id || 'STATUS' || p_obj_type || TO_CHAR(SYSDATE,'DDMMRRRRHH24MISS');
5951:
5952:
5953: wf_event.AddParameterToList(p_name => 'OBJECT_TYPE',