eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MTL_RELATED_ITEMS_PVT dependencies on MTL_RELATED_ITEMS_PUB

Line 31: ,p_Rel_Item_Rec IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Rel_Item_Rec_Type

27: -- -----------------------------------------------------------------------------
28: PROCEDURE Process_Rel_Item(
29: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
30: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
31: ,p_Rel_Item_Rec IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Rel_Item_Rec_Type
32: ,p_Pln_Info_Tbl IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Pln_Info_Tbl_Type
33: ,p_Cust_Ref_Tbl IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Cust_Ref_Tbl_Type
34: ,x_return_status OUT NOCOPY VARCHAR2
35: ,x_msg_count OUT NOCOPY NUMBER

Line 32: ,p_Pln_Info_Tbl IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Pln_Info_Tbl_Type

28: PROCEDURE Process_Rel_Item(
29: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
30: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
31: ,p_Rel_Item_Rec IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Rel_Item_Rec_Type
32: ,p_Pln_Info_Tbl IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Pln_Info_Tbl_Type
33: ,p_Cust_Ref_Tbl IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Cust_Ref_Tbl_Type
34: ,x_return_status OUT NOCOPY VARCHAR2
35: ,x_msg_count OUT NOCOPY NUMBER
36: ,x_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type) IS

Line 33: ,p_Cust_Ref_Tbl IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Cust_Ref_Tbl_Type

29: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
30: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
31: ,p_Rel_Item_Rec IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Rel_Item_Rec_Type
32: ,p_Pln_Info_Tbl IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Pln_Info_Tbl_Type
33: ,p_Cust_Ref_Tbl IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Cust_Ref_Tbl_Type
34: ,x_return_status OUT NOCOPY VARCHAR2
35: ,x_msg_count OUT NOCOPY NUMBER
36: ,x_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type) IS
37:

Line 50: l_Rel_Item_Rec MTL_RELATED_ITEMS_PUB.Rel_Item_Rec_Type; -- declaring related items record type

46: l_master_org_exists VARCHAR(1);
47: l_cust_ref_exists VARCHAR(1);
48: l_cust_ref_rel_exists VARCHAR(1);
49:
50: l_Rel_Item_Rec MTL_RELATED_ITEMS_PUB.Rel_Item_Rec_Type; -- declaring related items record type
51: l_Pln_Info_Rec MTL_RELATED_ITEMS_PUB.Pln_Info_Rec_Type; -- declating planning information record type
52: l_Pln_Info_Tbl MTL_RELATED_ITEMS_PUB.Pln_Info_Tbl_Type; -- declaring planning information table type
53: l_Cust_Ref_Rec MTL_RELATED_ITEMS_PUB.Cust_Ref_Rec_Type; -- declating customer reference record type
54: l_Cust_Ref_Tbl MTL_RELATED_ITEMS_PUB.Cust_Ref_Tbl_Type; -- declaring customer reference table type

Line 51: l_Pln_Info_Rec MTL_RELATED_ITEMS_PUB.Pln_Info_Rec_Type; -- declating planning information record type

47: l_cust_ref_exists VARCHAR(1);
48: l_cust_ref_rel_exists VARCHAR(1);
49:
50: l_Rel_Item_Rec MTL_RELATED_ITEMS_PUB.Rel_Item_Rec_Type; -- declaring related items record type
51: l_Pln_Info_Rec MTL_RELATED_ITEMS_PUB.Pln_Info_Rec_Type; -- declating planning information record type
52: l_Pln_Info_Tbl MTL_RELATED_ITEMS_PUB.Pln_Info_Tbl_Type; -- declaring planning information table type
53: l_Cust_Ref_Rec MTL_RELATED_ITEMS_PUB.Cust_Ref_Rec_Type; -- declating customer reference record type
54: l_Cust_Ref_Tbl MTL_RELATED_ITEMS_PUB.Cust_Ref_Tbl_Type; -- declaring customer reference table type
55:

Line 52: l_Pln_Info_Tbl MTL_RELATED_ITEMS_PUB.Pln_Info_Tbl_Type; -- declaring planning information table type

48: l_cust_ref_rel_exists VARCHAR(1);
49:
50: l_Rel_Item_Rec MTL_RELATED_ITEMS_PUB.Rel_Item_Rec_Type; -- declaring related items record type
51: l_Pln_Info_Rec MTL_RELATED_ITEMS_PUB.Pln_Info_Rec_Type; -- declating planning information record type
52: l_Pln_Info_Tbl MTL_RELATED_ITEMS_PUB.Pln_Info_Tbl_Type; -- declaring planning information table type
53: l_Cust_Ref_Rec MTL_RELATED_ITEMS_PUB.Cust_Ref_Rec_Type; -- declating customer reference record type
54: l_Cust_Ref_Tbl MTL_RELATED_ITEMS_PUB.Cust_Ref_Tbl_Type; -- declaring customer reference table type
55:
56: Returned_Row_Id VARCHAR2(30);

