DBA Data[Home] [Help]

APPS.OKL_SETUP_DISB_RULES_PVT dependencies on OKL_DISB_RULES_V

Line 352: , p_disb_rule_id IN okl_disb_rules_v.disb_rule_id%TYPE

348: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
349: , x_return_status OUT NOCOPY VARCHAR2
350: , x_msg_count OUT NOCOPY NUMBER
351: , x_msg_data OUT NOCOPY VARCHAR2
352: , p_disb_rule_id IN okl_disb_rules_v.disb_rule_id%TYPE
353: , p_vendor_id IN OKL_DISB_RULE_VENDOR_SITES.vendor_id%TYPE
354: , p_new_drv_tbl IN drv_tbl_type
355: )
356: IS

Line 503: l_disb_rule_id okl_disb_rules_v.disb_rule_id%TYPE;

499:
500: l_drav_rec drav_rec_type;
501: l_drs_tbl drs_tbl_type;
502: l_drs_rec drs_rec_type;
503: l_disb_rule_id okl_disb_rules_v.disb_rule_id%TYPE;
504:
505: lp_drv_tbl drv_tbl_type;
506: lp_drv_rec drv_rec_type;
507: lx_drv_tbl drv_tbl_type;

Line 841: , p_disb_rule_name IN OKL_DISB_RULES_V.RULE_NAME%TYPE

837: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
838: , x_return_status OUT NOCOPY VARCHAR2
839: , x_msg_count OUT NOCOPY NUMBER
840: , x_msg_data OUT NOCOPY VARCHAR2
841: , p_disb_rule_name IN OKL_DISB_RULES_V.RULE_NAME%TYPE
842: )
843: IS
844: l_api_name CONSTANT VARCHAR2(40) := 'validate_disb_rule_name';
845: l_api_version CONSTANT NUMBER := 1;

Line 921: -- p_drav_rec - record type for OKL_DISB_RULES_V

917: -- Function : validates disbursement rule
918: -- Parameters :
919: -- IN : p_api_version - Standard input parameter
920: -- p_init_msg_list - Standard input parameter
921: -- p_drav_rec - record type for OKL_DISB_RULES_V
922: -- p_drs_tbl - record type for OKL_DISB_RULE_STY_TYPES
923: -- p_drv_rec - record type for OKL_DISB_RULE_VENDOR_SITES
924: -- Version : 1.0
925: -- History : gboomina created.

Line 1091: -- p_drav_rec - record type for OKL_DISB_RULES_V

1087: -- OKL_DISB_RULE_STY_TYPES and OKL_DISB_RULE_VENDOR_SITES
1088: -- Parameters :
1089: -- IN : p_api_version - Standard input parameter
1090: -- p_init_msg_list - Standard input parameter
1091: -- p_drav_rec - record type for OKL_DISB_RULES_V
1092: -- p_drs_tbl - record type for OKL_DISB_RULE_STY_TYPES
1093: -- p_drv_rec - record type for OKL_DISB_RULE_VENDOR_SITES
1094: -- Version : 1.0
1095: -- History : gboomina created.

Line 1316: , p_disb_rule_id IN okl_disb_rules_v.disb_rule_id%type

1312: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1313: , x_return_status OUT NOCOPY VARCHAR2
1314: , x_msg_count OUT NOCOPY NUMBER
1315: , x_msg_data OUT NOCOPY VARCHAR2
1316: , p_disb_rule_id IN okl_disb_rules_v.disb_rule_id%type
1317: , p_new_drs_tbl IN drs_tbl_type
1318: )
1319: IS
1320: l_api_name CONSTANT VARCHAR2(40) := 'delete_disb_rule_sty_types';

Line 1442: -- p_drav_rec - record type for OKL_DISB_RULES_V

1438: -- OKL_DISB_RULE_STY_TYPES and OKL_DISB_RULE_VENDOR_SITES
1439: -- Parameters :
1440: -- IN : p_api_version - Standard input parameter
1441: -- p_init_msg_list - Standard input parameter
1442: -- p_drav_rec - record type for OKL_DISB_RULES_V
1443: -- p_drs_tbl - record type for OKL_DISB_RULE_STY_TYPES
1444: -- p_drv_rec - record type for OKL_DISB_RULE_VENDOR_SITES
1445: -- Version : 1.0
1446: -- History : gboomina created.

Line 1565: -- Delete the rows from OKL_DISB_RULES_VENDOR_SITES which

1561: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1562: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1563: RAISE OKL_API.G_EXCEPTION_ERROR;
1564: END IF;
1565: -- Delete the rows from OKL_DISB_RULES_VENDOR_SITES which
1566: -- are removed during update operation.
1567: del_disb_rule_vendor_sites( p_api_version => l_api_version
1568: , p_init_msg_list => p_init_msg_list
1569: , x_return_status => x_return_status