DBA Data[Home] [Help]

APPS.OKL_CSB_PVT dependencies on OKL_CRTRN_SBCLSSES_V

Line 95: p_token3_value => 'OKL_CRTRN_SBCLSSES_V');

91: p_token1_value => 'CRN_ID_FOR',
92: p_token2 => G_CHILD_TABLE_TOKEN,
93: p_token2_value => G_VIEW,
94: p_token3 => G_PARENT_TABLE_TOKEN,
95: p_token3_value => 'OKL_CRTRN_SBCLSSES_V');
96:
97: RAISE G_EXCEPTION_HALT_VALIDATION;
98: END IF;
99: END validate_crn_id;

Line 145: p_token3_value => 'OKL_CRTRN_SBCLSSES_V');

141: p_token1_value => 'SCS_CODE',
142: p_token2 => G_CHILD_TABLE_TOKEN,
143: p_token2_value => G_VIEW,
144: p_token3 => G_PARENT_TABLE_TOKEN,
145: p_token3_value => 'OKL_CRTRN_SBCLSSES_V');
146:
147: RAISE G_EXCEPTION_HALT_VALIDATION;
148: END IF;
149:

Line 266: -- FUNCTION get_rec for: OKL_CRTRN_SBCLSSES_V

262: BEGIN
263: RETURN(get_rec(p_csb_rec, l_row_notfound));
264: END get_rec;
265: ---------------------------------------------------------------------------
266: -- FUNCTION get_rec for: OKL_CRTRN_SBCLSSES_V
267: ---------------------------------------------------------------------------
268: FUNCTION get_rec (
269: p_csbv_rec IN csbv_rec_type,
270: x_no_data_found OUT NOCOPY BOOLEAN

Line 299: FROM Okl_Crtrn_Sbclsses_V

295: CREATION_DATE,
296: LAST_UPDATED_BY,
297: LAST_UPDATE_DATE,
298: LAST_UPDATE_LOGIN
299: FROM Okl_Crtrn_Sbclsses_V
300: WHERE okl_crtrn_sbclsses_v.id = p_id;
301: l_okl_csbv_pk okl_csbv_pk_csr%ROWTYPE;
302: l_csbv_rec csbv_rec_type;
303: BEGIN

Line 300: WHERE okl_crtrn_sbclsses_v.id = p_id;

296: LAST_UPDATED_BY,
297: LAST_UPDATE_DATE,
298: LAST_UPDATE_LOGIN
299: FROM Okl_Crtrn_Sbclsses_V
300: WHERE okl_crtrn_sbclsses_v.id = p_id;
301: l_okl_csbv_pk okl_csbv_pk_csr%ROWTYPE;
302: l_csbv_rec csbv_rec_type;
303: BEGIN
304: x_no_data_found := TRUE;

Line 347: -- FUNCTION null_out_defaults for: OKL_CRTRN_SBCLSSES_V --

343: RETURN(get_rec(p_csbv_rec, l_row_notfound));
344: END get_rec;
345:
346: ----------------------------------------------------------
347: -- FUNCTION null_out_defaults for: OKL_CRTRN_SBCLSSES_V --
348: ----------------------------------------------------------
349: FUNCTION null_out_defaults (
350: p_csbv_rec IN csbv_rec_type
351: ) RETURN csbv_rec_type IS

Line 432: -- Validate_Attributes for:OKL_CRTRN_SBCLSSES_V --

428: ---------------------------------------------------------------------------
429: -- PROCEDURE Validate_Attributes
430: ---------------------------------------------------------------------------
431: --------------------------------------------------
432: -- Validate_Attributes for:OKL_CRTRN_SBCLSSES_V --
433: --------------------------------------------------
434: FUNCTION Validate_Attributes (
435: p_csbv_rec IN csbv_rec_type
436: ) RETURN VARCHAR2 IS

Line 492: -- Validate_Record for:OKL_CRTRN_SBCLSSES_V --

488: ---------------------------------------------------------------------------
489: -- PROCEDURE Validate_Record
490: ---------------------------------------------------------------------------
491: ----------------------------------------------
492: -- Validate_Record for:OKL_CRTRN_SBCLSSES_V --
493: ----------------------------------------------
494: FUNCTION Validate_Record (
495: p_csbv_rec IN csbv_rec_type
496: ) RETURN VARCHAR2 IS

Line 572: -- validate_row for:OKL_CRTRN_SBCLSSES_V --

568: ---------------------------------------------------------------------------
569: -- PROCEDURE validate_row
570: ---------------------------------------------------------------------------
571: -------------------------------------------
572: -- validate_row for:OKL_CRTRN_SBCLSSES_V --
573: -------------------------------------------
574: PROCEDURE validate_row(
575: p_api_version IN NUMBER,
576: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 851: -- insert_row for:OKL_CRTRN_SBCLSSES_V --

847: '_PVT'
848: );
849: END insert_row;
850: -----------------------------------------
851: -- insert_row for:OKL_CRTRN_SBCLSSES_V --
852: -----------------------------------------
853: PROCEDURE insert_row(
854: p_api_version IN NUMBER,
855: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 885: -- Set_Attributes for:OKL_CRTRN_SBCLSSES_V --

881: l_csbv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
882: RETURN(l_csbv_rec);
883: END fill_who_columns;
884: ---------------------------------------------
885: -- Set_Attributes for:OKL_CRTRN_SBCLSSES_V --
886: ---------------------------------------------
887: FUNCTION Set_Attributes (
888: p_csbv_rec IN csbv_rec_type,
889: x_csbv_rec OUT NOCOPY csbv_rec_type

Line 1171: -- lock_row for:OKL_CRTRN_SBCLSSES_V --

1167: '_PVT'
1168: );
1169: END lock_row;
1170: ---------------------------------------
1171: -- lock_row for:OKL_CRTRN_SBCLSSES_V --
1172: ---------------------------------------
1173: PROCEDURE lock_row(
1174: p_api_version IN NUMBER,
1175: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 1554: -- update_row for:OKL_CRTRN_SBCLSSES_V --

1550: '_PVT'
1551: );
1552: END update_row;
1553: -----------------------------------------
1554: -- update_row for:OKL_CRTRN_SBCLSSES_V --
1555: -----------------------------------------
1556: PROCEDURE update_row(
1557: p_api_version IN NUMBER,
1558: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 1705: -- Set_Attributes for:OKL_CRTRN_SBCLSSES_V --

1701: END IF;
1702: RETURN(l_return_status);
1703: END populate_new_record;
1704: ---------------------------------------------
1705: -- Set_Attributes for:OKL_CRTRN_SBCLSSES_V --
1706: ---------------------------------------------
1707: FUNCTION Set_Attributes (
1708: p_csbv_rec IN csbv_rec_type,
1709: x_csbv_rec OUT NOCOPY csbv_rec_type

Line 1949: -- delete_row for:OKL_CRTRN_SBCLSSES_V --

1945: '_PVT'
1946: );
1947: END delete_row;
1948: -----------------------------------------
1949: -- delete_row for:OKL_CRTRN_SBCLSSES_V --
1950: -----------------------------------------
1951: PROCEDURE delete_row(
1952: p_api_version IN NUMBER,
1953: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,