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_BCL_PRINT_PREVIEW_PVT dependencies on OKS_BCL_PR

Line 1: PACKAGE BODY OKS_BCL_PRINT_PREVIEW_PVT AS

1: PACKAGE BODY OKS_BCL_PRINT_PREVIEW_PVT AS
2: /* $Header: OKSBCLPB.pls 120.1 2005/10/03 07:17:57 upillai noship $ */
3: ---------------------------------------------------------------------------
4: -- PROCEDURE load_error_tbl
5: ---------------------------------------------------------------------------

Line 94: -- FUNCTION get_rec for: OKS_BCL_PR

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

Line 100: CURSOR oks_bcl_pr_pk_csr (p_id IN NUMBER) IS

96: FUNCTION get_rec (
97: p_bcl_pr_rec IN bcl_pr_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN
99: ) RETURN bcl_pr_rec_type IS
100: CURSOR oks_bcl_pr_pk_csr (p_id IN NUMBER) IS
101: SELECT
102: ID,
103: CLE_ID,
104: BTN_ID,

Line 135: FROM Oks_Bcl_Pr

131: ATTRIBUTE13,
132: ATTRIBUTE14,
133: ATTRIBUTE15,
134: SECURITY_GROUP_ID
135: FROM Oks_Bcl_Pr
136: WHERE oks_bcl_pr.id = p_id;
137: l_oks_bcl_pr_pk oks_bcl_pr_pk_csr%ROWTYPE;
138: l_bcl_pr_rec bcl_pr_rec_type;
139: BEGIN

Line 136: WHERE oks_bcl_pr.id = p_id;

132: ATTRIBUTE14,
133: ATTRIBUTE15,
134: SECURITY_GROUP_ID
135: FROM Oks_Bcl_Pr
136: WHERE oks_bcl_pr.id = p_id;
137: l_oks_bcl_pr_pk oks_bcl_pr_pk_csr%ROWTYPE;
138: l_bcl_pr_rec bcl_pr_rec_type;
139: BEGIN
140: x_no_data_found := TRUE;

Line 137: l_oks_bcl_pr_pk oks_bcl_pr_pk_csr%ROWTYPE;

133: ATTRIBUTE15,
134: SECURITY_GROUP_ID
135: FROM Oks_Bcl_Pr
136: WHERE oks_bcl_pr.id = p_id;
137: l_oks_bcl_pr_pk oks_bcl_pr_pk_csr%ROWTYPE;
138: l_bcl_pr_rec bcl_pr_rec_type;
139: BEGIN
140: x_no_data_found := TRUE;
141: -- Get current database values

Line 142: OPEN oks_bcl_pr_pk_csr (p_bcl_pr_rec.id);

138: l_bcl_pr_rec bcl_pr_rec_type;
139: BEGIN
140: x_no_data_found := TRUE;
141: -- Get current database values
142: OPEN oks_bcl_pr_pk_csr (p_bcl_pr_rec.id);
143: FETCH oks_bcl_pr_pk_csr INTO
144: l_bcl_pr_rec.id,
145: l_bcl_pr_rec.cle_id,
146: l_bcl_pr_rec.btn_id,

Line 143: FETCH oks_bcl_pr_pk_csr INTO

139: BEGIN
140: x_no_data_found := TRUE;
141: -- Get current database values
142: OPEN oks_bcl_pr_pk_csr (p_bcl_pr_rec.id);
143: FETCH oks_bcl_pr_pk_csr INTO
144: l_bcl_pr_rec.id,
145: l_bcl_pr_rec.cle_id,
146: l_bcl_pr_rec.btn_id,
147: l_bcl_pr_rec.date_billed_from,

Line 177: x_no_data_found := oks_bcl_pr_pk_csr%NOTFOUND;

173: l_bcl_pr_rec.attribute13,
174: l_bcl_pr_rec.attribute14,
175: l_bcl_pr_rec.attribute15,
176: l_bcl_pr_rec.security_group_id;
177: x_no_data_found := oks_bcl_pr_pk_csr%NOTFOUND;
178: CLOSE oks_bcl_pr_pk_csr;
179: RETURN(l_bcl_pr_rec);
180: END get_rec;
181:

Line 178: CLOSE oks_bcl_pr_pk_csr;

174: l_bcl_pr_rec.attribute14,
175: l_bcl_pr_rec.attribute15,
176: l_bcl_pr_rec.security_group_id;
177: x_no_data_found := oks_bcl_pr_pk_csr%NOTFOUND;
178: CLOSE oks_bcl_pr_pk_csr;
179: RETURN(l_bcl_pr_rec);
180: END get_rec;
181:
182: ------------------------------------------------------------------

Line 210: -- FUNCTION null_out_defaults for: OKS_BCL_PR

206: BEGIN
207: RETURN(get_rec(p_bcl_pr_rec, l_row_not_found));
208: END get_rec;
209: ---------------------------------------------------------------------------
210: -- FUNCTION null_out_defaults for: OKS_BCL_PR
211: ---------------------------------------------------------------------------
212: FUNCTION null_out_defaults (
213: p_bcl_pr_rec IN bcl_pr_rec_type
214: ) RETURN bcl_pr_rec_type IS

Line 335: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BCL_PR'

331: RAISE G_EXCEPTION_HALT_VALIDATION;
332: END IF;
333:
334: -- Verify the value fits the length of the column in the database
335: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BCL_PR'
336: ,p_col_name => 'id'
337: ,p_col_value => p_id
338: ,x_return_status => x_return_status);
339: -- verify that length is within allowed limits

Line 373: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BCL_PR'

369: RAISE G_EXCEPTION_HALT_VALIDATION;
370: END IF;
371:
372: -- Verify the value fits the length of the column in the database
373: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BCL_PR'
374: ,p_col_name => 'cle_id'
375: ,p_col_value => p_cle_id
376: ,x_return_status => x_return_status);
377: -- verify that length is within allowed limits

Line 411: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BCL_PR'

407: RAISE G_EXCEPTION_HALT_VALIDATION;
408: END IF;
409:
410: -- Verify the value fits the length of the column in the database
411: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BCL_PR'
412: ,p_col_name => 'date_billed_from'
413: ,p_col_value => p_date_billed_from
414: ,x_return_status => x_return_status);
415: -- verify that length is within allowed limits

Line 449: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BCL_PR'

445: RAISE G_EXCEPTION_HALT_VALIDATION;
446: END IF;
447:
448: -- Verify the value fits the length of the column in the database
449: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BCL_PR'
450: ,p_col_name => 'date_billed_to'
451: ,p_col_value => p_date_billed_to
452: ,x_return_status => x_return_status);
453: -- verify that length is within allowed limits

Line 487: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BCL_PR'

483: RAISE G_EXCEPTION_HALT_VALIDATION;
484: END IF;
485:
486: -- Verify the value fits the length of the column in the database
487: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BCL_PR'
488: ,p_col_name => 'sent_yn'
489: ,p_col_value => p_sent_yn
490: ,x_return_status => x_return_status);
491: -- verify that length is within allowed limits

Line 525: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BCL_PR'

521: RAISE G_EXCEPTION_HALT_VALIDATION;
522: END IF;
523:
524: -- Verify the value fits the length of the column in the database
525: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BCL_PR'
526: ,p_col_name => 'object_version_number'
527: ,p_col_value => p_object_version_number
528: ,x_return_status => x_return_status);
529: -- verify that length is within allowed limits

Line 550: -- Validate_Attributes for:OKS_BCL_PR --

546: ---------------------------------------------------------------------------
547: -- FUNCTION Validate_Attributes
548: ---------------------------------------------------------------------------
549: ----------------------------------------
550: -- Validate_Attributes for:OKS_BCL_PR --
551: ----------------------------------------
552: FUNCTION Validate_Attributes (
553: p_bcl_pr_rec IN bcl_pr_rec_type
554: ) RETURN VARCHAR2 IS

Line 559: OKC_UTIL.ADD_VIEW('OKS_BCL_PR', x_return_status);

555: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
556: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
557: BEGIN
558: -- Call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
559: OKC_UTIL.ADD_VIEW('OKS_BCL_PR', x_return_status);
560: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
561: l_return_status := x_return_status;
562: RAISE G_EXCEPTION_HALT_VALIDATION;
563: END IF;

Line 639: -- Validate Record for:OKS_BCL_PR --

635: ---------------------------------------------------------------------------
636: -- PROCEDURE Validate_Record
637: ---------------------------------------------------------------------------
638: ------------------------------------
639: -- Validate Record for:OKS_BCL_PR --
640: ------------------------------------
641: FUNCTION Validate_Record (
642: p_bcl_pr_rec IN bcl_pr_rec_type,
643: p_db_bcl_pr_rec IN bcl_pr_rec_type

Line 803: -- validate_row for:OKS_BCL_PR --

799: ---------------------------------------------------------------------------
800: -- PROCEDURE validate_row
801: ---------------------------------------------------------------------------
802: ---------------------------------
803: -- validate_row for:OKS_BCL_PR --
804: ---------------------------------
805: PROCEDURE validate_row(
806: p_api_version IN NUMBER,
807: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 878: -- PL/SQL TBL validate_row for:OKS_BCL_PR --

874: '_PVT'
875: );
876: END validate_row;
877: --------------------------------------------
878: -- PL/SQL TBL validate_row for:OKS_BCL_PR --
879: --------------------------------------------
880: PROCEDURE validate_row(
881: p_api_version IN NUMBER,
882: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 974: -- PL/SQL TBL validate_row for:OKS_BCL_PR --

970: );
971: END validate_row;
972:
973: --------------------------------------------
974: -- PL/SQL TBL validate_row for:OKS_BCL_PR --
975: --------------------------------------------
976: PROCEDURE validate_row(
977: p_api_version IN NUMBER,
978: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1039: -- insert_row for:OKS_BCL_PR --

1035: ---------------------------------------------------------------------------
1036: -- PROCEDURE insert_row
1037: ---------------------------------------------------------------------------
1038: -------------------------------
1039: -- insert_row for:OKS_BCL_PR --
1040: -------------------------------
1041: PROCEDURE insert_row(
1042: p_api_version IN NUMBER,
1043: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1056: -- Set_Attributes for:OKS_BCL_PR --

1052: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1053: l_bcl_pr_rec bcl_pr_rec_type := p_bcl_pr_rec;
1054: l_def_bcl_pr_rec bcl_pr_rec_type;
1055: -----------------------------------
1056: -- Set_Attributes for:OKS_BCL_PR --
1057: -----------------------------------
1058: FUNCTION Set_Attributes (
1059: p_bcl_pr_rec IN bcl_pr_rec_type,
1060: x_bcl_pr_rec OUT NOCOPY bcl_pr_rec_type

Line 1087: INSERT INTO OKS_BCL_PR(

1083: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1084: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1085: RAISE OKC_API.G_EXCEPTION_ERROR;
1086: END IF;
1087: INSERT INTO OKS_BCL_PR(
1088: id,
1089: cle_id,
1090: btn_id,
1091: date_billed_from,

Line 1195: -- lock_row for:OKS_BCL_PR --

1191: ---------------------------------------------------------------------------
1192: -- PROCEDURE lock_row
1193: ---------------------------------------------------------------------------
1194: -----------------------------
1195: -- lock_row for:OKS_BCL_PR --
1196: -----------------------------
1197: PROCEDURE lock_row(
1198: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1199: x_return_status OUT NOCOPY VARCHAR2,

Line 1208: FROM OKS_BCL_PR

1204: E_Resource_Busy EXCEPTION;
1205: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1206: CURSOR lock_csr (p_bcl_pr_rec IN bcl_pr_rec_type) IS
1207: SELECT OBJECT_VERSION_NUMBER
1208: FROM OKS_BCL_PR
1209: WHERE ID = p_bcl_pr_rec.id
1210: AND OBJECT_VERSION_NUMBER = p_bcl_pr_rec.object_version_number
1211: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1212:

Line 1215: FROM OKS_BCL_PR

1211: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1212:
1213: CURSOR lchk_csr (p_bcl_pr_rec IN bcl_pr_rec_type) IS
1214: SELECT OBJECT_VERSION_NUMBER
1215: FROM OKS_BCL_PR
1216: WHERE ID = p_bcl_pr_rec.id;
1217: l_api_version CONSTANT NUMBER := 1;
1218: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1219: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1220: l_object_version_number OKS_BCL_PR.OBJECT_VERSION_NUMBER%TYPE;

1216: WHERE ID = p_bcl_pr_rec.id;
1217: l_api_version CONSTANT NUMBER := 1;
1218: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1219: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1220: l_object_version_number OKS_BCL_PR.OBJECT_VERSION_NUMBER%TYPE;
1221: lc_object_version_number OKS_BCL_PR.OBJECT_VERSION_NUMBER%TYPE;
1222: l_row_notfound BOOLEAN := FALSE;
1223: lc_row_notfound BOOLEAN := FALSE;
1224: BEGIN

Line 1221: lc_object_version_number OKS_BCL_PR.OBJECT_VERSION_NUMBER%TYPE;

1217: l_api_version CONSTANT NUMBER := 1;
1218: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1219: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1220: l_object_version_number OKS_BCL_PR.OBJECT_VERSION_NUMBER%TYPE;
1221: lc_object_version_number OKS_BCL_PR.OBJECT_VERSION_NUMBER%TYPE;
1222: l_row_notfound BOOLEAN := FALSE;
1223: lc_row_notfound BOOLEAN := FALSE;
1224: BEGIN
1225: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1302: -- lock_row for: OKS_BCL_PR --

1298: '_PVT'
1299: );
1300: END lock_row;
1301: ------------------------------
1302: -- lock_row for: OKS_BCL_PR --
1303: ------------------------------
1304: PROCEDURE lock_row(
1305: p_api_version IN NUMBER,
1306: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1542: -- update_row for:OKS_BCL_PR --

1538: ---------------------------------------------------------------------------
1539: -- PROCEDURE update_row
1540: ---------------------------------------------------------------------------
1541: -------------------------------
1542: -- update_row for:OKS_BCL_PR --
1543: -------------------------------
1544: PROCEDURE update_row(
1545: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1546: x_return_status OUT NOCOPY VARCHAR2,

Line 1709: -- Set_Attributes for:OKS_BCL_PR --

1705: END IF;
1706: RETURN(l_return_status);
1707: END populate_new_record;
1708: -----------------------------------
1709: -- Set_Attributes for:OKS_BCL_PR --
1710: -----------------------------------
1711: FUNCTION Set_Attributes (
1712: p_bcl_pr_rec IN bcl_pr_rec_type,
1713: x_bcl_pr_rec OUT NOCOPY bcl_pr_rec_type

Line 1747: UPDATE OKS_BCL_PR

1743: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1744: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1745: RAISE OKC_API.G_EXCEPTION_ERROR;
1746: END IF;
1747: UPDATE OKS_BCL_PR
1748: SET CLE_ID = l_def_bcl_pr_rec.cle_id,
1749: BTN_ID = l_def_bcl_pr_rec.btn_id,
1750: DATE_BILLED_FROM = l_def_bcl_pr_rec.date_billed_from,
1751: DATE_BILLED_TO = l_def_bcl_pr_rec.date_billed_to,

Line 1818: -- update_row for:OKS_BCL_PR --

1814: '_PVT'
1815: );
1816: END update_row;
1817: -------------------------------
1818: -- update_row for:OKS_BCL_PR --
1819: -------------------------------
1820: PROCEDURE update_row(
1821: p_api_version IN NUMBER,
1822: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1997: -- Set_Attributes for:OKS_BCL_PR --

1993: END IF;
1994: RETURN(l_return_status);
1995: END populate_new_record;
1996: -----------------------------------
1997: -- Set_Attributes for:OKS_BCL_PR --
1998: -----------------------------------
1999: FUNCTION Set_Attributes (
2000: p_bcl_pr_rec IN bcl_pr_rec_type,
2001: x_bcl_pr_rec OUT NOCOPY bcl_pr_rec_type

Line 2289: -- delete_row for:OKS_BCL_PR --

2285: ---------------------------------------------------------------------------
2286: -- PROCEDURE delete_row
2287: ---------------------------------------------------------------------------
2288: -------------------------------
2289: -- delete_row for:OKS_BCL_PR --
2290: -------------------------------
2291: PROCEDURE delete_row(
2292: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2293: x_return_status OUT NOCOPY VARCHAR2,

Line 2314: DELETE FROM OKS_BCL_PR

2310: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2311: RAISE OKC_API.G_EXCEPTION_ERROR;
2312: END IF;
2313:
2314: DELETE FROM OKS_BCL_PR
2315: WHERE ID = p_bcl_pr_rec.id;
2316:
2317: x_return_status := l_return_status;
2318: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2352: -- delete_row for:OKS_BCL_PR --

2348: '_PVT'
2349: );
2350: END delete_row;
2351: -------------------------------
2352: -- delete_row for:OKS_BCL_PR --
2353: -------------------------------
2354: PROCEDURE delete_row(
2355: p_api_version IN NUMBER,
2356: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2433: -- PL/SQL TBL delete_row for:OKS_BCL_PR --

2429: '_PVT'
2430: );
2431: END delete_row;
2432: ------------------------------------------
2433: -- PL/SQL TBL delete_row for:OKS_BCL_PR --
2434: ------------------------------------------
2435: PROCEDURE delete_row(
2436: p_api_version IN NUMBER,
2437: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2529: -- PL/SQL TBL delete_row for:OKS_BCL_PR --

2525: );
2526: END delete_row;
2527:
2528: ------------------------------------------
2529: -- PL/SQL TBL delete_row for:OKS_BCL_PR --
2530: ------------------------------------------
2531: PROCEDURE delete_row(
2532: p_api_version IN NUMBER,
2533: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2590: END OKS_BCL_PRINT_PREVIEW_PVT;

2586: '_PVT'
2587: );
2588: END delete_row;
2589:
2590: END OKS_BCL_PRINT_PREVIEW_PVT;