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 4211: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;

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);

Line 4212: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;

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:

Line 4283: okc_contract_pub.update_contract_header

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,

Line 4345: l_clev_tbl_in okc_contract_pub.clev_tbl_type;

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);

Line 4346: l_clev_tbl_out okc_contract_pub.clev_tbl_type;

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:

Line 4419: okc_contract_pub.update_contract_line

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,

Line 5379: l_clev_tbl_in okc_contract_pub.clev_tbl_type;

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);

Line 5380: l_clev_tbl_out okc_contract_pub.clev_tbl_type;

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);

Line 6679: l_clev_tbl_in okc_contract_pub.clev_tbl_type;

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;

Line 6680: l_clev_tbl_out okc_contract_pub.clev_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

Line 6682: l_chrv_tbl_in okc_contract_pub.chrv_tbl_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
6685: l_wf_attributes oks_wf_k_process_pvt.wf_attr_details;
6686: -- Instance History

Line 6683: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;

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;