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.OKS_BTN_PRINT_PREVIEW_PVT dependencies on OKS_BTN_PR

Line 1: PACKAGE BODY OKS_BTN_PRINT_PREVIEW_PVT AS

1: PACKAGE BODY OKS_BTN_PRINT_PREVIEW_PVT AS
2: /* $Header: OKSBTNPB.pls 120.1 2005/10/03 07:19:27 upillai noship $ */
3: ---------------------------------------------------------------------------
4: -- PROCEDURE load_error_tbl
5: ---------------------------------------------------------------------------

Line 94: -- FUNCTION get_rec for: OKS_BTN_PR

90: null;
91: END api_copy;
92:
93: ---------------------------------------------------------------------------
94: -- FUNCTION get_rec for: OKS_BTN_PR
95: ---------------------------------------------------------------------------
96: FUNCTION get_rec (
97: p_btn_pr_rec IN btn_pr_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN

Line 100: CURSOR oks_btn_pr_pk_csr (p_id IN NUMBER) IS

96: FUNCTION get_rec (
97: p_btn_pr_rec IN btn_pr_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN
99: ) RETURN btn_pr_rec_type IS
100: CURSOR oks_btn_pr_pk_csr (p_id IN NUMBER) IS
101: SELECT
102: ID,
103: CURRENCY_CODE,
104: OBJECT_VERSION_NUMBER,

Line 115: FROM Oks_Btn_Pr

111: TRX_AMOUNT,
112: TRX_CLASS,
113: LAST_UPDATE_LOGIN,
114: SECURITY_GROUP_ID
115: FROM Oks_Btn_Pr
116: WHERE oks_btn_pr.id = p_id;
117: l_oks_btn_pr_pk oks_btn_pr_pk_csr%ROWTYPE;
118: l_btn_pr_rec btn_pr_rec_type;
119: BEGIN

Line 116: WHERE oks_btn_pr.id = p_id;

112: TRX_CLASS,
113: LAST_UPDATE_LOGIN,
114: SECURITY_GROUP_ID
115: FROM Oks_Btn_Pr
116: WHERE oks_btn_pr.id = p_id;
117: l_oks_btn_pr_pk oks_btn_pr_pk_csr%ROWTYPE;
118: l_btn_pr_rec btn_pr_rec_type;
119: BEGIN
120: x_no_data_found := TRUE;

Line 117: l_oks_btn_pr_pk oks_btn_pr_pk_csr%ROWTYPE;

113: LAST_UPDATE_LOGIN,
114: SECURITY_GROUP_ID
115: FROM Oks_Btn_Pr
116: WHERE oks_btn_pr.id = p_id;
117: l_oks_btn_pr_pk oks_btn_pr_pk_csr%ROWTYPE;
118: l_btn_pr_rec btn_pr_rec_type;
119: BEGIN
120: x_no_data_found := TRUE;
121: -- Get current database values

Line 122: OPEN oks_btn_pr_pk_csr (p_btn_pr_rec.id);

118: l_btn_pr_rec btn_pr_rec_type;
119: BEGIN
120: x_no_data_found := TRUE;
121: -- Get current database values
122: OPEN oks_btn_pr_pk_csr (p_btn_pr_rec.id);
123: FETCH oks_btn_pr_pk_csr INTO
124: l_btn_pr_rec.id,
125: l_btn_pr_rec.currency_code,
126: l_btn_pr_rec.object_version_number,

Line 123: FETCH oks_btn_pr_pk_csr INTO

119: BEGIN
120: x_no_data_found := TRUE;
121: -- Get current database values
122: OPEN oks_btn_pr_pk_csr (p_btn_pr_rec.id);
123: FETCH oks_btn_pr_pk_csr INTO
124: l_btn_pr_rec.id,
125: l_btn_pr_rec.currency_code,
126: l_btn_pr_rec.object_version_number,
127: l_btn_pr_rec.created_by,

Line 137: x_no_data_found := oks_btn_pr_pk_csr%NOTFOUND;

133: l_btn_pr_rec.trx_amount,
134: l_btn_pr_rec.trx_class,
135: l_btn_pr_rec.last_update_login,
136: l_btn_pr_rec.security_group_id;
137: x_no_data_found := oks_btn_pr_pk_csr%NOTFOUND;
138: CLOSE oks_btn_pr_pk_csr;
139: RETURN(l_btn_pr_rec);
140: END get_rec;
141:

Line 138: CLOSE oks_btn_pr_pk_csr;

134: l_btn_pr_rec.trx_class,
135: l_btn_pr_rec.last_update_login,
136: l_btn_pr_rec.security_group_id;
137: x_no_data_found := oks_btn_pr_pk_csr%NOTFOUND;
138: CLOSE oks_btn_pr_pk_csr;
139: RETURN(l_btn_pr_rec);
140: END get_rec;
141:
142: ------------------------------------------------------------------

Line 170: -- FUNCTION null_out_defaults for: OKS_BTN_PR

166: BEGIN
167: RETURN(get_rec(p_btn_pr_rec, l_row_not_found));
168: END get_rec;
169: ---------------------------------------------------------------------------
170: -- FUNCTION null_out_defaults for: OKS_BTN_PR
171: ---------------------------------------------------------------------------
172: FUNCTION null_out_defaults (
173: p_btn_pr_rec IN btn_pr_rec_type
174: ) RETURN btn_pr_rec_type IS

Line 235: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BTN_PR'

231: RAISE G_EXCEPTION_HALT_VALIDATION;
232: END IF;
233:
234: -- Verify the value fits the length of the column in the database
235: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BTN_PR'
236: ,p_col_name => 'id'
237: ,p_col_value => p_id
238: ,x_return_status => x_return_status);
239: -- verify that length is within allowed limits

Line 273: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BTN_PR'

269: RAISE G_EXCEPTION_HALT_VALIDATION;
270: END IF;
271:
272: -- Verify the value fits the length of the column in the database
273: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BTN_PR'
274: ,p_col_name => 'currency_code'
275: ,p_col_value => p_currency_code
276: ,x_return_status => x_return_status);
277: -- verify that length is within allowed limits

Line 311: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BTN_PR'

307: RAISE G_EXCEPTION_HALT_VALIDATION;
308: END IF;
309:
310: -- Verify the value fits the length of the column in the database
311: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BTN_PR'
312: ,p_col_name => 'object_version_number'
313: ,p_col_value => p_object_version_number
314: ,x_return_status => x_return_status);
315: -- verify that length is within allowed limits

Line 336: -- Validate_Attributes for:OKS_BTN_PR --

332: ---------------------------------------------------------------------------
333: -- FUNCTION Validate_Attributes
334: ---------------------------------------------------------------------------
335: ----------------------------------------
336: -- Validate_Attributes for:OKS_BTN_PR --
337: ----------------------------------------
338: FUNCTION Validate_Attributes (
339: p_btn_pr_rec IN btn_pr_rec_type
340: ) RETURN VARCHAR2 IS

Line 345: OKC_UTIL.ADD_VIEW('OKS_BTN_PR', x_return_status);

341: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
342: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
343: BEGIN
344: -- Call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
345: OKC_UTIL.ADD_VIEW('OKS_BTN_PR', x_return_status);
346: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
347: l_return_status := x_return_status;
348: RAISE G_EXCEPTION_HALT_VALIDATION;
349: END IF;

Line 398: -- Validate Record for:OKS_BTN_PR --

394: ---------------------------------------------------------------------------
395: -- PROCEDURE Validate_Record
396: ---------------------------------------------------------------------------
397: ------------------------------------
398: -- Validate Record for:OKS_BTN_PR --
399: ------------------------------------
400: FUNCTION Validate_Record (
401: p_btn_pr_rec IN btn_pr_rec_type,
402: p_db_btn_pr_rec IN btn_pr_rec_type

Line 503: -- validate_row for:OKS_BTN_PR --

499: ---------------------------------------------------------------------------
500: -- PROCEDURE validate_row
501: ---------------------------------------------------------------------------
502: ---------------------------------
503: -- validate_row for:OKS_BTN_PR --
504: ---------------------------------
505: PROCEDURE validate_row(
506: p_api_version IN NUMBER,
507: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 579: -- PL/SQL TBL validate_row for:OKS_BTN_PR --

575: '_PVT'
576: );
577: END validate_row;
578: --------------------------------------------
579: -- PL/SQL TBL validate_row for:OKS_BTN_PR --
580: --------------------------------------------
581: PROCEDURE validate_row(
582: p_api_version IN NUMBER,
583: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 675: -- PL/SQL TBL validate_row for:OKS_BTN_PR --

671: );
672: END validate_row;
673:
674: --------------------------------------------
675: -- PL/SQL TBL validate_row for:OKS_BTN_PR --
676: --------------------------------------------
677: PROCEDURE validate_row(
678: p_api_version IN NUMBER,
679: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 740: -- insert_row for:OKS_BTN_PR --

736: ---------------------------------------------------------------------------
737: -- PROCEDURE insert_row
738: ---------------------------------------------------------------------------
739: -------------------------------
740: -- insert_row for:OKS_BTN_PR --
741: -------------------------------
742: PROCEDURE insert_row(
743: p_api_version IN NUMBER,
744: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 757: -- Set_Attributes for:OKS_BTN_PR --

753: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
754: l_btn_pr_rec btn_pr_rec_type := p_btn_pr_rec;
755: l_def_btn_pr_rec btn_pr_rec_type;
756: -----------------------------------
757: -- Set_Attributes for:OKS_BTN_PR --
758: -----------------------------------
759: FUNCTION Set_Attributes (
760: p_btn_pr_rec IN btn_pr_rec_type,
761: x_btn_pr_rec OUT NOCOPY btn_pr_rec_type

Line 788: INSERT INTO OKS_BTN_PR(

784: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
785: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
786: RAISE OKC_API.G_EXCEPTION_ERROR;
787: END IF;
788: INSERT INTO OKS_BTN_PR(
789: id,
790: currency_code,
791: object_version_number,
792: created_by,

Line 856: -- lock_row for:OKS_BTN_PR --

852: ---------------------------------------------------------------------------
853: -- PROCEDURE lock_row
854: ---------------------------------------------------------------------------
855: -----------------------------
856: -- lock_row for:OKS_BTN_PR --
857: -----------------------------
858: PROCEDURE lock_row(
859: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
860: x_return_status OUT NOCOPY VARCHAR2,

Line 869: FROM OKS_BTN_PR

865: E_Resource_Busy EXCEPTION;
866: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
867: CURSOR lock_csr (p_btn_pr_rec IN btn_pr_rec_type) IS
868: SELECT OBJECT_VERSION_NUMBER
869: FROM OKS_BTN_PR
870: WHERE ID = p_btn_pr_rec.id
871: AND OBJECT_VERSION_NUMBER = p_btn_pr_rec.object_version_number
872: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
873:

Line 876: FROM OKS_BTN_PR

872: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
873:
874: CURSOR lchk_csr (p_btn_pr_rec IN btn_pr_rec_type) IS
875: SELECT OBJECT_VERSION_NUMBER
876: FROM OKS_BTN_PR
877: WHERE ID = p_btn_pr_rec.id;
878: l_api_version CONSTANT NUMBER := 1;
879: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
880: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 881: l_object_version_number OKS_BTN_PR.OBJECT_VERSION_NUMBER%TYPE;

877: WHERE ID = p_btn_pr_rec.id;
878: l_api_version CONSTANT NUMBER := 1;
879: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
880: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
881: l_object_version_number OKS_BTN_PR.OBJECT_VERSION_NUMBER%TYPE;
882: lc_object_version_number OKS_BTN_PR.OBJECT_VERSION_NUMBER%TYPE;
883: l_row_notfound BOOLEAN := FALSE;
884: lc_row_notfound BOOLEAN := FALSE;
885: BEGIN

Line 882: lc_object_version_number OKS_BTN_PR.OBJECT_VERSION_NUMBER%TYPE;

878: l_api_version CONSTANT NUMBER := 1;
879: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
880: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
881: l_object_version_number OKS_BTN_PR.OBJECT_VERSION_NUMBER%TYPE;
882: lc_object_version_number OKS_BTN_PR.OBJECT_VERSION_NUMBER%TYPE;
883: l_row_notfound BOOLEAN := FALSE;
884: lc_row_notfound BOOLEAN := FALSE;
885: BEGIN
886: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 963: -- lock_row for: OKS_BTN_PR --

959: '_PVT'
960: );
961: END lock_row;
962: ------------------------------
963: -- lock_row for: OKS_BTN_PR --
964: ------------------------------
965: PROCEDURE lock_row(
966: p_api_version IN NUMBER,
967: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1203: -- update_row for:OKS_BTN_PR --

1199: ---------------------------------------------------------------------------
1200: -- PROCEDURE update_row
1201: ---------------------------------------------------------------------------
1202: -------------------------------
1203: -- update_row for:OKS_BTN_PR --
1204: -------------------------------
1205: PROCEDURE update_row(
1206: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1207: x_return_status OUT NOCOPY VARCHAR2,

Line 1290: -- Set_Attributes for:OKS_BTN_PR --

1286: END IF;
1287: RETURN(l_return_status);
1288: END populate_new_record;
1289: -----------------------------------
1290: -- Set_Attributes for:OKS_BTN_PR --
1291: -----------------------------------
1292: FUNCTION Set_Attributes (
1293: p_btn_pr_rec IN btn_pr_rec_type,
1294: x_btn_pr_rec OUT NOCOPY btn_pr_rec_type

Line 1328: UPDATE OKS_BTN_PR

1324: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1325: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1326: RAISE OKC_API.G_EXCEPTION_ERROR;
1327: END IF;
1328: UPDATE OKS_BTN_PR
1329: SET CURRENCY_CODE = l_def_btn_pr_rec.currency_code,
1330: OBJECT_VERSION_NUMBER = l_def_btn_pr_rec.object_version_number,
1331: CREATED_BY = l_def_btn_pr_rec.created_by,
1332: CREATION_DATE = l_def_btn_pr_rec.creation_date,

Line 1379: -- update_row for:OKS_BTN_PR --

1375: '_PVT'
1376: );
1377: END update_row;
1378: -------------------------------
1379: -- update_row for:OKS_BTN_PR --
1380: -------------------------------
1381: PROCEDURE update_row(
1382: p_api_version IN NUMBER,
1383: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1478: -- Set_Attributes for:OKS_BTN_PR --

1474: END IF;
1475: RETURN(l_return_status);
1476: END populate_new_record;
1477: -----------------------------------
1478: -- Set_Attributes for:OKS_BTN_PR --
1479: -----------------------------------
1480: FUNCTION Set_Attributes (
1481: p_btn_pr_rec IN btn_pr_rec_type,
1482: x_btn_pr_rec OUT NOCOPY btn_pr_rec_type

Line 1770: -- delete_row for:OKS_BTN_PR --

1766: ---------------------------------------------------------------------------
1767: -- PROCEDURE delete_row
1768: ---------------------------------------------------------------------------
1769: -------------------------------
1770: -- delete_row for:OKS_BTN_PR --
1771: -------------------------------
1772: PROCEDURE delete_row(
1773: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1774: x_return_status OUT NOCOPY VARCHAR2,

Line 1795: DELETE FROM OKS_BTN_PR

1791: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1792: RAISE OKC_API.G_EXCEPTION_ERROR;
1793: END IF;
1794:
1795: DELETE FROM OKS_BTN_PR
1796: WHERE ID = p_btn_pr_rec.id;
1797:
1798: x_return_status := l_return_status;
1799: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1833: -- delete_row for:OKS_BTN_PR --

1829: '_PVT'
1830: );
1831: END delete_row;
1832: -------------------------------
1833: -- delete_row for:OKS_BTN_PR --
1834: -------------------------------
1835: PROCEDURE delete_row(
1836: p_api_version IN NUMBER,
1837: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1914: -- PL/SQL TBL delete_row for:OKS_BTN_PR --

1910: '_PVT'
1911: );
1912: END delete_row;
1913: ------------------------------------------
1914: -- PL/SQL TBL delete_row for:OKS_BTN_PR --
1915: ------------------------------------------
1916: PROCEDURE delete_row(
1917: p_api_version IN NUMBER,
1918: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2010: -- PL/SQL TBL delete_row for:OKS_BTN_PR --

2006: );
2007: END delete_row;
2008:
2009: ------------------------------------------
2010: -- PL/SQL TBL delete_row for:OKS_BTN_PR --
2011: ------------------------------------------
2012: PROCEDURE delete_row(
2013: p_api_version IN NUMBER,
2014: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2071: END OKS_BTN_PRINT_PREVIEW_PVT;

2067: '_PVT'
2068: );
2069: END delete_row;
2070:
2071: END OKS_BTN_PRINT_PREVIEW_PVT;