DBA Data[Home] [Help]

APPS.OKL_BCH_PVT dependencies on OKL_BILLING_CHARGES_V

Line 17: G_VIEW CONSTANT VARCHAR2(30) := 'OKL_BILLING_CHARGES_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_BILLING_CHARGES_V';
18: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
19:
20: ---------------------------------------------------------------------------
21: -- FUNCTION get_seq_id

Line 323: -- FUNCTION get_rec for: OKL_BILLING_CHARGES_V

319: BEGIN
320: RETURN(get_rec(p_okl_billing_charges_tl_rec, l_row_notfound));
321: END get_rec;
322: ---------------------------------------------------------------------------
323: -- FUNCTION get_rec for: OKL_BILLING_CHARGES_V
324: ---------------------------------------------------------------------------
325: FUNCTION get_rec (
326: p_bchv_rec IN bchv_rec_type,
327: x_no_data_found OUT NOCOPY BOOLEAN

Line 390: FROM Okl_Billing_Charges_V

386: CREATION_DATE,
387: LAST_UPDATED_BY,
388: LAST_UPDATE_DATE,
389: LAST_UPDATE_LOGIN
390: FROM Okl_Billing_Charges_V
391: WHERE okl_billing_charges_v.id = p_id;
392: l_okl_bchv_pk okl_bchv_pk_csr%ROWTYPE;
393: l_bchv_rec bchv_rec_type;
394: BEGIN

Line 391: WHERE okl_billing_charges_v.id = p_id;

387: LAST_UPDATED_BY,
388: LAST_UPDATE_DATE,
389: LAST_UPDATE_LOGIN
390: FROM Okl_Billing_Charges_V
391: WHERE okl_billing_charges_v.id = p_id;
392: l_okl_bchv_pk okl_bchv_pk_csr%ROWTYPE;
393: l_bchv_rec bchv_rec_type;
394: BEGIN
395: x_no_data_found := TRUE;

Line 472: -- FUNCTION null_out_defaults for: OKL_BILLING_CHARGES_V --

468: RETURN(get_rec(p_bchv_rec, l_row_notfound));
469: END get_rec;
470:
471: -----------------------------------------------------------
472: -- FUNCTION null_out_defaults for: OKL_BILLING_CHARGES_V --
473: -----------------------------------------------------------
474: FUNCTION null_out_defaults (
475: p_bchv_rec IN bchv_rec_type
476: ) RETURN bchv_rec_type IS

Line 821: p_token2_value => 'OKL_BILLING_CHARGES_V',

817: p_msg_name => G_NO_PARENT_RECORD,
818: p_token1 => G_COL_NAME_TOKEN,
819: p_token1_value => 'bgh_id',
820: p_token2 => G_CHILD_TABLE_TOKEN,
821: p_token2_value => 'OKL_BILLING_CHARGES_V',
822: p_token3 => G_PARENT_TABLE_TOKEN,
823: p_token3_value => 'OKL_BLLNG_CHRG_HDRS_V');
824:
825: -- notify caller of en error

Line 957: FROM okl_billing_charges_v

953: ) RETURN VARCHAR2 IS
954:
955: CURSOR l_bchv_csr IS
956: SELECT 'x'
957: FROM okl_billing_charges_v
958: WHERE bgh_id = p_bchv_rec.bgh_id
959: AND sequence_number = p_bchv_rec.sequence_number
960: AND id <> NVL (p_bchv_rec.id, -99999);
961:

Line 1021: -- Validate_Attributes for:OKL_BILLING_CHARGES_V --

1017: -- Post-Generation Change
1018: -- By RDRAGUIL on 24-APR-2001
1019: ---------------------------------------------------------------------------
1020: ---------------------------------------------------
1021: -- Validate_Attributes for:OKL_BILLING_CHARGES_V --
1022: ---------------------------------------------------
1023: FUNCTION Validate_Attributes (
1024: p_bchv_rec IN bchv_rec_type
1025: ) RETURN VARCHAR2 IS

Line 1110: -- Validate_Record for:OKL_BILLING_CHARGES_V --

1106: -- Post-Generation Change
1107: -- By RDRAGUIL on 24-APR-2001
1108: ---------------------------------------------------------------------------
1109: -----------------------------------------------
1110: -- Validate_Record for:OKL_BILLING_CHARGES_V --
1111: -----------------------------------------------
1112: FUNCTION Validate_Record (
1113: p_bchv_rec IN bchv_rec_type
1114: ) RETURN VARCHAR2 IS

Line 1310: -- validate_row for:OKL_BILLING_CHARGES_V --

1306: ---------------------------------------------------------------------------
1307: -- PROCEDURE validate_row
1308: ---------------------------------------------------------------------------
1309: --------------------------------------------
1310: -- validate_row for:OKL_BILLING_CHARGES_V --
1311: --------------------------------------------
1312: PROCEDURE validate_row(
1313: p_api_version IN NUMBER,
1314: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 1785: -- insert_row for:OKL_BILLING_CHARGES_V --

1781: '_PVT'
1782: );
1783: END insert_row;
1784: ------------------------------------------
1785: -- insert_row for:OKL_BILLING_CHARGES_V --
1786: ------------------------------------------
1787: PROCEDURE insert_row(
1788: p_api_version IN NUMBER,
1789: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 1821: -- Set_Attributes for:OKL_BILLING_CHARGES_V --

1817: l_bchv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1818: RETURN(l_bchv_rec);
1819: END fill_who_columns;
1820: ----------------------------------------------
1821: -- Set_Attributes for:OKL_BILLING_CHARGES_V --
1822: ----------------------------------------------
1823: FUNCTION Set_Attributes (
1824: p_bchv_rec IN bchv_rec_type,
1825: x_bchv_rec OUT NOCOPY bchv_rec_type

Line 2238: -- lock_row for:OKL_BILLING_CHARGES_V --

2234: '_PVT'
2235: );
2236: END lock_row;
2237: ----------------------------------------
2238: -- lock_row for:OKL_BILLING_CHARGES_V --
2239: ----------------------------------------
2240: PROCEDURE lock_row(
2241: p_api_version IN NUMBER,
2242: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 2978: -- update_row for:OKL_BILLING_CHARGES_V --

2974: '_PVT'
2975: );
2976: END update_row;
2977: ------------------------------------------
2978: -- update_row for:OKL_BILLING_CHARGES_V --
2979: ------------------------------------------
2980: PROCEDURE update_row(
2981: p_api_version IN NUMBER,
2982: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 3267: -- Set_Attributes for:OKL_BILLING_CHARGES_V --

3263: END IF;
3264: RETURN(l_return_status);
3265: END populate_new_record;
3266: ----------------------------------------------
3267: -- Set_Attributes for:OKL_BILLING_CHARGES_V --
3268: ----------------------------------------------
3269: FUNCTION Set_Attributes (
3270: p_bchv_rec IN bchv_rec_type,
3271: x_bchv_rec OUT NOCOPY bchv_rec_type

Line 3644: -- delete_row for:OKL_BILLING_CHARGES_V --

3640: '_PVT'
3641: );
3642: END delete_row;
3643: ------------------------------------------
3644: -- delete_row for:OKL_BILLING_CHARGES_V --
3645: ------------------------------------------
3646: PROCEDURE delete_row(
3647: p_api_version IN NUMBER,
3648: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,