[Home] [Help]
4388: L_RETURN_STATUS VARCHAR2(1);
4389: L_MSG_DATA VARCHAR2(2000);
4390: L_TELEPHONE_NUMBER VARCHAR2(70);
4391:
4392: L_LABEL_CODE GR_LABELS_B.label_code%TYPE;
4393: L_ADDR_LINE SY_ADDR_MST.addr1%TYPE;
4394: L_DEFAULT_ORGN SY_ORGN_MST.orgn_code%TYPE;
4395:
4396: X_MSG_DATA VARCHAR2(2000);
4498: IS
4499: SELECT lab.data_position_indicator,
4500: lat.label_description
4501: FROM gr_labels_tl lat,
4502: gr_labels_b lab
4503: WHERE lab.label_code = l_label_code
4504: AND lat.label_code = lab.label_code
4505: AND lat.language = p_language_code;
4506: LocalLabelRecord c_get_label_info%ROWTYPE;