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 620: OKC_CHR_PVT.Update_Row(

616: Else
617: l_new_status := p_chrv_rec.sts_code;
618: End If;
619:
620: OKC_CHR_PVT.Update_Row(
621: p_api_version => p_api_version,
622: p_init_msg_list => p_init_msg_list,
623: x_return_status => x_return_status,
624: x_msg_count => x_msg_count,

Line 729: p_chrv_tbl IN OKC_CHR_PVT.chrv_tbl_type,

725: x_return_status OUT NOCOPY VARCHAR2,
726: x_msg_count OUT NOCOPY NUMBER,
727: x_msg_data OUT NOCOPY VARCHAR2,
728: p_restricted_update IN VARCHAR2 ,
729: p_chrv_tbl IN OKC_CHR_PVT.chrv_tbl_type,
730: x_chrv_tbl OUT NOCOPY OKC_CHR_PVT.chrv_tbl_type) IS
731:
732: BEGIN
733: OKC_CHR_PVT.Update_Row(

Line 730: x_chrv_tbl OUT NOCOPY OKC_CHR_PVT.chrv_tbl_type) IS

726: x_msg_count OUT NOCOPY NUMBER,
727: x_msg_data OUT NOCOPY VARCHAR2,
728: p_restricted_update IN VARCHAR2 ,
729: p_chrv_tbl IN OKC_CHR_PVT.chrv_tbl_type,
730: x_chrv_tbl OUT NOCOPY OKC_CHR_PVT.chrv_tbl_type) IS
731:
732: BEGIN
733: OKC_CHR_PVT.Update_Row(
734: p_api_version => p_api_version,

Line 733: OKC_CHR_PVT.Update_Row(

729: p_chrv_tbl IN OKC_CHR_PVT.chrv_tbl_type,
730: x_chrv_tbl OUT NOCOPY OKC_CHR_PVT.chrv_tbl_type) IS
731:
732: BEGIN
733: OKC_CHR_PVT.Update_Row(
734: p_api_version => p_api_version,
735: p_init_msg_list => p_init_msg_list,
736: x_return_status => x_return_status,
737: x_msg_count => x_msg_count,

Line 751: p_chrv_rec IN OKC_CHR_PVT.chrv_rec_type,

747: x_return_status OUT NOCOPY VARCHAR2,
748: x_msg_count OUT NOCOPY NUMBER,
749: x_msg_data OUT NOCOPY VARCHAR2,
750: p_restricted_update IN VARCHAR2 ,
751: p_chrv_rec IN OKC_CHR_PVT.chrv_rec_type,
752: p_control_rec IN control_rec_type,
753: x_chrv_rec OUT NOCOPY OKC_CHR_PVT.chrv_rec_type) IS
754:
755: l_currency_code VARCHAR2(5);

Line 753: x_chrv_rec OUT NOCOPY OKC_CHR_PVT.chrv_rec_type) IS

749: x_msg_data OUT NOCOPY VARCHAR2,
750: p_restricted_update IN VARCHAR2 ,
751: p_chrv_rec IN OKC_CHR_PVT.chrv_rec_type,
752: p_control_rec IN control_rec_type,
753: x_chrv_rec OUT NOCOPY OKC_CHR_PVT.chrv_rec_type) IS
754:
755: l_currency_code VARCHAR2(5);
756: l_hstv_rec OKC_K_HISTORY_PVT.hstv_rec_type;
757: x_hstv_rec OKC_K_HISTORY_PVT.hstv_rec_type;

Line 812: OKC_CHR_PVT.Update_Row(

808: Else
809: l_new_status := p_chrv_rec.sts_code;
810: End If;
811:
812: OKC_CHR_PVT.Update_Row(
813: p_api_version => p_api_version,
814: p_init_msg_list => p_init_msg_list,
815: x_return_status => x_return_status,
816: x_msg_count => x_msg_count,

Line 920: p_chrv_rec IN OKC_CHR_PVT.chrv_rec_type) IS

916: p_init_msg_list IN VARCHAR2 ,
917: x_return_status OUT NOCOPY VARCHAR2,
918: x_msg_count OUT NOCOPY NUMBER,
919: x_msg_data OUT NOCOPY VARCHAR2,
920: p_chrv_rec IN OKC_CHR_PVT.chrv_rec_type) IS
921:
922: l_dummy_val NUMBER;
923: l_major_version FND_ATTACHED_DOCUMENTS.PK2_VALUE%TYPE;
924:

Line 1010: OKC_CHR_PVT.Delete_Row(

1006: p_minor_version => 0,
1007: p_called_from => 'RESTORE_VERSION');
1008: End if;
1009:
1010: OKC_CHR_PVT.Delete_Row(
1011: p_api_version => p_api_version,
1012: p_init_msg_list => p_init_msg_list,
1013: x_return_status => x_return_status,
1014: x_msg_count => x_msg_count,

Line 1123: p_chrv_tbl IN OKC_CHR_PVT.chrv_tbl_type) IS

