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 1469: l_object_id ota_frm_obj_inclusions.object_id%type;

1465: p_forum_id in ota_forums_b.forum_id%type,
1466: p_self_enroll_only in varchar2) return varchar2 is
1467:
1468: l_now date := sysdate;
1469: l_object_id ota_frm_obj_inclusions.object_id%type;
1470: l_parent_cat_usage_id_1 ota_category_usages.category_usage_id%type;
1471: l_parent_cat_usage_id_2 ota_category_usages.category_usage_id%type;
1472: l_parent_cat_usage_id_3 ota_category_usages.category_usage_id%type;
1473: l_parent_cat_usage_id_4 ota_category_usages.category_usage_id%type;

Line 1520: l_object_id ota_frm_obj_inclusions.object_id%type;

1516: p_party_id in hz_parties.party_id%type,
1517: p_forum_id in ota_forums_b.forum_id%type,
1518: p_self_enroll_only in varchar2) return varchar2 is
1519:
1520: l_object_id ota_frm_obj_inclusions.object_id%type;
1521: l_parent_cat_usage_id_1 ota_category_usages.category_usage_id%type;
1522: l_parent_cat_usage_id_2 ota_category_usages.category_usage_id%type;
1523: l_parent_cat_usage_id_3 ota_category_usages.category_usage_id%type;
1524: l_parent_cat_usage_id_4 ota_category_usages.category_usage_id%type;