DBA Data[Home] [Help]

APPS.OKS_COVERAGES_PVT dependencies on OKC_RULE_PUB

Line 177: PROCEDURE Init_RGPV(P_RGPV_tbl_in_Out IN OUT NOCOPY okc_Rule_Pub.Rgpv_tbl_type)

173: END LOOP;
174: END IF;
175: END INIT_CLEV;
176:
177: PROCEDURE Init_RGPV(P_RGPV_tbl_in_Out IN OUT NOCOPY okc_Rule_Pub.Rgpv_tbl_type)
178: IS
179:
180: BEGIN
181: IF NOT P_Rgpv_Tbl_In_Out.COUNT=0

Line 217: PROCEDURE Init_RGPV(P_RGPV_rec_in_Out IN OUT NOCOPY okc_Rule_Pub.Rgpv_rec_type)

213: p_rgpv_tbl_IN_out(v_Index).rgp_type :=NULL;
214: END LOOP;
215: END IF;
216: END INIT_RGPV;
217: PROCEDURE Init_RGPV(P_RGPV_rec_in_Out IN OUT NOCOPY okc_Rule_Pub.Rgpv_rec_type)
218: IS
219:
220: BEGIN
221: p_rgpv_rec_IN_out.id :=NULL;

Line 254: PROCEDURE Init_RULV(P_RULV_tbl_in_Out IN OUT NOCOPY okc_Rule_Pub.Rulv_tbl_type)

250: END INIT_RGPV;
251:
252:
253:
254: PROCEDURE Init_RULV(P_RULV_tbl_in_Out IN OUT NOCOPY okc_Rule_Pub.Rulv_tbl_type)
255: IS
256:
257: BEGIN
258: IF NOT P_RULV_tbl_in_Out.COUNT=0

Line 783: l_ctiv_tbl_in okc_rule_pub.ctiv_tbl_type;

779: tmp_crt_cle_id NUMBER;
780: tmp_bt_cle_id NUMBER;
781: tmp_br_cle_id NUMBER;
782: g_Chr_Id NUMBER;
783: l_ctiv_tbl_in okc_rule_pub.ctiv_tbl_type;
784: l_ctiv_tbl_out okc_rule_pub.ctiv_tbl_type;
785: l_contact_Id Number;
786: l_bill_rate_tbl_in OKS_BRS_PVT.OKSBILLRATESCHEDULESVTBLTYPE;
787: x_bill_rate_tbl_out OKS_BRS_PVT.OKSBILLRATESCHEDULESVTBLTYPE;

Line 784: l_ctiv_tbl_out okc_rule_pub.ctiv_tbl_type;

780: tmp_bt_cle_id NUMBER;
781: tmp_br_cle_id NUMBER;
782: g_Chr_Id NUMBER;
783: l_ctiv_tbl_in okc_rule_pub.ctiv_tbl_type;
784: l_ctiv_tbl_out okc_rule_pub.ctiv_tbl_type;
785: l_contact_Id Number;
786: l_bill_rate_tbl_in OKS_BRS_PVT.OKSBILLRATESCHEDULESVTBLTYPE;
787: x_bill_rate_tbl_out OKS_BRS_PVT.OKSBILLRATESCHEDULESVTBLTYPE;
788: --

Line 3875: l_rgpv_tbl_in okc_rule_pub.rgpv_tbl_type;

3871: line_det_rec line_det_Cur%ROWTYPE;
3872: l_child_cur_rec Child_cur%rowtype;
3873: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
3874: l_clev_tbl_tmp okc_contract_pub.clev_tbl_type;
3875: l_rgpv_tbl_in okc_rule_pub.rgpv_tbl_type;
3876: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;
3877: l_cimv_tbl_in okc_Contract_Item_Pub.cimv_tbl_TYPE;
3878: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;
3879: l_cplv_tbl_in okc_contract_party_pub.cplv_tbl_type;

Line 3876: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;

3872: l_child_cur_rec Child_cur%rowtype;
3873: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
3874: l_clev_tbl_tmp okc_contract_pub.clev_tbl_type;
3875: l_rgpv_tbl_in okc_rule_pub.rgpv_tbl_type;
3876: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;
3877: l_cimv_tbl_in okc_Contract_Item_Pub.cimv_tbl_TYPE;
3878: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;
3879: l_cplv_tbl_in okc_contract_party_pub.cplv_tbl_type;
3880: l_crjv_tbl_in okc_k_rel_objs_pub.crjv_tbl_type;

