[Home] [Help]
6: -- AMS_ThldAct_PVT
7: --
8: -- HISTORY
9: -- 06/25/1999 ptendulk CREATED
10: -- 10/26/1999 ptendulk Modified according to new standards
11: -- 12/27/1999 ptendulk Added Validations for New columns in Action
12: -- Table(Del_id,..).
13: -- 02/24/2000 ptendulk Modified the validation for Collaterals
14: -- 03/16/2000 ptendulk Modified the Check_ThldAct_Fk_Items procedure
48: --
49: --
50: -- HISTORY
51: -- 06/29/1999 ptendulk created
52: -- 10/26/1999 ptendulk Modified according to new standards
53: -- 22/04/03 cgoyal added ACTION_NOTIF_USER_ID column value insert, for 11.5.8 backport
54: -- End of Comments
55:
56: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
85: SELECT COUNT(*)
86: FROM ams_trigger_actions
87: WHERE trigger_action_id = l_my_act_id;
88: BEGIN
89: -- Standard Start of API savepoint
90: SAVEPOINT Create_Thldact_PVT;
91:
92: --
93: -- Debug Message
104: FND_MSG_PUB.initialize;
105: END IF;
106:
107: --
108: -- Standard call to check for call compatibility.
109: --
110: IF NOT FND_API.Compatible_API_Call ( l_api_version,
111: p_api_version,
112: l_api_name,
232: --end soagrawa
233:
234: INSERT INTO ams_trigger_actions
235: (trigger_action_id
236: -- standard who columns
237: ,last_update_date
238: ,last_updated_by
239: ,creation_date
240: ,created_by
264: )
265: VALUES
266: (
267: l_thldact_rec.trigger_action_id
268: -- standard who columns
269: ,sysdate
270: ,FND_GLOBAL.User_Id
271: ,sysdate
272: ,FND_GLOBAL.User_Id
270: ,FND_GLOBAL.User_Id
271: ,sysdate
272: ,FND_GLOBAL.User_Id
273: ,FND_GLOBAL.Conc_Login_Id
274: -- end standard who columns
275: ,1 -- Object Version Number
276: ,l_thldact_rec.process_id --??
277: ,l_thldact_rec.trigger_id
278: ,l_thldact_rec.order_number --??
300: --
301: -- END of API body.
302: --
303: --
304: -- Standard check of p_commit.
305: --
306: IF FND_API.To_Boolean ( p_commit )
307: THEN
308: COMMIT WORK;
307: THEN
308: COMMIT WORK;
309: END IF;
310: --
311: -- Standard call to get message count AND IF count is 1, get message info.
312: --
313: FND_MSG_PUB.Count_AND_Get
314: (
315: p_count => x_msg_count,
368: --
369: --
370: -- HISTORY
371: -- 06/29/1999 ptendulk created
372: -- 10/26/1999 ptendulk Modified according to new standards
373: -- End of Comments
374:
375: PROCEDURE Delete_Thldact
376: ( p_api_version IN NUMBER,
390: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
391:
392: BEGIN
393: --
394: -- Standard Start of API savepoint
395: --
396: SAVEPOINT Delete_Thldact_PVT;
397:
398: --
410: FND_MSG_PUB.initialize;
411: END IF;
412:
413: --
414: -- Standard call to check for call compatibility.
415: --
416: IF NOT FND_API.Compatible_API_Call ( l_api_version,
417: p_api_version,
418: l_api_name,
461: --
462: -- END of API body.
463: --
464: --
465: -- Standard check of p_commit.
466: --
467: IF FND_API.To_Boolean ( p_commit )
468: THEN
469: COMMIT WORK;
469: COMMIT WORK;
470: END IF;
471:
472: --
473: -- Standard call to get message count AND IF count is 1, get message info.
474: --
475: FND_MSG_PUB.Count_AND_Get
476: ( p_count => x_msg_count,
477: p_data => x_msg_data,
528: --
529: --
530: -- HISTORY
531: -- 06/29/1999 ptendulk created
532: -- 10/26/1999 ptendulk Modified according to new standards
533: -- End of Comments
534:
535: PROCEDURE Lock_Thldact
536: ( p_api_version IN NUMBER,
575: FND_MSG_PUB.initialize;
576: END IF;
577:
578: --
579: -- Standard call to check for call compatibility.
580: --
581: IF NOT FND_API.Compatible_API_Call ( l_api_version,
582: p_api_version,
583: l_api_name,
623: -- END of API body.
624: --
625:
626: --
627: -- Standard call to get message count AND IF count is 1, get message info.
628: --
629: FND_MSG_PUB.Count_AND_Get
630: ( p_count => x_msg_count,
631: p_data => x_msg_data,
699: --
700: --
701: -- HISTORY
702: -- 06/29/1999 ptendulk created
703: -- 10/26/1999 ptendulk Modified according to new standards
704: -- End of Comments
705:
706: PROCEDURE Update_Thldact
707: ( p_api_version IN NUMBER,
726: l_thldact_rec thldact_rec_type ;
727:
728: BEGIN
729: --
730: -- Standard Start of API savepoint
731: --
732: SAVEPOINT Update_Thldact_PVT;
733:
734: --
746: FND_MSG_PUB.initialize;
747: END IF;
748:
749: --
750: -- Standard call to check for call compatibility.
751: --
752: IF NOT FND_API.Compatible_API_Call ( l_api_version,
753: p_api_version,
754: l_api_name,
851: --
852: -- END of API body.
853: --
854:
855: -- Standard check of p_commit.
856: IF FND_API.To_Boolean ( p_commit )
857: THEN
858: COMMIT WORK;
859: END IF;
858: COMMIT WORK;
859: END IF;
860:
861: --
862: -- Standard call to get message count AND IF count is 1, get message info.
863: --
864: FND_MSG_PUB.Count_AND_Get
865: ( p_count => x_msg_count,
866: p_data => x_msg_data,
925: --
926: --
927: -- HISTORY
928: -- 06/28/1999 ptendulk created
929: -- 10/26/1999 ptendulk Modified according to new standards
930: -- End of Comments
931:
932: PROCEDURE Validate_Thldact
933: ( p_api_version IN NUMBER,
963: IF FND_API.to_Boolean( p_init_msg_list ) THEN
964: FND_MSG_PUB.initialize;
965: END IF;
966:
967: -- Standard call to check for call compatibility.
968: IF NOT FND_API.Compatible_API_Call ( l_api_version,
969: p_api_version,
970: l_api_name,
971: G_PKG_NAME)
1018: END IF;
1019: END IF;
1020:
1021: --
1022: -- Standard call to get message count AND IF count is 1, get message info.
1023: --
1024: FND_MSG_PUB.Count_AND_Get
1025: ( p_count => x_msg_count,
1026: p_data => x_msg_data,
1091: --
1092: --
1093: -- HISTORY
1094: -- 02/28/1999 ptendulk created
1095: -- 10/26/1999 ptendulk Modified according to new standards
1096: -- End of Comments
1097:
1098: PROCEDURE Check_ThldAct_Req_Items
1099: ( p_thldact_rec IN thldact_rec_type,
1147: --
1148: --
1149: -- HISTORY
1150: -- 06/28/1999 ptendulk Created
1151: -- 10/26/1999 ptendulk Modified according to new standards
1152: -- End of Comments
1153: PROCEDURE Check_Thldact_Uk_Items(
1154: p_thldact_rec IN thldact_rec_type,
1155: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1228: --
1229: --
1230: -- HISTORY
1231: -- 06/28/1999 ptendulk Created
1232: -- 10/26/1999 ptendulk Modified according to new standards
1233: -- 03/16/2000 ptendulk Modified , the list of type 'TEMPLATE'
1234: -- can only be attached to the Triggers
1235: -- End of Comments
1236: PROCEDURE Check_ThldAct_Fk_Items(
1475: --
1476: --
1477: -- HISTORY
1478: -- 06/28/1999 ptendulk Created
1479: -- 10/26/1999 ptendulk Modified according to new standards
1480: -- End of Comments
1481: PROCEDURE Check_Thldact_Lookup_Items(
1482: p_thldact_rec IN thldact_rec_type,
1483: x_return_status OUT NOCOPY VARCHAR2
1621: --
1622: --
1623: -- HISTORY
1624: -- 06/28/1999 ptendulk Created
1625: -- 10/26/1999 ptendulk Modified according to new standards
1626: -- End of Comments
1627: PROCEDURE Check_ThldAct_Items(
1628: p_thldact_rec IN thldact_rec_type,
1629: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1693: --
1694: --
1695: -- HISTORY
1696: -- 07/26/1999 ptendulk Created
1697: -- 10/26/1999 ptendulk Modified according to new standards
1698: -- 02/24/2000 ptendulk Modified the validation for Collaterals
1699: -- 22/04/03 CGOYAL Added check for 11.5.8 backport
1700:
1701: -- End of Comments