APPS.PA_WORKFLOW_UTILS dependencies on PA_WF_PROCESSES

Line 22: --Description: This procedure inserts rows into the pa_wf_processes

18: -- -------------------------------------------------------------------------------------
19:
20: --Name: Insert_WF_Processes
21: --Type: Procedure
22: --Description: This procedure inserts rows into the pa_wf_processes
23: -- table for the start_approval procedures.
24: --
25: --
26: --Called subprograms: none.

Line 65: l_entity_key2 pa_wf_processes.entity_key2%TYPE;

61:
62: IS
63: --
64:
65: l_entity_key2 pa_wf_processes.entity_key2%TYPE;
66: l_description pa_wf_processes.description%TYPE;
67: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
68:
69: BEGIN

Line 66: l_description pa_wf_processes.description%TYPE;

62: IS
63: --
64:
65: l_entity_key2 pa_wf_processes.entity_key2%TYPE;
66: l_description pa_wf_processes.description%TYPE;
67: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
68:
69: BEGIN
70:

Line 105: :ORA-01400: cannot insert NULL into (PA."PA_WF_PROCESSES.ENTITY_KEY2)

101: THEN
102: l_entity_key2 := '0'; -- Bug 7170228
103:
104: /* Bug fix:5246812: When p_entity_key2 is NULL, throws
105: :ORA-01400: cannot insert NULL into (PA."PA_WF_PROCESSES.ENTITY_KEY2)
106: */
107: -- Bug#7517187
108: --ELSIF (p_entity_key2 is NULL OR p_entity_key2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) Then
109: ELSIF (p_entity_key2 is NULL) Then

Line 134: pa_debug.g_err_stage := 'LOG:'||'Inserting into pa_wf_processes: wf_type_code['||p_wf_type_code||']';

130: END IF;
131:
132: -- ----------------------------------------------------------------------------------
133: IF P_PA_DEBUG_MODE = 'Y' Then
134: pa_debug.g_err_stage := 'LOG:'||'Inserting into pa_wf_processes: wf_type_code['||p_wf_type_code||']';
135: pa_debug.g_err_stage := pa_debug.g_err_stage||'ItemType['||p_item_type||']ItemKey['||p_item_key||']';
136: pa_debug.g_err_stage := pa_debug.g_err_stage||'Key1['||p_entity_key1||']Key2['||l_entity_key2||']';
137: PA_DEBUG.write
138: (x_Module => 'pa_workflow_utils.Insert_WF_Processes'

Line 143: INSERT INTO pa_wf_processes

139: ,x_Msg => pa_debug.g_err_stage
140: ,x_Log_Level => 3);
141: END IF;
142:
143: INSERT INTO pa_wf_processes
144: (wf_type_code
145: , item_type
146: , item_key
147: , entity_key1