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.1 2006/01/10 03:41:28 sagarwal noship $ */
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.1 2006/01/10 03:41:28 sagarwal noship $ */
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 195: p_x_Detail_Rec_Type IN OUT NOCOPY ahl_mc_item_comp_pvt.Detail_Rec_Type

191:
192:
193: PROCEDURE Validate_Item_Comp_Det( p_item_composition_id IN NUMBER,
194: P_inv_item_name IN VARCHAR2,
195: p_x_Detail_Rec_Type IN OUT NOCOPY ahl_mc_item_comp_pvt.Detail_Rec_Type
196: )
197: AS
198:
199:

Line 242: l_Detail_Rec_Type ahl_mc_item_comp_pvt.Detail_Rec_Type DEFAULT p_x_Detail_Rec_Type;

238:
239:
240: l_dummy varchar2(1);
241:
242: l_Detail_Rec_Type ahl_mc_item_comp_pvt.Detail_Rec_Type DEFAULT p_x_Detail_Rec_Type;
243:
244: BEGIN
245:
246:

Line 394: p_x_ic_header_rec IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Header_Rec_Type,

390: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
391: x_return_status OUT NOCOPY VARCHAR2,
392: x_msg_count OUT NOCOPY NUMBER,
393: x_msg_data OUT NOCOPY VARCHAR2,
394: p_x_ic_header_rec IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Header_Rec_Type,
395: p_x_det_tbl IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Det_Tbl_Type
396: )
397:
398: AS

Line 395: p_x_det_tbl IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Det_Tbl_Type

391: x_return_status OUT NOCOPY VARCHAR2,
392: x_msg_count OUT NOCOPY NUMBER,
393: x_msg_data OUT NOCOPY VARCHAR2,
394: p_x_ic_header_rec IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Header_Rec_Type,
395: p_x_det_tbl IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Det_Tbl_Type
396: )
397:
398: AS
399:

Line 660: p_x_ic_header_rec IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Header_Rec_Type,

656: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
657: x_return_status OUT NOCOPY VARCHAR2,
658: x_msg_count OUT NOCOPY NUMBER,
659: x_msg_data OUT NOCOPY VARCHAR2,
660: p_x_ic_header_rec IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Header_Rec_Type,
661: p_x_det_tbl IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Det_Tbl_Type
662: )
663:
664: AS

Line 661: p_x_det_tbl IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Det_Tbl_Type

657: x_return_status OUT NOCOPY VARCHAR2,
658: x_msg_count OUT NOCOPY NUMBER,
659: x_msg_data OUT NOCOPY VARCHAR2,
660: p_x_ic_header_rec IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Header_Rec_Type,
661: p_x_det_tbl IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Det_Tbl_Type
662: )
663:
664: AS
665:

Line 1391: p_x_comp_det_rec IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Detail_Rec_Type

1387:
1388:
1389:
1390: PROCEDURE Create_Line_Item (p_item_composition_id IN NUMBER,
1391: p_x_comp_det_rec IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Detail_Rec_Type
1392: )
1393:
1394: AS
1395:

Line 1493: p_x_comp_det_rec IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Detail_Rec_Type

1489: END;
1490:
1491:
1492: PROCEDURE Update_Line_Item (p_item_composition_id IN NUMBER,
1493: p_x_comp_det_rec IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Detail_Rec_Type
1494: )
1495:
1496: AS
1497:

Line 1538: p_x_comp_det_rec IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Detail_Rec_Type

1534:
1535:
1536:
1537: PROCEDURE Delete_Line_Item (p_item_composition_id IN NUMBER,
1538: p_x_comp_det_rec IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Detail_Rec_Type
1539: )
1540:
1541: AS
1542:

Line 1774: ahl_mc_item_comp_pvt.approve_item_composiiton

1770: P_NOTES_FROM_REQUESTER =>NULL,
1771: P_WORKFLOWPROCESS =>'AHL_GEN_APPROVAL',
1772: P_ITEM_TYPE =>'AHLGAPP');
1773: ELSE
1774: ahl_mc_item_comp_pvt.approve_item_composiiton
1775: (
1776: p_api_version =>l_api_version,
1777: -- p_init_msg_list =>l_init_msg_list,
1778: -- p_commit =>l_commit,

Line 2585: End AHL_MC_ITEM_COMP_PVT;

2581: END Approve_Item_Composiiton;
2582:
2583:
2584:
2585: End AHL_MC_ITEM_COMP_PVT;