APPS.CSF_PARAMS_PKG dependencies on CSF_PARAMS

Line 1: PACKAGE BODY csf_params_pkg AS

1: PACKAGE BODY csf_params_pkg AS
2: /* $Header: CSFCPARB.pls 115.15.11510.2 2004/06/24 04:41:01 srengana ship $ */
3:
4: FUNCTION query_parameter
5: ( i_name varchar2

Line 380: Purpose: insert parameter in csf_params

376: Created by: T. Voerman, Oracle Nederland
377:
378: Date created:
379:
380: Purpose: insert parameter in csf_params
381:
382: Known Limitations:
383:
384: Remarks:

Line 388: insert into csf_params

384: Remarks:
385: ********************************************************/
386:
387: begin
388: insert into csf_params
389: ( PARAM_ID
390: , LAST_UPDATE_DATE
391: , LAST_UPDATED_BY
392: , CREATION_DATE

Line 398: values( csf_params_s.nextval

394: , LAST_UPDATE_LOGIN
395: , NAME
396: , VALUE
397: )
398: values( csf_params_s.nextval
399: , sysdate
400: , uid
401: , sysdate
402: , uid

Line 418: Purpose: update parameter in csf_params

414: Created by: T. Voerman, Oracle Nederland
415:
416: Date created:
417:
418: Purpose: update parameter in csf_params
419:
420: Known Limitations:
421:
422: Remarks:

Line 426: update csf_params par

422: Remarks:
423: ********************************************************/
424:
425: begin
426: update csf_params par
427: set par.value = i_value
428: , last_updated_by = uid
429: , last_update_date = sysdate
430: where Upper(par.name) = Upper(i_name);

Line 637: Purpose: exclusively lock table csf_params.

633: Created by: T. Voerman, Oracle Nederland
634:
635: Date created:
636:
637: Purpose: exclusively lock table csf_params.
638:
639: Known Limitations:
640:
641: Remarks:

Line 645: lock table csf_params

641: Remarks:
642: ********************************************************/
643:
644: BEGIN
645: lock table csf_params
646: in exclusive mode
647: nowait;
648: END lock_parameters;
649:

Line 652: END csf_params_PKG;

648: END lock_parameters;
649:
650: BEGIN
651: io_param(1).primary_key := 1;
652: END csf_params_PKG;