[Home] [Help]
23: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
24: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
25: -- P_Line_Rltship_Tbl IN Line_Rltship_Tbl_Type
26: -- Version : Current version 2.0
27: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
28: -- and basic operation, developer must manually add parameters and business logic as necessary.
29: --
30: -- End of Comments
31: --
42: IS
43: l_api_version_number NUMBER := 1.0;
44: l_api_name VARCHAR2(240) := 'CREATE_LINE_RELATIONSHIP';
45: BEGIN
46: -- Standard Start of API savepoint
47: SAVEPOINT CREATE_LINE_RELATIONSHIP_PUB;
48:
49: -- Standard call to check for call compatibility.
50: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
45: BEGIN
46: -- Standard Start of API savepoint
47: SAVEPOINT CREATE_LINE_RELATIONSHIP_PUB;
48:
49: -- Standard call to check for call compatibility.
50: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
51: p_api_version_number,
52: l_api_name,
53: G_PKG_NAME)
101: --
102: -- End of API body
103: --
104:
105: -- Standard check for p_commit
106: IF FND_API.to_Boolean( p_commit )
107: THEN
108: COMMIT WORK;
109: END IF;
108: COMMIT WORK;
109: END IF;
110:
111:
112: -- Standard call to get message count and if count is 1, get message info.
113: FND_MSG_PUB.Count_And_Get
114: ( p_count => x_msg_count,
115: p_data => x_msg_data
116: );
181: l_api_version_number NUMBER := 1.0;
182: l_api_name VARCHAR2(240) := 'UPDATE_LINE_RELATIONSHIP';
183: BEGIN
184:
185: -- Standard Start of API savepoint
186: SAVEPOINT UPDATE_LINE_RELATIONSHIP_PUB;
187:
188: -- Standard call to check for call compatibility.
189: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
184:
185: -- Standard Start of API savepoint
186: SAVEPOINT UPDATE_LINE_RELATIONSHIP_PUB;
187:
188: -- Standard call to check for call compatibility.
189: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
190: p_api_version_number,
191: l_api_name,
192: G_PKG_NAME)
238: --
239: -- End of API body
240: --
241:
242: -- Standard check for p_commit
243: IF FND_API.to_Boolean( p_commit )
244: THEN
245: COMMIT WORK;
246: END IF;
244: THEN
245: COMMIT WORK;
246: END IF;
247:
248: -- Standard call to get message count and if count is 1, get message info.
249: FND_MSG_PUB.Count_And_Get
250: ( p_count => x_msg_count,
251: p_data => x_msg_data
252: );
318: l_api_version_number NUMBER := 1.0;
319: l_api_name VARCHAR2(240) := 'DELETE_LINE_RELATIONSHIP';
320: BEGIN
321:
322: -- Standard Start of API savepoint
323: SAVEPOINT DELETE_LINE_RELATIONSHIP_PUB;
324:
325: -- Standard call to check for call compatibility.
326: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
321:
322: -- Standard Start of API savepoint
323: SAVEPOINT DELETE_LINE_RELATIONSHIP_PUB;
324:
325: -- Standard call to check for call compatibility.
326: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
327: p_api_version_number,
328: l_api_name,
329: G_PKG_NAME)
375: --
376: -- End of API body
377: --
378:
379: -- Standard check for p_commit
380: IF FND_API.to_Boolean( p_commit )
381: THEN
382: COMMIT WORK;
383: END IF;
382: COMMIT WORK;
383: END IF;
384:
385:
386: -- Standard call to get message count and if count is 1, get message info.
387: FND_MSG_PUB.Count_And_Get
388: ( p_count => x_msg_count,
389: p_data => x_msg_data
390: );
460: l_api_name VARCHAR2(240) := 'CREATE_HEADER_RELATIONSHIP';
461: BEGIN
462: null;
463:
464: -- Standard Start of API savepoint
465: SAVEPOINT CREATE_HEADER_RELATIONSHIP_PUB;
466:
467: -- Standard call to check for call compatibility.
468: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
463:
464: -- Standard Start of API savepoint
465: SAVEPOINT CREATE_HEADER_RELATIONSHIP_PUB;
466:
467: -- Standard call to check for call compatibility.
468: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
469: p_api_version_number,
470: l_api_name,
471: G_PKG_NAME)
516: --
517: -- End of API body
518: --
519:
520: -- Standard check for p_commit
521: IF FND_API.to_Boolean( p_commit )
522: THEN
523: COMMIT WORK;
524: END IF;
598: l_api_version_number NUMBER := 1.0;
599: l_api_name VARCHAR2(240) := 'UPDATE_HEADER_RELATIONSHIP';
600: BEGIN
601:
602: -- Standard Start of API savepoint
603: SAVEPOINT UPDATE_HEADER_RELATIONSHIP_PUB;
604:
605: -- Standard call to check for call compatibility.
606: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
601:
602: -- Standard Start of API savepoint
603: SAVEPOINT UPDATE_HEADER_RELATIONSHIP_PUB;
604:
605: -- Standard call to check for call compatibility.
606: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
607: p_api_version_number,
608: l_api_name,
609: G_PKG_NAME)
655: --
656: -- End of API body
657: --
658:
659: -- Standard check for p_commit
660: IF FND_API.to_Boolean( p_commit )
661: THEN
662: COMMIT WORK;
663: END IF;
663: END IF;
664:
665:
666:
667: -- Standard call to get message count and if count is 1, get message info.
668: FND_MSG_PUB.Count_And_Get
669: ( p_count => x_msg_count,
670: p_data => x_msg_data
671: );
741: l_api_name VARCHAR2(240) := 'DELETE_HEADER_RELATIONSHIP';
742:
743: BEGIN
744:
745: -- Standard Start of API savepoint
746: SAVEPOINT DELETE_HEADER_RELATIONSHIP_PUB;
747:
748: -- Standard call to check for call compatibility.
749: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
744:
745: -- Standard Start of API savepoint
746: SAVEPOINT DELETE_HEADER_RELATIONSHIP_PUB;
747:
748: -- Standard call to check for call compatibility.
749: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
750: p_api_version_number,
751: l_api_name,
752: G_PKG_NAME)
799: --
800: -- End of API body
801: --
802:
803: -- Standard check for p_commit
804: IF FND_API.to_Boolean( p_commit )
805: THEN
806: COMMIT WORK;
807: END IF;
806: COMMIT WORK;
807: END IF;
808:
809:
810: -- Standard call to get message count and if count is 1, get message info.
811: FND_MSG_PUB.Count_And_Get
812: ( p_count => x_msg_count,
813: p_data => x_msg_data
814: );
922: --
923: -- End of API body
924: --
925:
926: -- Standard check for p_commit
927: IF FND_API.to_Boolean( p_commit ) THEN
928: COMMIT WORK;
929: END IF;
930:
929: END IF;
930:
931:
932:
933: -- Standard call to get message count and if count is 1, get message info.
934: FND_MSG_PUB.Count_And_Get
935: ( p_count => x_msg_count,
936: p_data => x_msg_data
937: );
1002: l_api_version_number NUMBER := 1.0;
1003: l_api_name VARCHAR2(240) := 'UPDATE_PARTY_RELATIONSHIP';
1004: BEGIN
1005:
1006: -- Standard Start of API savepoint
1007: SAVEPOINT UPDATE_PARTY_RELATIONSHIP_PUB;
1008:
1009: IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number,l_api_name,G_PKG_NAME) THEN
1010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1047: --
1048: -- End of API body
1049: --
1050:
1051: -- Standard check for p_commit
1052: IF FND_API.to_Boolean( p_commit )
1053: THEN
1054: COMMIT WORK;
1055: END IF;
1058: -- Debug Message
1059: --AS_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
1060:
1061:
1062: -- Standard call to get message count and if count is 1, get message info.
1063: FND_MSG_PUB.Count_And_Get
1064: ( p_count => x_msg_count,
1065: p_data => x_msg_data
1066: );
1128: l_api_version_number NUMBER := 1.0;
1129: l_api_name VARCHAR2(240) := 'DELETE_PARTY_RELATIONSHIP';
1130: BEGIN
1131:
1132: -- Standard Start of API savepoint
1133: SAVEPOINT DELETE_PARTY_RELATIONSHIP_PUB;
1134:
1135: -- Standard call to check for call compatibility.
1136: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1131:
1132: -- Standard Start of API savepoint
1133: SAVEPOINT DELETE_PARTY_RELATIONSHIP_PUB;
1134:
1135: -- Standard call to check for call compatibility.
1136: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1137: p_api_version_number,
1138: l_api_name,
1139: G_PKG_NAME)
1180: --
1181: -- End of API body
1182: --
1183:
1184: -- Standard check for p_commit
1185: IF FND_API.to_Boolean( p_commit )
1186: THEN
1187: COMMIT WORK;
1188: END IF;
1189:
1190:
1191:
1192:
1193: -- Standard call to get message count and if count is 1, get message info.
1194: FND_MSG_PUB.Count_And_Get
1195: ( p_count => x_msg_count,
1196: p_data => x_msg_data
1197: );
1263: l_api_name VARCHAR2(240) := 'CREATE_OBJECT_RELATIONSHIP';
1264: BEGIN
1265:
1266:
1267: -- Standard Start of API savepoint
1268: SAVEPOINT CREATE_OBJECT_RELATIONSHIP_PUB;
1269:
1270: -- Standard call to check for call compatibility.
1271: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1266:
1267: -- Standard Start of API savepoint
1268: SAVEPOINT CREATE_OBJECT_RELATIONSHIP_PUB;
1269:
1270: -- Standard call to check for call compatibility.
1271: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1272: p_api_version_number,
1273: l_api_name,
1274: G_PKG_NAME)
1315:
1316:
1317: -- End of API body
1318:
1319: -- Standard check for p_commit
1320: IF FND_API.to_Boolean( p_commit )
1321: THEN
1322: COMMIT WORK;
1323: END IF;
1324:
1325:
1326:
1327:
1328: -- Standard call to get message count and if count is 1, get message info.
1329: FND_MSG_PUB.Count_And_Get
1330: ( p_count => x_msg_count,
1331: p_data => x_msg_data
1332: );
1407: l_api_name VARCHAR2(240) := 'UPDATE_OBJECT_RELATIONSHIP';
1408: BEGIN
1409:
1410:
1411: -- Standard Start of API savepoint
1412: SAVEPOINT UPDATE_OBJECT_RELATIONSHIP_PUB;
1413:
1414: -- Standard call to check for call compatibility.
1415: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1410:
1411: -- Standard Start of API savepoint
1412: SAVEPOINT UPDATE_OBJECT_RELATIONSHIP_PUB;
1413:
1414: -- Standard call to check for call compatibility.
1415: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1416: p_api_version_number,
1417: l_api_name,
1418: G_PKG_NAME)
1467: --
1468: -- End of API body
1469: --
1470:
1471: -- Standard check for p_commit
1472: IF FND_API.to_Boolean( p_commit )
1473: THEN
1474: COMMIT WORK;
1475: END IF;
1474: COMMIT WORK;
1475: END IF;
1476:
1477:
1478: -- Standard call to get message count and if count is 1, get message info.
1479: FND_MSG_PUB.Count_And_Get
1480: ( p_count => x_msg_count,
1481: p_data => x_msg_data
1482: );
1555: l_api_version_number NUMBER := 1.0;
1556: l_api_name VARCHAR2(240) := 'DELETE_OBJECT_RELATIONSHIP';
1557: BEGIN
1558:
1559: -- Standard Start of API savepoint
1560: SAVEPOINT DELETE_OBJECT_RELATIONSHIP_PUB;
1561:
1562: -- Standard call to check for call compatibility.
1563: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1558:
1559: -- Standard Start of API savepoint
1560: SAVEPOINT DELETE_OBJECT_RELATIONSHIP_PUB;
1561:
1562: -- Standard call to check for call compatibility.
1563: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1564: p_api_version_number,
1565: l_api_name,
1566: G_PKG_NAME)
1613: --
1614: -- End of API body
1615: --
1616:
1617: -- Standard check for p_commit
1618: IF FND_API.to_Boolean( p_commit )
1619: THEN
1620: COMMIT WORK;
1621: END IF;
1622:
1623:
1624:
1625:
1626: -- Standard call to get message count and if count is 1, get message info.
1627: FND_MSG_PUB.Count_And_Get
1628: ( p_count => x_msg_count,
1629: p_data => x_msg_data);
1630:
1697: IS
1698: l_api_version_number NUMBER := 1.0;
1699: l_api_name VARCHAR2(240) := 'CREATE_Price_Adj_RELATIONSHIP';
1700: BEGIN
1701: -- Standard Start of API savepoint
1702: SAVEPOINT CREATE_PRICE_ADJ_RLTSHIP_PUB;
1703:
1704: -- Standard call to check for call compatibility.
1705: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1700: BEGIN
1701: -- Standard Start of API savepoint
1702: SAVEPOINT CREATE_PRICE_ADJ_RLTSHIP_PUB;
1703:
1704: -- Standard call to check for call compatibility.
1705: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1706: p_api_version_number,
1707: l_api_name,
1708: G_PKG_NAME)
1754: --
1755: -- End of API body
1756: --
1757:
1758: -- Standard check for p_commit
1759: IF FND_API.to_Boolean( p_commit )
1760: THEN
1761: COMMIT WORK;
1762: END IF;
1761: COMMIT WORK;
1762: END IF;
1763:
1764:
1765: -- Standard call to get message count and if count is 1, get message info.
1766: FND_MSG_PUB.Count_And_Get
1767: ( p_count => x_msg_count,
1768: p_data => x_msg_data
1769: );
1831: IS
1832: l_api_version_number NUMBER := 1.0;
1833: l_api_name VARCHAR2(240) := 'UPDATE_Price_Adj_RELATIONSHIP';
1834: BEGIN
1835: -- Standard Start of API savepoint
1836: SAVEPOINT UPdate_PRICE_ADJ_RLTSHIP_PUB;
1837:
1838: -- Standard call to check for call compatibility.
1839: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1834: BEGIN
1835: -- Standard Start of API savepoint
1836: SAVEPOINT UPdate_PRICE_ADJ_RLTSHIP_PUB;
1837:
1838: -- Standard call to check for call compatibility.
1839: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1840: p_api_version_number,
1841: l_api_name,
1842: G_PKG_NAME)
1887: --
1888: -- End of API body
1889: --
1890:
1891: -- Standard check for p_commit
1892: IF FND_API.to_Boolean( p_commit )
1893: THEN
1894: COMMIT WORK;
1895: END IF;
1894: COMMIT WORK;
1895: END IF;
1896:
1897:
1898: -- Standard call to get message count and if count is 1, get message info.
1899: FND_MSG_PUB.Count_And_Get
1900: ( p_count => x_msg_count,
1901: p_data => x_msg_data
1902: );
1965: IS
1966: l_api_version_number NUMBER := 1.0;
1967: l_api_name VARCHAR2(240) := 'DELETE_Price_Adj_RELATIONSHIP';
1968: BEGIN
1969: -- Standard Start of API savepoint
1970: SAVEPOINT DELETE_PRICE_ADJ_RLTSHIP_PUB;
1971:
1972: -- Standard call to check for call compatibility.
1973: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1968: BEGIN
1969: -- Standard Start of API savepoint
1970: SAVEPOINT DELETE_PRICE_ADJ_RLTSHIP_PUB;
1971:
1972: -- Standard call to check for call compatibility.
1973: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1974: p_api_version_number,
1975: l_api_name,
1976: G_PKG_NAME)
2020: --
2021: -- End of API body
2022: --
2023:
2024: -- Standard check for p_commit
2025: IF FND_API.to_Boolean( p_commit )
2026: THEN
2027: COMMIT WORK;
2028: END IF;
2027: COMMIT WORK;
2028: END IF;
2029:
2030:
2031: -- Standard call to get message count and if count is 1, get message info.
2032: FND_MSG_PUB.Count_And_Get
2033: ( p_count => x_msg_count,
2034: p_data => x_msg_data
2035: );