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_BCL_PVT dependencies on OKS_BILL_CONT_LINES_V

Line 130: -- FUNCTION get_rec for: OKS_BILL_CONT_LINES_V

126: BEGIN
127: RETURN(get_rec(p_bcl_rec, l_row_notfound));
128: END get_rec;
129: ---------------------------------------------------------------------------
130: -- FUNCTION get_rec for: OKS_BILL_CONT_LINES_V
131: ---------------------------------------------------------------------------
132: FUNCTION get_rec (
133: p_bclv_rec IN bclv_rec_type,
134: x_no_data_found OUT NOCOPY BOOLEAN

Line 170: FROM Oks_Bill_Cont_Lines_V

166: CREATION_DATE,
167: LAST_UPDATED_BY,
168: LAST_UPDATE_DATE,
169: LAST_UPDATE_LOGIN
170: FROM Oks_Bill_Cont_Lines_V
171: WHERE oks_bill_cont_lines_v.id = p_id;
172: l_okc_bclv_pk okc_bclv_pk_csr%ROWTYPE;
173: l_bclv_rec bclv_rec_type;
174: BEGIN

Line 171: WHERE oks_bill_cont_lines_v.id = p_id;

167: LAST_UPDATED_BY,
168: LAST_UPDATE_DATE,
169: LAST_UPDATE_LOGIN
170: FROM Oks_Bill_Cont_Lines_V
171: WHERE oks_bill_cont_lines_v.id = p_id;
172: l_okc_bclv_pk okc_bclv_pk_csr%ROWTYPE;
173: l_bclv_rec bclv_rec_type;
174: BEGIN
175: x_no_data_found := TRUE;

Line 225: -- FUNCTION null_out_defaults for: OKS_BILL_CONT_LINES_V --

221: RETURN(get_rec(p_bclv_rec, l_row_notfound));
222: END get_rec;
223:
224: -----------------------------------------------------------
225: -- FUNCTION null_out_defaults for: OKS_BILL_CONT_LINES_V --
226: -----------------------------------------------------------
227: FUNCTION null_out_defaults (
228: p_bclv_rec IN bclv_rec_type
229: ) RETURN bclv_rec_type IS

Line 547: p_view_name => 'OKS_BILL_CONT_LINES_V'

543: -- call column length utility
544: /*
545: OKC_UTIL.CHECK_LENGTH
546: (
547: p_view_name => 'OKS_BILL_CONT_LINES_V'
548: ,p_col_name => 'Amount'
549: ,p_col_value => P_amount
550: ,x_return_status => l_return_status
551: );

Line 601: p_view_name => 'OKS_BILL_CONT_LINES_V'

597:
598: /*
599: OKC_UTIL.CHECK_LENGTH
600: (
601: p_view_name => 'OKS_BILL_CONT_LINES_V'
602: ,p_col_name => 'Bill_Action'
603: ,p_col_value => P_Bill_Action
604: ,x_return_status => l_return_status
605: );

Line 655: p_view_name => 'OKS_BILL_CONT_LINES_V'

651:
652: /*
653: OKC_UTIL.CHECK_LENGTH
654: (
655: p_view_name => 'OKS_BILL_CONT_LINES_V'
656: ,p_col_name => 'Sent_yn'
657: ,p_col_value => P_sent_yn
658: ,x_return_status => l_return_status
659: );

Line 710: p_view_name => 'OKS_BILL_CONT_LINES_V'

706:
707: /*
708: OKC_UTIL.CHECK_LENGTH
709: (
710: p_view_name => 'OKS_BILL_CONT_LINES_V'
711: ,p_col_name => 'currency_code'
712: ,p_col_value => P_currency_code
713: ,x_return_status => l_return_status
714: );

Line 821: p_view_name => 'OKS_BILL_CONT_LINES_V'

817: -- call column length utility
818: /*
819: OKC_UTIL.CHECK_LENGTH
820: (
821: p_view_name => 'OKS_BILL_CONT_LINES_V'
822: ,p_col_name => 'attribute1'
823: ,p_col_value => p_attribute1
824: ,x_return_status => l_return_status
825: );

Line 871: p_view_name => 'OKS_BILL_CONT_LINES_V'

867: -- call column length utility
868: /*
869: OKC_UTIL.CHECK_LENGTH
870: (
871: p_view_name => 'OKS_BILL_CONT_LINES_V'
872: ,p_col_name => 'attribute2'
873: ,p_col_value => p_attribute2
874: ,x_return_status => l_return_status
875: );

Line 922: p_view_name => 'OKS_BILL_CONT_LINES_V'

918: -- call column length utility
919: /*
920: OKC_UTIL.CHECK_LENGTH
921: (
922: p_view_name => 'OKS_BILL_CONT_LINES_V'
923: ,p_col_name => 'attribute3'
924: ,p_col_value => p_attribute3
925: ,x_return_status => l_return_status
926: );

Line 972: p_view_name => 'OKS_BILL_CONT_LINES_V'

968: -- call column length utility
969: /*
970: OKC_UTIL.CHECK_LENGTH
971: (
972: p_view_name => 'OKS_BILL_CONT_LINES_V'
973: ,p_col_name => 'attribute4'
974: ,p_col_value => p_attribute4
975: ,x_return_status => l_return_status
976: );

Line 1023: p_view_name => 'OKS_BILL_CONT_LINES_V'

1019: -- call column length utility
1020: /*
1021: OKC_UTIL.CHECK_LENGTH
1022: (
1023: p_view_name => 'OKS_BILL_CONT_LINES_V'
1024: ,p_col_name => 'attribute5'
1025: ,p_col_value => p_attribute5
1026: ,x_return_status => l_return_status
1027: );

Line 1074: p_view_name => 'OKS_BILL_CONT_LINES_V'

1070: -- call column length utility
1071: /*
1072: OKC_UTIL.CHECK_LENGTH
1073: (
1074: p_view_name => 'OKS_BILL_CONT_LINES_V'
1075: ,p_col_name => 'attribute6'
1076: ,p_col_value => p_attribute6
1077: ,x_return_status => l_return_status
1078: );

Line 1125: p_view_name => 'OKS_BILL_CONT_LINES_V'

1121: -- call column length utility
1122: /*
1123: OKC_UTIL.CHECK_LENGTH
1124: (
1125: p_view_name => 'OKS_BILL_CONT_LINES_V'
1126: ,p_col_name => 'attribute7'
1127: ,p_col_value => p_attribute7
1128: ,x_return_status => l_return_status
1129: );

Line 1177: p_view_name => 'OKS_BILL_CONT_LINES_V'

1173: -- call column length utility
1174: /*
1175: OKC_UTIL.CHECK_LENGTH
1176: (
1177: p_view_name => 'OKS_BILL_CONT_LINES_V'
1178: ,p_col_name => 'attribute8'
1179: ,p_col_value => p_attribute8
1180: ,x_return_status => l_return_status
1181: );

Line 1229: p_view_name => 'OKS_BILL_CONT_LINES_V'

1225: -- call column length utility
1226: /*
1227: OKC_UTIL.CHECK_LENGTH
1228: (
1229: p_view_name => 'OKS_BILL_CONT_LINES_V'
1230: ,p_col_name => 'attribute9'
1231: ,p_col_value => p_attribute9
1232: ,x_return_status => l_return_status
1233: );

Line 1280: p_view_name => 'OKS_BILL_CONT_LINES_V'

1276: -- call column length utility
1277: /*
1278: OKC_UTIL.CHECK_LENGTH
1279: (
1280: p_view_name => 'OKS_BILL_CONT_LINES_V'
1281: ,p_col_name => 'attribute10'
1282: ,p_col_value => p_attribute10
1283: ,x_return_status => l_return_status
1284: );

Line 1333: p_view_name => 'OKS_BILL_CONT_LINES_V'

1329:
1330: /*
1331: OKC_UTIL.CHECK_LENGTH
1332: (
1333: p_view_name => 'OKS_BILL_CONT_LINES_V'
1334: ,p_col_name => 'attribute11'
1335: ,p_col_value => p_attribute11
1336: ,x_return_status => l_return_status
1337: );

Line 1386: p_view_name => 'OKS_BILL_CONT_LINES_V'

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

Line 1439: p_view_name => 'OKS_BILL_CONT_LINES_V'

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

Line 1492: p_view_name => 'OKS_BILL_CONT_LINES_V'

1488: -- call column length utility
1489: /*
1490: OKC_UTIL.CHECK_LENGTH
1491: (
1492: p_view_name => 'OKS_BILL_CONT_LINES_V'
1493: ,p_col_name => 'attribute14'
1494: ,p_col_value => p_attribute14
1495: ,x_return_status => l_return_status
1496: );

Line 1543: p_view_name => 'OKS_BILL_CONT_LINES_V'

1539: -- call column length utility
1540: /*
1541: OKC_UTIL.CHECK_LENGTH
1542: (
1543: p_view_name => 'OKS_BILL_CONT_LINES_V'
1544: ,p_col_name => 'attribute15'
1545: ,p_col_value => p_attribute15
1546: ,x_return_status => l_return_status
1547: );

Line 1582: -- Validate_Attributes for:OKS_BILL_CONT_LINES_V --

1578: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1579: END validate_attribute15;
1580:
1581: ---------------------------------------------------
1582: -- Validate_Attributes for:OKS_BILL_CONT_LINES_V --
1583: ---------------------------------------------------
1584: FUNCTION Validate_Attributes (
1585: p_bclv_rec IN bclv_rec_type
1586: )

Line 1594: OKC_UTIL.ADD_VIEW('OKS_BILL_CONT_LINES_V',x_return_status);

1590:
1591: Begin
1592: -- call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
1593:
1594: OKC_UTIL.ADD_VIEW('OKS_BILL_CONT_LINES_V',x_return_status);
1595:
1596: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1597: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1598: -- need to leave

Line 2065: -- Validate_Attributes for:OKS_BILL_CONT_LINES_V --

2061:
2062:
2063: /*
2064: ---------------------------------------------------
2065: -- Validate_Attributes for:OKS_BILL_CONT_LINES_V --
2066: ---------------------------------------------------
2067: FUNCTION Validate_Attributes (
2068: p_bclv_rec IN bclv_rec_type
2069: ) RETURN VARCHAR2 IS

Line 2111: -- Validate_Record for:OKS_BILL_CONT_LINES_V --

2107: -- PROCEDURE Validate_Record
2108: ---------------------------------------------------------------------------
2109: */
2110: -----------------------------------------------
2111: -- Validate_Record for:OKS_BILL_CONT_LINES_V --
2112: -----------------------------------------------
2113: FUNCTION Validate_Record (
2114: p_bclv_rec IN bclv_rec_type
2115: ) RETURN VARCHAR2 IS

Line 2317: -- validate_row for:OKS_BILL_CONT_LINES_V --

2313: ---------------------------------------------------------------------------
2314: -- PROCEDURE validate_row
2315: ---------------------------------------------------------------------------
2316: --------------------------------------------
2317: -- validate_row for:OKS_BILL_CONT_LINES_V --
2318: --------------------------------------------
2319: PROCEDURE validate_row(
2320: p_api_version IN NUMBER,
2321: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2626: -- insert_row for:OKS_BILL_CONT_LINES_V --

2622: '_PVT'
2623: );
2624: END insert_row;
2625: ------------------------------------------
2626: -- insert_row for:OKS_BILL_CONT_LINES_V --
2627: ------------------------------------------
2628: PROCEDURE insert_row(
2629: p_api_version IN NUMBER,
2630: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2660: -- Set_Attributes for:OKS_BILL_CONT_LINES_V --

2656: l_bclv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2657: RETURN(l_bclv_rec);
2658: END fill_who_columns;
2659: ----------------------------------------------
2660: -- Set_Attributes for:OKS_BILL_CONT_LINES_V --
2661: ----------------------------------------------
2662: FUNCTION Set_Attributes (
2663: p_bclv_rec IN bclv_rec_type,
2664: x_bclv_rec OUT NOCOPY bclv_rec_type

Line 2946: -- lock_row for:OKS_BILL_CONT_LINES_V --

2942: '_PVT'
2943: );
2944: END lock_row;
2945: ----------------------------------------
2946: -- lock_row for:OKS_BILL_CONT_LINES_V --
2947: ----------------------------------------
2948: PROCEDURE lock_row(
2949: p_api_version IN NUMBER,
2950: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3364: -- update_row for:OKS_BILL_CONT_LINES_V --

3360: '_PVT'
3361: );
3362: END update_row;
3363: ------------------------------------------
3364: -- update_row for:OKS_BILL_CONT_LINES_V --
3365: ------------------------------------------
3366: PROCEDURE update_row(
3367: p_api_version IN NUMBER,
3368: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3543: -- Set_Attributes for:OKS_BILL_CONT_LINES_V --

3539: END IF;
3540: RETURN(l_return_status);
3541: END populate_new_record;
3542: ----------------------------------------------
3543: -- Set_Attributes for:OKS_BILL_CONT_LINES_V --
3544: ----------------------------------------------
3545: FUNCTION Set_Attributes (
3546: p_bclv_rec IN bclv_rec_type,
3547: x_bclv_rec OUT NOCOPY bclv_rec_type

Line 3787: -- delete_row for:OKS_BILL_CONT_LINES_V --

3783: '_PVT'
3784: );
3785: END delete_row;
3786: ------------------------------------------
3787: -- delete_row for:OKS_BILL_CONT_LINES_V --
3788: ------------------------------------------
3789: PROCEDURE delete_row(
3790: p_api_version IN NUMBER,
3791: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,