DBA Data[Home] [Help]

APPS.OKS_EXTWARPRGM_PVT dependencies on OKS_INS_PVT

Line 6736: l_insthist_rec oks_ins_pvt.insv_rec_type;

6732: x_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
6733: l_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
6734: l_instparent_id NUMBER;
6735: l_old_cp_id NUMBER;
6736: l_insthist_rec oks_ins_pvt.insv_rec_type;
6737: x_insthist_rec oks_ins_pvt.insv_rec_type;
6738: l_parameters VARCHAR2 (2000);
6739: l_renewal_id NUMBER;
6740: l_line_rec k_line_service_rec_type;

Line 6737: x_insthist_rec oks_ins_pvt.insv_rec_type;

6733: l_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
6734: l_instparent_id NUMBER;
6735: l_old_cp_id NUMBER;
6736: l_insthist_rec oks_ins_pvt.insv_rec_type;
6737: x_insthist_rec oks_ins_pvt.insv_rec_type;
6738: l_parameters VARCHAR2 (2000);
6739: l_renewal_id NUMBER;
6740: l_line_rec k_line_service_rec_type;
6741: l_covd_rec k_line_covered_level_rec_type;

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

7408: l_insthist_rec.transaction_date :=
7409: TRUNC(p_kdtl_tbl (l_ctr).transaction_date);
7410: l_insthist_rec.reference_number := l_ref_num;
7411: l_insthist_rec.PARAMETERS := l_parameters;
7412: oks_ins_pvt.insert_row (p_api_version => 1.0,
7413: p_init_msg_list => 'T',
7414: x_return_status => l_return_status,
7415: x_msg_count => x_msg_count,
7416: x_msg_data => x_msg_data,

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

7423: THEN
7424: fnd_log.STRING
7425: (fnd_log.level_event,
7426: g_module_current || '.CREATE_K_IBSPLIT',
7427: 'oks_ins_pvt.insert_row(Return status = '
7428: || l_return_status
7429: || ')'
7430: );
7431: END IF;

Line 7611: l_insthist_rec oks_ins_pvt.insv_rec_type;

7607: x_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
7608: l_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
7609: l_instparent_id NUMBER;
7610: l_old_cp_id NUMBER;
7611: l_insthist_rec oks_ins_pvt.insv_rec_type;
7612: x_insthist_rec oks_ins_pvt.insv_rec_type;
7613: l_parameters VARCHAR2 (2000);
7614: l_renewal_id NUMBER;
7615: -- l_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;

Line 7612: x_insthist_rec oks_ins_pvt.insv_rec_type;

7608: l_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
7609: l_instparent_id NUMBER;
7610: l_old_cp_id NUMBER;
7611: l_insthist_rec oks_ins_pvt.insv_rec_type;
7612: x_insthist_rec oks_ins_pvt.insv_rec_type;
7613: l_parameters VARCHAR2 (2000);
7614: l_renewal_id NUMBER;
7615: -- l_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;
7616: -- l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;

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

8389: l_insthist_rec.transaction_date :=
8390: TRUNC(p_kdtl_tbl (l_ctr).transaction_date);
8391: l_insthist_rec.reference_number := l_ref_num;
8392: l_insthist_rec.PARAMETERS := l_parameters;
8393: oks_ins_pvt.insert_row (p_api_version => 1.0,
8394: p_init_msg_list => 'T',
8395: x_return_status => l_return_status,
8396: x_msg_count => x_msg_count,
8397: x_msg_data => x_msg_data,

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

8404: THEN
8405: fnd_log.STRING
8406: (fnd_log.level_event,
8407: g_module_current || '.CREATE_IBREPLACE',
8408: 'oks_ins_pvt.insert_row(Return status = '
8409: || l_return_status
8410: || ')'
8411: );
8412: END IF;

Line 8528: l_insthist_rec oks_ins_pvt.insv_rec_type;

8524: x_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
8525: l_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
8526: l_instparent_id NUMBER;
8527: l_old_cp_id NUMBER;
8528: l_insthist_rec oks_ins_pvt.insv_rec_type;
8529: x_insthist_rec oks_ins_pvt.insv_rec_type;
8530: l_parameters VARCHAR2 (2000);
8531: l_price_attribs_in oks_extwarprgm_pvt.pricing_attributes_type;
8532: --SalesCredit

Line 8529: x_insthist_rec oks_ins_pvt.insv_rec_type;

8525: l_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
8526: l_instparent_id NUMBER;
8527: l_old_cp_id NUMBER;
8528: l_insthist_rec oks_ins_pvt.insv_rec_type;
8529: x_insthist_rec oks_ins_pvt.insv_rec_type;
8530: l_parameters VARCHAR2 (2000);
8531: l_price_attribs_in oks_extwarprgm_pvt.pricing_attributes_type;
8532: --SalesCredit
8533: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;

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

9096: l_insthist_rec.transaction_type := 'RET';
9097: l_insthist_rec.transaction_date := TRUNC(p_kdtl_tbl (l_ctr).transaction_date);
9098: l_insthist_rec.reference_number := l_ref_num;
9099: l_insthist_rec.PARAMETERS := l_parameters;
9100: oks_ins_pvt.insert_row (p_api_version => 1.0,
9101: p_init_msg_list => 'T',
9102: x_return_status => l_return_status,
9103: x_msg_count => x_msg_count,
9104: x_msg_data => x_msg_data,

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

9111: THEN
9112: fnd_log.STRING
9113: (fnd_log.level_event,
9114: g_module_current || '.CREATE_K_IBRETURN',
9115: 'oks_ins_pvt.insert_row(Return status = '
9116: || l_return_status
9117: || ')'
9118: );
9119: END IF;

Line 9387: l_insthist_rec oks_ins_pvt.insv_rec_type;

9383: l_qcl_id NUMBER;
9384: l_update_line VARCHAR2 (1);
9385: l_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
9386: x_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
9387: l_insthist_rec oks_ins_pvt.insv_rec_type;
9388: x_insthist_rec oks_ins_pvt.insv_rec_type;
9389: l_instparent_id NUMBER;
9390: l_parameters VARCHAR2 (2000);
9391: l_temp VARCHAR2 (2000);

Line 9388: x_insthist_rec oks_ins_pvt.insv_rec_type;

9384: l_update_line VARCHAR2 (1);
9385: l_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
9386: x_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
9387: l_insthist_rec oks_ins_pvt.insv_rec_type;
9388: x_insthist_rec oks_ins_pvt.insv_rec_type;
9389: l_instparent_id NUMBER;
9390: l_parameters VARCHAR2 (2000);
9391: l_temp VARCHAR2 (2000);
9392: l_old_party_id NUMBER;

Line 13754: oks_ins_pvt.insert_row

13750: l_insthist_rec.transaction_date :=
13751: (p_kdtl_tbl (l_ctr).transaction_date);
13752: l_insthist_rec.reference_number := l_ref_num;
13753: l_insthist_rec.PARAMETERS := l_parameters;
13754: oks_ins_pvt.insert_row
13755: (p_api_version => 1.0,
13756: p_init_msg_list => 'T',
13757: x_return_status => l_return_status,
13758: x_msg_count => l_msg_count,

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

13767: THEN
13768: fnd_log.STRING
13769: (fnd_log.level_event,
13770: g_module_current || '.CREATE_K_SYSTEM_TRF',
13771: 'oks_ins_pvt.insert_row(Return status = '
13772: || l_return_status
13773: || ')'
13774: );
13775: END IF;

Line 13916: l_insthist_rec oks_ins_pvt.insv_rec_type;

13912: x_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
13913: l_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
13914: l_instparent_id NUMBER;
13915: l_old_cp_id NUMBER;
13916: l_insthist_rec oks_ins_pvt.insv_rec_type;
13917: x_insthist_rec oks_ins_pvt.insv_rec_type;
13918: l_parameters VARCHAR2 (2000);
13919: l_service_name VARCHAR2 (2000);
13920: --Contract Line Table

Line 13917: x_insthist_rec oks_ins_pvt.insv_rec_type;

13913: l_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
13914: l_instparent_id NUMBER;
13915: l_old_cp_id NUMBER;
13916: l_insthist_rec oks_ins_pvt.insv_rec_type;
13917: x_insthist_rec oks_ins_pvt.insv_rec_type;
13918: l_parameters VARCHAR2 (2000);
13919: l_service_name VARCHAR2 (2000);
13920: --Contract Line Table
13921: l_clev_tbl_in okc_contract_pub.clev_tbl_type;

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

14486: l_insthist_rec.transaction_date :=
14487: TRUNC(p_kdtl_tbl (l_ctr).transaction_date);
14488: l_insthist_rec.reference_number := l_ref_num;
14489: l_insthist_rec.PARAMETERS := l_parameters;
14490: oks_ins_pvt.insert_row (p_api_version => 1.0,
14491: p_init_msg_list => 'T',
14492: x_return_status => l_return_status,
14493: x_msg_count => x_msg_count,
14494: x_msg_data => x_msg_data,

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

14501: THEN
14502: fnd_log.STRING
14503: (fnd_log.level_event,
14504: g_module_current || '.CREATE_K_SYSTEM_TRF',
14505: 'oks_ins_pvt.insert_row(Return status = '
14506: || l_return_status
14507: || ')'
14508: );
14509: END IF;

Line 14682: l_insthist_rec oks_ins_pvt.insv_rec_type;

14678: x_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
14679: l_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
14680: l_instparent_id NUMBER;
14681: l_old_cp_id NUMBER;
14682: l_insthist_rec oks_ins_pvt.insv_rec_type;
14683: x_insthist_rec oks_ins_pvt.insv_rec_type;
14684: l_parameters VARCHAR2 (2000);
14685: l_lndates_rec l_lndates_csr%ROWTYPE;
14686: l_hdrdates_rec l_hdrdates_csr%ROWTYPE;

Line 14683: x_insthist_rec oks_ins_pvt.insv_rec_type;

14679: l_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
14680: l_instparent_id NUMBER;
14681: l_old_cp_id NUMBER;
14682: l_insthist_rec oks_ins_pvt.insv_rec_type;
14683: x_insthist_rec oks_ins_pvt.insv_rec_type;
14684: l_parameters VARCHAR2 (2000);
14685: l_lndates_rec l_lndates_csr%ROWTYPE;
14686: l_hdrdates_rec l_hdrdates_csr%ROWTYPE;
14687: l_subline_rec l_subline_dates%ROWTYPE;

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

15387: l_insthist_rec.transaction_date :=
15388: TRUNC(p_kdtl_tbl (l_ctr).transaction_date);
15389: l_insthist_rec.reference_number := l_ref_num;
15390: l_insthist_rec.PARAMETERS := l_parameters;
15391: oks_ins_pvt.insert_row (p_api_version => 1.0,
15392: p_init_msg_list => 'T',
15393: x_return_status => l_return_status,
15394: x_msg_count => x_msg_count,
15395: x_msg_data => x_msg_data,

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

15402: THEN
15403: fnd_log.STRING
15404: (fnd_log.level_event,
15405: g_module_current || '.UPDATE_CONTRACT_IDC',
15406: 'oks_ins_pvt.insert_row(Return status = '
15407: || l_return_status
15408: || ')'
15409: );
15410: END IF;

Line 15581: l_insthist_rec oks_ins_pvt.insv_rec_type;

15577: l_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
15578: x_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
15579: l_instparent_id NUMBER;
15580: l_old_cp_id NUMBER;
15581: l_insthist_rec oks_ins_pvt.insv_rec_type;
15582: x_insthist_rec oks_ins_pvt.insv_rec_type;
15583: l_target_chr_id NUMBER;
15584: l_opr_instance_id NUMBER;
15585: l_renewal_opr_instance_id NUMBER;

Line 15582: x_insthist_rec oks_ins_pvt.insv_rec_type;

15578: x_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;
15579: l_instparent_id NUMBER;
15580: l_old_cp_id NUMBER;
15581: l_insthist_rec oks_ins_pvt.insv_rec_type;
15582: x_insthist_rec oks_ins_pvt.insv_rec_type;
15583: l_target_chr_id NUMBER;
15584: l_opr_instance_id NUMBER;
15585: l_renewal_opr_instance_id NUMBER;
15586: l_update_id NUMBER;

Line 16694: oks_ins_pvt.insert_row

16690: l_insthist_rec.transaction_date :=
16691: TRUNC(p_kdtl_tbl (l_ctr).transaction_date);
16692: l_insthist_rec.reference_number := l_ref_num;
16693: l_insthist_rec.PARAMETERS := l_parameters;
16694: oks_ins_pvt.insert_row
16695: (p_api_version => 1.0,
16696: p_init_msg_list => 'T',
16697: x_return_status => l_return_status,
16698: x_msg_count => l_msg_count,

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

16708: fnd_log.STRING
16709: (fnd_log.level_event,
16710: g_module_current
16711: || '.CREATE_CONTRACT_IBUPDATE',
16712: 'oks_ins_pvt.insert_row(Return status = '
16713: || l_return_status
16714: || ')'
16715: );
16716: END IF;