eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_WFTRIG_PVT dependencies on AMS_TRIGGERS

Line 287: -- workflowprocess Work Flaow Process Name (AMS_TRIGGERS)

283: -- IN
284: -- p_trigger_id Trigger id
285: -- p_trigger_name Trigger Name
286: -- processowner Owner Of the Process
287: -- workflowprocess Work Flaow Process Name (AMS_TRIGGERS)
288: -- item_type Item type DEFAULT NULL(AMS_TRIG)
289:
290: --
291: -- OUT

Line 386: UPDATE ams_triggers

382: -- FROM ams_trigger_actions
383: -- WHERE trigger_id = l_my_trigger_id ;
384: -- l_dummy NUMBER;
385: -- BEGIN
386: UPDATE ams_triggers
387: SET process_id = TO_NUMBER(itemkey)
388: WHERE trigger_id = p_trigger_id ;
389:
390: -- OPEN c_trigger_action(p_trigger_id);

Line 450: resultout := 'AMS_TRIGGERS';

446: --
447: IF (funcmode = 'RUN')
448: THEN
449: -- Return process to run
450: resultout := 'AMS_TRIGGERS';
451: RETURN;
452: END IF;
453: -- CANCEL mode - activity 'compensation'
454: IF (funcmode = 'CANCEL')

Line 457: resultout := 'AMS_TRIGGERS';

453: -- CANCEL mode - activity 'compensation'
454: IF (funcmode = 'CANCEL')
455: THEN
456: -- Return process to run
457: resultout := 'AMS_TRIGGERS';
458: RETURN;
459: END IF;
460: -- TIMEOUT mode
461: IF (funcmode = 'TIMEOUT')

Line 463: resultout := 'AMS_TRIGGERS';

459: END IF;
460: -- TIMEOUT mode
461: IF (funcmode = 'TIMEOUT')
462: THEN
463: resultout := 'AMS_TRIGGERS';
464: RETURN;
465: END IF;
466:
467: EXCEPTION

Line 609: FROM ams_triggers

605:
606: -- Start :anchaudh: 15 Oct'03 : added the following cursor and the variable.
607: CURSOR c_triggers(l_my_trigger_id NUMBER) IS
608: SELECT *
609: FROM ams_triggers
610: WHERE trigger_id = l_my_trigger_id ;
611:
612: l_trigger c_triggers%rowtype ;
613: -- End :anchaudh: 15 Oct'03 : added the following cursor and the variable.

Line 618: FROM ams_triggers

614:
615: /*
616: CURSOR c_sch_date(l_trigger_id NUMBER) IS
617: SELECT next_run_date_time
618: FROM ams_triggers
619: WHERE trigger_id = l_trigger_id;
620: l_trig_date c_sch_date%ROWTYPE;
621: */
622: BEGIN

Line 628: UPDATE ams_triggers SET next_run_date_time = (next_run_date_time+1/360) WHERE trigger_id = l_trigger_id;

624: l_trigger_id := WF_ENGINE.GetItemAttrText (itemtype => itemtype,
625: itemkey => itemkey ,
626: aname => 'AMS_TRIGGER_ID');
627:
628: UPDATE ams_triggers SET next_run_date_time = (next_run_date_time+1/360) WHERE trigger_id = l_trigger_id;
629: COMMIT;
630: OPEN c_sch_date(l_trigger_id);
631: FETCH c_sch_date INTO l_sch_date;
632: CLOSE c_sch_date;

Line 685: -- First Mark the Last Run Date Time (Update AMS_TRIGGERS with this date

681: OPEN c_triggers(l_trigger_id) ;
682: FETCH c_triggers INTO l_trigger ;
683: CLOSE c_triggers ;
684:
685: -- First Mark the Last Run Date Time (Update AMS_TRIGGERS with this date
686: -- at the end )
687: IF l_trigger.last_run_date_time IS NULL THEN
688: l_cur_date := l_trigger.start_date_time ;
689: l_last_run_date := l_trigger.start_date_time ;

Line 776: UPDATE ams_triggers

772: result := 'COMPLETE:ERROR' ;
773: RETURN;
774: END IF;
775:
776: UPDATE ams_triggers
777: SET last_run_date_time = l_cur_date,
778: next_run_date_time = l_sch_date,
779: user_last_run_date_time = l_user_last_run_date_time,
780: user_next_run_date_time = l_user_next_run_date_time

Line 873: FROM ams_triggers

869:
870: -- soagrawa 28-apr-2003 added this cursor to get end date of trigger
871: CURSOR c_trig_end_dt(p_trig_id NUMBER) IS
872: SELECT repeat_stop_date_time --to_char(repeat_stop_date_time,'DD-MM-RRRR HH:MI:SS AM')
873: FROM ams_triggers
874: WHERE trigger_id = p_trig_id;
875:
876: BEGIN
877: -- dbms_output.put_line('Process Check_Trigger_Status');

Line 1388: UPDATE ams_triggers

1384: aname => 'AMS_TRIG_RESULT_ID',
1385: avalue => NULL
1386: );
1387: /*
1388: UPDATE ams_triggers
1389: SET process_id = null
1390: WHERE trigger_id = l_trigger_id;
1391: */
1392: result := 'COMPLETE:' ;

Line 2082: l_process VARCHAR2(30) := nvl(p_workflow_process,'AMS_TRIGGERS');

2078: p_workflow_process IN VARCHAR2 DEFAULT NULL )
2079: IS
2080: l_itemtype VARCHAR2(30) := nvl(p_itemtype,'AMS_TRIG');
2081: l_itemkey VARCHAR2(30) ;
2082: l_process VARCHAR2(30) := nvl(p_workflow_process,'AMS_TRIGGERS');
2083: CURSOR c_trig_det IS
2084: SELECT process_id
2085: FROM ams_triggers
2086: WHERE trigger_id = p_trigger_id ;

Line 2085: FROM ams_triggers

2081: l_itemkey VARCHAR2(30) ;
2082: l_process VARCHAR2(30) := nvl(p_workflow_process,'AMS_TRIGGERS');
2083: CURSOR c_trig_det IS
2084: SELECT process_id
2085: FROM ams_triggers
2086: WHERE trigger_id = p_trigger_id ;
2087:
2088: l_status VARCHAR2(30);
2089: l_result VARCHAR2(30);

Line 2167: FROM ams_triggers

2163:
2164: -- soagrawa 28-apr-2003 added this cursor to get type of trigger
2165: CURSOR c_trig_type(p_trig_id NUMBER) IS
2166: SELECT triggering_type
2167: FROM ams_triggers
2168: WHERE trigger_id = p_trig_id;
2169:
2170: BEGIN
2171: -- dbms_output.put_line('Process Trig_Type_Date');

Line 2257: FROM ams_triggers

2253:
2254: -- soagrawa 28-apr-2003 added this cursor to get end date of trigger
2255: CURSOR c_trig_notify (p_trig_id NUMBER) IS
2256: SELECT notify_flag
2257: FROM ams_triggers
2258: WHERE trigger_id = p_trig_id;
2259:
2260: CURSOR c_notify_action_det (p_trig_id NUMBER) IS
2261: SELECT *

Line 2419: FROM ams_triggers

2415:
2416: -- soagrawa 28-apr-2003 added this cursor to get end date of trigger
2417: CURSOR c_trig_exec_csch (p_trig_id NUMBER) IS
2418: SELECT execute_schedule_flag
2419: FROM ams_triggers
2420: WHERE trigger_id = p_trig_id;
2421:
2422: BEGIN
2423: -- dbms_output.put_line('Process Trig_Type_Date');

Line 2611: FROM ams_Triggers

2607:
2608:
2609: CURSOR c_trigger_det (p_trigger_id NUMBER) IS
2610: SELECT repeat_frequency_type, repeat_every_x_frequency
2611: FROM ams_Triggers
2612: WHERE trigger_id = p_trigger_id;
2613:
2614:
2615: CURSOR c_camp_det (p_campaign_id IN NUMBER) IS

Line 3277: UPDATE ams_triggers

3273: p_parameters => l_parameter_list,
3274: p_send_date => l_sch_date
3275: );
3276:
3277: UPDATE ams_triggers
3278: SET process_id = to_number(l_new_item_key)
3279: WHERE trigger_id = l_trigger_id;
3280:
3281: END IF;

Line 3361: -- FROM ams_triggers

3357:
3358: CURSOR c_trig_det IS
3359: SELECT *
3360: -- modified by soagrawa
3361: -- FROM ams_triggers
3362: FROM ams_triggers_vl
3363: WHERE trigger_id = l_trigger_id ;
3364: l_trig_rec c_trig_det%ROWTYPE;
3365:

Line 3362: FROM ams_triggers_vl

3358: CURSOR c_trig_det IS
3359: SELECT *
3360: -- modified by soagrawa
3361: -- FROM ams_triggers
3362: FROM ams_triggers_vl
3363: WHERE trigger_id = l_trigger_id ;
3364: l_trig_rec c_trig_det%ROWTYPE;
3365:
3366: CURSOR c_check_det IS

Line 3445: UPDATE ams_triggers

3441: p_msg_type => 'DEBUG'
3442: );
3443:
3444: /*
3445: UPDATE ams_triggers
3446: SET process_id = TO_NUMBER(itemkey)
3447: WHERE trigger_id = l_trigger_id ;
3448: */
3449: OPEN c_trig_det;

Line 3669: FROM ams_triggers

3665: l_dummy NUMBER;
3666: l_return_status VARCHAR2(1);
3667: CURSOR c_trig_exist_det(p_trig_id NUMBER) IS
3668: SELECT 1
3669: FROM ams_triggers
3670: WHERE trigger_id = p_trig_id;
3671:
3672: BEGIN
3673: -- RUN mode - Normal Process Execution

Line 3796: FROM ams_triggers

3792:
3793: Delete from ams_trigger_results
3794: where trigger_result_for_id in
3795: (SELECT trigger_id
3796: FROM ams_triggers
3797: WHERE (repeat_stop_date_time + trig_end_date_days) < sysdate);
3798:
3799: retcode :=0;
3800: