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_PAY_INVOICES_CONS_PVT dependencies on OKL_DISB_RULE_VENDOR_SITES

Line 73: okl_disb_rule_vendor_sites drv,

69: drv.invoice_seq_end,
70: drv.next_inv_seq,
71: drv.disb_rule_vendor_site_id
72: from okl_disb_rules_all_b dra,
73: okl_disb_rule_vendor_sites drv,
74: okl_disb_rule_sty_types drs
75: where drv.disb_rule_id = dra.disb_rule_id
76: and drs.disb_rule_id = dra.disb_rule_id
77: and drv.vendor_id = p_vendor_id

Line 193: l_inv_seq_start okl_disb_rule_vendor_sites.invoice_seq_start%type;

189: l_api_version CONSTANT NUMBER := 1;
190: l_api_name CONSTANT VARCHAR2(30) := 'handle_next_invoice_seq';
191: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
192: --
193: l_inv_seq_start okl_disb_rule_vendor_sites.invoice_seq_start%type;
194: l_inv_seq_end okl_disb_rule_vendor_sites.invoice_seq_end%type;
195: l_next_inv_seq okl_disb_rule_vendor_sites.next_inv_seq%type;
196: l_new_next_inv_seq okl_disb_rule_vendor_sites.next_inv_seq%type := NULL;
197:

Line 194: l_inv_seq_end okl_disb_rule_vendor_sites.invoice_seq_end%type;

190: l_api_name CONSTANT VARCHAR2(30) := 'handle_next_invoice_seq';
191: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
192: --
193: l_inv_seq_start okl_disb_rule_vendor_sites.invoice_seq_start%type;
194: l_inv_seq_end okl_disb_rule_vendor_sites.invoice_seq_end%type;
195: l_next_inv_seq okl_disb_rule_vendor_sites.next_inv_seq%type;
196: l_new_next_inv_seq okl_disb_rule_vendor_sites.next_inv_seq%type := NULL;
197:
198: l_disb_rules disb_rules_type;

Line 195: l_next_inv_seq okl_disb_rule_vendor_sites.next_inv_seq%type;

191: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
192: --
193: l_inv_seq_start okl_disb_rule_vendor_sites.invoice_seq_start%type;
194: l_inv_seq_end okl_disb_rule_vendor_sites.invoice_seq_end%type;
195: l_next_inv_seq okl_disb_rule_vendor_sites.next_inv_seq%type;
196: l_new_next_inv_seq okl_disb_rule_vendor_sites.next_inv_seq%type := NULL;
197:
198: l_disb_rules disb_rules_type;
199: lx_rule_found BOOLEAN := FALSE;

Line 196: l_new_next_inv_seq okl_disb_rule_vendor_sites.next_inv_seq%type := NULL;

192: --
193: l_inv_seq_start okl_disb_rule_vendor_sites.invoice_seq_start%type;
194: l_inv_seq_end okl_disb_rule_vendor_sites.invoice_seq_end%type;
195: l_next_inv_seq okl_disb_rule_vendor_sites.next_inv_seq%type;
196: l_new_next_inv_seq okl_disb_rule_vendor_sites.next_inv_seq%type := NULL;
197:
198: l_disb_rules disb_rules_type;
199: lx_rule_found BOOLEAN := FALSE;
200: lx_return_status VARCHAR2(30) := G_RET_STS_SUCCESS;

Line 203: l_curr_next_inv_seq okl_disb_rule_vendor_sites.next_inv_seq%type; -- bug: 6662247

199: lx_rule_found BOOLEAN := FALSE;
200: lx_return_status VARCHAR2(30) := G_RET_STS_SUCCESS;
201:
202: l_update_flag boolean := TRUE; -- bug: 6662247
203: l_curr_next_inv_seq okl_disb_rule_vendor_sites.next_inv_seq%type; -- bug: 6662247
204:
205: BEGIN
206: ------------------------------------------------------------
207: -- Start processing

Line 320: -- Update okl_disb_rule_vendor_sites

316: -- END IF;
317:
318:
319: IF l_update_flag = TRUE THEN
320: -- Update okl_disb_rule_vendor_sites
321: UPDATE okl_disb_rule_vendor_sites
322: SET next_inv_seq = l_new_next_inv_seq
323: WHERE disb_rule_vendor_site_id = l_disb_rules.drv_rec.disb_rule_vendor_site_id
324: AND disb_rule_id = l_disb_rules.dra_rec.disb_rule_id;

Line 321: UPDATE okl_disb_rule_vendor_sites

317:
318:
319: IF l_update_flag = TRUE THEN
320: -- Update okl_disb_rule_vendor_sites
321: UPDATE okl_disb_rule_vendor_sites
322: SET next_inv_seq = l_new_next_inv_seq
323: WHERE disb_rule_vendor_site_id = l_disb_rules.drv_rec.disb_rule_vendor_site_id
324: AND disb_rule_id = l_disb_rules.dra_rec.disb_rule_id;
325: END IF;

Line 1119: okl_disb_rule_vendor_sites drv,

1115: drv.next_inv_seq,
1116: drv.disb_rule_vendor_site_id,
1117: drv.disb_rule_id
1118: from okl_disb_rules_all_b dra,
1119: okl_disb_rule_vendor_sites drv,
1120: okl_disb_rule_sty_types drs
1121: where drv.DISB_RULE_ID = dra.disb_rule_id
1122: and drs.disb_rule_id = dra.disb_rule_id
1123: and drv.vendor_id = vId

Line 1497: update okl_disb_rule_vendor_sites

1493:
1494: If l_found_rule_YN = 'Y' THEN
1495:
1496: l_cnsld_invs(i).cin_rec.self_bill_inv_num := l_next_inv_seq;
1497: update okl_disb_rule_vendor_sites
1498: set next_inv_seq = l_new_next_inv_seq
1499: where disb_rule_vendor_site_id = r_disb_rules.disb_rule_vendor_site_id
1500: and disb_rule_id = r_disb_rules.disb_rule_id;
1501: