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_ROUTINGHEADER_PVT dependencies on FND_API

Line 11: -- p_init_msg_list VARCHAR2 Optional Default = FND_API.G_FALSE

7: -- Pre-reqs : None.
8: -- Parameters :
9: -- IN :
10: -- p_api_version NUMBER Required
11: -- p_init_msg_list VARCHAR2 Optional Default = FND_API.G_FALSE
12: -- p_commit VARCHAR2 Optional Default = FND_API.G_FALSE
13: -- p_validation_level NUMBER Optional
14: -- Default = FND_API.G_VALID_LEVEL_FULL
15: -- p_routing_rec ROUTING_REC_TYPE Default = G_MISS_ROUTING_REC

Line 12: -- p_commit VARCHAR2 Optional Default = FND_API.G_FALSE

8: -- Parameters :
9: -- IN :
10: -- p_api_version NUMBER Required
11: -- p_init_msg_list VARCHAR2 Optional Default = FND_API.G_FALSE
12: -- p_commit VARCHAR2 Optional Default = FND_API.G_FALSE
13: -- p_validation_level NUMBER Optional
14: -- Default = FND_API.G_VALID_LEVEL_FULL
15: -- p_routing_rec ROUTING_REC_TYPE Default = G_MISS_ROUTING_REC
16: -- .

Line 14: -- Default = FND_API.G_VALID_LEVEL_FULL

10: -- p_api_version NUMBER Required
11: -- p_init_msg_list VARCHAR2 Optional Default = FND_API.G_FALSE
12: -- p_commit VARCHAR2 Optional Default = FND_API.G_FALSE
13: -- p_validation_level NUMBER Optional
14: -- Default = FND_API.G_VALID_LEVEL_FULL
15: -- p_routing_rec ROUTING_REC_TYPE Default = G_MISS_ROUTING_REC
16: -- .
17: -- OUT :
18: -- x_return_status VARCHAR2(1)

Line 35: -- p_init_msg_list VARCHAR2 Optional Default = FND_API.G_FALSE

31: -- Pre-reqs : None.
32: -- Parameters :
33: -- IN :
34: -- p_api_version NUMBER Required
35: -- p_init_msg_list VARCHAR2 Optional Default = FND_API.G_FALSE
36: -- p_commit VARCHAR2 Optional Default = FND_API.G_FALSE
37: -- p_validation_level NUMBER Optional
38: -- Default = FND_API.G_VALID_LEVEL_FULL
39: -- p_routing_rec ROUTING_REC_TYPE Default = G_MISS_ROUTING_REC

Line 36: -- p_commit VARCHAR2 Optional Default = FND_API.G_FALSE

32: -- Parameters :
33: -- IN :
34: -- p_api_version NUMBER Required
35: -- p_init_msg_list VARCHAR2 Optional Default = FND_API.G_FALSE
36: -- p_commit VARCHAR2 Optional Default = FND_API.G_FALSE
37: -- p_validation_level NUMBER Optional
38: -- Default = FND_API.G_VALID_LEVEL_FULL
39: -- p_routing_rec ROUTING_REC_TYPE Default = G_MISS_ROUTING_REC
40: --

Line 38: -- Default = FND_API.G_VALID_LEVEL_FULL

34: -- p_api_version NUMBER Required
35: -- p_init_msg_list VARCHAR2 Optional Default = FND_API.G_FALSE
36: -- p_commit VARCHAR2 Optional Default = FND_API.G_FALSE
37: -- p_validation_level NUMBER Optional
38: -- Default = FND_API.G_VALID_LEVEL_FULL
39: -- p_routing_rec ROUTING_REC_TYPE Default = G_MISS_ROUTING_REC
40: --
41: -- OUT :
42: -- x_return_status VARCHAR2(1)

Line 59: -- p_init_msg_list VARCHAR2 Optional Default = FND_API.G_FALSE

55: -- Pre-reqs : None.
56: -- Parameters :
57: -- IN :
58: -- p_api_version NUMBER Required
59: -- p_init_msg_list VARCHAR2 Optional Default = FND_API.G_FALSE
60: -- p_commit VARCHAR2 Optional Default = FND_API.G_FALSE
61: -- p_validation_level NUMBER Optional
62: -- Default = FND_API.G_VALID_LEVEL_FULL
63: -- p_routing_rec ROUTING_REC_TYPE Default = G_MISS_ROUTING_REC

Line 60: -- p_commit VARCHAR2 Optional Default = FND_API.G_FALSE

56: -- Parameters :
57: -- IN :
58: -- p_api_version NUMBER Required
59: -- p_init_msg_list VARCHAR2 Optional Default = FND_API.G_FALSE
60: -- p_commit VARCHAR2 Optional Default = FND_API.G_FALSE
61: -- p_validation_level NUMBER Optional
62: -- Default = FND_API.G_VALID_LEVEL_FULL
63: -- p_routing_rec ROUTING_REC_TYPE Default = G_MISS_ROUTING_REC
64: --

Line 62: -- Default = FND_API.G_VALID_LEVEL_FULL

58: -- p_api_version NUMBER Required
59: -- p_init_msg_list VARCHAR2 Optional Default = FND_API.G_FALSE
60: -- p_commit VARCHAR2 Optional Default = FND_API.G_FALSE
61: -- p_validation_level NUMBER Optional
62: -- Default = FND_API.G_VALID_LEVEL_FULL
63: -- p_routing_rec ROUTING_REC_TYPE Default = G_MISS_ROUTING_REC
64: --
65: -- OUT :
66: -- x_return_status VARCHAR2(1)

Line 84: -- p_init_msg_list VARCHAR2 Optional Default = FND_API.G_FALSE

80: -- Pre-reqs : None.
81: -- Parameters :
82: -- IN :
83: -- p_api_version NUMBER Required
84: -- p_init_msg_list VARCHAR2 Optional Default = FND_API.G_FALSE
85: -- p_commit VARCHAR2 Optional Default = FND_API.G_FALSE
86: -- p_validation_level NUMBER Optional
87: -- Default = FND_API.G_VALID_LEVEL_FULL
88: -- p_routing_rec ROUTING_REC_TYPE Default = G_MISS_ROUTING_REC

Line 85: -- p_commit VARCHAR2 Optional Default = FND_API.G_FALSE

81: -- Parameters :
82: -- IN :
83: -- p_api_version NUMBER Required
84: -- p_init_msg_list VARCHAR2 Optional Default = FND_API.G_FALSE
85: -- p_commit VARCHAR2 Optional Default = FND_API.G_FALSE
86: -- p_validation_level NUMBER Optional
87: -- Default = FND_API.G_VALID_LEVEL_FULL
88: -- p_routing_rec ROUTING_REC_TYPE Default = G_MISS_ROUTING_REC
89: -- .

Line 87: -- Default = FND_API.G_VALID_LEVEL_FULL

83: -- p_api_version NUMBER Required
84: -- p_init_msg_list VARCHAR2 Optional Default = FND_API.G_FALSE
85: -- p_commit VARCHAR2 Optional Default = FND_API.G_FALSE
86: -- p_validation_level NUMBER Optional
87: -- Default = FND_API.G_VALID_LEVEL_FULL
88: -- p_routing_rec ROUTING_REC_TYPE Default = G_MISS_ROUTING_REC
89: -- .
90: -- OUT :
91: -- x_return_status VARCHAR2(1)

Line 110: -- p_init_msg_list VARCHAR2 Optional Default = FND_API.G_FALSE

106: -- Pre-reqs : None.
107: -- Parameters :
108: -- IN :
109: -- p_api_version NUMBER Required
110: -- p_init_msg_list VARCHAR2 Optional Default = FND_API.G_FALSE
111: -- p_commit VARCHAR2 Optional Default = FND_API.G_FALSE
112: -- p_validation_level NUMBER Optional
113: -- Default = FND_API.G_VALID_LEVEL_FULL
114: -- p_delete_group VARCHAR2

Line 111: -- p_commit VARCHAR2 Optional Default = FND_API.G_FALSE

