101: END IF;
102: CLOSE C_GET_STATUS_RULE_Name;
103: END IF;
104:
105: -- Standard call to get message count and IF count is 1, get message info.
106:
107: FND_MSG_PUB.Count_And_Get
108: ( p_count => x_msg_count,
109: p_data => x_msg_data );
163: END IF;
164: CLOSE C_GET_STATUS_RULE_ID_Name;
165: END IF;
166:
167: -- Standard call to get message count and IF count is 1, get message info.
168:
169: FND_MSG_PUB.Count_And_Get
170: ( p_count => x_msg_count,
171: p_data => x_msg_data );
197: l_status_rule_id NUMBER ;
198:
199: BEGIN
200:
201: -- Standard Start of API savepoint
202: SAVEPOINT CREATE_STATUS_RULE_PVT;
203:
204: l_STATUS_RULE_REC := p_status_rule_rec;
205: -- Standard call to check for call compatibility.
201: -- Standard Start of API savepoint
202: SAVEPOINT CREATE_STATUS_RULE_PVT;
203:
204: l_STATUS_RULE_REC := p_status_rule_rec;
205: -- Standard call to check for call compatibility.
206: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
207: p_api_version,
208: l_api_name,
209: G_PKG_NAME)
290: --
291: -- End of API body
292: --
293:
294: -- Standard check for p_commit
295: IF FND_API.to_Boolean( p_commit )
296: THEN
297: COMMIT WORK;
298: END IF;
297: COMMIT WORK;
298: END IF;
299:
300:
301: -- Standard call to get message count and IF count is 1, get message info.
302: FND_MSG_PUB.Count_And_Get
303: ( p_count => x_msg_count,
304: p_data => x_msg_data
305: );
374:
375:
376: BEGIN
377:
378: -- Standard Start of API savepoint
379: SAVEPOINT UPDATE_STATUS_RULE_PVT;
380:
381: l_STATUS_RULE_REC := p_status_rule_rec;
382: -- Standard call to check for call compatibility.
378: -- Standard Start of API savepoint
379: SAVEPOINT UPDATE_STATUS_RULE_PVT;
380:
381: l_STATUS_RULE_REC := p_status_rule_rec;
382: -- Standard call to check for call compatibility.
383: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
384: p_api_version,
385: l_api_name,
386: G_PKG_NAME)
492: --
493: -- End of API body.
494: --
495:
496: -- Standard check for p_commit
497: IF FND_API.to_Boolean( p_commit )
498: THEN
499: COMMIT WORK;
500: END IF;
498: THEN
499: COMMIT WORK;
500: END IF;
501:
502: -- Standard call to get message count and IF count is 1, get message info.
503: FND_MSG_PUB.Count_And_Get
504: ( p_count => x_msg_count,
505: p_data => x_msg_data );
506:
561: l_rowid Varchar2(50);
562:
563:
564: BEGIN
565: -- Standard Start of API savepoint
566: SAVEPOINT DELETE_STATUS_RULE_PVT;
567:
568: -- Standard call to check for call compatibility.
569: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
564: BEGIN
565: -- Standard Start of API savepoint
566: SAVEPOINT DELETE_STATUS_RULE_PVT;
567:
568: -- Standard call to check for call compatibility.
569: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
570: p_api_version,
571: l_api_name,
572: G_PKG_NAME)
617: --
618: -- End of API body
619: --
620:
621: -- Standard check for p_commit
622: IF FND_API.to_Boolean( p_commit )
623: THEN
624: COMMIT WORK;
625: END IF;
679: l_rowid Varchar2(50);
680: l_status_rule_line_REC IEX_STATUS_RULE_PUB.status_rule_line_REC_TYPE := p_status_rule_line_REC;
681:
682: BEGIN
683: -- Standard Start of API savepoint
684: SAVEPOINT CREATE_status_rule_line_PVT;
685:
686: -- Standard call to check for call compatibility.
687: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
682: BEGIN
683: -- Standard Start of API savepoint
684: SAVEPOINT CREATE_status_rule_line_PVT;
685:
686: -- Standard call to check for call compatibility.
687: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
688: p_api_version,
689: l_api_name,
690: G_PKG_NAME)
743: --
744: -- End of API body
745: --
746:
747: -- Standard check for p_commit
748: IF FND_API.to_Boolean( p_commit )
749: THEN
750: COMMIT WORK;
751: END IF;
750: COMMIT WORK;
751: END IF;
752:
753:
754: -- Standard call to get message count and IF count is 1, get message info.
755: FND_MSG_PUB.Count_And_Get
756: ( p_count => x_msg_count,
757: p_data => x_msg_data
758: );
820:
821:
822: BEGIN
823:
824: -- Standard Start of API savepoint
825: SAVEPOINT UPDATE_status_rule_line_PVT;
826:
827: -- Standard call to check for call compatibility.
828: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
823:
824: -- Standard Start of API savepoint
825: SAVEPOINT UPDATE_status_rule_line_PVT;
826:
827: -- Standard call to check for call compatibility.
828: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
829: p_api_version,
830: l_api_name,
831: G_PKG_NAME)
929: --
930: -- End of API body.
931: --
932:
933: -- Standard check for p_commit
934: IF FND_API.to_Boolean( p_commit )
935: THEN
936: COMMIT WORK;
937: END IF;
936: COMMIT WORK;
937: END IF;
938:
939:
940: -- Standard call to get message count and IF count is 1, get message info.
941: FND_MSG_PUB.Count_And_Get
942: ( p_count => x_msg_count,
943: p_data => x_msg_data );
944:
990: l_msg_data VARCHAR2(32767);
991: l_rowid Varchar2(50);
992:
993: BEGIN
994: -- Standard Start of API savepoint
995: SAVEPOINT DELETE_status_rule_line_PUB;
996:
997: -- Standard call to check for call compatibility.
998: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
993: BEGIN
994: -- Standard Start of API savepoint
995: SAVEPOINT DELETE_status_rule_line_PUB;
996:
997: -- Standard call to check for call compatibility.
998: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
999: p_api_version,
1000: l_api_name,
1001: G_PKG_NAME)
1045: --
1046: -- End of API body
1047: --
1048:
1049: -- Standard check for p_commit
1050: IF FND_API.to_Boolean( p_commit )
1051: THEN
1052: COMMIT WORK;
1053: END IF;