DBA Data[Home] [Help]

APPS.IBE_DSP_HIERARCHY_SETUP_PVT dependencies on JTF_AMV_ITEMS_B

Line 516: FROM jtf_amv_items_b

512: FUNCTION Get_Layout_Type(p_deliverable_id IN NUMBER) RETURN VARCHAR2
513: IS
514: CURSOR c_get_layout_type_csr(c_item_id NUMBER) IS
515: SELECT access_name, applicable_to_code
516: FROM jtf_amv_items_b
517: WHERE item_id = c_item_id
518: AND deliverable_type_code = 'TEMPLATE';
519:
520: l_access_name VARCHAR2(40);

Line 853: FROM jtf_amv_items_b

849: l_c_deliverable_type_code IN VARCHAR2,
850: l_c_applicable_to_code IN VARCHAR2,
851: l_c_application_id IN NUMBER ) IS
852: SELECT item_id
853: FROM jtf_amv_items_b
854: WHERE access_name = l_c_access_name
855: AND deliverable_type_code = l_c_deliverable_type_code
856: AND applicable_to_code = l_c_applicable_to_code
857: AND application_id = l_c_application_id;

Line 5499: -- step2:Create copy of all these Logical Media (jtf_amv_items_b/tl table)

5495: -- DEPRECATED: Due to change in requirement from PMs. : abhandar 14-Aug 2002
5496: -- Reference the contents of the old section to the new section.
5497: --
5498: ---step1:Retrieve all the Logical Media associated with the Old_Section
5499: -- step2:Create copy of all these Logical Media (jtf_amv_items_b/tl table)
5500: -- step3:Associate the new section with these new Logical Media ( ibe_dsp_obj_lgl_ctnt table)
5501: -- step4:For all the new Logical media, create equivalent store mappings as existed for the Old Logical Media
5502: -- (ibe_dsp_lgl_phys_map)
5503: