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_SETUPDSFPARAMETERS_PVT dependencies on OKL_FNCTN_PRMTRS_V

Line 5: -- PROCEDURE get_rec for: OKL_FNCTN_PRMTRS_V

1: PACKAGE BODY OKL_SETUPDSFPARAMETERS_PVT AS
2: /* $Header: OKLRSFRB.pls 120.1 2005/06/03 05:31:09 rirawat noship $ */
3:
4: ---------------------------------------------------------------------------
5: -- PROCEDURE get_rec for: OKL_FNCTN_PRMTRS_V
6: ---------------------------------------------------------------------------
7: PROCEDURE get_rec (
8: p_fprv_rec IN fprv_rec_type,
9: x_return_status OUT NOCOPY VARCHAR2,

Line 29: FROM Okl_Fnctn_Prmtrs_V

25: CREATION_DATE,
26: LAST_UPDATED_BY,
27: LAST_UPDATE_DATE,
28: NVL(LAST_UPDATE_LOGIN, OKL_API.G_MISS_NUM) LAST_UPDATE_LOGIN
29: FROM Okl_Fnctn_Prmtrs_V
30: WHERE okl_Fnctn_Prmtrs_V.id = p_id;
31: l_okl_fprv_pk okl_fprv_pk_csr%ROWTYPE;
32: l_fprv_rec fprv_rec_type;
33: BEGIN

Line 30: WHERE okl_Fnctn_Prmtrs_V.id = p_id;

26: LAST_UPDATED_BY,
27: LAST_UPDATE_DATE,
28: NVL(LAST_UPDATE_LOGIN, OKL_API.G_MISS_NUM) LAST_UPDATE_LOGIN
29: FROM Okl_Fnctn_Prmtrs_V
30: WHERE okl_Fnctn_Prmtrs_V.id = p_id;
31: l_okl_fprv_pk okl_fprv_pk_csr%ROWTYPE;
32: l_fprv_rec fprv_rec_type;
33: BEGIN
34: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 76: -- PROCEDURE check_constraints for: OKL_FNCTN_PRMTRS_V

72:
73: END get_rec;
74:
75: ---------------------------------------------------------------------------
76: -- PROCEDURE check_constraints for: OKL_FNCTN_PRMTRS_V
77: -- To verify whether the dates are valid for both formula and operands
78: -- attached to it
79: ---------------------------------------------------------------------------
80: PROCEDURE check_constraints (

Line 85: CURSOR okl_fprv_pk_csr (p_dsf_id IN Okl_Fnctn_Prmtrs_V.dsf_id%TYPE,

81: p_fprv_rec IN fprv_rec_type,
82: x_return_status OUT NOCOPY VARCHAR2,
83: x_valid OUT NOCOPY BOOLEAN
84: ) IS
85: CURSOR okl_fprv_pk_csr (p_dsf_id IN Okl_Fnctn_Prmtrs_V.dsf_id%TYPE,
86: p_sequence_number IN Okl_Fnctn_Prmtrs_V.sequence_number%TYPE
87: ) IS
88: SELECT '1'
89: FROM Okl_Fnctn_Prmtrs_V fpr

Line 86: p_sequence_number IN Okl_Fnctn_Prmtrs_V.sequence_number%TYPE

82: x_return_status OUT NOCOPY VARCHAR2,
83: x_valid OUT NOCOPY BOOLEAN
84: ) IS
85: CURSOR okl_fprv_pk_csr (p_dsf_id IN Okl_Fnctn_Prmtrs_V.dsf_id%TYPE,
86: p_sequence_number IN Okl_Fnctn_Prmtrs_V.sequence_number%TYPE
87: ) IS
88: SELECT '1'
89: FROM Okl_Fnctn_Prmtrs_V fpr
90: WHERE fpr.DSF_ID = p_dsf_id

Line 89: FROM Okl_Fnctn_Prmtrs_V fpr

85: CURSOR okl_fprv_pk_csr (p_dsf_id IN Okl_Fnctn_Prmtrs_V.dsf_id%TYPE,
86: p_sequence_number IN Okl_Fnctn_Prmtrs_V.sequence_number%TYPE
87: ) IS
88: SELECT '1'
89: FROM Okl_Fnctn_Prmtrs_V fpr
90: WHERE fpr.DSF_ID = p_dsf_id
91: AND fpr.SEQUENCE_NUMBER = p_sequence_number;
92:
93: l_check VARCHAR2(1) := '?';

Line 155: CURSOR okl_pmrv_pk_csr (p_id IN OKL_FNCTN_PRMTRS_V.pmr_id%TYPE) IS

151: l_row_not_found BOOLEAN := FALSE;
152: l_token_1 VARCHAR2(1999);
153:
154: -- Cursor For OKL_FPR_PMR_FK;
155: CURSOR okl_pmrv_pk_csr (p_id IN OKL_FNCTN_PRMTRS_V.pmr_id%TYPE) IS
156: SELECT '1'
157: FROM OKL_PARAMETERS_V
158: WHERE OKL_PARAMETERS_V.id = p_id;
159:

Line 351: -- PROCEDURE insert_dsfparameters for: OKL_FNCTN_PRMTRS_V

347: RETURN(l_return_status);
348: END Validate_Attributes;
349:
350: ---------------------------------------------------------------------------
351: -- PROCEDURE insert_dsfparameters for: OKL_FNCTN_PRMTRS_V
352: ---------------------------------------------------------------------------
353: PROCEDURE insert_dsfparameters(p_api_version IN NUMBER,
354: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
355: x_return_status OUT NOCOPY VARCHAR2,

Line 450: -- PROCEDURE update_dsfparameters for: OKL_FNCTN_PRMTRS_V

446:
447: END insert_dsfparameters;
448:
449: ---------------------------------------------------------------------------
450: -- PROCEDURE update_dsfparameters for: OKL_FNCTN_PRMTRS_V
451: ---------------------------------------------------------------------------
452: PROCEDURE update_dsfparameters(p_api_version IN NUMBER,
453: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
454: x_return_status OUT NOCOPY VARCHAR2,

Line 542: -- PROCEDURE delete_dsfparameters for: OKL_FNCTN_PRMTRS_V

538: END update_dsfparameters;
539:
540:
541: ---------------------------------------------------------------------------
542: -- PROCEDURE delete_dsfparameters for: OKL_FNCTN_PRMTRS_V
543: -- This allows the user to delete table of records
544: ---------------------------------------------------------------------------
545: PROCEDURE delete_dsfparameters(p_api_version IN NUMBER,
546: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 615: -- rirawat 03-Feb-05 4149748: Added the following procedure to insert into OKL_FNCTN_PRMTRS_V - TBL : begin

611: p_api_type => '_PVT');
612:
613: END delete_dsfparameters;
614:
615: -- rirawat 03-Feb-05 4149748: Added the following procedure to insert into OKL_FNCTN_PRMTRS_V - TBL : begin
616: ---------------------------------------------------------------------------
617: -- PROCEDURE insert_dsfparameters for: OKL_FNCTN_PRMTRS_V - TBL
618: ---------------------------------------------------------------------------
619: PROCEDURE insert_dsfparameters(

Line 617: -- PROCEDURE insert_dsfparameters for: OKL_FNCTN_PRMTRS_V - TBL

613: END delete_dsfparameters;
614:
615: -- rirawat 03-Feb-05 4149748: Added the following procedure to insert into OKL_FNCTN_PRMTRS_V - TBL : begin
616: ---------------------------------------------------------------------------
617: -- PROCEDURE insert_dsfparameters for: OKL_FNCTN_PRMTRS_V - TBL
618: ---------------------------------------------------------------------------
619: PROCEDURE insert_dsfparameters(
620: p_api_version IN NUMBER,
621: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 702: -- rirawat 03-Feb-05 4149748: Added the following procedure to insert into OKL_FNCTN_PRMTRS_V - TBL : end

698: '_PVT'
699: );
700: END insert_dsfparameters;
701:
702: -- rirawat 03-Feb-05 4149748: Added the following procedure to insert into OKL_FNCTN_PRMTRS_V - TBL : end
703:
704: -- rirawat 03-Feb-05 4149748: Added the following procedure to update into OKL_FNCTN_PRMTRS_V - TBL : begin
705: ---------------------------------------------------------------------------
706: -- PROCEDURE update_dsfparameters for: OKL_FNCTN_PRMTRS_V -TBL

Line 704: -- rirawat 03-Feb-05 4149748: Added the following procedure to update into OKL_FNCTN_PRMTRS_V - TBL : begin

700: END insert_dsfparameters;
701:
702: -- rirawat 03-Feb-05 4149748: Added the following procedure to insert into OKL_FNCTN_PRMTRS_V - TBL : end
703:
704: -- rirawat 03-Feb-05 4149748: Added the following procedure to update into OKL_FNCTN_PRMTRS_V - TBL : begin
705: ---------------------------------------------------------------------------
706: -- PROCEDURE update_dsfparameters for: OKL_FNCTN_PRMTRS_V -TBL
707: ---------------------------------------------------------------------------
708: PROCEDURE update_dsfparameters(

Line 706: -- PROCEDURE update_dsfparameters for: OKL_FNCTN_PRMTRS_V -TBL

702: -- rirawat 03-Feb-05 4149748: Added the following procedure to insert into OKL_FNCTN_PRMTRS_V - TBL : end
703:
704: -- rirawat 03-Feb-05 4149748: Added the following procedure to update into OKL_FNCTN_PRMTRS_V - TBL : begin
705: ---------------------------------------------------------------------------
706: -- PROCEDURE update_dsfparameters for: OKL_FNCTN_PRMTRS_V -TBL
707: ---------------------------------------------------------------------------
708: PROCEDURE update_dsfparameters(
709: p_api_version IN NUMBER,
710: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 793: -- rirawat 03-Feb-05 4149748: Added the following procedure to update into OKL_FNCTN_PRMTRS_V - TBL : end

789: '_PVT'
790: );
791: END update_dsfparameters;
792:
793: -- rirawat 03-Feb-05 4149748: Added the following procedure to update into OKL_FNCTN_PRMTRS_V - TBL : end
794:
795:
796: END OKL_SETUPDSFPARAMETERS_PVT;