DBA Data[Home] [Help]

APPS.OKL_PROCESS_SALES_TAX_PVT dependencies on OKC_RULES_B

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

7235: ,p_rdf_code => 'AMBPOC'
7236: ,p_chr_id => p_khr_id
7237: ,p_cle_id => NULL
7238: ,p_message_yn => FALSE
7239: ,x_rulv_rec => l_rulv_rec -- hold a rule instance from okc_rules_b
7240: ,x_return_status => x_return_status
7241: ,x_msg_count => x_msg_count
7242: ,x_msg_data => x_msg_data);
7243:

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

7259: ,p_rdf_code => 'AMBPOC'
7260: ,p_chr_id => p_khr_id
7261: ,p_cle_id => NULL
7262: ,p_message_yn => FALSE
7263: ,x_rulv_rec => l_rulv_rec -- hold a rule instance from okc_rules_b
7264: ,x_return_status => x_return_status
7265: ,x_msg_count => x_msg_count
7266: ,x_msg_data => x_msg_data);
7267:

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

7284: ,p_rdf_code => 'LASTCL'
7285: ,p_chr_id => p_khr_id
7286: ,p_cle_id => NULL
7287: ,p_message_yn => FALSE
7288: ,x_rulv_rec => l_rulv_rec -- hold a rule instance from okc_rules_b
7289: ,x_return_status => x_return_status
7290: ,x_msg_count => x_msg_count
7291: ,x_msg_data => x_msg_data);
7292:

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

7324: ,p_rdf_code => 'AMBPOC'
7325: ,p_chr_id => p_khr_id
7326: ,p_cle_id => NULL
7327: ,p_message_yn => FALSE
7328: ,x_rulv_rec => l_rulv_rec -- hold a rule instance from okc_rules_b
7329: ,x_return_status => x_return_status
7330: ,x_msg_count => x_msg_count
7331: ,x_msg_data => x_msg_data);
7332:

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

7348: ,p_rdf_code => 'AMBPOC'
7349: ,p_chr_id => p_khr_id
7350: ,p_cle_id => NULL
7351: ,p_message_yn => FALSE
7352: ,x_rulv_rec => l_rulv_rec -- hold a rule instance from okc_rules_b
7353: ,x_return_status => x_return_status
7354: ,x_msg_count => x_msg_count
7355: ,x_msg_data => x_msg_data);
7356:

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

7372: ,p_rdf_code => 'LASTCL'
7373: ,p_chr_id => p_khr_id
7374: ,p_cle_id => NULL
7375: ,p_message_yn => FALSE
7376: ,x_rulv_rec => l_rulv_rec -- hold a rule instance from okc_rules_b
7377: ,x_return_status => x_return_status
7378: ,x_msg_count => x_msg_count
7379: ,x_msg_data => x_msg_data);
7380:

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

7409: ,p_rdf_code => 'AMBPOC'
7410: ,p_chr_id => p_khr_id
7411: ,p_cle_id => NULL
7412: ,p_message_yn => FALSE
7413: ,x_rulv_rec => l_rulv_rec -- hold a rule instance from okc_rules_b
7414: ,x_return_status => x_return_status
7415: ,x_msg_count => x_msg_count
7416: ,x_msg_data => x_msg_data);
7417:

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

7431: ,p_rdf_code => 'LASTCL'
7432: ,p_chr_id => p_khr_id
7433: ,p_cle_id => NULL
7434: ,p_message_yn => FALSE
7435: ,x_rulv_rec => l_rulv_rec -- hold a rule instance from okc_rules_b
7436: ,x_return_status => x_return_status
7437: ,x_msg_count => x_msg_count
7438: ,x_msg_data => x_msg_data);
7439:

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

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

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

7487: ,p_rdf_code => 'LASTCL'
7488: ,p_chr_id => p_khr_id
7489: ,p_cle_id => NULL
7490: ,p_message_yn => FALSE
7491: ,x_rulv_rec => l_rulv_rec -- hold a rule instance from okc_rules_b
7492: ,x_return_status => x_return_status
7493: ,x_msg_count => x_msg_count
7494: ,x_msg_data => x_msg_data);
7495:

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

7825: ,p_rdf_code => 'LAASTX'
7826: ,p_chr_id => p_khr_id
7827: ,p_cle_id => p_kle_id
7828: ,p_message_yn => FALSE
7829: ,x_rulv_rec => l_rulv_rec -- hold a rule instance from okc_rules_b
7830: ,x_return_status => x_return_status
7831: ,x_msg_count => x_msg_count
7832: ,x_msg_data => x_msg_data);
7833:

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

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

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

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

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

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

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

7936: ,p_rdf_code => 'LAASTX'
7937: ,p_chr_id => p_khr_id
7938: ,p_cle_id => p_kle_id
7939: ,p_message_yn => FALSE
7940: ,x_rulv_rec => l_rulv_rec -- hold a rule instance from okc_rules_b
7941: ,x_return_status => x_return_status
7942: ,x_msg_count => x_msg_count
7943: ,x_msg_data => x_msg_data);
7944:

Line 13238: okc_rules_b rulb,

13234: styb.CODE stream_type_code,
13235: sum(nvl((rulb2.RULE_INFORMATION3 * rulb2.RULE_INFORMATION6),0) + nvl(rulb2.RULE_INFORMATION8,0)) line_amt
13236: FROM
13237: okc_rule_groups_b rgpb,
13238: okc_rules_b rulb,
13239: okc_rules_b rulb2,
13240: okl_strm_type_b styb
13241: WHERE rgpb.dnz_chr_id = cp_chr_id
13242: AND rgpb.chr_id = cp_chr_id

Line 13239: okc_rules_b rulb2,

13235: sum(nvl((rulb2.RULE_INFORMATION3 * rulb2.RULE_INFORMATION6),0) + nvl(rulb2.RULE_INFORMATION8,0)) line_amt
13236: FROM
13237: okc_rule_groups_b rgpb,
13238: okc_rules_b rulb,
13239: okc_rules_b rulb2,
13240: okl_strm_type_b styb
13241: WHERE rgpb.dnz_chr_id = cp_chr_id
13242: AND rgpb.chr_id = cp_chr_id
13243: AND rgpb.cle_id IS NULL

Line 13260: okc_rules_b rulb,

13256: styb.CODE stream_type_code,
13257: sum(nvl((rulb2.RULE_INFORMATION3 * rulb2.RULE_INFORMATION6),0) + nvl(rulb2.RULE_INFORMATION8,0)) line_amt
13258: FROM okc_k_lines_b cleb,
13259: okc_rule_groups_b rgpb,
13260: okc_rules_b rulb,
13261: okc_rules_b rulb2,
13262: okl_strm_type_b styb
13263: WHERE rgpb.dnz_chr_id = cp_chr_id
13264: AND rgpb.chr_id IS NULL

Line 13261: okc_rules_b rulb2,

13257: sum(nvl((rulb2.RULE_INFORMATION3 * rulb2.RULE_INFORMATION6),0) + nvl(rulb2.RULE_INFORMATION8,0)) line_amt
13258: FROM okc_k_lines_b cleb,
13259: okc_rule_groups_b rgpb,
13260: okc_rules_b rulb,
13261: okc_rules_b rulb2,
13262: okl_strm_type_b styb
13263: WHERE rgpb.dnz_chr_id = cp_chr_id
13264: AND rgpb.chr_id IS NULL
13265: AND rgpb.cle_id = cleb.id

Line 17497: FROM okc_rules_b rul,

17493: WHERE org_id = cp_org_id;
17494:
17495: CURSOR l_tax_schedule_csr(cp_trx_id IN NUMBER) IS
17496: SELECT rul.rule_information5
17497: FROM okc_rules_b rul,
17498: okc_rule_groups_b rgp,
17499: okl_trx_requests trx
17500: WHERE rgp.dnz_chr_id = trx.dnz_khr_id
17501: AND rul.rgp_id = rgp.id