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_BSL_PVT dependencies on OKS_BILL_SUB_LINES

Line 36: -- FUNCTION get_rec for: OKS_BILL_SUB_LINES

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

Line 75: FROM Oks_Bill_Sub_Lines

71: ATTRIBUTE12,
72: ATTRIBUTE13,
73: ATTRIBUTE14,
74: ATTRIBUTE15
75: FROM Oks_Bill_Sub_Lines
76: WHERE oks_bill_sub_lines.id = p_id;
77: l_bsl_pk bsl_pk_csr%ROWTYPE;
78: l_bsl_rec bsl_rec_type;
79: BEGIN

Line 76: WHERE oks_bill_sub_lines.id = p_id;

72: ATTRIBUTE13,
73: ATTRIBUTE14,
74: ATTRIBUTE15
75: FROM Oks_Bill_Sub_Lines
76: WHERE oks_bill_sub_lines.id = p_id;
77: l_bsl_pk bsl_pk_csr%ROWTYPE;
78: l_bsl_rec bsl_rec_type;
79: BEGIN
80: x_no_data_found := TRUE;

Line 128: -- FUNCTION get_rec for: OKS_BILL_SUB_LINES_V

124: BEGIN
125: RETURN(get_rec(p_bsl_rec, l_row_notfound));
126: END get_rec;
127: ---------------------------------------------------------------------------
128: -- FUNCTION get_rec for: OKS_BILL_SUB_LINES_V
129: ---------------------------------------------------------------------------
130: FUNCTION get_rec (
131: p_bslv_rec IN bslv_rec_type,
132: x_no_data_found OUT NOCOPY BOOLEAN

Line 167: FROM Oks_Bill_Sub_Lines_V

163: CREATION_DATE,
164: LAST_UPDATED_BY,
165: LAST_UPDATE_DATE,
166: LAST_UPDATE_LOGIN
167: FROM Oks_Bill_Sub_Lines_V
168: WHERE oks_bill_sub_lines_v.id = p_id;
169: l_oks_bslv_pk oks_bslv_pk_csr%ROWTYPE;
170: l_bslv_rec bslv_rec_type;
171: BEGIN

Line 168: WHERE oks_bill_sub_lines_v.id = p_id;

164: LAST_UPDATED_BY,
165: LAST_UPDATE_DATE,
166: LAST_UPDATE_LOGIN
167: FROM Oks_Bill_Sub_Lines_V
168: WHERE oks_bill_sub_lines_v.id = p_id;
169: l_oks_bslv_pk oks_bslv_pk_csr%ROWTYPE;
170: l_bslv_rec bslv_rec_type;
171: BEGIN
172: x_no_data_found := TRUE;

Line 221: -- FUNCTION null_out_defaults for: OKS_BILL_SUB_LINES_V --

217: RETURN(get_rec(p_bslv_rec, l_row_notfound));
218: END get_rec;
219:
220: ----------------------------------------------------------
221: -- FUNCTION null_out_defaults for: OKS_BILL_SUB_LINES_V --
222: ----------------------------------------------------------
223: FUNCTION null_out_defaults (
224: p_bslv_rec IN bslv_rec_type
225: ) RETURN bslv_rec_type IS

Line 480: p_view_name => 'OKS_BILL_SUB_LINES_V'

476: -- call column length utility
477: /*
478: OKC_UTIL.CHECK_LENGTH
479: (
480: p_view_name => 'OKS_BILL_SUB_LINES_V'
481: ,p_col_name => 'Average'
482: ,p_col_value => P_average
483: ,x_return_status => l_return_status
484: );

Line 531: p_view_name => 'OKS_BILL_SUB_LINES_V'

527: -- call column length utility
528: /*
529: OKC_UTIL.CHECK_LENGTH
530: (
531: p_view_name => 'OKS_BILL_SUB_LINES_V'
532: ,p_col_name => 'Amount'
533: ,p_col_value => P_amount
534: ,x_return_status => l_return_status
535: );

Line 694: p_view_name => 'OKS_BILL_SUB_LINES_V'

690: -- call column length utility
691: /*
692: OKC_UTIL.CHECK_LENGTH
693: (
694: p_view_name => 'OKS_BILL_SUB_LINES_V'
695: ,p_col_name => 'attribute1'
696: ,p_col_value => p_attribute1
697: ,x_return_status => l_return_status
698: );

Line 743: p_view_name => 'OKS_BILL_SUB_LINES_V'

739:
740: -- call column length utility
741: /*OKC_UTIL.CHECK_LENGTH
742: (
743: p_view_name => 'OKS_BILL_SUB_LINES_V'
744: ,p_col_name => 'attribute2'
745: ,p_col_value => p_attribute2
746: ,x_return_status => l_return_status
747: );

Line 793: p_view_name => 'OKS_BILL_SUB_LINES_V'

789: -- call column length utility
790: /*
791: OKC_UTIL.CHECK_LENGTH
792: (
793: p_view_name => 'OKS_BILL_SUB_LINES_V'
794: ,p_col_name => 'attribute3'
795: ,p_col_value => p_attribute3
796: ,x_return_status => l_return_status
797: );

Line 843: p_view_name => 'OKS_BILL_SUB_LINES_V'

839: -- call column length utility
840: /*
841: OKC_UTIL.CHECK_LENGTH
842: (
843: p_view_name => 'OKS_BILL_SUB_LINES_V'
844: ,p_col_name => 'attribute4'
845: ,p_col_value => p_attribute4
846: ,x_return_status => l_return_status
847: );

Line 894: p_view_name => 'OKS_BILL_SUB_LINES_V'

890: -- call column length utility
891: /*
892: OKC_UTIL.CHECK_LENGTH
893: (
894: p_view_name => 'OKS_BILL_SUB_LINES_V'
895: ,p_col_name => 'attribute5'
896: ,p_col_value => p_attribute5
897: ,x_return_status => l_return_status
898: );

Line 945: p_view_name => 'OKS_BILL_SUB_LINES_V'

941: -- call column length utility
942: /*
943: OKC_UTIL.CHECK_LENGTH
944: (
945: p_view_name => 'OKS_BILL_SUB_LINES_V'
946: ,p_col_name => 'attribute6'
947: ,p_col_value => p_attribute6
948: ,x_return_status => l_return_status
949: );

Line 996: p_view_name => 'OKS_BILL_SUB_LINES_V'

992: -- call column length utility
993: /*
994: OKC_UTIL.CHECK_LENGTH
995: (
996: p_view_name => 'OKS_BILL_SUB_LINES_V'
997: ,p_col_name => 'attribute7'
998: ,p_col_value => p_attribute7
999: ,x_return_status => l_return_status
1000: );

Line 1048: p_view_name => 'OKS_BILL_SUB_LINES_V'

1044: -- call column length utility
1045: /*
1046: OKC_UTIL.CHECK_LENGTH
1047: (
1048: p_view_name => 'OKS_BILL_SUB_LINES_V'
1049: ,p_col_name => 'attribute8'
1050: ,p_col_value => p_attribute8
1051: ,x_return_status => l_return_status
1052: );

Line 1100: p_view_name => 'OKS_BILL_SUB_LINES_V'

1096: -- call column length utility
1097: /*
1098: OKC_UTIL.CHECK_LENGTH
1099: (
1100: p_view_name => 'OKS_BILL_SUB_LINES_V'
1101: ,p_col_name => 'attribute9'
1102: ,p_col_value => p_attribute9
1103: ,x_return_status => l_return_status
1104: );

Line 1151: p_view_name => 'OKS_BILL_SUB_LINES_V'

1147: -- call column length utility
1148: /*
1149: OKC_UTIL.CHECK_LENGTH
1150: (
1151: p_view_name => 'OKS_BILL_SUB_LINES_V'
1152: ,p_col_name => 'attribute10'
1153: ,p_col_value => p_attribute10
1154: ,x_return_status => l_return_status
1155: );

Line 1204: p_view_name => 'OKS_BILL_SUB_LINES_V'

1200:
1201: /*
1202: OKC_UTIL.CHECK_LENGTH
1203: (
1204: p_view_name => 'OKS_BILL_SUB_LINES_V'
1205: ,p_col_name => 'attribute11'
1206: ,p_col_value => p_attribute11
1207: ,x_return_status => l_return_status
1208: );

Line 1258: p_view_name => 'OKS_BILL_SUB_LINES_V'

1254: -- call column length utility
1255: /*
1256: OKC_UTIL.CHECK_LENGTH
1257: (
1258: p_view_name => 'OKS_BILL_SUB_LINES_V'
1259: ,p_col_name => 'attribute12'
1260: ,p_col_value => p_attribute12
1261: ,x_return_status => l_return_status
1262: );

Line 1311: p_view_name => 'OKS_BILL_SUB_LINES_V'

1307: -- call column length utility
1308: /*
1309: OKC_UTIL.CHECK_LENGTH
1310: (
1311: p_view_name => 'OKS_BILL_SUB_LINES_V'
1312: ,p_col_name => 'attribute13'
1313: ,p_col_value => p_attribute13
1314: ,x_return_status => l_return_status
1315: );

Line 1364: p_view_name => 'OKS_BILL_SUB_LINES_V'

1360: -- call column length utility
1361: /*
1362: OKC_UTIL.CHECK_LENGTH
1363: (
1364: p_view_name => 'OKS_BILL_SUB_LINES_V'
1365: ,p_col_name => 'attribute14'
1366: ,p_col_value => p_attribute14
1367: ,x_return_status => l_return_status
1368: );

Line 1415: p_view_name => 'OKS_BILL_SUB_LINES_V'

1411: -- call column length utility
1412: /*
1413: OKC_UTIL.CHECK_LENGTH
1414: (
1415: p_view_name => 'OKS_BILL_SUB_LINES_V'
1416: ,p_col_name => 'attribute15'
1417: ,p_col_value => p_attribute15
1418: ,x_return_status => l_return_status
1419: );

Line 1454: -- Validate_Attributes for:OKS_BILL_SUB_LINES_V --

1450: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1451: END validate_attribute15;
1452:
1453: --------------------------------------------------
1454: -- Validate_Attributes for:OKS_BILL_SUB_LINES_V --
1455: --------------------------------------------------
1456: /*
1457: FUNCTION Validate_Attributes (
1458: p_bslv_rec IN bslv_rec_type

Line 1502: OKC_UTIL.ADD_VIEW('OKS_BILL_SUB_LINES_V',x_return_status);

1498:
1499: Begin
1500: -- call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
1501:
1502: OKC_UTIL.ADD_VIEW('OKS_BILL_SUB_LINES_V',x_return_status);
1503:
1504: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1505: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1506: -- need to leave

Line 1950: -- Validate_Record for:OKS_BILL_SUB_LINES_V --

1946: ---------------------------------------------------------------------------
1947: -- PROCEDURE Validate_Record
1948: ---------------------------------------------------------------------------
1949: ----------------------------------------------
1950: -- Validate_Record for:OKS_BILL_SUB_LINES_V --
1951: ----------------------------------------------
1952: FUNCTION Validate_Record (
1953: p_bslv_rec IN bslv_rec_type
1954: ) RETURN VARCHAR2 IS

Line 2171: -- validate_row for:OKS_BILL_SUB_LINES_V --

2167: ---------------------------------------------------------------------------
2168: -- PROCEDURE validate_row
2169: ---------------------------------------------------------------------------
2170: -------------------------------------------
2171: -- validate_row for:OKS_BILL_SUB_LINES_V --
2172: -------------------------------------------
2173: PROCEDURE validate_row(
2174: p_api_version IN NUMBER,
2175: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2315: -- insert_row for:OKS_BILL_SUB_LINES --

2311: ---------------------------------------------------------------------------
2312: -- PROCEDURE insert_row
2313: ---------------------------------------------------------------------------
2314: ---------------------------------------
2315: -- insert_row for:OKS_BILL_SUB_LINES --
2316: ---------------------------------------
2317: PROCEDURE insert_row(
2318: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2319: x_return_status OUT NOCOPY VARCHAR2,

Line 2331: -- Set_Attributes for:OKS_BILL_SUB_LINES --

2327: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2328: l_bsl_rec bsl_rec_type := p_bsl_rec;
2329: l_def_bsl_rec bsl_rec_type;
2330: -------------------------------------------
2331: -- Set_Attributes for:OKS_BILL_SUB_LINES --
2332: -------------------------------------------
2333: FUNCTION Set_Attributes (
2334: p_bsl_rec IN bsl_rec_type,
2335: x_bsl_rec OUT NOCOPY bsl_rec_type

Line 2362: INSERT INTO OKS_BILL_SUB_LINES(

2358: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2359: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2360: RAISE OKC_API.G_EXCEPTION_ERROR;
2361: END IF;
2362: INSERT INTO OKS_BILL_SUB_LINES(
2363: id,
2364: bcl_id,
2365: cle_id,
2366: object_version_number,

Line 2462: -- insert_row for:OKS_BILL_SUB_LINES_V --

2458: '_PVT'
2459: );
2460: END insert_row;
2461: -----------------------------------------
2462: -- insert_row for:OKS_BILL_SUB_LINES_V --
2463: -----------------------------------------
2464: PROCEDURE insert_row(
2465: p_api_version IN NUMBER,
2466: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2496: -- Set_Attributes for:OKS_BILL_SUB_LINES_V --

2492: l_bslv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2493: RETURN(l_bslv_rec);
2494: END fill_who_columns;
2495: ---------------------------------------------
2496: -- Set_Attributes for:OKS_BILL_SUB_LINES_V --
2497: ---------------------------------------------
2498: FUNCTION Set_Attributes (
2499: p_bslv_rec IN bslv_rec_type,
2500: x_bslv_rec OUT NOCOPY bslv_rec_type

Line 2676: -- lock_row for:OKS_BILL_SUB_LINES --

2672: ---------------------------------------------------------------------------
2673: -- PROCEDURE lock_row
2674: ---------------------------------------------------------------------------
2675: -------------------------------------
2676: -- lock_row for:OKS_BILL_SUB_LINES --
2677: -------------------------------------
2678: PROCEDURE lock_row(
2679: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2680: x_return_status OUT NOCOPY VARCHAR2,

Line 2689: FROM OKS_BILL_SUB_LINES

2685: E_Resource_Busy EXCEPTION;
2686: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2687: CURSOR lock_csr (p_bsl_rec IN bsl_rec_type) IS
2688: SELECT OBJECT_VERSION_NUMBER
2689: FROM OKS_BILL_SUB_LINES
2690: WHERE ID = p_bsl_rec.id
2691: AND OBJECT_VERSION_NUMBER = p_bsl_rec.object_version_number
2692: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2693:

Line 2696: FROM OKS_BILL_SUB_LINES

2692: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2693:
2694: CURSOR lchk_csr (p_bsl_rec IN bsl_rec_type) IS
2695: SELECT OBJECT_VERSION_NUMBER
2696: FROM OKS_BILL_SUB_LINES
2697: WHERE ID = p_bsl_rec.id;
2698: l_api_version CONSTANT NUMBER := 1;
2699: l_api_name CONSTANT VARCHAR2(30) := 'LINES_lock_row';
2700: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2701: l_object_version_number OKS_BILL_SUB_LINES.OBJECT_VERSION_NUMBER%TYPE;

2697: WHERE ID = p_bsl_rec.id;
2698: l_api_version CONSTANT NUMBER := 1;
2699: l_api_name CONSTANT VARCHAR2(30) := 'LINES_lock_row';
2700: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2701: l_object_version_number OKS_BILL_SUB_LINES.OBJECT_VERSION_NUMBER%TYPE;
2702: lc_object_version_number OKS_BILL_SUB_LINES.OBJECT_VERSION_NUMBER%TYPE;
2703: l_row_notfound BOOLEAN := FALSE;
2704: lc_row_notfound BOOLEAN := FALSE;
2705: BEGIN

Line 2702: lc_object_version_number OKS_BILL_SUB_LINES.OBJECT_VERSION_NUMBER%TYPE;

2698: l_api_version CONSTANT NUMBER := 1;
2699: l_api_name CONSTANT VARCHAR2(30) := 'LINES_lock_row';
2700: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2701: l_object_version_number OKS_BILL_SUB_LINES.OBJECT_VERSION_NUMBER%TYPE;
2702: lc_object_version_number OKS_BILL_SUB_LINES.OBJECT_VERSION_NUMBER%TYPE;
2703: l_row_notfound BOOLEAN := FALSE;
2704: lc_row_notfound BOOLEAN := FALSE;
2705: BEGIN
2706: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2782: -- lock_row for:OKS_BILL_SUB_LINES_V --

2778: '_PVT'
2779: );
2780: END lock_row;
2781: ---------------------------------------
2782: -- lock_row for:OKS_BILL_SUB_LINES_V --
2783: ---------------------------------------
2784: PROCEDURE lock_row(
2785: p_api_version IN NUMBER,
2786: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2930: -- update_row for:OKS_BILL_SUB_LINES --

2926: ---------------------------------------------------------------------------
2927: -- PROCEDURE update_row
2928: ---------------------------------------------------------------------------
2929: ---------------------------------------
2930: -- update_row for:OKS_BILL_SUB_LINES --
2931: ---------------------------------------
2932: PROCEDURE update_row(
2933: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2934: x_return_status OUT NOCOPY VARCHAR2,

Line 3090: -- Set_Attributes for:OKS_BILL_SUB_LINES --

3086: END IF;
3087: RETURN(l_return_status);
3088: END populate_new_record;
3089: -------------------------------------------
3090: -- Set_Attributes for:OKS_BILL_SUB_LINES --
3091: -------------------------------------------
3092: FUNCTION Set_Attributes (
3093: p_bsl_rec IN bsl_rec_type,
3094: x_bsl_rec OUT NOCOPY bsl_rec_type

Line 3127: UPDATE OKS_BILL_SUB_LINES

3123: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3124: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3125: RAISE OKC_API.G_EXCEPTION_ERROR;
3126: END IF;
3127: UPDATE OKS_BILL_SUB_LINES
3128: SET BCL_ID = l_def_bsl_rec.bcl_id,
3129: CLE_ID = l_def_bsl_rec.cle_id,
3130: OBJECT_VERSION_NUMBER = l_def_bsl_rec.object_version_number,
3131: CREATED_BY = l_def_bsl_rec.created_by,

Line 3195: -- update_row for:OKS_BILL_SUB_LINES_V --

3191: '_PVT'
3192: );
3193: END update_row;
3194: -----------------------------------------
3195: -- update_row for:OKS_BILL_SUB_LINES_V --
3196: -----------------------------------------
3197: PROCEDURE update_row(
3198: p_api_version IN NUMBER,
3199: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3370: -- Set_Attributes for:OKS_BILL_SUB_LINES_V --

3366: END IF;
3367: RETURN(l_return_status);
3368: END populate_new_record;
3369: ---------------------------------------------
3370: -- Set_Attributes for:OKS_BILL_SUB_LINES_V --
3371: ---------------------------------------------
3372: FUNCTION Set_Attributes (
3373: p_bslv_rec IN bslv_rec_type,
3374: x_bslv_rec OUT NOCOPY bslv_rec_type

Line 3553: -- delete_row for:OKS_BILL_SUB_LINES --

3549: ---------------------------------------------------------------------------
3550: -- PROCEDURE delete_row
3551: ---------------------------------------------------------------------------
3552: ---------------------------------------
3553: -- delete_row for:OKS_BILL_SUB_LINES --
3554: ---------------------------------------
3555: PROCEDURE delete_row(
3556: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3557: x_return_status OUT NOCOPY VARCHAR2,

Line 3577: DELETE FROM OKS_BILL_SUB_LINES

3573: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3574: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3575: RAISE OKC_API.G_EXCEPTION_ERROR;
3576: END IF;
3577: DELETE FROM OKS_BILL_SUB_LINES
3578: WHERE ID = l_bsl_rec.id;
3579:
3580: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3581: EXCEPTION

Line 3614: -- delete_row for:OKS_BILL_SUB_LINES_V --

3610: '_PVT'
3611: );
3612: END delete_row;
3613: -----------------------------------------
3614: -- delete_row for:OKS_BILL_SUB_LINES_V --
3615: -----------------------------------------
3616: PROCEDURE delete_row(
3617: p_api_version IN NUMBER,
3618: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,