The following lines contain the word 'select', 'insert', 'update' or 'delete':
select db.defined_balance_id
from pay_defined_balances db,
pay_balance_dimensions bd,
pay_balance_types bt
where nvl(db.business_group_id,v_business_group_id) = v_business_group_id
and ((db.legislation_code is null)
or exists
(select null
from per_business_groups pbg
where pbg.business_group_id = v_business_group_id
and pbg.legislation_code = db.legislation_code))
and db.balance_dimension_id = bd.balance_dimension_id
and db.balance_type_id = bt.balance_type_id
and bd.payments_flag = 'Y'
and bt.assignment_remuneration_flag = 'Y'
order by db.business_group_id,db.legislation_code;
select nvl(ppt.territory_code,pbg.legislation_code)
from pay_payment_types ppt,
per_business_groups pbg
where ppt.payment_type_id = v_payment_type_id
and pbg.business_group_id = v_business_group_id;
select currency_code
from pay_payment_types
where payment_type_id = v_payment_type_id;
select CHART_OF_ACCOUNTS_ID
from gl_sets_of_books
where SET_OF_BOOKS_ID = v_sets_of_book_id;
select payment_type_name
from pay_payment_types
where payment_type_id = v_payment_type_id;
select gl_cash_ac_id,
gl_cash_clearing_ac_id,
gl_control_ac_id,
gl_error_ac_id,
set_of_books_id
from pay_payment_gl_accounts_f
where external_account_id = v_external_account_id;
pay_maintain_bank_acct.update_payroll_bank_acct(
p_bank_account_id => p_bank_account_id,
p_external_account_id => l_external_account_id,
p_org_payment_method_id => l_org_payment_method_id);
pay_maintain_bank_acct.update_asset_ccid(
p_assest_ccid =>l_ASSET_CODE_COMBINATION_ID,
p_set_of_books_id =>l_set_of_books_id,
p_external_account_id =>l_external_account_id
);
PAY_PAYMENT_GL_ACCOUNTS_PKG.INSERT_ROW (
P_PAY_GL_ACCOUNT_ID => l_pay_gl_account_id,
P_EFFECTIVE_START_DATE => l_effective_start_date,
P_EFFECTIVE_END_DATE => l_effective_end_date,
P_SET_OF_BOOKS_ID => l_set_of_books_id,
P_GL_CASH_AC_ID => l_gl_cash_ac_id,
P_GL_CASH_CLEARING_AC_ID => l_gl_cash_clearing_ac_id,
P_GL_CONTROL_AC_ID => l_gl_control_ac_id,
P_GL_ERROR_AC_ID => l_gl_error_ac_id,
P_EXTERNAL_ACCOUNT_ID => l_external_account_id,
P_ORG_PAYMENT_METHOD_ID => l_org_payment_method_id,
P_DEFAULT_GL_ACCOUNT => L_DEFAULT_GL_ACCOUNT);
procedure update_org_payment_method
(P_VALIDATE in boolean default false
,P_EFFECTIVE_DATE in date
,P_DATETRACK_UPDATE_MODE in varchar2
,P_LANGUAGE_CODE in varchar2 default hr_api.userenv_lang
,P_ORG_PAYMENT_METHOD_ID in number
,P_OBJECT_VERSION_NUMBER in out nocopy number
,P_ORG_PAYMENT_METHOD_NAME in varchar2 default hr_api.g_varchar2
,P_CURRENCY_CODE in varchar2 default hr_api.g_varchar2
,P_ATTRIBUTE_CATEGORY in varchar2 default hr_api.g_varchar2
,P_ATTRIBUTE1 in varchar2 default hr_api.g_varchar2
,P_ATTRIBUTE2 in varchar2 default hr_api.g_varchar2
,P_ATTRIBUTE3 in varchar2 default hr_api.g_varchar2
,P_ATTRIBUTE4 in varchar2 default hr_api.g_varchar2
,P_ATTRIBUTE5 in varchar2 default hr_api.g_varchar2
,P_ATTRIBUTE6 in varchar2 default hr_api.g_varchar2
,P_ATTRIBUTE7 in varchar2 default hr_api.g_varchar2
,P_ATTRIBUTE8 in varchar2 default hr_api.g_varchar2
,P_ATTRIBUTE9 in varchar2 default hr_api.g_varchar2
,P_ATTRIBUTE10 in varchar2 default hr_api.g_varchar2
,P_ATTRIBUTE11 in varchar2 default hr_api.g_varchar2
,P_ATTRIBUTE12 in varchar2 default hr_api.g_varchar2
,P_ATTRIBUTE13 in varchar2 default hr_api.g_varchar2
,P_ATTRIBUTE14 in varchar2 default hr_api.g_varchar2
,P_ATTRIBUTE15 in varchar2 default hr_api.g_varchar2
,P_ATTRIBUTE16 in varchar2 default hr_api.g_varchar2
,P_ATTRIBUTE17 in varchar2 default hr_api.g_varchar2
,P_ATTRIBUTE18 in varchar2 default hr_api.g_varchar2
,P_ATTRIBUTE19 in varchar2 default hr_api.g_varchar2
,P_ATTRIBUTE20 in varchar2 default hr_api.g_varchar2
-- ,P_PMETH_INFORMATION_CATEGORY in varchar2 default hr_api.g_varchar2
,P_PMETH_INFORMATION1 in varchar2 default hr_api.g_varchar2
,P_PMETH_INFORMATION2 in varchar2 default hr_api.g_varchar2
,P_PMETH_INFORMATION3 in varchar2 default hr_api.g_varchar2
,P_PMETH_INFORMATION4 in varchar2 default hr_api.g_varchar2
,P_PMETH_INFORMATION5 in varchar2 default hr_api.g_varchar2
,P_PMETH_INFORMATION6 in varchar2 default hr_api.g_varchar2
,P_PMETH_INFORMATION7 in varchar2 default hr_api.g_varchar2
,P_PMETH_INFORMATION8 in varchar2 default hr_api.g_varchar2
,P_PMETH_INFORMATION9 in varchar2 default hr_api.g_varchar2
,P_PMETH_INFORMATION10 in varchar2 default hr_api.g_varchar2
,P_PMETH_INFORMATION11 in varchar2 default hr_api.g_varchar2
,P_PMETH_INFORMATION12 in varchar2 default hr_api.g_varchar2
,P_PMETH_INFORMATION13 in varchar2 default hr_api.g_varchar2
,P_PMETH_INFORMATION14 in varchar2 default hr_api.g_varchar2
,P_PMETH_INFORMATION15 in varchar2 default hr_api.g_varchar2
,P_PMETH_INFORMATION16 in varchar2 default hr_api.g_varchar2
,P_PMETH_INFORMATION17 in varchar2 default hr_api.g_varchar2
,P_PMETH_INFORMATION18 in varchar2 default hr_api.g_varchar2
,P_PMETH_INFORMATION19 in varchar2 default hr_api.g_varchar2
,P_PMETH_INFORMATION20 in varchar2 default hr_api.g_varchar2
,P_COMMENTS in varchar2 default hr_api.g_varchar2
,P_SEGMENT1 in varchar2 default hr_api.g_varchar2
,P_SEGMENT2 in varchar2 default hr_api.g_varchar2
,P_SEGMENT3 in varchar2 default hr_api.g_varchar2
,P_SEGMENT4 in varchar2 default hr_api.g_varchar2
,P_SEGMENT5 in varchar2 default hr_api.g_varchar2
,P_SEGMENT6 in varchar2 default hr_api.g_varchar2
,P_SEGMENT7 in varchar2 default hr_api.g_varchar2
,P_SEGMENT8 in varchar2 default hr_api.g_varchar2
,P_SEGMENT9 in varchar2 default hr_api.g_varchar2
,P_SEGMENT10 in varchar2 default hr_api.g_varchar2
,P_SEGMENT11 in varchar2 default hr_api.g_varchar2
,P_SEGMENT12 in varchar2 default hr_api.g_varchar2
,P_SEGMENT13 in varchar2 default hr_api.g_varchar2
,P_SEGMENT14 in varchar2 default hr_api.g_varchar2
,P_SEGMENT15 in varchar2 default hr_api.g_varchar2
,P_SEGMENT16 in varchar2 default hr_api.g_varchar2
,P_SEGMENT17 in varchar2 default hr_api.g_varchar2
,P_SEGMENT18 in varchar2 default hr_api.g_varchar2
,P_SEGMENT19 in varchar2 default hr_api.g_varchar2
,P_SEGMENT20 in varchar2 default hr_api.g_varchar2
,P_SEGMENT21 in varchar2 default hr_api.g_varchar2
,P_SEGMENT22 in varchar2 default hr_api.g_varchar2
,P_SEGMENT23 in varchar2 default hr_api.g_varchar2
,P_SEGMENT24 in varchar2 default hr_api.g_varchar2
,P_SEGMENT25 in varchar2 default hr_api.g_varchar2
,P_SEGMENT26 in varchar2 default hr_api.g_varchar2
,P_SEGMENT27 in varchar2 default hr_api.g_varchar2
,P_SEGMENT28 in varchar2 default hr_api.g_varchar2
,P_SEGMENT29 in varchar2 default hr_api.g_varchar2
,P_SEGMENT30 in varchar2 default hr_api.g_varchar2
,P_CONCAT_SEGMENTS in varchar2 default hr_api.g_varchar2
,P_GL_SEGMENT1 in varchar2 default hr_api.g_varchar2
,P_GL_SEGMENT2 in varchar2 default hr_api.g_varchar2
,P_GL_SEGMENT3 in varchar2 default hr_api.g_varchar2
,P_GL_SEGMENT4 in varchar2 default hr_api.g_varchar2
,P_GL_SEGMENT5 in varchar2 default hr_api.g_varchar2
,P_GL_SEGMENT6 in varchar2 default hr_api.g_varchar2
,P_GL_SEGMENT7 in varchar2 default hr_api.g_varchar2
,P_GL_SEGMENT8 in varchar2 default hr_api.g_varchar2
,P_GL_SEGMENT9 in varchar2 default hr_api.g_varchar2
,P_GL_SEGMENT10 in varchar2 default hr_api.g_varchar2
,P_GL_SEGMENT11 in varchar2 default hr_api.g_varchar2
,P_GL_SEGMENT12 in varchar2 default hr_api.g_varchar2
,P_GL_SEGMENT13 in varchar2 default hr_api.g_varchar2
,P_GL_SEGMENT14 in varchar2 default hr_api.g_varchar2
,P_GL_SEGMENT15 in varchar2 default hr_api.g_varchar2
,P_GL_SEGMENT16 in varchar2 default hr_api.g_varchar2
,P_GL_SEGMENT17 in varchar2 default hr_api.g_varchar2
,P_GL_SEGMENT18 in varchar2 default hr_api.g_varchar2
,P_GL_SEGMENT19 in varchar2 default hr_api.g_varchar2
,P_GL_SEGMENT20 in varchar2 default hr_api.g_varchar2
,P_GL_SEGMENT21 in varchar2 default hr_api.g_varchar2
,P_GL_SEGMENT22 in varchar2 default hr_api.g_varchar2
,P_GL_SEGMENT23 in varchar2 default hr_api.g_varchar2
,P_GL_SEGMENT24 in varchar2 default hr_api.g_varchar2
,P_GL_SEGMENT25 in varchar2 default hr_api.g_varchar2
,P_GL_SEGMENT26 in varchar2 default hr_api.g_varchar2
,P_GL_SEGMENT27 in varchar2 default hr_api.g_varchar2
,P_GL_SEGMENT28 in varchar2 default hr_api.g_varchar2
,P_GL_SEGMENT29 in varchar2 default hr_api.g_varchar2
,P_GL_SEGMENT30 in varchar2 default hr_api.g_varchar2
,P_GL_CONCAT_SEGMENTS in varchar2 default hr_api.g_varchar2
,P_GL_CTRL_SEGMENT1 in varchar2 default hr_api.g_varchar2
,P_GL_CTRL_SEGMENT2 in varchar2 default hr_api.g_varchar2
,P_GL_CTRL_SEGMENT3 in varchar2 default hr_api.g_varchar2
,P_GL_CTRL_SEGMENT4 in varchar2 default hr_api.g_varchar2
,P_GL_CTRL_SEGMENT5 in varchar2 default hr_api.g_varchar2
,P_GL_CTRL_SEGMENT6 in varchar2 default hr_api.g_varchar2
,P_GL_CTRL_SEGMENT7 in varchar2 default hr_api.g_varchar2
,P_GL_CTRL_SEGMENT8 in varchar2 default hr_api.g_varchar2
,P_GL_CTRL_SEGMENT9 in varchar2 default hr_api.g_varchar2
,P_GL_CTRL_SEGMENT10 in varchar2 default hr_api.g_varchar2
,P_GL_CTRL_SEGMENT11 in varchar2 default hr_api.g_varchar2
,P_GL_CTRL_SEGMENT12 in varchar2 default hr_api.g_varchar2
,P_GL_CTRL_SEGMENT13 in varchar2 default hr_api.g_varchar2
,P_GL_CTRL_SEGMENT14 in varchar2 default hr_api.g_varchar2
,P_GL_CTRL_SEGMENT15 in varchar2 default hr_api.g_varchar2
,P_GL_CTRL_SEGMENT16 in varchar2 default hr_api.g_varchar2
,P_GL_CTRL_SEGMENT17 in varchar2 default hr_api.g_varchar2
,P_GL_CTRL_SEGMENT18 in varchar2 default hr_api.g_varchar2
,P_GL_CTRL_SEGMENT19 in varchar2 default hr_api.g_varchar2
,P_GL_CTRL_SEGMENT20 in varchar2 default hr_api.g_varchar2
,P_GL_CTRL_SEGMENT21 in varchar2 default hr_api.g_varchar2
,P_GL_CTRL_SEGMENT22 in varchar2 default hr_api.g_varchar2
,P_GL_CTRL_SEGMENT23 in varchar2 default hr_api.g_varchar2
,P_GL_CTRL_SEGMENT24 in varchar2 default hr_api.g_varchar2
,P_GL_CTRL_SEGMENT25 in varchar2 default hr_api.g_varchar2
,P_GL_CTRL_SEGMENT26 in varchar2 default hr_api.g_varchar2
,P_GL_CTRL_SEGMENT27 in varchar2 default hr_api.g_varchar2
,P_GL_CTRL_SEGMENT28 in varchar2 default hr_api.g_varchar2
,P_GL_CTRL_SEGMENT29 in varchar2 default hr_api.g_varchar2
,P_GL_CTRL_SEGMENT30 in varchar2 default hr_api.g_varchar2
,P_GL_CTRL_CONCAT_SEGMENTS in varchar2 default hr_api.g_varchar2
,P_GL_CCRL_SEGMENT1 in varchar2 default hr_api.g_varchar2
,P_GL_CCRL_SEGMENT2 in varchar2 default hr_api.g_varchar2
,P_GL_CCRL_SEGMENT3 in varchar2 default hr_api.g_varchar2
,P_GL_CCRL_SEGMENT4 in varchar2 default hr_api.g_varchar2
,P_GL_CCRL_SEGMENT5 in varchar2 default hr_api.g_varchar2
,P_GL_CCRL_SEGMENT6 in varchar2 default hr_api.g_varchar2
,P_GL_CCRL_SEGMENT7 in varchar2 default hr_api.g_varchar2
,P_GL_CCRL_SEGMENT8 in varchar2 default hr_api.g_varchar2
,P_GL_CCRL_SEGMENT9 in varchar2 default hr_api.g_varchar2
,P_GL_CCRL_SEGMENT10 in varchar2 default hr_api.g_varchar2
,P_GL_CCRL_SEGMENT11 in varchar2 default hr_api.g_varchar2
,P_GL_CCRL_SEGMENT12 in varchar2 default hr_api.g_varchar2
,P_GL_CCRL_SEGMENT13 in varchar2 default hr_api.g_varchar2
,P_GL_CCRL_SEGMENT14 in varchar2 default hr_api.g_varchar2
,P_GL_CCRL_SEGMENT15 in varchar2 default hr_api.g_varchar2
,P_GL_CCRL_SEGMENT16 in varchar2 default hr_api.g_varchar2
,P_GL_CCRL_SEGMENT17 in varchar2 default hr_api.g_varchar2
,P_GL_CCRL_SEGMENT18 in varchar2 default hr_api.g_varchar2
,P_GL_CCRL_SEGMENT19 in varchar2 default hr_api.g_varchar2
,P_GL_CCRL_SEGMENT20 in varchar2 default hr_api.g_varchar2
,P_GL_CCRL_SEGMENT21 in varchar2 default hr_api.g_varchar2
,P_GL_CCRL_SEGMENT22 in varchar2 default hr_api.g_varchar2
,P_GL_CCRL_SEGMENT23 in varchar2 default hr_api.g_varchar2
,P_GL_CCRL_SEGMENT24 in varchar2 default hr_api.g_varchar2
,P_GL_CCRL_SEGMENT25 in varchar2 default hr_api.g_varchar2
,P_GL_CCRL_SEGMENT26 in varchar2 default hr_api.g_varchar2
,P_GL_CCRL_SEGMENT27 in varchar2 default hr_api.g_varchar2
,P_GL_CCRL_SEGMENT28 in varchar2 default hr_api.g_varchar2
,P_GL_CCRL_SEGMENT29 in varchar2 default hr_api.g_varchar2
,P_GL_CCRL_SEGMENT30 in varchar2 default hr_api.g_varchar2
,P_GL_CCRL_CONCAT_SEGMENTS in varchar2 default hr_api.g_varchar2
,P_GL_ERR_SEGMENT1 in varchar2 default hr_api.g_varchar2
,P_GL_ERR_SEGMENT2 in varchar2 default hr_api.g_varchar2
,P_GL_ERR_SEGMENT3 in varchar2 default hr_api.g_varchar2
,P_GL_ERR_SEGMENT4 in varchar2 default hr_api.g_varchar2
,P_GL_ERR_SEGMENT5 in varchar2 default hr_api.g_varchar2
,P_GL_ERR_SEGMENT6 in varchar2 default hr_api.g_varchar2
,P_GL_ERR_SEGMENT7 in varchar2 default hr_api.g_varchar2
,P_GL_ERR_SEGMENT8 in varchar2 default hr_api.g_varchar2
,P_GL_ERR_SEGMENT9 in varchar2 default hr_api.g_varchar2
,P_GL_ERR_SEGMENT10 in varchar2 default hr_api.g_varchar2
,P_GL_ERR_SEGMENT11 in varchar2 default hr_api.g_varchar2
,P_GL_ERR_SEGMENT12 in varchar2 default hr_api.g_varchar2
,P_GL_ERR_SEGMENT13 in varchar2 default hr_api.g_varchar2
,P_GL_ERR_SEGMENT14 in varchar2 default hr_api.g_varchar2
,P_GL_ERR_SEGMENT15 in varchar2 default hr_api.g_varchar2
,P_GL_ERR_SEGMENT16 in varchar2 default hr_api.g_varchar2
,P_GL_ERR_SEGMENT17 in varchar2 default hr_api.g_varchar2
,P_GL_ERR_SEGMENT18 in varchar2 default hr_api.g_varchar2
,P_GL_ERR_SEGMENT19 in varchar2 default hr_api.g_varchar2
,P_GL_ERR_SEGMENT20 in varchar2 default hr_api.g_varchar2
,P_GL_ERR_SEGMENT21 in varchar2 default hr_api.g_varchar2
,P_GL_ERR_SEGMENT22 in varchar2 default hr_api.g_varchar2
,P_GL_ERR_SEGMENT23 in varchar2 default hr_api.g_varchar2
,P_GL_ERR_SEGMENT24 in varchar2 default hr_api.g_varchar2
,P_GL_ERR_SEGMENT25 in varchar2 default hr_api.g_varchar2
,P_GL_ERR_SEGMENT26 in varchar2 default hr_api.g_varchar2
,P_GL_ERR_SEGMENT27 in varchar2 default hr_api.g_varchar2
,P_GL_ERR_SEGMENT28 in varchar2 default hr_api.g_varchar2
,P_GL_ERR_SEGMENT29 in varchar2 default hr_api.g_varchar2
,P_GL_ERR_SEGMENT30 in varchar2 default hr_api.g_varchar2
,P_GL_ERR_CONCAT_SEGMENTS in varchar2 default hr_api.g_varchar2
,P_SETS_OF_BOOK_ID in number default hr_api.g_number
,P_TRANSFER_TO_GL_FLAG in varchar2 default hr_api.g_varchar2
,P_COST_PAYMENT in varchar2 default hr_api.g_varchar2
,P_COST_CLEARED_PAYMENT in varchar2 default hr_api.g_varchar2
,P_COST_CLEARED_VOID_PAYMENT in varchar2 default hr_api.g_varchar2
,P_EXCLUDE_MANUAL_PAYMENT in varchar2 default hr_api.g_varchar2
,P_DEFAULT_GL_ACCOUNT in varchar2 default 'Y'
,P_BANK_ACCOUNT_ID in number default hr_api.g_number
,P_EFFECTIVE_START_DATE out nocopy date
,P_EFFECTIVE_END_DATE out nocopy date
,P_ASSET_CODE_COMBINATION_ID out nocopy number
,P_COMMENT_ID out nocopy number
,P_EXTERNAL_ACCOUNT_ID out nocopy number
) is
--
-- Declare cursors and local variables
--
l_proc varchar2(72) := g_package||'update_org_payment_method';
select nvl(pty.territory_code,pbg.legislation_code)
from pay_payment_types pty
, pay_org_payment_methods_f opm
, per_business_groups pbg
where opm.org_payment_method_id = v_org_payment_method_id
and pty.payment_type_id = opm.payment_type_id
and pbg.business_group_id = opm.business_group_id;
select ppt.currency_code
from pay_org_payment_methods_f opm,
pay_payment_types ppt
where opm.org_payment_method_id = v_org_payment_method_id
and ppt.payment_type_id = opm.payment_type_id;
select opm.business_group_id
from pay_org_payment_methods_f opm
where opm.org_payment_method_id = v_org_payment_method_id;
select CHART_OF_ACCOUNTS_ID
from gl_sets_of_books
where SET_OF_BOOKS_ID = v_sets_of_book_id;
select opm.external_account_id
from pay_org_payment_methods_f opm
where opm.org_payment_method_id = v_org_payment_method_id
and v_effective_date between effective_start_date and effective_end_date;
select ppt.payment_type_name
from pay_payment_types ppt,
pay_org_payment_methods_f opm
where opm.org_payment_method_id = v_org_payment_method_id
and ppt.payment_type_id = opm.payment_type_id;
select cost_payment, cost_cleared_payment
from pay_org_payment_methods_f
where org_payment_method_id = v_org_payment_method_id
and v_effective_date between effective_start_date and effective_end_date;
savepoint update_org_payment_method;
pay_org_payment_method_bk2.update_org_payment_method_b
(P_EFFECTIVE_DATE => l_EFFECTIVE_DATE
,P_DATETRACK_UPDATE_MODE => P_DATETRACK_UPDATE_MODE
,P_LANGUAGE_CODE => l_LANGUAGE_CODE
,P_ORG_PAYMENT_METHOD_ID => P_ORG_PAYMENT_METHOD_ID
,P_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER
,P_ORG_PAYMENT_METHOD_NAME => P_ORG_PAYMENT_METHOD_NAME
,P_CURRENCY_CODE => P_CURRENCY_CODE
,P_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY
,P_ATTRIBUTE1 => P_ATTRIBUTE1
,P_ATTRIBUTE2 => P_ATTRIBUTE2
,P_ATTRIBUTE3 => P_ATTRIBUTE3
,P_ATTRIBUTE4 => P_ATTRIBUTE4
,P_ATTRIBUTE5 => P_ATTRIBUTE5
,P_ATTRIBUTE6 => P_ATTRIBUTE6
,P_ATTRIBUTE7 => P_ATTRIBUTE7
,P_ATTRIBUTE8 => P_ATTRIBUTE8
,P_ATTRIBUTE9 => P_ATTRIBUTE9
,P_ATTRIBUTE10 => P_ATTRIBUTE10
,P_ATTRIBUTE11 => P_ATTRIBUTE11
,P_ATTRIBUTE12 => P_ATTRIBUTE12
,P_ATTRIBUTE13 => P_ATTRIBUTE13
,P_ATTRIBUTE14 => P_ATTRIBUTE14
,P_ATTRIBUTE15 => P_ATTRIBUTE15
,P_ATTRIBUTE16 => P_ATTRIBUTE16
,P_ATTRIBUTE17 => P_ATTRIBUTE17
,P_ATTRIBUTE18 => P_ATTRIBUTE18
,P_ATTRIBUTE19 => P_ATTRIBUTE19
,P_ATTRIBUTE20 => P_ATTRIBUTE20
-- ,P_PMETH_INFORMATION_CATEGORY => P_PMETH_INFORMATION_CATEGORY
,P_PMETH_INFORMATION1 => P_PMETH_INFORMATION1
,P_PMETH_INFORMATION2 => P_PMETH_INFORMATION2
,P_PMETH_INFORMATION3 => P_PMETH_INFORMATION3
,P_PMETH_INFORMATION4 => P_PMETH_INFORMATION4
,P_PMETH_INFORMATION5 => P_PMETH_INFORMATION5
,P_PMETH_INFORMATION6 => P_PMETH_INFORMATION6
,P_PMETH_INFORMATION7 => P_PMETH_INFORMATION7
,P_PMETH_INFORMATION8 => P_PMETH_INFORMATION8
,P_PMETH_INFORMATION9 => P_PMETH_INFORMATION9
,P_PMETH_INFORMATION10 => P_PMETH_INFORMATION10
,P_PMETH_INFORMATION11 => P_PMETH_INFORMATION11
,P_PMETH_INFORMATION12 => P_PMETH_INFORMATION12
,P_PMETH_INFORMATION13 => P_PMETH_INFORMATION13
,P_PMETH_INFORMATION14 => P_PMETH_INFORMATION14
,P_PMETH_INFORMATION15 => P_PMETH_INFORMATION15
,P_PMETH_INFORMATION16 => P_PMETH_INFORMATION16
,P_PMETH_INFORMATION17 => P_PMETH_INFORMATION17
,P_PMETH_INFORMATION18 => P_PMETH_INFORMATION18
,P_PMETH_INFORMATION19 => P_PMETH_INFORMATION19
,P_PMETH_INFORMATION20 => P_PMETH_INFORMATION20
,P_COMMENTS => P_COMMENTS
,P_SEGMENT1 => P_SEGMENT1
,P_SEGMENT2 => P_SEGMENT2
,P_SEGMENT3 => P_SEGMENT3
,P_SEGMENT4 => P_SEGMENT4
,P_SEGMENT5 => P_SEGMENT5
,P_SEGMENT6 => P_SEGMENT6
,P_SEGMENT7 => P_SEGMENT7
,P_SEGMENT8 => P_SEGMENT8
,P_SEGMENT9 => P_SEGMENT9
,P_SEGMENT10 => P_SEGMENT10
,P_SEGMENT11 => P_SEGMENT11
,P_SEGMENT12 => P_SEGMENT12
,P_SEGMENT13 => P_SEGMENT13
,P_SEGMENT14 => P_SEGMENT14
,P_SEGMENT15 => P_SEGMENT15
,P_SEGMENT16 => P_SEGMENT16
,P_SEGMENT17 => P_SEGMENT17
,P_SEGMENT18 => P_SEGMENT18
,P_SEGMENT19 => P_SEGMENT19
,P_SEGMENT20 => P_SEGMENT20
,P_SEGMENT21 => P_SEGMENT21
,P_SEGMENT22 => P_SEGMENT22
,P_SEGMENT23 => P_SEGMENT23
,P_SEGMENT24 => P_SEGMENT24
,P_SEGMENT25 => P_SEGMENT25
,P_SEGMENT26 => P_SEGMENT26
,P_SEGMENT27 => P_SEGMENT27
,P_SEGMENT28 => P_SEGMENT28
,P_SEGMENT29 => P_SEGMENT29
,P_SEGMENT30 => P_SEGMENT30
,P_CONCAT_SEGMENTS => P_CONCAT_SEGMENTS
,P_GL_SEGMENT1 => P_GL_SEGMENT1
,P_GL_SEGMENT2 => P_GL_SEGMENT2
,P_GL_SEGMENT3 => P_GL_SEGMENT3
,P_GL_SEGMENT4 => P_GL_SEGMENT4
,P_GL_SEGMENT5 => P_GL_SEGMENT5
,P_GL_SEGMENT6 => P_GL_SEGMENT6
,P_GL_SEGMENT7 => P_GL_SEGMENT7
,P_GL_SEGMENT8 => P_GL_SEGMENT8
,P_GL_SEGMENT9 => P_GL_SEGMENT9
,P_GL_SEGMENT10 => P_GL_SEGMENT10
,P_GL_SEGMENT11 => P_GL_SEGMENT11
,P_GL_SEGMENT12 => P_GL_SEGMENT12
,P_GL_SEGMENT13 => P_GL_SEGMENT13
,P_GL_SEGMENT14 => P_GL_SEGMENT14
,P_GL_SEGMENT15 => P_GL_SEGMENT15
,P_GL_SEGMENT16 => P_GL_SEGMENT16
,P_GL_SEGMENT17 => P_GL_SEGMENT17
,P_GL_SEGMENT18 => P_GL_SEGMENT18
,P_GL_SEGMENT19 => P_GL_SEGMENT19
,P_GL_SEGMENT20 => P_GL_SEGMENT20
,P_GL_SEGMENT21 => P_GL_SEGMENT21
,P_GL_SEGMENT22 => P_GL_SEGMENT22
,P_GL_SEGMENT23 => P_GL_SEGMENT23
,P_GL_SEGMENT24 => P_GL_SEGMENT24
,P_GL_SEGMENT25 => P_GL_SEGMENT25
,P_GL_SEGMENT26 => P_GL_SEGMENT26
,P_GL_SEGMENT27 => P_GL_SEGMENT27
,P_GL_SEGMENT28 => P_GL_SEGMENT28
,P_GL_SEGMENT29 => P_GL_SEGMENT29
,P_GL_SEGMENT30 => P_GL_SEGMENT30
,P_GL_CONCAT_SEGMENTS => P_GL_CONCAT_SEGMENTS
,P_GL_CTRL_SEGMENT1 => P_GL_CTRL_SEGMENT1
,P_GL_CTRL_SEGMENT2 => P_GL_CTRL_SEGMENT2
,P_GL_CTRL_SEGMENT3 => P_GL_CTRL_SEGMENT3
,P_GL_CTRL_SEGMENT4 => P_GL_CTRL_SEGMENT4
,P_GL_CTRL_SEGMENT5 => P_GL_CTRL_SEGMENT5
,P_GL_CTRL_SEGMENT6 => P_GL_CTRL_SEGMENT6
,P_GL_CTRL_SEGMENT7 => P_GL_CTRL_SEGMENT7
,P_GL_CTRL_SEGMENT8 => P_GL_CTRL_SEGMENT8
,P_GL_CTRL_SEGMENT9 => P_GL_CTRL_SEGMENT9
,P_GL_CTRL_SEGMENT10 => P_GL_CTRL_SEGMENT10
,P_GL_CTRL_SEGMENT11 => P_GL_CTRL_SEGMENT11
,P_GL_CTRL_SEGMENT12 => P_GL_CTRL_SEGMENT12
,P_GL_CTRL_SEGMENT13 => P_GL_CTRL_SEGMENT13
,P_GL_CTRL_SEGMENT14 => P_GL_CTRL_SEGMENT14
,P_GL_CTRL_SEGMENT15 => P_GL_CTRL_SEGMENT15
,P_GL_CTRL_SEGMENT16 => P_GL_CTRL_SEGMENT16
,P_GL_CTRL_SEGMENT17 => P_GL_CTRL_SEGMENT17
,P_GL_CTRL_SEGMENT18 => P_GL_CTRL_SEGMENT18
,P_GL_CTRL_SEGMENT19 => P_GL_CTRL_SEGMENT19
,P_GL_CTRL_SEGMENT20 => P_GL_CTRL_SEGMENT20
,P_GL_CTRL_SEGMENT21 => P_GL_CTRL_SEGMENT21
,P_GL_CTRL_SEGMENT22 => P_GL_CTRL_SEGMENT22
,P_GL_CTRL_SEGMENT23 => P_GL_CTRL_SEGMENT23
,P_GL_CTRL_SEGMENT24 => P_GL_CTRL_SEGMENT24
,P_GL_CTRL_SEGMENT25 => P_GL_CTRL_SEGMENT25
,P_GL_CTRL_SEGMENT26 => P_GL_CTRL_SEGMENT26
,P_GL_CTRL_SEGMENT27 => P_GL_CTRL_SEGMENT27
,P_GL_CTRL_SEGMENT28 => P_GL_CTRL_SEGMENT28
,P_GL_CTRL_SEGMENT29 => P_GL_CTRL_SEGMENT29
,P_GL_CTRL_SEGMENT30 => P_GL_CTRL_SEGMENT30
,P_GL_CTRL_CONCAT_SEGMENTS => P_GL_CTRL_CONCAT_SEGMENTS
,P_GL_CCRL_SEGMENT1 => P_GL_CCRL_SEGMENT1
,P_GL_CCRL_SEGMENT2 => P_GL_CCRL_SEGMENT2
,P_GL_CCRL_SEGMENT3 => P_GL_CCRL_SEGMENT3
,P_GL_CCRL_SEGMENT4 => P_GL_CCRL_SEGMENT4
,P_GL_CCRL_SEGMENT5 => P_GL_CCRL_SEGMENT5
,P_GL_CCRL_SEGMENT6 => P_GL_CCRL_SEGMENT6
,P_GL_CCRL_SEGMENT7 => P_GL_CCRL_SEGMENT7
,P_GL_CCRL_SEGMENT8 => P_GL_CCRL_SEGMENT8
,P_GL_CCRL_SEGMENT9 => P_GL_CCRL_SEGMENT9
,P_GL_CCRL_SEGMENT10 => P_GL_CCRL_SEGMENT10
,P_GL_CCRL_SEGMENT11 => P_GL_CCRL_SEGMENT11
,P_GL_CCRL_SEGMENT12 => P_GL_CCRL_SEGMENT12
,P_GL_CCRL_SEGMENT13 => P_GL_CCRL_SEGMENT13
,P_GL_CCRL_SEGMENT14 => P_GL_CCRL_SEGMENT14
,P_GL_CCRL_SEGMENT15 => P_GL_CCRL_SEGMENT15
,P_GL_CCRL_SEGMENT16 => P_GL_CCRL_SEGMENT16
,P_GL_CCRL_SEGMENT17 => P_GL_CCRL_SEGMENT17
,P_GL_CCRL_SEGMENT18 => P_GL_CCRL_SEGMENT18
,P_GL_CCRL_SEGMENT19 => P_GL_CCRL_SEGMENT19
,P_GL_CCRL_SEGMENT20 => P_GL_CCRL_SEGMENT20
,P_GL_CCRL_SEGMENT21 => P_GL_CCRL_SEGMENT21
,P_GL_CCRL_SEGMENT22 => P_GL_CCRL_SEGMENT22
,P_GL_CCRL_SEGMENT23 => P_GL_CCRL_SEGMENT23
,P_GL_CCRL_SEGMENT24 => P_GL_CCRL_SEGMENT24
,P_GL_CCRL_SEGMENT25 => P_GL_CCRL_SEGMENT25
,P_GL_CCRL_SEGMENT26 => P_GL_CCRL_SEGMENT26
,P_GL_CCRL_SEGMENT27 => P_GL_CCRL_SEGMENT27
,P_GL_CCRL_SEGMENT28 => P_GL_CCRL_SEGMENT28
,P_GL_CCRL_SEGMENT29 => P_GL_CCRL_SEGMENT29
,P_GL_CCRL_SEGMENT30 => P_GL_CCRL_SEGMENT30
,P_GL_CCRL_CONCAT_SEGMENTS => P_GL_CCRL_CONCAT_SEGMENTS
,P_GL_ERR_SEGMENT1 => P_GL_ERR_SEGMENT1
,P_GL_ERR_SEGMENT2 => P_GL_ERR_SEGMENT2
,P_GL_ERR_SEGMENT3 => P_GL_ERR_SEGMENT3
,P_GL_ERR_SEGMENT4 => P_GL_ERR_SEGMENT4
,P_GL_ERR_SEGMENT5 => P_GL_ERR_SEGMENT5
,P_GL_ERR_SEGMENT6 => P_GL_ERR_SEGMENT6
,P_GL_ERR_SEGMENT7 => P_GL_ERR_SEGMENT7
,P_GL_ERR_SEGMENT8 => P_GL_ERR_SEGMENT8
,P_GL_ERR_SEGMENT9 => P_GL_ERR_SEGMENT9
,P_GL_ERR_SEGMENT10 => P_GL_ERR_SEGMENT10
,P_GL_ERR_SEGMENT11 => P_GL_ERR_SEGMENT11
,P_GL_ERR_SEGMENT12 => P_GL_ERR_SEGMENT12
,P_GL_ERR_SEGMENT13 => P_GL_ERR_SEGMENT13
,P_GL_ERR_SEGMENT14 => P_GL_ERR_SEGMENT14
,P_GL_ERR_SEGMENT15 => P_GL_ERR_SEGMENT15
,P_GL_ERR_SEGMENT16 => P_GL_ERR_SEGMENT16
,P_GL_ERR_SEGMENT17 => P_GL_ERR_SEGMENT17
,P_GL_ERR_SEGMENT18 => P_GL_ERR_SEGMENT18
,P_GL_ERR_SEGMENT19 => P_GL_ERR_SEGMENT19
,P_GL_ERR_SEGMENT20 => P_GL_ERR_SEGMENT20
,P_GL_ERR_SEGMENT21 => P_GL_ERR_SEGMENT21
,P_GL_ERR_SEGMENT22 => P_GL_ERR_SEGMENT22
,P_GL_ERR_SEGMENT23 => P_GL_ERR_SEGMENT23
,P_GL_ERR_SEGMENT24 => P_GL_ERR_SEGMENT24
,P_GL_ERR_SEGMENT25 => P_GL_ERR_SEGMENT25
,P_GL_ERR_SEGMENT26 => P_GL_ERR_SEGMENT26
,P_GL_ERR_SEGMENT27 => P_GL_ERR_SEGMENT27
,P_GL_ERR_SEGMENT28 => P_GL_ERR_SEGMENT28
,P_GL_ERR_SEGMENT29 => P_GL_ERR_SEGMENT29
,P_GL_ERR_SEGMENT30 => P_GL_ERR_SEGMENT30
,P_GL_ERR_CONCAT_SEGMENTS => P_GL_ERR_CONCAT_SEGMENTS
,P_SETS_OF_BOOK_ID => P_SETS_OF_BOOK_ID
,P_TRANSFER_TO_GL_FLAG => P_TRANSFER_TO_GL_FLAG
,P_COST_PAYMENT => P_COST_PAYMENT
,P_COST_CLEARED_PAYMENT => P_COST_CLEARED_PAYMENT
,P_COST_CLEARED_VOID_PAYMENT => P_COST_CLEARED_VOID_PAYMENT
,P_EXCLUDE_MANUAL_PAYMENT => P_EXCLUDE_MANUAL_PAYMENT
);
(p_module_name => 'update_org_payment_method_b'
,p_hook_type => 'BP'
);
,p_datetrack_mode => p_datetrack_update_mode
,p_org_payment_method_id => p_org_payment_method_id
,p_object_version_number => l_object_version_number
,p_external_account_id => l_external_account_id
,p_currency_code => l_currency_code
,p_comments => p_comments
,p_attribute_category => p_attribute_category
,p_attribute1 => p_attribute1
,p_attribute2 => p_attribute2
,p_attribute3 => p_attribute3
,p_attribute4 => p_attribute4
,p_attribute5 => p_attribute5
,p_attribute6 => p_attribute6
,p_attribute7 => p_attribute7
,p_attribute8 => p_attribute8
,p_attribute9 => p_attribute9
,p_attribute10 => p_attribute10
,p_attribute11 => p_attribute11
,p_attribute12 => p_attribute12
,p_attribute13 => p_attribute13
,p_attribute14 => p_attribute14
,p_attribute15 => p_attribute15
,p_attribute16 => p_attribute16
,p_attribute17 => p_attribute17
,p_attribute18 => p_attribute18
,p_attribute19 => p_attribute19
,p_attribute20 => p_attribute20
,p_pmeth_information_category => l_pmeth_information_category
,p_pmeth_information1 => p_pmeth_information1
,p_pmeth_information2 => p_pmeth_information2
,p_pmeth_information3 => p_pmeth_information3
,p_pmeth_information4 => p_pmeth_information4
,p_pmeth_information5 => p_pmeth_information5
,p_pmeth_information6 => p_pmeth_information6
,p_pmeth_information7 => p_pmeth_information7
,p_pmeth_information8 => p_pmeth_information8
,p_pmeth_information9 => p_pmeth_information9
,p_pmeth_information10 => p_pmeth_information10
,p_pmeth_information11 => p_pmeth_information11
,p_pmeth_information12 => p_pmeth_information12
,p_pmeth_information13 => p_pmeth_information13
,p_pmeth_information14 => p_pmeth_information14
,p_pmeth_information15 => p_pmeth_information15
,p_pmeth_information16 => p_pmeth_information16
,p_pmeth_information17 => p_pmeth_information17
,p_pmeth_information18 => p_pmeth_information18
,p_pmeth_information19 => p_pmeth_information19
,p_pmeth_information20 => p_pmeth_information20
,p_TRANSFER_TO_GL_FLAG => p_TRANSFER_TO_GL_FLAG
,p_cost_payment => p_cost_payment
,p_cost_cleared_payment => p_cost_cleared_payment
,p_cost_cleared_void_payment => p_cost_cleared_void_payment
,p_exclude_manual_payment => p_exclude_manual_payment
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date
,p_comment_id => l_comment_id
);
pay_maintain_bank_acct.update_payroll_bank_acct(
p_bank_account_id => p_bank_account_id,
p_external_account_id =>l_external_account_id,
p_org_payment_method_id => p_org_payment_method_id);
pay_maintain_bank_acct.update_asset_ccid(
p_assest_ccid =>l_ASSET_CODE_COMBINATION_ID,
p_set_of_books_id =>l_set_of_books_id,
p_external_account_id =>l_external_account_id
);
pay_maintain_bank_acct.update_asset_ccid(
p_assest_ccid =>null,
p_set_of_books_id =>l_set_of_books_id,
p_external_account_id =>l_external_account_id
);
PAY_PAYMENT_GL_ACCOUNTS_PKG.UPDATE_ROW
( P_EFFECTIVE_START_DATE => l_effective_start_date,
P_EFFECTIVE_END_DATE => l_effective_end_date,
P_SET_OF_BOOKS_ID => l_set_of_books_id,
P_GL_CASH_AC_ID => l_gl_cash_ac_id,
P_GL_CASH_CLEARING_AC_ID => l_gl_cash_clearing_ac_id,
P_GL_CONTROL_AC_ID => l_gl_control_ac_id,
P_GL_ERROR_AC_ID => l_gl_error_ac_id,
P_EXTERNAL_ACCOUNT_ID => l_external_account_id,
P_ORG_PAYMENT_METHOD_ID => p_org_payment_method_id,
P_DT_UPDATE_MODE => P_DATETRACK_UPDATE_MODE,
P_DEFAULT_GL_ACCOUNT => p_default_gl_account,
P_PAY_GL_ACCOUNT_ID_OUT => l_pay_gl_account_id_out
);
pay_org_payment_method_bk2.update_org_payment_method_a
(P_EFFECTIVE_DATE => l_EFFECTIVE_DATE
,P_DATETRACK_UPDATE_MODE => P_DATETRACK_UPDATE_MODE
,P_LANGUAGE_CODE => l_LANGUAGE_CODE
,P_ORG_PAYMENT_METHOD_ID => P_ORG_PAYMENT_METHOD_ID
,P_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER
,P_ORG_PAYMENT_METHOD_NAME => P_ORG_PAYMENT_METHOD_NAME
,P_CURRENCY_CODE => l_CURRENCY_CODE
,P_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY
,P_ATTRIBUTE1 => P_ATTRIBUTE1
,P_ATTRIBUTE2 => P_ATTRIBUTE2
,P_ATTRIBUTE3 => P_ATTRIBUTE3
,P_ATTRIBUTE4 => P_ATTRIBUTE4
,P_ATTRIBUTE5 => P_ATTRIBUTE5
,P_ATTRIBUTE6 => P_ATTRIBUTE6
,P_ATTRIBUTE7 => P_ATTRIBUTE7
,P_ATTRIBUTE8 => P_ATTRIBUTE8
,P_ATTRIBUTE9 => P_ATTRIBUTE9
,P_ATTRIBUTE10 => P_ATTRIBUTE10
,P_ATTRIBUTE11 => P_ATTRIBUTE11
,P_ATTRIBUTE12 => P_ATTRIBUTE12
,P_ATTRIBUTE13 => P_ATTRIBUTE13
,P_ATTRIBUTE14 => P_ATTRIBUTE14
,P_ATTRIBUTE15 => P_ATTRIBUTE15
,P_ATTRIBUTE16 => P_ATTRIBUTE16
,P_ATTRIBUTE17 => P_ATTRIBUTE17
,P_ATTRIBUTE18 => P_ATTRIBUTE18
,P_ATTRIBUTE19 => P_ATTRIBUTE19
,P_ATTRIBUTE20 => P_ATTRIBUTE20
-- ,P_PMETH_INFORMATION_CATEGORY => P_PMETH_INFORMATION_CATEGORY
,P_PMETH_INFORMATION1 => P_PMETH_INFORMATION1
,P_PMETH_INFORMATION2 => P_PMETH_INFORMATION2
,P_PMETH_INFORMATION3 => P_PMETH_INFORMATION3
,P_PMETH_INFORMATION4 => P_PMETH_INFORMATION4
,P_PMETH_INFORMATION5 => P_PMETH_INFORMATION5
,P_PMETH_INFORMATION6 => P_PMETH_INFORMATION6
,P_PMETH_INFORMATION7 => P_PMETH_INFORMATION7
,P_PMETH_INFORMATION8 => P_PMETH_INFORMATION8
,P_PMETH_INFORMATION9 => P_PMETH_INFORMATION9
,P_PMETH_INFORMATION10 => P_PMETH_INFORMATION10
,P_PMETH_INFORMATION11 => P_PMETH_INFORMATION11
,P_PMETH_INFORMATION12 => P_PMETH_INFORMATION12
,P_PMETH_INFORMATION13 => P_PMETH_INFORMATION13
,P_PMETH_INFORMATION14 => P_PMETH_INFORMATION14
,P_PMETH_INFORMATION15 => P_PMETH_INFORMATION15
,P_PMETH_INFORMATION16 => P_PMETH_INFORMATION16
,P_PMETH_INFORMATION17 => P_PMETH_INFORMATION17
,P_PMETH_INFORMATION18 => P_PMETH_INFORMATION18
,P_PMETH_INFORMATION19 => P_PMETH_INFORMATION19
,P_PMETH_INFORMATION20 => P_PMETH_INFORMATION20
,P_COMMENTS => P_COMMENTS
,P_SEGMENT1 => P_SEGMENT1
,P_SEGMENT2 => P_SEGMENT2
,P_SEGMENT3 => P_SEGMENT3
,P_SEGMENT4 => P_SEGMENT4
,P_SEGMENT5 => P_SEGMENT5
,P_SEGMENT6 => P_SEGMENT6
,P_SEGMENT7 => P_SEGMENT7
,P_SEGMENT8 => P_SEGMENT8
,P_SEGMENT9 => P_SEGMENT9
,P_SEGMENT10 => P_SEGMENT10
,P_SEGMENT11 => P_SEGMENT11
,P_SEGMENT12 => P_SEGMENT12
,P_SEGMENT13 => P_SEGMENT13
,P_SEGMENT14 => P_SEGMENT14
,P_SEGMENT15 => P_SEGMENT15
,P_SEGMENT16 => P_SEGMENT16
,P_SEGMENT17 => P_SEGMENT17
,P_SEGMENT18 => P_SEGMENT18
,P_SEGMENT19 => P_SEGMENT19
,P_SEGMENT20 => P_SEGMENT20
,P_SEGMENT21 => P_SEGMENT21
,P_SEGMENT22 => P_SEGMENT22
,P_SEGMENT23 => P_SEGMENT23
,P_SEGMENT24 => P_SEGMENT24
,P_SEGMENT25 => P_SEGMENT25
,P_SEGMENT26 => P_SEGMENT26
,P_SEGMENT27 => P_SEGMENT27
,P_SEGMENT28 => P_SEGMENT28
,P_SEGMENT29 => P_SEGMENT29
,P_SEGMENT30 => P_SEGMENT30
,P_CONCAT_SEGMENTS => P_CONCAT_SEGMENTS
,P_GL_SEGMENT1 => P_GL_SEGMENT1
,P_GL_SEGMENT2 => P_GL_SEGMENT2
,P_GL_SEGMENT3 => P_GL_SEGMENT3
,P_GL_SEGMENT4 => P_GL_SEGMENT4
,P_GL_SEGMENT5 => P_GL_SEGMENT5
,P_GL_SEGMENT6 => P_GL_SEGMENT6
,P_GL_SEGMENT7 => P_GL_SEGMENT7
,P_GL_SEGMENT8 => P_GL_SEGMENT8
,P_GL_SEGMENT9 => P_GL_SEGMENT9
,P_GL_SEGMENT10 => P_GL_SEGMENT10
,P_GL_SEGMENT11 => P_GL_SEGMENT11
,P_GL_SEGMENT12 => P_GL_SEGMENT12
,P_GL_SEGMENT13 => P_GL_SEGMENT13
,P_GL_SEGMENT14 => P_GL_SEGMENT14
,P_GL_SEGMENT15 => P_GL_SEGMENT15
,P_GL_SEGMENT16 => P_GL_SEGMENT16
,P_GL_SEGMENT17 => P_GL_SEGMENT17
,P_GL_SEGMENT18 => P_GL_SEGMENT18
,P_GL_SEGMENT19 => P_GL_SEGMENT19
,P_GL_SEGMENT20 => P_GL_SEGMENT20
,P_GL_SEGMENT21 => P_GL_SEGMENT21
,P_GL_SEGMENT22 => P_GL_SEGMENT22
,P_GL_SEGMENT23 => P_GL_SEGMENT23
,P_GL_SEGMENT24 => P_GL_SEGMENT24
,P_GL_SEGMENT25 => P_GL_SEGMENT25
,P_GL_SEGMENT26 => P_GL_SEGMENT26
,P_GL_SEGMENT27 => P_GL_SEGMENT27
,P_GL_SEGMENT28 => P_GL_SEGMENT28
,P_GL_SEGMENT29 => P_GL_SEGMENT29
,P_GL_SEGMENT30 => P_GL_SEGMENT30
,P_GL_CONCAT_SEGMENTS => P_GL_CONCAT_SEGMENTS
,P_GL_CTRL_SEGMENT1 => P_GL_CTRL_SEGMENT1
,P_GL_CTRL_SEGMENT2 => P_GL_CTRL_SEGMENT2
,P_GL_CTRL_SEGMENT3 => P_GL_CTRL_SEGMENT3
,P_GL_CTRL_SEGMENT4 => P_GL_CTRL_SEGMENT4
,P_GL_CTRL_SEGMENT5 => P_GL_CTRL_SEGMENT5
,P_GL_CTRL_SEGMENT6 => P_GL_CTRL_SEGMENT6
,P_GL_CTRL_SEGMENT7 => P_GL_CTRL_SEGMENT7
,P_GL_CTRL_SEGMENT8 => P_GL_CTRL_SEGMENT8
,P_GL_CTRL_SEGMENT9 => P_GL_CTRL_SEGMENT9
,P_GL_CTRL_SEGMENT10 => P_GL_CTRL_SEGMENT10
,P_GL_CTRL_SEGMENT11 => P_GL_CTRL_SEGMENT11
,P_GL_CTRL_SEGMENT12 => P_GL_CTRL_SEGMENT12
,P_GL_CTRL_SEGMENT13 => P_GL_CTRL_SEGMENT13
,P_GL_CTRL_SEGMENT14 => P_GL_CTRL_SEGMENT14
,P_GL_CTRL_SEGMENT15 => P_GL_CTRL_SEGMENT15
,P_GL_CTRL_SEGMENT16 => P_GL_CTRL_SEGMENT16
,P_GL_CTRL_SEGMENT17 => P_GL_CTRL_SEGMENT17
,P_GL_CTRL_SEGMENT18 => P_GL_CTRL_SEGMENT18
,P_GL_CTRL_SEGMENT19 => P_GL_CTRL_SEGMENT19
,P_GL_CTRL_SEGMENT20 => P_GL_CTRL_SEGMENT20
,P_GL_CTRL_SEGMENT21 => P_GL_CTRL_SEGMENT21
,P_GL_CTRL_SEGMENT22 => P_GL_CTRL_SEGMENT22
,P_GL_CTRL_SEGMENT23 => P_GL_CTRL_SEGMENT23
,P_GL_CTRL_SEGMENT24 => P_GL_CTRL_SEGMENT24
,P_GL_CTRL_SEGMENT25 => P_GL_CTRL_SEGMENT25
,P_GL_CTRL_SEGMENT26 => P_GL_CTRL_SEGMENT26
,P_GL_CTRL_SEGMENT27 => P_GL_CTRL_SEGMENT27
,P_GL_CTRL_SEGMENT28 => P_GL_CTRL_SEGMENT28
,P_GL_CTRL_SEGMENT29 => P_GL_CTRL_SEGMENT29
,P_GL_CTRL_SEGMENT30 => P_GL_CTRL_SEGMENT30
,P_GL_CTRL_CONCAT_SEGMENTS => P_GL_CTRL_CONCAT_SEGMENTS
,P_GL_CCRL_SEGMENT1 => P_GL_CCRL_SEGMENT1
,P_GL_CCRL_SEGMENT2 => P_GL_CCRL_SEGMENT2
,P_GL_CCRL_SEGMENT3 => P_GL_CCRL_SEGMENT3
,P_GL_CCRL_SEGMENT4 => P_GL_CCRL_SEGMENT4
,P_GL_CCRL_SEGMENT5 => P_GL_CCRL_SEGMENT5
,P_GL_CCRL_SEGMENT6 => P_GL_CCRL_SEGMENT6
,P_GL_CCRL_SEGMENT7 => P_GL_CCRL_SEGMENT7
,P_GL_CCRL_SEGMENT8 => P_GL_CCRL_SEGMENT8
,P_GL_CCRL_SEGMENT9 => P_GL_CCRL_SEGMENT9
,P_GL_CCRL_SEGMENT10 => P_GL_CCRL_SEGMENT10
,P_GL_CCRL_SEGMENT11 => P_GL_CCRL_SEGMENT11
,P_GL_CCRL_SEGMENT12 => P_GL_CCRL_SEGMENT12
,P_GL_CCRL_SEGMENT13 => P_GL_CCRL_SEGMENT13
,P_GL_CCRL_SEGMENT14 => P_GL_CCRL_SEGMENT14
,P_GL_CCRL_SEGMENT15 => P_GL_CCRL_SEGMENT15
,P_GL_CCRL_SEGMENT16 => P_GL_CCRL_SEGMENT16
,P_GL_CCRL_SEGMENT17 => P_GL_CCRL_SEGMENT17
,P_GL_CCRL_SEGMENT18 => P_GL_CCRL_SEGMENT18
,P_GL_CCRL_SEGMENT19 => P_GL_CCRL_SEGMENT19
,P_GL_CCRL_SEGMENT20 => P_GL_CCRL_SEGMENT20
,P_GL_CCRL_SEGMENT21 => P_GL_CCRL_SEGMENT21
,P_GL_CCRL_SEGMENT22 => P_GL_CCRL_SEGMENT22
,P_GL_CCRL_SEGMENT23 => P_GL_CCRL_SEGMENT23
,P_GL_CCRL_SEGMENT24 => P_GL_CCRL_SEGMENT24
,P_GL_CCRL_SEGMENT25 => P_GL_CCRL_SEGMENT25
,P_GL_CCRL_SEGMENT26 => P_GL_CCRL_SEGMENT26
,P_GL_CCRL_SEGMENT27 => P_GL_CCRL_SEGMENT27
,P_GL_CCRL_SEGMENT28 => P_GL_CCRL_SEGMENT28
,P_GL_CCRL_SEGMENT29 => P_GL_CCRL_SEGMENT29
,P_GL_CCRL_SEGMENT30 => P_GL_CCRL_SEGMENT30
,P_GL_CCRL_CONCAT_SEGMENTS => P_GL_CCRL_CONCAT_SEGMENTS
,P_GL_ERR_SEGMENT1 => P_GL_ERR_SEGMENT1
,P_GL_ERR_SEGMENT2 => P_GL_ERR_SEGMENT2
,P_GL_ERR_SEGMENT3 => P_GL_ERR_SEGMENT3
,P_GL_ERR_SEGMENT4 => P_GL_ERR_SEGMENT4
,P_GL_ERR_SEGMENT5 => P_GL_ERR_SEGMENT5
,P_GL_ERR_SEGMENT6 => P_GL_ERR_SEGMENT6
,P_GL_ERR_SEGMENT7 => P_GL_ERR_SEGMENT7
,P_GL_ERR_SEGMENT8 => P_GL_ERR_SEGMENT8
,P_GL_ERR_SEGMENT9 => P_GL_ERR_SEGMENT9
,P_GL_ERR_SEGMENT10 => P_GL_ERR_SEGMENT10
,P_GL_ERR_SEGMENT11 => P_GL_ERR_SEGMENT11
,P_GL_ERR_SEGMENT12 => P_GL_ERR_SEGMENT12
,P_GL_ERR_SEGMENT13 => P_GL_ERR_SEGMENT13
,P_GL_ERR_SEGMENT14 => P_GL_ERR_SEGMENT14
,P_GL_ERR_SEGMENT15 => P_GL_ERR_SEGMENT15
,P_GL_ERR_SEGMENT16 => P_GL_ERR_SEGMENT16
,P_GL_ERR_SEGMENT17 => P_GL_ERR_SEGMENT17
,P_GL_ERR_SEGMENT18 => P_GL_ERR_SEGMENT18
,P_GL_ERR_SEGMENT19 => P_GL_ERR_SEGMENT19
,P_GL_ERR_SEGMENT20 => P_GL_ERR_SEGMENT20
,P_GL_ERR_SEGMENT21 => P_GL_ERR_SEGMENT21
,P_GL_ERR_SEGMENT22 => P_GL_ERR_SEGMENT22
,P_GL_ERR_SEGMENT23 => P_GL_ERR_SEGMENT23
,P_GL_ERR_SEGMENT24 => P_GL_ERR_SEGMENT24
,P_GL_ERR_SEGMENT25 => P_GL_ERR_SEGMENT25
,P_GL_ERR_SEGMENT26 => P_GL_ERR_SEGMENT26
,P_GL_ERR_SEGMENT27 => P_GL_ERR_SEGMENT27
,P_GL_ERR_SEGMENT28 => P_GL_ERR_SEGMENT28
,P_GL_ERR_SEGMENT29 => P_GL_ERR_SEGMENT29
,P_GL_ERR_SEGMENT30 => P_GL_ERR_SEGMENT30
,P_GL_ERR_CONCAT_SEGMENTS => P_GL_ERR_CONCAT_SEGMENTS
,P_SETS_OF_BOOK_ID => P_SETS_OF_BOOK_ID
,P_EFFECTIVE_START_DATE => l_EFFECTIVE_START_DATE
,P_EFFECTIVE_END_DATE => l_EFFECTIVE_END_DATE
,P_ASSET_CODE_COMBINATION_ID => l_ASSET_CODE_COMBINATION_ID
,P_COMMENT_ID => l_COMMENT_ID
,P_EXTERNAL_ACCOUNT_ID => l_EXTERNAL_ACCOUNT_ID
,P_TRANSFER_TO_GL_FLAG => P_TRANSFER_TO_GL_FLAG
,P_COST_PAYMENT => P_COST_PAYMENT
,P_COST_CLEARED_PAYMENT => P_COST_CLEARED_PAYMENT
,P_COST_CLEARED_VOID_PAYMENT => P_COST_CLEARED_VOID_PAYMENT
,P_EXCLUDE_MANUAL_PAYMENT => P_EXCLUDE_MANUAL_PAYMENT
);
(p_module_name => 'update_org_payment_method_a'
,p_hook_type => 'AP'
);
rollback to update_org_payment_method;
rollback to update_org_payment_method;
end update_org_payment_method;
procedure delete_org_payment_method
(P_VALIDATE in boolean default false
,P_EFFECTIVE_DATE in date
,P_DATETRACK_DELETE_MODE in varchar2
,P_ORG_PAYMENT_METHOD_ID in number
,P_OBJECT_VERSION_NUMBER in out nocopy number
,P_EFFECTIVE_START_DATE out nocopy date
,P_EFFECTIVE_END_DATE out nocopy date
) is
--
-- Declare cursors and local variables
--
l_proc varchar2(72) := g_package||'delete_org_payment_method';
savepoint delete_org_payment_method;
pay_org_payment_method_bk3.delete_org_payment_method_b
(P_EFFECTIVE_DATE => l_EFFECTIVE_DATE
,P_DATETRACK_DELETE_MODE => P_DATETRACK_DELETE_MODE
,P_ORG_PAYMENT_METHOD_ID => P_ORG_PAYMENT_METHOD_ID
,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
);
(p_module_name => 'delete_org_payment_method_b'
,p_hook_type => 'BP'
);
if (p_datetrack_delete_mode = hr_api.g_zap) then
--
-- Need to lock main table to maintain the locking ladder order
--
hr_utility.set_location( l_proc, 30);
,p_datetrack_mode => p_datetrack_delete_mode
,p_org_payment_method_id => p_org_payment_method_id
,p_object_version_number => p_object_version_number
,p_validation_start_date => l_effective_start_date
,p_validation_end_date => l_effective_end_date
);
,p_datetrack_mode => P_DATETRACK_DELETE_MODE
,p_org_payment_method_id => p_org_payment_method_id
,p_object_version_number => l_object_version_number
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date
);
PAY_PAYMENT_GL_ACCOUNTS_PKG.DELETE_ROW (
p_org_payment_method_id => p_org_payment_method_id
,p_effective_date => l_effective_date
,p_datetrack_mode => P_DATETRACK_DELETE_MODE
,p_org_eff_start_date => l_effective_start_date
,p_org_eff_end_date => l_effective_end_date);
pay_org_payment_method_bk3.delete_org_payment_method_a
(P_EFFECTIVE_DATE => l_EFFECTIVE_DATE
,P_DATETRACK_DELETE_MODE => P_DATETRACK_DELETE_MODE
,P_ORG_PAYMENT_METHOD_ID => P_ORG_PAYMENT_METHOD_ID
,P_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER
,P_EFFECTIVE_START_DATE => l_EFFECTIVE_START_DATE
,P_EFFECTIVE_END_DATE => l_EFFECTIVE_END_DATE
);
(p_module_name => 'delete_org_payment_method_a'
,p_hook_type => 'AP'
);
ROLLBACK TO delete_org_payment_method;
ROLLBACK TO delete_org_payment_method;
end delete_org_payment_method;