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.RLM_RD_SV dependencies on RLM_CORE_SV

Line 195: k_TDEBUG CONSTANT NUMBER := rlm_CORE_SV.C_LEVEL10;

191: k_SHIPPING CONSTANT VARCHAR2(30) := 'SHIPPING';
192: k_SEQUENCED CONSTANT VARCHAR2(30) := 'SEQUENCED';
193: k_RECONCILE CONSTANT BOOLEAN := TRUE;
194: k_NORECONCILE CONSTANT BOOLEAN := FALSE;
195: k_TDEBUG CONSTANT NUMBER := rlm_CORE_SV.C_LEVEL10;
196: k_SDEBUG CONSTANT NUMBER := rlm_CORE_SV.C_LEVEL11;
197: k_DEBUG CONSTANT NUMBER := rlm_CORE_SV.C_LEVEL12;
198: k_VNULL CONSTANT VARCHAR2(25) := 'THIS_IS_A_NULL_VALUE';
199: k_NNULL CONSTANT NUMBER := -19999999999;

Line 196: k_SDEBUG CONSTANT NUMBER := rlm_CORE_SV.C_LEVEL11;

192: k_SEQUENCED CONSTANT VARCHAR2(30) := 'SEQUENCED';
193: k_RECONCILE CONSTANT BOOLEAN := TRUE;
194: k_NORECONCILE CONSTANT BOOLEAN := FALSE;
195: k_TDEBUG CONSTANT NUMBER := rlm_CORE_SV.C_LEVEL10;
196: k_SDEBUG CONSTANT NUMBER := rlm_CORE_SV.C_LEVEL11;
197: k_DEBUG CONSTANT NUMBER := rlm_CORE_SV.C_LEVEL12;
198: k_VNULL CONSTANT VARCHAR2(25) := 'THIS_IS_A_NULL_VALUE';
199: k_NNULL CONSTANT NUMBER := -19999999999;
200: k_DNULL CONSTANT DATE := to_date('01/01/1930','dd/mm/yyyy');

Line 197: k_DEBUG CONSTANT NUMBER := rlm_CORE_SV.C_LEVEL12;

193: k_RECONCILE CONSTANT BOOLEAN := TRUE;
194: k_NORECONCILE CONSTANT BOOLEAN := FALSE;
195: k_TDEBUG CONSTANT NUMBER := rlm_CORE_SV.C_LEVEL10;
196: k_SDEBUG CONSTANT NUMBER := rlm_CORE_SV.C_LEVEL11;
197: k_DEBUG CONSTANT NUMBER := rlm_CORE_SV.C_LEVEL12;
198: k_VNULL CONSTANT VARCHAR2(25) := 'THIS_IS_A_NULL_VALUE';
199: k_NNULL CONSTANT NUMBER := -19999999999;
200: k_DNULL CONSTANT DATE := to_date('01/01/1930','dd/mm/yyyy');
201: k_ATS CONSTANT VARCHAR2(1) := 'Y';

Line 297: g_GetDemandTab RLM_CORE_SV.t_dynamic_tab;

293:
294: --
295: -- Tables to hold bind variable values
296: --
297: g_GetDemandTab RLM_CORE_SV.t_dynamic_tab;
298: g_InitDemandTab RLM_CORE_SV.t_dynamic_tab;
299: g_NewDemandTab RLM_CORE_SV.t_dynamic_tab;
300: g_WhereTab1 RLM_CORE_SV.t_dynamic_tab;
301: g_WhereTab2 RLM_CORE_SV.t_dynamic_tab;

Line 298: g_InitDemandTab RLM_CORE_SV.t_dynamic_tab;

294: --
295: -- Tables to hold bind variable values
296: --
297: g_GetDemandTab RLM_CORE_SV.t_dynamic_tab;
298: g_InitDemandTab RLM_CORE_SV.t_dynamic_tab;
299: g_NewDemandTab RLM_CORE_SV.t_dynamic_tab;
300: g_WhereTab1 RLM_CORE_SV.t_dynamic_tab;
301: g_WhereTab2 RLM_CORE_SV.t_dynamic_tab;
302: g_BindVarTab RLM_CORE_SV.t_dynamic_tab;

