eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_GTP_PVT dependencies on OKL_ST_GEN_PRC_PARAMS

Line 14: -- FUNCTION get_rec for: OKL_ST_GEN_PRC_PARAMS

10: END get_seq_id;
11:
12:
13: ---------------------------------------------------------------------------
14: -- FUNCTION get_rec for: OKL_ST_GEN_PRC_PARAMS
15: ---------------------------------------------------------------------------
16: FUNCTION get_rec (
17: p_gtp_rec IN gtp_rec_type,
18: x_no_data_found OUT NOCOPY BOOLEAN

Line 20: CURSOR okl_st_gen_prc_params_pk_csr (p_id IN NUMBER) IS

16: FUNCTION get_rec (
17: p_gtp_rec IN gtp_rec_type,
18: x_no_data_found OUT NOCOPY BOOLEAN
19: ) RETURN gtp_rec_type IS
20: CURSOR okl_st_gen_prc_params_pk_csr (p_id IN NUMBER) IS
21: SELECT ID
22: ,OBJECT_VERSION_NUMBER
23: ,NAME
24: ,DESCRIPTION

Line 36: FROM OKL_ST_GEN_PRC_PARAMS

32: ,LAST_UPDATED_BY
33: ,LAST_UPDATE_DATE
34: ,LAST_UPDATE_LOGIN
35: ,GTT_ID
36: FROM OKL_ST_GEN_PRC_PARAMS
37: WHERE OKL_ST_GEN_PRC_PARAMS.id = p_id;
38:
39: l_okl_st_gen_prc_params_pk okl_st_gen_prc_params_pk_csr%ROWTYPE;
40: l_gtp_rec gtp_rec_type;

Line 37: WHERE OKL_ST_GEN_PRC_PARAMS.id = p_id;

33: ,LAST_UPDATE_DATE
34: ,LAST_UPDATE_LOGIN
35: ,GTT_ID
36: FROM OKL_ST_GEN_PRC_PARAMS
37: WHERE OKL_ST_GEN_PRC_PARAMS.id = p_id;
38:
39: l_okl_st_gen_prc_params_pk okl_st_gen_prc_params_pk_csr%ROWTYPE;
40: l_gtp_rec gtp_rec_type;
41: BEGIN

Line 39: l_okl_st_gen_prc_params_pk okl_st_gen_prc_params_pk_csr%ROWTYPE;

35: ,GTT_ID
36: FROM OKL_ST_GEN_PRC_PARAMS
37: WHERE OKL_ST_GEN_PRC_PARAMS.id = p_id;
38:
39: l_okl_st_gen_prc_params_pk okl_st_gen_prc_params_pk_csr%ROWTYPE;
40: l_gtp_rec gtp_rec_type;
41: BEGIN
42: x_no_data_found := TRUE;
43:

Line 45: OPEN okl_st_gen_prc_params_pk_csr (p_gtp_rec.id);

41: BEGIN
42: x_no_data_found := TRUE;
43:
44: -- Get current database values
45: OPEN okl_st_gen_prc_params_pk_csr (p_gtp_rec.id);
46:
47: FETCH okl_st_gen_prc_params_pk_csr INTO
48: l_gtp_rec.id
49: ,l_gtp_rec.object_version_number

Line 47: FETCH okl_st_gen_prc_params_pk_csr INTO

43:
44: -- Get current database values
45: OPEN okl_st_gen_prc_params_pk_csr (p_gtp_rec.id);
46:
47: FETCH okl_st_gen_prc_params_pk_csr INTO
48: l_gtp_rec.id
49: ,l_gtp_rec.object_version_number
50: ,l_gtp_rec.name
51: ,l_gtp_rec.description

Line 64: x_no_data_found := okl_st_gen_prc_params_pk_csr%NOTFOUND;

60: ,l_gtp_rec.last_update_date
61: ,l_gtp_rec.last_update_login
62: ,l_gtp_rec.gtt_id;
63:
64: x_no_data_found := okl_st_gen_prc_params_pk_csr%NOTFOUND;
65: CLOSE okl_st_gen_prc_params_pk_csr;
66:
67: RETURN(l_gtp_rec);
68:

Line 65: CLOSE okl_st_gen_prc_params_pk_csr;

61: ,l_gtp_rec.last_update_login
62: ,l_gtp_rec.gtt_id;
63:
64: x_no_data_found := okl_st_gen_prc_params_pk_csr%NOTFOUND;
65: CLOSE okl_st_gen_prc_params_pk_csr;
66:
67: RETURN(l_gtp_rec);
68:
69: END get_rec;

Line 79: -- FUNCTION get_rec for: OKL_ST_GEN_PRC_PARAMS_V

75: BEGIN
76: RETURN(get_rec(p_gtp_rec, l_row_notfound));
77: END get_rec;
78: ---------------------------------------------------------------------------
79: -- FUNCTION get_rec for: OKL_ST_GEN_PRC_PARAMS_V
80: ---------------------------------------------------------------------------
81: FUNCTION get_rec (
82: p_gtpv_rec IN gtpv_rec_type,
83: x_no_data_found OUT NOCOPY BOOLEAN

Line 101: FROM OKL_ST_GEN_PRC_PARAMS

97: ,LAST_UPDATED_BY
98: ,LAST_UPDATE_DATE
99: ,LAST_UPDATE_LOGIN
100: ,GTT_ID
101: FROM OKL_ST_GEN_PRC_PARAMS
102: WHERE OKL_ST_GEN_PRC_PARAMS.ID = p_id;
103:
104: l_okl_gtpv_pk okl_gtpv_pk_csr%ROWTYPE;
105: l_gtpv_rec gtpv_rec_type;

Line 102: WHERE OKL_ST_GEN_PRC_PARAMS.ID = p_id;

98: ,LAST_UPDATE_DATE
99: ,LAST_UPDATE_LOGIN
100: ,GTT_ID
101: FROM OKL_ST_GEN_PRC_PARAMS
102: WHERE OKL_ST_GEN_PRC_PARAMS.ID = p_id;
103:
104: l_okl_gtpv_pk okl_gtpv_pk_csr%ROWTYPE;
105: l_gtpv_rec gtpv_rec_type;
106: BEGIN

Line 309: CURSOR okl_st_gen_prc_params_csr(p_name OKL_ST_GEN_PRC_PARAMS.name%type,

305: p_gtpv_rec IN gtpv_rec_type,
306: x_return_status OUT NOCOPY VARCHAR2
307: ) IS
308:
309: CURSOR okl_st_gen_prc_params_csr(p_name OKL_ST_GEN_PRC_PARAMS.name%type,
310: p_gtt_id OKL_ST_GEN_PRC_PARAMS.gtt_id%TYPE ) IS
311: SELECT ID,
312: NAME PRC_PARAM_NAME
313: FROM OKL_ST_GEN_PRC_PARAMS gtp

Line 310: p_gtt_id OKL_ST_GEN_PRC_PARAMS.gtt_id%TYPE ) IS

306: x_return_status OUT NOCOPY VARCHAR2
307: ) IS
308:
309: CURSOR okl_st_gen_prc_params_csr(p_name OKL_ST_GEN_PRC_PARAMS.name%type,
310: p_gtt_id OKL_ST_GEN_PRC_PARAMS.gtt_id%TYPE ) IS
311: SELECT ID,
312: NAME PRC_PARAM_NAME
313: FROM OKL_ST_GEN_PRC_PARAMS gtp
314: WHERE UPPER(gtp.name) = upper( p_name )

