DBA Data[Home] [Help]

APPS.AHL_MC_ITEM_COMP_PVT dependencies on STANDARD

Line 369: -- Standard IN Parameters :

365: -- Function : Creates Item Composition for Trackable Items in ahl_item_compositions.
366: -- Also creates item-group and Non-Trackable Item association in ahl_comp_details table.
367: -- Pre-reqs :
368: -- Parameters :
369: -- Standard IN Parameters :
370: -- p_api_version IN NUMBER Required
371: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
372: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
373: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 375: -- Standard OUT Parameters :

371: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
372: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
373: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
374: --
375: -- Standard OUT Parameters :
376: -- x_return_status OUT VARCHAR2 Required
377: -- x_msg_count OUT NUMBER Required
378: -- x_msg_data OUT VARCHAR2 Required
379: -- Item Header Composition Record :

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

423:
424: SAVEPOINT Create_Item_Composition;
425:
426:
427: -- Standard call to check for call compatibility.
428:
429: IF FND_API.to_boolean(p_init_msg_list) THEN
430: FND_MSG_PUB.initialize;
431: END IF;

Line 635: -- Standard IN Parameters :

631: -- Function : Modifies Item Composition for Trackable Items in ahl_item_compositions.
632: -- Also creates,modifies item-group and Non-Trackable Item association in ahl_comp_details table.
633: -- Pre-reqs :
634: -- Parameters :
635: -- Standard IN Parameters :
636: -- p_api_version IN NUMBER Required
637: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
638: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
639: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 641: -- Standard OUT Parameters :

637: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
638: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
639: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
640: --
641: -- Standard OUT Parameters :
642: -- x_return_status OUT VARCHAR2 Required
643: -- x_msg_count OUT NUMBER Required
644: -- x_msg_data OUT VARCHAR2 Required
645: -- Item Header Composition Record :

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

718:
719: SAVEPOINT Modify_Item_Composition;
720:
721:
722: -- Standard call to check for call compatibility.
723:
724: IF FND_API.to_boolean(p_init_msg_list) THEN
725: FND_MSG_PUB.initialize;
726: END IF;

Line 917: -- Standard IN Parameters :

913: -- Also deletes association in ahl_comp_details table.
914: -- Incase of Complete status Item Composition it Expires it.
915: -- Pre-reqs :
916: -- Parameters :
917: -- Standard IN Parameters :
918: -- p_api_version IN NUMBER Required
919: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
920: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
921: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 923: -- Standard OUT Parameters :

919: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
920: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
921: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
922: --
923: -- Standard OUT Parameters :
924: -- x_return_status OUT VARCHAR2 Required
925: -- x_msg_count OUT NUMBER Required
926: -- x_msg_data OUT VARCHAR2 Required
927: -- Item Header Composition Record :

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

1008:
1009: SAVEPOINT Delete_Item_Composition;
1010:
1011:
1012: -- Standard call to check for call compatibility.
1013:
1014: IF FND_API.to_boolean(p_init_msg_list) THEN
1015: FND_MSG_PUB.initialize;
1016: END IF;

Line 1185: -- Standard IN Parameters :

1181: -- Function : Re-Open'ss Item Composition for Trackable Items in ahl_item_compositions.
1182: --
1183: -- Pre-reqs :
1184: -- Parameters :
1185: -- Standard IN Parameters :
1186: -- p_api_version IN NUMBER Required
1187: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1188: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1189: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 1191: -- Standard OUT Parameters :

1187: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1188: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1189: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1190: --
1191: -- Standard OUT Parameters :
1192: -- x_return_status OUT VARCHAR2 Required
1193: -- x_msg_count OUT NUMBER Required
1194: -- x_msg_data OUT VARCHAR2 Required
1195: -- Item Header Composition Record :

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

1268:
1269: SAVEPOINT Reopen_Item_Composition;
1270:
1271:
1272: -- Standard call to check for call compatibility.
1273:
1274: IF FND_API.to_boolean(p_init_msg_list) THEN
1275: FND_MSG_PUB.initialize;
1276: END IF;

Line 1347: -- Standard check of p_commit

