DBA Data[Home] [Help]

APPS.IBY_PMTMTHD_CONDITIONS_PKG dependencies on IBY_PMTMTHD_CONDITIONS

Line 1: package iby_pmtmthd_conditions_pkg AUTHID CURRENT_USER as

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. |

Line 10: i_paymentmethodid in iby_pmtmthd_conditions.paymentmethodid%type,

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,

Line 11: i_parameter_code in iby_pmtmthd_conditions.parameter_code%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,

Line 12: i_operation_code in iby_pmtmthd_conditions.operation_code%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);

Line 13: i_value in iby_pmtmthd_conditions.value%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:

Line 14: i_is_value_string in iby_pmtmthd_conditions.is_value_string%type,

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: /*

Line 15: i_entry_sequence in iby_pmtmthd_conditions.entry_sequence%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: /*
19: ** Function: modifyCondition.

Line 16: i_condition_name in iby_pmtmthd_conditions.condition_name%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.
20: ** Purpose: modifies rule condition information in the database.

Line 23: i_paymentmethodid in iby_pmtmthd_conditions.paymentmethodid%type,

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,

Line 24: i_parameter_code in iby_pmtmthd_conditions.parameter_code%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,

Line 25: i_operation_code in iby_pmtmthd_conditions.operation_code%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,

Line 26: i_value in iby_pmtmthd_conditions.value%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);

Line 27: i_is_value_string in iby_pmtmthd_conditions.is_value_string%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:

Line 28: i_entry_sequence in iby_pmtmthd_conditions.entry_sequence%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:
32: /*

Line 29: i_version in iby_pmtmthd_conditions.object_version_number%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: /*
33: ** Function: deleteCondition.

Line 30: i_condition_name in iby_pmtmthd_conditions.condition_name%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.
34: ** Purpose: deletes rule condition in the database.

Line 37: i_paymentmethodid in iby_pmtmthd_conditions.paymentmethodid%type,

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,

Line 38: i_parameter_code in iby_pmtmthd_conditions.parameter_code%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,

Line 39: i_operation_code in iby_pmtmthd_conditions.operation_code%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);

Line 40: i_value in iby_pmtmthd_conditions.value%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:

Line 41: i_is_value_string in iby_pmtmthd_conditions.is_value_string%type,

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: /*

Line 42: i_entry_sequence in iby_pmtmthd_conditions.entry_sequence%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: /*
46: ** Function: checkDuplicateCondName.

Line 43: i_version in iby_pmtmthd_conditions.object_version_number%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.
47: ** Purpose: Checks whether the condition name is unique for this rule. Returns

Line 51: i_condition_name in iby_pmtmthd_conditions.condition_name%type,

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;

Line 52: i_paymentmethodid in iby_pmtmthd_conditions.paymentmethodid%type

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;

Line 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;