396:
397: -- Begin
398:
399: -- Validation of Content Item before submitting it for approval
400: IBC_CITEM_ADMIN_GRP.pre_validate_item(
401: p_citem_ver_id => p_citem_ver_id
402: ,x_return_status => x_return_status
403: ,x_msg_count => x_msg_count
404: ,x_msg_data => x_msg_data
465: l_wf_no_approver_defined := 'Y';
466: END IF;
467:
468: -- Unlock Content Id
469: IBC_CITEM_ADMIN_GRP.unlock_item(
470: p_content_item_id => l_content_item_id
471: ,p_commit => FND_API.g_false
472: ,p_init_msg_list => FND_API.g_false
473: ,x_return_status => x_return_status
514: -- If no approver or submitter is approver
515: -- and approval workflow has not been customized
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
535:
536: ELSE
537: -- Set Status of Content Item to SUBMITTED
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
536: ELSE
537: -- Set Status of Content Item to SUBMITTED
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
812: itemtype => itemtype,
813: itemkey => itemkey,
814: aname => 'CITEM_VER_ID'
815: );
816: l_object_version_number := IBC_CITEM_ADMIN_GRP.getObjVerNum(getCitemId(l_citem_ver_id));
817: l_language := WF_ENGINE.GetItemAttrText(
818: itemtype => itemtype,
819: itemkey => itemkey,
820: aname => 'CITEM_LANGUAGE'
821: );
822:
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
937: itemtype => itemtype,
938: itemkey => itemkey,
939: aname => 'CITEM_VER_ID'
940: );
941: l_object_version_number := IBC_CITEM_ADMIN_GRP.getObjVerNum(getCitemId(l_citem_ver_id));
942: l_language := WF_ENGINE.GetItemAttrText(
943: itemtype => itemtype,
944: itemkey => itemkey,
945: aname => 'CITEM_LANGUAGE'
943: itemtype => itemtype,
944: itemkey => itemkey,
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
1184: FND_GLOBAL.Local_Chr(38) || 'CITEM_VERSION_ID',
1185: l_citem_ver_id);
1186: l_format_callback_url := REPLACE(l_format_callback_url,
1187: FND_GLOBAL.Local_Chr(38) || 'OBJECT_VERSION_NUMBER',
1188: IBC_CITEM_ADMIN_GRP.getobjvernum(l_content_item_id));
1189: l_format_callback_url := REPLACE(l_format_callback_url,
1190: FND_GLOBAL.Local_Chr(38) || 'CONTENT_ITEM_LANGUAGE',
1191: l_language);
1192: l_format_callback_url := REPLACE(l_format_callback_url,
1991: l_wf_no_approver_defined := 'Y';
1992: END IF;
1993:
1994: px_object_version_number := NVL(px_object_version_number
1995: ,IBC_CITEM_ADMIN_GRP.getObjVerNum(l_content_item_id)
1996: );
1997:
1998:
1999: --======================================================================
2006: IF l_wf_no_approver_defined = 'Y' AND
2007: NVL(Fnd_Profile.Value_specific('IBC_CUSTOMIZED_APPROVAL_WF',-999,-999,-999), 'N') = 'N'
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
2052: --======================================================================
2053: --======================================================================
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
2407: ,itemkey => itemkey
2408: ,aname => 'CITEM_VER_ID'
2409: );
2410:
2411: l_object_version_number := IBC_CITEM_ADMIN_GRP.getObjVerNum(getCitemId(l_citem_ver_id));
2412:
2413: l_language := WF_ENGINE.GetItemAttrText(itemtype => itemtype
2414: ,itemkey => itemkey
2415: ,aname => 'CITEM_LANGUAGE'
2415: ,aname => 'CITEM_LANGUAGE'
2416: );
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
2536: ,itemkey => itemkey
2537: ,aname => 'CITEM_VER_ID'
2538: );
2539:
2540: l_object_version_number := IBC_CITEM_ADMIN_GRP.getObjVerNum(getCitemId(l_citem_ver_id));
2541:
2542: l_language := WF_ENGINE.GetItemAttrText(itemtype => itemtype
2543: ,itemkey => itemkey
2544: ,aname => 'CITEM_LANGUAGE'
2545: );
2546:
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