APPS.XTR_HEDGE_PROCESS_P dependencies on XTR_HEDGE_PROCESS_P

Line 1: PACKAGE BODY XTR_HEDGE_PROCESS_P AS

1: PACKAGE BODY XTR_HEDGE_PROCESS_P AS
2: /* $Header: xtrhdgpb.pls 120.8.12020000.2 2013/03/19 14:43:15 nipant ship $ */
3:
4:
5: /*=====================================================================

Line 508: LOG_MSG('Error', 'Error occured in XTR_HEDGE_PROCESS_P.xtr_ins_dnm');

504: Exception
505: when others then
506: fnd_message.set_name('XTR', 'XTR_154');
507: APP_EXCEPTION.Raise_exception;
508: LOG_MSG('Error', 'Error occured in XTR_HEDGE_PROCESS_P.xtr_ins_dnm');
509: LOG_MSG('Error', SQLERRM);
510: END xtr_ins_dnm;
511:
512: Begin

Line 2022: If xtr_hedge_process_p.get_source_code(P_HEDGE_NO) = 'AP' then

2018: open source(P_HEDGE_NO);
2019: fetch source into l_source_id, l_iu_flag;
2020: close source;
2021:
2022: If xtr_hedge_process_p.get_source_code(P_HEDGE_NO) = 'AP' then
2023: l_query := ' SELECT INVOICE_ID, PAYMENT_NUM, AMOUNT FROM XTR_AP_ORIG_TRX_V '||get_where_clause(P_HEDGE_NO);
2024: Elsif xtr_hedge_process_p.get_source_code(P_HEDGE_NO) = 'AR' then
2025: l_query := ' SELECT CUSTOMER_TRX_ID, PAYMENT_SCHEDULE_ID, AMOUNT FROM XTR_AR_ORIG_TRX_V '||get_where_clause(P_HEDGE_NO);
2026: End If;

Line 2024: Elsif xtr_hedge_process_p.get_source_code(P_HEDGE_NO) = 'AR' then

2020: close source;
2021:
2022: If xtr_hedge_process_p.get_source_code(P_HEDGE_NO) = 'AP' then
2023: l_query := ' SELECT INVOICE_ID, PAYMENT_NUM, AMOUNT FROM XTR_AP_ORIG_TRX_V '||get_where_clause(P_HEDGE_NO);
2024: Elsif xtr_hedge_process_p.get_source_code(P_HEDGE_NO) = 'AR' then
2025: l_query := ' SELECT CUSTOMER_TRX_ID, PAYMENT_SCHEDULE_ID, AMOUNT FROM XTR_AR_ORIG_TRX_V '||get_where_clause(P_HEDGE_NO);
2026: End If;
2027:
2028: OPEN hcur FOR l_query;

Line 3014: END XTR_HEDGE_PROCESS_P;

3010: );
3011:
3012: END DELETE_CRITERIA_SET;
3013:
3014: END XTR_HEDGE_PROCESS_P;
3015: