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.

[Home] [Help]

APPS.PO_DOC_NUMBERING_PKG dependencies on PO_UDA_AG_TEMPLATES

Line 267: ,p_object_name => l_src_object_name --Get it from PO_UDA_AG_TEMPLATES

263: l_src_object_name := PO_UDA_DATA_UTIL.g_object_dff_tl(l_ag_type).l_object_name;
264:
265: ego_user_attrs_data_pvt.get_user_attrs_data(
266: p_api_version => 1.0
267: ,p_object_name => l_src_object_name --Get it from PO_UDA_AG_TEMPLATES
268: ,p_pk_column_name_value_pairs => l_src_pk_col_name_val_pairs--Source Primary Keys
269: ,p_attr_group_request_table => l_attr_group_request_table --Construct the Attribute Group Table
270: ,x_attributes_row_table => l_attributes_row_table
271: ,x_attributes_data_table => l_attributes_data_table

Line 508: po_uda_ag_templates puat

504:
505: CURSOR C IS
506: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
507: from PO_UDA_AG_TEMPLATE_USAGES puatu,
508: po_uda_ag_templates puat
509: WHERE puat.ENTITY_CODE='PO_REQ_HEADER_EXT_ATTRS'
510: AND puat.document_level='HEADER'
511: AND puat.template_id = puatu.template_id
512: AND puatu.attribute_category='DOCUMENT_NUMBERING';

Line 824: po_uda_ag_templates puat

820:
821: CURSOR C IS
822: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
823: from PO_UDA_AG_TEMPLATE_USAGES puatu,
824: po_uda_ag_templates puat
825: WHERE puat.ENTITY_CODE='PO_REQ_HEADER_EXT_ATTRS'
826: AND puat.document_level='HEADER'
827: AND puat.template_id = puatu.template_id
828: AND puatu.attribute_category='DOCUMENT_NUMBERING';

Line 1018: po_uda_ag_templates puat

1014:
1015: CURSOR C IS
1016: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
1017: from PO_UDA_AG_TEMPLATE_USAGES puatu,
1018: po_uda_ag_templates puat
1019: WHERE puat.ENTITY_CODE='PON_AUC_HDRS_EXT_ATTRS'
1020: AND puat.document_level='HEADER'
1021: AND puat.template_id = puatu.template_id
1022: AND puatu.attribute_category='DOCUMENT_NUMBERING'

Line 1312: po_uda_ag_templates puat

1308:
1309: CURSOR C IS
1310: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
1311: from PO_UDA_AG_TEMPLATE_USAGES puatu,
1312: po_uda_ag_templates puat
1313: WHERE puat.ENTITY_CODE='PON_AUC_HDRS_EXT_ATTRS'
1314: AND puat.document_level='HEADER'
1315: AND puat.template_id = puatu.template_id
1316: AND puatu.attribute_category='DOCUMENT_NUMBERING'

Line 1486: po_uda_ag_templates puat

1482:
1483: CURSOR C IS
1484: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
1485: from PO_UDA_AG_TEMPLATE_USAGES puatu,
1486: po_uda_ag_templates puat
1487: WHERE puat.ENTITY_CODE='PO_HEADER_EXT_ATTRS'
1488: AND puat.document_level='HEADER'
1489: AND puat.template_id = puatu.template_id
1490: AND puatu.attribute_category='DOCUMENT_NUMBERING'

Line 1780: po_uda_ag_templates puat

1776:
1777: CURSOR C IS
1778: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
1779: from PO_UDA_AG_TEMPLATE_USAGES puatu,
1780: po_uda_ag_templates puat
1781: WHERE puat.ENTITY_CODE='PO_HEADER_EXT_ATTRS'
1782: AND puat.document_level='HEADER'
1783: AND puat.template_id = puatu.template_id
1784: AND puatu.attribute_category='DOCUMENT_NUMBERING'

Line 1943: po_uda_ag_templates puat

1939:
1940: CURSOR C IS
1941: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
1942: from PO_UDA_AG_TEMPLATE_USAGES puatu,
1943: po_uda_ag_templates puat
1944: WHERE puat.ENTITY_CODE='PO_HEADER_EXT_ATTRS'
1945: AND puat.document_level='HEADER'
1946: AND puat.template_id = puatu.template_id
1947: AND puatu.attribute_category='DOCUMENT_NUMBERING'

Line 2079: po_uda_ag_templates puat

2075:
2076: CURSOR C IS
2077: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
2078: from PO_UDA_AG_TEMPLATE_USAGES puatu,
2079: po_uda_ag_templates puat
2080: WHERE puat.ENTITY_CODE='PON_AUC_HDRS_EXT_ATTRS'
2081: AND puat.document_level='HEADER'
2082: AND puat.template_id = puatu.template_id
2083: AND puatu.attribute_category='DOCUMENT_NUMBERING'

Line 2222: po_uda_ag_templates puat

2218:
2219: CURSOR C IS
2220: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
2221: from PO_UDA_AG_TEMPLATE_USAGES puatu,
2222: po_uda_ag_templates puat
2223: WHERE puat.ENTITY_CODE='PON_AUC_HDRS_EXT_ATTRS'
2224: AND puat.document_level='HEADER'
2225: AND puat.template_id = puatu.template_id
2226: AND puatu.attribute_category='DOCUMENT_NUMBERING'

Line 2766: po_uda_ag_templates puat

2762:
2763: /*CURSOR C IS
2764: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
2765: from PO_UDA_AG_TEMPLATE_USAGES puatu,
2766: po_uda_ag_templates puat
2767: WHERE puat.ENTITY_CODE='PO_HEADER_EXT_ATTRS'
2768: AND puat.document_level='HEADER'
2769: AND puat.template_id = puatu.template_id
2770: AND puatu.attribute_category='DOCUMENT_NUMBERING'

Line 3353: po_uda_ag_templates puat

3349:
3350: CURSOR C IS
3351: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
3352: from PO_UDA_AG_TEMPLATE_USAGES puatu,
3353: po_uda_ag_templates puat
3354: WHERE puat.ENTITY_CODE='PO_HEADER_EXT_ATTRS'
3355: AND puat.document_level='HEADER'
3356: AND puat.template_id = puatu.template_id
3357: AND puatu.attribute_category='DOCUMENT_NUMBERING'

Line 3830: po_uda_ag_templates puat

3826:
3827: CURSOR C IS
3828: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
3829: from PO_UDA_AG_TEMPLATE_USAGES puatu,
3830: po_uda_ag_templates puat
3831: WHERE puat.ENTITY_CODE='PO_HEADER_EXT_ATTRS'
3832: AND puat.document_level='HEADER'
3833: AND puat.template_id = puatu.template_id
3834: AND puatu.attribute_category='DOCUMENT_NUMBERING'

Line 4101: po_uda_ag_templates puat

4097:
4098: CURSOR C IS
4099: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
4100: from PO_UDA_AG_TEMPLATE_USAGES puatu,
4101: po_uda_ag_templates puat
4102: WHERE puat.ENTITY_CODE='PON_AUC_HDRS_EXT_ATTRS'
4103: AND puat.document_level='HEADER'
4104: AND puat.template_id = puatu.template_id
4105: AND puatu.attribute_category='DOCUMENT_NUMBERING'

Line 4296: po_uda_ag_templates puat

4292:
4293: CURSOR C IS
4294: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
4295: from PO_UDA_AG_TEMPLATE_USAGES puatu,
4296: po_uda_ag_templates puat
4297: WHERE puat.ENTITY_CODE='PO_HEADER_EXT_ATTRS'
4298: AND puat.document_level='HEADER'
4299: AND puat.template_id = puatu.template_id
4300: AND puatu.attribute_category='DOCUMENT_NUMBERING'

Line 4638: po_uda_ag_templates puat

4634:
4635: CURSOR C IS
4636: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
4637: from PO_UDA_AG_TEMPLATE_USAGES puatu,
4638: po_uda_ag_templates puat
4639: WHERE puat.ENTITY_CODE='PO_HEADER_EXT_ATTRS'
4640: AND puat.document_level='HEADER'
4641: AND puat.template_id = puatu.template_id
4642: AND puatu.attribute_category='DOCUMENT_NUMBERING'

Line 4876: po_uda_ag_templates puat

4872:
4873: CURSOR C IS
4874: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
4875: from PO_UDA_AG_TEMPLATE_USAGES puatu,
4876: po_uda_ag_templates puat
4877: WHERE puat.ENTITY_CODE='PO_HEADER_EXT_ATTRS'
4878: AND puat.document_level='HEADER'
4879: AND puat.template_id = puatu.template_id
4880: AND puatu.attribute_category='DOCUMENT_NUMBERING'

Line 5028: po_uda_ag_templates puat,

5024:
5025: SELECT puatu.ATTRIBUTE_GROUP_ID, ags.ATTR_GROUP_NAME
5026: INTO l_attr_group_id, l_attr_group_name
5027: FROM PO_UDA_AG_TEMPLATE_USAGES puatu,
5028: po_uda_ag_templates puat,
5029: ego_attr_groups_v ags,
5030: po_headers_all_ext_b phaeb
5031: WHERE puat.ENTITY_CODE=p_ag_type
5032: AND phaeb.po_header_id = p_po_header_id

Line 5082: ,p_object_name => l_src_object_name --Get it from PO_UDA_AG_TEMPLATES

5078: l_src_object_name := PO_UDA_DATA_UTIL.g_object_dff_tl(p_ag_type).l_object_name;
5079:
5080: ego_user_attrs_data_pvt.get_user_attrs_data(
5081: p_api_version => 1.0
5082: ,p_object_name => l_src_object_name --Get it from PO_UDA_AG_TEMPLATES
5083: ,p_pk_column_name_value_pairs => l_src_pk_col_name_val_pairs--Source Primary Keys
5084: ,p_attr_group_request_table => l_attr_group_request_table --Construct the Attribute Group Table
5085: ,x_attributes_row_table => l_attributes_row_table
5086: ,x_attributes_data_table => l_attributes_data_table

Line 5354: ,p_object_name => l_src_object_name --Get it from PO_UDA_AG_TEMPLATES

5350: l_src_object_name := PO_UDA_DATA_UTIL.g_object_dff_tl(l_ag_type).l_object_name;
5351:
5352: ego_user_attrs_data_pvt.get_user_attrs_data(
5353: p_api_version => 1.0
5354: ,p_object_name => l_src_object_name --Get it from PO_UDA_AG_TEMPLATES
5355: ,p_pk_column_name_value_pairs => l_src_pk_col_name_val_pairs--Source Primary Keys
5356: ,p_attr_group_request_table => l_attr_group_request_table --Construct the Attribute Group Table
5357: ,x_attributes_row_table => l_attributes_row_table
5358: ,x_attributes_data_table => l_attributes_data_table

Line 5478: po_uda_ag_templates puat

5474:
5475: CURSOR c_attr_grp_id IS
5476: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
5477: from PO_UDA_AG_TEMPLATE_USAGES puatu,
5478: po_uda_ag_templates puat
5479: WHERE puat.ENTITY_CODE='PO_HEADER_EXT_ATTRS'
5480: AND puat.document_level='HEADER'
5481: AND puat.template_id = puatu.template_id
5482: AND puatu.attribute_category='DOCUMENT_NUMBERING'