DBA Data[Home] [Help]

APPS.IBC_CITEM_WORKFLOW_PVT dependencies on IBC_UTILITIES_PUB

Line 412: OPEN c_component_not_status(p_citem_ver_id, IBC_UTILITIES_PUB.G_STV_APPROVED);

408: RAISE FND_API.G_EXC_ERROR;
409: END IF;
410:
411: -- Validation of Components (they need to be approved already)
412: OPEN c_component_not_status(p_citem_ver_id, IBC_UTILITIES_PUB.G_STV_APPROVED);
413: FETCH c_component_not_status INTO l_dummy;
414: IF (c_component_not_status%FOUND) THEN
415: CLOSE c_component_not_status;
416: x_return_status := FND_API.G_RET_STS_ERROR;

Line 520: ,p_new_status => IBC_UTILITIES_PUB.G_STV_APPROVED

516: -- then change status directly.
517: -- Requiremente driven by PRP, but generalized.
518: IBC_CITEM_ADMIN_GRP.change_status(
519: p_citem_ver_id => p_citem_ver_id
520: ,p_new_status => IBC_UTILITIES_PUB.G_STV_APPROVED
521: ,p_language => p_language
522: ,p_commit => FND_API.g_false
523: ,p_init_msg_list => FND_API.g_false
524: ,px_object_version_number => px_object_version_number

Line 542: ,p_new_status => IBC_UTILITIES_PUB.G_STV_SUBMIT_FOR_APPROVAL

538: px_object_version_number := NVL(px_object_version_number,
539: IBC_CITEM_ADMIN_GRP.getObjVerNum(l_content_item_id));
540: IBC_CITEM_ADMIN_GRP.change_status(
541: p_citem_ver_id => p_citem_ver_id
542: ,p_new_status => IBC_UTILITIES_PUB.G_STV_SUBMIT_FOR_APPROVAL
543: ,p_language => p_language
544: ,p_commit => FND_API.g_false
545: ,p_init_msg_list => FND_API.g_true
546: ,px_object_version_number => px_object_version_number

Line 699: IBC_UTILITIES_PUB.G_STV_SUBMIT_FOR_APPROVAL);

695: avalue => l_format_callback_url);
696:
697: l_format_callback_url := REPLACE(l_format_callback_url,
698: FND_GLOBAL.Local_Chr(38) || 'ACTION_MODE',
699: IBC_UTILITIES_PUB.G_STV_SUBMIT_FOR_APPROVAL);
700:
701: WF_ENGINE.SetItemAttrText( itemtype => l_ItemType,
702: itemkey => l_Itemkey,
703: aname => 'CALLBACK_URL',

Line 827: ,p_new_status => IBC_UTILITIES_PUB.G_STV_APPROVED

823: IF l_citem_ver_id IS NOT NULL THEN
824:
825: IBC_CITEM_ADMIN_GRP.change_status(
826: p_citem_ver_id => l_citem_ver_id
827: ,p_new_status => IBC_UTILITIES_PUB.G_STV_APPROVED
828: ,p_language => l_language
829: ,p_commit => FND_API.g_true
830: ,p_init_msg_list => FND_API.g_true
831: ,px_object_version_number => l_object_version_number

Line 850: IBC_UTILITIES_PUB.G_STV_APPROVED);

846: );
847: IF l_callback_url IS NOT NULL THEN
848: l_callback_url := REPLACE(l_callback_url,
849: FND_GLOBAL.Local_Chr(38) || 'ACTION_MODE',
850: IBC_UTILITIES_PUB.G_STV_APPROVED);
851: WF_ENGINE.SetItemAttrText(
852: itemtype => itemtype,
853: itemkey => itemkey,
854: aname => 'CALLBACK_URL',

Line 949: ,p_new_status => IBC_UTILITIES_PUB.G_STV_REJECTED

945: aname => 'CITEM_LANGUAGE'
946: );
947: IBC_CITEM_ADMIN_GRP.change_status(
948: p_citem_ver_id => l_citem_ver_id
949: ,p_new_status => IBC_UTILITIES_PUB.G_STV_REJECTED
950: ,p_language => l_language
951: ,p_commit => FND_API.g_true
952: ,p_init_msg_list => FND_API.g_true
953: ,px_object_version_number => l_object_version_number

Line 962: IBC_UTILITIES_PUB.G_STV_REJECTED);

958:
959: IF l_callback_url IS NOT NULL THEN
960: l_callback_url := REPLACE(l_callback_url,
961: FND_GLOBAL.Local_Chr(38) || 'ACTION_MODE',
962: IBC_UTILITIES_PUB.G_STV_REJECTED);
963: WF_ENGINE.SetItemAttrText(
964: itemtype => itemtype,
965: itemkey => itemkey,
966: aname => 'CALLBACK_URL',

Line 2012: ,p_new_status => IBC_UTILITIES_PUB.G_STV_APPROVED -- Change the status to approve

2008: THEN
2009: -- Set Status of Content Item Version
2010: IBC_CITEM_ADMIN_GRP.Change_Translation_Status(
2011: p_citem_ver_id => p_citem_ver_id
2012: ,p_new_status => IBC_UTILITIES_PUB.G_STV_APPROVED -- Change the status to approve
2013: ,p_language => p_language
2014: ,p_commit => FND_API.g_false
2015: ,p_init_msg_list => FND_API.g_true
2016: ,px_object_version_number => px_object_version_number

Line 2039: ,p_extra_info2_value => IBC_UTILITIES_PUB.G_STV_APPROVED

2035: ,p_message_application => 'IBC'
2036: ,p_message_name => 'IBC_TRANS_LOG_MSG'
2037: ,p_extra_info2_type => IBC_AUDIT_LOG_GRP.G_EI_LOOKUP
2038: ,p_extra_info2_ref_type => 'IBC_CITEM_VERSION_STATUS'
2039: ,p_extra_info2_value => IBC_UTILITIES_PUB.G_STV_APPROVED
2040: --,p_commit => FND_API.g_true
2041: ,p_init_msg_list => FND_API.g_true
2042: ,x_return_status => x_return_status
2043: ,x_msg_count => x_msg_count

Line 2058: ,p_new_status => IBC_UTILITIES_PUB.G_STV_SUBMIT_FOR_APPROVAL -- Change the status to submitted

2054:
2055: -- Set Status of Content Item Version
2056: IBC_CITEM_ADMIN_GRP.Change_Translation_Status(
2057: p_citem_ver_id => p_citem_ver_id
2058: ,p_new_status => IBC_UTILITIES_PUB.G_STV_SUBMIT_FOR_APPROVAL -- Change the status to submitted
2059: ,p_language => p_language
2060: ,p_commit => FND_API.g_false
2061: ,p_init_msg_list => FND_API.g_true
2062: ,px_object_version_number => px_object_version_number

Line 2083: ,p_extra_info2_value => IBC_UTILITIES_PUB.G_STV_SUBMIT_FOR_APPROVAL

2079: ,p_message_application => 'IBC'
2080: ,p_message_name => 'IBC_TRANS_LOG_MSG'
2081: ,p_extra_info2_type => IBC_AUDIT_LOG_GRP.G_EI_LOOKUP
2082: ,p_extra_info2_ref_type => 'IBC_CITEM_VERSION_STATUS'
2083: ,p_extra_info2_value => IBC_UTILITIES_PUB.G_STV_SUBMIT_FOR_APPROVAL
2084: --,p_commit => FND_API.g_true
2085: ,p_init_msg_list => FND_API.g_true
2086: ,x_return_status => x_return_status
2087: ,x_msg_count => x_msg_count

Line 2262: ,IBC_UTILITIES_PUB.G_STV_SUBMIT_FOR_APPROVAL);

2258: ,avalue => l_format_callback_url);
2259:
2260: l_format_callback_url := REPLACE(l_format_callback_url
2261: ,FND_GLOBAL.Local_Chr(38) || 'ACTION_MODE'
2262: ,IBC_UTILITIES_PUB.G_STV_SUBMIT_FOR_APPROVAL);
2263:
2264: WF_ENGINE.SetItemAttrText(itemtype => l_ItemType
2265: ,itemkey => l_Itemkey
2266: ,aname => 'CALLBACK_URL'

Line 2421: ,p_new_status => IBC_UTILITIES_PUB.G_STV_REJECTED

2417:
2418: -- Update the Translation Approval Status
2419: IBC_CITEM_ADMIN_GRP.Change_Translation_Status(
2420: p_citem_ver_id => l_citem_ver_id
2421: ,p_new_status => IBC_UTILITIES_PUB.G_STV_REJECTED
2422: ,p_language => l_language
2423: ,p_commit => FND_API.g_true
2424: ,p_init_msg_list => FND_API.g_true
2425: ,px_object_version_number => l_object_version_number

Line 2435: ,IBC_UTILITIES_PUB.G_STV_REJECTED

2431:
2432: IF l_callback_url IS NOT NULL THEN
2433: l_callback_url := REPLACE(l_callback_url
2434: ,FND_GLOBAL.Local_Chr(38) || 'ACTION_MODE'
2435: ,IBC_UTILITIES_PUB.G_STV_REJECTED
2436: );
2437:
2438: WF_ENGINE.SetItemAttrText(itemtype => itemtype
2439: ,itemkey => itemkey

Line 2465: ,p_extra_info2_value => IBC_UTILITIES_PUB.G_STV_REJECTED

2461: ,p_extra_info1_type => IBC_AUDIT_LOG_GRP.G_EI_CONSTANT
2462: ,p_extra_info1_value => l_comments
2463: ,p_extra_info2_type => IBC_AUDIT_LOG_GRP.G_EI_LOOKUP
2464: ,p_extra_info2_ref_type => 'IBC_CITEM_VERSION_STATUS'
2465: ,p_extra_info2_value => IBC_UTILITIES_PUB.G_STV_REJECTED
2466: --,p_commit => FND_API.g_true
2467: ,p_init_msg_list => FND_API.g_true
2468: ,x_return_status => l_return_status
2469: ,x_msg_count => l_msg_count

Line 2551: ,p_new_status => IBC_UTILITIES_PUB.G_STV_APPROVED

2547: IF l_citem_ver_id IS NOT NULL THEN
2548: -- Update the Translation Approval Status
2549: IBC_CITEM_ADMIN_GRP.Change_Translation_Status(
2550: p_citem_ver_id => l_citem_ver_id
2551: ,p_new_status => IBC_UTILITIES_PUB.G_STV_APPROVED
2552: ,p_language => l_language
2553: ,p_commit => FND_API.g_true
2554: ,p_init_msg_list => FND_API.g_true
2555: ,px_object_version_number => l_object_version_number

Line 2577: ,IBC_UTILITIES_PUB.G_STV_APPROVED

2573:
2574: IF l_callback_url IS NOT NULL THEN
2575: l_callback_url := REPLACE(l_callback_url
2576: ,FND_GLOBAL.Local_Chr(38) || 'ACTION_MODE'
2577: ,IBC_UTILITIES_PUB.G_STV_APPROVED
2578: );
2579:
2580: WF_ENGINE.SetItemAttrText(itemtype => itemtype
2581: ,itemkey => itemkey

Line 2599: ,p_extra_info2_value => IBC_UTILITIES_PUB.G_STV_APPROVED

2595: ,p_message_application => 'IBC'
2596: ,p_message_name => 'IBC_TRANS_LOG_MSG'
2597: ,p_extra_info2_type => IBC_AUDIT_LOG_GRP.G_EI_LOOKUP
2598: ,p_extra_info2_ref_type => 'IBC_CITEM_VERSION_STATUS'
2599: ,p_extra_info2_value => IBC_UTILITIES_PUB.G_STV_APPROVED
2600: --,p_commit => FND_API.g_true
2601: ,p_init_msg_list => FND_API.g_true
2602: ,x_return_status => l_return_status
2603: ,x_msg_count => l_msg_count