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.PQH_APPLY_BUDGET dependencies on PQH_WORKSHEET_DETAILS

Line 46: FROM pqh_worksheet_details

42:
43:
44: CURSOR csr_wkd IS
45: SELECT *
46: FROM pqh_worksheet_details
47: WHERE worksheet_id = p_worksheet_id
48: and parent_worksheet_detail_id is null;
49:
50: l_wkd_rec pqh_worksheet_details%ROWTYPE;

Line 50: l_wkd_rec pqh_worksheet_details%ROWTYPE;

46: FROM pqh_worksheet_details
47: WHERE worksheet_id = p_worksheet_id
48: and parent_worksheet_detail_id is null;
49:
50: l_wkd_rec pqh_worksheet_details%ROWTYPE;
51: l_wkd_ovn pqh_worksheet_details.object_version_number%TYPE;
52: BEGIN
53: hr_utility.set_location('Entering:'||l_proc, 5);
54: open csr_wkd;

Line 51: l_wkd_ovn pqh_worksheet_details.object_version_number%TYPE;

47: WHERE worksheet_id = p_worksheet_id
48: and parent_worksheet_detail_id is null;
49:
50: l_wkd_rec pqh_worksheet_details%ROWTYPE;
51: l_wkd_ovn pqh_worksheet_details.object_version_number%TYPE;
52: BEGIN
53: hr_utility.set_location('Entering:'||l_proc, 5);
54: open csr_wkd;
55: fetch csr_wkd into l_wkd_rec;

