APPS.ICX_CAT_R12_DATA_EXCEP_RPT_PVT dependencies on ICX_CAT_ATTRIBUTES_TL

Line 988: key icx_cat_attributes_tl.KEY%TYPE,

984: **/
985: PROCEDURE populate_namevalue_xmltag(p_category_id IN NUMBER)
986: IS
987: TYPE descriptors_rec_type IS RECORD(
988: key icx_cat_attributes_tl.KEY%TYPE,
989: stored_in_table icx_cat_attributes_tl.STORED_IN_TABLE%TYPE,
990: stored_in_column icx_cat_attributes_tl.STORED_IN_COLUMN%TYPE);
991:
992: TYPE descriptors_tbl_type IS TABLE OF descriptors_rec_type;

Line 989: stored_in_table icx_cat_attributes_tl.STORED_IN_TABLE%TYPE,

985: PROCEDURE populate_namevalue_xmltag(p_category_id IN NUMBER)
986: IS
987: TYPE descriptors_rec_type IS RECORD(
988: key icx_cat_attributes_tl.KEY%TYPE,
989: stored_in_table icx_cat_attributes_tl.STORED_IN_TABLE%TYPE,
990: stored_in_column icx_cat_attributes_tl.STORED_IN_COLUMN%TYPE);
991:
992: TYPE descriptors_tbl_type IS TABLE OF descriptors_rec_type;
993: l_descriptors_tbl descriptors_tbl_type;

Line 990: stored_in_column icx_cat_attributes_tl.STORED_IN_COLUMN%TYPE);

986: IS
987: TYPE descriptors_rec_type IS RECORD(
988: key icx_cat_attributes_tl.KEY%TYPE,
989: stored_in_table icx_cat_attributes_tl.STORED_IN_TABLE%TYPE,
990: stored_in_column icx_cat_attributes_tl.STORED_IN_COLUMN%TYPE);
991:
992: TYPE descriptors_tbl_type IS TABLE OF descriptors_rec_type;
993: l_descriptors_tbl descriptors_tbl_type;
994:

Line 1021: FROM icx_cat_attributes_tl

1017: 'PO_ATTRIBUTE_VALUES_TLP', 'poavti')
1018: stored_in_table,
1019: stored_in_column
1020: BULK COLLECT INTO l_descriptors_tbl
1021: FROM icx_cat_attributes_tl
1022: WHERE rt_category_id = p_category_id
1023: AND stored_in_Table is not null
1024: AND stored_in_column is not null;
1025: