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.JMF_GTA_TRX_HEADERS_ALL_PKG dependencies on JMF_GTA_TRX_HEADERS_ALL

Line 1: PACKAGE BODY JMF_GTA_TRX_HEADERS_ALL_PKG AS

1: PACKAGE BODY JMF_GTA_TRX_HEADERS_ALL_PKG AS
2: --$Header: JMFUGHAB.pls 120.2.12010000.2 2008/11/17 14:37:38 dwang ship $
3: --+=======================================================================+
4: --| Copyright (c) 1998 Oracle Corporation |
5: --| Redwood Shores, CA, USA |

Line 13: --| table JMF_GTA_TRX_HEADERS_ALL,these handlers |

9: --| JMFUGHAB.pls |
10: --| |
11: --| DESCRIPTION |
12: --| This package provides table handers for |
13: --| table JMF_GTA_TRX_HEADERS_ALL,these handlers |
14: --| will be called by 'Golden Tax Workbench' form and 'Golden Tax |
15: --| invoie import' program to operate data in table |
16: --| JMF_GTA_TRX_HEADERS_ALL |
17: --| |

Line 16: --| JMF_GTA_TRX_HEADERS_ALL |

12: --| This package provides table handers for |
13: --| table JMF_GTA_TRX_HEADERS_ALL,these handlers |
14: --| will be called by 'Golden Tax Workbench' form and 'Golden Tax |
15: --| invoie import' program to operate data in table |
16: --| JMF_GTA_TRX_HEADERS_ALL |
17: --| |
18: --| PROCEDURE LIST |
19: --| PROCEDURE Insert_Row |
20: --| PROCEDURE Update_Row |

Line 45: -- table JMF_GTA_TRX_HEADERS_ALL to create a new record

41: --
42: -- DESCRIPTION:
43: --
44: -- This procedure is to insert data that are passed in by parameters into
45: -- table JMF_GTA_TRX_HEADERS_ALL to create a new record
46: --
47: -- PARAMETERS:
48: -- In: p_ra_gl_date GL date
49: -- p_ra_gl_period GL Period

Line 236: jmf_gta_trx_headers_all

232: CURSOR C IS
233: SELECT
234: ROWID
235: FROM
236: jmf_gta_trx_headers_all
237: WHERE
238: gta_trx_header_id=p_gta_trx_header_id;
239: BEGIN
240:

Line 253: --Insert data into table JMF_GTA_TRX_HEADERS_ALL

249:
250: END IF; --( l_proc_level >= l_dbg_level)
251:
252:
253: --Insert data into table JMF_GTA_TRX_HEADERS_ALL
254: INSERT INTO jmf_gta_trx_headers_all(
255: ra_gl_date
256: ,ra_gl_period
257: ,set_of_books_id

Line 254: INSERT INTO jmf_gta_trx_headers_all(

250: END IF; --( l_proc_level >= l_dbg_level)
251:
252:
253: --Insert data into table JMF_GTA_TRX_HEADERS_ALL
254: INSERT INTO jmf_gta_trx_headers_all(
255: ra_gl_date
256: ,ra_gl_period
257: ,set_of_books_id
258: ,bill_to_customer_id

Line 439: -- This procedure is used to update data in table JMF_GTA_TRX_HEADERS_ALL

435: -- Update_Row Public
436: --
437: -- DESCRIPTION:
438: --
439: -- This procedure is used to update data in table JMF_GTA_TRX_HEADERS_ALL
440: -- according to parameters passed in
441: --
442: -- PARAMETERS:
443: -- In: p_ra_gl_date GL date

Line 640: --Update data on table JMF_GTA_TRX_HEADERS_ALL

636: );
637:
638: END IF; --( l_proc_level >= l_dbg_level)
639:
640: --Update data on table JMF_GTA_TRX_HEADERS_ALL
641: UPDATE jmf_gta_trx_headers_all
642: SET
643: ra_gl_date = p_ra_gl_date
644: ,ra_gl_period = p_ra_gl_period

Line 641: UPDATE jmf_gta_trx_headers_all

637:
638: END IF; --( l_proc_level >= l_dbg_level)
639:
640: --Update data on table JMF_GTA_TRX_HEADERS_ALL
641: UPDATE jmf_gta_trx_headers_all
642: SET
643: ra_gl_date = p_ra_gl_date
644: ,ra_gl_period = p_ra_gl_period
645: ,set_of_books_id = p_set_of_books_id

Line 750: -- JMF_GTA_TRX_HEADERS_ALL

746: --
747: -- DESCRIPTION:
748: --
749: -- This procedure is used to update implement lock on row level on table
750: -- JMF_GTA_TRX_HEADERS_ALL
751: --
752: -- PARAMETERS:
753: -- In: p_ra_gl_date GL date
754: -- p_ra_gl_period GL Period

Line 942: jmf_gta_trx_headers_all

938: CURSOR c IS
939: SELECT
940: *
941: FROM
942: jmf_gta_trx_headers_all
943: WHERE ROWID=p_row_id
944: FOR UPDATE OF gta_trx_header_id NOWAIT;
945:
946: recinfo c%ROWTYPE;

Line 1584: -- JMF_GTA_TRX_HEADERS_ALL

1580: --
1581: -- DESCRIPTION:
1582: --
1583: -- This procedure is used to delete record from table
1584: -- JMF_GTA_TRX_HEADERS_ALL
1585: --
1586: -- PARAMETERS:
1587: -- In:
1588: --

Line 1620: --Delete row from table JMF_GTA_TRX_HEADERS_ALL

1616: );
1617:
1618: END IF; --( l_proc_level >= l_dbg_level)
1619:
1620: --Delete row from table JMF_GTA_TRX_HEADERS_ALL
1621: DELETE
1622: FROM
1623: jmf_gta_trx_headers_all
1624: WHERE rowid = p_rowid;

Line 1623: jmf_gta_trx_headers_all

1619:
1620: --Delete row from table JMF_GTA_TRX_HEADERS_ALL
1621: DELETE
1622: FROM
1623: jmf_gta_trx_headers_all
1624: WHERE rowid = p_rowid;
1625:
1626: --In case of delete failed,raise error
1627: IF (SQL%NOTFOUND)

Line 1653: -- from table JMF_GTA_TRX_HEADERS_ALL

1649: --
1650: -- DESCRIPTION:
1651: --
1652: -- This procedure is used to retrieve record by parameter p_header
1653: -- from table JMF_GTA_TRX_HEADERS_ALL
1654: --
1655: -- PARAMETERS:
1656: -- In: p_header_id Identifier of GTA invoice header
1657: --

Line 1659: -- table JMF_GTA_TRX_HEADERS_ALL

1655: -- PARAMETERS:
1656: -- In: p_header_id Identifier of GTA invoice header
1657: --
1658: -- Out: x_trx_header_rec record to store a row fetched from
1659: -- table JMF_GTA_TRX_HEADERS_ALL
1660: --
1661: --
1662: -- DESIGN REFERENCES:
1663: -- GTA-Txt-Interface-TD.doc

Line 1694: --Retrive data from JMF_GTA_TRX_HEADERS_ALL and store them into PL/SQL record

1690: );
1691:
1692: END IF; --( l_proc_level >= l_dbg_level)
1693:
1694: --Retrive data from JMF_GTA_TRX_HEADERS_ALL and store them into PL/SQL record
1695: SELECT
1696: ra_gl_date
1697: ,ra_gl_period
1698: ,set_of_books_id

Line 1846: jmf_gta_trx_headers_all

1842: ,x_trx_header_rec.last_updated_by
1843: ,x_trx_header_rec.last_update_login
1844: ,x_trx_header_rec.invoice_type --added by subba for R12.1
1845: FROM
1846: jmf_gta_trx_headers_all
1847: WHERE gta_trx_header_id=p_header_id;
1848:
1849: --log for debug
1850: IF( l_proc_level >= l_dbg_level)

Line 1862: END jmf_gta_trx_headers_all_pkg;

1858: END IF; --( l_proc_level >= l_dbg_level)
1859:
1860: END query_row;
1861:
1862: END jmf_gta_trx_headers_all_pkg;