[Home] [Help]
6: -- AMS_Trig_PVT
7: --
8: -- HISTORY
9: -- 07/26/1999 ptendulk CREATED
10: -- 10/25/1999 ptendulk Modified According to new standards
11: -- 02/24/2000 ptendulk Add the code to update Object Attribute after
12: -- Deletion or addition
13: -- 02/26/2000 ptendulk Modified the Check_Record Procedure
14: -- 02/26/2000 ptendulk Modified the package to support the timezone
70: --
71: --
72: -- HISTORY
73: -- 07/26/1999 ptendulk created
74: -- 10/25/1999 ptendulk Modified according to new standards
75: -- 02/24/2000 ptendulk Add the code to update Object Attribute after addition
76: -- 04/24/2000 ptendulk Added 6 Date fields and timezone id for timezone support
77: -- 14-Feb-2001 ptendulk Modified as triggers will have tl table to store name/desc
78: -- 22/apr/03 cgoyal added notify_flag and execute_schedule_flag for 11.5.8 backport
122: WHERE trigger_id = l_my_trig_id;
123:
124: BEGIN
125: --
126: -- Standard Start of API savepoint
127: --
128: SAVEPOINT Create_Trig_PVT;
129:
130: IF (AMS_DEBUG_HIGH_ON) THEN
139: FND_MSG_PUB.initialize;
140: END IF;
141:
142: --
143: -- Standard call to check for call compatibility.
144: --
145: IF NOT FND_API.Compatible_API_Call ( l_api_version,
146: p_api_version,
147: l_api_name,
251:
252:
253: INSERT INTO ams_triggers
254: (trigger_id
255: -- standard who columns
256: ,last_update_date
257: ,last_updated_by
258: ,creation_date
259: ,created_by
292: )
293: VALUES
294: (
295: l_trig_rec.trigger_id
296: -- standard who columns
297: ,SYSDATE
298: ,FND_GLOBAL.User_Id
299: ,SYSDATE
300: ,FND_GLOBAL.User_Id
437: --
438: -- END of API body.
439: --
440:
441: -- Standard check of p_commit.
442: IF FND_API.To_Boolean ( p_commit )
443: THEN
444: COMMIT WORK;
445: END IF;
444: COMMIT WORK;
445: END IF;
446:
447: --
448: -- Standard call to get message count AND IF count is 1, get message info.
449: --
450: FND_MSG_PUB.Count_AND_Get
451: ( p_count => x_msg_count,
452: p_data => x_msg_data,
531: --
532: --
533: -- HISTORY
534: -- 07/26/1999 ptendulk created
535: -- 10/25/1999 ptendulk Modified according to new API standards
536: -- 02/24/2000 ptendulk Add the code to update Object Attribute after
537: -- Deletion
538: -- 14-Feb-2001 ptendulk Modified as triggers will have tl table to store name/desc
539: -- 24-Apr-2001 soagrawa Modified as per the new business rules
582:
583:
584: BEGIN
585: --
586: -- Standard Start of API savepoint
587: --
588: SAVEPOINT Delete_Trig_PVT;
589:
590: --
604: FND_MSG_PUB.initialize;
605: END IF;
606:
607: --
608: -- Standard call to check for call compatibility.
609: --
610: IF NOT FND_API.Compatible_API_Call ( l_api_version,
611: p_api_version,
612: l_api_name,
720: -- END of API body.
721: --
722:
723: --
724: -- Standard check of p_commit.
725: --
726: -- dbms_output.put_line('commit : '||p_commit);
727: IF FND_API.To_Boolean ( p_commit )
728: THEN
729: COMMIT WORK;
730: END IF;
731:
732: --
733: -- Standard call to get message count AND IF count is 1, get message info.
734: --
735: FND_MSG_PUB.Count_AND_Get
736: ( p_count => x_msg_count,
737: p_data => x_msg_data,
802: --
803: --
804: -- HISTORY
805: -- 06/29/1999 ptendulk created
806: -- 10/25/1999 ptendulk Modified according to new API standards
807: -- End of Comments
808:
809: PROCEDURE Lock_Trigger
810: ( p_api_version IN NUMBER,
907: -- END of API body.
908: --
909:
910: --
911: -- Standard call to get message count AND IF count is 1, get message info.
912: --
913: FND_MSG_PUB.Count_AND_Get
914: ( p_count => x_msg_count,
915: p_data => x_msg_data,
984: --
985: --
986: -- HISTORY
987: -- 07/26/1999 ptendulk created
988: -- 10/25/1999 ptendulk Modified According to new API standards
989: -- 04/24/2000 ptendulk Added 6 User date fields and time zone id for
990: -- timezone support
991: -- 22/apr/03 cgoyal added notify_flag and execute_schedule_flag for 11.5.8 backport
992: -- End of Comments
1022: l_trig_det_rec c_trig%ROWTYPE;
1023:
1024: BEGIN
1025: --
1026: -- Standard Start of API savepoint
1027: --
1028: SAVEPOINT Update_Trig_PVT;
1029:
1030: --
1042: FND_MSG_PUB.initialize;
1043: END IF;
1044:
1045: --
1046: -- Standard call to check for call compatibility.
1047: --
1048: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1049: p_api_version,
1050: l_api_name,
1208: -- END of API body.
1209: --
1210:
1211: --
1212: -- Standard check of p_commit.
1213: --
1214: IF FND_API.to_boolean(p_commit) THEN
1215: COMMIT;
1216: END IF;
1443: --
1444: --
1445: -- HISTORY
1446: -- 07/26/1999 ptendulk created
1447: -- 10/25/1999 ptendulk Modified according to new API standards
1448: -- End of Comments
1449:
1450: PROCEDURE Validate_Trigger(
1451: p_api_version IN NUMBER,
1597: --
1598: --
1599: -- HISTORY
1600: -- 07/26/1999 ptendulk created
1601: -- 10/25/1999 ptendulk Modified according to new standards
1602: -- End of Comments
1603:
1604: PROCEDURE Check_Trig_Req_Items
1605: ( p_trig_rec IN trig_rec_type,