DBA Data[Home] [Help]

APPS.BOM_RTG_ISETUP_IMP dependencies on BOM_RTG_PUB

Line 50: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type

46: insCtx DBMS_XMLSave.ctxType;
47: rows NUMBER;
48: ename_v VARCHAR2(20);
49:
50: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type
51: := Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC;
52: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
53: := Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;
54: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type

Line 51: := Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC;

47: rows NUMBER;
48: ename_v VARCHAR2(20);
49:
50: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type
51: := Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC;
52: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
53: := Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;
54: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type
55: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;

Line 52: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type

48: ename_v VARCHAR2(20);
49:
50: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type
51: := Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC;
52: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
53: := Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;
54: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type
55: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
56: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type

Line 53: := Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;

49:
50: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type
51: := Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC;
52: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
53: := Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;
54: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type
55: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
56: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type
57: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;

Line 54: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type

50: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type
51: := Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC;
52: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
53: := Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;
54: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type
55: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
56: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type
57: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
58: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type

Line 55: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;

51: := Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC;
52: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
53: := Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;
54: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type
55: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
56: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type
57: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
58: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type
59: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;

Line 56: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type

52: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
53: := Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;
54: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type
55: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
56: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type
57: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
58: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type
59: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;
60: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type

Line 57: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;

53: := Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;
54: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type
55: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
56: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type
57: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
58: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type
59: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;
60: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type
61: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL;

Line 58: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type

54: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type
55: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
56: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type
57: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
58: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type
59: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;
60: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type
61: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL;
62: x_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type

Line 59: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;

55: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
56: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type
57: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
58: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type
59: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;
60: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type
61: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL;
62: x_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type
63: := Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC;

Line 60: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type

56: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type
57: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
58: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type
59: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;
60: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type
61: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL;
62: x_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type
63: := Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC;
64: x_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type

Line 61: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL;

57: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
58: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type
59: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;
60: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type
61: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL;
62: x_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type
63: := Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC;
64: x_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
65: :=Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;

Line 62: x_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type

58: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type
59: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;
60: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type
61: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL;
62: x_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type
63: := Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC;
64: x_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
65: :=Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;
66: x_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type

Line 63: := Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC;

59: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;
60: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type
61: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL;
62: x_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type
63: := Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC;
64: x_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
65: :=Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;
66: x_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type
67: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;

Line 64: x_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type

60: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type
61: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL;
62: x_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type
63: := Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC;
64: x_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
65: :=Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;
66: x_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type
67: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
68: x_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type

Line 65: :=Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;

61: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL;
62: x_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type
63: := Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC;
64: x_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
65: :=Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;
66: x_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type
67: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
68: x_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type
69: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;

Line 66: x_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type

62: x_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type
63: := Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC;
64: x_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
65: :=Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;
66: x_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type
67: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
68: x_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type
69: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
70: x_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type

Line 67: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;

63: := Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC;
64: x_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
65: :=Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;
66: x_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type
67: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
68: x_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type
69: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
70: x_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type
71: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;

Line 68: x_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type

64: x_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
65: :=Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;
66: x_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type
67: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
68: x_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type
69: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
70: x_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type
71: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;
72: x_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type

Line 69: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;

65: :=Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;
66: x_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type
67: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
68: x_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type
69: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
70: x_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type
71: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;
72: x_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type
73: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL;

Line 70: x_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type

66: x_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type
67: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
68: x_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type
69: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
70: x_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type
71: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;
72: x_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type
73: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL;
74:

Line 71: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;

67: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
68: x_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type
69: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
70: x_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type
71: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;
72: x_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type
73: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL;
74:
75: CURSOR rtg_hdr_CUR IS

Line 72: x_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type

68: x_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type
69: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
70: x_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type
71: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;
72: x_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type
73: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL;
74:
75: CURSOR rtg_hdr_CUR IS
76: SELECT tmp.AssemblyItemName

Line 73: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL;

69: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
70: x_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type
71: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;
72: x_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type
73: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL;
74:
75: CURSOR rtg_hdr_CUR IS
76: SELECT tmp.AssemblyItemName
77: , tmp.OrganizationCode

Line 990: BOM_RTG_PUB.Process_RTG(p_rtg_header_rec => l_rtg_header_rec

986: END LOOP;
987: CLOSE rtg_op_networks_CUR;
988: BOM_GLOBALS.Set_Caller_Type('MIGRATION');
989: ERROR_HANDLER.Initialize;
990: BOM_RTG_PUB.Process_RTG(p_rtg_header_rec => l_rtg_header_rec
991: , p_rtg_revision_tbl => l_rtg_revision_tbl
992: , p_operation_tbl => l_operation_tbl
993: , p_op_resource_tbl => l_op_resource_tbl
994: , p_sub_resource_tbl => l_sub_resource_tbl