APPS.OTA_LEARNER_ACCESS_UTIL dependencies on OTA_FRM_OBJ_INCLUSIONS

Line 57: from ota_frm_obj_inclusions i,

53: c1.parent_cat_usage_id as parent_cat_usage_id_1,
54: c2.parent_cat_usage_id as parent_cat_usage_id_2,
55: c3.parent_cat_usage_id as parent_cat_usage_id_3,
56: c4.parent_cat_usage_id as parent_cat_usage_id_4
57: from ota_frm_obj_inclusions i,
58: ota_category_usages c1,
59: ota_category_usages c2,
60: ota_category_usages c3,
61: ota_category_usages c4

Line 1456: l_object_id ota_frm_obj_inclusions.object_id%type;

1452: p_forum_id in ota_forums_b.forum_id%type,
1453: p_self_enroll_only in varchar2) return varchar2 is
1454:
1455: l_now date := sysdate;
1456: l_object_id ota_frm_obj_inclusions.object_id%type;
1457: l_parent_cat_usage_id_1 ota_category_usages.category_usage_id%type;
1458: l_parent_cat_usage_id_2 ota_category_usages.category_usage_id%type;
1459: l_parent_cat_usage_id_3 ota_category_usages.category_usage_id%type;
1460: l_parent_cat_usage_id_4 ota_category_usages.category_usage_id%type;

Line 1507: l_object_id ota_frm_obj_inclusions.object_id%type;

1503: p_party_id in hz_parties.party_id%type,
1504: p_forum_id in ota_forums_b.forum_id%type,
1505: p_self_enroll_only in varchar2) return varchar2 is
1506:
1507: l_object_id ota_frm_obj_inclusions.object_id%type;
1508: l_parent_cat_usage_id_1 ota_category_usages.category_usage_id%type;
1509: l_parent_cat_usage_id_2 ota_category_usages.category_usage_id%type;
1510: l_parent_cat_usage_id_3 ota_category_usages.category_usage_id%type;
1511: l_parent_cat_usage_id_4 ota_category_usages.category_usage_id%type;