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_PTM_PVT dependencies on OKL_PROCESS_TMPLTS_B

Line 121: FROM okl_process_tmplts_b

117: l_org_id_original NUMBER;
118:
119: CURSOR c_ptmv_org IS
120: SELECT NVL(org_id, -99)
121: FROM okl_process_tmplts_b
122: WHERE id = p_ptmv_rec.id;
123:
124: BEGIN
125:

Line 421: FROM okl_process_tmplts_b

417: l_start_date DATE;
418:
419: CURSOR c_check_dates IS
420: SELECT start_date
421: FROM okl_process_tmplts_b
422: WHERE ptm_code = p_ptmv_rec.ptm_code
423: AND recipient_type_code = p_ptmv_rec.recipient_type_code
424: AND xml_tmplt_code = p_ptmv_rec.xml_tmplt_code
425: AND id <> p_ptmv_rec.id

Line 432: FROM okl_process_tmplts_b

428:
429:
430: CURSOR c_ptmv_uk IS
431: SELECT 1
432: FROM okl_process_tmplts_b
433: WHERE ptm_code = p_ptmv_rec.ptm_code AND
434: recipient_type_code = p_ptmv_rec.recipient_type_code AND
435: xml_tmplt_code = p_ptmv_rec.xml_tmplt_code AND
436: id <> p_ptmv_rec.id AND

Line 514: FROM okl_process_tmplts_b

510: x_return_status OUT NOCOPY VARCHAR2) IS
511:
512: CURSOR c_ptmv_sdate IS
513: SELECT TRUNC(start_date)
514: FROM okl_process_tmplts_b
515: WHERE id = p_ptmv_rec.id;
516:
517: l_start_date DATE;
518:

Line 683: -- FUNCTION get_rec for: okl_process_tmplts_b

679: END add_language;
680:
681:
682: ---------------------------------------------------------------------------
683: -- FUNCTION get_rec for: okl_process_tmplts_b
684: ---------------------------------------------------------------------------
685: FUNCTION get_rec (p_ptm_rec IN ptm_rec_type,
686: x_no_data_found OUT NOCOPY BOOLEAN) RETURN ptm_rec_type IS
687:

Line 688: CURSOR okl_process_tmplts_b_pk_csr (p_id IN NUMBER) IS

684: ---------------------------------------------------------------------------
685: FUNCTION get_rec (p_ptm_rec IN ptm_rec_type,
686: x_no_data_found OUT NOCOPY BOOLEAN) RETURN ptm_rec_type IS
687:
688: CURSOR okl_process_tmplts_b_pk_csr (p_id IN NUMBER) IS
689: SELECT
690: ID,
691: ORG_ID,
692: PTM_CODE,

Line 725: FROM okl_process_tmplts_b

721: */
722: RECIPIENT_TYPE_CODE,
723: XML_TMPLT_CODE
724: /* End Changes */
725: FROM okl_process_tmplts_b
726: WHERE okl_process_tmplts_b.id = p_id;
727:
728: l_ptm_rec ptm_rec_type;
729:

Line 726: WHERE okl_process_tmplts_b.id = p_id;

722: RECIPIENT_TYPE_CODE,
723: XML_TMPLT_CODE
724: /* End Changes */
725: FROM okl_process_tmplts_b
726: WHERE okl_process_tmplts_b.id = p_id;
727:
728: l_ptm_rec ptm_rec_type;
729:
730: BEGIN

Line 732: OPEN okl_process_tmplts_b_pk_csr (p_ptm_rec.id);

728: l_ptm_rec ptm_rec_type;
729:
730: BEGIN
731:
732: OPEN okl_process_tmplts_b_pk_csr (p_ptm_rec.id);
733: FETCH okl_process_tmplts_b_pk_csr INTO
734: l_ptm_rec.ID,
735: l_ptm_rec.ORG_ID,
736: l_ptm_rec.PTM_CODE,

Line 733: FETCH okl_process_tmplts_b_pk_csr INTO

729:
730: BEGIN
731:
732: OPEN okl_process_tmplts_b_pk_csr (p_ptm_rec.id);
733: FETCH okl_process_tmplts_b_pk_csr INTO
734: l_ptm_rec.ID,
735: l_ptm_rec.ORG_ID,
736: l_ptm_rec.PTM_CODE,
737: l_ptm_rec.JTF_AMV_ITEM_ID,

Line 770: x_no_data_found := okl_process_tmplts_b_pk_csr%NOTFOUND;

766: l_ptm_rec.recipient_type_code ,
767: l_ptm_rec.xml_tmplt_code
768: ;
769: /* End Changes */
770: x_no_data_found := okl_process_tmplts_b_pk_csr%NOTFOUND;
771:
772: CLOSE okl_process_tmplts_b_pk_csr;
773: RETURN(l_ptm_rec);
774: END get_rec;

Line 772: CLOSE okl_process_tmplts_b_pk_csr;

768: ;
769: /* End Changes */
770: x_no_data_found := okl_process_tmplts_b_pk_csr%NOTFOUND;
771:
772: CLOSE okl_process_tmplts_b_pk_csr;
773: RETURN(l_ptm_rec);
774: END get_rec;
775:
776: FUNCTION get_rec (p_ptm_rec IN ptm_rec_type) RETURN ptm_rec_type IS

Line 1168: FROM okl_process_tmplts_b

1164: l_start_date DATE;
1165:
1166: CURSOR c_check_dates IS
1167: SELECT start_date
1168: FROM okl_process_tmplts_b
1169: WHERE ptm_code = p_ptmv_rec.ptm_code
1170: AND jtf_amv_item_id = p_ptmv_rec.jtf_amv_item_id
1171: AND id <> p_ptmv_rec.id
1172: AND TRUNC(start_date) > TRUNC(p_ptmv_rec.start_date)

