DBA Data[Home] [Help]

APPS.PO_UDA_PUB dependencies on PO_TBL_VARCHAR4000

Line 34: p_attr_grp_pk_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL,

30: p_attr_grp_int_name IN VARCHAR2 DEFAULT NULL,
31: p_attr_id IN NUMBER DEFAULT NULL,
32: p_attr_int_name IN VARCHAR2 DEFAULT NULL,
33: p_mode IN VARCHAR2 DEFAULT 'INTERNAL_VALUE',
34: p_attr_grp_pk_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL,
35: x_multi_row_code OUT NOCOPY VARCHAR2,
36: x_single_attr_value OUT NOCOPY VARCHAR2,
37: x_multi_attr_value OUT NOCOPY PO_TBL_VARCHAR4000,
38: x_return_status OUT NOCOPY VARCHAR2,

Line 37: x_multi_attr_value OUT NOCOPY PO_TBL_VARCHAR4000,

33: p_mode IN VARCHAR2 DEFAULT 'INTERNAL_VALUE',
34: p_attr_grp_pk_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL,
35: x_multi_row_code OUT NOCOPY VARCHAR2,
36: x_single_attr_value OUT NOCOPY VARCHAR2,
37: x_multi_attr_value OUT NOCOPY PO_TBL_VARCHAR4000,
38: x_return_status OUT NOCOPY VARCHAR2,
39: x_msg_data OUT NOCOPY VARCHAR2
40: )
41: is

Line 848: p_attr_grp_pk_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL,

844: p_attr_grp_id IN NUMBER,
845: p_attr_grp_int_name IN VARCHAR2,
846: p_attr_id IN NUMBER,
847: p_attr_int_name IN VARCHAR2,
848: p_attr_grp_pk_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL,
849: p_mode IN VARCHAR2 DEFAULT 'INTERNAL_VALUE'
850: ) RETURN PO_TBL_VARCHAR4000
851: IS
852:

Line 850: ) RETURN PO_TBL_VARCHAR4000

846: p_attr_id IN NUMBER,
847: p_attr_int_name IN VARCHAR2,
848: p_attr_grp_pk_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL,
849: p_mode IN VARCHAR2 DEFAULT 'INTERNAL_VALUE'
850: ) RETURN PO_TBL_VARCHAR4000
851: IS
852:
853: d_api_name CONSTANT VARCHAR2(30) := 'get_multi_attr_value';
854: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name;

Line 859: l_multi_attr_value PO_TBL_VARCHAR4000;

855: d_progress NUMBER;
856:
857: l_multi_row_code VARCHAR2(3);
858: l_single_attr_value VARCHAR2(4000);
859: l_multi_attr_value PO_TBL_VARCHAR4000;
860: l_return_status VARCHAR2(3);
861: l_msg_data VARCHAR2(200);
862: l_attr_grp_pk_tbl PO_TBL_VARCHAR4000;
863:

Line 862: l_attr_grp_pk_tbl PO_TBL_VARCHAR4000;

858: l_single_attr_value VARCHAR2(4000);
859: l_multi_attr_value PO_TBL_VARCHAR4000;
860: l_return_status VARCHAR2(3);
861: l_msg_data VARCHAR2(200);
862: l_attr_grp_pk_tbl PO_TBL_VARCHAR4000;
863:
864: BEGIN
865:
866: PO_UDA_PUB.GET_ATTR_VALUE

Line 918: l_multi_attr_value PO_TBL_VARCHAR4000;

914: d_progress NUMBER;
915:
916: l_multi_row_code VARCHAR2(3);
917: l_single_attr_value VARCHAR2(4000);
918: l_multi_attr_value PO_TBL_VARCHAR4000;
919: l_return_status VARCHAR2(3);
920: l_msg_data VARCHAR2(200);
921:
922: BEGIN