107: -- Parameters :
108: -- IN :
109: -- p_api_version NUMBER Required
110: -- p_init_msg_list VARCHAR2 Optional Default = FND_API.G_FALSE
111: -- p_commit VARCHAR2 Optional Default = FND_API.G_FALSE
112: -- p_validation_level NUMBER Optional
113: -- Default = FND_API.G_VALID_LEVEL_FULL
114: -- p_delete_group VARCHAR2
115: -- p_description VARCHAR2 Default = Null

Line 113: -- Default = FND_API.G_VALID_LEVEL_FULL

109: -- p_api_version NUMBER Required
110: -- p_init_msg_list VARCHAR2 Optional Default = FND_API.G_FALSE
111: -- p_commit VARCHAR2 Optional Default = FND_API.G_FALSE
112: -- p_validation_level NUMBER Optional
113: -- Default = FND_API.G_VALID_LEVEL_FULL
114: -- p_delete_group VARCHAR2
115: -- p_description VARCHAR2 Default = Null
116: -- p_routing_rec ROUTING_REC_TYPE Default = G_MISS_ROUTING_REC,
117: -- .

Line 132: routing_sequence_id NUMBER := FND_API.G_MISS_NUM,

128: -- Notes : Full validation level includes AssignRouting
129: --
130: -- End of comments
131: TYPE routing_rec_type is record(
132: routing_sequence_id NUMBER := FND_API.G_MISS_NUM,
133: assembly_item_id NUMBER := FND_API.G_MISS_NUM,
134: assembly_item_number VARCHAR2(81) := FND_API.G_MISS_CHAR,
135: organization_id NUMBER := FND_API.G_MISS_NUM,
136: organization_code VARCHAR2(3) := FND_API.G_MISS_CHAR,

Line 133: assembly_item_id NUMBER := FND_API.G_MISS_NUM,

129: --
130: -- End of comments
131: TYPE routing_rec_type is record(
132: routing_sequence_id NUMBER := FND_API.G_MISS_NUM,
133: assembly_item_id NUMBER := FND_API.G_MISS_NUM,
134: assembly_item_number VARCHAR2(81) := FND_API.G_MISS_CHAR,
135: organization_id NUMBER := FND_API.G_MISS_NUM,
136: organization_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
137: alternate_routing_designator VARCHAR2(10) := FND_API.G_MISS_CHAR,

Line 134: assembly_item_number VARCHAR2(81) := FND_API.G_MISS_CHAR,

130: -- End of comments
131: TYPE routing_rec_type is record(
132: routing_sequence_id NUMBER := FND_API.G_MISS_NUM,
133: assembly_item_id NUMBER := FND_API.G_MISS_NUM,
134: assembly_item_number VARCHAR2(81) := FND_API.G_MISS_CHAR,
135: organization_id NUMBER := FND_API.G_MISS_NUM,
136: organization_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
137: alternate_routing_designator VARCHAR2(10) := FND_API.G_MISS_CHAR,
138: routing_type NUMBER := FND_API.G_MISS_NUM,

Line 135: organization_id NUMBER := FND_API.G_MISS_NUM,

131: TYPE routing_rec_type is record(
132: routing_sequence_id NUMBER := FND_API.G_MISS_NUM,
133: assembly_item_id NUMBER := FND_API.G_MISS_NUM,
134: assembly_item_number VARCHAR2(81) := FND_API.G_MISS_CHAR,
135: organization_id NUMBER := FND_API.G_MISS_NUM,
136: organization_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
137: alternate_routing_designator VARCHAR2(10) := FND_API.G_MISS_CHAR,
138: routing_type NUMBER := FND_API.G_MISS_NUM,
139: common_assembly_item_id NUMBER := FND_API.G_MISS_NUM,

Line 136: organization_code VARCHAR2(3) := FND_API.G_MISS_CHAR,

132: routing_sequence_id NUMBER := FND_API.G_MISS_NUM,
133: assembly_item_id NUMBER := FND_API.G_MISS_NUM,
134: assembly_item_number VARCHAR2(81) := FND_API.G_MISS_CHAR,
135: organization_id NUMBER := FND_API.G_MISS_NUM,
136: organization_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
137: alternate_routing_designator VARCHAR2(10) := FND_API.G_MISS_CHAR,
138: routing_type NUMBER := FND_API.G_MISS_NUM,
139: common_assembly_item_id NUMBER := FND_API.G_MISS_NUM,
140: common_item_number VARCHAR2(81) := FND_API.G_MISS_CHAR,

Line 137: alternate_routing_designator VARCHAR2(10) := FND_API.G_MISS_CHAR,

133: assembly_item_id NUMBER := FND_API.G_MISS_NUM,
134: assembly_item_number VARCHAR2(81) := FND_API.G_MISS_CHAR,
135: organization_id NUMBER := FND_API.G_MISS_NUM,
136: organization_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
137: alternate_routing_designator VARCHAR2(10) := FND_API.G_MISS_CHAR,
138: routing_type NUMBER := FND_API.G_MISS_NUM,
139: common_assembly_item_id NUMBER := FND_API.G_MISS_NUM,
140: common_item_number VARCHAR2(81) := FND_API.G_MISS_CHAR,
141: common_routing_sequence_id NUMBER := FND_API.G_MISS_NUM,

Line 138: routing_type NUMBER := FND_API.G_MISS_NUM,

134: assembly_item_number VARCHAR2(81) := FND_API.G_MISS_CHAR,
135: organization_id NUMBER := FND_API.G_MISS_NUM,
136: organization_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
137: alternate_routing_designator VARCHAR2(10) := FND_API.G_MISS_CHAR,
138: routing_type NUMBER := FND_API.G_MISS_NUM,
139: common_assembly_item_id NUMBER := FND_API.G_MISS_NUM,
140: common_item_number VARCHAR2(81) := FND_API.G_MISS_CHAR,
141: common_routing_sequence_id NUMBER := FND_API.G_MISS_NUM,
142: routing_comment VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 139: common_assembly_item_id NUMBER := FND_API.G_MISS_NUM,

135: organization_id NUMBER := FND_API.G_MISS_NUM,
136: organization_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
137: alternate_routing_designator VARCHAR2(10) := FND_API.G_MISS_CHAR,
138: routing_type NUMBER := FND_API.G_MISS_NUM,
139: common_assembly_item_id NUMBER := FND_API.G_MISS_NUM,
140: common_item_number VARCHAR2(81) := FND_API.G_MISS_CHAR,
141: common_routing_sequence_id NUMBER := FND_API.G_MISS_NUM,
142: routing_comment VARCHAR2(240) := FND_API.G_MISS_CHAR,
143: completion_subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR,

Line 140: common_item_number VARCHAR2(81) := FND_API.G_MISS_CHAR,

136: organization_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
137: alternate_routing_designator VARCHAR2(10) := FND_API.G_MISS_CHAR,
138: routing_type NUMBER := FND_API.G_MISS_NUM,
139: common_assembly_item_id NUMBER := FND_API.G_MISS_NUM,
140: common_item_number VARCHAR2(81) := FND_API.G_MISS_CHAR,
141: common_routing_sequence_id NUMBER := FND_API.G_MISS_NUM,
142: routing_comment VARCHAR2(240) := FND_API.G_MISS_CHAR,
143: completion_subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR,
144: completion_locator_id NUMBER := FND_API.G_MISS_NUM,

Line 141: common_routing_sequence_id NUMBER := FND_API.G_MISS_NUM,

137: alternate_routing_designator VARCHAR2(10) := FND_API.G_MISS_CHAR,
138: routing_type NUMBER := FND_API.G_MISS_NUM,
139: common_assembly_item_id NUMBER := FND_API.G_MISS_NUM,
140: common_item_number VARCHAR2(81) := FND_API.G_MISS_CHAR,
141: common_routing_sequence_id NUMBER := FND_API.G_MISS_NUM,
142: routing_comment VARCHAR2(240) := FND_API.G_MISS_CHAR,
143: completion_subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR,
144: completion_locator_id NUMBER := FND_API.G_MISS_NUM,
145: location_name VARCHAR2(81) := FND_API.G_MISS_CHAR,

Line 142: routing_comment VARCHAR2(240) := FND_API.G_MISS_CHAR,

138: routing_type NUMBER := FND_API.G_MISS_NUM,
139: common_assembly_item_id NUMBER := FND_API.G_MISS_NUM,
140: common_item_number VARCHAR2(81) := FND_API.G_MISS_CHAR,
141: common_routing_sequence_id NUMBER := FND_API.G_MISS_NUM,
142: routing_comment VARCHAR2(240) := FND_API.G_MISS_CHAR,
143: completion_subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR,
144: completion_locator_id NUMBER := FND_API.G_MISS_NUM,
145: location_name VARCHAR2(81) := FND_API.G_MISS_CHAR,
146: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 143: completion_subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR,

139: common_assembly_item_id NUMBER := FND_API.G_MISS_NUM,
140: common_item_number VARCHAR2(81) := FND_API.G_MISS_CHAR,
141: common_routing_sequence_id NUMBER := FND_API.G_MISS_NUM,
142: routing_comment VARCHAR2(240) := FND_API.G_MISS_CHAR,
143: completion_subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR,
144: completion_locator_id NUMBER := FND_API.G_MISS_NUM,
145: location_name VARCHAR2(81) := FND_API.G_MISS_CHAR,
146: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
147: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 144: completion_locator_id NUMBER := FND_API.G_MISS_NUM,

140: common_item_number VARCHAR2(81) := FND_API.G_MISS_CHAR,
141: common_routing_sequence_id NUMBER := FND_API.G_MISS_NUM,
142: routing_comment VARCHAR2(240) := FND_API.G_MISS_CHAR,
143: completion_subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR,
144: completion_locator_id NUMBER := FND_API.G_MISS_NUM,
145: location_name VARCHAR2(81) := FND_API.G_MISS_CHAR,
146: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
147: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 145: location_name VARCHAR2(81) := FND_API.G_MISS_CHAR,

141: common_routing_sequence_id NUMBER := FND_API.G_MISS_NUM,
142: routing_comment VARCHAR2(240) := FND_API.G_MISS_CHAR,
143: completion_subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR,
144: completion_locator_id NUMBER := FND_API.G_MISS_NUM,
145: location_name VARCHAR2(81) := FND_API.G_MISS_CHAR,
146: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
147: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 146: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,

142: routing_comment VARCHAR2(240) := FND_API.G_MISS_CHAR,
143: completion_subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR,
144: completion_locator_id NUMBER := FND_API.G_MISS_NUM,
145: location_name VARCHAR2(81) := FND_API.G_MISS_CHAR,
146: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
147: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 147: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

143: completion_subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR,
144: completion_locator_id NUMBER := FND_API.G_MISS_NUM,
145: location_name VARCHAR2(81) := FND_API.G_MISS_CHAR,
146: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
147: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 148: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

144: completion_locator_id NUMBER := FND_API.G_MISS_NUM,
145: location_name VARCHAR2(81) := FND_API.G_MISS_CHAR,
146: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
147: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 149: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

145: location_name VARCHAR2(81) := FND_API.G_MISS_CHAR,
146: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
147: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 150: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

146: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
147: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 151: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

147: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 152: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

148: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
156: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 153: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

149: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
156: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
157: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 154: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

150: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
156: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
157: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
158: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 155: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

151: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
156: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
157: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
158: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
159: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 156: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

152: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
156: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
157: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
158: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
159: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
160: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 157: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

153: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
156: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
157: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
158: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
159: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
160: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
161: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 158: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

154: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
156: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
157: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
158: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
159: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
160: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
161: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
162: line_id NUMBER := FND_API.G_MISS_NUM,

Line 159: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

155: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
156: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
157: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
158: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
159: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
160: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
161: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
162: line_id NUMBER := FND_API.G_MISS_NUM,
163: line_code VARCHAR2(10) := FND_API.G_MISS_CHAR,

Line 160: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

156: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
157: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
158: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
159: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
160: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
161: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
162: line_id NUMBER := FND_API.G_MISS_NUM,
163: line_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
164: mixed_model_map_flag NUMBER := FND_API.G_MISS_NUM,

Line 161: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,

157: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
158: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
159: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
160: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
161: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
162: line_id NUMBER := FND_API.G_MISS_NUM,
163: line_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
164: mixed_model_map_flag NUMBER := FND_API.G_MISS_NUM,
165: priority NUMBER := FND_API.G_MISS_NUM,

Line 162: line_id NUMBER := FND_API.G_MISS_NUM,

158: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
159: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
160: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
161: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
162: line_id NUMBER := FND_API.G_MISS_NUM,
163: line_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
164: mixed_model_map_flag NUMBER := FND_API.G_MISS_NUM,
165: priority NUMBER := FND_API.G_MISS_NUM,
166: cfm_routing_flag NUMBER := FND_API.G_MISS_NUM,

Line 163: line_code VARCHAR2(10) := FND_API.G_MISS_CHAR,

159: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
160: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
161: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
162: line_id NUMBER := FND_API.G_MISS_NUM,
163: line_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
164: mixed_model_map_flag NUMBER := FND_API.G_MISS_NUM,
165: priority NUMBER := FND_API.G_MISS_NUM,
166: cfm_routing_flag NUMBER := FND_API.G_MISS_NUM,
167: total_product_cycle_time NUMBER := FND_API.G_MISS_NUM,

Line 164: mixed_model_map_flag NUMBER := FND_API.G_MISS_NUM,

160: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
161: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
162: line_id NUMBER := FND_API.G_MISS_NUM,
163: line_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
164: mixed_model_map_flag NUMBER := FND_API.G_MISS_NUM,
165: priority NUMBER := FND_API.G_MISS_NUM,
166: cfm_routing_flag NUMBER := FND_API.G_MISS_NUM,
167: total_product_cycle_time NUMBER := FND_API.G_MISS_NUM,
168: ctp_flag NUMBER := FND_API.G_MISS_NUM,

Line 165: priority NUMBER := FND_API.G_MISS_NUM,

161: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
162: line_id NUMBER := FND_API.G_MISS_NUM,
163: line_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
164: mixed_model_map_flag NUMBER := FND_API.G_MISS_NUM,
165: priority NUMBER := FND_API.G_MISS_NUM,
166: cfm_routing_flag NUMBER := FND_API.G_MISS_NUM,
167: total_product_cycle_time NUMBER := FND_API.G_MISS_NUM,
168: ctp_flag NUMBER := FND_API.G_MISS_NUM,
169: -- Added as part of TTMO enh R12

Line 166: cfm_routing_flag NUMBER := FND_API.G_MISS_NUM,

162: line_id NUMBER := FND_API.G_MISS_NUM,
163: line_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
164: mixed_model_map_flag NUMBER := FND_API.G_MISS_NUM,
165: priority NUMBER := FND_API.G_MISS_NUM,
166: cfm_routing_flag NUMBER := FND_API.G_MISS_NUM,
167: total_product_cycle_time NUMBER := FND_API.G_MISS_NUM,
168: ctp_flag NUMBER := FND_API.G_MISS_NUM,
169: -- Added as part of TTMO enh R12
170: pending_from_ecn VARCHAR2(10) := FND_API.G_MISS_CHAR

Line 167: total_product_cycle_time NUMBER := FND_API.G_MISS_NUM,

163: line_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
164: mixed_model_map_flag NUMBER := FND_API.G_MISS_NUM,
165: priority NUMBER := FND_API.G_MISS_NUM,
166: cfm_routing_flag NUMBER := FND_API.G_MISS_NUM,
167: total_product_cycle_time NUMBER := FND_API.G_MISS_NUM,
168: ctp_flag NUMBER := FND_API.G_MISS_NUM,
169: -- Added as part of TTMO enh R12
170: pending_from_ecn VARCHAR2(10) := FND_API.G_MISS_CHAR
171: );

Line 168: ctp_flag NUMBER := FND_API.G_MISS_NUM,

164: mixed_model_map_flag NUMBER := FND_API.G_MISS_NUM,
165: priority NUMBER := FND_API.G_MISS_NUM,
166: cfm_routing_flag NUMBER := FND_API.G_MISS_NUM,
167: total_product_cycle_time NUMBER := FND_API.G_MISS_NUM,
168: ctp_flag NUMBER := FND_API.G_MISS_NUM,
169: -- Added as part of TTMO enh R12
170: pending_from_ecn VARCHAR2(10) := FND_API.G_MISS_CHAR
171: );
172:

Line 170: pending_from_ecn VARCHAR2(10) := FND_API.G_MISS_CHAR

166: cfm_routing_flag NUMBER := FND_API.G_MISS_NUM,
167: total_product_cycle_time NUMBER := FND_API.G_MISS_NUM,
168: ctp_flag NUMBER := FND_API.G_MISS_NUM,
169: -- Added as part of TTMO enh R12
170: pending_from_ecn VARCHAR2(10) := FND_API.G_MISS_CHAR
171: );
172:
173: G_MISS_ROUTING_REC ROUTING_REC_TYPE;
174: G_VALID_LEVEL_NO_ASSIGN constant number := 5;

Line 178: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

174: G_VALID_LEVEL_NO_ASSIGN constant number := 5;
175:
176: PROCEDURE AssignRouting
177: ( p_api_version IN NUMBER,
178: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
179: p_commit IN VARCHAR2 := FND_API.G_FALSE,
180: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
181: x_return_status IN OUT NOCOPY VARCHAR2,
182: x_msg_count IN OUT NOCOPY NUMBER,

Line 179: p_commit IN VARCHAR2 := FND_API.G_FALSE,

175:
176: PROCEDURE AssignRouting
177: ( p_api_version IN NUMBER,
178: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
179: p_commit IN VARCHAR2 := FND_API.G_FALSE,
180: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
181: x_return_status IN OUT NOCOPY VARCHAR2,
182: x_msg_count IN OUT NOCOPY NUMBER,
183: x_msg_data IN OUT NOCOPY VARCHAR2,

Line 180: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

176: PROCEDURE AssignRouting
177: ( p_api_version IN NUMBER,
178: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
179: p_commit IN VARCHAR2 := FND_API.G_FALSE,
180: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
181: x_return_status IN OUT NOCOPY VARCHAR2,
182: x_msg_count IN OUT NOCOPY NUMBER,
183: x_msg_data IN OUT NOCOPY VARCHAR2,
184: p_routing_rec IN ROUTING_REC_TYPE := G_MISS_ROUTING_REC,

Line 189: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

185: x_routing_rec IN OUT NOCOPY ROUTING_REC_TYPE
186: );
187: PROCEDURE ValidateRouting
188: ( p_api_version IN NUMBER,
189: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
190: p_commit IN VARCHAR2 := FND_API.G_FALSE,
191: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
192: x_return_status IN OUT NOCOPY VARCHAR2,
193: x_msg_count IN OUT NOCOPY NUMBER,

Line 190: p_commit IN VARCHAR2 := FND_API.G_FALSE,

186: );
187: PROCEDURE ValidateRouting
188: ( p_api_version IN NUMBER,
189: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
190: p_commit IN VARCHAR2 := FND_API.G_FALSE,
191: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
192: x_return_status IN OUT NOCOPY VARCHAR2,
193: x_msg_count IN OUT NOCOPY NUMBER,
194: x_msg_data IN OUT NOCOPY VARCHAR2,

Line 191: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

187: PROCEDURE ValidateRouting
188: ( p_api_version IN NUMBER,
189: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
190: p_commit IN VARCHAR2 := FND_API.G_FALSE,
191: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
192: x_return_status IN OUT NOCOPY VARCHAR2,
193: x_msg_count IN OUT NOCOPY NUMBER,
194: x_msg_data IN OUT NOCOPY VARCHAR2,
195: p_routing_rec IN ROUTING_REC_TYPE := G_MISS_ROUTING_REC,

Line 200: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

196: x_routing_rec IN OUT NOCOPY ROUTING_REC_TYPE
197: );
198: PROCEDURE CreateRouting
199: ( p_api_version IN NUMBER,
200: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
201: p_commit IN VARCHAR2 := FND_API.G_FALSE,
202: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
203: x_return_status IN OUT NOCOPY VARCHAR2,
204: x_msg_count IN OUT NOCOPY NUMBER,

Line 201: p_commit IN VARCHAR2 := FND_API.G_FALSE,

197: );
198: PROCEDURE CreateRouting
199: ( p_api_version IN NUMBER,
200: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
201: p_commit IN VARCHAR2 := FND_API.G_FALSE,
202: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
203: x_return_status IN OUT NOCOPY VARCHAR2,
204: x_msg_count IN OUT NOCOPY NUMBER,
205: x_msg_data IN OUT NOCOPY VARCHAR2,

Line 202: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

198: PROCEDURE CreateRouting
199: ( p_api_version IN NUMBER,
200: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
201: p_commit IN VARCHAR2 := FND_API.G_FALSE,
202: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
203: x_return_status IN OUT NOCOPY VARCHAR2,
204: x_msg_count IN OUT NOCOPY NUMBER,
205: x_msg_data IN OUT NOCOPY VARCHAR2,
206: p_routing_rec IN ROUTING_REC_TYPE := G_MISS_ROUTING_REC,

Line 211: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

207: x_routing_rec IN OUT NOCOPY ROUTING_REC_TYPE
208: );
209: PROCEDURE UpdateRouting
210: ( p_api_version IN NUMBER,
211: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
212: p_commit IN VARCHAR2 := FND_API.G_FALSE,
213: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
214: x_return_status IN OUT NOCOPY VARCHAR2,
215: x_msg_count IN OUT NOCOPY NUMBER,

Line 212: p_commit IN VARCHAR2 := FND_API.G_FALSE,

208: );
209: PROCEDURE UpdateRouting
210: ( p_api_version IN NUMBER,
211: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
212: p_commit IN VARCHAR2 := FND_API.G_FALSE,
213: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
214: x_return_status IN OUT NOCOPY VARCHAR2,
215: x_msg_count IN OUT NOCOPY NUMBER,
216: x_msg_data IN OUT NOCOPY VARCHAR2,

Line 213: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

209: PROCEDURE UpdateRouting
210: ( p_api_version IN NUMBER,
211: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
212: p_commit IN VARCHAR2 := FND_API.G_FALSE,
213: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
214: x_return_status IN OUT NOCOPY VARCHAR2,
215: x_msg_count IN OUT NOCOPY NUMBER,
216: x_msg_data IN OUT NOCOPY VARCHAR2,
217: p_routing_rec IN ROUTING_REC_TYPE := G_MISS_ROUTING_REC,

Line 222: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

218: x_routing_rec IN OUT NOCOPY ROUTING_REC_TYPE
219: );
220: PROCEDURE DeleteRouting
221: ( p_api_version IN NUMBER,
222: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
223: p_commit IN VARCHAR2 := FND_API.G_FALSE,
224: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
225: x_return_status IN OUT NOCOPY VARCHAR2,
226: x_msg_count IN OUT NOCOPY NUMBER,

Line 223: p_commit IN VARCHAR2 := FND_API.G_FALSE,

219: );
220: PROCEDURE DeleteRouting
221: ( p_api_version IN NUMBER,
222: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
223: p_commit IN VARCHAR2 := FND_API.G_FALSE,
224: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
225: x_return_status IN OUT NOCOPY VARCHAR2,
226: x_msg_count IN OUT NOCOPY NUMBER,
227: x_msg_data IN OUT NOCOPY VARCHAR2,

Line 224: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

220: PROCEDURE DeleteRouting
221: ( p_api_version IN NUMBER,
222: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
223: p_commit IN VARCHAR2 := FND_API.G_FALSE,
224: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
225: x_return_status IN OUT NOCOPY VARCHAR2,
226: x_msg_count IN OUT NOCOPY NUMBER,
227: x_msg_data IN OUT NOCOPY VARCHAR2,
228: p_delete_group IN VARCHAR2,