DBA Data[Home] [Help]

APPS.OKC_CONTRACT_PVT dependencies on OKC_CHR_PVT

Line 162: l_chrv_rec OKC_CHR_PVT.chrv_rec_type;

158: x_return_status OUT NOCOPY VARCHAR2,
159: x_contract_number IN OUT NOCOPY OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE) Is
160:
161: l_unique_number_found BOOLEAN := FALSE;
162: l_chrv_rec OKC_CHR_PVT.chrv_rec_type;
163: l_return_status VARCHAR2(1);
164:
165: BEGIN
166: IF (l_debug = 'Y') THEN

Line 205: l_return_status := OKC_CHR_PVT.Is_Unique(l_chrv_rec);

201: -- check for unique contract_number + modifier
202: /* l_chrv_rec.contract_number := x_contract_number;
203: l_chrv_rec.contract_number_modifier := p_modifier;
204:
205: l_return_status := OKC_CHR_PVT.Is_Unique(l_chrv_rec);
206: If (l_return_status = OKC_API.G_RET_STS_SUCCESS) Then
207: l_unique_number_found := TRUE;
208: End If;
209: x_return_status := l_return_status;

Line 425: p_chrv_rec IN OKC_CHR_PVT.chrv_rec_type,

421: p_init_msg_list IN VARCHAR2 ,
422: x_return_status OUT NOCOPY VARCHAR2,
423: x_msg_count OUT NOCOPY NUMBER,
424: x_msg_data OUT NOCOPY VARCHAR2,
425: p_chrv_rec IN OKC_CHR_PVT.chrv_rec_type,
426: x_chrv_rec OUT NOCOPY OKC_CHR_PVT.chrv_rec_type,
427: p_check_access IN VARCHAR2 ) IS
428:
429: l_chrv_rec OKC_CHR_PVT.chrv_rec_type := p_chrv_rec;

Line 426: x_chrv_rec OUT NOCOPY OKC_CHR_PVT.chrv_rec_type,

422: x_return_status OUT NOCOPY VARCHAR2,
423: x_msg_count OUT NOCOPY NUMBER,
424: x_msg_data OUT NOCOPY VARCHAR2,
425: p_chrv_rec IN OKC_CHR_PVT.chrv_rec_type,
426: x_chrv_rec OUT NOCOPY OKC_CHR_PVT.chrv_rec_type,
427: p_check_access IN VARCHAR2 ) IS
428:
429: l_chrv_rec OKC_CHR_PVT.chrv_rec_type := p_chrv_rec;
430: Cursor subclass_csr is

Line 429: l_chrv_rec OKC_CHR_PVT.chrv_rec_type := p_chrv_rec;

425: p_chrv_rec IN OKC_CHR_PVT.chrv_rec_type,
426: x_chrv_rec OUT NOCOPY OKC_CHR_PVT.chrv_rec_type,
427: p_check_access IN VARCHAR2 ) IS
428:
429: l_chrv_rec OKC_CHR_PVT.chrv_rec_type := p_chrv_rec;
430: Cursor subclass_csr is
431: Select meaning
432: from okc_subclasses_v
433: where code=p_chrv_rec.scs_code;

Line 481: OKC_CHR_PVT.Insert_Row(

477: End If;
478:
479: If (x_return_status = OKC_API.G_RET_STS_SUCCESS) Then
480:
481: OKC_CHR_PVT.Insert_Row(
482: p_api_version => p_api_version,
483: p_init_msg_list => p_init_msg_list,
484: x_return_status => x_return_status,
485: x_msg_count => x_msg_count,

Line 537: p_chrv_tbl IN OKC_CHR_PVT.chrv_tbl_type,

533: p_init_msg_list IN VARCHAR2 ,
534: x_return_status OUT NOCOPY VARCHAR2,
535: x_msg_count OUT NOCOPY NUMBER,
536: x_msg_data OUT NOCOPY VARCHAR2,
537: p_chrv_tbl IN OKC_CHR_PVT.chrv_tbl_type,
538: x_chrv_tbl OUT NOCOPY OKC_CHR_PVT.chrv_tbl_type,
539: p_check_access IN VARCHAR2 ) IS
540:
541: BEGIN

Line 538: x_chrv_tbl OUT NOCOPY OKC_CHR_PVT.chrv_tbl_type,

534: x_return_status OUT NOCOPY VARCHAR2,
535: x_msg_count OUT NOCOPY NUMBER,
536: x_msg_data OUT NOCOPY VARCHAR2,
537: p_chrv_tbl IN OKC_CHR_PVT.chrv_tbl_type,
538: x_chrv_tbl OUT NOCOPY OKC_CHR_PVT.chrv_tbl_type,
539: p_check_access IN VARCHAR2 ) IS
540:
541: BEGIN
542: OKC_CHR_PVT.Insert_Row(

Line 542: OKC_CHR_PVT.Insert_Row(

538: x_chrv_tbl OUT NOCOPY OKC_CHR_PVT.chrv_tbl_type,
539: p_check_access IN VARCHAR2 ) IS
540:
541: BEGIN
542: OKC_CHR_PVT.Insert_Row(
543: p_api_version => p_api_version,
544: p_init_msg_list => p_init_msg_list,
545: x_return_status => x_return_status,
546: x_msg_count => x_msg_count,

Line 560: p_chrv_rec IN OKC_CHR_PVT.chrv_rec_type,

556: x_return_status OUT NOCOPY VARCHAR2,
557: x_msg_count OUT NOCOPY NUMBER,
558: x_msg_data OUT NOCOPY VARCHAR2,
559: p_restricted_update IN VARCHAR2 ,
560: p_chrv_rec IN OKC_CHR_PVT.chrv_rec_type,
561: x_chrv_rec OUT NOCOPY OKC_CHR_PVT.chrv_rec_type) IS
562:
563: l_currency_code VARCHAR2(5);
564: l_hstv_rec OKC_K_HISTORY_PVT.hstv_rec_type;

Line 561: x_chrv_rec OUT NOCOPY OKC_CHR_PVT.chrv_rec_type) IS

557: x_msg_count OUT NOCOPY NUMBER,
558: x_msg_data OUT NOCOPY VARCHAR2,
559: p_restricted_update IN VARCHAR2 ,
560: p_chrv_rec IN OKC_CHR_PVT.chrv_rec_type,
561: x_chrv_rec OUT NOCOPY OKC_CHR_PVT.chrv_rec_type) IS
562:
563: l_currency_code VARCHAR2(5);
564: l_hstv_rec OKC_K_HISTORY_PVT.hstv_rec_type;
565: x_hstv_rec OKC_K_HISTORY_PVT.hstv_rec_type;

Line 627: OKC_CHR_PVT.Update_Row(

623: Else
624: l_new_status := p_chrv_rec.sts_code;
625: End If;
626:
627: OKC_CHR_PVT.Update_Row(
628: p_api_version => p_api_version,
629: p_init_msg_list => p_init_msg_list,
630: x_return_status => x_return_status,
631: x_msg_count => x_msg_count,

Line 758: p_chrv_tbl IN OKC_CHR_PVT.chrv_tbl_type,

754: x_return_status OUT NOCOPY VARCHAR2,
755: x_msg_count OUT NOCOPY NUMBER,
756: x_msg_data OUT NOCOPY VARCHAR2,
757: p_restricted_update IN VARCHAR2 ,
758: p_chrv_tbl IN OKC_CHR_PVT.chrv_tbl_type,
759: x_chrv_tbl OUT NOCOPY OKC_CHR_PVT.chrv_tbl_type) IS
760:
761: BEGIN
762: OKC_CHR_PVT.Update_Row(

Line 759: x_chrv_tbl OUT NOCOPY OKC_CHR_PVT.chrv_tbl_type) IS

755: x_msg_count OUT NOCOPY NUMBER,
756: x_msg_data OUT NOCOPY VARCHAR2,
757: p_restricted_update IN VARCHAR2 ,
758: p_chrv_tbl IN OKC_CHR_PVT.chrv_tbl_type,
759: x_chrv_tbl OUT NOCOPY OKC_CHR_PVT.chrv_tbl_type) IS
760:
761: BEGIN
762: OKC_CHR_PVT.Update_Row(
763: p_api_version => p_api_version,

Line 762: OKC_CHR_PVT.Update_Row(

758: p_chrv_tbl IN OKC_CHR_PVT.chrv_tbl_type,
759: x_chrv_tbl OUT NOCOPY OKC_CHR_PVT.chrv_tbl_type) IS
760:
761: BEGIN
762: OKC_CHR_PVT.Update_Row(
763: p_api_version => p_api_version,
764: p_init_msg_list => p_init_msg_list,
765: x_return_status => x_return_status,
766: x_msg_count => x_msg_count,

Line 780: p_chrv_rec IN OKC_CHR_PVT.chrv_rec_type,

776: x_return_status OUT NOCOPY VARCHAR2,
777: x_msg_count OUT NOCOPY NUMBER,
778: x_msg_data OUT NOCOPY VARCHAR2,
779: p_restricted_update IN VARCHAR2 ,
780: p_chrv_rec IN OKC_CHR_PVT.chrv_rec_type,
781: p_control_rec IN control_rec_type,
782: x_chrv_rec OUT NOCOPY OKC_CHR_PVT.chrv_rec_type) IS
783:
784: l_currency_code VARCHAR2(5);

Line 782: x_chrv_rec OUT NOCOPY OKC_CHR_PVT.chrv_rec_type) IS

778: x_msg_data OUT NOCOPY VARCHAR2,
779: p_restricted_update IN VARCHAR2 ,
780: p_chrv_rec IN OKC_CHR_PVT.chrv_rec_type,
781: p_control_rec IN control_rec_type,
782: x_chrv_rec OUT NOCOPY OKC_CHR_PVT.chrv_rec_type) IS
783:
784: l_currency_code VARCHAR2(5);
785: l_hstv_rec OKC_K_HISTORY_PVT.hstv_rec_type;
786: x_hstv_rec OKC_K_HISTORY_PVT.hstv_rec_type;

Line 848: OKC_CHR_PVT.Update_Row(

844: Else
845: l_new_status := p_chrv_rec.sts_code;
846: End If;
847:
848: OKC_CHR_PVT.Update_Row(
849: p_api_version => p_api_version,
850: p_init_msg_list => p_init_msg_list,
851: x_return_status => x_return_status,
852: x_msg_count => x_msg_count,

Line 978: p_chrv_rec IN OKC_CHR_PVT.chrv_rec_type) IS

974: p_init_msg_list IN VARCHAR2 ,
975: x_return_status OUT NOCOPY VARCHAR2,
976: x_msg_count OUT NOCOPY NUMBER,
977: x_msg_data OUT NOCOPY VARCHAR2,
978: p_chrv_rec IN OKC_CHR_PVT.chrv_rec_type) IS
979:
980: l_dummy_val NUMBER;
981: l_major_version FND_ATTACHED_DOCUMENTS.PK2_VALUE%TYPE;
982:

Line 1068: OKC_CHR_PVT.Delete_Row(

1064: p_minor_version => 0,
1065: p_called_from => 'RESTORE_VERSION');
1066: End if;
1067:
1068: OKC_CHR_PVT.Delete_Row(
1069: p_api_version => p_api_version,
1070: p_init_msg_list => p_init_msg_list,
1071: x_return_status => x_return_status,
1072: x_msg_count => x_msg_count,

Line 1181: p_chrv_tbl IN OKC_CHR_PVT.chrv_tbl_type) IS

1177: p_init_msg_list IN VARCHAR2 ,
1178: x_return_status OUT NOCOPY VARCHAR2,
1179: x_msg_count OUT NOCOPY NUMBER,
1180: x_msg_data OUT NOCOPY VARCHAR2,
1181: p_chrv_tbl IN OKC_CHR_PVT.chrv_tbl_type) IS
1182:
1183: BEGIN
1184: OKC_CHR_PVT.Delete_Row(
1185: p_api_version => p_api_version,

Line 1184: OKC_CHR_PVT.Delete_Row(

1180: x_msg_data OUT NOCOPY VARCHAR2,
1181: p_chrv_tbl IN OKC_CHR_PVT.chrv_tbl_type) IS
1182:
1183: BEGIN
1184: OKC_CHR_PVT.Delete_Row(
1185: p_api_version => p_api_version,
1186: p_init_msg_list => p_init_msg_list,
1187: x_return_status => x_return_status,
1188: x_msg_count => x_msg_count,

Line 1199: p_chrv_rec IN OKC_CHR_PVT.chrv_rec_type) IS

1195: p_init_msg_list IN VARCHAR2 ,
1196: x_return_status OUT NOCOPY VARCHAR2,
1197: x_msg_count OUT NOCOPY NUMBER,
1198: x_msg_data OUT NOCOPY VARCHAR2,
1199: p_chrv_rec IN OKC_CHR_PVT.chrv_rec_type) IS
1200:
1201: BEGIN
1202: OKC_CHR_PVT.Lock_Row(
1203: p_api_version => p_api_version,

Line 1202: OKC_CHR_PVT.Lock_Row(

1198: x_msg_data OUT NOCOPY VARCHAR2,
1199: p_chrv_rec IN OKC_CHR_PVT.chrv_rec_type) IS
1200:
1201: BEGIN
1202: OKC_CHR_PVT.Lock_Row(
1203: p_api_version => p_api_version,
1204: p_init_msg_list => p_init_msg_list,
1205: x_return_status => x_return_status,
1206: x_msg_count => x_msg_count,

Line 1217: p_chrv_tbl IN OKC_CHR_PVT.chrv_tbl_type) IS

1213: p_init_msg_list IN VARCHAR2 ,
1214: x_return_status OUT NOCOPY VARCHAR2,
1215: x_msg_count OUT NOCOPY NUMBER,
1216: x_msg_data OUT NOCOPY VARCHAR2,
1217: p_chrv_tbl IN OKC_CHR_PVT.chrv_tbl_type) IS
1218:
1219: BEGIN
1220: OKC_CHR_PVT.Lock_Row(
1221: p_api_version => p_api_version,

Line 1220: OKC_CHR_PVT.Lock_Row(

1216: x_msg_data OUT NOCOPY VARCHAR2,
1217: p_chrv_tbl IN OKC_CHR_PVT.chrv_tbl_type) IS
1218:
1219: BEGIN
1220: OKC_CHR_PVT.Lock_Row(
1221: p_api_version => p_api_version,
1222: p_init_msg_list => p_init_msg_list,
1223: x_return_status => x_return_status,
1224: x_msg_count => x_msg_count,

Line 1235: p_chrv_rec IN OKC_CHR_PVT.chrv_rec_type) IS

1231: p_init_msg_list IN VARCHAR2 ,
1232: x_return_status OUT NOCOPY VARCHAR2,
1233: x_msg_count OUT NOCOPY NUMBER,
1234: x_msg_data OUT NOCOPY VARCHAR2,
1235: p_chrv_rec IN OKC_CHR_PVT.chrv_rec_type) IS
1236:
1237: BEGIN
1238: OKC_CHR_PVT.Validate_Row(
1239: p_api_version => p_api_version,

Line 1238: OKC_CHR_PVT.Validate_Row(

1234: x_msg_data OUT NOCOPY VARCHAR2,
1235: p_chrv_rec IN OKC_CHR_PVT.chrv_rec_type) IS
1236:
1237: BEGIN
1238: OKC_CHR_PVT.Validate_Row(
1239: p_api_version => p_api_version,
1240: p_init_msg_list => p_init_msg_list,
1241: x_return_status => x_return_status,
1242: x_msg_count => x_msg_count,

Line 1253: p_chrv_tbl IN OKC_CHR_PVT.chrv_tbl_type) IS

1249: p_init_msg_list IN VARCHAR2 ,
1250: x_return_status OUT NOCOPY VARCHAR2,
1251: x_msg_count OUT NOCOPY NUMBER,
1252: x_msg_data OUT NOCOPY VARCHAR2,
1253: p_chrv_tbl IN OKC_CHR_PVT.chrv_tbl_type) IS
1254:
1255: BEGIN
1256: OKC_CHR_PVT.Validate_Row(
1257: p_api_version => p_api_version,

Line 1256: OKC_CHR_PVT.Validate_Row(

1252: x_msg_data OUT NOCOPY VARCHAR2,
1253: p_chrv_tbl IN OKC_CHR_PVT.chrv_tbl_type) IS
1254:
1255: BEGIN
1256: OKC_CHR_PVT.Validate_Row(
1257: p_api_version => p_api_version,
1258: p_init_msg_list => p_init_msg_list,
1259: x_return_status => x_return_status,
1260: x_msg_count => x_msg_count,

Line 4113: OKC_CHR_PVT.add_language;

4109: END validate_contract_access;
4110:
4111: PROCEDURE add_language IS
4112: BEGIN
4113: OKC_CHR_PVT.add_language;
4114: OKC_CLE_PVT.add_language;
4115: END add_language;
4116:
4117: PROCEDURE Get_Active_Process (