DBA Data[Home] [Help]

APPS.OKS_EXTWARPRGM_PVT dependencies on OKS_IHD_PVT

Line 5848: x_inst_dtls_tbl IN OUT NOCOPY oks_ihd_pvt.ihdv_tbl_type,

5844: p_salescredit_tbl_hdr_in IN oks_extwarprgm_pvt.salescredit_tbl,
5845: --mmadhavi bug 4174921
5846: p_salescredit_tbl_line_in IN oks_extwarprgm_pvt.salescredit_tbl,
5847: p_price_attribs_in IN oks_extwarprgm_pvt.pricing_attributes_type,
5848: x_inst_dtls_tbl IN OUT NOCOPY oks_ihd_pvt.ihdv_tbl_type,
5849: x_chrid OUT NOCOPY NUMBER,
5850: x_return_status OUT NOCOPY VARCHAR2,
5851: x_msg_count OUT NOCOPY NUMBER,
5852: x_msg_data OUT NOCOPY VARCHAR2

Line 6913: x_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;

6909: FROM csi_item_instances
6910: WHERE instance_id = p_cp_id;
6911:
6912: l_ref_num VARCHAR2 (30);
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;

Line 6914: l_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;

6910: WHERE instance_id = p_cp_id;
6911:
6912: l_ref_num VARCHAR2 (30);
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;

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

