eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_TRX_IMPORT dependencies on PA_TRX_IMPORT

Line 1: PACKAGE BODY PA_TRX_IMPORT AS

1: PACKAGE BODY PA_TRX_IMPORT AS
2: /* $Header: PAXTTRXB.pls 120.130.12020000.7 2013/04/05 07:06:35 rboyalap ship $ */
3:
4: last_empno VARCHAR2(30) DEFAULT NULL;
5: last_proj VARCHAR2(25) DEFAULT NULL;

Line 765: we are not performing these checks in PA_TRX_IMPORT.

761: /* PA-I Changes
762: For un-accounted transactions we need not call DefaultCurrAttributes.
763: This is because the checks that are being performed here will be anyway
764: performed during costing in pa_multi_currency_txn. To avoid redundant code
765: we are not performing these checks in PA_TRX_IMPORT.
766: Please see prior versions for the changed DefaultCurrAttributes if needed.
767: */
768:
769: PROCEDURE GetVendorId(P_vendor_number IN VARCHAR2)

Line 2466: IF pa_trx_import.g_skip_tc_flag <> 'Y' and PA_TRX_IMPORT.Get_GVal_ProjTskEi_Date = 'Y' then /* Added for Bug # 2170237 */

2462: END IF; --Predefined source check for person and organization id
2463:
2464: -- PA-K Changes: Moved CheckExporg to below one place
2465: IF G_org_id is not NULL THEN
2466: IF pa_trx_import.g_skip_tc_flag <> 'Y' and PA_TRX_IMPORT.Get_GVal_ProjTskEi_Date = 'Y' then /* Added for Bug # 2170237 */
2467: -- Modified the above condition for BUG6931833
2468: IF PG_DEBUG = 'Y' THEN
2469: pa_debug.G_err_stage := 'Calling pa_utils2.CheckExporg';
2470: log_message('log_message: ' || pa_debug.G_err_Stage);

Line 2554: ELSIF pa_trx_import.g_skip_tc_flag <> 'Y' and PA_TRX_IMPORT.Get_GVal_ProjTskEi_Date = 'Y' THEN /* Added for Bug # 2170237 */

2550: IF (G_override_to_org_id IS NULL) THEN
2551: X_status := 'PA_OVERRIDE_ORG_INVALID';
2552: pa_cc_utils.reset_curr_function;
2553: RETURN;
2554: ELSIF pa_trx_import.g_skip_tc_flag <> 'Y' and PA_TRX_IMPORT.Get_GVal_ProjTskEi_Date = 'Y' THEN /* Added for Bug # 2170237 */
2555: --Modified above condition for bug6931833
2556: IF pa_utils2.CheckExporg(G_override_to_org_id, X_ei_date) = 'N' THEN
2557: X_status := 'PA_OVERRIDE_ORG_NOT_ACTIVE';
2558: pa_cc_utils.reset_curr_function;

Line 2891: If pa_trx_import.g_skip_tc_flag <> 'Y' and PA_TRX_IMPORT.Get_GVal_ProjTskEi_Date = 'Y' then

2887: -- ===========================================================================
2888: -- Check if the cross charging is allowed for this project
2889:
2890: --Bug 2726763: Add skip_tc_flag check for checking if project is chargeable.
2891: If pa_trx_import.g_skip_tc_flag <> 'Y' and PA_TRX_IMPORT.Get_GVal_ProjTskEi_Date = 'Y' then
2892: --Modified above condition for BUG6931833
2893:
2894: IF PG_DEBUG = 'Y' THEN
2895: pa_debug.G_err_stage := 'Calling pa_utils.IsCrossChargeable';

Line 3539: we are not performing these checks in PA_TRX_IMPORT.

3535: /* PA-I Changes
3536: For un-accounted transactions we need not call DefaultCurrAttributes.
3537: This is because the checks that are being performed here will be anyway
3538: performed during costing in pa_multi_currency_txn. To avoid redundant code
3539: we are not performing these checks in PA_TRX_IMPORT.
3540: */
3541:
3542: /*-----------------------------------------------------------------------------
3543: -- END MULTI CURRENCY VALIDATION FOR COSTED/UNCOSTED UNACCOUNTED TXNS

Line 5413: Select Sum ( Quantity * PA_TRX_IMPORT.GET_PO_PRICE_TYPE_RATE (Project_id , Task_Id , P_Po_Line_Id , po_price_type ) )

5409: and exp.person_type = 'CWK';
5410: */
5411:
5412: /* Bug 4098920
5413: Select Sum ( Quantity * PA_TRX_IMPORT.GET_PO_PRICE_TYPE_RATE (Project_id , Task_Id , P_Po_Line_Id , po_price_type ) )
5414: into l_uncosted
5415: From
5416: (
5417: select ei.project_id , ei.task_id , ei.po_price_type , sum(quantity) Quantity

Line 5435: 'N', Quantity * PA_TRX_IMPORT.GET_PO_PRICE_TYPE_RATE (G_project_id , G_task_id , P_Po_Line_Id , po_price_type ), 0

5431: /* Bug 4098920 : Combined the SQLs for Costed and Uncosted EI */
5432: If Is_Po_Line_Task_Processed ( P_Po_Line_Id, G_task_id ) = False Then
5433: Select Sum (
5434: Decode ( cost_distributed_flag,
5435: 'N', Quantity * PA_TRX_IMPORT.GET_PO_PRICE_TYPE_RATE (G_project_id , G_task_id , P_Po_Line_Id , po_price_type ), 0
5436:
5437: )
5438: ) ,
5439: Sum (

Line 5580: If PA_TRX_IMPORT.Get_GVal_ProjTskEi_Date = 'Y' then -- Added for BUG6931833

5576: pa_debug.G_err_stage := 'Calling pa_transactions_pub.validate_transaction';
5577: log_message('log_message: ' || pa_debug.G_err_Stage);
5578: END IF;
5579:
5580: If PA_TRX_IMPORT.Get_GVal_ProjTskEi_Date = 'Y' then -- Added for BUG6931833
5581:
5582: pa_transactions_pub.validate_transaction(
5583: X_project_id => G_project_id
5584: , X_task_id => G_task_id

Line 9969: pa_trx_import.pre_import(P_transaction_source => X_transaction_source,

9965: pa_debug.G_err_Stage := 'Calling pre_import extension';
9966: log_message('log_message: ' || pa_debug.G_err_Stage);
9967: END IF;
9968:
9969: pa_trx_import.pre_import(P_transaction_source => X_transaction_source,
9970: P_batch => X_batch,
9971: P_xface_id => X_xface_id,
9972: P_user_id => X_userid);
9973:

Line 9990: pa_trx_import.import1(X_transaction_source

9986: END pre_import;
9987:
9988: <>
9989: BEGIN
9990: pa_trx_import.import1(X_transaction_source
9991: , X_batch
9992: , X_xface_id
9993: , X_userid
9994: , X_online_exp_comment);

Line 10103: pa_trx_import.post_import(P_transaction_source => X_transaction_source,

10099: pa_debug.G_err_Stage := 'Calling post_import extension';
10100: log_message('log_message: ' || pa_debug.G_err_Stage);
10101: END IF;
10102:
10103: pa_trx_import.post_import(P_transaction_source => X_transaction_source,
10104: P_batch => X_batch,
10105: P_xface_id => X_xface_id,
10106: P_user_id => X_userid);
10107:

Line 10162: pa_cc_utils.set_curr_function('pa_trx_import.init');

10158: pa_debug.set_process(x_process => 'PLSQL',
10159: x_debug_mode => G_debug_mode);
10160:
10161: pa_cc_utils.log_message('Debug Mode = '||G_debug_mode,1);
10162: pa_cc_utils.set_curr_function('pa_trx_import.init');
10163:
10164: IF PG_DEBUG = 'Y' THEN
10165: pa_debug.G_err_Stage := 'retriving transaction source';
10166: log_message('log_message: ' || pa_debug.G_err_Stage);

Line 10250: pa_trx_import.execute_import_extensions( P_program_name => G_pre_processing_extn,

10246: P_xface_id IN NUMBER,
10247: P_user_id IN NUMBER) IS
10248: BEGIN
10249:
10250: pa_trx_import.execute_import_extensions( P_program_name => G_pre_processing_extn,
10251: P_transaction_source => P_transaction_source,
10252: P_batch => P_batch,
10253: P_xface_id => P_xface_id,
10254: P_user_id => P_user_id);

Line 10266: pa_trx_import.execute_import_extensions( P_program_name => G_post_processing_extn,

10262: P_xface_id IN NUMBER,
10263: P_user_id IN NUMBER) IS
10264: BEGIN
10265:
10266: pa_trx_import.execute_import_extensions( P_program_name => G_post_processing_extn,
10267: P_transaction_source => P_transaction_source,
10268: P_batch => P_batch,
10269: P_xface_id => P_xface_id,
10270: P_user_id => P_user_id);

Line 10666: -- BUG : 4885459 : APPSPERF:PA:PJC: PA_TRX_IMPORT : PERF. REPOSITORY EXCEPTIONS

10662: END IF;
10663:
10664: IF (pa_funds_control_utils.get_bdgt_link(l_Project_Id, 'STD') = 'Y') THEN
10665:
10666: -- BUG : 4885459 : APPSPERF:PA:PJC: PA_TRX_IMPORT : PERF. REPOSITORY EXCEPTIONS
10667:
10668: l_ExpItemId_temp_Tab.DELETE ;
10669:
10670: select ei.expenditure_item_id

Line 10762: -- BUG : 4885459 APPSPERF:PA:PJC: PA_TRX_IMPORT : PERF. REPOSITORY EXCEPTIONS

10758: END IF;
10759:
10760: IF (pa_funds_control_utils.get_bdgt_link(l_Project_Id, 'STD') = 'Y') THEN
10761:
10762: -- BUG : 4885459 APPSPERF:PA:PJC: PA_TRX_IMPORT : PERF. REPOSITORY EXCEPTIONS
10763: l_ExpItemId_temp_Tab.DELETE ;
10764:
10765: select ei.expenditure_item_id
10766: bulk collect into l_ExpItemId_temp_Tab

Line 10860: -- BUG : 4885459 APPSPERF:PA:PJC: PA_TRX_IMPORT : PERF. REPOSITORY EXCEPTIONS

10856: END IF;
10857:
10858: IF (pa_funds_control_utils.get_bdgt_link(l_Project_Id, 'STD') = 'Y') THEN
10859:
10860: -- BUG : 4885459 APPSPERF:PA:PJC: PA_TRX_IMPORT : PERF. REPOSITORY EXCEPTIONS
10861:
10862: l_ExpItemId_temp_Tab.DELETE ;
10863:
10864: select ei.expenditure_item_id

Line 15640: END PA_TRX_IMPORT;

15636: Return G_Validate_Proj_Tsk_Ei_Date;
15637: END;
15638:
15639:
15640: END PA_TRX_IMPORT;