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_SETUPPDTTEMPLATES_PVT dependencies on OKL_PDT_TEMPLATES_V

Line 69: -- PROCEDURE get_rec for: OKL_PDT_TEMPLATES_V

65:
66: END get_version;
67:
68: ---------------------------------------------------------------------------
69: -- PROCEDURE get_rec for: OKL_PDT_TEMPLATES_V
70: ---------------------------------------------------------------------------
71: PROCEDURE get_rec (
72: p_ptlv_rec IN ptlv_rec_type,
73: x_return_status OUT NOCOPY VARCHAR2,

Line 91: FROM Okl_Pdt_Templates_V

87: CREATION_DATE,
88: LAST_UPDATED_BY,
89: LAST_UPDATE_DATE,
90: NVL(LAST_UPDATE_LOGIN, Okl_Api.G_MISS_NUM) LAST_UPDATE_LOGIN
91: FROM Okl_Pdt_Templates_V
92: WHERE okl_pdt_templates_v.id = p_id;
93: l_okl_ptlv_pk okl_ptlv_pk_csr%ROWTYPE;
94: l_ptlv_rec ptlv_rec_type;
95: BEGIN

Line 92: WHERE okl_pdt_templates_v.id = p_id;

88: LAST_UPDATED_BY,
89: LAST_UPDATE_DATE,
90: NVL(LAST_UPDATE_LOGIN, Okl_Api.G_MISS_NUM) LAST_UPDATE_LOGIN
91: FROM Okl_Pdt_Templates_V
92: WHERE okl_pdt_templates_v.id = p_id;
93: l_okl_ptlv_pk okl_ptlv_pk_csr%ROWTYPE;
94: l_ptlv_rec ptlv_rec_type;
95: BEGIN
96: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 214: -- PROCEDURE check_constraints for: OKL_PDT_TEMPLATES_V

210:
211: END check_overlaps;
212:
213: ---------------------------------------------------------------------------
214: -- PROCEDURE check_constraints for: OKL_PDT_TEMPLATES_V
215: -- To verify whether the dates are valid in the following entities
216: -- 1. Product
217: -- 2. Contract
218: -- 3. Product Template Quality

Line 228: CURSOR okl_products_csr (p_ptl_id IN Okl_Pdt_Templates_V.ID%TYPE,

224: p_ptlv_rec IN ptlv_rec_type,
225: x_return_status OUT NOCOPY VARCHAR2,
226: x_valid OUT NOCOPY BOOLEAN
227: ) IS
228: CURSOR okl_products_csr (p_ptl_id IN Okl_Pdt_Templates_V.ID%TYPE,
229: p_from_date IN Okl_Pdt_Templates_V.FROM_DATE%TYPE,
230: p_to_date IN Okl_Pdt_Templates_V.TO_DATE%TYPE
231: ) IS
232:

Line 229: p_from_date IN Okl_Pdt_Templates_V.FROM_DATE%TYPE,

225: x_return_status OUT NOCOPY VARCHAR2,
226: x_valid OUT NOCOPY BOOLEAN
227: ) IS
228: CURSOR okl_products_csr (p_ptl_id IN Okl_Pdt_Templates_V.ID%TYPE,
229: p_from_date IN Okl_Pdt_Templates_V.FROM_DATE%TYPE,
230: p_to_date IN Okl_Pdt_Templates_V.TO_DATE%TYPE
231: ) IS
232:
233: SELECT '1'

Line 230: p_to_date IN Okl_Pdt_Templates_V.TO_DATE%TYPE

226: x_valid OUT NOCOPY BOOLEAN
227: ) IS
228: CURSOR okl_products_csr (p_ptl_id IN Okl_Pdt_Templates_V.ID%TYPE,
229: p_from_date IN Okl_Pdt_Templates_V.FROM_DATE%TYPE,
230: p_to_date IN Okl_Pdt_Templates_V.TO_DATE%TYPE
231: ) IS
232:
233: SELECT '1'
234: FROM Okl_Products_V pdt

