DBA Data[Home] [Help]

APPS.PA_TRX_IMPORT dependencies on PA_UTILS4

Line 4658: -- The derivation of assignment id for ER is done in pa_utils4.

4654: -- Assignment_Id and Work_Type_Id derivation/validation checks
4655:
4656: -- PA-J Txn Ctrl Changes
4657: -- Assignment Id will now be derived for Expense Reports (system_linkage of ER)
4658: -- The derivation of assignment id for ER is done in pa_utils4.
4659:
4660: -- PA-K Changes: For pre-defined sources the values in assignment_name and
4661: -- work_type_name will be ignored. If ids are given they will used else it will be derived.
4662: -- For user defined sources ids will be ignored and the names if given will be validated

Line 4699: G_Assignment_Id := pa_utils4.get_assignment_id(

4695: pa_debug.G_err_stage := 'P_Assignment_id is null';
4696: log_message('log_message: ' || pa_debug.G_err_Stage);
4697: END IF;
4698:
4699: G_Assignment_Id := pa_utils4.get_assignment_id(
4700: p_person_id => G_Person_Id
4701: ,p_project_id => G_Project_Id
4702: ,p_task_id => G_Task_Id
4703: ,p_ei_date => X_Ei_Date);

Line 4724: /* If (nvl(pa_utils4.is_exp_work_type_enabled,'N') = 'Y') Then ** moved condition below bug 3104004 */

4720:
4721: End If;
4722:
4723: /*Bug# 2737538:Added check of profile option value for deriving work type */
4724: /* If (nvl(pa_utils4.is_exp_work_type_enabled,'N') = 'Y') Then ** moved condition below bug 3104004 */
4725:
4726: If (P_Work_Type_Id is not null) Then
4727:
4728: IF PG_DEBUG = 'Y' THEN

Line 4747: G_Work_Type_Id := pa_utils4.get_work_type_id(

4743: pa_debug.G_err_stage := 'P_Work_Type_Id is null';
4744: log_message('log_message: ' || pa_debug.G_err_Stage);
4745: END IF;
4746:
4747: G_Work_Type_Id := pa_utils4.get_work_type_id(
4748: p_project_id => G_Project_Id
4749: ,p_task_id => G_Task_Id
4750: ,p_assignment_id => nvl(G_Assignment_Id,0));
4751:

Line 4757: If (G_Work_Type_Id is NULL and nvl(pa_utils4.is_exp_work_type_enabled,'N') = 'Y') Then

4753: pa_debug.G_err_stage := 'G_Work_Type_Id = ' || G_Work_Type_Id;
4754: log_message('log_message: ' || pa_debug.G_err_Stage);
4755: END IF;
4756:
4757: If (G_Work_Type_Id is NULL and nvl(pa_utils4.is_exp_work_type_enabled,'N') = 'Y') Then
4758: /*** added and condition bug 3104004 */
4759: X_Status := 'INVALID_WORK_TYPE';
4760: pa_cc_utils.reset_curr_function;
4761: Return;

Line 4771: G_Tp_Amt_Type_Code := pa_utils4.get_tp_amt_type_code(

4767: pa_debug.G_err_stage := 'Get Tp Amt Type';
4768: log_message('log_message: ' || pa_debug.G_err_Stage);
4769: END IF;
4770:
4771: G_Tp_Amt_Type_Code := pa_utils4.get_tp_amt_type_code(
4772: p_work_type_id => G_Work_Type_Id);
4773:
4774: IF PG_DEBUG = 'Y' THEN
4775: pa_debug.G_err_stage := 'G_Tp_Amt_Type_Code = ' || G_Tp_Amt_Type_Code;

Line 4789: pa_utils4.get_work_assignment(

4785: log_message('log_message: ' || pa_debug.G_err_Stage);
4786: log_message('log_message: ' || 'Assignment Name = ' || X_Assignment_Name || ' Work Type Name = ' || X_Work_Type_Name);
4787: END IF;
4788:
4789: pa_utils4.get_work_assignment(
4790: p_person_id => G_Person_Id
4791: , p_project_id => G_Project_Id
4792: , p_task_id => G_Task_Id
4793: , p_ei_date => X_Ei_Date

Line 8577: pa_debug.G_err_stage := 'Calling pa_utils4.get_transaction_billability';

8573: --two profiles and if it is Y then use the billable_flag from
8574: --validate_transaction and if N then override with what user entered.
8575:
8576: IF PG_DEBUG = 'Y' THEN
8577: pa_debug.G_err_stage := 'Calling pa_utils4.get_transaction_billability';
8578: log_message('log_message: ' || pa_debug.G_err_stage);
8579: log_message('log_message: ' || 'Billable Flag before get_trxn_work_billabilty = ' || X_billable_flag);
8580: log_message('log_message: ' || 'Work Type Id = ' || G_work_type_id);
8581: END IF;

Line 8583: X_billable_flag := pa_utils4.get_trxn_work_billabilty(

8579: log_message('log_message: ' || 'Billable Flag before get_trxn_work_billabilty = ' || X_billable_flag);
8580: log_message('log_message: ' || 'Work Type Id = ' || G_work_type_id);
8581: END IF;
8582:
8583: X_billable_flag := pa_utils4.get_trxn_work_billabilty(
8584: p_work_type_id => G_work_type_id,
8585: p_tc_extn_bill_flag => X_billable_flag);
8586:
8587: IF PG_DEBUG = 'Y' THEN

Line 8702: ,X_billable_flag => pa_utils4.GetOrig_EiBillability_SST(l_temp_adjItemID,X_billable_flag,X_transaction_source)

8698: ,X_raw_cost_rate => l_rawCostRateTab(j)
8699: -- Trx_import enhancement
8700: ,X_override_to_org_id => G_override_to_org_id -- Changed from NULL
8701: /* Added for bug 3220230 for getting billability of items reversed in OIT */
8702: ,X_billable_flag => pa_utils4.GetOrig_EiBillability_SST(l_temp_adjItemID,X_billable_flag,X_transaction_source)
8703: /* Added for bug 4057474 for getting bill_hold_flag of items reversed in external txn sources like OTL. */
8704: ,X_bill_hold_flag => pa_utils4.GetOrig_EiBill_hold(l_temp_adjItemID,'N')
8705: ,X_orig_transaction_ref => l_OrigTxnRefTab(j)
8706: ,X_transferred_from_ei => NULL

Line 8704: ,X_bill_hold_flag => pa_utils4.GetOrig_EiBill_hold(l_temp_adjItemID,'N')

8700: ,X_override_to_org_id => G_override_to_org_id -- Changed from NULL
8701: /* Added for bug 3220230 for getting billability of items reversed in OIT */
8702: ,X_billable_flag => pa_utils4.GetOrig_EiBillability_SST(l_temp_adjItemID,X_billable_flag,X_transaction_source)
8703: /* Added for bug 4057474 for getting bill_hold_flag of items reversed in external txn sources like OTL. */
8704: ,X_bill_hold_flag => pa_utils4.GetOrig_EiBill_hold(l_temp_adjItemID,'N')
8705: ,X_orig_transaction_ref => l_OrigTxnRefTab(j)
8706: ,X_transferred_from_ei => NULL
8707: ,X_adj_expend_item_id => G_adj_item_id
8708: ,X_attribute_category => l_AttCatTab(j)

Line 11258: G_Tp_Amt_Type_Code := pa_utils4.get_tp_amt_type_code(p_work_type_id => p_work_type_id);

11254:
11255: G_Assignment_Id := P_Assignment_Id;
11256: G_Work_Type_Id := P_Work_Type_Id;
11257:
11258: G_Tp_Amt_Type_Code := pa_utils4.get_tp_amt_type_code(p_work_type_id => p_work_type_id);
11259:
11260: END IF;
11261:
11262: IF PG_DEBUG = 'Y' THEN

Line 11447: pa_utils4.get_work_assignment(

11443:
11444: /*S.N. 5297060*/
11445: If ( X_match_flag <> 'N' ) THEN
11446:
11447: pa_utils4.get_work_assignment(
11448: p_person_id => G_Person_Id
11449: , p_project_id => G_Project_Id
11450: , p_task_id => G_Task_Id
11451: , p_ei_date => X_Ei_Date