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_TRIGGER_PVT dependencies on AMS_THLDACT_PVT

Line 83: p_thldact_rec IN Ams_Thldact_pvt.thldact_rec_type ,

79:
80: -- p_create_type IN VARCHAR2 := 'ALL' ,
81: p_trig_Rec IN Ams_Trig_pvt.trig_rec_type,
82: p_thldchk_rec IN Ams_Thldchk_pvt.thldchk_rec_type DEFAULT NULL,
83: p_thldact_rec IN Ams_Thldact_pvt.thldact_rec_type ,
84:
85: x_trigger_check_id OUT NOCOPY NUMBER,
86: x_trigger_action_id OUT NOCOPY NUMBER,
87: x_trigger_id OUT NOCOPY NUMBER

Line 98: l_thldact_rec Ams_Thldact_pvt.thldact_rec_type := p_thldact_rec;

94:
95: -- Status Local Variables
96: l_return_status VARCHAR2(1); -- Return value from procedures
97: l_thldchk_rec Ams_Thldchk_pvt.thldchk_rec_type := p_thldchk_rec;
98: l_thldact_rec Ams_Thldact_pvt.thldact_rec_type := p_thldact_rec;
99: -- soagrawa 30-apr-2003 added for action for execution
100: l_thldact_exec_rec Ams_Thldact_pvt.thldact_rec_type ;
101:
102: -- soagrawa 05-may-2003

Line 100: l_thldact_exec_rec Ams_Thldact_pvt.thldact_rec_type ;

96: l_return_status VARCHAR2(1); -- Return value from procedures
97: l_thldchk_rec Ams_Thldchk_pvt.thldchk_rec_type := p_thldchk_rec;
98: l_thldact_rec Ams_Thldact_pvt.thldact_rec_type := p_thldact_rec;
99: -- soagrawa 30-apr-2003 added for action for execution
100: l_thldact_exec_rec Ams_Thldact_pvt.thldact_rec_type ;
101:
102: -- soagrawa 05-may-2003
103: l_parameter_list WF_PARAMETER_LIST_T;
104: l_new_item_key VARCHAR2(30);

Line 241: AMS_THLDACT_PVT.Create_thldact

237: l_thldact_rec.trigger_id := x_trigger_id;
238: l_thldact_rec.trigger_action_id := null;
239: -- soagrawa 30-apr-2003
240: l_thldact_rec.execute_action_type := 'NOTIFY';
241: AMS_THLDACT_PVT.Create_thldact
242: ( p_api_version => l_api_version,
243: p_init_msg_list => p_init_msg_list,
244: p_commit => FND_API.G_FALSE,
245: p_validation_level => p_validation_level,

Line 267: AMS_THLDACT_PVT.Create_thldact

263: IF (p_trig_Rec.EXECUTE_SCHEDULE_FLAG = 'Y')
264: THEN
265: l_thldact_exec_rec.trigger_id := x_trigger_id;
266: l_thldact_exec_rec.execute_action_type := 'EXECUTE';
267: AMS_THLDACT_PVT.Create_thldact
268: ( p_api_version => l_api_version,
269: p_init_msg_list => p_init_msg_list,
270: p_commit => FND_API.G_FALSE,
271: p_validation_level => p_validation_level,

Line 455: p_thldact_rec IN Ams_Thldact_pvt.thldact_rec_type

451: x_msg_data OUT NOCOPY VARCHAR2,
452:
453: p_trig_rec IN Ams_Trig_pvt.trig_rec_type,
454: p_thldchk_rec IN Ams_Thldchk_pvt.thldchk_rec_type DEFAULT NULL,
455: p_thldact_rec IN Ams_Thldact_pvt.thldact_rec_type
456: -- p_updt_type IN VARCHAR2
457:
458: ) IS
459:

Line 487: l_thldact_rec Ams_Thldact_pvt.thldact_rec_type := p_thldact_rec;

483: AND execute_Action_type = p_action_type;
484:
485: l_notify_flag VARCHAR2(1);
486: l_execute_schedule_flag VARCHAR2(1);
487: l_thldact_rec Ams_Thldact_pvt.thldact_rec_type := p_thldact_rec;
488: l_thldact_exec_rec Ams_Thldact_pvt.thldact_rec_type ;
489: l_trig_action_id NUMBER;
490: l_object_version_number NUMBER;
491: l_trigger_action_id NUMBER;

Line 488: l_thldact_exec_rec Ams_Thldact_pvt.thldact_rec_type ;

484:
485: l_notify_flag VARCHAR2(1);
486: l_execute_schedule_flag VARCHAR2(1);
487: l_thldact_rec Ams_Thldact_pvt.thldact_rec_type := p_thldact_rec;
488: l_thldact_exec_rec Ams_Thldact_pvt.thldact_rec_type ;
489: l_trig_action_id NUMBER;
490: l_object_version_number NUMBER;
491: l_trigger_action_id NUMBER;
492: l_thldchk_rec Ams_Thldchk_pvt.thldchk_rec_type:= p_thldchk_rec;

Line 695: AMS_THLDACT_PVT.Update_ThldAct

691: l_thldact_rec.trigger_action_id := l_trig_action_id;
692: l_thldact_rec.object_version_number := l_object_version_number;
693: l_thldact_rec.execute_action_type := 'NOTIFY';
694:
695: AMS_THLDACT_PVT.Update_ThldAct
696: ( p_api_version => l_api_version,
697: p_init_msg_list => FND_API.G_FALSE,
698: p_commit => FND_API.G_FALSE,
699: p_validation_level => p_validation_level,

Line 723: AMS_THLDACT_PVT.Create_ThldAct

719: l_thldact_rec.trigger_id := p_trig_rec.trigger_id;
720: l_thldact_rec.trigger_action_id := null;
721: l_thldact_rec.execute_action_type := 'NOTIFY';
722:
723: AMS_THLDACT_PVT.Create_ThldAct
724: ( p_api_version => l_api_version,
725: p_init_msg_list => FND_API.G_FALSE,
726: p_commit => FND_API.G_FALSE,
727: p_validation_level => p_validation_level,

Line 761: AMS_THLDACT_PVT.Delete_ThldAct

757: END IF;
758: CLOSE c_actions_det;
759:
760:
761: AMS_THLDACT_PVT.Delete_ThldAct
762: ( p_api_version => l_api_version,
763: p_init_msg_list => FND_API.G_FALSE,
764: p_commit => FND_API.G_FALSE,
765: x_return_status => l_return_status,

Line 806: AMS_THLDACT_PVT.Update_ThldAct

802: l_thldact_rec.trigger_id := p_trig_rec.trigger_id;
803: l_thldact_rec.trigger_action_id := l_trig_action_id;
804: l_thldact_rec.execute_action_type := 'EXECUTE';
805:
806: AMS_THLDACT_PVT.Update_ThldAct
807: ( p_api_version => l_api_version,
808: p_init_msg_list => FND_API.G_FALSE,
809: p_commit => FND_API.G_FALSE,
810: p_validation_level => p_validation_level,

Line 836: AMS_THLDACT_PVT.Create_ThldAct

832: l_thldact_rec.trigger_action_id := null;
833: l_thldact_rec.execute_action_type := 'EXECUTE';
834: l_thldact_rec.action_for_id := null;
835:
836: AMS_THLDACT_PVT.Create_ThldAct
837: ( p_api_version => l_api_version,
838: p_init_msg_list => FND_API.G_FALSE,
839: p_commit => FND_API.G_FALSE,
840: p_validation_level => p_validation_level,

Line 873: AMS_THLDACT_PVT.Delete_ThldAct

869: RAISE FND_API.G_EXC_ERROR;
870: END IF;
871: CLOSE c_actions_det;
872:
873: AMS_THLDACT_PVT.Delete_ThldAct
874: ( p_api_version => l_api_version,
875: p_init_msg_list => FND_API.G_FALSE,
876: p_commit => FND_API.G_FALSE,
877: x_return_status => l_return_status,