Line 58: pqh_worksheet_details_api.update_worksheet_detail(

54: open csr_wkd;
55: fetch csr_wkd into l_wkd_rec;
56: CLOSE csr_wkd;
57: l_wkd_ovn := l_wkd_rec.object_version_number;
58: pqh_worksheet_details_api.update_worksheet_detail(
59: p_validate => false
60: ,p_worksheet_detail_id => l_wkd_rec.worksheet_detail_id
61: ,p_object_version_number => l_wkd_ovn
62: ,p_status => p_status

Line 255: CURSOR pqh_worksheet_details_cur (p_worksheet_id IN pqh_worksheets.worksheet_id%TYPE) IS

251: SELECT *
252: FROM pqh_worksheets
253: WHERE worksheet_id = p_worksheet_id;
254:
255: CURSOR pqh_worksheet_details_cur (p_worksheet_id IN pqh_worksheets.worksheet_id%TYPE) IS
256: SELECT *
257: FROM pqh_worksheet_details
258: WHERE worksheet_id = p_worksheet_id
259: AND NVL(action_cd,'X') = 'B' ;

Line 257: FROM pqh_worksheet_details

253: WHERE worksheet_id = p_worksheet_id;
254:
255: CURSOR pqh_worksheet_details_cur (p_worksheet_id IN pqh_worksheets.worksheet_id%TYPE) IS
256: SELECT *
257: FROM pqh_worksheet_details
258: WHERE worksheet_id = p_worksheet_id
259: AND NVL(action_cd,'X') = 'B' ;
260:
261: CURSOR pqh_worksheet_periods_cur (p_worksheet_detail_id IN pqh_worksheet_details.worksheet_detail_id%TYPE) IS

Line 261: CURSOR pqh_worksheet_periods_cur (p_worksheet_detail_id IN pqh_worksheet_details.worksheet_detail_id%TYPE) IS

257: FROM pqh_worksheet_details
258: WHERE worksheet_id = p_worksheet_id
259: AND NVL(action_cd,'X') = 'B' ;
260:
261: CURSOR pqh_worksheet_periods_cur (p_worksheet_detail_id IN pqh_worksheet_details.worksheet_detail_id%TYPE) IS
262: SELECT *
263: FROM pqh_worksheet_periods
264: WHERE worksheet_detail_id = p_worksheet_detail_id;
265:

Line 291: l_pqh_worksheet_details_rec pqh_worksheet_details%ROWTYPE;

287:
288: l_proc varchar2(72) := g_package||'apply_new_budget';
289: l_pqh_worksheets_rec pqh_worksheets%ROWTYPE;
290: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
291: l_pqh_worksheet_details_rec pqh_worksheet_details%ROWTYPE;
292: l_budget_detail_id pqh_budget_details.budget_detail_id%TYPE;
293: l_pqh_worksheet_periods_rec pqh_worksheet_periods%ROWTYPE;
294: l_budget_period_id pqh_budget_periods.budget_period_id%TYPE;
295: l_pqh_worksheet_budget_set_rec pqh_worksheet_budget_sets%ROWTYPE;

Line 341: -- open pqh_worksheet_details_cur

337:
338: hr_utility.set_location('Budget Version: '||g_budget_version_id, 6);
339:
340:
341: -- open pqh_worksheet_details_cur
342: OPEN pqh_worksheet_details_cur(p_worksheet_id => l_pqh_worksheets_rec.worksheet_id );
343: LOOP -- loop 2
344: FETCH pqh_worksheet_details_cur INTO l_pqh_worksheet_details_rec;
345: EXIT WHEN pqh_worksheet_details_cur%NOTFOUND;

Line 342: OPEN pqh_worksheet_details_cur(p_worksheet_id => l_pqh_worksheets_rec.worksheet_id );

338: hr_utility.set_location('Budget Version: '||g_budget_version_id, 6);
339:
340:
341: -- open pqh_worksheet_details_cur
342: OPEN pqh_worksheet_details_cur(p_worksheet_id => l_pqh_worksheets_rec.worksheet_id );
343: LOOP -- loop 2
344: FETCH pqh_worksheet_details_cur INTO l_pqh_worksheet_details_rec;
345: EXIT WHEN pqh_worksheet_details_cur%NOTFOUND;
346:

Line 344: FETCH pqh_worksheet_details_cur INTO l_pqh_worksheet_details_rec;

340:
341: -- open pqh_worksheet_details_cur
342: OPEN pqh_worksheet_details_cur(p_worksheet_id => l_pqh_worksheets_rec.worksheet_id );
343: LOOP -- loop 2
344: FETCH pqh_worksheet_details_cur INTO l_pqh_worksheet_details_rec;
345: EXIT WHEN pqh_worksheet_details_cur%NOTFOUND;
346:
347: -- get log_context
348: set_wks_log_context

Line 345: EXIT WHEN pqh_worksheet_details_cur%NOTFOUND;

341: -- open pqh_worksheet_details_cur
342: OPEN pqh_worksheet_details_cur(p_worksheet_id => l_pqh_worksheets_rec.worksheet_id );
343: LOOP -- loop 2
344: FETCH pqh_worksheet_details_cur INTO l_pqh_worksheet_details_rec;
345: EXIT WHEN pqh_worksheet_details_cur%NOTFOUND;
346:
347: -- get log_context
348: set_wks_log_context
349: (

Line 350: p_worksheet_detail_id => l_pqh_worksheet_details_rec.worksheet_detail_id,

346:
347: -- get log_context
348: set_wks_log_context
349: (
350: p_worksheet_detail_id => l_pqh_worksheet_details_rec.worksheet_detail_id,
351: p_log_context => l_log_context
352: );
353:
354: -- set the context

Line 357: p_txn_id => l_pqh_worksheet_details_rec.worksheet_detail_id,

353:
354: -- set the context
355: pqh_process_batch_log.set_context_level
356: (
357: p_txn_id => l_pqh_worksheet_details_rec.worksheet_detail_id,
358: p_txn_table_route_id => g_table_route_id_wdt,
359: p_level => 2,
360: p_log_context => l_log_context
361: );

Line 366: p_worksheet_details_rec => l_pqh_worksheet_details_rec,

362:
363: -- create records in pqh_budget_details
364: populate_budget_details
365: (
366: p_worksheet_details_rec => l_pqh_worksheet_details_rec,
367: p_budget_version_id => g_budget_version_id,
368: p_worksheet_id => l_pqh_worksheets_rec.worksheet_id,
369: p_worksheet_mode_cd => g_worksheet_mode_cd,
370: p_budget_detail_id_o => l_budget_detail_id

Line 374: OPEN pqh_worksheet_periods_cur(p_worksheet_detail_id => l_pqh_worksheet_details_rec.worksheet_detail_id);

370: p_budget_detail_id_o => l_budget_detail_id
371: );
372:
373: -- open pqh_worksheet_periods_cur
374: OPEN pqh_worksheet_periods_cur(p_worksheet_detail_id => l_pqh_worksheet_details_rec.worksheet_detail_id);
375: LOOP -- loop 3
376: FETCH pqh_worksheet_periods_cur INTO l_pqh_worksheet_periods_rec;
377: EXIT WHEN pqh_worksheet_periods_cur%NOTFOUND;
378:

Line 509: CLOSE pqh_worksheet_details_cur;

505: END LOOP; -- loop 3
506: CLOSE pqh_worksheet_periods_cur;
507:
508: END LOOP; -- loop 2
509: CLOSE pqh_worksheet_details_cur;
510:
511: END LOOP; -- loop 1
512: CLOSE pqh_worksheets_cur;
513:

Line 585: we pick budget_detail_id from pqh_worksheet_details table for this worksheet_id

581:
582: -- delete the rows from budget tables
583: /*
584: delete_child_rows
585: we pick budget_detail_id from pqh_worksheet_details table for this worksheet_id
586: and delete only those rows from pqh_budget_periods table onwards for the above
587: fetched budget_detail_id from pqh_worksheet_details table.
588: */
589: delete_child_rows

Line 587: fetched budget_detail_id from pqh_worksheet_details table.

583: /*
584: delete_child_rows
585: we pick budget_detail_id from pqh_worksheet_details table for this worksheet_id
586: and delete only those rows from pqh_budget_periods table onwards for the above
587: fetched budget_detail_id from pqh_worksheet_details table.
588: */
589: delete_child_rows
590: (
591: p_worksheet_id => p_worksheet_id

Line 640: FROM pqh_worksheet_details

636: CURSOR units_csr IS
637: SELECT sum(nvl(BUDGET_UNIT1_VALUE,0)) ,
638: sum(nvl(BUDGET_UNIT2_VALUE,0)) ,
639: sum(nvl(BUDGET_UNIT3_VALUE,0))
640: FROM pqh_worksheet_details
641: WHERE worksheet_id = p_worksheets_rec.worksheet_id
642: AND nvl(action_cd,'X') = 'B' ;
643:
644:

Line 791: p_worksheet_details_rec IN pqh_worksheet_details%ROWTYPE,

787: --------------------------------------------------------------------------------------------------------------
788:
789: PROCEDURE populate_budget_details
790: (
791: p_worksheet_details_rec IN pqh_worksheet_details%ROWTYPE,
792: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,
793: p_worksheet_id IN pqh_worksheets.worksheet_id%type,
794: p_worksheet_mode_cd IN pqh_worksheets.worksheet_mode_cd%TYPE,
795: p_budget_detail_id_o OUT NOCOPY pqh_budget_details.budget_detail_id%TYPE

Line 818: FROM pqh_worksheet_details

814: CURSOR units_csr IS
815: SELECT sum(nvl(BUDGET_UNIT1_VALUE,0)) ,
816: sum(nvl(BUDGET_UNIT2_VALUE,0)) ,
817: sum(nvl(BUDGET_UNIT3_VALUE,0))
818: FROM pqh_worksheet_details
819: WHERE worksheet_id = p_worksheet_id
820: AND nvl(action_cd,'X') = 'B' ;
821:
822: BEGIN

Line 1208: FROM pqh_worksheet_details

1204: SELECT *
1205: FROM pqh_budget_details
1206: WHERE budget_version_id = p_curr_budget_version_id
1207: AND budget_detail_id NOT IN ( SELECT budget_detail_id
1208: FROM pqh_worksheet_details
1209: WHERE worksheet_id = p_worksheet_id
1210: AND NVL(action_cd,'X') = 'B' ) ;
1211:
1212: CURSOR pqh_budget_periods_cur (p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE) IS

Line 1631: FROM pqh_worksheets wks, pqh_worksheet_details wdt ,pqh_budget_periods bpr

1627: -- local variables and cursors
1628:
1629: CURSOR budget_period_id_cur IS
1630: SELECT bpr.budget_period_id
1631: FROM pqh_worksheets wks, pqh_worksheet_details wdt ,pqh_budget_periods bpr
1632: WHERE wks.worksheet_id = wdt.worksheet_id
1633: AND wdt.action_cd = 'B'
1634: AND wdt.budget_detail_id = bpr.budget_detail_id
1635: AND wks.worksheet_id = p_worksheet_id;

Line 1640: pqh_worksheet_details wdt , pqh_worksheets wks

1636:
1637: CURSOR budget_set_id_cur IS
1638: SELECT bst.budget_set_id
1639: FROM pqh_budget_sets bst, pqh_budget_periods bpr, pqh_budget_details bdt,
1640: pqh_worksheet_details wdt , pqh_worksheets wks
1641: WHERE bst.budget_period_id = bpr.budget_period_id
1642: AND bpr.budget_detail_id = wdt.budget_detail_id
1643: AND wks.worksheet_id = wdt.worksheet_id
1644: AND wdt.action_cd = 'B'

Line 1651: pqh_worksheet_details wdt , pqh_worksheets wks

1647: CURSOR budget_element_id_cur IS
1648: SELECT bel.budget_element_id
1649: FROM pqh_budget_elements bel, pqh_budget_sets bst,
1650: pqh_budget_periods bpr,
1651: pqh_worksheet_details wdt , pqh_worksheets wks
1652: WHERE bel.budget_set_id = bst.budget_set_id
1653: AND bst.budget_period_id = bpr.budget_period_id
1654: AND bpr.budget_detail_id = wdt.budget_detail_id
1655: AND wks.worksheet_id = wdt.worksheet_id

Line 1663: pqh_worksheet_details wdt , pqh_worksheets wks

1659: CURSOR budget_fund_src_id_cur IS
1660: SELECT bfs.budget_fund_src_id
1661: FROM pqh_budget_fund_srcs bfs, pqh_budget_elements bel, pqh_budget_sets bst,
1662: pqh_budget_periods bpr,
1663: pqh_worksheet_details wdt , pqh_worksheets wks
1664: WHERE bfs.budget_element_id = bel.budget_element_id
1665: AND bel.budget_set_id = bst.budget_set_id
1666: AND bst.budget_period_id = bpr.budget_period_id
1667: AND bpr.budget_detail_id = wdt.budget_detail_id

Line 1733: FROM pqh_worksheet_details wdt , pqh_worksheets wks

1729:
1730: DELETE FROM pqh_budget_details
1731: WHERE budget_detail_id IN (
1732: SELECT wdt.budget_detail_id
1733: FROM pqh_worksheet_details wdt , pqh_worksheets wks
1734: WHERE wks.worksheet_id = wdt.worksheet_id
1735: AND wdt.budget_detail_id IS NOT NULL
1736: AND NVL(wdt.action_cd,'X') = 'B'
1737: AND wks.worksheet_id = p_worksheet_id

Line 2002: -- table_route_id for pqh_worksheet_details

1998: OPEN csr_table_route (p_table_alias => 'WKS');
1999: FETCH csr_table_route INTO g_table_route_id_wks;
2000: CLOSE csr_table_route;
2001:
2002: -- table_route_id for pqh_worksheet_details
2003: OPEN csr_table_route (p_table_alias => 'WDT');
2004: FETCH csr_table_route INTO g_table_route_id_wdt;
2005: CLOSE csr_table_route;
2006:

Line 2047: p_worksheet_detail_id IN pqh_worksheet_details.worksheet_detail_id%TYPE,

2043: END populate_globals;
2044: --------------------------------------------------------------------------------------------------------------
2045: PROCEDURE set_wks_log_context
2046: (
2047: p_worksheet_detail_id IN pqh_worksheet_details.worksheet_detail_id%TYPE,
2048: p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE
2049: ) IS
2050:
2051: /*

Line 2061: l_worksheet_details_rec pqh_worksheet_details%ROWTYPE;

2057:
2058: */
2059:
2060: l_proc varchar2(72) := g_package||'set_wks_log_context';
2061: l_worksheet_details_rec pqh_worksheet_details%ROWTYPE;
2062: l_position_name hr_positions.name%TYPE;
2063: l_job_name per_jobs.name%TYPE;
2064: l_organization_name hr_all_organization_units_tl.name%TYPE;
2065: l_grade_name per_grades.name%TYPE;

Line 2069: FROM pqh_worksheet_details

2065: l_grade_name per_grades.name%TYPE;
2066:
2067: CURSOR csr_wks_detail_rec IS
2068: SELECT *
2069: FROM pqh_worksheet_details
2070: WHERE worksheet_detail_id = p_worksheet_detail_id ;
2071:
2072: BEGIN
2073:

Line 2404: l_wks_detail_rec pqh_worksheet_details%ROWTYPE;

2400: */
2401:
2402: l_proc varchar2(72) := g_package||'apply_transaction';
2403: l_status varchar2(30);
2404: l_wks_detail_rec pqh_worksheet_details%ROWTYPE;
2405: l_return varchar2(30) := 'SUCCESS' ;
2406: l_worksheet_id pqh_worksheet_details.worksheet_id%TYPE;
2407: l_budget_id pqh_budgets.budget_id%TYPE;
2408: l_budget_rec pqh_budgets%ROWTYPE;

Line 2406: l_worksheet_id pqh_worksheet_details.worksheet_id%TYPE;

2402: l_proc varchar2(72) := g_package||'apply_transaction';
2403: l_status varchar2(30);
2404: l_wks_detail_rec pqh_worksheet_details%ROWTYPE;
2405: l_return varchar2(30) := 'SUCCESS' ;
2406: l_worksheet_id pqh_worksheet_details.worksheet_id%TYPE;
2407: l_budget_id pqh_budgets.budget_id%TYPE;
2408: l_budget_rec pqh_budgets%ROWTYPE;
2409: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
2410: l_gl_validation varchar2(30);

Line 2420: FROM pqh_worksheet_details

2416:
2417:
2418: CURSOR csr_wks_dtl_rec IS
2419: SELECT *
2420: FROM pqh_worksheet_details
2421: WHERE worksheet_detail_id = p_transaction_id;
2422:
2423: CURSOR csr_txn_cat_id(p_transaction_category_id in number) IS
2424: SELECT *

Line 2440: from pqh_worksheets wks, pqh_worksheet_details wkd

2436: WHERE budget_id = p_budget_id;
2437:
2438: cursor c1(p_transaction_id in number) is
2439: select wf_transaction_category_id
2440: from pqh_worksheets wks, pqh_worksheet_details wkd
2441: where wks.worksheet_id = wkd.worksheet_id
2442: and wkd.worksheet_detail_id = p_transaction_id;
2443:
2444: BEGIN

Line 2652: pqh_worksheet_details as the user may not have clicked the populate all button in the form in

2648: ) IS
2649: /*
2650: This procedure will be called in the case of Correct the same version i.e worksheet_mode_cd = 'O'
2651: In this case will will compute the total of all unit values from pqh_budget_details instead of
2652: pqh_worksheet_details as the user may not have clicked the populate all button in the form in
2653: which case all budget records may not be there in pqh_worksheet_details table
2654: */
2655:
2656: -- cursor for unit1_value,2,3

Line 2653: which case all budget records may not be there in pqh_worksheet_details table

2649: /*
2650: This procedure will be called in the case of Correct the same version i.e worksheet_mode_cd = 'O'
2651: In this case will will compute the total of all unit values from pqh_budget_details instead of
2652: pqh_worksheet_details as the user may not have clicked the populate all button in the form in
2653: which case all budget records may not be there in pqh_worksheet_details table
2654: */
2655:
2656: -- cursor for unit1_value,2,3
2657: CURSOR units_csr IS

Line 2973: from pqh_worksheet_details

2969: ) IS
2970:
2971: cursor c1 is
2972: select worksheet_detail_id
2973: from pqh_worksheet_details
2974: where worksheet_id = p_worksheet_id
2975: and nvl(action_cd,'B') ='D';
2976:
2977: l_itemkey varchar2(30);

Line 2999: from pqh_worksheet_details

2995: p_transaction_id number
2996: ) RETURN VARCHAR2 IS
2997: cursor c1 is
2998: select parent_worksheet_detail_id
2999: from pqh_worksheet_details
3000: where worksheet_detail_id = p_transaction_id;
3001:
3002: l_parent_id number;
3003: l_result varchar2(30);

Line 3031: from pqh_worksheet_details

3027: p_worksheet_detail_id in number
3028: ) IS
3029: cursor c1 is select status,parent_worksheet_detail_id,
3030: budget_unit1_available,budget_unit2_available,budget_unit3_available
3031: from pqh_worksheet_details
3032: where worksheet_detail_id = p_worksheet_detail_id
3033: and action_cd = 'D'
3034: for update of status;
3035: cursor c2(p_parent_worksheet_detail_id number) is

Line 3037: from pqh_worksheet_details

3033: and action_cd = 'D'
3034: for update of status;
3035: cursor c2(p_parent_worksheet_detail_id number) is
3036: select budget_unit1_available,budget_unit2_available, budget_unit3_available
3037: from pqh_worksheet_details
3038: where worksheet_detail_id = p_parent_worksheet_detail_id
3039: for update of budget_unit1_available,budget_unit2_available, budget_unit3_available;
3040: BEGIN
3041: for i in c1 loop

Line 3044: update pqh_worksheet_details

3040: BEGIN
3041: for i in c1 loop
3042: if i.parent_worksheet_detail_id is not null then
3043: for j in c2(i.parent_worksheet_detail_id) loop
3044: update pqh_worksheet_details
3045: set budget_unit1_available = nvl(j.budget_unit1_available,0) + nvl(i.budget_unit1_available,0)
3046: , budget_unit2_available = nvl(j.budget_unit2_available,0) + nvl(i.budget_unit2_available,0)
3047: , budget_unit3_available = nvl(j.budget_unit3_available,0) + nvl(i.budget_unit3_available,0)
3048: where current of c2;

Line 3050: update pqh_worksheet_details

3046: , budget_unit2_available = nvl(j.budget_unit2_available,0) + nvl(i.budget_unit2_available,0)
3047: , budget_unit3_available = nvl(j.budget_unit3_available,0) + nvl(i.budget_unit3_available,0)
3048: where current of c2;
3049: end loop;
3050: update pqh_worksheet_details
3051: set status = 'APPROVED'
3052: where current of c1;
3053: else
3054: hr_utility.set_message(8302,'PQH_INVALID_WKS_TXN_ID');

Line 3085: from pqh_worksheet_details

3081: l_budget_entity_cd varchar2(30);
3082: l_budget_style_cd varchar2(30);
3083: l_tran_cat_id number;
3084: cursor c0 is select worksheet_id,organization_id
3085: from pqh_worksheet_details
3086: where worksheet_detail_id = p_transaction_id;
3087: cursor c1 is select budget_id,worksheet_name,version_number,worksheet_mode_cd,date_from,date_to,wf_transaction_category_id
3088: from pqh_worksheets
3089: where worksheet_id = l_worksheet_id;

Line 3555: from pqh_worksheet_details wkd, pqh_worksheets wks

3551:
3552: cursor c1 is select wkd.worksheet_detail_id transaction_id,
3553: wkd.parent_worksheet_detail_id parent_transaction_id,
3554: wkd.status transaction_status
3555: from pqh_worksheet_details wkd, pqh_worksheets wks
3556: where parent_worksheet_detail_id = p_transaction_id
3557: and parent_worksheet_detail_id <> worksheet_detail_id
3558: and wkd.worksheet_id = wks.worksheet_id
3559: and wks.wf_transaction_category_id = p_transaction_category_id

Line 3565: , pqh_worksheet_details wkd

3561:
3562: CURSOR csr_wks IS
3563: SELECT wks.*
3564: FROM pqh_worksheets wks
3565: , pqh_worksheet_details wkd
3566: WHERE wkd.worksheet_detail_id = p_transaction_id
3567: and wks.worksheet_id = wkd.worksheet_id;
3568:
3569: CURSOR csr_wdt IS

Line 3571: FROM pqh_worksheet_details wdt

3567: and wks.worksheet_id = wkd.worksheet_id;
3568:
3569: CURSOR csr_wdt IS
3570: SELECT wdt.*
3571: FROM pqh_worksheet_details wdt
3572: WHERE wdt.worksheet_detail_id = p_transaction_id;
3573:
3574: l_wks_rec pqh_worksheets%ROWTYPE;
3575: l_wdt_rec pqh_worksheet_details%ROWTYPE;

Line 3575: l_wdt_rec pqh_worksheet_details%ROWTYPE;

3571: FROM pqh_worksheet_details wdt
3572: WHERE wdt.worksheet_detail_id = p_transaction_id;
3573:
3574: l_wks_rec pqh_worksheets%ROWTYPE;
3575: l_wdt_rec pqh_worksheet_details%ROWTYPE;
3576: l_object_version_number pqh_worksheets.object_version_number%TYPE;
3577: l_object_version_number_wdt pqh_worksheet_details.object_version_number%TYPE;
3578: l_do_action boolean := FALSE;
3579: l_return_status varchar2(20);

Line 3577: l_object_version_number_wdt pqh_worksheet_details.object_version_number%TYPE;

3573:
3574: l_wks_rec pqh_worksheets%ROWTYPE;
3575: l_wdt_rec pqh_worksheet_details%ROWTYPE;
3576: l_object_version_number pqh_worksheets.object_version_number%TYPE;
3577: l_object_version_number_wdt pqh_worksheet_details.object_version_number%TYPE;
3578: l_do_action boolean := FALSE;
3579: l_return_status varchar2(20);
3580:
3581: BEGIN

Line 3616: pqh_worksheet_details_api.update_worksheet_detail

3612: null;
3613: END ; -- for abort process
3614: end if;
3615: l_object_version_number_wdt := l_wdt_rec.object_version_number;
3616: pqh_worksheet_details_api.update_worksheet_detail
3617: (
3618: p_validate => false
3619: ,p_worksheet_detail_id => p_transaction_id
3620: ,p_object_version_number => l_object_version_number_wdt