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_V

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 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 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 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 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,