APPS.OKL_BGH_PVT dependencies on OKL_BLLNG_CHRG_HDRS_V

Line 17: G_VIEW CONSTANT VARCHAR2(30) := 'OKL_BLLNG_CHRG_HDRS_V';

13: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
14: G_NOT_SAME CONSTANT VARCHAR2(200) := 'OKL_CANNOT_BE_SAME';
15:
16: --GLOBAL VARIABLES
17: G_VIEW CONSTANT VARCHAR2(30) := 'OKL_BLLNG_CHRG_HDRS_V';
18: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
19:
20: ---------------------------------------------------------------------------
21: -- FUNCTION get_seq_id

Line 280: -- FUNCTION get_rec for: OKL_BLLNG_CHRG_HDRS_V

276: BEGIN
277: RETURN(get_rec(p_okl_bllng_chrg_hdrs_tl_rec, l_row_notfound));
278: END get_rec;
279: ---------------------------------------------------------------------------
280: -- FUNCTION get_rec for: OKL_BLLNG_CHRG_HDRS_V
281: ---------------------------------------------------------------------------
282: FUNCTION get_rec (
283: p_bghv_rec IN bghv_rec_type,
284: x_no_data_found OUT NOCOPY BOOLEAN

Line 323: FROM Okl_Bllng_Chrg_Hdrs_V

319: CREATION_DATE,
320: LAST_UPDATED_BY,
321: LAST_UPDATE_DATE,
322: LAST_UPDATE_LOGIN
323: FROM Okl_Bllng_Chrg_Hdrs_V
324: WHERE okl_bllng_chrg_hdrs_v.id = p_id;
325: l_okl_bghv_pk okl_bghv_pk_csr%ROWTYPE;
326: l_bghv_rec bghv_rec_type;
327: BEGIN

Line 324: WHERE okl_bllng_chrg_hdrs_v.id = p_id;

320: LAST_UPDATED_BY,
321: LAST_UPDATE_DATE,
322: LAST_UPDATE_LOGIN
323: FROM Okl_Bllng_Chrg_Hdrs_V
324: WHERE okl_bllng_chrg_hdrs_v.id = p_id;
325: l_okl_bghv_pk okl_bghv_pk_csr%ROWTYPE;
326: l_bghv_rec bghv_rec_type;
327: BEGIN
328: x_no_data_found := TRUE;

Line 381: -- FUNCTION null_out_defaults for: OKL_BLLNG_CHRG_HDRS_V --

377: RETURN(get_rec(p_bghv_rec, l_row_notfound));
378: END get_rec;
379:
380: -----------------------------------------------------------
381: -- FUNCTION null_out_defaults for: OKL_BLLNG_CHRG_HDRS_V --
382: -----------------------------------------------------------
383: FUNCTION null_out_defaults (
384: p_bghv_rec IN bghv_rec_type
385: ) RETURN bghv_rec_type IS

Line 812: FROM okl_bllng_chrg_hdrs_v

808: ) RETURN VARCHAR2 IS
809:
810: CURSOR l_bghv_csr IS
811: SELECT 'x'
812: FROM okl_bllng_chrg_hdrs_v
813: WHERE name = p_bghv_rec.name
814: AND sequence_number = p_bghv_rec.sequence_number
815: AND id <> NVL (p_bghv_rec.id, -99999);
816:

Line 876: -- Validate_Attributes for:OKL_BLLNG_CHRG_HDRS_V --

872: -- Post-Generation Change
873: -- By RDRAGUIL on 24-APR-2001
874: ---------------------------------------------------------------------------
875: ---------------------------------------------------
876: -- Validate_Attributes for:OKL_BLLNG_CHRG_HDRS_V --
877: ---------------------------------------------------
878: FUNCTION Validate_Attributes (
879: p_bghv_rec IN bghv_rec_type
880: ) RETURN VARCHAR2 IS

Line 975: -- Validate_Record for:OKL_BLLNG_CHRG_HDRS_V --

971: -- Post-Generation Change
972: -- By RDRAGUIL on 24-APR-2001
973: ---------------------------------------------------------------------------
974: -----------------------------------------------
975: -- Validate_Record for:OKL_BLLNG_CHRG_HDRS_V --
976: -----------------------------------------------
977: FUNCTION Validate_Record (
978: p_bghv_rec IN bghv_rec_type
979: ) RETURN VARCHAR2 IS

Line 1127: -- validate_row for:OKL_BLLNG_CHRG_HDRS_V --

1123: ---------------------------------------------------------------------------
1124: -- PROCEDURE validate_row
1125: ---------------------------------------------------------------------------
1126: --------------------------------------------
1127: -- validate_row for:OKL_BLLNG_CHRG_HDRS_V --
1128: --------------------------------------------
1129: PROCEDURE validate_row(
1130: p_api_version IN NUMBER,
1131: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 1554: -- insert_row for:OKL_BLLNG_CHRG_HDRS_V --

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

Line 1590: -- Set_Attributes for:OKL_BLLNG_CHRG_HDRS_V --

1586: l_bghv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1587: RETURN(l_bghv_rec);
1588: END fill_who_columns;
1589: ----------------------------------------------
1590: -- Set_Attributes for:OKL_BLLNG_CHRG_HDRS_V --
1591: ----------------------------------------------
1592: FUNCTION Set_Attributes (
1593: p_bghv_rec IN bghv_rec_type,
1594: x_bghv_rec OUT NOCOPY bghv_rec_type

Line 2007: -- lock_row for:OKL_BLLNG_CHRG_HDRS_V --

2003: '_PVT'
2004: );
2005: END lock_row;
2006: ----------------------------------------
2007: -- lock_row for:OKL_BLLNG_CHRG_HDRS_V --
2008: ----------------------------------------
2009: PROCEDURE lock_row(
2010: p_api_version IN NUMBER,
2011: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 2627: -- update_row for:OKL_BLLNG_CHRG_HDRS_V --

2623: '_PVT'
2624: );
2625: END update_row;
2626: ------------------------------------------
2627: -- update_row for:OKL_BLLNG_CHRG_HDRS_V --
2628: ------------------------------------------
2629: PROCEDURE update_row(
2630: p_api_version IN NUMBER,
2631: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 2820: -- Set_Attributes for:OKL_BLLNG_CHRG_HDRS_V --

2816: END IF;
2817: RETURN(l_return_status);
2818: END populate_new_record;
2819: ----------------------------------------------
2820: -- Set_Attributes for:OKL_BLLNG_CHRG_HDRS_V --
2821: ----------------------------------------------
2822: FUNCTION Set_Attributes (
2823: p_bghv_rec IN bghv_rec_type,
2824: x_bghv_rec OUT NOCOPY bghv_rec_type

Line 3197: -- delete_row for:OKL_BLLNG_CHRG_HDRS_V --

3193: '_PVT'
3194: );
3195: END delete_row;
3196: ------------------------------------------
3197: -- delete_row for:OKL_BLLNG_CHRG_HDRS_V --
3198: ------------------------------------------
3199: PROCEDURE delete_row(
3200: p_api_version IN NUMBER,
3201: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,