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.POR_UDA_PKG dependencies on PO_UDA_USAGE_OBJECT

Line 18: l_po_uda_usage_object po_uda_usage_object ;

14: d_api_name CONSTANT VARCHAR2(30) := 'get_pr_line_attr_group_ids';
15: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name;
16: d_progress NUMBER := 0;
17:
18: l_po_uda_usage_object po_uda_usage_object ;
19: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;
20: l_attr_grp_ids_list PO_TBL_NUMBER;
21: l_contract_type VARCHAR2(250);
22: l_x_attr_ids_count NUMBER;

Line 63: l_po_uda_usage_object := po_uda_usage_object.new_instance(p_template_id,c_get_usages_rec.attribute_category,l_context );

59: PO_LOG.stmt(d_module, d_progress, 'Ignore Chain AG Ids');
60: END IF;
61:
62: ELSE
63: l_po_uda_usage_object := po_uda_usage_object.new_instance(p_template_id,c_get_usages_rec.attribute_category,l_context );
64: l_attr_grp_ids_list := l_po_uda_usage_object.Attr_group_Id;
65:
66: FOR i IN 1..l_attr_grp_ids_list.Count LOOP
67: l_x_attr_ids_count := l_attr_grp_ids.Count + 1;

Line 64: l_attr_grp_ids_list := l_po_uda_usage_object.Attr_group_Id;

60: END IF;
61:
62: ELSE
63: l_po_uda_usage_object := po_uda_usage_object.new_instance(p_template_id,c_get_usages_rec.attribute_category,l_context );
64: l_attr_grp_ids_list := l_po_uda_usage_object.Attr_group_Id;
65:
66: FOR i IN 1..l_attr_grp_ids_list.Count LOOP
67: l_x_attr_ids_count := l_attr_grp_ids.Count + 1;
68: l_attr_grp_ids.extend(1);

Line 100: l_po_uda_usage_object_array PO_UDA_USAGE_OBJECT_ARRAY;

96: d_api_name CONSTANT VARCHAR2(30) := 'SUBMIT_NON_RENDER_UDA';
97: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name;
98: d_progress NUMBER := 0;
99:
100: l_po_uda_usage_object_array PO_UDA_USAGE_OBJECT_ARRAY;
101: l_template_id NUMBER;
102: l_contract_type VARCHAR2(500);
103: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;
104: l_preparer_id NUMBER;

Line 588: l_po_uda_usage_object po_uda_usage_object ;

584: d_api_name CONSTANT VARCHAR2(30) := 'get_pr_header_attr_group_ids';
585: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name;
586: d_progress NUMBER := 0;
587:
588: l_po_uda_usage_object po_uda_usage_object ;
589: l_attr_grp_ids_list PO_TBL_NUMBER;
590: l_x_attr_ids_count NUMBER;
591: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;
592: l_attr_grp_ids PO_TBL_NUMBER;

Line 615: l_po_uda_usage_object := po_uda_usage_object.new_instance(p_template_id,c_get_usages_rec.attribute_category,l_context );

611: PO_LOG.stmt(d_module, d_progress, 'Ignore Chain AG Ids');
612: END IF;
613:
614: ELSE
615: l_po_uda_usage_object := po_uda_usage_object.new_instance(p_template_id,c_get_usages_rec.attribute_category,l_context );
616: l_attr_grp_ids_list := l_po_uda_usage_object.Attr_group_Id;
617: t_count := l_attr_grp_ids_list.Count;
618:
619: FOR i IN 1..l_attr_grp_ids_list.Count LOOP

Line 616: l_attr_grp_ids_list := l_po_uda_usage_object.Attr_group_Id;

612: END IF;
613:
614: ELSE
615: l_po_uda_usage_object := po_uda_usage_object.new_instance(p_template_id,c_get_usages_rec.attribute_category,l_context );
616: l_attr_grp_ids_list := l_po_uda_usage_object.Attr_group_Id;
617: t_count := l_attr_grp_ids_list.Count;
618:
619: FOR i IN 1..l_attr_grp_ids_list.Count LOOP
620: l_x_attr_ids_count := l_attr_grp_ids.Count + 1;

Line 1002: l_po_uda_usage_object_array PO_UDA_USAGE_OBJECT_ARRAY;

998: d_api_name CONSTANT VARCHAR2(30) := 'DEFAULT_NON_RENDER_UDA';
999: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name;
1000: d_progress NUMBER := 0;
1001:
1002: l_po_uda_usage_object_array PO_UDA_USAGE_OBJECT_ARRAY;
1003: l_template_id NUMBER;
1004: l_external_attr_value_pairs EGO_COL_NAME_VALUE_PAIR_TABLE;
1005: l_line_ext_attr_value_pairs EGO_COL_NAME_VALUE_PAIR_TABLE;
1006: l_po_uda_usage_object PO_UDA_USAGE_OBJECT;

