DBA Data[Home] [Help]

APPS.OKS_EXTWARPRGM_PVT dependencies on OKS_IHD_PVT

Line 5680: x_inst_dtls_tbl IN OUT NOCOPY oks_ihd_pvt.ihdv_tbl_type,

5676: p_salescredit_tbl_hdr_in IN oks_extwarprgm_pvt.salescredit_tbl,
5677: --mmadhavi bug 4174921
5678: p_salescredit_tbl_line_in IN oks_extwarprgm_pvt.salescredit_tbl,
5679: p_price_attribs_in IN oks_extwarprgm_pvt.pricing_attributes_type,
5680: x_inst_dtls_tbl IN OUT NOCOPY oks_ihd_pvt.ihdv_tbl_type,
5681: x_chrid OUT NOCOPY NUMBER,
5682: x_return_status OUT NOCOPY VARCHAR2,
5683: x_msg_count OUT NOCOPY NUMBER,
5684: x_msg_data OUT NOCOPY VARCHAR2

Line 6732: x_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;

6728: FROM csi_item_instances
6729: WHERE instance_id = p_cp_id;
6730:
6731: l_ref_num VARCHAR2 (30);
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;

Line 6733: l_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;

6729: WHERE instance_id = p_cp_id;
6730:
6731: l_ref_num VARCHAR2 (30);
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;

