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_BILLING_PROFILES_PVT dependencies on OKS_BILLING_PROFILES_B

Line 101: FROM OKS_BILLING_PROFILES_B B

97: BEGIN
98: DELETE FROM OKS_BILLING_PROFILES_TL T
99: WHERE NOT EXISTS (
100: SELECT NULL
101: FROM OKS_BILLING_PROFILES_B B
102: WHERE B.ID =T.ID
103: );
104:
105: UPDATE OKS_BILLING_PROFILES_TL T SET(

Line 334: -- FUNCTION get_rec for: OKS_BILLING_PROFILES_B

330: BEGIN
331: RETURN(get_rec(p_bpev_rec, l_row_not_found));
332: END get_rec;
333: ---------------------------------------------------------------------------
334: -- FUNCTION get_rec for: OKS_BILLING_PROFILES_B
335: ---------------------------------------------------------------------------
336: FUNCTION get_rec (
337: p_bpe_rec IN bpe_rec_type,
338: x_no_data_found OUT NOCOPY BOOLEAN

Line 340: CURSOR oks_billing_profiles_b_pk_csr (p_id IN NUMBER) IS

336: FUNCTION get_rec (
337: p_bpe_rec IN bpe_rec_type,
338: x_no_data_found OUT NOCOPY BOOLEAN
339: ) RETURN bpe_rec_type IS
340: CURSOR oks_billing_profiles_b_pk_csr (p_id IN NUMBER) IS
341: SELECT
342: ID,
343: MDA_CODE,
344: OWNED_PARTY_ID1,

Line 395: FROM Oks_Billing_Profiles_B

391: BILLING_TYPE,
392: INTERVAL,
393: INTERFACE_OFFSET,
394: INVOICE_OFFSET
395: FROM Oks_Billing_Profiles_B
396: WHERE oks_billing_profiles_b.id = p_id;
397: l_oks_billing_profiles_b_pk oks_billing_profiles_b_pk_csr%ROWTYPE;
398: l_bpe_rec bpe_rec_type;
399: BEGIN

Line 396: WHERE oks_billing_profiles_b.id = p_id;

392: INTERVAL,
393: INTERFACE_OFFSET,
394: INVOICE_OFFSET
395: FROM Oks_Billing_Profiles_B
396: WHERE oks_billing_profiles_b.id = p_id;
397: l_oks_billing_profiles_b_pk oks_billing_profiles_b_pk_csr%ROWTYPE;
398: l_bpe_rec bpe_rec_type;
399: BEGIN
400: x_no_data_found := TRUE;

Line 397: l_oks_billing_profiles_b_pk oks_billing_profiles_b_pk_csr%ROWTYPE;

393: INTERFACE_OFFSET,
394: INVOICE_OFFSET
395: FROM Oks_Billing_Profiles_B
396: WHERE oks_billing_profiles_b.id = p_id;
397: l_oks_billing_profiles_b_pk oks_billing_profiles_b_pk_csr%ROWTYPE;
398: l_bpe_rec bpe_rec_type;
399: BEGIN
400: x_no_data_found := TRUE;
401: -- Get current database values

Line 402: OPEN oks_billing_profiles_b_pk_csr (p_bpe_rec.id);

398: l_bpe_rec bpe_rec_type;
399: BEGIN
400: x_no_data_found := TRUE;
401: -- Get current database values
402: OPEN oks_billing_profiles_b_pk_csr (p_bpe_rec.id);
403: FETCH oks_billing_profiles_b_pk_csr INTO
404: l_bpe_rec.id,
405: l_bpe_rec.mda_code,
406: l_bpe_rec.owned_party_id1,

Line 403: FETCH oks_billing_profiles_b_pk_csr INTO

399: BEGIN
400: x_no_data_found := TRUE;
401: -- Get current database values
402: OPEN oks_billing_profiles_b_pk_csr (p_bpe_rec.id);
403: FETCH oks_billing_profiles_b_pk_csr INTO
404: l_bpe_rec.id,
405: l_bpe_rec.mda_code,
406: l_bpe_rec.owned_party_id1,
407: l_bpe_rec.owned_party_id2,

Line 457: x_no_data_found := oks_billing_profiles_b_pk_csr%NOTFOUND;

453: l_bpe_rec.billing_type,
454: l_bpe_rec.interval,
455: l_bpe_rec.interface_offset,
456: l_bpe_rec.invoice_offset;
457: x_no_data_found := oks_billing_profiles_b_pk_csr%NOTFOUND;
458: CLOSE oks_billing_profiles_b_pk_csr;
459: RETURN(l_bpe_rec);
460: END get_rec;
461:

Line 458: CLOSE oks_billing_profiles_b_pk_csr;

454: l_bpe_rec.interval,
455: l_bpe_rec.interface_offset,
456: l_bpe_rec.invoice_offset;
457: x_no_data_found := oks_billing_profiles_b_pk_csr%NOTFOUND;
458: CLOSE oks_billing_profiles_b_pk_csr;
459: RETURN(l_bpe_rec);
460: END get_rec;
461:
462: ------------------------------------------------------------------

Line 1619: -- insert_row for:OKS_BILLING_PROFILES_B --

1615: ---------------------------------------------------------------------------
1616: -- PROCEDURE insert_row
1617: ---------------------------------------------------------------------------
1618: -------------------------------------------
1619: -- insert_row for:OKS_BILLING_PROFILES_B --
1620: -------------------------------------------
1621: PROCEDURE insert_row(
1622: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1623: x_return_status OUT NOCOPY VARCHAR2,

Line 1635: -- Set_Attributes for:OKS_BILLING_PROFILES_B --

1631: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1632: l_bpe_rec bpe_rec_type := p_bpe_rec;
1633: l_def_bpe_rec bpe_rec_type;
1634: -----------------------------------------------
1635: -- Set_Attributes for:OKS_BILLING_PROFILES_B --
1636: -----------------------------------------------
1637: FUNCTION Set_Attributes (
1638: p_bpe_rec IN bpe_rec_type,
1639: x_bpe_rec OUT NOCOPY bpe_rec_type

Line 1666: INSERT INTO OKS_BILLING_PROFILES_B(

1662: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1663: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1664: RAISE OKC_API.G_EXCEPTION_ERROR;
1665: END IF;
1666: INSERT INTO OKS_BILLING_PROFILES_B(
1667: id,
1668: mda_code,
1669: owned_party_id1,
1670: owned_party_id2,

Line 2258: -- lock_row for:OKS_BILLING_PROFILES_B --

2254: ---------------------------------------------------------------------------
2255: -- PROCEDURE lock_row
2256: ---------------------------------------------------------------------------
2257: -----------------------------------------
2258: -- lock_row for:OKS_BILLING_PROFILES_B --
2259: -----------------------------------------
2260: PROCEDURE lock_row(
2261: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2262: x_return_status OUT NOCOPY VARCHAR2,

Line 2271: FROM OKS_BILLING_PROFILES_B

2267: E_Resource_Busy EXCEPTION;
2268: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2269: CURSOR lock_csr (p_bpe_rec IN bpe_rec_type) IS
2270: SELECT OBJECT_VERSION_NUMBER
2271: FROM OKS_BILLING_PROFILES_B
2272: WHERE ID = p_bpe_rec.id
2273: AND OBJECT_VERSION_NUMBER = p_bpe_rec.object_version_number
2274: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2275:

Line 2278: FROM OKS_BILLING_PROFILES_B

2274: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2275:
2276: CURSOR lchk_csr (p_bpe_rec IN bpe_rec_type) IS
2277: SELECT OBJECT_VERSION_NUMBER
2278: FROM OKS_BILLING_PROFILES_B
2279: WHERE ID = p_bpe_rec.id;
2280: l_api_version CONSTANT NUMBER := 1;
2281: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2282: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2283: l_object_version_number OKS_BILLING_PROFILES_B.OBJECT_VERSION_NUMBER%TYPE;

2279: WHERE ID = p_bpe_rec.id;
2280: l_api_version CONSTANT NUMBER := 1;
2281: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2282: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2283: l_object_version_number OKS_BILLING_PROFILES_B.OBJECT_VERSION_NUMBER%TYPE;
2284: lc_object_version_number OKS_BILLING_PROFILES_B.OBJECT_VERSION_NUMBER%TYPE;
2285: l_row_notfound BOOLEAN := FALSE;
2286: lc_row_notfound BOOLEAN := FALSE;
2287: BEGIN

Line 2284: lc_object_version_number OKS_BILLING_PROFILES_B.OBJECT_VERSION_NUMBER%TYPE;

2280: l_api_version CONSTANT NUMBER := 1;
2281: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2282: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2283: l_object_version_number OKS_BILLING_PROFILES_B.OBJECT_VERSION_NUMBER%TYPE;
2284: lc_object_version_number OKS_BILLING_PROFILES_B.OBJECT_VERSION_NUMBER%TYPE;
2285: l_row_notfound BOOLEAN := FALSE;
2286: lc_row_notfound BOOLEAN := FALSE;
2287: BEGIN
2288: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2705: -- update_row for:OKS_BILLING_PROFILES_B --

2701: ---------------------------------------------------------------------------
2702: -- PROCEDURE update_row
2703: ---------------------------------------------------------------------------
2704: -------------------------------------------
2705: -- update_row for:OKS_BILLING_PROFILES_B --
2706: -------------------------------------------
2707: PROCEDURE update_row(
2708: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2709: x_return_status OUT NOCOPY VARCHAR2,

Line 2952: -- Set_Attributes for:OKS_BILLING_PROFILES_B --

2948: END IF;
2949: RETURN(l_return_status);
2950: END populate_new_record;
2951: -----------------------------------------------
2952: -- Set_Attributes for:OKS_BILLING_PROFILES_B --
2953: -----------------------------------------------
2954: FUNCTION Set_Attributes (
2955: p_bpe_rec IN bpe_rec_type,
2956: x_bpe_rec OUT NOCOPY bpe_rec_type

Line 2990: UPDATE OKS_BILLING_PROFILES_B

2986: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2987: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2988: RAISE OKC_API.G_EXCEPTION_ERROR;
2989: END IF;
2990: UPDATE OKS_BILLING_PROFILES_B
2991: SET MDA_CODE = l_def_bpe_rec.mda_code,
2992: OWNED_PARTY_ID1 = l_def_bpe_rec.owned_party_id1,
2993: OWNED_PARTY_ID2 = l_def_bpe_rec.owned_party_id2,
2994: DEPENDENT_CUST_ACCT_ID1 = l_def_bpe_rec.dependent_cust_acct_id1,

Line 3841: -- delete_row for:OKS_BILLING_PROFILES_B --

3837: ---------------------------------------------------------------------------
3838: -- PROCEDURE delete_row
3839: ---------------------------------------------------------------------------
3840: -------------------------------------------
3841: -- delete_row for:OKS_BILLING_PROFILES_B --
3842: -------------------------------------------
3843: PROCEDURE delete_row(
3844: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3845: x_return_status OUT NOCOPY VARCHAR2,

Line 3866: DELETE FROM OKS_BILLING_PROFILES_B

3862: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3863: RAISE OKC_API.G_EXCEPTION_ERROR;
3864: END IF;
3865:
3866: DELETE FROM OKS_BILLING_PROFILES_B
3867: WHERE ID = p_bpe_rec.id;
3868:
3869: x_return_status := l_return_status;
3870: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);