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_SETUPPQUALITYS_PVT dependencies on OKL_PDT_QUALITYS_V

Line 10: -- PROCEDURE get_rec for: OKL_PDT_QUALITYS_V

6: G_UNQS CONSTANT VARCHAR2(200) := 'OKL_NOT_UNIQUE'; --- CHG001
7: G_TABLE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_TABLE_NAME'; --- CHG001
8:
9: ---------------------------------------------------------------------------
10: -- PROCEDURE get_rec for: OKL_PDT_QUALITYS_V
11: ---------------------------------------------------------------------------
12: PROCEDURE get_rec (
13: p_pqyv_rec IN pqyv_rec_type,
14: x_no_data_found OUT NOCOPY BOOLEAN,

Line 32: FROM Okl_Pdt_Qualitys_V

28: CREATION_DATE,
29: LAST_UPDATED_BY,
30: LAST_UPDATE_DATE,
31: LAST_UPDATE_LOGIN
32: FROM Okl_Pdt_Qualitys_V
33: WHERE okl_pdt_qualitys_v.id = p_id;
34: l_okl_pqyv_pk okl_pqyv_pk_csr%ROWTYPE;
35: l_pqyv_rec pqyv_rec_type;
36: BEGIN

Line 33: WHERE okl_pdt_qualitys_v.id = p_id;

29: LAST_UPDATED_BY,
30: LAST_UPDATE_DATE,
31: LAST_UPDATE_LOGIN
32: FROM Okl_Pdt_Qualitys_V
33: WHERE okl_pdt_qualitys_v.id = p_id;
34: l_okl_pqyv_pk okl_pqyv_pk_csr%ROWTYPE;
35: l_pqyv_rec pqyv_rec_type;
36: BEGIN
37: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 130: -- PROCEDURE check_constraints for: OKL_PDT_QUALITYS_V

126:
127: END get_pqy_values;
128:
129: ---------------------------------------------------------------------------
130: -- PROCEDURE check_constraints for: OKL_PDT_QUALITYS_V
131: -- To verify whether the dates are valid for both PRODUCT TEMPLATE VALUE and
132: -- PRODUCT TEMPLATE QUALITY VALUE -- attached to it
133: ---------------------------------------------------------------------------
134:

Line 140: CURSOR okl_pqy_constraints_csr (p_pqy_id IN Okl_Pdt_Qualitys_V.ID%TYPE,

136: p_pqyv_rec IN pqyv_rec_type,
137: x_return_status OUT NOCOPY VARCHAR2,
138: x_valid OUT NOCOPY BOOLEAN
139: ) IS
140: CURSOR okl_pqy_constraints_csr (p_pqy_id IN Okl_Pdt_Qualitys_V.ID%TYPE,
141: p_from_date IN Okl_Pdt_Qualitys_V.FROM_DATE%TYPE,
142: p_to_date IN Okl_Pdt_Qualitys_V.TO_DATE%TYPE
143: ) IS
144: SELECT '1'

Line 141: p_from_date IN Okl_Pdt_Qualitys_V.FROM_DATE%TYPE,

137: x_return_status OUT NOCOPY VARCHAR2,
138: x_valid OUT NOCOPY BOOLEAN
139: ) IS
140: CURSOR okl_pqy_constraints_csr (p_pqy_id IN Okl_Pdt_Qualitys_V.ID%TYPE,
141: p_from_date IN Okl_Pdt_Qualitys_V.FROM_DATE%TYPE,
142: p_to_date IN Okl_Pdt_Qualitys_V.TO_DATE%TYPE
143: ) IS
144: SELECT '1'
145: FROM Okl_Pqy_Values_V qve

Line 142: p_to_date IN Okl_Pdt_Qualitys_V.TO_DATE%TYPE

138: x_valid OUT NOCOPY BOOLEAN
139: ) IS
140: CURSOR okl_pqy_constraints_csr (p_pqy_id IN Okl_Pdt_Qualitys_V.ID%TYPE,
141: p_from_date IN Okl_Pdt_Qualitys_V.FROM_DATE%TYPE,
142: p_to_date IN Okl_Pdt_Qualitys_V.TO_DATE%TYPE
143: ) IS
144: SELECT '1'
145: FROM Okl_Pqy_Values_V qve
146: WHERE qve.pqy_id = p_pqy_id

Line 535: -- PROCEDURE determine_action for: Okl_pdt_Qualitys_v

531:
532: END check_updates;
533:
534: ---------------------------------------------------------------------------
535: -- PROCEDURE determine_action for: Okl_pdt_Qualitys_v
536: -- This function helps in determining the various checks to be performed
537: -- for the new/updated record.
538: ---------------------------------------------------------------------------
539: FUNCTION determine_action (

Line 627: -- PROCEDURE insert_pqualities for: Okl_pdt_Qualitys_v

623:
624: END copy_update_constraints;
625:
626: -----------------------------------------------------------------------------
627: -- PROCEDURE insert_pqualities for: Okl_pdt_Qualitys_v
628: -----------------------------------------------------------------------------
629:
630: PROCEDURE insert_pqualitys(p_api_version IN NUMBER,
631: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 638: CURSOR okl_pdt_quality_unique (p_unique OKL_PDT_QUALITYS_v.NAME%TYPE) IS

634: x_msg_data OUT NOCOPY VARCHAR2,
635: p_pqyv_rec IN pqyv_rec_type,
636: x_pqyv_rec OUT NOCOPY pqyv_rec_type
637: ) IS
638: CURSOR okl_pdt_quality_unique (p_unique OKL_PDT_QUALITYS_v.NAME%TYPE) IS
639: SELECT '1'
640: FROM OKL_PDT_QUALITYS_v
641: WHERE NAME = p_unique;
642:

Line 640: FROM OKL_PDT_QUALITYS_v

636: x_pqyv_rec OUT NOCOPY pqyv_rec_type
637: ) IS
638: CURSOR okl_pdt_quality_unique (p_unique OKL_PDT_QUALITYS_v.NAME%TYPE) IS
639: SELECT '1'
640: FROM OKL_PDT_QUALITYS_v
641: WHERE NAME = p_unique;
642:
643: l_unique_key OKL_PDT_QUALITYS_v.NAME%TYPE;
644: l_row_found BOOLEAN := FALSE;

Line 643: l_unique_key OKL_PDT_QUALITYS_v.NAME%TYPE;

639: SELECT '1'
640: FROM OKL_PDT_QUALITYS_v
641: WHERE NAME = p_unique;
642:
643: l_unique_key OKL_PDT_QUALITYS_v.NAME%TYPE;
644: l_row_found BOOLEAN := FALSE;
645: l_token_1 VARCHAR2(1999);
646: l_api_version CONSTANT NUMBER := 1;
647: l_api_name CONSTANT VARCHAR2(30) := 'insert_tqualities';

Line 761: -- PROCEDURE update_pqualities for: Okl_pdt_Qualitys_v

757:
758: END insert_pqualitys;
759:
760: ---------------------------------------------------------------------------
761: -- PROCEDURE update_pqualities for: Okl_pdt_Qualitys_v
762: ---------------------------------------------------------------------------
763: PROCEDURE update_pqualitys(p_api_version IN NUMBER,
764: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
765: x_return_status OUT NOCOPY VARCHAR2,