DBA Data[Home] [Help]

APPS.MTL_RELATED_ITEMS_PUB dependencies on MTL_RELATED_ITEMS_PUB

Line 1: PACKAGE BODY MTL_RELATED_ITEMS_PUB AS

1: PACKAGE BODY MTL_RELATED_ITEMS_PUB AS
2: /* $Header: INVPRITB.pls 120.0 2011/03/08 20:07:15 mshirkol noship $ */
3:
4: Procedure Process_Rel_Item(
5: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 7: ,p_Rel_Item_Rec IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Rel_Item_Rec_Type

3:
4: Procedure Process_Rel_Item(
5: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
6: ,P_Init_Msg_List In Varchar2 Default Fnd_Api.G_False
7: ,p_Rel_Item_Rec IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Rel_Item_Rec_Type
8: ,p_Pln_Info_Tbl IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Pln_Info_Tbl_Type
9: ,p_Cust_Ref_Tbl IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Cust_Ref_Tbl_Type
10: ,x_return_status OUT NOCOPY VARCHAR2
11: ,x_msg_count OUT NOCOPY NUMBER

Line 8: ,p_Pln_Info_Tbl IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Pln_Info_Tbl_Type

4: Procedure Process_Rel_Item(
5: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
6: ,P_Init_Msg_List In Varchar2 Default Fnd_Api.G_False
7: ,p_Rel_Item_Rec IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Rel_Item_Rec_Type
8: ,p_Pln_Info_Tbl IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Pln_Info_Tbl_Type
9: ,p_Cust_Ref_Tbl IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Cust_Ref_Tbl_Type
10: ,x_return_status OUT NOCOPY VARCHAR2
11: ,x_msg_count OUT NOCOPY NUMBER
12: ,x_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type) IS

Line 9: ,p_Cust_Ref_Tbl IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Cust_Ref_Tbl_Type

5: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
6: ,P_Init_Msg_List In Varchar2 Default Fnd_Api.G_False
7: ,p_Rel_Item_Rec IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Rel_Item_Rec_Type
8: ,p_Pln_Info_Tbl IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Pln_Info_Tbl_Type
9: ,p_Cust_Ref_Tbl IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Cust_Ref_Tbl_Type
10: ,x_return_status OUT NOCOPY VARCHAR2
11: ,x_msg_count OUT NOCOPY NUMBER
12: ,x_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type) IS
13:

Line 16: -- Savepoint for MTL_RELATED_ITEMS_PUB

12: ,x_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type) IS
13:
14: BEGIN
15:
16: -- Savepoint for MTL_RELATED_ITEMS_PUB
17: SAVEPOINT MTL_RELATED_ITEMS_PUB;
18:
19: -- Initialize message list
20: IF FND_API.To_Boolean (p_init_msg_list) THEN

Line 17: SAVEPOINT MTL_RELATED_ITEMS_PUB;

13:
14: BEGIN
15:
16: -- Savepoint for MTL_RELATED_ITEMS_PUB
17: SAVEPOINT MTL_RELATED_ITEMS_PUB;
18:
19: -- Initialize message list
20: IF FND_API.To_Boolean (p_init_msg_list) THEN
21: Error_Handler.Initialize;

Line 49: ROLLBACK TO MTL_RELATED_ITEMS_PUB; -- rolling back to savepoint

45:
46: EXCEPTION
47: WHEN OTHERS THEN
48: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
49: ROLLBACK TO MTL_RELATED_ITEMS_PUB; -- rolling back to savepoint
50:
51: END Process_Rel_Item;
52:
53: END MTL_RELATED_ITEMS_PUB;

Line 53: END MTL_RELATED_ITEMS_PUB;

49: ROLLBACK TO MTL_RELATED_ITEMS_PUB; -- rolling back to savepoint
50:
51: END Process_Rel_Item;
52:
53: END MTL_RELATED_ITEMS_PUB;