Line 299: g_NewDemandTab RLM_CORE_SV.t_dynamic_tab;

295: -- Tables to hold bind variable values
296: --
297: g_GetDemandTab RLM_CORE_SV.t_dynamic_tab;
298: g_InitDemandTab RLM_CORE_SV.t_dynamic_tab;
299: g_NewDemandTab RLM_CORE_SV.t_dynamic_tab;
300: g_WhereTab1 RLM_CORE_SV.t_dynamic_tab;
301: g_WhereTab2 RLM_CORE_SV.t_dynamic_tab;
302: g_BindVarTab RLM_CORE_SV.t_dynamic_tab;
303: --

Line 300: g_WhereTab1 RLM_CORE_SV.t_dynamic_tab;

296: --
297: g_GetDemandTab RLM_CORE_SV.t_dynamic_tab;
298: g_InitDemandTab RLM_CORE_SV.t_dynamic_tab;
299: g_NewDemandTab RLM_CORE_SV.t_dynamic_tab;
300: g_WhereTab1 RLM_CORE_SV.t_dynamic_tab;
301: g_WhereTab2 RLM_CORE_SV.t_dynamic_tab;
302: g_BindVarTab RLM_CORE_SV.t_dynamic_tab;
303: --
304: -- Bug 3666834 : To indicate that intransit calc. are done for a blanket

Line 301: g_WhereTab2 RLM_CORE_SV.t_dynamic_tab;

297: g_GetDemandTab RLM_CORE_SV.t_dynamic_tab;
298: g_InitDemandTab RLM_CORE_SV.t_dynamic_tab;
299: g_NewDemandTab RLM_CORE_SV.t_dynamic_tab;
300: g_WhereTab1 RLM_CORE_SV.t_dynamic_tab;
301: g_WhereTab2 RLM_CORE_SV.t_dynamic_tab;
302: g_BindVarTab RLM_CORE_SV.t_dynamic_tab;
303: --
304: -- Bug 3666834 : To indicate that intransit calc. are done for a blanket
305: g_BlktIntransits BOOLEAN := FALSE;

Line 302: g_BindVarTab RLM_CORE_SV.t_dynamic_tab;

298: g_InitDemandTab RLM_CORE_SV.t_dynamic_tab;
299: g_NewDemandTab RLM_CORE_SV.t_dynamic_tab;
300: g_WhereTab1 RLM_CORE_SV.t_dynamic_tab;
301: g_WhereTab2 RLM_CORE_SV.t_dynamic_tab;
302: g_BindVarTab RLM_CORE_SV.t_dynamic_tab;
303: --
304: -- Bug 3666834 : To indicate that intransit calc. are done for a blanket
305: g_BlktIntransits BOOLEAN := FALSE;
306: --

Line 1975: RLM_CORE_SV.OpenDynamicCursor

1971:
1972: DESCRIPTION: This function is called from ProcessATS and ProcessNATS.
1973: It takes in three bind variable value tables and concatenates
1974: all of them into one single table to be passed to
1975: RLM_CORE_SV.OpenDynamicCursor
1976:
1977: PARAMETERS:
1978:
1979: DESIGN REFERENCES: RLADPRDD.rtf

Line 1983: FUNCTION BuildBindVarTab3(p_Tab1 IN RLM_CORE_SV.t_dynamic_tab,

1979: DESIGN REFERENCES: RLADPRDD.rtf
1980:
1981: CHANGE HISTORY: created rlanka
1982: ===================================================================================*/
1983: FUNCTION BuildBindVarTab3(p_Tab1 IN RLM_CORE_SV.t_dynamic_tab,
1984: p_Tab2 IN RLM_CORE_SV.t_dynamic_tab,
1985: p_Tab3 IN RLM_CORE_SV.t_dynamic_tab)
1986: RETURN RLM_CORE_SV.t_dynamic_tab;
1987:

Line 1984: p_Tab2 IN RLM_CORE_SV.t_dynamic_tab,

1980:
1981: CHANGE HISTORY: created rlanka
1982: ===================================================================================*/
1983: FUNCTION BuildBindVarTab3(p_Tab1 IN RLM_CORE_SV.t_dynamic_tab,
1984: p_Tab2 IN RLM_CORE_SV.t_dynamic_tab,
1985: p_Tab3 IN RLM_CORE_SV.t_dynamic_tab)
1986: RETURN RLM_CORE_SV.t_dynamic_tab;
1987:
1988:

Line 1985: p_Tab3 IN RLM_CORE_SV.t_dynamic_tab)

1981: CHANGE HISTORY: created rlanka
1982: ===================================================================================*/
1983: FUNCTION BuildBindVarTab3(p_Tab1 IN RLM_CORE_SV.t_dynamic_tab,
1984: p_Tab2 IN RLM_CORE_SV.t_dynamic_tab,
1985: p_Tab3 IN RLM_CORE_SV.t_dynamic_tab)
1986: RETURN RLM_CORE_SV.t_dynamic_tab;
1987:
1988:
1989: /*==================================================================================

Line 1986: RETURN RLM_CORE_SV.t_dynamic_tab;

1982: ===================================================================================*/
1983: FUNCTION BuildBindVarTab3(p_Tab1 IN RLM_CORE_SV.t_dynamic_tab,
1984: p_Tab2 IN RLM_CORE_SV.t_dynamic_tab,
1985: p_Tab3 IN RLM_CORE_SV.t_dynamic_tab)
1986: RETURN RLM_CORE_SV.t_dynamic_tab;
1987:
1988:
1989: /*==================================================================================
1990: FUNCTION NAME: BuildBindVarTab5

Line 1995: RLM_CORE_SV.OpenDynamicCursor

1991:
1992: DESCRIPTION: This function is called from ProcessATS and ProcessNATS.
1993: It takes in five bind variable value tables and concatenates
1994: all of them into one single table to be passed to
1995: RLM_CORE_SV.OpenDynamicCursor
1996:
1997: PARAMETERS:
1998:
1999: DESIGN REFERENCES: RLADPRDD.rtf

Line 2003: FUNCTION BuildBindVarTab5(p_Tab1 IN RLM_CORE_SV.t_dynamic_tab,

1999: DESIGN REFERENCES: RLADPRDD.rtf
2000:
2001: CHANGE HISTORY: created rlanka
2002: ===================================================================================*/
2003: FUNCTION BuildBindVarTab5(p_Tab1 IN RLM_CORE_SV.t_dynamic_tab,
2004: p_Tab2 IN RLM_CORE_SV.t_dynamic_tab,
2005: p_Tab3 IN RLM_CORE_SV.t_dynamic_tab,
2006: p_Tab4 IN RLM_CORE_SV.t_dynamic_tab,
2007: p_Tab5 IN RLM_CORE_SV.t_dynamic_tab)

Line 2004: p_Tab2 IN RLM_CORE_SV.t_dynamic_tab,

2000:
2001: CHANGE HISTORY: created rlanka
2002: ===================================================================================*/
2003: FUNCTION BuildBindVarTab5(p_Tab1 IN RLM_CORE_SV.t_dynamic_tab,
2004: p_Tab2 IN RLM_CORE_SV.t_dynamic_tab,
2005: p_Tab3 IN RLM_CORE_SV.t_dynamic_tab,
2006: p_Tab4 IN RLM_CORE_SV.t_dynamic_tab,
2007: p_Tab5 IN RLM_CORE_SV.t_dynamic_tab)
2008: RETURN RLM_CORE_SV.t_dynamic_tab;

Line 2005: p_Tab3 IN RLM_CORE_SV.t_dynamic_tab,

2001: CHANGE HISTORY: created rlanka
2002: ===================================================================================*/
2003: FUNCTION BuildBindVarTab5(p_Tab1 IN RLM_CORE_SV.t_dynamic_tab,
2004: p_Tab2 IN RLM_CORE_SV.t_dynamic_tab,
2005: p_Tab3 IN RLM_CORE_SV.t_dynamic_tab,
2006: p_Tab4 IN RLM_CORE_SV.t_dynamic_tab,
2007: p_Tab5 IN RLM_CORE_SV.t_dynamic_tab)
2008: RETURN RLM_CORE_SV.t_dynamic_tab;
2009:

