APPS.OKL_UBB_INTEGRATION_PVT dependencies on RA_RULES

Line 762: l_rule_id ra_rules.rule_id%TYPE;

758: l_proc_name VARCHAR2(35) := 'POPULATE_HEADER_REC';
759: x_party_id NUMBER;
760: header_failed EXCEPTION;
761: x_rulv_rec rulv_rec_type;
762: l_rule_id ra_rules.rule_id%TYPE;
763: l_qcl_id okc_qa_check_lists_v.id%TYPE;
764: l_pdf_id okc_process_defs_v.id%TYPE;
765: --l_bill_to_id NUMBER;
766:

Line 768: CURSOR ra_rule_csr (p_name ra_rules.name%TYPE) IS

764: l_pdf_id okc_process_defs_v.id%TYPE;
765: --l_bill_to_id NUMBER;
766:
767: /*
768: CURSOR ra_rule_csr (p_name ra_rules.name%TYPE) IS
769: SELECT rule_id
770: FROM ra_rules
771: WHERE name = p_name;
772: */

Line 770: FROM ra_rules

766:
767: /*
768: CURSOR ra_rule_csr (p_name ra_rules.name%TYPE) IS
769: SELECT rule_id
770: FROM ra_rules
771: WHERE name = p_name;
772: */
773:
774: CURSOR qcl_csr (p_name okc_qa_check_lists_v.name%TYPE) IS

Line 854: x_oks_header_rec.accounting_rule_type := 1; -- IMMEDIATE, ra_rules table

850: RAISE header_failed;
851: END IF;
852: CLOSE ra_rule_csr;
853: */
854: x_oks_header_rec.accounting_rule_type := 1; -- IMMEDIATE, ra_rules table
855:
856: /* use rule_id instead
857: OPEN ra_rule_csr('ARREARS INVOICE');
858: FETCH ra_rule_csr INTO l_rule_id;

Line 871: x_oks_header_rec.invoice_rule_type := -3; -- ARREARS INVOICE, ra_rules table

867: END IF;
868: CLOSE ra_rule_csr;
869: */
870:
871: x_oks_header_rec.invoice_rule_type := -3; -- ARREARS INVOICE, ra_rules table
872:
873: get_party_id(
874: x_return_status => x_return_status,
875: x_msg_count => x_msg_count,

Line 989: l_rule_id ra_rules.rule_id%TYPE;

985:
986: l_proc_name VARCHAR2(35) := 'POPULATE_LINE_REC';
987: line_failed EXCEPTION;
988:
989: l_rule_id ra_rules.rule_id%TYPE;
990:
991: x_oks_header_rec header_rec_type;
992: x_party_id NUMBER;
993: x_rulv_rec rulv_rec_type;

Line 1009: CURSOR ra_rule_csr (p_name ra_rules.name%TYPE) IS

1005: FROM okc_k_headers_v
1006: WHERE id = p_chr_id;
1007:
1008: /*
1009: CURSOR ra_rule_csr (p_name ra_rules.name%TYPE) IS
1010: SELECT rule_id
1011: FROM ra_rules
1012: WHERE name = p_name;
1013: */

Line 1011: FROM ra_rules

1007:
1008: /*
1009: CURSOR ra_rule_csr (p_name ra_rules.name%TYPE) IS
1010: SELECT rule_id
1011: FROM ra_rules
1012: WHERE name = p_name;
1013: */
1014:
1015: l_bill_to_id OKC_K_HEADERS_B.BILL_TO_SITE_USE_ID%TYPE;

Line 1070: x_oks_line_rec.accounting_rule_type := 1; -- IMMEDIATE, ra_rules table

1066: END IF;
1067: CLOSE ra_rule_csr;
1068: */
1069:
1070: x_oks_line_rec.accounting_rule_type := 1; -- IMMEDIATE, ra_rules table
1071:
1072: /* use rule_id instead
1073: OPEN ra_rule_csr('ARREARS INVOICE');
1074: FETCH ra_rule_csr INTO l_rule_id;

Line 1086: x_oks_line_rec.invoicing_rule_type := -3; -- ARREARS INVOICE, ra_rules table

1082: RAISE line_failed;
1083: END IF;
1084: CLOSE ra_rule_csr;
1085: */
1086: x_oks_line_rec.invoicing_rule_type := -3; -- ARREARS INVOICE, ra_rules table
1087:
1088: -- Get LAUSBB information
1089: get_rule_information(
1090: x_return_status => x_return_status,