1343: WHERE ITEM_COMPOSITION_ID = p_item_composition_ID
1344: AND OBJECT_VERSION_NUMBER = p_object_version_number;
1345:
1346:
1347: -- Standard check of p_commit
1348: IF FND_API.TO_BOOLEAN(p_commit) THEN
1349: COMMIT WORK;
1350: END IF;
1351:

Line 1577: -- Standard IN Parameters :

1573: -- Function : Intiates Approval Process for Item groups
1574: --
1575: -- Pre-reqs :
1576: -- Parameters :
1577: -- Standard IN Parameters :
1578: -- p_api_version IN NUMBER Required
1579: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1580: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1581: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 1583: -- Standard OUT Parameters :

1579: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1580: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1581: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1582: --
1583: -- Standard OUT Parameters :
1584: -- x_return_status OUT VARCHAR2 Required
1585: -- x_msg_count OUT NUMBER Required
1586: -- x_msg_data OUT VARCHAR2 Required
1587: --

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

1652:
1653: BEGIN
1654: SAVEPOINT Initiate_Item_Comp_Approval;
1655:
1656: -- Standard call to check for call compatibility.
1657:
1658: IF FND_API.to_boolean(l_init_msg_list) THEN
1659: FND_MSG_PUB.initialize;
1660: END IF;

Line 1818: -- Standard check of p_commit

1814: RAISE FND_API.G_EXC_ERROR;
1815: END IF;
1816:
1817:
1818: -- Standard check of p_commit
1819: IF FND_API.TO_BOOLEAN(p_commit) THEN
1820: COMMIT WORK;
1821: END IF;
1822:

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

1819: IF FND_API.TO_BOOLEAN(p_commit) THEN
1820: COMMIT WORK;
1821: END IF;
1822:
1823: -- Standard call to get message count and if count is 1, get message info
1824: FND_MSG_PUB.Count_And_Get
1825: ( p_count => x_msg_count,
1826: p_data => x_msg_data,
1827: p_encoded => fnd_api.g_false);

Line 1897: -- Standard IN Parameters :

1893: -- Function : To create a New Revision of Item group
1894: --
1895: -- Pre-reqs :
1896: -- Parameters :
1897: -- Standard IN Parameters :
1898: -- p_api_version IN NUMBER Required
1899: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1900: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1901: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 1903: -- Standard OUT Parameters :

1899: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1900: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1901: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1902: --
1903: -- Standard OUT Parameters :
1904: -- x_return_status OUT VARCHAR2 Required
1905: -- x_msg_count OUT NUMBER Required
1906: -- x_msg_data OUT VARCHAR2 Required
1907:

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

1962:
1963:
1964: SAVEPOINT Create_Item_Comp_Revision;
1965:
1966: -- Standard call to check for call compatibility.
1967:
1968: IF FND_API.to_boolean(l_init_msg_list) THEN
1969: FND_MSG_PUB.initialize;
1970: END IF;

Line 2205: -- Standard check of p_commit

2201: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2202: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Comp_Revision', 'End of Loop');
2203: END IF;
2204:
2205: -- Standard check of p_commit
2206: IF FND_API.TO_BOOLEAN(p_commit) THEN
2207: COMMIT WORK;
2208: END IF;
2209:

Line 2279: -- Standard IN Parameters :

2275: -- Version : Added for 115.10
2276: --
2277: -- Pre-reqs :
2278: -- Parameters :
2279: -- Standard IN Parameters :
2280: -- p_api_version IN NUMBER Required
2281: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2282: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2283: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 2285: -- Standard OUT Parameters :

2281: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2282: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2283: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2284: --
2285: -- Standard OUT Parameters :
2286: -- x_return_status OUT VARCHAR2 Required
2287: -- x_msg_count OUT NUMBER Required
2288: -- x_msg_data OUT VARCHAR2 Required
2289:

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

2388:
2389: SAVEPOINT Approve_Item_Composiiton;
2390:
2391:
2392: -- Standard call to check for call compatibility.
2393:
2394: IF FND_API.to_boolean(l_init_msg_list) THEN
2395: FND_MSG_PUB.initialize;
2396: END IF;