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_SETUPPSTYPES_PVT dependencies on OKL_PROD_STRM_TYPES_V

Line 5: -- PROCEDURE get_rec for: Okl_Prod_Strm_Types_V

1: PACKAGE BODY Okl_Setuppstypes_Pvt AS
2: /* $Header: OKLRSPSB.pls 115.7 2003/07/23 18:36:58 sgorantl noship $ */
3: G_ITEM_NOT_FOUND_ERROR EXCEPTION;
4: ---------------------------------------------------------------------------
5: -- PROCEDURE get_rec for: Okl_Prod_Strm_Types_V
6: ---------------------------------------------------------------------------
7: PROCEDURE get_rec (
8: p_psyv_rec IN psyv_rec_type,
9: x_no_data_found OUT NOCOPY BOOLEAN,

Line 27: FROM Okl_Prod_Strm_Types_V

23: CREATION_DATE,
24: LAST_UPDATED_BY,
25: LAST_UPDATE_DATE,
26: LAST_UPDATE_LOGIN
27: FROM Okl_Prod_Strm_Types_V
28: WHERE Okl_Prod_Strm_Types_V.id = p_id;
29: l_okl_psyv_pk okl_psyv_pk_csr%ROWTYPE;
30: l_psyv_rec psyv_rec_type;
31: BEGIN

Line 28: WHERE Okl_Prod_Strm_Types_V.id = p_id;

24: LAST_UPDATED_BY,
25: LAST_UPDATE_DATE,
26: LAST_UPDATE_LOGIN
27: FROM Okl_Prod_Strm_Types_V
28: WHERE Okl_Prod_Strm_Types_V.id = p_id;
29: l_okl_psyv_pk okl_psyv_pk_csr%ROWTYPE;
30: l_psyv_rec psyv_rec_type;
31: BEGIN
32: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 71: -- PROCEDURE get_parent_dates for: Okl_Prod_Strm_Types_V

67:
68: END get_rec;
69:
70: ---------------------------------------------------------------------------
71: -- PROCEDURE get_parent_dates for: Okl_Prod_Strm_Types_V
72: ---------------------------------------------------------------------------
73:
74: PROCEDURE get_parent_dates(
75: p_psyv_rec IN psyv_rec_type,

Line 120: -- PROCEDURE check_constraints for: Okl_Prod_Strm_Types_V

116: END get_parent_dates;
117:
118:
119: -----------------------------------------------------------------------------
120: -- PROCEDURE check_constraints for: Okl_Prod_Strm_Types_V
121: -----------------------------------------------------------------------------
122:
123: PROCEDURE Check_Constraints (
124: p_api_version IN NUMBER,

Line 145: CURSOR okl_psy_constraints_csr(p_sty_id IN Okl_Prod_Strm_Types_V.STY_ID%TYPE,

141: FROM Okl_products_V pdt
142: WHERE pdt.ID = p_pdt_id
143: AND NVL(pdt.TO_DATE, p_date) < p_date;
144:
145: CURSOR okl_psy_constraints_csr(p_sty_id IN Okl_Prod_Strm_Types_V.STY_ID%TYPE,
146: p_from_date IN Okl_Prod_Strm_Types_V.FROM_DATE%TYPE,
147: p_to_date IN Okl_Prod_Strm_Types_V.TO_DATE%TYPE
148: ) IS
149: SELECT '1'

Line 146: p_from_date IN Okl_Prod_Strm_Types_V.FROM_DATE%TYPE,

142: WHERE pdt.ID = p_pdt_id
143: AND NVL(pdt.TO_DATE, p_date) < p_date;
144:
145: CURSOR okl_psy_constraints_csr(p_sty_id IN Okl_Prod_Strm_Types_V.STY_ID%TYPE,
146: p_from_date IN Okl_Prod_Strm_Types_V.FROM_DATE%TYPE,
147: p_to_date IN Okl_Prod_Strm_Types_V.TO_DATE%TYPE
148: ) IS
149: SELECT '1'
150: FROM Okl_Strm_Type_V sty

Line 147: p_to_date IN Okl_Prod_Strm_Types_V.TO_DATE%TYPE

143: AND NVL(pdt.TO_DATE, p_date) < p_date;
144:
145: CURSOR okl_psy_constraints_csr(p_sty_id IN Okl_Prod_Strm_Types_V.STY_ID%TYPE,
146: p_from_date IN Okl_Prod_Strm_Types_V.FROM_DATE%TYPE,
147: p_to_date IN Okl_Prod_Strm_Types_V.TO_DATE%TYPE
148: ) IS
149: SELECT '1'
150: FROM Okl_Strm_Type_V sty
151: WHERE sty.ID = p_sty_id

Line 156: CURSOR c1(p_pdt_id okl_prod_strm_types_v.pdt_id%TYPE,

152: AND ((sty.START_DATE > p_from_date OR
153: p_from_date > NVL(sty.END_DATE,p_from_date)) OR
154: NVL(sty.END_DATE, p_to_date) < p_to_date);
155:
156: CURSOR c1(p_pdt_id okl_prod_strm_types_v.pdt_id%TYPE,
157: p_sty_id okl_prod_strm_types_v.sty_id%TYPE) IS
158: SELECT '1'
159: FROM okl_prod_strm_types_v
160: WHERE pdt_id = p_pdt_id

Line 157: p_sty_id okl_prod_strm_types_v.sty_id%TYPE) IS

153: p_from_date > NVL(sty.END_DATE,p_from_date)) OR
154: NVL(sty.END_DATE, p_to_date) < p_to_date);
155:
156: CURSOR c1(p_pdt_id okl_prod_strm_types_v.pdt_id%TYPE,
157: p_sty_id okl_prod_strm_types_v.sty_id%TYPE) IS
158: SELECT '1'
159: FROM okl_prod_strm_types_v
160: WHERE pdt_id = p_pdt_id
161: AND sty_id = p_sty_id

Line 159: FROM okl_prod_strm_types_v

155:
156: CURSOR c1(p_pdt_id okl_prod_strm_types_v.pdt_id%TYPE,
157: p_sty_id okl_prod_strm_types_v.sty_id%TYPE) IS
158: SELECT '1'
159: FROM okl_prod_strm_types_v
160: WHERE pdt_id = p_pdt_id
161: AND sty_id = p_sty_id
162: AND id <> NVL(p_psyv_rec.id,-9999);
163:

Line 205: p_token1_value => 'Okl_Prod_Strm_Types_V',

201: IF l_row_not_found = FALSE THEN
202: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
203: p_msg_name => G_IN_USE,
204: p_token1 => G_PARENT_TABLE_TOKEN,
205: p_token1_value => 'Okl_Prod_Strm_Types_V',
206: p_token2 => G_CHILD_TABLE_TOKEN,
207: p_token2_value => 'okl_k_headers_v');
208: x_valid := FALSE;
209: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 243: p_token2_value => 'Okl_Prod_Strm_Types_V,Okl_Products_V');

239: p_msg_name => G_DATES_MISMATCH,
240: p_token1 => G_PARENT_TABLE_TOKEN,
241: p_token1_value => 'Okl_Strm_Type_V',
242: p_token2 => G_CHILD_TABLE_TOKEN,
243: p_token2_value => 'Okl_Prod_Strm_Types_V,Okl_Products_V');
244: x_valid := FALSE;
245: x_return_status := OKL_API.G_RET_STS_ERROR;
246: RAISE G_EXCEPTION_HALT_PROCESSING;
247: END IF;*/

Line 341: -- Validate_Attributes for:OKL_PROD_STRM_TYPES_V --

337: ---------------------------------------------------------------------------
338: -- FUNCTION Validate_Attributes
339: ---------------------------------------------------------------------------
340: ---------------------------------------------------
341: -- Validate_Attributes for:OKL_PROD_STRM_TYPES_V --
342: ---------------------------------------------------
343: FUNCTION Validate_Attributes (
344: p_psyv_rec IN psyv_rec_type
345: ) RETURN VARCHAR2 IS

Line 377: -- PROCEDURE insert_pstypes for: Okl_Prod_Strm_Types_V

373: RETURN(l_return_status);
374: END Validate_Attributes;
375:
376: ---------------------------------------------------------------------------
377: -- PROCEDURE insert_pstypes for: Okl_Prod_Strm_Types_V
378: ---------------------------------------------------------------------------
379: PROCEDURE insert_pstypes(
380: p_api_version IN NUMBER,
381: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 506: -- PROCEDURE update_pstypes for: Okl_Prod_Strm_Types_V

502:
503: END insert_pstypes;
504:
505: ---------------------------------------------------------------------------
506: -- PROCEDURE update_pstypes for: Okl_Prod_Strm_Types_V
507: ---------------------------------------------------------------------------
508: PROCEDURE update_pstypes(
509: p_api_version IN NUMBER,
510: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,