DBA Data[Home] [Help]

APPS.OKC_OC_INT_CONFIG_PVT dependencies on OKC_CONTRACT_PUB

Line 25: p_parent_clev_rec IN OUT NOCOPY okc_contract_pub.clev_rec_type,

21:
22: -- Out Parameters: x_return_status return Status
23: -------------------------------------------------------------------------------
24: PROCEDURE create_config_sublines(p_source_inf_rec IN SOURCE_INF_REC_TYPE,
25: p_parent_clev_rec IN OUT NOCOPY okc_contract_pub.clev_rec_type,
26: p_parent_cimv_rec IN okc_contract_item_pub.cimv_rec_type,
27: p_line_inf_tab IN OUT NOCOPY line_inf_tbl_type,
28: x_return_status OUT NOCOPY VARCHAR2
29: ) IS

Line 85: l_child_clev_rec OKC_CONTRACT_PUB.CLEV_REC_TYPE;

81: l_msg_data VARCHAR2(2000);
82: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
83: child_line_rec c_child_line_info%ROWTYPE;
84: l_child_cimv_rec OKC_CONTRACT_ITEM_PUB.CIMV_REC_TYPE;
85: l_child_clev_rec OKC_CONTRACT_PUB.CLEV_REC_TYPE;
86: lx_child_cimv_rec OKC_CONTRACT_ITEM_PUB.CIMV_REC_TYPE;
87: lx_child_clev_rec OKC_CONTRACT_PUB.CLEV_REC_TYPE;
88: temp_child_cimv_rec OKC_CONTRACT_ITEM_PUB.CIMV_REC_TYPE;
89: temp_child_clev_rec OKC_CONTRACT_PUB.CLEV_REC_TYPE;

Line 87: lx_child_clev_rec OKC_CONTRACT_PUB.CLEV_REC_TYPE;

83: child_line_rec c_child_line_info%ROWTYPE;
84: l_child_cimv_rec OKC_CONTRACT_ITEM_PUB.CIMV_REC_TYPE;
85: l_child_clev_rec OKC_CONTRACT_PUB.CLEV_REC_TYPE;
86: lx_child_cimv_rec OKC_CONTRACT_ITEM_PUB.CIMV_REC_TYPE;
87: lx_child_clev_rec OKC_CONTRACT_PUB.CLEV_REC_TYPE;
88: temp_child_cimv_rec OKC_CONTRACT_ITEM_PUB.CIMV_REC_TYPE;
89: temp_child_clev_rec OKC_CONTRACT_PUB.CLEV_REC_TYPE;
90: l_source_inf_rec SOURCE_INF_REC_TYPE;
91: l_subline_num NUMBER :=0;

Line 89: temp_child_clev_rec OKC_CONTRACT_PUB.CLEV_REC_TYPE;

85: l_child_clev_rec OKC_CONTRACT_PUB.CLEV_REC_TYPE;
86: lx_child_cimv_rec OKC_CONTRACT_ITEM_PUB.CIMV_REC_TYPE;
87: lx_child_clev_rec OKC_CONTRACT_PUB.CLEV_REC_TYPE;
88: temp_child_cimv_rec OKC_CONTRACT_ITEM_PUB.CIMV_REC_TYPE;
89: temp_child_clev_rec OKC_CONTRACT_PUB.CLEV_REC_TYPE;
90: l_source_inf_rec SOURCE_INF_REC_TYPE;
91: l_subline_num NUMBER :=0;
92: line_inf_tab_counter NUMBER :=0;
93:

Line 184: okc_util.print_trace(1, '>START - ******* OKC_CONTRACT_PUB.CREATE_CONTRACT_LINE -');

