DBA Data[Home] [Help]

APPS.PA_FP_WEBADI_UTILS dependencies on PA_LOOKUPS

Line 107: (p_mc_error_code IN pa_lookups.lookup_code%TYPE

103: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
104: ) ;
105:
106: PROCEDURE GET_MC_ERROR_LOOKUP_CODE
107: (p_mc_error_code IN pa_lookups.lookup_code%TYPE
108: ,p_attr_set_cost_rev IN VARCHAR2
109: ,p_attr_set_pc_pfc IN VARCHAR2
110: ,x_error_lookup_code OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895
111: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

106: PROCEDURE GET_MC_ERROR_LOOKUP_CODE
107: (p_mc_error_code IN pa_lookups.lookup_code%TYPE
108: ,p_attr_set_cost_rev IN VARCHAR2
109: ,p_attr_set_pc_pfc IN VARCHAR2
110: ,x_error_lookup_code OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895
111: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
112: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
113: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
114: );

Line 118: ,p_pc_cost_rate_date_type_name IN pa_lookups.meaning%TYPE

114: );
115:
116: PROCEDURE CONV_MC_ATTR_MEANING_TO_CODE
117: (p_pc_cost_rate_type_name IN pa_conversion_types_v.user_conversion_type%TYPE
118: ,p_pc_cost_rate_date_type_name IN pa_lookups.meaning%TYPE
119: ,p_pfc_cost_rate_type_name IN pa_conversion_types_v.user_conversion_type%TYPE
120: ,p_pfc_cost_rate_date_type_name IN pa_lookups.meaning%TYPE
121: ,p_pc_rev_rate_type_name IN pa_conversion_types_v.user_conversion_type%TYPE
122: ,p_pc_rev_rate_date_type_name IN pa_lookups.meaning%TYPE

Line 120: ,p_pfc_cost_rate_date_type_name IN pa_lookups.meaning%TYPE

116: PROCEDURE CONV_MC_ATTR_MEANING_TO_CODE
117: (p_pc_cost_rate_type_name IN pa_conversion_types_v.user_conversion_type%TYPE
118: ,p_pc_cost_rate_date_type_name IN pa_lookups.meaning%TYPE
119: ,p_pfc_cost_rate_type_name IN pa_conversion_types_v.user_conversion_type%TYPE
120: ,p_pfc_cost_rate_date_type_name IN pa_lookups.meaning%TYPE
121: ,p_pc_rev_rate_type_name IN pa_conversion_types_v.user_conversion_type%TYPE
122: ,p_pc_rev_rate_date_type_name IN pa_lookups.meaning%TYPE
123: ,p_pfc_rev_rate_type_name IN pa_conversion_types_v.user_conversion_type%TYPE
124: ,p_pfc_rev_rate_date_type_name IN pa_lookups.meaning%TYPE

Line 122: ,p_pc_rev_rate_date_type_name IN pa_lookups.meaning%TYPE

118: ,p_pc_cost_rate_date_type_name IN pa_lookups.meaning%TYPE
119: ,p_pfc_cost_rate_type_name IN pa_conversion_types_v.user_conversion_type%TYPE
120: ,p_pfc_cost_rate_date_type_name IN pa_lookups.meaning%TYPE
121: ,p_pc_rev_rate_type_name IN pa_conversion_types_v.user_conversion_type%TYPE
122: ,p_pc_rev_rate_date_type_name IN pa_lookups.meaning%TYPE
123: ,p_pfc_rev_rate_type_name IN pa_conversion_types_v.user_conversion_type%TYPE
124: ,p_pfc_rev_rate_date_type_name IN pa_lookups.meaning%TYPE
125: ,x_pc_cost_rate_type OUT NOCOPY pa_conversion_types_v.conversion_type%TYPE --File.Sql.39 bug 4440895
126: ,x_pc_cost_rate_date_type OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895

Line 124: ,p_pfc_rev_rate_date_type_name IN pa_lookups.meaning%TYPE

120: ,p_pfc_cost_rate_date_type_name IN pa_lookups.meaning%TYPE
121: ,p_pc_rev_rate_type_name IN pa_conversion_types_v.user_conversion_type%TYPE
122: ,p_pc_rev_rate_date_type_name IN pa_lookups.meaning%TYPE
123: ,p_pfc_rev_rate_type_name IN pa_conversion_types_v.user_conversion_type%TYPE
124: ,p_pfc_rev_rate_date_type_name IN pa_lookups.meaning%TYPE
125: ,x_pc_cost_rate_type OUT NOCOPY pa_conversion_types_v.conversion_type%TYPE --File.Sql.39 bug 4440895
126: ,x_pc_cost_rate_date_type OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895
127: ,x_pfc_cost_rate_type OUT NOCOPY pa_conversion_types_v.conversion_type%TYPE --File.Sql.39 bug 4440895
128: ,x_pfc_cost_rate_date_type OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895

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

122: ,p_pc_rev_rate_date_type_name IN pa_lookups.meaning%TYPE
123: ,p_pfc_rev_rate_type_name IN pa_conversion_types_v.user_conversion_type%TYPE
124: ,p_pfc_rev_rate_date_type_name IN pa_lookups.meaning%TYPE
125: ,x_pc_cost_rate_type OUT NOCOPY pa_conversion_types_v.conversion_type%TYPE --File.Sql.39 bug 4440895
126: ,x_pc_cost_rate_date_type OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895
127: ,x_pfc_cost_rate_type OUT NOCOPY pa_conversion_types_v.conversion_type%TYPE --File.Sql.39 bug 4440895
128: ,x_pfc_cost_rate_date_type OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895
129: ,x_pc_rev_rate_type OUT NOCOPY pa_conversion_types_v.conversion_type%TYPE --File.Sql.39 bug 4440895
130: ,x_pc_rev_rate_date_type OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895

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

124: ,p_pfc_rev_rate_date_type_name IN pa_lookups.meaning%TYPE
125: ,x_pc_cost_rate_type OUT NOCOPY pa_conversion_types_v.conversion_type%TYPE --File.Sql.39 bug 4440895
126: ,x_pc_cost_rate_date_type OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895
127: ,x_pfc_cost_rate_type OUT NOCOPY pa_conversion_types_v.conversion_type%TYPE --File.Sql.39 bug 4440895
128: ,x_pfc_cost_rate_date_type OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895
129: ,x_pc_rev_rate_type OUT NOCOPY pa_conversion_types_v.conversion_type%TYPE --File.Sql.39 bug 4440895
130: ,x_pc_rev_rate_date_type OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895
131: ,x_pfc_rev_rate_type OUT NOCOPY pa_conversion_types_v.conversion_type%TYPE --File.Sql.39 bug 4440895
132: ,x_pfc_rev_rate_date_type OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895

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

126: ,x_pc_cost_rate_date_type OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895
127: ,x_pfc_cost_rate_type OUT NOCOPY pa_conversion_types_v.conversion_type%TYPE --File.Sql.39 bug 4440895
128: ,x_pfc_cost_rate_date_type OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895
129: ,x_pc_rev_rate_type OUT NOCOPY pa_conversion_types_v.conversion_type%TYPE --File.Sql.39 bug 4440895
130: ,x_pc_rev_rate_date_type OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895
131: ,x_pfc_rev_rate_type OUT NOCOPY pa_conversion_types_v.conversion_type%TYPE --File.Sql.39 bug 4440895
132: ,x_pfc_rev_rate_date_type OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895
133: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
134: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

128: ,x_pfc_cost_rate_date_type OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895
129: ,x_pc_rev_rate_type OUT NOCOPY pa_conversion_types_v.conversion_type%TYPE --File.Sql.39 bug 4440895
130: ,x_pc_rev_rate_date_type OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895
131: ,x_pfc_rev_rate_type OUT NOCOPY pa_conversion_types_v.conversion_type%TYPE --File.Sql.39 bug 4440895
132: ,x_pfc_rev_rate_date_type OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895
133: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
134: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
135: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
136: );

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

151: PROCEDURE GET_LAYOUT_DETAILS
152: (p_layout_code IN pa_proj_fp_options.cost_layout_code%TYPE
153: ,p_integrator_code IN bne_integrators_b.integrator_code%TYPE
154: ,x_layout_name OUT NOCOPY bne_layouts_tl.user_name%TYPE --File.Sql.39 bug 4440895
155: ,x_layout_type_code OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895
156: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
157: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
158: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
159: );