DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_UTILS dependencies on PA_LOOKUPS

Line 20: g_pc_pfc_context PA_LOOKUPS.LOOKUP_CODE%TYPE;

16: beginning of the procedure these globals are set to null and then populated
17: down the line depending on the error.
18: */
19: g_first_error_code varchar2(30);
20: g_pc_pfc_context PA_LOOKUPS.LOOKUP_CODE%TYPE;
21: g_cost_rev_context varchar2(30);
22:
23:
24: function get_lookup_value

Line 25: (p_lookup_type pa_lookups.lookup_type%TYPE,

21: g_cost_rev_context varchar2(30);
22:
23:
24: function get_lookup_value
25: (p_lookup_type pa_lookups.lookup_type%TYPE,
26: p_lookup_code pa_lookups.lookup_code%TYPE) return VARCHAR2;
27:
28: procedure Check_Record_Version_Number
29: (p_unique_index IN NUMBER,

Line 26: p_lookup_code pa_lookups.lookup_code%TYPE) return VARCHAR2;

22:
23:
24: function get_lookup_value
25: (p_lookup_type pa_lookups.lookup_type%TYPE,
26: p_lookup_code pa_lookups.lookup_code%TYPE) return VARCHAR2;
27:
28: procedure Check_Record_Version_Number
29: (p_unique_index IN NUMBER,
30: p_record_version_number IN NUMBER,

Line 628: p_lookup_type IN pa_lookups.lookup_type%TYPE

624: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
625:
626: PROCEDURE GET_LOOKUP_CODE
627: (
628: p_lookup_type IN pa_lookups.lookup_type%TYPE
629: ,p_lookup_meaning IN pa_lookups.meaning%TYPE
630: ,x_lookup_code OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895
631: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
632: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 629: ,p_lookup_meaning IN pa_lookups.meaning%TYPE

625:
626: PROCEDURE GET_LOOKUP_CODE
627: (
628: p_lookup_type IN pa_lookups.lookup_type%TYPE
629: ,p_lookup_meaning IN pa_lookups.meaning%TYPE
630: ,x_lookup_code OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895
631: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
632: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
633: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 630: ,x_lookup_code OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895

626: PROCEDURE GET_LOOKUP_CODE
627: (
628: p_lookup_type IN pa_lookups.lookup_type%TYPE
629: ,p_lookup_meaning IN pa_lookups.meaning%TYPE
630: ,x_lookup_code OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895
631: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
632: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
633: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
634: );