APPS.PA_WORKFLOW_UTILS dependencies on PA_INTERFACE_UTILS_PUB

Line 55: , p_entity_key2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

51: (p_wf_type_code IN VARCHAR2
52: , p_item_type IN VARCHAR2
53: , p_item_key IN VARCHAR2
54: , p_entity_key1 IN VARCHAR2
55: , p_entity_key2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
56: , p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
57: , p_err_code IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
58: , p_err_stage IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
59: , p_err_stack IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 56: , p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

52: , p_item_type IN VARCHAR2
53: , p_item_key IN VARCHAR2
54: , p_entity_key1 IN VARCHAR2
55: , p_entity_key2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
56: , p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
57: , p_err_code IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
58: , p_err_stage IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
59: , p_err_stack IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
60: )

Line 100: IF (p_entity_key2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

96: p_err_code := 0;
97:
98: -- Value-Id Layer --------------------------------------------------------------
99:
100: IF (p_entity_key2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
101: THEN
102: l_entity_key2 := '0'; -- Bug 7170228
103:
104: /* Bug fix:5246812: When p_entity_key2 is NULL, throws

Line 108: --ELSIF (p_entity_key2 is NULL OR p_entity_key2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) Then

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
110: l_entity_key2 := '-99'; -- Bug 7170228
111: /* end of bug fix:5246812 */
112:

Line 125: IF (p_description = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

121: ,x_Msg => pa_debug.g_err_stage
122: ,x_Log_Level => 3);
123: END IF;
124:
125: IF (p_description = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
126: THEN
127: l_description := NULL;
128: ELSE
129: l_description := p_description;