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_CAF_PVT dependencies on OKL_CASH_FLOWS

Line 94: -- FUNCTION get_rec for: OKL_CASH_FLOWS_V

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

Line 134: FROM Okl_Cash_Flows_V

130: LAST_UPDATED_BY,
131: LAST_UPDATE_DATE,
132: LAST_UPDATE_LOGIN,
133: OBJECT_VERSION_NUMBER
134: FROM Okl_Cash_Flows_V
135: WHERE okl_cash_flows_v.id = p_id;
136: l_okl_cafv_pk okl_cafv_pk_csr%ROWTYPE;
137: l_cafv_rec cafv_rec_type;
138: BEGIN

Line 135: WHERE okl_cash_flows_v.id = p_id;

131: LAST_UPDATE_DATE,
132: LAST_UPDATE_LOGIN,
133: OBJECT_VERSION_NUMBER
134: FROM Okl_Cash_Flows_V
135: WHERE okl_cash_flows_v.id = p_id;
136: l_okl_cafv_pk okl_cafv_pk_csr%ROWTYPE;
137: l_cafv_rec cafv_rec_type;
138: BEGIN
139: x_no_data_found := TRUE;

Line 209: -- FUNCTION get_rec for: OKL_CASH_FLOWS

205: BEGIN
206: RETURN(get_rec(p_cafv_rec, l_row_not_found));
207: END get_rec;
208: ---------------------------------------------------------------------------
209: -- FUNCTION get_rec for: OKL_CASH_FLOWS
210: ---------------------------------------------------------------------------
211: FUNCTION get_rec (
212: p_caf_rec IN caf_rec_type,
213: x_no_data_found OUT NOCOPY BOOLEAN

Line 215: CURSOR okl_cash_flows_pk_csr (p_id IN NUMBER) IS

211: FUNCTION get_rec (
212: p_caf_rec IN caf_rec_type,
213: x_no_data_found OUT NOCOPY BOOLEAN
214: ) RETURN caf_rec_type IS
215: CURSOR okl_cash_flows_pk_csr (p_id IN NUMBER) IS
216: SELECT
217: ID,
218: CFO_ID,
219: STS_CODE,

Line 249: FROM Okl_Cash_Flows

245: LAST_UPDATED_BY,
246: LAST_UPDATE_DATE,
247: LAST_UPDATE_LOGIN,
248: OBJECT_VERSION_NUMBER
249: FROM Okl_Cash_Flows
250: WHERE okl_cash_flows.id = p_id;
251: l_okl_cash_flows_pk okl_cash_flows_pk_csr%ROWTYPE;
252: l_caf_rec caf_rec_type;
253: BEGIN

Line 250: WHERE okl_cash_flows.id = p_id;

246: LAST_UPDATE_DATE,
247: LAST_UPDATE_LOGIN,
248: OBJECT_VERSION_NUMBER
249: FROM Okl_Cash_Flows
250: WHERE okl_cash_flows.id = p_id;
251: l_okl_cash_flows_pk okl_cash_flows_pk_csr%ROWTYPE;
252: l_caf_rec caf_rec_type;
253: BEGIN
254: x_no_data_found := TRUE;

Line 251: l_okl_cash_flows_pk okl_cash_flows_pk_csr%ROWTYPE;

247: LAST_UPDATE_LOGIN,
248: OBJECT_VERSION_NUMBER
249: FROM Okl_Cash_Flows
250: WHERE okl_cash_flows.id = p_id;
251: l_okl_cash_flows_pk okl_cash_flows_pk_csr%ROWTYPE;
252: l_caf_rec caf_rec_type;
253: BEGIN
254: x_no_data_found := TRUE;
255: -- Get current database values

Line 256: OPEN okl_cash_flows_pk_csr (p_caf_rec.id);

252: l_caf_rec caf_rec_type;
253: BEGIN
254: x_no_data_found := TRUE;
255: -- Get current database values
256: OPEN okl_cash_flows_pk_csr (p_caf_rec.id);
257: FETCH okl_cash_flows_pk_csr INTO
258: l_caf_rec.id,
259: l_caf_rec.cfo_id,
260: l_caf_rec.sts_code,

Line 257: FETCH okl_cash_flows_pk_csr INTO

253: BEGIN
254: x_no_data_found := TRUE;
255: -- Get current database values
256: OPEN okl_cash_flows_pk_csr (p_caf_rec.id);
257: FETCH okl_cash_flows_pk_csr INTO
258: l_caf_rec.id,
259: l_caf_rec.cfo_id,
260: l_caf_rec.sts_code,
261: l_caf_rec.sty_id,

Line 290: x_no_data_found := okl_cash_flows_pk_csr%NOTFOUND;

286: l_caf_rec.last_updated_by,
287: l_caf_rec.last_update_date,
288: l_caf_rec.last_update_login,
289: l_caf_rec.object_version_number;
290: x_no_data_found := okl_cash_flows_pk_csr%NOTFOUND;
291: CLOSE okl_cash_flows_pk_csr;
292: RETURN(l_caf_rec);
293: END get_rec;
294:

Line 291: CLOSE okl_cash_flows_pk_csr;

287: l_caf_rec.last_update_date,
288: l_caf_rec.last_update_login,
289: l_caf_rec.object_version_number;
290: x_no_data_found := okl_cash_flows_pk_csr%NOTFOUND;
291: CLOSE okl_cash_flows_pk_csr;
292: RETURN(l_caf_rec);
293: END get_rec;
294:
295: ------------------------------------------------------------------

Line 324: -- FUNCTION null_out_defaults for: OKL_CASH_FLOWS_V

320: BEGIN
321: RETURN(get_rec(p_caf_rec, l_row_not_found));
322: END get_rec;
323: ---------------------------------------------------------------------------
324: -- FUNCTION null_out_defaults for: OKL_CASH_FLOWS_V
325: ---------------------------------------------------------------------------
326: FUNCTION null_out_defaults (
327: p_cafv_rec IN cafv_rec_type
328: ) RETURN cafv_rec_type IS

Line 488: 'OKL_CASH_FLOWS_V',

484: g_no_parent_record,
485: g_col_name_token,
486: 'cfo_id',
487: g_child_table_token ,
488: 'OKL_CASH_FLOWS_V',
489: g_parent_table_token ,
490: 'OKL_CASH_FLOW_OBJECTS_V');
491: l_return_status := OKC_API.G_RET_STS_ERROR;
492:

