APPS.RLM_RLMDPPSR_XMLP_PKG dependencies on RLM_DEMAND_EXCEPTIONS

Line 44: DELETE FROM RLM_DEMAND_EXCEPTIONS

40: ,'Failed in AFTER REPORT TRIGGER')*/NULL;
41: RETURN (FALSE);
42: END;
43: IF (P_REQUEST_ID IS NOT NULL) THEN
44: DELETE FROM RLM_DEMAND_EXCEPTIONS
45: WHERE REQUEST_ID = P_REQUEST_ID
46: AND PURGE_STATUS is not null;
47: COMMIT;
48: END IF;

Line 112: RLM_DEMAND_EXCEPTIONS

108: SELECT
109: count(distinct SCHEDULE_HEADER_ID)
110: INTO V_COUNT1
111: FROM
112: RLM_DEMAND_EXCEPTIONS
113: WHERE REQUEST_ID = P_REQUEST_ID
114: AND ( MESSAGE_NAME like '%SUCCESS%'
115: OR MESSAGE_NAME like '%PURGABLE%'
116: OR MESSAGE_NAME IS NULL );

Line 121: RLM_DEMAND_EXCEPTIONS

117: SELECT
118: count(distinct SCHEDULE_HEADER_ID)
119: INTO V_COUNT2
120: FROM
121: RLM_DEMAND_EXCEPTIONS
122: WHERE REQUEST_ID = P_REQUEST_ID
123: AND MESSAGE_NAME NOT like '%SUCCESS%'
124: AND MESSAGE_NAME NOT like '%PURGABLE%'
125: AND MESSAGE_NAME IS NOT NULL;

Line 141: RLM_DEMAND_EXCEPTIONS

137: SELECT
138: count(distinct SCHEDULE_HEADER_ID)
139: INTO V_COUNT
140: FROM
141: RLM_DEMAND_EXCEPTIONS
142: WHERE REQUEST_ID = P_REQUEST_ID
143: AND ( MESSAGE_NAME like '%SUCCESS%'
144: OR MESSAGE_NAME like '%PURGABLE%'
145: OR MESSAGE_NAME IS NULL );

Line 160: RLM_DEMAND_EXCEPTIONS

156: SELECT
157: count(distinct SCHEDULE_HEADER_ID)
158: INTO V_COUNT
159: FROM
160: RLM_DEMAND_EXCEPTIONS
161: WHERE REQUEST_ID = P_REQUEST_ID
162: AND MESSAGE_NAME NOT like '%SUCCESS%'
163: AND MESSAGE_NAME NOT like '%PURGABLE%'
164: AND MESSAGE_NAME IS NOT NULL;

Line 181: RLM_DEMAND_EXCEPTIONS

177: DISTINCT
178: SCHEDULE_REFERENCE_NUM
179: INTO V_REF
180: FROM
181: RLM_DEMAND_EXCEPTIONS
182: WHERE REQUEST_ID = P_REQUEST_ID;
183: RETURN V_REF;
184: ELSE
185: RETURN NULL;

Line 380: SELECT COUNT(*) INTO V_COUNT FROM RLM_DEMAND_EXCEPTIONS

376:
377:
378: BEGIN
379:
380: SELECT COUNT(*) INTO V_COUNT FROM RLM_DEMAND_EXCEPTIONS
381: WHERE REQUEST_ID = P_REQUEST_ID;
382:
383: IF(V_COUNT > 0) THEN
384: RETURN ('Y');