DBA Data[Home] [Help]

APPS.JL_JLARPCWT_XMLP_PKG dependencies on JL_AR_AP_AWT_CERTIF

Line 264: JL_AR_AP_AWT_CERTIF jaac

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'

Line 447: LP_JL_AR_AP_AWT_CERTIF_ALL_WH := ' AND jaac.legal_entity_id = ' || P_REPORTING_CONTEXT;

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');

Line 452: LP_JL_AR_AP_AWT_CERTIF_ALL_WH := FND_MO_REPORTING_API.GET_PREDICATE('jaac'

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'

Line 457: ,'Condition Where in After Form Trigger:' || LP_JL_AR_AP_AWT_CERTIF_ALL_WH)*/NULL;

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