DBA Data[Home] [Help]

APPS.AMS_ACTPRODUCT_PVT dependencies on STANDARD

Line 126: -- Standard Start of API savepoint

122: CURSOR C_act_product_id IS
123: SELECT ams_act_products_s.NEXTVAL
124: FROM dual;
125: BEGIN
126: -- Standard Start of API savepoint
127: SAVEPOINT Create_Act_Product_PVT;
128: -- Standard call to check for call compatibility.
129: IF NOT FND_API.Compatible_API_Call ( l_api_version,
130: p_api_version,

Line 128: -- Standard call to check for call compatibility.

124: FROM dual;
125: BEGIN
126: -- Standard Start of API savepoint
127: SAVEPOINT Create_Act_Product_PVT;
128: -- Standard call to check for call compatibility.
129: IF NOT FND_API.Compatible_API_Call ( l_api_version,
130: p_api_version,
131: l_api_name,
132: G_PACKAGE_NAME)

Line 254: -- standard who columns

250: adjustment_flag)
251: VALUES
252: (
253: l_act_Product_rec.activity_product_id,
254: -- standard who columns
255: sysdate,
256: FND_GLOBAL.User_Id,
257: sysdate,
258: FND_GLOBAL.User_Id,

Line 328: -- Standard check of p_commit.

324: */
325: --
326: -- END of API body.
327: --
328: -- Standard check of p_commit.
329: IF FND_API.To_Boolean ( p_commit )
330: THEN
331: COMMIT WORK;
332: END IF;

Line 333: -- Standard call to get message count AND IF count is 1, get message info.

329: IF FND_API.To_Boolean ( p_commit )
330: THEN
331: COMMIT WORK;
332: END IF;
333: -- Standard call to get message count AND IF count is 1, get message info.
334: FND_MSG_PUB.Count_AND_Get
335: ( p_count => x_msg_count,
336: p_data => x_msg_data,
337: p_encoded => FND_API.G_FALSE

Line 409: -- Standard Start of API savepoint

405: FROM ams_jtf_rs_emp_v
406: WHERE user_id = l_user_id;
407:
408: BEGIN
409: -- Standard Start of API savepoint
410: SAVEPOINT Update_Act_Product_PVT;
411: -- Standard call to check for call compatibility.
412: IF NOT FND_API.Compatible_API_Call ( l_api_version,
413: p_api_version,

Line 411: -- Standard call to check for call compatibility.

407:
408: BEGIN
409: -- Standard Start of API savepoint
410: SAVEPOINT Update_Act_Product_PVT;
411: -- Standard call to check for call compatibility.
412: IF NOT FND_API.Compatible_API_Call ( l_api_version,
413: p_api_version,
414: l_api_name,
415: G_PACKAGE_NAME)

Line 539: -- Standard check of p_commit.

535: END IF;
536: --
537: -- END of API body.
538: --
539: -- Standard check of p_commit.
540: IF FND_API.To_Boolean ( p_commit )
541: THEN
542: COMMIT WORK;
543: END IF;

Line 544: -- Standard call to get message count AND IF count is 1, get message info.

540: IF FND_API.To_Boolean ( p_commit )
541: THEN
542: COMMIT WORK;
543: END IF;
544: -- Standard call to get message count AND IF count is 1, get message info.
545: FND_MSG_PUB.Count_AND_Get
546: ( p_count => x_msg_count,
547: p_data => x_msg_data,
548: p_encoded => FND_API.G_FALSE

Line 641: -- Standard Start of API savepoint

637: FROM ams_act_products
638: WHERE activity_product_id = l_actprd_id;
639:
640: BEGIN
641: -- Standard Start of API savepoint
642: SAVEPOINT Delete_Act_Product_PVT;
643: -- Standard call to check for call compatibility.
644: IF NOT FND_API.Compatible_API_Call ( l_api_version,
645: p_api_version,

Line 643: -- Standard call to check for call compatibility.

639:
640: BEGIN
641: -- Standard Start of API savepoint
642: SAVEPOINT Delete_Act_Product_PVT;
643: -- Standard call to check for call compatibility.
644: IF NOT FND_API.Compatible_API_Call ( l_api_version,
645: p_api_version,
646: l_api_name,
647: G_PACKAGE_NAME)

Line 753: -- Standard check of p_commit.

749:
750: --
751: -- END of API body.
752: --
753: -- Standard check of p_commit.
754: IF FND_API.To_Boolean ( p_commit )
755: THEN
756: COMMIT WORK;
757: END IF;

Line 758: -- Standard call to get message count AND IF count is 1, get message info.

754: IF FND_API.To_Boolean ( p_commit )
755: THEN
756: COMMIT WORK;
757: END IF;
758: -- Standard call to get message count AND IF count is 1, get message info.
759: FND_MSG_PUB.Count_AND_Get
760: ( p_count => x_msg_count,
761: p_data => x_msg_data,
762: p_encoded => FND_API.G_FALSE

Line 834: -- Standard call to check for call compatibility.

830: WHERE activity_product_id = p_act_product_id
831: AND object_version_number = p_object_version
832: FOR UPDATE of activity_product_id NOWAIT;
833: BEGIN
834: -- Standard call to check for call compatibility.
835: IF NOT FND_API.Compatible_API_Call ( l_api_version,
836: p_api_version,
837: l_api_name,
838: G_PACKAGE_NAME)

Line 870: -- Standard call to get message count AND IF count is 1, get message info.

866: CLOSE c_act_product;
867: --
868: -- END of API body.
869: --
870: -- Standard call to get message count AND IF count is 1, get message info.
871: FND_MSG_PUB.Count_AND_Get
872: ( p_count => x_msg_count,
873: p_data => x_msg_data,
874: p_encoded => FND_API.G_FALSE

Line 947: -- Standard call to check for call compatibility.

943: l_act_Product_rec act_Product_rec_type := p_act_Product_rec;
944: l_default_act_product_rec act_Product_rec_type;
945: l_act_product_id NUMBER;
946: BEGIN
947: -- Standard call to check for call compatibility.
948: IF NOT FND_API.Compatible_API_Call ( l_api_version,
949: p_api_version,
950: l_api_name,
951: G_PACKAGE_NAME)

Line 1809: -- Standard call to check for call compatibility.

1805: WHERE qp_list_header_id = l_id;
1806: l_offer_type VARCHAR2(30);
1807:
1808: BEGIN
1809: -- Standard call to check for call compatibility.
1810: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1811: l_api_version,
1812: l_api_name,
1813: G_PACKAGE_NAME)