APPS.GMF_COPY_RSRC_COST dependencies on CR_RSRC_MST

Line 54: pi_resource_class IN cr_rsrc_mst.resource_class%TYPE,

50: pi_organization_id_to IN cm_rsrc_dtl.organization_id%TYPE,
51: pi_calendar_code_to IN cm_rsrc_dtl.calendar_code%TYPE,
52: pi_period_code_to IN cm_rsrc_dtl.period_code%TYPE,
53: pi_cost_type_id_to IN cm_rsrc_dtl.cost_type_id%TYPE,
54: pi_resource_class IN cr_rsrc_mst.resource_class%TYPE,
55: pi_all_periods_from IN cm_cmpt_dtl.period_code%TYPE,
56: pi_all_periods_to IN cm_cmpt_dtl.period_code%TYPE,
57: pi_all_organization_flag IN NUMBER
58: )

Line 90: l_from_range cr_rsrc_mst.resources%TYPE ;

86:
87: l_sql_rsrc VARCHAR2(2000) ;
88: l_sql_orgn VARCHAR2(2000) ;
89: l_sql_periods VARCHAR2(2000) ;
90: l_from_range cr_rsrc_mst.resources%TYPE ;
91: l_to_range cr_rsrc_mst.resources%TYPE ;
92: l_organization_id_to cm_rsrc_dtl.organization_id%TYPE;
93: pi_period_id_to cm_rsrc_dtl.period_id%TYPE ;
94: l_period_id_from cm_rsrc_dtl.period_id%TYPE ;

Line 91: l_to_range cr_rsrc_mst.resources%TYPE ;

87: l_sql_rsrc VARCHAR2(2000) ;
88: l_sql_orgn VARCHAR2(2000) ;
89: l_sql_periods VARCHAR2(2000) ;
90: l_from_range cr_rsrc_mst.resources%TYPE ;
91: l_to_range cr_rsrc_mst.resources%TYPE ;
92: l_organization_id_to cm_rsrc_dtl.organization_id%TYPE;
93: pi_period_id_to cm_rsrc_dtl.period_id%TYPE ;
94: l_period_id_from cm_rsrc_dtl.period_id%TYPE ;
95: l_period_id_to cm_rsrc_dtl.period_id%TYPE ;

Line 177: 'cr_rsrc_mst m ' ||

173: 'd.nominal_cost, ' ||
174: 'd.usage_uom ' ||
175: ' FROM ' ||
176: 'cm_rsrc_dtl d, ' ||
177: 'cr_rsrc_mst m ' ||
178: ' WHERE ' ||
179: 'd.legal_entity_id = :b_legal_entity_id AND '||
180: 'nvl(d.organization_id,0) = nvl(:b_organization_id,0) AND ' ||
181: 'd.period_id = :b_period_id AND ' ||

Line 459: pi_resource_class IN cr_rsrc_mst.resource_class%TYPE

455: (
456: pi_legal_entity_id IN cm_rsrc_dtl.legal_entity_id%TYPE,
457: pi_organization_id IN cm_rsrc_dtl.organization_id%TYPE,
458: pi_period_id IN cm_rsrc_dtl.period_id%TYPE,
459: pi_resource_class IN cr_rsrc_mst.resource_class%TYPE
460: )
461: RETURN NUMBER
462: IS
463: CURSOR cur_num_cost_rows

Line 468: p_resource_class IN cr_rsrc_mst.resource_class%TYPE

464: (
465: p_legal_entity_id IN cm_rsrc_dtl.legal_entity_id%TYPE,
466: p_organization_id IN cm_rsrc_dtl.organization_id%TYPE,
467: p_period_id IN cm_rsrc_dtl.period_id%TYPE,
468: p_resource_class IN cr_rsrc_mst.resource_class%TYPE
469: )
470: IS
471: SELECT COUNT(1)
472: FROM cm_rsrc_dtl d,

Line 473: cr_rsrc_mst m

469: )
470: IS
471: SELECT COUNT(1)
472: FROM cm_rsrc_dtl d,
473: cr_rsrc_mst m
474: WHERE d.legal_entity_id = p_legal_entity_id
475: AND nvl(d.organization_id,0) = nvl(p_organization_id,0)
476: AND d.period_id = p_period_id
477: AND d.delete_mark = 0

Line 519: pi_resource_class IN cr_rsrc_mst.resource_class%TYPE

515: FUNCTION do_costs_exist
516: (
517: pi_legal_entity_id IN cm_rsrc_dtl.legal_entity_id%TYPE,
518: pi_period_id IN cm_rsrc_dtl.period_id%TYPE,
519: pi_resource_class IN cr_rsrc_mst.resource_class%TYPE
520: )
521: RETURN NUMBER
522: IS
523: CURSOR cur_num_cost_rows

Line 527: p_resource_class IN cr_rsrc_mst.resource_class%TYPE

523: CURSOR cur_num_cost_rows
524: (
525: p_legal_entity_id IN cm_rsrc_dtl.legal_entity_id%TYPE,
526: p_period_id IN cm_rsrc_dtl.period_id%TYPE,
527: p_resource_class IN cr_rsrc_mst.resource_class%TYPE
528: )
529: IS
530: SELECT COUNT(1)
531: FROM cm_rsrc_dtl d,

Line 532: cr_rsrc_mst m

528: )
529: IS
530: SELECT COUNT(1)
531: FROM cm_rsrc_dtl d,
532: cr_rsrc_mst m
533: WHERE d.legal_entity_id = p_legal_entity_id
534: AND d.organization_id IN (SELECT a.organization_id FROM hr_organization_information a, mtl_parameters b
535: where a.organization_id = b.organization_id
536: and b.process_enabled_flag = 'Y' and