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_BSD_PVT dependencies on OKS_BILL_SUB_LINE_DTLS

Line 36: -- FUNCTION get_rec for: OKS_BILL_SUB_LINE_DTLS

32: null;
33: END api_copy;
34:
35: ---------------------------------------------------------------------------
36: -- FUNCTION get_rec for: OKS_BILL_SUB_LINE_DTLS
37: ---------------------------------------------------------------------------
38: FUNCTION get_rec (
39: p_bsd_rec IN bsd_rec_type,
40: x_no_data_found OUT NOCOPY BOOLEAN

Line 86: FROM Oks_Bill_Sub_Line_Dtls

82: ATTRIBUTE12,
83: ATTRIBUTE13,
84: ATTRIBUTE14,
85: ATTRIBUTE15
86: FROM Oks_Bill_Sub_Line_Dtls
87: WHERE oks_bill_sub_line_dtls.id = p_id;
88: l_bsd_pk bsd_pk_csr%ROWTYPE;
89: l_bsd_rec bsd_rec_type;
90: BEGIN

Line 87: WHERE oks_bill_sub_line_dtls.id = p_id;

83: ATTRIBUTE13,
84: ATTRIBUTE14,
85: ATTRIBUTE15
86: FROM Oks_Bill_Sub_Line_Dtls
87: WHERE oks_bill_sub_line_dtls.id = p_id;
88: l_bsd_pk bsd_pk_csr%ROWTYPE;
89: l_bsd_rec bsd_rec_type;
90: BEGIN
91: x_no_data_found := TRUE;

Line 3235: -- insert_row for:OKS_BILL_SUB_LINE_DTLS --

3231: ---------------------------------------------------------------------------
3232: -- PROCEDURE insert_row
3233: ---------------------------------------------------------------------------
3234: -------------------------------------------
3235: -- insert_row for:OKS_BILL_SUB_LINE_DTLS --
3236: -------------------------------------------
3237: PROCEDURE insert_row(
3238: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3239: x_return_status OUT NOCOPY VARCHAR2,

Line 3251: -- Set_Attributes for:OKS_BILL_SUB_LINE_DTLS --

3247: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3248: l_bsd_rec bsd_rec_type := p_bsd_rec;
3249: l_def_bsd_rec bsd_rec_type;
3250: -----------------------------------------------
3251: -- Set_Attributes for:OKS_BILL_SUB_LINE_DTLS --
3252: -----------------------------------------------
3253: FUNCTION Set_Attributes (
3254: p_bsd_rec IN bsd_rec_type,
3255: x_bsd_rec OUT NOCOPY bsd_rec_type

Line 3282: INSERT INTO OKS_BILL_SUB_LINE_DTLS(

3278: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3279: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3280: RAISE OKC_API.G_EXCEPTION_ERROR;
3281: END IF;
3282: INSERT INTO OKS_BILL_SUB_LINE_DTLS(
3283: id,
3284: bsl_id,
3285: bsl_id_averaged,
3286: bsd_id,

Line 3618: -- lock_row for:OKS_BILL_SUB_LINE_DTLS --

3614: ---------------------------------------------------------------------------
3615: -- PROCEDURE lock_row
3616: ---------------------------------------------------------------------------
3617: -----------------------------------------
3618: -- lock_row for:OKS_BILL_SUB_LINE_DTLS --
3619: -----------------------------------------
3620: PROCEDURE lock_row(
3621: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3622: x_return_status OUT NOCOPY VARCHAR2,

Line 3631: FROM OKS_BILL_SUB_LINE_DTLS

3627: E_Resource_Busy EXCEPTION;
3628: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3629: CURSOR lock_csr (p_bsd_rec IN bsd_rec_type) IS
3630: SELECT OBJECT_VERSION_NUMBER
3631: FROM OKS_BILL_SUB_LINE_DTLS
3632: WHERE ID = p_bsd_rec.id
3633: AND OBJECT_VERSION_NUMBER = p_bsd_rec.object_version_number
3634: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3635:

Line 3638: FROM OKS_BILL_SUB_LINE_DTLS

3634: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3635:
3636: CURSOR lchk_csr (p_bsd_rec IN bsd_rec_type) IS
3637: SELECT OBJECT_VERSION_NUMBER
3638: FROM OKS_BILL_SUB_LINE_DTLS
3639: WHERE ID = p_bsd_rec.id;
3640: l_api_version CONSTANT NUMBER := 1;
3641: l_api_name CONSTANT VARCHAR2(30) := 'DTLS_lock_row';
3642: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3643: l_object_version_number OKS_BILL_SUB_LINE_DTLS.OBJECT_VERSION_NUMBER%TYPE;

3639: WHERE ID = p_bsd_rec.id;
3640: l_api_version CONSTANT NUMBER := 1;
3641: l_api_name CONSTANT VARCHAR2(30) := 'DTLS_lock_row';
3642: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3643: l_object_version_number OKS_BILL_SUB_LINE_DTLS.OBJECT_VERSION_NUMBER%TYPE;
3644: lc_object_version_number OKS_BILL_SUB_LINE_DTLS.OBJECT_VERSION_NUMBER%TYPE;
3645: l_row_notfound BOOLEAN := FALSE;
3646: lc_row_notfound BOOLEAN := FALSE;
3647: BEGIN

Line 3644: lc_object_version_number OKS_BILL_SUB_LINE_DTLS.OBJECT_VERSION_NUMBER%TYPE;

3640: l_api_version CONSTANT NUMBER := 1;
3641: l_api_name CONSTANT VARCHAR2(30) := 'DTLS_lock_row';
3642: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3643: l_object_version_number OKS_BILL_SUB_LINE_DTLS.OBJECT_VERSION_NUMBER%TYPE;
3644: lc_object_version_number OKS_BILL_SUB_LINE_DTLS.OBJECT_VERSION_NUMBER%TYPE;
3645: l_row_notfound BOOLEAN := FALSE;
3646: lc_row_notfound BOOLEAN := FALSE;
3647: BEGIN
3648: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3872: -- update_row for:OKS_BILL_SUB_LINE_DTLS --

3868: ---------------------------------------------------------------------------
3869: -- PROCEDURE update_row
3870: ---------------------------------------------------------------------------
3871: -------------------------------------------
3872: -- update_row for:OKS_BILL_SUB_LINE_DTLS --
3873: -------------------------------------------
3874: PROCEDURE update_row(
3875: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3876: x_return_status OUT NOCOPY VARCHAR2,

Line 4076: -- Set_Attributes for:OKS_BILL_SUB_LINE_DTLS --

4072: END IF;
4073: RETURN(l_return_status);
4074: END populate_new_record;
4075: -----------------------------------------------
4076: -- Set_Attributes for:OKS_BILL_SUB_LINE_DTLS --
4077: -----------------------------------------------
4078: FUNCTION Set_Attributes (
4079: p_bsd_rec IN bsd_rec_type,
4080: x_bsd_rec OUT NOCOPY bsd_rec_type

Line 4113: UPDATE OKS_BILL_SUB_LINE_DTLS

4109: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4110: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4111: RAISE OKC_API.G_EXCEPTION_ERROR;
4112: END IF;
4113: UPDATE OKS_BILL_SUB_LINE_DTLS
4114: SET BSL_ID = l_def_bsd_rec.bsl_id,
4115: BSL_ID_AVERAGED = l_def_bsd_rec.bsl_id_averaged,
4116: BSD_ID = l_def_bsd_rec.bsd_id,
4117: BSD_ID_APPLIED = l_def_bsd_rec.bsd_id_applied,

Line 4594: -- delete_row for:OKS_BILL_SUB_LINE_DTLS --

4590: ---------------------------------------------------------------------------
4591: -- PROCEDURE delete_row
4592: ---------------------------------------------------------------------------
4593: -------------------------------------------
4594: -- delete_row for:OKS_BILL_SUB_LINE_DTLS --
4595: -------------------------------------------
4596: PROCEDURE delete_row(
4597: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4598: x_return_status OUT NOCOPY VARCHAR2,

Line 4618: DELETE FROM OKS_BILL_SUB_LINE_DTLS

4614: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4615: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4616: RAISE OKC_API.G_EXCEPTION_ERROR;
4617: END IF;
4618: DELETE FROM OKS_BILL_SUB_LINE_DTLS
4619: WHERE ID = l_bsd_rec.id;
4620:
4621: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
4622: EXCEPTION