DBA Data[Home] [Help]

APPS.PO_UDA_PUB dependencies on PO_TBL_VARCHAR4000

Line 115: -- PO_TBL_VARCHAR4000 : The values of the UDA attributes specified in a table

111: -- p_attr_grp_pk_tbl : IF Null would get all the appropriate values else would get one appropriate value in the table
112: -- p_attr_grp_pk_tbl refers to the attribute group unique keys for a multi row AG, in the sequence of the corresponding attributes
113: --
114: -- RETURN
115: -- PO_TBL_VARCHAR4000 : The values of the UDA attributes specified in a table
116: ------------------------------------------------------------------------------------------
117:
118: function get_multi_attr_value (
119: p_template_id IN NUMBER,

Line 130: p_attr_grp_pk_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL,

126: p_attr_grp_id IN NUMBER,
127: p_attr_grp_int_name IN VARCHAR2,
128: p_attr_id IN NUMBER,
129: p_attr_int_name IN VARCHAR2,
130: p_attr_grp_pk_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL,
131: p_mode IN VARCHAR2 DEFAULT 'INTERNAL_VALUE'
132: ) RETURN PO_TBL_VARCHAR4000;
133:
134:

Line 132: ) RETURN PO_TBL_VARCHAR4000;

128: p_attr_id IN NUMBER,
129: p_attr_int_name IN VARCHAR2,
130: p_attr_grp_pk_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL,
131: p_mode IN VARCHAR2 DEFAULT 'INTERNAL_VALUE'
132: ) RETURN PO_TBL_VARCHAR4000;
133:
134:
135: ------------------------------------------------------------------------------------------
136: -- Procedure: This procedure is used to get the sepecific UDA address attribute values

Line 186: p_attr_grp_pk_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL,

182: p_attr_grp_int_name IN VARCHAR2 DEFAULT NULL,
183: p_attr_id IN NUMBER DEFAULT NULL,
184: p_attr_int_name IN VARCHAR2 DEFAULT NULL,
185: p_mode IN VARCHAR2 DEFAULT 'INTERNAL_VALUE',
186: p_attr_grp_pk_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL,
187: x_multi_row_code OUT NOCOPY VARCHAR2,
188: x_single_attr_value OUT NOCOPY VARCHAR2,
189: x_multi_attr_value OUT NOCOPY PO_TBL_VARCHAR4000,
190: x_return_status OUT NOCOPY VARCHAR2,

Line 189: x_multi_attr_value OUT NOCOPY PO_TBL_VARCHAR4000,

185: p_mode IN VARCHAR2 DEFAULT 'INTERNAL_VALUE',
186: p_attr_grp_pk_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL,
187: x_multi_row_code OUT NOCOPY VARCHAR2,
188: x_single_attr_value OUT NOCOPY VARCHAR2,
189: x_multi_attr_value OUT NOCOPY PO_TBL_VARCHAR4000,
190: x_return_status OUT NOCOPY VARCHAR2,
191: x_msg_data OUT NOCOPY VARCHAR2
192: );
193: