APPS.GME_GANTT_RSRC_PKG dependencies on CR_RSRC_MST

Line 46: FROM cr_rsrc_mst r, cr_rsrc_dtl d

42: IS
43: CURSOR get_plant_resources
44: IS
45: SELECT DISTINCT r.resources, r.resource_desc
46: FROM cr_rsrc_mst r, cr_rsrc_dtl d
47: WHERE d.organization_id = p_organization_id
48: AND d.delete_mark = 0
49: AND r.resources = d.resources
50: AND r.delete_mark = 0

Line 58: l_resource_desc_str CR_RSRC_MST_B.RESOURCE_DESC%TYPE; -- bug14480509

54: resource_desc resdesc;
55: l_nb_record BINARY_INTEGER := 0;
56: l_record_ind BINARY_INTEGER := 1;
57: l_resources_str VARCHAR2 (64);
58: l_resource_desc_str CR_RSRC_MST_B.RESOURCE_DESC%TYPE; -- bug14480509
59: l_rsrc_record VARCHAR2 (500);-- bug 14693125 add enough size to store resource||resource_desc
60: l_rsrc_record_tbl VARCHAR2 (32000);
61: l_api_name CONSTANT VARCHAR2 (30) := 'Get_Available_Plant_Resources';
62: BEGIN

Line 315: FROM cr_rsrc_mst m, cr_rsrc_dtl d

311: -- Get resource information
312: CURSOR get_rsrc_info
313: IS
314: SELECT d.resource_id, m.std_usage_um, m.resource_desc
315: FROM cr_rsrc_mst m, cr_rsrc_dtl d
316: WHERE d.organization_id = p_organization_id
317: AND d.resources = p_resource_code
318: AND d.resources = m.resources;
319:

Line 334: l_resource_desc CR_RSRC_MST_B.RESOURCE_DESC%TYPE; -- bug14480509

330: l_msg_count NUMBER (10);
331: l_msg_data VARCHAR2 (2000);
332: l_return_code VARCHAR2 (1);
333: l_rsrc_count_str VARCHAR2 (10);
334: l_resource_desc CR_RSRC_MST_B.RESOURCE_DESC%TYPE; -- bug14480509
335: l_resource_um VARCHAR2 (16);
336: l_resource_code VARCHAR2 (64);
337: l_record_ind BINARY_INTEGER := 1;
338: l_nb_record BINARY_INTEGER := 0;