DBA Data[Home] [Help]

APPS.CSD_GROUP_JOB_PVT dependencies on FND_API

Line 11: ( group_job_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 12: repair_group_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,

Line 13: incident_id 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,

Line 14: inventory_item_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,

Line 15: organization_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 16: job_type 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,
20: accounting_class VARCHAR2(10) := FND_API.G_MISS_CHAR,

Line 17: routing_reference_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,
21: start_date DATE := FND_API.G_MISS_DATE,

Line 18: alternate_designator_code VARCHAR2(10) := FND_API.G_MISS_CHAR,

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,

Line 19: job_status_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

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,

Line 20: accounting_class VARCHAR2(10) := FND_API.G_MISS_CHAR,

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,

Line 21: start_date DATE := FND_API.G_MISS_DATE,

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,

Line 22: completion_date DATE := FND_API.G_MISS_DATE,

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,

Line 23: quantity_received NUMBER := FND_API.G_MISS_NUM,

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,

Line 24: quantity_submitted NUMBER := FND_API.G_MISS_NUM,

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,

Line 25: item_revision VARCHAR2(3) := 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,
29: created_by NUMBER := FND_API.G_MISS_NUM,

Line 26: last_update_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,
30: last_update_login NUMBER := FND_API.G_MISS_NUM,

Line 27: creation_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,
31: object_version_number NUMBER := FND_API.G_MISS_NUM,

Line 28: last_updated_by 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);

Line 29: created_by 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:

Line 30: last_update_login NUMBER := FND_API.G_MISS_NUM,

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: /*-----------------------------------------------------------------*/

Line 31: object_version_number NUMBER := FND_API.G_MISS_NUM,

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 */

Line 32: process_id NUMBER := FND_API.G_MISS_NUM);

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 */

Line 42: p_commit IN VARCHAR2 := fnd_api.g_false,

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,

Line 43: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

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,

Line 44: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

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,

Line 59: p_commit IN VARCHAR2 := fnd_api.g_false,

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,

Line 60: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

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,

Line 61: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

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);

Line 75: p_commit IN VARCHAR2 := fnd_api.g_false,

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,

Line 76: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

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,

Line 77: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

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);

Line 123: p_commit IN VARCHAR2 := fnd_api.g_false,

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,

Line 124: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

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,

Line 125: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

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 );

Line 139: p_commit IN VARCHAR2 := fnd_api.g_false,

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,

Line 140: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

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,

Line 141: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

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 );