7: /* */
8: /*--------------------------------------------------*/
9:
10: TYPE JOB_PARAMETER_REC IS RECORD
11: ( group_job_id NUMBER := FND_API.G_MISS_NUM,
12: repair_group_id NUMBER := FND_API.G_MISS_NUM,
13: incident_id NUMBER := FND_API.G_MISS_NUM,
14: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
15: organization_id NUMBER := FND_API.G_MISS_NUM,
8: /*--------------------------------------------------*/
9:
10: TYPE JOB_PARAMETER_REC IS RECORD
11: ( group_job_id NUMBER := FND_API.G_MISS_NUM,
12: repair_group_id NUMBER := FND_API.G_MISS_NUM,
13: incident_id NUMBER := FND_API.G_MISS_NUM,
14: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
15: organization_id NUMBER := FND_API.G_MISS_NUM,
16: job_type NUMBER := FND_API.G_MISS_NUM,
9:
10: TYPE JOB_PARAMETER_REC IS RECORD
11: ( group_job_id NUMBER := FND_API.G_MISS_NUM,
12: repair_group_id NUMBER := FND_API.G_MISS_NUM,
13: incident_id NUMBER := FND_API.G_MISS_NUM,
14: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
15: organization_id NUMBER := FND_API.G_MISS_NUM,
16: job_type NUMBER := FND_API.G_MISS_NUM,
17: routing_reference_id NUMBER := FND_API.G_MISS_NUM,
10: TYPE JOB_PARAMETER_REC IS RECORD
11: ( group_job_id NUMBER := FND_API.G_MISS_NUM,
12: repair_group_id NUMBER := FND_API.G_MISS_NUM,
13: incident_id NUMBER := FND_API.G_MISS_NUM,
14: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
15: organization_id NUMBER := FND_API.G_MISS_NUM,
16: job_type NUMBER := FND_API.G_MISS_NUM,
17: routing_reference_id NUMBER := FND_API.G_MISS_NUM,
18: alternate_designator_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
11: ( group_job_id NUMBER := FND_API.G_MISS_NUM,
12: repair_group_id NUMBER := FND_API.G_MISS_NUM,
13: incident_id NUMBER := FND_API.G_MISS_NUM,
14: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
15: organization_id NUMBER := FND_API.G_MISS_NUM,
16: job_type NUMBER := FND_API.G_MISS_NUM,
17: routing_reference_id NUMBER := FND_API.G_MISS_NUM,
18: alternate_designator_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
19: job_status_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
12: repair_group_id NUMBER := FND_API.G_MISS_NUM,
13: incident_id NUMBER := FND_API.G_MISS_NUM,
14: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
15: organization_id NUMBER := FND_API.G_MISS_NUM,
16: job_type NUMBER := FND_API.G_MISS_NUM,
17: routing_reference_id NUMBER := FND_API.G_MISS_NUM,
18: alternate_designator_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
19: job_status_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: accounting_class VARCHAR2(10) := FND_API.G_MISS_CHAR,
13: incident_id NUMBER := FND_API.G_MISS_NUM,
14: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
15: organization_id NUMBER := FND_API.G_MISS_NUM,
16: job_type NUMBER := FND_API.G_MISS_NUM,
17: routing_reference_id NUMBER := FND_API.G_MISS_NUM,
18: alternate_designator_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
19: job_status_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: accounting_class VARCHAR2(10) := FND_API.G_MISS_CHAR,
21: start_date DATE := FND_API.G_MISS_DATE,
14: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
15: organization_id NUMBER := FND_API.G_MISS_NUM,
16: job_type NUMBER := FND_API.G_MISS_NUM,
17: routing_reference_id NUMBER := FND_API.G_MISS_NUM,
18: alternate_designator_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
19: job_status_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: accounting_class VARCHAR2(10) := FND_API.G_MISS_CHAR,
21: start_date DATE := FND_API.G_MISS_DATE,
22: completion_date DATE := FND_API.G_MISS_DATE,
15: organization_id NUMBER := FND_API.G_MISS_NUM,
16: job_type NUMBER := FND_API.G_MISS_NUM,
17: routing_reference_id NUMBER := FND_API.G_MISS_NUM,
18: alternate_designator_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
19: job_status_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: accounting_class VARCHAR2(10) := FND_API.G_MISS_CHAR,
21: start_date DATE := FND_API.G_MISS_DATE,
22: completion_date DATE := FND_API.G_MISS_DATE,
23: quantity_received NUMBER := FND_API.G_MISS_NUM,
16: job_type NUMBER := FND_API.G_MISS_NUM,
17: routing_reference_id NUMBER := FND_API.G_MISS_NUM,
18: alternate_designator_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
19: job_status_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: accounting_class VARCHAR2(10) := FND_API.G_MISS_CHAR,
21: start_date DATE := FND_API.G_MISS_DATE,
22: completion_date DATE := FND_API.G_MISS_DATE,
23: quantity_received NUMBER := FND_API.G_MISS_NUM,
24: quantity_submitted NUMBER := FND_API.G_MISS_NUM,
17: routing_reference_id NUMBER := FND_API.G_MISS_NUM,
18: alternate_designator_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
19: job_status_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: accounting_class VARCHAR2(10) := FND_API.G_MISS_CHAR,
21: start_date DATE := FND_API.G_MISS_DATE,
22: completion_date DATE := FND_API.G_MISS_DATE,
23: quantity_received NUMBER := FND_API.G_MISS_NUM,
24: quantity_submitted NUMBER := FND_API.G_MISS_NUM,
25: item_revision VARCHAR2(3) := FND_API.G_MISS_CHAR,
18: alternate_designator_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
19: job_status_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: accounting_class VARCHAR2(10) := FND_API.G_MISS_CHAR,
21: start_date DATE := FND_API.G_MISS_DATE,
22: completion_date DATE := FND_API.G_MISS_DATE,
23: quantity_received NUMBER := FND_API.G_MISS_NUM,
24: quantity_submitted NUMBER := FND_API.G_MISS_NUM,
25: item_revision VARCHAR2(3) := FND_API.G_MISS_CHAR,
26: last_update_date DATE := FND_API.G_MISS_DATE,
19: job_status_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: accounting_class VARCHAR2(10) := FND_API.G_MISS_CHAR,
21: start_date DATE := FND_API.G_MISS_DATE,
22: completion_date DATE := FND_API.G_MISS_DATE,
23: quantity_received NUMBER := FND_API.G_MISS_NUM,
24: quantity_submitted NUMBER := FND_API.G_MISS_NUM,
25: item_revision VARCHAR2(3) := FND_API.G_MISS_CHAR,
26: last_update_date DATE := FND_API.G_MISS_DATE,
27: creation_date DATE := FND_API.G_MISS_DATE,
20: accounting_class VARCHAR2(10) := FND_API.G_MISS_CHAR,
21: start_date DATE := FND_API.G_MISS_DATE,
22: completion_date DATE := FND_API.G_MISS_DATE,
23: quantity_received NUMBER := FND_API.G_MISS_NUM,
24: quantity_submitted NUMBER := FND_API.G_MISS_NUM,
25: item_revision VARCHAR2(3) := FND_API.G_MISS_CHAR,
26: last_update_date DATE := FND_API.G_MISS_DATE,
27: creation_date DATE := FND_API.G_MISS_DATE,
28: last_updated_by NUMBER := FND_API.G_MISS_NUM,
21: start_date DATE := FND_API.G_MISS_DATE,
22: completion_date DATE := FND_API.G_MISS_DATE,
23: quantity_received NUMBER := FND_API.G_MISS_NUM,
24: quantity_submitted NUMBER := FND_API.G_MISS_NUM,
25: item_revision VARCHAR2(3) := FND_API.G_MISS_CHAR,
26: last_update_date DATE := FND_API.G_MISS_DATE,
27: creation_date DATE := FND_API.G_MISS_DATE,
28: last_updated_by NUMBER := FND_API.G_MISS_NUM,
29: created_by NUMBER := FND_API.G_MISS_NUM,
22: completion_date DATE := FND_API.G_MISS_DATE,
23: quantity_received NUMBER := FND_API.G_MISS_NUM,
24: quantity_submitted NUMBER := FND_API.G_MISS_NUM,
25: item_revision VARCHAR2(3) := FND_API.G_MISS_CHAR,
26: last_update_date DATE := FND_API.G_MISS_DATE,
27: creation_date DATE := FND_API.G_MISS_DATE,
28: last_updated_by NUMBER := FND_API.G_MISS_NUM,
29: created_by NUMBER := FND_API.G_MISS_NUM,
30: last_update_login NUMBER := FND_API.G_MISS_NUM,
23: quantity_received NUMBER := FND_API.G_MISS_NUM,
24: quantity_submitted NUMBER := FND_API.G_MISS_NUM,
25: item_revision VARCHAR2(3) := FND_API.G_MISS_CHAR,
26: last_update_date DATE := FND_API.G_MISS_DATE,
27: creation_date DATE := FND_API.G_MISS_DATE,
28: last_updated_by NUMBER := FND_API.G_MISS_NUM,
29: created_by NUMBER := FND_API.G_MISS_NUM,
30: last_update_login NUMBER := FND_API.G_MISS_NUM,
31: object_version_number NUMBER := FND_API.G_MISS_NUM,
24: quantity_submitted NUMBER := FND_API.G_MISS_NUM,
25: item_revision VARCHAR2(3) := FND_API.G_MISS_CHAR,
26: last_update_date DATE := FND_API.G_MISS_DATE,
27: creation_date DATE := FND_API.G_MISS_DATE,
28: last_updated_by NUMBER := FND_API.G_MISS_NUM,
29: created_by NUMBER := FND_API.G_MISS_NUM,
30: last_update_login NUMBER := FND_API.G_MISS_NUM,
31: object_version_number NUMBER := FND_API.G_MISS_NUM,
32: process_id NUMBER := FND_API.G_MISS_NUM);
25: item_revision VARCHAR2(3) := FND_API.G_MISS_CHAR,
26: last_update_date DATE := FND_API.G_MISS_DATE,
27: creation_date DATE := FND_API.G_MISS_DATE,
28: last_updated_by NUMBER := FND_API.G_MISS_NUM,
29: created_by NUMBER := FND_API.G_MISS_NUM,
30: last_update_login NUMBER := FND_API.G_MISS_NUM,
31: object_version_number NUMBER := FND_API.G_MISS_NUM,
32: process_id NUMBER := FND_API.G_MISS_NUM);
33:
26: last_update_date DATE := FND_API.G_MISS_DATE,
27: creation_date DATE := FND_API.G_MISS_DATE,
28: last_updated_by NUMBER := FND_API.G_MISS_NUM,
29: created_by NUMBER := FND_API.G_MISS_NUM,
30: last_update_login NUMBER := FND_API.G_MISS_NUM,
31: object_version_number NUMBER := FND_API.G_MISS_NUM,
32: process_id NUMBER := FND_API.G_MISS_NUM);
33:
34: /*-----------------------------------------------------------------*/
27: creation_date DATE := FND_API.G_MISS_DATE,
28: last_updated_by NUMBER := FND_API.G_MISS_NUM,
29: created_by NUMBER := FND_API.G_MISS_NUM,
30: last_update_login NUMBER := FND_API.G_MISS_NUM,
31: object_version_number NUMBER := FND_API.G_MISS_NUM,
32: process_id NUMBER := FND_API.G_MISS_NUM);
33:
34: /*-----------------------------------------------------------------*/
35: /* procedure name: create_job_parameters */
28: last_updated_by NUMBER := FND_API.G_MISS_NUM,
29: created_by NUMBER := FND_API.G_MISS_NUM,
30: last_update_login NUMBER := FND_API.G_MISS_NUM,
31: object_version_number NUMBER := FND_API.G_MISS_NUM,
32: process_id NUMBER := FND_API.G_MISS_NUM);
33:
34: /*-----------------------------------------------------------------*/
35: /* procedure name: create_job_parameters */
36: /* description : procedure used to create */
38: /*-----------------------------------------------------------------*/
39:
40: PROCEDURE create_job_parameters
41: ( p_api_version IN NUMBER,
42: p_commit IN VARCHAR2 := fnd_api.g_false,
43: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
44: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
45: p_job_parameter_rec IN OUT NOCOPY JOB_PARAMETER_REC,
46: x_group_job_id OUT NOCOPY NUMBER,
39:
40: PROCEDURE create_job_parameters
41: ( p_api_version IN NUMBER,
42: p_commit IN VARCHAR2 := fnd_api.g_false,
43: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
44: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
45: p_job_parameter_rec IN OUT NOCOPY JOB_PARAMETER_REC,
46: x_group_job_id OUT NOCOPY NUMBER,
47: x_return_status OUT NOCOPY VARCHAR2,
40: PROCEDURE create_job_parameters
41: ( p_api_version IN NUMBER,
42: p_commit IN VARCHAR2 := fnd_api.g_false,
43: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
44: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
45: p_job_parameter_rec IN OUT NOCOPY JOB_PARAMETER_REC,
46: x_group_job_id OUT NOCOPY NUMBER,
47: x_return_status OUT NOCOPY VARCHAR2,
48: x_msg_count OUT NOCOPY NUMBER,
55: /*-----------------------------------------------------------------*/
56:
57: PROCEDURE update_job_parameters
58: ( p_api_version IN NUMBER,
59: p_commit IN VARCHAR2 := fnd_api.g_false,
60: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
61: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
62: p_job_parameter_rec IN OUT NOCOPY JOB_PARAMETER_REC,
63: x_return_status OUT NOCOPY VARCHAR2,
56:
57: PROCEDURE update_job_parameters
58: ( p_api_version IN NUMBER,
59: p_commit IN VARCHAR2 := fnd_api.g_false,
60: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
61: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
62: p_job_parameter_rec IN OUT NOCOPY JOB_PARAMETER_REC,
63: x_return_status OUT NOCOPY VARCHAR2,
64: x_msg_count OUT NOCOPY NUMBER,
57: PROCEDURE update_job_parameters
58: ( p_api_version IN NUMBER,
59: p_commit IN VARCHAR2 := fnd_api.g_false,
60: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
61: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
62: p_job_parameter_rec IN OUT NOCOPY JOB_PARAMETER_REC,
63: x_return_status OUT NOCOPY VARCHAR2,
64: x_msg_count OUT NOCOPY NUMBER,
65: x_msg_data OUT NOCOPY VARCHAR2);
71: /*-----------------------------------------------------------------*/
72:
73: PROCEDURE lock_job_parameters
74: ( p_api_version IN NUMBER,
75: p_commit IN VARCHAR2 := fnd_api.g_false,
76: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
77: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
78: p_job_parameter_rec IN JOB_PARAMETER_REC,
79: x_return_status OUT NOCOPY VARCHAR2,
72:
73: PROCEDURE lock_job_parameters
74: ( p_api_version IN NUMBER,
75: p_commit IN VARCHAR2 := fnd_api.g_false,
76: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
77: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
78: p_job_parameter_rec IN JOB_PARAMETER_REC,
79: x_return_status OUT NOCOPY VARCHAR2,
80: x_msg_count OUT NOCOPY NUMBER,
73: PROCEDURE lock_job_parameters
74: ( p_api_version IN NUMBER,
75: p_commit IN VARCHAR2 := fnd_api.g_false,
76: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
77: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
78: p_job_parameter_rec IN JOB_PARAMETER_REC,
79: x_return_status OUT NOCOPY VARCHAR2,
80: x_msg_count OUT NOCOPY NUMBER,
81: x_msg_data OUT NOCOPY VARCHAR2);
119: ----------------------------------------------
120:
121: PROCEDURE CREATE_JOB_ALL_GROUPS
122: ( p_api_version IN NUMBER,
123: p_commit IN VARCHAR2 := fnd_api.g_false,
124: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
125: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
126: p_incident_id IN NUMBER,
127: x_return_status OUT NOCOPY VARCHAR2,
120:
121: PROCEDURE CREATE_JOB_ALL_GROUPS
122: ( p_api_version IN NUMBER,
123: p_commit IN VARCHAR2 := fnd_api.g_false,
124: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
125: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
126: p_incident_id IN NUMBER,
127: x_return_status OUT NOCOPY VARCHAR2,
128: x_msg_count OUT NOCOPY NUMBER,
121: PROCEDURE CREATE_JOB_ALL_GROUPS
122: ( p_api_version IN NUMBER,
123: p_commit IN VARCHAR2 := fnd_api.g_false,
124: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
125: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
126: p_incident_id IN NUMBER,
127: x_return_status OUT NOCOPY VARCHAR2,
128: x_msg_count OUT NOCOPY NUMBER,
129: x_msg_data OUT NOCOPY VARCHAR2 );
135: ----------------------------------------------
136:
137: PROCEDURE CREATE_JOB_ONE_GROUP
138: ( p_api_version IN NUMBER,
139: p_commit IN VARCHAR2 := fnd_api.g_false,
140: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
141: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
142: p_repair_group_id IN Number,
143: x_return_status OUT NOCOPY VARCHAR2,
136:
137: PROCEDURE CREATE_JOB_ONE_GROUP
138: ( p_api_version IN NUMBER,
139: p_commit IN VARCHAR2 := fnd_api.g_false,
140: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
141: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
142: p_repair_group_id IN Number,
143: x_return_status OUT NOCOPY VARCHAR2,
144: x_msg_count OUT NOCOPY NUMBER,
137: PROCEDURE CREATE_JOB_ONE_GROUP
138: ( p_api_version IN NUMBER,
139: p_commit IN VARCHAR2 := fnd_api.g_false,
140: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
141: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
142: p_repair_group_id IN Number,
143: x_return_status OUT NOCOPY VARCHAR2,
144: x_msg_count OUT NOCOPY NUMBER,
145: x_msg_data OUT NOCOPY VARCHAR2 );