APPS.IBC_VALIDATE_PVT dependencies on IBC_UTILITIES_PUB

Line 33: citem_version_status = IBC_UTILITIES_PUB.G_STV_APPROVED;

29: ibc_citem_versions_b
30: WHERE
31: citem_version_id = f_citem_ver_id
32: AND
33: citem_version_status = IBC_UTILITIES_PUB.G_STV_APPROVED;
34:
35: temp NUMBER;
36: BEGIN
37: open c_app;

Line 71: content_item_status = IBC_UTILITIES_PUB.G_STI_APPROVED;

67: ibc_content_items
68: WHERE
69: content_item_id = f_citem_id
70: AND
71: content_item_status = IBC_UTILITIES_PUB.G_STI_APPROVED;
72:
73: temp NUMBER;
74: BEGIN
75: open c_appi;

Line 717: if ( (f_status = IBC_UTILITIES_PUB.G_STV_SUBMIT_FOR_APPROVAL) or

713: IS
714: temp VARCHAR2(30);
715: BEGIN
716:
717: if ( (f_status = IBC_UTILITIES_PUB.G_STV_SUBMIT_FOR_APPROVAL) or
718: (f_status = IBC_UTILITIES_PUB.G_STV_APPROVED) or
719: (f_status = IBC_UTILITIES_PUB.G_STV_ARCHIVED) or
720: (f_status = IBC_UTILITIES_PUB.G_STV_WORK_IN_PROGRESS) or
721: (f_status = IBC_UTILITIES_PUB.G_STV_REJECTED) ) then

Line 718: (f_status = IBC_UTILITIES_PUB.G_STV_APPROVED) or

714: temp VARCHAR2(30);
715: BEGIN
716:
717: if ( (f_status = IBC_UTILITIES_PUB.G_STV_SUBMIT_FOR_APPROVAL) or
718: (f_status = IBC_UTILITIES_PUB.G_STV_APPROVED) or
719: (f_status = IBC_UTILITIES_PUB.G_STV_ARCHIVED) or
720: (f_status = IBC_UTILITIES_PUB.G_STV_WORK_IN_PROGRESS) or
721: (f_status = IBC_UTILITIES_PUB.G_STV_REJECTED) ) then
722:

Line 719: (f_status = IBC_UTILITIES_PUB.G_STV_ARCHIVED) or

715: BEGIN
716:
717: if ( (f_status = IBC_UTILITIES_PUB.G_STV_SUBMIT_FOR_APPROVAL) or
718: (f_status = IBC_UTILITIES_PUB.G_STV_APPROVED) or
719: (f_status = IBC_UTILITIES_PUB.G_STV_ARCHIVED) or
720: (f_status = IBC_UTILITIES_PUB.G_STV_WORK_IN_PROGRESS) or
721: (f_status = IBC_UTILITIES_PUB.G_STV_REJECTED) ) then
722:
723: RETURN FND_API.g_true;

Line 720: (f_status = IBC_UTILITIES_PUB.G_STV_WORK_IN_PROGRESS) or

716:
717: if ( (f_status = IBC_UTILITIES_PUB.G_STV_SUBMIT_FOR_APPROVAL) or
718: (f_status = IBC_UTILITIES_PUB.G_STV_APPROVED) or
719: (f_status = IBC_UTILITIES_PUB.G_STV_ARCHIVED) or
720: (f_status = IBC_UTILITIES_PUB.G_STV_WORK_IN_PROGRESS) or
721: (f_status = IBC_UTILITIES_PUB.G_STV_REJECTED) ) then
722:
723: RETURN FND_API.g_true;
724: else

Line 721: (f_status = IBC_UTILITIES_PUB.G_STV_REJECTED) ) then

717: if ( (f_status = IBC_UTILITIES_PUB.G_STV_SUBMIT_FOR_APPROVAL) or
718: (f_status = IBC_UTILITIES_PUB.G_STV_APPROVED) or
719: (f_status = IBC_UTILITIES_PUB.G_STV_ARCHIVED) or
720: (f_status = IBC_UTILITIES_PUB.G_STV_WORK_IN_PROGRESS) or
721: (f_status = IBC_UTILITIES_PUB.G_STV_REJECTED) ) then
722:
723: RETURN FND_API.g_true;
724: else
725: RETURN FND_API.g_false;

Line 1303: AND citem_translation_status = IBC_UTILITIES_PUB.G_STV_APPROVED;

1299: ibc_citem_versions_tl
1300: WHERE
1301: citem_version_id = f_citem_ver_id
1302: AND language = f_language
1303: AND citem_translation_status = IBC_UTILITIES_PUB.G_STV_APPROVED;
1304:
1305: temp NUMBER;
1306: BEGIN
1307: open c_app;