Line 7450: oks_ihd_pvt.insert_row (p_api_version => 1.0,

7446: l_inst_dtls_tbl (i).ins_id := l_instparent_id;
7447: END LOOP;
7448:
7449: --oks_inst_history_details
7450: oks_ihd_pvt.insert_row (p_api_version => 1.0,
7451: p_init_msg_list => 'T',
7452: x_return_status => l_return_status,
7453: x_msg_count => x_msg_count,
7454: x_msg_data => x_msg_data,

Line 7464: 'oks_ihd_pvt.insert_row(Return status = '

7460: THEN
7461: fnd_log.STRING
7462: (fnd_log.level_event,
7463: g_module_current || '.CREATE_K_IBSPLIT',
7464: 'oks_ihd_pvt.insert_row(Return status = '
7465: || l_return_status
7466: || ')'
7467: );
7468: END IF;

Line 7607: x_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;

7603: FROM csi_item_instances
7604: WHERE instance_id = p_cp_id;
7605:
7606: l_ref_num VARCHAR2 (30);
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;

Line 7608: l_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;

7604: WHERE instance_id = p_cp_id;
7605:
7606: l_ref_num VARCHAR2 (30);
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;

Line 8431: oks_ihd_pvt.insert_row (p_api_version => 1.0,

8427: l_inst_dtls_tbl (i).ins_id := l_instparent_id;
8428: END LOOP;
8429:
8430: --oks_inst_history_details
8431: oks_ihd_pvt.insert_row (p_api_version => 1.0,
8432: p_init_msg_list => 'T',
8433: x_return_status => l_return_status,
8434: x_msg_count => x_msg_count,
8435: x_msg_data => x_msg_data,

Line 8445: 'oks_ihd_pvt.insert_row(Return status = '

8441: THEN
8442: fnd_log.STRING
8443: (fnd_log.level_event,
8444: g_module_current || '.CREATE_K_IBREPLACE',
8445: 'oks_ihd_pvt.insert_row(Return status = '
8446: || l_return_status
8447: || ')'
8448: );
8449: END IF;

Line 8524: x_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;

8520:
8521: l_hdr_status Varchar2(240);
8522:
8523: l_ref_num VARCHAR2 (30);
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;

Line 8525: l_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;

8521: l_hdr_status Varchar2(240);
8522:
8523: l_ref_num VARCHAR2 (30);
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;

Line 9134: oks_ihd_pvt.insert_row (p_api_version => 1.0,

9130: END IF;
9131:
9132: l_inst_dtls_tbl (1).ins_id := l_instparent_id;
9133: --oks_inst_history_details
9134: oks_ihd_pvt.insert_row (p_api_version => 1.0,
9135: p_init_msg_list => 'T',
9136: x_return_status => l_return_status,
9137: x_msg_count => x_msg_count,
9138: x_msg_data => x_msg_data,

Line 9148: 'oks_ihd_pvt.insert_row(Return status = '

9144: THEN
9145: fnd_log.STRING
9146: (fnd_log.level_event,
9147: g_module_current || '.CREATE_IBRETURN',
9148: 'oks_ihd_pvt.insert_row(Return status = '
9149: || l_return_status
9150: || ')'
9151: );
9152: END IF;

Line 9385: l_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;

9381: l_covlvl_id NUMBER;
9382: i NUMBER;
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;

Line 9386: x_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;

9382: i NUMBER;
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);

Line 13807: oks_ihd_pvt.insert_row (p_api_version => 1.0,

13803: -- FIx for bug 2408704
13804: END LOOP;
13805:
13806: --oks_inst_history_details
13807: oks_ihd_pvt.insert_row (p_api_version => 1.0,
13808: p_init_msg_list => 'T',
13809: x_return_status => l_return_status,
13810: x_msg_count => l_msg_count,
13811: x_msg_data => l_msg_data,

Line 13822: 'oks_ihd_pvt.insert_row(Return status = '

13818: THEN
13819: fnd_log.STRING
13820: (fnd_log.level_event,
13821: g_module_current || '.CREATE_K_SYSTEM_TRF',
13822: 'oks_ihd_pvt.insert_row(Return status = '
13823: || l_return_status
13824: || ')'
13825: );
13826: END IF;

Line 13912: x_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;

13908:
13909: l_hdr_status Varchar2(240);
13910:
13911: l_ref_num VARCHAR2 (30);
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;

Line 13913: l_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;

13909: l_hdr_status Varchar2(240);
13910:
13911: l_ref_num VARCHAR2 (30);
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;

Line 14524: oks_ihd_pvt.insert_row (p_api_version => 1.0,

14520: END IF;
14521:
14522: l_inst_dtls_tbl (l_ptr).ins_id := l_instparent_id;
14523: --oks_inst_history_details
14524: oks_ihd_pvt.insert_row (p_api_version => 1.0,
14525: p_init_msg_list => 'T',
14526: x_return_status => l_return_status,
14527: x_msg_count => x_msg_count,
14528: x_msg_data => x_msg_data,

Line 14538: 'oks_ihd_pvt.insert_row(Return status = '

14534: THEN
14535: fnd_log.STRING
14536: (fnd_log.level_event,
14537: g_module_current || '.CREATE_IBTERMINATE',
14538: 'oks_ihd_pvt.insert_row(Return status = '
14539: || l_return_status
14540: || ')'
14541: );
14542: END IF;

Line 14678: x_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;

14674: FROM csi_item_instances
14675: WHERE instance_id = p_cp_id;
14676:
14677: l_ref_num VARCHAR2 (30);
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;

Line 14679: l_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;

14675: WHERE instance_id = p_cp_id;
14676:
14677: l_ref_num VARCHAR2 (30);
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;

Line 15425: oks_ihd_pvt.insert_row (p_api_version => 1.0,

15421: END IF;
15422:
15423: l_inst_dtls_tbl (1).ins_id := l_instparent_id;
15424: --oks_inst_history_details
15425: oks_ihd_pvt.insert_row (p_api_version => 1.0,
15426: p_init_msg_list => 'T',
15427: x_return_status => l_return_status,
15428: x_msg_count => x_msg_count,
15429: x_msg_data => x_msg_data,

Line 15439: 'oks_ihd_pvt.insert_row(Return status = '

15435: THEN
15436: fnd_log.STRING
15437: (fnd_log.level_event,
15438: g_module_current || '.UPDATE_CONTRACT_IDC',
15439: 'oks_ihd_pvt.insert_row(Return status = '
15440: || l_return_status
15441: || ')'
15442: );
15443: END IF;

Line 15577: l_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;

15573: l_output_details oks_qp_pkg.price_details;
15574: l_modif_details qp_preq_grp.line_detail_tbl_type;
15575: l_pb_details oks_qp_pkg.g_price_break_tbl_type;
15576: l_warranty_flag VARCHAR2 (2);
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;

Line 15578: x_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;

15574: l_modif_details qp_preq_grp.line_detail_tbl_type;
15575: l_pb_details oks_qp_pkg.g_price_break_tbl_type;
15576: l_warranty_flag VARCHAR2 (2);
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;

Line 16735: oks_ihd_pvt.insert_row (p_api_version => 1.0,

16731: l_inst_dtls_tbl (i).ins_id := l_instparent_id;
16732: END LOOP;
16733:
16734: --oks_inst_history_details
16735: oks_ihd_pvt.insert_row (p_api_version => 1.0,
16736: p_init_msg_list => 'T',
16737: x_return_status => l_return_status,
16738: x_msg_count => l_msg_count,
16739: x_msg_data => l_msg_data,

Line 16751: 'oks_ihd_pvt.insert_row(Return status = '

16747: fnd_log.STRING
16748: (fnd_log.level_event,
16749: g_module_current
16750: || '.CREATE_CONTRACT_IBUPDATE',
16751: 'oks_ihd_pvt.insert_row(Return status = '
16752: || l_return_status
16753: || ')'
16754: );
16755: END IF;