Line 2006: p_Tab4 IN RLM_CORE_SV.t_dynamic_tab,

2002: ===================================================================================*/
2003: FUNCTION BuildBindVarTab5(p_Tab1 IN RLM_CORE_SV.t_dynamic_tab,
2004: p_Tab2 IN RLM_CORE_SV.t_dynamic_tab,
2005: p_Tab3 IN RLM_CORE_SV.t_dynamic_tab,
2006: p_Tab4 IN RLM_CORE_SV.t_dynamic_tab,
2007: p_Tab5 IN RLM_CORE_SV.t_dynamic_tab)
2008: RETURN RLM_CORE_SV.t_dynamic_tab;
2009:
2010:

Line 2007: p_Tab5 IN RLM_CORE_SV.t_dynamic_tab)

2003: FUNCTION BuildBindVarTab5(p_Tab1 IN RLM_CORE_SV.t_dynamic_tab,
2004: p_Tab2 IN RLM_CORE_SV.t_dynamic_tab,
2005: p_Tab3 IN RLM_CORE_SV.t_dynamic_tab,
2006: p_Tab4 IN RLM_CORE_SV.t_dynamic_tab,
2007: p_Tab5 IN RLM_CORE_SV.t_dynamic_tab)
2008: RETURN RLM_CORE_SV.t_dynamic_tab;
2009:
2010:
2011: /*==================================================================================

Line 2008: RETURN RLM_CORE_SV.t_dynamic_tab;

2004: p_Tab2 IN RLM_CORE_SV.t_dynamic_tab,
2005: p_Tab3 IN RLM_CORE_SV.t_dynamic_tab,
2006: p_Tab4 IN RLM_CORE_SV.t_dynamic_tab,
2007: p_Tab5 IN RLM_CORE_SV.t_dynamic_tab)
2008: RETURN RLM_CORE_SV.t_dynamic_tab;
2009:
2010:
2011: /*==================================================================================
2012: FUNCTION NAME: BuildBindVarTab2

Line 2017: RLM_CORE_SV.OpenDynamicCursor

2013:
2014: DESCRIPTION: This function is called from ProcessATS and ProcessNATS.
2015: It takes in two bind variable value tables and concatenates
2016: all of them into one single table to be passed to
2017: RLM_CORE_SV.OpenDynamicCursor
2018:
2019: PARAMETERS:
2020:
2021: DESIGN REFERENCES: RLADPRDD.rtf

Line 2025: FUNCTION BuildBindVarTab2(p_Tab1 IN RLM_CORE_SV.t_dynamic_tab,

2021: DESIGN REFERENCES: RLADPRDD.rtf
2022:
2023: CHANGE HISTORY: created rlanka
2024: ===================================================================================*/
2025: FUNCTION BuildBindVarTab2(p_Tab1 IN RLM_CORE_SV.t_dynamic_tab,
2026: p_Tab2 IN RLM_CORE_SV.t_dynamic_tab)
2027: RETURN RLM_CORE_SV.t_dynamic_tab;
2028:
2029:

Line 2026: p_Tab2 IN RLM_CORE_SV.t_dynamic_tab)

2022:
2023: CHANGE HISTORY: created rlanka
2024: ===================================================================================*/
2025: FUNCTION BuildBindVarTab2(p_Tab1 IN RLM_CORE_SV.t_dynamic_tab,
2026: p_Tab2 IN RLM_CORE_SV.t_dynamic_tab)
2027: RETURN RLM_CORE_SV.t_dynamic_tab;
2028:
2029:
2030:

Line 2027: RETURN RLM_CORE_SV.t_dynamic_tab;

2023: CHANGE HISTORY: created rlanka
2024: ===================================================================================*/
2025: FUNCTION BuildBindVarTab2(p_Tab1 IN RLM_CORE_SV.t_dynamic_tab,
2026: p_Tab2 IN RLM_CORE_SV.t_dynamic_tab)
2027: RETURN RLM_CORE_SV.t_dynamic_tab;
2028:
2029:
2030:
2031: