DBA Data[Home] [Help]

APPS.IBC_ASSOCIATION_TYPES_PVT dependencies on IBC_ASSOCIATION_TYPES_B

Line 157: FROM ibc_Association_types_b

153: IS
154:
155: CURSOR C_Association_Type(p_Association_Type_Code IN VARCHAR2) IS
156: SELECT Association_Type_Code
157: FROM ibc_Association_types_b
158: WHERE association_Type_Code = p_Association_Type_Code;
159:
160: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
161:

Line 294: -- Insert The Corresponding Associations in ibc_Association_types_b table

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

Line 441: -- Update The Corresponding Associations in ibc_Association_types_b table

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

Line 554: FROM ibc_Association_types_b

550:
551: CURSOR C_Association_Type IS
552: SELECT
553: Association_Type_Code
554: FROM ibc_Association_types_b
555: WHERE Association_Type_Code = p_Association_Type_Code;
556:
557:
558: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 737: FROM ibc_Association_types_b

733: IS
734:
735: CURSOR C_Association_Type(p_Association_Type_Code IN VARCHAR2) IS
736: SELECT Association_Type_Code
737: FROM ibc_Association_types_b
738: WHERE Association_Type_Code = p_Association_Type_Code;
739:
740: l_temp CHAR(1);
741: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 824: FROM ibc_Association_types_b

820: IS
821:
822: CURSOR C_Association_Type(p_Association_Type_Code IN VARCHAR2) IS
823: SELECT Association_Type_Code
824: FROM ibc_Association_types_b
825: WHERE Association_Type_Code = p_Association_Type_Code;
826:
827: l_temp CHAR(1);
828: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;