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_GTL_PVT dependencies on OKL_ST_GEN_TMPT_LNS

Line 14: -- FUNCTION get_rec for: OKL_ST_GEN_TMPT_LNS

10: END get_seq_id;
11:
12:
13: ---------------------------------------------------------------------------
14: -- FUNCTION get_rec for: OKL_ST_GEN_TMPT_LNS
15: ---------------------------------------------------------------------------
16: FUNCTION get_rec (
17: p_gtl_rec IN gtl_rec_type,
18: x_no_data_found OUT NOCOPY BOOLEAN

Line 20: CURSOR okl_st_gen_tmpt_lns_pk_csr (p_id IN NUMBER) IS

16: FUNCTION get_rec (
17: p_gtl_rec IN gtl_rec_type,
18: x_no_data_found OUT NOCOPY BOOLEAN
19: ) RETURN gtl_rec_type IS
20: CURSOR okl_st_gen_tmpt_lns_pk_csr (p_id IN NUMBER) IS
21: SELECT ID
22: ,OBJECT_VERSION_NUMBER
23: ,GTT_ID
24: ,PRIMARY_YN

Line 34: FROM OKL_ST_GEN_TMPT_LNS

30: ,CREATION_DATE
31: ,LAST_UPDATED_BY
32: ,LAST_UPDATE_DATE
33: ,LAST_UPDATE_LOGIN
34: FROM OKL_ST_GEN_TMPT_LNS
35: WHERE OKL_ST_GEN_TMPT_LNS.id = p_id;
36:
37: l_okl_st_gen_tmpt_lns_pk okl_st_gen_tmpt_lns_pk_csr%ROWTYPE;
38: l_gtl_rec gtl_rec_type;

Line 35: WHERE OKL_ST_GEN_TMPT_LNS.id = p_id;

31: ,LAST_UPDATED_BY
32: ,LAST_UPDATE_DATE
33: ,LAST_UPDATE_LOGIN
34: FROM OKL_ST_GEN_TMPT_LNS
35: WHERE OKL_ST_GEN_TMPT_LNS.id = p_id;
36:
37: l_okl_st_gen_tmpt_lns_pk okl_st_gen_tmpt_lns_pk_csr%ROWTYPE;
38: l_gtl_rec gtl_rec_type;
39: BEGIN

Line 37: l_okl_st_gen_tmpt_lns_pk okl_st_gen_tmpt_lns_pk_csr%ROWTYPE;

33: ,LAST_UPDATE_LOGIN
34: FROM OKL_ST_GEN_TMPT_LNS
35: WHERE OKL_ST_GEN_TMPT_LNS.id = p_id;
36:
37: l_okl_st_gen_tmpt_lns_pk okl_st_gen_tmpt_lns_pk_csr%ROWTYPE;
38: l_gtl_rec gtl_rec_type;
39: BEGIN
40: x_no_data_found := TRUE;
41:

Line 43: OPEN okl_st_gen_tmpt_lns_pk_csr (p_gtl_rec.id);

39: BEGIN
40: x_no_data_found := TRUE;
41:
42: -- Get current database values
43: OPEN okl_st_gen_tmpt_lns_pk_csr (p_gtl_rec.id);
44:
45: FETCH okl_st_gen_tmpt_lns_pk_csr INTO
46: l_gtl_rec.id
47: ,l_gtl_rec.object_version_number

Line 45: FETCH okl_st_gen_tmpt_lns_pk_csr INTO

41:
42: -- Get current database values
43: OPEN okl_st_gen_tmpt_lns_pk_csr (p_gtl_rec.id);
44:
45: FETCH okl_st_gen_tmpt_lns_pk_csr INTO
46: l_gtl_rec.id
47: ,l_gtl_rec.object_version_number
48: ,l_gtl_rec.gtt_id
49: ,l_gtl_rec.primary_yn

Line 60: x_no_data_found := okl_st_gen_tmpt_lns_pk_csr%NOTFOUND;

56: ,l_gtl_rec.last_updated_by
57: ,l_gtl_rec.last_update_date
58: ,l_gtl_rec.last_update_login;
59:
60: x_no_data_found := okl_st_gen_tmpt_lns_pk_csr%NOTFOUND;
61: CLOSE okl_st_gen_tmpt_lns_pk_csr;
62:
63: RETURN(l_gtl_rec);
64:

Line 61: CLOSE okl_st_gen_tmpt_lns_pk_csr;

57: ,l_gtl_rec.last_update_date
58: ,l_gtl_rec.last_update_login;
59:
60: x_no_data_found := okl_st_gen_tmpt_lns_pk_csr%NOTFOUND;
61: CLOSE okl_st_gen_tmpt_lns_pk_csr;
62:
63: RETURN(l_gtl_rec);
64:
65: END get_rec;

Line 75: -- FUNCTION get_rec for: OKL_ST_GEN_TMPT_LNS_V

71: BEGIN
72: RETURN(get_rec(p_gtl_rec, l_row_notfound));
73: END get_rec;
74: ---------------------------------------------------------------------------
75: -- FUNCTION get_rec for: OKL_ST_GEN_TMPT_LNS_V
76: ---------------------------------------------------------------------------
77: FUNCTION get_rec (
78: p_gtlv_rec IN gtlv_rec_type,
79: x_no_data_found OUT NOCOPY BOOLEAN

Line 95: FROM OKL_ST_GEN_TMPT_LNS

91: ,CREATION_DATE
92: ,LAST_UPDATED_BY
93: ,LAST_UPDATE_DATE
94: ,LAST_UPDATE_LOGIN
95: FROM OKL_ST_GEN_TMPT_LNS
96: WHERE OKL_ST_GEN_TMPT_LNS.ID = p_id;
97:
98: l_okl_gtlv_pk okl_gtlv_pk_csr%ROWTYPE;
99: l_gtlv_rec gtlv_rec_type;

Line 96: WHERE OKL_ST_GEN_TMPT_LNS.ID = p_id;

92: ,LAST_UPDATED_BY
93: ,LAST_UPDATE_DATE
94: ,LAST_UPDATE_LOGIN
95: FROM OKL_ST_GEN_TMPT_LNS
96: WHERE OKL_ST_GEN_TMPT_LNS.ID = p_id;
97:
98: l_okl_gtlv_pk okl_gtlv_pk_csr%ROWTYPE;
99: l_gtlv_rec gtlv_rec_type;
100: BEGIN

Line 133: -- validate_record for: OKL_ST_GEN_TMPT_LNS_V --

129: RETURN(get_rec(p_gtlv_rec, l_row_notfound));
130: END get_rec;
131:
132: ----------------------------------------------
133: -- validate_record for: OKL_ST_GEN_TMPT_LNS_V --
134: ----------------------------------------------
135: FUNCTION validate_record (
136: p_gtlv_rec IN gtlv_rec_type
137: ) RETURN VARCHAR2 IS

Line 139: l_gtt_id OKL_ST_GEN_TMPT_LNS.GTT_ID%TYPE;

135: FUNCTION validate_record (
136: p_gtlv_rec IN gtlv_rec_type
137: ) RETURN VARCHAR2 IS
138: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
139: l_gtt_id OKL_ST_GEN_TMPT_LNS.GTT_ID%TYPE;
140: l_gtlv_rec gtlv_rec_type := p_gtlv_rec;
141:
142: -- Modified by RGOOTY:
143: -- Bug 4054596: Issue No. 3: Start

Line 144: CURSOR gtl_pri_dup_csr( p_id OKL_ST_GEN_TMPT_LNS.ID%TYPE

140: l_gtlv_rec gtlv_rec_type := p_gtlv_rec;
141:
142: -- Modified by RGOOTY:
143: -- Bug 4054596: Issue No. 3: Start
144: CURSOR gtl_pri_dup_csr( p_id OKL_ST_GEN_TMPT_LNS.ID%TYPE
145: ,p_gtt_id OKL_ST_GEN_TMPT_LNS.GTT_ID%TYPE
146: ,p_pri_sty_id OKL_ST_GEN_TMPT_LNS.PRIMARY_STY_ID%TYPE) IS
147: SELECT NAME stream_name
148: FROM OKL_STRM_TYPE_V

Line 145: ,p_gtt_id OKL_ST_GEN_TMPT_LNS.GTT_ID%TYPE

141:
142: -- Modified by RGOOTY:
143: -- Bug 4054596: Issue No. 3: Start
144: CURSOR gtl_pri_dup_csr( p_id OKL_ST_GEN_TMPT_LNS.ID%TYPE
145: ,p_gtt_id OKL_ST_GEN_TMPT_LNS.GTT_ID%TYPE
146: ,p_pri_sty_id OKL_ST_GEN_TMPT_LNS.PRIMARY_STY_ID%TYPE) IS
147: SELECT NAME stream_name
148: FROM OKL_STRM_TYPE_V
149: WHERE ID IN

Line 146: ,p_pri_sty_id OKL_ST_GEN_TMPT_LNS.PRIMARY_STY_ID%TYPE) IS

142: -- Modified by RGOOTY:
143: -- Bug 4054596: Issue No. 3: Start
144: CURSOR gtl_pri_dup_csr( p_id OKL_ST_GEN_TMPT_LNS.ID%TYPE
145: ,p_gtt_id OKL_ST_GEN_TMPT_LNS.GTT_ID%TYPE
146: ,p_pri_sty_id OKL_ST_GEN_TMPT_LNS.PRIMARY_STY_ID%TYPE) IS
147: SELECT NAME stream_name
148: FROM OKL_STRM_TYPE_V
149: WHERE ID IN
150: (

Line 152: FROM OKL_ST_GEN_TMPT_LNS GTL

148: FROM OKL_STRM_TYPE_V
149: WHERE ID IN
150: (
151: SELECT primary_Sty_id
152: FROM OKL_ST_GEN_TMPT_LNS GTL
153: WHERE GTL.GTT_ID = p_gtt_id
154: AND GTL.PRIMARY_YN = 'Y'
155: AND GTL.PRIMARY_STY_ID = p_pri_sty_id
156: AND GTL.ID <> p_id

Line 159: CURSOR gtl_dep_dup_csr( p_id OKL_ST_GEN_TMPT_LNS.ID%TYPE

155: AND GTL.PRIMARY_STY_ID = p_pri_sty_id
156: AND GTL.ID <> p_id
157: );
158:
159: CURSOR gtl_dep_dup_csr( p_id OKL_ST_GEN_TMPT_LNS.ID%TYPE
160: ,p_gtt_id OKL_ST_GEN_TMPT_LNS.GTT_ID%TYPE
161: ,p_pri_sty_id OKL_ST_GEN_TMPT_LNS.PRIMARY_STY_ID%TYPE
162: ,p_dep_sty_id OKL_ST_GEN_TMPT_LNS.DEPENDENT_STY_ID%TYPE) IS
163: SELECT NAME stream_name

Line 160: ,p_gtt_id OKL_ST_GEN_TMPT_LNS.GTT_ID%TYPE

156: AND GTL.ID <> p_id
157: );
158:
159: CURSOR gtl_dep_dup_csr( p_id OKL_ST_GEN_TMPT_LNS.ID%TYPE
160: ,p_gtt_id OKL_ST_GEN_TMPT_LNS.GTT_ID%TYPE
161: ,p_pri_sty_id OKL_ST_GEN_TMPT_LNS.PRIMARY_STY_ID%TYPE
162: ,p_dep_sty_id OKL_ST_GEN_TMPT_LNS.DEPENDENT_STY_ID%TYPE) IS
163: SELECT NAME stream_name
164: FROM OKL_STRM_TYPE_V

Line 161: ,p_pri_sty_id OKL_ST_GEN_TMPT_LNS.PRIMARY_STY_ID%TYPE

157: );
158:
159: CURSOR gtl_dep_dup_csr( p_id OKL_ST_GEN_TMPT_LNS.ID%TYPE
160: ,p_gtt_id OKL_ST_GEN_TMPT_LNS.GTT_ID%TYPE
161: ,p_pri_sty_id OKL_ST_GEN_TMPT_LNS.PRIMARY_STY_ID%TYPE
162: ,p_dep_sty_id OKL_ST_GEN_TMPT_LNS.DEPENDENT_STY_ID%TYPE) IS
163: SELECT NAME stream_name
164: FROM OKL_STRM_TYPE_V
165: WHERE ID IN

Line 162: ,p_dep_sty_id OKL_ST_GEN_TMPT_LNS.DEPENDENT_STY_ID%TYPE) IS

158:
159: CURSOR gtl_dep_dup_csr( p_id OKL_ST_GEN_TMPT_LNS.ID%TYPE
160: ,p_gtt_id OKL_ST_GEN_TMPT_LNS.GTT_ID%TYPE
161: ,p_pri_sty_id OKL_ST_GEN_TMPT_LNS.PRIMARY_STY_ID%TYPE
162: ,p_dep_sty_id OKL_ST_GEN_TMPT_LNS.DEPENDENT_STY_ID%TYPE) IS
163: SELECT NAME stream_name
164: FROM OKL_STRM_TYPE_V
165: WHERE ID IN
166: (

Line 168: FROM OKL_ST_GEN_TMPT_LNS GTL

164: FROM OKL_STRM_TYPE_V
165: WHERE ID IN
166: (
167: SELECT dependent_sty_id
168: FROM OKL_ST_GEN_TMPT_LNS GTL
169: WHERE GTL.GTT_ID = p_gtt_id
170: AND GTL.PRIMARY_YN = 'N'
171: AND GTL.PRIMARY_STY_ID = p_pri_sty_id
172: AND GTL.DEPENDENT_STY_ID = p_dep_sty_id

Line 641: -- table OKL_ST_GEN_TMPT_LNS

637: -- Start of comments
638: --
639: -- Procedure Name : insert_row
640: -- Description : procedure for inserting the records in
641: -- table OKL_ST_GEN_TMPT_LNS
642: -- Business Rules :
643: -- Parameters :
644: -- Version : 1.0
645: -- End of comments

Line 664: -- Set_Attributes for:OKL_ST_GEN_TMPT_LNS --

660: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
661: l_gtl_rec gtl_rec_type := p_gtl_rec;
662: l_def_gtl_rec gtl_rec_type;
663: ---------------------------------------------
664: -- Set_Attributes for:OKL_ST_GEN_TMPT_LNS --
665: ---------------------------------------------
666: FUNCTION Set_Attributes (
667: p_gtl_rec IN gtl_rec_type,
668: x_gtl_rec OUT NOCOPY gtl_rec_type

Line 699: INSERT INTO OKL_ST_GEN_TMPT_LNS(

695: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
696: RAISE Okl_Api.G_EXCEPTION_ERROR;
697: END IF;
698:
699: INSERT INTO OKL_ST_GEN_TMPT_LNS(
700: ID
701: ,OBJECT_VERSION_NUMBER
702: ,GTT_ID
703: ,PRIMARY_YN

Line 802: -- Set_Attributes for:OKL_ST_GEN_TMPT_LNS_V --

798: RETURN(l_gtlv_rec);
799: END fill_who_columns;
800:
801: -----------------------------------------------
802: -- Set_Attributes for:OKL_ST_GEN_TMPT_LNS_V --
803: -----------------------------------------------
804: FUNCTION Set_Attributes (
805: p_gtlv_rec IN gtlv_rec_type,
806: x_gtlv_rec OUT NOCOPY gtlv_rec_type

Line 1153: UPDATE OKL_ST_GEN_TMPT_LNS

1149: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1150: RAISE Okl_Api.G_EXCEPTION_ERROR;
1151: END IF;
1152:
1153: UPDATE OKL_ST_GEN_TMPT_LNS
1154: SET ID = l_def_gtl_rec.id
1155: ,OBJECT_VERSION_NUMBER = l_def_gtl_rec.object_version_number
1156: ,GTT_ID = l_def_gtl_rec.gtt_id
1157: ,PRIMARY_YN = l_def_gtl_rec.primary_yn

Line 1504: -- delete_row for:OKL_ST_GEN_TMPT_LNS --

1500: ---------------------------------------------------------------------------
1501: -- PROCEDURE delete_row
1502: ---------------------------------------------------------------------------
1503: -----------------------------------------
1504: -- delete_row for:OKL_ST_GEN_TMPT_LNS --
1505: -----------------------------------------
1506: PROCEDURE delete_row(
1507: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1508: x_return_status OUT NOCOPY VARCHAR2,

Line 1530: DELETE FROM OKL_ST_GEN_TMPT_LNS

1526: RAISE Okl_Api.G_EXCEPTION_ERROR;
1527: END IF;
1528:
1529: -- Actual deletion of the row
1530: DELETE FROM OKL_ST_GEN_TMPT_LNS
1531: WHERE ID = l_gtl_rec.id;
1532:
1533: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1534:

Line 1568: -- delete_row for:OKL_ST_GEN_TMPT_LNS --

1564: '_PVT'
1565: );
1566: END delete_row;
1567: ------------------------------------------
1568: -- delete_row for:OKL_ST_GEN_TMPT_LNS --
1569: ------------------------------------------
1570: PROCEDURE delete_row(
1571: p_api_version IN NUMBER,
1572: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 1652: -- PL/SQL TBL delete_row for:OKL_ST_GEN_TMPT_LNS --

1648: );
1649: END delete_row;
1650:
1651: ----------------------------------------------------
1652: -- PL/SQL TBL delete_row for:OKL_ST_GEN_TMPT_LNS --
1653: ----------------------------------------------------
1654: PROCEDURE delete_row(
1655: p_api_version IN NUMBER,
1656: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,