eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SETUP_DISB_RULES_PVT dependencies on OKL_DISB_RULE_STY_TYPES

Line 27: CURSOR vendor_site_eff_dates_csr( p_sty_purpose IN OKL_DISB_RULE_STY_TYPES.STREAM_TYPE_PURPOSE%TYPE

23: l_exist_start_date OKL_DISB_RULE_VENDOR_SITES.START_DATE%TYPE;
24: l_exist_end_date OKL_DISB_RULE_VENDOR_SITES.END_DATE%TYPE;
25:
26:
27: CURSOR vendor_site_eff_dates_csr( p_sty_purpose IN OKL_DISB_RULE_STY_TYPES.STREAM_TYPE_PURPOSE%TYPE
28: , p_vendor_id IN OKL_DISB_RULE_VENDOR_SITES.VENDOR_ID%TYPE
29: , p_vendor_site_id IN OKL_DISB_RULE_VENDOR_SITES.VENDOR_SITE_ID%TYPE
30: , p_disb_rule_vendor_site_id IN OKL_DISB_RULE_VENDOR_SITES.DISB_RULE_VENDOR_SITE_ID%TYPE)
31: IS

Line 34: FROM okl_disb_rule_sty_types disb_sty,

30: , p_disb_rule_vendor_site_id IN OKL_DISB_RULE_VENDOR_SITES.DISB_RULE_VENDOR_SITE_ID%TYPE)
31: IS
32: SELECT disb_vsites.start_date
33: , disb_vsites.end_date
34: FROM okl_disb_rule_sty_types disb_sty,
35: okl_disb_rule_vendor_sites disb_vsites
36: WHERE disb_sty.stream_type_purpose = p_sty_purpose
37: AND disb_sty.disb_rule_id = disb_vsites.disb_rule_id
38: AND disb_vsites.vendor_id = p_vendor_id

Line 341: -- p_drs_tbl - record type for OKL_DISB_RULE_STY_TYPES

337: -- Function : validates disbursement rule vendor sites effective dates.
338: -- Parameters :
339: -- IN : p_api_version - Standard input parameter
340: -- p_init_msg_list - Standard input parameter
341: -- p_drs_tbl - record type for OKL_DISB_RULE_STY_TYPES
342: -- p_drv_rec - record type for OKL_DISB_RULE_VENDOR_SITES
343: -- Version : 1.0
344: -- History : gboomina created.
345: -- End of comments

Line 470: -- OKL_DISB_RULE_STY_TYPES and OKL_DISB_RULE_VENDOR_SITES

466: -- API name : create_v_disbursement_rulete_v_disbursement_rule
467: -- Pre-reqs : None
468: -- Function : Associate the Vendor with the Rule uses
469: -- OKL_DISB_RULES_B, OKL_DISB_RULES_TL,
470: -- OKL_DISB_RULE_STY_TYPES and OKL_DISB_RULE_VENDOR_SITES
471: -- Parameters :
472: -- IN : p_api_version - Standard input parameter
473: -- p_init_msg_list - Standard input parameter
474: -- p_drv_tbl - record type for OKL_DISB_RULE_VENDOR_SITES

Line 522: CURSOR get_drs_tbl(c_disb_rule_id OKL_DISB_RULE_STY_TYPES.DISB_RULE_ID%TYPE) IS

518: fee_percent ,consolidate_by_due_date ,frequency ,day_of_month ,scheduled_month
519: FROM OKL_DISB_RULES_B
520: WHERE DISB_RULE_ID = c_disb_rule_id;
521:
522: CURSOR get_drs_tbl(c_disb_rule_id OKL_DISB_RULE_STY_TYPES.DISB_RULE_ID%TYPE) IS
523: SELECT DISB_RULE_ID ,STREAM_TYPE_PURPOSE ,DISB_RULE_STY_TYPE_ID
524: FROM OKL_DISB_RULE_STY_TYPES
525: WHERE DISB_RULE_ID = c_disb_rule_id;
526:

Line 524: FROM OKL_DISB_RULE_STY_TYPES

520: WHERE DISB_RULE_ID = c_disb_rule_id;
521:
522: CURSOR get_drs_tbl(c_disb_rule_id OKL_DISB_RULE_STY_TYPES.DISB_RULE_ID%TYPE) IS
523: SELECT DISB_RULE_ID ,STREAM_TYPE_PURPOSE ,DISB_RULE_STY_TYPE_ID
524: FROM OKL_DISB_RULE_STY_TYPES
525: WHERE DISB_RULE_ID = c_disb_rule_id;
526:
527: CURSOR get_seq_no(c_disb_rule_vendor_site_id OKL_DISB_RULE_VENDOR_SITES.INVOICE_SEQ_START%TYPE) IS
528: SELECT INVOICE_SEQ_START ,NEXT_INV_SEQ ,INVOICE_SEQ_END

Line 922: -- p_drs_tbl - record type for OKL_DISB_RULE_STY_TYPES

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.
926: -- End of comments

Line 1087: -- OKL_DISB_RULE_STY_TYPES and OKL_DISB_RULE_VENDOR_SITES

1083: -- API name : create_disbursement_rule
1084: -- Pre-reqs : None
1085: -- Function : create disbursement rule in the following tables
1086: -- OKL_DISB_RULES_B, OKL_DISB_RULES_TL,
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

Line 1092: -- p_drs_tbl - record type for OKL_DISB_RULE_STY_TYPES

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.
1096: -- End of comments

Line 1210: -- populate the OKL_DISB_RULE_STY_TYPES table with the

1206: RAISE OKL_API.G_EXCEPTION_ERROR;
1207: END IF;
1208: --DBMS_OUTPUT.PUT_LINE('Rule Inserted');
1209: --g_debug_proc('Rule Inserted');
1210: -- populate the OKL_DISB_RULE_STY_TYPES table with the
1211: -- disb rule id returned from the okl_dra_pvt.insert_row
1212: IF ( p_drs_tbl.COUNT > 0) THEN
1213: i := p_drs_tbl.FIRST;
1214: LOOP

Line 1221: -- insert record in to OKL_DISB_RULE_STY_TYPES

1217: EXIT WHEN ( i = p_drs_tbl.LAST);
1218: i := p_drs_tbl.NEXT(i);
1219: END LOOP;
1220:
1221: -- insert record in to OKL_DISB_RULE_STY_TYPES
1222: okl_drs_pvt.insert_row( p_api_version => l_api_version
1223: , p_init_msg_list => p_init_msg_list
1224: , x_return_status => x_return_status
1225: , x_msg_count => x_msg_count

Line 1248: -- insert record in to OKL_DISB_RULE_STY_TYPES

1244: EXIT WHEN ( i = p_drv_tbl.LAST);
1245: i := p_drv_tbl.NEXT(i);
1246: END LOOP;
1247:
1248: -- insert record in to OKL_DISB_RULE_STY_TYPES
1249: okl_drv_pvt.insert_row( p_api_version => l_api_version
1250: , p_init_msg_list => p_init_msg_list
1251: , x_return_status => x_return_status
1252: , x_msg_count => x_msg_count

Line 1298: -- p_drs_tbl but in the OKL_DISB_RULE_STY_TYPES

1294: -- Start of comments
1295: -- API name : delete_disb_rule_sty_types
1296: -- Pre-reqs : None
1297: -- Function : deletes stream types which are not present in the input
1298: -- p_drs_tbl but in the OKL_DISB_RULE_STY_TYPES
1299: -- for a disbursement rule. This API deletes stream types from
1300: -- OKL_DISB_RULE_STY_TYPES table which user had deleted during
1301: -- update operation.
1302: -- Parameters :

Line 1300: -- OKL_DISB_RULE_STY_TYPES table which user had deleted during

1296: -- Pre-reqs : None
1297: -- Function : deletes stream types which are not present in the input
1298: -- p_drs_tbl but in the OKL_DISB_RULE_STY_TYPES
1299: -- for a disbursement rule. This API deletes stream types from
1300: -- OKL_DISB_RULE_STY_TYPES table which user had deleted during
1301: -- update operation.
1302: -- Parameters :
1303: -- IN : p_api_version - Standard input parameter
1304: -- p_init_msg_list - Standard input parameter

Line 1306: -- p_drs_tbl - record type for OKL_DISB_RULE_STY_TYPES

1302: -- Parameters :
1303: -- IN : p_api_version - Standard input parameter
1304: -- p_init_msg_list - Standard input parameter
1305: -- p_disb_rule_id - disbursement rule id
1306: -- p_drs_tbl - record type for OKL_DISB_RULE_STY_TYPES
1307: -- Version : 1.0
1308: -- History : gboomina created.
1309: -- End of comments
1310:

Line 1329: CURSOR old_disb_sty_types_csr( p_disb_rule_id IN OKL_DISB_RULE_STY_TYPES.DISB_RULE_ID%TYPE )

1325: l_found VARCHAR2(1) := 'N';
1326:
1327: l_drs_del_tbl drs_tbl_type;
1328:
1329: CURSOR old_disb_sty_types_csr( p_disb_rule_id IN OKL_DISB_RULE_STY_TYPES.DISB_RULE_ID%TYPE )
1330: IS
1331: SELECT disb_rule_sty_type_id
1332: FROM okl_disb_rule_sty_types
1333: WHERE disb_rule_id = p_disb_rule_id;

Line 1332: FROM okl_disb_rule_sty_types

1328:
1329: CURSOR old_disb_sty_types_csr( p_disb_rule_id IN OKL_DISB_RULE_STY_TYPES.DISB_RULE_ID%TYPE )
1330: IS
1331: SELECT disb_rule_sty_type_id
1332: FROM okl_disb_rule_sty_types
1333: WHERE disb_rule_id = p_disb_rule_id;
1334:
1335: old_sty_type_rec old_disb_sty_types_csr%rowtype;
1336:

Line 1372: -- delete record from OKL_DISB_RULE_STY_TYPES

1368: END IF;
1369: END LOOP;
1370:
1371: IF ( l_drs_del_tbl.COUNT > 0 ) THEN
1372: -- delete record from OKL_DISB_RULE_STY_TYPES
1373: okl_drs_pvt.delete_row( p_api_version => l_api_version
1374: , p_init_msg_list => p_init_msg_list
1375: , x_return_status => x_return_status
1376: , x_msg_count => x_msg_count

Line 1438: -- OKL_DISB_RULE_STY_TYPES and OKL_DISB_RULE_VENDOR_SITES

1434: -- API name : update_disbursement_rule
1435: -- Pre-reqs : None
1436: -- Function : update disbursement rule in the following tables
1437: -- OKL_DISB_RULES_B, OKL_DISB_RULES_TL,
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

Line 1443: -- p_drs_tbl - record type for OKL_DISB_RULE_STY_TYPES

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.
1447: -- End of comments

Line 1582: -- Check whether we need to create or update in to OKL_DISB_RULE_STY_TYPES table

1578: RAISE OKL_API.G_EXCEPTION_ERROR;
1579: END IF;
1580:
1581: --g_debug_proc('Update Del DRS');
1582: -- Check whether we need to create or update in to OKL_DISB_RULE_STY_TYPES table
1583: IF ( p_drs_tbl.COUNT > 0) THEN
1584: ins_count := 0;
1585: upd_count := 0;
1586: FOR i in p_drs_tbl.FIRST .. p_drs_tbl.LAST

Line 1603: -- insert record in to OKL_DISB_RULE_STY_TYPES

1599:
1600: --g_debug_proc('Count ' || ins_count || ' , ' || upd_count );
1601:
1602: IF ( l_drs_ins_tbl.COUNT > 0 ) THEN
1603: -- insert record in to OKL_DISB_RULE_STY_TYPES
1604: okl_drs_pvt.insert_row( p_api_version => l_api_version
1605: , p_init_msg_list => p_init_msg_list
1606: , x_return_status => x_return_status
1607: , x_msg_count => x_msg_count

Line 1620: -- update record in to OKL_DISB_RULE_STY_TYPES

1616: END IF;
1617:
1618: --g_debug_proc('Update Insert DRS');
1619: IF ( l_drs_upd_tbl.COUNT > 0 ) THEN
1620: -- update record in to OKL_DISB_RULE_STY_TYPES
1621: okl_drs_pvt.update_row( p_api_version => l_api_version
1622: , p_init_msg_list => p_init_msg_list
1623: , x_return_status => x_return_status
1624: , x_msg_count => x_msg_count