PACKAGE: APPS.IBY_PMTMTHD_CONDITIONS_PKG

Source

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,
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.
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,
30                i_condition_name in iby_pmtmthd_conditions.condition_name%type);
31 
32 /*
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,
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
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;