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.PO_UDA_DATA_UTIL dependencies on EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 156: -- This variable would contain an array of type EGO_COL_NAME_VALUE_PAIR_ARRAY with the PK values

152: -- This variable would contain the template id for which the actions are to be defaulted
153: -- 2. p_attr_grp_id
154: -- This variable would contain the attribute group id for which the actions are to be defaulted
155: -- 3. p_pk_column_name_value_pairs
156: -- This variable would contain an array of type EGO_COL_NAME_VALUE_PAIR_ARRAY with the PK values
157: --IN/OUT:
158: -- 1. x_attributes_row_table
159: -- This variable would contain a table of type EGO_USER_ATTR_ROW_TABLE with the attribute group details
160: -- 2. x_attr_name_value_pairs

Line 176: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

172: PROCEDURE UDA_DEFAULT_ATTRIBUTES
173: (
174: p_template_id IN NUMBER
175: ,p_attr_grp_id IN NUMBER
176: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
177: ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
178: ,x_attr_name_value_pairs OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
179: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
180: ,x_return_status OUT NOCOPY VARCHAR2

Line 194: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

190: l_attr_group_name VARCHAR2(200);
191: l_data_level VARCHAR2(200);
192: l_attr_name VARCHAR2(200);
193:
194: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
195:
196: CURSOR cur_uda_attributes
197: (
198: p_attr_grp_type VARCHAR2

Line 332: -- This variable would contain an array of type EGO_COL_NAME_VALUE_PAIR_ARRAY with the PK values

328: --IN:
329: -- 1. p_template_id
330: -- This variable would contain the template id for which the actions are to be defaulted
331: -- 2. p_pk_column_name_value_pairs
332: -- This variable would contain an array of type EGO_COL_NAME_VALUE_PAIR_ARRAY with the PK values
333: --IN/OUT:
334: -- 1. x_attributes_row_table
335: -- This variable would contain a table of type EGO_USER_ATTR_ROW_TABLE with the attribute group details
336: -- 2. x_attr_name_value_pairs

Line 351: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

347: --------------------------------------------------------------------------------------------------------------------
348: PROCEDURE UDA_VALIDATE_ATTRIBUTES
349: (
350: p_template_id IN NUMBER
351: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
352: ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
353: ,x_attr_name_value_pairs OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
354: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
355: ,x_return_status OUT NOCOPY VARCHAR2

Line 364: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

360: IS
361: d_progress NUMBER := 0;
362: l_failed_row_id_list VARCHAR2(200);
363: l_base_object_name VARCHAR2(200);
364: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
365:
366: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
367:
368: BEGIN

Line 366: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

362: l_failed_row_id_list VARCHAR2(200);
363: l_base_object_name VARCHAR2(200);
364: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
365:
366: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
367:
368: BEGIN
369: d_progress := 10;
370: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 370: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY

366: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
367:
368: BEGIN
369: d_progress := 10;
370: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
371: (
372: EGO_COL_NAME_VALUE_PAIR_OBJ
373: (
374: 'UDA_TEMPLATE_ID'

Line 863: -- Is the Name Value Pair Arry of type EGO_COL_NAME_VALUE_PAIR_ARRAY which need to created for all the primary Keys of Source Document.

859: --IN:
860: -- 1. from_template_id - Source Document's UDA Template Id needs to passed.
861: -- 2. to_template_id - Destination Document's UDA Template Id needs to passed.
862: -- 3. from_pk_col_value_pairs
863: -- Is the Name Value Pair Arry of type EGO_COL_NAME_VALUE_PAIR_ARRAY which need to created for all the primary Keys of Source Document.
864: -- 4. to_pk_col_value_pairs
865: -- Is the Name Value Pair Arry of type EGO_COL_NAME_VALUE_PAIR_ARRAY which need to created for all the primary Keys of Source Document.
866: -- 5. copy_attribute_groups - Possible Values are :
867: -- 1. 'ALL' [Default] - Identify that all the Attribute Groups which are associated to Source Document and having a Attribute Group Mapping to a Destination Document Attribute Group and have a usage in Destination template.

Line 865: -- Is the Name Value Pair Arry of type EGO_COL_NAME_VALUE_PAIR_ARRAY which need to created for all the primary Keys of Source Document.

861: -- 2. to_template_id - Destination Document's UDA Template Id needs to passed.
862: -- 3. from_pk_col_value_pairs
863: -- Is the Name Value Pair Arry of type EGO_COL_NAME_VALUE_PAIR_ARRAY which need to created for all the primary Keys of Source Document.
864: -- 4. to_pk_col_value_pairs
865: -- Is the Name Value Pair Arry of type EGO_COL_NAME_VALUE_PAIR_ARRAY which need to created for all the primary Keys of Source Document.
866: -- 5. copy_attribute_groups - Possible Values are :
867: -- 1. 'ALL' [Default] - Identify that all the Attribute Groups which are associated to Source Document and having a Attribute Group Mapping to a Destination Document Attribute Group and have a usage in Destination template.
868: -- 2. SPECIFIC - Only Specific Attribute Groups which internal names are mentioned in attribute_group_table parameter.
869: -- 3. EXCLUSIVE - All the Attribute group mentioned in attribute_group_table will be ignored.

Line 888: ,from_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

884: PROCEDURE AutoCreate_User_Attrs
885: (
886: from_template_id IN NUMBER
887: ,to_template_id IN NUMBER
888: ,from_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
889: ,to_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
890: ,copy_attribute_groups IN VARCHAR2 DEFAULT 'ALL' -- SPECIFIC / EXCLUSIVE
891: ,attribute_group_table IN PO_TBL_VARCHAR30 DEFAULT NULL
892: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 889: ,to_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

885: (
886: from_template_id IN NUMBER
887: ,to_template_id IN NUMBER
888: ,from_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
889: ,to_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
890: ,copy_attribute_groups IN VARCHAR2 DEFAULT 'ALL' -- SPECIFIC / EXCLUSIVE
891: ,attribute_group_table IN PO_TBL_VARCHAR30 DEFAULT NULL
892: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
893: ,x_return_status OUT NOCOPY VARCHAR2

Line 1595: -- Is the Name Value Pair Arry of type EGO_COL_NAME_VALUE_PAIR_ARRAY which need to created for all the primary Keys of Source Document.

1591: --Parameters:
1592: --IN:
1593: -- 1. x_template_id - Document's UDA Template Id needs to passed.
1594: -- 2. x_pk_col_value_pairs
1595: -- Is the Name Value Pair Arry of type EGO_COL_NAME_VALUE_PAIR_ARRAY which need to created for all the primary Keys of Source Document.
1596: -- 3. x_revision_id
1597: -- Is the Revision Id which needs to be created.
1598: -- 4. p_commit - Flag to indentify whether the commit has to be done by the API or calling program will perform a commit.
1599: -- Possible Values are :

Line 1614: ,x_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

1610:
1611: PROCEDURE Archive_Attrs_Data
1612: (
1613: x_template_id IN NUMBER
1614: ,x_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1615: ,x_revision_id IN NUMBER
1616: ,x_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1617: ,x_return_status OUT NOCOPY VARCHAR2
1618: ,x_msg_count OUT NOCOPY NUMBER

Line 1632: l_new_dtlevel_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

1628: l_object FND_OBJECTS%ROWTYPE;
1629: l_main_data_level_id NUMBER;
1630: l_archive_data_level EGO_DATA_LEVEL_B%ROWTYPE;
1631: l_to_data_level_id NUMBER;
1632: l_new_dtlevel_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1633: l_old_dtlevel_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1634: l_return_status VARCHAR2(1);
1635: l_errorcode NUMBER;
1636: l_msg_count NUMBER;

Line 1633: l_old_dtlevel_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

1629: l_main_data_level_id NUMBER;
1630: l_archive_data_level EGO_DATA_LEVEL_B%ROWTYPE;
1631: l_to_data_level_id NUMBER;
1632: l_new_dtlevel_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1633: l_old_dtlevel_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1634: l_return_status VARCHAR2(1);
1635: l_errorcode NUMBER;
1636: l_msg_count NUMBER;
1637: l_msg_data VARCHAR2(1000);

Line 1730: EGO_COL_NAME_VALUE_PAIR_ARRAY(

1726: END IF;
1727:
1728: d_progress := 050;
1729: l_new_dtlevel_col_value_pairs :=
1730: EGO_COL_NAME_VALUE_PAIR_ARRAY(
1731: EGO_COL_NAME_VALUE_PAIR_OBJ(
1732: l_archive_data_level.PK1_COLUMN_NAME, x_revision_id
1733: )
1734: );

Line 1736: EGO_COL_NAME_VALUE_PAIR_ARRAY(

1732: l_archive_data_level.PK1_COLUMN_NAME, x_revision_id
1733: )
1734: );
1735: l_old_dtlevel_col_value_pairs :=
1736: EGO_COL_NAME_VALUE_PAIR_ARRAY(
1737: EGO_COL_NAME_VALUE_PAIR_OBJ(
1738: l_archive_data_level.PK1_COLUMN_NAME, null
1739: )
1740: );

Line 1820: -- Is the Name Value Pair Arry of type EGO_COL_NAME_VALUE_PAIR_ARRAY which need to created for all the primary Keys of Source Document.

1816: --Parameters:
1817: --IN:
1818: -- 1. x_template_id - Document's UDA Template Id needs to pass.
1819: -- 2. x_from_pk_col_value_pairs
1820: -- Is the Name Value Pair Arry of type EGO_COL_NAME_VALUE_PAIR_ARRAY which need to created for all the primary Keys of Source Document.
1821: -- 3. x_to_pk_col_value_pairs
1822: -- Is the Name Value Pair Arry of type EGO_COL_NAME_VALUE_PAIR_ARRAY which need to created for all the primary Keys of Destination Document.
1823: -- 4. x_copy_attribute_groups - Possible Values are :
1824: -- 1. 'ALL' [Default] - Identify that all the Attribute Groups which are associated to Source Document and having a Attribute Group Mapping to a Destination Document Attribute Group and have a usage in Destination template.

Line 1822: -- Is the Name Value Pair Arry of type EGO_COL_NAME_VALUE_PAIR_ARRAY which need to created for all the primary Keys of Destination Document.

1818: -- 1. x_template_id - Document's UDA Template Id needs to pass.
1819: -- 2. x_from_pk_col_value_pairs
1820: -- Is the Name Value Pair Arry of type EGO_COL_NAME_VALUE_PAIR_ARRAY which need to created for all the primary Keys of Source Document.
1821: -- 3. x_to_pk_col_value_pairs
1822: -- Is the Name Value Pair Arry of type EGO_COL_NAME_VALUE_PAIR_ARRAY which need to created for all the primary Keys of Destination Document.
1823: -- 4. x_copy_attribute_groups - Possible Values are :
1824: -- 1. 'ALL' [Default] - Identify that all the Attribute Groups which are associated to Source Document and having a Attribute Group Mapping to a Destination Document Attribute Group and have a usage in Destination template.
1825: -- 2. SPECIFIC - Only Specific Attribute Groups which internal names are mentioned in attribute_group_table parameter.
1826: -- 3. EXCLUSIVE - All the Attribute group mentioned in attribute_group_table will be ignored.

Line 1842: ,x_from_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

1838:
1839: PROCEDURE Copy_User_Attrs
1840: (
1841: x_template_id IN NUMBER
1842: ,x_from_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1843: ,x_to_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1844: ,x_copy_attribute_groups IN VARCHAR2 DEFAULT 'ALL' -- SPECIFIC / EXCLUSIVE
1845: ,x_attribute_group_table IN PO_TBL_VARCHAR30 DEFAULT NULL
1846: ,x_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 1843: ,x_to_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

1839: PROCEDURE Copy_User_Attrs
1840: (
1841: x_template_id IN NUMBER
1842: ,x_from_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1843: ,x_to_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1844: ,x_copy_attribute_groups IN VARCHAR2 DEFAULT 'ALL' -- SPECIFIC / EXCLUSIVE
1845: ,x_attribute_group_table IN PO_TBL_VARCHAR30 DEFAULT NULL
1846: ,x_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1847: ,x_return_status OUT NOCOPY VARCHAR2

Line 1861: l_dtlevel_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

1857: l_object_dff_cr g_object_dff_cr;
1858: l_object FND_OBJECTS%ROWTYPE;
1859: l_main_data_level EGO_DATA_LEVEL_B%ROWTYPE;
1860: l_to_data_level_id NUMBER;
1861: l_dtlevel_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1862: l_return_status VARCHAR2(1);
1863: l_errorcode NUMBER;
1864: l_msg_count NUMBER;
1865: l_msg_data VARCHAR2(1000);

Line 2057: EGO_COL_NAME_VALUE_PAIR_ARRAY(

2053: END IF;
2054:
2055:
2056: l_dtlevel_col_value_pairs :=
2057: EGO_COL_NAME_VALUE_PAIR_ARRAY(
2058: EGO_COL_NAME_VALUE_PAIR_OBJ(
2059: 'PK1_VALUE', null
2060: )
2061: );

Line 2430: ,x_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

2426: p_Action_Id IN NUMBER
2427: ,p_template_id IN NUMBER
2428: ,p_attribute_group_id IN NUMBER
2429: ,p_event IN VARCHAR2
2430: ,x_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2431: ,x_attribute_row_table IN OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
2432: ,x_attribute_data_table IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
2433: ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
2434: ,x_return_status OUT NOCOPY VARCHAR2

Line 2446: l_dtlevel_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

2442: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name;
2443: d_progress NUMBER := 0;
2444:
2445: l_action_id NUMBER;
2446: l_dtlevel_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
2447: l_return_status VARCHAR2(10);
2448: l_errorcode NUMBER;
2449: l_msg_count NUMBER;
2450: l_msg_data VARCHAR2(2000);

Line 2779: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;

2775: l_po_uda_usage_object po_uda_usage_object ;
2776: l_attr_grp_ids_list PO_TBL_NUMBER;
2777: l_x_attr_ids_count NUMBER;
2778: l_clm_standard_form PO_HEADERS_ALL.CLM_STANDARD_FORM%TYPE;
2779: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;
2780: l_attr_grp_ids PO_TBL_NUMBER;
2781: t_count NUMBER;
2782:
2783: cursor c_get_usages(p_template_id number) is

Line 2801: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'FORM_NAME', l_clm_standard_form));

2797:
2798: /* IF (c_get_usages_rec.attribute_category = 'FORMS') then
2799: SELECT clm_standard_form into l_clm_standard_form FROM po_headers_all
2800: WHERE po_header_id = p_po_header_id;
2801: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'FORM_NAME', l_clm_standard_form));
2802: END IF; */
2803:
2804: IF((p_is_doc_mod = FND_API.G_TRUE AND c_get_usages_rec.attribute_category = 'CHAIN')
2805: OR (c_get_usages_rec.attribute_category = 'DOCUMENT_NUMBERING') ) THEN

Line 2852: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;

2848: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name;
2849: d_progress NUMBER := 0;
2850:
2851: l_po_uda_usage_object po_uda_usage_object ;
2852: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;
2853: l_attr_grp_ids_list PO_TBL_NUMBER;
2854: l_contract_type PO_LINES_ALL.CONTRACT_TYPE%TYPE;
2855: l_clm_idc_type PO_LINES_ALL.CLM_IDC_TYPE%TYPE;
2856: l_x_attr_ids_count NUMBER;

Line 2891: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTRACT_LINE_TYPE', l_contract_type),

2887: FROM po_lines_draft_all
2888: WHERE po_line_id = p_po_line_id
2889: AND draft_id = p_draft_id;
2890: END IF;
2891: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTRACT_LINE_TYPE', l_contract_type),
2892: EGO_COL_NAME_VALUE_PAIR_OBJ( 'IDC_TYPE' , l_clm_idc_type ));
2893: END IF;
2894:
2895: IF(p_is_doc_mod = FND_API.G_TRUE AND c_get_usages_rec.attribute_category = 'CHAIN') THEN

Line 2944: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;

2940: d_progress NUMBER := 0;
2941: l_po_uda_usage_object po_uda_usage_object ;
2942: l_attr_grp_ids_list PO_TBL_NUMBER;
2943: l_x_attr_ids_count NUMBER;
2944: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;
2945: l_attr_grp_ids PO_TBL_NUMBER;
2946: t_count NUMBER;
2947:
2948: CURSOR c_get_usages(p_template_id NUMBER) IS