180: okc_util.print_trace(1, 'Context org_id = '|| SYS_CONTEXT('OKC_CONTEXT', 'ORG_ID'));
181: okc_util.print_trace(1, 'Context organization_id = '|| SYS_CONTEXT('OKC_CONTEXT', 'ORGANIZATION_ID'));
182: okc_util.print_trace(1, '----------------------------');
183: okc_util.print_trace(1, '--------------------------------------------------------');
184: okc_util.print_trace(1, '>START - ******* OKC_CONTRACT_PUB.CREATE_CONTRACT_LINE -');
185: END IF;
186:
187: okc_contract_pub.create_contract_line(p_api_version => 1
188: ,p_init_msg_list => OKC_API.G_FALSE

Line 187: okc_contract_pub.create_contract_line(p_api_version => 1

183: okc_util.print_trace(1, '--------------------------------------------------------');
184: okc_util.print_trace(1, '>START - ******* OKC_CONTRACT_PUB.CREATE_CONTRACT_LINE -');
185: END IF;
186:
187: okc_contract_pub.create_contract_line(p_api_version => 1
188: ,p_init_msg_list => OKC_API.G_FALSE
189: ,x_return_status => l_return_status
190: ,x_msg_count => l_msg_count
191: ,x_msg_data => l_msg_data

Line 197: okc_util.print_trace(1, '

193: ,x_clev_rec => lx_child_clev_rec
194: );
195:
196: IF (l_debug = 'Y') THEN
197: okc_util.print_trace(1, ' 198: okc_util.print_trace(1, '----------------------------');
199: okc_util.print_trace(1, 'Context org_id = '|| SYS_CONTEXT('OKC_CONTEXT', 'ORG_ID'));
200: okc_util.print_trace(1, 'Context organization_id = '|| SYS_CONTEXT('OKC_CONTEXT', 'ORGANIZATION_ID'));
201: okc_util.print_trace(1, '----------------------------');

Line 417: p_clev_rec IN OKC_CONTRACT_PUB.CLEV_REC_TYPE,

413: -- Out Parameters: x_return_status return Status
414: -- x_clev_rec Contract Line rec of Top line
415: --------------------------------------------------------------------------------
416: Procedure create_k_config_lines( p_source_inf_rec IN SOURCE_INF_REC_TYPE,
417: p_clev_rec IN OKC_CONTRACT_PUB.CLEV_REC_TYPE,
418: p_cimv_rec IN OKC_CONTRACT_ITEM_PUB.CIMV_REC_TYPE,
419: p_line_inf_tab IN OUT NOCOPY LINE_INF_TBL_TYPE,
420: x_clev_rec OUT NOCOPY OKC_CONTRACT_PUB.CLEV_REC_TYPE,
421: x_return_status OUT NOCOPY VARCHAR2

Line 420: x_clev_rec OUT NOCOPY OKC_CONTRACT_PUB.CLEV_REC_TYPE,

416: Procedure create_k_config_lines( p_source_inf_rec IN SOURCE_INF_REC_TYPE,
417: p_clev_rec IN OKC_CONTRACT_PUB.CLEV_REC_TYPE,
418: p_cimv_rec IN OKC_CONTRACT_ITEM_PUB.CIMV_REC_TYPE,
419: p_line_inf_tab IN OUT NOCOPY LINE_INF_TBL_TYPE,
420: x_clev_rec OUT NOCOPY OKC_CONTRACT_PUB.CLEV_REC_TYPE,
421: x_return_status OUT NOCOPY VARCHAR2
422: ) IS
423:
424: l_clev_rec OKC_CONTRACT_PUB.CLEV_REC_TYPE;

Line 424: l_clev_rec OKC_CONTRACT_PUB.CLEV_REC_TYPE;

420: x_clev_rec OUT NOCOPY OKC_CONTRACT_PUB.CLEV_REC_TYPE,
421: x_return_status OUT NOCOPY VARCHAR2
422: ) IS
423:
424: l_clev_rec OKC_CONTRACT_PUB.CLEV_REC_TYPE;
425: model_clev_rec OKC_CONTRACT_PUB.CLEV_REC_TYPE;
426: xmodel_clev_rec OKC_CONTRACT_PUB.CLEV_REC_TYPE;
427: lx_clev_rec OKC_CONTRACT_PUB.CLEV_REC_TYPE;
428: l_cimv_rec OKC_CONTRACT_ITEM_PUB.CIMV_REC_TYPE;

Line 425: model_clev_rec OKC_CONTRACT_PUB.CLEV_REC_TYPE;

421: x_return_status OUT NOCOPY VARCHAR2
422: ) IS
423:
424: l_clev_rec OKC_CONTRACT_PUB.CLEV_REC_TYPE;
425: model_clev_rec OKC_CONTRACT_PUB.CLEV_REC_TYPE;
426: xmodel_clev_rec OKC_CONTRACT_PUB.CLEV_REC_TYPE;
427: lx_clev_rec OKC_CONTRACT_PUB.CLEV_REC_TYPE;
428: l_cimv_rec OKC_CONTRACT_ITEM_PUB.CIMV_REC_TYPE;
429: model_cimv_rec OKC_CONTRACT_ITEM_PUB.CIMV_REC_TYPE;

Line 426: xmodel_clev_rec OKC_CONTRACT_PUB.CLEV_REC_TYPE;

422: ) IS
423:
424: l_clev_rec OKC_CONTRACT_PUB.CLEV_REC_TYPE;
425: model_clev_rec OKC_CONTRACT_PUB.CLEV_REC_TYPE;
426: xmodel_clev_rec OKC_CONTRACT_PUB.CLEV_REC_TYPE;
427: lx_clev_rec OKC_CONTRACT_PUB.CLEV_REC_TYPE;
428: l_cimv_rec OKC_CONTRACT_ITEM_PUB.CIMV_REC_TYPE;
429: model_cimv_rec OKC_CONTRACT_ITEM_PUB.CIMV_REC_TYPE;
430: lx_cimv_rec OKC_CONTRACT_ITEM_PUB.CIMV_REC_TYPE;

Line 427: lx_clev_rec OKC_CONTRACT_PUB.CLEV_REC_TYPE;

423:
424: l_clev_rec OKC_CONTRACT_PUB.CLEV_REC_TYPE;
425: model_clev_rec OKC_CONTRACT_PUB.CLEV_REC_TYPE;
426: xmodel_clev_rec OKC_CONTRACT_PUB.CLEV_REC_TYPE;
427: lx_clev_rec OKC_CONTRACT_PUB.CLEV_REC_TYPE;
428: l_cimv_rec OKC_CONTRACT_ITEM_PUB.CIMV_REC_TYPE;
429: model_cimv_rec OKC_CONTRACT_ITEM_PUB.CIMV_REC_TYPE;
430: lx_cimv_rec OKC_CONTRACT_ITEM_PUB.CIMV_REC_TYPE;
431: line_inf_tab_counter NUMBER := 0;

Line 486: okc_util.print_trace(1, '>START - ******* OKC_CONTRACT_PUB.CREATE_CONTRACT_LINE -');

482: okc_util.print_trace(1, 'Context org_id = '|| SYS_CONTEXT('OKC_CONTEXT', 'ORG_ID'));
483: okc_util.print_trace(1, 'Context organization_id = '|| SYS_CONTEXT('OKC_CONTEXT', 'ORGANIZATION_ID'));
484: okc_util.print_trace(1, '----------------------------');
485: okc_util.print_trace(1, '--------------------------------------------------------');
486: okc_util.print_trace(1, '>START - ******* OKC_CONTRACT_PUB.CREATE_CONTRACT_LINE -');
487: END IF;
488:
489: okc_contract_pub.create_contract_line(p_api_version => 1
490: ,p_init_msg_list => OKC_API.G_FALSE

Line 489: okc_contract_pub.create_contract_line(p_api_version => 1

485: okc_util.print_trace(1, '--------------------------------------------------------');
486: okc_util.print_trace(1, '>START - ******* OKC_CONTRACT_PUB.CREATE_CONTRACT_LINE -');
487: END IF;
488:
489: okc_contract_pub.create_contract_line(p_api_version => 1
490: ,p_init_msg_list => OKC_API.G_FALSE
491: ,x_return_status => l_return_status
492: ,x_msg_count => l_msg_count
493: ,x_msg_data => l_msg_data

Line 499: okc_util.print_trace(1, '

495: ,x_clev_rec => lx_clev_rec
496: );
497: xmodel_clev_rec := lx_clev_rec;
498: IF (l_debug = 'Y') THEN
499: okc_util.print_trace(1, ' 500: okc_util.print_trace(1, '----------------------------');
501: okc_util.print_trace(1, 'Context org_id = '|| SYS_CONTEXT('OKC_CONTEXT', 'ORG_ID'));
502: okc_util.print_trace(1, 'Context organization_id = '|| SYS_CONTEXT('OKC_CONTEXT', 'ORGANIZATION_ID'));
503: okc_util.print_trace(1, '----------------------------');

Line 695: okc_util.print_trace(1, '>START - ******* OKC_CONTRACT_PUB.CREATE_CONTRACT_LINE -');

691: okc_util.print_trace(1, 'Context org_id = '|| SYS_CONTEXT('OKC_CONTEXT', 'ORG_ID'));
692: okc_util.print_trace(1, 'Context organization_id = '|| SYS_CONTEXT('OKC_CONTEXT', 'ORGANIZATION_ID'));
693: okc_util.print_trace(1, '----------------------------');
694: okc_util.print_trace(1, '--------------------------------------------------------');
695: okc_util.print_trace(1, '>START - ******* OKC_CONTRACT_PUB.CREATE_CONTRACT_LINE -');
696: END IF;
697:
698: okc_contract_pub.create_contract_line(p_api_version => 1
699: ,p_init_msg_list => OKC_API.G_FALSE

Line 698: okc_contract_pub.create_contract_line(p_api_version => 1

694: okc_util.print_trace(1, '--------------------------------------------------------');
695: okc_util.print_trace(1, '>START - ******* OKC_CONTRACT_PUB.CREATE_CONTRACT_LINE -');
696: END IF;
697:
698: okc_contract_pub.create_contract_line(p_api_version => 1
699: ,p_init_msg_list => OKC_API.G_FALSE
700: ,x_return_status => l_return_status
701: ,x_msg_count => l_msg_count
702: ,x_msg_data => l_msg_data

Line 708: okc_util.print_trace(1, '

704: ,x_clev_rec => lx_clev_rec
705: );
706:
707: IF (l_debug = 'Y') THEN
708: okc_util.print_trace(1, ' 709: okc_util.print_trace(1, '----------------------------');
710: okc_util.print_trace(1, 'Context org_id = '|| SYS_CONTEXT('OKC_CONTEXT', 'ORG_ID'));
711: okc_util.print_trace(1, 'Context organization_id = '|| SYS_CONTEXT('OKC_CONTEXT', 'ORGANIZATION_ID'));
712: okc_util.print_trace(1, '----------------------------');

Line 908: okc_util.print_trace(1, '>START - ******* OKC_CONTRACT_PUB.UPDATE_CONTRACT_LINE -');

904: okc_util.print_trace(1, '-----------------------------------------------------------------');
905: okc_util.print_trace(1, 'Rolled Up Line List Price : '||model_clev_rec.line_list_price );
906: okc_util.print_trace(1, 'Rolled Up Price Negotiated : '||model_clev_rec.price_negotiated);
907: okc_util.print_trace(1, '--------------------------------------------------------');
908: okc_util.print_trace(1, '>START - ******* OKC_CONTRACT_PUB.UPDATE_CONTRACT_LINE -');
909: END IF;
910:
911: okc_contract_pub.update_contract_line(p_api_version => 1
912: ,p_init_msg_list => OKC_API.G_FALSE

Line 911: okc_contract_pub.update_contract_line(p_api_version => 1

907: okc_util.print_trace(1, '--------------------------------------------------------');
908: okc_util.print_trace(1, '>START - ******* OKC_CONTRACT_PUB.UPDATE_CONTRACT_LINE -');
909: END IF;
910:
911: okc_contract_pub.update_contract_line(p_api_version => 1
912: ,p_init_msg_list => OKC_API.G_FALSE
913: ,x_return_status => l_return_status
914: ,x_msg_count => l_msg_count
915: ,x_msg_data => l_msg_data

Line 932: okc_util.print_trace(1, '

928: p_token2_value => p_source_inf_rec.line_number
929: );
930: END IF;
931: IF (l_debug = 'Y') THEN
932: okc_util.print_trace(1, ' 933: okc_util.print_trace(1, '----------------------------');
934: okc_util.print_trace(1, 'Context org_id = '|| SYS_CONTEXT('OKC_CONTEXT', 'ORG_ID'));
935: okc_util.print_trace(1, 'Context organization_id = '|| SYS_CONTEXT('OKC_CONTEXT', 'ORGANIZATION_ID'));
936: okc_util.print_trace(1, '----------------------------');