47: TYPE Entity_Map_Log_Rec_Type IS RECORD (
48: change_propagation_map_id NUMBER
49: , change_id NUMBER
50: , revised_item_sequence_id NUMBER
51: , revised_line_type eng_change_propagation_maps.revised_line_type%TYPE
52: , revised_line_id1 eng_change_propagation_maps.revised_line_id1%TYPE
53: , revised_line_id2 eng_change_propagation_maps.revised_line_id2%TYPE
54: , revised_line_id3 eng_change_propagation_maps.revised_line_id3%TYPE
55: , revised_line_id4 eng_change_propagation_maps.revised_line_id4%TYPE
48: change_propagation_map_id NUMBER
49: , change_id NUMBER
50: , revised_item_sequence_id NUMBER
51: , revised_line_type eng_change_propagation_maps.revised_line_type%TYPE
52: , revised_line_id1 eng_change_propagation_maps.revised_line_id1%TYPE
53: , revised_line_id2 eng_change_propagation_maps.revised_line_id2%TYPE
54: , revised_line_id3 eng_change_propagation_maps.revised_line_id3%TYPE
55: , revised_line_id4 eng_change_propagation_maps.revised_line_id4%TYPE
56: , revised_line_id5 eng_change_propagation_maps.revised_line_id5%TYPE
49: , change_id NUMBER
50: , revised_item_sequence_id NUMBER
51: , revised_line_type eng_change_propagation_maps.revised_line_type%TYPE
52: , revised_line_id1 eng_change_propagation_maps.revised_line_id1%TYPE
53: , revised_line_id2 eng_change_propagation_maps.revised_line_id2%TYPE
54: , revised_line_id3 eng_change_propagation_maps.revised_line_id3%TYPE
55: , revised_line_id4 eng_change_propagation_maps.revised_line_id4%TYPE
56: , revised_line_id5 eng_change_propagation_maps.revised_line_id5%TYPE
57: , local_organization_id NUMBER
50: , revised_item_sequence_id NUMBER
51: , revised_line_type eng_change_propagation_maps.revised_line_type%TYPE
52: , revised_line_id1 eng_change_propagation_maps.revised_line_id1%TYPE
53: , revised_line_id2 eng_change_propagation_maps.revised_line_id2%TYPE
54: , revised_line_id3 eng_change_propagation_maps.revised_line_id3%TYPE
55: , revised_line_id4 eng_change_propagation_maps.revised_line_id4%TYPE
56: , revised_line_id5 eng_change_propagation_maps.revised_line_id5%TYPE
57: , local_organization_id NUMBER
58: , local_change_id NUMBER
51: , revised_line_type eng_change_propagation_maps.revised_line_type%TYPE
52: , revised_line_id1 eng_change_propagation_maps.revised_line_id1%TYPE
53: , revised_line_id2 eng_change_propagation_maps.revised_line_id2%TYPE
54: , revised_line_id3 eng_change_propagation_maps.revised_line_id3%TYPE
55: , revised_line_id4 eng_change_propagation_maps.revised_line_id4%TYPE
56: , revised_line_id5 eng_change_propagation_maps.revised_line_id5%TYPE
57: , local_organization_id NUMBER
58: , local_change_id NUMBER
59: , local_revised_item_seq_id NUMBER
52: , revised_line_id1 eng_change_propagation_maps.revised_line_id1%TYPE
53: , revised_line_id2 eng_change_propagation_maps.revised_line_id2%TYPE
54: , revised_line_id3 eng_change_propagation_maps.revised_line_id3%TYPE
55: , revised_line_id4 eng_change_propagation_maps.revised_line_id4%TYPE
56: , revised_line_id5 eng_change_propagation_maps.revised_line_id5%TYPE
57: , local_organization_id NUMBER
58: , local_change_id NUMBER
59: , local_revised_item_seq_id NUMBER
60: , local_revised_line_id1 eng_change_propagation_maps.local_revised_line_id1%TYPE
56: , revised_line_id5 eng_change_propagation_maps.revised_line_id5%TYPE
57: , local_organization_id NUMBER
58: , local_change_id NUMBER
59: , local_revised_item_seq_id NUMBER
60: , local_revised_line_id1 eng_change_propagation_maps.local_revised_line_id1%TYPE
61: , local_revised_line_id2 eng_change_propagation_maps.local_revised_line_id2%TYPE
62: , local_revised_line_id3 eng_change_propagation_maps.local_revised_line_id3%TYPE
63: , local_revised_line_id4 eng_change_propagation_maps.local_revised_line_id4%TYPE
64: , local_revised_line_id5 eng_change_propagation_maps.local_revised_line_id5%TYPE
57: , local_organization_id NUMBER
58: , local_change_id NUMBER
59: , local_revised_item_seq_id NUMBER
60: , local_revised_line_id1 eng_change_propagation_maps.local_revised_line_id1%TYPE
61: , local_revised_line_id2 eng_change_propagation_maps.local_revised_line_id2%TYPE
62: , local_revised_line_id3 eng_change_propagation_maps.local_revised_line_id3%TYPE
63: , local_revised_line_id4 eng_change_propagation_maps.local_revised_line_id4%TYPE
64: , local_revised_line_id5 eng_change_propagation_maps.local_revised_line_id5%TYPE
65: , entity_name eng_change_propagation_maps.entity_name%TYPE
58: , local_change_id NUMBER
59: , local_revised_item_seq_id NUMBER
60: , local_revised_line_id1 eng_change_propagation_maps.local_revised_line_id1%TYPE
61: , local_revised_line_id2 eng_change_propagation_maps.local_revised_line_id2%TYPE
62: , local_revised_line_id3 eng_change_propagation_maps.local_revised_line_id3%TYPE
63: , local_revised_line_id4 eng_change_propagation_maps.local_revised_line_id4%TYPE
64: , local_revised_line_id5 eng_change_propagation_maps.local_revised_line_id5%TYPE
65: , entity_name eng_change_propagation_maps.entity_name%TYPE
66: , entity_action_status NUMBER
59: , local_revised_item_seq_id NUMBER
60: , local_revised_line_id1 eng_change_propagation_maps.local_revised_line_id1%TYPE
61: , local_revised_line_id2 eng_change_propagation_maps.local_revised_line_id2%TYPE
62: , local_revised_line_id3 eng_change_propagation_maps.local_revised_line_id3%TYPE
63: , local_revised_line_id4 eng_change_propagation_maps.local_revised_line_id4%TYPE
64: , local_revised_line_id5 eng_change_propagation_maps.local_revised_line_id5%TYPE
65: , entity_name eng_change_propagation_maps.entity_name%TYPE
66: , entity_action_status NUMBER
67: , message_list Error_Handler.Error_Tbl_Type
60: , local_revised_line_id1 eng_change_propagation_maps.local_revised_line_id1%TYPE
61: , local_revised_line_id2 eng_change_propagation_maps.local_revised_line_id2%TYPE
62: , local_revised_line_id3 eng_change_propagation_maps.local_revised_line_id3%TYPE
63: , local_revised_line_id4 eng_change_propagation_maps.local_revised_line_id4%TYPE
64: , local_revised_line_id5 eng_change_propagation_maps.local_revised_line_id5%TYPE
65: , entity_name eng_change_propagation_maps.entity_name%TYPE
66: , entity_action_status NUMBER
67: , message_list Error_Handler.Error_Tbl_Type
68: );
61: , local_revised_line_id2 eng_change_propagation_maps.local_revised_line_id2%TYPE
62: , local_revised_line_id3 eng_change_propagation_maps.local_revised_line_id3%TYPE
63: , local_revised_line_id4 eng_change_propagation_maps.local_revised_line_id4%TYPE
64: , local_revised_line_id5 eng_change_propagation_maps.local_revised_line_id5%TYPE
65: , entity_name eng_change_propagation_maps.entity_name%TYPE
66: , entity_action_status NUMBER
67: , message_list Error_Handler.Error_Tbl_Type
68: );
69:
77: PROCEDURE Write_Propagation_Log;
78:
79: PROCEDURE Check_Entity_Map_Existance (
80: p_change_id IN NUMBER
81: , p_entity_name IN eng_change_propagation_maps.entity_name%TYPE
82: , p_revised_item_sequence_id IN NUMBER := NULL
83: , p_revised_line_type IN eng_change_propagation_maps.revised_line_type%TYPE := NULL
84: , p_revised_line_id1 IN eng_change_propagation_maps.revised_line_id1%TYPE := NULL
85: , p_revised_line_id2 IN eng_change_propagation_maps.revised_line_id2%TYPE := NULL
79: PROCEDURE Check_Entity_Map_Existance (
80: p_change_id IN NUMBER
81: , p_entity_name IN eng_change_propagation_maps.entity_name%TYPE
82: , p_revised_item_sequence_id IN NUMBER := NULL
83: , p_revised_line_type IN eng_change_propagation_maps.revised_line_type%TYPE := NULL
84: , p_revised_line_id1 IN eng_change_propagation_maps.revised_line_id1%TYPE := NULL
85: , p_revised_line_id2 IN eng_change_propagation_maps.revised_line_id2%TYPE := NULL
86: , p_revised_line_id3 IN eng_change_propagation_maps.revised_line_id3%TYPE := NULL
87: , p_revised_line_id4 IN eng_change_propagation_maps.revised_line_id4%TYPE := NULL
80: p_change_id IN NUMBER
81: , p_entity_name IN eng_change_propagation_maps.entity_name%TYPE
82: , p_revised_item_sequence_id IN NUMBER := NULL
83: , p_revised_line_type IN eng_change_propagation_maps.revised_line_type%TYPE := NULL
84: , p_revised_line_id1 IN eng_change_propagation_maps.revised_line_id1%TYPE := NULL
85: , p_revised_line_id2 IN eng_change_propagation_maps.revised_line_id2%TYPE := NULL
86: , p_revised_line_id3 IN eng_change_propagation_maps.revised_line_id3%TYPE := NULL
87: , p_revised_line_id4 IN eng_change_propagation_maps.revised_line_id4%TYPE := NULL
88: , p_revised_line_id5 IN eng_change_propagation_maps.revised_line_id5%TYPE := NULL
81: , p_entity_name IN eng_change_propagation_maps.entity_name%TYPE
82: , p_revised_item_sequence_id IN NUMBER := NULL
83: , p_revised_line_type IN eng_change_propagation_maps.revised_line_type%TYPE := NULL
84: , p_revised_line_id1 IN eng_change_propagation_maps.revised_line_id1%TYPE := NULL
85: , p_revised_line_id2 IN eng_change_propagation_maps.revised_line_id2%TYPE := NULL
86: , p_revised_line_id3 IN eng_change_propagation_maps.revised_line_id3%TYPE := NULL
87: , p_revised_line_id4 IN eng_change_propagation_maps.revised_line_id4%TYPE := NULL
88: , p_revised_line_id5 IN eng_change_propagation_maps.revised_line_id5%TYPE := NULL
89: , p_local_organization_id IN NUMBER
82: , p_revised_item_sequence_id IN NUMBER := NULL
83: , p_revised_line_type IN eng_change_propagation_maps.revised_line_type%TYPE := NULL
84: , p_revised_line_id1 IN eng_change_propagation_maps.revised_line_id1%TYPE := NULL
85: , p_revised_line_id2 IN eng_change_propagation_maps.revised_line_id2%TYPE := NULL
86: , p_revised_line_id3 IN eng_change_propagation_maps.revised_line_id3%TYPE := NULL
87: , p_revised_line_id4 IN eng_change_propagation_maps.revised_line_id4%TYPE := NULL
88: , p_revised_line_id5 IN eng_change_propagation_maps.revised_line_id5%TYPE := NULL
89: , p_local_organization_id IN NUMBER
90: , x_change_map_id OUT NOCOPY NUMBER
83: , p_revised_line_type IN eng_change_propagation_maps.revised_line_type%TYPE := NULL
84: , p_revised_line_id1 IN eng_change_propagation_maps.revised_line_id1%TYPE := NULL
85: , p_revised_line_id2 IN eng_change_propagation_maps.revised_line_id2%TYPE := NULL
86: , p_revised_line_id3 IN eng_change_propagation_maps.revised_line_id3%TYPE := NULL
87: , p_revised_line_id4 IN eng_change_propagation_maps.revised_line_id4%TYPE := NULL
88: , p_revised_line_id5 IN eng_change_propagation_maps.revised_line_id5%TYPE := NULL
89: , p_local_organization_id IN NUMBER
90: , x_change_map_id OUT NOCOPY NUMBER
91: );
84: , p_revised_line_id1 IN eng_change_propagation_maps.revised_line_id1%TYPE := NULL
85: , p_revised_line_id2 IN eng_change_propagation_maps.revised_line_id2%TYPE := NULL
86: , p_revised_line_id3 IN eng_change_propagation_maps.revised_line_id3%TYPE := NULL
87: , p_revised_line_id4 IN eng_change_propagation_maps.revised_line_id4%TYPE := NULL
88: , p_revised_line_id5 IN eng_change_propagation_maps.revised_line_id5%TYPE := NULL
89: , p_local_organization_id IN NUMBER
90: , x_change_map_id OUT NOCOPY NUMBER
91: );
92:
92:
93: PROCEDURE Add_Entity_Map (
94: p_change_id IN NUMBER
95: , p_revised_item_sequence_id IN NUMBER := NULL
96: , p_revised_line_type IN eng_change_propagation_maps.revised_line_type%TYPE := NULL
97: , p_revised_line_id1 IN eng_change_propagation_maps.revised_line_id1%TYPE := NULL
98: , p_revised_line_id2 IN eng_change_propagation_maps.revised_line_id2%TYPE := NULL
99: , p_revised_line_id3 IN eng_change_propagation_maps.revised_line_id3%TYPE := NULL
100: , p_revised_line_id4 IN eng_change_propagation_maps.revised_line_id4%TYPE := NULL
93: PROCEDURE Add_Entity_Map (
94: p_change_id IN NUMBER
95: , p_revised_item_sequence_id IN NUMBER := NULL
96: , p_revised_line_type IN eng_change_propagation_maps.revised_line_type%TYPE := NULL
97: , p_revised_line_id1 IN eng_change_propagation_maps.revised_line_id1%TYPE := NULL
98: , p_revised_line_id2 IN eng_change_propagation_maps.revised_line_id2%TYPE := NULL
99: , p_revised_line_id3 IN eng_change_propagation_maps.revised_line_id3%TYPE := NULL
100: , p_revised_line_id4 IN eng_change_propagation_maps.revised_line_id4%TYPE := NULL
101: , p_revised_line_id5 IN eng_change_propagation_maps.revised_line_id5%TYPE := NULL
94: p_change_id IN NUMBER
95: , p_revised_item_sequence_id IN NUMBER := NULL
96: , p_revised_line_type IN eng_change_propagation_maps.revised_line_type%TYPE := NULL
97: , p_revised_line_id1 IN eng_change_propagation_maps.revised_line_id1%TYPE := NULL
98: , p_revised_line_id2 IN eng_change_propagation_maps.revised_line_id2%TYPE := NULL
99: , p_revised_line_id3 IN eng_change_propagation_maps.revised_line_id3%TYPE := NULL
100: , p_revised_line_id4 IN eng_change_propagation_maps.revised_line_id4%TYPE := NULL
101: , p_revised_line_id5 IN eng_change_propagation_maps.revised_line_id5%TYPE := NULL
102: , p_local_organization_id IN NUMBER
95: , p_revised_item_sequence_id IN NUMBER := NULL
96: , p_revised_line_type IN eng_change_propagation_maps.revised_line_type%TYPE := NULL
97: , p_revised_line_id1 IN eng_change_propagation_maps.revised_line_id1%TYPE := NULL
98: , p_revised_line_id2 IN eng_change_propagation_maps.revised_line_id2%TYPE := NULL
99: , p_revised_line_id3 IN eng_change_propagation_maps.revised_line_id3%TYPE := NULL
100: , p_revised_line_id4 IN eng_change_propagation_maps.revised_line_id4%TYPE := NULL
101: , p_revised_line_id5 IN eng_change_propagation_maps.revised_line_id5%TYPE := NULL
102: , p_local_organization_id IN NUMBER
103: , p_local_change_id IN NUMBER := NULL
96: , p_revised_line_type IN eng_change_propagation_maps.revised_line_type%TYPE := NULL
97: , p_revised_line_id1 IN eng_change_propagation_maps.revised_line_id1%TYPE := NULL
98: , p_revised_line_id2 IN eng_change_propagation_maps.revised_line_id2%TYPE := NULL
99: , p_revised_line_id3 IN eng_change_propagation_maps.revised_line_id3%TYPE := NULL
100: , p_revised_line_id4 IN eng_change_propagation_maps.revised_line_id4%TYPE := NULL
101: , p_revised_line_id5 IN eng_change_propagation_maps.revised_line_id5%TYPE := NULL
102: , p_local_organization_id IN NUMBER
103: , p_local_change_id IN NUMBER := NULL
104: , p_local_revised_item_seq_id IN NUMBER := NULL
97: , p_revised_line_id1 IN eng_change_propagation_maps.revised_line_id1%TYPE := NULL
98: , p_revised_line_id2 IN eng_change_propagation_maps.revised_line_id2%TYPE := NULL
99: , p_revised_line_id3 IN eng_change_propagation_maps.revised_line_id3%TYPE := NULL
100: , p_revised_line_id4 IN eng_change_propagation_maps.revised_line_id4%TYPE := NULL
101: , p_revised_line_id5 IN eng_change_propagation_maps.revised_line_id5%TYPE := NULL
102: , p_local_organization_id IN NUMBER
103: , p_local_change_id IN NUMBER := NULL
104: , p_local_revised_item_seq_id IN NUMBER := NULL
105: , p_local_revised_line_id1 IN eng_change_propagation_maps.local_revised_line_id1%TYPE := NULL
101: , p_revised_line_id5 IN eng_change_propagation_maps.revised_line_id5%TYPE := NULL
102: , p_local_organization_id IN NUMBER
103: , p_local_change_id IN NUMBER := NULL
104: , p_local_revised_item_seq_id IN NUMBER := NULL
105: , p_local_revised_line_id1 IN eng_change_propagation_maps.local_revised_line_id1%TYPE := NULL
106: , p_local_revised_line_id2 IN eng_change_propagation_maps.local_revised_line_id2%TYPE := NULL
107: , p_local_revised_line_id3 IN eng_change_propagation_maps.local_revised_line_id3%TYPE := NULL
108: , p_local_revised_line_id4 IN eng_change_propagation_maps.local_revised_line_id4%TYPE := NULL
109: , p_local_revised_line_id5 IN eng_change_propagation_maps.local_revised_line_id5%TYPE := NULL
102: , p_local_organization_id IN NUMBER
103: , p_local_change_id IN NUMBER := NULL
104: , p_local_revised_item_seq_id IN NUMBER := NULL
105: , p_local_revised_line_id1 IN eng_change_propagation_maps.local_revised_line_id1%TYPE := NULL
106: , p_local_revised_line_id2 IN eng_change_propagation_maps.local_revised_line_id2%TYPE := NULL
107: , p_local_revised_line_id3 IN eng_change_propagation_maps.local_revised_line_id3%TYPE := NULL
108: , p_local_revised_line_id4 IN eng_change_propagation_maps.local_revised_line_id4%TYPE := NULL
109: , p_local_revised_line_id5 IN eng_change_propagation_maps.local_revised_line_id5%TYPE := NULL
110: , p_entity_name IN eng_change_propagation_maps.entity_name%TYPE
103: , p_local_change_id IN NUMBER := NULL
104: , p_local_revised_item_seq_id IN NUMBER := NULL
105: , p_local_revised_line_id1 IN eng_change_propagation_maps.local_revised_line_id1%TYPE := NULL
106: , p_local_revised_line_id2 IN eng_change_propagation_maps.local_revised_line_id2%TYPE := NULL
107: , p_local_revised_line_id3 IN eng_change_propagation_maps.local_revised_line_id3%TYPE := NULL
108: , p_local_revised_line_id4 IN eng_change_propagation_maps.local_revised_line_id4%TYPE := NULL
109: , p_local_revised_line_id5 IN eng_change_propagation_maps.local_revised_line_id5%TYPE := NULL
110: , p_entity_name IN eng_change_propagation_maps.entity_name%TYPE
111: , p_entity_action_status IN NUMBER
104: , p_local_revised_item_seq_id IN NUMBER := NULL
105: , p_local_revised_line_id1 IN eng_change_propagation_maps.local_revised_line_id1%TYPE := NULL
106: , p_local_revised_line_id2 IN eng_change_propagation_maps.local_revised_line_id2%TYPE := NULL
107: , p_local_revised_line_id3 IN eng_change_propagation_maps.local_revised_line_id3%TYPE := NULL
108: , p_local_revised_line_id4 IN eng_change_propagation_maps.local_revised_line_id4%TYPE := NULL
109: , p_local_revised_line_id5 IN eng_change_propagation_maps.local_revised_line_id5%TYPE := NULL
110: , p_entity_name IN eng_change_propagation_maps.entity_name%TYPE
111: , p_entity_action_status IN NUMBER
112: , p_bo_entity_identifier IN VARCHAR2
105: , p_local_revised_line_id1 IN eng_change_propagation_maps.local_revised_line_id1%TYPE := NULL
106: , p_local_revised_line_id2 IN eng_change_propagation_maps.local_revised_line_id2%TYPE := NULL
107: , p_local_revised_line_id3 IN eng_change_propagation_maps.local_revised_line_id3%TYPE := NULL
108: , p_local_revised_line_id4 IN eng_change_propagation_maps.local_revised_line_id4%TYPE := NULL
109: , p_local_revised_line_id5 IN eng_change_propagation_maps.local_revised_line_id5%TYPE := NULL
110: , p_entity_name IN eng_change_propagation_maps.entity_name%TYPE
111: , p_entity_action_status IN NUMBER
112: , p_bo_entity_identifier IN VARCHAR2
113: );
106: , p_local_revised_line_id2 IN eng_change_propagation_maps.local_revised_line_id2%TYPE := NULL
107: , p_local_revised_line_id3 IN eng_change_propagation_maps.local_revised_line_id3%TYPE := NULL
108: , p_local_revised_line_id4 IN eng_change_propagation_maps.local_revised_line_id4%TYPE := NULL
109: , p_local_revised_line_id5 IN eng_change_propagation_maps.local_revised_line_id5%TYPE := NULL
110: , p_entity_name IN eng_change_propagation_maps.entity_name%TYPE
111: , p_entity_action_status IN NUMBER
112: , p_bo_entity_identifier IN VARCHAR2
113: );
114: