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_ITEM_COST dependencies on GMF_PERIOD_STATUSES

Line 93: PROCEDURE verify_frozen_periods (p_period_id IN gmf_period_statuses.period_id%TYPE,

89: )
90: RETURN NUMBER;
91:
92: -- added this procedure as part of bug 5567102
93: PROCEDURE verify_frozen_periods (p_period_id IN gmf_period_statuses.period_id%TYPE,
94: p_period_code OUT NOCOPY gmf_period_statuses.period_code%TYPE,
95: p_period_status OUT NOCOPY gmf_period_statuses.period_status%TYPE );
96:
97: -- Added to check record exists in a frozen period, bug 5672543

Line 94: p_period_code OUT NOCOPY gmf_period_statuses.period_code%TYPE,

90: RETURN NUMBER;
91:
92: -- added this procedure as part of bug 5567102
93: PROCEDURE verify_frozen_periods (p_period_id IN gmf_period_statuses.period_id%TYPE,
94: p_period_code OUT NOCOPY gmf_period_statuses.period_code%TYPE,
95: p_period_status OUT NOCOPY gmf_period_statuses.period_status%TYPE );
96:
97: -- Added to check record exists in a frozen period, bug 5672543
98: FUNCTION check_rec_infrozen_period(p_organization_id cm_cmpt_dtl.organization_id%TYPE,

Line 95: p_period_status OUT NOCOPY gmf_period_statuses.period_status%TYPE );

91:
92: -- added this procedure as part of bug 5567102
93: PROCEDURE verify_frozen_periods (p_period_id IN gmf_period_statuses.period_id%TYPE,
94: p_period_code OUT NOCOPY gmf_period_statuses.period_code%TYPE,
95: p_period_status OUT NOCOPY gmf_period_statuses.period_status%TYPE );
96:
97: -- Added to check record exists in a frozen period, bug 5672543
98: FUNCTION check_rec_infrozen_period(p_organization_id cm_cmpt_dtl.organization_id%TYPE,
99: p_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,

Line 527: l_period_code gmf_period_statuses.period_code%TYPE;

523: l_cost_rows_upd NUMBER;
524: l_cost_rows_ins NUMBER;
525: l_cost_rows_skip NUMBER;
526: -- bug 5567102
527: l_period_code gmf_period_statuses.period_code%TYPE;
528: l_period_status gmf_period_statuses.period_status%TYPE;
529:
530: l_copy_to_upper_lvl NUMBER;
531:

Line 528: l_period_status gmf_period_statuses.period_status%TYPE;

524: l_cost_rows_ins NUMBER;
525: l_cost_rows_skip NUMBER;
526: -- bug 5567102
527: l_period_code gmf_period_statuses.period_code%TYPE;
528: l_period_status gmf_period_statuses.period_status%TYPE;
529:
530: l_copy_to_upper_lvl NUMBER;
531:
532: pi_period_id_to NUMBER;

Line 551: FROM gmf_period_statuses gps, hr_organization_information org

547: if(pi_period_code_to is not null) then
548: if(pi_organization_id_to is not null) then
549: SELECT gps.period_id
550: INTO pi_period_id_to
551: FROM gmf_period_statuses gps, hr_organization_information org
552: WHERE gps.PERIOD_CODE = pi_period_code_to
553: AND gps.CALENDAR_CODE = pi_calendar_code_to
554: AND gps.legal_entity_id = org.org_information2
555: AND org.organization_id = pi_organization_id_to

Line 561: FROM gmf_period_statuses

557: AND gps.cost_type_id = pi_cost_type_id_to;
558: else
559: SELECT period_id
560: INTO pi_period_id_to
561: FROM gmf_period_statuses
562: WHERE PERIOD_CODE = pi_period_code_to
563: AND CALENDAR_CODE = pi_calendar_code_to
564: AND legal_entity_id = pi_all_org_id
565: AND cost_type_id = pi_cost_type_id_to;

Line 573: FROM gmf_period_statuses gps, hr_organization_information org

569: end if;
570:
571: SELECT gps.period_id
572: INTO pi_period_id_from
573: FROM gmf_period_statuses gps, hr_organization_information org
574: WHERE gps.PERIOD_CODE = pi_period_code_from
575: AND gps.CALENDAR_CODE = pi_calendar_code_from
576: AND gps.legal_entity_id = org.org_information2
577: AND org.organization_id = pi_organization_id_from

Line 754: 'gmf_period_statuses c3, gmf_period_statuses c2, gmf_period_statuses c1, hr_organization_information d ' ||

750: if(pi_organization_id_to is not null) then
751: l_sql_periods := 'SELECT ' ||
752: 'c3.period_id ' ||
753: 'FROM ' ||
754: 'gmf_period_statuses c3, gmf_period_statuses c2, gmf_period_statuses c1, hr_organization_information d ' ||
755: 'WHERE ' ||
756: 'd.organization_id = :pi_organization_id_to AND '||
757: 'd.org_information_context = ''Accounting Information'' AND '||
758: 'c1.calendar_code = :pi_calendar_code_to AND ' ||

Line 776: 'gmf_period_statuses c3, gmf_period_statuses c2, gmf_period_statuses c1 ' ||

772: else
773: l_sql_periods := 'SELECT ' ||
774: 'c3.period_id ' ||
775: 'FROM ' ||
776: 'gmf_period_statuses c3, gmf_period_statuses c2, gmf_period_statuses c1 ' ||
777: 'WHERE ' ||
778: 'c1.calendar_code = :pi_calendar_code_to AND ' ||
779: 'c1.period_code = :pi_all_periods_from AND ' ||
780: 'c2.calendar_code = :pi_calendar_code_to AND ' ||

Line 1611: PROCEDURE verify_frozen_periods (p_period_id IN gmf_period_statuses.period_id%TYPE,

1607: * HISTORY
1608: * 12-Oct-2006 pmarada, created for bug 5567102
1609: *
1610: ******************************************************************************/
1611: PROCEDURE verify_frozen_periods (p_period_id IN gmf_period_statuses.period_id%TYPE,
1612: p_period_code OUT NOCOPY gmf_period_statuses.period_code%TYPE,
1613: p_period_status OUT NOCOPY gmf_period_statuses.period_status%TYPE )
1614: IS
1615:

Line 1612: p_period_code OUT NOCOPY gmf_period_statuses.period_code%TYPE,

1608: * 12-Oct-2006 pmarada, created for bug 5567102
1609: *
1610: ******************************************************************************/
1611: PROCEDURE verify_frozen_periods (p_period_id IN gmf_period_statuses.period_id%TYPE,
1612: p_period_code OUT NOCOPY gmf_period_statuses.period_code%TYPE,
1613: p_period_status OUT NOCOPY gmf_period_statuses.period_status%TYPE )
1614: IS
1615:
1616: CURSOR cur_froz_periods (cp_period_id gmf_period_statuses.period_id%TYPE) IS

Line 1613: p_period_status OUT NOCOPY gmf_period_statuses.period_status%TYPE )

1609: *
1610: ******************************************************************************/
1611: PROCEDURE verify_frozen_periods (p_period_id IN gmf_period_statuses.period_id%TYPE,
1612: p_period_code OUT NOCOPY gmf_period_statuses.period_code%TYPE,
1613: p_period_status OUT NOCOPY gmf_period_statuses.period_status%TYPE )
1614: IS
1615:
1616: CURSOR cur_froz_periods (cp_period_id gmf_period_statuses.period_id%TYPE) IS
1617: SELECT period_code, period_status FROM gmf_period_statuses

Line 1616: CURSOR cur_froz_periods (cp_period_id gmf_period_statuses.period_id%TYPE) IS

1612: p_period_code OUT NOCOPY gmf_period_statuses.period_code%TYPE,
1613: p_period_status OUT NOCOPY gmf_period_statuses.period_status%TYPE )
1614: IS
1615:
1616: CURSOR cur_froz_periods (cp_period_id gmf_period_statuses.period_id%TYPE) IS
1617: SELECT period_code, period_status FROM gmf_period_statuses
1618: WHERE period_id = cp_period_id;
1619:
1620: l_per_code gmf_period_statuses.period_code%TYPE;

Line 1617: SELECT period_code, period_status FROM gmf_period_statuses

1613: p_period_status OUT NOCOPY gmf_period_statuses.period_status%TYPE )
1614: IS
1615:
1616: CURSOR cur_froz_periods (cp_period_id gmf_period_statuses.period_id%TYPE) IS
1617: SELECT period_code, period_status FROM gmf_period_statuses
1618: WHERE period_id = cp_period_id;
1619:
1620: l_per_code gmf_period_statuses.period_code%TYPE;
1621: l_per_status gmf_period_statuses.period_status%TYPE;

Line 1620: l_per_code gmf_period_statuses.period_code%TYPE;

1616: CURSOR cur_froz_periods (cp_period_id gmf_period_statuses.period_id%TYPE) IS
1617: SELECT period_code, period_status FROM gmf_period_statuses
1618: WHERE period_id = cp_period_id;
1619:
1620: l_per_code gmf_period_statuses.period_code%TYPE;
1621: l_per_status gmf_period_statuses.period_status%TYPE;
1622:
1623: BEGIN
1624: gmf_util.trace( 'Entering verify_frozen_periods', 0 );

Line 1621: l_per_status gmf_period_statuses.period_status%TYPE;

1617: SELECT period_code, period_status FROM gmf_period_statuses
1618: WHERE period_id = cp_period_id;
1619:
1620: l_per_code gmf_period_statuses.period_code%TYPE;
1621: l_per_status gmf_period_statuses.period_status%TYPE;
1622:
1623: BEGIN
1624: gmf_util.trace( 'Entering verify_frozen_periods', 0 );
1625: OPEN cur_froz_periods (p_period_id);

Line 1950: l_period_id_to gmf_period_statuses.period_id%TYPE ;

1946: l_sql_org_b VARCHAR2(2000);
1947: l_sql_periods_b VARCHAR2(2000);
1948: l_org_id mtl_organizations.organization_id%TYPE ;
1949:
1950: l_period_id_to gmf_period_statuses.period_id%TYPE ;
1951: l_brdn_rows NUMBER;
1952: l_brdn_rows_upd NUMBER;
1953: l_brdn_rows_ins NUMBER;
1954:

Line 1972: FROM gmf_period_statuses gps, hr_organization_information org

1968: if(pi_period_code_to is not null) then
1969: if(pi_organization_id_to is not null) then
1970: SELECT gps.period_id
1971: INTO pi_period_id_to
1972: FROM gmf_period_statuses gps, hr_organization_information org
1973: WHERE gps.PERIOD_CODE = pi_period_code_to
1974: AND gps.CALENDAR_CODE = pi_calendar_code_to
1975: AND gps.legal_entity_id = org.org_information2
1976: AND org.organization_id = pi_organization_id_to

Line 1982: FROM gmf_period_statuses

1978: AND gps.cost_type_id = pi_cost_type_id_to;
1979: else
1980: SELECT period_id
1981: INTO pi_period_id_to
1982: FROM gmf_period_statuses
1983: WHERE PERIOD_CODE = pi_period_code_to
1984: AND CALENDAR_CODE = pi_calendar_code_to
1985: AND legal_entity_id = pi_all_org_id
1986: AND cost_type_id = pi_cost_type_id_to;

Line 1994: FROM gmf_period_statuses gps, hr_organization_information org

1990: end if;
1991:
1992: SELECT gps.period_id
1993: INTO pi_period_id_from
1994: FROM gmf_period_statuses gps, hr_organization_information org
1995: WHERE gps.PERIOD_CODE = pi_period_code_from
1996: AND gps.CALENDAR_CODE = pi_calendar_code_from
1997: AND gps.legal_entity_id = org.org_information2
1998: and org.organization_id = pi_organization_id_from

Line 2122: 'gmf_period_statuses c3, gmf_period_statuses c2, gmf_period_statuses c1, hr_organization_information d ' ||

2118: if(pi_organization_id_to is not null) then
2119: l_sql_periods_b := 'SELECT ' ||
2120: 'c3.period_id ' ||
2121: 'FROM ' ||
2122: 'gmf_period_statuses c3, gmf_period_statuses c2, gmf_period_statuses c1, hr_organization_information d ' ||
2123: 'WHERE ' ||
2124: 'd.organization_id = :pi_organization_id_to AND '||
2125: 'd.org_information_context = ''Accounting Information'' AND '||
2126: 'c1.calendar_code = :pi_calendar_code_to AND ' ||

Line 2144: 'gmf_period_statuses c3, gmf_period_statuses c2, gmf_period_statuses c1 ' ||

2140: else
2141: l_sql_periods_b := 'SELECT ' ||
2142: 'c3.period_id ' ||
2143: 'FROM ' ||
2144: 'gmf_period_statuses c3, gmf_period_statuses c2, gmf_period_statuses c1 ' ||
2145: 'WHERE ' ||
2146: 'c1.calendar_code = :pi_calendar_code_to AND ' ||
2147: 'c1.period_code = :pi_all_periods_from AND ' ||
2148: 'c2.calendar_code = :pi_calendar_code_to AND ' ||