1: package iby_pmtmthd_conditions_pkg AUTHID CURRENT_USER as
2: /*$Header: ibyconds.pls 115.6 2002/10/04 20:46:16 jleybovi ship $*/
3:
4: /*--------------------------------------------------------------+
5: | Function: createCondition. |
6: | Purpose: To create a rule condition in the database. |
7: +--------------------------------------------------------------*/
8:
9: procedure createCondition(
10: i_paymentmethodid in iby_pmtmthd_conditions.paymentmethodid%type,
11: i_parameter_code in iby_pmtmthd_conditions.parameter_code%type,
12: i_operation_code in iby_pmtmthd_conditions.operation_code%type,
13: i_value in iby_pmtmthd_conditions.value%type,
14: i_is_value_string in iby_pmtmthd_conditions.is_value_string%type,
7: +--------------------------------------------------------------*/
8:
9: procedure createCondition(
10: i_paymentmethodid in iby_pmtmthd_conditions.paymentmethodid%type,
11: i_parameter_code in iby_pmtmthd_conditions.parameter_code%type,
12: i_operation_code in iby_pmtmthd_conditions.operation_code%type,
13: i_value in iby_pmtmthd_conditions.value%type,
14: i_is_value_string in iby_pmtmthd_conditions.is_value_string%type,
15: i_entry_sequence in iby_pmtmthd_conditions.entry_sequence%type,
8:
9: procedure createCondition(
10: i_paymentmethodid in iby_pmtmthd_conditions.paymentmethodid%type,
11: i_parameter_code in iby_pmtmthd_conditions.parameter_code%type,
12: i_operation_code in iby_pmtmthd_conditions.operation_code%type,
13: i_value in iby_pmtmthd_conditions.value%type,
14: i_is_value_string in iby_pmtmthd_conditions.is_value_string%type,
15: i_entry_sequence in iby_pmtmthd_conditions.entry_sequence%type,
16: i_condition_name in iby_pmtmthd_conditions.condition_name%type);
9: procedure createCondition(
10: i_paymentmethodid in iby_pmtmthd_conditions.paymentmethodid%type,
11: i_parameter_code in iby_pmtmthd_conditions.parameter_code%type,
12: i_operation_code in iby_pmtmthd_conditions.operation_code%type,
13: i_value in iby_pmtmthd_conditions.value%type,
14: i_is_value_string in iby_pmtmthd_conditions.is_value_string%type,
15: i_entry_sequence in iby_pmtmthd_conditions.entry_sequence%type,
16: i_condition_name in iby_pmtmthd_conditions.condition_name%type);
17:
10: i_paymentmethodid in iby_pmtmthd_conditions.paymentmethodid%type,
11: i_parameter_code in iby_pmtmthd_conditions.parameter_code%type,
12: i_operation_code in iby_pmtmthd_conditions.operation_code%type,
13: i_value in iby_pmtmthd_conditions.value%type,
14: i_is_value_string in iby_pmtmthd_conditions.is_value_string%type,
15: i_entry_sequence in iby_pmtmthd_conditions.entry_sequence%type,
16: i_condition_name in iby_pmtmthd_conditions.condition_name%type);
17:
18: /*
11: i_parameter_code in iby_pmtmthd_conditions.parameter_code%type,
12: i_operation_code in iby_pmtmthd_conditions.operation_code%type,
13: i_value in iby_pmtmthd_conditions.value%type,
14: i_is_value_string in iby_pmtmthd_conditions.is_value_string%type,
15: i_entry_sequence in iby_pmtmthd_conditions.entry_sequence%type,
16: i_condition_name in iby_pmtmthd_conditions.condition_name%type);
17:
18: /*
19: ** Function: modifyCondition.
12: i_operation_code in iby_pmtmthd_conditions.operation_code%type,
13: i_value in iby_pmtmthd_conditions.value%type,
14: i_is_value_string in iby_pmtmthd_conditions.is_value_string%type,
15: i_entry_sequence in iby_pmtmthd_conditions.entry_sequence%type,
16: i_condition_name in iby_pmtmthd_conditions.condition_name%type);
17:
18: /*
19: ** Function: modifyCondition.
20: ** Purpose: modifies rule condition information in the database.
19: ** Function: modifyCondition.
20: ** Purpose: modifies rule condition information in the database.
21: */
22: procedure modifyCondition (
23: i_paymentmethodid in iby_pmtmthd_conditions.paymentmethodid%type,
24: i_parameter_code in iby_pmtmthd_conditions.parameter_code%type,
25: i_operation_code in iby_pmtmthd_conditions.operation_code%type,
26: i_value in iby_pmtmthd_conditions.value%type,
27: i_is_value_string in iby_pmtmthd_conditions.is_value_string%type,
20: ** Purpose: modifies rule condition information in the database.
21: */
22: procedure modifyCondition (
23: i_paymentmethodid in iby_pmtmthd_conditions.paymentmethodid%type,
24: i_parameter_code in iby_pmtmthd_conditions.parameter_code%type,
25: i_operation_code in iby_pmtmthd_conditions.operation_code%type,
26: i_value in iby_pmtmthd_conditions.value%type,
27: i_is_value_string in iby_pmtmthd_conditions.is_value_string%type,
28: i_entry_sequence in iby_pmtmthd_conditions.entry_sequence%type,
21: */
22: procedure modifyCondition (
23: i_paymentmethodid in iby_pmtmthd_conditions.paymentmethodid%type,
24: i_parameter_code in iby_pmtmthd_conditions.parameter_code%type,
25: i_operation_code in iby_pmtmthd_conditions.operation_code%type,
26: i_value in iby_pmtmthd_conditions.value%type,
27: i_is_value_string in iby_pmtmthd_conditions.is_value_string%type,
28: i_entry_sequence in iby_pmtmthd_conditions.entry_sequence%type,
29: i_version in iby_pmtmthd_conditions.object_version_number%type,
22: procedure modifyCondition (
23: i_paymentmethodid in iby_pmtmthd_conditions.paymentmethodid%type,
24: i_parameter_code in iby_pmtmthd_conditions.parameter_code%type,
25: i_operation_code in iby_pmtmthd_conditions.operation_code%type,
26: i_value in iby_pmtmthd_conditions.value%type,
27: i_is_value_string in iby_pmtmthd_conditions.is_value_string%type,
28: i_entry_sequence in iby_pmtmthd_conditions.entry_sequence%type,
29: i_version in iby_pmtmthd_conditions.object_version_number%type,
30: i_condition_name in iby_pmtmthd_conditions.condition_name%type);
23: i_paymentmethodid in iby_pmtmthd_conditions.paymentmethodid%type,
24: i_parameter_code in iby_pmtmthd_conditions.parameter_code%type,
25: i_operation_code in iby_pmtmthd_conditions.operation_code%type,
26: i_value in iby_pmtmthd_conditions.value%type,
27: i_is_value_string in iby_pmtmthd_conditions.is_value_string%type,
28: i_entry_sequence in iby_pmtmthd_conditions.entry_sequence%type,
29: i_version in iby_pmtmthd_conditions.object_version_number%type,
30: i_condition_name in iby_pmtmthd_conditions.condition_name%type);
31:
24: i_parameter_code in iby_pmtmthd_conditions.parameter_code%type,
25: i_operation_code in iby_pmtmthd_conditions.operation_code%type,
26: i_value in iby_pmtmthd_conditions.value%type,
27: i_is_value_string in iby_pmtmthd_conditions.is_value_string%type,
28: i_entry_sequence in iby_pmtmthd_conditions.entry_sequence%type,
29: i_version in iby_pmtmthd_conditions.object_version_number%type,
30: i_condition_name in iby_pmtmthd_conditions.condition_name%type);
31:
32: /*
25: i_operation_code in iby_pmtmthd_conditions.operation_code%type,
26: i_value in iby_pmtmthd_conditions.value%type,
27: i_is_value_string in iby_pmtmthd_conditions.is_value_string%type,
28: i_entry_sequence in iby_pmtmthd_conditions.entry_sequence%type,
29: i_version in iby_pmtmthd_conditions.object_version_number%type,
30: i_condition_name in iby_pmtmthd_conditions.condition_name%type);
31:
32: /*
33: ** Function: deleteCondition.
26: i_value in iby_pmtmthd_conditions.value%type,
27: i_is_value_string in iby_pmtmthd_conditions.is_value_string%type,
28: i_entry_sequence in iby_pmtmthd_conditions.entry_sequence%type,
29: i_version in iby_pmtmthd_conditions.object_version_number%type,
30: i_condition_name in iby_pmtmthd_conditions.condition_name%type);
31:
32: /*
33: ** Function: deleteCondition.
34: ** Purpose: deletes rule condition in the database.
33: ** Function: deleteCondition.
34: ** Purpose: deletes rule condition in the database.
35: */
36: procedure deleteCondition (
37: i_paymentmethodid in iby_pmtmthd_conditions.paymentmethodid%type,
38: i_parameter_code in iby_pmtmthd_conditions.parameter_code%type,
39: i_operation_code in iby_pmtmthd_conditions.operation_code%type,
40: i_value in iby_pmtmthd_conditions.value%type,
41: i_is_value_string in iby_pmtmthd_conditions.is_value_string%type,
34: ** Purpose: deletes rule condition in the database.
35: */
36: procedure deleteCondition (
37: i_paymentmethodid in iby_pmtmthd_conditions.paymentmethodid%type,
38: i_parameter_code in iby_pmtmthd_conditions.parameter_code%type,
39: i_operation_code in iby_pmtmthd_conditions.operation_code%type,
40: i_value in iby_pmtmthd_conditions.value%type,
41: i_is_value_string in iby_pmtmthd_conditions.is_value_string%type,
42: i_entry_sequence in iby_pmtmthd_conditions.entry_sequence%type,
35: */
36: procedure deleteCondition (
37: i_paymentmethodid in iby_pmtmthd_conditions.paymentmethodid%type,
38: i_parameter_code in iby_pmtmthd_conditions.parameter_code%type,
39: i_operation_code in iby_pmtmthd_conditions.operation_code%type,
40: i_value in iby_pmtmthd_conditions.value%type,
41: i_is_value_string in iby_pmtmthd_conditions.is_value_string%type,
42: i_entry_sequence in iby_pmtmthd_conditions.entry_sequence%type,
43: i_version in iby_pmtmthd_conditions.object_version_number%type);
36: procedure deleteCondition (
37: i_paymentmethodid in iby_pmtmthd_conditions.paymentmethodid%type,
38: i_parameter_code in iby_pmtmthd_conditions.parameter_code%type,
39: i_operation_code in iby_pmtmthd_conditions.operation_code%type,
40: i_value in iby_pmtmthd_conditions.value%type,
41: i_is_value_string in iby_pmtmthd_conditions.is_value_string%type,
42: i_entry_sequence in iby_pmtmthd_conditions.entry_sequence%type,
43: i_version in iby_pmtmthd_conditions.object_version_number%type);
44:
37: i_paymentmethodid in iby_pmtmthd_conditions.paymentmethodid%type,
38: i_parameter_code in iby_pmtmthd_conditions.parameter_code%type,
39: i_operation_code in iby_pmtmthd_conditions.operation_code%type,
40: i_value in iby_pmtmthd_conditions.value%type,
41: i_is_value_string in iby_pmtmthd_conditions.is_value_string%type,
42: i_entry_sequence in iby_pmtmthd_conditions.entry_sequence%type,
43: i_version in iby_pmtmthd_conditions.object_version_number%type);
44:
45: /*
38: i_parameter_code in iby_pmtmthd_conditions.parameter_code%type,
39: i_operation_code in iby_pmtmthd_conditions.operation_code%type,
40: i_value in iby_pmtmthd_conditions.value%type,
41: i_is_value_string in iby_pmtmthd_conditions.is_value_string%type,
42: i_entry_sequence in iby_pmtmthd_conditions.entry_sequence%type,
43: i_version in iby_pmtmthd_conditions.object_version_number%type);
44:
45: /*
46: ** Function: checkDuplicateCondName.
39: i_operation_code in iby_pmtmthd_conditions.operation_code%type,
40: i_value in iby_pmtmthd_conditions.value%type,
41: i_is_value_string in iby_pmtmthd_conditions.is_value_string%type,
42: i_entry_sequence in iby_pmtmthd_conditions.entry_sequence%type,
43: i_version in iby_pmtmthd_conditions.object_version_number%type);
44:
45: /*
46: ** Function: checkDuplicateCondName.
47: ** Purpose: Checks whether the condition name is unique for this rule. Returns
47: ** Purpose: Checks whether the condition name is unique for this rule. Returns
48: ** true if the name is unique, false otherwise.
49: */
50: function checkDuplicateCondName(
51: i_condition_name in iby_pmtmthd_conditions.condition_name%type,
52: i_paymentmethodid in iby_pmtmthd_conditions.paymentmethodid%type
53: ) RETURN BOOLEAN;
54:
55: end iby_pmtmthd_conditions_pkg;
48: ** true if the name is unique, false otherwise.
49: */
50: function checkDuplicateCondName(
51: i_condition_name in iby_pmtmthd_conditions.condition_name%type,
52: i_paymentmethodid in iby_pmtmthd_conditions.paymentmethodid%type
53: ) RETURN BOOLEAN;
54:
55: end iby_pmtmthd_conditions_pkg;
51: i_condition_name in iby_pmtmthd_conditions.condition_name%type,
52: i_paymentmethodid in iby_pmtmthd_conditions.paymentmethodid%type
53: ) RETURN BOOLEAN;
54:
55: end iby_pmtmthd_conditions_pkg;