Line 313: FROM OKL_ST_GEN_PRC_PARAMS gtp

309: CURSOR okl_st_gen_prc_params_csr(p_name OKL_ST_GEN_PRC_PARAMS.name%type,
310: p_gtt_id OKL_ST_GEN_PRC_PARAMS.gtt_id%TYPE ) IS
311: SELECT ID,
312: NAME PRC_PARAM_NAME
313: FROM OKL_ST_GEN_PRC_PARAMS gtp
314: WHERE UPPER(gtp.name) = upper( p_name )
315: AND gtp.gtt_id = p_gtt_id;
316: l_name_in_use VARCHAR2(1) := okl_api.G_FALSE;
317: BEGIN

Line 329: FOR gtpv_temp_rec In okl_st_gen_prc_params_csr(p_gtpv_rec.name,p_gtpv_rec.gtt_id)

325: RAISE G_EXCEPTION_HALT_VALIDATION;
326: ELSE
327: -- Check for the pricing parameter within this template and with the same name
328: -- and with different ID. Because in Update you may update the existing pricing param name.
329: FOR gtpv_temp_rec In okl_st_gen_prc_params_csr(p_gtpv_rec.name,p_gtpv_rec.gtt_id)
330: LOOP
331: IF( gtpv_temp_rec.id <> p_gtpv_rec.id )
332: THEN
333: l_name_in_use := Okl_Api.G_TRUE;

Line 807: -- table OKL_ST_GEN_PRC_PARAMS

803: -- Start of comments
804: --
805: -- Procedure Name : insert_row
806: -- Description : procedure for inserting the records in
807: -- table OKL_ST_GEN_PRC_PARAMS
808: -- Business Rules :
809: -- Parameters :
810: -- Version : 1.0
811: -- End of comments

Line 830: -- Set_Attributes for:OKL_ST_GEN_PRC_PARAMS --

