[Home] [Help]
5: -- | Private Global Definitions |
6: -- --------------------------------------------------------------------------
7: --
8: g_package Varchar2(30) := 'per_sshr_change_pay.';
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: type t_tx_name is table of varchar2(30) index by binary_integer;
12: type t_tx_char is table of varchar2(2000) index by binary_integer;
13: type t_tx_num is table of number index by binary_integer;
59: l_txn_grade_ladder_id number;
60: Begin
61: l_txn_grade_ladder_id := -1;
62: if g_debug then
63: hr_utility.set_location('Enter Check_GSP_Manual_Override ', 1);
64: hr_utility.set_location('p_assignment_id '||p_assignment_id, 2);
65: hr_utility.set_location('p_effective_date '||p_effective_date,3);
66: hr_utility.set_location('p_transaction_id '||p_transaction_id,4);
67: end if;
60: Begin
61: l_txn_grade_ladder_id := -1;
62: if g_debug then
63: hr_utility.set_location('Enter Check_GSP_Manual_Override ', 1);
64: hr_utility.set_location('p_assignment_id '||p_assignment_id, 2);
65: hr_utility.set_location('p_effective_date '||p_effective_date,3);
66: hr_utility.set_location('p_transaction_id '||p_transaction_id,4);
67: end if;
68:
61: l_txn_grade_ladder_id := -1;
62: if g_debug then
63: hr_utility.set_location('Enter Check_GSP_Manual_Override ', 1);
64: hr_utility.set_location('p_assignment_id '||p_assignment_id, 2);
65: hr_utility.set_location('p_effective_date '||p_effective_date,3);
66: hr_utility.set_location('p_transaction_id '||p_transaction_id,4);
67: end if;
68:
69: Open csr_gsp_ladder_id;
62: if g_debug then
63: hr_utility.set_location('Enter Check_GSP_Manual_Override ', 1);
64: hr_utility.set_location('p_assignment_id '||p_assignment_id, 2);
65: hr_utility.set_location('p_effective_date '||p_effective_date,3);
66: hr_utility.set_location('p_transaction_id '||p_transaction_id,4);
67: end if;
68:
69: Open csr_gsp_ladder_id;
70: Fetch csr_gsp_ladder_id into l_txn_grade_ladder_id ;
70: Fetch csr_gsp_ladder_id into l_txn_grade_ladder_id ;
71: Close csr_gsp_ladder_id;
72:
73: if g_debug then
74: hr_utility.set_location('In GSP_CHECK l_txn_grade_ladder_id '||l_txn_grade_ladder_id, 5);
75: end if;
76:
77: if l_txn_grade_ladder_id is null or l_txn_grade_ladder_id = -1 then
78: Open csr_assignment_check;
78: Open csr_assignment_check;
79: Fetch csr_assignment_check into l_Status;
80: Close csr_assignment_check;
81: if g_debug then
82: hr_utility.set_location('In GSP_CHECK_AST l_Status '||l_Status, 6);
83: end if;
84: else
85: Open csr_transaction_check(l_txn_grade_ladder_id);
86: Fetch csr_transaction_check into l_Status;
85: Open csr_transaction_check(l_txn_grade_ladder_id);
86: Fetch csr_transaction_check into l_Status;
87: Close csr_transaction_check;
88: if g_debug then
89: hr_utility.set_location('In GSP_CHECK_TXN l_Status '||l_Status, 7);
90: end if;
91: end if;
92: RETURN l_Status;
93: End;
158: --
159: BEGIN
160: --
161: if g_debug then
162: hr_utility.set_location('Enter check_base_salary_profile ', 1);
163: end if;
164: --
165: -- Get the transaction_step_id of the assignment step.
166: --
168: Fetch asg_step into l_transaction_id,l_transaction_step_id;
169: Close asg_step;
170: --
171: if g_debug then
172: hr_utility.set_location('l_transaction_id '||l_transaction_id, 2);
173: hr_utility.set_location('l_transaction_step_id '||l_transaction_step_id, 3);
174: end if;
175: --
176: -- There exists an assignment step, Hence get the pay basis from the txn table.
169: Close asg_step;
170: --
171: if g_debug then
172: hr_utility.set_location('l_transaction_id '||l_transaction_id, 2);
173: hr_utility.set_location('l_transaction_step_id '||l_transaction_step_id, 3);
174: end if;
175: --
176: -- There exists an assignment step, Hence get the pay basis from the txn table.
177: -- Note, If new hire flow, there will be an assignment txn step.
218: Fetch csr_prop into l_change_date;
219: Close csr_prop ;
220: -- If no row returned above, raise error
221: if l_change_date is null then
222: hr_utility.set_message(800,'PER_33490_CHGPAY_PROPOSAL_REQD');
223: hr_utility.raise_error;
224: end if;
225: --
226: End if;
219: Close csr_prop ;
220: -- If no row returned above, raise error
221: if l_change_date is null then
222: hr_utility.set_message(800,'PER_33490_CHGPAY_PROPOSAL_REQD');
223: hr_utility.raise_error;
224: end if;
225: --
226: End if;
227: --
1289: Begin
1290: p_allow_change_date := 'YES';
1291: p_allow_basis_change := 'YES';
1292:
1293: --hr_utility.trace_on(null, 'TIGER');
1294: --g_debug := TRUE;
1295:
1296: if g_debug then
1297: hr_utility.set_location('Enter check_Salary_Basis_Change ', 1);
1293: --hr_utility.trace_on(null, 'TIGER');
1294: --g_debug := TRUE;
1295:
1296: if g_debug then
1297: hr_utility.set_location('Enter check_Salary_Basis_Change ', 1);
1298: hr_utility.set_location('p_assignment_id '||p_assignment_id, 2);
1299: hr_utility.set_location('p_effective_date: '||p_effective_date, 3);
1300: hr_utility.set_location('p_item_key '||p_item_key, 4);
1301: end if;
1294: --g_debug := TRUE;
1295:
1296: if g_debug then
1297: hr_utility.set_location('Enter check_Salary_Basis_Change ', 1);
1298: hr_utility.set_location('p_assignment_id '||p_assignment_id, 2);
1299: hr_utility.set_location('p_effective_date: '||p_effective_date, 3);
1300: hr_utility.set_location('p_item_key '||p_item_key, 4);
1301: end if;
1302:
1295:
1296: if g_debug then
1297: hr_utility.set_location('Enter check_Salary_Basis_Change ', 1);
1298: hr_utility.set_location('p_assignment_id '||p_assignment_id, 2);
1299: hr_utility.set_location('p_effective_date: '||p_effective_date, 3);
1300: hr_utility.set_location('p_item_key '||p_item_key, 4);
1301: end if;
1302:
1303: Open csr_asg_basis_change_date;
1296: if g_debug then
1297: hr_utility.set_location('Enter check_Salary_Basis_Change ', 1);
1298: hr_utility.set_location('p_assignment_id '||p_assignment_id, 2);
1299: hr_utility.set_location('p_effective_date: '||p_effective_date, 3);
1300: hr_utility.set_location('p_item_key '||p_item_key, 4);
1301: end if;
1302:
1303: Open csr_asg_basis_change_date;
1304: Fetch csr_asg_basis_change_date into l_date;
1305: if l_date is not null then
1306: p_allow_basis_change := 'ASG_BASIS';
1307: p_allow_change_date := 'NO';
1308: if g_debug then
1309: hr_utility.set_location('ASG_BASIS ', 5);
1310: end if;
1311: return;
1312: end if;
1313: Close csr_asg_basis_change_date;
1317: if l_date is not null then
1318: p_allow_basis_change := 'F_BASIS';
1319: p_allow_change_date := 'NO';
1320: if g_debug then
1321: hr_utility.set_location('F_BASIS ', 6);
1322: end if;
1323: end if;
1324: Close csr_txn_basis_change_date;
1325:
1553: l_failed_to_delete varchar2(2) := 'N';
1554: --
1555: begin
1556: --
1557: --hr_utility.trace_on(null, 'TIGER');
1558: --g_debug := TRUE;
1559: --
1560: if g_debug then
1561: hr_utility.set_location('Entering:'|| l_proc, 10);
1557: --hr_utility.trace_on(null, 'TIGER');
1558: --g_debug := TRUE;
1559: --
1560: if g_debug then
1561: hr_utility.set_location('Entering:'|| l_proc, 10);
1562: end if;
1563: --
1564: if g_debug then
1565: hr_utility.set_location('assgnid:'||p_assgn_id||'effDate:'||p_effective_dt||'transId:'||p_transaction_id, 10);
1561: hr_utility.set_location('Entering:'|| l_proc, 10);
1562: end if;
1563: --
1564: if g_debug then
1565: hr_utility.set_location('assgnid:'||p_assgn_id||'effDate:'||p_effective_dt||'transId:'||p_transaction_id, 10);
1566: hr_utility.set_location('transStepId:'||p_transaction_step_id||'itemKey:'||p_item_key||'itemtype:'||p_item_type, 10);
1567: hr_utility.set_location('nextChangedt:'||p_next_change_date||'currChangedt:'||p_changedt_curr||'lastChangedt:'||p_changedt_last, 10);
1568: end if;
1569: --
1562: end if;
1563: --
1564: if g_debug then
1565: hr_utility.set_location('assgnid:'||p_assgn_id||'effDate:'||p_effective_dt||'transId:'||p_transaction_id, 10);
1566: hr_utility.set_location('transStepId:'||p_transaction_step_id||'itemKey:'||p_item_key||'itemtype:'||p_item_type, 10);
1567: hr_utility.set_location('nextChangedt:'||p_next_change_date||'currChangedt:'||p_changedt_curr||'lastChangedt:'||p_changedt_last, 10);
1568: end if;
1569: --
1570: l_count := 0;
1563: --
1564: if g_debug then
1565: hr_utility.set_location('assgnid:'||p_assgn_id||'effDate:'||p_effective_dt||'transId:'||p_transaction_id, 10);
1566: hr_utility.set_location('transStepId:'||p_transaction_step_id||'itemKey:'||p_item_key||'itemtype:'||p_item_type, 10);
1567: hr_utility.set_location('nextChangedt:'||p_next_change_date||'currChangedt:'||p_changedt_curr||'lastChangedt:'||p_changedt_last, 10);
1568: end if;
1569: --
1570: l_count := 0;
1571: --
1571: --
1572: if p_changedt_last is null then
1573: --
1574: if g_debug then
1575: hr_utility.set_location('Entering if p_changedt_last:'|| l_proc, 20);
1576: end if;
1577: --
1578: l_changedt_last := p_changedt_curr;
1579: --
1579: --
1580: else
1581: --
1582: if g_debug then
1583: hr_utility.set_location('Entering else p_changedt_last:'|| l_proc, 30);
1584: end if;
1585: --
1586: l_changedt_last := p_changedt_last;
1587: --
1618:
1619: for delete_recs in csr_delete_recs(p_effective_dt, p_assgn_id, p_changedt_curr, l_changedt_last, p_transaction_id) loop
1620: --
1621: if g_debug then
1622: hr_utility.set_location(l_proc, 40);
1623: end if;
1624: --
1625: if l_count = 0 then
1626: --
1624: --
1625: if l_count = 0 then
1626: --
1627: if g_debug then
1628: hr_utility.set_location('Entering l_count 0:'|| l_proc, 50);
1629: end if;
1630: --
1631: --
1632: l_last_rec_from := delete_recs.from_tab;
1638: if l_changedt_last = p_changedt_curr then
1639: --
1640: --
1641: if g_debug then
1642: hr_utility.set_location('Entering when last date NULL:'|| l_proc, 60);
1643: end if;
1644: --
1645: if delete_recs.from_tab = 'TRANSACTION' then
1646: --
1668: else
1669: --
1670: --
1671: if g_debug then
1672: hr_utility.set_location('Inserting when p_changedt_last NULL:'|| l_proc, 70);
1673: end if;
1674: --
1675: select PER_PAY_TRANSACTIONS_S.NEXTVAL into l_seq_val from dual;
1676: --
1883: --
1884: elsif l_count = 1 then
1885: --
1886: if g_debug then
1887: hr_utility.set_location('Entering l_count 1:'|| l_proc, 80);
1888: end if;
1889: --
1890: l_curr_rec_from := delete_recs.from_tab;
1891: --
1895: --
1896: if l_last_rec_from = 'TRANSACTION' then
1897: --
1898: if g_debug then
1899: hr_utility.set_location('Entering last rec TRANS:'|| l_proc, 90);
1900: end if;
1901: --
1902: --
1903: --update the last record with current recs date_to
1908: else
1909: --
1910: --
1911: if g_debug then
1912: hr_utility.set_location('Inserting last rec from PROPO:'|| l_proc, 120);
1913: end if;
1914: --
1915: --
1916: select PER_PAY_TRANSACTIONS_S.NEXTVAL into l_seq_val from dual;--replace by Seq number
2125: if delete_recs.from_tab = 'TRANSACTION' then
2126: --
2127: --
2128: if g_debug then
2129: hr_utility.set_location('Entering curr rec from TRANS:'|| l_proc, 100);
2130: end if;
2131: --
2132:
2133: if delete_recs.pay_proposal_id is null then
2161: select PER_PAY_TRANSACTIONS_S.NEXTVAL into l_seq_val from dual; --replace by Seq number
2162: --
2163: --
2164: if g_debug then
2165: hr_utility.set_location('Inserting curr rec PROPOSAL:'|| l_proc, 110);
2166: end if;
2167: --
2168: l_last_change_date_curr := delete_recs.last_change_date;
2169: --
2377: end if;
2378: --
2379: --
2380: if g_debug then
2381: hr_utility.set_location('Incrementing l_count'|| l_proc, 55);
2382: end if;
2383: --
2384: l_count := l_count + 1;
2385: --
2444: --
2445: begin
2446: --
2447: if g_debug then
2448: hr_utility.set_location('Entering:'|| l_proc, 10);
2449: end if;
2450: --
2451: --
2452: --hr_utility.trace_on(null, 'TIGER');
2448: hr_utility.set_location('Entering:'|| l_proc, 10);
2449: end if;
2450: --
2451: --
2452: --hr_utility.trace_on(null, 'TIGER');
2453: --g_debug := TRUE;
2454: --
2455: l_change_amount_comp := 0 ;
2456: --
2462: l_change_amount_comp := l_change_amount_comp + (update_comp_recs.change_percentage * p_prior_proposed_salary*p_xchg_rate/100);
2463: --
2464: --
2465: if g_debug then
2466: hr_utility.set_location('Entering:l_change amount'||l_change_amount_comp||l_proc, 10);
2467: hr_utility.set_location('Entering:prior PROPOSED_SALARY_N'||p_prior_proposed_salary||l_proc, 10);
2468: end if;
2469: --
2470: if p_update_prior = 'Y' then
2463: --
2464: --
2465: if g_debug then
2466: hr_utility.set_location('Entering:l_change amount'||l_change_amount_comp||l_proc, 10);
2467: hr_utility.set_location('Entering:prior PROPOSED_SALARY_N'||p_prior_proposed_salary||l_proc, 10);
2468: end if;
2469: --
2470: if p_update_prior = 'Y' then
2471: --
2470: if p_update_prior = 'Y' then
2471: --
2472: --
2473: if g_debug then
2474: hr_utility.set_location('Entering: prior Update:p_prior_transaction_id'||p_prior_transaction_id, 10);
2475: end if;
2476: --
2477: update per_pay_transactions
2478: set change_amount_n = (update_comp_recs.change_percentage * p_prior_proposed_salary*p_xchg_rate/100),
2486: --
2487: else
2488: --
2489: if g_debug then
2490: hr_utility.set_location('Entering: Else of prior Update'||l_proc, 10);
2491: end if;
2492: --
2493: update per_pay_transactions
2494: set change_amount_n = (update_comp_recs.change_percentage * p_prior_proposed_salary*p_xchg_rate/100)
2579: --
2580: begin
2581: --
2582: if g_debug then
2583: hr_utility.set_location('Entering:'|| l_proc, 10);
2584: end if;
2585: --
2586: --
2587: --hr_utility.trace_on(null, 'TIGER');
2583: hr_utility.set_location('Entering:'|| l_proc, 10);
2584: end if;
2585: --
2586: --
2587: --hr_utility.trace_on(null, 'TIGER');
2588: --g_debug := TRUE;
2589: --
2590: l_count := 0;
2591: --
2595: --
2596: for update_recs in csr_update_recs(p_assgn_id, p_changedate_curr, p_transaction_id) loop
2597: --
2598: if g_debug then
2599: hr_utility.set_location(l_proc, 25);
2600: end if;
2601: --
2602: l_change_amount := 0;
2603: --
2603: --
2604: if l_count = 0 then
2605: --
2606: if g_debug then
2607: hr_utility.set_location(l_proc||'l_count 0', 25);
2608: end if;
2609: --
2610: --
2611: l_prior_trans_id := update_recs.pay_transaction_id;
2622: --
2623: if p_last_change_date is null then
2624: --
2625: if g_debug then
2626: hr_utility.set_location('when last_change_date is null'||l_proc, 30);
2627: hr_utility.set_location('l_prior_trans_id'||l_prior_trans_id||l_proc, 30);
2628: end if;
2629: --need to change prior record as well
2630: --when deleting only rec from PPP
2623: if p_last_change_date is null then
2624: --
2625: if g_debug then
2626: hr_utility.set_location('when last_change_date is null'||l_proc, 30);
2627: hr_utility.set_location('l_prior_trans_id'||l_prior_trans_id||l_proc, 30);
2628: end if;
2629: --need to change prior record as well
2630: --when deleting only rec from PPP
2631: update per_pay_transactions
2649: --immediate record to last record
2650: --to be updated in case of UPD/DEL
2651: --
2652: if g_debug then
2653: hr_utility.set_location(l_proc||'l_count 1', 25);
2654: end if;
2655: --
2656: if update_recs.MULTIPLE_COMPONENTS = 'N' then
2657: --
2655: --
2656: if update_recs.MULTIPLE_COMPONENTS = 'N' then
2657: --
2658: if g_debug then
2659: hr_utility.set_location('No MULTIPLE_COMPONENTS '||l_prior_proposed_sal||l_proc, 25);
2660: end if;
2661: --
2662: if l_last_currency <> update_recs.input_currency_code then
2663: select PER_SALADMIN_UTILITY.get_currency_rate(l_last_currency,update_recs.input_currency_code,update_recs.change_date,p_busgroup_id) into l_xchg_rate
2703: l_xchg_rate);
2704:
2705: --
2706: if g_debug then
2707: hr_utility.set_location('l_change_amt'||l_change_amount, 25);
2708: end if;
2709: ----
2710: --Update only change amount , % remains same
2711: update per_pay_transactions
2726: elsif l_count > 1 then
2727: --
2728: --
2729: if g_debug then
2730: hr_utility.set_location(l_proc||'l_count :'||l_count, 25);
2731: end if;
2732: --
2733: if update_recs.MULTIPLE_COMPONENTS = 'N' then
2734: --
2732: --
2733: if update_recs.MULTIPLE_COMPONENTS = 'N' then
2734: --
2735: if g_debug then
2736: hr_utility.set_location(l_proc||'No MULTIPLE_COMPONENTS'||l_count, 25);
2737: end if;
2738: --
2739: if l_last_currency <> update_recs.input_currency_code then
2740: select PER_SALADMIN_UTILITY.get_currency_rate(l_last_currency,update_recs.input_currency_code,update_recs.change_date,p_busgroup_id) into l_xchg_rate
2754: --
2755: else
2756: --
2757: if g_debug then
2758: hr_utility.set_location('Multiple Comp'||l_proc, 25);
2759: end if;
2760: --
2761: if l_last_currency <> update_recs.input_currency_code then
2762: select PER_SALADMIN_UTILITY.get_currency_rate(l_last_currency,update_recs.input_currency_code,update_recs.change_date,p_busgroup_id) into l_xchg_rate
2854: --
2855: p_status := 'N';
2856: --
2857: if g_debug then
2858: hr_utility.set_location('Entering:'|| l_proc, 10);
2859: end if;
2860: --
2861: open csr_rows_to_be_deleted(p_item_type, p_item_key, p_assignment_id);
2862: fetch csr_rows_to_be_deleted into l_pay_basis_id, l_pay_trans_id;
2971: l_proc varchar2(61) := 'get_pay_transaction' ;
2972: --
2973: Begin
2974: --
2975: hr_utility.set_location('Entering '||l_proc,10);
2976: --
2977: p_update_mode := true;
2978: -- get the transaction id
2979: l_transaction_id := hr_transaction_ss.get_transaction_id
3069: --
3070: p_transaction_id := l_transaction_id;
3071: p_transaction_step_id := l_transaction_step_id;
3072: --
3073: hr_utility.set_location('Leaving '||l_proc,99);
3074: exception
3075: when others then
3076: hr_utility.set_location('Exception Raised',420);
3077: raise;
3072: --
3073: hr_utility.set_location('Leaving '||l_proc,99);
3074: exception
3075: when others then
3076: hr_utility.set_location('Exception Raised',420);
3077: raise;
3078: End get_pay_transaction;
3079: --
3080: ---------------------- process_salary_basis_change --------------------------------------
3095: l_proc varchar2(61) := 'process_salary_basis_change' ;
3096: --
3097: Begin
3098: --
3099: hr_utility.set_location('Entering '||l_proc,10);
3100: --
3101: for csr_sel in csr_sel_item loop
3102: --
3103: hr_transaction_ss.process_web_api_call
3106: ,p_validate => false);
3107: end loop;
3108: --
3109: --
3110: hr_utility.set_location('Leaving '||l_proc,99);
3111: exception
3112: when others then
3113: hr_utility.set_location('Exception Raised',420);
3114: raise;
3109: --
3110: hr_utility.set_location('Leaving '||l_proc,99);
3111: exception
3112: when others then
3113: hr_utility.set_location('Exception Raised',420);
3114: raise;
3115: End process_salary_basis_change;
3116: --
3117: --
3169: l_effective_date_option hr_api_transactions.EFFECTIVE_DATE_OPTION%type;
3170: --
3171: Begin
3172: --
3173: hr_utility.set_location('Entering '||l_proc,10);
3174: --
3175: IF nvl(p_new_hire_flag,'N') = 'Y' THEN
3176: --
3177: hr_utility.set_location(l_proc,95);
3173: hr_utility.set_location('Entering '||l_proc,10);
3174: --
3175: IF nvl(p_new_hire_flag,'N') = 'Y' THEN
3176: --
3177: hr_utility.set_location(l_proc,95);
3178: Open csr_sel_item;
3179: Fetch csr_sel_item into l_item_type,l_item_key;
3180: Close csr_sel_item;
3181: --
3195: -- Set the Assignment Id to the one just created, don't use the
3196: -- transaction table.
3197:
3198: l_g_assignment_id := hr_process_person_ss.g_assignment_id;
3199: hr_utility.set_location('Getting global assignment id = ' ||to_char(l_g_assignment_id),20);
3200: --
3201: END IF;
3202: --
3203: -- query insert pay actions.
3309: p_validate => FALSE);
3310:
3311: End loop;
3312: --
3313: hr_utility.set_location('Leaving '||l_proc,99);
3314: exception
3315: when others then
3316: hr_utility.set_location('Exception Raised',420);
3317: raise;
3312: --
3313: hr_utility.set_location('Leaving '||l_proc,99);
3314: exception
3315: when others then
3316: hr_utility.set_location('Exception Raised',420);
3317: raise;
3318: --
3319: End process_create_pay_action;
3320: --
3351: l_proc varchar2(61) := 'process_update_pay_action' ;
3352: --
3353: Begin
3354: --
3355: hr_utility.set_location('Entering '||l_proc,10);
3356: --
3357: per_pyp_bus.g_validate_ss_change_pay := 'Y';
3358: For l_pay_rec in csr_update_pay loop
3359: --
3443: p_validate => FALSE);
3444: --
3445: End loop;
3446: --
3447: hr_utility.set_location('Leaving '||l_proc,99);
3448: exception
3449: when others then
3450: per_pyp_bus.g_validate_ss_change_pay := 'N';
3451: hr_utility.set_location('Exception Raised',420);
3447: hr_utility.set_location('Leaving '||l_proc,99);
3448: exception
3449: when others then
3450: per_pyp_bus.g_validate_ss_change_pay := 'N';
3451: hr_utility.set_location('Exception Raised',420);
3452: raise;
3453: --
3454: End process_update_pay_action;
3455: --
3479: l_proc varchar2(61) := 'process_delete_pay_action' ;
3480: --
3481: Begin
3482: --
3483: hr_utility.set_location('Entering '||l_proc,10);
3484: --
3485: For l_comp_rec in csr_delete_comp loop
3486: --
3487: Select object_version_number into l_comp_ovn
3506: ,p_validate => FALSE
3507: ,p_salary_warning => l_salary_warning);
3508: End loop;
3509:
3510: hr_utility.set_location('Leaving '||l_proc,99);
3511: exception
3512: when others then
3513: hr_utility.set_location('Exception Raised',420);
3514: raise;
3509:
3510: hr_utility.set_location('Leaving '||l_proc,99);
3511: exception
3512: when others then
3513: hr_utility.set_location('Exception Raised',420);
3514: raise;
3515: --
3516: End process_delete_pay_action;
3517: --
3534: Begin
3535: --
3536:
3537: --
3538: hr_utility.set_location('Entering '||l_proc,10);
3539: --
3540: savepoint apply_change_pay_txn;
3541: --
3542: -- gsp support changes --vkodedal 6141175
3551: --
3552: -- BUG 6002700. Check for "HR Base Salary Required"
3553: check_base_salary_profile(p_transaction_step_id,p_item_key,p_item_type,p_effective_date,p_assignment_id);
3554: --
3555: hr_utility.set_location('Profile check done '||l_proc,12);
3556:
3557: --
3558: if nvl(p_new_hire_flag,'N') = 'N' then
3559: --
3564: --
3565: process_delete_pay_action(
3566: p_transaction_step_id => p_transaction_step_id);
3567: --
3568: hr_utility.set_location('After Deletes '||l_proc,10);
3569: --
3570: process_update_pay_action(
3571: p_transaction_step_id => p_transaction_step_id);
3572: --
3569: --
3570: process_update_pay_action(
3571: p_transaction_step_id => p_transaction_step_id);
3572: --
3573: hr_utility.set_location('After Updates '||l_proc,10);
3574: --
3575: process_create_pay_action(
3576: p_transaction_step_id => p_transaction_step_id,
3577: --p_new_hire_flag => 'Y' );
3576: p_transaction_step_id => p_transaction_step_id,
3577: --p_new_hire_flag => 'Y' );
3578: p_new_hire_flag => p_new_hire_flag );
3579: --
3580: hr_utility.set_location('After Inserts '||l_proc,10);
3581: --
3582: if nvl(p_validate,'N') = 'Y' then
3583: hr_utility.set_location('validate mode '||p_validate,10);
3584: raise hr_api.validate_enabled;
3579: --
3580: hr_utility.set_location('After Inserts '||l_proc,10);
3581: --
3582: if nvl(p_validate,'N') = 'Y' then
3583: hr_utility.set_location('validate mode '||p_validate,10);
3584: raise hr_api.validate_enabled;
3585: Else
3586: --
3587: -- Purge data from transaction tables.
3590: where transaction_step_id = p_transaction_step_id;
3591: --
3592: end if;
3593: --
3594: hr_utility.set_location('Leaving '||l_proc,99);
3595: --
3596: exception
3597: when hr_api.validate_enabled then
3598: --
3600: -- we must rollback to the savepoint
3601: --
3602: ROLLBACK TO apply_change_pay_txn;
3603: --
3604: hr_utility.set_location('Leaving after Rollback'||l_proc,99);
3605: --
3606: when others then
3607: --
3608: ROLLBACK TO apply_change_pay_txn;
3606: when others then
3607: --
3608: ROLLBACK TO apply_change_pay_txn;
3609: --
3610: hr_utility.set_location('Exception Raised',420);
3611: raise;
3612: End;
3613: --
3614: --
3629: l_gsp_assignment varchar2(30);
3630: --
3631: Begin
3632: --
3633: hr_utility.set_location('Entering '||l_proc,10);
3634: --
3635: savepoint apply_change_pay_txn1;
3636: --
3637: -- gsp support changes --vkodedal 6141175
3646: --
3647: process_delete_pay_action(
3648: p_transaction_step_id => p_transaction_step_id);
3649: --
3650: hr_utility.set_location('After Deletes '||l_proc,10);
3651: --
3652: process_update_pay_action(
3653: p_transaction_step_id => p_transaction_step_id);
3654: --
3651: --
3652: process_update_pay_action(
3653: p_transaction_step_id => p_transaction_step_id);
3654: --
3655: hr_utility.set_location('After Updates '||l_proc,10);
3656: --
3657: process_create_pay_action(
3658: p_transaction_step_id => p_transaction_step_id);
3659: --
3656: --
3657: process_create_pay_action(
3658: p_transaction_step_id => p_transaction_step_id);
3659: --
3660: hr_utility.set_location('After Inserts '||l_proc,10);
3661: --
3662: if p_validate then
3663: hr_utility.set_location('validate mode '||l_proc,10);
3664: raise hr_api.validate_enabled;
3659: --
3660: hr_utility.set_location('After Inserts '||l_proc,10);
3661: --
3662: if p_validate then
3663: hr_utility.set_location('validate mode '||l_proc,10);
3664: raise hr_api.validate_enabled;
3665: Else
3666: --
3667: -- Purge data from transaction tables.
3670: where transaction_step_id = p_transaction_step_id;
3671: --
3672: end if;
3673: --
3674: hr_utility.set_location('Leaving '||l_proc,99);
3675: --
3676: exception
3677: when hr_api.validate_enabled then
3678: --
3680: -- we must rollback to the savepoint
3681: --
3682: ROLLBACK TO apply_change_pay_txn1;
3683: --
3684: hr_utility.set_location('Leaving after Rollback'||l_proc,99);
3685: --
3686: when others then
3687: --
3688: ROLLBACK TO apply_change_pay_txn1;
3686: when others then
3687: --
3688: ROLLBACK TO apply_change_pay_txn1;
3689: --
3690: hr_utility.set_location('Exception Raised',420);
3691: raise;
3692: --
3693: End process_api;
3694: --
3843: --
3844: Begin
3845: --
3846: --
3847: -- hr_utility.trace_on(null, 'TIGER');
3848: -- g_debug := TRUE;
3849:
3850: l_proposals_exists := 'YES';
3851: l_payroll_attached := 'YES';
3857: p_default_salary_basis_id := null;
3858: p_basis_default_min_date := null;
3859: --
3860: if g_debug then
3861: hr_utility.set_location('Enter get_create_date ', 1);
3862: hr_utility.set_location('p_assignment_id '||p_assignment_id, 2);
3863: hr_utility.set_location('p_effective_date: '||p_effective_date, 3);
3864: hr_utility.set_location('p_transaction_id '||p_transaction_id, 4);
3865: end if;
3858: p_basis_default_min_date := null;
3859: --
3860: if g_debug then
3861: hr_utility.set_location('Enter get_create_date ', 1);
3862: hr_utility.set_location('p_assignment_id '||p_assignment_id, 2);
3863: hr_utility.set_location('p_effective_date: '||p_effective_date, 3);
3864: hr_utility.set_location('p_transaction_id '||p_transaction_id, 4);
3865: end if;
3866:
3859: --
3860: if g_debug then
3861: hr_utility.set_location('Enter get_create_date ', 1);
3862: hr_utility.set_location('p_assignment_id '||p_assignment_id, 2);
3863: hr_utility.set_location('p_effective_date: '||p_effective_date, 3);
3864: hr_utility.set_location('p_transaction_id '||p_transaction_id, 4);
3865: end if;
3866:
3867: open csr_assgn_exists;
3860: if g_debug then
3861: hr_utility.set_location('Enter get_create_date ', 1);
3862: hr_utility.set_location('p_assignment_id '||p_assignment_id, 2);
3863: hr_utility.set_location('p_effective_date: '||p_effective_date, 3);
3864: hr_utility.set_location('p_transaction_id '||p_transaction_id, 4);
3865: end if;
3866:
3867: open csr_assgn_exists;
3868: Fetch csr_assgn_exists into l_assgn_exists;
3871: if l_assgn_exists is null then
3872:
3873: l_asst_on_gsp := PER_SSHR_CHANGE_PAY.Check_GSP_Manual_Override(p_assignment_id,p_effective_date,p_transaction_id);
3874: if g_debug then
3875: hr_utility.set_location('l_asst_on_gsp '||l_asst_on_gsp, 5);
3876: end if;
3877: if l_asst_on_gsp = 'N' then
3878: p_allow_create := 'Y_GSP';
3879: p_create_date := p_effective_date;
3877: if l_asst_on_gsp = 'N' then
3878: p_allow_create := 'Y_GSP';
3879: p_create_date := p_effective_date;
3880: if g_debug then
3881: hr_utility.set_location('GSP EXISTS ', 6);
3882: end if;
3883: return;
3884: end if;
3885:
3890: close csr_txn_basis_id;
3891:
3892: if p_default_salary_basis_id is null then
3893: if g_debug then
3894: hr_utility.set_location('New Hire and N_BASIS ', 5);
3895: end if;
3896: p_create_date := sysdate;
3897: p_allow_create := 'N_BASIS';
3898: return;
3912: --p_basis_default_date
3913: --p_basis_default_min_date
3914: --p_orig_salary_basis_id
3915: if g_debug then
3916: hr_utility.set_location('New Hire and p_create_date '||p_create_date, 6);
3917: end if;
3918: else
3919: if p_effective_date > l_last_change_date then
3920: p_create_date := p_effective_date;
3930: --p_basis_default_date
3931: --p_basis_default_min_date
3932: --p_orig_salary_basis_id
3933: if g_debug then
3934: hr_utility.set_location('New Hire and p_create_date '||p_create_date, 7);
3935: end if;
3936: end if;
3937:
3938: return;
3956: l_proposals_exists := 'NO';
3957: end if;
3958: --
3959: if g_debug then
3960: hr_utility.set_location('l_payroll_attached '||l_payroll_attached, 10);
3961: hr_utility.set_location('l_last_payroll_run_date: '||l_last_payroll_run_date, 15);
3962: hr_utility.set_location('l_last_change_date '||l_last_change_date, 16);
3963: hr_utility.set_location('l_proposals_exists: '||l_proposals_exists, 17);
3964: end if;
3957: end if;
3958: --
3959: if g_debug then
3960: hr_utility.set_location('l_payroll_attached '||l_payroll_attached, 10);
3961: hr_utility.set_location('l_last_payroll_run_date: '||l_last_payroll_run_date, 15);
3962: hr_utility.set_location('l_last_change_date '||l_last_change_date, 16);
3963: hr_utility.set_location('l_proposals_exists: '||l_proposals_exists, 17);
3964: end if;
3965:
3958: --
3959: if g_debug then
3960: hr_utility.set_location('l_payroll_attached '||l_payroll_attached, 10);
3961: hr_utility.set_location('l_last_payroll_run_date: '||l_last_payroll_run_date, 15);
3962: hr_utility.set_location('l_last_change_date '||l_last_change_date, 16);
3963: hr_utility.set_location('l_proposals_exists: '||l_proposals_exists, 17);
3964: end if;
3965:
3966: --
3959: if g_debug then
3960: hr_utility.set_location('l_payroll_attached '||l_payroll_attached, 10);
3961: hr_utility.set_location('l_last_payroll_run_date: '||l_last_payroll_run_date, 15);
3962: hr_utility.set_location('l_last_change_date '||l_last_change_date, 16);
3963: hr_utility.set_location('l_proposals_exists: '||l_proposals_exists, 17);
3964: end if;
3965:
3966: --
3967: -- CASE 1,2,3,4
3990: l_min_create_date := l_last_payroll_run_date + 1;
3991: l_max_create_date_src := 'PAYROLL';
3992: end if;
3993: if g_debug then
3994: hr_utility.set_location('l_max_create_date '||l_max_create_date, 18);
3995: hr_utility.set_location('l_min_create_date: '||l_min_create_date, 19);
3996: end if;
3997:
3998: --
3991: l_max_create_date_src := 'PAYROLL';
3992: end if;
3993: if g_debug then
3994: hr_utility.set_location('l_max_create_date '||l_max_create_date, 18);
3995: hr_utility.set_location('l_min_create_date: '||l_min_create_date, 19);
3996: end if;
3997:
3998: --
3999: if l_max_create_date_src = 'EFFECTIVEDATE' then
4003: else
4004: l_min_create_date := l_last_change_date + 1;
4005: end if;
4006: if g_debug then
4007: hr_utility.set_location('l_max_create_date '||l_max_create_date, 20);
4008: hr_utility.set_location('l_min_create_date: '||l_min_create_date, 21);
4009: end if;
4010: elsif l_payroll_attached = 'YES' and l_payroll_attached = 'NO' then
4011: l_min_create_date := l_last_payroll_run_date + 1;
4004: l_min_create_date := l_last_change_date + 1;
4005: end if;
4006: if g_debug then
4007: hr_utility.set_location('l_max_create_date '||l_max_create_date, 20);
4008: hr_utility.set_location('l_min_create_date: '||l_min_create_date, 21);
4009: end if;
4010: elsif l_payroll_attached = 'YES' and l_payroll_attached = 'NO' then
4011: l_min_create_date := l_last_payroll_run_date + 1;
4012: if g_debug then
4009: end if;
4010: elsif l_payroll_attached = 'YES' and l_payroll_attached = 'NO' then
4011: l_min_create_date := l_last_payroll_run_date + 1;
4012: if g_debug then
4013: hr_utility.set_location('l_max_create_date '||l_max_create_date, 22);
4014: hr_utility.set_location('l_min_create_date: '||l_min_create_date, 23);
4015: end if;
4016: elsif l_payroll_attached = 'NO' and l_proposals_exists = 'YES' then
4017: l_min_create_date := l_last_change_date + 1;
4010: elsif l_payroll_attached = 'YES' and l_payroll_attached = 'NO' then
4011: l_min_create_date := l_last_payroll_run_date + 1;
4012: if g_debug then
4013: hr_utility.set_location('l_max_create_date '||l_max_create_date, 22);
4014: hr_utility.set_location('l_min_create_date: '||l_min_create_date, 23);
4015: end if;
4016: elsif l_payroll_attached = 'NO' and l_proposals_exists = 'YES' then
4017: l_min_create_date := l_last_change_date + 1;
4018: if g_debug then
4015: end if;
4016: elsif l_payroll_attached = 'NO' and l_proposals_exists = 'YES' then
4017: l_min_create_date := l_last_change_date + 1;
4018: if g_debug then
4019: hr_utility.set_location('l_max_create_date '||l_max_create_date, 24);
4020: hr_utility.set_location('l_min_create_date: '||l_min_create_date, 25);
4021: end if;
4022: elsif l_payroll_attached = 'NO' and l_proposals_exists = 'NO' then
4023: Open csr_asst_start_date;
4016: elsif l_payroll_attached = 'NO' and l_proposals_exists = 'YES' then
4017: l_min_create_date := l_last_change_date + 1;
4018: if g_debug then
4019: hr_utility.set_location('l_max_create_date '||l_max_create_date, 24);
4020: hr_utility.set_location('l_min_create_date: '||l_min_create_date, 25);
4021: end if;
4022: elsif l_payroll_attached = 'NO' and l_proposals_exists = 'NO' then
4023: Open csr_asst_start_date;
4024: Fetch csr_asst_start_date into l_min_create_date;
4026: if l_min_create_date is null then
4027: l_min_create_date := l_max_create_date;
4028: end if;
4029: if g_debug then
4030: hr_utility.set_location('l_max_create_date '||l_max_create_date, 26);
4031: hr_utility.set_location('l_min_create_date: '||l_min_create_date, 27);
4032: end if;
4033: end if;
4034: end if;
4027: l_min_create_date := l_max_create_date;
4028: end if;
4029: if g_debug then
4030: hr_utility.set_location('l_max_create_date '||l_max_create_date, 26);
4031: hr_utility.set_location('l_min_create_date: '||l_min_create_date, 27);
4032: end if;
4033: end if;
4034: end if;
4035:
4037:
4038: Open csr_future_asst_change_max(l_min_create_date,l_max_create_date);
4039: Fetch csr_future_asst_change_max into l_future_asst_change_max;
4040: if g_debug then
4041: hr_utility.set_location('l_future_asst_change_max '||l_future_asst_change_max, 28);
4042: end if;
4043: Close csr_future_asst_change_max;
4044:
4045: if l_future_asst_change_max is not null then
4044:
4045: if l_future_asst_change_max is not null then
4046: l_min_create_date := l_future_asst_change_max;
4047: if g_debug then
4048: hr_utility.set_location('l_min_create_date '||l_min_create_date, 29);
4049: end if;
4050: end if;
4051: --
4052: p_create_date := l_max_create_date;
4051: --
4052: p_create_date := l_max_create_date;
4053: p_min_create_date := l_min_create_date;
4054: if g_debug then
4055: hr_utility.set_location('p_create_date '||p_create_date, 30);
4056: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 35);
4057: end if;
4058: --
4059: Open csr_asst_change_date(l_max_create_date);
4052: p_create_date := l_max_create_date;
4053: p_min_create_date := l_min_create_date;
4054: if g_debug then
4055: hr_utility.set_location('p_create_date '||p_create_date, 30);
4056: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 35);
4057: end if;
4058: --
4059: Open csr_asst_change_date(l_max_create_date);
4060: Fetch csr_asst_change_date into l_asst_change_date;
4081: if (l_asst_change_date is not null and l_csr_asst_chg_count >1) then
4082: p_allow_create := 'M_BASIS';
4083: p_status := 5;
4084: if g_debug then
4085: hr_utility.set_location('p_create_date '||p_create_date, 38);
4086: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 39);
4087: end if;
4088: end if;
4089: --
4082: p_allow_create := 'M_BASIS';
4083: p_status := 5;
4084: if g_debug then
4085: hr_utility.set_location('p_create_date '||p_create_date, 38);
4086: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 39);
4087: end if;
4088: end if;
4089: --
4090: -- CASE 5,6,7,8
4100: p_allow_basis_change := 'YES';
4101: p_allow_date_change := 'YES';
4102: p_status := 1;
4103: if g_debug then
4104: hr_utility.set_location('p_create_date '||p_create_date, 40);
4105: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 45);
4106: end if;
4107: end if;
4108: end if;
4101: p_allow_date_change := 'YES';
4102: p_status := 1;
4103: if g_debug then
4104: hr_utility.set_location('p_create_date '||p_create_date, 40);
4105: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 45);
4106: end if;
4107: end if;
4108: end if;
4109: --
4116: p_allow_basis_change := 'NO';
4117: p_allow_date_change := 'YES';
4118: p_status := 1;
4119: if g_debug then
4120: hr_utility.set_location('p_create_date '||p_create_date, 47);
4121: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 48);
4122: end if;
4123: end if;
4124: end if;
4117: p_allow_date_change := 'YES';
4118: p_status := 1;
4119: if g_debug then
4120: hr_utility.set_location('p_create_date '||p_create_date, 47);
4121: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 48);
4122: end if;
4123: end if;
4124: end if;
4125: --
4134: p_allow_basis_change := 'YES';
4135: p_allow_date_change := 'YES';
4136: p_status := 2;
4137: if g_debug then
4138: hr_utility.set_location('p_create_date '||p_create_date, 50);
4139: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 55);
4140: end if;
4141: end if;
4142: end if;
4135: p_allow_date_change := 'YES';
4136: p_status := 2;
4137: if g_debug then
4138: hr_utility.set_location('p_create_date '||p_create_date, 50);
4139: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 55);
4140: end if;
4141: end if;
4142: end if;
4143: --
4152: p_allow_basis_change := 'YES';
4153: p_allow_date_change := 'YES';
4154: p_status := 3;
4155: if g_debug then
4156: hr_utility.set_location('p_create_date '||p_create_date, 60);
4157: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 65);
4158: end if;
4159: end if;
4160: --
4153: p_allow_date_change := 'YES';
4154: p_status := 3;
4155: if g_debug then
4156: hr_utility.set_location('p_create_date '||p_create_date, 60);
4157: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 65);
4158: end if;
4159: end if;
4160: --
4161: -- CASE 17,18,19,20
4169: p_allow_basis_change := 'YES';
4170: p_allow_date_change := 'YES';
4171: p_status := 4;
4172: if g_debug then
4173: hr_utility.set_location('p_create_date '||p_create_date, 70);
4174: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 75);
4175: end if;
4176: end if;
4177: --
4170: p_allow_date_change := 'YES';
4171: p_status := 4;
4172: if g_debug then
4173: hr_utility.set_location('p_create_date '||p_create_date, 70);
4174: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 75);
4175: end if;
4176: end if;
4177: --
4178: -- CASE 21,22,23,24
4189: p_allow_basis_change := 'YES';
4190: p_allow_date_change := 'YES';
4191: p_status := 4;
4192: if g_debug then
4193: hr_utility.set_location('p_create_date '||p_create_date, 80);
4194: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 85);
4195: end if;
4196: end if;
4197: --
4190: p_allow_date_change := 'YES';
4191: p_status := 4;
4192: if g_debug then
4193: hr_utility.set_location('p_create_date '||p_create_date, 80);
4194: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 85);
4195: end if;
4196: end if;
4197: --
4198: if ((l_asst_basis_change_date is null and l_asst_change_date is not null)
4206: p_allow_basis_change := 'NO';
4207: p_allow_date_change := 'YES';
4208: p_status := 4;
4209: if g_debug then
4210: hr_utility.set_location('p_create_date '||p_create_date, 87);
4211: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 88);
4212: end if;
4213: end if;
4214: --
4207: p_allow_date_change := 'YES';
4208: p_status := 4;
4209: if g_debug then
4210: hr_utility.set_location('p_create_date '||p_create_date, 87);
4211: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 88);
4212: end if;
4213: end if;
4214: --
4215: -- CASE 25 to 28
4218: if (l_csr_asst_basis_chg_count > 1) then
4219: p_allow_create := 'M_BASIS';
4220: p_status := 5;
4221: if g_debug then
4222: hr_utility.set_location('p_create_date '||p_create_date, 90);
4223: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 95);
4224: end if;
4225: elsif (l_csr_asst_basis_chg_count = 1) then
4226: p_create_date := l_asst_basis_change_date;
4219: p_allow_create := 'M_BASIS';
4220: p_status := 5;
4221: if g_debug then
4222: hr_utility.set_location('p_create_date '||p_create_date, 90);
4223: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 95);
4224: end if;
4225: elsif (l_csr_asst_basis_chg_count = 1) then
4226: p_create_date := l_asst_basis_change_date;
4227: p_min_create_date := l_asst_basis_change_date;
4231: p_allow_basis_change := 'NO';
4232: p_allow_date_change := 'NO';
4233: p_status := 0;
4234: if g_debug then
4235: hr_utility.set_location('p_create_date '||p_create_date, 100);
4236: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 105);
4237: end if;
4238: end if;
4239: end if;
4232: p_allow_date_change := 'NO';
4233: p_status := 0;
4234: if g_debug then
4235: hr_utility.set_location('p_create_date '||p_create_date, 100);
4236: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 105);
4237: end if;
4238: end if;
4239: end if;
4240: --
4243: OR (l_csr_asst_basis_chg_count > 1)) then
4244: p_allow_create := 'M_BASIS';
4245: p_status := 5;
4246: if g_debug then
4247: hr_utility.set_location('p_create_date '||p_create_date, 110);
4248: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 115);
4249: end if;
4250: end if;
4251: --
4244: p_allow_create := 'M_BASIS';
4245: p_status := 5;
4246: if g_debug then
4247: hr_utility.set_location('p_create_date '||p_create_date, 110);
4248: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 115);
4249: end if;
4250: end if;
4251: --
4252: l_asst_on_gsp := PER_SSHR_CHANGE_PAY.Check_GSP_Manual_Override(p_assignment_id,p_create_date,p_transaction_id);
4252: l_asst_on_gsp := PER_SSHR_CHANGE_PAY.Check_GSP_Manual_Override(p_assignment_id,p_create_date,p_transaction_id);
4253: if l_asst_on_gsp = 'N' then
4254: p_allow_create := 'Y_GSP';
4255: if g_debug then
4256: hr_utility.set_location('GSP EXISTS ', 120);
4257: end if;
4258: return;
4259: end if;
4260: --
4270: Close csr_pay_basis_exists;
4271: end if;
4272:
4273: if g_debug then
4274: hr_utility.set_location('p_default_salary_basis_id '||p_default_salary_basis_id, 130);
4275: end if;
4276: end if;
4277:
4278: if p_default_salary_basis_id is null then
4279: Open csr_txn_basis_id;
4280: fetch csr_txn_basis_id into p_default_salary_basis_id, p_orig_salary_basis_id;
4281: Close csr_txn_basis_id;
4282: if g_debug then
4283: hr_utility.set_location('p_default_salary_basis_id '||p_default_salary_basis_id, 140);
4284: end if;
4285: end if;
4286:
4287:
4385: --
4386: --
4387: Begin
4388: --
4389: --hr_utility.trace_on(null, 'TIGER');
4390: g_debug := TRUE;
4391: --
4392: if g_debug then
4393: hr_utility.set_location('Entering '||'get_Create_Date', 5);
4389: --hr_utility.trace_on(null, 'TIGER');
4390: g_debug := TRUE;
4391: --
4392: if g_debug then
4393: hr_utility.set_location('Entering '||'get_Create_Date', 5);
4394: end if;
4395: p_create_date := p_effective_date;
4396: p_allow_date_change := 'YES';
4397: p_allow_basis_change := 'YES';
4400:
4401: l_last_payroll_run_date := PER_SALADMIN_UTILITY.get_last_payroll_dt(p_assignment_id);
4402:
4403: if g_debug then
4404: hr_utility.set_location('Selected p_effective_date '||p_effective_date, 10);
4405: hr_utility.set_location('l_last_payroll_run_date: '||l_last_payroll_run_date, 15);
4406: end if;
4407:
4408: if(l_last_payroll_run_date is null) then
4401: l_last_payroll_run_date := PER_SALADMIN_UTILITY.get_last_payroll_dt(p_assignment_id);
4402:
4403: if g_debug then
4404: hr_utility.set_location('Selected p_effective_date '||p_effective_date, 10);
4405: hr_utility.set_location('l_last_payroll_run_date: '||l_last_payroll_run_date, 15);
4406: end if;
4407:
4408: if(l_last_payroll_run_date is null) then
4409: l_last_payroll_run_date := p_effective_date;
4408: if(l_last_payroll_run_date is null) then
4409: l_last_payroll_run_date := p_effective_date;
4410: l_payroll_attached := 'NO';
4411: if g_debug then
4412: hr_utility.set_location('l_last_payroll_run_date is null and set to '||l_last_payroll_run_date,20);
4413: end if;
4414: end if;
4415:
4416: Open csr_last_change_date;
4421: Fetch csr_txn_basis_change_date into l_txn_basis_change_date,l_default_txn_salary_basis_id;
4422: Close csr_txn_basis_change_date;
4423:
4424: if g_debug then
4425: hr_utility.set_location('l_last_change_date '||l_last_change_date, 25);
4426: hr_utility.set_location('l_txn_basis_change_date '||l_txn_basis_change_date, 27);
4427: end if;
4428:
4429: if l_last_change_date is null then
4422: Close csr_txn_basis_change_date;
4423:
4424: if g_debug then
4425: hr_utility.set_location('l_last_change_date '||l_last_change_date, 25);
4426: hr_utility.set_location('l_txn_basis_change_date '||l_txn_basis_change_date, 27);
4427: end if;
4428:
4429: if l_last_change_date is null then
4430: l_last_change_date := l_last_payroll_run_date;
4429: if l_last_change_date is null then
4430: l_last_change_date := l_last_payroll_run_date;
4431: l_proposals_exists := 'NO';
4432: if g_debug then
4433: hr_utility.set_location('l_last_change_date is null and set to '||l_last_change_date, 30);
4434: end if;
4435: end if;
4436:
4437: Open csr_last_asst_change_date(l_last_change_date);
4439: l_csr_last_asst_chg_dt_count:= csr_last_asst_change_date%ROWCOUNT;
4440: Close csr_last_asst_change_date;
4441:
4442: if g_debug then
4443: hr_utility.set_location('l_csr_last_asst_chg_dt_count: '||l_csr_last_asst_chg_dt_count, 35);
4444: hr_utility.set_location('l_last_assignment_change_date: '||l_last_assignment_change_date, 38);
4445: hr_utility.set_location('l_default_asst_salary_basis_id: '||l_default_asst_salary_basis_id, 39);
4446: end if;
4447: --
4440: Close csr_last_asst_change_date;
4441:
4442: if g_debug then
4443: hr_utility.set_location('l_csr_last_asst_chg_dt_count: '||l_csr_last_asst_chg_dt_count, 35);
4444: hr_utility.set_location('l_last_assignment_change_date: '||l_last_assignment_change_date, 38);
4445: hr_utility.set_location('l_default_asst_salary_basis_id: '||l_default_asst_salary_basis_id, 39);
4446: end if;
4447: --
4448: --
4441:
4442: if g_debug then
4443: hr_utility.set_location('l_csr_last_asst_chg_dt_count: '||l_csr_last_asst_chg_dt_count, 35);
4444: hr_utility.set_location('l_last_assignment_change_date: '||l_last_assignment_change_date, 38);
4445: hr_utility.set_location('l_default_asst_salary_basis_id: '||l_default_asst_salary_basis_id, 39);
4446: end if;
4447: --
4448: --
4449: if( (l_txn_basis_change_date is not null and l_last_assignment_change_date is not null and l_txn_basis_change_date <> l_last_assignment_change_date)
4451: (l_csr_last_asst_chg_dt_count >1)
4452: ) then
4453: p_allow_create := 'M_BASIS';
4454: if g_debug then
4455: hr_utility.set_location('l_csr_last_asst_chg_dt_count>1:: M_BASIS::return ',40);
4456: end if;
4457: return;
4458: else
4459: if g_debug then
4456: end if;
4457: return;
4458: else
4459: if g_debug then
4460: hr_utility.set_location('l_csr_last_asst_chg_dt_count<1:: p_allow_create = Y ',43);
4461: end if;
4462: p_allow_create := 'Y';
4463: end if;
4464: --
4467: if (l_last_change_date = l_txn_basis_change_date) then
4468: p_allow_basis_change := 'NO';
4469:
4470: if g_debug then
4471: hr_utility.set_location('TXN_SAL_BASIS_EXISTS and l_last_change_date = l_txn_basis_change_date',45);
4472: end if;
4473:
4474: if (l_last_payroll_run_date > l_last_change_date) then
4475:
4476: if(l_payroll_attached = 'NO') then
4477: p_create_date := p_effective_date;
4478: p_min_create_date := l_last_change_date;
4479: if g_debug then
4480: hr_utility.set_location('p_create_date '||p_create_date,46);
4481: hr_utility.set_location('p_min_create_date '||p_min_create_date,47);
4482: end if;
4483: else
4484: Open csr_get_next_payroll_date(p_assignment_id,l_last_payroll_run_date);
4477: p_create_date := p_effective_date;
4478: p_min_create_date := l_last_change_date;
4479: if g_debug then
4480: hr_utility.set_location('p_create_date '||p_create_date,46);
4481: hr_utility.set_location('p_min_create_date '||p_min_create_date,47);
4482: end if;
4483: else
4484: Open csr_get_next_payroll_date(p_assignment_id,l_last_payroll_run_date);
4485: Fetch csr_get_next_payroll_date into p_create_date;
4485: Fetch csr_get_next_payroll_date into p_create_date;
4486: Close csr_get_next_payroll_date;
4487: p_min_create_date := l_last_payroll_run_date;
4488: if g_debug then
4489: hr_utility.set_location('p_create_date '||p_create_date,48);
4490: hr_utility.set_location('p_min_create_date '||p_min_create_date,49);
4491: end if;
4492: end if;
4493:
4486: Close csr_get_next_payroll_date;
4487: p_min_create_date := l_last_payroll_run_date;
4488: if g_debug then
4489: hr_utility.set_location('p_create_date '||p_create_date,48);
4490: hr_utility.set_location('p_min_create_date '||p_min_create_date,49);
4491: end if;
4492: end if;
4493:
4494: elsif (l_last_payroll_run_date = l_last_change_date) then
4496: if(l_payroll_attached = 'NO' and l_proposals_exists = 'YES') then
4497: p_create_date := l_last_change_date+1;
4498: p_min_create_date := l_last_change_date;
4499: if g_debug then
4500: hr_utility.set_location('p_create_date '||p_create_date,50);
4501: hr_utility.set_location('p_min_create_date '||p_min_create_date,51);
4502: end if;
4503: elsif(l_payroll_attached = 'NO' and l_proposals_exists = 'NO') then
4504: p_create_date := p_effective_date;
4497: p_create_date := l_last_change_date+1;
4498: p_min_create_date := l_last_change_date;
4499: if g_debug then
4500: hr_utility.set_location('p_create_date '||p_create_date,50);
4501: hr_utility.set_location('p_min_create_date '||p_min_create_date,51);
4502: end if;
4503: elsif(l_payroll_attached = 'NO' and l_proposals_exists = 'NO') then
4504: p_create_date := p_effective_date;
4505: p_min_create_date := p_effective_date;
4503: elsif(l_payroll_attached = 'NO' and l_proposals_exists = 'NO') then
4504: p_create_date := p_effective_date;
4505: p_min_create_date := p_effective_date;
4506: if g_debug then
4507: hr_utility.set_location('p_create_date '||p_create_date,52);
4508: hr_utility.set_location('p_min_create_date '||p_min_create_date,53);
4509: end if;
4510: else
4511: Open csr_get_next_payroll_date(p_assignment_id,l_last_change_date);
4504: p_create_date := p_effective_date;
4505: p_min_create_date := p_effective_date;
4506: if g_debug then
4507: hr_utility.set_location('p_create_date '||p_create_date,52);
4508: hr_utility.set_location('p_min_create_date '||p_min_create_date,53);
4509: end if;
4510: else
4511: Open csr_get_next_payroll_date(p_assignment_id,l_last_change_date);
4512: Fetch csr_get_next_payroll_date into p_create_date;
4512: Fetch csr_get_next_payroll_date into p_create_date;
4513: Close csr_get_next_payroll_date;
4514: p_min_create_date := l_last_change_date+1;
4515: if g_debug then
4516: hr_utility.set_location('p_create_date '||p_create_date,54);
4517: hr_utility.set_location('p_min_create_date '||p_min_create_date,55);
4518: end if;
4519: end if;
4520:
4513: Close csr_get_next_payroll_date;
4514: p_min_create_date := l_last_change_date+1;
4515: if g_debug then
4516: hr_utility.set_location('p_create_date '||p_create_date,54);
4517: hr_utility.set_location('p_min_create_date '||p_min_create_date,55);
4518: end if;
4519: end if;
4520:
4521: elsif (l_last_payroll_run_date < l_last_change_date) then
4523: if(l_payroll_attached = 'NO') then
4524: p_create_date := l_last_change_date+1;
4525: p_min_create_date := l_last_change_date;
4526: if g_debug then
4527: hr_utility.set_location('p_create_date '||p_create_date,56);
4528: hr_utility.set_location('p_min_create_date '||p_min_create_date,57);
4529: end if;
4530: else
4531: Open csr_get_next_payroll_date(p_assignment_id,l_last_change_date);
4524: p_create_date := l_last_change_date+1;
4525: p_min_create_date := l_last_change_date;
4526: if g_debug then
4527: hr_utility.set_location('p_create_date '||p_create_date,56);
4528: hr_utility.set_location('p_min_create_date '||p_min_create_date,57);
4529: end if;
4530: else
4531: Open csr_get_next_payroll_date(p_assignment_id,l_last_change_date);
4532: Fetch csr_get_next_payroll_date into p_create_date;
4532: Fetch csr_get_next_payroll_date into p_create_date;
4533: Close csr_get_next_payroll_date;
4534: p_min_create_date := l_last_change_date;
4535: if g_debug then
4536: hr_utility.set_location('p_create_date '||p_create_date,61);
4537: hr_utility.set_location('p_min_create_date '||p_min_create_date,63);
4538: end if;
4539: end if;
4540:
4533: Close csr_get_next_payroll_date;
4534: p_min_create_date := l_last_change_date;
4535: if g_debug then
4536: hr_utility.set_location('p_create_date '||p_create_date,61);
4537: hr_utility.set_location('p_min_create_date '||p_min_create_date,63);
4538: end if;
4539: end if;
4540:
4541: end if;
4555: p_create_date := l_txn_basis_change_date;
4556: p_min_create_date := l_txn_basis_change_date;
4557: p_allow_date_change := 'NO';
4558: if g_debug then
4559: hr_utility.set_location('l_txn_basis_change_date >= l_last_payroll_run_date l_last_change_date ',66);
4560: hr_utility.set_location('p_create_date '||p_create_date,67);
4561: hr_utility.set_location('p_min_create_date '||p_min_create_date,68);
4562: end if;
4563: else
4556: p_min_create_date := l_txn_basis_change_date;
4557: p_allow_date_change := 'NO';
4558: if g_debug then
4559: hr_utility.set_location('l_txn_basis_change_date >= l_last_payroll_run_date l_last_change_date ',66);
4560: hr_utility.set_location('p_create_date '||p_create_date,67);
4561: hr_utility.set_location('p_min_create_date '||p_min_create_date,68);
4562: end if;
4563: else
4564: p_create_date := null;
4557: p_allow_date_change := 'NO';
4558: if g_debug then
4559: hr_utility.set_location('l_txn_basis_change_date >= l_last_payroll_run_date l_last_change_date ',66);
4560: hr_utility.set_location('p_create_date '||p_create_date,67);
4561: hr_utility.set_location('p_min_create_date '||p_min_create_date,68);
4562: end if;
4563: else
4564: p_create_date := null;
4565: if g_debug then
4562: end if;
4563: else
4564: p_create_date := null;
4565: if g_debug then
4566: hr_utility.set_location('p_create_date is set to null ', 69);
4567: end if;
4568: end if;
4569: end if;
4570: --
4573: if (l_last_change_date = l_last_assignment_change_date) then
4574: --p_allow_basis_change := 'NO';
4575:
4576: if g_debug then
4577: hr_utility.set_location('AST_SAL_BASIS_CHG_EXISTS', 70);
4578: end if;
4579:
4580: if (l_last_payroll_run_date > l_last_change_date) then
4581:
4582: if(l_payroll_attached = 'NO') then
4583: p_create_date := p_effective_date;
4584: p_min_create_date := l_last_change_date;
4585: if g_debug then
4586: hr_utility.set_location('p_create_date '||p_create_date,71);
4587: hr_utility.set_location('p_min_create_date '||p_min_create_date,72);
4588: end if;
4589: else
4590: Open csr_get_next_payroll_date(p_assignment_id,l_last_payroll_run_date);
4583: p_create_date := p_effective_date;
4584: p_min_create_date := l_last_change_date;
4585: if g_debug then
4586: hr_utility.set_location('p_create_date '||p_create_date,71);
4587: hr_utility.set_location('p_min_create_date '||p_min_create_date,72);
4588: end if;
4589: else
4590: Open csr_get_next_payroll_date(p_assignment_id,l_last_payroll_run_date);
4591: Fetch csr_get_next_payroll_date into p_create_date;
4591: Fetch csr_get_next_payroll_date into p_create_date;
4592: Close csr_get_next_payroll_date;
4593: p_min_create_date := l_last_payroll_run_date;
4594: if g_debug then
4595: hr_utility.set_location('p_create_date '||p_create_date,73);
4596: hr_utility.set_location('p_min_create_date '||p_min_create_date,74);
4597: end if;
4598: end if;
4599:
4592: Close csr_get_next_payroll_date;
4593: p_min_create_date := l_last_payroll_run_date;
4594: if g_debug then
4595: hr_utility.set_location('p_create_date '||p_create_date,73);
4596: hr_utility.set_location('p_min_create_date '||p_min_create_date,74);
4597: end if;
4598: end if;
4599:
4600: elsif (l_last_payroll_run_date = l_last_change_date) then
4602: if(l_payroll_attached = 'NO' and l_proposals_exists = 'YES') then
4603: p_create_date := l_last_change_date+1;
4604: p_min_create_date := l_last_change_date;
4605: if g_debug then
4606: hr_utility.set_location('p_create_date '||p_create_date,75);
4607: hr_utility.set_location('p_min_create_date '||p_min_create_date,76);
4608: end if;
4609: elsif(l_payroll_attached = 'NO' and l_proposals_exists = 'NO') then
4610: p_create_date := p_effective_date;
4603: p_create_date := l_last_change_date+1;
4604: p_min_create_date := l_last_change_date;
4605: if g_debug then
4606: hr_utility.set_location('p_create_date '||p_create_date,75);
4607: hr_utility.set_location('p_min_create_date '||p_min_create_date,76);
4608: end if;
4609: elsif(l_payroll_attached = 'NO' and l_proposals_exists = 'NO') then
4610: p_create_date := p_effective_date;
4611: p_min_create_date := p_effective_date;
4609: elsif(l_payroll_attached = 'NO' and l_proposals_exists = 'NO') then
4610: p_create_date := p_effective_date;
4611: p_min_create_date := p_effective_date;
4612: if g_debug then
4613: hr_utility.set_location('p_create_date '||p_create_date,77);
4614: hr_utility.set_location('p_min_create_date '||p_min_create_date,78);
4615: end if;
4616: else
4617: Open csr_get_next_payroll_date(p_assignment_id,l_last_payroll_run_date);
4610: p_create_date := p_effective_date;
4611: p_min_create_date := p_effective_date;
4612: if g_debug then
4613: hr_utility.set_location('p_create_date '||p_create_date,77);
4614: hr_utility.set_location('p_min_create_date '||p_min_create_date,78);
4615: end if;
4616: else
4617: Open csr_get_next_payroll_date(p_assignment_id,l_last_payroll_run_date);
4618: Fetch csr_get_next_payroll_date into p_create_date;
4618: Fetch csr_get_next_payroll_date into p_create_date;
4619: Close csr_get_next_payroll_date;
4620: p_min_create_date := l_last_change_date;
4621: if g_debug then
4622: hr_utility.set_location('p_create_date '||p_create_date,79);
4623: hr_utility.set_location('p_min_create_date '||p_min_create_date,80);
4624: end if;
4625: end if;
4626:
4619: Close csr_get_next_payroll_date;
4620: p_min_create_date := l_last_change_date;
4621: if g_debug then
4622: hr_utility.set_location('p_create_date '||p_create_date,79);
4623: hr_utility.set_location('p_min_create_date '||p_min_create_date,80);
4624: end if;
4625: end if;
4626:
4627: elsif (l_last_payroll_run_date < l_last_change_date) then
4629: if(l_payroll_attached = 'NO') then
4630: p_create_date := l_last_change_date+1;
4631: p_min_create_date := l_last_change_date;
4632: if g_debug then
4633: hr_utility.set_location('p_create_date '||p_create_date,83);
4634: hr_utility.set_location('p_min_create_date '||p_min_create_date,84);
4635: end if;
4636: else
4637: Open csr_get_next_payroll_date(p_assignment_id,l_last_change_date);
4630: p_create_date := l_last_change_date+1;
4631: p_min_create_date := l_last_change_date;
4632: if g_debug then
4633: hr_utility.set_location('p_create_date '||p_create_date,83);
4634: hr_utility.set_location('p_min_create_date '||p_min_create_date,84);
4635: end if;
4636: else
4637: Open csr_get_next_payroll_date(p_assignment_id,l_last_change_date);
4638: Fetch csr_get_next_payroll_date into p_create_date;
4638: Fetch csr_get_next_payroll_date into p_create_date;
4639: Close csr_get_next_payroll_date;
4640: p_min_create_date := l_last_change_date;
4641: if g_debug then
4642: hr_utility.set_location('p_create_date '||p_create_date,87);
4643: hr_utility.set_location('p_min_create_date '||p_min_create_date,88);
4644: end if;
4645: end if;
4646:
4639: Close csr_get_next_payroll_date;
4640: p_min_create_date := l_last_change_date;
4641: if g_debug then
4642: hr_utility.set_location('p_create_date '||p_create_date,87);
4643: hr_utility.set_location('p_min_create_date '||p_min_create_date,88);
4644: end if;
4645: end if;
4646:
4647: end if;
4660: p_create_date := l_last_assignment_change_date;
4661: p_min_create_date := l_txn_basis_change_date;
4662: p_allow_date_change := 'NO';
4663: if g_debug then
4664: hr_utility.set_location('l_last_assignment_change_date > l_last_payroll_run_date ',90);
4665: hr_utility.set_location('p_create_date '||p_create_date,95);
4666: hr_utility.set_location('p_min_create_date '||p_min_create_date,96);
4667: end if;
4668: else
4661: p_min_create_date := l_txn_basis_change_date;
4662: p_allow_date_change := 'NO';
4663: if g_debug then
4664: hr_utility.set_location('l_last_assignment_change_date > l_last_payroll_run_date ',90);
4665: hr_utility.set_location('p_create_date '||p_create_date,95);
4666: hr_utility.set_location('p_min_create_date '||p_min_create_date,96);
4667: end if;
4668: else
4669: p_create_date := null;
4662: p_allow_date_change := 'NO';
4663: if g_debug then
4664: hr_utility.set_location('l_last_assignment_change_date > l_last_payroll_run_date ',90);
4665: hr_utility.set_location('p_create_date '||p_create_date,95);
4666: hr_utility.set_location('p_min_create_date '||p_min_create_date,96);
4667: end if;
4668: else
4669: p_create_date := null;
4670: if g_debug then
4667: end if;
4668: else
4669: p_create_date := null;
4670: if g_debug then
4671: hr_utility.set_location('p_create_date is set null ', 100);
4672: end if;
4673: end if;
4674: end if;
4675: --
4675: --
4676: --
4677: else
4678: if g_debug then
4679: hr_utility.set_location('NO_SAL_BASIS_CHG ', 101);
4680: end if;
4681: p_allow_basis_change := 'YES';
4682:
4683: if (l_last_payroll_run_date > l_last_change_date) then
4685: if(l_payroll_attached = 'NO') then
4686: p_create_date := p_effective_date;
4687: p_min_create_date := l_last_change_date;
4688: if g_debug then
4689: hr_utility.set_location('p_create_date: '||p_create_date, 101);
4690: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 102);
4691: end if;
4692: else
4693: Open csr_get_next_payroll_date(p_assignment_id,l_last_payroll_run_date);
4686: p_create_date := p_effective_date;
4687: p_min_create_date := l_last_change_date;
4688: if g_debug then
4689: hr_utility.set_location('p_create_date: '||p_create_date, 101);
4690: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 102);
4691: end if;
4692: else
4693: Open csr_get_next_payroll_date(p_assignment_id,l_last_payroll_run_date);
4694: Fetch csr_get_next_payroll_date into p_create_date;
4694: Fetch csr_get_next_payroll_date into p_create_date;
4695: Close csr_get_next_payroll_date;
4696: p_min_create_date := l_last_payroll_run_date;
4697: if g_debug then
4698: hr_utility.set_location('p_create_date: '||p_create_date, 103);
4699: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 104);
4700: end if;
4701: end if;
4702:
4695: Close csr_get_next_payroll_date;
4696: p_min_create_date := l_last_payroll_run_date;
4697: if g_debug then
4698: hr_utility.set_location('p_create_date: '||p_create_date, 103);
4699: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 104);
4700: end if;
4701: end if;
4702:
4703: elsif (l_last_payroll_run_date = l_last_change_date) then
4705: if(l_payroll_attached = 'NO' and l_proposals_exists = 'YES' ) then
4706: p_create_date := l_last_change_date+1;
4707: p_min_create_date := p_effective_date;
4708: if g_debug then
4709: hr_utility.set_location('p_create_date: '||p_create_date, 105);
4710: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 106);
4711: end if;
4712: elsif(l_payroll_attached = 'NO' and l_proposals_exists = 'NO') then
4713: p_create_date := p_effective_date;
4706: p_create_date := l_last_change_date+1;
4707: p_min_create_date := p_effective_date;
4708: if g_debug then
4709: hr_utility.set_location('p_create_date: '||p_create_date, 105);
4710: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 106);
4711: end if;
4712: elsif(l_payroll_attached = 'NO' and l_proposals_exists = 'NO') then
4713: p_create_date := p_effective_date;
4714: p_min_create_date := p_effective_date;
4712: elsif(l_payroll_attached = 'NO' and l_proposals_exists = 'NO') then
4713: p_create_date := p_effective_date;
4714: p_min_create_date := p_effective_date;
4715: if g_debug then
4716: hr_utility.set_location('p_create_date '||p_create_date,107);
4717: hr_utility.set_location('p_min_create_date '||p_min_create_date,108);
4718: end if;
4719: else
4720: Open csr_get_next_payroll_date(p_assignment_id,l_last_change_date);
4713: p_create_date := p_effective_date;
4714: p_min_create_date := p_effective_date;
4715: if g_debug then
4716: hr_utility.set_location('p_create_date '||p_create_date,107);
4717: hr_utility.set_location('p_min_create_date '||p_min_create_date,108);
4718: end if;
4719: else
4720: Open csr_get_next_payroll_date(p_assignment_id,l_last_change_date);
4721: Fetch csr_get_next_payroll_date into p_create_date;
4721: Fetch csr_get_next_payroll_date into p_create_date;
4722: Close csr_get_next_payroll_date;
4723: p_min_create_date := l_last_change_date+1;
4724: if g_debug then
4725: hr_utility.set_location('p_create_date: '||p_create_date, 109);
4726: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 110);
4727: end if;
4728: end if;
4729:
4722: Close csr_get_next_payroll_date;
4723: p_min_create_date := l_last_change_date+1;
4724: if g_debug then
4725: hr_utility.set_location('p_create_date: '||p_create_date, 109);
4726: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 110);
4727: end if;
4728: end if;
4729:
4730: elsif (l_last_payroll_run_date < l_last_change_date) then
4732: if(l_payroll_attached = 'NO') then
4733: p_create_date := l_last_change_date+1;
4734: p_min_create_date := l_last_change_date;
4735: if g_debug then
4736: hr_utility.set_location('p_create_date: '||p_create_date, 111);
4737: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 112);
4738: end if;
4739: else
4740: Open csr_get_next_payroll_date(p_assignment_id,l_last_change_date);
4733: p_create_date := l_last_change_date+1;
4734: p_min_create_date := l_last_change_date;
4735: if g_debug then
4736: hr_utility.set_location('p_create_date: '||p_create_date, 111);
4737: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 112);
4738: end if;
4739: else
4740: Open csr_get_next_payroll_date(p_assignment_id,l_last_change_date);
4741: Fetch csr_get_next_payroll_date into p_create_date;
4741: Fetch csr_get_next_payroll_date into p_create_date;
4742: Close csr_get_next_payroll_date;
4743: p_min_create_date := l_last_change_date;
4744: if g_debug then
4745: hr_utility.set_location('p_create_date: '||p_create_date, 117);
4746: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 118);
4747: end if;
4748: end if;
4749:
4742: Close csr_get_next_payroll_date;
4743: p_min_create_date := l_last_change_date;
4744: if g_debug then
4745: hr_utility.set_location('p_create_date: '||p_create_date, 117);
4746: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 118);
4747: end if;
4748: end if;
4749:
4750: end if;
4775: end if;
4776: --
4777: --
4778: if g_debug then
4779: hr_utility.set_location('csr_pay_basis_exists : '||l_pay_basis_id, 120);
4780: hr_utility.set_location('p_allow_create : '||p_allow_create, 121);
4781: end if;
4782: --
4783: --
4776: --
4777: --
4778: if g_debug then
4779: hr_utility.set_location('csr_pay_basis_exists : '||l_pay_basis_id, 120);
4780: hr_utility.set_location('p_allow_create : '||p_allow_create, 121);
4781: end if;
4782: --
4783: --
4784: if l_default_txn_salary_basis_id is not null then
4783: --
4784: if l_default_txn_salary_basis_id is not null then
4785: p_default_salary_basis_id := l_default_txn_salary_basis_id;
4786: if g_debug then
4787: hr_utility.set_location('l_default_txn_salary_basis_id is not null ', 122);
4788: end if;
4789: elsif l_default_asst_salary_basis_id is not null then
4790: p_default_salary_basis_id := l_default_asst_salary_basis_id;
4791: if g_debug then
4788: end if;
4789: elsif l_default_asst_salary_basis_id is not null then
4790: p_default_salary_basis_id := l_default_asst_salary_basis_id;
4791: if g_debug then
4792: hr_utility.set_location('l_default_asst_salary_basis_id is not null ', 124);
4793: end if;
4794: end if;
4795: --
4796: --
4799: Open csr_curr_asst_change_date(p_create_date);
4800: Fetch csr_curr_asst_change_date into p_min_create_date;
4801: Close csr_curr_asst_change_date;
4802: if g_debug then
4803: hr_utility.set_location('p_min_create_date is not null '||p_min_create_date, 130);
4804: end if;
4805: else
4806: p_min_create_date := l_last_payroll_run_date;
4807: if g_debug then
4804: end if;
4805: else
4806: p_min_create_date := l_last_payroll_run_date;
4807: if g_debug then
4808: hr_utility.set_location('p_min_create_date is not null '||p_min_create_date, 140);
4809: end if;
4810: end if;
4811: end if;
4812: --
4811: end if;
4812: --
4813: --
4814: if g_debug then
4815: hr_utility.set_location('Leaving: '||'get_Create_Date', 150);
4816: end if;
4817: --
4818: --
4819: End get_Create_Date_old;
4960: l_payroll_attached := 'NO';
4961: end if;
4962: --
4963: if g_debug then
4964: hr_utility.set_location('get_update_param ', 5);
4965: hr_utility.set_location('l_payroll_attached '||l_payroll_attached, 10);
4966: hr_utility.set_location('l_last_payroll_run_date: '||l_last_payroll_run_date, 15);
4967: end if;
4968: l_max_create_date := p_previous_date;
4961: end if;
4962: --
4963: if g_debug then
4964: hr_utility.set_location('get_update_param ', 5);
4965: hr_utility.set_location('l_payroll_attached '||l_payroll_attached, 10);
4966: hr_utility.set_location('l_last_payroll_run_date: '||l_last_payroll_run_date, 15);
4967: end if;
4968: l_max_create_date := p_previous_date;
4969: l_min_create_date := p_previous_date;
4962: --
4963: if g_debug then
4964: hr_utility.set_location('get_update_param ', 5);
4965: hr_utility.set_location('l_payroll_attached '||l_payroll_attached, 10);
4966: hr_utility.set_location('l_last_payroll_run_date: '||l_last_payroll_run_date, 15);
4967: end if;
4968: l_max_create_date := p_previous_date;
4969: l_min_create_date := p_previous_date;
4970: l_max_create_date_src := 'EFFECTIVEDATE';
4995:
4996: p_min_update_date := l_min_create_date;
4997:
4998: if g_debug then
4999: hr_utility.set_location('l_max_create_date '||l_max_create_date, 25);
5000: hr_utility.set_location('p_current_date: '||p_current_date, 26);
5001: hr_utility.set_location('l_min_create_date: '||l_min_create_date, 30);
5002: hr_utility.set_location('l_max_create_date_src: '||l_max_create_date_src, 31);
5003:
4996: p_min_update_date := l_min_create_date;
4997:
4998: if g_debug then
4999: hr_utility.set_location('l_max_create_date '||l_max_create_date, 25);
5000: hr_utility.set_location('p_current_date: '||p_current_date, 26);
5001: hr_utility.set_location('l_min_create_date: '||l_min_create_date, 30);
5002: hr_utility.set_location('l_max_create_date_src: '||l_max_create_date_src, 31);
5003:
5004: end if;
4997:
4998: if g_debug then
4999: hr_utility.set_location('l_max_create_date '||l_max_create_date, 25);
5000: hr_utility.set_location('p_current_date: '||p_current_date, 26);
5001: hr_utility.set_location('l_min_create_date: '||l_min_create_date, 30);
5002: hr_utility.set_location('l_max_create_date_src: '||l_max_create_date_src, 31);
5003:
5004: end if;
5005: --
4998: if g_debug then
4999: hr_utility.set_location('l_max_create_date '||l_max_create_date, 25);
5000: hr_utility.set_location('p_current_date: '||p_current_date, 26);
5001: hr_utility.set_location('l_min_create_date: '||l_min_create_date, 30);
5002: hr_utility.set_location('l_max_create_date_src: '||l_max_create_date_src, 31);
5003:
5004: end if;
5005: --
5006: Open csr_asst_change_date(l_max_create_date);
5022: Close csr_txn_basis_change_date;
5023: --
5024: if (l_txn_asst_change_date is not null and l_txn_asst_change_date = p_current_date and l_asst_change_date is not null) then
5025: if g_debug then
5026: hr_utility.set_location('l_txn_asst_change_date '||l_txn_asst_change_date, 32);
5027: end if;
5028: l_txn_asst_change_date := null;
5029: end if;
5030:
5029: end if;
5030:
5031: if (l_txn_basis_change_date is not null and l_txn_basis_change_date = p_current_date) then
5032: if g_debug then
5033: hr_utility.set_location('l_txn_asst_change_date '||l_txn_asst_change_date, 33);
5034: end if;
5035: l_txn_basis_change_date := null;
5036: end if;
5037: --
5035: l_txn_basis_change_date := null;
5036: end if;
5037: --
5038: if g_debug then
5039: hr_utility.set_location('l_asst_change_date '||l_asst_change_date, 36);
5040: hr_utility.set_location('l_asst_basis_change_date: '||l_asst_basis_change_date, 37);
5041: hr_utility.set_location('l_txn_asst_change_date: '||l_txn_asst_change_date, 38);
5042: hr_utility.set_location('l_txn_basis_change_date: '||l_txn_basis_change_date, 39);
5043: end if;
5036: end if;
5037: --
5038: if g_debug then
5039: hr_utility.set_location('l_asst_change_date '||l_asst_change_date, 36);
5040: hr_utility.set_location('l_asst_basis_change_date: '||l_asst_basis_change_date, 37);
5041: hr_utility.set_location('l_txn_asst_change_date: '||l_txn_asst_change_date, 38);
5042: hr_utility.set_location('l_txn_basis_change_date: '||l_txn_basis_change_date, 39);
5043: end if;
5044: --
5037: --
5038: if g_debug then
5039: hr_utility.set_location('l_asst_change_date '||l_asst_change_date, 36);
5040: hr_utility.set_location('l_asst_basis_change_date: '||l_asst_basis_change_date, 37);
5041: hr_utility.set_location('l_txn_asst_change_date: '||l_txn_asst_change_date, 38);
5042: hr_utility.set_location('l_txn_basis_change_date: '||l_txn_basis_change_date, 39);
5043: end if;
5044: --
5045: if (l_txn_basis_change_date is not null and l_asst_basis_change_date is null) then
5038: if g_debug then
5039: hr_utility.set_location('l_asst_change_date '||l_asst_change_date, 36);
5040: hr_utility.set_location('l_asst_basis_change_date: '||l_asst_basis_change_date, 37);
5041: hr_utility.set_location('l_txn_asst_change_date: '||l_txn_asst_change_date, 38);
5042: hr_utility.set_location('l_txn_basis_change_date: '||l_txn_basis_change_date, 39);
5043: end if;
5044: --
5045: if (l_txn_basis_change_date is not null and l_asst_basis_change_date is null) then
5046: if (l_csr_asst_chg_count = 0 and
5050: p_allow_basis_change := 'YES';
5051: p_allow_date_change := 'YES';
5052: p_status := 1;
5053: if g_debug then
5054: hr_utility.set_location('p_min_update_date '||p_min_update_date, 40);
5055: hr_utility.set_location('p_allow_basis_change '||p_allow_basis_change, 50);
5056: hr_utility.set_location('p_allow_date_change '||p_allow_date_change, 51);
5057: end if;
5058: end if;
5051: p_allow_date_change := 'YES';
5052: p_status := 1;
5053: if g_debug then
5054: hr_utility.set_location('p_min_update_date '||p_min_update_date, 40);
5055: hr_utility.set_location('p_allow_basis_change '||p_allow_basis_change, 50);
5056: hr_utility.set_location('p_allow_date_change '||p_allow_date_change, 51);
5057: end if;
5058: end if;
5059: end if;
5052: p_status := 1;
5053: if g_debug then
5054: hr_utility.set_location('p_min_update_date '||p_min_update_date, 40);
5055: hr_utility.set_location('p_allow_basis_change '||p_allow_basis_change, 50);
5056: hr_utility.set_location('p_allow_date_change '||p_allow_date_change, 51);
5057: end if;
5058: end if;
5059: end if;
5060: --
5065: p_allow_basis_change := 'NO';
5066: p_allow_date_change := 'YES';
5067: p_status := 1;
5068: if g_debug then
5069: hr_utility.set_location('p_allow_date_change '||p_allow_date_change, 50);
5070: hr_utility.set_location('p_allow_basis_change '||p_allow_basis_change, 60);
5071: end if;
5072: end if;
5073: end if;
5066: p_allow_date_change := 'YES';
5067: p_status := 1;
5068: if g_debug then
5069: hr_utility.set_location('p_allow_date_change '||p_allow_date_change, 50);
5070: hr_utility.set_location('p_allow_basis_change '||p_allow_basis_change, 60);
5071: end if;
5072: end if;
5073: end if;
5074: --
5080: p_allow_basis_change := 'YES';
5081: p_allow_date_change := 'YES';
5082: p_status := 2;
5083: if g_debug then
5084: hr_utility.set_location('p_min_update_date '||p_min_update_date, 65);
5085: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 70);
5086: hr_utility.set_location('p_basis_default_min_date '||p_basis_default_min_date, 71);
5087: hr_utility.set_location('p_allow_basis_change '||p_allow_basis_change, 72);
5088: end if;
5081: p_allow_date_change := 'YES';
5082: p_status := 2;
5083: if g_debug then
5084: hr_utility.set_location('p_min_update_date '||p_min_update_date, 65);
5085: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 70);
5086: hr_utility.set_location('p_basis_default_min_date '||p_basis_default_min_date, 71);
5087: hr_utility.set_location('p_allow_basis_change '||p_allow_basis_change, 72);
5088: end if;
5089: end if;
5082: p_status := 2;
5083: if g_debug then
5084: hr_utility.set_location('p_min_update_date '||p_min_update_date, 65);
5085: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 70);
5086: hr_utility.set_location('p_basis_default_min_date '||p_basis_default_min_date, 71);
5087: hr_utility.set_location('p_allow_basis_change '||p_allow_basis_change, 72);
5088: end if;
5089: end if;
5090: end if;
5083: if g_debug then
5084: hr_utility.set_location('p_min_update_date '||p_min_update_date, 65);
5085: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 70);
5086: hr_utility.set_location('p_basis_default_min_date '||p_basis_default_min_date, 71);
5087: hr_utility.set_location('p_allow_basis_change '||p_allow_basis_change, 72);
5088: end if;
5089: end if;
5090: end if;
5091: --
5097: p_allow_basis_change := 'YES';
5098: p_allow_date_change := 'YES';
5099: p_status := 3;
5100: if g_debug then
5101: hr_utility.set_location('p_min_update_date '||p_min_update_date, 75);
5102: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 80);
5103: hr_utility.set_location('p_basis_default_min_date '||p_basis_default_min_date, 81);
5104: end if;
5105: end if;
5098: p_allow_date_change := 'YES';
5099: p_status := 3;
5100: if g_debug then
5101: hr_utility.set_location('p_min_update_date '||p_min_update_date, 75);
5102: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 80);
5103: hr_utility.set_location('p_basis_default_min_date '||p_basis_default_min_date, 81);
5104: end if;
5105: end if;
5106: --
5099: p_status := 3;
5100: if g_debug then
5101: hr_utility.set_location('p_min_update_date '||p_min_update_date, 75);
5102: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 80);
5103: hr_utility.set_location('p_basis_default_min_date '||p_basis_default_min_date, 81);
5104: end if;
5105: end if;
5106: --
5107: if ((l_asst_basis_change_date is null and l_asst_change_date is not null)
5112: p_allow_basis_change := 'YES';
5113: p_allow_date_change := 'YES';
5114: p_status := 4;
5115: if g_debug then
5116: hr_utility.set_location('p_min_update_date '||p_min_update_date, 85);
5117: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 90);
5118: hr_utility.set_location('p_basis_default_min_date '||p_basis_default_min_date, 91);
5119: end if;
5120: end if;
5113: p_allow_date_change := 'YES';
5114: p_status := 4;
5115: if g_debug then
5116: hr_utility.set_location('p_min_update_date '||p_min_update_date, 85);
5117: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 90);
5118: hr_utility.set_location('p_basis_default_min_date '||p_basis_default_min_date, 91);
5119: end if;
5120: end if;
5121: --
5114: p_status := 4;
5115: if g_debug then
5116: hr_utility.set_location('p_min_update_date '||p_min_update_date, 85);
5117: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 90);
5118: hr_utility.set_location('p_basis_default_min_date '||p_basis_default_min_date, 91);
5119: end if;
5120: end if;
5121: --
5122: if ((l_asst_basis_change_date is null and l_asst_change_date is not null)
5128: p_allow_basis_change := 'YES';
5129: p_allow_date_change := 'YES';
5130: p_status := 4;
5131: if g_debug then
5132: hr_utility.set_location('p_min_update_date '||p_min_update_date, 95);
5133: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 100);
5134: end if;
5135: end if;
5136: --
5129: p_allow_date_change := 'YES';
5130: p_status := 4;
5131: if g_debug then
5132: hr_utility.set_location('p_min_update_date '||p_min_update_date, 95);
5133: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 100);
5134: end if;
5135: end if;
5136: --
5137: if ((l_asst_basis_change_date is null and l_asst_change_date is not null)
5143: p_allow_basis_change := 'NO';
5144: p_allow_date_change := 'YES';
5145: p_status := 4;
5146: if g_debug then
5147: hr_utility.set_location('p_min_update_date '||p_min_update_date, 105);
5148: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 100);
5149: hr_utility.set_location('p_basis_default_min_date '||p_basis_default_min_date, 101);
5150: end if;
5151: end if;
5144: p_allow_date_change := 'YES';
5145: p_status := 4;
5146: if g_debug then
5147: hr_utility.set_location('p_min_update_date '||p_min_update_date, 105);
5148: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 100);
5149: hr_utility.set_location('p_basis_default_min_date '||p_basis_default_min_date, 101);
5150: end if;
5151: end if;
5152: --
5145: p_status := 4;
5146: if g_debug then
5147: hr_utility.set_location('p_min_update_date '||p_min_update_date, 105);
5148: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 100);
5149: hr_utility.set_location('p_basis_default_min_date '||p_basis_default_min_date, 101);
5150: end if;
5151: end if;
5152: --
5153: if (l_asst_basis_change_date is not null and l_txn_basis_change_date is null) then
5157: p_allow_basis_change := 'NO';
5158: p_allow_date_change := 'NO';
5159: p_status := 0;
5160: if g_debug then
5161: hr_utility.set_location('p_min_update_date '||p_min_update_date, 115);
5162: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 120);
5163: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 121);
5164: end if;
5165: end if;
5158: p_allow_date_change := 'NO';
5159: p_status := 0;
5160: if g_debug then
5161: hr_utility.set_location('p_min_update_date '||p_min_update_date, 115);
5162: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 120);
5163: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 121);
5164: end if;
5165: end if;
5166: end if;
5159: p_status := 0;
5160: if g_debug then
5161: hr_utility.set_location('p_min_update_date '||p_min_update_date, 115);
5162: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 120);
5163: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 121);
5164: end if;
5165: end if;
5166: end if;
5167: --
5279: --
5280: BEGIN
5281: --
5282: if g_debug then
5283: hr_utility.set_location('get_fte_factor ', 5);
5284: end if;
5285:
5286: if (l_fte_profile_value = 'NHBGWH') then
5287: open get_asg_hours;
5324: close get_pos_hrs;
5325: end if;
5326:
5327: if (l_hours is null or l_frequency is null or l_org_id is not null ) then
5328: hr_utility.set_location('-1-', 20);
5329: open get_org_hrs(l_org_id);
5330: fetch get_org_hrs into l_hours, l_frequency;
5331: close get_org_hrs;
5332: end if;
5331: close get_org_hrs;
5332: end if;
5333:
5334: if (l_hours is null or l_frequency is null or l_bg_id is not null) then
5335: hr_utility.set_location('-2-', 20);
5336: open get_bus_hrs(l_bg_id);
5337: fetch get_bus_hrs into l_hours, l_frequency;
5338: close get_bus_hrs;
5339: end if;