DBA Data[Home] [Help]

APPS.OKL_TEH_PVT dependencies on OKL_TRX_EXTENSION_V

Line 181: -- FUNCTION get_rec for: OKL_TRX_EXTENSION_V

177: );
178: END add_language;
179:
180: ---------------------------------------------------------------------------
181: -- FUNCTION get_rec for: OKL_TRX_EXTENSION_V
182: ---------------------------------------------------------------------------
183: FUNCTION get_rec (
184: p_tehv_rec IN tehv_rec_type,
185: x_no_data_found OUT NOCOPY BOOLEAN

Line 259: FROM Okl_Trx_Extension_V

255: CHR_OPERATING_UNIT_CODE,
256: PARTY_ID,
257: CUST_ACCOUNT_ID,
258: CUST_SITE_USE_ID
259: FROM Okl_Trx_Extension_V
260: WHERE okl_trx_extension_v.header_extension_id = p_header_extension_id;
261: l_okl_trx_extension_pk okl_trx_extension_pk_csr%ROWTYPE;
262: l_tehv_rec tehv_rec_type;
263: BEGIN

Line 260: WHERE okl_trx_extension_v.header_extension_id = p_header_extension_id;

256: PARTY_ID,
257: CUST_ACCOUNT_ID,
258: CUST_SITE_USE_ID
259: FROM Okl_Trx_Extension_V
260: WHERE okl_trx_extension_v.header_extension_id = p_header_extension_id;
261: l_okl_trx_extension_pk okl_trx_extension_pk_csr%ROWTYPE;
262: l_tehv_rec tehv_rec_type;
263: BEGIN
264: x_no_data_found := TRUE;

Line 634: -- FUNCTION null_out_defaults for: OKL_TRX_EXTENSION_V

630: BEGIN
631: RETURN(get_rec(p_tehl_rec, l_row_not_found));
632: END get_rec;
633: ---------------------------------------------------------------------------
634: -- FUNCTION null_out_defaults for: OKL_TRX_EXTENSION_V
635: ---------------------------------------------------------------------------
636: FUNCTION null_out_defaults (
637: p_tehv_rec IN tehv_rec_type
638: ) RETURN tehv_rec_type IS

Line 1094: -- Validate_Attributes for:OKL_TRX_EXTENSION_V --

1090: ---------------------------------------------------------------------------
1091: -- FUNCTION Validate_Attributes
1092: ---------------------------------------------------------------------------
1093: -------------------------------------------------
1094: -- Validate_Attributes for:OKL_TRX_EXTENSION_V --
1095: -------------------------------------------------
1096: FUNCTION Validate_Attributes (
1097: p_tehv_rec IN tehv_rec_type
1098: ) RETURN VARCHAR2 IS

Line 1169: -- Validate Record for:OKL_TRX_EXTENSION_V --

1165: ---------------------------------------------------------------------------
1166: -- PROCEDURE Validate_Record
1167: ---------------------------------------------------------------------------
1168: ---------------------------------------------
1169: -- Validate Record for:OKL_TRX_EXTENSION_V --
1170: ---------------------------------------------
1171: FUNCTION Validate_Record (
1172: p_tehv_rec IN tehv_rec_type,
1173: p_db_tehv_rec IN tehv_rec_type

Line 1373: -- validate_row for:OKL_TRX_EXTENSION_V --

1369: ---------------------------------------------------------------------------
1370: -- PROCEDURE validate_row
1371: ---------------------------------------------------------------------------
1372: ------------------------------------------
1373: -- validate_row for:OKL_TRX_EXTENSION_V --
1374: ------------------------------------------
1375: PROCEDURE validate_row(
1376: p_api_version IN NUMBER,
1377: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1450: -- PL/SQL TBL validate_row for:OKL_TRX_EXTENSION_V --

1446: '_PVT'
1447: );
1448: END validate_row;
1449: -----------------------------------------------------
1450: -- PL/SQL TBL validate_row for:OKL_TRX_EXTENSION_V --
1451: -----------------------------------------------------
1452: PROCEDURE validate_row(
1453: p_api_version IN NUMBER,
1454: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1546: -- PL/SQL TBL validate_row for:OKL_TRX_EXTENSION_V --

1542: );
1543: END validate_row;
1544:
1545: -----------------------------------------------------
1546: -- PL/SQL TBL validate_row for:OKL_TRX_EXTENSION_V --
1547: -----------------------------------------------------
1548: PROCEDURE validate_row(
1549: p_api_version IN NUMBER,
1550: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2469: -- lock_row for: OKL_TRX_EXTENSION_V --

2465: '_PVT'
2466: );
2467: END lock_row;
2468: ---------------------------------------
2469: -- lock_row for: OKL_TRX_EXTENSION_V --
2470: ---------------------------------------
2471: PROCEDURE lock_row(
2472: p_api_version IN NUMBER,
2473: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 3261: -- update_row for:OKL_TRX_EXTENSION_V --

3257: '_PVT'
3258: );
3259: END update_row;
3260: ----------------------------------------
3261: -- update_row for:OKL_TRX_EXTENSION_V --
3262: ----------------------------------------
3263: PROCEDURE update_row(
3264: p_api_version IN NUMBER,
3265: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 3522: -- Set_Attributes for:OKL_TRX_EXTENSION_V --

3518: END IF;
3519: RETURN(l_return_status);
3520: END populate_new_record;
3521: --------------------------------------------
3522: -- Set_Attributes for:OKL_TRX_EXTENSION_V --
3523: --------------------------------------------
3524: FUNCTION Set_Attributes (
3525: p_tehv_rec IN tehv_rec_type,
3526: x_tehv_rec OUT NOCOPY tehv_rec_type

Line 3956: -- delete_row for:OKL_TRX_EXTENSION_V --

3952: '_PVT'
3953: );
3954: END delete_row;
3955: ----------------------------------------
3956: -- delete_row for:OKL_TRX_EXTENSION_V --
3957: ----------------------------------------
3958: PROCEDURE delete_row(
3959: p_api_version IN NUMBER,
3960: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 4052: -- PL/SQL TBL delete_row for:OKL_TRX_EXTENSION_V --

4048: '_PVT'
4049: );
4050: END delete_row;
4051: ---------------------------------------------------
4052: -- PL/SQL TBL delete_row for:OKL_TRX_EXTENSION_V --
4053: ---------------------------------------------------
4054: PROCEDURE delete_row(
4055: p_api_version IN NUMBER,
4056: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 4148: -- PL/SQL TBL delete_row for:OKL_TRX_EXTENSION_V --

4144: );
4145: END delete_row;
4146:
4147: ---------------------------------------------------
4148: -- PL/SQL TBL delete_row for:OKL_TRX_EXTENSION_V --
4149: ---------------------------------------------------
4150: PROCEDURE delete_row(
4151: p_api_version IN NUMBER,
4152: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,