826: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
827: l_gtp_rec gtp_rec_type := p_gtp_rec;
828: l_def_gtp_rec gtp_rec_type;
829: ---------------------------------------------
830: -- Set_Attributes for:OKL_ST_GEN_PRC_PARAMS --
831: ---------------------------------------------
832: FUNCTION Set_Attributes (
833: p_gtp_rec IN gtp_rec_type,
834: x_gtp_rec OUT NOCOPY gtp_rec_type

Line 865: INSERT INTO OKL_ST_GEN_PRC_PARAMS(

861: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
862: RAISE Okl_Api.G_EXCEPTION_ERROR;
863: END IF;
864:
865: INSERT INTO OKL_ST_GEN_PRC_PARAMS(
866: ID
867: ,OBJECT_VERSION_NUMBER
868: ,NAME
869: ,DESCRIPTION

Line 1186: -- table OKL_ST_GEN_PRC_PARAMS

1182: -- Start of comments
1183: --
1184: -- Procedure Name : update_row
1185: -- Description : procedure for updating the records in
1186: -- table OKL_ST_GEN_PRC_PARAMS
1187: -- Business Rules :
1188: -- Parameters :
1189: -- Version : 1.0
1190: -- End of comments

Line 1283: -- Set_Attributes for:OKL_ST_GEN_PRC_PARAMS --

1279: END IF;
1280: RETURN(l_return_status);
1281: END populate_new_record;
1282: ---------------------------------------------
1283: -- Set_Attributes for:OKL_ST_GEN_PRC_PARAMS --
1284: ---------------------------------------------
1285: FUNCTION Set_Attributes (
1286: p_gtp_rec IN gtp_rec_type,
1287: x_gtp_rec OUT NOCOPY gtp_rec_type

Line 1323: UPDATE OKL_ST_GEN_PRC_PARAMS

1319: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1320: RAISE Okl_Api.G_EXCEPTION_ERROR;
1321: END IF;
1322:
1323: UPDATE OKL_ST_GEN_PRC_PARAMS
1324: SET ID = l_def_gtp_rec.id
1325: ,OBJECT_VERSION_NUMBER = l_def_gtp_rec.object_version_number
1326: ,NAME = l_def_gtp_rec.name
1327: ,DESCRIPTION = l_def_gtp_rec.description

Line 1483: -- Set_Attributes for: OKL_ST_GEN_PRC_PARAMS_v --

1479: END IF;
1480: RETURN(l_return_status);
1481: END populate_new_record;
1482: ----------------------------------------------
1483: -- Set_Attributes for: OKL_ST_GEN_PRC_PARAMS_v --
1484: ----------------------------------------------
1485: FUNCTION Set_Attributes (
1486: p_gtpv_rec IN gtpv_rec_type,
1487: x_gtpv_rec OUT NOCOPY gtpv_rec_type

Line 1599: -- PL/SQL TBL update_row for:OKL_ST_GEN_PRC_PARAMS_V --

1595: );
1596: END;
1597:
1598: -------------------------------------------------------
1599: -- PL/SQL TBL update_row for:OKL_ST_GEN_PRC_PARAMS_V --
1600: -------------------------------------------------------
1601: PROCEDURE update_row(
1602: p_api_version IN NUMBER,
1603: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 1681: -- delete_row for:OKL_ST_GEN_PRC_PARAMS --

1677: ---------------------------------------------------------------------------
1678: -- PROCEDURE delete_row
1679: ---------------------------------------------------------------------------
1680: ------------------------------------------
1681: -- delete_row for:OKL_ST_GEN_PRC_PARAMS --
1682: ------------------------------------------
1683: PROCEDURE delete_row(
1684: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1685: x_return_status OUT NOCOPY VARCHAR2,

Line 1707: DELETE FROM OKL_ST_GEN_PRC_PARAMS

1703: RAISE Okl_Api.G_EXCEPTION_ERROR;
1704: END IF;
1705:
1706: -- Actual deletion of the row
1707: DELETE FROM OKL_ST_GEN_PRC_PARAMS
1708: WHERE ID = l_gtp_rec.id;
1709:
1710: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1711:

Line 1746: -- delete_row for:OKL_ST_GEN_PRC_PARAMS_V --

1742: );
1743: END delete_row;
1744:
1745: --------------------------------------------
1746: -- delete_row for:OKL_ST_GEN_PRC_PARAMS_V --
1747: --------------------------------------------
1748: PROCEDURE delete_row(
1749: p_api_version IN NUMBER,
1750: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 1832: -- PL/SQL TBL delete_row for: OKL_ST_GEN_PRC_PARAMS_V --

1828:
1829:
1830:
1831: --------------------------------------------------------
1832: -- PL/SQL TBL delete_row for: OKL_ST_GEN_PRC_PARAMS_V --
1833: --------------------------------------------------------
1834: PROCEDURE delete_row(
1835: p_api_version IN NUMBER,
1836: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,