DBA Data[Home] [Help]

APPS.OKL_PXL_PVT dependencies on OKL_EXT_AP_LINE_SOURCES_V

Line 181: -- FUNCTION get_rec for: OKL_EXT_AP_LINE_SOURCES_V

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

Line 237: FROM Okl_Ext_Ap_Line_Sources_V

233: ASSET_CATEGORY_NAME,
234: INVENTORY_ITEM_NAME_CODE,
235: INVENTORY_ITEM_NAME,
236: ASSET_VENDOR_ID
237: FROM Okl_Ext_Ap_Line_Sources_V
238: WHERE okl_ext_ap_line_sources_v.line_extension_id = p_line_extension_id;
239: l_okl_ext_ap_line_sources_v_pk okl_ext_ap_line_sou7%ROWTYPE;
240: l_pxlv_rec pxlv_rec_type;
241: BEGIN

Line 238: WHERE okl_ext_ap_line_sources_v.line_extension_id = p_line_extension_id;

234: INVENTORY_ITEM_NAME_CODE,
235: INVENTORY_ITEM_NAME,
236: ASSET_VENDOR_ID
237: FROM Okl_Ext_Ap_Line_Sources_V
238: WHERE okl_ext_ap_line_sources_v.line_extension_id = p_line_extension_id;
239: l_okl_ext_ap_line_sources_v_pk okl_ext_ap_line_sou7%ROWTYPE;
240: l_pxlv_rec pxlv_rec_type;
241: BEGIN
242: x_no_data_found := TRUE;

Line 239: l_okl_ext_ap_line_sources_v_pk okl_ext_ap_line_sou7%ROWTYPE;

235: INVENTORY_ITEM_NAME,
236: ASSET_VENDOR_ID
237: FROM Okl_Ext_Ap_Line_Sources_V
238: WHERE okl_ext_ap_line_sources_v.line_extension_id = p_line_extension_id;
239: l_okl_ext_ap_line_sources_v_pk okl_ext_ap_line_sou7%ROWTYPE;
240: l_pxlv_rec pxlv_rec_type;
241: BEGIN
242: x_no_data_found := TRUE;
243: -- Get current database values

Line 546: -- FUNCTION null_out_defaults for: OKL_EXT_AP_LINE_SOURCES_V

542: BEGIN
543: RETURN(get_rec(p_pxll_rec, l_row_not_found));
544: END get_rec;
545: ---------------------------------------------------------------------------
546: -- FUNCTION null_out_defaults for: OKL_EXT_AP_LINE_SOURCES_V
547: ---------------------------------------------------------------------------
548: FUNCTION null_out_defaults (
549: p_pxlv_rec IN pxlv_rec_type
550: ) RETURN pxlv_rec_type IS

Line 927: -- Validate_Attributes for:OKL_EXT_AP_LINE_SOURCES_V --

923: ---------------------------------------------------------------------------
924: -- FUNCTION Validate_Attributes
925: ---------------------------------------------------------------------------
926: -------------------------------------------------------
927: -- Validate_Attributes for:OKL_EXT_AP_LINE_SOURCES_V --
928: -------------------------------------------------------
929: FUNCTION Validate_Attributes (
930: p_pxlv_rec IN pxlv_rec_type
931: ) RETURN VARCHAR2 IS

Line 1024: -- Validate Record for:OKL_EXT_AP_LINE_SOURCES_V --

