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.1.12000000.2 2007/09/14 10:56:38 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 798: END CTO_WIP_WORKFLOW_API_PK;

794: return (2);
795:
796: END workflow_build_status;
797:
798: END CTO_WIP_WORKFLOW_API_PK;