APPS.CTO_WIP_WORKFLOW_API_PK dependencies on CTO_WIP_WORKFLOW_API_PK

Line 1: PACKAGE BODY CTO_WIP_WORKFLOW_API_PK as

1: PACKAGE BODY CTO_WIP_WORKFLOW_API_PK as
2: /* $Header: CTOWIPAB.pls 120.3 2010/07/21 08:00:08 abhissri ship $ */
3: /*============================================================================+
4: | Copyright (c) 1993 Oracle Corporation Belmont, California, USA |
5: | All rights reserved. |

Line 51: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CTO_WIP_WORKFLOW_API_PK';

47: =============================================================================*/
48:
49:
50:
51: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CTO_WIP_WORKFLOW_API_PK';
52: G_ITEM_TYPE_NAME CONSTANT VARCHAR2(30) := 'OEOL';
53:
54:
55: /******************************************************************************

Line 87: if CTO_WIP_WORKFLOW_API_PK.file_dir is null then

83: return;
84: end if;
85:
86:
87: if CTO_WIP_WORKFLOW_API_PK.file_dir is null then
88:
89: /* -- begin bugfix 3511114: use v$parameter2 instead.
90: *
91: * select ltrim(rtrim(substr(value, instr(value,',',-1,1)+1)))

Line 112: if CTO_WIP_WORKFLOW_API_PK.file_name is null then

108: -- end bugfix 3511114
109:
110: end if;
111:
112: if CTO_WIP_WORKFLOW_API_PK.file_name is null then
113: file_name := 'cto_'||to_char(sysdate,'ddhh24miss')||'.dbg';
114: end if;
115:
116: fname := utl_file.fopen(CTO_WIP_WORKFLOW_API_PK.file_dir,CTO_WIP_WORKFLOW_API_PK.file_name,'a');

Line 116: fname := utl_file.fopen(CTO_WIP_WORKFLOW_API_PK.file_dir,CTO_WIP_WORKFLOW_API_PK.file_name,'a');

112: if CTO_WIP_WORKFLOW_API_PK.file_name is null then
113: file_name := 'cto_'||to_char(sysdate,'ddhh24miss')||'.dbg';
114: end if;
115:
116: fname := utl_file.fopen(CTO_WIP_WORKFLOW_API_PK.file_dir,CTO_WIP_WORKFLOW_API_PK.file_name,'a');
117: utl_file.put_line(fname,proc_name||'::'||text);
118: utl_file.fflush(fname);
119: utl_file.fclose(fname);
120:

Line 818: END CTO_WIP_WORKFLOW_API_PK;

814: return (2);
815:
816: END workflow_build_status;
817:
818: END CTO_WIP_WORKFLOW_API_PK;