Line 540: 'OKL_CASH_FLOWS_V',

536: g_no_parent_record,
537: g_col_name_token,
538: 'sts_code',
539: g_child_table_token ,
540: 'OKL_CASH_FLOWS_V',
541: g_parent_table_token ,
542: 'FND_LOOKUP_VALUES');
543: l_return_status := OKC_API.G_RET_STS_ERROR;
544:

Line 590: 'OKL_CASH_FLOWS_V',

586: g_no_parent_record,
587: g_col_name_token,
588: 'sty_id',
589: g_child_table_token ,
590: 'OKL_CASH_FLOWS_V',
591: g_parent_table_token ,
592: 'OKL_STRM_TYPE_V');
593: l_return_status := OKC_API.G_RET_STS_ERROR;
594:

Line 643: 'OKL_CASH_FLOWS_V',

639: g_no_parent_record,
640: g_col_name_token,
641: 'cft_code',
642: g_child_table_token ,
643: 'OKL_CASH_FLOWS_V',
644: g_parent_table_token ,
645: 'FND_LOOKUP_VALUES');
646: l_return_status := OKC_API.G_RET_STS_ERROR;
647:

Line 693: -- Validate_Attributes for:OKL_CASH_FLOWS_V --

689: ---------------------------------------------------------------------------
690: -- FUNCTION Validate_Attributes
691: ---------------------------------------------------------------------------
692: ----------------------------------------------
693: -- Validate_Attributes for:OKL_CASH_FLOWS_V --
694: ----------------------------------------------
695: FUNCTION Validate_Attributes (
696: p_cafv_rec IN cafv_rec_type
697: ) RETURN VARCHAR2 IS

Line 813: -- Validate Record for:OKL_CASH_FLOWS_V --

