APPS.OKL_ILT_PVT dependencies on OKL_INVC_LINE_TYPES_V

Line 10: FROM okl_invc_line_types_v

6: FUNCTION IS_UNIQUE (p_iltv_rec iltv_rec_type) RETURN VARCHAR2
7: IS
8: CURSOR l_ilt_csr IS
9: SELECT 'x'
10: FROM okl_invc_line_types_v
11: WHERE ity_id = p_iltv_rec.ity_id
12: AND name = p_iltv_rec.name
13: AND id <> NVL(p_iltv_rec.id,-99999);
14:

Line 220: p_token2_value => 'OKL_INVC_LINE_TYPES_V',

216: p_msg_name => g_no_parent_record,
217: p_token1 => g_col_name_token,
218: p_token1_value => 'ity_id',
219: p_token2 => g_child_table_token,
220: p_token2_value => 'OKL_INVC_LINE_TYPES_V',
221: p_token3 => g_parent_table_token,
222: p_token3_value => 'OKL_INVOICE_TYPES_V');
223:
224: -- notify caller of an error

Line 493: -- FUNCTION get_rec for: OKL_INVC_LINE_TYPES_V

489: BEGIN
490: RETURN(get_rec(p_okl_invc_line_types_tl_rec, l_row_notfound));
491: END get_rec;
492: ---------------------------------------------------------------------------
493: -- FUNCTION get_rec for: OKL_INVC_LINE_TYPES_V
494: ---------------------------------------------------------------------------
495: FUNCTION get_rec (
496: p_iltv_rec IN iltv_rec_type,
497: x_no_data_found OUT NOCOPY BOOLEAN

Line 529: FROM Okl_Invc_Line_Types_V

525: CREATION_DATE,
526: LAST_UPDATED_BY,
527: LAST_UPDATE_DATE,
528: LAST_UPDATE_LOGIN
529: FROM Okl_Invc_Line_Types_V
530: WHERE okl_invc_line_types_v.id = p_id;
531: l_okl_iltv_pk okl_iltv_pk_csr%ROWTYPE;
532: l_iltv_rec iltv_rec_type;
533: BEGIN

Line 530: WHERE okl_invc_line_types_v.id = p_id;

526: LAST_UPDATED_BY,
527: LAST_UPDATE_DATE,
528: LAST_UPDATE_LOGIN
529: FROM Okl_Invc_Line_Types_V
530: WHERE okl_invc_line_types_v.id = p_id;
531: l_okl_iltv_pk okl_iltv_pk_csr%ROWTYPE;
532: l_iltv_rec iltv_rec_type;
533: BEGIN
534: x_no_data_found := TRUE;

Line 580: -- FUNCTION null_out_defaults for: OKL_INVC_LINE_TYPES_V --

576: RETURN(get_rec(p_iltv_rec, l_row_notfound));
577: END get_rec;
578:
579: -----------------------------------------------------------
580: -- FUNCTION null_out_defaults for: OKL_INVC_LINE_TYPES_V --
581: -----------------------------------------------------------
582: FUNCTION null_out_defaults (
583: p_iltv_rec IN iltv_rec_type
584: ) RETURN iltv_rec_type IS

Line 674: -- Validate_Attributes for:OKL_INVC_LINE_TYPES_V --

670: ---------------------------------------------------------------------------
671: -- PROCEDURE Validate_Attributes
672: ---------------------------------------------------------------------------
673: ---------------------------------------------------
674: -- Validate_Attributes for:OKL_INVC_LINE_TYPES_V --
675: ---------------------------------------------------
676: FUNCTION Validate_Attributes (
677: p_iltv_rec IN iltv_rec_type
678: ) RETURN VARCHAR2 IS

Line 742: -- Validate_Record for:OKL_INVC_LINE_TYPES_V --

738: ---------------------------------------------------------------------------
739: -- PROCEDURE Validate_Record
740: ---------------------------------------------------------------------------
741: -----------------------------------------------
742: -- Validate_Record for:OKL_INVC_LINE_TYPES_V --
743: -----------------------------------------------
744: FUNCTION Validate_Record (
745: p_iltv_rec IN iltv_rec_type
746: ) RETURN VARCHAR2 IS

Line 853: -- validate_row for:OKL_INVC_LINE_TYPES_V --

849: ---------------------------------------------------------------------------
850: -- PROCEDURE validate_row
851: ---------------------------------------------------------------------------
852: --------------------------------------------
853: -- validate_row for:OKL_INVC_LINE_TYPES_V --
854: --------------------------------------------
855: PROCEDURE validate_row(
856: p_api_version IN NUMBER,
857: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 1258: -- insert_row for:OKL_INVC_LINE_TYPES_V --

1254: '_PVT'
1255: );
1256: END insert_row;
1257: ------------------------------------------
1258: -- insert_row for:OKL_INVC_LINE_TYPES_V --
1259: ------------------------------------------
1260: PROCEDURE insert_row(
1261: p_api_version IN NUMBER,
1262: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 1294: -- Set_Attributes for:OKL_INVC_LINE_TYPES_V --

1290: l_iltv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1291: RETURN(l_iltv_rec);
1292: END fill_who_columns;
1293: ----------------------------------------------
1294: -- Set_Attributes for:OKL_INVC_LINE_TYPES_V --
1295: ----------------------------------------------
1296: FUNCTION Set_Attributes (
1297: p_iltv_rec IN iltv_rec_type,
1298: x_iltv_rec OUT NOCOPY iltv_rec_type

Line 1690: -- lock_row for:OKL_INVC_LINE_TYPES_V --

1686: '_PVT'
1687: );
1688: END lock_row;
1689: ----------------------------------------
1690: -- lock_row for:OKL_INVC_LINE_TYPES_V --
1691: ----------------------------------------
1692: PROCEDURE lock_row(
1693: p_api_version IN NUMBER,
1694: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 2267: -- update_row for:OKL_INVC_LINE_TYPES_V --

2263: '_PVT'
2264: );
2265: END update_row;
2266: ------------------------------------------
2267: -- update_row for:OKL_INVC_LINE_TYPES_V --
2268: ------------------------------------------
2269: PROCEDURE update_row(
2270: p_api_version IN NUMBER,
2271: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 2432: -- Set_Attributes for:OKL_INVC_LINE_TYPES_V --

2428: END IF;
2429: RETURN(l_return_status);
2430: END populate_new_record;
2431: ----------------------------------------------
2432: -- Set_Attributes for:OKL_INVC_LINE_TYPES_V --
2433: ----------------------------------------------
2434: FUNCTION Set_Attributes (
2435: p_iltv_rec IN iltv_rec_type,
2436: x_iltv_rec OUT NOCOPY iltv_rec_type

Line 2784: -- delete_row for:OKL_INVC_LINE_TYPES_V --

2780: '_PVT'
2781: );
2782: END delete_row;
2783: ------------------------------------------
2784: -- delete_row for:OKL_INVC_LINE_TYPES_V --
2785: ------------------------------------------
2786: PROCEDURE delete_row(
2787: p_api_version IN NUMBER,
2788: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,