eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBC_CITEM_ADMIN_GRP dependencies on FND_API

Line 67: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false

63: --
64: -- --------------------------------------------------------------
65: PROCEDURE approve_item(
66: p_citem_ver_id IN NUMBER
67: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
68: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
69: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
70: ,px_object_version_number IN OUT NOCOPY NUMBER
71: ,x_return_status OUT NOCOPY VARCHAR2

Line 69: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

65: PROCEDURE approve_item(
66: p_citem_ver_id IN NUMBER
67: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
68: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
69: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
70: ,px_object_version_number IN OUT NOCOPY NUMBER
71: ,x_return_status OUT NOCOPY VARCHAR2
72: ,x_msg_count OUT NOCOPY NUMBER
73: ,x_msg_data OUT NOCOPY VARCHAR2

Line 95: ,p_cascaded_flag IN VARCHAR2 DEFAULT FND_API.g_false

91: --
92: -- --------------------------------------------------------------
93: PROCEDURE archive_item(
94: p_content_item_id IN NUMBER
95: ,p_cascaded_flag IN VARCHAR2 DEFAULT FND_API.g_false
96: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
97: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
98: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
99: ,px_object_version_number IN OUT NOCOPY NUMBER

Line 96: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false

92: -- --------------------------------------------------------------
93: PROCEDURE archive_item(
94: p_content_item_id IN NUMBER
95: ,p_cascaded_flag IN VARCHAR2 DEFAULT FND_API.g_false
96: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
97: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
98: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
99: ,px_object_version_number IN OUT NOCOPY NUMBER
100: ,x_return_status OUT NOCOPY VARCHAR2

Line 98: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

94: p_content_item_id IN NUMBER
95: ,p_cascaded_flag IN VARCHAR2 DEFAULT FND_API.g_false
96: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
97: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
98: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
99: ,px_object_version_number IN OUT NOCOPY NUMBER
100: ,x_return_status OUT NOCOPY VARCHAR2
101: ,x_msg_count OUT NOCOPY NUMBER
102: ,x_msg_data OUT NOCOPY VARCHAR2

Line 123: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false

119: PROCEDURE change_status(
120: p_citem_ver_id IN NUMBER
121: ,p_new_status IN VARCHAR2
122: ,p_language IN VARCHAR2 DEFAULT USERENV('LANG')
123: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
124: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
125: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
126: ,px_object_version_number IN OUT NOCOPY NUMBER
127: ,x_return_status OUT NOCOPY VARCHAR2

Line 125: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

121: ,p_new_status IN VARCHAR2
122: ,p_language IN VARCHAR2 DEFAULT USERENV('LANG')
123: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
124: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
125: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
126: ,px_object_version_number IN OUT NOCOPY NUMBER
127: ,x_return_status OUT NOCOPY VARCHAR2
128: ,x_msg_count OUT NOCOPY NUMBER
129: ,x_msg_data OUT NOCOPY VARCHAR2

Line 149: ,p_commit IN VARCHAR2 DEFAULT Fnd_Api.g_false

145: p_item_reference_code IN VARCHAR2 DEFAULT NULL
146: ,p_new_citem_name IN VARCHAR2
147: ,p_directory_node_id IN NUMBER
148: ,p_language IN VARCHAR2 DEFAULT USERENV('LANG')
149: ,p_commit IN VARCHAR2 DEFAULT Fnd_Api.g_false
150: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
151: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.g_false
152: ,px_content_item_id IN OUT NOCOPY NUMBER
153: ,px_citem_ver_id IN OUT NOCOPY NUMBER

Line 151: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.g_false

147: ,p_directory_node_id IN NUMBER
148: ,p_language IN VARCHAR2 DEFAULT USERENV('LANG')
149: ,p_commit IN VARCHAR2 DEFAULT Fnd_Api.g_false
150: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
151: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.g_false
152: ,px_content_item_id IN OUT NOCOPY NUMBER
153: ,px_citem_ver_id IN OUT NOCOPY NUMBER
154: ,px_object_version_number IN OUT NOCOPY NUMBER
155: ,x_return_status OUT NOCOPY VARCHAR2

Line 163: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false

159:
160: PROCEDURE copy_item(
161: p_item_reference_code IN VARCHAR2 DEFAULT NULL
162: ,p_language IN VARCHAR2 DEFAULT USERENV('LANG')
163: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
164: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
165: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
166: ,px_content_item_id IN OUT NOCOPY NUMBER
167: ,px_citem_ver_id IN OUT NOCOPY NUMBER

Line 165: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

161: p_item_reference_code IN VARCHAR2 DEFAULT NULL
162: ,p_language IN VARCHAR2 DEFAULT USERENV('LANG')
163: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
164: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
165: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
166: ,px_content_item_id IN OUT NOCOPY NUMBER
167: ,px_citem_ver_id IN OUT NOCOPY NUMBER
168: ,px_object_version_number IN OUT NOCOPY NUMBER
169: ,x_return_status OUT NOCOPY VARCHAR2

Line 184: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false

180: PROCEDURE copy_item(
181: p_item_reference_code IN VARCHAR2 DEFAULT NULL
182: ,p_directory_node_id IN NUMBER
183: ,p_language IN VARCHAR2 DEFAULT USERENV('LANG')
184: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
185: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
186: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
187: ,px_content_item_id IN OUT NOCOPY NUMBER
188: ,px_citem_ver_id IN OUT NOCOPY NUMBER

Line 186: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

182: ,p_directory_node_id IN NUMBER
183: ,p_language IN VARCHAR2 DEFAULT USERENV('LANG')
184: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
185: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
186: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
187: ,px_content_item_id IN OUT NOCOPY NUMBER
188: ,px_citem_ver_id IN OUT NOCOPY NUMBER
189: ,px_object_version_number IN OUT NOCOPY NUMBER
190: ,x_return_status OUT NOCOPY VARCHAR2

Line 204: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false

200: --
201: -- --------------------------------------------------------------
202: PROCEDURE copy_version(
203: p_language IN VARCHAR2 DEFAULT USERENV('LANG')
204: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
205: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
206: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
207: ,px_content_item_id IN OUT NOCOPY NUMBER
208: ,px_citem_ver_id IN OUT NOCOPY NUMBER

Line 206: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

202: PROCEDURE copy_version(
203: p_language IN VARCHAR2 DEFAULT USERENV('LANG')
204: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
205: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
206: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
207: ,px_content_item_id IN OUT NOCOPY NUMBER
208: ,px_citem_ver_id IN OUT NOCOPY NUMBER
209: ,px_object_version_number IN OUT NOCOPY NUMBER
210: ,x_return_status OUT NOCOPY VARCHAR2

Line 227: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false

223: PROCEDURE delete_component(
224: p_attribute_type_code IN VARCHAR2
225: ,p_citem_ver_id IN NUMBER
226: ,p_content_item_id IN NUMBER
227: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
228: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
229: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
230: ,x_return_status OUT NOCOPY VARCHAR2
231: ,x_msg_count OUT NOCOPY NUMBER

Line 229: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

225: ,p_citem_ver_id IN NUMBER
226: ,p_content_item_id IN NUMBER
227: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
228: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
229: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
230: ,x_return_status OUT NOCOPY VARCHAR2
231: ,x_msg_count OUT NOCOPY NUMBER
232: ,x_msg_data OUT NOCOPY VARCHAR2
233: );

Line 259: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false

255: ,p_associated_object_val2 IN VARCHAR2 DEFAULT NULL
256: ,p_associated_object_val3 IN VARCHAR2 DEFAULT NULL
257: ,p_associated_object_val4 IN VARCHAR2 DEFAULT NULL
258: ,p_associated_object_val5 IN VARCHAR2 DEFAULT NULL
259: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
260: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
261: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
262: ,x_return_status OUT NOCOPY VARCHAR2
263: ,x_msg_count OUT NOCOPY NUMBER

Line 261: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

257: ,p_associated_object_val4 IN VARCHAR2 DEFAULT NULL
258: ,p_associated_object_val5 IN VARCHAR2 DEFAULT NULL
259: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
260: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
261: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
262: ,x_return_status OUT NOCOPY VARCHAR2
263: ,x_msg_count OUT NOCOPY NUMBER
264: ,x_msg_data OUT NOCOPY VARCHAR2
265: );

Line 285: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

281: --
282: -- --------------------------------------------------------------
283: PROCEDURE get_attribute_bundle(
284: p_citem_ver_id IN NUMBER
285: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
286: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
287: ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100
288: ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
289: ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_32767

Line 299: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

295:
296: -- Overloaded for 4K limit support on attr values
297: PROCEDURE get_attribute_bundle(
298: p_citem_ver_id IN NUMBER
299: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
300: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
301: ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100
302: ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
303: ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_4000

Line 318: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

314: --
315: -- --------------------------------------------------------------
316: PROCEDURE get_item(
317: p_citem_ver_id IN NUMBER
318: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
319: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
320: ,x_content_item_id OUT NOCOPY NUMBER
321: ,x_citem_name OUT NOCOPY VARCHAR2
322: ,x_citem_version OUT NOCOPY NUMBER

Line 372: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

368: --
369: -- --------------------------------------------------------------
370: PROCEDURE get_item(
371: p_citem_ver_id IN NUMBER
372: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
373: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
374: ,x_content_item_id OUT NOCOPY NUMBER
375: ,x_citem_name OUT NOCOPY VARCHAR2
376: ,x_citem_version OUT NOCOPY NUMBER

Line 700: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

696: -- --------------------------------------------------------------
697: PROCEDURE get_trans_item(
698: p_citem_ver_id IN NUMBER
699: ,p_language IN VARCHAR2 DEFAULT USERENV('LANG')
700: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
701: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
702: ,x_content_item_id OUT NOCOPY NUMBER
703: ,x_citem_name OUT NOCOPY VARCHAR2
704: ,x_citem_version OUT NOCOPY NUMBER

Line 752: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

748: -- --------------------------------------------------------------
749: PROCEDURE get_trans_item(
750: p_citem_ver_id IN NUMBER
751: ,p_language IN VARCHAR2 DEFAULT USERENV('LANG')
752: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
753: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
754: ,x_content_item_id OUT NOCOPY NUMBER
755: ,x_citem_name OUT NOCOPY VARCHAR2
756: ,x_citem_version OUT NOCOPY NUMBER

Line 1037: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1033: --
1034: -- --------------------------------------------------------------
1035: PROCEDURE hard_delete_item_versions(
1036: p_api_version IN NUMBER,
1037: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1038: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1039: p_citem_version_ids IN JTF_NUMBER_TABLE,
1040: x_return_status OUT NOCOPY VARCHAR2,
1041: x_msg_count OUT NOCOPY NUMBER,

Line 1038: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1034: -- --------------------------------------------------------------
1035: PROCEDURE hard_delete_item_versions(
1036: p_api_version IN NUMBER,
1037: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1038: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1039: p_citem_version_ids IN JTF_NUMBER_TABLE,
1040: x_return_status OUT NOCOPY VARCHAR2,
1041: x_msg_count OUT NOCOPY NUMBER,
1042: x_msg_data OUT NOCOPY VARCHAR2

Line 1060: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1056: --
1057: -- --------------------------------------------------------------
1058: PROCEDURE hard_delete_items (
1059: p_api_version IN NUMBER,
1060: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1061: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1062: p_content_item_ids IN JTF_NUMBER_TABLE,
1063: x_return_status OUT NOCOPY VARCHAR2,
1064: x_msg_count OUT NOCOPY NUMBER,

Line 1061: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1057: -- --------------------------------------------------------------
1058: PROCEDURE hard_delete_items (
1059: p_api_version IN NUMBER,
1060: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1061: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1062: p_content_item_ids IN JTF_NUMBER_TABLE,
1063: x_return_status OUT NOCOPY VARCHAR2,
1064: x_msg_count OUT NOCOPY NUMBER,
1065: x_msg_data OUT NOCOPY VARCHAR2

Line 1086: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false

1082: ,p_content_item_ids IN JTF_NUMBER_TABLE
1083: ,p_citem_ver_ids IN JTF_NUMBER_TABLE
1084: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100
1085: ,p_sort_order IN JTF_NUMBER_TABLE DEFAULT NULL
1086: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1087: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1088: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1089: ,x_return_status OUT NOCOPY VARCHAR2
1090: ,x_msg_count OUT NOCOPY NUMBER

Line 1088: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

1084: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100
1085: ,p_sort_order IN JTF_NUMBER_TABLE DEFAULT NULL
1086: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1087: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1088: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1089: ,x_return_status OUT NOCOPY VARCHAR2
1090: ,x_msg_count OUT NOCOPY NUMBER
1091: ,x_msg_data OUT NOCOPY VARCHAR2
1092: );

Line 1103: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false

1099: p_citem_ver_id IN NUMBER
1100: ,p_content_item_ids IN JTF_NUMBER_TABLE
1101: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100
1102: ,p_sort_order IN JTF_NUMBER_TABLE DEFAULT NULL
1103: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1104: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1105: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1106: ,x_return_status OUT NOCOPY VARCHAR2
1107: ,x_msg_count OUT NOCOPY NUMBER

Line 1105: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

1101: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100
1102: ,p_sort_order IN JTF_NUMBER_TABLE DEFAULT NULL
1103: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1104: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1105: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1106: ,x_return_status OUT NOCOPY VARCHAR2
1107: ,x_msg_count OUT NOCOPY NUMBER
1108: ,x_msg_data OUT NOCOPY VARCHAR2
1109: );

Line 1132: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false

1128: ,p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL
1129: ,p_assoc_objects3 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL
1130: ,p_assoc_objects4 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL
1131: ,p_assoc_objects5 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL
1132: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1133: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1134: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1135: ,x_return_status OUT NOCOPY VARCHAR2
1136: ,x_msg_count OUT NOCOPY NUMBER

Line 1134: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

1130: ,p_assoc_objects4 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL
1131: ,p_assoc_objects5 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL
1132: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1133: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1134: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1135: ,x_return_status OUT NOCOPY VARCHAR2
1136: ,x_msg_count OUT NOCOPY NUMBER
1137: ,x_msg_data OUT NOCOPY VARCHAR2
1138: );

Line 1149: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false

1145: ,p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL
1146: ,p_assoc_objects3 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL
1147: ,p_assoc_objects4 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL
1148: ,p_assoc_objects5 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL
1149: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1150: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1151: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1152: ,x_return_status OUT NOCOPY VARCHAR2
1153: ,x_msg_count OUT NOCOPY NUMBER

Line 1151: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

1147: ,p_assoc_objects4 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL
1148: ,p_assoc_objects5 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL
1149: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1150: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1151: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1152: ,x_return_status OUT NOCOPY VARCHAR2
1153: ,x_msg_count OUT NOCOPY NUMBER
1154: ,x_msg_data OUT NOCOPY VARCHAR2
1155: );

Line 1168: ,p_lock_flag IN VARCHAR2 DEFAULT FND_API.g_true

1164: PROCEDURE insert_minimum_item(
1165: p_ctype_code IN VARCHAR2
1166: ,p_citem_name IN VARCHAR2
1167: ,p_citem_description IN VARCHAR2 DEFAULT NULL
1168: ,p_lock_flag IN VARCHAR2 DEFAULT FND_API.g_true
1169: ,p_dir_node_id IN NUMBER DEFAULT IBC_UTILITIES_PUB.G_COMMON_DIR_NODE
1170: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1171: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1172: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

Line 1170: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false

1166: ,p_citem_name IN VARCHAR2
1167: ,p_citem_description IN VARCHAR2 DEFAULT NULL
1168: ,p_lock_flag IN VARCHAR2 DEFAULT FND_API.g_true
1169: ,p_dir_node_id IN NUMBER DEFAULT IBC_UTILITIES_PUB.G_COMMON_DIR_NODE
1170: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1171: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1172: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1173: ,px_content_item_id IN OUT NOCOPY NUMBER
1174: ,px_object_version_number IN OUT NOCOPY NUMBER

Line 1172: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

1168: ,p_lock_flag IN VARCHAR2 DEFAULT FND_API.g_true
1169: ,p_dir_node_id IN NUMBER DEFAULT IBC_UTILITIES_PUB.G_COMMON_DIR_NODE
1170: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1171: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1172: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1173: ,px_content_item_id IN OUT NOCOPY NUMBER
1174: ,px_object_version_number IN OUT NOCOPY NUMBER
1175: ,x_citem_ver_id OUT NOCOPY NUMBER
1176: ,x_return_status OUT NOCOPY VARCHAR2

Line 1198: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_true

1194: -- --------------------------------------------------------------
1195:
1196: PROCEDURE lock_item(
1197: p_content_item_id IN NUMBER
1198: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_true
1199: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1200: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1201: ,x_citem_version_id OUT NOCOPY NUMBER
1202: ,x_object_version_number OUT NOCOPY NUMBER

Line 1200: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

1196: PROCEDURE lock_item(
1197: p_content_item_id IN NUMBER
1198: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_true
1199: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1200: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1201: ,x_citem_version_id OUT NOCOPY NUMBER
1202: ,x_object_version_number OUT NOCOPY NUMBER
1203: ,x_return_status OUT NOCOPY VARCHAR2
1204: ,x_msg_count OUT NOCOPY NUMBER

Line 1238: ,p_remove_old IN VARCHAR2 DEFAULT FND_API.g_false

1234: PROCEDURE set_attribute_bundle(
1235: p_citem_ver_id IN NUMBER
1236: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100
1237: ,p_attributes IN JTF_VARCHAR2_TABLE_4000
1238: ,p_remove_old IN VARCHAR2 DEFAULT FND_API.g_false
1239: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1240: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1241: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1242: ,px_object_version_number IN OUT NOCOPY NUMBER

Line 1239: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false

1235: p_citem_ver_id IN NUMBER
1236: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100
1237: ,p_attributes IN JTF_VARCHAR2_TABLE_4000
1238: ,p_remove_old IN VARCHAR2 DEFAULT FND_API.g_false
1239: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1240: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1241: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1242: ,px_object_version_number IN OUT NOCOPY NUMBER
1243: ,x_return_status OUT NOCOPY VARCHAR2

Line 1241: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

1237: ,p_attributes IN JTF_VARCHAR2_TABLE_4000
1238: ,p_remove_old IN VARCHAR2 DEFAULT FND_API.g_false
1239: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1240: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1241: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1242: ,px_object_version_number IN OUT NOCOPY NUMBER
1243: ,x_return_status OUT NOCOPY VARCHAR2
1244: ,x_msg_count OUT NOCOPY NUMBER
1245: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1253: ,p_remove_old IN VARCHAR2 DEFAULT FND_API.g_false

1249: PROCEDURE set_attribute_bundle(
1250: p_citem_ver_id IN NUMBER
1251: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100
1252: ,p_attributes IN JTF_VARCHAR2_TABLE_32767
1253: ,p_remove_old IN VARCHAR2 DEFAULT FND_API.g_false
1254: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1255: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1256: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1257: ,px_object_version_number IN OUT NOCOPY NUMBER

Line 1254: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false

1250: p_citem_ver_id IN NUMBER
1251: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100
1252: ,p_attributes IN JTF_VARCHAR2_TABLE_32767
1253: ,p_remove_old IN VARCHAR2 DEFAULT FND_API.g_false
1254: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1255: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1256: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1257: ,px_object_version_number IN OUT NOCOPY NUMBER
1258: ,x_return_status OUT NOCOPY VARCHAR2

Line 1256: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

1252: ,p_attributes IN JTF_VARCHAR2_TABLE_32767
1253: ,p_remove_old IN VARCHAR2 DEFAULT FND_API.g_false
1254: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1255: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1256: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1257: ,px_object_version_number IN OUT NOCOPY NUMBER
1258: ,x_return_status OUT NOCOPY VARCHAR2
1259: ,x_msg_count OUT NOCOPY NUMBER
1260: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1279: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false

1275: PROCEDURE set_attachment(
1276: p_citem_ver_id IN NUMBER
1277: ,p_attach_file_id IN NUMBER
1278: ,p_language IN VARCHAR2 DEFAULT USERENV('LANG')
1279: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1280: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1281: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1282: ,px_object_version_number IN OUT NOCOPY NUMBER
1283: ,x_return_status OUT NOCOPY VARCHAR2

Line 1281: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

1277: ,p_attach_file_id IN NUMBER
1278: ,p_language IN VARCHAR2 DEFAULT USERENV('LANG')
1279: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1280: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1281: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1282: ,px_object_version_number IN OUT NOCOPY NUMBER
1283: ,x_return_status OUT NOCOPY VARCHAR2
1284: ,x_msg_count OUT NOCOPY NUMBER
1285: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1308: ,p_trans_required IN VARCHAR2 DEFAULT FND_API.g_false

1304: -- --------------------------------------------------------------
1305: PROCEDURE set_citem_meta(
1306: p_content_item_id IN NUMBER
1307: ,p_dir_node_id IN NUMBER DEFAULT Ibc_Utilities_Pub.G_COMMON_DIR_NODE
1308: ,p_trans_required IN VARCHAR2 DEFAULT FND_API.g_false
1309: ,p_owner_resource_id IN NUMBER DEFAULT NULL
1310: ,p_owner_resource_type IN VARCHAR2 DEFAULT NULL
1311: ,p_parent_item_id IN NUMBER DEFAULT NULL
1312: ,p_wd_restricted IN VARCHAR2 DEFAULT FND_API.g_false

Line 1312: ,p_wd_restricted IN VARCHAR2 DEFAULT FND_API.g_false

1308: ,p_trans_required IN VARCHAR2 DEFAULT FND_API.g_false
1309: ,p_owner_resource_id IN NUMBER DEFAULT NULL
1310: ,p_owner_resource_type IN VARCHAR2 DEFAULT NULL
1311: ,p_parent_item_id IN NUMBER DEFAULT NULL
1312: ,p_wd_restricted IN VARCHAR2 DEFAULT FND_API.g_false
1313: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1314: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1315: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1316: ,px_object_version_number IN OUT NOCOPY NUMBER

Line 1313: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false

1309: ,p_owner_resource_id IN NUMBER DEFAULT NULL
1310: ,p_owner_resource_type IN VARCHAR2 DEFAULT NULL
1311: ,p_parent_item_id IN NUMBER DEFAULT NULL
1312: ,p_wd_restricted IN VARCHAR2 DEFAULT FND_API.g_false
1313: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1314: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1315: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1316: ,px_object_version_number IN OUT NOCOPY NUMBER
1317: ,x_return_status OUT NOCOPY VARCHAR2

Line 1314: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

1310: ,p_owner_resource_type IN VARCHAR2 DEFAULT NULL
1311: ,p_parent_item_id IN NUMBER DEFAULT NULL
1312: ,p_wd_restricted IN VARCHAR2 DEFAULT FND_API.g_false
1313: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1314: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1315: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1316: ,px_object_version_number IN OUT NOCOPY NUMBER
1317: ,x_return_status OUT NOCOPY VARCHAR2
1318: ,x_msg_count OUT NOCOPY NUMBER

Line 1336: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false

1332: -- --------------------------------------------------------------
1333: PROCEDURE Set_Live_Version(
1334: p_content_item_id IN NUMBER
1335: ,p_citem_ver_id IN NUMBER
1336: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1337: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1338: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1339: ,px_object_version_number IN OUT NOCOPY NUMBER
1340: ,x_return_status OUT NOCOPY VARCHAR2

Line 1338: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

1334: p_content_item_id IN NUMBER
1335: ,p_citem_ver_id IN NUMBER
1336: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1337: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1338: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1339: ,px_object_version_number IN OUT NOCOPY NUMBER
1340: ,x_return_status OUT NOCOPY VARCHAR2
1341: ,x_msg_count OUT NOCOPY NUMBER
1342: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1359: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false

1355: ,p_citem_name IN VARCHAR2 DEFAULT NULL
1356: ,p_citem_description IN VARCHAR2 DEFAULT NULL
1357: ,p_start_date IN DATE DEFAULT NULL
1358: ,p_end_date IN DATE DEFAULT NULL
1359: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1360: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1361: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1362: ,px_object_version_number IN OUT NOCOPY NUMBER
1363: ,x_return_status OUT NOCOPY VARCHAR2

Line 1360: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

1356: ,p_citem_description IN VARCHAR2 DEFAULT NULL
1357: ,p_start_date IN DATE DEFAULT NULL
1358: ,p_end_date IN DATE DEFAULT NULL
1359: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1360: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1361: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1362: ,px_object_version_number IN OUT NOCOPY NUMBER
1363: ,x_return_status OUT NOCOPY VARCHAR2
1364: ,x_msg_count OUT NOCOPY NUMBER

Line 1384: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false

1380: --
1381: -- --------------------------------------------------------------
1382: PROCEDURE unarchive_item(
1383: p_content_item_id IN NUMBER
1384: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1385: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1386: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1387: ,px_object_version_number IN OUT NOCOPY NUMBER
1388: ,x_return_status OUT NOCOPY VARCHAR2

Line 1386: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

1382: PROCEDURE unarchive_item(
1383: p_content_item_id IN NUMBER
1384: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1385: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1386: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1387: ,px_object_version_number IN OUT NOCOPY NUMBER
1388: ,x_return_status OUT NOCOPY VARCHAR2
1389: ,x_msg_count OUT NOCOPY NUMBER
1390: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1410: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_true

1406: -- --------------------------------------------------------------
1407:
1408: PROCEDURE unlock_item(
1409: p_content_item_id IN NUMBER
1410: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_true
1411: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1412: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1413: ,x_return_status OUT NOCOPY VARCHAR2
1414: ,x_msg_count OUT NOCOPY NUMBER

Line 1412: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

1408: PROCEDURE unlock_item(
1409: p_content_item_id IN NUMBER
1410: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_true
1411: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1412: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1413: ,x_return_status OUT NOCOPY VARCHAR2
1414: ,x_msg_count OUT NOCOPY NUMBER
1415: ,x_msg_data OUT NOCOPY VARCHAR2
1416: );

Line 1435: ,p_trans_required IN VARCHAR2 DEFAULT FND_API.g_false

1431: ,p_dir_node_id IN NUMBER DEFAULT IBC_UTILITIES_PUB.G_COMMON_DIR_NODE
1432: ,p_owner_resource_id IN NUMBER DEFAULT NULL
1433: ,p_owner_resource_type IN VARCHAR2 DEFAULT NULL
1434: ,p_reference_code IN VARCHAR2 DEFAULT NULL
1435: ,p_trans_required IN VARCHAR2 DEFAULT FND_API.g_false
1436: ,p_parent_item_id IN NUMBER DEFAULT NULL
1437: ,p_lock_flag IN VARCHAR2 DEFAULT FND_API.g_true
1438: ,p_wd_restricted IN VARCHAR2 DEFAULT FND_API.g_true
1439: ,p_start_date IN DATE DEFAULT NULL

Line 1437: ,p_lock_flag IN VARCHAR2 DEFAULT FND_API.g_true

1433: ,p_owner_resource_type IN VARCHAR2 DEFAULT NULL
1434: ,p_reference_code IN VARCHAR2 DEFAULT NULL
1435: ,p_trans_required IN VARCHAR2 DEFAULT FND_API.g_false
1436: ,p_parent_item_id IN NUMBER DEFAULT NULL
1437: ,p_lock_flag IN VARCHAR2 DEFAULT FND_API.g_true
1438: ,p_wd_restricted IN VARCHAR2 DEFAULT FND_API.g_true
1439: ,p_start_date IN DATE DEFAULT NULL
1440: ,p_end_date IN DATE DEFAULT NULL
1441: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL

Line 1438: ,p_wd_restricted IN VARCHAR2 DEFAULT FND_API.g_true

1434: ,p_reference_code IN VARCHAR2 DEFAULT NULL
1435: ,p_trans_required IN VARCHAR2 DEFAULT FND_API.g_false
1436: ,p_parent_item_id IN NUMBER DEFAULT NULL
1437: ,p_lock_flag IN VARCHAR2 DEFAULT FND_API.g_true
1438: ,p_wd_restricted IN VARCHAR2 DEFAULT FND_API.g_true
1439: ,p_start_date IN DATE DEFAULT NULL
1440: ,p_end_date IN DATE DEFAULT NULL
1441: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL
1442: ,p_attributes IN JTF_VARCHAR2_TABLE_4000 DEFAULT NULL

Line 1448: ,p_log_action IN VARCHAR2 DEFAULT FND_API.g_true

1444: ,p_component_citems IN JTF_NUMBER_TABLE DEFAULT NULL
1445: ,p_component_atypes IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL
1446: ,p_sort_order IN JTF_NUMBER_TABLE DEFAULT NULL
1447: ,p_status IN VARCHAR2 DEFAULT IBC_UTILITIES_PUB.G_STV_WORK_IN_PROGRESS
1448: ,p_log_action IN VARCHAR2 DEFAULT FND_API.g_true
1449: ,p_language IN VARCHAR2 DEFAULT USERENV('LANG')
1450: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_true
1451: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1452: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

Line 1450: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_true

1446: ,p_sort_order IN JTF_NUMBER_TABLE DEFAULT NULL
1447: ,p_status IN VARCHAR2 DEFAULT IBC_UTILITIES_PUB.G_STV_WORK_IN_PROGRESS
1448: ,p_log_action IN VARCHAR2 DEFAULT FND_API.g_true
1449: ,p_language IN VARCHAR2 DEFAULT USERENV('LANG')
1450: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_true
1451: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1452: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1453: ,px_content_item_id IN OUT NOCOPY NUMBER
1454: ,px_citem_ver_id IN OUT NOCOPY NUMBER

Line 1452: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

1448: ,p_log_action IN VARCHAR2 DEFAULT FND_API.g_true
1449: ,p_language IN VARCHAR2 DEFAULT USERENV('LANG')
1450: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_true
1451: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1452: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1453: ,px_content_item_id IN OUT NOCOPY NUMBER
1454: ,px_citem_ver_id IN OUT NOCOPY NUMBER
1455: ,px_object_version_number IN OUT NOCOPY NUMBER
1456: ,x_return_status OUT NOCOPY VARCHAR2

Line 1473: ,p_trans_required IN VARCHAR2 DEFAULT FND_API.g_false

1469: ,p_dir_node_id IN NUMBER DEFAULT Ibc_Utilities_Pub.G_COMMON_DIR_NODE
1470: ,p_owner_resource_id IN NUMBER DEFAULT NULL
1471: ,p_owner_resource_type IN VARCHAR2 DEFAULT NULL
1472: ,p_reference_code IN VARCHAR2 DEFAULT NULL
1473: ,p_trans_required IN VARCHAR2 DEFAULT FND_API.g_false
1474: ,p_parent_item_id IN NUMBER DEFAULT NULL
1475: ,p_lock_flag IN VARCHAR2 DEFAULT FND_API.g_true
1476: ,p_wd_restricted IN VARCHAR2 DEFAULT FND_API.g_true
1477: ,p_start_date IN DATE DEFAULT NULL

Line 1475: ,p_lock_flag IN VARCHAR2 DEFAULT FND_API.g_true

1471: ,p_owner_resource_type IN VARCHAR2 DEFAULT NULL
1472: ,p_reference_code IN VARCHAR2 DEFAULT NULL
1473: ,p_trans_required IN VARCHAR2 DEFAULT FND_API.g_false
1474: ,p_parent_item_id IN NUMBER DEFAULT NULL
1475: ,p_lock_flag IN VARCHAR2 DEFAULT FND_API.g_true
1476: ,p_wd_restricted IN VARCHAR2 DEFAULT FND_API.g_true
1477: ,p_start_date IN DATE DEFAULT NULL
1478: ,p_end_date IN DATE DEFAULT NULL
1479: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL

Line 1476: ,p_wd_restricted IN VARCHAR2 DEFAULT FND_API.g_true

1472: ,p_reference_code IN VARCHAR2 DEFAULT NULL
1473: ,p_trans_required IN VARCHAR2 DEFAULT FND_API.g_false
1474: ,p_parent_item_id IN NUMBER DEFAULT NULL
1475: ,p_lock_flag IN VARCHAR2 DEFAULT FND_API.g_true
1476: ,p_wd_restricted IN VARCHAR2 DEFAULT FND_API.g_true
1477: ,p_start_date IN DATE DEFAULT NULL
1478: ,p_end_date IN DATE DEFAULT NULL
1479: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL
1480: ,p_attributes IN JTF_VARCHAR2_TABLE_4000 DEFAULT NULL

Line 1487: ,p_log_action IN VARCHAR2 DEFAULT FND_API.g_true

1483: ,p_component_citems IN JTF_NUMBER_TABLE DEFAULT NULL
1484: ,p_component_atypes IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL
1485: ,p_sort_order IN JTF_NUMBER_TABLE DEFAULT NULL
1486: ,p_status IN VARCHAR2 DEFAULT Ibc_Utilities_Pub.G_STV_WORK_IN_PROGRESS
1487: ,p_log_action IN VARCHAR2 DEFAULT FND_API.g_true
1488: ,p_language IN VARCHAR2 DEFAULT USERENV('LANG')
1489: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_true
1490: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1491: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

Line 1489: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_true

1485: ,p_sort_order IN JTF_NUMBER_TABLE DEFAULT NULL
1486: ,p_status IN VARCHAR2 DEFAULT Ibc_Utilities_Pub.G_STV_WORK_IN_PROGRESS
1487: ,p_log_action IN VARCHAR2 DEFAULT FND_API.g_true
1488: ,p_language IN VARCHAR2 DEFAULT USERENV('LANG')
1489: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_true
1490: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1491: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1492: ,px_content_item_id IN OUT NOCOPY NUMBER
1493: ,px_citem_ver_id IN OUT NOCOPY NUMBER

Line 1491: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

1487: ,p_log_action IN VARCHAR2 DEFAULT FND_API.g_true
1488: ,p_language IN VARCHAR2 DEFAULT USERENV('LANG')
1489: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_true
1490: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1491: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1492: ,px_content_item_id IN OUT NOCOPY NUMBER
1493: ,px_citem_ver_id IN OUT NOCOPY NUMBER
1494: ,px_object_version_number IN OUT NOCOPY NUMBER
1495: ,x_return_status OUT NOCOPY VARCHAR2

Line 1687: ,p_trans_required IN VARCHAR2 DEFAULT FND_API.g_false

1683: ,p_dir_node_id IN NUMBER DEFAULT Ibc_Utilities_Pub.G_COMMON_DIR_NODE
1684: ,p_owner_resource_id IN NUMBER DEFAULT NULL
1685: ,p_owner_resource_type IN VARCHAR2 DEFAULT NULL
1686: ,p_reference_code IN VARCHAR2 DEFAULT NULL
1687: ,p_trans_required IN VARCHAR2 DEFAULT FND_API.g_false
1688: ,p_parent_item_id IN NUMBER DEFAULT NULL
1689: ,p_lock_flag IN VARCHAR2 DEFAULT FND_API.g_true
1690: ,p_wd_restricted IN VARCHAR2 DEFAULT FND_API.g_true
1691: ,p_start_date IN DATE DEFAULT NULL

Line 1689: ,p_lock_flag IN VARCHAR2 DEFAULT FND_API.g_true

1685: ,p_owner_resource_type IN VARCHAR2 DEFAULT NULL
1686: ,p_reference_code IN VARCHAR2 DEFAULT NULL
1687: ,p_trans_required IN VARCHAR2 DEFAULT FND_API.g_false
1688: ,p_parent_item_id IN NUMBER DEFAULT NULL
1689: ,p_lock_flag IN VARCHAR2 DEFAULT FND_API.g_true
1690: ,p_wd_restricted IN VARCHAR2 DEFAULT FND_API.g_true
1691: ,p_start_date IN DATE DEFAULT NULL
1692: ,p_end_date IN DATE DEFAULT NULL
1693: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL

Line 1690: ,p_wd_restricted IN VARCHAR2 DEFAULT FND_API.g_true

1686: ,p_reference_code IN VARCHAR2 DEFAULT NULL
1687: ,p_trans_required IN VARCHAR2 DEFAULT FND_API.g_false
1688: ,p_parent_item_id IN NUMBER DEFAULT NULL
1689: ,p_lock_flag IN VARCHAR2 DEFAULT FND_API.g_true
1690: ,p_wd_restricted IN VARCHAR2 DEFAULT FND_API.g_true
1691: ,p_start_date IN DATE DEFAULT NULL
1692: ,p_end_date IN DATE DEFAULT NULL
1693: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL
1694: ,p_attributes IN JTF_VARCHAR2_TABLE_4000 DEFAULT NULL

Line 1701: ,p_log_action IN VARCHAR2 DEFAULT FND_API.g_true

1697: ,p_component_citems IN JTF_NUMBER_TABLE DEFAULT NULL
1698: ,p_component_atypes IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL
1699: ,p_sort_order IN JTF_NUMBER_TABLE DEFAULT NULL
1700: ,p_status IN VARCHAR2 DEFAULT Ibc_Utilities_Pub.G_STV_WORK_IN_PROGRESS
1701: ,p_log_action IN VARCHAR2 DEFAULT FND_API.g_true
1702: ,p_language IN VARCHAR2 DEFAULT USERENV('LANG')
1703: ,p_update IN VARCHAR2 DEFAULT FND_API.g_false
1704: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_true
1705: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT

Line 1703: ,p_update IN VARCHAR2 DEFAULT FND_API.g_false

1699: ,p_sort_order IN JTF_NUMBER_TABLE DEFAULT NULL
1700: ,p_status IN VARCHAR2 DEFAULT Ibc_Utilities_Pub.G_STV_WORK_IN_PROGRESS
1701: ,p_log_action IN VARCHAR2 DEFAULT FND_API.g_true
1702: ,p_language IN VARCHAR2 DEFAULT USERENV('LANG')
1703: ,p_update IN VARCHAR2 DEFAULT FND_API.g_false
1704: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_true
1705: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1706: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1707: ,px_content_item_id IN OUT NOCOPY NUMBER

Line 1704: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_true

1700: ,p_status IN VARCHAR2 DEFAULT Ibc_Utilities_Pub.G_STV_WORK_IN_PROGRESS
1701: ,p_log_action IN VARCHAR2 DEFAULT FND_API.g_true
1702: ,p_language IN VARCHAR2 DEFAULT USERENV('LANG')
1703: ,p_update IN VARCHAR2 DEFAULT FND_API.g_false
1704: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_true
1705: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1706: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1707: ,px_content_item_id IN OUT NOCOPY NUMBER
1708: ,px_citem_ver_id IN OUT NOCOPY NUMBER

Line 1706: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

1702: ,p_language IN VARCHAR2 DEFAULT USERENV('LANG')
1703: ,p_update IN VARCHAR2 DEFAULT FND_API.g_false
1704: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_true
1705: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1706: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1707: ,px_content_item_id IN OUT NOCOPY NUMBER
1708: ,px_citem_ver_id IN OUT NOCOPY NUMBER
1709: ,px_object_version_number IN OUT NOCOPY NUMBER
1710: ,x_return_status OUT NOCOPY VARCHAR2

Line 1728: ,p_trans_required IN VARCHAR2 DEFAULT FND_API.g_false

1724: ,p_dir_node_id IN NUMBER DEFAULT Ibc_Utilities_Pub.G_COMMON_DIR_NODE
1725: ,p_owner_resource_id IN NUMBER DEFAULT NULL
1726: ,p_owner_resource_type IN VARCHAR2 DEFAULT NULL
1727: ,p_reference_code IN VARCHAR2 DEFAULT NULL
1728: ,p_trans_required IN VARCHAR2 DEFAULT FND_API.g_false
1729: ,p_parent_item_id IN NUMBER DEFAULT NULL
1730: ,p_lock_flag IN VARCHAR2 DEFAULT FND_API.g_true
1731: ,p_wd_restricted IN VARCHAR2 DEFAULT FND_API.g_true
1732: ,p_start_date IN DATE DEFAULT NULL

Line 1730: ,p_lock_flag IN VARCHAR2 DEFAULT FND_API.g_true

1726: ,p_owner_resource_type IN VARCHAR2 DEFAULT NULL
1727: ,p_reference_code IN VARCHAR2 DEFAULT NULL
1728: ,p_trans_required IN VARCHAR2 DEFAULT FND_API.g_false
1729: ,p_parent_item_id IN NUMBER DEFAULT NULL
1730: ,p_lock_flag IN VARCHAR2 DEFAULT FND_API.g_true
1731: ,p_wd_restricted IN VARCHAR2 DEFAULT FND_API.g_true
1732: ,p_start_date IN DATE DEFAULT NULL
1733: ,p_end_date IN DATE DEFAULT NULL
1734: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL

Line 1731: ,p_wd_restricted IN VARCHAR2 DEFAULT FND_API.g_true

1727: ,p_reference_code IN VARCHAR2 DEFAULT NULL
1728: ,p_trans_required IN VARCHAR2 DEFAULT FND_API.g_false
1729: ,p_parent_item_id IN NUMBER DEFAULT NULL
1730: ,p_lock_flag IN VARCHAR2 DEFAULT FND_API.g_true
1731: ,p_wd_restricted IN VARCHAR2 DEFAULT FND_API.g_true
1732: ,p_start_date IN DATE DEFAULT NULL
1733: ,p_end_date IN DATE DEFAULT NULL
1734: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL
1735: ,p_attributes IN JTF_VARCHAR2_TABLE_4000 DEFAULT NULL

Line 1741: ,p_log_action IN VARCHAR2 DEFAULT FND_API.g_true

1737: ,p_component_citems IN JTF_NUMBER_TABLE DEFAULT NULL
1738: ,p_component_atypes IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL
1739: ,p_sort_order IN JTF_NUMBER_TABLE DEFAULT NULL
1740: ,p_status IN VARCHAR2 DEFAULT Ibc_Utilities_Pub.G_STV_WORK_IN_PROGRESS
1741: ,p_log_action IN VARCHAR2 DEFAULT FND_API.g_true
1742: ,p_language IN VARCHAR2 DEFAULT USERENV('LANG')
1743: ,p_update IN VARCHAR2 DEFAULT FND_API.g_false
1744: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_true
1745: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT

Line 1743: ,p_update IN VARCHAR2 DEFAULT FND_API.g_false

1739: ,p_sort_order IN JTF_NUMBER_TABLE DEFAULT NULL
1740: ,p_status IN VARCHAR2 DEFAULT Ibc_Utilities_Pub.G_STV_WORK_IN_PROGRESS
1741: ,p_log_action IN VARCHAR2 DEFAULT FND_API.g_true
1742: ,p_language IN VARCHAR2 DEFAULT USERENV('LANG')
1743: ,p_update IN VARCHAR2 DEFAULT FND_API.g_false
1744: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_true
1745: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1746: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1747: ,px_content_item_id IN OUT NOCOPY NUMBER

Line 1744: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_true

1740: ,p_status IN VARCHAR2 DEFAULT Ibc_Utilities_Pub.G_STV_WORK_IN_PROGRESS
1741: ,p_log_action IN VARCHAR2 DEFAULT FND_API.g_true
1742: ,p_language IN VARCHAR2 DEFAULT USERENV('LANG')
1743: ,p_update IN VARCHAR2 DEFAULT FND_API.g_false
1744: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_true
1745: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1746: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1747: ,px_content_item_id IN OUT NOCOPY NUMBER
1748: ,px_citem_ver_id IN OUT NOCOPY NUMBER

Line 1746: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

1742: ,p_language IN VARCHAR2 DEFAULT USERENV('LANG')
1743: ,p_update IN VARCHAR2 DEFAULT FND_API.g_false
1744: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_true
1745: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1746: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1747: ,px_content_item_id IN OUT NOCOPY NUMBER
1748: ,px_citem_ver_id IN OUT NOCOPY NUMBER
1749: ,px_object_version_number IN OUT NOCOPY NUMBER
1750: ,x_return_status OUT NOCOPY VARCHAR2

Line 1767: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false

1763: PROCEDURE Change_Translation_Status(
1764: p_citem_ver_id IN NUMBER
1765: ,p_new_status IN VARCHAR2
1766: ,p_language IN VARCHAR2 DEFAULT USERENV('LANG')
1767: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1768: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1769: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1770: ,px_object_version_number IN OUT NOCOPY NUMBER
1771: ,x_return_status OUT NOCOPY VARCHAR2

Line 1769: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

1765: ,p_new_status IN VARCHAR2
1766: ,p_language IN VARCHAR2 DEFAULT USERENV('LANG')
1767: ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1768: ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1769: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1770: ,px_object_version_number IN OUT NOCOPY NUMBER
1771: ,x_return_status OUT NOCOPY VARCHAR2
1772: ,x_msg_count OUT NOCOPY NUMBER
1773: ,x_msg_data OUT NOCOPY VARCHAR2