[Home] [Help]
246: function R_Daily_Item_Usage(doc_type_1 varchar2,reason_code_1 varchar2) return varchar2 is
247: return_flag varchar2(4);
248: begin
249: if doc_type_1 in ('ADJI','ADJR') then
250: select 'TRUE' into return_flag from dual
251: where reason_code_1 in (select reason_code from sy_reas_cds where flow_type in (1,-1));
252: end if;
253: return('true');
254: exception
257: end;
258: function F_Doc_Type_InCP(doc_type_1 varchar2,reason_code_1 varchar2,line_id_1 number,doc_id_1 number,quantity_1 number) return varchar2 is
259: return_flag varchar2(4);
260: begin
261: select 'TRUE' into return_flag from dual
262: where doc_type_1 in ('PORD','RECV','CREI','CRER','FPO','REQ')
263: or (doc_type_1 in ('TRNI','TRNR')and quantity_1 > 0)
264: or (doc_type_1 ='PROD' and line_id_1 in (select line_id from pm_matl_dtl
265: where line_type in (1,2) and batch_id = doc_id_1 and line_id=line_id_1))
272: function F_Doc_Type_OutCP(doc_type_1 varchar2,reason_code_1 varchar2,line_id_1 number,doc_id_1 number,quantity_1 number) return varchar2 is
273: return_flag varchar2(4);
274: return_flag1 varchar2(4);
275: begin
276: select 'TRUE' into return_flag from dual
277: where doc_type_1 in ('OPCR','OPSO','OPSP')
278: or (doc_type_1 in ('TRNI','TRNR','MTRI')and quantity_1 < 0)
279: or (doc_type_1 ='PROD' and line_id_1 in (select line_id from pm_matl_dtl
280: where line_type =-1 and batch_id = doc_id_1 and line_id=line_id_1))