DBA Data[Home] [Help]

APPS.OKL_PROCESS_SALES_TAX_PVT dependencies on OKC_RULES_B

Line 7270: ,x_rulv_rec => l_rulv_rec -- hold a rule instance from okc_rules_b

7266: ,p_rdf_code => 'AMBPOC'
7267: ,p_chr_id => p_khr_id
7268: ,p_cle_id => NULL
7269: ,p_message_yn => FALSE
7270: ,x_rulv_rec => l_rulv_rec -- hold a rule instance from okc_rules_b
7271: ,x_return_status => x_return_status
7272: ,x_msg_count => x_msg_count
7273: ,x_msg_data => x_msg_data);
7274:

Line 7294: ,x_rulv_rec => l_rulv_rec -- hold a rule instance from okc_rules_b

7290: ,p_rdf_code => 'AMBPOC'
7291: ,p_chr_id => p_khr_id
7292: ,p_cle_id => NULL
7293: ,p_message_yn => FALSE
7294: ,x_rulv_rec => l_rulv_rec -- hold a rule instance from okc_rules_b
7295: ,x_return_status => x_return_status
7296: ,x_msg_count => x_msg_count
7297: ,x_msg_data => x_msg_data);
7298:

Line 7319: ,x_rulv_rec => l_rulv_rec -- hold a rule instance from okc_rules_b

7315: ,p_rdf_code => 'LASTCL'
7316: ,p_chr_id => p_khr_id
7317: ,p_cle_id => NULL
7318: ,p_message_yn => FALSE
7319: ,x_rulv_rec => l_rulv_rec -- hold a rule instance from okc_rules_b
7320: ,x_return_status => x_return_status
7321: ,x_msg_count => x_msg_count
7322: ,x_msg_data => x_msg_data);
7323:

Line 7359: ,x_rulv_rec => l_rulv_rec -- hold a rule instance from okc_rules_b

7355: ,p_rdf_code => 'AMBPOC'
7356: ,p_chr_id => p_khr_id
7357: ,p_cle_id => NULL
7358: ,p_message_yn => FALSE
7359: ,x_rulv_rec => l_rulv_rec -- hold a rule instance from okc_rules_b
7360: ,x_return_status => x_return_status
7361: ,x_msg_count => x_msg_count
7362: ,x_msg_data => x_msg_data);
7363:

Line 7383: ,x_rulv_rec => l_rulv_rec -- hold a rule instance from okc_rules_b

7379: ,p_rdf_code => 'AMBPOC'
7380: ,p_chr_id => p_khr_id
7381: ,p_cle_id => NULL
7382: ,p_message_yn => FALSE
7383: ,x_rulv_rec => l_rulv_rec -- hold a rule instance from okc_rules_b
7384: ,x_return_status => x_return_status
7385: ,x_msg_count => x_msg_count
7386: ,x_msg_data => x_msg_data);
7387:

Line 7407: ,x_rulv_rec => l_rulv_rec -- hold a rule instance from okc_rules_b

7403: ,p_rdf_code => 'LASTCL'
7404: ,p_chr_id => p_khr_id
7405: ,p_cle_id => NULL
7406: ,p_message_yn => FALSE
7407: ,x_rulv_rec => l_rulv_rec -- hold a rule instance from okc_rules_b
7408: ,x_return_status => x_return_status
7409: ,x_msg_count => x_msg_count
7410: ,x_msg_data => x_msg_data);
7411:

Line 7444: ,x_rulv_rec => l_rulv_rec -- hold a rule instance from okc_rules_b

7440: ,p_rdf_code => 'AMBPOC'
7441: ,p_chr_id => p_khr_id
7442: ,p_cle_id => NULL
7443: ,p_message_yn => FALSE
7444: ,x_rulv_rec => l_rulv_rec -- hold a rule instance from okc_rules_b
7445: ,x_return_status => x_return_status
7446: ,x_msg_count => x_msg_count
7447: ,x_msg_data => x_msg_data);
7448:

Line 7466: ,x_rulv_rec => l_rulv_rec -- hold a rule instance from okc_rules_b

7462: ,p_rdf_code => 'LASTCL'
7463: ,p_chr_id => p_khr_id
7464: ,p_cle_id => NULL
7465: ,p_message_yn => FALSE
7466: ,x_rulv_rec => l_rulv_rec -- hold a rule instance from okc_rules_b
7467: ,x_return_status => x_return_status
7468: ,x_msg_count => x_msg_count
7469: ,x_msg_data => x_msg_data);
7470:

Line 7500: ,x_rulv_rec => l_rulv_rec -- hold a rule instance from okc_rules_b

7496: ,p_rdf_code => 'AMBPOC'
7497: ,p_chr_id => p_khr_id
7498: ,p_cle_id => NULL
7499: ,p_message_yn => FALSE
7500: ,x_rulv_rec => l_rulv_rec -- hold a rule instance from okc_rules_b
7501: ,x_return_status => x_return_status
7502: ,x_msg_count => x_msg_count
7503: ,x_msg_data => x_msg_data);
7504:

Line 7522: ,x_rulv_rec => l_rulv_rec -- hold a rule instance from okc_rules_b

7518: ,p_rdf_code => 'LASTCL'
7519: ,p_chr_id => p_khr_id
7520: ,p_cle_id => NULL
7521: ,p_message_yn => FALSE
7522: ,x_rulv_rec => l_rulv_rec -- hold a rule instance from okc_rules_b
7523: ,x_return_status => x_return_status
7524: ,x_msg_count => x_msg_count
7525: ,x_msg_data => x_msg_data);
7526:

Line 7860: ,x_rulv_rec => l_rulv_rec -- hold a rule instance from okc_rules_b

7856: ,p_rdf_code => 'LAASTX'
7857: ,p_chr_id => p_khr_id
7858: ,p_cle_id => p_kle_id
7859: ,p_message_yn => FALSE
7860: ,x_rulv_rec => l_rulv_rec -- hold a rule instance from okc_rules_b
7861: ,x_return_status => x_return_status
7862: ,x_msg_count => x_msg_count
7863: ,x_msg_data => x_msg_data);
7864:

Line 7888: ,x_rulv_rec => l_rulv_rec -- hold a rule instance from okc_rules_b

7884: ,p_rdf_code => 'LAASTX'
7885: ,p_chr_id => p_khr_id
7886: ,p_cle_id => p_kle_id
7887: ,p_message_yn => FALSE
7888: ,x_rulv_rec => l_rulv_rec -- hold a rule instance from okc_rules_b
7889: ,x_return_status => x_return_status
7890: ,x_msg_count => x_msg_count
7891: ,x_msg_data => x_msg_data);
7892:

Line 7917: ,x_rulv_rec => l_rulv_rec -- hold a rule instance from okc_rules_b

7913: ,p_rdf_code => 'LAASTX'
7914: ,p_chr_id => p_khr_id
7915: ,p_cle_id => p_kle_id
7916: ,p_message_yn => FALSE
7917: ,x_rulv_rec => l_rulv_rec -- hold a rule instance from okc_rules_b
7918: ,x_return_status => x_return_status
7919: ,x_msg_count => x_msg_count
7920: ,x_msg_data => x_msg_data);
7921:

Line 7946: ,x_rulv_rec => l_rulv_rec -- hold a rule instance from okc_rules_b

7942: ,p_rdf_code => 'LAASTX'
7943: ,p_chr_id => p_khr_id
7944: ,p_cle_id => p_kle_id
7945: ,p_message_yn => FALSE
7946: ,x_rulv_rec => l_rulv_rec -- hold a rule instance from okc_rules_b
7947: ,x_return_status => x_return_status
7948: ,x_msg_count => x_msg_count
7949: ,x_msg_data => x_msg_data);
7950:

Line 7971: ,x_rulv_rec => l_rulv_rec -- hold a rule instance from okc_rules_b

7967: ,p_rdf_code => 'LAASTX'
7968: ,p_chr_id => p_khr_id
7969: ,p_cle_id => p_kle_id
7970: ,p_message_yn => FALSE
7971: ,x_rulv_rec => l_rulv_rec -- hold a rule instance from okc_rules_b
7972: ,x_return_status => x_return_status
7973: ,x_msg_count => x_msg_count
7974: ,x_msg_data => x_msg_data);
7975:

Line 13288: okc_rules_b rulb,

13284: styb.CODE stream_type_code,
13285: sum(nvl((rulb2.RULE_INFORMATION3 * rulb2.RULE_INFORMATION6),0) + nvl(rulb2.RULE_INFORMATION8,0)) line_amt
13286: FROM
13287: okc_rule_groups_b rgpb,
13288: okc_rules_b rulb,
13289: okc_rules_b rulb2,
13290: okl_strm_type_b styb
13291: WHERE rgpb.dnz_chr_id = cp_chr_id
13292: AND rgpb.chr_id = cp_chr_id

Line 13289: okc_rules_b rulb2,

13285: sum(nvl((rulb2.RULE_INFORMATION3 * rulb2.RULE_INFORMATION6),0) + nvl(rulb2.RULE_INFORMATION8,0)) line_amt
13286: FROM
13287: okc_rule_groups_b rgpb,
13288: okc_rules_b rulb,
13289: okc_rules_b rulb2,
13290: okl_strm_type_b styb
13291: WHERE rgpb.dnz_chr_id = cp_chr_id
13292: AND rgpb.chr_id = cp_chr_id
13293: AND rgpb.cle_id IS NULL

Line 13320: okc_rules_b rulb,

13316: styb.CODE stream_type_code,
13317: sum(nvl((rulb2.RULE_INFORMATION3 * rulb2.RULE_INFORMATION6),0) + nvl(rulb2.RULE_INFORMATION8,0)) line_amt
13318: FROM okc_k_lines_b cleb,
13319: okc_rule_groups_b rgpb,
13320: okc_rules_b rulb,
13321: okc_rules_b rulb2,
13322: okl_strm_type_b styb
13323: WHERE rgpb.dnz_chr_id = cp_chr_id
13324: AND rgpb.chr_id IS NULL

Line 13321: okc_rules_b rulb2,

13317: sum(nvl((rulb2.RULE_INFORMATION3 * rulb2.RULE_INFORMATION6),0) + nvl(rulb2.RULE_INFORMATION8,0)) line_amt
13318: FROM okc_k_lines_b cleb,
13319: okc_rule_groups_b rgpb,
13320: okc_rules_b rulb,
13321: okc_rules_b rulb2,
13322: okl_strm_type_b styb
13323: WHERE rgpb.dnz_chr_id = cp_chr_id
13324: AND rgpb.chr_id IS NULL
13325: AND rgpb.cle_id = cleb.id

Line 17569: FROM okc_rules_b rul,

17565: WHERE org_id = cp_org_id;
17566:
17567: CURSOR l_tax_schedule_csr(cp_trx_id IN NUMBER) IS
17568: SELECT rul.rule_information5
17569: FROM okc_rules_b rul,
17570: okc_rule_groups_b rgp,
17571: okl_trx_requests trx
17572: WHERE rgp.dnz_chr_id = trx.dnz_khr_id
17573: AND rul.rgp_id = rgp.id