DBA Data[Home] [Help]

APPS.EGO_ITEM_PVT dependencies on FND_API

Line 6: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_SUCCESS; --'S'

2: /* $Header: EGOVITMS.pls 120.11.12020000.2 2012/07/13 01:41:37 mshirkol ship $ */
3:
4: G_FILE_NAME CONSTANT VARCHAR2(12) := 'EGOVITMS.pls';
5:
6: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_SUCCESS; --'S'
7: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'
8: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
9:
10: -- Define the package global constants to substitute FND_API global variables for missing values

Line 7: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'

3:
4: G_FILE_NAME CONSTANT VARCHAR2(12) := 'EGOVITMS.pls';
5:
6: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_SUCCESS; --'S'
7: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'
8: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
9:
10: -- Define the package global constants to substitute FND_API global variables for missing values
11:

Line 8: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'

4: G_FILE_NAME CONSTANT VARCHAR2(12) := 'EGOVITMS.pls';
5:
6: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_SUCCESS; --'S'
7: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'
8: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
9:
10: -- Define the package global constants to substitute FND_API global variables for missing values
11:
12: G_MISS_NUM CONSTANT NUMBER := 9.99E125;

Line 10: -- Define the package global constants to substitute FND_API global variables for missing values

6: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_SUCCESS; --'S'
7: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'
8: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
9:
10: -- Define the package global constants to substitute FND_API global variables for missing values
11:
12: G_MISS_NUM CONSTANT NUMBER := 9.99E125;
13: G_MISS_CHAR CONSTANT VARCHAR2(1) := CHR(0);
14: G_MISS_DATE CONSTANT DATE := TO_DATE('1','j');

Line 49: p_commit IN VARCHAR2 DEFAULT FND_API.g_FALSE

45: -- -----------------------------------------------------------------------------
46:
47: PROCEDURE Process_Items
48: (
49: p_commit IN VARCHAR2 DEFAULT FND_API.g_FALSE
50: , x_return_status OUT NOCOPY VARCHAR2
51: , x_msg_count OUT NOCOPY NUMBER
52: );
53:

Line 65: p_commit IN VARCHAR2 DEFAULT FND_API.g_FALSE

61: -- -----------------------------------------------------------------------------
62:
63: PROCEDURE Process_Item
64: (
65: p_commit IN VARCHAR2 DEFAULT FND_API.g_FALSE
66: , x_return_status OUT NOCOPY VARCHAR2
67: , x_msg_count OUT NOCOPY NUMBER
68: );
69: */

Line 80: p_commit IN VARCHAR2 DEFAULT FND_API.g_FALSE

76: -- -----------------------------------------------------------------------------
77:
78: PROCEDURE Process_Item_Org_Assignments
79: (
80: p_commit IN VARCHAR2 DEFAULT FND_API.g_FALSE
81: , x_return_status OUT NOCOPY VARCHAR2
82: , x_msg_count OUT NOCOPY NUMBER
83: );
84:

Line 136: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE

132: ,p_entity_id IN NUMBER DEFAULT NULL
133: ,p_entity_index IN NUMBER DEFAULT NULL
134: ,p_entity_code IN VARCHAR2 DEFAULT NULL
135: ,p_debug_level IN NUMBER DEFAULT 0
136: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
137: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
138: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
139: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
140: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 137: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE

133: ,p_entity_index IN NUMBER DEFAULT NULL
134: ,p_entity_code IN VARCHAR2 DEFAULT NULL
135: ,p_debug_level IN NUMBER DEFAULT 0
136: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
137: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
138: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
139: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
140: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
141: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 138: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

134: ,p_entity_code IN VARCHAR2 DEFAULT NULL
135: ,p_debug_level IN NUMBER DEFAULT 0
136: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
137: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
138: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
139: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
140: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
141: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
142: ,p_do_policy_check IN VARCHAR2 DEFAULT FND_API.G_TRUE

Line 139: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE

135: ,p_debug_level IN NUMBER DEFAULT 0
136: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
137: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
138: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
139: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
140: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
141: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
142: ,p_do_policy_check IN VARCHAR2 DEFAULT FND_API.G_TRUE
143: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE

Line 140: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

136: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
137: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
138: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
139: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
140: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
141: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
142: ,p_do_policy_check IN VARCHAR2 DEFAULT FND_API.G_TRUE
143: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE
144: ,x_failed_row_id_list OUT NOCOPY VARCHAR2

Line 141: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

137: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
138: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
139: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
140: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
141: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
142: ,p_do_policy_check IN VARCHAR2 DEFAULT FND_API.G_TRUE
143: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE
144: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
145: ,x_return_status OUT NOCOPY VARCHAR2

Line 142: ,p_do_policy_check IN VARCHAR2 DEFAULT FND_API.G_TRUE

138: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
139: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
140: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
141: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
142: ,p_do_policy_check IN VARCHAR2 DEFAULT FND_API.G_TRUE
143: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE
144: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
145: ,x_return_status OUT NOCOPY VARCHAR2
146: ,x_errorcode OUT NOCOPY NUMBER

Line 143: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE

139: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
140: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
141: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
142: ,p_do_policy_check IN VARCHAR2 DEFAULT FND_API.G_TRUE
143: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE
144: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
145: ,x_return_status OUT NOCOPY VARCHAR2
146: ,x_errorcode OUT NOCOPY NUMBER
147: ,x_msg_count OUT NOCOPY NUMBER

Line 167: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE

163: ,p_entity_id IN NUMBER DEFAULT NULL
164: ,p_entity_index IN NUMBER DEFAULT NULL
165: ,p_entity_code IN VARCHAR2 DEFAULT NULL
166: ,p_debug_level IN NUMBER DEFAULT 0
167: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
168: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
169: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
170: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
171: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

Line 168: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

164: ,p_entity_index IN NUMBER DEFAULT NULL
165: ,p_entity_code IN VARCHAR2 DEFAULT NULL
166: ,p_debug_level IN NUMBER DEFAULT 0
167: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
168: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
169: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
170: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
171: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
172: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

Line 169: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

165: ,p_entity_code IN VARCHAR2 DEFAULT NULL
166: ,p_debug_level IN NUMBER DEFAULT 0
167: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
168: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
169: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
170: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
171: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
172: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
173: ,x_return_status OUT NOCOPY VARCHAR2

Line 170: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

166: ,p_debug_level IN NUMBER DEFAULT 0
167: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
168: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
169: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
170: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
171: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
172: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
173: ,x_return_status OUT NOCOPY VARCHAR2
174: ,x_errorcode OUT NOCOPY NUMBER

Line 477: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

473: --
474: -- -----------------------------------------------------------------------------
475: PROCEDURE Process_Serial_Tag_Assignments (
476: p_api_version IN NUMBER
477: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
478: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
479: ,p_inventory_item_id IN NUMBER
480: ,p_organization_id IN NUMBER
481: ,p_template_id IN NUMBER

Line 478: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

474: -- -----------------------------------------------------------------------------
475: PROCEDURE Process_Serial_Tag_Assignments (
476: p_api_version IN NUMBER
477: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
478: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
479: ,p_inventory_item_id IN NUMBER
480: ,p_organization_id IN NUMBER
481: ,p_template_id IN NUMBER
482: ,p_serial_tag_assignments IN EGO_SERIAL_TAG_ASSIGN_TABLE