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.OKL_STM_PVT dependencies on OKL_API

Line 592: IF (l_found <> OKL_API.G_TRUE ) THEN

588: p_app_id => 0,
589: p_view_app_id => 0);
590:
591:
592: IF (l_found <> OKL_API.G_TRUE ) THEN
593: OKC_API.set_message(G_OKC_APP, G_INVALID_VALUE,G_COL_NAME_TOKEN,'Active_YN');
594: x_return_status := Okc_Api.G_RET_STS_ERROR;
595: -- raise the exception as there's no matching foreign key value
596: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 878: IF (l_found <> OKL_API.G_TRUE ) THEN

874: l_found := okl_accounting_util.validate_lookup_code(p_lookup_type => 'OKL_STREAM_GENERATOR',
875: p_lookup_code => p_stmv_rec.sgn_code);
876:
877:
878: IF (l_found <> OKL_API.G_TRUE ) THEN
879: OKC_API.set_message(G_OKC_APP, G_INVALID_VALUE,G_COL_NAME_TOKEN,'SPS_CODE');
880: x_return_status := Okc_Api.G_RET_STS_ERROR;
881: -- raise the exception as there's no matching foreign key value
882: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 942: IF (l_found <> OKL_API.G_TRUE ) THEN

938: l_found := okl_accounting_util.validate_lookup_code(p_lookup_type => 'OKL_STREAM_ACTIVITY',
939: p_lookup_code => p_stmv_rec.say_code);
940:
941:
942: IF (l_found <> OKL_API.G_TRUE ) THEN
943: OKC_API.set_message(G_OKC_APP, G_INVALID_VALUE,G_COL_NAME_TOKEN,'SPS_CODE');
944: x_return_status := Okc_Api.G_RET_STS_ERROR;
945: -- raise the exception as there's no matching foreign key value
946: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1945: IF p_stmv_rec.say_code = 'CURR' AND p_stmv_rec.date_current = OKL_API.G_MISS_DATE THEN

1941:
1942: /*
1943: * veramach 19-Dec-2007 bug 6691567 - set values for date_history/date_current/date_working based on say_code
1944: */
1945: IF p_stmv_rec.say_code = 'CURR' AND p_stmv_rec.date_current = OKL_API.G_MISS_DATE THEN
1946: x_stmv_rec.date_current := SYSDATE;
1947: END IF;
1948: IF p_stmv_rec.say_code = 'HIST' AND p_stmv_rec.date_history = OKL_API.G_MISS_DATE THEN
1949: x_stmv_rec.date_history := SYSDATE;

Line 1948: IF p_stmv_rec.say_code = 'HIST' AND p_stmv_rec.date_history = OKL_API.G_MISS_DATE THEN

1944: */
1945: IF p_stmv_rec.say_code = 'CURR' AND p_stmv_rec.date_current = OKL_API.G_MISS_DATE THEN
1946: x_stmv_rec.date_current := SYSDATE;
1947: END IF;
1948: IF p_stmv_rec.say_code = 'HIST' AND p_stmv_rec.date_history = OKL_API.G_MISS_DATE THEN
1949: x_stmv_rec.date_history := SYSDATE;
1950: END IF;
1951: IF p_stmv_rec.say_code = 'WORK' AND p_stmv_rec.date_working = OKL_API.G_MISS_DATE THEN
1952: x_stmv_rec.date_working := SYSDATE;

Line 1951: IF p_stmv_rec.say_code = 'WORK' AND p_stmv_rec.date_working = OKL_API.G_MISS_DATE THEN

1947: END IF;
1948: IF p_stmv_rec.say_code = 'HIST' AND p_stmv_rec.date_history = OKL_API.G_MISS_DATE THEN
1949: x_stmv_rec.date_history := SYSDATE;
1950: END IF;
1951: IF p_stmv_rec.say_code = 'WORK' AND p_stmv_rec.date_working = OKL_API.G_MISS_DATE THEN
1952: x_stmv_rec.date_working := SYSDATE;
1953: END IF;
1954: /*
1955: * veramach 19-Dec-2007 bug 6691567 - set values for date_history/date_current/date_working based on say_code

Line 2254: IF p_stmv_tbl(i).say_code = 'CURR' AND p_stmv_tbl(i).date_current = OKL_API.G_MISS_DATE THEN

2250:
2251: /*
2252: * veramach 19-Dec-2007 bug 6691567 - set values for date_history/date_current/date_working based on say_code
2253: */
2254: IF p_stmv_tbl(i).say_code = 'CURR' AND p_stmv_tbl(i).date_current = OKL_API.G_MISS_DATE THEN
2255: in_date_current(j) := SYSDATE;
2256: END IF;
2257: IF p_stmv_tbl(i).say_code = 'HIST' AND p_stmv_tbl(i).date_history = OKL_API.G_MISS_DATE THEN
2258: in_date_history(j) := SYSDATE;

Line 2257: IF p_stmv_tbl(i).say_code = 'HIST' AND p_stmv_tbl(i).date_history = OKL_API.G_MISS_DATE THEN

2253: */
2254: IF p_stmv_tbl(i).say_code = 'CURR' AND p_stmv_tbl(i).date_current = OKL_API.G_MISS_DATE THEN
2255: in_date_current(j) := SYSDATE;
2256: END IF;
2257: IF p_stmv_tbl(i).say_code = 'HIST' AND p_stmv_tbl(i).date_history = OKL_API.G_MISS_DATE THEN
2258: in_date_history(j) := SYSDATE;
2259: END IF;
2260: IF p_stmv_tbl(i).say_code = 'WORK' AND p_stmv_tbl(i).date_working = OKL_API.G_MISS_DATE THEN
2261: in_date_working(j) := SYSDATE;

Line 2260: IF p_stmv_tbl(i).say_code = 'WORK' AND p_stmv_tbl(i).date_working = OKL_API.G_MISS_DATE THEN

2256: END IF;
2257: IF p_stmv_tbl(i).say_code = 'HIST' AND p_stmv_tbl(i).date_history = OKL_API.G_MISS_DATE THEN
2258: in_date_history(j) := SYSDATE;
2259: END IF;
2260: IF p_stmv_tbl(i).say_code = 'WORK' AND p_stmv_tbl(i).date_working = OKL_API.G_MISS_DATE THEN
2261: in_date_working(j) := SYSDATE;
2262: END IF;
2263: /*
2264: * veramach 19-Dec-2007 bug 6691567 - set values for date_history/date_current/date_working based on say_code

Line 3155: IF p_stmv_rec.say_code = 'CURR' AND (p_stmv_rec.date_current IS NULL OR p_stmv_rec.date_current = OKL_API.G_MISS_DATE) THEN

3151:
3152: /*
3153: * veramach 19-Dec-2007 bug 6691567 - set values for date_history/date_current/date_working based on say_code
3154: */
3155: IF p_stmv_rec.say_code = 'CURR' AND (p_stmv_rec.date_current IS NULL OR p_stmv_rec.date_current = OKL_API.G_MISS_DATE) THEN
3156: x_stmv_rec.date_current := SYSDATE;
3157: END IF;
3158: IF p_stmv_rec.say_code = 'HIST' AND (p_stmv_rec.date_history IS NULL OR p_stmv_rec.date_history = OKL_API.G_MISS_DATE) THEN
3159: x_stmv_rec.date_history := SYSDATE;

Line 3158: IF p_stmv_rec.say_code = 'HIST' AND (p_stmv_rec.date_history IS NULL OR p_stmv_rec.date_history = OKL_API.G_MISS_DATE) THEN

3154: */
3155: IF p_stmv_rec.say_code = 'CURR' AND (p_stmv_rec.date_current IS NULL OR p_stmv_rec.date_current = OKL_API.G_MISS_DATE) THEN
3156: x_stmv_rec.date_current := SYSDATE;
3157: END IF;
3158: IF p_stmv_rec.say_code = 'HIST' AND (p_stmv_rec.date_history IS NULL OR p_stmv_rec.date_history = OKL_API.G_MISS_DATE) THEN
3159: x_stmv_rec.date_history := SYSDATE;
3160: END IF;
3161: IF p_stmv_rec.say_code = 'WORK' AND (p_stmv_rec.date_working IS NULL OR p_stmv_rec.date_working = OKL_API.G_MISS_DATE) THEN
3162: x_stmv_rec.date_working := SYSDATE;

Line 3161: IF p_stmv_rec.say_code = 'WORK' AND (p_stmv_rec.date_working IS NULL OR p_stmv_rec.date_working = OKL_API.G_MISS_DATE) THEN

3157: END IF;
3158: IF p_stmv_rec.say_code = 'HIST' AND (p_stmv_rec.date_history IS NULL OR p_stmv_rec.date_history = OKL_API.G_MISS_DATE) THEN
3159: x_stmv_rec.date_history := SYSDATE;
3160: END IF;
3161: IF p_stmv_rec.say_code = 'WORK' AND (p_stmv_rec.date_working IS NULL OR p_stmv_rec.date_working = OKL_API.G_MISS_DATE) THEN
3162: x_stmv_rec.date_working := SYSDATE;
3163: END IF;
3164: /*
3165: * veramach 19-Dec-2007 bug 6691567 - set values for date_history/date_current/date_working based on say_code