[Home] [Help]
9: RETURN(Okc_P_Util.raw_to_number(sys_guid()));
10: END get_seq_id;
11:
12: ---------------------------------------------------------------------------
13: -- FUNCTION get_rec for: OKL_SIF_PRICING_PARAMS
14: ---------------------------------------------------------------------------
15: FUNCTION get_rec (
16: p_spm_rec IN spm_rec_type,
17: x_no_data_found OUT NOCOPY BOOLEAN
15: FUNCTION get_rec (
16: p_spm_rec IN spm_rec_type,
17: x_no_data_found OUT NOCOPY BOOLEAN
18: ) RETURN spm_rec_type IS
19: CURSOR okl_sif_pricing_params_pk_csr (p_id IN NUMBER) IS
20: SELECT ID
21: ,OBJECT_VERSION_NUMBER
22: ,SIF_ID
23: ,khr_id
32: ,CREATION_DATE
33: ,LAST_UPDATED_BY
34: ,LAST_UPDATE_DATE
35: ,LAST_UPDATE_LOGIN
36: FROM OKL_SIF_PRICING_PARAMS
37: WHERE OKL_SIF_PRICING_PARAMS.id = p_id;
38:
39: l_okl_sif_pricing_params_pk okl_sif_pricing_params_pk_csr%ROWTYPE;
40: l_spm_rec spm_rec_type;
33: ,LAST_UPDATED_BY
34: ,LAST_UPDATE_DATE
35: ,LAST_UPDATE_LOGIN
36: FROM OKL_SIF_PRICING_PARAMS
37: WHERE OKL_SIF_PRICING_PARAMS.id = p_id;
38:
39: l_okl_sif_pricing_params_pk okl_sif_pricing_params_pk_csr%ROWTYPE;
40: l_spm_rec spm_rec_type;
41: BEGIN
35: ,LAST_UPDATE_LOGIN
36: FROM OKL_SIF_PRICING_PARAMS
37: WHERE OKL_SIF_PRICING_PARAMS.id = p_id;
38:
39: l_okl_sif_pricing_params_pk okl_sif_pricing_params_pk_csr%ROWTYPE;
40: l_spm_rec spm_rec_type;
41: BEGIN
42: x_no_data_found := TRUE;
43:
41: BEGIN
42: x_no_data_found := TRUE;
43:
44: -- Get current database values
45: OPEN okl_sif_pricing_params_pk_csr (p_spm_rec.id);
46:
47: FETCH okl_sif_pricing_params_pk_csr INTO
48: l_spm_rec.id
49: ,l_spm_rec.object_version_number
43:
44: -- Get current database values
45: OPEN okl_sif_pricing_params_pk_csr (p_spm_rec.id);
46:
47: FETCH okl_sif_pricing_params_pk_csr INTO
48: l_spm_rec.id
49: ,l_spm_rec.object_version_number
50: ,l_spm_rec.sif_id
51: ,l_spm_rec.khr_id
61: ,l_spm_rec.last_updated_by
62: ,l_spm_rec.last_update_date
63: ,l_spm_rec.last_update_login;
64:
65: x_no_data_found := okl_sif_pricing_params_pk_csr%NOTFOUND;
66: CLOSE okl_sif_pricing_params_pk_csr;
67:
68: RETURN(l_spm_rec);
69:
62: ,l_spm_rec.last_update_date
63: ,l_spm_rec.last_update_login;
64:
65: x_no_data_found := okl_sif_pricing_params_pk_csr%NOTFOUND;
66: CLOSE okl_sif_pricing_params_pk_csr;
67:
68: RETURN(l_spm_rec);
69:
70: END get_rec;
76: BEGIN
77: RETURN(get_rec(p_spm_rec, l_row_notfound));
78: END get_rec;
79: ---------------------------------------------------------------------------
80: -- FUNCTION get_rec for: OKL_SIF_PRICING_PARAMS_V
81: ---------------------------------------------------------------------------
82: FUNCTION get_rec (
83: p_spmv_rec IN spmv_rec_type,
84: x_no_data_found OUT NOCOPY BOOLEAN
100: ,CREATION_DATE
101: ,LAST_UPDATED_BY
102: ,LAST_UPDATE_DATE
103: ,LAST_UPDATE_LOGIN
104: FROM OKL_SIF_PRICING_PARAMS_V
105: WHERE OKL_SIF_PRICING_PARAMS_V.ID = p_id;
106:
107: l_okl_spmv_pk okl_spmv_pk_csr%ROWTYPE;
108: l_spmv_rec spmv_rec_type;
101: ,LAST_UPDATED_BY
102: ,LAST_UPDATE_DATE
103: ,LAST_UPDATE_LOGIN
104: FROM OKL_SIF_PRICING_PARAMS_V
105: WHERE OKL_SIF_PRICING_PARAMS_V.ID = p_id;
106:
107: l_okl_spmv_pk okl_spmv_pk_csr%ROWTYPE;
108: l_spmv_rec spmv_rec_type;
109: BEGIN
517: -- Start of comments
518: --
519: -- Procedure Name : insert_row
520: -- Description : procedure for inserting the records in
521: -- table OKL_SIF_PRICING_PARAMS
522: -- Business Rules :
523: -- Parameters :
524: -- Version : 1.0
525: -- End of comments
538: l_spm_rec spm_rec_type := p_spm_rec;
539: l_def_spm_rec spm_rec_type;
540:
541: ---------------------------------------------
542: -- Set_Attributes for:OKL_SIF_PRICING_PARAMS --
543: ---------------------------------------------
544: FUNCTION Set_Attributes (
545: p_spm_rec IN spm_rec_type,
546: x_spm_rec OUT NOCOPY spm_rec_type
575: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
576: RAISE Okl_Api.G_EXCEPTION_ERROR;
577: END IF;
578:
579: INSERT INTO OKL_SIF_PRICING_PARAMS(
580: ID
581: ,OBJECT_VERSION_NUMBER
582: ,SIF_ID
583: ,KHR_ID
686: RETURN(l_spmv_rec);
687: END fill_who_columns;
688:
689: -----------------------------------------------
690: -- Set_Attributes for:OKL_SIF_PRICING_PARAMS_V --
691: -----------------------------------------------
692: FUNCTION Set_Attributes (
693: p_spmv_rec IN spmv_rec_type,
694: x_spmv_rec OUT NOCOPY spmv_rec_type
900: -- Start of comments
901: --
902: -- Procedure Name : update_row
903: -- Description : procedure for updating the records in
904: -- table OKL_SIF_PRICING_PARAMS
905: -- Business Rules :
906: -- Parameters :
907: -- Version : 1.0
908: -- End of comments
1000: RETURN(l_return_status);
1001: END populate_new_record;
1002:
1003: ---------------------------------------------
1004: -- Set_Attributes for:OKL_SIF_PRICING_PARAMS --
1005: ---------------------------------------------
1006: FUNCTION Set_Attributes (
1007: p_spm_rec IN spm_rec_type,
1008: x_spm_rec OUT NOCOPY spm_rec_type
1042: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1043: RAISE Okl_Api.G_EXCEPTION_ERROR;
1044: END IF;
1045:
1046: UPDATE OKL_SIF_PRICING_PARAMS
1047: SET ID = l_def_spm_rec.id
1048: ,OBJECT_VERSION_NUMBER = l_def_spm_rec.object_version_number
1049: ,SIF_ID = l_def_spm_rec.sif_id
1050: ,KHR_ID = l_def_spm_rec.khr_id
1097: );
1098: END update_row;
1099:
1100: -------------------------------------------------------
1101: -- PL/SQL TBL update_row for: OKL_SIF_PRICING_PARAMS --
1102: -------------------------------------------------------
1103: PROCEDURE update_row(
1104: p_api_version IN NUMBER,
1105: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1325: );
1326: END;
1327:
1328: -------------------------------------------------------
1329: -- PL/SQL TBL update_row for:OKL_SIF_PRICING_PARAMS_V --
1330: -------------------------------------------------------
1331: PROCEDURE update_row(
1332: p_api_version IN NUMBER,
1333: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,