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_CFP_PVT dependencies on OKL_CF_OBJECT_PERIODS

Line 94: -- FUNCTION get_rec for: OKL_CF_OBJECT_PERIODS_V

90: null;
91: END api_copy;
92:
93: ---------------------------------------------------------------------------
94: -- FUNCTION get_rec for: OKL_CF_OBJECT_PERIODS_V
95: ---------------------------------------------------------------------------
96: FUNCTION get_rec (
97: p_cfpv_rec IN cfpv_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN

Line 129: FROM Okl_Cf_Object_Periods_V

125: LAST_UPDATED_BY,
126: LAST_UPDATE_DATE,
127: LAST_UPDATE_LOGIN,
128: OBJECT_VERSION_NUMBER
129: FROM Okl_Cf_Object_Periods_V
130: WHERE okl_cf_object_periods_v.id = p_id;
131: l_cfpv_pk cfpv_pk_csr%ROWTYPE;
132: l_cfpv_rec cfpv_rec_type;
133: BEGIN

Line 130: WHERE okl_cf_object_periods_v.id = p_id;

126: LAST_UPDATE_DATE,
127: LAST_UPDATE_LOGIN,
128: OBJECT_VERSION_NUMBER
129: FROM Okl_Cf_Object_Periods_V
130: WHERE okl_cf_object_periods_v.id = p_id;
131: l_cfpv_pk cfpv_pk_csr%ROWTYPE;
132: l_cfpv_rec cfpv_rec_type;
133: BEGIN
134: x_no_data_found := TRUE;

Line 199: -- FUNCTION get_rec for: OKL_CF_OBJECT_PERIODS

195: BEGIN
196: RETURN(get_rec(p_cfpv_rec, l_row_not_found));
197: END get_rec;
198: ---------------------------------------------------------------------------
199: -- FUNCTION get_rec for: OKL_CF_OBJECT_PERIODS
200: ---------------------------------------------------------------------------
201: FUNCTION get_rec (
202: p_cfp_rec IN cfp_rec_type,
203: x_no_data_found OUT NOCOPY BOOLEAN

Line 205: CURSOR okl_cf_object_periods_pk_csr (p_id IN NUMBER) IS

201: FUNCTION get_rec (
202: p_cfp_rec IN cfp_rec_type,
203: x_no_data_found OUT NOCOPY BOOLEAN
204: ) RETURN cfp_rec_type IS
205: CURSOR okl_cf_object_periods_pk_csr (p_id IN NUMBER) IS
206: SELECT
207: ID,
208: CFO_ID,
209: PTP_CODE,

Line 234: FROM Okl_Cf_Object_Periods

230: LAST_UPDATED_BY,
231: LAST_UPDATE_DATE,
232: LAST_UPDATE_LOGIN,
233: OBJECT_VERSION_NUMBER
234: FROM Okl_Cf_Object_Periods
235: WHERE okl_cf_object_periods.id = p_id;
236: l_okl_cf_object_periods_pk okl_cf_object_periods_pk_csr%ROWTYPE;
237: l_cfp_rec cfp_rec_type;
238: BEGIN

Line 235: WHERE okl_cf_object_periods.id = p_id;

231: LAST_UPDATE_DATE,
232: LAST_UPDATE_LOGIN,
233: OBJECT_VERSION_NUMBER
234: FROM Okl_Cf_Object_Periods
235: WHERE okl_cf_object_periods.id = p_id;
236: l_okl_cf_object_periods_pk okl_cf_object_periods_pk_csr%ROWTYPE;
237: l_cfp_rec cfp_rec_type;
238: BEGIN
239: x_no_data_found := TRUE;

Line 236: l_okl_cf_object_periods_pk okl_cf_object_periods_pk_csr%ROWTYPE;

232: LAST_UPDATE_LOGIN,
233: OBJECT_VERSION_NUMBER
234: FROM Okl_Cf_Object_Periods
235: WHERE okl_cf_object_periods.id = p_id;
236: l_okl_cf_object_periods_pk okl_cf_object_periods_pk_csr%ROWTYPE;
237: l_cfp_rec cfp_rec_type;
238: BEGIN
239: x_no_data_found := TRUE;
240: -- Get current database values

Line 241: OPEN okl_cf_object_periods_pk_csr (p_cfp_rec.id);

237: l_cfp_rec cfp_rec_type;
238: BEGIN
239: x_no_data_found := TRUE;
240: -- Get current database values
241: OPEN okl_cf_object_periods_pk_csr (p_cfp_rec.id);
242: FETCH okl_cf_object_periods_pk_csr INTO
243: l_cfp_rec.id,
244: l_cfp_rec.cfo_id,
245: l_cfp_rec.ptp_code,

Line 242: FETCH okl_cf_object_periods_pk_csr INTO

238: BEGIN
239: x_no_data_found := TRUE;
240: -- Get current database values
241: OPEN okl_cf_object_periods_pk_csr (p_cfp_rec.id);
242: FETCH okl_cf_object_periods_pk_csr INTO
243: l_cfp_rec.id,
244: l_cfp_rec.cfo_id,
245: l_cfp_rec.ptp_code,
246: l_cfp_rec.start_date,

Line 270: x_no_data_found := okl_cf_object_periods_pk_csr%NOTFOUND;

266: l_cfp_rec.last_updated_by,
267: l_cfp_rec.last_update_date,
268: l_cfp_rec.last_update_login,
269: l_cfp_rec.object_version_number;
270: x_no_data_found := okl_cf_object_periods_pk_csr%NOTFOUND;
271: CLOSE okl_cf_object_periods_pk_csr;
272: RETURN(l_cfp_rec);
273: END get_rec;
274:

Line 271: CLOSE okl_cf_object_periods_pk_csr;

267: l_cfp_rec.last_update_date,
268: l_cfp_rec.last_update_login,
269: l_cfp_rec.object_version_number;
270: x_no_data_found := okl_cf_object_periods_pk_csr%NOTFOUND;
271: CLOSE okl_cf_object_periods_pk_csr;
272: RETURN(l_cfp_rec);
273: END get_rec;
274:
275: ------------------------------------------------------------------

Line 304: -- FUNCTION null_out_defaults for: OKL_CF_OBJECT_PERIODS_V

300: BEGIN
301: RETURN(get_rec(p_cfp_rec, l_row_not_found));
302: END get_rec;
303: ---------------------------------------------------------------------------
304: -- FUNCTION null_out_defaults for: OKL_CF_OBJECT_PERIODS_V
305: ---------------------------------------------------------------------------
306: FUNCTION null_out_defaults (
307: p_cfpv_rec IN cfpv_rec_type
308: ) RETURN cfpv_rec_type IS

Line 451: 'OKL_CF_OBJECT_PERIODS_V',

447: g_no_parent_record,
448: g_col_name_token,
449: 'cfo_id',
450: g_child_table_token ,
451: 'OKL_CF_OBJECT_PERIODS_V',
452: g_parent_table_token ,
453: 'OKL_CASH_FLOW_OBJECTS_V');
454: l_return_status := OKC_API.G_RET_STS_ERROR;
455:

Line 505: 'OKL_CF_OBJECT_PERIODS_V',

501: g_no_parent_record,
502: g_col_name_token,
503: 'ptp_code',
504: g_child_table_token ,
505: 'OKL_CF_OBJECT_PERIODS_V',
506: g_parent_table_token ,
507: 'FND_LOOKUP_VALUES');
508: l_return_status := OKC_API.G_RET_STS_ERROR;
509:

Line 555: -- Validate_Attributes for:OKL_CF_OBJECT_PERIODS_V --

551: ---------------------------------------------------------------------------
552: -- FUNCTION Validate_Attributes
553: ---------------------------------------------------------------------------
554: -----------------------------------------------------
555: -- Validate_Attributes for:OKL_CF_OBJECT_PERIODS_V --
556: -----------------------------------------------------
557: FUNCTION Validate_Attributes (
558: p_cfpv_rec IN cfpv_rec_type
559: ) RETURN VARCHAR2 IS

Line 636: -- Validate Record for:OKL_CF_OBJECT_PERIODS_V --

632: ---------------------------------------------------------------------------
633: -- PROCEDURE Validate_Record
634: ---------------------------------------------------------------------------
635: -------------------------------------------------
636: -- Validate Record for:OKL_CF_OBJECT_PERIODS_V --
637: -------------------------------------------------
638: /* SECHAWLA - Not needed, as foreign key validation was moved under individual validate_ procedures
639: FUNCTION Validate_Record (
640: p_cfpv_rec IN cfpv_rec_type,

Line 789: -- validate_row for:OKL_CF_OBJECT_PERIODS_V --

785: ---------------------------------------------------------------------------
786: -- PROCEDURE validate_row
787: ---------------------------------------------------------------------------
788: ----------------------------------------------
789: -- validate_row for:OKL_CF_OBJECT_PERIODS_V --
790: ----------------------------------------------
791: PROCEDURE validate_row(
792: p_api_version IN NUMBER,
793: p_init_msg_list IN VARCHAR2,

Line 871: -- PL/SQL TBL validate_row for:OKL_CF_OBJECT_PERIODS_V --

867: '_PVT'
868: );
869: END validate_row;
870: ---------------------------------------------------------
871: -- PL/SQL TBL validate_row for:OKL_CF_OBJECT_PERIODS_V --
872: ---------------------------------------------------------
873: PROCEDURE validate_row(
874: p_api_version IN NUMBER,
875: p_init_msg_list IN VARCHAR2,

Line 967: -- PL/SQL TBL validate_row for:OKL_CF_OBJECT_PERIODS_V --

963: );
964: END validate_row;
965:
966: ---------------------------------------------------------
967: -- PL/SQL TBL validate_row for:OKL_CF_OBJECT_PERIODS_V --
968: ---------------------------------------------------------
969: PROCEDURE validate_row(
970: p_api_version IN NUMBER,
971: p_init_msg_list IN VARCHAR2,

Line 1032: -- insert_row for:OKL_CF_OBJECT_PERIODS --

1028: ---------------------------------------------------------------------------
1029: -- PROCEDURE insert_row
1030: ---------------------------------------------------------------------------
1031: ------------------------------------------
1032: -- insert_row for:OKL_CF_OBJECT_PERIODS --
1033: ------------------------------------------
1034: PROCEDURE insert_row(
1035: p_init_msg_list IN VARCHAR2,
1036: x_return_status OUT NOCOPY VARCHAR2,

Line 1048: -- Set_Attributes for:OKL_CF_OBJECT_PERIODS --

1044: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1045: l_cfp_rec cfp_rec_type := p_cfp_rec;
1046: l_def_cfp_rec cfp_rec_type;
1047: ----------------------------------------------
1048: -- Set_Attributes for:OKL_CF_OBJECT_PERIODS --
1049: ----------------------------------------------
1050: FUNCTION Set_Attributes (
1051: p_cfp_rec IN cfp_rec_type,
1052: x_cfp_rec OUT NOCOPY cfp_rec_type

Line 1079: INSERT INTO OKL_CF_OBJECT_PERIODS(

1075: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1076: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1077: RAISE OKL_API.G_EXCEPTION_ERROR;
1078: END IF;
1079: INSERT INTO OKL_CF_OBJECT_PERIODS(
1080: id,
1081: cfo_id,
1082: ptp_code,
1083: start_date,

Line 1172: -- insert_row for :OKL_CF_OBJECT_PERIODS_V --

1168: '_PVT'
1169: );
1170: END insert_row;
1171: ---------------------------------------------
1172: -- insert_row for :OKL_CF_OBJECT_PERIODS_V --
1173: ---------------------------------------------
1174: PROCEDURE insert_row(
1175: p_api_version IN NUMBER,
1176: p_init_msg_list IN VARCHAR2,

Line 1206: -- Set_Attributes for:OKL_CF_OBJECT_PERIODS_V --

1202: l_cfpv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1203: RETURN(l_cfpv_rec);
1204: END fill_who_columns;
1205: ------------------------------------------------
1206: -- Set_Attributes for:OKL_CF_OBJECT_PERIODS_V --
1207: ------------------------------------------------
1208: FUNCTION Set_Attributes (
1209: p_cfpv_rec IN cfpv_rec_type,
1210: x_cfpv_rec OUT NOCOPY cfpv_rec_type

Line 1488: -- lock_row for:OKL_CF_OBJECT_PERIODS --

1484: ---------------------------------------------------------------------------
1485: -- PROCEDURE lock_row
1486: ---------------------------------------------------------------------------
1487: ----------------------------------------
1488: -- lock_row for:OKL_CF_OBJECT_PERIODS --
1489: ----------------------------------------
1490: PROCEDURE lock_row(
1491: p_init_msg_list IN VARCHAR2,
1492: x_return_status OUT NOCOPY VARCHAR2,

Line 1501: FROM OKL_CF_OBJECT_PERIODS

1497: E_Resource_Busy EXCEPTION;
1498: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1499: CURSOR lock_csr (p_cfp_rec IN cfp_rec_type) IS
1500: SELECT OBJECT_VERSION_NUMBER
1501: FROM OKL_CF_OBJECT_PERIODS
1502: WHERE ID = p_cfp_rec.id
1503: AND OBJECT_VERSION_NUMBER = p_cfp_rec.object_version_number
1504: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1505:

Line 1508: FROM OKL_CF_OBJECT_PERIODS

1504: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1505:
1506: CURSOR lchk_csr (p_cfp_rec IN cfp_rec_type) IS
1507: SELECT OBJECT_VERSION_NUMBER
1508: FROM OKL_CF_OBJECT_PERIODS
1509: WHERE ID = p_cfp_rec.id;
1510: l_api_version CONSTANT NUMBER := 1;
1511: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1512: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 1513: l_object_version_number OKL_CF_OBJECT_PERIODS.OBJECT_VERSION_NUMBER%TYPE;

1509: WHERE ID = p_cfp_rec.id;
1510: l_api_version CONSTANT NUMBER := 1;
1511: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1512: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1513: l_object_version_number OKL_CF_OBJECT_PERIODS.OBJECT_VERSION_NUMBER%TYPE;
1514: lc_object_version_number OKL_CF_OBJECT_PERIODS.OBJECT_VERSION_NUMBER%TYPE;
1515: l_row_notfound BOOLEAN := FALSE;
1516: lc_row_notfound BOOLEAN := FALSE;
1517: BEGIN

Line 1514: lc_object_version_number OKL_CF_OBJECT_PERIODS.OBJECT_VERSION_NUMBER%TYPE;

1510: l_api_version CONSTANT NUMBER := 1;
1511: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1512: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1513: l_object_version_number OKL_CF_OBJECT_PERIODS.OBJECT_VERSION_NUMBER%TYPE;
1514: lc_object_version_number OKL_CF_OBJECT_PERIODS.OBJECT_VERSION_NUMBER%TYPE;
1515: l_row_notfound BOOLEAN := FALSE;
1516: lc_row_notfound BOOLEAN := FALSE;
1517: BEGIN
1518: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 1595: -- lock_row for: OKL_CF_OBJECT_PERIODS_V --

1591: '_PVT'
1592: );
1593: END lock_row;
1594: -------------------------------------------
1595: -- lock_row for: OKL_CF_OBJECT_PERIODS_V --
1596: -------------------------------------------
1597: PROCEDURE lock_row(
1598: p_api_version IN NUMBER,
1599: p_init_msg_list IN VARCHAR2,

Line 1835: -- update_row for:OKL_CF_OBJECT_PERIODS --

1831: ---------------------------------------------------------------------------
1832: -- PROCEDURE update_row
1833: ---------------------------------------------------------------------------
1834: ------------------------------------------
1835: -- update_row for:OKL_CF_OBJECT_PERIODS --
1836: ------------------------------------------
1837: PROCEDURE update_row(
1838: p_init_msg_list IN VARCHAR2,
1839: x_return_status OUT NOCOPY VARCHAR2,

Line 1978: -- Set_Attributes for:OKL_CF_OBJECT_PERIODS --

1974: END IF;
1975: RETURN(l_return_status);
1976: END populate_new_record;
1977: ----------------------------------------------
1978: -- Set_Attributes for:OKL_CF_OBJECT_PERIODS --
1979: ----------------------------------------------
1980: FUNCTION Set_Attributes (
1981: p_cfp_rec IN cfp_rec_type,
1982: x_cfp_rec OUT NOCOPY cfp_rec_type

Line 2016: UPDATE OKL_CF_OBJECT_PERIODS

2012: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2013: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2014: RAISE OKL_API.G_EXCEPTION_ERROR;
2015: END IF;
2016: UPDATE OKL_CF_OBJECT_PERIODS
2017: SET CFO_ID = l_def_cfp_rec.cfo_id,
2018: PTP_CODE = l_def_cfp_rec.ptp_code,
2019: START_DATE = l_def_cfp_rec.start_date,
2020: END_DATE = l_def_cfp_rec.end_date,

Line 2081: -- update_row for:OKL_CF_OBJECT_PERIODS_V --

2077: '_PVT'
2078: );
2079: END update_row;
2080: --------------------------------------------
2081: -- update_row for:OKL_CF_OBJECT_PERIODS_V --
2082: --------------------------------------------
2083: PROCEDURE update_row(
2084: p_api_version IN NUMBER,
2085: p_init_msg_list IN VARCHAR2,

Line 2237: -- Set_Attributes for:OKL_CF_OBJECT_PERIODS_V --

2233: END IF;
2234: RETURN(l_return_status);
2235: END populate_new_record;
2236: ------------------------------------------------
2237: -- Set_Attributes for:OKL_CF_OBJECT_PERIODS_V --
2238: ------------------------------------------------
2239: FUNCTION Set_Attributes (
2240: p_cfpv_rec IN cfpv_rec_type,
2241: x_cfpv_rec OUT NOCOPY cfpv_rec_type

Line 2535: -- delete_row for:OKL_CF_OBJECT_PERIODS --

2531: ---------------------------------------------------------------------------
2532: -- PROCEDURE delete_row
2533: ---------------------------------------------------------------------------
2534: ------------------------------------------
2535: -- delete_row for:OKL_CF_OBJECT_PERIODS --
2536: ------------------------------------------
2537: PROCEDURE delete_row(
2538: p_init_msg_list IN VARCHAR2,
2539: x_return_status OUT NOCOPY VARCHAR2,

Line 2560: DELETE FROM OKL_CF_OBJECT_PERIODS

2556: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2557: RAISE OKL_API.G_EXCEPTION_ERROR;
2558: END IF;
2559:
2560: DELETE FROM OKL_CF_OBJECT_PERIODS
2561: WHERE ID = p_cfp_rec.id;
2562:
2563: x_return_status := l_return_status;
2564: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2598: -- delete_row for:OKL_CF_OBJECT_PERIODS_V --

2594: '_PVT'
2595: );
2596: END delete_row;
2597: --------------------------------------------
2598: -- delete_row for:OKL_CF_OBJECT_PERIODS_V --
2599: --------------------------------------------
2600: PROCEDURE delete_row(
2601: p_api_version IN NUMBER,
2602: p_init_msg_list IN VARCHAR2,

Line 2680: -- PL/SQL TBL delete_row for:OKL_CF_OBJECT_PERIODS_V --

2676: '_PVT'
2677: );
2678: END delete_row;
2679: -------------------------------------------------------
2680: -- PL/SQL TBL delete_row for:OKL_CF_OBJECT_PERIODS_V --
2681: -------------------------------------------------------
2682: PROCEDURE delete_row(
2683: p_api_version IN NUMBER,
2684: p_init_msg_list IN VARCHAR2,

Line 2776: -- PL/SQL TBL delete_row for:OKL_CF_OBJECT_PERIODS_V --

2772: );
2773: END delete_row;
2774:
2775: -------------------------------------------------------
2776: -- PL/SQL TBL delete_row for:OKL_CF_OBJECT_PERIODS_V --
2777: -------------------------------------------------------
2778: PROCEDURE delete_row(
2779: p_api_version IN NUMBER,
2780: p_init_msg_list IN VARCHAR2,