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_TEMPLATES_UTIL dependencies on PO_UDA_TEMPLATES_UTIL

Line 1: PACKAGE BODY PO_UDA_TEMPLATES_UTIL AS

1: PACKAGE BODY PO_UDA_TEMPLATES_UTIL AS
2: /* $Header: PO_UDA_TEMPLATES_UTIL.plb 120.22.12020000.5 2013/04/22 23:24:42 rarajar ship $ */
3:
4: d_pkg_name CONSTANT varchar2(50) := PO_LOG.get_package_base('PO_UDA_TEMPLATES_UTIL');
5: d_appln_short_name CONSTANT VARCHAR2(20) := 'PO';

Line 2: /* $Header: PO_UDA_TEMPLATES_UTIL.plb 120.22.12020000.5 2013/04/22 23:24:42 rarajar ship $ */

1: PACKAGE BODY PO_UDA_TEMPLATES_UTIL AS
2: /* $Header: PO_UDA_TEMPLATES_UTIL.plb 120.22.12020000.5 2013/04/22 23:24:42 rarajar ship $ */
3:
4: d_pkg_name CONSTANT varchar2(50) := PO_LOG.get_package_base('PO_UDA_TEMPLATES_UTIL');
5: d_appln_short_name CONSTANT VARCHAR2(20) := 'PO';
6:

Line 4: d_pkg_name CONSTANT varchar2(50) := PO_LOG.get_package_base('PO_UDA_TEMPLATES_UTIL');

1: PACKAGE BODY PO_UDA_TEMPLATES_UTIL AS
2: /* $Header: PO_UDA_TEMPLATES_UTIL.plb 120.22.12020000.5 2013/04/22 23:24:42 rarajar ship $ */
3:
4: d_pkg_name CONSTANT varchar2(50) := PO_LOG.get_package_base('PO_UDA_TEMPLATES_UTIL');
5: d_appln_short_name CONSTANT VARCHAR2(20) := 'PO';
6:
7: -------------------------------------------------------------------------------
8: --- Start of Comments

Line 445: --- po_uda_templates_util.generate_template_view

441: --- Else it would compile all the templates which satisfy the criteria depending on the parameters passed
442: ---
443: --- Compileing a template:
444: --- The Database view is generated using the call
445: --- po_uda_templates_util.generate_template_view
446: --- The appropriate pages are created using the call
447: --- po_uda_templates_util.sync_page_entries
448: --- The compiled flag is changed to ?Y? once the above process is successful
449: ---

Line 447: --- po_uda_templates_util.sync_page_entries

443: --- Compileing a template:
444: --- The Database view is generated using the call
445: --- po_uda_templates_util.generate_template_view
446: --- The appropriate pages are created using the call
447: --- po_uda_templates_util.sync_page_entries
448: --- The compiled flag is changed to ?Y? once the above process is successful
449: ---
450: --- End of Comments
451: -------------------------------------------------------------------------------

Line 537: PO_UDA_TEMPLATES_UTIL.COMPILE_TEMPLATE

533: -----------------------------------------------------------------------------
534: d_progress := 20;
535:
536:
537: PO_UDA_TEMPLATES_UTIL.COMPILE_TEMPLATE
538: (
539: p_template_id => p_template_id
540: ,errbuf => errbuf
541: ,retcode => retcode

Line 572: PO_UDA_TEMPLATES_UTIL.COMPILE_TEMPLATE

568: FETCH c_templates INTO l_template_id;
569: EXIT WHEN c_templates%NOTFOUND;
570: d_progress := 100;
571:
572: PO_UDA_TEMPLATES_UTIL.COMPILE_TEMPLATE
573: (
574: p_template_id => p_template_id
575: ,errbuf => errbuf
576: ,retcode => retcode

Line 643: --- po_uda_templates_util.generate_template_view

639: --- It would compile the specific template
640: ---
641: --- Compileing a template:
642: --- The Database view is generated using the call
643: --- po_uda_templates_util.generate_template_view
644: --- The appropriate pages are created using the call
645: --- po_uda_templates_util.sync_page_entries
646: --- The compiled flag is changed to ?Y? once the above process is successful
647: ---

Line 645: --- po_uda_templates_util.sync_page_entries

641: --- Compileing a template:
642: --- The Database view is generated using the call
643: --- po_uda_templates_util.generate_template_view
644: --- The appropriate pages are created using the call
645: --- po_uda_templates_util.sync_page_entries
646: --- The compiled flag is changed to ?Y? once the above process is successful
647: ---
648: --- End of Comments
649: -------------------------------------------------------------------------------

Line 700: PO_UDA_TEMPLATES_UTIL.generate_template_view

696: d_progress := 180;
697:
698: SAVEPOINT BEFORE_GENERATE_TEMPALTE_VIEW;
699:
700: PO_UDA_TEMPLATES_UTIL.generate_template_view
701: (
702: p_api_version => 1.0
703: ,p_template_id => p_template_id
704: ,x_template_view_name => l_template_view_name

Line 729: PO_UDA_TEMPLATES_UTIL.SYNC_PAGE_ENTRIES

725:
726: END IF;
727:
728: d_progress := 220;
729: PO_UDA_TEMPLATES_UTIL.SYNC_PAGE_ENTRIES
730: (
731: p_template_id => p_template_id
732: ,x_return_status => l_return_status
733: ,x_errorcode => l_errorcode

Line 831: PO_UDA_TEMPLATES_UTIL.is_read_only_attribute_group

827: WHERE DUMMY_ATTRIBUTE_GROUP_ID = l_attr_grp_id
828: AND ROWNUM < 2;
829:
830: IF l_po_header_group_id IS NOT NULL THEN
831: PO_UDA_TEMPLATES_UTIL.is_read_only_attribute_group
832: (
833: p_attribute_group_type => 'PO_HEADER_EXT_ATTRS',
834: p_attribute_group_id => l_po_header_group_id,
835: p_source => p_source,

Line 841: PO_UDA_TEMPLATES_UTIL.is_read_only_attribute_group

837: );
838: END IF;
839:
840: IF l_po_line_group_id IS NOT NULL AND x_return_status NOT IN ('S', 'U') THEN
841: PO_UDA_TEMPLATES_UTIL.is_read_only_attribute_group
842: (
843: p_attribute_group_type => 'PO_LINE_EXT_ATTRS',
844: p_attribute_group_id => l_po_line_group_id,
845: p_source => p_source,

Line 851: PO_UDA_TEMPLATES_UTIL.is_read_only_attribute_group

847: );
848: END IF;
849:
850: IF l_shipments_group_id IS NOT NULL AND x_return_status NOT IN ('S', 'U') THEN
851: PO_UDA_TEMPLATES_UTIL.is_read_only_attribute_group
852: (
853: p_attribute_group_type => 'PO_SHIPMENTS_EXT_ATTRS',
854: p_attribute_group_id => l_shipments_group_id,
855: p_source => p_source,

Line 861: PO_UDA_TEMPLATES_UTIL.is_read_only_attribute_group

857: );
858: END IF;
859:
860: IF l_po_distributions_group_id IS NOT NULL AND x_return_status NOT IN ('S', 'U') THEN
861: PO_UDA_TEMPLATES_UTIL.is_read_only_attribute_group
862: (
863: p_attribute_group_type => 'PO_DISTRIBUTIONS_EXT_ATTRS',
864: p_attribute_group_id => l_po_distributions_group_id,
865: p_source => p_source,

Line 871: PO_UDA_TEMPLATES_UTIL.is_read_only_attribute_group

867: );
868: END IF;
869:
870: IF l_req_header_group_id IS NOT NULL AND x_return_status NOT IN ('S', 'U') THEN
871: PO_UDA_TEMPLATES_UTIL.is_read_only_attribute_group
872: (
873: p_attribute_group_type => 'PO_REQ_HEADER_EXT_ATTRS',
874: p_attribute_group_id => l_req_header_group_id,
875: p_source => p_source,

Line 881: PO_UDA_TEMPLATES_UTIL.is_read_only_attribute_group

877: );
878: END IF;
879:
880: IF l_req_line_group_id IS NOT NULL AND x_return_status NOT IN ('S', 'U') THEN
881: PO_UDA_TEMPLATES_UTIL.is_read_only_attribute_group
882: (
883: p_attribute_group_type => 'PO_REQ_LINE_EXT_ATTRS',
884: p_attribute_group_id => l_req_line_group_id,
885: p_source => p_source,

Line 891: PO_UDA_TEMPLATES_UTIL.is_read_only_attribute_group

887: );
888: END IF;
889:
890: IF l_req_distribution_group_id IS NOT NULL AND x_return_status NOT IN ('S', 'U') THEN
891: PO_UDA_TEMPLATES_UTIL.is_read_only_attribute_group
892: (
893: p_attribute_group_type => 'PO_REQ_DIST_EXT_ATTRS',
894: p_attribute_group_id => l_req_distribution_group_id,
895: p_source => p_source,

Line 901: PO_UDA_TEMPLATES_UTIL.is_read_only_attribute_group

897: );
898: END IF;
899:
900: IF l_bid_item_proce_group_id IS NOT NULL AND x_return_status NOT IN ('S', 'U') THEN
901: PO_UDA_TEMPLATES_UTIL.is_read_only_attribute_group
902: (
903: p_attribute_group_type => 'PON_BID_PRICES_EXT_ATTRS',
904: p_attribute_group_id => l_bid_item_proce_group_id,
905: p_source => p_source,

Line 911: PO_UDA_TEMPLATES_UTIL.is_read_only_attribute_group

907: );
908: END IF;
909:
910: IF l_bid_header_group_id IS NOT NULL AND x_return_status NOT IN ('S', 'U') THEN
911: PO_UDA_TEMPLATES_UTIL.is_read_only_attribute_group
912: (
913: p_attribute_group_type => 'PON_BID_HDRS_EXT_ATTRS',
914: p_attribute_group_id => l_bid_header_group_id,
915: p_source => p_source,

Line 921: PO_UDA_TEMPLATES_UTIL.is_read_only_attribute_group

917: );
918: END IF;
919:
920: IF l_pon_auc_header_group_id IS NOT NULL AND x_return_status NOT IN ('S', 'U') THEN
921: PO_UDA_TEMPLATES_UTIL.is_read_only_attribute_group
922: (
923: p_attribute_group_type => 'PON_AUC_HDRS_EXT_ATTRS',
924: p_attribute_group_id => l_pon_auc_header_group_id,
925: p_source => p_source,

Line 931: PO_UDA_TEMPLATES_UTIL.is_read_only_attribute_group

927: );
928: END IF;
929:
930: IF l_pon_auc_item_price_group_id IS NOT NULL AND x_return_status NOT IN ('S', 'U') THEN
931: PO_UDA_TEMPLATES_UTIL.is_read_only_attribute_group
932: (
933: p_attribute_group_type => 'PON_AUC_PRICES_EXT_ATTRS',
934: p_attribute_group_id => l_pon_auc_item_price_group_id,
935: p_source => p_source,

Line 1267: PO_UDA_TEMPLATES_UTIL.sync_attribute_group(

1263: PO_LOG.stmt(d_module, d_progress, 'l_attr_grp_id', l_attr_grp_id);
1264: END IF;
1265:
1266: -- Fetched the attribute group ID and calling the overloaded sync api
1267: PO_UDA_TEMPLATES_UTIL.sync_attribute_group(
1268: p_glb_api_version,
1269: p_glb_application_id,
1270: l_attr_grp_id,
1271: x_return_status,

Line 1298: PO_UDA_TEMPLATES_UTIL.delete_real_attr_group(

1294: LOOP
1295: FETCH c_to_delete_AG INTO l_attr_grp_id;
1296: EXIT WHEN c_to_delete_AG%NOTFOUND;
1297:
1298: PO_UDA_TEMPLATES_UTIL.delete_real_attr_group(
1299: p_glb_api_version,
1300: l_attr_grp_id
1301: );
1302:

Line 5906: END PO_UDA_TEMPLATES_UTIL;

5902: END IF;
5903: END Delete_Association;
5904:
5905:
5906: END PO_UDA_TEMPLATES_UTIL;