DBA Data[Home] [Help]

APPS.AHL_MC_ITEM_COMP_PVT dependencies on STANDARD

Line 360: -- Standard IN Parameters :

356: -- Function : Creates Item Composition for Trackable Items in ahl_item_compositions.
357: -- Also creates item-group and Non-Trackable Item association in ahl_comp_details table.
358: -- Pre-reqs :
359: -- Parameters :
360: -- Standard IN Parameters :
361: -- p_api_version IN NUMBER Required
362: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
363: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
364: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 366: -- Standard OUT Parameters :

362: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
363: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
364: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
365: --
366: -- Standard OUT Parameters :
367: -- x_return_status OUT VARCHAR2 Required
368: -- x_msg_count OUT NUMBER Required
369: -- x_msg_data OUT VARCHAR2 Required
370: -- Item Header Composition Record :

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

414:
415: SAVEPOINT Create_Item_Composition;
416:
417:
418: -- Standard call to check for call compatibility.
419:
420: IF FND_API.to_boolean(p_init_msg_list) THEN
421: FND_MSG_PUB.initialize;
422: END IF;

Line 626: -- Standard IN Parameters :

622: -- Function : Modifies Item Composition for Trackable Items in ahl_item_compositions.
623: -- Also creates,modifies item-group and Non-Trackable Item association in ahl_comp_details table.
624: -- Pre-reqs :
625: -- Parameters :
626: -- Standard IN Parameters :
627: -- p_api_version IN NUMBER Required
628: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
629: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
630: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 632: -- Standard OUT Parameters :

628: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
629: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
630: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
631: --
632: -- Standard OUT Parameters :
633: -- x_return_status OUT VARCHAR2 Required
634: -- x_msg_count OUT NUMBER Required
635: -- x_msg_data OUT VARCHAR2 Required
636: -- Item Header Composition Record :

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

707:
708: SAVEPOINT Modify_Item_Composition;
709:
710:
711: -- Standard call to check for call compatibility.
712:
713: IF FND_API.to_boolean(p_init_msg_list) THEN
714: FND_MSG_PUB.initialize;
715: END IF;

Line 901: -- Standard IN Parameters :

897: -- Also deletes association in ahl_comp_details table.
898: -- Incase of Complete status Item Composition it Expires it.
899: -- Pre-reqs :
900: -- Parameters :
901: -- Standard IN Parameters :
902: -- p_api_version IN NUMBER Required
903: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
904: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
905: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 907: -- Standard OUT Parameters :

903: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
904: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
905: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
906: --
907: -- Standard OUT Parameters :
908: -- x_return_status OUT VARCHAR2 Required
909: -- x_msg_count OUT NUMBER Required
910: -- x_msg_data OUT VARCHAR2 Required
911: -- Item Header Composition Record :

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

992:
993: SAVEPOINT Delete_Item_Composition;
994:
995:
996: -- Standard call to check for call compatibility.
997:
998: IF FND_API.to_boolean(p_init_msg_list) THEN
999: FND_MSG_PUB.initialize;
1000: END IF;

Line 1169: -- Standard IN Parameters :

1165: -- Function : Re-Open'ss Item Composition for Trackable Items in ahl_item_compositions.
1166: --
1167: -- Pre-reqs :
1168: -- Parameters :
1169: -- Standard IN Parameters :
1170: -- p_api_version IN NUMBER Required
1171: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1172: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1173: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 1175: -- Standard OUT Parameters :

1171: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1172: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1173: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1174: --
1175: -- Standard OUT Parameters :
1176: -- x_return_status OUT VARCHAR2 Required
1177: -- x_msg_count OUT NUMBER Required
1178: -- x_msg_data OUT VARCHAR2 Required
1179: -- Item Header Composition Record :

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

1252:
1253: SAVEPOINT Reopen_Item_Composition;
1254:
1255:
1256: -- Standard call to check for call compatibility.
1257:
1258: IF FND_API.to_boolean(p_init_msg_list) THEN
1259: FND_MSG_PUB.initialize;
1260: END IF;

Line 1331: -- Standard check of p_commit

