DBA Data[Home] [Help]

APPS.IBC_ASSOCIATIONS_GRP dependencies on IBC_ASSOCIATION_TYPES_B

Line 606: SELECT association_type_code FROM IBC_ASSOCIATION_TYPES_B C;

602: CURSOR cur_assoc IS
603: SELECT A.COLUMN_VALUE association_type_code
604: FROM TABLE(CAST(p_assoc_type_codes AS JTF_VARCHAR2_TABLE_100)) A
605: MINUS
606: SELECT association_type_code FROM IBC_ASSOCIATION_TYPES_B C;
607:
608: BEGIN
609: -- ******************* Standard Begins *******************
610: -- Standard Start of API savepoint

Line 1467: FROM IBC_ASSOCIATIONS a, IBC_ASSOCIATION_TYPES_B t

1463: CURSOR Get_Assoc IS
1464: SELECT a.ASSOCIATION_TYPE_CODE, a.ASSOCIATED_OBJECT_VAL1, a.ASSOCIATED_OBJECT_VAL2,
1465: a.ASSOCIATED_OBJECT_VAL3, a.ASSOCIATED_OBJECT_VAL4, a.ASSOCIATED_OBJECT_VAL5,
1466: t.CALL_BACK_PKG
1467: FROM IBC_ASSOCIATIONS a, IBC_ASSOCIATION_TYPES_B t
1468: WHERE a.CONTENT_ITEM_ID = p_content_item_id AND
1469: a.citem_version_id = NVL(p_citem_version_id,a.citem_version_id) AND
1470: a.ASSOCIATION_TYPE_CODE = t.ASSOCIATION_TYPE_CODE;
1471:

Line 1474: FROM IBC_ASSOCIATION_TYPES_B

1470: a.ASSOCIATION_TYPE_CODE = t.ASSOCIATION_TYPE_CODE;
1471:
1472: CURSOR Get_CallBack IS
1473: SELECT CALL_BACK_PKG
1474: FROM IBC_ASSOCIATION_TYPES_B
1475: WHERE ASSOCIATION_TYPE_CODE = l_assoc_type_code;
1476:
1477: BEGIN
1478: -- ******************* Standard Begins *******************

Line 1714: FROM ibc_association_types_b

1710: post_plsql_block VARCHAR2(200) := '.Get_Object_Name(:at, :v1, :v2, :v3, :v4, :v5, :xn, :xc, :xret, :xmc, :md); END;';
1711:
1712: CURSOR c_callback(p_assoc_type_code VARCHAR2) IS
1713: SELECT call_back_pkg
1714: FROM ibc_association_types_b
1715: WHERE association_type_code = p_assoc_type_code;
1716:
1717: BEGIN
1718: