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.78.12010000.9 2008/12/01 02:15:24 prabsing ship $ */
3:
4: last_empno VARCHAR2(30) DEFAULT NULL;
5: last_proj VARCHAR2(25) DEFAULT NULL;

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

717: /* PA-I Changes
718: For un-accounted transactions we need not call DefaultCurrAttributes.
719: This is because the checks that are being performed here will be anyway
720: performed during costing in pa_multi_currency_txn. To avoid redundant code
721: we are not performing these checks in PA_TRX_IMPORT.
722: Please see prior versions for the changed DefaultCurrAttributes if needed.
723: */
724:
725: PROCEDURE GetVendorId(P_vendor_number IN VARCHAR2)

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

2237: END IF; --Predefined source check for person and organization id
2238:
2239: -- PA-K Changes: Moved CheckExporg to below one place
2240: IF G_org_id is not NULL THEN
2241: IF pa_trx_import.g_skip_tc_flag <> 'Y' and PA_TRX_IMPORT.Get_GVal_ProjTskEi_Date = 'Y' then /* Added for Bug # 2170237 */
2242: -- Modified the above condition for BUG6931833
2243: IF PG_DEBUG = 'Y' THEN
2244: pa_debug.G_err_stage := 'Calling pa_utils2.CheckExporg';
2245: log_message('log_message: ' || pa_debug.G_err_Stage);

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

2290: IF (G_override_to_org_id IS NULL) THEN
2291: X_status := 'PA_OVERRIDE_ORG_INVALID';
2292: pa_cc_utils.reset_curr_function;
2293: RETURN;
2294: ELSIF pa_trx_import.g_skip_tc_flag <> 'Y' and PA_TRX_IMPORT.Get_GVal_ProjTskEi_Date = 'Y' THEN /* Added for Bug # 2170237 */
2295: --Modified above condition for bug6931833
2296: IF pa_utils2.CheckExporg(G_override_to_org_id, X_ei_date) = 'N' THEN
2297: X_status := 'PA_OVERRIDE_ORG_NOT_ACTIVE';
2298: pa_cc_utils.reset_curr_function;

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

2624: -- ===========================================================================
2625: -- Check if the cross charging is allowed for this project
2626:
2627: --Bug 2726763: Add skip_tc_flag check for checking if project is chargeable.
2628: If pa_trx_import.g_skip_tc_flag <> 'Y' and PA_TRX_IMPORT.Get_GVal_ProjTskEi_Date = 'Y' then
2629: --Modified above condition for BUG6931833
2630:
2631: IF PG_DEBUG = 'Y' THEN
2632: pa_debug.G_err_stage := 'Calling pa_utils.IsCrossChargeable';

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

3140: /* PA-I Changes
3141: For un-accounted transactions we need not call DefaultCurrAttributes.
3142: This is because the checks that are being performed here will be anyway
3143: performed during costing in pa_multi_currency_txn. To avoid redundant code
3144: we are not performing these checks in PA_TRX_IMPORT.
3145: */
3146:
3147: /*-----------------------------------------------------------------------------
3148: -- END MULTI CURRENCY VALIDATION FOR COSTED/UNCOSTED UNACCOUNTED TXNS

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

4973: and exp.person_type = 'CWK';
4974: */
4975:
4976: /* Bug 4098920
4977: Select Sum ( Quantity * PA_TRX_IMPORT.GET_PO_PRICE_TYPE_RATE (Project_id , Task_Id , P_Po_Line_Id , po_price_type ) )
4978: into l_uncosted
4979: From
4980: (
4981: select ei.project_id , ei.task_id , ei.po_price_type , sum(quantity) Quantity

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

4995: /* Bug 4098920 : Combined the SQLs for Costed and Uncosted EI */
4996: If Is_Po_Line_Task_Processed ( P_Po_Line_Id, G_task_id ) = False Then
4997: Select Sum (
4998: Decode ( cost_distributed_flag,
4999: 'N', Quantity * PA_TRX_IMPORT.GET_PO_PRICE_TYPE_RATE (G_project_id , G_task_id , P_Po_Line_Id , po_price_type ), 0
5000:
5001: )
5002: ) ,
5003: Sum (

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

5140: pa_debug.G_err_stage := 'Calling pa_transactions_pub.validate_transaction';
5141: log_message('log_message: ' || pa_debug.G_err_Stage);
5142: END IF;
5143:
5144: If PA_TRX_IMPORT.Get_GVal_ProjTskEi_Date = 'Y' then -- Added for BUG6931833
5145:
5146: pa_transactions_pub.validate_transaction(
5147: X_project_id => G_project_id
5148: , X_task_id => G_task_id

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

9174: pa_debug.G_err_Stage := 'Calling pre_import extension';
9175: log_message('log_message: ' || pa_debug.G_err_Stage);
9176: END IF;
9177:
9178: pa_trx_import.pre_import(P_transaction_source => X_transaction_source,
9179: P_batch => X_batch,
9180: P_xface_id => X_xface_id,
9181: P_user_id => X_userid);
9182:

Line 9199: pa_trx_import.import1(X_transaction_source

9195: END pre_import;
9196:
9197: <>
9198: BEGIN
9199: pa_trx_import.import1(X_transaction_source
9200: , X_batch
9201: , X_xface_id
9202: , X_userid
9203: , X_online_exp_comment);

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

9308: pa_debug.G_err_Stage := 'Calling post_import extension';
9309: log_message('log_message: ' || pa_debug.G_err_Stage);
9310: END IF;
9311:
9312: pa_trx_import.post_import(P_transaction_source => X_transaction_source,
9313: P_batch => X_batch,
9314: P_xface_id => X_xface_id,
9315: P_user_id => X_userid);
9316:

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

9367: pa_debug.set_process(x_process => 'PLSQL',
9368: x_debug_mode => G_debug_mode);
9369:
9370: pa_cc_utils.log_message('Debug Mode = '||G_debug_mode,1);
9371: pa_cc_utils.set_curr_function('pa_trx_import.init');
9372:
9373: IF PG_DEBUG = 'Y' THEN
9374: pa_debug.G_err_Stage := 'retriving transaction source';
9375: log_message('log_message: ' || pa_debug.G_err_Stage);

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

9453: P_xface_id IN NUMBER,
9454: P_user_id IN NUMBER) IS
9455: BEGIN
9456:
9457: pa_trx_import.execute_import_extensions( P_program_name => G_pre_processing_extn,
9458: P_transaction_source => P_transaction_source,
9459: P_batch => P_batch,
9460: P_xface_id => P_xface_id,
9461: P_user_id => P_user_id);

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

9469: P_xface_id IN NUMBER,
9470: P_user_id IN NUMBER) IS
9471: BEGIN
9472:
9473: pa_trx_import.execute_import_extensions( P_program_name => G_post_processing_extn,
9474: P_transaction_source => P_transaction_source,
9475: P_batch => P_batch,
9476: P_xface_id => P_xface_id,
9477: P_user_id => P_user_id);

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

9844: END IF;
9845:
9846: IF (pa_funds_control_utils.get_bdgt_link(l_Project_Id, 'STD') = 'Y') THEN
9847:
9848: -- BUG : 4885459 : APPSPERF:PA:PJC: PA_TRX_IMPORT : PERF. REPOSITORY EXCEPTIONS
9849:
9850: l_ExpItemId_temp_Tab.DELETE ;
9851:
9852: select ei.expenditure_item_id

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

9940: END IF;
9941:
9942: IF (pa_funds_control_utils.get_bdgt_link(l_Project_Id, 'STD') = 'Y') THEN
9943:
9944: -- BUG : 4885459 APPSPERF:PA:PJC: PA_TRX_IMPORT : PERF. REPOSITORY EXCEPTIONS
9945: l_ExpItemId_temp_Tab.DELETE ;
9946:
9947: select ei.expenditure_item_id
9948: bulk collect into l_ExpItemId_temp_Tab

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

10038: END IF;
10039:
10040: IF (pa_funds_control_utils.get_bdgt_link(l_Project_Id, 'STD') = 'Y') THEN
10041:
10042: -- BUG : 4885459 APPSPERF:PA:PJC: PA_TRX_IMPORT : PERF. REPOSITORY EXCEPTIONS
10043:
10044: l_ExpItemId_temp_Tab.DELETE ;
10045:
10046: select ei.expenditure_item_id

Line 14652: END PA_TRX_IMPORT;

14648: BEGIN
14649: Return G_Validate_Proj_Tsk_Ei_Date;
14650: END;
14651:
14652: END PA_TRX_IMPORT;