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 STANDARD

Line 22: -- Function Conv_To_TblHandler created for STANDARD/perf change for

18: -- -------------------
19: -- ----- PRIVATE -----
20: -- -------------------
21:
22: -- Function Conv_To_TblHandler created for STANDARD/perf change for
23: -- the use of G_MISS_xxx variables.
24:
25: FUNCTION Conv_To_TblHandler(p_value IN DATE) RETURN DATE
26: IS

Line 3077: ,p_LOCKED_BY_USER_ID => FND_API.G_MISS_NUM -- Updated for STANDARD/perf change of G_MISS_xxx

3073: Ibc_Content_Items_Pkg.update_row (
3074: p_CONTENT_ITEM_ID => p_content_item_id
3075: ,p_LIVE_CITEM_VERSION_ID => p_citem_ver_id
3076: ,p_CONTENT_ITEM_STATUS => Ibc_Utilities_Pub.G_STI_APPROVED
3077: ,p_LOCKED_BY_USER_ID => FND_API.G_MISS_NUM -- Updated for STANDARD/perf change of G_MISS_xxx
3078: ,px_object_version_number => px_object_version_number
3079: );
3080:
3081: --DBMS_OUTPUT.put_line('POPULATING ALL LANGS');

Line 3436: -- Standard call to check for call compatibility. --|**|