Line 4200: okc_Rule_pub.delete_Rule (

4196: OKC_API.Set_Message(G_APP_NAME,G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ERROR IN DELETING LEVEL_ELEMENTS');
4197: RETURN;
4198: END IF;
4199:
4200: okc_Rule_pub.delete_Rule (
4201: p_api_version => l_api_version,
4202: p_init_msg_list => l_init_msg_list,
4203: x_return_status => l_return_status,
4204: x_msg_count => l_msg_count,

Line 4227: okc_Rule_pub.delete_Rule_group (

4223: END IF;
4224:
4225: IF NOT l_rgpv_tbl_in.COUNT=0
4226: THEN
4227: okc_Rule_pub.delete_Rule_group (
4228: p_api_version => l_api_version,
4229: p_init_msg_list => l_init_msg_list,
4230: x_return_status => l_return_status,
4231: x_msg_count => l_msg_count,

Line 6115: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type ;

6111: l_msg_data VARCHAR2(2000):=null;
6112: l_api_name VARCHAR2(80):= 'OKS_MIGRATE_BILLRATES';
6113: G_PKG_NAME VARCHAR2(80):= 'OKS_COVERAGES_PVT' ;
6114:
6115: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type ;
6116: l_rulv_tbl_out okc_rule_pub.rulv_tbl_type ;
6117: BEGIN
6118:
6119: FOR br_rec IN CUR_GET_BILLRATES

Line 6116: l_rulv_tbl_out okc_rule_pub.rulv_tbl_type ;

6112: l_api_name VARCHAR2(80):= 'OKS_MIGRATE_BILLRATES';
6113: G_PKG_NAME VARCHAR2(80):= 'OKS_COVERAGES_PVT' ;
6114:
6115: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type ;
6116: l_rulv_tbl_out okc_rule_pub.rulv_tbl_type ;
6117: BEGIN
6118:
6119: FOR br_rec IN CUR_GET_BILLRATES
6120: LOOP

Line 6265: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type ;

6261: l_bill_rate_tbl_in OKS_BRS_PVT.OKSBILLRATESCHEDULESVTBLTYPE ;
6262: x_bill_rate_tbl_out OKS_BRS_PVT.OKSBILLRATESCHEDULESVTBLTYPE ;
6263: l_clev_tbl_in OKC_CONTRACT_PUB.clev_tbl_type ;
6264: l_clev_tbl_out OKC_CONTRACT_PUB.clev_tbl_type ;
6265: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type ;
6266: l_rulv_tbl_out okc_rule_pub.rulv_tbl_type ;
6267: l_cle_id NUMBER;
6268: l_bill_rate_code VARCHAR2(30);
6269:

Line 6266: l_rulv_tbl_out okc_rule_pub.rulv_tbl_type ;

6262: x_bill_rate_tbl_out OKS_BRS_PVT.OKSBILLRATESCHEDULESVTBLTYPE ;
6263: l_clev_tbl_in OKC_CONTRACT_PUB.clev_tbl_type ;
6264: l_clev_tbl_out OKC_CONTRACT_PUB.clev_tbl_type ;
6265: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type ;
6266: l_rulv_tbl_out okc_rule_pub.rulv_tbl_type ;
6267: l_cle_id NUMBER;
6268: l_bill_rate_code VARCHAR2(30);
6269:
6270: l_conc_request_id NUMBER;

Line 6557: OKC_RULE_PUB.UPDATE_RULE(p_api_version => l_api_version,

6553: l_rulv_tbl_in(1).rule_information10 := 'Y';
6554: l_rulv_tbl_in(1).template_yn := bill_rate_rec.template_yn;
6555:
6556:
6557: OKC_RULE_PUB.UPDATE_RULE(p_api_version => l_api_version,
6558: p_init_msg_list => l_init_msg_list,
6559: x_return_status => l_return_status,
6560: x_msg_count => l_msg_count,
6561: x_msg_data => l_msg_data,

Line 6566: fnd_file.put_line(FND_FILE.LOG, 'AFTER OKC_RULE_PUB.UPDATE_RULE......Updating RULE_INFORMATION10 to Y');

6562: p_rulv_tbl => l_rulv_tbl_in,
6563: x_rulv_tbl => l_rulv_tbl_out); */
6564:
6565: IF fnd_global.conc_request_id <> -1 THEN
6566: fnd_file.put_line(FND_FILE.LOG, 'AFTER OKC_RULE_PUB.UPDATE_RULE......Updating RULE_INFORMATION10 to Y');
6567: -- fnd_file.put_line(FND_FILE.LOG, 'Return Status from OKC_RULE_PUB.UPDATE_RULE API...'||l_return_status);
6568: END IF;
6569:
6570:

Line 6567: -- fnd_file.put_line(FND_FILE.LOG, 'Return Status from OKC_RULE_PUB.UPDATE_RULE API...'||l_return_status);

6563: x_rulv_tbl => l_rulv_tbl_out); */
6564:
6565: IF fnd_global.conc_request_id <> -1 THEN
6566: fnd_file.put_line(FND_FILE.LOG, 'AFTER OKC_RULE_PUB.UPDATE_RULE......Updating RULE_INFORMATION10 to Y');
6567: -- fnd_file.put_line(FND_FILE.LOG, 'Return Status from OKC_RULE_PUB.UPDATE_RULE API...'||l_return_status);
6568: END IF;
6569:
6570:
6571: