48: l_api_version CONSTANT NUMBER := 1.0;
49: l_server_id NUMBER;
50: request_id NUMBER;
51: BEGIN
52: -- Standard Start of API savepoint
53:
54: -- Standard call to check for call compatibility.
55: IF NOT FND_API.Compatible_API_Call
56: (
50: request_id NUMBER;
51: BEGIN
52: -- Standard Start of API savepoint
53:
54: -- Standard call to check for call compatibility.
55: IF NOT FND_API.Compatible_API_Call
56: (
57: l_api_version,
58: p_api_version,
111: );
112:
113: -- End of API body.
114:
115: -- Standard check of p_commit.
116: IF FND_API.To_Boolean( p_commit ) THEN
117: COMMIT WORK;
118: END IF;
119: -- Standard call to get message count and if count is 1, get message info.
115: -- Standard check of p_commit.
116: IF FND_API.To_Boolean( p_commit ) THEN
117: COMMIT WORK;
118: END IF;
119: -- Standard call to get message count and if count is 1, get message info.
120: FND_MSG_PUB.Count_And_Get
121: (
122: p_count => x_msg_count,
123: p_data => x_msg_data
157: l_api_name CONSTANT VARCHAR2(30) := 'EXECUTE_ICSM_CMD';
158: l_api_version CONSTANT NUMBER := 1.0;
159: request_id NUMBER;
160: BEGIN
161: -- Standard Start of API savepoint
162:
163: -- Standard call to check for call compatibility.
164: IF NOT FND_API.Compatible_API_Call
165: (
159: request_id NUMBER;
160: BEGIN
161: -- Standard Start of API savepoint
162:
163: -- Standard call to check for call compatibility.
164: IF NOT FND_API.Compatible_API_Call
165: (
166: l_api_version,
167: p_api_version,
218: );
219:
220: -- End of API body.
221:
222: -- Standard check of p_commit.
223: IF FND_API.To_Boolean( p_commit ) THEN
224: COMMIT WORK;
225: END IF;
226: -- Standard call to get message count and if count is 1, get message info.
222: -- Standard check of p_commit.
223: IF FND_API.To_Boolean( p_commit ) THEN
224: COMMIT WORK;
225: END IF;
226: -- Standard call to get message count and if count is 1, get message info.
227: FND_MSG_PUB.Count_And_Get
228: (
229: p_count => x_msg_count,
230: p_data => x_msg_data
265: l_api_version CONSTANT NUMBER := 1.0;
266: xml_data VARCHAR2(2048);
267: request_id NUMBER;
268: BEGIN
269: -- Standard Start of API savepoint
270:
271: -- Standard call to check for call compatibility.
272: IF NOT FND_API.Compatible_API_Call
273: (
267: request_id NUMBER;
268: BEGIN
269: -- Standard Start of API savepoint
270:
271: -- Standard call to check for call compatibility.
272: IF NOT FND_API.Compatible_API_Call
273: (
274: l_api_version,
275: p_api_version,
328: );
329:
330: -- End of API body.
331:
332: -- Standard check of p_commit.
333: IF FND_API.To_Boolean( p_commit ) THEN
334: COMMIT WORK;
335: END IF;
336: -- Standard call to get message count and if count is 1, get message info.
332: -- Standard check of p_commit.
333: IF FND_API.To_Boolean( p_commit ) THEN
334: COMMIT WORK;
335: END IF;
336: -- Standard call to get message count and if count is 1, get message info.
337: FND_MSG_PUB.Count_And_Get
338: (
339: p_count => x_msg_count,
340: p_data => x_msg_data
393: l_api_version CONSTANT NUMBER := 1.0;
394: xml_data VARCHAR2(2048);
395: request_id NUMBER;
396: BEGIN
397: -- Standard Start of API savepoint
398:
399: -- Standard call to check for call compatibility.
400: IF NOT FND_API.Compatible_API_Call
401: (
395: request_id NUMBER;
396: BEGIN
397: -- Standard Start of API savepoint
398:
399: -- Standard call to check for call compatibility.
400: IF NOT FND_API.Compatible_API_Call
401: (
402: l_api_version,
403: p_api_version,
455:
456: -- get the return data for response
457: x_xml_data := xml_data;
458:
459: -- Standard check of p_commit.
460: IF FND_API.To_Boolean( p_commit ) THEN
461: COMMIT WORK;
462: END IF;
463: -- Standard call to get message count and if count is 1, get message info.
459: -- Standard check of p_commit.
460: IF FND_API.To_Boolean( p_commit ) THEN
461: COMMIT WORK;
462: END IF;
463: -- Standard call to get message count and if count is 1, get message info.
464: FND_MSG_PUB.Count_And_Get
465: (
466: p_count => x_msg_count,
467: p_data => x_msg_data
502: l_api_version CONSTANT NUMBER := 1.0;
503: xml_data VARCHAR2(2048);
504: request_id NUMBER;
505: BEGIN
506: -- Standard Start of API savepoint
507:
508: -- Standard call to check for call compatibility.
509: IF NOT FND_API.Compatible_API_Call
510: (
504: request_id NUMBER;
505: BEGIN
506: -- Standard Start of API savepoint
507:
508: -- Standard call to check for call compatibility.
509: IF NOT FND_API.Compatible_API_Call
510: (
511: l_api_version,
512: p_api_version,
561: );
562:
563: -- End of API body.
564:
565: -- Standard check of p_commit.
566: IF FND_API.To_Boolean( p_commit ) THEN
567: COMMIT WORK;
568: END IF;
569: -- Standard call to get message count and if count is 1, get message info.
565: -- Standard check of p_commit.
566: IF FND_API.To_Boolean( p_commit ) THEN
567: COMMIT WORK;
568: END IF;
569: -- Standard call to get message count and if count is 1, get message info.
570: FND_MSG_PUB.Count_And_Get
571: (
572: p_count => x_msg_count,
573: p_data => x_msg_data
609: l_api_version CONSTANT NUMBER := 1.0;
610: xml_data VARCHAR2(2048);
611: request_id NUMBER;
612: BEGIN
613: -- Standard Start of API savepoint
614:
615: -- Standard call to check for call compatibility.
616: IF NOT FND_API.Compatible_API_Call
617: (
611: request_id NUMBER;
612: BEGIN
613: -- Standard Start of API savepoint
614:
615: -- Standard call to check for call compatibility.
616: IF NOT FND_API.Compatible_API_Call
617: (
618: l_api_version,
619: p_api_version,
668: );
669:
670: -- End of API body.
671:
672: -- Standard check of p_commit.
673: IF FND_API.To_Boolean( p_commit ) THEN
674: COMMIT WORK;
675: END IF;
676: -- Standard call to get message count and if count is 1, get message info.
672: -- Standard check of p_commit.
673: IF FND_API.To_Boolean( p_commit ) THEN
674: COMMIT WORK;
675: END IF;
676: -- Standard call to get message count and if count is 1, get message info.
677: FND_MSG_PUB.Count_And_Get
678: (
679: p_count => x_msg_count,
680: p_data => x_msg_data
716: l_api_version CONSTANT NUMBER := 1.0;
717: xml_data VARCHAR2(2048);
718: request_id NUMBER;
719: BEGIN
720: -- Standard Start of API savepoint
721:
722: -- Standard call to check for call compatibility.
723: IF NOT FND_API.Compatible_API_Call
724: (
718: request_id NUMBER;
719: BEGIN
720: -- Standard Start of API savepoint
721:
722: -- Standard call to check for call compatibility.
723: IF NOT FND_API.Compatible_API_Call
724: (
725: l_api_version,
726: p_api_version,
775: );
776:
777: -- End of API body.
778:
779: -- Standard check of p_commit.
780: IF FND_API.To_Boolean( p_commit ) THEN
781: COMMIT WORK;
782: END IF;
783: -- Standard call to get message count and if count is 1, get message info.
779: -- Standard check of p_commit.
780: IF FND_API.To_Boolean( p_commit ) THEN
781: COMMIT WORK;
782: END IF;
783: -- Standard call to get message count and if count is 1, get message info.
784: FND_MSG_PUB.Count_And_Get
785: (
786: p_count => x_msg_count,
787: p_data => x_msg_data
822: l_api_version CONSTANT NUMBER := 1.0;
823: xml_data VARCHAR2(2048);
824: request_id NUMBER;
825: BEGIN
826: -- Standard Start of API savepoint
827:
828: -- Standard call to check for call compatibility.
829: IF NOT FND_API.Compatible_API_Call
830: (
824: request_id NUMBER;
825: BEGIN
826: -- Standard Start of API savepoint
827:
828: -- Standard call to check for call compatibility.
829: IF NOT FND_API.Compatible_API_Call
830: (
831: l_api_version,
832: p_api_version,
881: );
882:
883: -- End of API body.
884:
885: -- Standard check of p_commit.
886: IF FND_API.To_Boolean( p_commit ) THEN
887: COMMIT WORK;
888: END IF;
889: -- Standard call to get message count and if count is 1, get message info.
885: -- Standard check of p_commit.
886: IF FND_API.To_Boolean( p_commit ) THEN
887: COMMIT WORK;
888: END IF;
889: -- Standard call to get message count and if count is 1, get message info.
890: FND_MSG_PUB.Count_And_Get
891: (
892: p_count => x_msg_count,
893: p_data => x_msg_data
931: l_api_version CONSTANT NUMBER := 1.0;
932: xml_data VARCHAR2(2048);
933: request_id NUMBER;
934: BEGIN
935: -- Standard Start of API savepoint
936:
937: -- Standard call to check for call compatibility.
938: IF NOT FND_API.Compatible_API_Call
939: (
933: request_id NUMBER;
934: BEGIN
935: -- Standard Start of API savepoint
936:
937: -- Standard call to check for call compatibility.
938: IF NOT FND_API.Compatible_API_Call
939: (
940: l_api_version,
941: p_api_version,
990: );
991:
992: -- End of API body.
993:
994: -- Standard check of p_commit.
995: IF FND_API.To_Boolean( p_commit ) THEN
996: COMMIT WORK;
997: END IF;
998: -- Standard call to get message count and if count is 1, get message info.
994: -- Standard check of p_commit.
995: IF FND_API.To_Boolean( p_commit ) THEN
996: COMMIT WORK;
997: END IF;
998: -- Standard call to get message count and if count is 1, get message info.
999: FND_MSG_PUB.Count_And_Get
1000: (
1001: p_count => x_msg_count,
1002: p_data => x_msg_data
1038: l_api_version CONSTANT NUMBER := 1.0;
1039: xml_data VARCHAR2(2048);
1040: request_id NUMBER;
1041: BEGIN
1042: -- Standard Start of API savepoint
1043:
1044: -- Standard call to check for call compatibility.
1045: IF NOT FND_API.Compatible_API_Call
1046: (
1040: request_id NUMBER;
1041: BEGIN
1042: -- Standard Start of API savepoint
1043:
1044: -- Standard call to check for call compatibility.
1045: IF NOT FND_API.Compatible_API_Call
1046: (
1047: l_api_version,
1048: p_api_version,
1097: );
1098:
1099: -- End of API body.
1100:
1101: -- Standard check of p_commit.
1102: IF FND_API.To_Boolean( p_commit ) THEN
1103: COMMIT WORK;
1104: END IF;
1105: -- Standard call to get message count and if count is 1, get message info.
1101: -- Standard check of p_commit.
1102: IF FND_API.To_Boolean( p_commit ) THEN
1103: COMMIT WORK;
1104: END IF;
1105: -- Standard call to get message count and if count is 1, get message info.
1106: FND_MSG_PUB.Count_And_Get
1107: (
1108: p_count => x_msg_count,
1109: p_data => x_msg_data