DBA Data[Home] [Help]

APPS.PA_TRX_IMPORT dependencies on PA_UTILS4

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

5088: -- Assignment_Id and Work_Type_Id derivation/validation checks
5089:
5090: -- PA-J Txn Ctrl Changes
5091: -- Assignment Id will now be derived for Expense Reports (system_linkage of ER)
5092: -- The derivation of assignment id for ER is done in pa_utils4.
5093:
5094: -- PA-K Changes: For pre-defined sources the values in assignment_name and
5095: -- work_type_name will be ignored. If ids are given they will used else it will be derived.
5096: -- For user defined sources ids will be ignored and the names if given will be validated

Line 5133: G_Assignment_Id := pa_utils4.get_assignment_id(

5129: pa_debug.G_err_stage := 'P_Assignment_id is null';
5130: log_message('log_message: ' || pa_debug.G_err_Stage);
5131: END IF;
5132:
5133: G_Assignment_Id := pa_utils4.get_assignment_id(
5134: p_person_id => G_Person_Id
5135: ,p_project_id => G_Project_Id
5136: ,p_task_id => G_Task_Id
5137: ,p_ei_date => X_Ei_Date);

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

5154:
5155: End If;
5156:
5157: /*Bug# 2737538:Added check of profile option value for deriving work type */
5158: /* If (nvl(pa_utils4.is_exp_work_type_enabled,'N') = 'Y') Then ** moved condition below bug 3104004 */
5159:
5160: log_message('log_message: p work type id: ' || p_work_type_id);
5161:
5162: If (P_Work_Type_Id is not null) Then

Line 5183: G_Work_Type_Id := pa_utils4.get_work_type_id(

5179: pa_debug.G_err_stage := 'P_Work_Type_Id is null';
5180: log_message('log_message: ' || pa_debug.G_err_Stage);
5181: END IF;
5182:
5183: G_Work_Type_Id := pa_utils4.get_work_type_id(
5184: p_project_id => G_Project_Id
5185: ,p_task_id => G_Task_Id
5186: ,p_assignment_id => nvl(G_Assignment_Id,0));
5187:

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

5189: pa_debug.G_err_stage := 'G_Work_Type_Id = ' || G_Work_Type_Id;
5190: log_message('log_message: ' || pa_debug.G_err_Stage);
5191: END IF;
5192:
5193: If (G_Work_Type_Id is NULL and nvl(pa_utils4.is_exp_work_type_enabled,'N') = 'Y') Then
5194: /*** added and condition bug 3104004 */
5195: X_Status := 'INVALID_WORK_TYPE';
5196: pa_cc_utils.reset_curr_function;
5197: Return;

Line 5207: G_Tp_Amt_Type_Code := pa_utils4.get_tp_amt_type_code(

5203: pa_debug.G_err_stage := 'Get Tp Amt Type';
5204: log_message('log_message: ' || pa_debug.G_err_Stage);
5205: END IF;
5206:
5207: G_Tp_Amt_Type_Code := pa_utils4.get_tp_amt_type_code(
5208: p_work_type_id => G_Work_Type_Id);
5209:
5210: IF PG_DEBUG = 'Y' THEN
5211: pa_debug.G_err_stage := 'G_Tp_Amt_Type_Code = ' || G_Tp_Amt_Type_Code;

Line 5225: pa_utils4.get_work_assignment(

5221: log_message('log_message: ' || pa_debug.G_err_Stage);
5222: log_message('log_message: ' || 'Assignment Name = ' || X_Assignment_Name || ' Work Type Name = ' || X_Work_Type_Name);
5223: END IF;
5224:
5225: pa_utils4.get_work_assignment(
5226: p_person_id => G_Person_Id
5227: , p_project_id => G_Project_Id
5228: , p_task_id => G_Task_Id
5229: , p_ei_date => X_Ei_Date

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

9324: --two profiles and if it is Y then use the billable_flag from
9325: --validate_transaction and if N then override with what user entered.
9326:
9327: IF PG_DEBUG = 'Y' THEN
9328: pa_debug.G_err_stage := 'Calling pa_utils4.get_transaction_billability';
9329: log_message('log_message: ' || pa_debug.G_err_stage);
9330: log_message('log_message: ' || 'Billable Flag before get_trxn_work_billabilty = ' || X_billable_flag);
9331: log_message('log_message: ' || 'Work Type Id = ' || G_work_type_id);
9332: END IF;

Line 9334: X_billable_flag := pa_utils4.get_trxn_work_billabilty(

9330: log_message('log_message: ' || 'Billable Flag before get_trxn_work_billabilty = ' || X_billable_flag);
9331: log_message('log_message: ' || 'Work Type Id = ' || G_work_type_id);
9332: END IF;
9333:
9334: X_billable_flag := pa_utils4.get_trxn_work_billabilty(
9335: p_work_type_id => G_work_type_id,
9336: p_tc_extn_bill_flag => X_billable_flag);
9337:
9338: IF PG_DEBUG = 'Y' THEN

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

9478: ,X_raw_cost_rate => l_rawCostRateTab(j)
9479: -- Trx_import enhancement
9480: ,X_override_to_org_id => G_override_to_org_id -- Changed from NULL
9481: /* Added for bug 3220230 for getting billability of items reversed in OIT */
9482: ,X_billable_flag => pa_utils4.GetOrig_EiBillability_SST(l_temp_adjItemID,X_billable_flag,X_transaction_source)
9483: /* Added for bug 4057474 for getting bill_hold_flag of items reversed in external txn sources like OTL. */
9484: ,X_bill_hold_flag => pa_utils4.GetOrig_EiBill_hold(l_temp_adjItemID,'N')
9485: ,X_orig_transaction_ref => l_OrigTxnRefTab(j)
9486: ,X_transferred_from_ei => NULL

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

9480: ,X_override_to_org_id => G_override_to_org_id -- Changed from NULL
9481: /* Added for bug 3220230 for getting billability of items reversed in OIT */
9482: ,X_billable_flag => pa_utils4.GetOrig_EiBillability_SST(l_temp_adjItemID,X_billable_flag,X_transaction_source)
9483: /* Added for bug 4057474 for getting bill_hold_flag of items reversed in external txn sources like OTL. */
9484: ,X_bill_hold_flag => pa_utils4.GetOrig_EiBill_hold(l_temp_adjItemID,'N')
9485: ,X_orig_transaction_ref => l_OrigTxnRefTab(j)
9486: ,X_transferred_from_ei => NULL
9487: ,X_adj_expend_item_id => G_adj_item_id
9488: ,X_attribute_category => l_AttCatTab(j)

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

12137:
12138: G_Assignment_Id := P_Assignment_Id;
12139: G_Work_Type_Id := P_Work_Type_Id;
12140:
12141: G_Tp_Amt_Type_Code := pa_utils4.get_tp_amt_type_code(p_work_type_id => p_work_type_id);
12142:
12143: END IF;
12144:
12145: IF PG_DEBUG = 'Y' THEN

Line 12332: pa_utils4.get_work_assignment(

12328:
12329: /*S.N. 5297060*/
12330: If ( X_match_flag <> 'N' ) THEN
12331:
12332: pa_utils4.get_work_assignment(
12333: p_person_id => G_Person_Id
12334: , p_project_id => G_Project_Id
12335: , p_task_id => G_Task_Id
12336: , p_ei_date => X_Ei_Date