DBA Data[Home] [Help]

APPS.OKS_EXTWARPRGM_PVT dependencies on OKS_INS_PVT

Line 6917: l_insthist_rec oks_ins_pvt.insv_rec_type;

6913: x_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
6914: l_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
6915: l_instparent_id NUMBER;
6916: l_old_cp_id NUMBER;
6917: l_insthist_rec oks_ins_pvt.insv_rec_type;
6918: x_insthist_rec oks_ins_pvt.insv_rec_type;
6919: l_parameters VARCHAR2 (2000);
6920: l_renewal_id NUMBER;
6921: l_line_rec k_line_service_rec_type;

Line 6918: x_insthist_rec oks_ins_pvt.insv_rec_type;

6914: l_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
6915: l_instparent_id NUMBER;
6916: l_old_cp_id NUMBER;
6917: l_insthist_rec oks_ins_pvt.insv_rec_type;
6918: x_insthist_rec oks_ins_pvt.insv_rec_type;
6919: l_parameters VARCHAR2 (2000);
6920: l_renewal_id NUMBER;
6921: l_line_rec k_line_service_rec_type;
6922: l_covd_rec k_line_covered_level_rec_type;

Line 7593: oks_ins_pvt.insert_row (p_api_version => 1.0,

7589: l_insthist_rec.transaction_date :=
7590: TRUNC(p_kdtl_tbl (l_ctr).transaction_date);
7591: l_insthist_rec.reference_number := l_ref_num;
7592: l_insthist_rec.PARAMETERS := l_parameters;
7593: oks_ins_pvt.insert_row (p_api_version => 1.0,
7594: p_init_msg_list => 'T',
7595: x_return_status => l_return_status,
7596: x_msg_count => x_msg_count,
7597: x_msg_data => x_msg_data,

Line 7608: 'oks_ins_pvt.insert_row(Return status = '

7604: THEN
7605: fnd_log.STRING
7606: (fnd_log.level_event,
7607: g_module_current || '.CREATE_K_IBSPLIT',
7608: 'oks_ins_pvt.insert_row(Return status = '
7609: || l_return_status
7610: || ')'
7611: );
7612: END IF;

Line 7805: l_insthist_rec oks_ins_pvt.insv_rec_type;

7801: x_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
7802: l_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
7803: l_instparent_id NUMBER;
7804: l_old_cp_id NUMBER;
7805: l_insthist_rec oks_ins_pvt.insv_rec_type;
7806: x_insthist_rec oks_ins_pvt.insv_rec_type;
7807: l_parameters VARCHAR2 (2000);
7808: l_renewal_id NUMBER;
7809: -- l_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;

Line 7806: x_insthist_rec oks_ins_pvt.insv_rec_type;

7802: l_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
7803: l_instparent_id NUMBER;
7804: l_old_cp_id NUMBER;
7805: l_insthist_rec oks_ins_pvt.insv_rec_type;
7806: x_insthist_rec oks_ins_pvt.insv_rec_type;
7807: l_parameters VARCHAR2 (2000);
7808: l_renewal_id NUMBER;
7809: -- l_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;
7810: -- l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;

Line 8611: oks_ins_pvt.insert_row (p_api_version => 1.0,

8607: l_insthist_rec.transaction_date :=
8608: TRUNC(p_kdtl_tbl (l_ctr).transaction_date);
8609: l_insthist_rec.reference_number := l_ref_num;
8610: l_insthist_rec.PARAMETERS := l_parameters;
8611: oks_ins_pvt.insert_row (p_api_version => 1.0,
8612: p_init_msg_list => 'T',
8613: x_return_status => l_return_status,
8614: x_msg_count => x_msg_count,
8615: x_msg_data => x_msg_data,

Line 8626: 'oks_ins_pvt.insert_row(Return status = '

8622: THEN
8623: fnd_log.STRING
8624: (fnd_log.level_event,
8625: g_module_current || '.CREATE_IBREPLACE',
8626: 'oks_ins_pvt.insert_row(Return status = '
8627: || l_return_status
8628: || ')'
8629: );
8630: END IF;

Line 8759: l_insthist_rec oks_ins_pvt.insv_rec_type;

8755: x_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
8756: l_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
8757: l_instparent_id NUMBER;
8758: l_old_cp_id NUMBER;
8759: l_insthist_rec oks_ins_pvt.insv_rec_type;
8760: x_insthist_rec oks_ins_pvt.insv_rec_type;
8761: l_parameters VARCHAR2 (2000);
8762: l_price_attribs_in oks_extwarprgm_pvt.pricing_attributes_type;
8763: --SalesCredit

Line 8760: x_insthist_rec oks_ins_pvt.insv_rec_type;

8756: l_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
8757: l_instparent_id NUMBER;
8758: l_old_cp_id NUMBER;
8759: l_insthist_rec oks_ins_pvt.insv_rec_type;
8760: x_insthist_rec oks_ins_pvt.insv_rec_type;
8761: l_parameters VARCHAR2 (2000);
8762: l_price_attribs_in oks_extwarprgm_pvt.pricing_attributes_type;
8763: --SalesCredit
8764: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;

Line 9331: oks_ins_pvt.insert_row (p_api_version => 1.0,

9327: l_insthist_rec.transaction_type := 'RET';
9328: l_insthist_rec.transaction_date := TRUNC(p_kdtl_tbl (l_ctr).transaction_date);
9329: l_insthist_rec.reference_number := l_ref_num;
9330: l_insthist_rec.PARAMETERS := l_parameters;
9331: oks_ins_pvt.insert_row (p_api_version => 1.0,
9332: p_init_msg_list => 'T',
9333: x_return_status => l_return_status,
9334: x_msg_count => x_msg_count,
9335: x_msg_data => x_msg_data,

Line 9346: 'oks_ins_pvt.insert_row(Return status = '

9342: THEN
9343: fnd_log.STRING
9344: (fnd_log.level_event,
9345: g_module_current || '.CREATE_K_IBRETURN',
9346: 'oks_ins_pvt.insert_row(Return status = '
9347: || l_return_status
9348: || ')'
9349: );
9350: END IF;

Line 9631: l_insthist_rec oks_ins_pvt.insv_rec_type;

9627: l_qcl_id NUMBER;
9628: l_update_line VARCHAR2 (1);
9629: l_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
9630: x_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
9631: l_insthist_rec oks_ins_pvt.insv_rec_type;
9632: x_insthist_rec oks_ins_pvt.insv_rec_type;
9633: l_instparent_id NUMBER;
9634: l_parameters VARCHAR2 (2000);
9635: l_temp VARCHAR2 (2000);

Line 9632: x_insthist_rec oks_ins_pvt.insv_rec_type;

9628: l_update_line VARCHAR2 (1);
9629: l_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
9630: x_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
9631: l_insthist_rec oks_ins_pvt.insv_rec_type;
9632: x_insthist_rec oks_ins_pvt.insv_rec_type;
9633: l_instparent_id NUMBER;
9634: l_parameters VARCHAR2 (2000);
9635: l_temp VARCHAR2 (2000);
9636: l_old_party_id NUMBER;

Line 14025: oks_ins_pvt.insert_row

14021: l_insthist_rec.transaction_date :=
14022: (p_kdtl_tbl (l_ctr).transaction_date);
14023: l_insthist_rec.reference_number := l_ref_num;
14024: l_insthist_rec.PARAMETERS := l_parameters;
14025: oks_ins_pvt.insert_row
14026: (p_api_version => 1.0,
14027: p_init_msg_list => 'T',
14028: x_return_status => l_return_status,
14029: x_msg_count => l_msg_count,

Line 14042: 'oks_ins_pvt.insert_row(Return status = '

14038: THEN
14039: fnd_log.STRING
14040: (fnd_log.level_event,
14041: g_module_current || '.CREATE_K_SYSTEM_TRF',
14042: 'oks_ins_pvt.insert_row(Return status = '
14043: || l_return_status
14044: || ')'
14045: );
14046: END IF;

Line 14201: l_insthist_rec oks_ins_pvt.insv_rec_type;

14197: x_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
14198: l_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
14199: l_instparent_id NUMBER;
14200: l_old_cp_id NUMBER;
14201: l_insthist_rec oks_ins_pvt.insv_rec_type;
14202: x_insthist_rec oks_ins_pvt.insv_rec_type;
14203: l_parameters VARCHAR2 (2000);
14204: l_service_name VARCHAR2 (2000);
14205: --Contract Line Table

Line 14202: x_insthist_rec oks_ins_pvt.insv_rec_type;

14198: l_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
14199: l_instparent_id NUMBER;
14200: l_old_cp_id NUMBER;
14201: l_insthist_rec oks_ins_pvt.insv_rec_type;
14202: x_insthist_rec oks_ins_pvt.insv_rec_type;
14203: l_parameters VARCHAR2 (2000);
14204: l_service_name VARCHAR2 (2000);
14205: --Contract Line Table
14206: l_clev_tbl_in okc_contract_pub.clev_tbl_type;

Line 14775: oks_ins_pvt.insert_row (p_api_version => 1.0,

14771: l_insthist_rec.transaction_date :=
14772: TRUNC(p_kdtl_tbl (l_ctr).transaction_date);
14773: l_insthist_rec.reference_number := l_ref_num;
14774: l_insthist_rec.PARAMETERS := l_parameters;
14775: oks_ins_pvt.insert_row (p_api_version => 1.0,
14776: p_init_msg_list => 'T',
14777: x_return_status => l_return_status,
14778: x_msg_count => x_msg_count,
14779: x_msg_data => x_msg_data,

Line 14790: 'oks_ins_pvt.insert_row(Return status = '

14786: THEN
14787: fnd_log.STRING
14788: (fnd_log.level_event,
14789: g_module_current || '.CREATE_K_SYSTEM_TRF',
14790: 'oks_ins_pvt.insert_row(Return status = '
14791: || l_return_status
14792: || ')'
14793: );
14794: END IF;

Line 14967: l_insthist_rec oks_ins_pvt.insv_rec_type;

14963: x_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
14964: l_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
14965: l_instparent_id NUMBER;
14966: l_old_cp_id NUMBER;
14967: l_insthist_rec oks_ins_pvt.insv_rec_type;
14968: x_insthist_rec oks_ins_pvt.insv_rec_type;
14969: l_parameters VARCHAR2 (2000);
14970: l_lndates_rec l_lndates_csr%ROWTYPE;
14971: l_hdrdates_rec l_hdrdates_csr%ROWTYPE;

Line 14968: x_insthist_rec oks_ins_pvt.insv_rec_type;

14964: l_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
14965: l_instparent_id NUMBER;
14966: l_old_cp_id NUMBER;
14967: l_insthist_rec oks_ins_pvt.insv_rec_type;
14968: x_insthist_rec oks_ins_pvt.insv_rec_type;
14969: l_parameters VARCHAR2 (2000);
14970: l_lndates_rec l_lndates_csr%ROWTYPE;
14971: l_hdrdates_rec l_hdrdates_csr%ROWTYPE;
14972: l_subline_rec l_subline_dates%ROWTYPE;

Line 15676: oks_ins_pvt.insert_row (p_api_version => 1.0,

15672: l_insthist_rec.transaction_date :=
15673: TRUNC(p_kdtl_tbl (l_ctr).transaction_date);
15674: l_insthist_rec.reference_number := l_ref_num;
15675: l_insthist_rec.PARAMETERS := l_parameters;
15676: oks_ins_pvt.insert_row (p_api_version => 1.0,
15677: p_init_msg_list => 'T',
15678: x_return_status => l_return_status,
15679: x_msg_count => x_msg_count,
15680: x_msg_data => x_msg_data,

Line 15691: 'oks_ins_pvt.insert_row(Return status = '

15687: THEN
15688: fnd_log.STRING
15689: (fnd_log.level_event,
15690: g_module_current || '.UPDATE_CONTRACT_IDC',
15691: 'oks_ins_pvt.insert_row(Return status = '
15692: || l_return_status
15693: || ')'
15694: );
15695: END IF;

Line 15879: l_insthist_rec oks_ins_pvt.insv_rec_type;

15875: l_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
15876: x_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
15877: l_instparent_id NUMBER;
15878: l_old_cp_id NUMBER;
15879: l_insthist_rec oks_ins_pvt.insv_rec_type;
15880: x_insthist_rec oks_ins_pvt.insv_rec_type;
15881: l_target_chr_id NUMBER;
15882: l_opr_instance_id NUMBER;
15883: l_renewal_opr_instance_id NUMBER;

Line 15880: x_insthist_rec oks_ins_pvt.insv_rec_type;

15876: x_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
15877: l_instparent_id NUMBER;
15878: l_old_cp_id NUMBER;
15879: l_insthist_rec oks_ins_pvt.insv_rec_type;
15880: x_insthist_rec oks_ins_pvt.insv_rec_type;
15881: l_target_chr_id NUMBER;
15882: l_opr_instance_id NUMBER;
15883: l_renewal_opr_instance_id NUMBER;
15884: l_update_id NUMBER;

Line 16992: oks_ins_pvt.insert_row

16988: l_insthist_rec.transaction_date :=
16989: TRUNC(p_kdtl_tbl (l_ctr).transaction_date);
16990: l_insthist_rec.reference_number := l_ref_num;
16991: l_insthist_rec.PARAMETERS := l_parameters;
16992: oks_ins_pvt.insert_row
16993: (p_api_version => 1.0,
16994: p_init_msg_list => 'T',
16995: x_return_status => l_return_status,
16996: x_msg_count => l_msg_count,

Line 17010: 'oks_ins_pvt.insert_row(Return status = '

17006: fnd_log.STRING
17007: (fnd_log.level_event,
17008: g_module_current
17009: || '.CREATE_CONTRACT_IBUPDATE',
17010: 'oks_ins_pvt.insert_row(Return status = '
17011: || l_return_status
17012: || ')'
17013: );
17014: END IF;