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_DEFAULTING_PKG dependencies on PO_UDA_USAGE_OBJECT

Line 331: -- This procedure would construct the PO_UDA_USAGE_OBJECT_ARRAY with the usages for which the attribute groups

327: --------------------------------------------------------------------------------------------------------------------
328: --Start of Comments
329: --Name: CONSTRUCT_USAGE_OBJECT_ARRAY
330: --Procedure:
331: -- This procedure would construct the PO_UDA_USAGE_OBJECT_ARRAY with the usages for which the attribute groups
332: -- are not populated in the extention table throught the UI.
333: --Parameters:
334: --IN:
335: -- 1. p_pk1_value, p_pk2_value, p_pk3_value, p_pk4_value, p_pk5_value

Line 340: -- 1. x_po_uda_usage_object_array

336: -- The Primary Key values for the UDA Attributes
337: -- 2. p_template_id
338: -- This variable would contain the template id for which the actions are to be executed
339: --OUT:
340: -- 1. x_po_uda_usage_object_array
341: -- This variable of type PO_UDA_USAGE_OBJECT_ARRAY contains data of hhe usages.
342: -- 2. x_return_status - Generic Out parameter having return status
343: -- 3. x_errorcode - Generic Out parameter having error code
344: -- 4. x_msg_count - Generic Out parameter having return msg Count

Line 341: -- This variable of type PO_UDA_USAGE_OBJECT_ARRAY contains data of hhe usages.

337: -- 2. p_template_id
338: -- This variable would contain the template id for which the actions are to be executed
339: --OUT:
340: -- 1. x_po_uda_usage_object_array
341: -- This variable of type PO_UDA_USAGE_OBJECT_ARRAY contains data of hhe usages.
342: -- 2. x_return_status - Generic Out parameter having return status
343: -- 3. x_errorcode - Generic Out parameter having error code
344: -- 4. x_msg_count - Generic Out parameter having return msg Count
345: -- 5. x_msg_data - Generic Out parameter having return msg

Line 357: ,x_po_uda_usage_object_array OUT NOCOPY PO_UDA_USAGE_OBJECT_ARRAY

353: ,p_pk3_value IN NUMBER
354: ,p_pk4_value IN NUMBER
355: ,p_pk5_value IN NUMBER
356: ,p_template_id IN NUMBER
357: ,x_po_uda_usage_object_array OUT NOCOPY PO_UDA_USAGE_OBJECT_ARRAY
358: ,x_return_status OUT NOCOPY VARCHAR2
359: ,x_errorcode OUT NOCOPY NUMBER
360: ,x_msg_count OUT NOCOPY NUMBER
361: ,x_msg_data OUT NOCOPY VARCHAR2

Line 386: l_po_uda_usage_object PO_UDA_USAGE_OBJECT;

382: -- CURSORS FOR ALL CONTEXTS should be added later if needed
383:
384: l_entity_code VARCHAR2(200);
385: l_context_array EGO_COL_NAME_VALUE_PAIR_ARRAY;
386: l_po_uda_usage_object PO_UDA_USAGE_OBJECT;
387: l_po_uda_usage_object_array PO_UDA_USAGE_OBJECT_ARRAY;
388: l_attr_grp_ids_list PO_TBL_NUMBER;
389: l_idc_type VARCHAR2(200);
390: l_std_form VARCHAR2(200);

Line 387: l_po_uda_usage_object_array PO_UDA_USAGE_OBJECT_ARRAY;

383:
384: l_entity_code VARCHAR2(200);
385: l_context_array EGO_COL_NAME_VALUE_PAIR_ARRAY;
386: l_po_uda_usage_object PO_UDA_USAGE_OBJECT;
387: l_po_uda_usage_object_array PO_UDA_USAGE_OBJECT_ARRAY;
388: l_attr_grp_ids_list PO_TBL_NUMBER;
389: l_idc_type VARCHAR2(200);
390: l_std_form VARCHAR2(200);
391: l_contract_type VARCHAR2(200);

Line 431: l_po_uda_usage_object := PO_UDA_USAGE_OBJECT();

427: RAISE;
428: END;
429:
430: d_progress := 50;
431: l_po_uda_usage_object := PO_UDA_USAGE_OBJECT();
432: l_po_uda_usage_object_array := PO_UDA_USAGE_OBJECT_ARRAY();
433:
434: d_progress := 60;
435: PO_UDA_DEFAULTING_PKG.DEBUG('Initialized objects l_po_uda_usage_object, l_po_uda_usage_object_array', d_progress);

Line 432: l_po_uda_usage_object_array := PO_UDA_USAGE_OBJECT_ARRAY();

428: END;
429:
430: d_progress := 50;
431: l_po_uda_usage_object := PO_UDA_USAGE_OBJECT();
432: l_po_uda_usage_object_array := PO_UDA_USAGE_OBJECT_ARRAY();
433:
434: d_progress := 60;
435: PO_UDA_DEFAULTING_PKG.DEBUG('Initialized objects l_po_uda_usage_object, l_po_uda_usage_object_array', d_progress);
436:

Line 435: PO_UDA_DEFAULTING_PKG.DEBUG('Initialized objects l_po_uda_usage_object, l_po_uda_usage_object_array', d_progress);

431: l_po_uda_usage_object := PO_UDA_USAGE_OBJECT();
432: l_po_uda_usage_object_array := PO_UDA_USAGE_OBJECT_ARRAY();
433:
434: d_progress := 60;
435: PO_UDA_DEFAULTING_PKG.DEBUG('Initialized objects l_po_uda_usage_object, l_po_uda_usage_object_array', d_progress);
436:
437: FOR c_get_usages_rec IN c_get_usages(p_template_id) LOOP
438: l_context_array := EGO_COL_NAME_VALUE_PAIR_ARRAY();
439: PO_UDA_DEFAULTING_PKG.DEBUG('Initialized objects l_context_array', d_progress);

Line 477: l_po_uda_usage_object := po_uda_usage_object.new_instance(p_template_id, c_get_usages_rec.attribute_category, l_context_array);

473: d_progress := 150;
474: -- IF CASES FOR ALL USAGES which have a context
475: -- FOR ALL CONTEXTS should be added later if needed
476:
477: l_po_uda_usage_object := po_uda_usage_object.new_instance(p_template_id, c_get_usages_rec.attribute_category, l_context_array);
478: l_attr_grp_ids_list := l_po_uda_usage_object.Attr_group_Id;
479:
480: d_progress := 160;
481: PO_UDA_DEFAULTING_PKG.DEBUG('Before is_valid_ag_list' , d_progress);

Line 478: l_attr_grp_ids_list := l_po_uda_usage_object.Attr_group_Id;

474: -- IF CASES FOR ALL USAGES which have a context
475: -- FOR ALL CONTEXTS should be added later if needed
476:
477: l_po_uda_usage_object := po_uda_usage_object.new_instance(p_template_id, c_get_usages_rec.attribute_category, l_context_array);
478: l_attr_grp_ids_list := l_po_uda_usage_object.Attr_group_Id;
479:
480: d_progress := 160;
481: PO_UDA_DEFAULTING_PKG.DEBUG('Before is_valid_ag_list' , d_progress);
482:

Line 487: l_po_uda_usage_object_array.EXTEND(1);

483: IF is_valid_ag_list (p_pk1_value, p_pk2_value, p_pk3_value, p_pk4_value, p_pk5_value, p_template_id, l_attr_grp_ids_list)
484: THEN
485: d_progress := 170;
486: PO_UDA_DEFAULTING_PKG.DEBUG('The Usage Object is valid' , d_progress);
487: l_po_uda_usage_object_array.EXTEND(1);
488: l_po_uda_usage_object_array(l_po_uda_usage_object_array.COUNT) := l_po_uda_usage_object;
489: PO_UDA_DEFAULTING_PKG.DEBUG('Added usage object' , d_progress);
490: d_progress := 180;
491: ELSE

Line 488: l_po_uda_usage_object_array(l_po_uda_usage_object_array.COUNT) := l_po_uda_usage_object;

484: THEN
485: d_progress := 170;
486: PO_UDA_DEFAULTING_PKG.DEBUG('The Usage Object is valid' , d_progress);
487: l_po_uda_usage_object_array.EXTEND(1);
488: l_po_uda_usage_object_array(l_po_uda_usage_object_array.COUNT) := l_po_uda_usage_object;
489: PO_UDA_DEFAULTING_PKG.DEBUG('Added usage object' , d_progress);
490: d_progress := 180;
491: ELSE
492: d_progress := 190;

Line 500: PO_UDA_DEFAULTING_PKG.DEBUG(l_po_uda_usage_object_array, d_progress);

496: END LOOP;
497:
498: d_progress := 210;
499: PO_UDA_DEFAULTING_PKG.DEBUG('The Usage Object array constructed is as follows' , d_progress);
500: PO_UDA_DEFAULTING_PKG.DEBUG(l_po_uda_usage_object_array, d_progress);
501: x_po_uda_usage_object_array := l_po_uda_usage_object_array;
502: d_progress := 220;
503:
504: EXCEPTION

Line 501: x_po_uda_usage_object_array := l_po_uda_usage_object_array;

497:
498: d_progress := 210;
499: PO_UDA_DEFAULTING_PKG.DEBUG('The Usage Object array constructed is as follows' , d_progress);
500: PO_UDA_DEFAULTING_PKG.DEBUG(l_po_uda_usage_object_array, d_progress);
501: x_po_uda_usage_object_array := l_po_uda_usage_object_array;
502: d_progress := 220;
503:
504: EXCEPTION
505: WHEN OTHERS THEN

Line 1740: l_po_uda_usage_object_array PO_UDA_USAGE_OBJECT_ARRAY;

1736: ,x_msg_data OUT NOCOPY VARCHAR2
1737: )
1738: IS
1739: d_progress NUMBER := 0;
1740: l_po_uda_usage_object_array PO_UDA_USAGE_OBJECT_ARRAY;
1741:
1742: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;
1743: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
1744:

Line 1792: ,x_po_uda_usage_object_array => l_po_uda_usage_object_array

1788: ,p_pk3_value => p_pk3_value
1789: ,p_pk4_value => p_pk4_value
1790: ,p_pk5_value => p_pk5_value
1791: ,p_template_id => p_template_id
1792: ,x_po_uda_usage_object_array => l_po_uda_usage_object_array
1793: ,x_return_status => x_return_status
1794: ,x_errorcode => x_errorcode
1795: ,x_msg_count => x_msg_count
1796: ,x_msg_data => x_msg_data

Line 1814: ,x_po_uda_usage_object_array => l_po_uda_usage_object_array

1810: ,p_pk5_value => p_pk5_value
1811: ,p_template_id => p_template_id
1812: ,p_address_lookup_type => p_address_lookup_type
1813: ,x_external_attr_value_pairs => x_external_attr_value_pairs
1814: ,x_po_uda_usage_object_array => l_po_uda_usage_object_array
1815: ,x_return_status => x_return_status
1816: ,x_errorcode => x_errorcode
1817: ,x_msg_count => x_msg_count
1818: ,x_msg_data => x_msg_data

Line 1842: -- This procedure would execute for each object in the x_po_uda_usage_object_array array

1838: --------------------------------------------------------------------------------------------------------------------
1839: --Start of Comments
1840: --Name: DEFAULT_AGS_FROM_USAGE_OBJECT
1841: --Procedure:
1842: -- This procedure would execute for each object in the x_po_uda_usage_object_array array
1843: -- It executes the PO_UDA_IMPORT_PKG.POPULATE_EMPTY_AGS, PO_UDA_IMPORT_PKG.EXECUTE_IMPORT_UDA_FUNCTION(XD),
1844: -- EGO_USER_ATTRS_DATA_PVT.Process_User_Attrs_Data(EGO Validations),
1845: -- PO_UDA_IMPORT_PKG.EXECUTE_IMPORT_UDA_FUNCTION(XV),EGO_USER_ATTRS_DATA_PVT.Process_User_Attrs_Data(Populates the data),
1846: -- PO_UDA_IMPORT_PKG.EXECUTE_IMPORT_UDA_FUNCTION(XPD).

Line 1856: -- 2. x_po_uda_usage_object_array

1852: -- This variable would contain the template id for which the actions are to be executed
1853: --IN/OUT:
1854: -- 1. x_external_attr_value_pairs
1855: -- This variable would contain an array of attribute value pairs (EGO_COL_NAME_VALUE_PAIR_TABLE)
1856: -- 2. x_po_uda_usage_object_array
1857: -- This variable of type PO_UDA_USAGE_OBJECT_ARRAY contains data of the usages.
1858: -- 3. p_address_lookup_type
1859: -- This variable would contain the address lookup type to get the address type
1860: --OUT:

Line 1857: -- This variable of type PO_UDA_USAGE_OBJECT_ARRAY contains data of the usages.

1853: --IN/OUT:
1854: -- 1. x_external_attr_value_pairs
1855: -- This variable would contain an array of attribute value pairs (EGO_COL_NAME_VALUE_PAIR_TABLE)
1856: -- 2. x_po_uda_usage_object_array
1857: -- This variable of type PO_UDA_USAGE_OBJECT_ARRAY contains data of the usages.
1858: -- 3. p_address_lookup_type
1859: -- This variable would contain the address lookup type to get the address type
1860: --OUT:
1861: -- 1. x_return_status - Generic Out parameter having return status

Line 1878: ,x_po_uda_usage_object_array IN OUT NOCOPY PO_UDA_USAGE_OBJECT_ARRAY

1874: ,p_pk5_value IN NUMBER DEFAULT NULL
1875: ,p_template_id IN NUMBER
1876: ,p_address_lookup_type IN VARCHAR2 DEFAULT NULL
1877: ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
1878: ,x_po_uda_usage_object_array IN OUT NOCOPY PO_UDA_USAGE_OBJECT_ARRAY
1879: ,x_return_status OUT NOCOPY VARCHAR2
1880: ,x_errorcode OUT NOCOPY NUMBER
1881: ,x_msg_count OUT NOCOPY NUMBER
1882: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1920: PO_UDA_DEFAULTING_PKG.DEBUG('x_po_uda_usage_object_array is as follows :', d_progress);

1916: PO_UDA_DEFAULTING_PKG.DEBUG('p_template_id : ' || p_template_id, d_progress);
1917: PO_UDA_DEFAULTING_PKG.DEBUG('p_address_lookup_type : ' || p_address_lookup_type, d_progress);
1918: PO_UDA_DEFAULTING_PKG.DEBUG('x_external_attr_value_pairs is as follows :', d_progress);
1919: PO_UDA_DEFAULTING_PKG.DEBUG(x_external_attr_value_pairs, d_progress);
1920: PO_UDA_DEFAULTING_PKG.DEBUG('x_po_uda_usage_object_array is as follows :', d_progress);
1921: PO_UDA_DEFAULTING_PKG.DEBUG(x_po_uda_usage_object_array, d_progress);
1922:
1923: x_return_status := FND_API.G_RET_STS_SUCCESS;
1924: BEGIN

Line 1921: PO_UDA_DEFAULTING_PKG.DEBUG(x_po_uda_usage_object_array, d_progress);

1917: PO_UDA_DEFAULTING_PKG.DEBUG('p_address_lookup_type : ' || p_address_lookup_type, d_progress);
1918: PO_UDA_DEFAULTING_PKG.DEBUG('x_external_attr_value_pairs is as follows :', d_progress);
1919: PO_UDA_DEFAULTING_PKG.DEBUG(x_external_attr_value_pairs, d_progress);
1920: PO_UDA_DEFAULTING_PKG.DEBUG('x_po_uda_usage_object_array is as follows :', d_progress);
1921: PO_UDA_DEFAULTING_PKG.DEBUG(x_po_uda_usage_object_array, d_progress);
1922:
1923: x_return_status := FND_API.G_RET_STS_SUCCESS;
1924: BEGIN
1925: d_progress := 20;

Line 1989: ,x_po_uda_usage_object_array => x_po_uda_usage_object_array

1985: p_template_id => l_class_code_name_value_pairs(l_class_code_name_value_pairs.FIRST).VALUE
1986: ,p_pk_column_name_value_pairs => l_pk_column_name_value_pairs
1987: ,p_external_attr_value_pairs => x_external_attr_value_pairs
1988: ,p_address_lookup_type => p_address_lookup_type
1989: ,x_po_uda_usage_object_array => x_po_uda_usage_object_array
1990: ,x_attr_name_value_pairs => l_attr_name_value_pairs
1991: ,x_attributes_row_table => l_attributes_row_table
1992: ,x_return_status => x_return_status
1993: ,x_errorcode => x_errorcode

Line 3302: p_structure_array IN PO_UDA_USAGE_OBJECT_ARRAY

3298: END DEBUG;
3299:
3300: PROCEDURE DEBUG
3301: (
3302: p_structure_array IN PO_UDA_USAGE_OBJECT_ARRAY
3303: ,p_progress IN NUMBER
3304: )
3305: IS
3306: l_structure_ind NUMBER;

Line 3307: l_structure PO_UDA_USAGE_OBJECT;

3303: ,p_progress IN NUMBER
3304: )
3305: IS
3306: l_structure_ind NUMBER;
3307: l_structure PO_UDA_USAGE_OBJECT;
3308: BEGIN
3309: IF PO_LOG.d_stmt THEN --bug 12611018
3310:
3311: IF p_structure_array IS NOT NULL THEN