809: ---------------------------------------------------------------------------
810:
811: /* SECHAWLA - Not needed, as foreign key validation was moved under individual validate_ procedures
812: ------------------------------------------
813: -- Validate Record for:OKL_CASH_FLOWS_V --
814: ------------------------------------------
815: FUNCTION Validate_Record (
816: p_cafv_rec IN cafv_rec_type,
817: p_db_cafv_rec IN cafv_rec_type

Line 928: -- validate_row for:OKL_CASH_FLOWS_V --

924: ---------------------------------------------------------------------------
925: -- PROCEDURE validate_row
926: ---------------------------------------------------------------------------
927: ---------------------------------------
928: -- validate_row for:OKL_CASH_FLOWS_V --
929: ---------------------------------------
930: PROCEDURE validate_row(
931: p_api_version IN NUMBER,
932: p_init_msg_list IN VARCHAR2,

Line 1012: -- PL/SQL TBL validate_row for:OKL_CASH_FLOWS_V --

1008: '_PVT'
1009: );
1010: END validate_row;
1011: --------------------------------------------------
1012: -- PL/SQL TBL validate_row for:OKL_CASH_FLOWS_V --
1013: --------------------------------------------------
1014: PROCEDURE validate_row(
1015: p_api_version IN NUMBER,
1016: p_init_msg_list IN VARCHAR2,

Line 1108: -- PL/SQL TBL validate_row for:OKL_CASH_FLOWS_V --

1104: );
1105: END validate_row;
1106:
1107: --------------------------------------------------
1108: -- PL/SQL TBL validate_row for:OKL_CASH_FLOWS_V --
1109: --------------------------------------------------
1110: PROCEDURE validate_row(
1111: p_api_version IN NUMBER,
1112: p_init_msg_list IN VARCHAR2,

Line 1173: -- insert_row for:OKL_CASH_FLOWS --

1169: ---------------------------------------------------------------------------
1170: -- PROCEDURE insert_row
1171: ---------------------------------------------------------------------------
1172: -----------------------------------
1173: -- insert_row for:OKL_CASH_FLOWS --
1174: -----------------------------------
1175: PROCEDURE insert_row(
1176: p_init_msg_list IN VARCHAR2,
1177: x_return_status OUT NOCOPY VARCHAR2,

Line 1189: -- Set_Attributes for:OKL_CASH_FLOWS --

1185: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1186: l_caf_rec caf_rec_type := p_caf_rec;
1187: l_def_caf_rec caf_rec_type;
1188: ---------------------------------------
1189: -- Set_Attributes for:OKL_CASH_FLOWS --
1190: ---------------------------------------
1191: FUNCTION Set_Attributes (
1192: p_caf_rec IN caf_rec_type,
1193: x_caf_rec OUT NOCOPY caf_rec_type

Line 1220: INSERT INTO OKL_CASH_FLOWS(

1216: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1217: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1218: RAISE OKL_API.G_EXCEPTION_ERROR;
1219: END IF;
1220: INSERT INTO OKL_CASH_FLOWS(
1221: id,
1222: cfo_id,
1223: sts_code,
1224: sty_id,

Line 1323: -- insert_row for :OKL_CASH_FLOWS_V --

1319: '_PVT'
1320: );
1321: END insert_row;
1322: --------------------------------------
1323: -- insert_row for :OKL_CASH_FLOWS_V --
1324: --------------------------------------
1325: PROCEDURE insert_row(
1326: p_api_version IN NUMBER,
1327: p_init_msg_list IN VARCHAR2,

Line 1357: -- Set_Attributes for:OKL_CASH_FLOWS_V --

1353: l_cafv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1354: RETURN(l_cafv_rec);
1355: END fill_who_columns;
1356: -----------------------------------------
1357: -- Set_Attributes for:OKL_CASH_FLOWS_V --
1358: -----------------------------------------
1359: FUNCTION Set_Attributes (
1360: p_cafv_rec IN cafv_rec_type,
1361: x_cafv_rec OUT NOCOPY cafv_rec_type

Line 1639: -- insert row for bulk insert in OKL_CASH_FLOWS --

1635:
1636: --Bug 4299668 PAGARG new procedure to implement bulk insert
1637: --**START**--
1638: --------------------------------------------------
1639: -- insert row for bulk insert in OKL_CASH_FLOWS --
1640: --------------------------------------------------
1641: PROCEDURE insert_row_bulk(
1642: p_api_version IN NUMBER,
1643: p_init_msg_list IN VARCHAR2,

Line 1785: INSERT INTO OKL_CASH_FLOWS(

1781: END LOOP;
1782:
1783: -- Bulk insert into table
1784: FORALL i in 1..l_tabsize
1785: INSERT INTO OKL_CASH_FLOWS(
1786: id,
1787: cfo_id,
1788: sts_code,
1789: sty_id,

Line 1893: -- lock_row for:OKL_CASH_FLOWS --

1889: ---------------------------------------------------------------------------
1890: -- PROCEDURE lock_row
1891: ---------------------------------------------------------------------------
1892: ---------------------------------
1893: -- lock_row for:OKL_CASH_FLOWS --
1894: ---------------------------------
1895: PROCEDURE lock_row(
1896: p_init_msg_list IN VARCHAR2,
1897: x_return_status OUT NOCOPY VARCHAR2,

Line 1906: FROM OKL_CASH_FLOWS

1902: E_Resource_Busy EXCEPTION;
1903: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1904: CURSOR lock_csr (p_caf_rec IN caf_rec_type) IS
1905: SELECT OBJECT_VERSION_NUMBER
1906: FROM OKL_CASH_FLOWS
1907: WHERE ID = p_caf_rec.id
1908: AND OBJECT_VERSION_NUMBER = p_caf_rec.object_version_number
1909: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1910:

Line 1913: FROM OKL_CASH_FLOWS

1909: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1910:
1911: CURSOR lchk_csr (p_caf_rec IN caf_rec_type) IS
1912: SELECT OBJECT_VERSION_NUMBER
1913: FROM OKL_CASH_FLOWS
1914: WHERE ID = p_caf_rec.id;
1915: l_api_version CONSTANT NUMBER := 1;
1916: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1917: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 1918: l_object_version_number OKL_CASH_FLOWS.OBJECT_VERSION_NUMBER%TYPE;

1914: WHERE ID = p_caf_rec.id;
1915: l_api_version CONSTANT NUMBER := 1;
1916: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1917: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1918: l_object_version_number OKL_CASH_FLOWS.OBJECT_VERSION_NUMBER%TYPE;
1919: lc_object_version_number OKL_CASH_FLOWS.OBJECT_VERSION_NUMBER%TYPE;
1920: l_row_notfound BOOLEAN := FALSE;
1921: lc_row_notfound BOOLEAN := FALSE;
1922: BEGIN

Line 1919: lc_object_version_number OKL_CASH_FLOWS.OBJECT_VERSION_NUMBER%TYPE;

1915: l_api_version CONSTANT NUMBER := 1;
1916: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1917: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1918: l_object_version_number OKL_CASH_FLOWS.OBJECT_VERSION_NUMBER%TYPE;
1919: lc_object_version_number OKL_CASH_FLOWS.OBJECT_VERSION_NUMBER%TYPE;
1920: l_row_notfound BOOLEAN := FALSE;
1921: lc_row_notfound BOOLEAN := FALSE;
1922: BEGIN
1923: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 2000: -- lock_row for: OKL_CASH_FLOWS_V --

1996: '_PVT'
1997: );
1998: END lock_row;
1999: ------------------------------------
2000: -- lock_row for: OKL_CASH_FLOWS_V --
2001: ------------------------------------
2002: PROCEDURE lock_row(
2003: p_api_version IN NUMBER,
2004: p_init_msg_list IN VARCHAR2,

Line 2240: -- update_row for:OKL_CASH_FLOWS --

2236: ---------------------------------------------------------------------------
2237: -- PROCEDURE update_row
2238: ---------------------------------------------------------------------------
2239: -----------------------------------
2240: -- update_row for:OKL_CASH_FLOWS --
2241: -----------------------------------
2242: PROCEDURE update_row(
2243: p_init_msg_list IN VARCHAR2,
2244: x_return_status OUT NOCOPY VARCHAR2,

Line 2403: -- Set_Attributes for:OKL_CASH_FLOWS --

2399: END IF;
2400: RETURN(l_return_status);
2401: END populate_new_record;
2402: ---------------------------------------
2403: -- Set_Attributes for:OKL_CASH_FLOWS --
2404: ---------------------------------------
2405: FUNCTION Set_Attributes (
2406: p_caf_rec IN caf_rec_type,
2407: x_caf_rec OUT NOCOPY caf_rec_type

Line 2441: UPDATE OKL_CASH_FLOWS

2437: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2438: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2439: RAISE OKL_API.G_EXCEPTION_ERROR;
2440: END IF;
2441: UPDATE OKL_CASH_FLOWS
2442: SET CFO_ID = l_def_caf_rec.cfo_id,
2443: STS_CODE = l_def_caf_rec.sts_code,
2444: STY_ID = l_def_caf_rec.sty_id,
2445: CFT_CODE = l_def_caf_rec.cft_code,

Line 2511: -- update_row for:OKL_CASH_FLOWS_V --

2507: '_PVT'
2508: );
2509: END update_row;
2510: -------------------------------------
2511: -- update_row for:OKL_CASH_FLOWS_V --
2512: -------------------------------------
2513: PROCEDURE update_row(
2514: p_api_version IN NUMBER,
2515: p_init_msg_list IN VARCHAR2,

Line 2687: -- Set_Attributes for:OKL_CASH_FLOWS_V --

2683: END IF;
2684: RETURN(l_return_status);
2685: END populate_new_record;
2686: -----------------------------------------
2687: -- Set_Attributes for:OKL_CASH_FLOWS_V --
2688: -----------------------------------------
2689: FUNCTION Set_Attributes (
2690: p_cafv_rec IN cafv_rec_type,
2691: x_cafv_rec OUT NOCOPY cafv_rec_type

Line 2985: -- delete_row for:OKL_CASH_FLOWS --

2981: ---------------------------------------------------------------------------
2982: -- PROCEDURE delete_row
2983: ---------------------------------------------------------------------------
2984: -----------------------------------
2985: -- delete_row for:OKL_CASH_FLOWS --
2986: -----------------------------------
2987: PROCEDURE delete_row(
2988: p_init_msg_list IN VARCHAR2,
2989: x_return_status OUT NOCOPY VARCHAR2,

Line 3010: DELETE FROM OKL_CASH_FLOWS

3006: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3007: RAISE OKL_API.G_EXCEPTION_ERROR;
3008: END IF;
3009:
3010: DELETE FROM OKL_CASH_FLOWS
3011: WHERE ID = p_caf_rec.id;
3012:
3013: x_return_status := l_return_status;
3014: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 3048: -- delete_row for:OKL_CASH_FLOWS_V --

3044: '_PVT'
3045: );
3046: END delete_row;
3047: -------------------------------------
3048: -- delete_row for:OKL_CASH_FLOWS_V --
3049: -------------------------------------
3050: PROCEDURE delete_row(
3051: p_api_version IN NUMBER,
3052: p_init_msg_list IN VARCHAR2,

Line 3130: -- PL/SQL TBL delete_row for:OKL_CASH_FLOWS_V --

3126: '_PVT'
3127: );
3128: END delete_row;
3129: ------------------------------------------------
3130: -- PL/SQL TBL delete_row for:OKL_CASH_FLOWS_V --
3131: ------------------------------------------------
3132: PROCEDURE delete_row(
3133: p_api_version IN NUMBER,
3134: p_init_msg_list IN VARCHAR2,

Line 3226: -- PL/SQL TBL delete_row for:OKL_CASH_FLOWS_V --

3222: );
3223: END delete_row;
3224:
3225: ------------------------------------------------
3226: -- PL/SQL TBL delete_row for:OKL_CASH_FLOWS_V --
3227: ------------------------------------------------
3228: PROCEDURE delete_row(
3229: p_api_version IN NUMBER,
3230: p_init_msg_list IN VARCHAR2,