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_SETUPTQUALITYS_PVT dependencies on OKL_PTL_QUALITYS_V

Line 12: -- PROCEDURE get_rec for: OKL_PTL_QUALITYS_V

8: G_UNQS CONSTANT VARCHAR2(200) := 'OKL_NOT_UNIQUE'; --- CHG001
9: G_TABLE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_TABLE_NAME'; --- CHG001
10:
11: ---------------------------------------------------------------------------
12: -- PROCEDURE get_rec for: OKL_PTL_QUALITYS_V
13: ---------------------------------------------------------------------------
14:
15: PROCEDURE get_rec (
16: p_ptqv_rec IN ptqv_rec_type,

Line 34: FROM Okl_Ptl_Qualitys_v

30: CREATION_DATE,
31: LAST_UPDATED_BY,
32: LAST_UPDATE_DATE,
33: LAST_UPDATE_LOGIN
34: FROM Okl_Ptl_Qualitys_v
35: WHERE id = p_id;
36: l_okl_ptl_qualitys_pk okl_ptl_qualitys_pk_csr%ROWTYPE;
37: l_ptqv_rec ptqv_rec_type;
38: BEGIN

Line 131: -- PROCEDURE validate_constraints for: OKL_PTL_QUALITYS_V

127:
128: END get_ptq_values;
129:
130: ---------------------------------------------------------------------------
131: -- PROCEDURE validate_constraints for: OKL_PTL_QUALITYS_V
132: -- To verify whether the dates are valid for both PRODUCT TEMPLATE VALUE and
133: -- PRODUCT TEMPLATE QUALITY VALUE -- attached to it
134: ---------------------------------------------------------------------------
135:

Line 141: CURSOR okl_ptq_constraints_csr (p_ptq_id IN Okl_ptl_qualitys_V.ID%TYPE,

137: p_ptqv_rec IN ptqv_rec_type,
138: x_return_status OUT NOCOPY VARCHAR2,
139: x_valid OUT NOCOPY BOOLEAN
140: ) IS
141: CURSOR okl_ptq_constraints_csr (p_ptq_id IN Okl_ptl_qualitys_V.ID%TYPE,
142: p_from_date IN Okl_ptl_Qualitys_V.FROM_DATE%TYPE,
143: p_to_date IN Okl_ptl_Qualitys_V.TO_DATE%TYPE
144: ) IS
145: SELECT '1'

Line 142: p_from_date IN Okl_ptl_Qualitys_V.FROM_DATE%TYPE,

138: x_return_status OUT NOCOPY VARCHAR2,
139: x_valid OUT NOCOPY BOOLEAN
140: ) IS
141: CURSOR okl_ptq_constraints_csr (p_ptq_id IN Okl_ptl_qualitys_V.ID%TYPE,
142: p_from_date IN Okl_ptl_Qualitys_V.FROM_DATE%TYPE,
143: p_to_date IN Okl_ptl_Qualitys_V.TO_DATE%TYPE
144: ) IS
145: SELECT '1'
146: FROM OKL_ptq_values_V ptv

Line 143: p_to_date IN Okl_ptl_Qualitys_V.TO_DATE%TYPE

139: x_valid OUT NOCOPY BOOLEAN
140: ) IS
141: CURSOR okl_ptq_constraints_csr (p_ptq_id IN Okl_ptl_qualitys_V.ID%TYPE,
142: p_from_date IN Okl_ptl_Qualitys_V.FROM_DATE%TYPE,
143: p_to_date IN Okl_ptl_Qualitys_V.TO_DATE%TYPE
144: ) IS
145: SELECT '1'
146: FROM OKL_ptq_values_V ptv
147: WHERE ptv.ptq_id = p_ptq_id

Line 157: CURSOR c1(p_name okl_ptl_qualitys_v.name%TYPE) IS

153: WHERE pmv.ptq_id = p_ptq_id
154: AND (pmv.FROM_DATE < p_from_date OR
155: NVL(pmv.TO_DATE, pmv.FROM_DATE) > p_to_date);
156:
157: CURSOR c1(p_name okl_ptl_qualitys_v.name%TYPE) IS
158: SELECT '1'
159: FROM okl_ptl_qualitys_v
160: WHERE name = p_name;
161: -- AND id <> NVL(p_ptqv_rec.id,-9999);

Line 159: FROM okl_ptl_qualitys_v

155: NVL(pmv.TO_DATE, pmv.FROM_DATE) > p_to_date);
156:
157: CURSOR c1(p_name okl_ptl_qualitys_v.name%TYPE) IS
158: SELECT '1'
159: FROM okl_ptl_qualitys_v
160: WHERE name = p_name;
161: -- AND id <> NVL(p_ptqv_rec.id,-9999);
162:
163: l_token_1 VARCHAR2(999);

Line 594: -- PROCEDURE copy_update_constraints for: OKL_PTL_QUALITYS_V

590: END determine_action;
591:
592:
593: ---------------------------------------------------------------------------
594: -- PROCEDURE copy_update_constraints for: OKL_PTL_QUALITYS_V
595: ---------------------------------------------------------------------------
596: PROCEDURE copy_update_constraints (p_api_version IN NUMBER,
597: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
598: p_upd_ptqv_rec IN ptqv_rec_type,

Line 663: -- PROCEDURE insert_tqualitys for: Okl_Ptl_Qualitys_v

659: END copy_update_constraints;
660:
661:
662: ---------------------------------------------------------------------------
663: -- PROCEDURE insert_tqualitys for: Okl_Ptl_Qualitys_v
664: ---------------------------------------------------------------------------
665:
666: PROCEDURE insert_tqualitys(p_api_version IN NUMBER,
667: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 675: CURSOR c1(p_name okl_ptl_qualitys_v.name%TYPE) IS

671: p_ptqv_rec IN ptqv_rec_type,
672: x_ptqv_rec OUT NOCOPY ptqv_rec_type
673: ) IS
674:
675: CURSOR c1(p_name okl_ptl_qualitys_v.name%TYPE) IS
676: SELECT '1'
677: FROM okl_ptl_qualitys_v
678: WHERE name = p_name;
679: -- AND id <> NVL(p_ptqv_rec.id,-9999);

Line 677: FROM okl_ptl_qualitys_v

673: ) IS
674:
675: CURSOR c1(p_name okl_ptl_qualitys_v.name%TYPE) IS
676: SELECT '1'
677: FROM okl_ptl_qualitys_v
678: WHERE name = p_name;
679: -- AND id <> NVL(p_ptqv_rec.id,-9999);
680:
681: l_token_1 VARCHAR2(1999);

Line 786: -- PROCEDURE update_tqualitys for: Okl_Ptl_Qualitys_v

782:
783: END insert_tqualitys;
784:
785: ---------------------------------------------------------------------------
786: -- PROCEDURE update_tqualitys for: Okl_Ptl_Qualitys_v
787: ---------------------------------------------------------------------------
788: PROCEDURE update_tqualitys(p_api_version IN NUMBER,
789: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
790: x_return_status OUT NOCOPY VARCHAR2,