1020: ---------------------------------------------------------------------------
1021: -- PROCEDURE Validate_Record
1022: ---------------------------------------------------------------------------
1023: ---------------------------------------------------
1024: -- Validate Record for:OKL_EXT_AP_LINE_SOURCES_V --
1025: ---------------------------------------------------
1026: FUNCTION Validate_Record (
1027: p_pxlv_rec IN pxlv_rec_type,
1028: p_db_pxlv_rec IN pxlv_rec_type

Line 1184: -- validate_row for:OKL_EXT_AP_LINE_SOURCES_V --

1180: ---------------------------------------------------------------------------
1181: -- PROCEDURE validate_row
1182: ---------------------------------------------------------------------------
1183: ------------------------------------------------
1184: -- validate_row for:OKL_EXT_AP_LINE_SOURCES_V --
1185: ------------------------------------------------
1186: PROCEDURE validate_row(
1187: p_api_version IN NUMBER,
1188: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1261: -- PL/SQL TBL validate_row for:OKL_EXT_AP_LINE_SOURCES_V --

1257: '_PVT'
1258: );
1259: END validate_row;
1260: -----------------------------------------------------------
1261: -- PL/SQL TBL validate_row for:OKL_EXT_AP_LINE_SOURCES_V --
1262: -----------------------------------------------------------
1263: PROCEDURE validate_row(
1264: p_api_version IN NUMBER,
1265: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1357: -- PL/SQL TBL validate_row for:OKL_EXT_AP_LINE_SOURCES_V --

1353: );
1354: END validate_row;
1355:
1356: -----------------------------------------------------------
1357: -- PL/SQL TBL validate_row for:OKL_EXT_AP_LINE_SOURCES_V --
1358: -----------------------------------------------------------
1359: PROCEDURE validate_row(
1360: p_api_version IN NUMBER,
1361: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2232: -- lock_row for: OKL_EXT_AP_LINE_SOURCES_V --

2228: '_PVT'
2229: );
2230: END lock_row;
2231: ---------------------------------------------
2232: -- lock_row for: OKL_EXT_AP_LINE_SOURCES_V --
2233: ---------------------------------------------
2234: PROCEDURE lock_row(
2235: p_api_version IN NUMBER,
2236: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2936: -- update_row for:OKL_EXT_AP_LINE_SOURCES_V --

2932: '_PVT'
2933: );
2934: END update_row;
2935: ----------------------------------------------
2936: -- update_row for:OKL_EXT_AP_LINE_SOURCES_V --
2937: ----------------------------------------------
2938: PROCEDURE update_row(
2939: p_api_version IN NUMBER,
2940: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 3131: -- Set_Attributes for:OKL_EXT_AP_LINE_SOURCES_V --

3127: END IF;
3128: RETURN(l_return_status);
3129: END populate_new_record;
3130: --------------------------------------------------
3131: -- Set_Attributes for:OKL_EXT_AP_LINE_SOURCES_V --
3132: --------------------------------------------------
3133: FUNCTION Set_Attributes (
3134: p_pxlv_rec IN pxlv_rec_type,
3135: x_pxlv_rec OUT NOCOPY pxlv_rec_type

Line 3565: -- delete_row for:OKL_EXT_AP_LINE_SOURCES_V --

3561: '_PVT'
3562: );
3563: END delete_row;
3564: ----------------------------------------------
3565: -- delete_row for:OKL_EXT_AP_LINE_SOURCES_V --
3566: ----------------------------------------------
3567: PROCEDURE delete_row(
3568: p_api_version IN NUMBER,
3569: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 3661: -- PL/SQL TBL delete_row for:OKL_EXT_AP_LINE_SOURCES_V --

3657: '_PVT'
3658: );
3659: END delete_row;
3660: ---------------------------------------------------------
3661: -- PL/SQL TBL delete_row for:OKL_EXT_AP_LINE_SOURCES_V --
3662: ---------------------------------------------------------
3663: PROCEDURE delete_row(
3664: p_api_version IN NUMBER,
3665: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 3757: -- PL/SQL TBL delete_row for:OKL_EXT_AP_LINE_SOURCES_V --

3753: );
3754: END delete_row;
3755:
3756: ---------------------------------------------------------
3757: -- PL/SQL TBL delete_row for:OKL_EXT_AP_LINE_SOURCES_V --
3758: ---------------------------------------------------------
3759: PROCEDURE delete_row(
3760: p_api_version IN NUMBER,
3761: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,