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.AME_API3 dependencies on AME_RULES

Line 1904: ame_rules.rule_type,

1900: start_date and
1901: nvl(end_date - ame_util.oneSecond, sysdate);
1902: cursor ruleCursor is
1903: select
1904: ame_rules.rule_type,
1905: ame_rules.description
1906: from
1907: ame_rules
1908: where

Line 1905: ame_rules.description

1901: nvl(end_date - ame_util.oneSecond, sysdate);
1902: cursor ruleCursor is
1903: select
1904: ame_rules.rule_type,
1905: ame_rules.description
1906: from
1907: ame_rules
1908: where
1909: ame_rules.rule_id = ruleIdIn and

Line 1907: ame_rules

1903: select
1904: ame_rules.rule_type,
1905: ame_rules.description
1906: from
1907: ame_rules
1908: where
1909: ame_rules.rule_id = ruleIdIn and
1910: sysdate between
1911: ame_rules.start_date and

Line 1909: ame_rules.rule_id = ruleIdIn and

1905: ame_rules.description
1906: from
1907: ame_rules
1908: where
1909: ame_rules.rule_id = ruleIdIn and
1910: sysdate between
1911: ame_rules.start_date and
1912: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate) ;
1913: begin

Line 1911: ame_rules.start_date and

1907: ame_rules
1908: where
1909: ame_rules.rule_id = ruleIdIn and
1910: sysdate between
1911: ame_rules.start_date and
1912: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate) ;
1913: begin
1914: open ruleCursor;
1915: fetch ruleCursor into

Line 1912: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate) ;

1908: where
1909: ame_rules.rule_id = ruleIdIn and
1910: sysdate between
1911: ame_rules.start_date and
1912: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate) ;
1913: begin
1914: open ruleCursor;
1915: fetch ruleCursor into
1916: ruleTypeOut,

Line 1977: ame_rules.rule_type,

1973: ame_condition_usages.start_date and
1974: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate);
1975: cursor ruleCursor is
1976: select
1977: ame_rules.rule_type,
1978: ame_rules.description
1979: from
1980: ame_rules
1981: where

Line 1978: ame_rules.description

1974: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate);
1975: cursor ruleCursor is
1976: select
1977: ame_rules.rule_type,
1978: ame_rules.description
1979: from
1980: ame_rules
1981: where
1982: ame_rules.rule_id = ruleIdIn and

Line 1980: ame_rules

1976: select
1977: ame_rules.rule_type,
1978: ame_rules.description
1979: from
1980: ame_rules
1981: where
1982: ame_rules.rule_id = ruleIdIn and
1983: sysdate between
1984: ame_rules.start_date and

Line 1982: ame_rules.rule_id = ruleIdIn and

1978: ame_rules.description
1979: from
1980: ame_rules
1981: where
1982: ame_rules.rule_id = ruleIdIn and
1983: sysdate between
1984: ame_rules.start_date and
1985: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate) ;
1986: begin

Line 1984: ame_rules.start_date and

1980: ame_rules
1981: where
1982: ame_rules.rule_id = ruleIdIn and
1983: sysdate between
1984: ame_rules.start_date and
1985: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate) ;
1986: begin
1987: open ruleCursor;
1988: fetch ruleCursor into

Line 1985: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate) ;

1981: where
1982: ame_rules.rule_id = ruleIdIn and
1983: sysdate between
1984: ame_rules.start_date and
1985: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate) ;
1986: begin
1987: open ruleCursor;
1988: fetch ruleCursor into
1989: ruleTypeOut,

Line 2068: ame_rules.rule_type,

2064: ame_attributes.start_date and
2065: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate);
2066: cursor ruleCursor is
2067: select
2068: ame_rules.rule_type,
2069: ame_rules.description
2070: from
2071: ame_rules
2072: where

Line 2069: ame_rules.description

2065: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate);
2066: cursor ruleCursor is
2067: select
2068: ame_rules.rule_type,
2069: ame_rules.description
2070: from
2071: ame_rules
2072: where
2073: ame_rules.rule_id = ruleIdIn and

Line 2071: ame_rules

2067: select
2068: ame_rules.rule_type,
2069: ame_rules.description
2070: from
2071: ame_rules
2072: where
2073: ame_rules.rule_id = ruleIdIn and
2074: sysdate between
2075: ame_rules.start_date and

Line 2073: ame_rules.rule_id = ruleIdIn and

2069: ame_rules.description
2070: from
2071: ame_rules
2072: where
2073: ame_rules.rule_id = ruleIdIn and
2074: sysdate between
2075: ame_rules.start_date and
2076: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate) ;
2077: begin

Line 2075: ame_rules.start_date and

2071: ame_rules
2072: where
2073: ame_rules.rule_id = ruleIdIn and
2074: sysdate between
2075: ame_rules.start_date and
2076: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate) ;
2077: begin
2078: open ruleCursor;
2079: fetch ruleCursor into

Line 2076: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate) ;

2072: where
2073: ame_rules.rule_id = ruleIdIn and
2074: sysdate between
2075: ame_rules.start_date and
2076: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate) ;
2077: begin
2078: open ruleCursor;
2079: fetch ruleCursor into
2080: ruleTypeOut,