147: SELECT
148: USERENV('LANG')
149: INTO P_USER_LANG
150: FROM
151: DUAL;
152: END;
153: RETURN (TRUE);
154: END AFTERPFORM;
155:
243: ,INSTR(USERENV('LANGUAGE')
244: ,'_') - 1)
245: INTO SESSION_LANGUAGE
246: FROM
247: DUAL;
248: SELECT
249: NLS_LANGUAGE
250: INTO BASE_LANGUAGE
251: FROM
491: C_GL_CONV_RATE * NVL(SVC_EXTENDED_PRICE
492: ,0)
493: INTO FC_SVC_EXTENDED_PRICE
494: FROM
495: DUAL;
496: RETURN (ROUND(NVL(FC_SVC_EXTENDED_PRICE
497: ,0)
498: ,C_PRECISION));
499: ELSE
515: SELECT
516: C_GL_CONV_RATE * SVC_SELLING_PRICE
517: INTO FC_SVC_SELLING_PRICE
518: FROM
519: DUAL;
520: RETURN (FC_SVC_SELLING_PRICE);
521: ELSE
522: RETURN (SVC_SELLING_PRICE);
523: END IF;
606: ,MO_GLOBAL.GET_CURRENT_ORG_ID)
607: ,0)
608: INTO V_MASTER_ORG
609: FROM
610: DUAL;
611: RETURN V_MASTER_ORG;
612: END C_MASTER_ORGFORMULA;
613:
614: FUNCTION CF_1FORMULA(S_TAX_TOTAL IN NUMBER