APPS.MTL_CROSS_REFERENCES_PVT dependencies on MTL_CROSS_REFERENCES_PUB

Line 41: ,p_XRef_Tbl IN OUT NOCOPY MTL_CROSS_REFERENCES_PUB.XRef_Tbl_Type

37:
38: PROCEDURE Process_XRef(
39: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
40: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
41: ,p_XRef_Tbl IN OUT NOCOPY MTL_CROSS_REFERENCES_PUB.XRef_Tbl_Type
42: ,x_return_status OUT NOCOPY VARCHAR2
43: ,x_msg_count OUT NOCOPY NUMBER
44: ,x_message_list OUT NOCOPY Error_Handler.Error_Tbl_Type) IS
45:

Line 58: l_XRef_Rec MTL_CROSS_REFERENCES_PUB.XRef_Rec_Type; -- Declaring the record type object

54:
55: l_uom_code_valid VARCHAR(1); /*bug 14138918*/
56: l_rev_id_invalid VARCHAR(1); /*bug 14138918*/
57:
58: l_XRef_Rec MTL_CROSS_REFERENCES_PUB.XRef_Rec_Type; -- Declaring the record type object
59: l_XRef_Tbl MTL_CROSS_REFERENCES_PUB.XRef_Tbl_Type; -- Declaring local table object
60: l_Token_Tbl Error_Handler.Token_Tbl_Type; -- For passing token in error msgs
61: l_msg_count NUMBER:=0;
62: returned_cross_ref_id NUMBER;

Line 59: l_XRef_Tbl MTL_CROSS_REFERENCES_PUB.XRef_Tbl_Type; -- Declaring local table object

55: l_uom_code_valid VARCHAR(1); /*bug 14138918*/
56: l_rev_id_invalid VARCHAR(1); /*bug 14138918*/
57:
58: l_XRef_Rec MTL_CROSS_REFERENCES_PUB.XRef_Rec_Type; -- Declaring the record type object
59: l_XRef_Tbl MTL_CROSS_REFERENCES_PUB.XRef_Tbl_Type; -- Declaring local table object
60: l_Token_Tbl Error_Handler.Token_Tbl_Type; -- For passing token in error msgs
61: l_msg_count NUMBER:=0;
62: returned_cross_ref_id NUMBER;
63: returned_object_version_number NUMBER;

Line 1224: ,p_GTIN_XRef_Rec IN OUT NOCOPY MTL_CROSS_REFERENCES_PUB.XRef_Rec_Type

1220:
1221: PROCEDURE Validate_GTIN_Rec(
1222: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1223: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1224: ,p_GTIN_XRef_Rec IN OUT NOCOPY MTL_CROSS_REFERENCES_PUB.XRef_Rec_Type
1225: ,x_return_status OUT NOCOPY VARCHAR2
1226: ,x_msg_count OUT NOCOPY NUMBER) IS
1227:
1228: -- Local variable declarations

Line 1229: l_GTIN_XRef_Rec MTL_CROSS_REFERENCES_PUB.XRef_Rec_Type; -- Declaring the record type object

1225: ,x_return_status OUT NOCOPY VARCHAR2
1226: ,x_msg_count OUT NOCOPY NUMBER) IS
1227:
1228: -- Local variable declarations
1229: l_GTIN_XRef_Rec MTL_CROSS_REFERENCES_PUB.XRef_Rec_Type; -- Declaring the record type object
1230: l_gtin_xref_exists VARCHAR(1);
1231: l_item_revision_exists VARCHAR(1);
1232: l_uom_exists VARCHAR(1);
1233: l_gtin_packitem_exists VARCHAR(1);

Line 1692: l_XRef_Tbl MTL_CROSS_REFERENCES_PUB.XRef_Tbl_Type;

1688:
1689: l_return_status VARCHAR2(1);
1690: l_msg_list Error_Handler.Error_Tbl_Type;
1691: l_msg Error_Handler.Error_Rec_Type;
1692: l_XRef_Tbl MTL_CROSS_REFERENCES_PUB.XRef_Tbl_Type;
1693: l_XRef_Rec MTL_CROSS_REFERENCES_PUB.XRef_Rec_Type;
1694: L_MSG_COUNT number;
1695: l_uom_code VARCHAR2(3);
1696: l_dummyInt INTEGER;

Line 1693: l_XRef_Rec MTL_CROSS_REFERENCES_PUB.XRef_Rec_Type;

1689: l_return_status VARCHAR2(1);
1690: l_msg_list Error_Handler.Error_Tbl_Type;
1691: l_msg Error_Handler.Error_Rec_Type;
1692: l_XRef_Tbl MTL_CROSS_REFERENCES_PUB.XRef_Tbl_Type;
1693: l_XRef_Rec MTL_CROSS_REFERENCES_PUB.XRef_Rec_Type;
1694: L_MSG_COUNT number;
1695: l_uom_code VARCHAR2(3);
1696: l_dummyInt INTEGER;
1697: ret_code NUMBER;