Line 53: l_Cust_Ref_Rec MTL_RELATED_ITEMS_PUB.Cust_Ref_Rec_Type; -- declating customer reference record type

49:
50: l_Rel_Item_Rec MTL_RELATED_ITEMS_PUB.Rel_Item_Rec_Type; -- declaring related items record type
51: l_Pln_Info_Rec MTL_RELATED_ITEMS_PUB.Pln_Info_Rec_Type; -- declating planning information record type
52: l_Pln_Info_Tbl MTL_RELATED_ITEMS_PUB.Pln_Info_Tbl_Type; -- declaring planning information table type
53: l_Cust_Ref_Rec MTL_RELATED_ITEMS_PUB.Cust_Ref_Rec_Type; -- declating customer reference record type
54: l_Cust_Ref_Tbl MTL_RELATED_ITEMS_PUB.Cust_Ref_Tbl_Type; -- declaring customer reference table type
55:
56: Returned_Row_Id VARCHAR2(30);
57:

Line 54: l_Cust_Ref_Tbl MTL_RELATED_ITEMS_PUB.Cust_Ref_Tbl_Type; -- declaring customer reference table type

50: l_Rel_Item_Rec MTL_RELATED_ITEMS_PUB.Rel_Item_Rec_Type; -- declaring related items record type
51: l_Pln_Info_Rec MTL_RELATED_ITEMS_PUB.Pln_Info_Rec_Type; -- declating planning information record type
52: l_Pln_Info_Tbl MTL_RELATED_ITEMS_PUB.Pln_Info_Tbl_Type; -- declaring planning information table type
53: l_Cust_Ref_Rec MTL_RELATED_ITEMS_PUB.Cust_Ref_Rec_Type; -- declating customer reference record type
54: l_Cust_Ref_Tbl MTL_RELATED_ITEMS_PUB.Cust_Ref_Tbl_Type; -- declaring customer reference table type
55:
56: Returned_Row_Id VARCHAR2(30);
57:
58:

Line 2234: l_Rel_Item_Rec MTL_RELATED_ITEMS_PUB.Rel_Item_Rec_Type;

2230: l_err_text VARCHAR2(255);
2231: l_dummyInt INTEGER;
2232: ret_code NUMBER;
2233: err_msg VARCHAR2(300);
2234: l_Rel_Item_Rec MTL_RELATED_ITEMS_PUB.Rel_Item_Rec_Type;
2235: l_Pln_Info_Tbl MTL_RELATED_ITEMS_PUB.Pln_Info_Tbl_Type;
2236: l_Cust_Ref_Tbl MTL_RELATED_ITEMS_PUB.Cust_Ref_Tbl_Type;
2237: l_proc_rec_count NUMBER;
2238: l_err_count NUMBER; -- to see if error msg exists

Line 2235: l_Pln_Info_Tbl MTL_RELATED_ITEMS_PUB.Pln_Info_Tbl_Type;

2231: l_dummyInt INTEGER;
2232: ret_code NUMBER;
2233: err_msg VARCHAR2(300);
2234: l_Rel_Item_Rec MTL_RELATED_ITEMS_PUB.Rel_Item_Rec_Type;
2235: l_Pln_Info_Tbl MTL_RELATED_ITEMS_PUB.Pln_Info_Tbl_Type;
2236: l_Cust_Ref_Tbl MTL_RELATED_ITEMS_PUB.Cust_Ref_Tbl_Type;
2237: l_proc_rec_count NUMBER;
2238: l_err_count NUMBER; -- to see if error msg exists
2239:

Line 2236: l_Cust_Ref_Tbl MTL_RELATED_ITEMS_PUB.Cust_Ref_Tbl_Type;

2232: ret_code NUMBER;
2233: err_msg VARCHAR2(300);
2234: l_Rel_Item_Rec MTL_RELATED_ITEMS_PUB.Rel_Item_Rec_Type;
2235: l_Pln_Info_Tbl MTL_RELATED_ITEMS_PUB.Pln_Info_Tbl_Type;
2236: l_Cust_Ref_Tbl MTL_RELATED_ITEMS_PUB.Cust_Ref_Tbl_Type;
2237: l_proc_rec_count NUMBER;
2238: l_err_count NUMBER; -- to see if error msg exists
2239:
2240: -- Adding to derive these based on the organization_code , related_item_name and item_number columns