260: ,V_CERTIFICATE_NUMBER IN NUMBER) RETURN BOOLEAN IS
261: PRAGMA AUTONOMOUS_TRANSACTION;
262: BEGIN
263: UPDATE
264: JL_AR_AP_AWT_CERTIF jaac
265: SET
266: STATUS = DECODE(STATUS
267: ,'NOT PRINTED'
268: ,'PRINTED'
443: /*SRW.MESSAGE('1'
444: ,'Making Condition Where in After Form Trigger:' || P_SELECTED_SUPPLIERS)*/NULL;
445: END IF;
446: IF P_REPORTING_LEVEL = '2000' THEN
447: LP_JL_AR_AP_AWT_CERTIF_ALL_WH := ' AND jaac.legal_entity_id = ' || P_REPORTING_CONTEXT;
448: ELSE
449: FND_MO_REPORTING_API.INITIALIZE(P_REPORTING_LEVEL
450: ,P_REPORTING_CONTEXT
451: ,'AUTO');
448: ELSE
449: FND_MO_REPORTING_API.INITIALIZE(P_REPORTING_LEVEL
450: ,P_REPORTING_CONTEXT
451: ,'AUTO');
452: LP_JL_AR_AP_AWT_CERTIF_ALL_WH := FND_MO_REPORTING_API.GET_PREDICATE('jaac'
453: ,NULL
454: ,P_REPORTING_CONTEXT);
455: END IF;
456: /*SRW.MESSAGE('1'
453: ,NULL
454: ,P_REPORTING_CONTEXT);
455: END IF;
456: /*SRW.MESSAGE('1'
457: ,'Condition Where in After Form Trigger:' || LP_JL_AR_AP_AWT_CERTIF_ALL_WH)*/NULL;
458: RETURN (TRUE);
459: END AFTERPFORM;
460:
461: FUNCTION CF_1FORMULA0039(AWT_TYPE_CODE IN VARCHAR2