1327: WHERE ITEM_COMPOSITION_ID = p_item_composition_ID
1328: AND OBJECT_VERSION_NUMBER = p_object_version_number;
1329:
1330:
1331: -- Standard check of p_commit
1332: IF FND_API.TO_BOOLEAN(p_commit) THEN
1333: COMMIT WORK;
1334: END IF;
1335:

Line 1561: -- Standard IN Parameters :

1557: -- Function : Intiates Approval Process for Item groups
1558: --
1559: -- Pre-reqs :
1560: -- Parameters :
1561: -- Standard IN Parameters :
1562: -- p_api_version IN NUMBER Required
1563: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1564: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1565: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 1567: -- Standard OUT Parameters :

1563: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1564: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1565: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1566: --
1567: -- Standard OUT Parameters :
1568: -- x_return_status OUT VARCHAR2 Required
1569: -- x_msg_count OUT NUMBER Required
1570: -- x_msg_data OUT VARCHAR2 Required
1571: --

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

1636:
1637: BEGIN
1638: SAVEPOINT Initiate_Item_Comp_Approval;
1639:
1640: -- Standard call to check for call compatibility.
1641:
1642: IF FND_API.to_boolean(l_init_msg_list) THEN
1643: FND_MSG_PUB.initialize;
1644: END IF;

Line 1802: -- Standard check of p_commit

1798: RAISE FND_API.G_EXC_ERROR;
1799: END IF;
1800:
1801:
1802: -- Standard check of p_commit
1803: IF FND_API.TO_BOOLEAN(p_commit) THEN
1804: COMMIT WORK;
1805: END IF;
1806:

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

1803: IF FND_API.TO_BOOLEAN(p_commit) THEN
1804: COMMIT WORK;
1805: END IF;
1806:
1807: -- Standard call to get message count and if count is 1, get message info
1808: FND_MSG_PUB.Count_And_Get
1809: ( p_count => x_msg_count,
1810: p_data => x_msg_data,
1811: p_encoded => fnd_api.g_false);

Line 1881: -- Standard IN Parameters :

1877: -- Function : To create a New Revision of Item group
1878: --
1879: -- Pre-reqs :
1880: -- Parameters :
1881: -- Standard IN Parameters :
1882: -- p_api_version IN NUMBER Required
1883: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1884: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1885: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 1887: -- Standard OUT Parameters :

1883: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1884: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1885: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1886: --
1887: -- Standard OUT Parameters :
1888: -- x_return_status OUT VARCHAR2 Required
1889: -- x_msg_count OUT NUMBER Required
1890: -- x_msg_data OUT VARCHAR2 Required
1891:

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

1946:
1947:
1948: SAVEPOINT Create_Item_Comp_Revision;
1949:
1950: -- Standard call to check for call compatibility.
1951:
1952: IF FND_API.to_boolean(l_init_msg_list) THEN
1953: FND_MSG_PUB.initialize;
1954: END IF;

Line 2189: -- Standard check of p_commit

2185: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2186: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Comp_Revision', 'End of Loop');
2187: END IF;
2188:
2189: -- Standard check of p_commit
2190: IF FND_API.TO_BOOLEAN(p_commit) THEN
2191: COMMIT WORK;
2192: END IF;
2193:

Line 2263: -- Standard IN Parameters :

2259: -- Version : Added for 115.10
2260: --
2261: -- Pre-reqs :
2262: -- Parameters :
2263: -- Standard IN Parameters :
2264: -- p_api_version IN NUMBER Required
2265: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2266: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2267: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 2269: -- Standard OUT Parameters :

2265: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2266: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2267: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2268: --
2269: -- Standard OUT Parameters :
2270: -- x_return_status OUT VARCHAR2 Required
2271: -- x_msg_count OUT NUMBER Required
2272: -- x_msg_data OUT VARCHAR2 Required
2273:

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

2331:
2332: SAVEPOINT Approve_Item_Composiiton;
2333:
2334:
2335: -- Standard call to check for call compatibility.
2336:
2337: IF FND_API.to_boolean(l_init_msg_list) THEN
2338: FND_MSG_PUB.initialize;
2339: END IF;