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.PAY_JP_SWOT_NUMBERS_PKG dependencies on PAY_JP_SWOT_NUMBERS

Line 1: PACKAGE BODY PAY_JP_SWOT_NUMBERS_PKG AS

1: PACKAGE BODY PAY_JP_SWOT_NUMBERS_PKG AS
2: /* $Header: pyjppswn.pkb 120.1.12010000.3 2009/06/24 06:49:56 keyazawa ship $ */
3: --
4: -------------------------------------------------------------------------------
5: -- INSERT ROW

Line 7: -- To insert a row into PAY_JP_SWOT_NUMBERS from PAYJPSWN.fmx

3: --
4: -------------------------------------------------------------------------------
5: -- INSERT ROW
6: --
7: -- To insert a row into PAY_JP_SWOT_NUMBERS from PAYJPSWN.fmx
8: --
9: -------------------------------------------------------------------------------
10: PROCEDURE insert_row
11: (

Line 30: from pay_jp_swot_numbers

26: )IS
27: --
28: cursor cur_row is
29: select rowidtochar(rowid)
30: from pay_jp_swot_numbers
31: where organization_id = x_organization_id
32: and district_code = x_district_code;
33: --
34: BEGIN

Line 36: insert into pay_jp_swot_numbers

32: and district_code = x_district_code;
33: --
34: BEGIN
35: --
36: insert into pay_jp_swot_numbers
37: (
38: organization_id,
39: district_code,
40: report_district_code,

Line 84: -- To lock row of PAY_JP_SWOT_NUMBERS from PAYJPSWN.fmx

80: --
81: -------------------------------------------------------------------------------
82: -- LOCK ROW
83: --
84: -- To lock row of PAY_JP_SWOT_NUMBERS from PAYJPSWN.fmx
85: --
86: -------------------------------------------------------------------------------
87: PROCEDURE lock_row
88: (

Line 121: pay_jp_swot_numbers

117: last_update_login,
118: created_by,
119: creation_date
120: from
121: pay_jp_swot_numbers
122: where
123: rowid = chartorowid(x_rowid)
124: for update of
125: organization_id,

Line 202: -- To update row of PAY_JP_SWOT_NUMBERS from PAYJPSWN.fmx

198: --
199: -------------------------------------------------------------------------------
200: -- UPDATE ROW
201: --
202: -- To update row of PAY_JP_SWOT_NUMBERS from PAYJPSWN.fmx
203: --
204: -------------------------------------------------------------------------------
205: PROCEDURE update_row
206: (

Line 225: pay_jp_swot_numbers

221: )IS
222: BEGIN
223: --
224: update
225: pay_jp_swot_numbers
226: set
227: organization_id = x_organization_id,
228: district_code = x_district_code,
229: report_district_code = x_report_district_code,

Line 252: -- To delete row of PAY_JP_SWOT_NUMBERS from PAYJPSWN.fmx

248: --
249: --------------------------------------------------------------------------------
250: -- DELETE ROW
251: --
252: -- To delete row of PAY_JP_SWOT_NUMBERS from PAYJPSWN.fmx
253: --
254: -------------------------------------------------------------------------------
255: PROCEDURE delete_row(x_rowid in varchar2)IS
256: BEGIN

Line 258: delete from pay_jp_swot_numbers

254: -------------------------------------------------------------------------------
255: PROCEDURE delete_row(x_rowid in varchar2)IS
256: BEGIN
257: --
258: delete from pay_jp_swot_numbers
259: where rowid = chartorowid(x_rowid);
260: --
261: if (SQL%NOTFOUND) then
262: raise NO_DATA_FOUND;

Line 324: END PAY_JP_SWOT_NUMBERS_PKG;

320: --
321: return l_result;
322: end chk_output_file_name;
323: --
324: END PAY_JP_SWOT_NUMBERS_PKG;