Line 1181: FROM okl_process_tmplts_b

1177: --varangan modified the cursor for bug#5020750
1178: --dkagrawa modified the cursor for bug#5083633
1179: CURSOR c_ptmv_uk IS
1180: SELECT 1
1181: FROM okl_process_tmplts_b
1182: WHERE ptm_code = p_ptmv_rec.ptm_code AND
1183: jtf_amv_item_id = p_ptmv_rec.jtf_amv_item_id AND
1184: id <> p_ptmv_rec.id AND
1185: TRUNC(start_date)<= TRUNC(p_ptmv_rec.start_date) AND

Line 1542: -- insert_row for:OKL_PROCESS_TMPLTS_B --

1538: END validate_row;
1539:
1540:
1541: -----------------------------------------
1542: -- insert_row for:OKL_PROCESS_TMPLTS_B --
1543: -----------------------------------------
1544: PROCEDURE insert_row(
1545: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1546: x_return_status OUT NOCOPY VARCHAR2,

Line 1593: INSERT INTO OKL_PROCESS_TMPLTS_B(

1589: END IF;
1590:
1591:
1592:
1593: INSERT INTO OKL_PROCESS_TMPLTS_B(
1594: id,
1595: org_id,
1596: ptm_code,
1597: jtf_amv_item_id,

Line 2103: -- lock_row for: OKL_PROCESS_TMPLTS_B --

2099: END insert_row;
2100:
2101:
2102: ---------------------------------------
2103: -- lock_row for: OKL_PROCESS_TMPLTS_B --
2104: ---------------------------------------
2105: PROCEDURE lock_row(
2106: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2107: x_return_status OUT NOCOPY VARCHAR2,

Line 2116: FROM OKL_PROCESS_TMPLTS_B

2112: E_Resource_Busy EXCEPTION;
2113: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2114: CURSOR lock_csr (p_ptm_rec IN ptm_rec_type) IS
2115: SELECT OBJECT_VERSION_NUMBER
2116: FROM OKL_PROCESS_TMPLTS_B
2117: WHERE ID = p_ptm_rec.id
2118: AND OBJECT_VERSION_NUMBER = p_ptm_rec.object_version_number
2119: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2120:

Line 2123: FROM okl_process_tmplts_b

2119: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2120:
2121: CURSOR lchk_csr (p_ptm_rec IN ptm_rec_type) IS
2122: SELECT OBJECT_VERSION_NUMBER
2123: FROM okl_process_tmplts_b
2124: WHERE ID = p_ptm_rec.id;
2125: l_api_version CONSTANT NUMBER := 1;
2126: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2127: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 2128: l_object_version_number okl_process_tmplts_b.OBJECT_VERSION_NUMBER%TYPE;

2124: WHERE ID = p_ptm_rec.id;
2125: l_api_version CONSTANT NUMBER := 1;
2126: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2127: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2128: l_object_version_number okl_process_tmplts_b.OBJECT_VERSION_NUMBER%TYPE;
2129: lc_object_version_number okl_process_tmplts_b.OBJECT_VERSION_NUMBER%TYPE;
2130: l_row_notfound BOOLEAN := FALSE;
2131: lc_row_notfound BOOLEAN := FALSE;
2132: BEGIN

Line 2129: lc_object_version_number okl_process_tmplts_b.OBJECT_VERSION_NUMBER%TYPE;

2125: l_api_version CONSTANT NUMBER := 1;
2126: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2127: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2128: l_object_version_number okl_process_tmplts_b.OBJECT_VERSION_NUMBER%TYPE;
2129: lc_object_version_number okl_process_tmplts_b.OBJECT_VERSION_NUMBER%TYPE;
2130: l_row_notfound BOOLEAN := FALSE;
2131: lc_row_notfound BOOLEAN := FALSE;
2132: BEGIN
2133: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 2458: -- update_row for:OKL_PROCESS_TMPLTS_B --

2454: END lock_row;
2455:
2456:
2457: -----------------------------------------
2458: -- update_row for:OKL_PROCESS_TMPLTS_B --
2459: -----------------------------------------
2460: PROCEDURE update_row(
2461: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2462: x_return_status OUT NOCOPY VARCHAR2,

Line 2658: UPDATE OKL_PROCESS_TMPLTS_B

2654: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2655: RAISE OKL_API.G_EXCEPTION_ERROR;
2656: END IF;
2657:
2658: UPDATE OKL_PROCESS_TMPLTS_B
2659: SET ORG_ID = l_def_ptm_rec.org_id,
2660: PTM_CODE = l_def_ptm_rec.ptm_code,
2661: JTF_AMV_ITEM_ID = l_def_ptm_rec.jtf_amv_item_id,
2662: START_DATE = l_def_ptm_rec.start_date,

Line 3311: -- delete_row for:OKL_PROCESS_TMPLTS_B --

3307: END update_row;
3308:
3309:
3310: -----------------------------------------
3311: -- delete_row for:OKL_PROCESS_TMPLTS_B --
3312: -----------------------------------------
3313: PROCEDURE delete_row(
3314: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
3315: x_return_status OUT NOCOPY VARCHAR2,

Line 3339: DELETE FROM OKL_PROCESS_TMPLTS_B

3335: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3336: RAISE OKL_API.G_EXCEPTION_ERROR;
3337: END IF;
3338:
3339: DELETE FROM OKL_PROCESS_TMPLTS_B
3340: WHERE ID = l_ptm_rec.id;
3341:
3342: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
3343: