[Home] [Help]
71: -- UDA Related Changes
72: x_database_view_name VARCHAR2(50);
73: l_select_cols VARCHAR2(1000) := 'C_EXT_ATTR39';
74:
75: CURSOR col_list(x_addr_group_name EGO_ATTRS_V.attr_group_name%TYPE)
76: IS
77: SELECT attr.database_column
78: FROM ego_attrs_v attr
79: WHERE attr.attr_group_name = x_addr_group_name
74:
75: CURSOR col_list(x_addr_group_name EGO_ATTRS_V.attr_group_name%TYPE)
76: IS
77: SELECT attr.database_column
78: FROM ego_attrs_v attr
79: WHERE attr.attr_group_name = x_addr_group_name
80: AND attr.attr_group_type = 'PO_REQ_HEADER_EXT_ATTRS'
81: AND attr.display_code <> 'H'
82: AND read_only_flag = 'N';
852: x_database_column := xmldom.getNodeName(node1);
853:
854: SELECT attr_display_name
855: INTO x_attr_display_name
856: FROM ego_attrs_v
857: WHERE attr_group_type = 'PO_REQ_HEADER_EXT_ATTRS'
858: AND attr_group_name = g_address_group_name
859: AND database_column = x_database_column;
860:
7832:
7833:
7834: SELECT attr_display_name
7835: INTO x_attr_disp_name
7836: FROM ego_attrs_v
7837: WHERE p_node_name = attr_group_name||PO_UDA_TEMPLATES_UTIL.g_delimiter||attr_name
7838: AND ATTR_GROUP_TYPE = 'PO_UDA_DUMMY_EXT_ATTRS'
7839: AND application_id = 201;
7840:
7913: l_attr_group_Type,
7914: l_attr_grp_name,
7915: l_attr_id,
7916: l_application_id
7917: FROM ego_attrs_v
7918: WHERE p_node_name = attr_group_name||PO_UDA_TEMPLATES_UTIL.g_delimiter||attr_name
7919: AND ATTR_GROUP_TYPE = 'PO_UDA_DUMMY_EXT_ATTRS'
7920: AND application_id = 201;
7921:
7977: attr.application_id
7978: INTO l_attr_id,
7979: l_attr_name,
7980: l_application_id
7981: FROM ego_attrs_v attr
7982: WHERE attr.attr_group_name = 'addresses'
7983: AND attr.attr_group_type = 'PO_REQ_HEADER_EXT_ATTRS'
7984: AND attr.database_column = p_node_name
7985: AND attr.display_code <> 'H'