eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_USER_ATTR_PUB dependencies on EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 28: l_orig_proj_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

24: IS
25: l_api_name CONSTANT VARCHAR(30) := 'Copy_User_Attrs_Data';
26: l_api_version CONSTANT NUMBER := 1.0;
27:
28: l_orig_proj_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
29: l_new_proj_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
30: l_orig_task_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
31: l_new_task_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
32:

Line 29: l_new_proj_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

25: l_api_name CONSTANT VARCHAR(30) := 'Copy_User_Attrs_Data';
26: l_api_version CONSTANT NUMBER := 1.0;
27:
28: l_orig_proj_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
29: l_new_proj_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
30: l_orig_task_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
31: l_new_task_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
32:
33: CURSOR get_project_id(c_task_id NUMBER)

Line 30: l_orig_task_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

26: l_api_version CONSTANT NUMBER := 1.0;
27:
28: l_orig_proj_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
29: l_new_proj_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
30: l_orig_task_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
31: l_new_task_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
32:
33: CURSOR get_project_id(c_task_id NUMBER)
34: IS

Line 31: l_new_task_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

27:
28: l_orig_proj_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
29: l_new_proj_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
30: l_orig_task_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
31: l_new_task_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
32:
33: CURSOR get_project_id(c_task_id NUMBER)
34: IS
35: SELECT project_id

Line 137: l_orig_proj_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PROJECT_ID', p_object_id_from));

133: end if;
134:
135: if p_object_type = 'PA_PROJECTS' then
136:
137: l_orig_proj_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PROJECT_ID', p_object_id_from));
138: l_new_proj_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PROJECT_ID', p_object_id_to));
139:
140: l_orig_task_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PROJ_ELEMENT_ID', NULL));
141: l_new_task_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PROJ_ELEMENT_ID', NULL));

Line 138: l_new_proj_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PROJECT_ID', p_object_id_to));

134:
135: if p_object_type = 'PA_PROJECTS' then
136:
137: l_orig_proj_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PROJECT_ID', p_object_id_from));
138: l_new_proj_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PROJECT_ID', p_object_id_to));
139:
140: l_orig_task_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PROJ_ELEMENT_ID', NULL));
141: l_new_task_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PROJ_ELEMENT_ID', NULL));
142:

Line 140: l_orig_task_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PROJ_ELEMENT_ID', NULL));

136:
137: l_orig_proj_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PROJECT_ID', p_object_id_from));
138: l_new_proj_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PROJECT_ID', p_object_id_to));
139:
140: l_orig_task_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PROJ_ELEMENT_ID', NULL));
141: l_new_task_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PROJ_ELEMENT_ID', NULL));
142:
143: EGO_USER_ATTRS_DATA_PUB.Copy_User_Attrs_Data (
144: p_api_version => 1.0

Line 141: l_new_task_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PROJ_ELEMENT_ID', NULL));

137: l_orig_proj_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PROJECT_ID', p_object_id_from));
138: l_new_proj_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PROJECT_ID', p_object_id_to));
139:
140: l_orig_task_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PROJ_ELEMENT_ID', NULL));
141: l_new_task_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PROJ_ELEMENT_ID', NULL));
142:
143: EGO_USER_ATTRS_DATA_PUB.Copy_User_Attrs_Data (
144: p_api_version => 1.0
145: ,p_application_id => 275

Line 180: l_orig_task_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PROJ_ELEMENT_ID', l_old_proj_element_id));

176:
177: OPEN get_new_proj_element_id(l_old_proj_element_id, p_object_id_from, p_object_id_to);
178: FETCH get_new_proj_element_id INTO l_new_proj_element_id;
179: if get_new_proj_element_id%FOUND THEN
180: l_orig_task_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PROJ_ELEMENT_ID', l_old_proj_element_id));
181: l_new_task_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PROJ_ELEMENT_ID', l_new_proj_element_id));
182:
183: EGO_USER_ATTRS_DATA_PUB.Copy_User_Attrs_Data (
184: p_api_version => 1.0

Line 181: l_new_task_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PROJ_ELEMENT_ID', l_new_proj_element_id));

177: OPEN get_new_proj_element_id(l_old_proj_element_id, p_object_id_from, p_object_id_to);
178: FETCH get_new_proj_element_id INTO l_new_proj_element_id;
179: if get_new_proj_element_id%FOUND THEN
180: l_orig_task_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PROJ_ELEMENT_ID', l_old_proj_element_id));
181: l_new_task_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PROJ_ELEMENT_ID', l_new_proj_element_id));
182:
183: EGO_USER_ATTRS_DATA_PUB.Copy_User_Attrs_Data (
184: p_api_version => 1.0
185: ,p_application_id => 275

Line 718: p_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

714: l_api_name CONSTANT VARCHAR(30) := 'Process_User_Attrs_Data';
715: l_api_version CONSTANT NUMBER := 1.0;
716: i NUMBER;
717: attr_rec PA_PROJECT_PUB.PA_EXT_ATTR_ROW_TYPE;
718: p_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
719: p_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
720: p_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
721: p_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
722: l_prev_loop_row_identifier NUMBER;

Line 719: p_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

715: l_api_version CONSTANT NUMBER := 1.0;
716: i NUMBER;
717: attr_rec PA_PROJECT_PUB.PA_EXT_ATTR_ROW_TYPE;
718: p_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
719: p_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
720: p_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
721: p_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
722: l_prev_loop_row_identifier NUMBER;
723: l_at_start_of_row BOOLEAN;

Line 759: p_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

755: -- 1. Build arrays for the Primary Key columns and the --
756: -- Classification Code columns --
757: -- 2. We also build Attr Row and Attr Data tables --
758: ------------------------------------------------------------------
759: p_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
760: EGO_COL_NAME_VALUE_PAIR_OBJ('PROJECT_ID', p_project_id)
761: );
762:
763: p_attributes_row_table := EGO_USER_ATTR_ROW_TABLE();

Line 874: p_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(); --Bug 7688888

870: -------------------------------------------------------------------------
871: if (p_debug_mode = 'Y') then
872: pa_debug.debug('>> EGO_USER_ATTRS_DATA_PUB.Process_User_Attrs_Data');
873: end if;
874: p_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(); --Bug 7688888
875: EGO_USER_ATTRS_DATA_PUB.Process_User_Attrs_Data
876: (
877: p_api_version => 1.0
878: ,p_object_name => p_object_name