DBA Data[Home] [Help]

APPS.OKL_TAP_PVT dependencies on OKL_TRX_AP_INVOICES_V

Line 763: FROM OKL_TRX_AP_INVOICES_V

759: l_return_status varchar2(1) := OKL_Api.G_RET_STS_SUCCESS;
760: l_dummy_var VARCHAR2(1) := '?';
761: CURSOR l_tapv_csr IS
762: SELECT 'x'
763: FROM OKL_TRX_AP_INVOICES_V
764: WHERE id = p_tapv_rec.tap_id_reverses;
765: BEGIN
766: x_return_status := OKL_Api.G_RET_STS_SUCCESS;
767: IF(p_tapv_rec.tap_id_reverses IS NOT NULL) THEN

Line 793: p_token3_value => 'OKL_TRX_AP_INVOICES_V');

789: p_token1_value => 'tap_id_reverses',
790: p_token2 => g_child_table_token,
791: p_token2_value => g_view,
792: p_token3 => g_parent_table_token,
793: p_token3_value => 'OKL_TRX_AP_INVOICES_V');
794: x_return_status := OKL_Api.G_RET_STS_ERROR;
795: RAISE G_EXCEPTION_HALT_VALIDATION;
796: END IF;
797: EXCEPTION

Line 1576: FROM OKL_TRX_AP_INVOICES_V

1572: l_dummy_var VARCHAR2(1) := '0';
1573:
1574: CURSOR l_asset_tap_id_csr IS
1575: SELECT '1'
1576: FROM OKL_TRX_AP_INVOICES_V
1577: WHERE id = p_tapv_rec.asset_tap_id;
1578:
1579: BEGIN
1580: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 1596: p_token3_value => 'OKL_TRX_AP_INVOICES_V');

1592: p_token1_value => 'ASSET_TAP_ID',
1593: p_token2 => G_CHILD_TABLE_TOKEN,
1594: p_token2_value => G_VIEW,
1595: p_token3 => G_PARENT_TABLE_TOKEN,
1596: p_token3_value => 'OKL_TRX_AP_INVOICES_V');
1597:
1598: END IF;
1599: END IF;
1600:

Line 1914: -- FUNCTION get_rec for: OKL_TRX_AP_INVOICES_V

