APPS.IBC_CV_LABEL_GRP dependencies on IBC_CITEM_VERSION_LABELS

Line 29: FROM IBC_CITEM_VERSION_LABELS

25: IS
26: CURSOR C_CV_Label IS
27: SELECT
28: label_code
29: FROM IBC_CITEM_VERSION_LABELS
30: WHERE Label_Code = P_CV_Label_Rec.Label_Code
31: AND content_item_id = P_CV_Label_Rec.content_item_id;
32:
33: l_api_version_number NUMBER := 1.0;

Line 128: Ibc_Citem_Version_Labels_Pkg.INSERT_ROW (

124:
125: --
126: -- Table Handler to Insert Row into IBC_CV_LabelS
127: --
128: Ibc_Citem_Version_Labels_Pkg.INSERT_ROW (
129: x_ROWID => lx_rowid
130: ,p_content_item_id => l_CV_Label_rec.content_item_id
131: ,p_Label_code => l_CV_Label_rec.Label_code
132: ,p_citem_version_id => l_CV_Label_rec.citem_version_id

Line 229: FROM IBC_CITEM_VERSION_LABELS

225: IS
226: CURSOR C_CV_Label IS
227: SELECT
228: label_code
229: FROM IBC_CITEM_VERSION_LABELS
230: WHERE Label_Code = P_CV_Label_Rec.Label_Code
231: AND content_item_id = P_CV_Label_Rec.content_item_id;
232:
233: l_temp CHAR(1);

Line 330: Ibc_Citem_Version_Labels_Pkg.UPDATE_ROW (

326:
327: --
328: -- Table Handler to Update Row into IBC_CV_LabelS
329: --
330: Ibc_Citem_Version_Labels_Pkg.UPDATE_ROW (
331: p_content_item_id => l_CV_Label_rec.content_item_id
332: ,p_Label_code => l_CV_Label_rec.Label_code
333: ,p_citem_version_id => l_CV_Label_rec.citem_version_id
334: ,p_LAST_UPDATED_BY => l_CV_Label_rec.LAST_UPDATED_BY

Line 430: FROM IBC_CITEM_VERSION_LABELS

426:
427: CURSOR C_CV_Label IS
428: SELECT
429: label_code
430: FROM IBC_CITEM_VERSION_LABELS
431: WHERE Label_Code = P_Label_Code
432: AND content_item_id = P_content_item_id;
433:
434: l_temp CHAR(1);

Line 472: Ibc_Citem_Version_Labels_Pkg.DELETE_ROW (

468:
469: --
470: -- Table Handler to Insert Row into IBC_CV_LabelS
471: --
472: Ibc_Citem_Version_Labels_Pkg.DELETE_ROW (
473: p_content_item_id => p_content_item_id
474: ,p_Label_code => p_Label_code);
475:
476:

Line 578: FROM IBC_CITEM_VERSION_LABELS

574: ,l_CV_Label_Rec.LAST_UPDATED_BY
575: ,l_CV_Label_Rec.LAST_UPDATE_DATE
576: ,l_CV_Label_Rec.LAST_UPDATE_LOGIN
577: ,l_CV_Label_Rec.OBJECT_VERSION_NUMBER
578: FROM IBC_CITEM_VERSION_LABELS
579: WHERE CONTENT_ITEM_ID = p_content_item_id
580: AND LABEL_CODE = p_label_code;
581:
582: RETURN l_CV_Label_rec;

Line 719: UPDATE IBC_CITEM_VERSION_LABELS SET

715:
716: --
717: -- Update
718: FORALL i IN p_content_item_ids.FIRST..p_content_item_ids.LAST
719: UPDATE IBC_CITEM_VERSION_LABELS SET
720: CITEM_VERSION_ID = l_citem_version_ids(i),
721: OBJECT_VERSION_NUMBER = 1,
722: LAST_UPDATE_DATE = SYSDATE,
723: LAST_UPDATED_BY = Fnd_Global.user_id,

Line 750: INSERT INTO IBC_CITEM_VERSION_LABELS (

746: --
747: IF l_ins_content_item_ids.EXISTS(l_ins_content_item_ids.FIRST) THEN
748:
749: FORALL i IN l_ins_content_item_ids.FIRST..l_ins_content_item_ids.LAST
750: INSERT INTO IBC_CITEM_VERSION_LABELS (
751: CONTENT_ITEM_ID,
752: LABEL_CODE,
753: CITEM_VERSION_ID,
754: OBJECT_VERSION_NUMBER,

Line 962: DELETE FROM IBC_CITEM_VERSION_LABELS

958:
959: --
960: -- Delete
961: FORALL i IN p_content_item_ids.FIRST..p_content_item_ids.LAST
962: DELETE FROM IBC_CITEM_VERSION_LABELS
963: WHERE label_code = p_label_code
964: AND content_item_id = p_content_item_ids(i);
965:
966: --DBMS_OUTPUT.put_line('Delete Successful....');