123: --| OKS_INSTANCE_HISTORY | X | X | | | | |
124: --+---------------------------------+---+---+---+---+---+----------------------+
125: --| OKC_QA_CHECK_PUB | | | | | |X |
126: --+---------------------------------+---+---+---+---+---+----------------------+
127: --| OKC_CONTRACT_PUB | | | | | |X |
128: --+---------------------------------+---+---+---+---+---+----------------------+
129: --| OKS_WF_K_PROCESS_PVT | | | | | |X |
130: --+---------------------------------+---+---+---+---+---+----------------------+
131: --| OKS_IHD_PVT | | | | | |X |
4207: x_msg_data Out NOCOPY Varchar2,
4208: x_msg_count Out NOCOPY Number
4209: ) Is
4210: --Contract Header
4211: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
4212: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
4213: l_cancel_date Date;
4214: l_term_date Date;
4215: l_return_status Varchar2(1);
4208: x_msg_count Out NOCOPY Number
4209: ) Is
4210: --Contract Header
4211: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
4212: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
4213: l_cancel_date Date;
4214: l_term_date Date;
4215: l_return_status Varchar2(1);
4216:
4279:
4280: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate the Header ( = '
4281: || contract_id ||' ) with date = ( ' || l_term_date || ' )');
4282:
4283: okc_contract_pub.update_contract_header
4284: (p_api_version => l_api_version,
4285: p_init_msg_list => l_init_msg_list,
4286: p_restricted_update => okc_api.g_true,
4287: x_return_status => l_return_status,
4341: x_msg_data Out NOCOPY Varchar2,
4342: x_msg_count Out NOCOPY Number
4343: ) Is
4344: --Contract Line Table
4345: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
4346: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
4347: l_cancel_date Date;
4348: l_term_date Date;
4349: l_return_status Varchar2(1);
4342: x_msg_count Out NOCOPY Number
4343: ) Is
4344: --Contract Line Table
4345: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
4346: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
4347: l_cancel_date Date;
4348: l_term_date Date;
4349: l_return_status Varchar2(1);
4350:
4415: End If;
4416: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate the Line = ( '
4417: || Service_line_id ||' ) with date = ( ' || l_term_date ||' )' );
4418:
4419: okc_contract_pub.update_contract_line
4420: (p_api_version => l_api_version,
4421: p_init_msg_list => l_init_msg_list,
4422: p_restricted_update => okc_api.g_true,
4423: x_return_status => l_return_status,
5375: x_return_status OUT NOCOPY VARCHAR2
5376: )
5377: IS
5378: l_return_status VARCHAR2 (1) := 'S';
5379: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
5380: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
5381: l_term_date DATE;
5382: l_ste_code VARCHAR2(30);
5383: l_sts_code VARCHAR2(30);
5376: )
5377: IS
5378: l_return_status VARCHAR2 (1) := 'S';
5379: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
5380: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
5381: l_term_date DATE;
5382: l_ste_code VARCHAR2(30);
5383: l_sts_code VARCHAR2(30);
5384: l_term_date_flag VARCHAR2(1);
6675: l_jtf_note_id NUMBER;
6676: l_jtf_note_contexts_tab jtf_notes_pub.jtf_note_contexts_tbl_type;
6677: l_note_details csi_mass_edit_entries_tl.Description%TYPE;
6678: --Contract Line Table
6679: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
6680: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
6681: --Contract Header
6682: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
6683: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
6676: l_jtf_note_contexts_tab jtf_notes_pub.jtf_note_contexts_tbl_type;
6677: l_note_details csi_mass_edit_entries_tl.Description%TYPE;
6678: --Contract Line Table
6679: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
6680: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
6681: --Contract Header
6682: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
6683: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
6684: -- workflow variabled
6678: --Contract Line Table
6679: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
6680: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
6681: --Contract Header
6682: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
6683: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
6684: -- workflow variabled
6685: l_wf_attributes oks_wf_k_process_pvt.wf_attr_details;
6686: -- Instance History
6679: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
6680: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
6681: --Contract Header
6682: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
6683: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
6684: -- workflow variabled
6685: l_wf_attributes oks_wf_k_process_pvt.wf_attr_details;
6686: -- Instance History
6687: l_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;