DBA Data[Home] [Help]

APPS.PQP_NL_ABP_TEMPLATE dependencies on PAY_TEMPLATE_CORE_OBJECTS

Line 78: l_ele_core_id pay_template_core_objects.core_object_id%TYPE:= -1;

74: INDEX BY BINARY_INTEGER;
75:
76: l_main_eei_info19 t_eei_info;
77: l_retro_eei_info19 t_eei_info;
78: l_ele_core_id pay_template_core_objects.core_object_id%TYPE:= -1;
79:
80: --
81: -- Extra Information variables
82: --

Line 117: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;

113: l_dbi_user_name ff_database_items.user_name%TYPE;
114: l_balance_name pay_balance_types.balance_name%TYPE;
115: l_balance_dbi_name ff_database_items.user_name%TYPE;
116: l_template_id pay_shadow_element_types.template_id%TYPE;
117: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
118: l_er_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
119: l_cy_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
120: l_cy_er_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
121: l_py_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;

Line 118: l_er_base_element_type_id pay_template_core_objects.core_object_id%TYPE;

114: l_balance_name pay_balance_types.balance_name%TYPE;
115: l_balance_dbi_name ff_database_items.user_name%TYPE;
116: l_template_id pay_shadow_element_types.template_id%TYPE;
117: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
118: l_er_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
119: l_cy_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
120: l_cy_er_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
121: l_py_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
122: l_py_er_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;

Line 119: l_cy_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;

115: l_balance_dbi_name ff_database_items.user_name%TYPE;
116: l_template_id pay_shadow_element_types.template_id%TYPE;
117: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
118: l_er_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
119: l_cy_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
120: l_cy_er_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
121: l_py_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
122: l_py_er_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
123: l_source_template_id pay_element_templates.template_id%TYPE;

Line 120: l_cy_er_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;

116: l_template_id pay_shadow_element_types.template_id%TYPE;
117: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
118: l_er_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
119: l_cy_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
120: l_cy_er_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
121: l_py_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
122: l_py_er_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
123: l_source_template_id pay_element_templates.template_id%TYPE;
124: l_object_version_NUMBER pay_element_types_f.object_version_NUMBER%TYPE;

Line 121: l_py_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;

117: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
118: l_er_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
119: l_cy_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
120: l_cy_er_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
121: l_py_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
122: l_py_er_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
123: l_source_template_id pay_element_templates.template_id%TYPE;
124: l_object_version_NUMBER pay_element_types_f.object_version_NUMBER%TYPE;
125: l_proc_name VARCHAR2(80)

Line 122: l_py_er_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;

118: l_er_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
119: l_cy_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
120: l_cy_er_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
121: l_py_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
122: l_py_er_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
123: l_source_template_id pay_element_templates.template_id%TYPE;
124: l_object_version_NUMBER pay_element_types_f.object_version_NUMBER%TYPE;
125: l_proc_name VARCHAR2(80)
126: := g_proc_name || 'create_user_template';