APPS.GMF_COPY_RSRC_COST dependencies on CR_RSRC_MST

Line 55: pi_resource_class IN cr_rsrc_mst.resource_class%TYPE,

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

Line 91: l_from_range cr_rsrc_mst.resources%TYPE ;

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

Line 92: l_to_range cr_rsrc_mst.resources%TYPE ;

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

Line 178: 'cr_rsrc_mst m ' ||

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

Line 461: pi_resource_class IN cr_rsrc_mst.resource_class%TYPE

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

Line 470: p_resource_class IN cr_rsrc_mst.resource_class%TYPE

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

Line 475: cr_rsrc_mst m

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

Line 521: pi_resource_class IN cr_rsrc_mst.resource_class%TYPE

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

Line 529: p_resource_class IN cr_rsrc_mst.resource_class%TYPE

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

Line 534: cr_rsrc_mst m

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