eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMA_VALID_GRP dependencies on SY_ORGN_MST

Line 203: --| on sy_orgn_mst |

199: --| Validates Organization Code |
200: --| |
201: --| DESCRIPTION |
202: --| This generic function validates that the Organization Code exists |
203: --| on sy_orgn_mst |
204: --| |
205: --| PARAMETERS |
206: --| p_orgn_code IN VARCHAR2 - Organization Code |
207: --| |

Line 217: (p_orgn_code IN sy_orgn_mst.orgn_code%TYPE

213: --| |
214: --+==========================================================================+
215: -- Func end of comments
216: FUNCTION Validate_Orgn_Code
217: (p_orgn_code IN sy_orgn_mst.orgn_code%TYPE
218: )
219: RETURN BOOLEAN
220: IS
221: l_orgn_code VARCHAR2(4);

Line 222: CURSOR sy_orgn_mst_c1 IS

218: )
219: RETURN BOOLEAN
220: IS
221: l_orgn_code VARCHAR2(4);
222: CURSOR sy_orgn_mst_c1 IS
223: SELECT
224: orgn_code
225: FROM
226: sy_orgn_mst

Line 226: sy_orgn_mst

222: CURSOR sy_orgn_mst_c1 IS
223: SELECT
224: orgn_code
225: FROM
226: sy_orgn_mst
227: WHERE
228: orgn_code = p_orgn_code
229: AND delete_mark = 0;
230:

Line 232: OPEN sy_orgn_mst_c1;

228: orgn_code = p_orgn_code
229: AND delete_mark = 0;
230:
231: BEGIN
232: OPEN sy_orgn_mst_c1;
233: FETCH sy_orgn_mst_c1 INTO l_orgn_code;
234: IF (sy_orgn_mst_c1%NOTFOUND)
235: THEN
236: CLOSE sy_orgn_mst_c1;

Line 233: FETCH sy_orgn_mst_c1 INTO l_orgn_code;

229: AND delete_mark = 0;
230:
231: BEGIN
232: OPEN sy_orgn_mst_c1;
233: FETCH sy_orgn_mst_c1 INTO l_orgn_code;
234: IF (sy_orgn_mst_c1%NOTFOUND)
235: THEN
236: CLOSE sy_orgn_mst_c1;
237: RETURN FALSE;

Line 234: IF (sy_orgn_mst_c1%NOTFOUND)

230:
231: BEGIN
232: OPEN sy_orgn_mst_c1;
233: FETCH sy_orgn_mst_c1 INTO l_orgn_code;
234: IF (sy_orgn_mst_c1%NOTFOUND)
235: THEN
236: CLOSE sy_orgn_mst_c1;
237: RETURN FALSE;
238: ELSE

Line 236: CLOSE sy_orgn_mst_c1;

232: OPEN sy_orgn_mst_c1;
233: FETCH sy_orgn_mst_c1 INTO l_orgn_code;
234: IF (sy_orgn_mst_c1%NOTFOUND)
235: THEN
236: CLOSE sy_orgn_mst_c1;
237: RETURN FALSE;
238: ELSE
239: CLOSE sy_orgn_mst_c1;
240: RETURN TRUE;

Line 239: CLOSE sy_orgn_mst_c1;

235: THEN
236: CLOSE sy_orgn_mst_c1;
237: RETURN FALSE;
238: ELSE
239: CLOSE sy_orgn_mst_c1;
240: RETURN TRUE;
241: END IF;
242:
243: EXCEPTION

Line 259: --| on sy_orgn_mst and is defined as a company |

255: --| Validates Company Code |
256: --| |
257: --| DESCRIPTION |
258: --| This generic function validates that the Organization Code exists |
259: --| on sy_orgn_mst and is defined as a company |
260: --| |
261: --| PARAMETERS |
262: --| p_co_code IN VARCHAR2 - Company Code |
263: --| |

Line 273: (p_co_code IN sy_orgn_mst.orgn_code%TYPE

269: --| |
270: --+==========================================================================+
271: -- Func end of comments
272: FUNCTION Validate_Co_Code
273: (p_co_code IN sy_orgn_mst.orgn_code%TYPE
274: )
275: RETURN BOOLEAN
276: IS
277: l_co_code VARCHAR2(4);

Line 278: CURSOR sy_orgn_mst_c1 IS

274: )
275: RETURN BOOLEAN
276: IS
277: l_co_code VARCHAR2(4);
278: CURSOR sy_orgn_mst_c1 IS
279: SELECT
280: co_code
281: FROM
282: sy_orgn_mst

Line 282: sy_orgn_mst

278: CURSOR sy_orgn_mst_c1 IS
279: SELECT
280: co_code
281: FROM
282: sy_orgn_mst
283: WHERE
284: orgn_code = p_co_code
285: AND co_code = p_co_code
286: AND delete_mark = 0;

Line 289: OPEN sy_orgn_mst_c1;

285: AND co_code = p_co_code
286: AND delete_mark = 0;
287:
288: BEGIN
289: OPEN sy_orgn_mst_c1;
290: FETCH sy_orgn_mst_c1 INTO l_co_code;
291: IF (sy_orgn_mst_c1%NOTFOUND)
292: THEN
293: CLOSE sy_orgn_mst_c1;

Line 290: FETCH sy_orgn_mst_c1 INTO l_co_code;

286: AND delete_mark = 0;
287:
288: BEGIN
289: OPEN sy_orgn_mst_c1;
290: FETCH sy_orgn_mst_c1 INTO l_co_code;
291: IF (sy_orgn_mst_c1%NOTFOUND)
292: THEN
293: CLOSE sy_orgn_mst_c1;
294: RETURN FALSE;

Line 291: IF (sy_orgn_mst_c1%NOTFOUND)

287:
288: BEGIN
289: OPEN sy_orgn_mst_c1;
290: FETCH sy_orgn_mst_c1 INTO l_co_code;
291: IF (sy_orgn_mst_c1%NOTFOUND)
292: THEN
293: CLOSE sy_orgn_mst_c1;
294: RETURN FALSE;
295: ELSE

Line 293: CLOSE sy_orgn_mst_c1;

289: OPEN sy_orgn_mst_c1;
290: FETCH sy_orgn_mst_c1 INTO l_co_code;
291: IF (sy_orgn_mst_c1%NOTFOUND)
292: THEN
293: CLOSE sy_orgn_mst_c1;
294: RETURN FALSE;
295: ELSE
296: CLOSE sy_orgn_mst_c1;
297: RETURN TRUE;

Line 296: CLOSE sy_orgn_mst_c1;

292: THEN
293: CLOSE sy_orgn_mst_c1;
294: RETURN FALSE;
295: ELSE
296: CLOSE sy_orgn_mst_c1;
297: RETURN TRUE;
298: END IF;
299:
300: EXCEPTION

Line 331: ( p_orgn_code IN sy_orgn_mst.orgn_code%TYPE

327: --| |
328: --+==========================================================================+
329: -- Func end of comments
330: FUNCTION Validate_Orgn_For_Company
331: ( p_orgn_code IN sy_orgn_mst.orgn_code%TYPE
332: , p_co_code IN sy_orgn_mst.orgn_code%TYPE
333: )
334: RETURN BOOLEAN
335: IS

Line 332: , p_co_code IN sy_orgn_mst.orgn_code%TYPE

328: --+==========================================================================+
329: -- Func end of comments
330: FUNCTION Validate_Orgn_For_Company
331: ( p_orgn_code IN sy_orgn_mst.orgn_code%TYPE
332: , p_co_code IN sy_orgn_mst.orgn_code%TYPE
333: )
334: RETURN BOOLEAN
335: IS
336: l_co_code VARCHAR2(4);

Line 337: CURSOR sy_orgn_mst_c1 IS

333: )
334: RETURN BOOLEAN
335: IS
336: l_co_code VARCHAR2(4);
337: CURSOR sy_orgn_mst_c1 IS
338: SELECT
339: co_code
340: FROM
341: sy_orgn_mst

Line 341: sy_orgn_mst

337: CURSOR sy_orgn_mst_c1 IS
338: SELECT
339: co_code
340: FROM
341: sy_orgn_mst
342: WHERE
343: orgn_code = p_orgn_code
344: AND co_code = p_co_code
345: AND delete_mark = 0;

Line 348: OPEN sy_orgn_mst_c1;

344: AND co_code = p_co_code
345: AND delete_mark = 0;
346:
347: BEGIN
348: OPEN sy_orgn_mst_c1;
349: FETCH sy_orgn_mst_c1 INTO l_co_code;
350: IF (sy_orgn_mst_c1%NOTFOUND)
351: THEN
352: CLOSE sy_orgn_mst_c1;

Line 349: FETCH sy_orgn_mst_c1 INTO l_co_code;

345: AND delete_mark = 0;
346:
347: BEGIN
348: OPEN sy_orgn_mst_c1;
349: FETCH sy_orgn_mst_c1 INTO l_co_code;
350: IF (sy_orgn_mst_c1%NOTFOUND)
351: THEN
352: CLOSE sy_orgn_mst_c1;
353: RETURN FALSE;

Line 350: IF (sy_orgn_mst_c1%NOTFOUND)

346:
347: BEGIN
348: OPEN sy_orgn_mst_c1;
349: FETCH sy_orgn_mst_c1 INTO l_co_code;
350: IF (sy_orgn_mst_c1%NOTFOUND)
351: THEN
352: CLOSE sy_orgn_mst_c1;
353: RETURN FALSE;
354: ELSE

Line 352: CLOSE sy_orgn_mst_c1;

348: OPEN sy_orgn_mst_c1;
349: FETCH sy_orgn_mst_c1 INTO l_co_code;
350: IF (sy_orgn_mst_c1%NOTFOUND)
351: THEN
352: CLOSE sy_orgn_mst_c1;
353: RETURN FALSE;
354: ELSE
355: CLOSE sy_orgn_mst_c1;
356: RETURN TRUE;

Line 355: CLOSE sy_orgn_mst_c1;

351: THEN
352: CLOSE sy_orgn_mst_c1;
353: RETURN FALSE;
354: ELSE
355: CLOSE sy_orgn_mst_c1;
356: RETURN TRUE;
357: END IF;
358:
359: EXCEPTION

Line 396: , p_orgn_code IN sy_orgn_mst.orgn_code%TYPE

392: -- Func end of comments
393: FUNCTION Validate_Doc_No
394: ( p_doc_type IN sy_docs_seq.doc_type%TYPE
395: , p_doc_no IN VARCHAR2
396: , p_orgn_code IN sy_orgn_mst.orgn_code%TYPE
397: )
398: RETURN BOOLEAN
399: IS
400: l_assignment_type sy_docs_seq.assignment_type%TYPE;