DBA Data[Home] [Help]

APPS.AMS_TRIGGER_PVT dependencies on AMS_THLDCHK_PVT

Line 82: p_thldchk_rec IN Ams_Thldchk_pvt.thldchk_rec_type DEFAULT NULL,

78: x_msg_data OUT NOCOPY VARCHAR2,
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,

Line 97: l_thldchk_rec Ams_Thldchk_pvt.thldchk_rec_type := p_thldchk_rec;

93:
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:

Line 202: AMS_THLDCHK_PVT.Create_thldchk

198: AMS_Utility_PVT.debug_message(l_full_name ||'CG : Create Trigger Check' || 'Trigger type = ' || p_trig_rec.triggering_type);
199: END IF;
200:
201: IF ( p_trig_rec.triggering_type <> 'DATE' ) THEN
202: AMS_THLDCHK_PVT.Create_thldchk
203: ( p_api_version => l_api_version,
204: p_init_msg_list => p_init_msg_list,
205: p_commit => FND_API.G_FALSE,
206: p_validation_level => p_validation_level,

Line 454: p_thldchk_rec IN Ams_Thldchk_pvt.thldchk_rec_type DEFAULT NULL,

450: x_msg_count OUT NOCOPY NUMBER,
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

Line 492: l_thldchk_rec Ams_Thldchk_pvt.thldchk_rec_type:= p_thldchk_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;
493:
494: BEGIN
495: --
496: -- Standard Start of API savepoint

Line 573: AMS_THLDCHK_PVT.Update_Thldchk

569:
570: IF ( p_trig_rec.triggering_type <> 'DATE' )
571: THEN
572: l_thldchk_rec.trigger_id := p_trig_rec.trigger_id;
573: AMS_THLDCHK_PVT.Update_Thldchk
574: ( p_api_version => l_api_version,
575: p_init_msg_list => FND_API.G_FALSE,
576: p_commit => FND_API.G_FALSE,
577: p_validation_level => p_validation_level,

Line 595: -- AMS_THLDCHK_PVT.Create_thldchk

591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
592: END IF;
593:
594: --ELSIF (p_updt_type = 'CREATE' ) THEN
595: -- AMS_THLDCHK_PVT.Create_thldchk
596: -- ( p_api_version => l_api_version,
597: -- p_init_msg_list => p_init_msg_list,
598: -- p_commit => FND_API.G_FALSE,
599: -- p_validation_level => p_validation_level,

Line 617: -- AMS_THLDCHK_PVT.Delete_thldchk

613: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
614: -- END IF;
615:
616: --ELSIF (p_updt_type = 'DELETE' ) THEN
617: -- AMS_THLDCHK_PVT.Delete_thldchk
618: -- ( p_api_version => l_api_version,
619: -- p_init_msg_list => p_init_msg_list,
620: -- p_commit => FND_API.G_FALSE,
621: