DBA Data[Home] [Help]

APPS.ASO_INSTDTLS_INT dependencies on STANDARD

Line 52: -- Standard Start of API savepoint

48:
49: /*
50: -- dbms_output.put_line('beginning of the interface API');
51:
52: -- Standard Start of API savepoint
53: SAVEPOINT Autocreate_systems_PUB;
54:
55: -- Standard call to check for call compatibility.
56: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

51:
52: -- Standard Start of API savepoint
53: SAVEPOINT Autocreate_systems_PUB;
54:
55: -- Standard call to check for call compatibility.
56: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
57: p_api_version_number,
58: l_api_name,
59: G_PKG_NAME)

Line 171: -- Standard check for p_commit

167: --
168: -- End of API body.
169: --
170:
171: -- Standard check for p_commit
172: IF FND_API.to_Boolean( p_commit )
173: THEN
174: COMMIT WORK;
175: END IF;

Line 182: -- Standard call to get message count and if count is 1, get message info.

178: -- Debug Message
179: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');
180:
181:
182: -- Standard call to get message count and if count is 1, get message info.
183: FND_MSG_PUB.Count_And_Get
184: ( p_count => x_msg_count,
185: p_data => x_msg_data
186: );

Line 530: -- Standard Start of API savepoint

526: i NUMBER;
527: p_cascade_line_tbl Cascade_Line_Tbl_Type; */
528: BEGIN
529: /*
530: -- Standard Start of API savepoint
531: SAVEPOINT CASCADE_DETAILS_YN_PUB;
532:
533: -- Standard call to check for call compatibility.
534: IF NOT FND_API.Compatible_API_Call ( l_api_version,

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

529: /*
530: -- Standard Start of API savepoint
531: SAVEPOINT CASCADE_DETAILS_YN_PUB;
532:
533: -- Standard call to check for call compatibility.
534: IF NOT FND_API.Compatible_API_Call ( l_api_version,
535: p_api_version,
536: l_api_name,
537: G_PKG_NAME)

Line 640: -- Standard check for p_commit

636: --
637: -- End of API body.
638: --
639:
640: -- Standard check for p_commit
641: IF FND_API.to_Boolean( p_commit )
642: THEN
643: COMMIT WORK;
644: END IF;

Line 651: -- Standard call to get message count and if count is 1, get message info.

647: -- Debug Message
648: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');
649:
650:
651: -- Standard call to get message count and if count is 1, get message info.
652: FND_MSG_PUB.Count_And_Get
653: ( p_count => x_msg_count,
654: p_data => x_msg_data
655: );

Line 844: -- Standard IN Parameters:

840: -- Type : Public
841: -- Pre-Req :
842: -- Parameters:
843: --
844: -- Standard IN Parameters:
845: -- p_api_version IN NUMBER Required
846: -- p_init_msg_list IN VARCHAR2 Optional
847: -- := FND_API.G_FALSE
848: --

Line 849: -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:

845: -- p_api_version IN NUMBER Required
846: -- p_init_msg_list IN VARCHAR2 Optional
847: -- := FND_API.G_FALSE
848: --
849: -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:
850: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
851: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
852: -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2(2000)
853: --

Line 900: -- Standard Start of API savepoint

896: my_message VARCHAR2(2000);
897: */
898: BEGIN
899: /*
900: -- Standard Start of API savepoint
901: SAVEPOINT CREATE_installation_detail_PUB;
902:
903: -- Standard call to check for call compatibility.
904: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

899: /*
900: -- Standard Start of API savepoint
901: SAVEPOINT CREATE_installation_detail_PUB;
902:
903: -- Standard call to check for call compatibility.
904: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
905: p_api_version_number,
906: l_api_name,
907: G_PKG_NAME)

Line 1038: -- Standard check for p_commit

1034: --
1035: -- End of API body.
1036: --
1037:
1038: -- Standard check for p_commit
1039: IF FND_API.to_Boolean( p_commit )
1040: THEN
1041: COMMIT WORK;
1042: END IF;

Line 1049: -- Standard call to get message count and if count is 1, get message info.

1045: -- Debug Message
1046: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');
1047:
1048:
1049: -- Standard call to get message count and if count is 1, get message info.
1050: FND_MSG_PUB.Count_And_Get
1051: ( p_count => x_msg_count,
1052: p_data => x_msg_data
1053: );

Line 1103: -- Standard IN Parameters:

1099: -- Type : Public
1100: -- Function : This API is used to update Installation details records.
1101: -- Pre-reqs : None.
1102: --
1103: -- Standard IN Parameters:
1104: -- p_api_version IN NUMBER Required
1105: -- p_init_msg_list IN VARCHAR2 Optional
1106: -- Default = FND_API.G_FALSE
1107: --

Line 1108: -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:

1104: -- p_api_version IN NUMBER Required
1105: -- p_init_msg_list IN VARCHAR2 Optional
1106: -- Default = FND_API.G_FALSE
1107: --
1108: -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:
1109: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
1110: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1111: -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2(2000)
1112: --

Line 1153: -- Standard Start of API savepoint

1149: l_old_quantity NUMBER := 1;
1150: l_p_contact_tbl contact_tbl_type; */
1151: BEGIN
1152: /*
1153: -- Standard Start of API savepoint
1154: SAVEPOINT Update_Installation_detail_PUB;
1155:
1156: -- Standard call to check for call compatibility.
1157: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

1152: /*
1153: -- Standard Start of API savepoint
1154: SAVEPOINT Update_Installation_detail_PUB;
1155:
1156: -- Standard call to check for call compatibility.
1157: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1158: p_api_version_number,
1159: l_api_name,
1160: G_PKG_NAME)

Line 1305: -- Standard check for p_commit

1301: --
1302: -- End of API body.
1303: --
1304:
1305: -- Standard check for p_commit
1306: IF FND_API.to_Boolean( p_commit )
1307: THEN
1308: COMMIT WORK;
1309: END IF;

Line 1316: -- Standard call to get message count and if count is 1, get message info.

1312: -- Debug Message
1313: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');
1314:
1315:
1316: -- Standard call to get message count and if count is 1, get message info.
1317: FND_MSG_PUB.Count_And_Get
1318: ( p_count => x_msg_count,
1319: p_data => x_msg_data
1320: );

Line 1374: -- Standard IN Parameters:

1370: -- Type : Public
1371: -- Function : This API is used to delete Installation details records.
1372: -- Pre-reqs : None.
1373: --
1374: -- Standard IN Parameters:
1375: -- p_api_version IN NUMBER Required
1376: -- p_init_msg_list IN VARCHAR2 Optional
1377: -- Default = FND_API.G_FALSE
1378: --

Line 1379: -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:

1375: -- p_api_version IN NUMBER Required
1376: -- p_init_msg_list IN VARCHAR2 Optional
1377: -- Default = FND_API.G_FALSE
1378: --
1379: -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:
1380: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
1381: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1382: -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2(2000)
1383: --

Line 1421: -- Standard Start of API savepoint

1417: j NUMBER := 1;
1418: */
1419: BEGIN
1420: /*
1421: -- Standard Start of API savepoint
1422: SAVEPOINT Delete_Installation_detail_PUB;
1423:
1424: -- Standard call to check for call compatibility.
1425: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

1420: /*
1421: -- Standard Start of API savepoint
1422: SAVEPOINT Delete_Installation_detail_PUB;
1423:
1424: -- Standard call to check for call compatibility.
1425: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1426: p_api_version_number,
1427: l_api_name,
1428: G_PKG_NAME)

Line 1504: -- Standard check for p_commit

1500: --
1501: -- End of API body.
1502: --
1503:
1504: -- Standard check for p_commit
1505: IF FND_API.to_Boolean( p_commit )
1506: THEN
1507: COMMIT WORK;
1508: END IF;

Line 1515: -- Standard call to get message count and if count is 1, get message info.

1511: -- Debug Message
1512: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');
1513:
1514:
1515: -- Standard call to get message count and if count is 1, get message info.
1516: FND_MSG_PUB.Count_And_Get
1517: ( p_count => x_msg_count,
1518: p_data => x_msg_data
1519: );

Line 1594: -- Standard Start of API savepoint

1590: */
1591:
1592: BEGIN
1593: /*
1594: -- Standard Start of API savepoint
1595: SAVEPOINT Update_Inst_details_ORder_PUB;
1596:
1597: -- Standard call to check for call compatibility.
1598: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

1593: /*
1594: -- Standard Start of API savepoint
1595: SAVEPOINT Update_Inst_details_ORder_PUB;
1596:
1597: -- Standard call to check for call compatibility.
1598: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1599: p_api_version_number,
1600: l_api_name,
1601: G_PKG_NAME)

Line 1640: -- Standard check for p_commit

1636: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1637: RAISE FND_API.G_EXC_ERROR;
1638: END IF;
1639:
1640: -- Standard check for p_commit
1641: IF FND_API.to_Boolean( p_commit )
1642: THEN
1643: COMMIT WORK;
1644: END IF;

Line 1651: -- Standard call to get message count and if count is 1, get message info.

1647: -- Debug Message
1648: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');
1649:
1650:
1651: -- Standard call to get message count and if count is 1, get message info.
1652: FND_MSG_PUB.Count_And_Get
1653: ( p_count => x_msg_count,
1654: p_data => x_msg_data
1655: );