Line 1006: l_po_uda_usage_object PO_UDA_USAGE_OBJECT;

1002: l_po_uda_usage_object_array PO_UDA_USAGE_OBJECT_ARRAY;
1003: l_template_id NUMBER;
1004: l_external_attr_value_pairs EGO_COL_NAME_VALUE_PAIR_TABLE;
1005: l_line_ext_attr_value_pairs EGO_COL_NAME_VALUE_PAIR_TABLE;
1006: l_po_uda_usage_object PO_UDA_USAGE_OBJECT;
1007: l_contract_type VARCHAR2(500);
1008: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;
1009: l_address_lookup_type VARCHAR2(200);
1010: l_preparer_id NUMBER;

Line 1051: l_po_uda_usage_object := PO_UDA_USAGE_OBJECT();

1047:
1048: SELECT uda_template_id INTO l_template_id
1049: FROM po_requisition_headers_all WHERE requisition_header_id = p_req_header_id;
1050:
1051: l_po_uda_usage_object := PO_UDA_USAGE_OBJECT();
1052: l_po_uda_usage_object_array := PO_UDA_USAGE_OBJECT_ARRAY();
1053: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY();
1054:
1055: IF p_is_amend_flow = 'true' THEN

Line 1052: l_po_uda_usage_object_array := PO_UDA_USAGE_OBJECT_ARRAY();

1048: SELECT uda_template_id INTO l_template_id
1049: FROM po_requisition_headers_all WHERE requisition_header_id = p_req_header_id;
1050:
1051: l_po_uda_usage_object := PO_UDA_USAGE_OBJECT();
1052: l_po_uda_usage_object_array := PO_UDA_USAGE_OBJECT_ARRAY();
1053: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY();
1054:
1055: IF p_is_amend_flow = 'true' THEN
1056: l_address_lookup_type := 'PR_AMD_UDA_ADDRESS_TYPES';

Line 1063: l_po_uda_usage_object := po_uda_usage_object.new_instance(l_template_id,c_get_usages_rec.attribute_category,l_context );

1059: END IF;
1060:
1061: FOR c_get_usages_rec IN c_get_usages(l_template_id) LOOP
1062:
1063: l_po_uda_usage_object := po_uda_usage_object.new_instance(l_template_id,c_get_usages_rec.attribute_category,l_context );
1064: l_attr_grp_ids_list := l_po_uda_usage_object.Attr_group_Id;
1065:
1066: IF po_uda_defaulting_pkg.is_valid_ag_list (p_req_header_id, null, null, null, null, l_template_id, l_attr_grp_ids_list)
1067: THEN

Line 1064: l_attr_grp_ids_list := l_po_uda_usage_object.Attr_group_Id;

1060:
1061: FOR c_get_usages_rec IN c_get_usages(l_template_id) LOOP
1062:
1063: l_po_uda_usage_object := po_uda_usage_object.new_instance(l_template_id,c_get_usages_rec.attribute_category,l_context );
1064: l_attr_grp_ids_list := l_po_uda_usage_object.Attr_group_Id;
1065:
1066: IF po_uda_defaulting_pkg.is_valid_ag_list (p_req_header_id, null, null, null, null, l_template_id, l_attr_grp_ids_list)
1067: THEN
1068: l_po_uda_usage_object_array.EXTEND(1);

Line 1068: l_po_uda_usage_object_array.EXTEND(1);

1064: l_attr_grp_ids_list := l_po_uda_usage_object.Attr_group_Id;
1065:
1066: IF po_uda_defaulting_pkg.is_valid_ag_list (p_req_header_id, null, null, null, null, l_template_id, l_attr_grp_ids_list)
1067: THEN
1068: l_po_uda_usage_object_array.EXTEND(1);
1069: l_po_uda_usage_object_array(l_po_uda_usage_object_array.COUNT) := l_po_uda_usage_object;
1070: END IF;
1071: END LOOP;
1072:

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

1065:
1066: IF po_uda_defaulting_pkg.is_valid_ag_list (p_req_header_id, null, null, null, null, l_template_id, l_attr_grp_ids_list)
1067: THEN
1068: l_po_uda_usage_object_array.EXTEND(1);
1069: l_po_uda_usage_object_array(l_po_uda_usage_object_array.COUNT) := l_po_uda_usage_object;
1070: END IF;
1071: END LOOP;
1072:
1073: SELECT preparer_id, org_id INTO l_preparer_id, l_org_id

Line 1086: ,x_po_uda_usage_object_array => l_po_uda_usage_object_array

1082: p_pk1_value => p_req_header_id
1083: ,p_template_id => l_template_id
1084: ,p_address_lookup_type => l_address_lookup_type
1085: ,x_external_attr_value_pairs => l_external_attr_value_pairs
1086: ,x_po_uda_usage_object_array => l_po_uda_usage_object_array
1087: ,x_return_status => l_return_status
1088: ,x_errorcode => l_errorcode
1089: ,x_msg_count => l_msg_count
1090: ,x_msg_data => l_msg_data

Line 1102: l_po_uda_usage_object := PO_UDA_USAGE_OBJECT();

1098: SELECT uda_template_id INTO l_template_id
1099: FROM po_requisition_lines_all
1100: WHERE requisition_line_id = c_get_lines_rec.requisition_line_id;
1101:
1102: l_po_uda_usage_object := PO_UDA_USAGE_OBJECT();
1103: l_po_uda_usage_object_array := PO_UDA_USAGE_OBJECT_ARRAY();
1104:
1105: FOR c_get_line_usages_rec IN c_get_line_usages(l_template_id) LOOP
1106:

Line 1103: l_po_uda_usage_object_array := PO_UDA_USAGE_OBJECT_ARRAY();

1099: FROM po_requisition_lines_all
1100: WHERE requisition_line_id = c_get_lines_rec.requisition_line_id;
1101:
1102: l_po_uda_usage_object := PO_UDA_USAGE_OBJECT();
1103: l_po_uda_usage_object_array := PO_UDA_USAGE_OBJECT_ARRAY();
1104:
1105: FOR c_get_line_usages_rec IN c_get_line_usages(l_template_id) LOOP
1106:
1107: IF (c_get_line_usages_rec.attribute_category = 'PRICING') then

Line 1115: l_po_uda_usage_object := po_uda_usage_object.new_instance(l_template_id,c_get_line_usages_rec.attribute_category,l_context );

1111:
1112: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTRACT_LINE_TYPE', l_contract_type));
1113: END IF;
1114:
1115: l_po_uda_usage_object := po_uda_usage_object.new_instance(l_template_id,c_get_line_usages_rec.attribute_category,l_context );
1116: l_attr_grp_ids_list := l_po_uda_usage_object.Attr_group_Id;
1117:
1118: IF po_uda_defaulting_pkg.is_valid_ag_list (p_req_header_id, null, null, null, null, l_template_id, l_attr_grp_ids_list)
1119: THEN

Line 1116: l_attr_grp_ids_list := l_po_uda_usage_object.Attr_group_Id;

1112: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTRACT_LINE_TYPE', l_contract_type));
1113: END IF;
1114:
1115: l_po_uda_usage_object := po_uda_usage_object.new_instance(l_template_id,c_get_line_usages_rec.attribute_category,l_context );
1116: l_attr_grp_ids_list := l_po_uda_usage_object.Attr_group_Id;
1117:
1118: IF po_uda_defaulting_pkg.is_valid_ag_list (p_req_header_id, null, null, null, null, l_template_id, l_attr_grp_ids_list)
1119: THEN
1120: l_po_uda_usage_object_array.EXTEND(1);

Line 1120: l_po_uda_usage_object_array.EXTEND(1);

1116: l_attr_grp_ids_list := l_po_uda_usage_object.Attr_group_Id;
1117:
1118: IF po_uda_defaulting_pkg.is_valid_ag_list (p_req_header_id, null, null, null, null, l_template_id, l_attr_grp_ids_list)
1119: THEN
1120: l_po_uda_usage_object_array.EXTEND(1);
1121: l_po_uda_usage_object_array(l_po_uda_usage_object_array.COUNT) := l_po_uda_usage_object;
1122: END IF;
1123: END LOOP;
1124:

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

1117:
1118: IF po_uda_defaulting_pkg.is_valid_ag_list (p_req_header_id, null, null, null, null, l_template_id, l_attr_grp_ids_list)
1119: THEN
1120: l_po_uda_usage_object_array.EXTEND(1);
1121: l_po_uda_usage_object_array(l_po_uda_usage_object_array.COUNT) := l_po_uda_usage_object;
1122: END IF;
1123: END LOOP;
1124:
1125: SELECT line_type_id, contract_type, item_id, deliver_to_location_id

Line 1140: ,x_po_uda_usage_object_array => l_po_uda_usage_object_array

1136: (
1137: p_pk1_value => c_get_lines_rec.requisition_line_id
1138: ,p_template_id => l_template_id
1139: ,x_external_attr_value_pairs => l_external_attr_value_pairs
1140: ,x_po_uda_usage_object_array => l_po_uda_usage_object_array
1141: ,x_return_status => l_return_status
1142: ,x_errorcode => l_errorcode
1143: ,x_msg_count => l_msg_count
1144: ,x_msg_data => l_msg_data