16: IS
17: I NUMBER:=0;
18: BEGIN
19:
20: FND_API.g_attr_tbl.DELETE;
21:
22: -- START GEN attributes
23:
24: -- Generator will append new attributes before end generate comment.
23:
24: -- Generator will append new attributes before end generate comment.
25:
26: I := I + 1;
27: FND_API.g_attr_tbl(I).name := 'Desc_Flex';
28: I := I + 1;
29: FND_API.g_attr_tbl(I).name := 'alternate_bom_designator';
30: I := I + 1;
31: FND_API.g_attr_tbl(I).name := 'alternate_routing_desig';
25:
26: I := I + 1;
27: FND_API.g_attr_tbl(I).name := 'Desc_Flex';
28: I := I + 1;
29: FND_API.g_attr_tbl(I).name := 'alternate_bom_designator';
30: I := I + 1;
31: FND_API.g_attr_tbl(I).name := 'alternate_routing_desig';
32: I := I + 1;
33: FND_API.g_attr_tbl(I).name := 'bom_revision';
27: FND_API.g_attr_tbl(I).name := 'Desc_Flex';
28: I := I + 1;
29: FND_API.g_attr_tbl(I).name := 'alternate_bom_designator';
30: I := I + 1;
31: FND_API.g_attr_tbl(I).name := 'alternate_routing_desig';
32: I := I + 1;
33: FND_API.g_attr_tbl(I).name := 'bom_revision';
34: I := I + 1;
35: FND_API.g_attr_tbl(I).name := 'bom_revision_date';
29: FND_API.g_attr_tbl(I).name := 'alternate_bom_designator';
30: I := I + 1;
31: FND_API.g_attr_tbl(I).name := 'alternate_routing_desig';
32: I := I + 1;
33: FND_API.g_attr_tbl(I).name := 'bom_revision';
34: I := I + 1;
35: FND_API.g_attr_tbl(I).name := 'bom_revision_date';
36: I := I + 1;
37: FND_API.g_attr_tbl(I).name := 'build_sequence';
31: FND_API.g_attr_tbl(I).name := 'alternate_routing_desig';
32: I := I + 1;
33: FND_API.g_attr_tbl(I).name := 'bom_revision';
34: I := I + 1;
35: FND_API.g_attr_tbl(I).name := 'bom_revision_date';
36: I := I + 1;
37: FND_API.g_attr_tbl(I).name := 'build_sequence';
38: I := I + 1;
39: FND_API.g_attr_tbl(I).name := 'class';
33: FND_API.g_attr_tbl(I).name := 'bom_revision';
34: I := I + 1;
35: FND_API.g_attr_tbl(I).name := 'bom_revision_date';
36: I := I + 1;
37: FND_API.g_attr_tbl(I).name := 'build_sequence';
38: I := I + 1;
39: FND_API.g_attr_tbl(I).name := 'class';
40: I := I + 1;
41: FND_API.g_attr_tbl(I).name := 'completion_locator';
35: FND_API.g_attr_tbl(I).name := 'bom_revision_date';
36: I := I + 1;
37: FND_API.g_attr_tbl(I).name := 'build_sequence';
38: I := I + 1;
39: FND_API.g_attr_tbl(I).name := 'class';
40: I := I + 1;
41: FND_API.g_attr_tbl(I).name := 'completion_locator';
42: I := I + 1;
43: FND_API.g_attr_tbl(I).name := 'completion_subinventory';
37: FND_API.g_attr_tbl(I).name := 'build_sequence';
38: I := I + 1;
39: FND_API.g_attr_tbl(I).name := 'class';
40: I := I + 1;
41: FND_API.g_attr_tbl(I).name := 'completion_locator';
42: I := I + 1;
43: FND_API.g_attr_tbl(I).name := 'completion_subinventory';
44: I := I + 1;
45: FND_API.g_attr_tbl(I).name := 'created_by';
39: FND_API.g_attr_tbl(I).name := 'class';
40: I := I + 1;
41: FND_API.g_attr_tbl(I).name := 'completion_locator';
42: I := I + 1;
43: FND_API.g_attr_tbl(I).name := 'completion_subinventory';
44: I := I + 1;
45: FND_API.g_attr_tbl(I).name := 'created_by';
46: I := I + 1;
47: FND_API.g_attr_tbl(I).name := 'creation_date';
41: FND_API.g_attr_tbl(I).name := 'completion_locator';
42: I := I + 1;
43: FND_API.g_attr_tbl(I).name := 'completion_subinventory';
44: I := I + 1;
45: FND_API.g_attr_tbl(I).name := 'created_by';
46: I := I + 1;
47: FND_API.g_attr_tbl(I).name := 'creation_date';
48: I := I + 1;
49: FND_API.g_attr_tbl(I).name := 'date_closed';
43: FND_API.g_attr_tbl(I).name := 'completion_subinventory';
44: I := I + 1;
45: FND_API.g_attr_tbl(I).name := 'created_by';
46: I := I + 1;
47: FND_API.g_attr_tbl(I).name := 'creation_date';
48: I := I + 1;
49: FND_API.g_attr_tbl(I).name := 'date_closed';
50: I := I + 1;
51: FND_API.g_attr_tbl(I).name := 'demand_class';
45: FND_API.g_attr_tbl(I).name := 'created_by';
46: I := I + 1;
47: FND_API.g_attr_tbl(I).name := 'creation_date';
48: I := I + 1;
49: FND_API.g_attr_tbl(I).name := 'date_closed';
50: I := I + 1;
51: FND_API.g_attr_tbl(I).name := 'demand_class';
52: I := I + 1;
53: FND_API.g_attr_tbl(I).name := 'demand_source_delivery';
47: FND_API.g_attr_tbl(I).name := 'creation_date';
48: I := I + 1;
49: FND_API.g_attr_tbl(I).name := 'date_closed';
50: I := I + 1;
51: FND_API.g_attr_tbl(I).name := 'demand_class';
52: I := I + 1;
53: FND_API.g_attr_tbl(I).name := 'demand_source_delivery';
54: I := I + 1;
55: FND_API.g_attr_tbl(I).name := 'end_item_unit_number';
49: FND_API.g_attr_tbl(I).name := 'date_closed';
50: I := I + 1;
51: FND_API.g_attr_tbl(I).name := 'demand_class';
52: I := I + 1;
53: FND_API.g_attr_tbl(I).name := 'demand_source_delivery';
54: I := I + 1;
55: FND_API.g_attr_tbl(I).name := 'end_item_unit_number';
56: I := I + 1;
57: FND_API.g_attr_tbl(I).name := 'quantity_scrapped ';
51: FND_API.g_attr_tbl(I).name := 'demand_class';
52: I := I + 1;
53: FND_API.g_attr_tbl(I).name := 'demand_source_delivery';
54: I := I + 1;
55: FND_API.g_attr_tbl(I).name := 'end_item_unit_number';
56: I := I + 1;
57: FND_API.g_attr_tbl(I).name := 'quantity_scrapped ';
58: I := I + 1;
59: FND_API.g_attr_tbl(I).name := 'demand_source_header';
53: FND_API.g_attr_tbl(I).name := 'demand_source_delivery';
54: I := I + 1;
55: FND_API.g_attr_tbl(I).name := 'end_item_unit_number';
56: I := I + 1;
57: FND_API.g_attr_tbl(I).name := 'quantity_scrapped ';
58: I := I + 1;
59: FND_API.g_attr_tbl(I).name := 'demand_source_header';
60: I := I + 1;
61: FND_API.g_attr_tbl(I).name := 'demand_source_line';
55: FND_API.g_attr_tbl(I).name := 'end_item_unit_number';
56: I := I + 1;
57: FND_API.g_attr_tbl(I).name := 'quantity_scrapped ';
58: I := I + 1;
59: FND_API.g_attr_tbl(I).name := 'demand_source_header';
60: I := I + 1;
61: FND_API.g_attr_tbl(I).name := 'demand_source_line';
62: I := I + 1;
63: FND_API.g_attr_tbl(I).name := 'demand_source_type';
57: FND_API.g_attr_tbl(I).name := 'quantity_scrapped ';
58: I := I + 1;
59: FND_API.g_attr_tbl(I).name := 'demand_source_header';
60: I := I + 1;
61: FND_API.g_attr_tbl(I).name := 'demand_source_line';
62: I := I + 1;
63: FND_API.g_attr_tbl(I).name := 'demand_source_type';
64: I := I + 1;
65: FND_API.g_attr_tbl(I).name := 'last_updated_by';
59: FND_API.g_attr_tbl(I).name := 'demand_source_header';
60: I := I + 1;
61: FND_API.g_attr_tbl(I).name := 'demand_source_line';
62: I := I + 1;
63: FND_API.g_attr_tbl(I).name := 'demand_source_type';
64: I := I + 1;
65: FND_API.g_attr_tbl(I).name := 'last_updated_by';
66: I := I + 1;
67: FND_API.g_attr_tbl(I).name := 'last_update_date';
61: FND_API.g_attr_tbl(I).name := 'demand_source_line';
62: I := I + 1;
63: FND_API.g_attr_tbl(I).name := 'demand_source_type';
64: I := I + 1;
65: FND_API.g_attr_tbl(I).name := 'last_updated_by';
66: I := I + 1;
67: FND_API.g_attr_tbl(I).name := 'last_update_date';
68: I := I + 1;
69: FND_API.g_attr_tbl(I).name := 'last_update_login';
63: FND_API.g_attr_tbl(I).name := 'demand_source_type';
64: I := I + 1;
65: FND_API.g_attr_tbl(I).name := 'last_updated_by';
66: I := I + 1;
67: FND_API.g_attr_tbl(I).name := 'last_update_date';
68: I := I + 1;
69: FND_API.g_attr_tbl(I).name := 'last_update_login';
70: I := I + 1;
71: FND_API.g_attr_tbl(I).name := 'line';
65: FND_API.g_attr_tbl(I).name := 'last_updated_by';
66: I := I + 1;
67: FND_API.g_attr_tbl(I).name := 'last_update_date';
68: I := I + 1;
69: FND_API.g_attr_tbl(I).name := 'last_update_login';
70: I := I + 1;
71: FND_API.g_attr_tbl(I).name := 'line';
72: I := I + 1;
73: FND_API.g_attr_tbl(I).name := 'material_account';
67: FND_API.g_attr_tbl(I).name := 'last_update_date';
68: I := I + 1;
69: FND_API.g_attr_tbl(I).name := 'last_update_login';
70: I := I + 1;
71: FND_API.g_attr_tbl(I).name := 'line';
72: I := I + 1;
73: FND_API.g_attr_tbl(I).name := 'material_account';
74: I := I + 1;
75: FND_API.g_attr_tbl(I).name := 'material_overhead_account';
69: FND_API.g_attr_tbl(I).name := 'last_update_login';
70: I := I + 1;
71: FND_API.g_attr_tbl(I).name := 'line';
72: I := I + 1;
73: FND_API.g_attr_tbl(I).name := 'material_account';
74: I := I + 1;
75: FND_API.g_attr_tbl(I).name := 'material_overhead_account';
76: I := I + 1;
77: FND_API.g_attr_tbl(I).name := 'material_variance_account';
71: FND_API.g_attr_tbl(I).name := 'line';
72: I := I + 1;
73: FND_API.g_attr_tbl(I).name := 'material_account';
74: I := I + 1;
75: FND_API.g_attr_tbl(I).name := 'material_overhead_account';
76: I := I + 1;
77: FND_API.g_attr_tbl(I).name := 'material_variance_account';
78: I := I + 1;
79: FND_API.g_attr_tbl(I).name := 'mps_net_quantity';
73: FND_API.g_attr_tbl(I).name := 'material_account';
74: I := I + 1;
75: FND_API.g_attr_tbl(I).name := 'material_overhead_account';
76: I := I + 1;
77: FND_API.g_attr_tbl(I).name := 'material_variance_account';
78: I := I + 1;
79: FND_API.g_attr_tbl(I).name := 'mps_net_quantity';
80: I := I + 1;
81: FND_API.g_attr_tbl(I).name := 'mps_scheduled_comp_date';
75: FND_API.g_attr_tbl(I).name := 'material_overhead_account';
76: I := I + 1;
77: FND_API.g_attr_tbl(I).name := 'material_variance_account';
78: I := I + 1;
79: FND_API.g_attr_tbl(I).name := 'mps_net_quantity';
80: I := I + 1;
81: FND_API.g_attr_tbl(I).name := 'mps_scheduled_comp_date';
82: I := I + 1;
83: FND_API.g_attr_tbl(I).name := 'organization';
77: FND_API.g_attr_tbl(I).name := 'material_variance_account';
78: I := I + 1;
79: FND_API.g_attr_tbl(I).name := 'mps_net_quantity';
80: I := I + 1;
81: FND_API.g_attr_tbl(I).name := 'mps_scheduled_comp_date';
82: I := I + 1;
83: FND_API.g_attr_tbl(I).name := 'organization';
84: I := I + 1;
85: FND_API.g_attr_tbl(I).name := 'outside_processing_acct';
79: FND_API.g_attr_tbl(I).name := 'mps_net_quantity';
80: I := I + 1;
81: FND_API.g_attr_tbl(I).name := 'mps_scheduled_comp_date';
82: I := I + 1;
83: FND_API.g_attr_tbl(I).name := 'organization';
84: I := I + 1;
85: FND_API.g_attr_tbl(I).name := 'outside_processing_acct';
86: I := I + 1;
87: FND_API.g_attr_tbl(I).name := 'outside_proc_var_acct';
81: FND_API.g_attr_tbl(I).name := 'mps_scheduled_comp_date';
82: I := I + 1;
83: FND_API.g_attr_tbl(I).name := 'organization';
84: I := I + 1;
85: FND_API.g_attr_tbl(I).name := 'outside_processing_acct';
86: I := I + 1;
87: FND_API.g_attr_tbl(I).name := 'outside_proc_var_acct';
88: I := I + 1;
89: FND_API.g_attr_tbl(I).name := 'overhead_account';
83: FND_API.g_attr_tbl(I).name := 'organization';
84: I := I + 1;
85: FND_API.g_attr_tbl(I).name := 'outside_processing_acct';
86: I := I + 1;
87: FND_API.g_attr_tbl(I).name := 'outside_proc_var_acct';
88: I := I + 1;
89: FND_API.g_attr_tbl(I).name := 'overhead_account';
90: I := I + 1;
91: FND_API.g_attr_tbl(I).name := 'overhead_variance_account';
85: FND_API.g_attr_tbl(I).name := 'outside_processing_acct';
86: I := I + 1;
87: FND_API.g_attr_tbl(I).name := 'outside_proc_var_acct';
88: I := I + 1;
89: FND_API.g_attr_tbl(I).name := 'overhead_account';
90: I := I + 1;
91: FND_API.g_attr_tbl(I).name := 'overhead_variance_account';
92: I := I + 1;
93: FND_API.g_attr_tbl(I).name := 'planned_quantity';
87: FND_API.g_attr_tbl(I).name := 'outside_proc_var_acct';
88: I := I + 1;
89: FND_API.g_attr_tbl(I).name := 'overhead_account';
90: I := I + 1;
91: FND_API.g_attr_tbl(I).name := 'overhead_variance_account';
92: I := I + 1;
93: FND_API.g_attr_tbl(I).name := 'planned_quantity';
94: I := I + 1;
95: FND_API.g_attr_tbl(I).name := 'primary_item';
89: FND_API.g_attr_tbl(I).name := 'overhead_account';
90: I := I + 1;
91: FND_API.g_attr_tbl(I).name := 'overhead_variance_account';
92: I := I + 1;
93: FND_API.g_attr_tbl(I).name := 'planned_quantity';
94: I := I + 1;
95: FND_API.g_attr_tbl(I).name := 'primary_item';
96: I := I + 1;
97: FND_API.g_attr_tbl(I).name := 'program_application';
91: FND_API.g_attr_tbl(I).name := 'overhead_variance_account';
92: I := I + 1;
93: FND_API.g_attr_tbl(I).name := 'planned_quantity';
94: I := I + 1;
95: FND_API.g_attr_tbl(I).name := 'primary_item';
96: I := I + 1;
97: FND_API.g_attr_tbl(I).name := 'program_application';
98: I := I + 1;
99: FND_API.g_attr_tbl(I).name := 'program';
93: FND_API.g_attr_tbl(I).name := 'planned_quantity';
94: I := I + 1;
95: FND_API.g_attr_tbl(I).name := 'primary_item';
96: I := I + 1;
97: FND_API.g_attr_tbl(I).name := 'program_application';
98: I := I + 1;
99: FND_API.g_attr_tbl(I).name := 'program';
100: I := I + 1;
101: FND_API.g_attr_tbl(I).name := 'program_update_date';
95: FND_API.g_attr_tbl(I).name := 'primary_item';
96: I := I + 1;
97: FND_API.g_attr_tbl(I).name := 'program_application';
98: I := I + 1;
99: FND_API.g_attr_tbl(I).name := 'program';
100: I := I + 1;
101: FND_API.g_attr_tbl(I).name := 'program_update_date';
102: I := I + 1;
103: FND_API.g_attr_tbl(I).name := 'project';
97: FND_API.g_attr_tbl(I).name := 'program_application';
98: I := I + 1;
99: FND_API.g_attr_tbl(I).name := 'program';
100: I := I + 1;
101: FND_API.g_attr_tbl(I).name := 'program_update_date';
102: I := I + 1;
103: FND_API.g_attr_tbl(I).name := 'project';
104: I := I + 1;
105: FND_API.g_attr_tbl(I).name := 'quantity_completed';
99: FND_API.g_attr_tbl(I).name := 'program';
100: I := I + 1;
101: FND_API.g_attr_tbl(I).name := 'program_update_date';
102: I := I + 1;
103: FND_API.g_attr_tbl(I).name := 'project';
104: I := I + 1;
105: FND_API.g_attr_tbl(I).name := 'quantity_completed';
106: I := I + 1;
107: FND_API.g_attr_tbl(I).name := 'request';
101: FND_API.g_attr_tbl(I).name := 'program_update_date';
102: I := I + 1;
103: FND_API.g_attr_tbl(I).name := 'project';
104: I := I + 1;
105: FND_API.g_attr_tbl(I).name := 'quantity_completed';
106: I := I + 1;
107: FND_API.g_attr_tbl(I).name := 'request';
108: I := I + 1;
109: FND_API.g_attr_tbl(I).name := 'resource_account';
103: FND_API.g_attr_tbl(I).name := 'project';
104: I := I + 1;
105: FND_API.g_attr_tbl(I).name := 'quantity_completed';
106: I := I + 1;
107: FND_API.g_attr_tbl(I).name := 'request';
108: I := I + 1;
109: FND_API.g_attr_tbl(I).name := 'resource_account';
110: I := I + 1;
111: FND_API.g_attr_tbl(I).name := 'resource_variance_account';
105: FND_API.g_attr_tbl(I).name := 'quantity_completed';
106: I := I + 1;
107: FND_API.g_attr_tbl(I).name := 'request';
108: I := I + 1;
109: FND_API.g_attr_tbl(I).name := 'resource_account';
110: I := I + 1;
111: FND_API.g_attr_tbl(I).name := 'resource_variance_account';
112: I := I + 1;
113: FND_API.g_attr_tbl(I).name := 'routing_revision';
107: FND_API.g_attr_tbl(I).name := 'request';
108: I := I + 1;
109: FND_API.g_attr_tbl(I).name := 'resource_account';
110: I := I + 1;
111: FND_API.g_attr_tbl(I).name := 'resource_variance_account';
112: I := I + 1;
113: FND_API.g_attr_tbl(I).name := 'routing_revision';
114: I := I + 1;
115: FND_API.g_attr_tbl(I).name := 'routing_revision_date';
109: FND_API.g_attr_tbl(I).name := 'resource_account';
110: I := I + 1;
111: FND_API.g_attr_tbl(I).name := 'resource_variance_account';
112: I := I + 1;
113: FND_API.g_attr_tbl(I).name := 'routing_revision';
114: I := I + 1;
115: FND_API.g_attr_tbl(I).name := 'routing_revision_date';
116: I := I + 1;
117: FND_API.g_attr_tbl(I).name := 'scheduled_completion_date';
111: FND_API.g_attr_tbl(I).name := 'resource_variance_account';
112: I := I + 1;
113: FND_API.g_attr_tbl(I).name := 'routing_revision';
114: I := I + 1;
115: FND_API.g_attr_tbl(I).name := 'routing_revision_date';
116: I := I + 1;
117: FND_API.g_attr_tbl(I).name := 'scheduled_completion_date';
118: I := I + 1;
119: FND_API.g_attr_tbl(I).name := 'scheduled';
113: FND_API.g_attr_tbl(I).name := 'routing_revision';
114: I := I + 1;
115: FND_API.g_attr_tbl(I).name := 'routing_revision_date';
116: I := I + 1;
117: FND_API.g_attr_tbl(I).name := 'scheduled_completion_date';
118: I := I + 1;
119: FND_API.g_attr_tbl(I).name := 'scheduled';
120: I := I + 1;
121: FND_API.g_attr_tbl(I).name := 'scheduled_start_date';
115: FND_API.g_attr_tbl(I).name := 'routing_revision_date';
116: I := I + 1;
117: FND_API.g_attr_tbl(I).name := 'scheduled_completion_date';
118: I := I + 1;
119: FND_API.g_attr_tbl(I).name := 'scheduled';
120: I := I + 1;
121: FND_API.g_attr_tbl(I).name := 'scheduled_start_date';
122: I := I + 1;
123: FND_API.g_attr_tbl(I).name := 'schedule_group';
117: FND_API.g_attr_tbl(I).name := 'scheduled_completion_date';
118: I := I + 1;
119: FND_API.g_attr_tbl(I).name := 'scheduled';
120: I := I + 1;
121: FND_API.g_attr_tbl(I).name := 'scheduled_start_date';
122: I := I + 1;
123: FND_API.g_attr_tbl(I).name := 'schedule_group';
124: I := I + 1;
125: FND_API.g_attr_tbl(I).name := 'schedule_number';
119: FND_API.g_attr_tbl(I).name := 'scheduled';
120: I := I + 1;
121: FND_API.g_attr_tbl(I).name := 'scheduled_start_date';
122: I := I + 1;
123: FND_API.g_attr_tbl(I).name := 'schedule_group';
124: I := I + 1;
125: FND_API.g_attr_tbl(I).name := 'schedule_number';
126: I := I + 1;
127: FND_API.g_attr_tbl(I).name := 'status';
121: FND_API.g_attr_tbl(I).name := 'scheduled_start_date';
122: I := I + 1;
123: FND_API.g_attr_tbl(I).name := 'schedule_group';
124: I := I + 1;
125: FND_API.g_attr_tbl(I).name := 'schedule_number';
126: I := I + 1;
127: FND_API.g_attr_tbl(I).name := 'status';
128: I := I + 1;
129: FND_API.g_attr_tbl(I).name := 'std_cost_adjustment_acct';
123: FND_API.g_attr_tbl(I).name := 'schedule_group';
124: I := I + 1;
125: FND_API.g_attr_tbl(I).name := 'schedule_number';
126: I := I + 1;
127: FND_API.g_attr_tbl(I).name := 'status';
128: I := I + 1;
129: FND_API.g_attr_tbl(I).name := 'std_cost_adjustment_acct';
130: I := I + 1;
131: FND_API.g_attr_tbl(I).name := 'task';
125: FND_API.g_attr_tbl(I).name := 'schedule_number';
126: I := I + 1;
127: FND_API.g_attr_tbl(I).name := 'status';
128: I := I + 1;
129: FND_API.g_attr_tbl(I).name := 'std_cost_adjustment_acct';
130: I := I + 1;
131: FND_API.g_attr_tbl(I).name := 'task';
132: I := I + 1;
133: FND_API.g_attr_tbl(I).name := 'wip_entity';
127: FND_API.g_attr_tbl(I).name := 'status';
128: I := I + 1;
129: FND_API.g_attr_tbl(I).name := 'std_cost_adjustment_acct';
130: I := I + 1;
131: FND_API.g_attr_tbl(I).name := 'task';
132: I := I + 1;
133: FND_API.g_attr_tbl(I).name := 'wip_entity';
134:
135: I := I + 1;
129: FND_API.g_attr_tbl(I).name := 'std_cost_adjustment_acct';
130: I := I + 1;
131: FND_API.g_attr_tbl(I).name := 'task';
132: I := I + 1;
133: FND_API.g_attr_tbl(I).name := 'wip_entity';
134:
135: I := I + 1;
136: FND_API.g_attr_tbl(I).name := 'Assignment_Set';
137: I := I + 1;
132: I := I + 1;
133: FND_API.g_attr_tbl(I).name := 'wip_entity';
134:
135: I := I + 1;
136: FND_API.g_attr_tbl(I).name := 'Assignment_Set';
137: I := I + 1;
138: FND_API.g_attr_tbl(I).name := 'Assignment';
139: I := I + 1;
140: FND_API.g_attr_tbl(I).name := 'Sourcing_Rule';
134:
135: I := I + 1;
136: FND_API.g_attr_tbl(I).name := 'Assignment_Set';
137: I := I + 1;
138: FND_API.g_attr_tbl(I).name := 'Assignment';
139: I := I + 1;
140: FND_API.g_attr_tbl(I).name := 'Sourcing_Rule';
141: I := I + 1;
142: FND_API.g_attr_tbl(I).name := 'Receiving_Org';
136: FND_API.g_attr_tbl(I).name := 'Assignment_Set';
137: I := I + 1;
138: FND_API.g_attr_tbl(I).name := 'Assignment';
139: I := I + 1;
140: FND_API.g_attr_tbl(I).name := 'Sourcing_Rule';
141: I := I + 1;
142: FND_API.g_attr_tbl(I).name := 'Receiving_Org';
143: I := I + 1;
144: FND_API.g_attr_tbl(I).name := 'Shipping_Org';
138: FND_API.g_attr_tbl(I).name := 'Assignment';
139: I := I + 1;
140: FND_API.g_attr_tbl(I).name := 'Sourcing_Rule';
141: I := I + 1;
142: FND_API.g_attr_tbl(I).name := 'Receiving_Org';
143: I := I + 1;
144: FND_API.g_attr_tbl(I).name := 'Shipping_Org';
145: -- END GEN attributes
146:
140: FND_API.g_attr_tbl(I).name := 'Sourcing_Rule';
141: I := I + 1;
142: FND_API.g_attr_tbl(I).name := 'Receiving_Org';
143: I := I + 1;
144: FND_API.g_attr_tbl(I).name := 'Shipping_Org';
145: -- END GEN attributes
146:
147: END Get_Attr_Tbl;
148:
192: ELSE
193:
194: -- In case of an unexpected error raise an exception.
195:
196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
197:
198: END IF;
199:
200: END IF;
210: l_dummy VARCHAR2(10);
211: BEGIN
212:
213: IF p_alternate_bom_designator IS NULL OR
214: p_alternate_bom_designator = FND_API.G_MISS_CHAR
215: THEN
216: RETURN TRUE;
217: END IF;
218:
247: , 'Alternate_Bom_Designator'
248: );
249: END IF;
250:
251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
252:
253: END Alternate_Bom_Designator;
254:
255: FUNCTION Alternate_Routing_Desig ( p_alternate_routing_desig IN VARCHAR2 )
258: l_dummy VARCHAR2(10);
259: BEGIN
260:
261: IF p_alternate_routing_desig IS NULL OR
262: p_alternate_routing_desig = FND_API.G_MISS_CHAR
263: THEN
264: RETURN TRUE;
265: END IF;
266:
295: , 'Alternate_Routing_Desig'
296: );
297: END IF;
298:
299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
300:
301: END Alternate_Routing_Desig;
302:
303: FUNCTION Bom_Revision ( p_bom_revision IN VARCHAR2 )
306: l_dummy VARCHAR2(10);
307: BEGIN
308:
309: IF p_bom_revision IS NULL OR
310: p_bom_revision = FND_API.G_MISS_CHAR
311: THEN
312: RETURN TRUE;
313: END IF;
314:
343: , 'Bom_Revision'
344: );
345: END IF;
346:
347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
348:
349: END Bom_Revision;
350:
351: FUNCTION Bom_Revision_Date ( p_bom_revision_date IN DATE )
354: l_dummy VARCHAR2(10);
355: BEGIN
356:
357: IF p_bom_revision_date IS NULL OR
358: p_bom_revision_date = FND_API.G_MISS_DATE
359: THEN
360: RETURN TRUE;
361: END IF;
362:
391: , 'Bom_Revision_Date'
392: );
393: END IF;
394:
395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
396:
397: END Bom_Revision_Date;
398:
399: FUNCTION Build_Sequence ( p_build_sequence IN NUMBER )
402: l_dummy VARCHAR2(10);
403: BEGIN
404:
405: IF p_build_sequence IS NULL OR
406: p_build_sequence = FND_API.G_MISS_NUM
407: THEN
408: RETURN TRUE;
409: END IF;
410:
439: , 'Build_Sequence'
440: );
441: END IF;
442:
443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
444:
445: END Build_Sequence;
446:
447: FUNCTION Class ( p_class_code IN VARCHAR2 )
450: l_dummy VARCHAR2(10);
451: BEGIN
452:
453: IF p_class_code IS NULL OR
454: p_class_code = FND_API.G_MISS_CHAR
455: THEN
456: RETURN TRUE;
457: END IF;
458:
487: , 'Class'
488: );
489: END IF;
490:
491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
492:
493: END Class;
494:
495: FUNCTION Completion_Locator ( p_completion_locator_id IN NUMBER )
498: l_dummy VARCHAR2(10);
499: BEGIN
500:
501: IF p_completion_locator_id IS NULL OR
502: p_completion_locator_id = FND_API.G_MISS_NUM
503: THEN
504: RETURN TRUE;
505: END IF;
506:
535: , 'Completion_Locator'
536: );
537: END IF;
538:
539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
540:
541: END Completion_Locator;
542:
543: FUNCTION Completion_Subinventory ( p_completion_subinventory IN VARCHAR2 )
546: l_dummy VARCHAR2(10);
547: BEGIN
548:
549: IF p_completion_subinventory IS NULL OR
550: p_completion_subinventory = FND_API.G_MISS_CHAR
551: THEN
552: RETURN TRUE;
553: END IF;
554:
583: , 'Completion_Subinventory'
584: );
585: END IF;
586:
587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
588:
589: END Completion_Subinventory;
590:
591: FUNCTION Created_By ( p_created_by IN NUMBER )
594: l_dummy VARCHAR2(10);
595: BEGIN
596:
597: IF p_created_by IS NULL OR
598: p_created_by = FND_API.G_MISS_NUM
599: THEN
600: RETURN TRUE;
601: END IF;
602:
631: , 'Created_By'
632: );
633: END IF;
634:
635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
636:
637: END Created_By;
638:
639: FUNCTION Creation_Date ( p_creation_date IN DATE )
642: l_dummy VARCHAR2(10);
643: BEGIN
644:
645: IF p_creation_date IS NULL OR
646: p_creation_date = FND_API.G_MISS_DATE
647: THEN
648: RETURN TRUE;
649: END IF;
650:
679: , 'Creation_Date'
680: );
681: END IF;
682:
683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
684:
685: END Creation_Date;
686:
687: FUNCTION Date_Closed ( p_date_closed IN DATE )
690: l_dummy VARCHAR2(10);
691: BEGIN
692:
693: IF p_date_closed IS NULL OR
694: p_date_closed = FND_API.G_MISS_DATE
695: THEN
696: RETURN TRUE;
697: END IF;
698:
727: , 'Date_Closed'
728: );
729: END IF;
730:
731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
732:
733: END Date_Closed;
734:
735: FUNCTION Demand_Class ( p_demand_class IN VARCHAR2 )
738: l_dummy VARCHAR2(10);
739: BEGIN
740:
741: IF p_demand_class IS NULL OR
742: p_demand_class = FND_API.G_MISS_CHAR
743: THEN
744: RETURN TRUE;
745: END IF;
746:
779: , 'Demand_Class'
780: );
781: END IF;
782:
783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
784:
785: END Demand_Class;
786:
787: FUNCTION Demand_Source_Delivery ( p_demand_source_delivery IN VARCHAR2 )
790: l_dummy VARCHAR2(10);
791: BEGIN
792:
793: IF p_demand_source_delivery IS NULL OR
794: p_demand_source_delivery = FND_API.G_MISS_CHAR
795: THEN
796: RETURN TRUE;
797: END IF;
798:
827: , 'Demand_Source_Delivery'
828: );
829: END IF;
830:
831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
832:
833: END Demand_Source_Delivery;
834:
835: FUNCTION Demand_Source_Header ( p_demand_source_header_id IN NUMBER )
838: l_dummy VARCHAR2(10);
839: BEGIN
840:
841: IF p_demand_source_header_id IS NULL OR
842: p_demand_source_header_id = FND_API.G_MISS_NUM
843: THEN
844: RETURN TRUE;
845: END IF;
846:
875: , 'Demand_Source_Header'
876: );
877: END IF;
878:
879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
880:
881: END Demand_Source_Header;
882:
883: FUNCTION Demand_Source_Line ( p_demand_source_line IN VARCHAR2 )
886: l_dummy VARCHAR2(10);
887: BEGIN
888:
889: IF p_demand_source_line IS NULL OR
890: p_demand_source_line = FND_API.G_MISS_CHAR
891: THEN
892: RETURN TRUE;
893: END IF;
894:
923: , 'Demand_Source_Line'
924: );
925: END IF;
926:
927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
928:
929: END Demand_Source_Line;
930:
931: FUNCTION Demand_Source_Type ( p_demand_source_type IN NUMBER )
934: l_dummy VARCHAR2(10);
935: BEGIN
936:
937: IF p_demand_source_type IS NULL OR
938: p_demand_source_type = FND_API.G_MISS_NUM
939: THEN
940: RETURN TRUE;
941: END IF;
942:
975: , 'Demand_Source_Type'
976: );
977: END IF;
978:
979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
980:
981: END Demand_Source_Type;
982:
983: FUNCTION Last_Updated_By ( p_last_updated_by IN NUMBER )
986: l_dummy VARCHAR2(10);
987: BEGIN
988:
989: IF p_last_updated_by IS NULL OR
990: p_last_updated_by = FND_API.G_MISS_NUM
991: THEN
992: RETURN TRUE;
993: END IF;
994:
1023: , 'Last_Updated_By'
1024: );
1025: END IF;
1026:
1027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1028:
1029: END Last_Updated_By;
1030:
1031: FUNCTION Last_Update_Date ( p_last_update_date IN DATE )
1034: l_dummy VARCHAR2(10);
1035: BEGIN
1036:
1037: IF p_last_update_date IS NULL OR
1038: p_last_update_date = FND_API.G_MISS_DATE
1039: THEN
1040: RETURN TRUE;
1041: END IF;
1042:
1071: , 'Last_Update_Date'
1072: );
1073: END IF;
1074:
1075: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1076:
1077: END Last_Update_Date;
1078:
1079: FUNCTION Last_Update_Login ( p_last_update_login IN NUMBER )
1082: l_dummy VARCHAR2(10);
1083: BEGIN
1084:
1085: IF p_last_update_login IS NULL OR
1086: p_last_update_login = FND_API.G_MISS_NUM
1087: THEN
1088: RETURN TRUE;
1089: END IF;
1090:
1119: , 'Last_Update_Login'
1120: );
1121: END IF;
1122:
1123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1124:
1125: END Last_Update_Login;
1126:
1127: FUNCTION Line ( p_line_id IN NUMBER )
1130: l_dummy VARCHAR2(10);
1131: BEGIN
1132:
1133: IF p_line_id IS NULL OR
1134: p_line_id = FND_API.G_MISS_NUM
1135: THEN
1136: RETURN TRUE;
1137: END IF;
1138:
1167: , 'Line'
1168: );
1169: END IF;
1170:
1171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1172:
1173: END Line;
1174:
1175: FUNCTION Material_Account ( p_material_account IN NUMBER )
1178: l_dummy VARCHAR2(10);
1179: BEGIN
1180:
1181: IF p_material_account IS NULL OR
1182: p_material_account = FND_API.G_MISS_NUM
1183: THEN
1184: RETURN TRUE;
1185: END IF;
1186:
1215: , 'Material_Account'
1216: );
1217: END IF;
1218:
1219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1220:
1221: END Material_Account;
1222:
1223: FUNCTION Material_Overhead_Account ( p_material_overhead_account IN NUMBER )
1226: l_dummy VARCHAR2(10);
1227: BEGIN
1228:
1229: IF p_material_overhead_account IS NULL OR
1230: p_material_overhead_account = FND_API.G_MISS_NUM
1231: THEN
1232: RETURN TRUE;
1233: END IF;
1234:
1263: , 'Material_Overhead_Account'
1264: );
1265: END IF;
1266:
1267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1268:
1269: END Material_Overhead_Account;
1270:
1271: FUNCTION Material_Variance_Account ( p_material_variance_account IN NUMBER )
1274: l_dummy VARCHAR2(10);
1275: BEGIN
1276:
1277: IF p_material_variance_account IS NULL OR
1278: p_material_variance_account = FND_API.G_MISS_NUM
1279: THEN
1280: RETURN TRUE;
1281: END IF;
1282:
1311: , 'Material_Variance_Account'
1312: );
1313: END IF;
1314:
1315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1316:
1317: END Material_Variance_Account;
1318:
1319: FUNCTION Mps_Net_Quantity ( p_mps_net_quantity IN NUMBER )
1322: l_dummy VARCHAR2(10);
1323: BEGIN
1324:
1325: IF p_mps_net_quantity IS NULL OR
1326: p_mps_net_quantity = FND_API.G_MISS_NUM
1327: THEN
1328: RETURN TRUE;
1329: END IF;
1330:
1359: , 'Mps_Net_Quantity'
1360: );
1361: END IF;
1362:
1363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1364:
1365: END Mps_Net_Quantity;
1366:
1367: FUNCTION Mps_Scheduled_Comp_Date ( p_mps_scheduled_comp_date IN DATE )
1370: l_dummy VARCHAR2(10);
1371: BEGIN
1372:
1373: IF p_mps_scheduled_comp_date IS NULL OR
1374: p_mps_scheduled_comp_date = FND_API.G_MISS_DATE
1375: THEN
1376: RETURN TRUE;
1377: END IF;
1378:
1407: , 'Mps_Scheduled_Comp_Date'
1408: );
1409: END IF;
1410:
1411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1412:
1413: END Mps_Scheduled_Comp_Date;
1414:
1415: FUNCTION Organization ( p_organization_id IN NUMBER )
1418: l_dummy VARCHAR2(10);
1419: BEGIN
1420:
1421: IF p_organization_id IS NULL OR
1422: p_organization_id = FND_API.G_MISS_NUM
1423: THEN
1424: RETURN TRUE;
1425: END IF;
1426:
1455: , 'Organization'
1456: );
1457: END IF;
1458:
1459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1460:
1461: END Organization;
1462:
1463: FUNCTION Outside_Processing_Acct ( p_outside_processing_acct IN NUMBER )
1466: l_dummy VARCHAR2(10);
1467: BEGIN
1468:
1469: IF p_outside_processing_acct IS NULL OR
1470: p_outside_processing_acct = FND_API.G_MISS_NUM
1471: THEN
1472: RETURN TRUE;
1473: END IF;
1474:
1503: , 'Outside_Processing_Acct'
1504: );
1505: END IF;
1506:
1507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1508:
1509: END Outside_Processing_Acct;
1510:
1511: FUNCTION Outside_Proc_Var_Acct ( p_outside_proc_var_acct IN NUMBER )
1514: l_dummy VARCHAR2(10);
1515: BEGIN
1516:
1517: IF p_outside_proc_var_acct IS NULL OR
1518: p_outside_proc_var_acct = FND_API.G_MISS_NUM
1519: THEN
1520: RETURN TRUE;
1521: END IF;
1522:
1551: , 'Outside_Proc_Var_Acct'
1552: );
1553: END IF;
1554:
1555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1556:
1557: END Outside_Proc_Var_Acct;
1558:
1559: FUNCTION Overhead_Account ( p_overhead_account IN NUMBER )
1562: l_dummy VARCHAR2(10);
1563: BEGIN
1564:
1565: IF p_overhead_account IS NULL OR
1566: p_overhead_account = FND_API.G_MISS_NUM
1567: THEN
1568: RETURN TRUE;
1569: END IF;
1570:
1599: , 'Overhead_Account'
1600: );
1601: END IF;
1602:
1603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1604:
1605: END Overhead_Account;
1606:
1607: FUNCTION Overhead_Variance_Account ( p_overhead_variance_account IN NUMBER )
1610: l_dummy VARCHAR2(10);
1611: BEGIN
1612:
1613: IF p_overhead_variance_account IS NULL OR
1614: p_overhead_variance_account = FND_API.G_MISS_NUM
1615: THEN
1616: RETURN TRUE;
1617: END IF;
1618:
1647: , 'Overhead_Variance_Account'
1648: );
1649: END IF;
1650:
1651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1652:
1653: END Overhead_Variance_Account;
1654:
1655: FUNCTION Planned_Quantity ( p_planned_quantity IN NUMBER )
1658: l_dummy VARCHAR2(10);
1659: BEGIN
1660:
1661: IF p_planned_quantity IS NULL OR
1662: p_planned_quantity = FND_API.G_MISS_NUM
1663: THEN
1664: RETURN TRUE;
1665: END IF;
1666:
1695: , 'Planned_Quantity'
1696: );
1697: END IF;
1698:
1699: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1700:
1701: END Planned_Quantity;
1702:
1703: FUNCTION Primary_Item ( p_primary_item_id IN NUMBER )
1706: l_dummy VARCHAR2(10);
1707: BEGIN
1708:
1709: IF p_primary_item_id IS NULL OR
1710: p_primary_item_id = FND_API.G_MISS_NUM
1711: THEN
1712: RETURN TRUE;
1713: END IF;
1714:
1743: , 'Primary_Item'
1744: );
1745: END IF;
1746:
1747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1748:
1749: END Primary_Item;
1750:
1751: FUNCTION Program_Application ( p_program_application_id IN NUMBER )
1754: l_dummy VARCHAR2(10);
1755: BEGIN
1756:
1757: IF p_program_application_id IS NULL OR
1758: p_program_application_id = FND_API.G_MISS_NUM
1759: THEN
1760: RETURN TRUE;
1761: END IF;
1762:
1791: , 'Program_Application'
1792: );
1793: END IF;
1794:
1795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1796:
1797: END Program_Application;
1798:
1799: FUNCTION Program ( p_program_id IN NUMBER )
1802: l_dummy VARCHAR2(10);
1803: BEGIN
1804:
1805: IF p_program_id IS NULL OR
1806: p_program_id = FND_API.G_MISS_NUM
1807: THEN
1808: RETURN TRUE;
1809: END IF;
1810:
1839: , 'Program'
1840: );
1841: END IF;
1842:
1843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1844:
1845: END Program;
1846:
1847: FUNCTION Program_Update_Date ( p_program_update_date IN DATE )
1850: l_dummy VARCHAR2(10);
1851: BEGIN
1852:
1853: IF p_program_update_date IS NULL OR
1854: p_program_update_date = FND_API.G_MISS_DATE
1855: THEN
1856: RETURN TRUE;
1857: END IF;
1858:
1887: , 'Program_Update_Date'
1888: );
1889: END IF;
1890:
1891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1892:
1893: END Program_Update_Date;
1894:
1895: FUNCTION Project ( p_project_id IN NUMBER )
1898: l_dummy VARCHAR2(10);
1899: BEGIN
1900:
1901: IF p_project_id IS NULL OR
1902: p_project_id = FND_API.G_MISS_NUM
1903: THEN
1904: RETURN TRUE;
1905: END IF;
1906:
1935: , 'Project'
1936: );
1937: END IF;
1938:
1939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1940:
1941: END Project;
1942:
1943: FUNCTION Quantity_Completed ( p_quantity_completed IN NUMBER )
1946: l_dummy VARCHAR2(10);
1947: BEGIN
1948:
1949: IF p_quantity_completed IS NULL OR
1950: p_quantity_completed = FND_API.G_MISS_NUM
1951: THEN
1952: RETURN TRUE;
1953: END IF;
1954:
1983: , 'Quantity_Completed'
1984: );
1985: END IF;
1986:
1987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1988:
1989: END Quantity_Completed;
1990:
1991: FUNCTION Request ( p_request_id IN NUMBER )
1994: l_dummy VARCHAR2(10);
1995: BEGIN
1996:
1997: IF p_request_id IS NULL OR
1998: p_request_id = FND_API.G_MISS_NUM
1999: THEN
2000: RETURN TRUE;
2001: END IF;
2002:
2031: , 'Request'
2032: );
2033: END IF;
2034:
2035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2036:
2037: END Request;
2038:
2039: FUNCTION Resource_Account ( p_resource_account IN NUMBER )
2042: l_dummy VARCHAR2(10);
2043: BEGIN
2044:
2045: IF p_resource_account IS NULL OR
2046: p_resource_account = FND_API.G_MISS_NUM
2047: THEN
2048: RETURN TRUE;
2049: END IF;
2050:
2079: , 'Resource_Account'
2080: );
2081: END IF;
2082:
2083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2084:
2085: END Resource_Account;
2086:
2087: FUNCTION Resource_Variance_Account ( p_resource_variance_account IN NUMBER )
2090: l_dummy VARCHAR2(10);
2091: BEGIN
2092:
2093: IF p_resource_variance_account IS NULL OR
2094: p_resource_variance_account = FND_API.G_MISS_NUM
2095: THEN
2096: RETURN TRUE;
2097: END IF;
2098:
2127: , 'Resource_Variance_Account'
2128: );
2129: END IF;
2130:
2131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2132:
2133: END Resource_Variance_Account;
2134:
2135: FUNCTION Routing_Revision ( p_routing_revision IN VARCHAR2 )
2138: l_dummy VARCHAR2(10);
2139: BEGIN
2140:
2141: IF p_routing_revision IS NULL OR
2142: p_routing_revision = FND_API.G_MISS_CHAR
2143: THEN
2144: RETURN TRUE;
2145: END IF;
2146:
2175: , 'Routing_Revision'
2176: );
2177: END IF;
2178:
2179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2180:
2181: END Routing_Revision;
2182:
2183: FUNCTION Routing_Revision_Date ( p_routing_revision_date IN DATE )
2186: l_dummy VARCHAR2(10);
2187: BEGIN
2188:
2189: IF p_routing_revision_date IS NULL OR
2190: p_routing_revision_date = FND_API.G_MISS_DATE
2191: THEN
2192: RETURN TRUE;
2193: END IF;
2194:
2223: , 'Routing_Revision_Date'
2224: );
2225: END IF;
2226:
2227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2228:
2229: END Routing_Revision_Date;
2230:
2231: FUNCTION Scheduled_Completion_Date ( p_scheduled_completion_date IN DATE )
2234: l_dummy VARCHAR2(10);
2235: BEGIN
2236:
2237: IF p_scheduled_completion_date IS NULL OR
2238: p_scheduled_completion_date = FND_API.G_MISS_DATE
2239: THEN
2240: RETURN TRUE;
2241: END IF;
2242:
2271: , 'Scheduled_Completion_Date'
2272: );
2273: END IF;
2274:
2275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2276:
2277: END Scheduled_Completion_Date;
2278:
2279: FUNCTION Scheduled ( p_scheduled_flag IN NUMBER )
2282: l_dummy VARCHAR2(10);
2283: BEGIN
2284:
2285: IF p_scheduled_flag IS NULL OR
2286: p_scheduled_flag = FND_API.G_MISS_NUM
2287: THEN
2288: RETURN TRUE;
2289: END IF;
2290:
2319: , 'Scheduled'
2320: );
2321: END IF;
2322:
2323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2324:
2325: END Scheduled;
2326:
2327: FUNCTION Scheduled_Start_Date ( p_scheduled_start_date IN DATE )
2330: l_dummy VARCHAR2(10);
2331: BEGIN
2332:
2333: IF p_scheduled_start_date IS NULL OR
2334: p_scheduled_start_date = FND_API.G_MISS_DATE
2335: THEN
2336: RETURN TRUE;
2337: END IF;
2338:
2367: , 'Scheduled_Start_Date'
2368: );
2369: END IF;
2370:
2371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2372:
2373: END Scheduled_Start_Date;
2374:
2375: FUNCTION Schedule_Group ( p_schedule_group_id IN NUMBER )
2378: l_dummy VARCHAR2(10);
2379: BEGIN
2380:
2381: IF p_schedule_group_id IS NULL OR
2382: p_schedule_group_id = FND_API.G_MISS_NUM
2383: THEN
2384: RETURN TRUE;
2385: END IF;
2386:
2415: , 'Schedule_Group'
2416: );
2417: END IF;
2418:
2419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2420:
2421: END Schedule_Group;
2422:
2423: FUNCTION Schedule_Number ( p_schedule_number IN VARCHAR2 )
2426: l_dummy VARCHAR2(10);
2427: BEGIN
2428:
2429: IF p_schedule_number IS NULL OR
2430: p_schedule_number = FND_API.G_MISS_CHAR
2431: THEN
2432: RETURN TRUE;
2433: END IF;
2434:
2463: , 'Schedule_Number'
2464: );
2465: END IF;
2466:
2467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2468:
2469: END Schedule_Number;
2470:
2471: FUNCTION Status ( p_status IN NUMBER )
2474: l_dummy VARCHAR2(10);
2475: BEGIN
2476:
2477: IF p_status IS NULL OR
2478: p_status = FND_API.G_MISS_NUM
2479: THEN
2480: RETURN TRUE;
2481: END IF;
2482:
2511: , 'Status'
2512: );
2513: END IF;
2514:
2515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2516:
2517: END Status;
2518:
2519: FUNCTION Std_Cost_Adjustment_Acct ( p_std_cost_adjustment_acct IN NUMBER )
2522: l_dummy VARCHAR2(10);
2523: BEGIN
2524:
2525: IF p_std_cost_adjustment_acct IS NULL OR
2526: p_std_cost_adjustment_acct = FND_API.G_MISS_NUM
2527: THEN
2528: RETURN TRUE;
2529: END IF;
2530:
2559: , 'Std_Cost_Adjustment_Acct'
2560: );
2561: END IF;
2562:
2563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2564:
2565: END Std_Cost_Adjustment_Acct;
2566:
2567: FUNCTION Task ( p_task_id IN NUMBER )
2570: l_dummy VARCHAR2(10);
2571: BEGIN
2572:
2573: IF p_task_id IS NULL OR
2574: p_task_id = FND_API.G_MISS_NUM
2575: THEN
2576: RETURN TRUE;
2577: END IF;
2578:
2607: , 'Task'
2608: );
2609: END IF;
2610:
2611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2612:
2613: END Task;
2614:
2615: FUNCTION Wip_Entity ( p_wip_entity_id IN NUMBER )
2618: l_dummy VARCHAR2(10);
2619: BEGIN
2620:
2621: IF p_wip_entity_id IS NULL OR
2622: p_wip_entity_id = FND_API.G_MISS_NUM
2623: THEN
2624: RETURN TRUE;
2625: END IF;
2626:
2655: , 'Wip_Entity'
2656: );
2657: END IF;
2658:
2659: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2660:
2661: END Wip_Entity;
2662:
2663:
2669: l_dummy VARCHAR2(10);
2670: BEGIN
2671:
2672: IF p_end_item_unit_number IS NULL OR
2673: p_end_item_unit_number = FND_API.G_MISS_CHAR
2674: THEN
2675: RETURN TRUE;
2676: END IF;
2677:
2708: , 'End_Item_Unit_Number'
2709: );
2710: END IF;
2711:
2712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2713:
2714: END End_Item_Unit_Number;
2715:
2716:
2719: IS
2720: BEGIN
2721:
2722: IF p_quantity_scrapped IS NULL OR
2723: p_quantity_scrapped = FND_API.G_MISS_NUM
2724: THEN
2725: RETURN TRUE;
2726: END IF;
2727:
2751: , 'quantity_scrapped'
2752: );
2753: END IF;
2754:
2755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2756:
2757: END Quantity_Scrapped;
2758:
2759: FUNCTION Assignment_Set
2763: l_dummy VARCHAR2(10);
2764: BEGIN
2765:
2766: IF (p_Assignment_Set_Id IS NULL OR
2767: p_Assignment_Set_Id = FND_API.G_MISS_NUM)
2768: THEN
2769: RETURN TRUE;
2770: END IF;
2771:
2795: , 'Assignment_Set'
2796: );
2797: END IF;
2798:
2799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2800:
2801: END Assignment_Set;
2802:
2803: FUNCTION Assignment
2807: l_dummy VARCHAR2(10);
2808: BEGIN
2809:
2810: IF (p_Assignment_Id IS NULL OR
2811: p_Assignment_Id = FND_API.G_MISS_NUM)
2812: THEN
2813: RETURN TRUE;
2814: END IF;
2815:
2839: , 'Assignment'
2840: );
2841: END IF;
2842:
2843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2844:
2845: END Assignment;
2846:
2847: FUNCTION Sourcing_Rule
2851: l_dummy VARCHAR2(10);
2852: BEGIN
2853:
2854: IF (p_Sourcing_Rule_Id IS NULL OR
2855: p_Sourcing_Rule_Id = FND_API.G_MISS_NUM)
2856: THEN
2857: RETURN TRUE;
2858: END IF;
2859:
2883: , 'Sourcing_Rule'
2884: );
2885: END IF;
2886:
2887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2888:
2889: END Sourcing_Rule;
2890:
2891: FUNCTION Receiving_Org
2895: l_dummy VARCHAR2(10);
2896: BEGIN
2897:
2898: IF (p_Sr_Receipt_Id IS NULL OR
2899: p_Sr_Receipt_Id = FND_API.G_MISS_NUM)
2900: THEN
2901: RETURN TRUE;
2902: END IF;
2903:
2927: , 'Receiving_Org'
2928: );
2929: END IF;
2930:
2931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2932:
2933: END Receiving_Org;
2934:
2935: FUNCTION Shipping_Org
2939: l_dummy VARCHAR2(10);
2940: BEGIN
2941:
2942: IF (p_Sr_Source_Id IS NULL OR
2943: p_Sr_Source_Id = FND_API.G_MISS_NUM)
2944: THEN
2945: RETURN TRUE;
2946: END IF;
2947:
2971: , 'Shipping_Org'
2972: );
2973: END IF;
2974:
2975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2976:
2977: END Shipping_Org;
2978: -- END GEN validate
2979: