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.BOM_RTG_COPYORG_IMP dependencies on BOM_RTG_PUB

Line 29: -- the call to BOM_RTG_PUB.Process_RTG to

25: -- pass all the records to Routing Interface API.
26: -- Routing Interface API will do the copying.
27: -- 13-DEC-06 Mohan Yerramsetty Bug# 5493353, Modified the code to delete
28: -- the successfully processed records after
29: -- the call to BOM_RTG_PUB.Process_RTG to
30: -- reduce the memory consumed by the process.
31: ***************************************************************************/
32:
33: --=============================================

Line 54: TYPE Rtg_Header_Tbl_Type IS TABLE OF Bom_Rtg_Pub.Rtg_Header_Rec_Type

50: X_return_status OUT NOCOPY VARCHAR2,
51: X_msg_count OUT NOCOPY NUMBER,
52: X_G_msg_data OUT NOCOPY LONG) IS
53:
54: TYPE Rtg_Header_Tbl_Type IS TABLE OF Bom_Rtg_Pub.Rtg_Header_Rec_Type
55: INDEX BY BINARY_INTEGER ;
56: l_rtg_header_tbl Rtg_Header_Tbl_Type;
57:
58: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;

Line 58: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;

54: TYPE Rtg_Header_Tbl_Type IS TABLE OF Bom_Rtg_Pub.Rtg_Header_Rec_Type
55: INDEX BY BINARY_INTEGER ;
56: l_rtg_header_tbl Rtg_Header_Tbl_Type;
57:
58: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
59: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
60: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
61: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
62: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;

Line 59: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;

55: INDEX BY BINARY_INTEGER ;
56: l_rtg_header_tbl Rtg_Header_Tbl_Type;
57:
58: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
59: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
60: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
61: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
62: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
63: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;

Line 60: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;

56: l_rtg_header_tbl Rtg_Header_Tbl_Type;
57:
58: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
59: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
60: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
61: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
62: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
63: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
64:

Line 61: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;

57:
58: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
59: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
60: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
61: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
62: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
63: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
64:
65: x_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;

Line 62: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;

58: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
59: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
60: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
61: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
62: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
63: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
64:
65: x_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
66: x_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;

Line 63: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;

59: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
60: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
61: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
62: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
63: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
64:
65: x_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
66: x_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
67: x_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;

Line 65: x_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;

61: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
62: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
63: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
64:
65: x_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
66: x_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
67: x_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
68: x_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
69: x_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;

Line 66: x_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;

62: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
63: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
64:
65: x_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
66: x_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
67: x_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
68: x_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
69: x_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
70: x_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;

Line 67: x_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;

63: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
64:
65: x_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
66: x_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
67: x_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
68: x_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
69: x_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
70: x_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
71:

Line 68: x_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;

64:
65: x_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
66: x_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
67: x_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
68: x_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
69: x_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
70: x_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
71:
72:

Line 69: x_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;

65: x_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
66: x_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
67: x_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
68: x_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
69: x_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
70: x_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
71:
72:
73: ---------------------------------Operational Routings Cursor-----------------------------------------------

Line 70: x_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;

66: x_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
67: x_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
68: x_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
69: x_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
70: x_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
71:
72:
73: ---------------------------------Operational Routings Cursor-----------------------------------------------
74:

Line 579: BOM_RTG_PUB.Process_RTG(p_rtg_header_rec => l_rtg_header_rec

575: END LOOP;
576: CLOSE rtg_op_networks_CUR;
577: BOM_GLOBALS.Set_Caller_Type('MIGRATION');
578: ERROR_HANDLER.Initialize;
579: BOM_RTG_PUB.Process_RTG(p_rtg_header_rec => l_rtg_header_rec
580: , p_rtg_revision_tbl => l_rtg_revision_tbl
581: , p_operation_tbl => l_operation_tbl
582: , p_op_resource_tbl => l_op_resource_tbl
583: , p_sub_resource_tbl => l_sub_resource_tbl

Line 598: --call to BOM_RTG_PUB.Process_RTG to reduce the memory consumed by the process

594: , x_return_status => l_X_return_status
595: , x_msg_count => X_msg_count);
596:
597: --myerrams, Bug: 5493353; Delete the successfully processed records after the
598: --call to BOM_RTG_PUB.Process_RTG to reduce the memory consumed by the process
599: X_rtg_revision_tbl.DELETE;
600: X_operation_tbl.DELETE;
601: X_op_resource_tbl.DELETE;
602: X_sub_resource_tbl.DELETE;