1910: BEGIN
1911: RETURN(get_rec(p_okl_trx_ap_invoices_tl_rec, l_row_notfound));
1912: END get_rec;
1913: ---------------------------------------------------------------------------
1914: -- FUNCTION get_rec for: OKL_TRX_AP_INVOICES_V
1915: ---------------------------------------------------------------------------
1916: FUNCTION get_rec (
1917: p_tapv_rec IN tapv_rec_type,
1918: x_no_data_found OUT NOCOPY BOOLEAN

Line 1993: FROM Okl_Trx_Ap_Invoices_V

1989: ASSET_TAP_ID,
1990: -- 30-OCT-2006 ANSETHUR R12B - Legal Entity
1991: legal_entity_id
1992: ,transaction_date
1993: FROM Okl_Trx_Ap_Invoices_V
1994: WHERE okl_trx_ap_invoices_v.id = p_id;
1995: l_okl_tapv_pk okl_tapv_pk_csr%ROWTYPE;
1996: l_tapv_rec tapv_rec_type;
1997: BEGIN

Line 1994: WHERE okl_trx_ap_invoices_v.id = p_id;

1990: -- 30-OCT-2006 ANSETHUR R12B - Legal Entity
1991: legal_entity_id
1992: ,transaction_date
1993: FROM Okl_Trx_Ap_Invoices_V
1994: WHERE okl_trx_ap_invoices_v.id = p_id;
1995: l_okl_tapv_pk okl_tapv_pk_csr%ROWTYPE;
1996: l_tapv_rec tapv_rec_type;
1997: BEGIN
1998: x_no_data_found := TRUE;

Line 2085: -- FUNCTION null_out_defaults for: OKL_TRX_AP_INVOICES_V --

2081: BEGIN
2082: RETURN(get_rec(p_tapv_rec, l_row_notfound));
2083: END get_rec;
2084: -----------------------------------------------------------
2085: -- FUNCTION null_out_defaults for: OKL_TRX_AP_INVOICES_V --
2086: -----------------------------------------------------------
2087: FUNCTION null_out_defaults (
2088: p_tapv_rec IN tapv_rec_type
2089: ) RETURN tapv_rec_type IS

Line 2324: -- PROCEDURE Validate_Attributes for:OKL_TRX_AP_INVOICES_V : Modified for PostGen-12

2320:
2321: RETURN(l_tapv_rec);
2322: END null_out_defaults;
2323: ------------------------------------------------------------------------------------
2324: -- PROCEDURE Validate_Attributes for:OKL_TRX_AP_INVOICES_V : Modified for PostGen-12
2325: ------------------------------------------------------------------------------------
2326: FUNCTION Validate_Attributes
2327: ( p_tapv_rec IN tapv_rec_type
2328: ) RETURN VARCHAR2 IS

Line 2698: -- PROCEDURE Validate_Record for:OKL_TRX_AP_INVOICES_V : Modified for PostGen-13

2694: x_return_status := OKL_Api.G_RET_STS_UNEXP_ERROR; -- Notify caller of this error
2695: return x_return_status; -- Return status to the caller
2696: END Validate_Attributes;
2697: --------------------------------------------------------------------------------
2698: -- PROCEDURE Validate_Record for:OKL_TRX_AP_INVOICES_V : Modified for PostGen-13
2699: --------------------------------------------------------------------------------
2700: FUNCTION Validate_Record
2701: ( p_tapv_rec IN tapv_rec_type
2702: ) RETURN VARCHAR2 IS

Line 2958: -- validate_row for:OKL_TRX_AP_INVOICES_V --

2954: ---------------------------------------------------------------------------
2955: -- PROCEDURE validate_row
2956: ---------------------------------------------------------------------------
2957: --------------------------------------------
2958: -- validate_row for:OKL_TRX_AP_INVOICES_V --
2959: --------------------------------------------
2960: PROCEDURE validate_row(
2961: p_api_version IN NUMBER,
2962: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 3453: -- insert_row for:OKL_TRX_AP_INVOICES_V --

3449: '_PVT'
3450: );
3451: END insert_row;
3452: ------------------------------------------
3453: -- insert_row for:OKL_TRX_AP_INVOICES_V --
3454: ------------------------------------------
3455: PROCEDURE insert_row(
3456: p_api_version IN NUMBER,
3457: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 3488: -- Set_Attributes for:OKL_TRX_AP_INVOICES_V --

3484: l_tapv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
3485: RETURN(l_tapv_rec);
3486: END fill_who_columns;
3487: ----------------------------------------------
3488: -- Set_Attributes for:OKL_TRX_AP_INVOICES_V --
3489: ----------------------------------------------
3490: FUNCTION Set_Attributes (
3491: p_tapv_rec IN tapv_rec_type,
3492: x_tapv_rec OUT NOCOPY tapv_rec_type

Line 3888: -- lock_row for:OKL_TRX_AP_INVOICES_V --

3884: '_PVT'
3885: );
3886: END lock_row;
3887: ----------------------------------------
3888: -- lock_row for:OKL_TRX_AP_INVOICES_V --
3889: ----------------------------------------
3890: PROCEDURE lock_row(
3891: p_api_version IN NUMBER,
3892: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 4691: -- update_row for:OKL_TRX_AP_INVOICES_V --

4687: '_PVT'
4688: );
4689: END update_row;
4690: ------------------------------------------
4691: -- update_row for:OKL_TRX_AP_INVOICES_V --
4692: ------------------------------------------
4693: PROCEDURE update_row(
4694: p_api_version IN NUMBER,
4695: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 5045: -- Set_Attributes for:OKL_TRX_AP_INVOICES_V --

5041:
5042: RETURN(l_return_status);
5043: END populate_new_record;
5044: ----------------------------------------------
5045: -- Set_Attributes for:OKL_TRX_AP_INVOICES_V --
5046: ----------------------------------------------
5047: FUNCTION Set_Attributes (
5048: p_tapv_rec IN tapv_rec_type,
5049: x_tapv_rec OUT NOCOPY tapv_rec_type

Line 5406: -- delete_row for:OKL_TRX_AP_INVOICES_V --

5402: '_PVT'
5403: );
5404: END delete_row;
5405: ------------------------------------------
5406: -- delete_row for:OKL_TRX_AP_INVOICES_V --
5407: ------------------------------------------
5408: PROCEDURE delete_row(
5409: p_api_version IN NUMBER,
5410: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,