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_MASSCHANGE_PVT dependencies on OKC_CONTRACT_PUB

Line 7132: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;

7128:
7129: l_criteria_rec criteria_rec_type;
7130: l_eligible_contracts_tbl eligible_contracts_tbl;
7131:
7132: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
7133: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
7134:
7135: l_chrv_rec_in okc_contract_pub.chrv_rec_type;
7136: l_chrv_rec_out okc_contract_pub.chrv_rec_type;

Line 7133: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;

7129: l_criteria_rec criteria_rec_type;
7130: l_eligible_contracts_tbl eligible_contracts_tbl;
7131:
7132: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
7133: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
7134:
7135: l_chrv_rec_in okc_contract_pub.chrv_rec_type;
7136: l_chrv_rec_out okc_contract_pub.chrv_rec_type;
7137: l_chrv_rec_null okc_contract_pub.chrv_rec_type := Null;

Line 7135: l_chrv_rec_in okc_contract_pub.chrv_rec_type;

7131:
7132: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
7133: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
7134:
7135: l_chrv_rec_in okc_contract_pub.chrv_rec_type;
7136: l_chrv_rec_out okc_contract_pub.chrv_rec_type;
7137: l_chrv_rec_null okc_contract_pub.chrv_rec_type := Null;
7138:
7139: l_clev_tbl_in okc_contract_pub.clev_tbl_type;

Line 7136: l_chrv_rec_out okc_contract_pub.chrv_rec_type;

7132: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
7133: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
7134:
7135: l_chrv_rec_in okc_contract_pub.chrv_rec_type;
7136: l_chrv_rec_out okc_contract_pub.chrv_rec_type;
7137: l_chrv_rec_null okc_contract_pub.chrv_rec_type := Null;
7138:
7139: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
7140: l_clev_tbl_out okc_contract_pub.clev_tbl_type;

Line 7137: l_chrv_rec_null okc_contract_pub.chrv_rec_type := Null;

7133: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
7134:
7135: l_chrv_rec_in okc_contract_pub.chrv_rec_type;
7136: l_chrv_rec_out okc_contract_pub.chrv_rec_type;
7137: l_chrv_rec_null okc_contract_pub.chrv_rec_type := Null;
7138:
7139: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
7140: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
7141:

Line 7139: l_clev_tbl_in okc_contract_pub.clev_tbl_type;

7135: l_chrv_rec_in okc_contract_pub.chrv_rec_type;
7136: l_chrv_rec_out okc_contract_pub.chrv_rec_type;
7137: l_chrv_rec_null okc_contract_pub.chrv_rec_type := Null;
7138:
7139: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
7140: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
7141:
7142: l_khrv_rec_type_in oks_contract_hdr_pub.khrv_rec_type ;
7143: l_khrv_rec_type_out oks_contract_hdr_pub.khrv_rec_type ;

Line 7140: l_clev_tbl_out okc_contract_pub.clev_tbl_type;

7136: l_chrv_rec_out okc_contract_pub.chrv_rec_type;
7137: l_chrv_rec_null okc_contract_pub.chrv_rec_type := Null;
7138:
7139: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
7140: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
7141:
7142: l_khrv_rec_type_in oks_contract_hdr_pub.khrv_rec_type ;
7143: l_khrv_rec_type_out oks_contract_hdr_pub.khrv_rec_type ;
7144:

Line 7320: x_clev_tbl OUT NOCOPY okc_contract_pub.clev_tbl_type)

7316: p_attr IN Varchar2,
7317: p_old_value IN Varchar2,
7318: p_new_value IN Varchar2,
7319: x_return_status OUT NOCOPY Varchar2,
7320: x_clev_tbl OUT NOCOPY okc_contract_pub.clev_tbl_type)
7321: AS
7322: TYPE t_cont_lines IS REF CURSOR;
7323:
7324: v_CurContLine t_cont_lines;

Line 7987: OKC_CONTRACT_PUB.lock_contract_header (

7983:
7984: l_chrv_tbl_in(1).id := l_eligible_contracts_tbl(i).contract_id;
7985: l_chrv_tbl_in(1).object_version_number := l_eligible_contracts_tbl(i).object_version_number;
7986:
7987: OKC_CONTRACT_PUB.lock_contract_header (
7988: p_api_version => l_api_version,
7989: p_init_msg_list => l_init_msg_list,
7990: x_return_status => l_return_status,
7991: x_msg_count => l_msg_count,

Line 8010: OKC_CONTRACT_PUB.lock_contract_line(

8006: IF l_return_status = G_RET_STS_SUCCESS THEN
8007:
8008:
8009: LOG_MESSAGES('Locking contract lines for update, lines count:'||l_clev_tbl_in.COUNT);
8010: OKC_CONTRACT_PUB.lock_contract_line(
8011: p_api_version => l_api_version,
8012: p_init_msg_list => l_init_msg_list,
8013: x_return_status => l_return_status,
8014: x_msg_count => l_msg_count,

Line 8052: OKC_CONTRACT_PUB.update_contract_header (

8048: l_chrv_rec_in.start_date := to_date(l_new_value,'YYYY/MM/DD HH24:MI:SS');
8049: l_chrv_rec_in.sts_code := l_sts_code;
8050:
8051: LOG_MESSAGES('updating contract header with new value:'||l_new_value);
8052: OKC_CONTRACT_PUB.update_contract_header (
8053: p_api_version => l_api_version,
8054: p_init_msg_list => l_init_msg_list,
8055: x_return_status => l_return_status,
8056: x_msg_count => l_msg_count,

Line 8070: OKC_CONTRACT_PUB.update_contract_line(

8066: l_clev_tbl_in(j).start_date := to_date(l_new_value,'YYYY/MM/DD HH24:MI:SS');
8067: l_clev_tbl_in(j).sts_code := l_sts_code;
8068: END LOOP;
8069: LOG_MESSAGES('updating contract lines with new value:'||l_new_value);
8070: OKC_CONTRACT_PUB.update_contract_line(
8071: p_api_version => l_api_version,
8072: p_init_msg_list => l_init_msg_list,
8073: x_return_status => l_return_status,
8074: x_msg_count => l_msg_count,

Line 8247: OKC_CONTRACT_PUB.lock_contract_header (

8243:
8244: l_chrv_tbl_in(1).id := l_eligible_contracts_tbl(i).contract_id;
8245: l_chrv_tbl_in(1).object_version_number := l_eligible_contracts_tbl(i).object_version_number;
8246:
8247: OKC_CONTRACT_PUB.lock_contract_header (
8248: p_api_version => l_api_version,
8249: p_init_msg_list => l_init_msg_list,
8250: x_return_status => l_return_status,
8251: x_msg_count => l_msg_count,

Line 8268: OKC_CONTRACT_PUB.lock_contract_line(

8264: x_clev_tbl => l_clev_tbl_in);
8265:
8266: IF l_return_status = G_RET_STS_SUCCESS THEN
8267: LOG_MESSAGES('Locking contract lines for update, lines count:'||l_clev_tbl_in.COUNT);
8268: OKC_CONTRACT_PUB.lock_contract_line(
8269: p_api_version => l_api_version,
8270: p_init_msg_list => l_init_msg_list,
8271: x_return_status => l_return_status,
8272: x_msg_count => l_msg_count,

Line 8310: OKC_CONTRACT_PUB.update_contract_header (

8306: l_chrv_rec_in.end_date := to_date(l_new_value,'YYYY/MM/DD HH24:MI:SS');
8307: l_chrv_rec_in.sts_code := l_sts_code;
8308:
8309: LOG_MESSAGES('updating contract header with new value:'||l_new_value);
8310: OKC_CONTRACT_PUB.update_contract_header (
8311: p_api_version => l_api_version,
8312: p_init_msg_list => l_init_msg_list,
8313: x_return_status => l_return_status,
8314: x_msg_count => l_msg_count,

Line 8328: OKC_CONTRACT_PUB.update_contract_line(

8324: l_clev_tbl_in(j).end_date := to_date(l_new_value,'YYYY/MM/DD HH24:MI:SS');
8325: l_clev_tbl_in(j).sts_code := l_sts_code;
8326: END LOOP;
8327: LOG_MESSAGES('updating contract lines with new value:'||l_new_value);
8328: OKC_CONTRACT_PUB.update_contract_line(
8329: p_api_version => l_api_version,
8330: p_init_msg_list => l_init_msg_list,
8331: x_return_status => l_return_status,
8332: x_msg_count => l_msg_count,

Line 9046: OKC_CONTRACT_PUB.lock_contract_header(

9042: l_chrv_rec_in.id := l_eligible_contracts_tbl(i).contract_id ;
9043: l_chrv_rec_in.object_version_number := l_eligible_contracts_tbl(i).object_version_number;
9044:
9045:
9046: OKC_CONTRACT_PUB.lock_contract_header(
9047: p_api_version => l_api_version,
9048: p_init_msg_list => l_init_msg_list,
9049: x_return_status => l_return_status,
9050: x_msg_count => l_msg_count,

Line 9059: OKC_CONTRACT_PUB.update_contract_header(

9055: IF l_return_status = G_RET_STS_SUCCESS THEN
9056:
9057: l_chrv_rec_in.ship_to_site_use_id := l_new_value_id;
9058:
9059: OKC_CONTRACT_PUB.update_contract_header(
9060: p_api_version => l_api_version,
9061: p_init_msg_list => l_init_msg_list,
9062: x_return_status => l_return_status,
9063: x_msg_count => l_msg_count,

Line 9117: OKC_CONTRACT_PUB.lock_contract_header(

9113:
9114: l_chrv_rec_in.id := l_eligible_contracts_tbl(i).contract_id ;
9115: l_chrv_rec_in.object_version_number := l_eligible_contracts_tbl(i).object_version_number;
9116:
9117: OKC_CONTRACT_PUB.lock_contract_header(
9118: p_api_version => l_api_version,
9119: p_init_msg_list => l_init_msg_list,
9120: x_return_status => l_return_status,
9121: x_msg_count => l_msg_count,

Line 9130: OKC_CONTRACT_PUB.update_contract_header(

9126: IF l_return_status = G_RET_STS_SUCCESS THEN
9127:
9128: l_chrv_rec_in.payment_term_id := l_new_value_id;
9129:
9130: OKC_CONTRACT_PUB.update_contract_header(
9131: p_api_version => l_api_version,
9132: p_init_msg_list => l_init_msg_list,
9133: x_return_status => l_return_status,
9134: x_msg_count => l_msg_count,

Line 9192: OKC_CONTRACT_PUB.lock_contract_header(

9188: End If;
9189: l_chrv_rec_in.id := l_eligible_contracts_tbl(i).contract_id ;
9190: l_chrv_rec_in.object_version_number := l_eligible_contracts_tbl(i).object_version_number;
9191:
9192: OKC_CONTRACT_PUB.lock_contract_header(
9193: p_api_version => l_api_version,
9194: p_init_msg_list => l_init_msg_list,
9195: x_return_status => l_return_status,
9196: x_msg_count => l_msg_count,

Line 9208: OKC_CONTRACT_PUB.update_contract_header(

9204: Else
9205: l_chrv_rec_in.renewal_type_code := l_new_value_id;
9206: End If;
9207:
9208: OKC_CONTRACT_PUB.update_contract_header(
9209: p_api_version => l_api_version,
9210: p_init_msg_list => l_init_msg_list,
9211: x_return_status => l_return_status,
9212: x_msg_count => l_msg_count,

Line 9577: OKC_CONTRACT_PUB.lock_contract_header(

9573:
9574: l_chrv_rec_in.id := l_eligible_contracts_tbl(i).contract_id ;
9575: l_chrv_rec_in.object_version_number := l_eligible_contracts_tbl(i).object_version_number;
9576:
9577: OKC_CONTRACT_PUB.lock_contract_header(
9578: p_api_version => l_api_version,
9579: p_init_msg_list => l_init_msg_list,
9580: x_return_status => l_return_status,
9581: x_msg_count => l_msg_count,

Line 9589: OKC_CONTRACT_PUB.update_contract_header(

9585:
9586: IF l_return_status = G_RET_STS_SUCCESS THEN
9587: l_chrv_rec_in.inv_rule_id := l_new_value_id;
9588:
9589: OKC_CONTRACT_PUB.update_contract_header(
9590: p_api_version => l_api_version,
9591: p_init_msg_list => l_init_msg_list,
9592: x_return_status => l_return_status,
9593: x_msg_count => l_msg_count,

Line 9797: OKC_CONTRACT_PUB.lock_contract_line(

9793: END LOOP;
9794: End If;
9795:
9796: If l_clev_tbl_in.count > 0 Then
9797: OKC_CONTRACT_PUB.lock_contract_line(
9798: p_api_version => l_api_version,
9799: p_init_msg_list => l_init_msg_list,
9800: x_return_status => l_return_status,
9801: x_msg_count => l_msg_count,

Line 9807: OKC_CONTRACT_PUB.update_contract_line(

9803: p_clev_tbl => l_clev_tbl_in);
9804:
9805: IF l_return_status = G_RET_STS_SUCCESS THEN
9806:
9807: OKC_CONTRACT_PUB.update_contract_line(
9808: p_api_version => l_api_version,
9809: p_init_msg_list => l_init_msg_list,
9810: x_return_status => l_return_status,
9811: x_msg_count => l_msg_count,

Line 10214: OKC_CONTRACT_PUB.lock_contract_header(

10210:
10211: l_chrv_rec_in.id := l_eligible_contracts_tbl(i).contract_id ;
10212: l_chrv_rec_in.object_version_number := l_eligible_contracts_tbl(i).object_version_number;
10213:
10214: OKC_CONTRACT_PUB.lock_contract_header(
10215: p_api_version => l_api_version,
10216: p_init_msg_list => l_init_msg_list,
10217: x_return_status => l_return_status,
10218: x_msg_count => l_msg_count,

Line 10227: OKC_CONTRACT_PUB.update_contract_header(

10223: IF l_return_status = G_RET_STS_SUCCESS THEN
10224:
10225: l_chrv_rec_in.bill_to_site_use_id := l_new_value_id;
10226:
10227: OKC_CONTRACT_PUB.update_contract_header(
10228: p_api_version => l_api_version,
10229: p_init_msg_list => l_init_msg_list,
10230: x_return_status => l_return_status,
10231: x_msg_count => l_msg_count,

Line 10310: OKC_CONTRACT_PUB.lock_contract_header(

10306: l_message := FND_MESSAGE.get_string('OKS','OKS_INVALID_PRICE_LIST') ;
10307: RAISE G_EXCEPTION_HALT_VALIDATION;
10308: End If;
10309:
10310: OKC_CONTRACT_PUB.lock_contract_header(
10311: p_api_version => l_api_version,
10312: p_init_msg_list => l_init_msg_list,
10313: x_return_status => l_return_status,
10314: x_msg_count => l_msg_count,

Line 10324: OKC_CONTRACT_PUB.update_contract_header(

10320:
10321: -- l_chrv_rec_in.bill_to_site_use_id := l_new_value_id;
10322: l_chrv_rec_in.price_list_id := to_number(l_new_value_id);
10323:
10324: OKC_CONTRACT_PUB.update_contract_header(
10325: p_api_version => l_api_version,
10326: p_init_msg_list => l_init_msg_list,
10327: x_return_status => l_return_status,
10328: x_msg_count => l_msg_count,

Line 10896: OKC_CONTRACT_PUB.lock_contract_header (

10892:
10893: l_chrv_tbl_in(1).id := l_eligible_contracts_tbl(i).contract_id;
10894: l_chrv_tbl_in(1).object_version_number := l_eligible_contracts_tbl(i).object_version_number;
10895:
10896: OKC_CONTRACT_PUB.lock_contract_header (
10897: p_api_version => l_api_version,
10898: p_init_msg_list => l_init_msg_list,
10899: x_return_status => l_return_status,
10900: x_msg_count => l_msg_count,

Line 10910: OKC_CONTRACT_PUB.update_contract_header (

10906:
10907: l_chrv_rec_in.id := l_eligible_contracts_tbl(i).contract_id;
10908: l_chrv_rec_in.cognomen := l_new_value_id;
10909:
10910: OKC_CONTRACT_PUB.update_contract_header (
10911: p_api_version => l_api_version,
10912: p_init_msg_list => l_init_msg_list,
10913: x_return_status => l_return_status,
10914: x_msg_count => l_msg_count,

Line 10963: OKC_CONTRACT_PUB.lock_contract_header (

10959:
10960: l_chrv_tbl_in(1).id := l_eligible_contracts_tbl(i).contract_id;
10961: l_chrv_tbl_in(1).object_version_number := l_eligible_contracts_tbl(i).object_version_number;
10962:
10963: OKC_CONTRACT_PUB.lock_contract_header (
10964: p_api_version => l_api_version,
10965: p_init_msg_list => l_init_msg_list,
10966: x_return_status => l_return_status,
10967: x_msg_count => l_msg_count,

Line 10978: OKC_CONTRACT_PUB.update_contract_header (

10974: l_chrv_rec_in.id := l_eligible_contracts_tbl(i).contract_id;
10975: l_chrv_rec_in.cust_po_number := l_new_value_id;
10976: l_chrv_rec_in.payment_instruction_type := 'PON';
10977:
10978: OKC_CONTRACT_PUB.update_contract_header (
10979: p_api_version => l_api_version,
10980: p_init_msg_list => l_init_msg_list,
10981: x_return_status => l_return_status,
10982: x_msg_count => l_msg_count,

Line 11037: OKC_CONTRACT_PUB.lock_contract_header (

11033: x_clev_tbl => l_clev_tbl_in);
11034:
11035: IF l_return_status = G_RET_STS_SUCCESS AND l_clev_tbl_in.COUNT>0 THEN
11036: LOG_MESSAGES('Locking contract lines for update');
11037: OKC_CONTRACT_PUB.lock_contract_header (
11038: p_api_version => l_api_version,
11039: p_init_msg_list => l_init_msg_list,
11040: x_return_status => l_return_status,
11041: x_msg_count => l_msg_count,

Line 11052: OKC_CONTRACT_PUB.update_contract_line(

11048: FOR j in 1 .. l_clev_tbl_in.COUNT LOOP
11049: l_clev_tbl_in(j).cognomen := l_new_value_id;
11050: END LOOP;
11051:
11052: OKC_CONTRACT_PUB.update_contract_line(
11053: p_api_version => l_api_version,
11054: p_init_msg_list => l_init_msg_list,
11055: x_return_status => l_return_status,
11056: x_msg_count => l_msg_count,

Line 11113: OKC_CONTRACT_PUB.lock_contract_header (

11109:
11110: IF l_return_status = G_RET_STS_SUCCESS AND l_clev_tbl_in.COUNT >0 THEN
11111: LOG_MESSAGES('Locking contract lines for update');
11112:
11113: OKC_CONTRACT_PUB.lock_contract_header (
11114: p_api_version => l_api_version,
11115: p_init_msg_list => l_init_msg_list,
11116: x_return_status => l_return_status,
11117: x_msg_count => l_msg_count,

Line 11128: OKC_CONTRACT_PUB.update_contract_line(

11124: FOR j in 1 .. l_clev_tbl_in.COUNT LOOP
11125: l_clev_tbl_in(j).cognomen := l_new_value_id;
11126: END LOOP;
11127:
11128: OKC_CONTRACT_PUB.update_contract_line(
11129: p_api_version => l_api_version,
11130: p_init_msg_list => l_init_msg_list,
11131: x_return_status => l_return_status,
11132: x_msg_count => l_msg_count,

Line 11236: OKC_CONTRACT_PUB.lock_contract_header (

11232: RAISE l_notelligible_exception ;
11233:
11234: Else
11235:
11236: OKC_CONTRACT_PUB.lock_contract_header (
11237: p_api_version => l_api_version,
11238: p_init_msg_list => l_init_msg_list,
11239: x_return_status => l_return_status,
11240: x_msg_count => l_msg_count,

Line 11277: OKC_CONTRACT_PUB.lock_contract_line(

11273:
11274: IF l_return_status = G_RET_STS_SUCCESS THEN
11275: LOG_MESSAGES('Locking contract lines for update, lines count:'||l_clev_tbl_in.COUNT);
11276:
11277: OKC_CONTRACT_PUB.lock_contract_line(
11278: p_api_version => l_api_version,
11279: p_init_msg_list => l_init_msg_list,
11280: x_return_status => l_return_status,
11281: x_msg_count => l_msg_count,

Line 11360: OKC_CONTRACT_PUB.update_contract_header (

11356: l_chrv_rec_in.id := l_eligible_contracts_tbl(i).contract_id;
11357: l_chrv_rec_in.start_date := to_date(l_new_value,'YYYY/MM/DD HH24:MI:SS');
11358: LOG_MESSAGES('updating contract header with new value:'||l_chrv_rec_in.start_date);
11359:
11360: OKC_CONTRACT_PUB.update_contract_header (
11361: p_api_version => l_api_version,
11362: p_init_msg_list => l_init_msg_list,
11363: x_return_status => l_return_status,
11364: x_msg_count => l_msg_count,

Line 11397: OKC_CONTRACT_PUB.update_contract_line(

11393: to_date(l_new_value,'YYYY/MM/DD HH24:MI:SS');
11394: END LOOP;
11395: LOG_MESSAGES('updating contract lines with new value:'||l_new_value);
11396:
11397: OKC_CONTRACT_PUB.update_contract_line(
11398: p_api_version => l_api_version,
11399: p_init_msg_list => l_init_msg_list,
11400: x_return_status => l_return_status,
11401: x_msg_count => l_msg_count,

Line 11595: OKC_CONTRACT_PUB.lock_contract_header (

11591: RAISE l_notelligible_exception ;
11592:
11593: ELSE
11594:
11595: OKC_CONTRACT_PUB.lock_contract_header (
11596: p_api_version => l_api_version,
11597: p_init_msg_list => l_init_msg_list,
11598: x_return_status => l_return_status,
11599: x_msg_count => l_msg_count,

Line 11636: OKC_CONTRACT_PUB.lock_contract_line(

11632:
11633: IF l_return_status = G_RET_STS_SUCCESS THEN
11634: LOG_MESSAGES('Locking contract lines for update, lines count:'||l_clev_tbl_in.COUNT);
11635:
11636: OKC_CONTRACT_PUB.lock_contract_line(
11637: p_api_version => l_api_version,
11638: p_init_msg_list => l_init_msg_list,
11639: x_return_status => l_return_status,
11640: x_msg_count => l_msg_count,

Line 11719: OKC_CONTRACT_PUB.update_contract_header (

11715: l_chrv_rec_in.id := l_eligible_contracts_tbl(i).contract_id;
11716: l_chrv_rec_in.End_date := to_date(l_new_value,'YYYY/MM/DD HH24:MI:SS');
11717: LOG_MESSAGES('updating contract header with new value:'||l_chrv_rec_in.End_date);
11718:
11719: OKC_CONTRACT_PUB.update_contract_header (
11720: p_api_version => l_api_version,
11721: p_init_msg_list => l_init_msg_list,
11722: x_return_status => l_return_status,
11723: x_msg_count => l_msg_count,

Line 11756: OKC_CONTRACT_PUB.update_contract_line(

11752: to_date(l_new_value,'YYYY/MM/DD HH24:MI:SS');
11753: END LOOP;
11754: LOG_MESSAGES('updating contract lines with new value:'||l_new_value);
11755:
11756: OKC_CONTRACT_PUB.update_contract_line(
11757: p_api_version => l_api_version,
11758: p_init_msg_list => l_init_msg_list,
11759: x_return_status => l_return_status,
11760: x_msg_count => l_msg_count,

Line 12457: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;

12453: l_return_status VARCHAR2(1);
12454: l_msg_count NUMBER;
12455: l_msg_data VARCHAR2(2000);
12456: l_msg_index_out NUMBER;
12457: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
12458: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
12459:
12460: BEGIN
12461: l_chrv_tbl_in(1).id := p_header_id;

Line 12458: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;

12454: l_msg_count NUMBER;
12455: l_msg_data VARCHAR2(2000);
12456: l_msg_index_out NUMBER;
12457: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
12458: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
12459:
12460: BEGIN
12461: l_chrv_tbl_in(1).id := p_header_id;
12462: l_chrv_tbl_in(1).object_version_number := p_object_version_number;

Line 12463: okc_contract_pub.lock_contract_header (

12459:
12460: BEGIN
12461: l_chrv_tbl_in(1).id := p_header_id;
12462: l_chrv_tbl_in(1).object_version_number := p_object_version_number;
12463: okc_contract_pub.lock_contract_header (
12464: p_api_version => l_api_version,
12465: p_init_msg_list => l_init_msg_list,
12466: x_return_status => l_return_status,
12467: x_msg_count => l_msg_count,

Line 12478: PROCEDURE UPDATE_CONTRACT(p_chrv_rec IN okc_contract_pub.chrv_rec_type,

12474: END IF;
12475: x_return_status := l_return_status;
12476: END LOCK_CONTRACT_HEADER;
12477:
12478: PROCEDURE UPDATE_CONTRACT(p_chrv_rec IN okc_contract_pub.chrv_rec_type,
12479: x_return_status OUT NOCOPY VARCHAR2) IS
12480: l_api_version CONSTANT NUMBER := 1.0;
12481: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
12482: l_return_status VARCHAR2(1);

Line 12487: l_chrv_rec_out okc_contract_pub.chrv_rec_type;

12483: l_msg_count NUMBER;
12484: l_msg_data VARCHAR2(2000);
12485: l_msg_index_out NUMBER;
12486:
12487: l_chrv_rec_out okc_contract_pub.chrv_rec_type;
12488:
12489: BEGIN
12490:
12491: LOG_MESSAGES(' UPDATEing Contract, header_id = ' ||p_chrv_rec.id);

Line 12495: okc_contract_pub.update_contract_header (

12491: LOG_MESSAGES(' UPDATEing Contract, header_id = ' ||p_chrv_rec.id);
12492: x_return_status := OKC_API.G_RET_STS_SUCCESS;
12493:
12494: IF p_chrv_rec.id IS NOT NULL THEN
12495: okc_contract_pub.update_contract_header (
12496: p_api_version => l_api_version,
12497: p_init_msg_list => l_init_msg_list,
12498: x_return_status => l_return_status,
12499: x_msg_count => l_msg_count,

Line 12504: LOG_MESSAGES('okc_contract_pub.update_contract_header l_return_status = ' || l_return_status);

12500: x_msg_data => l_msg_data,
12501: p_chrv_rec => p_chrv_rec,
12502: x_chrv_rec => l_chrv_rec_out );
12503:
12504: LOG_MESSAGES('okc_contract_pub.update_contract_header l_return_status = ' || l_return_status);
12505: x_return_status := l_return_status;
12506: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
12507: LOG_MESSAGES('okc_contract_pub.update_contract_header l_msg_data = ' || l_msg_data);
12508: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 12507: LOG_MESSAGES('okc_contract_pub.update_contract_header l_msg_data = ' || l_msg_data);

12503:
12504: LOG_MESSAGES('okc_contract_pub.update_contract_header l_return_status = ' || l_return_status);
12505: x_return_status := l_return_status;
12506: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
12507: LOG_MESSAGES('okc_contract_pub.update_contract_header l_msg_data = ' || l_msg_data);
12508: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
12509: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
12510: LOG_MESSAGES('okc_contract_pub.update_contract_header l_msg_data = ' || l_msg_data);
12511: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 12510: LOG_MESSAGES('okc_contract_pub.update_contract_header l_msg_data = ' || l_msg_data);

12506: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
12507: LOG_MESSAGES('okc_contract_pub.update_contract_header l_msg_data = ' || l_msg_data);
12508: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
12509: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
12510: LOG_MESSAGES('okc_contract_pub.update_contract_header l_msg_data = ' || l_msg_data);
12511: RAISE OKC_API.G_EXCEPTION_ERROR;
12512: END IF;
12513: END IF;
12514: END UPDATE_CONTRACT;