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.

[Home] [Help]

APPS.GMF_COPY_RSRC_COST dependencies on CM_RSRC_DTL

Line 45: pi_legal_entity_id_from IN cm_rsrc_dtl.legal_entity_id%TYPE,

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

Line 46: pi_organization_id_from IN cm_rsrc_dtl.organization_id%TYPE,

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

Line 47: pi_calendar_code_from IN cm_rsrc_dtl.calendar_code%TYPE,

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

Line 48: pi_period_code_from IN cm_rsrc_dtl.period_code%TYPE,

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

Line 49: pi_cost_type_id_from IN cm_rsrc_dtl.cost_type_id%TYPE,

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

Line 50: pi_legal_entity_id_to IN cm_rsrc_dtl.legal_entity_id%TYPE,

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

Line 51: pi_organization_id_to IN cm_rsrc_dtl.organization_id%TYPE,

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

Line 52: pi_calendar_code_to IN cm_rsrc_dtl.calendar_code%TYPE,

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

Line 53: pi_period_code_to IN cm_rsrc_dtl.period_code%TYPE,

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

Line 54: pi_cost_type_id_to IN cm_rsrc_dtl.cost_type_id%TYPE,

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

Line 67: resources cm_rsrc_dtl.resources%TYPE,

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

Line 68: nominal_cost cm_rsrc_dtl.nominal_cost%TYPE,

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

Line 69: usage_uom cm_rsrc_dtl.usage_uom%TYPE

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

Line 93: l_organization_id_to cm_rsrc_dtl.organization_id%TYPE;

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

Line 94: pi_period_id_to cm_rsrc_dtl.period_id%TYPE ;

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

Line 95: l_period_id_from cm_rsrc_dtl.period_id%TYPE ;

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

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

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

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

Line 177: 'cm_rsrc_dtl d, ' ||

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

Line 316: UPDATE cm_rsrc_dtl

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

Line 336: INSERT INTO cm_rsrc_dtl

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

Line 458: pi_legal_entity_id IN cm_rsrc_dtl.legal_entity_id%TYPE,

454: **************************************************************************************/
455:
456: FUNCTION do_costs_exist
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: )

Line 459: pi_organization_id IN cm_rsrc_dtl.organization_id%TYPE,

455:
456: FUNCTION do_costs_exist
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

Line 460: pi_period_id IN cm_rsrc_dtl.period_id%TYPE,

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

Line 467: p_legal_entity_id IN cm_rsrc_dtl.legal_entity_id%TYPE,

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

Line 468: p_organization_id IN cm_rsrc_dtl.organization_id%TYPE,

464: IS
465: CURSOR cur_num_cost_rows
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

Line 469: p_period_id IN cm_rsrc_dtl.period_id%TYPE,

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

Line 474: FROM cm_rsrc_dtl d,

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

Line 519: pi_legal_entity_id IN cm_rsrc_dtl.legal_entity_id%TYPE,

515: **************************************************************************************/
516:
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

Line 520: pi_period_id IN cm_rsrc_dtl.period_id%TYPE,

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

Line 527: p_legal_entity_id IN cm_rsrc_dtl.legal_entity_id%TYPE,

523: RETURN NUMBER
524: IS
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

Line 528: p_period_id IN cm_rsrc_dtl.period_id%TYPE,

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

Line 533: FROM cm_rsrc_dtl d,

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