APPS.PAY_TXR_SHD dependencies on PAY_TXR_SHD

Line 1: Package Body pay_txr_shd as

1: Package Body pay_txr_shd as
2: /* $Header: pytxrrhi.pkb 120.0 2005/05/29 09:09 appldev noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' pay_txr_shd.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' pay_txr_shd.'; -- Global package name
9: --
10: -- ----------------------------------------------------------------------------
11: -- |---------------------------< constraint_error >---------------------------|
12: -- ----------------------------------------------------------------------------

Line 114: = pay_txr_shd.g_old_rec.jurisdiction_code and

110: --
111: l_fct_ret := false;
112: Else
113: If (p_jurisdiction_code
114: = pay_txr_shd.g_old_rec.jurisdiction_code and
115: nvl(p_tax_type, 'X')
116: = nvl(pay_txr_shd.g_old_rec.tax_type, 'X') and
117: nvl(p_tax_category, 'X')
118: = nvl(pay_txr_shd.g_old_rec.tax_category, 'X') and

Line 116: = nvl(pay_txr_shd.g_old_rec.tax_type, 'X') and

112: Else
113: If (p_jurisdiction_code
114: = pay_txr_shd.g_old_rec.jurisdiction_code and
115: nvl(p_tax_type, 'X')
116: = nvl(pay_txr_shd.g_old_rec.tax_type, 'X') and
117: nvl(p_tax_category, 'X')
118: = nvl(pay_txr_shd.g_old_rec.tax_category, 'X') and
119: nvl(p_classification_id, 0)
120: = nvl(pay_txr_shd.g_old_rec.classification_id, 0) and

Line 118: = nvl(pay_txr_shd.g_old_rec.tax_category, 'X') and

114: = pay_txr_shd.g_old_rec.jurisdiction_code and
115: nvl(p_tax_type, 'X')
116: = nvl(pay_txr_shd.g_old_rec.tax_type, 'X') and
117: nvl(p_tax_category, 'X')
118: = nvl(pay_txr_shd.g_old_rec.tax_category, 'X') and
119: nvl(p_classification_id, 0)
120: = nvl(pay_txr_shd.g_old_rec.classification_id, 0) and
121: nvl(p_secondary_classification_id, 0)
122: = nvl(pay_txr_shd.g_old_rec.secondary_classification_id, 0) and

Line 120: = nvl(pay_txr_shd.g_old_rec.classification_id, 0) and

116: = nvl(pay_txr_shd.g_old_rec.tax_type, 'X') and
117: nvl(p_tax_category, 'X')
118: = nvl(pay_txr_shd.g_old_rec.tax_category, 'X') and
119: nvl(p_classification_id, 0)
120: = nvl(pay_txr_shd.g_old_rec.classification_id, 0) and
121: nvl(p_secondary_classification_id, 0)
122: = nvl(pay_txr_shd.g_old_rec.secondary_classification_id, 0) and
123: p_taxability_rules_date_id
124: = pay_txr_shd.g_old_rec.taxability_rules_date_id

Line 122: = nvl(pay_txr_shd.g_old_rec.secondary_classification_id, 0) and

118: = nvl(pay_txr_shd.g_old_rec.tax_category, 'X') and
119: nvl(p_classification_id, 0)
120: = nvl(pay_txr_shd.g_old_rec.classification_id, 0) and
121: nvl(p_secondary_classification_id, 0)
122: = nvl(pay_txr_shd.g_old_rec.secondary_classification_id, 0) and
123: p_taxability_rules_date_id
124: = pay_txr_shd.g_old_rec.taxability_rules_date_id
125: ) Then
126: --

Line 124: = pay_txr_shd.g_old_rec.taxability_rules_date_id

120: = nvl(pay_txr_shd.g_old_rec.classification_id, 0) and
121: nvl(p_secondary_classification_id, 0)
122: = nvl(pay_txr_shd.g_old_rec.secondary_classification_id, 0) and
123: p_taxability_rules_date_id
124: = pay_txr_shd.g_old_rec.taxability_rules_date_id
125: ) Then
126: --
127: -- The g_old_rec is current therefore we must
128: -- set the returning function to true

Line 136: Fetch C_Sel1 Into pay_txr_shd.g_old_rec;

132: --
133: -- Select the current row into g_old_rec
134: --
135: Open C_Sel1;
136: Fetch C_Sel1 Into pay_txr_shd.g_old_rec;
137: If C_Sel1%notfound Then
138: Close C_Sel1;
139: --
140: -- The primary key is invalid therefore we must error

Line 225: Fetch C_Sel1 Into pay_txr_shd.g_old_rec;

221: ,p_argument_value => p_taxability_rules_date_id
222: );
223: --
224: Open C_Sel1;
225: Fetch C_Sel1 Into pay_txr_shd.g_old_rec;
226: If C_Sel1%notfound then
227: Close C_Sel1;
228: --
229: -- The primary key is invalid therefore we must error

Line 298: end pay_txr_shd;

294: hr_utility.trace('Error in Convert arguments = '||SQLERRM);
295:
296: End convert_args;
297: --
298: end pay_txr_shd;