DBA Data[Home] [Help]

APPS.IBC_LABELS_GRP dependencies on IBC_LABELS_B

Line 155: FROM ibc_Labels_b

151: IS
152:
153: CURSOR C_Label(p_Label_Code IN VARCHAR2) IS
154: SELECT Label_Code
155: FROM ibc_Labels_b
156: WHERE Label_Code = p_Label_Code;
157:
158: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
159:

Line 291: -- Insert The Corresponding Associations in ibc_Labels_b table

287: RAISE FND_API.G_EXC_ERROR;
288: END IF;
289:
290: --dbms_output.put_line('Insert into Association Type Success');
291: -- Insert The Corresponding Associations in ibc_Labels_b table
292:
293: IF l_Label_tbl.COUNT <> 0 THEN
294: FOR i IN l_Label_tbl.FIRST..l_Label_tbl.LAST LOOP
295:

Line 440: -- Update The Corresponding Associations in ibc_Labels_b table

436: END IF;
437: RAISE FND_API.G_EXC_ERROR;
438: END IF;
439:
440: -- Update The Corresponding Associations in ibc_Labels_b table
441:
442: IF l_Label_tbl.COUNT <> 0 THEN
443:
444: FOR i IN l_Label_tbl.FIRST..l_Label_tbl.LAST LOOP

Line 556: FROM ibc_Labels_b

552:
553: CURSOR C_Label IS
554: SELECT
555: Label_Code
556: FROM ibc_Labels_b
557: WHERE Label_Code = p_Label_Code;
558:
559:
560: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 739: FROM ibc_Labels_b

735: IS
736:
737: CURSOR C_Label(p_Label_Code IN VARCHAR2) IS
738: SELECT Label_Code
739: FROM ibc_Labels_b
740: WHERE Label_Code = p_Label_Code;
741:
742: l_temp CHAR(1);
743: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 825: FROM ibc_Labels_b

821: IS
822:
823: CURSOR C_Label(p_Label_Code IN VARCHAR2) IS
824: SELECT Label_Code
825: FROM ibc_Labels_b
826: WHERE Label_Code = p_Label_Code;
827:
828: l_temp CHAR(1);
829: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;