3432: IF (p_init_msg_list = FND_API.g_true) THEN --|**|
3433: FND_MSG_PUB.initialize; --|**|
3434: END IF; --|**|
3435: --|**|
3436: -- Standard call to check for call compatibility. --|**|
3437: IF NOT FND_API.Compatible_API_Call ( --|**|
3438: l_api_version_number --|**|
3439: ,p_api_version_number --|**|
3440: ,l_api_name --|**|

Line 3582: -- Standard call to get message count and if count is 1, get message info.

3578: IF ( (x_return_status = FND_API.G_RET_STS_SUCCESS) AND (p_commit = FND_API.g_true) ) THEN
3579: COMMIT;
3580: END IF;
3581:
3582: -- Standard call to get message count and if count is 1, get message info.
3583: FND_MSG_PUB.Count_And_Get(
3584: p_count => x_msg_count,
3585: p_data => x_msg_data
3586: );

Line 3727: -- Standard call to check for call compatibility. --|**|

3723: IF (p_init_msg_list = FND_API.g_true) THEN --|**|
3724: FND_MSG_PUB.initialize; --|**|
3725: END IF; --|**|
3726: --|**|
3727: -- Standard call to check for call compatibility. --|**|
3728: IF NOT FND_API.Compatible_API_Call ( --|**|
3729: l_api_version_number --|**|
3730: ,p_api_version_number --|**|
3731: ,l_api_name --|**|

Line 3884: ,p_locked_by_user_id => FND_API.G_MISS_NUM -- Updated for STANDARD/perf change of G_MISS_xxx

3880: IF p_cascaded_flag = FND_API.g_false THEN
3881: Ibc_Content_Items_Pkg.update_row (
3882: p_content_item_id => p_content_item_id
3883: ,p_content_item_status => Ibc_Utilities_Pub.G_STI_ARCHIVED
3884: ,p_locked_by_user_id => FND_API.G_MISS_NUM -- Updated for STANDARD/perf change of G_MISS_xxx
3885: ,px_object_version_number => px_object_version_number
3886: );
3887: ELSE
3888: Ibc_Content_Items_Pkg.update_row (

Line 3891: ,p_locked_by_user_id => FND_API.G_MISS_NUM -- Updated for STANDARD/perf change of G_MISS_xxx

3887: ELSE
3888: Ibc_Content_Items_Pkg.update_row (
3889: p_content_item_id => p_content_item_id
3890: ,p_content_item_status => Ibc_Utilities_Pub.G_STI_ARCHIVED_CASCADE
3891: ,p_locked_by_user_id => FND_API.G_MISS_NUM -- Updated for STANDARD/perf change of G_MISS_xxx
3892: ,px_object_version_number => px_object_version_number
3893: );
3894: END IF;
3895:

Line 3918: -- Standard call to get message count and if count is 1, get message info.

3914: IF ( (x_return_status = FND_API.G_RET_STS_SUCCESS) AND (p_commit = FND_API.g_true) ) THEN
3915: COMMIT;
3916: END IF;
3917:
3918: -- Standard call to get message count and if count is 1, get message info.
3919: FND_MSG_PUB.Count_And_Get(
3920: p_count => x_msg_count,
3921: p_data => x_msg_data
3922: );

Line 4058: -- Standard call to check for call compatibility. --|**|

4054: IF (p_init_msg_list = FND_API.g_true) THEN --|**|
4055: FND_MSG_PUB.initialize; --|**|
4056: END IF; --|**|
4057: --|**|
4058: -- Standard call to check for call compatibility. --|**|
4059: IF NOT FND_API.Compatible_API_Call ( --|**|
4060: l_api_version_number --|**|
4061: ,p_api_version_number --|**|
4062: ,l_api_name --|**|

Line 4268: -- Standard call to get message count and if count is 1, get message info.

4264: IF ( (x_return_status = FND_API.G_RET_STS_SUCCESS) AND (p_commit = FND_API.g_true) ) THEN
4265: COMMIT;
4266: END IF;
4267:
4268: -- Standard call to get message count and if count is 1, get message info.
4269: FND_MSG_PUB.Count_And_Get(
4270: p_count => x_msg_count,
4271: p_data => x_msg_data
4272: );

Line 4482: -- Standard call to check for call compatibility. --|**|

4478: IF (p_init_msg_list = FND_API.g_true) THEN --|**|
4479: FND_MSG_PUB.initialize; --|**|
4480: END IF; --|**|
4481: --|**|
4482: -- Standard call to check for call compatibility. --|**|
4483: IF NOT FND_API.Compatible_API_Call ( --|**|
4484: l_api_version_number --|**|
4485: ,p_api_version_number --|**|
4486: ,l_api_name --|**|

Line 4736: -- Standard call to get message count and if count is 1, get message info.

4732: ELSIF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4733: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4734: END IF;
4735:
4736: -- Standard call to get message count and if count is 1, get message info.
4737: FND_MSG_PUB.Count_And_Get(
4738: p_count => x_msg_count,
4739: p_data => x_msg_data
4740: );

Line 4967: -- Standard call to check for call compatibility. --|**|

4963: IF (p_init_msg_list = FND_API.g_true) THEN --|**|
4964: FND_MSG_PUB.initialize; --|**|
4965: END IF; --|**|
4966: --|**|
4967: -- Standard call to check for call compatibility. --|**|
4968: IF NOT FND_API.Compatible_API_Call ( --|**|
4969: l_api_version_number --|**|
4970: ,p_api_version_number --|**|
4971: ,l_api_name --|**|

Line 5049: -- Standard call to get message count and if count is 1, get message info.

5045: ELSIF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5047: END IF;
5048:
5049: -- Standard call to get message count and if count is 1, get message info.
5050: FND_MSG_PUB.Count_And_Get(
5051: p_count => x_msg_count,
5052: p_data => x_msg_data
5053: );

Line 5198: -- Standard call to check for call compatibility. --|**|

5194: IF (p_init_msg_list = FND_API.g_true) THEN --|**|
5195: FND_MSG_PUB.initialize; --|**|
5196: END IF; --|**|
5197: --|**|
5198: -- Standard call to check for call compatibility. --|**|
5199: IF NOT FND_API.Compatible_API_Call ( --|**|
5200: l_api_version_number --|**|
5201: ,p_api_version_number --|**|
5202: ,l_api_name --|**|

Line 5350: -- Standard call to get message count and if count is 1, get message info.

5346: IF ( (x_return_status = FND_API.G_RET_STS_SUCCESS) AND (p_commit = FND_API.g_true) ) THEN
5347: COMMIT;
5348: END IF;
5349:
5350: -- Standard call to get message count and if count is 1, get message info.
5351: FND_MSG_PUB.Count_And_Get(
5352: p_count => x_msg_count,
5353: p_data => x_msg_data
5354: );

Line 5501: -- Standard call to check for call compatibility. --|**|

5497: IF (p_init_msg_list = FND_API.g_true) THEN --|**|
5498: FND_MSG_PUB.initialize; --|**|
5499: END IF; --|**|
5500: --|**|
5501: -- Standard call to check for call compatibility. --|**|
5502: IF NOT FND_API.Compatible_API_Call ( --|**|
5503: l_api_version_number --|**|
5504: ,p_api_version_number --|**|
5505: ,l_api_name --|**|

Line 5698: -- Standard call to get message count and if count is 1, get message info.

5694: IF ( (x_return_status = FND_API.G_RET_STS_SUCCESS) AND (p_commit = FND_API.g_true) ) THEN
5695: COMMIT;
5696: END IF;
5697:
5698: -- Standard call to get message count and if count is 1, get message info.
5699: FND_MSG_PUB.Count_And_Get(
5700: p_count => x_msg_count,
5701: p_data => x_msg_data
5702: );

Line 5834: -- Standard call to check for call compatibility. --|**|

5830: IF (p_init_msg_list = FND_API.g_true) THEN --|**|
5831: FND_MSG_PUB.initialize; --|**|
5832: END IF; --|**|
5833: --|**|
5834: -- Standard call to check for call compatibility. --|**|
5835: IF NOT FND_API.Compatible_API_Call ( --|**|
5836: l_api_version_number --|**|
5837: ,p_api_version_number --|**|
5838: ,l_api_name --|**|

Line 5924: -- Standard call to get message count and if count is 1, get message info.

5920: FND_MSG_PUB.ADD;
5921: RAISE FND_API.G_EXC_ERROR;
5922: END IF;
5923:
5924: -- Standard call to get message count and if count is 1, get message info.
5925: FND_MSG_PUB.Count_And_Get(
5926: p_count => x_msg_count,
5927: p_data => x_msg_data
5928: );

Line 6217: -- Standard call to check for call compatibility. --|**|

6213: IF (p_init_msg_list = FND_API.g_true) THEN --|**|
6214: FND_MSG_PUB.initialize; --|**|
6215: END IF; --|**|
6216: --|**|
6217: -- Standard call to check for call compatibility. --|**|
6218: IF NOT FND_API.Compatible_API_Call ( --|**|
6219: L_API_VERSION_NUMBER --|**|
6220: ,p_api_version_number --|**|
6221: ,L_API_NAME --|**|

Line 6501: -- Standard call to get message count and if count is 1, get message info.

6497: x_keywords.extend;
6498: x_keywords(l_index) := r_keyword.keyword;
6499: END LOOP;
6500:
6501: -- Standard call to get message count and if count is 1, get message info.
6502: FND_MSG_PUB.Count_And_Get(
6503: p_count => x_msg_count,
6504: p_data => x_msg_data
6505: );

Line 8066: -- Standard call to check for call compatibility. --|**|

8062: IF (p_init_msg_list = FND_API.g_true) THEN --|**|
8063: FND_MSG_PUB.initialize; --|**|
8064: END IF; --|**|
8065: --|**|
8066: -- Standard call to check for call compatibility. --|**|
8067: IF NOT FND_API.Compatible_API_Call ( --|**|
8068: l_api_version_number --|**|
8069: ,p_api_version_number --|**|
8070: ,l_api_name --|**|

Line 8173: -- Standard call to get message count and if count is 1, get message info.

8169: IF ( (x_return_status = FND_API.G_RET_STS_SUCCESS) AND (p_commit = FND_API.g_true) ) THEN
8170: COMMIT;
8171: END IF;
8172:
8173: -- Standard call to get message count and if count is 1, get message info.
8174: FND_MSG_PUB.Count_And_Get(
8175: p_count => x_msg_count,
8176: p_data => x_msg_data
8177: );

Line 8386: -- Standard call to check for call compatibility. --|**|

8382: IF (p_init_msg_list = FND_API.g_true) THEN --|**|
8383: FND_MSG_PUB.initialize; --|**|
8384: END IF; --|**|
8385: --|**|
8386: -- Standard call to check for call compatibility. --|**|
8387: IF NOT FND_API.Compatible_API_Call ( --|**|
8388: l_api_version_number --|**|
8389: ,p_api_version_number --|**|
8390: ,l_api_name --|**|

Line 8515: -- Standard call to get message count and if count is 1, get message info.

8511: IF ( (x_return_status = FND_API.G_RET_STS_SUCCESS) AND (p_commit = FND_API.g_true) ) THEN
8512: COMMIT;
8513: END IF;
8514:
8515: -- Standard call to get message count and if count is 1, get message info.
8516: FND_MSG_PUB.Count_And_Get(
8517: p_count => x_msg_count,
8518: p_data => x_msg_data
8519: );

Line 8655: -- Standard call to check for call compatibility. --|**|

8651: IF (p_init_msg_list = FND_API.g_true) THEN --|**|
8652: FND_MSG_PUB.initialize; --|**|
8653: END IF; --|**|
8654: --|**|
8655: -- Standard call to check for call compatibility. --|**|
8656: IF NOT FND_API.Compatible_API_Call ( --|**|
8657: l_api_version_number --|**|
8658: ,p_api_version_number --|**|
8659: ,l_api_name --|**|

Line 8909: -- Standard call to get message count and if count is 1, get message info.

8905: IF ( (x_return_status = FND_API.G_RET_STS_SUCCESS) AND (p_commit = FND_API.g_true) ) THEN
8906: COMMIT;
8907: END IF;
8908:
8909: -- Standard call to get message count and if count is 1, get message info.
8910: FND_MSG_PUB.Count_And_Get(
8911: p_count => x_msg_count,
8912: p_data => x_msg_data
8913: );

Line 9042: -- Standard call to check for call compatibility. --|**|

9038: IF (p_init_msg_list = FND_API.g_true) THEN --|**|
9039: FND_MSG_PUB.initialize; --|**|
9040: END IF; --|**|
9041: --|**|
9042: -- Standard call to check for call compatibility. --|**|
9043: IF NOT FND_API.Compatible_API_Call ( --|**|
9044: l_api_version_number --|**|
9045: ,p_api_version_number --|**|
9046: ,l_api_name --|**|

Line 9123: -- Standard call to get message count and if count is 1, get message info.

9119: IF ( (x_return_status = FND_API.G_RET_STS_SUCCESS) AND (p_commit = FND_API.g_true) ) THEN
9120: COMMIT;
9121: END IF;
9122:
9123: -- Standard call to get message count and if count is 1, get message info.
9124: FND_MSG_PUB.Count_And_Get(
9125: p_count => x_msg_count,
9126: p_data => x_msg_data
9127: );

Line 9306: -- Standard call to get message count and if count is 1, get message info.

9302: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
9303: RAISE FND_API.G_EXC_ERROR;
9304: END IF;
9305:
9306: -- Standard call to get message count and if count is 1, get message info.
9307: FND_MSG_PUB.Count_And_Get(
9308: p_count => x_msg_count,
9309: p_data => x_msg_data
9310: );

Line 9445: -- Standard call to check for call compatibility. --|**|

9441: IF (p_init_msg_list = FND_API.g_true) THEN --|**|
9442: FND_MSG_PUB.initialize; --|**|
9443: END IF; --|**|
9444: --|**|
9445: -- Standard call to check for call compatibility. --|**|
9446: IF NOT FND_API.Compatible_API_Call ( --|**|
9447: l_api_version_number --|**|
9448: ,p_api_version_number --|**|
9449: ,l_api_name --|**|

Line 9626: -- Standard call to get message count and if count is 1, get message info.

9622: IF ( (x_return_status = FND_API.G_RET_STS_SUCCESS) AND (p_commit = FND_API.g_true) ) THEN
9623: COMMIT;
9624: END IF;
9625:
9626: -- Standard call to get message count and if count is 1, get message info.
9627: FND_MSG_PUB.Count_And_Get(
9628: p_count => x_msg_count,
9629: p_data => x_msg_data
9630: );

Line 9822: -- Standard call to check for call compatibility. --|**|

9818: IF (p_init_msg_list = FND_API.g_true) THEN --|**|
9819: FND_MSG_PUB.initialize; --|**|
9820: END IF; --|**|
9821: --|**|
9822: -- Standard call to check for call compatibility. --|**|
9823: IF NOT FND_API.Compatible_API_Call ( --|**|
9824: l_api_version_number --|**|
9825: ,p_api_version_number --|**|
9826: ,l_api_name --|**|

Line 9982: ,p_attachment_file_id => Conv_To_TblHandler(p_attach_file_id) -- Updated for STANDARD/perf change of G_MISS_xxx

9978: -- ****RENDITIONS_WORK****
9979: Ibc_Citem_Versions_Pkg.update_row (
9980: p_citem_version_id => p_citem_ver_id
9981: ,p_content_item_id => content_item_id
9982: ,p_attachment_file_id => Conv_To_TblHandler(p_attach_file_id) -- Updated for STANDARD/perf change of G_MISS_xxx
9983: ,p_attachment_file_name => Conv_To_TblHandler(att_file_name) -- Updated for STANDARD/perf change of G_MISS_xxx
9984: ,p_attachment_attribute_code => Conv_To_TblHandler(att_type_code) -- Updated for STANDARD/perf change of G_MISS_xxx
9985: ,p_default_rendition_mime_type => Conv_To_TblHandler(l_attach_rendition_mtype) -- Updated for STANDARD/perf change of G_MISS_xxx
9986: ,px_object_version_number => px_object_version_number

Line 9983: ,p_attachment_file_name => Conv_To_TblHandler(att_file_name) -- Updated for STANDARD/perf change of G_MISS_xxx

9979: Ibc_Citem_Versions_Pkg.update_row (
9980: p_citem_version_id => p_citem_ver_id
9981: ,p_content_item_id => content_item_id
9982: ,p_attachment_file_id => Conv_To_TblHandler(p_attach_file_id) -- Updated for STANDARD/perf change of G_MISS_xxx
9983: ,p_attachment_file_name => Conv_To_TblHandler(att_file_name) -- Updated for STANDARD/perf change of G_MISS_xxx
9984: ,p_attachment_attribute_code => Conv_To_TblHandler(att_type_code) -- Updated for STANDARD/perf change of G_MISS_xxx
9985: ,p_default_rendition_mime_type => Conv_To_TblHandler(l_attach_rendition_mtype) -- Updated for STANDARD/perf change of G_MISS_xxx
9986: ,px_object_version_number => px_object_version_number
9987: );

Line 9984: ,p_attachment_attribute_code => Conv_To_TblHandler(att_type_code) -- Updated for STANDARD/perf change of G_MISS_xxx

9980: p_citem_version_id => p_citem_ver_id
9981: ,p_content_item_id => content_item_id
9982: ,p_attachment_file_id => Conv_To_TblHandler(p_attach_file_id) -- Updated for STANDARD/perf change of G_MISS_xxx
9983: ,p_attachment_file_name => Conv_To_TblHandler(att_file_name) -- Updated for STANDARD/perf change of G_MISS_xxx
9984: ,p_attachment_attribute_code => Conv_To_TblHandler(att_type_code) -- Updated for STANDARD/perf change of G_MISS_xxx
9985: ,p_default_rendition_mime_type => Conv_To_TblHandler(l_attach_rendition_mtype) -- Updated for STANDARD/perf change of G_MISS_xxx
9986: ,px_object_version_number => px_object_version_number
9987: );
9988:

Line 9985: ,p_default_rendition_mime_type => Conv_To_TblHandler(l_attach_rendition_mtype) -- Updated for STANDARD/perf change of G_MISS_xxx

9981: ,p_content_item_id => content_item_id
9982: ,p_attachment_file_id => Conv_To_TblHandler(p_attach_file_id) -- Updated for STANDARD/perf change of G_MISS_xxx
9983: ,p_attachment_file_name => Conv_To_TblHandler(att_file_name) -- Updated for STANDARD/perf change of G_MISS_xxx
9984: ,p_attachment_attribute_code => Conv_To_TblHandler(att_type_code) -- Updated for STANDARD/perf change of G_MISS_xxx
9985: ,p_default_rendition_mime_type => Conv_To_TblHandler(l_attach_rendition_mtype) -- Updated for STANDARD/perf change of G_MISS_xxx
9986: ,px_object_version_number => px_object_version_number
9987: );
9988:
9989: --***************************************************

Line 10024: ,P_FILE_ID => Conv_To_TblHandler(p_attach_file_id) -- Updated for STANDARD/perf change of G_MISS_xxx

10020: Px_rowid => l_row_id
10021: ,Px_RENDITION_ID => l_rendition_id
10022: ,p_object_version_number => G_OBJ_VERSION_DEFAULT
10023: ,P_LANGUAGE => p_language
10024: ,P_FILE_ID => Conv_To_TblHandler(p_attach_file_id) -- Updated for STANDARD/perf change of G_MISS_xxx
10025: ,P_FILE_NAME => Conv_To_TblHandler(att_file_name) -- Updated for STANDARD/perf change of G_MISS_xxx
10026: ,P_CITEM_VERSION_ID => p_citem_ver_id
10027: ,P_MIME_TYPE => Conv_To_TblHandler(l_attach_rendition_mtype) -- Updated for STANDARD/perf change of G_MISS_xxx
10028: );

Line 10025: ,P_FILE_NAME => Conv_To_TblHandler(att_file_name) -- Updated for STANDARD/perf change of G_MISS_xxx

10021: ,Px_RENDITION_ID => l_rendition_id
10022: ,p_object_version_number => G_OBJ_VERSION_DEFAULT
10023: ,P_LANGUAGE => p_language
10024: ,P_FILE_ID => Conv_To_TblHandler(p_attach_file_id) -- Updated for STANDARD/perf change of G_MISS_xxx
10025: ,P_FILE_NAME => Conv_To_TblHandler(att_file_name) -- Updated for STANDARD/perf change of G_MISS_xxx
10026: ,P_CITEM_VERSION_ID => p_citem_ver_id
10027: ,P_MIME_TYPE => Conv_To_TblHandler(l_attach_rendition_mtype) -- Updated for STANDARD/perf change of G_MISS_xxx
10028: );
10029: END IF;

Line 10027: ,P_MIME_TYPE => Conv_To_TblHandler(l_attach_rendition_mtype) -- Updated for STANDARD/perf change of G_MISS_xxx

10023: ,P_LANGUAGE => p_language
10024: ,P_FILE_ID => Conv_To_TblHandler(p_attach_file_id) -- Updated for STANDARD/perf change of G_MISS_xxx
10025: ,P_FILE_NAME => Conv_To_TblHandler(att_file_name) -- Updated for STANDARD/perf change of G_MISS_xxx
10026: ,P_CITEM_VERSION_ID => p_citem_ver_id
10027: ,P_MIME_TYPE => Conv_To_TblHandler(l_attach_rendition_mtype) -- Updated for STANDARD/perf change of G_MISS_xxx
10028: );
10029: END IF;
10030:
10031:

Line 10037: -- Standard call to get message count and if count is 1, get message info.

10033: IF ( (x_return_status = FND_API.G_RET_STS_SUCCESS) AND (p_commit = FND_API.g_true) ) THEN
10034: COMMIT;
10035: END IF;
10036:
10037: -- Standard call to get message count and if count is 1, get message info.
10038: FND_MSG_PUB.Count_And_Get(
10039: p_count => x_msg_count,
10040: p_data => x_msg_data
10041: );

Line 10177: -- Standard call to check for call compatibility. --|**|

10173: IF (p_init_msg_list = FND_API.g_true) THEN --|**|
10174: FND_MSG_PUB.initialize; --|**|
10175: END IF; --|**|
10176: --|**|
10177: -- Standard call to check for call compatibility. --|**|
10178: IF NOT FND_API.Compatible_API_Call ( --|**|
10179: l_api_version_number --|**|
10180: ,p_api_version_number --|**|
10181: ,l_api_name --|**|

Line 10333: ,p_directory_node_id => Conv_To_TblHandler(directory_node) -- Update for STANDARD/perf change of G_MISS_xxx

10329: -- *** UPDATING DATA IN DB *********
10330: -- Updating Content Item
10331: Ibc_Content_Items_Pkg.update_row (
10332: p_content_item_id => p_content_item_id
10333: ,p_directory_node_id => Conv_To_TblHandler(directory_node) -- Update for STANDARD/perf change of G_MISS_xxx
10334: ,p_wd_restricted_flag => Conv_To_TblHandler(p_wd_restricted) -- Updated for STANDARD/perf change of G_MISS_xxx
10335: ,p_translation_required_flag => Conv_To_TblHandler(p_trans_required) -- Updated for STANDARD/perf change of G_MISS_xxx
10336: ,p_owner_resource_id => Conv_To_TblHandler(p_new_owner_resource_id) -- Updated for STANDARD/perf change of G_MISS_xxx
10337: ,p_owner_resource_type => Conv_To_TblHandler(p_new_owner_resource_type) -- Updated for STANDARD/perf change of G_MISS_xxx

Line 10334: ,p_wd_restricted_flag => Conv_To_TblHandler(p_wd_restricted) -- Updated for STANDARD/perf change of G_MISS_xxx

10330: -- Updating Content Item
10331: Ibc_Content_Items_Pkg.update_row (
10332: p_content_item_id => p_content_item_id
10333: ,p_directory_node_id => Conv_To_TblHandler(directory_node) -- Update for STANDARD/perf change of G_MISS_xxx
10334: ,p_wd_restricted_flag => Conv_To_TblHandler(p_wd_restricted) -- Updated for STANDARD/perf change of G_MISS_xxx
10335: ,p_translation_required_flag => Conv_To_TblHandler(p_trans_required) -- Updated for STANDARD/perf change of G_MISS_xxx
10336: ,p_owner_resource_id => Conv_To_TblHandler(p_new_owner_resource_id) -- Updated for STANDARD/perf change of G_MISS_xxx
10337: ,p_owner_resource_type => Conv_To_TblHandler(p_new_owner_resource_type) -- Updated for STANDARD/perf change of G_MISS_xxx
10338: ,p_parent_item_id => Conv_To_TblHandler(p_parent_item_id) -- Updated for STANDARD/perf change of G_MISS_xxx

Line 10335: ,p_translation_required_flag => Conv_To_TblHandler(p_trans_required) -- Updated for STANDARD/perf change of G_MISS_xxx

10331: Ibc_Content_Items_Pkg.update_row (
10332: p_content_item_id => p_content_item_id
10333: ,p_directory_node_id => Conv_To_TblHandler(directory_node) -- Update for STANDARD/perf change of G_MISS_xxx
10334: ,p_wd_restricted_flag => Conv_To_TblHandler(p_wd_restricted) -- Updated for STANDARD/perf change of G_MISS_xxx
10335: ,p_translation_required_flag => Conv_To_TblHandler(p_trans_required) -- Updated for STANDARD/perf change of G_MISS_xxx
10336: ,p_owner_resource_id => Conv_To_TblHandler(p_new_owner_resource_id) -- Updated for STANDARD/perf change of G_MISS_xxx
10337: ,p_owner_resource_type => Conv_To_TblHandler(p_new_owner_resource_type) -- Updated for STANDARD/perf change of G_MISS_xxx
10338: ,p_parent_item_id => Conv_To_TblHandler(p_parent_item_id) -- Updated for STANDARD/perf change of G_MISS_xxx
10339: ,px_object_version_number => px_object_version_number

Line 10336: ,p_owner_resource_id => Conv_To_TblHandler(p_new_owner_resource_id) -- Updated for STANDARD/perf change of G_MISS_xxx

10332: p_content_item_id => p_content_item_id
10333: ,p_directory_node_id => Conv_To_TblHandler(directory_node) -- Update for STANDARD/perf change of G_MISS_xxx
10334: ,p_wd_restricted_flag => Conv_To_TblHandler(p_wd_restricted) -- Updated for STANDARD/perf change of G_MISS_xxx
10335: ,p_translation_required_flag => Conv_To_TblHandler(p_trans_required) -- Updated for STANDARD/perf change of G_MISS_xxx
10336: ,p_owner_resource_id => Conv_To_TblHandler(p_new_owner_resource_id) -- Updated for STANDARD/perf change of G_MISS_xxx
10337: ,p_owner_resource_type => Conv_To_TblHandler(p_new_owner_resource_type) -- Updated for STANDARD/perf change of G_MISS_xxx
10338: ,p_parent_item_id => Conv_To_TblHandler(p_parent_item_id) -- Updated for STANDARD/perf change of G_MISS_xxx
10339: ,px_object_version_number => px_object_version_number
10340: );

Line 10337: ,p_owner_resource_type => Conv_To_TblHandler(p_new_owner_resource_type) -- Updated for STANDARD/perf change of G_MISS_xxx

10333: ,p_directory_node_id => Conv_To_TblHandler(directory_node) -- Update for STANDARD/perf change of G_MISS_xxx
10334: ,p_wd_restricted_flag => Conv_To_TblHandler(p_wd_restricted) -- Updated for STANDARD/perf change of G_MISS_xxx
10335: ,p_translation_required_flag => Conv_To_TblHandler(p_trans_required) -- Updated for STANDARD/perf change of G_MISS_xxx
10336: ,p_owner_resource_id => Conv_To_TblHandler(p_new_owner_resource_id) -- Updated for STANDARD/perf change of G_MISS_xxx
10337: ,p_owner_resource_type => Conv_To_TblHandler(p_new_owner_resource_type) -- Updated for STANDARD/perf change of G_MISS_xxx
10338: ,p_parent_item_id => Conv_To_TblHandler(p_parent_item_id) -- Updated for STANDARD/perf change of G_MISS_xxx
10339: ,px_object_version_number => px_object_version_number
10340: );
10341: --***************************************************

Line 10338: ,p_parent_item_id => Conv_To_TblHandler(p_parent_item_id) -- Updated for STANDARD/perf change of G_MISS_xxx

10334: ,p_wd_restricted_flag => Conv_To_TblHandler(p_wd_restricted) -- Updated for STANDARD/perf change of G_MISS_xxx
10335: ,p_translation_required_flag => Conv_To_TblHandler(p_trans_required) -- Updated for STANDARD/perf change of G_MISS_xxx
10336: ,p_owner_resource_id => Conv_To_TblHandler(p_new_owner_resource_id) -- Updated for STANDARD/perf change of G_MISS_xxx
10337: ,p_owner_resource_type => Conv_To_TblHandler(p_new_owner_resource_type) -- Updated for STANDARD/perf change of G_MISS_xxx
10338: ,p_parent_item_id => Conv_To_TblHandler(p_parent_item_id) -- Updated for STANDARD/perf change of G_MISS_xxx
10339: ,px_object_version_number => px_object_version_number
10340: );
10341: --***************************************************
10342: --************ADDING TO AUDIT LOG********************

Line 10363: -- Standard call to get message count and if count is 1, get message info.

10359: IF ( (x_return_status = FND_API.G_RET_STS_SUCCESS) AND (p_commit = FND_API.g_true) ) THEN
10360: COMMIT;
10361: END IF;
10362:
10363: -- Standard call to get message count and if count is 1, get message info.
10364: FND_MSG_PUB.Count_And_Get(
10365: p_count => x_msg_count,
10366: p_data => x_msg_data
10367: );

Line 10511: -- Standard call to check for call compatibility. --|**|

10507: IF (p_init_msg_list = FND_API.g_true) THEN --|**|
10508: FND_MSG_PUB.initialize; --|**|
10509: END IF; --|**|
10510: --|**|
10511: -- Standard call to check for call compatibility. --|**|
10512: IF NOT FND_API.Compatible_API_Call ( --|**|
10513: l_api_version_number --|**|
10514: ,p_api_version_number --|**|
10515: ,l_api_name --|**|

Line 10626: -- Standard call to get message count and if count is 1, get message info.

10622: IF ( (x_return_status = FND_API.G_RET_STS_SUCCESS) AND (p_commit = FND_API.g_true) ) THEN
10623: COMMIT;
10624: END IF;
10625:
10626: -- Standard call to get message count and if count is 1, get message info.
10627: FND_MSG_PUB.Count_And_Get(
10628: p_count => x_msg_count,
10629: p_data => x_msg_data
10630: );

Line 10761: -- Standard call to check for call compatibility. --|**|

10757: IF (p_init_msg_list = FND_API.g_true) THEN --|**|
10758: FND_MSG_PUB.initialize; --|**|
10759: END IF; --|**|
10760: --|**|
10761: -- Standard call to check for call compatibility. --|**|
10762: IF NOT FND_API.Compatible_API_Call ( --|**|
10763: l_api_version_number --|**|
10764: ,p_api_version_number --|**|
10765: ,l_api_name --|**|

Line 10877: ,p_start_date => Conv_To_TblHandler(p_start_date) -- Updated for STANDARD/perf change of G_MISS_xxx

10873: -- Updating Content Item Version
10874: Ibc_Citem_Versions_Pkg.update_row (
10875: p_citem_version_id => p_citem_ver_id
10876: ,p_content_item_id => content_item_id
10877: ,p_start_date => Conv_To_TblHandler(p_start_date) -- Updated for STANDARD/perf change of G_MISS_xxx
10878: ,p_end_date => Conv_To_TblHandler(p_end_date) -- Updated for STANDARD/perf change of G_MISS_xxx
10879: ,p_content_item_name => Conv_To_TblHandler(p_citem_name) -- Updated for STANDARD/perf change of G_MISS_xxx
10880: ,p_description => Conv_To_TblHandler(p_citem_description) -- Updated for STANDARD/perf change of G_MISS_xxx
10881: ,px_object_version_number => px_object_version_number

Line 10878: ,p_end_date => Conv_To_TblHandler(p_end_date) -- Updated for STANDARD/perf change of G_MISS_xxx

10874: Ibc_Citem_Versions_Pkg.update_row (
10875: p_citem_version_id => p_citem_ver_id
10876: ,p_content_item_id => content_item_id
10877: ,p_start_date => Conv_To_TblHandler(p_start_date) -- Updated for STANDARD/perf change of G_MISS_xxx
10878: ,p_end_date => Conv_To_TblHandler(p_end_date) -- Updated for STANDARD/perf change of G_MISS_xxx
10879: ,p_content_item_name => Conv_To_TblHandler(p_citem_name) -- Updated for STANDARD/perf change of G_MISS_xxx
10880: ,p_description => Conv_To_TblHandler(p_citem_description) -- Updated for STANDARD/perf change of G_MISS_xxx
10881: ,px_object_version_number => px_object_version_number
10882: );

Line 10879: ,p_content_item_name => Conv_To_TblHandler(p_citem_name) -- Updated for STANDARD/perf change of G_MISS_xxx

10875: p_citem_version_id => p_citem_ver_id
10876: ,p_content_item_id => content_item_id
10877: ,p_start_date => Conv_To_TblHandler(p_start_date) -- Updated for STANDARD/perf change of G_MISS_xxx
10878: ,p_end_date => Conv_To_TblHandler(p_end_date) -- Updated for STANDARD/perf change of G_MISS_xxx
10879: ,p_content_item_name => Conv_To_TblHandler(p_citem_name) -- Updated for STANDARD/perf change of G_MISS_xxx
10880: ,p_description => Conv_To_TblHandler(p_citem_description) -- Updated for STANDARD/perf change of G_MISS_xxx
10881: ,px_object_version_number => px_object_version_number
10882: );
10883:

Line 10880: ,p_description => Conv_To_TblHandler(p_citem_description) -- Updated for STANDARD/perf change of G_MISS_xxx

10876: ,p_content_item_id => content_item_id
10877: ,p_start_date => Conv_To_TblHandler(p_start_date) -- Updated for STANDARD/perf change of G_MISS_xxx
10878: ,p_end_date => Conv_To_TblHandler(p_end_date) -- Updated for STANDARD/perf change of G_MISS_xxx
10879: ,p_content_item_name => Conv_To_TblHandler(p_citem_name) -- Updated for STANDARD/perf change of G_MISS_xxx
10880: ,p_description => Conv_To_TblHandler(p_citem_description) -- Updated for STANDARD/perf change of G_MISS_xxx
10881: ,px_object_version_number => px_object_version_number
10882: );
10883:
10884:

Line 10919: -- Standard call to get message count and if count is 1, get message info.

10915: IF ( (x_return_status = FND_API.G_RET_STS_SUCCESS) AND (p_commit = FND_API.g_true) ) THEN
10916: COMMIT;
10917: END IF;
10918:
10919: -- Standard call to get message count and if count is 1, get message info.
10920: FND_MSG_PUB.Count_And_Get(
10921: p_count => x_msg_count,
10922: p_data => x_msg_data
10923: );

Line 11056: -- Standard call to check for call compatibility. --|**|

11052: IF (p_init_msg_list = FND_API.g_true) THEN --|**|
11053: FND_MSG_PUB.initialize; --|**|
11054: END IF; --|**|
11055: --|**|
11056: -- Standard call to check for call compatibility. --|**|
11057: IF NOT FND_API.Compatible_API_Call ( --|**|
11058: l_api_version_number --|**|
11059: ,p_api_version_number --|**|
11060: ,l_api_name --|**|

Line 11180: ,p_locked_by_user_id => FND_API.G_MISS_NUM -- Updated for STANDARD/perf change of G_MISS_xxx

11176: -- Actual changing of status if made it to this point
11177: Ibc_Content_Items_Pkg.update_row (
11178: p_content_item_id => p_content_item_id
11179: ,p_content_item_status => new_status
11180: ,p_locked_by_user_id => FND_API.G_MISS_NUM -- Updated for STANDARD/perf change of G_MISS_xxx
11181: ,px_object_version_number => px_object_version_number
11182: );
11183:
11184: --***************************************************

Line 11206: -- Standard call to get message count and if count is 1, get message info.

11202: IF ( (x_return_status = FND_API.G_RET_STS_SUCCESS) AND (p_commit = FND_API.g_true) ) THEN
11203: COMMIT;
11204: END IF;
11205:
11206: -- Standard call to get message count and if count is 1, get message info.
11207: FND_MSG_PUB.Count_And_Get(
11208: p_count => x_msg_count,
11209: p_data => x_msg_data
11210: );

Line 11336: -- Standard call to check for call compatibility. --|**|

11332: IF (p_init_msg_list = FND_API.g_true) THEN --|**|
11333: FND_MSG_PUB.initialize; --|**|
11334: END IF; --|**|
11335: --|**|
11336: -- Standard call to check for call compatibility. --|**|
11337: IF NOT FND_API.Compatible_API_Call ( --|**|
11338: l_api_version_number --|**|
11339: ,p_api_version_number --|**|
11340: ,l_api_name --|**|

Line 11416: -- Standard call to get message count and if count is 1, get message info.

11412: IF ( (x_return_status = FND_API.G_RET_STS_SUCCESS) AND (p_commit = FND_API.g_true) ) THEN
11413: COMMIT;
11414: END IF;
11415:
11416: -- Standard call to get message count and if count is 1, get message info.
11417: FND_MSG_PUB.Count_And_Get(
11418: p_count => x_msg_count,
11419: p_data => x_msg_data
11420: );

Line 11606: -- Standard call to check for call compatibility. --|**|

11602: IF (p_init_msg_list = FND_API.g_true) THEN --|**|
11603: FND_MSG_PUB.initialize; --|**|
11604: END IF; --|**|
11605: --|**|
11606: -- Standard call to check for call compatibility. --|**|
11607: IF NOT FND_API.Compatible_API_Call ( --|**|
11608: L_API_VERSION_NUMBER --|**|
11609: ,p_api_version_number --|**|
11610: ,L_API_NAME --|**|

Line 11950: ,p_ITEM_REFERENCE_CODE => Conv_To_TblHandler(p_reference_code) -- Updated for STANDARD/perf change of G_MISS_xxx

11946:
11947: --DBMS_OUTPUT.put_line('ITEM - UPDATE ROW');
11948: Ibc_Content_Items_Pkg.update_row(
11949: p_CONTENT_ITEM_ID => px_content_item_id
11950: ,p_ITEM_REFERENCE_CODE => Conv_To_TblHandler(p_reference_code) -- Updated for STANDARD/perf change of G_MISS_xxx
11951: ,p_DIRECTORY_NODE_ID => Conv_To_TblHandler(directory_node) -- Updated for STANDARD/perf change of G_MISS_xxx
11952: ,p_LOCKED_BY_USER_ID => Conv_To_TblHandler(locked_by) -- Updated for STANDARD/perf change of G_MISS_xxx
11953: ,p_WD_RESTRICTED_FLAG => Conv_To_TblHandler(p_wd_restricted) -- Updated for STANDARD/perf change of G_MISS_xxx
11954: ,p_TRANSLATION_REQUIRED_FLAG => Conv_To_TblHandler(p_trans_required) -- Updated for STANDARD/perf change of G_MISS_xxx

Line 11951: ,p_DIRECTORY_NODE_ID => Conv_To_TblHandler(directory_node) -- Updated for STANDARD/perf change of G_MISS_xxx

11947: --DBMS_OUTPUT.put_line('ITEM - UPDATE ROW');
11948: Ibc_Content_Items_Pkg.update_row(
11949: p_CONTENT_ITEM_ID => px_content_item_id
11950: ,p_ITEM_REFERENCE_CODE => Conv_To_TblHandler(p_reference_code) -- Updated for STANDARD/perf change of G_MISS_xxx
11951: ,p_DIRECTORY_NODE_ID => Conv_To_TblHandler(directory_node) -- Updated for STANDARD/perf change of G_MISS_xxx
11952: ,p_LOCKED_BY_USER_ID => Conv_To_TblHandler(locked_by) -- Updated for STANDARD/perf change of G_MISS_xxx
11953: ,p_WD_RESTRICTED_FLAG => Conv_To_TblHandler(p_wd_restricted) -- Updated for STANDARD/perf change of G_MISS_xxx
11954: ,p_TRANSLATION_REQUIRED_FLAG => Conv_To_TblHandler(p_trans_required) -- Updated for STANDARD/perf change of G_MISS_xxx
11955: ,p_OWNER_RESOURCE_ID => Conv_To_TblHandler(p_new_owner_resource_id) -- Updated for STANDARD/perf change of G_MISS_xxx

Line 11952: ,p_LOCKED_BY_USER_ID => Conv_To_TblHandler(locked_by) -- Updated for STANDARD/perf change of G_MISS_xxx

11948: Ibc_Content_Items_Pkg.update_row(
11949: p_CONTENT_ITEM_ID => px_content_item_id
11950: ,p_ITEM_REFERENCE_CODE => Conv_To_TblHandler(p_reference_code) -- Updated for STANDARD/perf change of G_MISS_xxx
11951: ,p_DIRECTORY_NODE_ID => Conv_To_TblHandler(directory_node) -- Updated for STANDARD/perf change of G_MISS_xxx
11952: ,p_LOCKED_BY_USER_ID => Conv_To_TblHandler(locked_by) -- Updated for STANDARD/perf change of G_MISS_xxx
11953: ,p_WD_RESTRICTED_FLAG => Conv_To_TblHandler(p_wd_restricted) -- Updated for STANDARD/perf change of G_MISS_xxx
11954: ,p_TRANSLATION_REQUIRED_FLAG => Conv_To_TblHandler(p_trans_required) -- Updated for STANDARD/perf change of G_MISS_xxx
11955: ,p_OWNER_RESOURCE_ID => Conv_To_TblHandler(p_new_owner_resource_id) -- Updated for STANDARD/perf change of G_MISS_xxx
11956: ,p_OWNER_RESOURCE_TYPE => Conv_To_TblHandler(p_new_owner_resource_type) -- Updated for STANDARD/perf change of G_MISS_xxx

Line 11953: ,p_WD_RESTRICTED_FLAG => Conv_To_TblHandler(p_wd_restricted) -- Updated for STANDARD/perf change of G_MISS_xxx

11949: p_CONTENT_ITEM_ID => px_content_item_id
11950: ,p_ITEM_REFERENCE_CODE => Conv_To_TblHandler(p_reference_code) -- Updated for STANDARD/perf change of G_MISS_xxx
11951: ,p_DIRECTORY_NODE_ID => Conv_To_TblHandler(directory_node) -- Updated for STANDARD/perf change of G_MISS_xxx
11952: ,p_LOCKED_BY_USER_ID => Conv_To_TblHandler(locked_by) -- Updated for STANDARD/perf change of G_MISS_xxx
11953: ,p_WD_RESTRICTED_FLAG => Conv_To_TblHandler(p_wd_restricted) -- Updated for STANDARD/perf change of G_MISS_xxx
11954: ,p_TRANSLATION_REQUIRED_FLAG => Conv_To_TblHandler(p_trans_required) -- Updated for STANDARD/perf change of G_MISS_xxx
11955: ,p_OWNER_RESOURCE_ID => Conv_To_TblHandler(p_new_owner_resource_id) -- Updated for STANDARD/perf change of G_MISS_xxx
11956: ,p_OWNER_RESOURCE_TYPE => Conv_To_TblHandler(p_new_owner_resource_type) -- Updated for STANDARD/perf change of G_MISS_xxx
11957: ,p_PARENT_ITEM_ID => Conv_To_TblHandler(p_parent_item_id) -- Updated for STANDARD/perf change of G_MISS_xxx

Line 11954: ,p_TRANSLATION_REQUIRED_FLAG => Conv_To_TblHandler(p_trans_required) -- Updated for STANDARD/perf change of G_MISS_xxx

11950: ,p_ITEM_REFERENCE_CODE => Conv_To_TblHandler(p_reference_code) -- Updated for STANDARD/perf change of G_MISS_xxx
11951: ,p_DIRECTORY_NODE_ID => Conv_To_TblHandler(directory_node) -- Updated for STANDARD/perf change of G_MISS_xxx
11952: ,p_LOCKED_BY_USER_ID => Conv_To_TblHandler(locked_by) -- Updated for STANDARD/perf change of G_MISS_xxx
11953: ,p_WD_RESTRICTED_FLAG => Conv_To_TblHandler(p_wd_restricted) -- Updated for STANDARD/perf change of G_MISS_xxx
11954: ,p_TRANSLATION_REQUIRED_FLAG => Conv_To_TblHandler(p_trans_required) -- Updated for STANDARD/perf change of G_MISS_xxx
11955: ,p_OWNER_RESOURCE_ID => Conv_To_TblHandler(p_new_owner_resource_id) -- Updated for STANDARD/perf change of G_MISS_xxx
11956: ,p_OWNER_RESOURCE_TYPE => Conv_To_TblHandler(p_new_owner_resource_type) -- Updated for STANDARD/perf change of G_MISS_xxx
11957: ,p_PARENT_ITEM_ID => Conv_To_TblHandler(p_parent_item_id) -- Updated for STANDARD/perf change of G_MISS_xxx
11958: ,px_object_version_number => px_object_version_number

Line 11955: ,p_OWNER_RESOURCE_ID => Conv_To_TblHandler(p_new_owner_resource_id) -- Updated for STANDARD/perf change of G_MISS_xxx

11951: ,p_DIRECTORY_NODE_ID => Conv_To_TblHandler(directory_node) -- Updated for STANDARD/perf change of G_MISS_xxx
11952: ,p_LOCKED_BY_USER_ID => Conv_To_TblHandler(locked_by) -- Updated for STANDARD/perf change of G_MISS_xxx
11953: ,p_WD_RESTRICTED_FLAG => Conv_To_TblHandler(p_wd_restricted) -- Updated for STANDARD/perf change of G_MISS_xxx
11954: ,p_TRANSLATION_REQUIRED_FLAG => Conv_To_TblHandler(p_trans_required) -- Updated for STANDARD/perf change of G_MISS_xxx
11955: ,p_OWNER_RESOURCE_ID => Conv_To_TblHandler(p_new_owner_resource_id) -- Updated for STANDARD/perf change of G_MISS_xxx
11956: ,p_OWNER_RESOURCE_TYPE => Conv_To_TblHandler(p_new_owner_resource_type) -- Updated for STANDARD/perf change of G_MISS_xxx
11957: ,p_PARENT_ITEM_ID => Conv_To_TblHandler(p_parent_item_id) -- Updated for STANDARD/perf change of G_MISS_xxx
11958: ,px_object_version_number => px_object_version_number
11959: );

Line 11956: ,p_OWNER_RESOURCE_TYPE => Conv_To_TblHandler(p_new_owner_resource_type) -- Updated for STANDARD/perf change of G_MISS_xxx

11952: ,p_LOCKED_BY_USER_ID => Conv_To_TblHandler(locked_by) -- Updated for STANDARD/perf change of G_MISS_xxx
11953: ,p_WD_RESTRICTED_FLAG => Conv_To_TblHandler(p_wd_restricted) -- Updated for STANDARD/perf change of G_MISS_xxx
11954: ,p_TRANSLATION_REQUIRED_FLAG => Conv_To_TblHandler(p_trans_required) -- Updated for STANDARD/perf change of G_MISS_xxx
11955: ,p_OWNER_RESOURCE_ID => Conv_To_TblHandler(p_new_owner_resource_id) -- Updated for STANDARD/perf change of G_MISS_xxx
11956: ,p_OWNER_RESOURCE_TYPE => Conv_To_TblHandler(p_new_owner_resource_type) -- Updated for STANDARD/perf change of G_MISS_xxx
11957: ,p_PARENT_ITEM_ID => Conv_To_TblHandler(p_parent_item_id) -- Updated for STANDARD/perf change of G_MISS_xxx
11958: ,px_object_version_number => px_object_version_number
11959: );
11960:

Line 11957: ,p_PARENT_ITEM_ID => Conv_To_TblHandler(p_parent_item_id) -- Updated for STANDARD/perf change of G_MISS_xxx

11953: ,p_WD_RESTRICTED_FLAG => Conv_To_TblHandler(p_wd_restricted) -- Updated for STANDARD/perf change of G_MISS_xxx
11954: ,p_TRANSLATION_REQUIRED_FLAG => Conv_To_TblHandler(p_trans_required) -- Updated for STANDARD/perf change of G_MISS_xxx
11955: ,p_OWNER_RESOURCE_ID => Conv_To_TblHandler(p_new_owner_resource_id) -- Updated for STANDARD/perf change of G_MISS_xxx
11956: ,p_OWNER_RESOURCE_TYPE => Conv_To_TblHandler(p_new_owner_resource_type) -- Updated for STANDARD/perf change of G_MISS_xxx
11957: ,p_PARENT_ITEM_ID => Conv_To_TblHandler(p_parent_item_id) -- Updated for STANDARD/perf change of G_MISS_xxx
11958: ,px_object_version_number => px_object_version_number
11959: );
11960:
11961: --DBMS_OUTPUT.put_line('ITEM - ROW UPDATED');

Line 12222: ,P_CITEM_VERSION_STATUS => Conv_To_TblHandler(bulk_status) -- Updated for STANDARD/perf change of G_MISS_xxx

12218: Ibc_Citem_Versions_Pkg.update_row(
12219: P_CITEM_VERSION_ID => px_citem_ver_id
12220: ,P_CONTENT_ITEM_ID => px_content_item_id
12221: ,P_SOURCE_LANG => lang
12222: ,P_CITEM_VERSION_STATUS => Conv_To_TblHandler(bulk_status) -- Updated for STANDARD/perf change of G_MISS_xxx
12223: ,P_START_DATE => Conv_To_TblHandler(p_start_date) -- Updated for STANDARD/perf change of G_MISS_xxx
12224: ,P_END_DATE => Conv_To_TblHandler(p_end_date) -- Updated for STANDARD/perf change of G_MISS_xxx
12225: ,P_ATTRIBUTE_FILE_ID => Conv_To_TblHandler(bundle_file_id) -- Updated for STANDARD/perf change of G_MISS_xxx
12226: ,P_ATTACHMENT_FILE_ID => Conv_To_TblHandler(p_attach_file_id) -- Updated for STANDARD/perf change of G_MISS_xxx

Line 12223: ,P_START_DATE => Conv_To_TblHandler(p_start_date) -- Updated for STANDARD/perf change of G_MISS_xxx

12219: P_CITEM_VERSION_ID => px_citem_ver_id
12220: ,P_CONTENT_ITEM_ID => px_content_item_id
12221: ,P_SOURCE_LANG => lang
12222: ,P_CITEM_VERSION_STATUS => Conv_To_TblHandler(bulk_status) -- Updated for STANDARD/perf change of G_MISS_xxx
12223: ,P_START_DATE => Conv_To_TblHandler(p_start_date) -- Updated for STANDARD/perf change of G_MISS_xxx
12224: ,P_END_DATE => Conv_To_TblHandler(p_end_date) -- Updated for STANDARD/perf change of G_MISS_xxx
12225: ,P_ATTRIBUTE_FILE_ID => Conv_To_TblHandler(bundle_file_id) -- Updated for STANDARD/perf change of G_MISS_xxx
12226: ,P_ATTACHMENT_FILE_ID => Conv_To_TblHandler(p_attach_file_id) -- Updated for STANDARD/perf change of G_MISS_xxx
12227: ,P_ATTACHMENT_FILE_NAME => Conv_To_TblHandler(l_attach_file_name) -- Updated for STANDARD/perf change of G_MISS_xxx

Line 12224: ,P_END_DATE => Conv_To_TblHandler(p_end_date) -- Updated for STANDARD/perf change of G_MISS_xxx

12220: ,P_CONTENT_ITEM_ID => px_content_item_id
12221: ,P_SOURCE_LANG => lang
12222: ,P_CITEM_VERSION_STATUS => Conv_To_TblHandler(bulk_status) -- Updated for STANDARD/perf change of G_MISS_xxx
12223: ,P_START_DATE => Conv_To_TblHandler(p_start_date) -- Updated for STANDARD/perf change of G_MISS_xxx
12224: ,P_END_DATE => Conv_To_TblHandler(p_end_date) -- Updated for STANDARD/perf change of G_MISS_xxx
12225: ,P_ATTRIBUTE_FILE_ID => Conv_To_TblHandler(bundle_file_id) -- Updated for STANDARD/perf change of G_MISS_xxx
12226: ,P_ATTACHMENT_FILE_ID => Conv_To_TblHandler(p_attach_file_id) -- Updated for STANDARD/perf change of G_MISS_xxx
12227: ,P_ATTACHMENT_FILE_NAME => Conv_To_TblHandler(l_attach_file_name) -- Updated for STANDARD/perf change of G_MISS_xxx
12228: ,P_DEFAULT_RENDITION_MIME_TYPE => Conv_To_TblHandler(l_attach_rendition_mtype) -- Updated for STANDARD/perf change of G_MISS_xxx

Line 12225: ,P_ATTRIBUTE_FILE_ID => Conv_To_TblHandler(bundle_file_id) -- Updated for STANDARD/perf change of G_MISS_xxx

12221: ,P_SOURCE_LANG => lang
12222: ,P_CITEM_VERSION_STATUS => Conv_To_TblHandler(bulk_status) -- Updated for STANDARD/perf change of G_MISS_xxx
12223: ,P_START_DATE => Conv_To_TblHandler(p_start_date) -- Updated for STANDARD/perf change of G_MISS_xxx
12224: ,P_END_DATE => Conv_To_TblHandler(p_end_date) -- Updated for STANDARD/perf change of G_MISS_xxx
12225: ,P_ATTRIBUTE_FILE_ID => Conv_To_TblHandler(bundle_file_id) -- Updated for STANDARD/perf change of G_MISS_xxx
12226: ,P_ATTACHMENT_FILE_ID => Conv_To_TblHandler(p_attach_file_id) -- Updated for STANDARD/perf change of G_MISS_xxx
12227: ,P_ATTACHMENT_FILE_NAME => Conv_To_TblHandler(l_attach_file_name) -- Updated for STANDARD/perf change of G_MISS_xxx
12228: ,P_DEFAULT_RENDITION_MIME_TYPE => Conv_To_TblHandler(l_attach_rendition_mtype) -- Updated for STANDARD/perf change of G_MISS_xxx
12229: ,P_ATTACHMENT_ATTRIBUTE_CODE => Conv_To_TblHandler(attach_code) -- Updated for STANDARD/perf change of G_MISS_xxx

Line 12226: ,P_ATTACHMENT_FILE_ID => Conv_To_TblHandler(p_attach_file_id) -- Updated for STANDARD/perf change of G_MISS_xxx

12222: ,P_CITEM_VERSION_STATUS => Conv_To_TblHandler(bulk_status) -- Updated for STANDARD/perf change of G_MISS_xxx
12223: ,P_START_DATE => Conv_To_TblHandler(p_start_date) -- Updated for STANDARD/perf change of G_MISS_xxx
12224: ,P_END_DATE => Conv_To_TblHandler(p_end_date) -- Updated for STANDARD/perf change of G_MISS_xxx
12225: ,P_ATTRIBUTE_FILE_ID => Conv_To_TblHandler(bundle_file_id) -- Updated for STANDARD/perf change of G_MISS_xxx
12226: ,P_ATTACHMENT_FILE_ID => Conv_To_TblHandler(p_attach_file_id) -- Updated for STANDARD/perf change of G_MISS_xxx
12227: ,P_ATTACHMENT_FILE_NAME => Conv_To_TblHandler(l_attach_file_name) -- Updated for STANDARD/perf change of G_MISS_xxx
12228: ,P_DEFAULT_RENDITION_MIME_TYPE => Conv_To_TblHandler(l_attach_rendition_mtype) -- Updated for STANDARD/perf change of G_MISS_xxx
12229: ,P_ATTACHMENT_ATTRIBUTE_CODE => Conv_To_TblHandler(attach_code) -- Updated for STANDARD/perf change of G_MISS_xxx
12230: ,P_CONTENT_ITEM_NAME => Conv_To_TblHandler(p_citem_name) -- Updated for STANDARD/perf change of G_MISS_xxx

Line 12227: ,P_ATTACHMENT_FILE_NAME => Conv_To_TblHandler(l_attach_file_name) -- Updated for STANDARD/perf change of G_MISS_xxx

12223: ,P_START_DATE => Conv_To_TblHandler(p_start_date) -- Updated for STANDARD/perf change of G_MISS_xxx
12224: ,P_END_DATE => Conv_To_TblHandler(p_end_date) -- Updated for STANDARD/perf change of G_MISS_xxx
12225: ,P_ATTRIBUTE_FILE_ID => Conv_To_TblHandler(bundle_file_id) -- Updated for STANDARD/perf change of G_MISS_xxx
12226: ,P_ATTACHMENT_FILE_ID => Conv_To_TblHandler(p_attach_file_id) -- Updated for STANDARD/perf change of G_MISS_xxx
12227: ,P_ATTACHMENT_FILE_NAME => Conv_To_TblHandler(l_attach_file_name) -- Updated for STANDARD/perf change of G_MISS_xxx
12228: ,P_DEFAULT_RENDITION_MIME_TYPE => Conv_To_TblHandler(l_attach_rendition_mtype) -- Updated for STANDARD/perf change of G_MISS_xxx
12229: ,P_ATTACHMENT_ATTRIBUTE_CODE => Conv_To_TblHandler(attach_code) -- Updated for STANDARD/perf change of G_MISS_xxx
12230: ,P_CONTENT_ITEM_NAME => Conv_To_TblHandler(p_citem_name) -- Updated for STANDARD/perf change of G_MISS_xxx
12231: ,P_DESCRIPTION => Conv_To_TblHandler(p_citem_description) -- Updated for STANDARD/perf change of G_MISS_xxx

Line 12228: ,P_DEFAULT_RENDITION_MIME_TYPE => Conv_To_TblHandler(l_attach_rendition_mtype) -- Updated for STANDARD/perf change of G_MISS_xxx

12224: ,P_END_DATE => Conv_To_TblHandler(p_end_date) -- Updated for STANDARD/perf change of G_MISS_xxx
12225: ,P_ATTRIBUTE_FILE_ID => Conv_To_TblHandler(bundle_file_id) -- Updated for STANDARD/perf change of G_MISS_xxx
12226: ,P_ATTACHMENT_FILE_ID => Conv_To_TblHandler(p_attach_file_id) -- Updated for STANDARD/perf change of G_MISS_xxx
12227: ,P_ATTACHMENT_FILE_NAME => Conv_To_TblHandler(l_attach_file_name) -- Updated for STANDARD/perf change of G_MISS_xxx
12228: ,P_DEFAULT_RENDITION_MIME_TYPE => Conv_To_TblHandler(l_attach_rendition_mtype) -- Updated for STANDARD/perf change of G_MISS_xxx
12229: ,P_ATTACHMENT_ATTRIBUTE_CODE => Conv_To_TblHandler(attach_code) -- Updated for STANDARD/perf change of G_MISS_xxx
12230: ,P_CONTENT_ITEM_NAME => Conv_To_TblHandler(p_citem_name) -- Updated for STANDARD/perf change of G_MISS_xxx
12231: ,P_DESCRIPTION => Conv_To_TblHandler(p_citem_description) -- Updated for STANDARD/perf change of G_MISS_xxx
12232: ,PX_OBJECT_VERSION_NUMBER => px_object_version_number

Line 12229: ,P_ATTACHMENT_ATTRIBUTE_CODE => Conv_To_TblHandler(attach_code) -- Updated for STANDARD/perf change of G_MISS_xxx

12225: ,P_ATTRIBUTE_FILE_ID => Conv_To_TblHandler(bundle_file_id) -- Updated for STANDARD/perf change of G_MISS_xxx
12226: ,P_ATTACHMENT_FILE_ID => Conv_To_TblHandler(p_attach_file_id) -- Updated for STANDARD/perf change of G_MISS_xxx
12227: ,P_ATTACHMENT_FILE_NAME => Conv_To_TblHandler(l_attach_file_name) -- Updated for STANDARD/perf change of G_MISS_xxx
12228: ,P_DEFAULT_RENDITION_MIME_TYPE => Conv_To_TblHandler(l_attach_rendition_mtype) -- Updated for STANDARD/perf change of G_MISS_xxx
12229: ,P_ATTACHMENT_ATTRIBUTE_CODE => Conv_To_TblHandler(attach_code) -- Updated for STANDARD/perf change of G_MISS_xxx
12230: ,P_CONTENT_ITEM_NAME => Conv_To_TblHandler(p_citem_name) -- Updated for STANDARD/perf change of G_MISS_xxx
12231: ,P_DESCRIPTION => Conv_To_TblHandler(p_citem_description) -- Updated for STANDARD/perf change of G_MISS_xxx
12232: ,PX_OBJECT_VERSION_NUMBER => px_object_version_number
12233: );

Line 12230: ,P_CONTENT_ITEM_NAME => Conv_To_TblHandler(p_citem_name) -- Updated for STANDARD/perf change of G_MISS_xxx

12226: ,P_ATTACHMENT_FILE_ID => Conv_To_TblHandler(p_attach_file_id) -- Updated for STANDARD/perf change of G_MISS_xxx
12227: ,P_ATTACHMENT_FILE_NAME => Conv_To_TblHandler(l_attach_file_name) -- Updated for STANDARD/perf change of G_MISS_xxx
12228: ,P_DEFAULT_RENDITION_MIME_TYPE => Conv_To_TblHandler(l_attach_rendition_mtype) -- Updated for STANDARD/perf change of G_MISS_xxx
12229: ,P_ATTACHMENT_ATTRIBUTE_CODE => Conv_To_TblHandler(attach_code) -- Updated for STANDARD/perf change of G_MISS_xxx
12230: ,P_CONTENT_ITEM_NAME => Conv_To_TblHandler(p_citem_name) -- Updated for STANDARD/perf change of G_MISS_xxx
12231: ,P_DESCRIPTION => Conv_To_TblHandler(p_citem_description) -- Updated for STANDARD/perf change of G_MISS_xxx
12232: ,PX_OBJECT_VERSION_NUMBER => px_object_version_number
12233: );
12234: IF(p_log_action = FND_API.g_true) THEN

Line 12231: ,P_DESCRIPTION => Conv_To_TblHandler(p_citem_description) -- Updated for STANDARD/perf change of G_MISS_xxx

12227: ,P_ATTACHMENT_FILE_NAME => Conv_To_TblHandler(l_attach_file_name) -- Updated for STANDARD/perf change of G_MISS_xxx
12228: ,P_DEFAULT_RENDITION_MIME_TYPE => Conv_To_TblHandler(l_attach_rendition_mtype) -- Updated for STANDARD/perf change of G_MISS_xxx
12229: ,P_ATTACHMENT_ATTRIBUTE_CODE => Conv_To_TblHandler(attach_code) -- Updated for STANDARD/perf change of G_MISS_xxx
12230: ,P_CONTENT_ITEM_NAME => Conv_To_TblHandler(p_citem_name) -- Updated for STANDARD/perf change of G_MISS_xxx
12231: ,P_DESCRIPTION => Conv_To_TblHandler(p_citem_description) -- Updated for STANDARD/perf change of G_MISS_xxx
12232: ,PX_OBJECT_VERSION_NUMBER => px_object_version_number
12233: );
12234: IF(p_log_action = FND_API.g_true) THEN
12235: --***************************************************

Line 12306: ,P_CONTENT_ITEM_NAME => Conv_To_TblHandler(p_citem_name) -- Updated for STANDARD/perf change of G_MISS_xxx

12302: Ibc_Citem_Versions_Pkg.update_row(
12303: P_CITEM_VERSION_ID => px_citem_ver_id
12304: ,P_CONTENT_ITEM_ID => px_content_item_id
12305: ,P_SOURCE_LANG => lang
12306: ,P_CONTENT_ITEM_NAME => Conv_To_TblHandler(p_citem_name) -- Updated for STANDARD/perf change of G_MISS_xxx
12307: ,P_DESCRIPTION => Conv_To_TblHandler(p_citem_description) -- Updated for STANDARD/perf change of G_MISS_xxx
12308: ,PX_OBJECT_VERSION_NUMBER => px_object_version_number
12309: );
12310: IF(p_log_action = FND_API.g_true) THEN

Line 12307: ,P_DESCRIPTION => Conv_To_TblHandler(p_citem_description) -- Updated for STANDARD/perf change of G_MISS_xxx

12303: P_CITEM_VERSION_ID => px_citem_ver_id
12304: ,P_CONTENT_ITEM_ID => px_content_item_id
12305: ,P_SOURCE_LANG => lang
12306: ,P_CONTENT_ITEM_NAME => Conv_To_TblHandler(p_citem_name) -- Updated for STANDARD/perf change of G_MISS_xxx
12307: ,P_DESCRIPTION => Conv_To_TblHandler(p_citem_description) -- Updated for STANDARD/perf change of G_MISS_xxx
12308: ,PX_OBJECT_VERSION_NUMBER => px_object_version_number
12309: );
12310: IF(p_log_action = FND_API.g_true) THEN
12311: --***************************************************

Line 12447: -- Standard call to get message count and if count is 1, get message info.

12443: IF (p_commit = FND_API.g_true) THEN
12444: COMMIT;
12445: END IF;
12446:
12447: -- Standard call to get message count and if count is 1, get message info.
12448: FND_MSG_PUB.Count_And_Get(
12449: p_count => x_msg_count,
12450: p_data => x_msg_data
12451: );

Line 12471: -- Standard call to get message count and if count is 1, get message info.

12467: IF (p_commit = FND_API.g_true) THEN
12468: COMMIT;
12469: END IF;
12470:
12471: -- Standard call to get message count and if count is 1, get message info.
12472: FND_MSG_PUB.Count_And_Get(
12473: p_count => x_msg_count,
12474: p_data => x_msg_data
12475: );

Line 13248: -- local variable for standards **

13244: ,x_return_status OUT NOCOPY VARCHAR2
13245: ,x_msg_count OUT NOCOPY NUMBER
13246: ,x_msg_data OUT NOCOPY VARCHAR2
13247: ) AS
13248: --******** local variable for standards **********
13249: --******************* BEGIN REQUIRED VARIABLES *************************
13250: l_api_name CONSTANT VARCHAR2(30) := 'hard_delete_item_versions';--|**|
13251: l_api_version_number CONSTANT NUMBER := G_API_VERSION_DEFAULT; --|**|
13252: --******************* END REQUIRED VARIABLES ****************************

Line 13274: -- * Standard Begins *

13270: CITEM_VERSION_ID = l_citem_version_id;
13271:
13272: BEGIN
13273: --DBMS_OUTPUT.put_line('----- ' || l_api_name || ' -----');
13274: -- ******************* Standard Begins *******************
13275: -- Standard Start of API savepoint
13276: SAVEPOINT HARD_DELETE_ITEM_VERSIONS_PT;
13277:
13278: -- Standard call to check for call compatibility.

Line 13275: -- Standard Start of API savepoint

13271:
13272: BEGIN
13273: --DBMS_OUTPUT.put_line('----- ' || l_api_name || ' -----');
13274: -- ******************* Standard Begins *******************
13275: -- Standard Start of API savepoint
13276: SAVEPOINT HARD_DELETE_ITEM_VERSIONS_PT;
13277:
13278: -- Standard call to check for call compatibility.
13279: IF NOT FND_API.Compatible_API_Call (

Line 13278: -- Standard call to check for call compatibility.

13274: -- ******************* Standard Begins *******************
13275: -- Standard Start of API savepoint
13276: SAVEPOINT HARD_DELETE_ITEM_VERSIONS_PT;
13277:
13278: -- Standard call to check for call compatibility.
13279: IF NOT FND_API.Compatible_API_Call (
13280: l_api_version_number,
13281: p_api_version,
13282: l_api_name,

Line 13424: -- Standard check of p_commit.

13420:
13421:
13422: --******************* Real Logic End *********************
13423:
13424: -- Standard check of p_commit.
13425: IF( (x_return_status = FND_API.G_RET_STS_SUCCESS) AND (p_commit = FND_API.g_true) ) THEN
13426: COMMIT;
13427: END IF;
13428:

Line 13429: -- Standard call to get message count and if count is 1, get message info.

13425: IF( (x_return_status = FND_API.G_RET_STS_SUCCESS) AND (p_commit = FND_API.g_true) ) THEN
13426: COMMIT;
13427: END IF;
13428:
13429: -- Standard call to get message count and if count is 1, get message info.
13430: FND_MSG_PUB.Count_And_Get(
13431: p_count => x_msg_count,
13432: p_data => x_msg_data
13433: );

Line 13555: -- * Standard Begins *

13551: WHERE CONTENT_ITEM_ID = l_citem_id;
13552:
13553: BEGIN
13554: --DBMS_OUTPUT.put_line('----- ' || l_api_name || ' -----');
13555: -- ******************* Standard Begins *******************
13556: -- Standard Start of API savepoint
13557: SAVEPOINT HARD_DELETE_ITEMS_PT;
13558:
13559: -- Standard call to check for call compatibility.

Line 13556: -- Standard Start of API savepoint

13552:
13553: BEGIN
13554: --DBMS_OUTPUT.put_line('----- ' || l_api_name || ' -----');
13555: -- ******************* Standard Begins *******************
13556: -- Standard Start of API savepoint
13557: SAVEPOINT HARD_DELETE_ITEMS_PT;
13558:
13559: -- Standard call to check for call compatibility.
13560: IF NOT FND_API.Compatible_API_Call (

Line 13559: -- Standard call to check for call compatibility.

13555: -- ******************* Standard Begins *******************
13556: -- Standard Start of API savepoint
13557: SAVEPOINT HARD_DELETE_ITEMS_PT;
13558:
13559: -- Standard call to check for call compatibility.
13560: IF NOT FND_API.Compatible_API_Call (
13561: l_api_version_number,
13562: p_api_version,
13563: l_api_name,

Line 13677: -- Standard check of p_commit.

13673:
13674: END LOOP;
13675:
13676: --******************* Real Logic End *********************
13677: -- Standard check of p_commit.
13678: IF((x_return_status = FND_API.G_RET_STS_SUCCESS) AND (p_commit = FND_API.g_true) ) THEN
13679: COMMIT;
13680: END IF;
13681:

Line 13682: -- Standard call to get message count and if count is 1, get message info.

13678: IF((x_return_status = FND_API.G_RET_STS_SUCCESS) AND (p_commit = FND_API.g_true) ) THEN
13679: COMMIT;
13680: END IF;
13681:
13682: -- Standard call to get message count and if count is 1, get message info.
13683: FND_MSG_PUB.Count_And_Get(
13684: p_count => x_msg_count,
13685: p_data => x_msg_data
13686: );

Line 13827: -- Standard call to check for call compatibility. --|**|

13823: IF (p_init_msg_list = FND_API.g_true) THEN --|**|
13824: FND_MSG_PUB.initialize; --|**|
13825: END IF; --|**|
13826: --|**|
13827: -- Standard call to check for call compatibility. --|**|
13828: IF NOT FND_API.Compatible_API_Call ( --|**|
13829: l_api_version_number --|**|
13830: ,p_api_version_number --|**|
13831: ,l_api_name --|**|

Line 14021: -- Standard call to get message count and if count is 1, get message info.

14017: IF ( (x_return_status = FND_API.G_RET_STS_SUCCESS) AND (p_commit = FND_API.g_true) ) THEN
14018: COMMIT;
14019: END IF;
14020:
14021: -- Standard call to get message count and if count is 1, get message info.
14022: FND_MSG_PUB.Count_And_Get(
14023: p_count => x_msg_count
14024: ,p_data => x_msg_data
14025: );