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_PFC_PVT dependencies on OKL_PRTFL_CNTRCTS_V

Line 163: -- FUNCTION get_rec for: OKL_PRTFL_CNTRCTS_V

159: );
160: END add_language;
161:
162: ---------------------------------------------------------------------------
163: -- FUNCTION get_rec for: OKL_PRTFL_CNTRCTS_V
164: ---------------------------------------------------------------------------
165: FUNCTION get_rec (
166: p_pfcv_rec IN pfcv_rec_type,
167: x_no_data_found OUT NOCOPY BOOLEAN

Line 203: FROM Okl_Prtfl_Cntrcts_V

199: CREATION_DATE,
200: LAST_UPDATED_BY,
201: LAST_UPDATE_DATE,
202: LAST_UPDATE_LOGIN
203: FROM Okl_Prtfl_Cntrcts_V
204: WHERE okl_prtfl_cntrcts_v.id = p_id;
205: l_okl_pfcv_pk okl_pfcv_pk_csr%ROWTYPE;
206: l_pfcv_rec pfcv_rec_type;
207: BEGIN

Line 204: WHERE okl_prtfl_cntrcts_v.id = p_id;

200: LAST_UPDATED_BY,
201: LAST_UPDATE_DATE,
202: LAST_UPDATE_LOGIN
203: FROM Okl_Prtfl_Cntrcts_V
204: WHERE okl_prtfl_cntrcts_v.id = p_id;
205: l_okl_pfcv_pk okl_pfcv_pk_csr%ROWTYPE;
206: l_pfcv_rec pfcv_rec_type;
207: BEGIN
208: x_no_data_found := TRUE;

Line 464: -- FUNCTION null_out_defaults for: OKL_PRTFL_CNTRCTS_V

460: BEGIN
461: RETURN(get_rec(p_okl_prtfl_cntrcts_tl_rec, l_row_not_found));
462: END get_rec;
463: ---------------------------------------------------------------------------
464: -- FUNCTION null_out_defaults for: OKL_PRTFL_CNTRCTS_V
465: ---------------------------------------------------------------------------
466: FUNCTION null_out_defaults (
467: p_pfcv_rec IN pfcv_rec_type
468: ) RETURN pfcv_rec_type IS

Line 681: -- Validate_Attributes for:OKL_PRTFL_CNTRCTS_V --

677: ---------------------------------------------------------------------------
678: -- FUNCTION Validate_Attributes
679: ---------------------------------------------------------------------------
680: -------------------------------------------------
681: -- Validate_Attributes for:OKL_PRTFL_CNTRCTS_V --
682: -------------------------------------------------
683: FUNCTION Validate_Attributes (
684: p_pfcv_rec IN pfcv_rec_type
685: ) RETURN VARCHAR2 IS

Line 753: FROM OKL_PRTFL_CNTRCTS_V

749:
750: -- Cursor to check whether create or update mode
751: CURSOR okl_cre_upd_csr ( p_id IN NUMBER) IS
752: SELECT id, khr_id
753: FROM OKL_PRTFL_CNTRCTS_V
754: WHERE id = p_id;
755:
756: -- Cursor to get khr_id if a contract exists (create mode)
757: CURSOR okl_pfc_cre_csr ( p_khr_id IN NUMBER) IS

Line 759: FROM OKL_PRTFL_CNTRCTS_V

755:
756: -- Cursor to get khr_id if a contract exists (create mode)
757: CURSOR okl_pfc_cre_csr ( p_khr_id IN NUMBER) IS
758: SELECT khr_id
759: FROM OKL_PRTFL_CNTRCTS_V
760: WHERE khr_id = p_khr_id
761: AND id <> NVL(NULL,-999);
762:
763: -- Cursor to get khr_id if a contract exists (update mode)

Line 766: FROM OKL_PRTFL_CNTRCTS_V

762:
763: -- Cursor to get khr_id if a contract exists (update mode)
764: CURSOR okl_pfc_upd_csr ( p_id IN NUMBER, p_khr_id IN NUMBER) IS
765: SELECT khr_id
766: FROM OKL_PRTFL_CNTRCTS_V
767: WHERE khr_id = p_khr_id
768: AND id <> p_id;
769:
770: -- Cursor to get the contract number for khr_id

Line 882: -- Validate Record for:OKL_PRTFL_CNTRCTS_V --

878: ---------------------------------------------------------------------------
879: -- PROCEDURE Validate_Record
880: ---------------------------------------------------------------------------
881: ---------------------------------------------
882: -- Validate Record for:OKL_PRTFL_CNTRCTS_V --
883: ---------------------------------------------
884: FUNCTION Validate_Record (
885: p_pfcv_rec IN pfcv_rec_type,
886: p_db_pfcv_rec IN pfcv_rec_type

Line 1084: -- validate_row for:OKL_PRTFL_CNTRCTS_V --

1080: ---------------------------------------------------------------------------
1081: -- PROCEDURE validate_row
1082: ---------------------------------------------------------------------------
1083: ------------------------------------------
1084: -- validate_row for:OKL_PRTFL_CNTRCTS_V --
1085: ------------------------------------------
1086: PROCEDURE validate_row(
1087: p_api_version IN NUMBER,
1088: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1161: -- PL/SQL TBL validate_row for:OKL_PRTFL_CNTRCTS_V --

1157: '_PVT'
1158: );
1159: END validate_row;
1160: -----------------------------------------------------
1161: -- PL/SQL TBL validate_row for:OKL_PRTFL_CNTRCTS_V --
1162: -----------------------------------------------------
1163: PROCEDURE validate_row(
1164: p_api_version IN NUMBER,
1165: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1257: -- PL/SQL TBL validate_row for:OKL_PRTFL_CNTRCTS_V --

1253: );
1254: END validate_row;
1255:
1256: -----------------------------------------------------
1257: -- PL/SQL TBL validate_row for:OKL_PRTFL_CNTRCTS_V --
1258: -----------------------------------------------------
1259: PROCEDURE validate_row(
1260: p_api_version IN NUMBER,
1261: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1583: -- insert_row for :OKL_PRTFL_CNTRCTS_V --

1579: '_PVT'
1580: );
1581: END insert_row;
1582: -----------------------------------------
1583: -- insert_row for :OKL_PRTFL_CNTRCTS_V --
1584: -----------------------------------------
1585: PROCEDURE insert_row(
1586: p_api_version IN NUMBER,
1587: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1619: -- Set_Attributes for:OKL_PRTFL_CNTRCTS_V --

1615: l_pfcv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1616: RETURN(l_pfcv_rec);
1617: END fill_who_columns;
1618: --------------------------------------------
1619: -- Set_Attributes for:OKL_PRTFL_CNTRCTS_V --
1620: --------------------------------------------
1621: FUNCTION Set_Attributes (
1622: p_pfcv_rec IN pfcv_rec_type,
1623: x_pfcv_rec OUT NOCOPY pfcv_rec_type

Line 2104: -- lock_row for: OKL_PRTFL_CNTRCTS_V --

2100: '_PVT'
2101: );
2102: END lock_row;
2103: ---------------------------------------
2104: -- lock_row for: OKL_PRTFL_CNTRCTS_V --
2105: ---------------------------------------
2106: PROCEDURE lock_row(
2107: p_api_version IN NUMBER,
2108: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2786: -- update_row for:OKL_PRTFL_CNTRCTS_V --

2782: '_PVT'
2783: );
2784: END update_row;
2785: ----------------------------------------
2786: -- update_row for:OKL_PRTFL_CNTRCTS_V --
2787: ----------------------------------------
2788: PROCEDURE update_row(
2789: p_api_version IN NUMBER,
2790: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2970: -- Set_Attributes for:OKL_PRTFL_CNTRCTS_V --

2966: END IF;
2967: RETURN(l_return_status);
2968: END populate_new_record;
2969: --------------------------------------------
2970: -- Set_Attributes for:OKL_PRTFL_CNTRCTS_V --
2971: --------------------------------------------
2972: FUNCTION Set_Attributes (
2973: p_pfcv_rec IN pfcv_rec_type,
2974: x_pfcv_rec OUT NOCOPY pfcv_rec_type

Line 3404: -- delete_row for:OKL_PRTFL_CNTRCTS_V --

3400: '_PVT'
3401: );
3402: END delete_row;
3403: ----------------------------------------
3404: -- delete_row for:OKL_PRTFL_CNTRCTS_V --
3405: ----------------------------------------
3406: PROCEDURE delete_row(
3407: p_api_version IN NUMBER,
3408: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 3500: -- PL/SQL TBL delete_row for:OKL_PRTFL_CNTRCTS_V --

3496: '_PVT'
3497: );
3498: END delete_row;
3499: ---------------------------------------------------
3500: -- PL/SQL TBL delete_row for:OKL_PRTFL_CNTRCTS_V --
3501: ---------------------------------------------------
3502: PROCEDURE delete_row(
3503: p_api_version IN NUMBER,
3504: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 3596: -- PL/SQL TBL delete_row for:OKL_PRTFL_CNTRCTS_V --

3592: );
3593: END delete_row;
3594:
3595: ---------------------------------------------------
3596: -- PL/SQL TBL delete_row for:OKL_PRTFL_CNTRCTS_V --
3597: ---------------------------------------------------
3598: PROCEDURE delete_row(
3599: p_api_version IN NUMBER,
3600: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,