1: PACKAGE BODY CSD_FLOW_STATUSES_PVT as
2: /* $Header: csdvflsb.pls 120.3 2005/07/29 16:37:00 vkjain noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_FLOW_STATUSES_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdvflsb.pls';
1: PACKAGE BODY CSD_FLOW_STATUSES_PVT as
2: /* $Header: csdvflsb.pls 120.3 2005/07/29 16:37:00 vkjain noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_FLOW_STATUSES_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdvflsb.pls';
6:
7: /*--------------------------------------------------*/
8: /* procedure name: Create_Flow_Status */
23: x_flow_status_id OUT NOCOPY NUMBER
24: ) IS
25:
26: -- CONSTANTS --
27: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.CSD_FLOW_STATUSES_PVT.create_flow_status';
28: lc_api_name CONSTANT VARCHAR2(30) := 'Create_Flow_Status';
29: lc_api_version CONSTANT NUMBER := 1.0;
30:
31: -- VARIABLES --
261: x_obj_ver_number OUT NOCOPY NUMBER
262: ) IS
263:
264: -- CONSTANTS --
265: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.CSD_FLOW_STATUSES_PVT.update_flow_status';
266: lc_api_name CONSTANT VARCHAR2(30) := 'Update_Flow_Status';
267: lc_api_version CONSTANT NUMBER := 1.0;
268:
269: -- VARIABLES --
502: p_flow_status_id IN NUMBER
503: ) IS
504:
505: -- CONSTANTS --
506: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.CSD_FLOW_STATUSES_PVT.Delete_Flow_Status';
507: lc_api_name CONSTANT VARCHAR2(30) := 'Delete_Flow_Status';
508: lc_api_version CONSTANT NUMBER := 1.0;
509:
510: -- VARIABLES --
681: p_flow_status_rec IN FLOW_STATUS_REC_TYPE
682: ) IS
683:
684: -- CONSTANTS --
685: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.CSD_FLOW_STATUSES_PVT.lock_flow_status';
686: lc_api_name CONSTANT VARCHAR2(30) := 'Lock_Flow_Status';
687: lc_api_version CONSTANT NUMBER := 1.0;
688:
689: -- VARIABLES --
848: END IF;
849:
850: END Lock_Flow_Status;
851:
852: End CSD_FLOW_STATUSES_PVT;