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_GTT_PVT dependencies on OKL_ST_GEN_TEMPLATES

Line 13: -- FUNCTION get_rec for: OKL_ST_GEN_TEMPLATES

9: END get_seq_id;
10:
11:
12: ---------------------------------------------------------------------------
13: -- FUNCTION get_rec for: OKL_ST_GEN_TEMPLATES
14: ---------------------------------------------------------------------------
15: FUNCTION get_rec (
16: p_gtt_rec IN gtt_rec_type,
17: x_no_data_found OUT NOCOPY BOOLEAN

Line 19: CURSOR okl_st_gen_templates_pk_csr (p_id IN NUMBER) IS

15: FUNCTION get_rec (
16: p_gtt_rec IN gtt_rec_type,
17: x_no_data_found OUT NOCOPY BOOLEAN
18: ) RETURN gtt_rec_type IS
19: CURSOR okl_st_gen_templates_pk_csr (p_id IN NUMBER) IS
20: SELECT ID
21: ,OBJECT_VERSION_NUMBER
22: ,GTS_ID
23: ,VERSION

Line 49: FROM OKL_ST_GEN_TEMPLATES

45: ,CREATION_DATE
46: ,LAST_UPDATED_BY
47: ,LAST_UPDATE_DATE
48: ,LAST_UPDATE_LOGIN
49: FROM OKL_ST_GEN_TEMPLATES
50: WHERE OKL_ST_GEN_TEMPLATES.id = p_id;
51:
52: l_okl_st_gen_templates_pk okl_st_gen_templates_pk_csr%ROWTYPE;
53: l_gtt_rec gtt_rec_type;

Line 50: WHERE OKL_ST_GEN_TEMPLATES.id = p_id;

46: ,LAST_UPDATED_BY
47: ,LAST_UPDATE_DATE
48: ,LAST_UPDATE_LOGIN
49: FROM OKL_ST_GEN_TEMPLATES
50: WHERE OKL_ST_GEN_TEMPLATES.id = p_id;
51:
52: l_okl_st_gen_templates_pk okl_st_gen_templates_pk_csr%ROWTYPE;
53: l_gtt_rec gtt_rec_type;
54: BEGIN

Line 52: l_okl_st_gen_templates_pk okl_st_gen_templates_pk_csr%ROWTYPE;

48: ,LAST_UPDATE_LOGIN
49: FROM OKL_ST_GEN_TEMPLATES
50: WHERE OKL_ST_GEN_TEMPLATES.id = p_id;
51:
52: l_okl_st_gen_templates_pk okl_st_gen_templates_pk_csr%ROWTYPE;
53: l_gtt_rec gtt_rec_type;
54: BEGIN
55: x_no_data_found := TRUE;
56:

Line 58: OPEN okl_st_gen_templates_pk_csr (p_gtt_rec.id);

54: BEGIN
55: x_no_data_found := TRUE;
56:
57: -- Get current database values
58: OPEN okl_st_gen_templates_pk_csr (p_gtt_rec.id);
59:
60: FETCH okl_st_gen_templates_pk_csr INTO
61: l_gtt_rec.id
62: ,l_gtt_rec.object_version_number

Line 60: FETCH okl_st_gen_templates_pk_csr INTO

56:
57: -- Get current database values
58: OPEN okl_st_gen_templates_pk_csr (p_gtt_rec.id);
59:
60: FETCH okl_st_gen_templates_pk_csr INTO
61: l_gtt_rec.id
62: ,l_gtt_rec.object_version_number
63: ,l_gtt_rec.gts_id
64: ,l_gtt_rec.version

Line 91: x_no_data_found := okl_st_gen_templates_pk_csr%NOTFOUND;

87: ,l_gtt_rec.last_updated_by
88: ,l_gtt_rec.last_update_date
89: ,l_gtt_rec.last_update_login;
90:
91: x_no_data_found := okl_st_gen_templates_pk_csr%NOTFOUND;
92: CLOSE okl_st_gen_templates_pk_csr;
93:
94: RETURN(l_gtt_rec);
95:

Line 92: CLOSE okl_st_gen_templates_pk_csr;

88: ,l_gtt_rec.last_update_date
89: ,l_gtt_rec.last_update_login;
90:
91: x_no_data_found := okl_st_gen_templates_pk_csr%NOTFOUND;
92: CLOSE okl_st_gen_templates_pk_csr;
93:
94: RETURN(l_gtt_rec);
95:
96: END get_rec;

Line 142: FROM OKL_ST_GEN_TEMPLATES

138: ,CREATION_DATE
139: ,LAST_UPDATED_BY
140: ,LAST_UPDATE_DATE
141: ,LAST_UPDATE_LOGIN
142: FROM OKL_ST_GEN_TEMPLATES
143: WHERE OKL_ST_GEN_TEMPLATES.ID = p_id;
144:
145: l_okl_gttv_pk okl_gttv_pk_csr%ROWTYPE;
146: l_gttv_rec gttv_rec_type;

Line 143: WHERE OKL_ST_GEN_TEMPLATES.ID = p_id;

139: ,LAST_UPDATED_BY
140: ,LAST_UPDATE_DATE
141: ,LAST_UPDATE_LOGIN
142: FROM OKL_ST_GEN_TEMPLATES
143: WHERE OKL_ST_GEN_TEMPLATES.ID = p_id;
144:
145: l_okl_gttv_pk okl_gttv_pk_csr%ROWTYPE;
146: l_gttv_rec gttv_rec_type;
147: BEGIN

Line 197: -- validate_record for:OKL_ST_GEN_TEMPLATES --

193: END get_rec;
194:
195:
196: ----------------------------------------------
197: -- validate_record for:OKL_ST_GEN_TEMPLATES --
198: ----------------------------------------------
199: FUNCTION validate_record (
200: p_gttv_rec IN gttv_rec_type
201: ) RETURN VARCHAR2 IS

Line 857: -- table OKL_ST_GEN_TEMPLATES

853: -- Start of comments
854: --
855: -- Procedure Name : insert_row
856: -- Description : procedure for inserting the records in
857: -- table OKL_ST_GEN_TEMPLATES
858: -- Business Rules :
859: -- Parameters :
860: -- Version : 1.0
861: -- End of comments

Line 880: -- Set_Attributes for:OKL_ST_GEN_TEMPLATES --

876: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
877: l_gtt_rec gtt_rec_type := p_gtt_rec;
878: l_def_gtt_rec gtt_rec_type;
879: ---------------------------------------------
880: -- Set_Attributes for:OKL_ST_GEN_TEMPLATES --
881: ---------------------------------------------
882: FUNCTION Set_Attributes (
883: p_gtt_rec IN gtt_rec_type,
884: x_gtt_rec OUT NOCOPY gtt_rec_type

Line 915: INSERT INTO OKL_ST_GEN_TEMPLATES(

911: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
912: RAISE Okl_Api.G_EXCEPTION_ERROR;
913: END IF;
914:
915: INSERT INTO OKL_ST_GEN_TEMPLATES(
916: id
917: ,object_version_number
918: ,gts_id
919: ,version

Line 1049: -- Set_Attributes for:OKL_ST_GEN_TEMPLATES_V --

1045: RETURN(l_gttv_rec);
1046: END fill_who_columns;
1047:
1048: -----------------------------------------------
1049: -- Set_Attributes for:OKL_ST_GEN_TEMPLATES_V --
1050: -----------------------------------------------
1051: FUNCTION Set_Attributes (
1052: p_gttv_rec IN gttv_rec_type,
1053: x_gttv_rec OUT NOCOPY gttv_rec_type

Line 1266: -- table OKL_ST_GEN_TEMPLATES

1262: -- Start of comments
1263: --
1264: -- Procedure Name : update_row
1265: -- Description : procedure for updating the records in
1266: -- table OKL_ST_GEN_TEMPLATES
1267: -- Business Rules :
1268: -- Parameters :
1269: -- Version : 1.0
1270: -- End of comments

Line 1401: -- Set_Attributes for:OKL_ST_GEN_TEMPLATES --

1397: END IF;
1398: RETURN(l_return_status);
1399: END populate_new_record;
1400: ---------------------------------------------
1401: -- Set_Attributes for:OKL_ST_GEN_TEMPLATES --
1402: ---------------------------------------------
1403: FUNCTION Set_Attributes (
1404: p_gtt_rec IN gtt_rec_type,
1405: x_gtt_rec OUT NOCOPY gtt_rec_type

Line 1441: UPDATE OKL_ST_GEN_TEMPLATES

1437: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1438: RAISE Okl_Api.G_EXCEPTION_ERROR;
1439: END IF;
1440:
1441: UPDATE OKL_ST_GEN_TEMPLATES
1442: SET ID = l_def_gtt_rec.id
1443: ,OBJECT_VERSION_NUMBER = l_def_gtt_rec.object_version_number
1444: ,GTS_ID = l_def_gtt_rec.gts_id
1445: ,VERSION = l_def_gtt_rec.version

Line 1652: -- Set_Attributes for: OKL_ST_GEN_TEMPLATES --

1648: END IF;
1649: RETURN(l_return_status);
1650: END populate_new_record;
1651: ----------------------------------------------
1652: -- Set_Attributes for: OKL_ST_GEN_TEMPLATES --
1653: ----------------------------------------------
1654: FUNCTION Set_Attributes (
1655: p_gttv_rec IN gttv_rec_type,
1656: x_gttv_rec OUT NOCOPY gttv_rec_type

Line 1773: -- PL/SQL TBL update_row for:OKL_ST_GEN_TEMPLATES --

1769: END;
1770:
1771:
1772: ----------------------------------------------------
1773: -- PL/SQL TBL update_row for:OKL_ST_GEN_TEMPLATES --
1774: ----------------------------------------------------
1775: PROCEDURE update_row(
1776: p_api_version IN NUMBER,
1777: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 1855: -- delete_row for:OKL_ST_GEN_TEMPLATES --

1851: ---------------------------------------------------------------------------
1852: -- PROCEDURE delete_row
1853: ---------------------------------------------------------------------------
1854: -----------------------------------------
1855: -- delete_row for:OKL_ST_GEN_TEMPLATES --
1856: -----------------------------------------
1857: PROCEDURE delete_row(
1858: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1859: x_return_status OUT NOCOPY VARCHAR2,

Line 1881: DELETE FROM OKL_ST_GEN_TEMPLATES

1877: RAISE Okl_Api.G_EXCEPTION_ERROR;
1878: END IF;
1879:
1880: -- Actual deletion of the row
1881: DELETE FROM OKL_ST_GEN_TEMPLATES
1882: WHERE ID = l_gtt_rec.id;
1883:
1884: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1885:

Line 1920: -- delete_row for:OKL_ST_GEN_TEMPLATES --

1916: );
1917: END delete_row;
1918:
1919: ------------------------------------------
1920: -- delete_row for:OKL_ST_GEN_TEMPLATES --
1921: ------------------------------------------
1922: PROCEDURE delete_row(
1923: p_api_version IN NUMBER,
1924: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 2003: -- PL/SQL TBL delete_row for:OKL_ST_GEN_TEMPLATES --

1999: );
2000: END delete_row;
2001:
2002: ----------------------------------------------------
2003: -- PL/SQL TBL delete_row for:OKL_ST_GEN_TEMPLATES --
2004: ----------------------------------------------------
2005: PROCEDURE delete_row(
2006: p_api_version IN NUMBER,
2007: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,