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_PERCENTAGE_BURDEN dependencies on GMF_BURDEN_CODES

Line 46: pi_from_range IN gmf_burden_codes.burden_code%TYPE,

42: pi_legal_entity_id_to IN gmf_burden_percentages.legal_entity_id%TYPE,
43: pi_calendar_code_to IN cm_cldr_hdr.calendar_code%TYPE,
44: pi_period_code_to IN cm_cldr_dtl.period_code%TYPE,
45: pi_cost_type_id_to IN cm_mthd_mst.cost_type_id%TYPE,
46: pi_from_range IN gmf_burden_codes.burden_code%TYPE,
47: pi_to_range IN gmf_burden_codes.burden_code%TYPE,
48: pi_rem_repl IN NUMBER,
49: pi_all_periods_from IN cm_cldr_dtl.period_code%TYPE,
50: pi_all_periods_to IN cm_cldr_dtl.period_code%TYPE

Line 47: pi_to_range IN gmf_burden_codes.burden_code%TYPE,

43: pi_calendar_code_to IN cm_cldr_hdr.calendar_code%TYPE,
44: pi_period_code_to IN cm_cldr_dtl.period_code%TYPE,
45: pi_cost_type_id_to IN cm_mthd_mst.cost_type_id%TYPE,
46: pi_from_range IN gmf_burden_codes.burden_code%TYPE,
47: pi_to_range IN gmf_burden_codes.burden_code%TYPE,
48: pi_rem_repl IN NUMBER,
49: pi_all_periods_from IN cm_cldr_dtl.period_code%TYPE,
50: pi_all_periods_to IN cm_cldr_dtl.period_code%TYPE
51: );

Line 58: pi_from_range IN gmf_burden_codes.burden_code%TYPE,

54: (
55: pi_legal_entity_id IN gmf_burden_percentages.legal_entity_id%TYPE,
56: pi_period_id IN gmf_burden_percentages.period_id%TYPE,
57: pi_cost_type_id IN cm_mthd_mst.cost_type_id%TYPE,
58: pi_from_range IN gmf_burden_codes.burden_code%TYPE,
59: pi_to_range IN gmf_burden_codes.burden_code%TYPE
60: );
61:
62: FUNCTION do_pct_exist

Line 59: pi_to_range IN gmf_burden_codes.burden_code%TYPE

55: pi_legal_entity_id IN gmf_burden_percentages.legal_entity_id%TYPE,
56: pi_period_id IN gmf_burden_percentages.period_id%TYPE,
57: pi_cost_type_id IN cm_mthd_mst.cost_type_id%TYPE,
58: pi_from_range IN gmf_burden_codes.burden_code%TYPE,
59: pi_to_range IN gmf_burden_codes.burden_code%TYPE
60: );
61:
62: FUNCTION do_pct_exist
63: (

Line 67: pi_burden_code_from IN gmf_burden_codes.burden_code%TYPE,

63: (
64: pi_legal_entity_id IN gmf_burden_percentages.legal_entity_id%TYPE,
65: pi_period_id IN gmf_burden_percentages.period_id%TYPE,
66: pi_cost_type_id IN cm_mthd_mst.cost_type_id%TYPE,
67: pi_burden_code_from IN gmf_burden_codes.burden_code%TYPE,
68: pi_burden_code_to IN gmf_burden_codes.burden_code%TYPE
69: )
70: RETURN NUMBER ;
71:

Line 68: pi_burden_code_to IN gmf_burden_codes.burden_code%TYPE

64: pi_legal_entity_id IN gmf_burden_percentages.legal_entity_id%TYPE,
65: pi_period_id IN gmf_burden_percentages.period_id%TYPE,
66: pi_cost_type_id IN cm_mthd_mst.cost_type_id%TYPE,
67: pi_burden_code_from IN gmf_burden_codes.burden_code%TYPE,
68: pi_burden_code_to IN gmf_burden_codes.burden_code%TYPE
69: )
70: RETURN NUMBER ;
71:
72: /**************

Line 114: pi_burden_code_from IN gmf_burden_codes.burden_code%TYPE,

110: pi_legal_entity_id_to IN gmf_burden_percentages.legal_entity_id%TYPE,
111: pi_calendar_code_to IN cm_cldr_hdr.calendar_code%TYPE,
112: pi_period_code_to IN cm_cldr_dtl.period_code%TYPE,
113: pi_cost_type_id_to IN cm_mthd_mst.cost_type_id%TYPE,
114: pi_burden_code_from IN gmf_burden_codes.burden_code%TYPE,
115: pi_burden_code_to IN gmf_burden_codes.burden_code%TYPE,
116: pi_rem_repl IN VARCHAR2,
117: pi_all_periods_from IN cm_cldr_dtl.period_code%TYPE,
118: pi_all_periods_to IN cm_cldr_dtl.period_code%TYPE

Line 115: pi_burden_code_to IN gmf_burden_codes.burden_code%TYPE,

111: pi_calendar_code_to IN cm_cldr_hdr.calendar_code%TYPE,
112: pi_period_code_to IN cm_cldr_dtl.period_code%TYPE,
113: pi_cost_type_id_to IN cm_mthd_mst.cost_type_id%TYPE,
114: pi_burden_code_from IN gmf_burden_codes.burden_code%TYPE,
115: pi_burden_code_to IN gmf_burden_codes.burden_code%TYPE,
116: pi_rem_repl IN VARCHAR2,
117: pi_all_periods_from IN cm_cldr_dtl.period_code%TYPE,
118: pi_all_periods_to IN cm_cldr_dtl.period_code%TYPE
119: )

Line 126: l_from_range gmf_burden_codes.burden_code%TYPE;

122: /******************
123: * Local Variables *
124: ******************/
125:
126: l_from_range gmf_burden_codes.burden_code%TYPE;
127: l_to_range gmf_burden_codes.burden_code%TYPE;
128: l_rem_repl NUMBER;
129: l_num_src_rows NUMBER; -- num rows in source period
130: l_period_id_from gmf_burden_percentages.period_id%TYPE;

Line 127: l_to_range gmf_burden_codes.burden_code%TYPE;

123: * Local Variables *
124: ******************/
125:
126: l_from_range gmf_burden_codes.burden_code%TYPE;
127: l_to_range gmf_burden_codes.burden_code%TYPE;
128: l_rem_repl NUMBER;
129: l_num_src_rows NUMBER; -- num rows in source period
130: l_period_id_from gmf_burden_percentages.period_id%TYPE;
131:

Line 343: pi_from_range IN gmf_burden_codes.burden_code%TYPE,

339: pi_legal_entity_id_to IN gmf_burden_percentages.legal_entity_id%TYPE,
340: pi_calendar_code_to IN cm_cldr_hdr.calendar_code%TYPE,
341: pi_period_code_to IN cm_cldr_dtl.period_code%TYPE,
342: pi_cost_type_id_to IN cm_mthd_mst.cost_type_id%TYPE,
343: pi_from_range IN gmf_burden_codes.burden_code%TYPE,
344: pi_to_range IN gmf_burden_codes.burden_code%TYPE,
345: pi_rem_repl IN NUMBER,
346: pi_all_periods_from IN cm_cldr_dtl.period_code%TYPE,
347: pi_all_periods_to IN cm_cldr_dtl.period_code%TYPE

Line 344: pi_to_range IN gmf_burden_codes.burden_code%TYPE,

340: pi_calendar_code_to IN cm_cldr_hdr.calendar_code%TYPE,
341: pi_period_code_to IN cm_cldr_dtl.period_code%TYPE,
342: pi_cost_type_id_to IN cm_mthd_mst.cost_type_id%TYPE,
343: pi_from_range IN gmf_burden_codes.burden_code%TYPE,
344: pi_to_range IN gmf_burden_codes.burden_code%TYPE,
345: pi_rem_repl IN NUMBER,
346: pi_all_periods_from IN cm_cldr_dtl.period_code%TYPE,
347: pi_all_periods_to IN cm_cldr_dtl.period_code%TYPE
348: )

Line 360: burden_id gmf_burden_codes.burden_id%TYPE,

356: (
357: legal_entity_id gmf_burden_percentages.legal_entity_id%TYPE,
358: period_id gmf_burden_percentages.period_id%TYPE,
359: cost_type_id cm_mthd_mst.cost_type_id%TYPE,
360: burden_id gmf_burden_codes.burden_id%TYPE,
361: burden_code gmf_burden_codes.burden_code%TYPE,
362: organization_id gmf_burden_percentages.organization_id%TYPE,
363: master_organization_id gmf_burden_percentages.master_organization_id%TYPE,
364: inventory_item_id gmf_burden_percentages.inventory_item_id%TYPE,

Line 361: burden_code gmf_burden_codes.burden_code%TYPE,

357: legal_entity_id gmf_burden_percentages.legal_entity_id%TYPE,
358: period_id gmf_burden_percentages.period_id%TYPE,
359: cost_type_id cm_mthd_mst.cost_type_id%TYPE,
360: burden_id gmf_burden_codes.burden_id%TYPE,
361: burden_code gmf_burden_codes.burden_code%TYPE,
362: organization_id gmf_burden_percentages.organization_id%TYPE,
363: master_organization_id gmf_burden_percentages.master_organization_id%TYPE,
364: inventory_item_id gmf_burden_percentages.inventory_item_id%TYPE,
365: gl_category_id gmf_burden_percentages.gl_category_id%TYPE,

Line 419: ' gmf_burden_codes bur ' ||

415: ' pct.sspl_category_id, ' ||
416: ' pct.percentage ' ||
417: ' FROM ' ||
418: ' gmf_burden_percentages pct, ' ||
419: ' gmf_burden_codes bur ' ||
420: ' WHERE ' ||
421: ' pct.legal_entity_id = :b_legal_entity_id AND ' ||
422: ' pct.period_id = :b_period_id AND ' ||
423: ' pct.cost_type_id = :b_cost_type_id AND ' ||

Line 691: pi_from_range IN gmf_burden_codes.burden_code%TYPE,

687: (
688: pi_legal_entity_id IN gmf_burden_percentages.legal_entity_id%TYPE,
689: pi_period_id IN gmf_burden_percentages.period_id%TYPE,
690: pi_cost_type_id IN cm_mthd_mst.cost_type_id%TYPE,
691: pi_from_range IN gmf_burden_codes.burden_code%TYPE,
692: pi_to_range IN gmf_burden_codes.burden_code%TYPE
693: )
694: IS
695:

Line 692: pi_to_range IN gmf_burden_codes.burden_code%TYPE

688: pi_legal_entity_id IN gmf_burden_percentages.legal_entity_id%TYPE,
689: pi_period_id IN gmf_burden_percentages.period_id%TYPE,
690: pi_cost_type_id IN cm_mthd_mst.cost_type_id%TYPE,
691: pi_from_range IN gmf_burden_codes.burden_code%TYPE,
692: pi_to_range IN gmf_burden_codes.burden_code%TYPE
693: )
694: IS
695:
696: /******************

Line 718: ' gmf_burden_codes bur ' ||

714:
715: l_sub_qry := ' SELECT ' ||
716: ' bur.burden_id ' ||
717: ' FROM ' ||
718: ' gmf_burden_codes bur ' ||
719: ' WHERE ' ||
720: ' bur.delete_mark = 0 AND ' ||
721: ' bur.burden_code >= nvl(:b_burden_code_from,bur.burden_code) AND ' ||
722: ' bur.burden_code <= nvl(:b_burden_code_to,bur.burden_code) ' ;

Line 792: pi_burden_code_from IN gmf_burden_codes.burden_code%TYPE,

788: (
789: pi_legal_entity_id IN gmf_burden_percentages.legal_entity_id%TYPE,
790: pi_period_id IN gmf_burden_percentages.period_id%TYPE,
791: pi_cost_type_id IN cm_mthd_mst.cost_type_id%TYPE,
792: pi_burden_code_from IN gmf_burden_codes.burden_code%TYPE,
793: pi_burden_code_to IN gmf_burden_codes.burden_code%TYPE
794: )
795: RETURN NUMBER
796: IS

Line 793: pi_burden_code_to IN gmf_burden_codes.burden_code%TYPE

789: pi_legal_entity_id IN gmf_burden_percentages.legal_entity_id%TYPE,
790: pi_period_id IN gmf_burden_percentages.period_id%TYPE,
791: pi_cost_type_id IN cm_mthd_mst.cost_type_id%TYPE,
792: pi_burden_code_from IN gmf_burden_codes.burden_code%TYPE,
793: pi_burden_code_to IN gmf_burden_codes.burden_code%TYPE
794: )
795: RETURN NUMBER
796: IS
797:

Line 806: p_burden_code_from IN gmf_burden_codes.burden_code%TYPE,

802: CURSOR cur_num_pct_rows
803: (
804: p_legal_entity_id IN gmf_burden_percentages.legal_entity_id%TYPE,
805: p_period_id IN gmf_burden_percentages.period_id%TYPE,
806: p_burden_code_from IN gmf_burden_codes.burden_code%TYPE,
807: p_burden_code_to IN gmf_burden_codes.burden_code%TYPE
808: )
809: IS
810: SELECT COUNT(1)

Line 807: p_burden_code_to IN gmf_burden_codes.burden_code%TYPE

803: (
804: p_legal_entity_id IN gmf_burden_percentages.legal_entity_id%TYPE,
805: p_period_id IN gmf_burden_percentages.period_id%TYPE,
806: p_burden_code_from IN gmf_burden_codes.burden_code%TYPE,
807: p_burden_code_to IN gmf_burden_codes.burden_code%TYPE
808: )
809: IS
810: SELECT COUNT(1)
811: FROM gmf_burden_percentages pct,

Line 812: gmf_burden_codes bur

808: )
809: IS
810: SELECT COUNT(1)
811: FROM gmf_burden_percentages pct,
812: gmf_burden_codes bur
813: WHERE pct.legal_entity_id = p_legal_entity_id
814: AND pct.period_id = p_period_id
815: AND pct.delete_mark = 0
816: AND pct.burden_id = bur.burden_id