APPS.OKC_MRD_PVT dependencies on OKC_MASSCHANGE_REQ_DTLS_V

Line 9: G_VIEW CONSTANT VARCHAR2(200) := 'OKC_MASSCHANGE_REQ_DTLS_V';

5:
6: G_EXCEPTION_HALT_VALIDATION exception;
7: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
8: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKC_NO_PARENT_RECORD';
9: G_VIEW CONSTANT VARCHAR2(200) := 'OKC_MASSCHANGE_REQ_DTLS_V';
10: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
11: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
12:
13: -- Start of comments

Line 307: -- FUNCTION get_rec for: OKC_MASSCHANGE_REQ_DTLS_V

303: BEGIN
304: RETURN(get_rec(p_mrd_rec, l_row_notfound));
305: END get_rec;
306: ---------------------------------------------------------------------------
307: -- FUNCTION get_rec for: OKC_MASSCHANGE_REQ_DTLS_V
308: ---------------------------------------------------------------------------
309: FUNCTION get_rec (
310: p_mrdv_rec IN mrdv_rec_type,
311: x_no_data_found OUT NOCOPY BOOLEAN

Line 327: FROM Okc_Masschange_Req_Dtls_V

323: CREATION_DATE,
324: LAST_UPDATED_BY,
325: LAST_UPDATE_DATE,
326: LAST_UPDATE_LOGIN
327: FROM Okc_Masschange_Req_Dtls_V
328: WHERE okc_masschange_req_dtls_v.id = p_id;
329: l_omrv_pk omrv_pk_csr%ROWTYPE;
330: l_mrdv_rec mrdv_rec_type;
331: BEGIN

Line 328: WHERE okc_masschange_req_dtls_v.id = p_id;

324: LAST_UPDATED_BY,
325: LAST_UPDATE_DATE,
326: LAST_UPDATE_LOGIN
327: FROM Okc_Masschange_Req_Dtls_V
328: WHERE okc_masschange_req_dtls_v.id = p_id;
329: l_omrv_pk omrv_pk_csr%ROWTYPE;
330: l_mrdv_rec mrdv_rec_type;
331: BEGIN
332: x_no_data_found := TRUE;

Line 362: -- FUNCTION null_out_defaults for: OKC_MASSCHANGE_REQ_DTLS_V --

358: RETURN(get_rec(p_mrdv_rec, l_row_notfound));
359: END get_rec;
360:
361: ---------------------------------------------------------------
362: -- FUNCTION null_out_defaults for: OKC_MASSCHANGE_REQ_DTLS_V --
363: ---------------------------------------------------------------
364: FUNCTION null_out_defaults (
365: p_mrdv_rec IN mrdv_rec_type
366: ) RETURN mrdv_rec_type IS

Line 408: -- Validate_Attributes for:OKC_MASSCHANGE_REQ_DTLS_V --

404: ---------------------------------------------------------------------------
405: -- PROCEDURE Validate_Attributes
406: ---------------------------------------------------------------------------
407: -------------------------------------------------------
408: -- Validate_Attributes for:OKC_MASSCHANGE_REQ_DTLS_V --
409: -------------------------------------------------------
410: FUNCTION Validate_Attributes (
411: p_mrdv_rec IN mrdv_rec_type
412: ) RETURN VARCHAR2 IS

Line 472: -- Validate_Record for:OKC_MASSCHANGE_REQ_DTLS_V --

468: ---------------------------------------------------------------------------
469: -- PROCEDURE Validate_Record
470: ---------------------------------------------------------------------------
471: ---------------------------------------------------
472: -- Validate_Record for:OKC_MASSCHANGE_REQ_DTLS_V --
473: ---------------------------------------------------
474: FUNCTION Validate_Record (
475: p_mrdv_rec IN mrdv_rec_type
476: ) RETURN VARCHAR2 IS

Line 526: -- validate_row for:OKC_MASSCHANGE_REQ_DTLS_V --

522: ---------------------------------------------------------------------------
523: -- PROCEDURE validate_row
524: ---------------------------------------------------------------------------
525: ------------------------------------------------
526: -- validate_row for:OKC_MASSCHANGE_REQ_DTLS_V --
527: ------------------------------------------------
528: PROCEDURE validate_row(
529: p_api_version IN NUMBER,
530: p_init_msg_list IN VARCHAR2 ,

Line 789: -- insert_row for:OKC_MASSCHANGE_REQ_DTLS_V --

785: '_PVT'
786: );
787: END insert_row;
788: ----------------------------------------------
789: -- insert_row for:OKC_MASSCHANGE_REQ_DTLS_V --
790: ----------------------------------------------
791: PROCEDURE insert_row(
792: p_api_version IN NUMBER,
793: p_init_msg_list IN VARCHAR2 ,

Line 823: -- Set_Attributes for:OKC_MASSCHANGE_REQ_DTLS_V --

819: l_mrdv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
820: RETURN(l_mrdv_rec);
821: END fill_who_columns;
822: --------------------------------------------------
823: -- Set_Attributes for:OKC_MASSCHANGE_REQ_DTLS_V --
824: --------------------------------------------------
825: FUNCTION Set_Attributes (
826: p_mrdv_rec IN mrdv_rec_type,
827: x_mrdv_rec OUT NOCOPY mrdv_rec_type

Line 1119: -- lock_row for:OKC_MASSCHANGE_REQ_DTLS_V --

1115: '_PVT'
1116: );
1117: END lock_row;
1118: --------------------------------------------
1119: -- lock_row for:OKC_MASSCHANGE_REQ_DTLS_V --
1120: --------------------------------------------
1121: PROCEDURE lock_row(
1122: p_api_version IN NUMBER,
1123: p_init_msg_list IN VARCHAR2 ,

Line 1446: -- update_row for:OKC_MASSCHANGE_REQ_DTLS_V --

1442: '_PVT'
1443: );
1444: END update_row;
1445: ----------------------------------------------
1446: -- update_row for:OKC_MASSCHANGE_REQ_DTLS_V --
1447: ----------------------------------------------
1448: PROCEDURE update_row(
1449: p_api_version IN NUMBER,
1450: p_init_msg_list IN VARCHAR2 ,

Line 1544: -- Set_Attributes for:OKC_MASSCHANGE_REQ_DTLS_V --

1540: END IF;
1541: RETURN(l_return_status);
1542: END populate_new_record;
1543: --------------------------------------------------
1544: -- Set_Attributes for:OKC_MASSCHANGE_REQ_DTLS_V --
1545: --------------------------------------------------
1546: FUNCTION Set_Attributes (
1547: p_mrdv_rec IN mrdv_rec_type,
1548: x_mrdv_rec OUT NOCOPY mrdv_rec_type

Line 1797: -- delete_row for:OKC_MASSCHANGE_REQ_DTLS_V --

1793: '_PVT'
1794: );
1795: END delete_row;
1796: ----------------------------------------------
1797: -- delete_row for:OKC_MASSCHANGE_REQ_DTLS_V --
1798: ----------------------------------------------
1799: PROCEDURE delete_row(
1800: p_api_version IN NUMBER,
1801: p_init_msg_list IN VARCHAR2 ,