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 468: X_backout_id := pa_utils.GetNextEiId;

464: item_comment VARCHAR2(240);
465:
466: BEGIN
467:
468: X_backout_id := pa_utils.GetNextEiId;
469: /*12.2 Payroll Integration changes*/
470: IF X_module = 'PAXREVTXN' THEN
471: G_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
472: G_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;

Line 1087: PROCEDURE RecalcRev( ItemsIdTab IN pa_utils.IdTabTyp

1083: -- ========================================================================
1084: -- PROCEDURE RecalcRev
1085: -- ========================================================================
1086:
1087: PROCEDURE RecalcRev( ItemsIdTab IN pa_utils.IdTabTyp
1088: , AdjustsIdTab IN pa_utils.IdTabTyp
1089: , X_user IN NUMBER
1090: , X_login IN NUMBER
1091: , X_module IN VARCHAR2

Line 1088: , AdjustsIdTab IN pa_utils.IdTabTyp

1084: -- PROCEDURE RecalcRev
1085: -- ========================================================================
1086:
1087: PROCEDURE RecalcRev( ItemsIdTab IN pa_utils.IdTabTyp
1088: , AdjustsIdTab IN pa_utils.IdTabTyp
1089: , X_user IN NUMBER
1090: , X_login IN NUMBER
1091: , X_module IN VARCHAR2
1092: , rows IN NUMBER

Line 1176: PROCEDURE RecalcCostRev( ItemsIdTab IN pa_utils.IdTabTyp

1172: -- ========================================================================
1173: -- PROCEDURE RecalcCostRev
1174: -- ========================================================================
1175:
1176: PROCEDURE RecalcCostRev( ItemsIdTab IN pa_utils.IdTabTyp
1177: , AdjustsIdTab IN pa_utils.IdTabTyp
1178: , X_user IN NUMBER
1179: , X_login IN NUMBER
1180: , X_module IN VARCHAR2

Line 1177: , AdjustsIdTab IN pa_utils.IdTabTyp

1173: -- PROCEDURE RecalcCostRev
1174: -- ========================================================================
1175:
1176: PROCEDURE RecalcCostRev( ItemsIdTab IN pa_utils.IdTabTyp
1177: , AdjustsIdTab IN pa_utils.IdTabTyp
1178: , X_user IN NUMBER
1179: , X_login IN NUMBER
1180: , X_module IN VARCHAR2
1181: , rows IN NUMBER

Line 1434: PROCEDURE RecalcIndCost( ItemsIdTab IN pa_utils.IdTabTyp

1430: -- ========================================================================
1431: -- PROCEDURE RecalcIndCost
1432: -- ========================================================================
1433:
1434: PROCEDURE RecalcIndCost( ItemsIdTab IN pa_utils.IdTabTyp
1435: , AdjustsIdTab IN pa_utils.IdTabTyp
1436: , X_user IN NUMBER
1437: , X_login IN NUMBER
1438: , X_module IN VARCHAR2

Line 1435: , AdjustsIdTab IN pa_utils.IdTabTyp

1431: -- PROCEDURE RecalcIndCost
1432: -- ========================================================================
1433:
1434: PROCEDURE RecalcIndCost( ItemsIdTab IN pa_utils.IdTabTyp
1435: , AdjustsIdTab IN pa_utils.IdTabTyp
1436: , X_user IN NUMBER
1437: , X_login IN NUMBER
1438: , X_module IN VARCHAR2
1439: , rows IN BINARY_INTEGER

Line 1560: PROCEDURE RecalcRawCost( ItemsIdTab IN pa_utils.IdTabTyp

1556: -- inserts the action 'RAW COST RECALC' into the adjustment activity
1557: -- table, instead of 'COST AND REV RECALC'. Used for indirect and
1558: -- capital (v4.0) projects, where the latter action would not make sense.
1559:
1560: PROCEDURE RecalcRawCost( ItemsIdTab IN pa_utils.IdTabTyp
1561: , AdjustsIdTab IN pa_utils.IdTabTyp
1562: , X_user IN NUMBER
1563: , X_login IN NUMBER
1564: , X_module IN VARCHAR2

Line 1561: , AdjustsIdTab IN pa_utils.IdTabTyp

1557: -- table, instead of 'COST AND REV RECALC'. Used for indirect and
1558: -- capital (v4.0) projects, where the latter action would not make sense.
1559:
1560: PROCEDURE RecalcRawCost( ItemsIdTab IN pa_utils.IdTabTyp
1561: , AdjustsIdTab IN pa_utils.IdTabTyp
1562: , X_user IN NUMBER
1563: , X_login IN NUMBER
1564: , X_module IN VARCHAR2
1565: , rows IN NUMBER

Line 1824: PROCEDURE RecalcCapCost( ItemsIdTab IN pa_utils.IdTabTyp

1820: -- This is the exact same as RecalcIndCost, except it also sets the
1821: -- revenue_distributed_flag to 'N'. Used for expenditure items
1822: -- belonging to CAPITAL projects (v4.0).
1823:
1824: PROCEDURE RecalcCapCost( ItemsIdTab IN pa_utils.IdTabTyp
1825: , AdjustsIdTab IN pa_utils.IdTabTyp
1826: , X_user IN NUMBER
1827: , X_login IN NUMBER
1828: , X_module IN VARCHAR2

Line 1825: , AdjustsIdTab IN pa_utils.IdTabTyp

1821: -- revenue_distributed_flag to 'N'. Used for expenditure items
1822: -- belonging to CAPITAL projects (v4.0).
1823:
1824: PROCEDURE RecalcCapCost( ItemsIdTab IN pa_utils.IdTabTyp
1825: , AdjustsIdTab IN pa_utils.IdTabTyp
1826: , X_user IN NUMBER
1827: , X_login IN NUMBER
1828: , X_module IN VARCHAR2
1829: , rows IN BINARY_INTEGER

Line 2050: PROCEDURE Hold( ItemsIdTab IN pa_utils.IdTabTyp

2046: -- ========================================================================
2047: -- PROCEDURE Hold
2048: -- ========================================================================
2049:
2050: PROCEDURE Hold( ItemsIdTab IN pa_utils.IdTabTyp
2051: , AdjustsIdTab IN pa_utils.IdTabTyp
2052: , X_hold IN VARCHAR2
2053: , X_adj_activity IN VARCHAR2
2054: , X_user IN NUMBER

Line 2051: , AdjustsIdTab IN pa_utils.IdTabTyp

2047: -- PROCEDURE Hold
2048: -- ========================================================================
2049:
2050: PROCEDURE Hold( ItemsIdTab IN pa_utils.IdTabTyp
2051: , AdjustsIdTab IN pa_utils.IdTabTyp
2052: , X_hold IN VARCHAR2
2053: , X_adj_activity IN VARCHAR2
2054: , X_user IN NUMBER
2055: , X_login IN NUMBER

Line 2146: ( ItemsIdTab IN pa_utils.IdTabTyp

2142: * To change the billability of the transaction user has to run the
2143: * Reclass Billable / Non Billable adjustments seperately
2144: **/
2145: PROCEDURE work_type_adjustment
2146: ( ItemsIdTab IN pa_utils.IdTabTyp
2147: --, AdjustsIdTab IN pa_utils.IdTabTyp
2148: , p_billable IN VARCHAR2
2149: , p_work_type_id IN NUMBER
2150: , p_adj_activity IN VARCHAR2

Line 2147: --, AdjustsIdTab IN pa_utils.IdTabTyp

2143: * Reclass Billable / Non Billable adjustments seperately
2144: **/
2145: PROCEDURE work_type_adjustment
2146: ( ItemsIdTab IN pa_utils.IdTabTyp
2147: --, AdjustsIdTab IN pa_utils.IdTabTyp
2148: , p_billable IN VARCHAR2
2149: , p_work_type_id IN NUMBER
2150: , p_adj_activity IN VARCHAR2
2151: , p_user IN NUMBER

Line 2155: , p_TpAmtTypCodeTab IN pa_utils.Char30TabTyp

2151: , p_user IN NUMBER
2152: , p_login IN NUMBER
2153: , p_module IN VARCHAR2
2154: , p_rows IN BINARY_INTEGER
2155: , p_TpAmtTypCodeTab IN pa_utils.Char30TabTyp
2156: , p_dest_tp_amt_type_code IN VARCHAR2
2157: , x_status OUT NOCOPY NUMBER )
2158: IS
2159: l_temp_status NUMBER DEFAULT NULL;

Line 2409: l_profile_option := pa_utils4.IS_WORKTYPE_BILLABLE_ENABLED ;

2405: print_message ('get_denom_curr_code: ' || 'after select l_old_work_type_id ['||l_old_work_type_id||
2406: ']l_gl_accounted_flag['||l_gl_accounted_flag||']l_old_billability['||l_old_billability||']' );
2407: END IF;
2408:
2409: l_profile_option := pa_utils4.IS_WORKTYPE_BILLABLE_ENABLED ;
2410:
2411: If l_profile_option = 'Y' and l_proj_type_class_code in ('CAPITAL','CONTRACT') then
2412:
2413:

Line 2414: l_new_billability := PA_UTILS4.get_trxn_work_billabilty

2410:
2411: If l_profile_option = 'Y' and l_proj_type_class_code in ('CAPITAL','CONTRACT') then
2412:
2413:
2414: l_new_billability := PA_UTILS4.get_trxn_work_billabilty
2415: (p_work_type_id => p_work_type_id
2416: ,p_tc_extn_bill_flag => NULL );
2417:
2418: /*** Commented out this portion due to following issue

Line 2423: l_old_billability := PA_UTILS4.get_trxn_work_billabilty

2419: ** Initially set the work type profile to 'N' and transaction is entered with billability = 'Y'
2420: ** Now set the work type profile to 'Y', As the old and new worktype results no change in billability
2421: ** then EI will never be updated with the billablity change . in order to fix this
2422: ** donot derive old billabity based on worktype
2423: l_old_billability := PA_UTILS4.get_trxn_work_billabilty
2424: (p_work_type_id => l_old_work_type_id
2425: ,p_tc_extn_bill_flag => NULL );
2426: **/
2427:

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

2437: l_change_in_billable := 'N';
2438:
2439: End if;
2440:
2441: --l_profile_option := pa_utils4.IS_WORKTYPE_BILLABLE_ENABLED ;
2442:
2443: IF P_DEBUG_MODE THEN
2444: print_message('get_denom_curr_code: ' || 'l_old_billability['||l_old_billability||
2445: ']l_new_billability['||l_new_billability||

Line 2542: ,ei.tp_amt_type_code = PA_UTILS4.get_tp_amt_type_code

2538: ,ei.billable_flag = decode(l_change_in_billable,'Y',l_new_billability,ei.billable_flag)
2539: ,ei.last_updated_by = p_user
2540: ,ei.last_update_date = sysdate
2541: ,ei.last_update_login = p_login
2542: ,ei.tp_amt_type_code = PA_UTILS4.get_tp_amt_type_code
2543: (p_work_type_id)
2544: ,cc_bl_distributed_code = DECODE(p_dest_tp_amt_type_code, p_TpAmtTypCodeTab(i),
2545: cc_bl_distributed_code,
2546: decode(cc_bl_distributed_code,'X','X','N'))

Line 2599: PROCEDURE Reclass( ItemsIdTab IN pa_utils.IdTabTyp

2595: -- ========================================================================
2596: -- PROCEDURE Reclass
2597: -- ========================================================================
2598:
2599: PROCEDURE Reclass( ItemsIdTab IN pa_utils.IdTabTyp
2600: , AdjustsIdTab IN pa_utils.IdTabTyp
2601: , X_billable IN VARCHAR2
2602: , X_adj_activity IN VARCHAR2
2603: , X_user IN NUMBER

Line 2600: , AdjustsIdTab IN pa_utils.IdTabTyp

2596: -- PROCEDURE Reclass
2597: -- ========================================================================
2598:
2599: PROCEDURE Reclass( ItemsIdTab IN pa_utils.IdTabTyp
2600: , AdjustsIdTab IN pa_utils.IdTabTyp
2601: , X_billable IN VARCHAR2
2602: , X_adj_activity IN VARCHAR2
2603: , X_user IN NUMBER
2604: , X_login IN NUMBER

Line 3190: new_item_id := pa_utils.GetNextEiId;

3186: item_project_burdened_cost := p_item2_project_burden_cost;
3187:
3188: END IF;
3189:
3190: new_item_id := pa_utils.GetNextEiId;
3191:
3192: IF P_DEBUG_MODE THEN
3193: print_message('get_denom_curr_code: ' || 'calling insert into EI');
3194: END IF;

Line 3497: PROCEDURE Transfer ( ItemsIdTab IN pa_utils.IdTabTyp

3493: -- ========================================================================
3494: -- PROCEDURE Transfer
3495: -- ========================================================================
3496:
3497: PROCEDURE Transfer ( ItemsIdTab IN pa_utils.IdTabTyp
3498: , X_dest_prj_id IN NUMBER
3499: , X_dest_task_id IN NUMBER
3500: , X_project_currency_code IN VARCHAR2
3501: , X_project_rate_type IN VARCHAR2

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

3766:
3767: IF P_DEBUG_MODE THEN
3768: print_message('get_denom_curr_code: ' || 'inside Transfer api');
3769: END IF;
3770: l_dest_lcm := pa_utils2.GetLaborCostMultiplier(X_dest_task_id);
3771: FOR i IN 1..rows LOOP
3772:
3773: FOR EiRec IN Items( ItemsIdTab(i) ) LOOP
3774:

Line 3810: Pa_Utils4.Get_Work_Assignment (

3806: IF P_DEBUG_MODE THEN
3807: print_message('get_denom_curr_code: ' || 'calling get work type assignment api');
3808: END IF;
3809: /** derive work type and assignment for the destination task , project **/
3810: Pa_Utils4.Get_Work_Assignment (
3811: p_person_id => EiRec.inc_by_person_id
3812: ,p_project_id => X_dest_prj_id
3813: ,p_task_id => X_dest_task_id
3814: ,p_ei_date => EiRec.expenditure_item_date

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

3913: END IF;
3914:
3915: ELSE
3916:
3917: EiRec.expenditure_item_id := pa_utils.GetNextEiId;
3918: pa_transactions_pub.validate_transaction(
3919: X_project_id => X_dest_prj_id
3920: , X_task_id => X_dest_task_id
3921: , X_ei_date => EiRec.expenditure_item_date

Line 4256: ItemsIdTab pa_utils.IdTabTyp;

4252: /** end of proj currency and additional EI attributes **/
4253: , p_cbs_element_id IN number -- Added for CBS Enhancement Bug 16220146
4254: ) IS
4255:
4256: ItemsIdTab pa_utils.IdTabTyp;
4257: AdjustsIdTab pa_utils.IdTabTyp;
4258: DenomCurrCodeTab pa_utils.Char15TabTyp;
4259: ProjCurrCodeTab pa_utils.Char15TabTyp;
4260: ProjFuncCurrCodeTab pa_utils.Char15TabTyp;

Line 4257: AdjustsIdTab pa_utils.IdTabTyp;

4253: , p_cbs_element_id IN number -- Added for CBS Enhancement Bug 16220146
4254: ) IS
4255:
4256: ItemsIdTab pa_utils.IdTabTyp;
4257: AdjustsIdTab pa_utils.IdTabTyp;
4258: DenomCurrCodeTab pa_utils.Char15TabTyp;
4259: ProjCurrCodeTab pa_utils.Char15TabTyp;
4260: ProjFuncCurrCodeTab pa_utils.Char15TabTyp;
4261:

Line 4258: DenomCurrCodeTab pa_utils.Char15TabTyp;

4254: ) IS
4255:
4256: ItemsIdTab pa_utils.IdTabTyp;
4257: AdjustsIdTab pa_utils.IdTabTyp;
4258: DenomCurrCodeTab pa_utils.Char15TabTyp;
4259: ProjCurrCodeTab pa_utils.Char15TabTyp;
4260: ProjFuncCurrCodeTab pa_utils.Char15TabTyp;
4261:
4262: TpAmtTypCodeTab pa_utils.Char30TabTyp;

Line 4259: ProjCurrCodeTab pa_utils.Char15TabTyp;

4255:
4256: ItemsIdTab pa_utils.IdTabTyp;
4257: AdjustsIdTab pa_utils.IdTabTyp;
4258: DenomCurrCodeTab pa_utils.Char15TabTyp;
4259: ProjCurrCodeTab pa_utils.Char15TabTyp;
4260: ProjFuncCurrCodeTab pa_utils.Char15TabTyp;
4261:
4262: TpAmtTypCodeTab pa_utils.Char30TabTyp;
4263:

Line 4260: ProjFuncCurrCodeTab pa_utils.Char15TabTyp;

4256: ItemsIdTab pa_utils.IdTabTyp;
4257: AdjustsIdTab pa_utils.IdTabTyp;
4258: DenomCurrCodeTab pa_utils.Char15TabTyp;
4259: ProjCurrCodeTab pa_utils.Char15TabTyp;
4260: ProjFuncCurrCodeTab pa_utils.Char15TabTyp;
4261:
4262: TpAmtTypCodeTab pa_utils.Char30TabTyp;
4263:
4264: dummy NUMBER;

Line 4262: TpAmtTypCodeTab pa_utils.Char30TabTyp;

4258: DenomCurrCodeTab pa_utils.Char15TabTyp;
4259: ProjCurrCodeTab pa_utils.Char15TabTyp;
4260: ProjFuncCurrCodeTab pa_utils.Char15TabTyp;
4261:
4262: TpAmtTypCodeTab pa_utils.Char30TabTyp;
4263:
4264: dummy NUMBER;
4265: temp_outcome VARCHAR2(30) DEFAULT NULL;
4266: temp_status NUMBER DEFAULT NULL;

Line 5427: ItemsIdTab pa_utils.IdTabTyp;

5423: /* R12 Changes - End */
5424: , p_cbs_element_id IN NUMBER -- Added for CBS Enhancement Bug 16220146
5425: , p_dest_cbs_element_id IN NUMBER -- Added for bug 16446988
5426: ) IS
5427: ItemsIdTab pa_utils.IdTabTyp;
5428: AdjustsIdTab pa_utils.IdTabTyp;
5429: ItemsIdCapTab pa_utils.IdTabTyp;
5430: AdjustsIdCapTab pa_utils.IdTabTyp;
5431: ItemsIdNCapTab pa_utils.IdTabTyp;

Line 5428: AdjustsIdTab pa_utils.IdTabTyp;

5424: , p_cbs_element_id IN NUMBER -- Added for CBS Enhancement Bug 16220146
5425: , p_dest_cbs_element_id IN NUMBER -- Added for bug 16446988
5426: ) IS
5427: ItemsIdTab pa_utils.IdTabTyp;
5428: AdjustsIdTab pa_utils.IdTabTyp;
5429: ItemsIdCapTab pa_utils.IdTabTyp;
5430: AdjustsIdCapTab pa_utils.IdTabTyp;
5431: ItemsIdNCapTab pa_utils.IdTabTyp;
5432: AdjustsIdNCapTab pa_utils.IdTabTyp;

Line 5429: ItemsIdCapTab pa_utils.IdTabTyp;

5425: , p_dest_cbs_element_id IN NUMBER -- Added for bug 16446988
5426: ) IS
5427: ItemsIdTab pa_utils.IdTabTyp;
5428: AdjustsIdTab pa_utils.IdTabTyp;
5429: ItemsIdCapTab pa_utils.IdTabTyp;
5430: AdjustsIdCapTab pa_utils.IdTabTyp;
5431: ItemsIdNCapTab pa_utils.IdTabTyp;
5432: AdjustsIdNCapTab pa_utils.IdTabTyp;
5433: DenomCurrCodeTab pa_utils.Char15TabTyp;

Line 5430: AdjustsIdCapTab pa_utils.IdTabTyp;

5426: ) IS
5427: ItemsIdTab pa_utils.IdTabTyp;
5428: AdjustsIdTab pa_utils.IdTabTyp;
5429: ItemsIdCapTab pa_utils.IdTabTyp;
5430: AdjustsIdCapTab pa_utils.IdTabTyp;
5431: ItemsIdNCapTab pa_utils.IdTabTyp;
5432: AdjustsIdNCapTab pa_utils.IdTabTyp;
5433: DenomCurrCodeTab pa_utils.Char15TabTyp;
5434: ProjCurrCodeTab pa_utils.Char15TabTyp;

Line 5431: ItemsIdNCapTab pa_utils.IdTabTyp;

5427: ItemsIdTab pa_utils.IdTabTyp;
5428: AdjustsIdTab pa_utils.IdTabTyp;
5429: ItemsIdCapTab pa_utils.IdTabTyp;
5430: AdjustsIdCapTab pa_utils.IdTabTyp;
5431: ItemsIdNCapTab pa_utils.IdTabTyp;
5432: AdjustsIdNCapTab pa_utils.IdTabTyp;
5433: DenomCurrCodeTab pa_utils.Char15TabTyp;
5434: ProjCurrCodeTab pa_utils.Char15TabTyp;
5435: ProjFuncCurrCodeTab pa_utils.Char15TabTyp;

Line 5432: AdjustsIdNCapTab pa_utils.IdTabTyp;

5428: AdjustsIdTab pa_utils.IdTabTyp;
5429: ItemsIdCapTab pa_utils.IdTabTyp;
5430: AdjustsIdCapTab pa_utils.IdTabTyp;
5431: ItemsIdNCapTab pa_utils.IdTabTyp;
5432: AdjustsIdNCapTab pa_utils.IdTabTyp;
5433: DenomCurrCodeTab pa_utils.Char15TabTyp;
5434: ProjCurrCodeTab pa_utils.Char15TabTyp;
5435: ProjFuncCurrCodeTab pa_utils.Char15TabTyp;
5436: ProjTpCurrCodeTab pa_utils.Char15TabTyp;

Line 5433: DenomCurrCodeTab pa_utils.Char15TabTyp;

5429: ItemsIdCapTab pa_utils.IdTabTyp;
5430: AdjustsIdCapTab pa_utils.IdTabTyp;
5431: ItemsIdNCapTab pa_utils.IdTabTyp;
5432: AdjustsIdNCapTab pa_utils.IdTabTyp;
5433: DenomCurrCodeTab pa_utils.Char15TabTyp;
5434: ProjCurrCodeTab pa_utils.Char15TabTyp;
5435: ProjFuncCurrCodeTab pa_utils.Char15TabTyp;
5436: ProjTpCurrCodeTab pa_utils.Char15TabTyp;
5437:

Line 5434: ProjCurrCodeTab pa_utils.Char15TabTyp;

5430: AdjustsIdCapTab pa_utils.IdTabTyp;
5431: ItemsIdNCapTab pa_utils.IdTabTyp;
5432: AdjustsIdNCapTab pa_utils.IdTabTyp;
5433: DenomCurrCodeTab pa_utils.Char15TabTyp;
5434: ProjCurrCodeTab pa_utils.Char15TabTyp;
5435: ProjFuncCurrCodeTab pa_utils.Char15TabTyp;
5436: ProjTpCurrCodeTab pa_utils.Char15TabTyp;
5437:
5438: TpAmtTypCodeTab pa_utils.Char30TabTyp;

Line 5435: ProjFuncCurrCodeTab pa_utils.Char15TabTyp;

5431: ItemsIdNCapTab pa_utils.IdTabTyp;
5432: AdjustsIdNCapTab pa_utils.IdTabTyp;
5433: DenomCurrCodeTab pa_utils.Char15TabTyp;
5434: ProjCurrCodeTab pa_utils.Char15TabTyp;
5435: ProjFuncCurrCodeTab pa_utils.Char15TabTyp;
5436: ProjTpCurrCodeTab pa_utils.Char15TabTyp;
5437:
5438: TpAmtTypCodeTab pa_utils.Char30TabTyp;
5439:

Line 5436: ProjTpCurrCodeTab pa_utils.Char15TabTyp;

5432: AdjustsIdNCapTab pa_utils.IdTabTyp;
5433: DenomCurrCodeTab pa_utils.Char15TabTyp;
5434: ProjCurrCodeTab pa_utils.Char15TabTyp;
5435: ProjFuncCurrCodeTab pa_utils.Char15TabTyp;
5436: ProjTpCurrCodeTab pa_utils.Char15TabTyp;
5437:
5438: TpAmtTypCodeTab pa_utils.Char30TabTyp;
5439:
5440: dummy NUMBER;

Line 5438: TpAmtTypCodeTab pa_utils.Char30TabTyp;

5434: ProjCurrCodeTab pa_utils.Char15TabTyp;
5435: ProjFuncCurrCodeTab pa_utils.Char15TabTyp;
5436: ProjTpCurrCodeTab pa_utils.Char15TabTyp;
5437:
5438: TpAmtTypCodeTab pa_utils.Char30TabTyp;
5439:
5440: dummy NUMBER;
5441: l_project_start_date DATE;
5442: l_project_completion_date DATE;

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

5705: || ' AND et.expenditure_category = :expenditure_catg)';
5706: end if;
5707:
5708: if x_ex_end_date_low is not null then
5709: where_clause := where_clause || ' AND e.expenditure_ending_date >= trunc(pa_utils.getweekending(:ex_end_date_low) - 6)';
5710: end if;
5711:
5712: if x_ex_end_date_high is not null then
5713: where_clause := where_clause || ' AND e.expenditure_ending_date <= trunc(pa_utils.getweekending(:ex_end_date_high))';

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

5709: where_clause := where_clause || ' AND e.expenditure_ending_date >= trunc(pa_utils.getweekending(:ex_end_date_low) - 6)';
5710: end if;
5711:
5712: if x_ex_end_date_high is not null then
5713: where_clause := where_clause || ' AND e.expenditure_ending_date <= trunc(pa_utils.getweekending(:ex_end_date_high))';
5714: end if;
5715:
5716: if x_expenditure_group is not null then
5717: where_clause := where_clause || ' AND e.expenditure_group = :expenditure_group';

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

6566: /* Bug 5364389 - Start */
6567: if v_allow_adjustments = 'N'
6568: and x_adj_action in ( 'CHANGE WORK TYPE ATTRIBUTE')
6569: and l_allow_adjustments_flag = 'N'
6570: and NVL(PA_UTILS4.get_trxn_work_billabilty(p_dest_work_type_id, NULL),l_billable_flag) <> l_billable_flag then
6571: v_allow_adjustments := 'PA_TR_APE_NO_ADJUST';
6572: end if;
6573: /* Bug 5364389 - End */
6574:

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

6874: , 'NON-CAPITALIZABLE RECLASS'
6875: , 'RAW COST RECALC'
6876: , 'COST AND REV RECALC')
6877: OR ( X_adj_action = 'CHANGE WORK TYPE ATTRIBUTE'
6878: AND NVL(PA_UTILS4.get_trxn_work_billabilty(p_dest_work_type_id, NULL),l_billable_flag) <> l_billable_flag)) THEN
6879:
6880: IF NVL(FND_PROFILE.VALUE('PA_ALLOW_RCV_ERV_ADJ_WHEN_JOURNAL_CONVERT'), 'N') = 'N'
6881: AND RepCurrOrSecLedgerDiffCurr(v_exp_org_id) THEN
6882:

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

6905: , 'NON-CAPITALIZABLE RECLASS'
6906: , 'RAW COST RECALC'
6907: , 'COST AND REV RECALC')
6908: OR ( X_adj_action = 'CHANGE WORK TYPE ATTRIBUTE'
6909: AND NVL(PA_UTILS4.get_trxn_work_billabilty(p_dest_work_type_id, NULL),l_billable_flag) <> l_billable_flag)) THEN
6910:
6911: IF pa_adjustments.is_recoverability_affected
6912: (p_expenditure_item_id => v_expenditure_item_id
6913: ,p_org_id => v_exp_org_id

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

6952: , 'NON-CAPITALIZABLE RECLASS'
6953: , 'RAW COST RECALC'
6954: , 'COST AND REV RECALC')
6955: OR ( X_adj_action = 'CHANGE WORK TYPE ATTRIBUTE'
6956: AND NVL(PA_UTILS4.get_trxn_work_billabilty(p_dest_work_type_id, NULL),l_billable_flag) <> l_billable_flag)) THEN
6957:
6958: IF NOT pa_adjustments.Allow_Adjust_with_Auto_Offset
6959: (p_expenditure_item_id => v_expenditure_item_id
6960: ,p_org_id => v_exp_org_id

Line 7035: pa_utils.get_rate_source_cost_method(v_expenditure_item_id,v_exp_item_date,l_curr_rate_source_code,l_curr_costing_mthd,l_curr_accrual_flag);

7031: --Expenditure Adjustments
7032:
7033: IF v_allow_adjustments = 'N'
7034: and x_adj_action IN ('COST AND REV RECALC', 'RAW COST RECALC','TRANSFER') THEN
7035: pa_utils.get_rate_source_cost_method(v_expenditure_item_id,v_exp_item_date,l_curr_rate_source_code,l_curr_costing_mthd,l_curr_accrual_flag);
7036: IF (l_prev_costing_method = 'STANDARD_COSTING' AND
7037: l_curr_costing_mthd = 'ACTUAL') OR
7038: (l_prev_costing_method = 'ACTUAL' AND
7039: l_curr_costing_mthd = 'STANDARD') THEN

Line 7447: ItemsIdTab IN pa_utils.IdTabTyp

7443:
7444: -- This procedure was created to improve the performance allowing multiple
7445:
7446: PROCEDURE MassAction(
7447: ItemsIdTab IN pa_utils.IdTabTyp
7448: , AdjustsIdTab IN pa_utils.IdTabTyp
7449: , X_adj_action IN VARCHAR2
7450: , X_module IN VARCHAR2
7451: , X_user IN NUMBER

Line 7448: , AdjustsIdTab IN pa_utils.IdTabTyp

7444: -- This procedure was created to improve the performance allowing multiple
7445:
7446: PROCEDURE MassAction(
7447: ItemsIdTab IN pa_utils.IdTabTyp
7448: , AdjustsIdTab IN pa_utils.IdTabTyp
7449: , X_adj_action IN VARCHAR2
7450: , X_module IN VARCHAR2
7451: , X_user IN NUMBER
7452: , X_login IN NUMBER

Line 7463: , DenomCurrCodeTab IN pa_utils.Char15TabTyp

7459: , X_project_exchange_rate IN NUMBER
7460: , X_acct_rate_type IN VARCHAR2
7461: , X_acct_rate_date IN DATE
7462: , X_acct_exchange_rate IN NUMBER
7463: , DenomCurrCodeTab IN pa_utils.Char15TabTyp
7464: , ProjCurrCodeTab IN pa_utils.Char15TabTyp
7465: , X_status OUT NOCOPY VARCHAR2
7466: , X_num_processed OUT NOCOPY NUMBER
7467: , X_num_rejected OUT NOCOPY NUMBER

Line 7464: , ProjCurrCodeTab IN pa_utils.Char15TabTyp

7460: , X_acct_rate_type IN VARCHAR2
7461: , X_acct_rate_date IN DATE
7462: , X_acct_exchange_rate IN NUMBER
7463: , DenomCurrCodeTab IN pa_utils.Char15TabTyp
7464: , ProjCurrCodeTab IN pa_utils.Char15TabTyp
7465: , X_status OUT NOCOPY VARCHAR2
7466: , X_num_processed OUT NOCOPY NUMBER
7467: , X_num_rejected OUT NOCOPY NUMBER
7468: , ProjFuncCurrCodeTab IN pa_utils.Char15TabTyp

Line 7468: , ProjFuncCurrCodeTab IN pa_utils.Char15TabTyp

7464: , ProjCurrCodeTab IN pa_utils.Char15TabTyp
7465: , X_status OUT NOCOPY VARCHAR2
7466: , X_num_processed OUT NOCOPY NUMBER
7467: , X_num_rejected OUT NOCOPY NUMBER
7468: , ProjFuncCurrCodeTab IN pa_utils.Char15TabTyp
7469: , p_projfunc_cost_rate_type IN VARCHAR2
7470: , p_projfunc_cost_rate_date IN date
7471: , p_projfunc_cost_exchange_rate IN NUMBER
7472: , p_project_tp_cost_rate_type IN VARCHAR2

Line 7478: , p_TpAmtTypCodeTab IN pa_utils.Char30TabTyp

7474: , p_project_tp_cost_exchg_rate IN NUMBER
7475: , p_assignment_id IN NUMBER
7476: , p_work_type_id IN NUMBER
7477: , p_projfunc_currency_code IN VARCHAR2
7478: , p_TpAmtTypCodeTab IN pa_utils.Char30TabTyp
7479: , p_dest_tp_amt_type_code IN VARCHAR2
7480: -- , p_cbs_element_id IN NUMBER -- Added for CBS Enhancement Bug 16220146
7481: -- commented the above line as part of bug 16686195
7482: , p_dest_cbs_element_id IN NUMBER -- Modified this parameter for Bug 16446988

Line 7890: PROCEDURE ChangeFuncAttributes(ItemsIdTab IN pa_utils.IdTabTyp

7886:
7887: -- Fix for bug # 913353. in the decode for the project attributes
7888: -- replaced acct_rate_type etc with X_acct_rate_type
7889:
7890: PROCEDURE ChangeFuncAttributes(ItemsIdTab IN pa_utils.IdTabTyp
7891: , X_adjust_level IN VARCHAR2
7892: , X_user IN NUMBER
7893: , X_login IN NUMBER
7894: , X_module IN VARCHAR2

Line 7898: , DenomCurrCodeTab IN pa_utils.Char15TabTyp

7894: , X_module IN VARCHAR2
7895: , X_acct_rate_type IN VARCHAR2
7896: , X_acct_rate_date IN DATE
7897: , X_acct_exchange_rate IN NUMBER
7898: , DenomCurrCodeTab IN pa_utils.Char15TabTyp
7899: , ProjCurrCodeTab IN pa_utils.Char15TabTyp
7900: , rows IN NUMBER
7901: , X_num_processed OUT NOCOPY NUMBER
7902: , X_num_rejected OUT NOCOPY NUMBER

Line 7899: , ProjCurrCodeTab IN pa_utils.Char15TabTyp

7895: , X_acct_rate_type IN VARCHAR2
7896: , X_acct_rate_date IN DATE
7897: , X_acct_exchange_rate IN NUMBER
7898: , DenomCurrCodeTab IN pa_utils.Char15TabTyp
7899: , ProjCurrCodeTab IN pa_utils.Char15TabTyp
7900: , rows IN NUMBER
7901: , X_num_processed OUT NOCOPY NUMBER
7902: , X_num_rejected OUT NOCOPY NUMBER
7903: , X_status OUT NOCOPY NUMBER

Line 7904: , ProjfuncCurrCodeTab IN pa_utils.Char15TabTyp ) IS

7900: , rows IN NUMBER
7901: , X_num_processed OUT NOCOPY NUMBER
7902: , X_num_rejected OUT NOCOPY NUMBER
7903: , X_status OUT NOCOPY NUMBER
7904: , ProjfuncCurrCodeTab IN pa_utils.Char15TabTyp ) IS
7905:
7906: temp_status NUMBER DEFAULT NULL;
7907: item_count NUMBER := 0;
7908: failed_count NUMBER := 0 ;

Line 8156: (ItemsIdTab IN pa_utils.IdTabTyp

8152: /** This api is newly added to convert / change the project functional currency attributes
8153: * this is called from EI enquiry form for EI adjustments
8154: */
8155: PROCEDURE ChangeProjFuncAttributes
8156: (ItemsIdTab IN pa_utils.IdTabTyp
8157: , p_adjust_level IN VARCHAR2
8158: , p_user IN NUMBER
8159: , p_login IN NUMBER
8160: , p_module IN VARCHAR2

Line 8164: , p_DenomCurrCodeTab IN pa_utils.Char15TabTyp

8160: , p_module IN VARCHAR2
8161: , p_projfunc_cost_rate_type IN VARCHAR2
8162: , p_projfunc_cost_rate_date IN DATE
8163: , p_projfunc_cost_exchg_rate IN NUMBER
8164: , p_DenomCurrCodeTab IN pa_utils.Char15TabTyp
8165: , p_ProjFuncCurrCodeTab IN pa_utils.Char15TabTyp
8166: , p_rows IN NUMBER
8167: , X_num_processed OUT NOCOPY NUMBER
8168: , X_num_rejected OUT NOCOPY NUMBER

Line 8165: , p_ProjFuncCurrCodeTab IN pa_utils.Char15TabTyp

8161: , p_projfunc_cost_rate_type IN VARCHAR2
8162: , p_projfunc_cost_rate_date IN DATE
8163: , p_projfunc_cost_exchg_rate IN NUMBER
8164: , p_DenomCurrCodeTab IN pa_utils.Char15TabTyp
8165: , p_ProjFuncCurrCodeTab IN pa_utils.Char15TabTyp
8166: , p_rows IN NUMBER
8167: , X_num_processed OUT NOCOPY NUMBER
8168: , X_num_rejected OUT NOCOPY NUMBER
8169: , X_status OUT NOCOPY NUMBER

Line 8415: PROCEDURE ChangeProjAttributes(ItemsIdTab IN pa_utils.IdTabTyp

8411: END ChangeProjFuncAttributes;
8412:
8413: /** This api update the EI table when project curenncy attributes are changed **/
8414:
8415: PROCEDURE ChangeProjAttributes(ItemsIdTab IN pa_utils.IdTabTyp
8416: , X_adjust_level IN VARCHAR2
8417: , X_user IN NUMBER
8418: , X_login IN NUMBER
8419: , X_module IN VARCHAR2

Line 8423: , DenomCurrCodeTab IN pa_utils.Char15TabTyp

8419: , X_module IN VARCHAR2
8420: , X_project_rate_type IN VARCHAR2
8421: , X_project_rate_date IN DATE
8422: , X_project_exchange_rate IN NUMBER
8423: , DenomCurrCodeTab IN pa_utils.Char15TabTyp
8424: , ProjCurrCodeTab IN pa_utils.Char15TabTyp
8425: , rows IN NUMBER
8426: , X_num_processed OUT NOCOPY NUMBER
8427: , X_num_rejected OUT NOCOPY NUMBER

Line 8424: , ProjCurrCodeTab IN pa_utils.Char15TabTyp

8420: , X_project_rate_type IN VARCHAR2
8421: , X_project_rate_date IN DATE
8422: , X_project_exchange_rate IN NUMBER
8423: , DenomCurrCodeTab IN pa_utils.Char15TabTyp
8424: , ProjCurrCodeTab IN pa_utils.Char15TabTyp
8425: , rows IN NUMBER
8426: , X_num_processed OUT NOCOPY NUMBER
8427: , X_num_rejected OUT NOCOPY NUMBER
8428: , X_status OUT NOCOPY NUMBER ) IS

Line 8632: PROCEDURE ReprocessCrossCharge(ItemsIdTab IN pa_utils.IdTabTyp

8628: END ChangeProjAttributes;
8629:
8630: -- New procedure for the Cross Charge Adjustments
8631:
8632: PROCEDURE ReprocessCrossCharge(ItemsIdTab IN pa_utils.IdTabTyp
8633: , X_adjust_level IN VARCHAR2
8634: , X_user IN NUMBER
8635: , X_login IN NUMBER
8636: , X_module IN VARCHAR2

Line 8988: PROCEDURE MarkNoCCProcess (ItemsIdTab IN pa_utils.IdTabTyp

8984: X_status := SQLCODE;
8985: RAISE;
8986: END ReprocessCrossCharge ;
8987:
8988: PROCEDURE MarkNoCCProcess (ItemsIdTab IN pa_utils.IdTabTyp
8989: , X_adjust_level IN VARCHAR2
8990: , X_user IN NUMBER
8991: , X_login IN NUMBER
8992: , X_module IN VARCHAR2

Line 9169: PROCEDURE ChangeTPAttributes(ItemsIdTab IN pa_utils.IdTabTyp

9165: X_status := SQLCODE;
9166: RAISE;
9167: END MarkNoCCProcess ;
9168:
9169: PROCEDURE ChangeTPAttributes(ItemsIdTab IN pa_utils.IdTabTyp
9170: , X_adjust_level IN VARCHAR2
9171: , X_user IN NUMBER
9172: , X_login IN NUMBER
9173: , X_module IN VARCHAR2

Line 9179: , DenomCurrCodeTab IN pa_utils.Char15TabTyp

9175: , X_acct_tp_rate_date IN DATE
9176: , X_acct_tp_exchange_rate IN NUMBER
9177: , X_bl_dist_code IN VARCHAR2
9178: , X_ic_proc_code IN VARCHAR2
9179: , DenomCurrCodeTab IN pa_utils.Char15TabTyp
9180: , rows IN NUMBER
9181: , X_num_processed OUT NOCOPY NUMBER
9182: , X_num_rejected OUT NOCOPY NUMBER
9183: , X_status OUT NOCOPY NUMBER

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

9943:
9944: /* For Supplier Costs, we have to pass the accounting data
9945: as a parameter. We derive the latest open GL period */
9946:
9947: l_gl_date := NVL(pa_utils2.get_prvdr_gl_date(p_reference_date => l_gl_date
9948: ,p_application_id => l_pa_gl_app_id
9949: ,p_set_of_books_id => G_SET_OF_BOOKS_ID),l_gl_date);
9950:
9951: /* Call Supplier Invoice Account Generator Workflow */

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

10202:
10203: BEGIN
10204:
10205: /* Bug 5006835 - Start */
10206: IF PA_UTILS4.get_ledger_cash_basis_flag = 'Y' THEN
10207:
10208: /* Bug 5551933 - Start */
10209: IF p_transaction_source = 'AP DISCOUNTS' THEN
10210: