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_BTL_PVT dependencies on OKS_BILL_TXN_LINES

Line 36: -- FUNCTION get_rec for: OKS_BILL_TXN_LINES

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

Line 80: FROM Oks_Bill_Txn_Lines

76: ATTRIBUTE14,
77: ATTRIBUTE15,
78: SPLIT_FLAG,
79: CYCLE_REFRENCE
80: FROM Oks_Bill_Txn_Lines
81: WHERE oks_bill_txn_lines.id = p_id;
82: l_btl_pk btl_pk_csr%ROWTYPE;
83: l_btl_rec btl_rec_type;
84: BEGIN

Line 81: WHERE oks_bill_txn_lines.id = p_id;

77: ATTRIBUTE15,
78: SPLIT_FLAG,
79: CYCLE_REFRENCE
80: FROM Oks_Bill_Txn_Lines
81: WHERE oks_bill_txn_lines.id = p_id;
82: l_btl_pk btl_pk_csr%ROWTYPE;
83: l_btl_rec btl_rec_type;
84: BEGIN
85: x_no_data_found := TRUE;

Line 138: -- FUNCTION get_rec for: OKS_BILL_TXN_LINES_V

134: BEGIN
135: RETURN(get_rec(p_btl_rec, l_row_notfound));
136: END get_rec;
137: ---------------------------------------------------------------------------
138: -- FUNCTION get_rec for: OKS_BILL_TXN_LINES_V
139: ---------------------------------------------------------------------------
140: FUNCTION get_rec (
141: p_btlv_rec IN btlv_rec_type,
142: x_no_data_found OUT NOCOPY BOOLEAN

Line 182: FROM Oks_Bill_Txn_Lines_V

178: LAST_UPDATE_DATE,
179: LAST_UPDATE_LOGIN,
180: split_flag,
181: cycle_refrence
182: FROM Oks_Bill_Txn_Lines_V
183: WHERE oks_bill_txn_lines_v.id = p_id;
184: l_okc_btlv_pk okc_btlv_pk_csr%ROWTYPE;
185: l_btlv_rec btlv_rec_type;
186: BEGIN

Line 183: WHERE oks_bill_txn_lines_v.id = p_id;

179: LAST_UPDATE_LOGIN,
180: split_flag,
181: cycle_refrence
182: FROM Oks_Bill_Txn_Lines_V
183: WHERE oks_bill_txn_lines_v.id = p_id;
184: l_okc_btlv_pk okc_btlv_pk_csr%ROWTYPE;
185: l_btlv_rec btlv_rec_type;
186: BEGIN
187: x_no_data_found := TRUE;

Line 241: -- FUNCTION null_out_defaults for: OKS_BILL_TXN_LINES_V --

237: RETURN(get_rec(p_btlv_rec, l_row_notfound));
238: END get_rec;
239:
240: ----------------------------------------------------------
241: -- FUNCTION null_out_defaults for: OKS_BILL_TXN_LINES_V --
242: ----------------------------------------------------------
243: FUNCTION null_out_defaults (
244: p_btlv_rec IN btlv_rec_type
245: ) RETURN btlv_rec_type IS

Line 587: p_view_name => 'OKS_BILL_TXN_LINES_V'

583: null;
584: -- call column length utility
585: /*OKC_UTIL.CHECK_LENGTH
586: (
587: p_view_name => 'OKS_BILL_TXN_LINES_V'
588: ,p_col_name => 'TRX_LINE_AMOUNT'
589: ,p_col_value => P_Trx_Line_Amount
590: ,x_return_status => l_return_status
591: );

Line 795: p_view_name => 'OKS_BILL_TXN_LINES_V'

791: -- call column length utility
792: /*
793: OKC_UTIL.CHECK_LENGTH
794: (
795: p_view_name => 'OKS_BILL_TXN_LINES_V'
796: ,p_col_name => 'attribute1'
797: ,p_col_value => p_attribute1
798: ,x_return_status => l_return_status
799: );

Line 848: p_view_name => 'OKS_BILL_TXN_LINES_V'

844: -- call column length utility
845: /*
846: OKC_UTIL.CHECK_LENGTH
847: (
848: p_view_name => 'OKS_BILL_TXN_LINES_V'
849: ,p_col_name => 'attribute2'
850: ,p_col_value => p_attribute2
851: ,x_return_status => l_return_status
852: );

Line 902: p_view_name => 'OKS_BILL_TXN_LINES_V'

898: -- call column length utility
899: /*
900: OKC_UTIL.CHECK_LENGTH
901: (
902: p_view_name => 'OKS_BILL_TXN_LINES_V'
903: ,p_col_name => 'attribute3'
904: ,p_col_value => p_attribute3
905: ,x_return_status => l_return_status
906: );

Line 954: p_view_name => 'OKS_BILL_TXN_LINES_V'

950: -- call column length utility
951: /*
952: OKC_UTIL.CHECK_LENGTH
953: (
954: p_view_name => 'OKS_BILL_TXN_LINES_V'
955: ,p_col_name => 'attribute4'
956: ,p_col_value => p_attribute4
957: ,x_return_status => l_return_status
958: );

Line 1007: p_view_name => 'OKS_BILL_TXN_LINES_V'

1003: -- call column length utility
1004: /*
1005: OKC_UTIL.CHECK_LENGTH
1006: (
1007: p_view_name => 'OKS_BILL_TXN_LINES_V'
1008: ,p_col_name => 'attribute5'
1009: ,p_col_value => p_attribute5
1010: ,x_return_status => l_return_status
1011: );

Line 1060: p_view_name => 'OKS_BILL_TXN_LINES_V'

1056: -- call column length utility
1057: /*
1058: OKC_UTIL.CHECK_LENGTH
1059: (
1060: p_view_name => 'OKS_BILL_TXN_LINES_V'
1061: ,p_col_name => 'attribute6'
1062: ,p_col_value => p_attribute6
1063: ,x_return_status => l_return_status
1064: );

Line 1113: p_view_name => 'OKS_BILL_TXN_LINES_V'

1109: -- call column length utility
1110: /*
1111: OKC_UTIL.CHECK_LENGTH
1112: (
1113: p_view_name => 'OKS_BILL_TXN_LINES_V'
1114: ,p_col_name => 'attribute7'
1115: ,p_col_value => p_attribute7
1116: ,x_return_status => l_return_status
1117: );

Line 1167: p_view_name => 'OKS_BILL_TXN_LINES_V'

1163: -- call column length utility
1164: /*
1165: OKC_UTIL.CHECK_LENGTH
1166: (
1167: p_view_name => 'OKS_BILL_TXN_LINES_V'
1168: ,p_col_name => 'attribute8'
1169: ,p_col_value => p_attribute8
1170: ,x_return_status => l_return_status
1171: );

Line 1221: p_view_name => 'OKS_BILL_TXN_LINES_V'

1217: -- call column length utility
1218: /*
1219: OKC_UTIL.CHECK_LENGTH
1220: (
1221: p_view_name => 'OKS_BILL_TXN_LINES_V'
1222: ,p_col_name => 'attribute9'
1223: ,p_col_value => p_attribute9
1224: ,x_return_status => l_return_status
1225: );

Line 1275: p_view_name => 'OKS_BILL_TXN_LINES_V'

1271: -- call column length utility
1272: /*
1273: OKC_UTIL.CHECK_LENGTH
1274: (
1275: p_view_name => 'OKS_BILL_TXN_LINES_V'
1276: ,p_col_name => 'attribute10'
1277: ,p_col_value => p_attribute10
1278: ,x_return_status => l_return_status
1279: );

Line 1330: p_view_name => 'OKS_BILL_TXN_LINES_V'

1326:
1327: /*
1328: OKC_UTIL.CHECK_LENGTH
1329: (
1330: p_view_name => 'OKS_BILL_TXN_LINES_V'
1331: ,p_col_name => 'attribute11'
1332: ,p_col_value => p_attribute11
1333: ,x_return_status => l_return_status
1334: );

Line 1385: p_view_name => 'OKS_BILL_TXN_LINES_V'

1381: -- call column length utility
1382: /*
1383: OKC_UTIL.CHECK_LENGTH
1384: (
1385: p_view_name => 'OKS_BILL_TXN_LINES_V'
1386: ,p_col_name => 'attribute12'
1387: ,p_col_value => p_attribute12
1388: ,x_return_status => l_return_status
1389: );

Line 1440: p_view_name => 'OKS_BILL_TXN_LINES_V'

1436: -- call column length utility
1437: /*
1438: OKC_UTIL.CHECK_LENGTH
1439: (
1440: p_view_name => 'OKS_BILL_TXN_LINES_V'
1441: ,p_col_name => 'attribute13'
1442: ,p_col_value => p_attribute13
1443: ,x_return_status => l_return_status
1444: );

Line 1495: p_view_name => 'OKS_BILL_TXN_LINES_V'

1491: -- call column length utility
1492: /*
1493: OKC_UTIL.CHECK_LENGTH
1494: (
1495: p_view_name => 'OKS_BILL_TXN_LINES_V'
1496: ,p_col_name => 'attribute14'
1497: ,p_col_value => p_attribute14
1498: ,x_return_status => l_return_status
1499: );

Line 1548: p_view_name => 'OKS_BILL_TXN_LINES_V'

1544: -- call column length utility
1545: /*
1546: OKC_UTIL.CHECK_LENGTH
1547: (
1548: p_view_name => 'OKS_BILL_TXN_LINES_V'
1549: ,p_col_name => 'attribute15'
1550: ,p_col_value => p_attribute15
1551: ,x_return_status => l_return_status
1552: );

Line 1586: -- Validate_Attributes for:OKS_BILL_TXN_LINES_V --

1582: -- notify caller of an UNEXPECTED error
1583: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1584: END validate_attribute15;
1585: --------------------------------------------------
1586: -- Validate_Attributes for:OKS_BILL_TXN_LINES_V --
1587: --------------------------------------------------
1588: FUNCTION Validate_Attributes (
1589: p_btlv_rec IN btlv_rec_type
1590: )

Line 1598: OKC_UTIL.ADD_VIEW('OKS_BILL_TXN_LINES_V',x_return_status);

1594:
1595: Begin
1596: -- call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
1597:
1598: OKC_UTIL.ADD_VIEW('OKS_BILL_TXN_LINES_V',x_return_status);
1599:
1600: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1601: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1602: -- need to leave

Line 2074: -- Validate_Attributes for:OKS_BILL_TXN_LINES_V --

2070:
2071: END validate_attributes;
2072:
2073: /* --------------------------------------------------
2074: -- Validate_Attributes for:OKS_BILL_TXN_LINES_V --
2075: --------------------------------------------------
2076: FUNCTION Validate_Attributes (
2077: p_btlv_rec IN btlv_rec_type
2078: ) RETURN VARCHAR2 IS

Line 2114: -- Validate_Record for:OKS_BILL_TXN_LINES_V --

2110: ---------------------------------------------------------------------------
2111: -- PROCEDURE Validate_Record
2112: ---------------------------------------------------------------------------
2113: ----------------------------------------------
2114: -- Validate_Record for:OKS_BILL_TXN_LINES_V --
2115: ----------------------------------------------
2116: FUNCTION Validate_Record (
2117: p_btlv_rec IN btlv_rec_type
2118: ) RETURN VARCHAR2 IS

Line 2307: -- validate_row for:OKS_BILL_TXN_LINES_V --

2303: ---------------------------------------------------------------------------
2304: -- PROCEDURE validate_row
2305: ---------------------------------------------------------------------------
2306: -------------------------------------------
2307: -- validate_row for:OKS_BILL_TXN_LINES_V --
2308: -------------------------------------------
2309: PROCEDURE validate_row(
2310: p_api_version IN NUMBER,
2311: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2451: -- insert_row for:OKS_BILL_TXN_LINES --

2447: ---------------------------------------------------------------------------
2448: -- PROCEDURE insert_row
2449: ---------------------------------------------------------------------------
2450: ---------------------------------------
2451: -- insert_row for:OKS_BILL_TXN_LINES --
2452: ---------------------------------------
2453: PROCEDURE insert_row(
2454: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2455: x_return_status OUT NOCOPY VARCHAR2,

Line 2467: -- Set_Attributes for:OKS_BILL_TXN_LINES --

2463: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2464: l_btl_rec btl_rec_type := p_btl_rec;
2465: l_def_btl_rec btl_rec_type;
2466: -------------------------------------------
2467: -- Set_Attributes for:OKS_BILL_TXN_LINES --
2468: -------------------------------------------
2469: FUNCTION Set_Attributes (
2470: p_btl_rec IN btl_rec_type,
2471: x_btl_rec OUT NOCOPY btl_rec_type

Line 2498: INSERT INTO OKS_BILL_TXN_LINES(

2494: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2495: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2496: RAISE OKC_API.G_EXCEPTION_ERROR;
2497: END IF;
2498: INSERT INTO OKS_BILL_TXN_LINES(
2499: id,
2500: btn_id,
2501: bsl_id,
2502: bcl_id,

Line 2608: -- insert_row for:OKS_BILL_TXN_LINES_V --

2604: '_PVT'
2605: );
2606: END insert_row;
2607: -----------------------------------------
2608: -- insert_row for:OKS_BILL_TXN_LINES_V --
2609: -----------------------------------------
2610: PROCEDURE insert_row(
2611: p_api_version IN NUMBER,
2612: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2642: -- Set_Attributes for:OKS_BILL_TXN_LINES_V --

2638: l_btlv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2639: RETURN(l_btlv_rec);
2640: END fill_who_columns;
2641: ---------------------------------------------
2642: -- Set_Attributes for:OKS_BILL_TXN_LINES_V --
2643: ---------------------------------------------
2644: FUNCTION Set_Attributes (
2645: p_btlv_rec IN btlv_rec_type,
2646: x_btlv_rec OUT NOCOPY btlv_rec_type

Line 2829: -- lock_row for:OKS_BILL_TXN_LINES --

2825: ---------------------------------------------------------------------------
2826: -- PROCEDURE lock_row
2827: ---------------------------------------------------------------------------
2828: -------------------------------------
2829: -- lock_row for:OKS_BILL_TXN_LINES --
2830: -------------------------------------
2831: PROCEDURE lock_row(
2832: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2833: x_return_status OUT NOCOPY VARCHAR2,

Line 2842: FROM OKS_BILL_TXN_LINES

2838: E_Resource_Busy EXCEPTION;
2839: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2840: CURSOR lock_csr (p_btl_rec IN btl_rec_type) IS
2841: SELECT OBJECT_VERSION_NUMBER
2842: FROM OKS_BILL_TXN_LINES
2843: WHERE ID = p_btl_rec.id
2844: AND OBJECT_VERSION_NUMBER = p_btl_rec.object_version_number
2845: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2846:

Line 2849: FROM OKS_BILL_TXN_LINES

2845: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2846:
2847: CURSOR lchk_csr (p_btl_rec IN btl_rec_type) IS
2848: SELECT OBJECT_VERSION_NUMBER
2849: FROM OKS_BILL_TXN_LINES
2850: WHERE ID = p_btl_rec.id;
2851: l_api_version CONSTANT NUMBER := 1;
2852: l_api_name CONSTANT VARCHAR2(30) := 'LINES_lock_row';
2853: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2854: l_object_version_number OKS_BILL_TXN_LINES.OBJECT_VERSION_NUMBER%TYPE;

2850: WHERE ID = p_btl_rec.id;
2851: l_api_version CONSTANT NUMBER := 1;
2852: l_api_name CONSTANT VARCHAR2(30) := 'LINES_lock_row';
2853: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2854: l_object_version_number OKS_BILL_TXN_LINES.OBJECT_VERSION_NUMBER%TYPE;
2855: lc_object_version_number OKS_BILL_TXN_LINES.OBJECT_VERSION_NUMBER%TYPE;
2856: l_row_notfound BOOLEAN := FALSE;
2857: lc_row_notfound BOOLEAN := FALSE;
2858: BEGIN

Line 2855: lc_object_version_number OKS_BILL_TXN_LINES.OBJECT_VERSION_NUMBER%TYPE;

2851: l_api_version CONSTANT NUMBER := 1;
2852: l_api_name CONSTANT VARCHAR2(30) := 'LINES_lock_row';
2853: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2854: l_object_version_number OKS_BILL_TXN_LINES.OBJECT_VERSION_NUMBER%TYPE;
2855: lc_object_version_number OKS_BILL_TXN_LINES.OBJECT_VERSION_NUMBER%TYPE;
2856: l_row_notfound BOOLEAN := FALSE;
2857: lc_row_notfound BOOLEAN := FALSE;
2858: BEGIN
2859: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2935: -- lock_row for:OKS_BILL_TXN_LINES_V --

2931: '_PVT'
2932: );
2933: END lock_row;
2934: ---------------------------------------
2935: -- lock_row for:OKS_BILL_TXN_LINES_V --
2936: ---------------------------------------
2937: PROCEDURE lock_row(
2938: p_api_version IN NUMBER,
2939: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3083: -- update_row for:OKS_BILL_TXN_LINES --

3079: ---------------------------------------------------------------------------
3080: -- PROCEDURE update_row
3081: ---------------------------------------------------------------------------
3082: ---------------------------------------
3083: -- update_row for:OKS_BILL_TXN_LINES --
3084: ---------------------------------------
3085: PROCEDURE update_row(
3086: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3087: x_return_status OUT NOCOPY VARCHAR2,

Line 3263: -- Set_Attributes for:OKS_BILL_TXN_LINES --

3259: END IF;
3260: RETURN(l_return_status);
3261: END populate_new_record;
3262: -------------------------------------------
3263: -- Set_Attributes for:OKS_BILL_TXN_LINES --
3264: -------------------------------------------
3265: FUNCTION Set_Attributes (
3266: p_btl_rec IN btl_rec_type,
3267: x_btl_rec OUT NOCOPY btl_rec_type

Line 3300: UPDATE OKS_BILL_TXN_LINES

3296: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3297: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3298: RAISE OKC_API.G_EXCEPTION_ERROR;
3299: END IF;
3300: UPDATE OKS_BILL_TXN_LINES
3301: SET BTN_ID = l_def_btl_rec.btn_id,
3302: BSL_ID = l_def_btl_rec.bsl_id,
3303: BCL_ID = l_def_btl_rec.bcl_id,
3304: OBJECT_VERSION_NUMBER = l_def_btl_rec.object_version_number,

Line 3373: -- update_row for:OKS_BILL_TXN_LINES_V --

3369: '_PVT'
3370: );
3371: END update_row;
3372: -----------------------------------------
3373: -- update_row for:OKS_BILL_TXN_LINES_V --
3374: -----------------------------------------
3375: PROCEDURE update_row(
3376: p_api_version IN NUMBER,
3377: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3568: -- Set_Attributes for:OKS_BILL_TXN_LINES_V --

3564: END IF;
3565: RETURN(l_return_status);
3566: END populate_new_record;
3567: ---------------------------------------------
3568: -- Set_Attributes for:OKS_BILL_TXN_LINES_V --
3569: ---------------------------------------------
3570: FUNCTION Set_Attributes (
3571: p_btlv_rec IN btlv_rec_type,
3572: x_btlv_rec OUT NOCOPY btlv_rec_type

Line 3751: -- delete_row for:OKS_BILL_TXN_LINES --

3747: ---------------------------------------------------------------------------
3748: -- PROCEDURE delete_row
3749: ---------------------------------------------------------------------------
3750: ---------------------------------------
3751: -- delete_row for:OKS_BILL_TXN_LINES --
3752: ---------------------------------------
3753: PROCEDURE delete_row(
3754: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3755: x_return_status OUT NOCOPY VARCHAR2,

Line 3775: DELETE FROM OKS_BILL_TXN_LINES

3771: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3772: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3773: RAISE OKC_API.G_EXCEPTION_ERROR;
3774: END IF;
3775: DELETE FROM OKS_BILL_TXN_LINES
3776: WHERE ID = l_btl_rec.id;
3777:
3778: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3779: EXCEPTION

Line 3812: -- delete_row for:OKS_BILL_TXN_LINES_V --

3808: '_PVT'
3809: );
3810: END delete_row;
3811: -----------------------------------------
3812: -- delete_row for:OKS_BILL_TXN_LINES_V --
3813: -----------------------------------------
3814: PROCEDURE delete_row(
3815: p_api_version IN NUMBER,
3816: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 4049: INTO OKS_BILL_TXN_LINES

4045: END LOOP;
4046:
4047: FORALL i in 1..l_tabsize
4048: INSERT
4049: INTO OKS_BILL_TXN_LINES
4050: (
4051: id,
4052: btn_id,
4053: bsl_id,