DBA Data[Home] [Help]

APPS.AHL_MC_ITEM_COMP_PVT dependencies on AHL_MC_ITEM_COMP_PVT

Line 1: PACKAGE BODY AHL_MC_ITEM_COMP_PVT AS

1: PACKAGE BODY AHL_MC_ITEM_COMP_PVT AS
2: /* $Header: AHLVICXB.pls 120.5.12020000.2 2012/12/10 13:40:38 shnatu ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ahl_mc_item_comp_pvt';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ahl_mc_item_comp_pvt';

1: PACKAGE BODY AHL_MC_ITEM_COMP_PVT AS
2: /* $Header: AHLVICXB.pls 120.5.12020000.2 2012/12/10 13:40:38 shnatu ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ahl_mc_item_comp_pvt';
5:
6: PROCEDURE Create_Line_Item (p_item_composition_id IN NUMBER,
7: p_x_comp_det_rec IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Detail_Rec_Type
8: );

Line 7: p_x_comp_det_rec IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Detail_Rec_Type

3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ahl_mc_item_comp_pvt';
5:
6: PROCEDURE Create_Line_Item (p_item_composition_id IN NUMBER,
7: p_x_comp_det_rec IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Detail_Rec_Type
8: );
9:
10: PROCEDURE Update_Line_Item (p_item_composition_id IN NUMBER,
11: p_x_comp_det_rec IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Detail_Rec_Type

Line 11: p_x_comp_det_rec IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Detail_Rec_Type

7: p_x_comp_det_rec IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Detail_Rec_Type
8: );
9:
10: PROCEDURE Update_Line_Item (p_item_composition_id IN NUMBER,
11: p_x_comp_det_rec IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Detail_Rec_Type
12: );
13:
14: PROCEDURE Delete_Line_Item (p_item_composition_id IN NUMBER,
15: p_x_comp_det_rec IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Detail_Rec_Type

Line 15: p_x_comp_det_rec IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Detail_Rec_Type

11: p_x_comp_det_rec IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Detail_Rec_Type
12: );
13:
14: PROCEDURE Delete_Line_Item (p_item_composition_id IN NUMBER,
15: p_x_comp_det_rec IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Detail_Rec_Type
16: );
17:
18: PROCEDURE Validate_InventoryID(p_inventory_item_id IN NUMBER,
19: p_inventory_org_id IN NUMBER,

Line 200: p_x_Detail_Rec_Type IN OUT NOCOPY ahl_mc_item_comp_pvt.Detail_Rec_Type

196:
197:
198: PROCEDURE Validate_Item_Comp_Det( p_item_composition_id IN NUMBER,
199: P_inv_item_name IN VARCHAR2,
200: p_x_Detail_Rec_Type IN OUT NOCOPY ahl_mc_item_comp_pvt.Detail_Rec_Type
201: )
202: AS
203:
204:

Line 247: l_Detail_Rec_Type ahl_mc_item_comp_pvt.Detail_Rec_Type DEFAULT p_x_Detail_Rec_Type;

243:
244:
245: l_dummy varchar2(1);
246:
247: l_Detail_Rec_Type ahl_mc_item_comp_pvt.Detail_Rec_Type DEFAULT p_x_Detail_Rec_Type;
248:
249: BEGIN
250:
251:

Line 403: p_x_ic_header_rec IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Header_Rec_Type,

399: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
400: x_return_status OUT NOCOPY VARCHAR2,
401: x_msg_count OUT NOCOPY NUMBER,
402: x_msg_data OUT NOCOPY VARCHAR2,
403: p_x_ic_header_rec IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Header_Rec_Type,
404: p_x_det_tbl IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Det_Tbl_Type
405: )
406:
407: AS

Line 404: p_x_det_tbl IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Det_Tbl_Type

400: x_return_status OUT NOCOPY VARCHAR2,
401: x_msg_count OUT NOCOPY NUMBER,
402: x_msg_data OUT NOCOPY VARCHAR2,
403: p_x_ic_header_rec IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Header_Rec_Type,
404: p_x_det_tbl IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Det_Tbl_Type
405: )
406:
407: AS
408:

Line 669: p_x_ic_header_rec IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Header_Rec_Type,

665: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
666: x_return_status OUT NOCOPY VARCHAR2,
667: x_msg_count OUT NOCOPY NUMBER,
668: x_msg_data OUT NOCOPY VARCHAR2,
669: p_x_ic_header_rec IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Header_Rec_Type,
670: p_x_det_tbl IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Det_Tbl_Type
671: )
672:
673: AS

Line 670: p_x_det_tbl IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Det_Tbl_Type

666: x_return_status OUT NOCOPY VARCHAR2,
667: x_msg_count OUT NOCOPY NUMBER,
668: x_msg_data OUT NOCOPY VARCHAR2,
669: p_x_ic_header_rec IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Header_Rec_Type,
670: p_x_det_tbl IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Det_Tbl_Type
671: )
672:
673: AS
674:

Line 1407: p_x_comp_det_rec IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Detail_Rec_Type

1403:
1404:
1405:
1406: PROCEDURE Create_Line_Item (p_item_composition_id IN NUMBER,
1407: p_x_comp_det_rec IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Detail_Rec_Type
1408: )
1409:
1410: AS
1411:

Line 1509: p_x_comp_det_rec IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Detail_Rec_Type

1505: END;
1506:
1507:
1508: PROCEDURE Update_Line_Item (p_item_composition_id IN NUMBER,
1509: p_x_comp_det_rec IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Detail_Rec_Type
1510: )
1511:
1512: AS
1513:

Line 1554: p_x_comp_det_rec IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Detail_Rec_Type

1550:
1551:
1552:
1553: PROCEDURE Delete_Line_Item (p_item_composition_id IN NUMBER,
1554: p_x_comp_det_rec IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Detail_Rec_Type
1555: )
1556:
1557: AS
1558:

Line 1790: ahl_mc_item_comp_pvt.approve_item_composiiton

1786: P_NOTES_FROM_REQUESTER =>NULL,
1787: P_WORKFLOWPROCESS =>'AHL_GEN_APPROVAL',
1788: P_ITEM_TYPE =>'AHLGAPP');
1789: ELSE
1790: ahl_mc_item_comp_pvt.approve_item_composiiton
1791: (
1792: p_api_version =>l_api_version,
1793: -- p_init_msg_list =>l_init_msg_list,
1794: -- p_commit =>l_commit,

Line 2718: End AHL_MC_ITEM_COMP_PVT;

2714: END Approve_Item_Composiiton;
2715:
2716:
2717:
2718: End AHL_MC_ITEM_COMP_PVT;