Line 240: CURSOR okl_ptl_constraints_csr (p_ptl_id IN Okl_Pdt_Templates_V.ID%TYPE,

236: AND (pdt.FROM_DATE < p_from_date OR
237: NVL(pdt.TO_DATE, pdt.FROM_DATE) > p_to_date);
238:
239:
240: CURSOR okl_ptl_constraints_csr (p_ptl_id IN Okl_Pdt_Templates_V.ID%TYPE,
241: p_from_date IN Okl_Pdt_Templates_V.FROM_DATE%TYPE,
242: p_to_date IN Okl_Pdt_Templates_V.TO_DATE%TYPE
243: ) IS
244: SELECT '1'

Line 241: p_from_date IN Okl_Pdt_Templates_V.FROM_DATE%TYPE,

237: NVL(pdt.TO_DATE, pdt.FROM_DATE) > p_to_date);
238:
239:
240: CURSOR okl_ptl_constraints_csr (p_ptl_id IN Okl_Pdt_Templates_V.ID%TYPE,
241: p_from_date IN Okl_Pdt_Templates_V.FROM_DATE%TYPE,
242: p_to_date IN Okl_Pdt_Templates_V.TO_DATE%TYPE
243: ) IS
244: SELECT '1'
245: FROM Okl_Ptq_Values_V ptv,

Line 242: p_to_date IN Okl_Pdt_Templates_V.TO_DATE%TYPE

238:
239:
240: CURSOR okl_ptl_constraints_csr (p_ptl_id IN Okl_Pdt_Templates_V.ID%TYPE,
241: p_from_date IN Okl_Pdt_Templates_V.FROM_DATE%TYPE,
242: p_to_date IN Okl_Pdt_Templates_V.TO_DATE%TYPE
243: ) IS
244: SELECT '1'
245: FROM Okl_Ptq_Values_V ptv,
246: Okl_Ptl_Ptq_Vals_V pmv

Line 270: l_to_date okl_pdt_templates_v.TO_DATE%TYPE;

266: l_token_4 VARCHAR2(1999);
267: l_token_5 VARCHAR2(1999);
268:
269: l_row_not_found BOOLEAN := FALSE;
270: l_to_date okl_pdt_templates_v.TO_DATE%TYPE;
271:
272: BEGIN
273: x_valid := TRUE;
274: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 484: p_table => 'Okl_Pdt_Templates_V',

480: /*check_overlaps(p_id => l_upd_ptlv_rec.id,
481: p_name => l_ptlv_rec.name,
482: p_from_date => l_ptlv_rec.from_date,
483: p_to_date => l_ptlv_rec.TO_DATE,
484: p_table => 'Okl_Pdt_Templates_V',
485: x_return_status => l_return_status,
486: x_valid => l_valid);
487: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
488: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 535: -- PROCEDURE determine_action for: OKL_PDT_TEMPLATES_V

531:
532: END check_updates;
533:
534: ---------------------------------------------------------------------------
535: -- PROCEDURE determine_action for: OKL_PDT_TEMPLATES_V
536: -- This function helps in determining the various checks to be performed
537: -- for the new/updated record and also helps in determining whether a new
538: -- version is required or not
539: ---------------------------------------------------------------------------

Line 567: -- PROCEDURE get_ptl_ptq_vals for: OKL_PDT_TEMPLATES_V

563: RETURN(l_action);
564: END determine_action;
565:
566: ---------------------------------------------------------------------------
567: -- PROCEDURE get_ptl_ptq_vals for: OKL_PDT_TEMPLATES_V
568: -- To fetch the template qualities/values that are attached to the existing
569: -- version of the product template
570: ---------------------------------------------------------------------------
571: PROCEDURE get_ptl_ptq_vals (p_upd_ptlv_rec IN ptlv_rec_type,

Line 638: -- PROCEDURE get_pdt_pqys for: OKL_PDT_TEMPLATES_V

634:
635: END get_ptl_ptq_vals;
636:
637: ---------------------------------------------------------------------------
638: -- PROCEDURE get_pdt_pqys for: OKL_PDT_TEMPLATES_V
639: -- To fetch the product qualities that are attached to the existing
640: -- version of the product template
641: ---------------------------------------------------------------------------
642: PROCEDURE get_pdt_pqys (p_upd_ptlv_rec IN ptlv_rec_type,

Line 707: -- PROCEDURE copy_update_constraints for: OKL_PDT_TEMPLATES_V

703:
704: END get_pdt_pqys;
705:
706: ---------------------------------------------------------------------------
707: -- PROCEDURE copy_update_constraints for: OKL_PDT_TEMPLATES_V
708: -- To copy constraints data from one version to the other
709: ---------------------------------------------------------------------------
710: PROCEDURE copy_update_constraints (p_api_version IN NUMBER,
711: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 837: -- PROCEDURE insert_pdttemplates for: OKL_PDT_TEMPLATES_V

833:
834: END copy_update_constraints;
835:
836: ---------------------------------------------------------------------------
837: -- PROCEDURE insert_pdttemplates for: OKL_PDT_TEMPLATES_V
838: ---------------------------------------------------------------------------
839: PROCEDURE insert_pdttemplates(p_api_version IN NUMBER,
840: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
841: x_return_status OUT NOCOPY VARCHAR2,

Line 848: CURSOR c1(p_name okl_pdt_templates_v.name%TYPE,

844: p_ptlv_rec IN ptlv_rec_type,
845: x_ptlv_rec OUT NOCOPY ptlv_rec_type
846: ) IS
847:
848: CURSOR c1(p_name okl_pdt_templates_v.name%TYPE,
849: p_version okl_pdt_templates_v.version%TYPE) IS
850: SELECT '1'
851: FROM okl_pdt_templates_v
852: WHERE name = p_name;

Line 849: p_version okl_pdt_templates_v.version%TYPE) IS

845: x_ptlv_rec OUT NOCOPY ptlv_rec_type
846: ) IS
847:
848: CURSOR c1(p_name okl_pdt_templates_v.name%TYPE,
849: p_version okl_pdt_templates_v.version%TYPE) IS
850: SELECT '1'
851: FROM okl_pdt_templates_v
852: WHERE name = p_name;
853:

Line 851: FROM okl_pdt_templates_v

847:
848: CURSOR c1(p_name okl_pdt_templates_v.name%TYPE,
849: p_version okl_pdt_templates_v.version%TYPE) IS
850: SELECT '1'
851: FROM okl_pdt_templates_v
852: WHERE name = p_name;
853:
854: l_name okl_pdt_templates_v.name%TYPE;
855: l_unq_tbl Okc_Util.unq_tbl_type;

Line 854: l_name okl_pdt_templates_v.name%TYPE;

850: SELECT '1'
851: FROM okl_pdt_templates_v
852: WHERE name = p_name;
853:
854: l_name okl_pdt_templates_v.name%TYPE;
855: l_unq_tbl Okc_Util.unq_tbl_type;
856: l_token_1 VARCHAR2(1999);
857: l_pdt_status VARCHAR2(1);
858: l_row_found BOOLEAN := FALSE;

Line 951: -- PROCEDURE update_pdttemplates for: OKL_PDT_TEMPLATES_V

947:
948: END insert_pdttemplates;
949:
950: ---------------------------------------------------------------------------
951: -- PROCEDURE update_pdttemplates for: OKL_PDT_TEMPLATES_V
952: ---------------------------------------------------------------------------
953: PROCEDURE update_pdttemplates(p_api_version IN NUMBER,
954: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
955: x_return_status OUT NOCOPY VARCHAR2,