7627: l_inst_dtls_tbl (i).ins_id := l_instparent_id;
7628: END LOOP;
7629:
7630: --oks_inst_history_details
7631: oks_ihd_pvt.insert_row (p_api_version => 1.0,
7632: p_init_msg_list => 'T',
7633: x_return_status => l_return_status,
7634: x_msg_count => x_msg_count,
7635: x_msg_data => x_msg_data,

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

7641: THEN
7642: fnd_log.STRING
7643: (fnd_log.level_event,
7644: g_module_current || '.CREATE_K_IBSPLIT',
7645: 'oks_ihd_pvt.insert_row(Return status = '
7646: || l_return_status
7647: || ')'
7648: );
7649: END IF;

Line 7801: x_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;

7797: FROM csi_item_instances
7798: WHERE instance_id = p_cp_id;
7799:
7800: l_ref_num VARCHAR2 (30);
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;

Line 7802: l_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;

7798: WHERE instance_id = p_cp_id;
7799:
7800: l_ref_num VARCHAR2 (30);
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;

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

8645: l_inst_dtls_tbl (i).ins_id := l_instparent_id;
8646: END LOOP;
8647:
8648: --oks_inst_history_details
8649: oks_ihd_pvt.insert_row (p_api_version => 1.0,
8650: p_init_msg_list => 'T',
8651: x_return_status => l_return_status,
8652: x_msg_count => x_msg_count,
8653: x_msg_data => x_msg_data,

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

8659: THEN
8660: fnd_log.STRING
8661: (fnd_log.level_event,
8662: g_module_current || '.CREATE_K_IBREPLACE',
8663: 'oks_ihd_pvt.insert_row(Return status = '
8664: || l_return_status
8665: || ')'
8666: );
8667: END IF;

Line 8755: x_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;

8751:
8752: l_hdr_status Varchar2(240);
8753:
8754: l_ref_num VARCHAR2 (30);
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;

Line 8756: l_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;

8752: l_hdr_status Varchar2(240);
8753:
8754: l_ref_num VARCHAR2 (30);
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;

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

9361: END IF;
9362:
9363: l_inst_dtls_tbl (1).ins_id := l_instparent_id;
9364: --oks_inst_history_details
9365: oks_ihd_pvt.insert_row (p_api_version => 1.0,
9366: p_init_msg_list => 'T',
9367: x_return_status => l_return_status,
9368: x_msg_count => x_msg_count,
9369: x_msg_data => x_msg_data,

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

9375: THEN
9376: fnd_log.STRING
9377: (fnd_log.level_event,
9378: g_module_current || '.CREATE_IBRETURN',
9379: 'oks_ihd_pvt.insert_row(Return status = '
9380: || l_return_status
9381: || ')'
9382: );
9383: END IF;

Line 9629: l_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;

9625: l_covlvl_id NUMBER;
9626: i NUMBER;
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;

Line 9630: x_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;

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

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

14074: -- FIx for bug 2408704
14075: END LOOP;
14076:
14077: --oks_inst_history_details
14078: oks_ihd_pvt.insert_row (p_api_version => 1.0,
14079: p_init_msg_list => 'T',
14080: x_return_status => l_return_status,
14081: x_msg_count => l_msg_count,
14082: x_msg_data => l_msg_data,

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

14089: THEN
14090: fnd_log.STRING
14091: (fnd_log.level_event,
14092: g_module_current || '.CREATE_K_SYSTEM_TRF',
14093: 'oks_ihd_pvt.insert_row(Return status = '
14094: || l_return_status
14095: || ')'
14096: );
14097: END IF;

Line 14197: x_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;

14193:
14194: l_hdr_status Varchar2(240);
14195:
14196: l_ref_num VARCHAR2 (30);
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;

Line 14198: l_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;

14194: l_hdr_status Varchar2(240);
14195:
14196: l_ref_num VARCHAR2 (30);
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;

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

14805: END IF;
14806:
14807: l_inst_dtls_tbl (l_ptr).ins_id := l_instparent_id;
14808: --oks_inst_history_details
14809: oks_ihd_pvt.insert_row (p_api_version => 1.0,
14810: p_init_msg_list => 'T',
14811: x_return_status => l_return_status,
14812: x_msg_count => x_msg_count,
14813: x_msg_data => x_msg_data,

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

14819: THEN
14820: fnd_log.STRING
14821: (fnd_log.level_event,
14822: g_module_current || '.CREATE_IBTERMINATE',
14823: 'oks_ihd_pvt.insert_row(Return status = '
14824: || l_return_status
14825: || ')'
14826: );
14827: END IF;

Line 14963: x_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;

14959: FROM csi_item_instances
14960: WHERE instance_id = p_cp_id;
14961:
14962: l_ref_num VARCHAR2 (30);
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;

Line 14964: l_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;

14960: WHERE instance_id = p_cp_id;
14961:
14962: l_ref_num VARCHAR2 (30);
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;

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

15706: END IF;
15707:
15708: l_inst_dtls_tbl (1).ins_id := l_instparent_id;
15709: --oks_inst_history_details
15710: oks_ihd_pvt.insert_row (p_api_version => 1.0,
15711: p_init_msg_list => 'T',
15712: x_return_status => l_return_status,
15713: x_msg_count => x_msg_count,
15714: x_msg_data => x_msg_data,

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

15720: THEN
15721: fnd_log.STRING
15722: (fnd_log.level_event,
15723: g_module_current || '.UPDATE_CONTRACT_IDC',
15724: 'oks_ihd_pvt.insert_row(Return status = '
15725: || l_return_status
15726: || ')'
15727: );
15728: END IF;

Line 15875: l_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;

15871: l_output_details oks_qp_pkg.price_details;
15872: l_modif_details qp_preq_grp.line_detail_tbl_type;
15873: l_pb_details oks_qp_pkg.g_price_break_tbl_type;
15874: l_warranty_flag VARCHAR2 (2);
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;

Line 15876: x_inst_dtls_tbl oks_ihd_pvt.ihdv_tbl_type;

15872: l_modif_details qp_preq_grp.line_detail_tbl_type;
15873: l_pb_details oks_qp_pkg.g_price_break_tbl_type;
15874: l_warranty_flag VARCHAR2 (2);
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;

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

17029: l_inst_dtls_tbl (i).ins_id := l_instparent_id;
17030: END LOOP;
17031:
17032: --oks_inst_history_details
17033: oks_ihd_pvt.insert_row (p_api_version => 1.0,
17034: p_init_msg_list => 'T',
17035: x_return_status => l_return_status,
17036: x_msg_count => l_msg_count,
17037: x_msg_data => l_msg_data,

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

17045: fnd_log.STRING
17046: (fnd_log.level_event,
17047: g_module_current
17048: || '.CREATE_CONTRACT_IBUPDATE',
17049: 'oks_ihd_pvt.insert_row(Return status = '
17050: || l_return_status
17051: || ')'
17052: );
17053: END IF;