[Home] [Help]
15: l_text_code NUMBER DEFAULT NULL;
16:
17: BEGIN
18:
19: FOR cur_lab_tmp IN (SELECT * FROM lm_ltyp_mst l
20: where not exists ( select 1 from sy_orgn_mst
21: where orgn_code = l.lab_type)) LOOP
22: Begin
23:
86: source_id ,
87: target_id ,
88: message_text )
89: SELECT GMD_REQUEST_ID_S.nextval,
90: 'LM_LTYP_MST',
91: 'SY_ORGN_MST',
92: Cur_lab_tmp.lab_type,
93: Cur_lab_tmp.lab_type,
94: error_msg