APPS.OKL_PROCESS_TMPT_SET_PVT dependencies on OKL_AE_TEMPLATES

Line 123: FROM OKL_AE_TEMPLATES

119:
120: CURSOR avl_csr(v_name VARCHAR2, v_aes_id NUMBER) IS
121: SELECT start_date,
122: end_date
123: FROM OKL_AE_TEMPLATES
124: WHERE NAME = v_name
125: AND aes_id = v_aes_id;
126:
127: exist_rec avl_csr%ROWTYPE;

Line 200: FROM OKL_AE_TEMPLATES

196:
197: CURSOR avl_csr IS
198: SELECT start_date,
199: end_date
200: FROM OKL_AE_TEMPLATES
201: WHERE nvl(sty_id,OKL_API.G_MISS_NUM)
202: = nvl(p_avlv_rec.sty_id,OKL_API.G_MISS_NUM) AND
203: nvl(try_id,OKL_API.G_MISS_NUM)
204: = nvl(p_avlv_rec.try_id,OKL_API.G_MISS_NUM) AND

Line 293: FROM OKL_AE_TEMPLATES

289:
290: CURSOR avl_csr IS
291: SELECT start_date,
292: end_date
293: FROM OKL_AE_TEMPLATES
294: WHERE nvl(sty_id,OKL_API.G_MISS_NUM)
295: = nvl(p_avlv_rec.sty_id,OKL_API.G_MISS_NUM) AND
296: nvl(try_id,OKL_API.G_MISS_NUM)
297: = nvl(p_avlv_rec.try_id,OKL_API.G_MISS_NUM) AND

Line 430: FROM OKL_AE_TEMPLATES

426: CREATION_DATE,
427: LAST_UPDATED_BY,
428: LAST_UPDATE_DATE,
429: LAST_UPDATE_LOGIN
430: FROM OKL_AE_TEMPLATES
431: WHERE OKL_AE_TEMPLATES.id = p_id;
432:
433: l_okl_avlv_pk okl_avlv_pk_csr%ROWTYPE;
434: l_avlv_rec avlv_rec_type;

Line 431: WHERE OKL_AE_TEMPLATES.id = p_id;

427: LAST_UPDATED_BY,
428: LAST_UPDATE_DATE,
429: LAST_UPDATE_LOGIN
430: FROM OKL_AE_TEMPLATES
431: WHERE OKL_AE_TEMPLATES.id = p_id;
432:
433: l_okl_avlv_pk okl_avlv_pk_csr%ROWTYPE;
434: l_avlv_rec avlv_rec_type;
435:

Line 888: FROM OKL_AE_TEMPLATES

884:
885:
886: CURSOR avl_csr(v_name VARCHAR2) IS
887: SELECT nvl(max(version),0)
888: FROM OKL_AE_TEMPLATES
889: WHERE name = v_name;
890:
891: CURSOR atl_csr(v_avl_id NUMBER) IS
892: SELECT SEQUENCE_NUMBER,

Line 924: l_name OKL_AE_TEMPLATES.NAME%TYPE;

920: l_atlv_tbl ATLV_TBL_TYPE;
921: x_atlv_tbl ATLV_TBL_TYPE;
922:
923: i NUMBER := 0;
924: l_name OKL_AE_TEMPLATES.NAME%TYPE;
925: l_max_version NUMBER := 0;
926: p_api_version NUMBER := 1.0;
927: p_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
928: x_msg_count NUMBER := 0;

Line 1042: FROM OKL_AE_TEMPLATES

1038:
1039:
1040: CURSOR avl_csr(v_name VARCHAR2) IS
1041: SELECT nvl(max(version),0)
1042: FROM OKL_AE_TEMPLATES
1043: WHERE name = v_name;
1044:
1045: CURSOR atl_csr(v_id NUMBER) IS
1046: SELECT AVL_ID

Line 1059: l_name OKL_AE_TEMPLATES.NAME%TYPE;

1055: l_atlv_tbl_out ATLV_TBL_TYPE;
1056: x_atlv_tbl ATLV_TBL_TYPE;
1057:
1058: i NUMBER := 0;
1059: l_name OKL_AE_TEMPLATES.NAME%TYPE;
1060: l_max_version NUMBER := 0;
1061: p_api_version NUMBER := 1.0;
1062: p_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
1063: x_msg_count NUMBER := 0;

Line 1761: FROM OKL_AE_TEMPLATES

1757: l_avlv_rec AVLV_REC_TYPE;
1758:
1759: CURSOR avl_csr(v_name VARCHAR2, v_aes_id NUMBER) IS
1760: SELECT nvl(max(version),0)
1761: FROM OKL_AE_TEMPLATES
1762: WHERE NAME = v_name AND
1763: AES_ID = v_aes_id ;
1764:
1765:

Line 1984: FROM OKL_AE_TEMPLATES

1980: ATTRIBUTE12,
1981: ATTRIBUTE13,
1982: ATTRIBUTE14,
1983: ATTRIBUTE15
1984: FROM OKL_AE_TEMPLATES
1985: WHERE ID = v_id;
1986:
1987: CURSOR dist_csr(v_avl_id NUMBER ) IS
1988: SELECT ID

Line 2550: FROM OKL_AE_TEMPLATES

2546: CURSOR avl_csr(v_atl_id NUMBER) IS
2547: SELECT ID,
2548: start_date,
2549: end_date
2550: FROM OKL_AE_TEMPLATES
2551: WHERE ID = (SELECT avl_id FROM OKL_AE_TMPT_LNES
2552: WHERE ID = v_atl_id);
2553:
2554: l_start_date DATE;

Line 3015: FROM okl_ae_templates

3011: ,attribute12
3012: ,attribute13
3013: ,attribute14
3014: ,attribute15
3015: FROM okl_ae_templates
3016: WHERE aes_id = v_aes_id;
3017:
3018:
3019: CURSOR atl_csr(v_avl_id NUMBER) IS