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 2005/10/19 20:30:17 hikubo noship $ */
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 26: from pay_jp_swot_numbers

22: )IS
23: --
24: cursor cur_row is
25: select rowidtochar(rowid)
26: from pay_jp_swot_numbers
27: where organization_id = x_organization_id
28: and district_code = x_district_code;
29: --
30: BEGIN

Line 32: insert into pay_jp_swot_numbers

28: and district_code = x_district_code;
29: --
30: BEGIN
31: --
32: insert into pay_jp_swot_numbers
33: (
34: organization_id,
35: district_code,
36: report_district_code,

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

68: --
69: -------------------------------------------------------------------------------
70: -- LOCK ROW
71: --
72: -- To lock row of PAY_JP_SWOT_NUMBERS from PAYJPSWN.fmx
73: --
74: -------------------------------------------------------------------------------
75: PROCEDURE lock_row
76: (

Line 101: pay_jp_swot_numbers

97: last_update_login,
98: created_by,
99: creation_date
100: from
101: pay_jp_swot_numbers
102: where
103: rowid = chartorowid(x_rowid)
104: for update of
105: organization_id,

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

174: --
175: -------------------------------------------------------------------------------
176: -- UPDATE ROW
177: --
178: -- To update row of PAY_JP_SWOT_NUMBERS from PAYJPSWN.fmx
179: --
180: -------------------------------------------------------------------------------
181: PROCEDURE update_row
182: (

Line 197: pay_jp_swot_numbers

193: )IS
194: BEGIN
195: --
196: update
197: pay_jp_swot_numbers
198: set
199: organization_id = x_organization_id,
200: district_code = x_district_code,
201: report_district_code = x_report_district_code,

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

216: --
217: --------------------------------------------------------------------------------
218: -- DELETE ROW
219: --
220: -- To delete row of PAY_JP_SWOT_NUMBERS from PAYJPSWN.fmx
221: --
222: -------------------------------------------------------------------------------
223: PROCEDURE delete_row(x_rowid in varchar2)IS
224: BEGIN

Line 226: delete from pay_jp_swot_numbers

222: -------------------------------------------------------------------------------
223: PROCEDURE delete_row(x_rowid in varchar2)IS
224: BEGIN
225: --
226: delete from pay_jp_swot_numbers
227: where rowid = chartorowid(x_rowid);
228: --
229: if (SQL%NOTFOUND) then
230: raise NO_DATA_FOUND;

Line 262: END PAY_JP_SWOT_NUMBERS_PKG;

258: end if;
259: --
260: END chk_swot_number;
261: --
262: END PAY_JP_SWOT_NUMBERS_PKG;