1119: p_init_msg_list IN VARCHAR2 ,
1120: x_return_status OUT NOCOPY VARCHAR2,
1121: x_msg_count OUT NOCOPY NUMBER,
1122: x_msg_data OUT NOCOPY VARCHAR2,
1123: p_chrv_tbl IN OKC_CHR_PVT.chrv_tbl_type) IS
1124:
1125: BEGIN
1126: OKC_CHR_PVT.Delete_Row(
1127: p_api_version => p_api_version,

Line 1126: OKC_CHR_PVT.Delete_Row(

1122: x_msg_data OUT NOCOPY VARCHAR2,
1123: p_chrv_tbl IN OKC_CHR_PVT.chrv_tbl_type) IS
1124:
1125: BEGIN
1126: OKC_CHR_PVT.Delete_Row(
1127: p_api_version => p_api_version,
1128: p_init_msg_list => p_init_msg_list,
1129: x_return_status => x_return_status,
1130: x_msg_count => x_msg_count,

Line 1141: p_chrv_rec IN OKC_CHR_PVT.chrv_rec_type) IS

1137: p_init_msg_list IN VARCHAR2 ,
1138: x_return_status OUT NOCOPY VARCHAR2,
1139: x_msg_count OUT NOCOPY NUMBER,
1140: x_msg_data OUT NOCOPY VARCHAR2,
1141: p_chrv_rec IN OKC_CHR_PVT.chrv_rec_type) IS
1142:
1143: BEGIN
1144: OKC_CHR_PVT.Lock_Row(
1145: p_api_version => p_api_version,

Line 1144: OKC_CHR_PVT.Lock_Row(

1140: x_msg_data OUT NOCOPY VARCHAR2,
1141: p_chrv_rec IN OKC_CHR_PVT.chrv_rec_type) IS
1142:
1143: BEGIN
1144: OKC_CHR_PVT.Lock_Row(
1145: p_api_version => p_api_version,
1146: p_init_msg_list => p_init_msg_list,
1147: x_return_status => x_return_status,
1148: x_msg_count => x_msg_count,

Line 1159: p_chrv_tbl IN OKC_CHR_PVT.chrv_tbl_type) IS

1155: p_init_msg_list IN VARCHAR2 ,
1156: x_return_status OUT NOCOPY VARCHAR2,
1157: x_msg_count OUT NOCOPY NUMBER,
1158: x_msg_data OUT NOCOPY VARCHAR2,
1159: p_chrv_tbl IN OKC_CHR_PVT.chrv_tbl_type) IS
1160:
1161: BEGIN
1162: OKC_CHR_PVT.Lock_Row(
1163: p_api_version => p_api_version,

Line 1162: OKC_CHR_PVT.Lock_Row(

1158: x_msg_data OUT NOCOPY VARCHAR2,
1159: p_chrv_tbl IN OKC_CHR_PVT.chrv_tbl_type) IS
1160:
1161: BEGIN
1162: OKC_CHR_PVT.Lock_Row(
1163: p_api_version => p_api_version,
1164: p_init_msg_list => p_init_msg_list,
1165: x_return_status => x_return_status,
1166: x_msg_count => x_msg_count,

Line 1177: p_chrv_rec IN OKC_CHR_PVT.chrv_rec_type) IS

1173: p_init_msg_list IN VARCHAR2 ,
1174: x_return_status OUT NOCOPY VARCHAR2,
1175: x_msg_count OUT NOCOPY NUMBER,
1176: x_msg_data OUT NOCOPY VARCHAR2,
1177: p_chrv_rec IN OKC_CHR_PVT.chrv_rec_type) IS
1178:
1179: BEGIN
1180: OKC_CHR_PVT.Validate_Row(
1181: p_api_version => p_api_version,

Line 1180: OKC_CHR_PVT.Validate_Row(

1176: x_msg_data OUT NOCOPY VARCHAR2,
1177: p_chrv_rec IN OKC_CHR_PVT.chrv_rec_type) IS
1178:
1179: BEGIN
1180: OKC_CHR_PVT.Validate_Row(
1181: p_api_version => p_api_version,
1182: p_init_msg_list => p_init_msg_list,
1183: x_return_status => x_return_status,
1184: x_msg_count => x_msg_count,

Line 1195: p_chrv_tbl IN OKC_CHR_PVT.chrv_tbl_type) IS

1191: p_init_msg_list IN VARCHAR2 ,
1192: x_return_status OUT NOCOPY VARCHAR2,
1193: x_msg_count OUT NOCOPY NUMBER,
1194: x_msg_data OUT NOCOPY VARCHAR2,
1195: p_chrv_tbl IN OKC_CHR_PVT.chrv_tbl_type) IS
1196:
1197: BEGIN
1198: OKC_CHR_PVT.Validate_Row(
1199: p_api_version => p_api_version,

Line 1198: OKC_CHR_PVT.Validate_Row(

1194: x_msg_data OUT NOCOPY VARCHAR2,
1195: p_chrv_tbl IN OKC_CHR_PVT.chrv_tbl_type) IS
1196:
1197: BEGIN
1198: OKC_CHR_PVT.Validate_Row(
1199: p_api_version => p_api_version,
1200: p_init_msg_list => p_init_msg_list,
1201: x_return_status => x_return_status,
1202: x_msg_count => x_msg_count,

Line 4055: OKC_CHR_PVT.add_language;

4051: END validate_contract_access;
4052:
4053: PROCEDURE add_language IS
4054: BEGIN
4055: OKC_CHR_PVT.add_language;
4056: OKC_CLE_PVT.add_language;
4057: END add_language;
4058:
4059: PROCEDURE Get_Active_Process (