APPS.OKL_INF_PVT dependencies on OKL_INVOICE_FORMATS_V

Line 10: FROM okl_invoice_formats_v

6: FUNCTION IS_UNIQUE (p_infv_rec infv_rec_type) RETURN VARCHAR2
7: IS
8: CURSOR l_inf_csr IS
9: SELECT 'x'
10: FROM okl_invoice_formats_v
11: WHERE name = p_infv_rec.name
12: AND id <> NVL(p_infv_rec.id,-99999);
13:
14: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;

Line 181: p_token2_value => 'OKL_INVOICE_FORMATS_V',

177: p_msg_name => g_no_parent_record,
178: p_token1 => g_col_name_token,
179: p_token1_value => 'ilt_id',
180: p_token2 => g_child_table_token,
181: p_token2_value => 'OKL_INVOICE_FORMATS_V',
182: p_token3 => g_parent_table_token,
183: p_token3_value => 'OKL_INVC_LINE_TYPES_V');
184:
185: -- notify caller of an error

Line 459: -- FUNCTION get_rec for: OKL_INVOICE_FORMATS_V

455: BEGIN
456: RETURN(get_rec(p_okl_invoice_formats_tl_rec, l_row_notfound));
457: END get_rec;
458: ---------------------------------------------------------------------------
459: -- FUNCTION get_rec for: OKL_INVOICE_FORMATS_V
460: ---------------------------------------------------------------------------
461: FUNCTION get_rec (
462: p_infv_rec IN infv_rec_type,
463: x_no_data_found OUT NOCOPY BOOLEAN

Line 497: FROM Okl_Invoice_Formats_V

493: CREATION_DATE,
494: LAST_UPDATED_BY,
495: LAST_UPDATE_DATE,
496: LAST_UPDATE_LOGIN
497: FROM Okl_Invoice_Formats_V
498: WHERE okl_invoice_formats_v.id = p_id;
499: l_okl_infv_pk okl_infv_pk_csr%ROWTYPE;
500: l_infv_rec infv_rec_type;
501: BEGIN

Line 498: WHERE okl_invoice_formats_v.id = p_id;

494: LAST_UPDATED_BY,
495: LAST_UPDATE_DATE,
496: LAST_UPDATE_LOGIN
497: FROM Okl_Invoice_Formats_V
498: WHERE okl_invoice_formats_v.id = p_id;
499: l_okl_infv_pk okl_infv_pk_csr%ROWTYPE;
500: l_infv_rec infv_rec_type;
501: BEGIN
502: x_no_data_found := TRUE;

Line 550: -- FUNCTION null_out_defaults for: OKL_INVOICE_FORMATS_V --

546: RETURN(get_rec(p_infv_rec, l_row_notfound));
547: END get_rec;
548:
549: -----------------------------------------------------------
550: -- FUNCTION null_out_defaults for: OKL_INVOICE_FORMATS_V --
551: -----------------------------------------------------------
552: FUNCTION null_out_defaults (
553: p_infv_rec IN infv_rec_type
554: ) RETURN infv_rec_type IS

Line 653: -- Validate_Attributes for:OKL_INVOICE_FORMATS_V --

649: ---------------------------------------------------------------------------
650: -- PROCEDURE Validate_Attributes
651: ---------------------------------------------------------------------------
652: ---------------------------------------------------
653: -- Validate_Attributes for:OKL_INVOICE_FORMATS_V --
654: ---------------------------------------------------
655: FUNCTION Validate_Attributes (
656: p_infv_rec IN infv_rec_type
657: ) RETURN VARCHAR2 IS

Line 720: -- Validate_Record for:OKL_INVOICE_FORMATS_V --

716: ---------------------------------------------------------------------------
717: -- PROCEDURE Validate_Record
718: ---------------------------------------------------------------------------
719: -----------------------------------------------
720: -- Validate_Record for:OKL_INVOICE_FORMATS_V --
721: -----------------------------------------------
722: FUNCTION Validate_Record (
723: p_infv_rec IN infv_rec_type
724: ) RETURN VARCHAR2 IS

Line 837: -- validate_row for:OKL_INVOICE_FORMATS_V --

833: ---------------------------------------------------------------------------
834: -- PROCEDURE validate_row
835: ---------------------------------------------------------------------------
836: --------------------------------------------
837: -- validate_row for:OKL_INVOICE_FORMATS_V --
838: --------------------------------------------
839: PROCEDURE validate_row(
840: p_api_version IN NUMBER,
841: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 1272: -- insert_row for:OKL_INVOICE_FORMATS_V --

1268: );
1269: */
1270: END insert_row;
1271: ------------------------------------------
1272: -- insert_row for:OKL_INVOICE_FORMATS_V --
1273: ------------------------------------------
1274: PROCEDURE insert_row(
1275: p_api_version IN NUMBER,
1276: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 1308: -- Set_Attributes for:OKL_INVOICE_FORMATS_V --

1304: l_infv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1305: RETURN(l_infv_rec);
1306: END fill_who_columns;
1307: ----------------------------------------------
1308: -- Set_Attributes for:OKL_INVOICE_FORMATS_V --
1309: ----------------------------------------------
1310: FUNCTION Set_Attributes (
1311: p_infv_rec IN infv_rec_type,
1312: x_infv_rec OUT NOCOPY infv_rec_type

Line 1713: -- lock_row for:OKL_INVOICE_FORMATS_V --

1709: '_PVT'
1710: );
1711: END lock_row;
1712: ----------------------------------------
1713: -- lock_row for:OKL_INVOICE_FORMATS_V --
1714: ----------------------------------------
1715: PROCEDURE lock_row(
1716: p_api_version IN NUMBER,
1717: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 2307: -- update_row for:OKL_INVOICE_FORMATS_V --

2303: '_PVT'
2304: );
2305: END update_row;
2306: ------------------------------------------
2307: -- update_row for:OKL_INVOICE_FORMATS_V --
2308: ------------------------------------------
2309: PROCEDURE update_row(
2310: p_api_version IN NUMBER,
2311: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 2484: -- Set_Attributes for:OKL_INVOICE_FORMATS_V --

2480: END IF;
2481: RETURN(l_return_status);
2482: END populate_new_record;
2483: ----------------------------------------------
2484: -- Set_Attributes for:OKL_INVOICE_FORMATS_V --
2485: ----------------------------------------------
2486: FUNCTION Set_Attributes (
2487: p_infv_rec IN infv_rec_type,
2488: x_infv_rec OUT NOCOPY infv_rec_type

Line 2836: -- delete_row for:OKL_INVOICE_FORMATS_V --

2832: '_PVT'
2833: );
2834: END delete_row;
2835: ------------------------------------------
2836: -- delete_row for:OKL_INVOICE_FORMATS_V --
2837: ------------------------------------------
2838: PROCEDURE delete_row(
2839: p_api_version IN NUMBER,
2840: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,