DBA Data[Home] [Help]

APPS.EAM_COMMON_UTILITIES_PVT dependencies on FND_API

Line 11: -- Default = FND_API.G_FALSE

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

Line 13: -- Default = FND_API.G_FALSE

9: -- IN p_api_version IN NUMBER Required
10: -- p_init_msg_list IN VARCHAR2 Optional
11: -- Default = FND_API.G_FALSE
12: -- p_commit IN VARCHAR2 Optional
13: -- Default = FND_API.G_FALSE
14: -- p_validation_level IN NUMBER Optional
15: -- Default = FND_API.G_VALID_LEVEL_FULL
16: -- parameter1
17: -- parameter2

Line 15: -- Default = FND_API.G_VALID_LEVEL_FULL

11: -- Default = FND_API.G_FALSE
12: -- p_commit IN VARCHAR2 Optional
13: -- Default = FND_API.G_FALSE
14: -- p_validation_level IN NUMBER Optional
15: -- Default = FND_API.G_VALID_LEVEL_FULL
16: -- parameter1
17: -- parameter2
18: -- .
19: -- .

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

39: -- End of comments
40:
41: PROCEDURE get_org_code(
42: p_api_version IN NUMBER
43: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
44: ,p_commit IN VARCHAR2 := fnd_api.g_false
45: ,p_validation_level IN NUMBER
46: := fnd_api.g_valid_level_full
47: ,p_organization_id IN NUMBER

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

40:
41: PROCEDURE get_org_code(
42: p_api_version IN NUMBER
43: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
44: ,p_commit IN VARCHAR2 := fnd_api.g_false
45: ,p_validation_level IN NUMBER
46: := fnd_api.g_valid_level_full
47: ,p_organization_id IN NUMBER
48: ,x_organization_code OUT NOCOPY VARCHAR2

Line 46: := fnd_api.g_valid_level_full

42: p_api_version IN NUMBER
43: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
44: ,p_commit IN VARCHAR2 := fnd_api.g_false
45: ,p_validation_level IN NUMBER
46: := fnd_api.g_valid_level_full
47: ,p_organization_id IN NUMBER
48: ,x_organization_code OUT NOCOPY VARCHAR2
49: ,x_return_status OUT NOCOPY VARCHAR2
50: ,x_msg_count OUT NOCOPY NUMBER

Line 61: -- Default = FND_API.G_FALSE

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

Line 63: -- Default = FND_API.G_FALSE

59: -- IN p_api_version IN NUMBER Required
60: -- p_init_msg_list IN VARCHAR2 Optional
61: -- Default = FND_API.G_FALSE
62: -- p_commit IN VARCHAR2 Optional
63: -- Default = FND_API.G_FALSE
64: -- p_validation_level IN NUMBER Optional
65: -- Default = FND_API.G_VALID_LEVEL_FULL
66: -- parameter1
67: -- parameter2

Line 65: -- Default = FND_API.G_VALID_LEVEL_FULL

61: -- Default = FND_API.G_FALSE
62: -- p_commit IN VARCHAR2 Optional
63: -- Default = FND_API.G_FALSE
64: -- p_validation_level IN NUMBER Optional
65: -- Default = FND_API.G_VALID_LEVEL_FULL
66: -- parameter1
67: -- parameter2
68: -- .
69: -- .

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

89: -- End of comments
90:
91: PROCEDURE get_item_id(
92: p_api_version IN NUMBER
93: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
94: ,p_commit IN VARCHAR2 := fnd_api.g_false
95: ,p_validation_level IN NUMBER
96: := fnd_api.g_valid_level_full
97: ,p_organization_id IN NUMBER

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

90:
91: PROCEDURE get_item_id(
92: p_api_version IN NUMBER
93: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
94: ,p_commit IN VARCHAR2 := fnd_api.g_false
95: ,p_validation_level IN NUMBER
96: := fnd_api.g_valid_level_full
97: ,p_organization_id IN NUMBER
98: ,p_concatenated_segments IN VARCHAR2

Line 96: := fnd_api.g_valid_level_full

92: p_api_version IN NUMBER
93: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
94: ,p_commit IN VARCHAR2 := fnd_api.g_false
95: ,p_validation_level IN NUMBER
96: := fnd_api.g_valid_level_full
97: ,p_organization_id IN NUMBER
98: ,p_concatenated_segments IN VARCHAR2
99: ,x_inventory_item_id OUT NOCOPY NUMBER
100: ,x_return_status OUT NOCOPY VARCHAR2

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

105:
106:
107: PROCEDURE get_current_period(
108: p_api_version IN NUMBER
109: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
110: ,p_commit IN VARCHAR2 := fnd_api.g_false
111: ,p_validation_level IN NUMBER
112: := fnd_api.g_valid_level_full
113: ,p_organization_id IN NUMBER

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

106:
107: PROCEDURE get_current_period(
108: p_api_version IN NUMBER
109: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
110: ,p_commit IN VARCHAR2 := fnd_api.g_false
111: ,p_validation_level IN NUMBER
112: := fnd_api.g_valid_level_full
113: ,p_organization_id IN NUMBER
114: ,x_period_name OUT NOCOPY VARCHAR2

Line 112: := fnd_api.g_valid_level_full

108: p_api_version IN NUMBER
109: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
110: ,p_commit IN VARCHAR2 := fnd_api.g_false
111: ,p_validation_level IN NUMBER
112: := fnd_api.g_valid_level_full
113: ,p_organization_id IN NUMBER
114: ,x_period_name OUT NOCOPY VARCHAR2
115: ,x_return_status OUT NOCOPY VARCHAR2
116: ,x_msg_count OUT NOCOPY NUMBER

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

118:
119:
120: PROCEDURE get_currency(
121: p_api_version IN NUMBER
122: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
123: ,p_commit IN VARCHAR2 := fnd_api.g_false
124: ,p_validation_level IN NUMBER
125: := fnd_api.g_valid_level_full
126: ,p_organization_id IN NUMBER

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

119:
120: PROCEDURE get_currency(
121: p_api_version IN NUMBER
122: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
123: ,p_commit IN VARCHAR2 := fnd_api.g_false
124: ,p_validation_level IN NUMBER
125: := fnd_api.g_valid_level_full
126: ,p_organization_id IN NUMBER
127: ,x_currency OUT NOCOPY VARCHAR2

Line 125: := fnd_api.g_valid_level_full

121: p_api_version IN NUMBER
122: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
123: ,p_commit IN VARCHAR2 := fnd_api.g_false
124: ,p_validation_level IN NUMBER
125: := fnd_api.g_valid_level_full
126: ,p_organization_id IN NUMBER
127: ,x_currency OUT NOCOPY VARCHAR2
128: ,x_return_status OUT NOCOPY VARCHAR2
129: ,x_msg_count OUT NOCOPY NUMBER

Line 142: -- Default = FND_API.G_FALSE

138: -- Pre-reqs : None.
139: -- Parameters :
140: -- IN p_api_version IN NUMBER Required
141: -- p_init_msg_list IN VARCHAR2 Optional
142: -- Default = FND_API.G_FALSE
143: -- p_commit IN VARCHAR2 Optional
144: -- Default = FND_API.G_FALSE
145: -- p_validation_level IN NUMBER Optional
146: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 144: -- Default = FND_API.G_FALSE

140: -- IN p_api_version IN NUMBER Required
141: -- p_init_msg_list IN VARCHAR2 Optional
142: -- Default = FND_API.G_FALSE
143: -- p_commit IN VARCHAR2 Optional
144: -- Default = FND_API.G_FALSE
145: -- p_validation_level IN NUMBER Optional
146: -- Default = FND_API.G_VALID_LEVEL_FULL
147: -- parameter1
148: -- parameter2

Line 146: -- Default = FND_API.G_VALID_LEVEL_FULL

142: -- Default = FND_API.G_FALSE
143: -- p_commit IN VARCHAR2 Optional
144: -- Default = FND_API.G_FALSE
145: -- p_validation_level IN NUMBER Optional
146: -- Default = FND_API.G_VALID_LEVEL_FULL
147: -- parameter1
148: -- parameter2
149: -- .
150: -- .

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

170: -- End of comments
171:
172: PROCEDURE get_next_asset_number (
173: p_api_version IN NUMBER
174: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
175: ,p_commit IN VARCHAR2 := fnd_api.g_false
176: ,p_validation_level IN NUMBER
177: := fnd_api.g_valid_level_full
178: ,p_organization_id IN NUMBER

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

171:
172: PROCEDURE get_next_asset_number (
173: p_api_version IN NUMBER
174: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
175: ,p_commit IN VARCHAR2 := fnd_api.g_false
176: ,p_validation_level IN NUMBER
177: := fnd_api.g_valid_level_full
178: ,p_organization_id IN NUMBER
179: ,p_inventory_item_id IN NUMBER

Line 177: := fnd_api.g_valid_level_full

173: p_api_version IN NUMBER
174: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
175: ,p_commit IN VARCHAR2 := fnd_api.g_false
176: ,p_validation_level IN NUMBER
177: := fnd_api.g_valid_level_full
178: ,p_organization_id IN NUMBER
179: ,p_inventory_item_id IN NUMBER
180: ,x_asset_number OUT NOCOPY VARCHAR2
181: ,x_return_status OUT NOCOPY VARCHAR2

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

185: PROCEDURE verify_org(
186: p_resp_id number default FND_GLOBAL.RESP_ID,
187: p_resp_app_id number default FND_GLOBAL.RESP_APPL_ID,
188: p_org_id number,
189: p_init_msg_list in VARCHAR2 := FND_API.G_FALSE,
190: x_boolean out NOCOPY number,
191: x_return_status out NOCOPY VARCHAR2,
192: x_msg_count out NOCOPY NUMBER,
193: x_msg_data out NOCOPY VARCHAR2);

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

370: ------------------------------------------------------------------------------------------------*/
371:
372: PROCEDURE get_work_order_count (
373: p_api_version IN NUMBER
374: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
375: ,p_commit IN VARCHAR2 := fnd_api.g_false
376: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
377: ,p_organization_id IN VARCHAR2
378: ,p_employee_id IN VARCHAR2

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

371:
372: PROCEDURE get_work_order_count (
373: p_api_version IN NUMBER
374: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
375: ,p_commit IN VARCHAR2 := fnd_api.g_false
376: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
377: ,p_organization_id IN VARCHAR2
378: ,p_employee_id IN VARCHAR2
379: ,p_instance_id IN NUMBER

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

372: PROCEDURE get_work_order_count (
373: p_api_version IN NUMBER
374: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
375: ,p_commit IN VARCHAR2 := fnd_api.g_false
376: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
377: ,p_organization_id IN VARCHAR2
378: ,p_employee_id IN VARCHAR2
379: ,p_instance_id IN NUMBER
380: ,p_asset_group_id IN NUMBER

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

400: ------------------------------------------------------------------------------------------------*/
401:
402: PROCEDURE insert_into_wori (
403: p_api_version IN NUMBER
404: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
405: ,p_commit IN VARCHAR2 := fnd_api.g_false
406: ,p_organization_id IN VARCHAR2
407: ,p_employee_id IN VARCHAR2
408: ,p_wip_entity_id IN VARCHAR2

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

401:
402: PROCEDURE insert_into_wori (
403: p_api_version IN NUMBER
404: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
405: ,p_commit IN VARCHAR2 := fnd_api.g_false
406: ,p_organization_id IN VARCHAR2
407: ,p_employee_id IN VARCHAR2
408: ,p_wip_entity_id IN VARCHAR2
409: ,p_operation_seq_num IN VARCHAR2

Line 424: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

420: return number;
421:
422: PROCEDURE deactivate_assets(
423: P_API_VERSION IN NUMBER,
424: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
425: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
426: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
427: P_INVENTORY_ITEM_ID IN NUMBER DEFAULT NULL,
428: P_SERIAL_NUMBER IN VARCHAR2 DEFAULT NULL,

Line 425: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

421:
422: PROCEDURE deactivate_assets(
423: P_API_VERSION IN NUMBER,
424: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
425: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
426: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
427: P_INVENTORY_ITEM_ID IN NUMBER DEFAULT NULL,
428: P_SERIAL_NUMBER IN VARCHAR2 DEFAULT NULL,
429: P_ORGANIZATION_ID IN NUMBER,

Line 426: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

422: PROCEDURE deactivate_assets(
423: P_API_VERSION IN NUMBER,
424: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
425: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
426: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
427: P_INVENTORY_ITEM_ID IN NUMBER DEFAULT NULL,
428: P_SERIAL_NUMBER IN VARCHAR2 DEFAULT NULL,
429: P_ORGANIZATION_ID IN NUMBER,
430: P_GEN_OBJECT_ID IN NUMBER DEFAULT NULL,

Line 486: ,P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE

482:
483:
484: PROCEDURE CREATE_ASSET(
485: P_API_VERSION IN NUMBER
486: ,P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
487: ,P_COMMIT IN VARCHAR2 := FND_API.G_FALSE
488: ,P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL
489: ,X_EAM_WO_REC IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
490: ,X_RETURN_STATUS OUT NOCOPY VARCHAR2

Line 487: ,P_COMMIT IN VARCHAR2 := FND_API.G_FALSE

483:
484: PROCEDURE CREATE_ASSET(
485: P_API_VERSION IN NUMBER
486: ,P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
487: ,P_COMMIT IN VARCHAR2 := FND_API.G_FALSE
488: ,P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL
489: ,X_EAM_WO_REC IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
490: ,X_RETURN_STATUS OUT NOCOPY VARCHAR2
491: ,X_MSG_COUNT OUT NOCOPY NUMBER

Line 488: ,P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL

484: PROCEDURE CREATE_ASSET(
485: P_API_VERSION IN NUMBER
486: ,P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
487: ,P_COMMIT IN VARCHAR2 := FND_API.G_FALSE
488: ,P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL
489: ,X_EAM_WO_REC IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
490: ,X_RETURN_STATUS OUT NOCOPY VARCHAR2
491: ,X_MSG_COUNT OUT NOCOPY NUMBER
492: ,X_MSG_DATA OUT NOCOPY VARCHAR2

Line 522: ,P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE

518: );
519:
520: PROCEDURE Adjust_WORU (
521: P_API_VERSION IN NUMBER
522: ,P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
523: ,P_COMMIT IN VARCHAR2 := FND_API.G_FALSE
524: ,P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL
525: ,P_WIP_ENTITY_ID IN NUMBER
526: ,P_ORGANIZATION_ID IN NUMBER

Line 523: ,P_COMMIT IN VARCHAR2 := FND_API.G_FALSE

519:
520: PROCEDURE Adjust_WORU (
521: P_API_VERSION IN NUMBER
522: ,P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
523: ,P_COMMIT IN VARCHAR2 := FND_API.G_FALSE
524: ,P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL
525: ,P_WIP_ENTITY_ID IN NUMBER
526: ,P_ORGANIZATION_ID IN NUMBER
527: ,P_OPERATION_SEQ_NUM IN NUMBER

Line 524: ,P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL

520: PROCEDURE Adjust_WORU (
521: P_API_VERSION IN NUMBER
522: ,P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
523: ,P_COMMIT IN VARCHAR2 := FND_API.G_FALSE
524: ,P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL
525: ,P_WIP_ENTITY_ID IN NUMBER
526: ,P_ORGANIZATION_ID IN NUMBER
527: ,P_OPERATION_SEQ_NUM IN NUMBER
528: ,P_RESOURCE_SEQ_NUM IN NUMBER