eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMF_COPY_RSRC_COST dependencies on CM_RSRC_DTL

Line 44: pi_legal_entity_id_from IN cm_rsrc_dtl.legal_entity_id%TYPE,

40: PROCEDURE copy_rsrc_cost
41: (
42: po_errbuf OUT NOCOPY VARCHAR2,
43: po_retcode OUT NOCOPY VARCHAR2,
44: pi_legal_entity_id_from IN cm_rsrc_dtl.legal_entity_id%TYPE,
45: pi_organization_id_from IN cm_rsrc_dtl.organization_id%TYPE,
46: pi_calendar_code_from IN cm_rsrc_dtl.calendar_code%TYPE,
47: pi_period_code_from IN cm_rsrc_dtl.period_code%TYPE,
48: pi_cost_type_id_from IN cm_rsrc_dtl.cost_type_id%TYPE,

Line 45: pi_organization_id_from IN cm_rsrc_dtl.organization_id%TYPE,

41: (
42: po_errbuf OUT NOCOPY VARCHAR2,
43: po_retcode OUT NOCOPY VARCHAR2,
44: pi_legal_entity_id_from IN cm_rsrc_dtl.legal_entity_id%TYPE,
45: pi_organization_id_from IN cm_rsrc_dtl.organization_id%TYPE,
46: pi_calendar_code_from IN cm_rsrc_dtl.calendar_code%TYPE,
47: pi_period_code_from IN cm_rsrc_dtl.period_code%TYPE,
48: pi_cost_type_id_from IN cm_rsrc_dtl.cost_type_id%TYPE,
49: pi_legal_entity_id_to IN cm_rsrc_dtl.legal_entity_id%TYPE,

Line 46: pi_calendar_code_from IN cm_rsrc_dtl.calendar_code%TYPE,

42: po_errbuf OUT NOCOPY VARCHAR2,
43: po_retcode OUT NOCOPY VARCHAR2,
44: pi_legal_entity_id_from IN cm_rsrc_dtl.legal_entity_id%TYPE,
45: pi_organization_id_from IN cm_rsrc_dtl.organization_id%TYPE,
46: pi_calendar_code_from IN cm_rsrc_dtl.calendar_code%TYPE,
47: pi_period_code_from IN cm_rsrc_dtl.period_code%TYPE,
48: pi_cost_type_id_from IN cm_rsrc_dtl.cost_type_id%TYPE,
49: pi_legal_entity_id_to IN cm_rsrc_dtl.legal_entity_id%TYPE,
50: pi_organization_id_to IN cm_rsrc_dtl.organization_id%TYPE,

Line 47: pi_period_code_from IN cm_rsrc_dtl.period_code%TYPE,

43: po_retcode OUT NOCOPY VARCHAR2,
44: pi_legal_entity_id_from IN cm_rsrc_dtl.legal_entity_id%TYPE,
45: pi_organization_id_from IN cm_rsrc_dtl.organization_id%TYPE,
46: pi_calendar_code_from IN cm_rsrc_dtl.calendar_code%TYPE,
47: pi_period_code_from IN cm_rsrc_dtl.period_code%TYPE,
48: pi_cost_type_id_from IN cm_rsrc_dtl.cost_type_id%TYPE,
49: pi_legal_entity_id_to IN cm_rsrc_dtl.legal_entity_id%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,

Line 48: pi_cost_type_id_from IN cm_rsrc_dtl.cost_type_id%TYPE,

44: pi_legal_entity_id_from IN cm_rsrc_dtl.legal_entity_id%TYPE,
45: pi_organization_id_from IN cm_rsrc_dtl.organization_id%TYPE,
46: pi_calendar_code_from IN cm_rsrc_dtl.calendar_code%TYPE,
47: pi_period_code_from IN cm_rsrc_dtl.period_code%TYPE,
48: pi_cost_type_id_from IN cm_rsrc_dtl.cost_type_id%TYPE,
49: pi_legal_entity_id_to IN cm_rsrc_dtl.legal_entity_id%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,

Line 49: pi_legal_entity_id_to IN cm_rsrc_dtl.legal_entity_id%TYPE,

45: pi_organization_id_from IN cm_rsrc_dtl.organization_id%TYPE,
46: pi_calendar_code_from IN cm_rsrc_dtl.calendar_code%TYPE,
47: pi_period_code_from IN cm_rsrc_dtl.period_code%TYPE,
48: pi_cost_type_id_from IN cm_rsrc_dtl.cost_type_id%TYPE,
49: pi_legal_entity_id_to IN cm_rsrc_dtl.legal_entity_id%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,

Line 50: pi_organization_id_to IN cm_rsrc_dtl.organization_id%TYPE,

46: pi_calendar_code_from IN cm_rsrc_dtl.calendar_code%TYPE,
47: pi_period_code_from IN cm_rsrc_dtl.period_code%TYPE,
48: pi_cost_type_id_from IN cm_rsrc_dtl.cost_type_id%TYPE,
49: pi_legal_entity_id_to IN cm_rsrc_dtl.legal_entity_id%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,

Line 51: pi_calendar_code_to IN cm_rsrc_dtl.calendar_code%TYPE,

47: pi_period_code_from IN cm_rsrc_dtl.period_code%TYPE,
48: pi_cost_type_id_from IN cm_rsrc_dtl.cost_type_id%TYPE,
49: pi_legal_entity_id_to IN cm_rsrc_dtl.legal_entity_id%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,

Line 52: pi_period_code_to IN cm_rsrc_dtl.period_code%TYPE,

48: pi_cost_type_id_from IN cm_rsrc_dtl.cost_type_id%TYPE,
49: pi_legal_entity_id_to IN cm_rsrc_dtl.legal_entity_id%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,

Line 53: pi_cost_type_id_to IN cm_rsrc_dtl.cost_type_id%TYPE,

49: pi_legal_entity_id_to IN cm_rsrc_dtl.legal_entity_id%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

Line 66: resources cm_rsrc_dtl.resources%TYPE,

62: * PL/SQL Typ Definitions *
63: *************************/
64:
65: TYPE rectyp_rsrc_dtl IS RECORD (
66: resources cm_rsrc_dtl.resources%TYPE,
67: nominal_cost cm_rsrc_dtl.nominal_cost%TYPE,
68: usage_uom cm_rsrc_dtl.usage_uom%TYPE
69: );
70:

Line 67: nominal_cost cm_rsrc_dtl.nominal_cost%TYPE,

63: *************************/
64:
65: TYPE rectyp_rsrc_dtl IS RECORD (
66: resources cm_rsrc_dtl.resources%TYPE,
67: nominal_cost cm_rsrc_dtl.nominal_cost%TYPE,
68: usage_uom cm_rsrc_dtl.usage_uom%TYPE
69: );
70:
71: TYPE curtyp_rsrc IS REF CURSOR ;

Line 68: usage_uom cm_rsrc_dtl.usage_uom%TYPE

64:
65: TYPE rectyp_rsrc_dtl IS RECORD (
66: resources cm_rsrc_dtl.resources%TYPE,
67: nominal_cost cm_rsrc_dtl.nominal_cost%TYPE,
68: usage_uom cm_rsrc_dtl.usage_uom%TYPE
69: );
70:
71: TYPE curtyp_rsrc IS REF CURSOR ;
72:

Line 92: l_organization_id_to cm_rsrc_dtl.organization_id%TYPE;

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 ;
96: l_legal_entity_id_to cm_rsrc_dtl.legal_entity_id%TYPE;

Line 93: pi_period_id_to cm_rsrc_dtl.period_id%TYPE ;

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 ;
96: l_legal_entity_id_to cm_rsrc_dtl.legal_entity_id%TYPE;
97: l_cost_Type_id_to cm_rsrc_dtl.cost_Type_id%TYPE;

Line 94: l_period_id_from cm_rsrc_dtl.period_id%TYPE ;

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 ;
96: l_legal_entity_id_to cm_rsrc_dtl.legal_entity_id%TYPE;
97: l_cost_Type_id_to cm_rsrc_dtl.cost_Type_id%TYPE;
98: l_user_id NUMBER := FND_GLOBAL.USER_ID;

Line 95: l_period_id_to cm_rsrc_dtl.period_id%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 ;
96: l_legal_entity_id_to cm_rsrc_dtl.legal_entity_id%TYPE;
97: l_cost_Type_id_to cm_rsrc_dtl.cost_Type_id%TYPE;
98: l_user_id NUMBER := FND_GLOBAL.USER_ID;
99: l_num_src_rows NUMBER; -- num cost rows in source period

Line 96: l_legal_entity_id_to cm_rsrc_dtl.legal_entity_id%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 ;
96: l_legal_entity_id_to cm_rsrc_dtl.legal_entity_id%TYPE;
97: l_cost_Type_id_to cm_rsrc_dtl.cost_Type_id%TYPE;
98: l_user_id NUMBER := FND_GLOBAL.USER_ID;
99: l_num_src_rows NUMBER; -- num cost rows in source period
100: l_ins_rows NUMBER; -- num rows inserted

Line 97: l_cost_Type_id_to cm_rsrc_dtl.cost_Type_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 ;
96: l_legal_entity_id_to cm_rsrc_dtl.legal_entity_id%TYPE;
97: l_cost_Type_id_to cm_rsrc_dtl.cost_Type_id%TYPE;
98: l_user_id NUMBER := FND_GLOBAL.USER_ID;
99: l_num_src_rows NUMBER; -- num cost rows in source period
100: l_ins_rows NUMBER; -- num rows inserted
101: l_upd_rows NUMBER; -- num rows updated

Line 176: 'cm_rsrc_dtl d, ' ||

172: 'd.resources, ' ||
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 ' ||

Line 314: UPDATE cm_rsrc_dtl

310:
311: gmf_util.trace( 'Values : ' || rec_rsrc_dtl.resources || ' - ' || rec_rsrc_dtl.usage_uom || ' - ' || to_char(rec_rsrc_dtl.nominal_cost), 1 );
312: gmf_util.msg_log('GMF_CPRC_ORGPRD', nvl(TO_CHAR(l_organization_id_to), ' '), nvl(TO_CHAR(l_period_id_to),' '));
313:
314: UPDATE cm_rsrc_dtl
315: SET usage_uom = rec_rsrc_dtl.usage_uom,
316: nominal_cost = rec_rsrc_dtl.nominal_cost,
317: rollover_ind = 0, ----unset the rollover_ind in target period
318: last_update_date = SYSDATE,

Line 334: INSERT INTO cm_rsrc_dtl

330: gmf_util.trace( 'Updated ' || TO_CHAR(SQL%ROWCOUNT) || ' rows', 1 );
331:
332: ELSE
333:
334: INSERT INTO cm_rsrc_dtl
335: (
336: legal_entity_id,
337: organization_id,
338: resources,

Line 456: pi_legal_entity_id IN cm_rsrc_dtl.legal_entity_id%TYPE,

452: **************************************************************************************/
453:
454: FUNCTION do_costs_exist
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: )

Line 457: pi_organization_id IN cm_rsrc_dtl.organization_id%TYPE,

453:
454: FUNCTION do_costs_exist
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

Line 458: pi_period_id IN cm_rsrc_dtl.period_id%TYPE,

454: FUNCTION do_costs_exist
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

Line 465: p_legal_entity_id IN cm_rsrc_dtl.legal_entity_id%TYPE,

461: RETURN NUMBER
462: IS
463: CURSOR cur_num_cost_rows
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: )

Line 466: p_organization_id IN cm_rsrc_dtl.organization_id%TYPE,

462: IS
463: CURSOR cur_num_cost_rows
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

Line 467: p_period_id IN cm_rsrc_dtl.period_id%TYPE,

463: CURSOR cur_num_cost_rows
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)

Line 472: FROM cm_rsrc_dtl d,

468: p_resource_class IN cr_rsrc_mst.resource_class%TYPE
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

Line 517: pi_legal_entity_id IN cm_rsrc_dtl.legal_entity_id%TYPE,

513: **************************************************************************************/
514:
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

Line 518: pi_period_id IN cm_rsrc_dtl.period_id%TYPE,

514:
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

Line 525: p_legal_entity_id IN cm_rsrc_dtl.legal_entity_id%TYPE,

521: RETURN NUMBER
522: IS
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

Line 526: p_period_id IN cm_rsrc_dtl.period_id%TYPE,

522: IS
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)

Line 531: FROM cm_rsrc_dtl d,

527: p_resource_class IN cr_rsrc_mst.resource_class%TYPE
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