DBA Data[Home] [Help]

APPS.OKS_MASS_UPDATE_PVT dependencies on OKC_CONTRACT_PUB

Line 127: --| OKC_CONTRACT_PUB | | | | | |X |

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 |

Line 4216: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;

4212: x_msg_data Out NOCOPY Varchar2,
4213: x_msg_count Out NOCOPY Number
4214: ) Is
4215: --Contract Header
4216: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
4217: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
4218: l_cancel_date Date;
4219: l_term_date Date;
4220: l_return_status Varchar2(1);

Line 4217: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;

4213: x_msg_count Out NOCOPY Number
4214: ) Is
4215: --Contract Header
4216: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
4217: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
4218: l_cancel_date Date;
4219: l_term_date Date;
4220: l_return_status Varchar2(1);
4221:

Line 4288: okc_contract_pub.update_contract_header

4284:
4285: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate the Header ( = '
4286: || contract_id ||' ) with date = ( ' || l_term_date || ' )');
4287:
4288: okc_contract_pub.update_contract_header
4289: (p_api_version => l_api_version,
4290: p_init_msg_list => l_init_msg_list,
4291: p_restricted_update => okc_api.g_true,
4292: x_return_status => l_return_status,

Line 4350: l_clev_tbl_in okc_contract_pub.clev_tbl_type;

4346: x_msg_data Out NOCOPY Varchar2,
4347: x_msg_count Out NOCOPY Number
4348: ) Is
4349: --Contract Line Table
4350: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
4351: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
4352: l_cancel_date Date;
4353: l_term_date Date;
4354: l_return_status Varchar2(1);

Line 4351: l_clev_tbl_out okc_contract_pub.clev_tbl_type;

4347: x_msg_count Out NOCOPY Number
4348: ) Is
4349: --Contract Line Table
4350: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
4351: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
4352: l_cancel_date Date;
4353: l_term_date Date;
4354: l_return_status Varchar2(1);
4355:

Line 4424: okc_contract_pub.update_contract_line

4420: End If;
4421: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate the Line = ( '
4422: || Service_line_id ||' ) with date = ( ' || l_term_date ||' )' );
4423:
4424: okc_contract_pub.update_contract_line
4425: (p_api_version => l_api_version,
4426: p_init_msg_list => l_init_msg_list,
4427: p_restricted_update => okc_api.g_true,
4428: x_return_status => l_return_status,

Line 5396: l_clev_tbl_in okc_contract_pub.clev_tbl_type;

5392: x_return_status OUT NOCOPY VARCHAR2
5393: )
5394: IS
5395: l_return_status VARCHAR2 (1) := 'S';
5396: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
5397: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
5398: l_term_date DATE;
5399: l_ste_code VARCHAR2(30);
5400: l_sts_code VARCHAR2(30);

Line 5397: l_clev_tbl_out okc_contract_pub.clev_tbl_type;

5393: )
5394: IS
5395: l_return_status VARCHAR2 (1) := 'S';
5396: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
5397: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
5398: l_term_date DATE;
5399: l_ste_code VARCHAR2(30);
5400: l_sts_code VARCHAR2(30);
5401: l_term_date_flag VARCHAR2(1);

Line 6696: l_clev_tbl_in okc_contract_pub.clev_tbl_type;

6692: l_jtf_note_id NUMBER;
6693: l_jtf_note_contexts_tab jtf_notes_pub.jtf_note_contexts_tbl_type;
6694: l_note_details csi_mass_edit_entries_tl.Description%TYPE;
6695: --Contract Line Table
6696: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
6697: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
6698: --Contract Header
6699: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
6700: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;

Line 6697: l_clev_tbl_out okc_contract_pub.clev_tbl_type;

6693: l_jtf_note_contexts_tab jtf_notes_pub.jtf_note_contexts_tbl_type;
6694: l_note_details csi_mass_edit_entries_tl.Description%TYPE;
6695: --Contract Line Table
6696: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
6697: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
6698: --Contract Header
6699: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
6700: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
6701: -- workflow variabled

Line 6699: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;

6695: --Contract Line Table
6696: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
6697: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
6698: --Contract Header
6699: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
6700: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
6701: -- workflow variabled
6702: l_wf_attributes oks_wf_k_process_pvt.wf_attr_details;
6703: -- Instance History

Line 6700: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;

6696: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
6697: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
6698: --Contract Header
6699: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
6700: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
6701: -- workflow variabled
6702: l_wf_attributes oks_wf_k_process_pvt.wf_attr_details;
6703: -- Instance History
6704: l_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;