DBA Data[Home] [Help]

APPS.OKL_BTC_PVT dependencies on OKL_TRX_CSH_BATCH_V

Line 270: -- FUNCTION get_rec for: OKL_TRX_CSH_BATCH_V

266: BEGIN
267: RETURN(get_rec(p_okl_trx_csh_batch_tl_rec, l_row_notfound));
268: END get_rec;
269: ---------------------------------------------------------------------------
270: -- FUNCTION get_rec for: OKL_TRX_CSH_BATCH_V
271: ---------------------------------------------------------------------------
272: FUNCTION get_rec (
273: p_btcv_rec IN btcv_rec_type,
274: x_no_data_found OUT NOCOPY BOOLEAN

Line 321: FROM Okl_Trx_Csh_Batch_V

317: CURRENCY_CONVERSION_TYPE,
318: CURRENCY_CONVERSION_RATE,
319: CURRENCY_CONVERSION_DATE,
320: REMIT_BANK_ID
321: FROM Okl_Trx_Csh_Batch_V
322: WHERE okl_trx_csh_batch_v.id = p_id;
323: l_okl_btcv_pk okl_btcv_pk_csr%ROWTYPE;
324: l_btcv_rec btcv_rec_type;
325: BEGIN

Line 322: WHERE okl_trx_csh_batch_v.id = p_id;

318: CURRENCY_CONVERSION_RATE,
319: CURRENCY_CONVERSION_DATE,
320: REMIT_BANK_ID
321: FROM Okl_Trx_Csh_Batch_V
322: WHERE okl_trx_csh_batch_v.id = p_id;
323: l_okl_btcv_pk okl_btcv_pk_csr%ROWTYPE;
324: l_btcv_rec btcv_rec_type;
325: BEGIN
326: x_no_data_found := TRUE;

Line 387: -- FUNCTION null_out_defaults for: OKL_TRX_CSH_BATCH_V --

383: RETURN(get_rec(p_btcv_rec, l_row_notfound));
384: END get_rec;
385:
386: ---------------------------------------------------------
387: -- FUNCTION null_out_defaults for: OKL_TRX_CSH_BATCH_V --
388: ---------------------------------------------------------
389: FUNCTION null_out_defaults (
390: p_btcv_rec IN btcv_rec_type
391: ) RETURN btcv_rec_type IS

Line 542: FROM okl_trx_csh_batch_v

538: ) RETURN VARCHAR2 IS
539:
540: CURSOR l_btcv_csr IS
541: SELECT 'x'
542: FROM okl_trx_csh_batch_v
543: WHERE name = p_btcv_rec.name
544: AND id <> NVL (p_btcv_rec.id, -99999);
545:
546: x_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 882: -- Validate_Attributes for:OKL_TRX_CSH_BATCH_V --

878: ---------------------------------------------------------------------------
879: -- PROCEDURE Validate_Attributes
880: ---------------------------------------------------------------------------
881: -------------------------------------------------
882: -- Validate_Attributes for:OKL_TRX_CSH_BATCH_V --
883: -------------------------------------------------
884: FUNCTION Validate_Attributes (
885: p_btcv_rec IN btcv_rec_type
886: ) RETURN VARCHAR2 IS

Line 1004: -- Validate_Record for:OKL_TRX_CSH_BATCH_V --

1000: ---------------------------------------------------------------------------
1001: -- PROCEDURE Validate_Record
1002: ---------------------------------------------------------------------------
1003: ---------------------------------------------
1004: -- Validate_Record for:OKL_TRX_CSH_BATCH_V --
1005: ---------------------------------------------
1006: FUNCTION Validate_Record (
1007: p_btcv_rec IN btcv_rec_type
1008: ) RETURN VARCHAR2 IS

Line 1174: -- validate_row for:OKL_TRX_CSH_BATCH_V --

1170: ---------------------------------------------------------------------------
1171: -- PROCEDURE validate_row
1172: ---------------------------------------------------------------------------
1173: ------------------------------------------
1174: -- validate_row for:OKL_TRX_CSH_BATCH_V --
1175: ------------------------------------------
1176: PROCEDURE validate_row(
1177: p_api_version IN NUMBER,
1178: p_init_msg_list IN VARCHAR2,

Line 1617: -- insert_row for:OKL_TRX_CSH_BATCH_V --

1613: '_PVT'
1614: );
1615: END insert_row;
1616: ----------------------------------------
1617: -- insert_row for:OKL_TRX_CSH_BATCH_V --
1618: ----------------------------------------
1619: PROCEDURE insert_row(
1620: p_api_version IN NUMBER,
1621: p_init_msg_list IN VARCHAR2,

Line 1671: -- Set_Attributes for:OKL_TRX_CSH_BATCH_V --

1667: l_btcv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1668: RETURN(l_btcv_rec);
1669: END fill_who_columns;
1670: --------------------------------------------
1671: -- Set_Attributes for:OKL_TRX_CSH_BATCH_V --
1672: --------------------------------------------
1673: FUNCTION Set_Attributes (
1674: p_btcv_rec IN btcv_rec_type,
1675: x_btcv_rec OUT NOCOPY btcv_rec_type

Line 2083: -- lock_row for:OKL_TRX_CSH_BATCH_V --

2079: '_PVT'
2080: );
2081: END lock_row;
2082: --------------------------------------
2083: -- lock_row for:OKL_TRX_CSH_BATCH_V --
2084: --------------------------------------
2085: PROCEDURE lock_row(
2086: p_api_version IN NUMBER,
2087: p_init_msg_list IN VARCHAR2,

Line 2752: -- update_row for:OKL_TRX_CSH_BATCH_V --

2748: '_PVT'
2749: );
2750: END update_row;
2751: ----------------------------------------
2752: -- update_row for:OKL_TRX_CSH_BATCH_V --
2753: ----------------------------------------
2754: PROCEDURE update_row(
2755: p_api_version IN NUMBER,
2756: p_init_msg_list IN VARCHAR2,

Line 2982: -- Set_Attributes for:OKL_TRX_CSH_BATCH_V --

2978:
2979: RETURN(l_return_status);
2980: END populate_new_record;
2981: --------------------------------------------
2982: -- Set_Attributes for:OKL_TRX_CSH_BATCH_V --
2983: --------------------------------------------
2984: FUNCTION Set_Attributes (
2985: p_btcv_rec IN btcv_rec_type,
2986: x_btcv_rec OUT NOCOPY btcv_rec_type

Line 3346: -- delete_row for:OKL_TRX_CSH_BATCH_V --

3342: '_PVT'
3343: );
3344: END delete_row;
3345: ----------------------------------------
3346: -- delete_row for:OKL_TRX_CSH_BATCH_V --
3347: ----------------------------------------
3348: PROCEDURE delete_row(
3349: p_api_version IN NUMBER,
3350: p_init_msg_list IN VARCHAR2,