APPS.OKL_ITY_PVT dependencies on OKL_INVOICE_TYPES_V

Line 10: FROM okl_invoice_types_v

6: FUNCTION IS_UNIQUE (p_ityv_rec ityv_rec_type) RETURN VARCHAR2
7: IS
8: CURSOR l_ity_csr IS
9: SELECT 'x'
10: FROM okl_invoice_types_v
11: WHERE inf_id = p_ityv_rec.inf_id
12: AND name = p_ityv_rec.name
13: AND id <> NVL(p_ityv_rec.id,-99999);
14:

Line 210: p_token2_value => 'OKL_INVOICE_TYPES_V',

206: p_msg_name => g_no_parent_record,
207: p_token1 => g_col_name_token,
208: p_token1_value => 'inf_id',
209: p_token2 => g_child_table_token,
210: p_token2_value => 'OKL_INVOICE_TYPES_V',
211: p_token3 => g_parent_table_token,
212: p_token3_value => 'OKL_INVOICE_FORMATS_V');
213:
214: -- notify caller of an error

Line 486: -- FUNCTION get_rec for: OKL_INVOICE_TYPES_V

482: BEGIN
483: RETURN(get_rec(p_okl_invoice_types_tl_rec, l_row_notfound));
484: END get_rec;
485: ---------------------------------------------------------------------------
486: -- FUNCTION get_rec for: OKL_INVOICE_TYPES_V
487: ---------------------------------------------------------------------------
488: FUNCTION get_rec (
489: p_ityv_rec IN ityv_rec_type,
490: x_no_data_found OUT NOCOPY BOOLEAN

Line 523: FROM Okl_Invoice_Types_V

519: CREATION_DATE,
520: LAST_UPDATED_BY,
521: LAST_UPDATE_DATE,
522: LAST_UPDATE_LOGIN
523: FROM Okl_Invoice_Types_V
524: WHERE okl_invoice_types_v.id = p_id;
525: l_okl_ityv_pk okl_ityv_pk_csr%ROWTYPE;
526: l_ityv_rec ityv_rec_type;
527: BEGIN

Line 524: WHERE okl_invoice_types_v.id = p_id;

520: LAST_UPDATED_BY,
521: LAST_UPDATE_DATE,
522: LAST_UPDATE_LOGIN
523: FROM Okl_Invoice_Types_V
524: WHERE okl_invoice_types_v.id = p_id;
525: l_okl_ityv_pk okl_ityv_pk_csr%ROWTYPE;
526: l_ityv_rec ityv_rec_type;
527: BEGIN
528: x_no_data_found := TRUE;

Line 575: -- FUNCTION null_out_defaults for: OKL_INVOICE_TYPES_V --

571: RETURN(get_rec(p_ityv_rec, l_row_notfound));
572: END get_rec;
573:
574: ---------------------------------------------------------
575: -- FUNCTION null_out_defaults for: OKL_INVOICE_TYPES_V --
576: ---------------------------------------------------------
577: FUNCTION null_out_defaults (
578: p_ityv_rec IN ityv_rec_type
579: ) RETURN ityv_rec_type IS

Line 672: -- Validate_Attributes for:OKL_INVOICE_TYPES_V --

668: ---------------------------------------------------------------------------
669: -- PROCEDURE Validate_Attributes
670: ---------------------------------------------------------------------------
671: -------------------------------------------------
672: -- Validate_Attributes for:OKL_INVOICE_TYPES_V --
673: -------------------------------------------------
674: FUNCTION Validate_Attributes (
675: p_ityv_rec IN ityv_rec_type
676: ) RETURN VARCHAR2 IS

Line 749: -- Validate_Record for:OKL_INVOICE_TYPES_V --

745: ---------------------------------------------------------------------------
746: -- PROCEDURE Validate_Record
747: ---------------------------------------------------------------------------
748: ---------------------------------------------
749: -- Validate_Record for:OKL_INVOICE_TYPES_V --
750: ---------------------------------------------
751: FUNCTION Validate_Record (
752: p_ityv_rec IN ityv_rec_type
753: ) RETURN VARCHAR2 IS

Line 862: -- validate_row for:OKL_INVOICE_TYPES_V --

858: ---------------------------------------------------------------------------
859: -- PROCEDURE validate_row
860: ---------------------------------------------------------------------------
861: ------------------------------------------
862: -- validate_row for:OKL_INVOICE_TYPES_V --
863: ------------------------------------------
864: PROCEDURE validate_row(
865: p_api_version IN NUMBER,
866: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 1269: -- insert_row for:OKL_INVOICE_TYPES_V --

1265: '_PVT'
1266: );
1267: END insert_row;
1268: ----------------------------------------
1269: -- insert_row for:OKL_INVOICE_TYPES_V --
1270: ----------------------------------------
1271: PROCEDURE insert_row(
1272: p_api_version IN NUMBER,
1273: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 1305: -- Set_Attributes for:OKL_INVOICE_TYPES_V --

1301: l_ityv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1302: RETURN(l_ityv_rec);
1303: END fill_who_columns;
1304: --------------------------------------------
1305: -- Set_Attributes for:OKL_INVOICE_TYPES_V --
1306: --------------------------------------------
1307: FUNCTION Set_Attributes (
1308: p_ityv_rec IN ityv_rec_type,
1309: x_ityv_rec OUT NOCOPY ityv_rec_type

Line 1710: -- lock_row for:OKL_INVOICE_TYPES_V --

1706: '_PVT'
1707: );
1708: END lock_row;
1709: --------------------------------------
1710: -- lock_row for:OKL_INVOICE_TYPES_V --
1711: --------------------------------------
1712: PROCEDURE lock_row(
1713: p_api_version IN NUMBER,
1714: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 2292: -- update_row for:OKL_INVOICE_TYPES_V --

2288: '_PVT'
2289: );
2290: END update_row;
2291: ----------------------------------------
2292: -- update_row for:OKL_INVOICE_TYPES_V --
2293: ----------------------------------------
2294: PROCEDURE update_row(
2295: p_api_version IN NUMBER,
2296: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 2461: -- Set_Attributes for:OKL_INVOICE_TYPES_V --

2457: END IF;
2458: RETURN(l_return_status);
2459: END populate_new_record;
2460: --------------------------------------------
2461: -- Set_Attributes for:OKL_INVOICE_TYPES_V --
2462: --------------------------------------------
2463: FUNCTION Set_Attributes (
2464: p_ityv_rec IN ityv_rec_type,
2465: x_ityv_rec OUT NOCOPY ityv_rec_type

Line 2813: -- delete_row for:OKL_INVOICE_TYPES_V --

2809: '_PVT'
2810: );
2811: END delete_row;
2812: ----------------------------------------
2813: -- delete_row for:OKL_INVOICE_TYPES_V --
2814: ----------------------------------------
2815: PROCEDURE delete_row(
2816: p_api_version IN NUMBER,
2817: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,