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_ADJUSTMENTS dependencies on PA_UTILS

Line 473: X_backout_id := pa_utils.GetNextEiId;

469: item_comment VARCHAR2(240);
470:
471: BEGIN
472:
473: X_backout_id := pa_utils.GetNextEiId;
474:
475: INSERT INTO pa_expenditure_items_all(
476: expenditure_item_id
477: , task_id

Line 1058: PROCEDURE RecalcRev( ItemsIdTab IN pa_utils.IdTabTyp

1054: -- ========================================================================
1055: -- PROCEDURE RecalcRev
1056: -- ========================================================================
1057:
1058: PROCEDURE RecalcRev( ItemsIdTab IN pa_utils.IdTabTyp
1059: , AdjustsIdTab IN pa_utils.IdTabTyp
1060: , X_user IN NUMBER
1061: , X_login IN NUMBER
1062: , X_module IN VARCHAR2

Line 1059: , AdjustsIdTab IN pa_utils.IdTabTyp

1055: -- PROCEDURE RecalcRev
1056: -- ========================================================================
1057:
1058: PROCEDURE RecalcRev( ItemsIdTab IN pa_utils.IdTabTyp
1059: , AdjustsIdTab IN pa_utils.IdTabTyp
1060: , X_user IN NUMBER
1061: , X_login IN NUMBER
1062: , X_module IN VARCHAR2
1063: , rows IN NUMBER

Line 1145: PROCEDURE RecalcCostRev( ItemsIdTab IN pa_utils.IdTabTyp

1141: -- ========================================================================
1142: -- PROCEDURE RecalcCostRev
1143: -- ========================================================================
1144:
1145: PROCEDURE RecalcCostRev( ItemsIdTab IN pa_utils.IdTabTyp
1146: , AdjustsIdTab IN pa_utils.IdTabTyp
1147: , X_user IN NUMBER
1148: , X_login IN NUMBER
1149: , X_module IN VARCHAR2

Line 1146: , AdjustsIdTab IN pa_utils.IdTabTyp

1142: -- PROCEDURE RecalcCostRev
1143: -- ========================================================================
1144:
1145: PROCEDURE RecalcCostRev( ItemsIdTab IN pa_utils.IdTabTyp
1146: , AdjustsIdTab IN pa_utils.IdTabTyp
1147: , X_user IN NUMBER
1148: , X_login IN NUMBER
1149: , X_module IN VARCHAR2
1150: , rows IN NUMBER

Line 1391: PROCEDURE RecalcIndCost( ItemsIdTab IN pa_utils.IdTabTyp

1387: -- ========================================================================
1388: -- PROCEDURE RecalcIndCost
1389: -- ========================================================================
1390:
1391: PROCEDURE RecalcIndCost( ItemsIdTab IN pa_utils.IdTabTyp
1392: , AdjustsIdTab IN pa_utils.IdTabTyp
1393: , X_user IN NUMBER
1394: , X_login IN NUMBER
1395: , X_module IN VARCHAR2

Line 1392: , AdjustsIdTab IN pa_utils.IdTabTyp

1388: -- PROCEDURE RecalcIndCost
1389: -- ========================================================================
1390:
1391: PROCEDURE RecalcIndCost( ItemsIdTab IN pa_utils.IdTabTyp
1392: , AdjustsIdTab IN pa_utils.IdTabTyp
1393: , X_user IN NUMBER
1394: , X_login IN NUMBER
1395: , X_module IN VARCHAR2
1396: , rows IN BINARY_INTEGER

Line 1517: PROCEDURE RecalcRawCost( ItemsIdTab IN pa_utils.IdTabTyp

1513: -- inserts the action 'RAW COST RECALC' into the adjustment activity
1514: -- table, instead of 'COST AND REV RECALC'. Used for indirect and
1515: -- capital (v4.0) projects, where the latter action would not make sense.
1516:
1517: PROCEDURE RecalcRawCost( ItemsIdTab IN pa_utils.IdTabTyp
1518: , AdjustsIdTab IN pa_utils.IdTabTyp
1519: , X_user IN NUMBER
1520: , X_login IN NUMBER
1521: , X_module IN VARCHAR2

Line 1518: , AdjustsIdTab IN pa_utils.IdTabTyp

1514: -- table, instead of 'COST AND REV RECALC'. Used for indirect and
1515: -- capital (v4.0) projects, where the latter action would not make sense.
1516:
1517: PROCEDURE RecalcRawCost( ItemsIdTab IN pa_utils.IdTabTyp
1518: , AdjustsIdTab IN pa_utils.IdTabTyp
1519: , X_user IN NUMBER
1520: , X_login IN NUMBER
1521: , X_module IN VARCHAR2
1522: , rows IN NUMBER

Line 1769: PROCEDURE RecalcCapCost( ItemsIdTab IN pa_utils.IdTabTyp

1765: -- This is the exact same as RecalcIndCost, except it also sets the
1766: -- revenue_distributed_flag to 'N'. Used for expenditure items
1767: -- belonging to CAPITAL projects (v4.0).
1768:
1769: PROCEDURE RecalcCapCost( ItemsIdTab IN pa_utils.IdTabTyp
1770: , AdjustsIdTab IN pa_utils.IdTabTyp
1771: , X_user IN NUMBER
1772: , X_login IN NUMBER
1773: , X_module IN VARCHAR2

Line 1770: , AdjustsIdTab IN pa_utils.IdTabTyp

1766: -- revenue_distributed_flag to 'N'. Used for expenditure items
1767: -- belonging to CAPITAL projects (v4.0).
1768:
1769: PROCEDURE RecalcCapCost( ItemsIdTab IN pa_utils.IdTabTyp
1770: , AdjustsIdTab IN pa_utils.IdTabTyp
1771: , X_user IN NUMBER
1772: , X_login IN NUMBER
1773: , X_module IN VARCHAR2
1774: , rows IN BINARY_INTEGER

Line 1994: PROCEDURE Hold( ItemsIdTab IN pa_utils.IdTabTyp

1990: -- ========================================================================
1991: -- PROCEDURE Hold
1992: -- ========================================================================
1993:
1994: PROCEDURE Hold( ItemsIdTab IN pa_utils.IdTabTyp
1995: , AdjustsIdTab IN pa_utils.IdTabTyp
1996: , X_hold IN VARCHAR2
1997: , X_adj_activity IN VARCHAR2
1998: , X_user IN NUMBER

Line 1995: , AdjustsIdTab IN pa_utils.IdTabTyp

1991: -- PROCEDURE Hold
1992: -- ========================================================================
1993:
1994: PROCEDURE Hold( ItemsIdTab IN pa_utils.IdTabTyp
1995: , AdjustsIdTab IN pa_utils.IdTabTyp
1996: , X_hold IN VARCHAR2
1997: , X_adj_activity IN VARCHAR2
1998: , X_user IN NUMBER
1999: , X_login IN NUMBER

Line 2090: ( ItemsIdTab IN pa_utils.IdTabTyp

2086: * To change the billability of the transaction user has to run the
2087: * Reclass Billable / Non Billable adjustments seperately
2088: **/
2089: PROCEDURE work_type_adjustment
2090: ( ItemsIdTab IN pa_utils.IdTabTyp
2091: --, AdjustsIdTab IN pa_utils.IdTabTyp
2092: , p_billable IN VARCHAR2
2093: , p_work_type_id IN NUMBER
2094: , p_adj_activity IN VARCHAR2

Line 2091: --, AdjustsIdTab IN pa_utils.IdTabTyp

2087: * Reclass Billable / Non Billable adjustments seperately
2088: **/
2089: PROCEDURE work_type_adjustment
2090: ( ItemsIdTab IN pa_utils.IdTabTyp
2091: --, AdjustsIdTab IN pa_utils.IdTabTyp
2092: , p_billable IN VARCHAR2
2093: , p_work_type_id IN NUMBER
2094: , p_adj_activity IN VARCHAR2
2095: , p_user IN NUMBER

Line 2099: , p_TpAmtTypCodeTab IN pa_utils.Char30TabTyp

2095: , p_user IN NUMBER
2096: , p_login IN NUMBER
2097: , p_module IN VARCHAR2
2098: , p_rows IN BINARY_INTEGER
2099: , p_TpAmtTypCodeTab IN pa_utils.Char30TabTyp
2100: , p_dest_tp_amt_type_code IN VARCHAR2
2101: , x_status OUT NOCOPY NUMBER )
2102: IS
2103: l_temp_status NUMBER DEFAULT NULL;

Line 2353: l_profile_option := pa_utils4.IS_WORKTYPE_BILLABLE_ENABLED ;

2349: print_message ('get_denom_curr_code: ' || 'after select l_old_work_type_id ['||l_old_work_type_id||
2350: ']l_gl_accounted_flag['||l_gl_accounted_flag||']l_old_billability['||l_old_billability||']' );
2351: END IF;
2352:
2353: l_profile_option := pa_utils4.IS_WORKTYPE_BILLABLE_ENABLED ;
2354:
2355: If l_profile_option = 'Y' and l_proj_type_class_code in ('CAPITAL','CONTRACT') then
2356:
2357:

Line 2358: l_new_billability := PA_UTILS4.get_trxn_work_billabilty

2354:
2355: If l_profile_option = 'Y' and l_proj_type_class_code in ('CAPITAL','CONTRACT') then
2356:
2357:
2358: l_new_billability := PA_UTILS4.get_trxn_work_billabilty
2359: (p_work_type_id => p_work_type_id
2360: ,p_tc_extn_bill_flag => NULL );
2361:
2362: /*** Commented out this portion due to following issue

Line 2367: l_old_billability := PA_UTILS4.get_trxn_work_billabilty

2363: ** Initially set the work type profile to 'N' and transaction is entered with billability = 'Y'
2364: ** Now set the work type profile to 'Y', As the old and new worktype results no change in billability
2365: ** then EI will never be updated with the billablity change . in order to fix this
2366: ** donot derive old billabity based on worktype
2367: l_old_billability := PA_UTILS4.get_trxn_work_billabilty
2368: (p_work_type_id => l_old_work_type_id
2369: ,p_tc_extn_bill_flag => NULL );
2370: **/
2371:

Line 2385: --l_profile_option := pa_utils4.IS_WORKTYPE_BILLABLE_ENABLED ;

2381: l_change_in_billable := 'N';
2382:
2383: End if;
2384:
2385: --l_profile_option := pa_utils4.IS_WORKTYPE_BILLABLE_ENABLED ;
2386:
2387: IF P_DEBUG_MODE THEN
2388: print_message('get_denom_curr_code: ' || 'l_old_billability['||l_old_billability||
2389: ']l_new_billability['||l_new_billability||

Line 2485: ,ei.tp_amt_type_code = PA_UTILS4.get_tp_amt_type_code

2481: ,ei.billable_flag = decode(l_change_in_billable,'Y',l_new_billability,ei.billable_flag)
2482: ,ei.last_updated_by = p_user
2483: ,ei.last_update_date = sysdate
2484: ,ei.last_update_login = p_login
2485: ,ei.tp_amt_type_code = PA_UTILS4.get_tp_amt_type_code
2486: (p_work_type_id)
2487: ,cc_bl_distributed_code = DECODE(p_dest_tp_amt_type_code, p_TpAmtTypCodeTab(i),
2488: cc_bl_distributed_code,
2489: decode(cc_bl_distributed_code,'X','X','N'))

Line 2542: PROCEDURE Reclass( ItemsIdTab IN pa_utils.IdTabTyp

2538: -- ========================================================================
2539: -- PROCEDURE Reclass
2540: -- ========================================================================
2541:
2542: PROCEDURE Reclass( ItemsIdTab IN pa_utils.IdTabTyp
2543: , AdjustsIdTab IN pa_utils.IdTabTyp
2544: , X_billable IN VARCHAR2
2545: , X_adj_activity IN VARCHAR2
2546: , X_user IN NUMBER

Line 2543: , AdjustsIdTab IN pa_utils.IdTabTyp

2539: -- PROCEDURE Reclass
2540: -- ========================================================================
2541:
2542: PROCEDURE Reclass( ItemsIdTab IN pa_utils.IdTabTyp
2543: , AdjustsIdTab IN pa_utils.IdTabTyp
2544: , X_billable IN VARCHAR2
2545: , X_adj_activity IN VARCHAR2
2546: , X_user IN NUMBER
2547: , X_login IN NUMBER

Line 3131: new_item_id := pa_utils.GetNextEiId;

3127: item_project_burdened_cost := p_item2_project_burden_cost;
3128:
3129: END IF;
3130:
3131: new_item_id := pa_utils.GetNextEiId;
3132:
3133: IF P_DEBUG_MODE THEN
3134: print_message('get_denom_curr_code: ' || 'calling insert into EI');
3135: END IF;

Line 3417: PROCEDURE Transfer ( ItemsIdTab IN pa_utils.IdTabTyp

3413: -- ========================================================================
3414: -- PROCEDURE Transfer
3415: -- ========================================================================
3416:
3417: PROCEDURE Transfer ( ItemsIdTab IN pa_utils.IdTabTyp
3418: , X_dest_prj_id IN NUMBER
3419: , X_dest_task_id IN NUMBER
3420: , X_project_currency_code IN VARCHAR2
3421: , X_project_rate_type IN VARCHAR2

Line 3676: l_dest_lcm := pa_utils2.GetLaborCostMultiplier(X_dest_task_id);

3672:
3673: IF P_DEBUG_MODE THEN
3674: print_message('get_denom_curr_code: ' || 'inside Transfer api');
3675: END IF;
3676: l_dest_lcm := pa_utils2.GetLaborCostMultiplier(X_dest_task_id);
3677: FOR i IN 1..rows LOOP
3678:
3679: FOR EiRec IN Items( ItemsIdTab(i) ) LOOP
3680:

Line 3716: Pa_Utils4.Get_Work_Assignment (

3712: IF P_DEBUG_MODE THEN
3713: print_message('get_denom_curr_code: ' || 'calling get work type assignment api');
3714: END IF;
3715: /** derive work type and assignment for the destination task , project **/
3716: Pa_Utils4.Get_Work_Assignment (
3717: p_person_id => EiRec.inc_by_person_id
3718: ,p_project_id => X_dest_prj_id
3719: ,p_task_id => X_dest_task_id
3720: ,p_ei_date => EiRec.expenditure_item_date

Line 3823: EiRec.expenditure_item_id := pa_utils.GetNextEiId;

3819: END IF;
3820:
3821: ELSE
3822:
3823: EiRec.expenditure_item_id := pa_utils.GetNextEiId;
3824: pa_transactions_pub.validate_transaction(
3825: X_project_id => X_dest_prj_id
3826: , X_task_id => X_dest_task_id
3827: , X_ei_date => EiRec.expenditure_item_date

Line 4146: ItemsIdTab pa_utils.IdTabTyp;

4142: , p_dest_tp_amt_type_code IN varchar2
4143: /** end of proj currency and additional EI attributes **/
4144: ) IS
4145:
4146: ItemsIdTab pa_utils.IdTabTyp;
4147: AdjustsIdTab pa_utils.IdTabTyp;
4148: DenomCurrCodeTab pa_utils.Char15TabTyp;
4149: ProjCurrCodeTab pa_utils.Char15TabTyp;
4150: ProjFuncCurrCodeTab pa_utils.Char15TabTyp;

Line 4147: AdjustsIdTab pa_utils.IdTabTyp;

4143: /** end of proj currency and additional EI attributes **/
4144: ) IS
4145:
4146: ItemsIdTab pa_utils.IdTabTyp;
4147: AdjustsIdTab pa_utils.IdTabTyp;
4148: DenomCurrCodeTab pa_utils.Char15TabTyp;
4149: ProjCurrCodeTab pa_utils.Char15TabTyp;
4150: ProjFuncCurrCodeTab pa_utils.Char15TabTyp;
4151:

Line 4148: DenomCurrCodeTab pa_utils.Char15TabTyp;

4144: ) IS
4145:
4146: ItemsIdTab pa_utils.IdTabTyp;
4147: AdjustsIdTab pa_utils.IdTabTyp;
4148: DenomCurrCodeTab pa_utils.Char15TabTyp;
4149: ProjCurrCodeTab pa_utils.Char15TabTyp;
4150: ProjFuncCurrCodeTab pa_utils.Char15TabTyp;
4151:
4152: TpAmtTypCodeTab pa_utils.Char30TabTyp;

Line 4149: ProjCurrCodeTab pa_utils.Char15TabTyp;

4145:
4146: ItemsIdTab pa_utils.IdTabTyp;
4147: AdjustsIdTab pa_utils.IdTabTyp;
4148: DenomCurrCodeTab pa_utils.Char15TabTyp;
4149: ProjCurrCodeTab pa_utils.Char15TabTyp;
4150: ProjFuncCurrCodeTab pa_utils.Char15TabTyp;
4151:
4152: TpAmtTypCodeTab pa_utils.Char30TabTyp;
4153:

Line 4150: ProjFuncCurrCodeTab pa_utils.Char15TabTyp;

4146: ItemsIdTab pa_utils.IdTabTyp;
4147: AdjustsIdTab pa_utils.IdTabTyp;
4148: DenomCurrCodeTab pa_utils.Char15TabTyp;
4149: ProjCurrCodeTab pa_utils.Char15TabTyp;
4150: ProjFuncCurrCodeTab pa_utils.Char15TabTyp;
4151:
4152: TpAmtTypCodeTab pa_utils.Char30TabTyp;
4153:
4154: dummy NUMBER;

Line 4152: TpAmtTypCodeTab pa_utils.Char30TabTyp;

4148: DenomCurrCodeTab pa_utils.Char15TabTyp;
4149: ProjCurrCodeTab pa_utils.Char15TabTyp;
4150: ProjFuncCurrCodeTab pa_utils.Char15TabTyp;
4151:
4152: TpAmtTypCodeTab pa_utils.Char30TabTyp;
4153:
4154: dummy NUMBER;
4155: temp_outcome VARCHAR2(30) DEFAULT NULL;
4156: temp_status NUMBER DEFAULT NULL;

Line 5313: ItemsIdTab pa_utils.IdTabTyp;

5309: , p_wip_resource_id IN NUMBER
5310: , p_inventory_item_id IN NUMBER
5311: /* R12 Changes - End */
5312: ) IS
5313: ItemsIdTab pa_utils.IdTabTyp;
5314: AdjustsIdTab pa_utils.IdTabTyp;
5315: ItemsIdCapTab pa_utils.IdTabTyp;
5316: AdjustsIdCapTab pa_utils.IdTabTyp;
5317: ItemsIdNCapTab pa_utils.IdTabTyp;

Line 5314: AdjustsIdTab pa_utils.IdTabTyp;

5310: , p_inventory_item_id IN NUMBER
5311: /* R12 Changes - End */
5312: ) IS
5313: ItemsIdTab pa_utils.IdTabTyp;
5314: AdjustsIdTab pa_utils.IdTabTyp;
5315: ItemsIdCapTab pa_utils.IdTabTyp;
5316: AdjustsIdCapTab pa_utils.IdTabTyp;
5317: ItemsIdNCapTab pa_utils.IdTabTyp;
5318: AdjustsIdNCapTab pa_utils.IdTabTyp;

Line 5315: ItemsIdCapTab pa_utils.IdTabTyp;

5311: /* R12 Changes - End */
5312: ) IS
5313: ItemsIdTab pa_utils.IdTabTyp;
5314: AdjustsIdTab pa_utils.IdTabTyp;
5315: ItemsIdCapTab pa_utils.IdTabTyp;
5316: AdjustsIdCapTab pa_utils.IdTabTyp;
5317: ItemsIdNCapTab pa_utils.IdTabTyp;
5318: AdjustsIdNCapTab pa_utils.IdTabTyp;
5319: DenomCurrCodeTab pa_utils.Char15TabTyp;

Line 5316: AdjustsIdCapTab pa_utils.IdTabTyp;

5312: ) IS
5313: ItemsIdTab pa_utils.IdTabTyp;
5314: AdjustsIdTab pa_utils.IdTabTyp;
5315: ItemsIdCapTab pa_utils.IdTabTyp;
5316: AdjustsIdCapTab pa_utils.IdTabTyp;
5317: ItemsIdNCapTab pa_utils.IdTabTyp;
5318: AdjustsIdNCapTab pa_utils.IdTabTyp;
5319: DenomCurrCodeTab pa_utils.Char15TabTyp;
5320: ProjCurrCodeTab pa_utils.Char15TabTyp;

Line 5317: ItemsIdNCapTab pa_utils.IdTabTyp;

5313: ItemsIdTab pa_utils.IdTabTyp;
5314: AdjustsIdTab pa_utils.IdTabTyp;
5315: ItemsIdCapTab pa_utils.IdTabTyp;
5316: AdjustsIdCapTab pa_utils.IdTabTyp;
5317: ItemsIdNCapTab pa_utils.IdTabTyp;
5318: AdjustsIdNCapTab pa_utils.IdTabTyp;
5319: DenomCurrCodeTab pa_utils.Char15TabTyp;
5320: ProjCurrCodeTab pa_utils.Char15TabTyp;
5321: ProjFuncCurrCodeTab pa_utils.Char15TabTyp;

Line 5318: AdjustsIdNCapTab pa_utils.IdTabTyp;

5314: AdjustsIdTab pa_utils.IdTabTyp;
5315: ItemsIdCapTab pa_utils.IdTabTyp;
5316: AdjustsIdCapTab pa_utils.IdTabTyp;
5317: ItemsIdNCapTab pa_utils.IdTabTyp;
5318: AdjustsIdNCapTab pa_utils.IdTabTyp;
5319: DenomCurrCodeTab pa_utils.Char15TabTyp;
5320: ProjCurrCodeTab pa_utils.Char15TabTyp;
5321: ProjFuncCurrCodeTab pa_utils.Char15TabTyp;
5322: ProjTpCurrCodeTab pa_utils.Char15TabTyp;

Line 5319: DenomCurrCodeTab pa_utils.Char15TabTyp;

5315: ItemsIdCapTab pa_utils.IdTabTyp;
5316: AdjustsIdCapTab pa_utils.IdTabTyp;
5317: ItemsIdNCapTab pa_utils.IdTabTyp;
5318: AdjustsIdNCapTab pa_utils.IdTabTyp;
5319: DenomCurrCodeTab pa_utils.Char15TabTyp;
5320: ProjCurrCodeTab pa_utils.Char15TabTyp;
5321: ProjFuncCurrCodeTab pa_utils.Char15TabTyp;
5322: ProjTpCurrCodeTab pa_utils.Char15TabTyp;
5323:

Line 5320: ProjCurrCodeTab pa_utils.Char15TabTyp;

5316: AdjustsIdCapTab pa_utils.IdTabTyp;
5317: ItemsIdNCapTab pa_utils.IdTabTyp;
5318: AdjustsIdNCapTab pa_utils.IdTabTyp;
5319: DenomCurrCodeTab pa_utils.Char15TabTyp;
5320: ProjCurrCodeTab pa_utils.Char15TabTyp;
5321: ProjFuncCurrCodeTab pa_utils.Char15TabTyp;
5322: ProjTpCurrCodeTab pa_utils.Char15TabTyp;
5323:
5324: TpAmtTypCodeTab pa_utils.Char30TabTyp;

Line 5321: ProjFuncCurrCodeTab pa_utils.Char15TabTyp;

5317: ItemsIdNCapTab pa_utils.IdTabTyp;
5318: AdjustsIdNCapTab pa_utils.IdTabTyp;
5319: DenomCurrCodeTab pa_utils.Char15TabTyp;
5320: ProjCurrCodeTab pa_utils.Char15TabTyp;
5321: ProjFuncCurrCodeTab pa_utils.Char15TabTyp;
5322: ProjTpCurrCodeTab pa_utils.Char15TabTyp;
5323:
5324: TpAmtTypCodeTab pa_utils.Char30TabTyp;
5325:

Line 5322: ProjTpCurrCodeTab pa_utils.Char15TabTyp;

5318: AdjustsIdNCapTab pa_utils.IdTabTyp;
5319: DenomCurrCodeTab pa_utils.Char15TabTyp;
5320: ProjCurrCodeTab pa_utils.Char15TabTyp;
5321: ProjFuncCurrCodeTab pa_utils.Char15TabTyp;
5322: ProjTpCurrCodeTab pa_utils.Char15TabTyp;
5323:
5324: TpAmtTypCodeTab pa_utils.Char30TabTyp;
5325:
5326: dummy NUMBER;

Line 5324: TpAmtTypCodeTab pa_utils.Char30TabTyp;

5320: ProjCurrCodeTab pa_utils.Char15TabTyp;
5321: ProjFuncCurrCodeTab pa_utils.Char15TabTyp;
5322: ProjTpCurrCodeTab pa_utils.Char15TabTyp;
5323:
5324: TpAmtTypCodeTab pa_utils.Char30TabTyp;
5325:
5326: dummy NUMBER;
5327: l_project_start_date DATE;
5328: l_project_completion_date DATE;

Line 5579: where_clause := where_clause || ' AND e.expenditure_ending_date >= trunc(pa_utils.getweekending(:ex_end_date_low) - 6)';

5575: || ' AND et.expenditure_category = :expenditure_catg)';
5576: end if;
5577:
5578: if x_ex_end_date_low is not null then
5579: where_clause := where_clause || ' AND e.expenditure_ending_date >= trunc(pa_utils.getweekending(:ex_end_date_low) - 6)';
5580: end if;
5581:
5582: if x_ex_end_date_high is not null then
5583: where_clause := where_clause || ' AND e.expenditure_ending_date <= trunc(pa_utils.getweekending(:ex_end_date_high))';

Line 5583: where_clause := where_clause || ' AND e.expenditure_ending_date <= trunc(pa_utils.getweekending(:ex_end_date_high))';

5579: where_clause := where_clause || ' AND e.expenditure_ending_date >= trunc(pa_utils.getweekending(:ex_end_date_low) - 6)';
5580: end if;
5581:
5582: if x_ex_end_date_high is not null then
5583: where_clause := where_clause || ' AND e.expenditure_ending_date <= trunc(pa_utils.getweekending(:ex_end_date_high))';
5584: end if;
5585:
5586: if x_expenditure_group is not null then
5587: where_clause := where_clause || ' AND e.expenditure_group = :expenditure_group';

Line 6406: and NVL(PA_UTILS4.get_trxn_work_billabilty(p_dest_work_type_id, NULL),l_billable_flag) <> l_billable_flag then

6402: /* Bug 5364389 - Start */
6403: if v_allow_adjustments = 'N'
6404: and x_adj_action in ( 'CHANGE WORK TYPE ATTRIBUTE')
6405: and l_allow_adjustments_flag = 'N'
6406: and NVL(PA_UTILS4.get_trxn_work_billabilty(p_dest_work_type_id, NULL),l_billable_flag) <> l_billable_flag then
6407: v_allow_adjustments := 'PA_TR_APE_NO_ADJUST';
6408: end if;
6409: /* Bug 5364389 - End */
6410:

Line 6714: AND NVL(PA_UTILS4.get_trxn_work_billabilty(p_dest_work_type_id, NULL),l_billable_flag) <> l_billable_flag)) THEN

6710: , 'NON-CAPITALIZABLE RECLASS'
6711: , 'RAW COST RECALC'
6712: , 'COST AND REV RECALC')
6713: OR ( X_adj_action = 'CHANGE WORK TYPE ATTRIBUTE'
6714: AND NVL(PA_UTILS4.get_trxn_work_billabilty(p_dest_work_type_id, NULL),l_billable_flag) <> l_billable_flag)) THEN
6715:
6716: IF NVL(FND_PROFILE.VALUE('PA_ALLOW_RCV_ERV_ADJ_WHEN_JOURNAL_CONVERT'), 'N') = 'N'
6717: AND RepCurrOrSecLedgerDiffCurr(v_exp_org_id) THEN
6718:

Line 6745: AND NVL(PA_UTILS4.get_trxn_work_billabilty(p_dest_work_type_id, NULL),l_billable_flag) <> l_billable_flag)) THEN

6741: , 'NON-CAPITALIZABLE RECLASS'
6742: , 'RAW COST RECALC'
6743: , 'COST AND REV RECALC')
6744: OR ( X_adj_action = 'CHANGE WORK TYPE ATTRIBUTE'
6745: AND NVL(PA_UTILS4.get_trxn_work_billabilty(p_dest_work_type_id, NULL),l_billable_flag) <> l_billable_flag)) THEN
6746:
6747: IF pa_adjustments.is_recoverability_affected
6748: (p_expenditure_item_id => v_expenditure_item_id
6749: ,p_org_id => v_exp_org_id

Line 6791: AND NVL(PA_UTILS4.get_trxn_work_billabilty(p_dest_work_type_id, NULL),l_billable_flag) <> l_billable_flag)) THEN

6787: , 'NON-CAPITALIZABLE RECLASS'
6788: , 'RAW COST RECALC'
6789: , 'COST AND REV RECALC')
6790: OR ( X_adj_action = 'CHANGE WORK TYPE ATTRIBUTE'
6791: AND NVL(PA_UTILS4.get_trxn_work_billabilty(p_dest_work_type_id, NULL),l_billable_flag) <> l_billable_flag)) THEN
6792:
6793: IF NOT pa_adjustments.Allow_Adjust_with_Auto_Offset
6794: (p_expenditure_item_id => v_expenditure_item_id
6795: ,p_org_id => v_exp_org_id

Line 7236: ItemsIdTab IN pa_utils.IdTabTyp

7232:
7233: -- This procedure was created to improve the performance allowing multiple
7234:
7235: PROCEDURE MassAction(
7236: ItemsIdTab IN pa_utils.IdTabTyp
7237: , AdjustsIdTab IN pa_utils.IdTabTyp
7238: , X_adj_action IN VARCHAR2
7239: , X_module IN VARCHAR2
7240: , X_user IN NUMBER

Line 7237: , AdjustsIdTab IN pa_utils.IdTabTyp

7233: -- This procedure was created to improve the performance allowing multiple
7234:
7235: PROCEDURE MassAction(
7236: ItemsIdTab IN pa_utils.IdTabTyp
7237: , AdjustsIdTab IN pa_utils.IdTabTyp
7238: , X_adj_action IN VARCHAR2
7239: , X_module IN VARCHAR2
7240: , X_user IN NUMBER
7241: , X_login IN NUMBER

Line 7252: , DenomCurrCodeTab IN pa_utils.Char15TabTyp

7248: , X_project_exchange_rate IN NUMBER
7249: , X_acct_rate_type IN VARCHAR2
7250: , X_acct_rate_date IN DATE
7251: , X_acct_exchange_rate IN NUMBER
7252: , DenomCurrCodeTab IN pa_utils.Char15TabTyp
7253: , ProjCurrCodeTab IN pa_utils.Char15TabTyp
7254: , X_status OUT NOCOPY VARCHAR2
7255: , X_num_processed OUT NOCOPY NUMBER
7256: , X_num_rejected OUT NOCOPY NUMBER

Line 7253: , ProjCurrCodeTab IN pa_utils.Char15TabTyp

7249: , X_acct_rate_type IN VARCHAR2
7250: , X_acct_rate_date IN DATE
7251: , X_acct_exchange_rate IN NUMBER
7252: , DenomCurrCodeTab IN pa_utils.Char15TabTyp
7253: , ProjCurrCodeTab IN pa_utils.Char15TabTyp
7254: , X_status OUT NOCOPY VARCHAR2
7255: , X_num_processed OUT NOCOPY NUMBER
7256: , X_num_rejected OUT NOCOPY NUMBER
7257: , ProjFuncCurrCodeTab IN pa_utils.Char15TabTyp

Line 7257: , ProjFuncCurrCodeTab IN pa_utils.Char15TabTyp

7253: , ProjCurrCodeTab IN pa_utils.Char15TabTyp
7254: , X_status OUT NOCOPY VARCHAR2
7255: , X_num_processed OUT NOCOPY NUMBER
7256: , X_num_rejected OUT NOCOPY NUMBER
7257: , ProjFuncCurrCodeTab IN pa_utils.Char15TabTyp
7258: , p_projfunc_cost_rate_type IN VARCHAR2
7259: , p_projfunc_cost_rate_date IN date
7260: , p_projfunc_cost_exchange_rate IN NUMBER
7261: , p_project_tp_cost_rate_type IN VARCHAR2

Line 7267: , p_TpAmtTypCodeTab IN pa_utils.Char30TabTyp

7263: , p_project_tp_cost_exchg_rate IN NUMBER
7264: , p_assignment_id IN NUMBER
7265: , p_work_type_id IN NUMBER
7266: , p_projfunc_currency_code IN VARCHAR2
7267: , p_TpAmtTypCodeTab IN pa_utils.Char30TabTyp
7268: , p_dest_tp_amt_type_code IN VARCHAR2 )
7269:
7270: IS
7271: dummy NUMBER;

Line 7671: PROCEDURE ChangeFuncAttributes(ItemsIdTab IN pa_utils.IdTabTyp

7667:
7668: -- Fix for bug # 913353. in the decode for the project attributes
7669: -- replaced acct_rate_type etc with X_acct_rate_type
7670:
7671: PROCEDURE ChangeFuncAttributes(ItemsIdTab IN pa_utils.IdTabTyp
7672: , X_adjust_level IN VARCHAR2
7673: , X_user IN NUMBER
7674: , X_login IN NUMBER
7675: , X_module IN VARCHAR2

Line 7679: , DenomCurrCodeTab IN pa_utils.Char15TabTyp

7675: , X_module IN VARCHAR2
7676: , X_acct_rate_type IN VARCHAR2
7677: , X_acct_rate_date IN DATE
7678: , X_acct_exchange_rate IN NUMBER
7679: , DenomCurrCodeTab IN pa_utils.Char15TabTyp
7680: , ProjCurrCodeTab IN pa_utils.Char15TabTyp
7681: , rows IN NUMBER
7682: , X_num_processed OUT NOCOPY NUMBER
7683: , X_num_rejected OUT NOCOPY NUMBER

Line 7680: , ProjCurrCodeTab IN pa_utils.Char15TabTyp

7676: , X_acct_rate_type IN VARCHAR2
7677: , X_acct_rate_date IN DATE
7678: , X_acct_exchange_rate IN NUMBER
7679: , DenomCurrCodeTab IN pa_utils.Char15TabTyp
7680: , ProjCurrCodeTab IN pa_utils.Char15TabTyp
7681: , rows IN NUMBER
7682: , X_num_processed OUT NOCOPY NUMBER
7683: , X_num_rejected OUT NOCOPY NUMBER
7684: , X_status OUT NOCOPY NUMBER

Line 7685: , ProjfuncCurrCodeTab IN pa_utils.Char15TabTyp ) IS

7681: , rows IN NUMBER
7682: , X_num_processed OUT NOCOPY NUMBER
7683: , X_num_rejected OUT NOCOPY NUMBER
7684: , X_status OUT NOCOPY NUMBER
7685: , ProjfuncCurrCodeTab IN pa_utils.Char15TabTyp ) IS
7686:
7687: temp_status NUMBER DEFAULT NULL;
7688: item_count NUMBER := 0;
7689: failed_count NUMBER := 0 ;

Line 7935: (ItemsIdTab IN pa_utils.IdTabTyp

7931: /** This api is newly added to convert / change the project functional currency attributes
7932: * this is called from EI enquiry form for EI adjustments
7933: */
7934: PROCEDURE ChangeProjFuncAttributes
7935: (ItemsIdTab IN pa_utils.IdTabTyp
7936: , p_adjust_level IN VARCHAR2
7937: , p_user IN NUMBER
7938: , p_login IN NUMBER
7939: , p_module IN VARCHAR2

Line 7943: , p_DenomCurrCodeTab IN pa_utils.Char15TabTyp

7939: , p_module IN VARCHAR2
7940: , p_projfunc_cost_rate_type IN VARCHAR2
7941: , p_projfunc_cost_rate_date IN DATE
7942: , p_projfunc_cost_exchg_rate IN NUMBER
7943: , p_DenomCurrCodeTab IN pa_utils.Char15TabTyp
7944: , p_ProjFuncCurrCodeTab IN pa_utils.Char15TabTyp
7945: , p_rows IN NUMBER
7946: , X_num_processed OUT NOCOPY NUMBER
7947: , X_num_rejected OUT NOCOPY NUMBER

Line 7944: , p_ProjFuncCurrCodeTab IN pa_utils.Char15TabTyp

7940: , p_projfunc_cost_rate_type IN VARCHAR2
7941: , p_projfunc_cost_rate_date IN DATE
7942: , p_projfunc_cost_exchg_rate IN NUMBER
7943: , p_DenomCurrCodeTab IN pa_utils.Char15TabTyp
7944: , p_ProjFuncCurrCodeTab IN pa_utils.Char15TabTyp
7945: , p_rows IN NUMBER
7946: , X_num_processed OUT NOCOPY NUMBER
7947: , X_num_rejected OUT NOCOPY NUMBER
7948: , X_status OUT NOCOPY NUMBER

Line 8192: PROCEDURE ChangeProjAttributes(ItemsIdTab IN pa_utils.IdTabTyp

8188: END ChangeProjFuncAttributes;
8189:
8190: /** This api update the EI table when project curenncy attributes are changed **/
8191:
8192: PROCEDURE ChangeProjAttributes(ItemsIdTab IN pa_utils.IdTabTyp
8193: , X_adjust_level IN VARCHAR2
8194: , X_user IN NUMBER
8195: , X_login IN NUMBER
8196: , X_module IN VARCHAR2

Line 8200: , DenomCurrCodeTab IN pa_utils.Char15TabTyp

8196: , X_module IN VARCHAR2
8197: , X_project_rate_type IN VARCHAR2
8198: , X_project_rate_date IN DATE
8199: , X_project_exchange_rate IN NUMBER
8200: , DenomCurrCodeTab IN pa_utils.Char15TabTyp
8201: , ProjCurrCodeTab IN pa_utils.Char15TabTyp
8202: , rows IN NUMBER
8203: , X_num_processed OUT NOCOPY NUMBER
8204: , X_num_rejected OUT NOCOPY NUMBER

Line 8201: , ProjCurrCodeTab IN pa_utils.Char15TabTyp

8197: , X_project_rate_type IN VARCHAR2
8198: , X_project_rate_date IN DATE
8199: , X_project_exchange_rate IN NUMBER
8200: , DenomCurrCodeTab IN pa_utils.Char15TabTyp
8201: , ProjCurrCodeTab IN pa_utils.Char15TabTyp
8202: , rows IN NUMBER
8203: , X_num_processed OUT NOCOPY NUMBER
8204: , X_num_rejected OUT NOCOPY NUMBER
8205: , X_status OUT NOCOPY NUMBER ) IS

Line 8407: PROCEDURE ReprocessCrossCharge(ItemsIdTab IN pa_utils.IdTabTyp

8403: END ChangeProjAttributes;
8404:
8405: -- New procedure for the Cross Charge Adjustments
8406:
8407: PROCEDURE ReprocessCrossCharge(ItemsIdTab IN pa_utils.IdTabTyp
8408: , X_adjust_level IN VARCHAR2
8409: , X_user IN NUMBER
8410: , X_login IN NUMBER
8411: , X_module IN VARCHAR2

Line 8705: PROCEDURE MarkNoCCProcess (ItemsIdTab IN pa_utils.IdTabTyp

8701: X_status := SQLCODE;
8702: RAISE;
8703: END ReprocessCrossCharge ;
8704:
8705: PROCEDURE MarkNoCCProcess (ItemsIdTab IN pa_utils.IdTabTyp
8706: , X_adjust_level IN VARCHAR2
8707: , X_user IN NUMBER
8708: , X_login IN NUMBER
8709: , X_module IN VARCHAR2

Line 8886: PROCEDURE ChangeTPAttributes(ItemsIdTab IN pa_utils.IdTabTyp

8882: X_status := SQLCODE;
8883: RAISE;
8884: END MarkNoCCProcess ;
8885:
8886: PROCEDURE ChangeTPAttributes(ItemsIdTab IN pa_utils.IdTabTyp
8887: , X_adjust_level IN VARCHAR2
8888: , X_user IN NUMBER
8889: , X_login IN NUMBER
8890: , X_module IN VARCHAR2

Line 8896: , DenomCurrCodeTab IN pa_utils.Char15TabTyp

8892: , X_acct_tp_rate_date IN DATE
8893: , X_acct_tp_exchange_rate IN NUMBER
8894: , X_bl_dist_code IN VARCHAR2
8895: , X_ic_proc_code IN VARCHAR2
8896: , DenomCurrCodeTab IN pa_utils.Char15TabTyp
8897: , rows IN NUMBER
8898: , X_num_processed OUT NOCOPY NUMBER
8899: , X_num_rejected OUT NOCOPY NUMBER
8900: , X_status OUT NOCOPY NUMBER

Line 9664: l_gl_date := NVL(pa_utils2.get_prvdr_gl_date(p_reference_date => l_gl_date

9660:
9661: /* For Supplier Costs, we have to pass the accounting data
9662: as a parameter. We derive the latest open GL period */
9663:
9664: l_gl_date := NVL(pa_utils2.get_prvdr_gl_date(p_reference_date => l_gl_date
9665: ,p_application_id => l_pa_gl_app_id
9666: ,p_set_of_books_id => G_SET_OF_BOOKS_ID),l_gl_date);
9667:
9668: /* Call Supplier Invoice Account Generator Workflow */

Line 9923: IF PA_UTILS4.get_ledger_cash_basis_flag = 'Y' THEN

9919:
9920: BEGIN
9921:
9922: /* Bug 5006835 - Start */
9923: IF PA_UTILS4.get_ledger_cash_basis_flag = 'Y' THEN
9924:
9925: /* Bug 5551933 - Start */
9926: IF p_transaction_source = 'AP DISCOUNTS' THEN
9927: