APPS.JL_CO_GL_MG_MEDIA_PKG dependencies on JL_CO_GL_MG_HEADERS_S

Line 634: Check for JL_CO_GL_MG_HEADERS.STATUS = 'Y'. If any row

630: fnd_file.put_line(fnd_file.log, '----------------------------------------');
631:
632:
633: /******************************************************
634: Check for JL_CO_GL_MG_HEADERS.STATUS = 'Y'. If any row
635: exists with status of 'Y' then give a message to USER
636: and exist the procedure
637: ******************************************************/
638:

Line 753: SELECT jl_co_gl_mg_headers_s.NEXTVAL

749: BEGIN
750:
751: BEGIN
752:
753: SELECT jl_co_gl_mg_headers_s.NEXTVAL
754: INTO x_mg_header_id
755: FROM SYS.DUAL;
756:
757: END;

Line 1122: Check for JL_CO_GL_MG_HEADERS.STATUS = 'Y'. If any row

1118: put_line( fnd_file.log, fnd_message.get);
1119: fnd_file.put_line(fnd_file.log, '----------------------------------------');
1120:
1121: /******************************************************
1122: Check for JL_CO_GL_MG_HEADERS.STATUS = 'Y'. If any row
1123: exists with status of 'Y' then give a message to USER
1124: and exist the procedure
1125: ******************************************************/
1126:

Line 1501: Check for JL_CO_GL_MG_HEADERS.STATUS = 'Y'. If any row

1497: fnd_file.put_line(fnd_file.log, '----------------------------------------');
1498:
1499:
1500: /******************************************************
1501: Check for JL_CO_GL_MG_HEADERS.STATUS = 'Y'. If any row
1502: exists with status of 'Y' then give a message to USER
1503: and exist the procedure
1504: ******************************************************/
1505:

Line 1775: Update the jl_co_gl_mg_headers.status to 'Y'

1771: fnd_message.set_name('JL', 'JL_CO_GL_MG_CLOSE_REGISTER');
1772: put_line( fnd_file.log, fnd_message.get);
1773:
1774: /********************************************
1775: Update the jl_co_gl_mg_headers.status to 'Y'
1776: for final generation is done for DIAN
1777: ********************************************/
1778:
1779: UPDATE jl_co_gl_mg_headers