eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_CC_BL_PROCESS dependencies on PA_CC_UTILS

Line 254: pa_cc_utils.g_debug_mode := TRUE;

250:
251: -- Set Debugging info
252: IF p_debug_mode = 'Y'
253: THEN
254: pa_cc_utils.g_debug_mode := TRUE;
255: ELSE
256: pa_cc_utils.g_debug_mode := FALSE;
257: END IF;
258:

Line 256: pa_cc_utils.g_debug_mode := FALSE;

252: IF p_debug_mode = 'Y'
253: THEN
254: pa_cc_utils.g_debug_mode := TRUE;
255: ELSE
256: pa_cc_utils.g_debug_mode := FALSE;
257: END IF;
258:
259:
260: set_curr_function('pa_bl_pr');

Line 1398: AND application_id = pa_cc_utils.g_program_application_id

1394: SELECT ledger_id,
1395: currency_code
1396: FROM gl_alc_ledger_rships_v
1397: WHERE source_ledger_id = p_primary_sob_id
1398: AND application_id = pa_cc_utils.g_program_application_id
1399: AND relationship_enabled_flag = 'Y'
1400: AND (org_id = -99 OR org_id = p_org_id); -- R12 MRC changes
1401: -- AND nvl(org_id,-99) = nvl(p_org_id, -99);
1402: -- AND trunc(sysdate) BETWEEN start_date AND nvl(end_date, sysdate);

Line 1413: pa_cc_utils.g_request_id := p_request_id;

1409: END IF;
1410:
1411: -- Copy who columns into global variables
1412:
1413: pa_cc_utils.g_request_id := p_request_id;
1414: pa_cc_utils.g_program_application_id := p_program_application_id;
1415: pa_cc_utils.g_program_id := p_program_id;
1416: pa_cc_utils.g_user_id := p_user_id;
1417: pa_cc_utils.g_login_id := p_login_id;

Line 1414: pa_cc_utils.g_program_application_id := p_program_application_id;

1410:
1411: -- Copy who columns into global variables
1412:
1413: pa_cc_utils.g_request_id := p_request_id;
1414: pa_cc_utils.g_program_application_id := p_program_application_id;
1415: pa_cc_utils.g_program_id := p_program_id;
1416: pa_cc_utils.g_user_id := p_user_id;
1417: pa_cc_utils.g_login_id := p_login_id;
1418:

Line 1415: pa_cc_utils.g_program_id := p_program_id;

1411: -- Copy who columns into global variables
1412:
1413: pa_cc_utils.g_request_id := p_request_id;
1414: pa_cc_utils.g_program_application_id := p_program_application_id;
1415: pa_cc_utils.g_program_id := p_program_id;
1416: pa_cc_utils.g_user_id := p_user_id;
1417: pa_cc_utils.g_login_id := p_login_id;
1418:
1419: -- Set global variables

Line 1416: pa_cc_utils.g_user_id := p_user_id;

1412:
1413: pa_cc_utils.g_request_id := p_request_id;
1414: pa_cc_utils.g_program_application_id := p_program_application_id;
1415: pa_cc_utils.g_program_id := p_program_id;
1416: pa_cc_utils.g_user_id := p_user_id;
1417: pa_cc_utils.g_login_id := p_login_id;
1418:
1419: -- Set global variables
1420: pa_cc_utils.g_prvdr_org_id := p_prvdr_org_id;

Line 1417: pa_cc_utils.g_login_id := p_login_id;

1413: pa_cc_utils.g_request_id := p_request_id;
1414: pa_cc_utils.g_program_application_id := p_program_application_id;
1415: pa_cc_utils.g_program_id := p_program_id;
1416: pa_cc_utils.g_user_id := p_user_id;
1417: pa_cc_utils.g_login_id := p_login_id;
1418:
1419: -- Set global variables
1420: pa_cc_utils.g_prvdr_org_id := p_prvdr_org_id;
1421: pa_cc_utils.g_primary_sob_id := p_primary_sob_id;

Line 1420: pa_cc_utils.g_prvdr_org_id := p_prvdr_org_id;

1416: pa_cc_utils.g_user_id := p_user_id;
1417: pa_cc_utils.g_login_id := p_login_id;
1418:
1419: -- Set global variables
1420: pa_cc_utils.g_prvdr_org_id := p_prvdr_org_id;
1421: pa_cc_utils.g_primary_sob_id := p_primary_sob_id;
1422:
1423:
1424: -- Set initialization flag so that this procedure is not performed in

Line 1421: pa_cc_utils.g_primary_sob_id := p_primary_sob_id;

1417: pa_cc_utils.g_login_id := p_login_id;
1418:
1419: -- Set global variables
1420: pa_cc_utils.g_prvdr_org_id := p_prvdr_org_id;
1421: pa_cc_utils.g_primary_sob_id := p_primary_sob_id;
1422:
1423:
1424: -- Set initialization flag so that this procedure is not performed in
1425: -- the second call to this package for the next set of expenditure

Line 1445: pa_cc_utils.g_reporting_sob_id(i) := c.ledger_id;

1441: LOOP
1442:
1443: i := i + 1;
1444:
1445: pa_cc_utils.g_reporting_sob_id(i) := c.ledger_id;
1446:
1447: IF P_DEBUG_MODE = 'Y' THEN
1448: log_message('reverse_distribution: ' || '3450: Got a reporting SOB: ' || pa_cc_utils.g_reporting_sob_id(i));
1449: END IF;

Line 1448: log_message('reverse_distribution: ' || '3450: Got a reporting SOB: ' || pa_cc_utils.g_reporting_sob_id(i));

1444:
1445: pa_cc_utils.g_reporting_sob_id(i) := c.ledger_id;
1446:
1447: IF P_DEBUG_MODE = 'Y' THEN
1448: log_message('reverse_distribution: ' || '3450: Got a reporting SOB: ' || pa_cc_utils.g_reporting_sob_id(i));
1449: END IF;
1450:
1451: pa_cc_utils.g_reporting_curr_code(i) := c.currency_code;
1452:

Line 1451: pa_cc_utils.g_reporting_curr_code(i) := c.currency_code;

1447: IF P_DEBUG_MODE = 'Y' THEN
1448: log_message('reverse_distribution: ' || '3450: Got a reporting SOB: ' || pa_cc_utils.g_reporting_sob_id(i));
1449: END IF;
1450:
1451: pa_cc_utils.g_reporting_curr_code(i) := c.currency_code;
1452:
1453: END LOOP;
1454:
1455: -- MRC is enabled if at least one reporting set of books is present

Line 1457: IF pa_cc_utils.g_reporting_sob_id.exists(1)

1453: END LOOP;
1454:
1455: -- MRC is enabled if at least one reporting set of books is present
1456:
1457: IF pa_cc_utils.g_reporting_sob_id.exists(1)
1458: THEN
1459: --g_mrc_enabled := TRUE;
1460: IF P_DEBUG_MODE = 'Y' THEN
1461: log_message('reverse_distribution: ' || '3500: MRC ENABLED');

Line 1921: ,p_debug_mode => pa_cc_utils.g_debug_mode

1917:
1918: pa_mc_borrlent.bl_mc_delete
1919: (
1920: p_cc_dist_line_id => in_cc_dist_line_id
1921: ,p_debug_mode => pa_cc_utils.g_debug_mode
1922: );
1923:
1924: log_message('4700: Finished delete for MRC');
1925:

Line 2011: in_prvdr_org_id(i) := pa_cc_utils.g_prvdr_org_id;

2007: -- performed for a reporting set of books across operating units and
2008: -- hence a combination of operating units may be present in a single
2009: -- call
2010:
2011: in_prvdr_org_id(i) := pa_cc_utils.g_prvdr_org_id;
2012:
2013: -- The following reference_1, reference_2 and reference_3 columns are
2014: -- only populated by the InterCompany invoicing and the MRC upgrade
2015: -- processes. Reference_2 (type of provider reclass base) and

Line 2136: pa_cc_utils.g_request_id, -- request_id

2132: in_acct_currency_code(i), -- acct_currency_code
2133: in_amount(i), -- amount
2134: in_project_id(i), -- project_id
2135: in_task_id(i), -- task_id
2136: pa_cc_utils.g_request_id, -- request_id
2137: sysdate, -- last_update_date
2138: pa_cc_utils.g_user_id, -- last_updated_by
2139: sysdate, -- creation_date
2140: pa_cc_utils.g_user_id, -- created_by

Line 2138: pa_cc_utils.g_user_id, -- last_updated_by

2134: in_project_id(i), -- project_id
2135: in_task_id(i), -- task_id
2136: pa_cc_utils.g_request_id, -- request_id
2137: sysdate, -- last_update_date
2138: pa_cc_utils.g_user_id, -- last_updated_by
2139: sysdate, -- creation_date
2140: pa_cc_utils.g_user_id, -- created_by
2141: pa_cc_utils.g_login_id, -- last_update_login
2142: in_line_num_reversed(i), -- line_num_reversed

Line 2140: pa_cc_utils.g_user_id, -- created_by

2136: pa_cc_utils.g_request_id, -- request_id
2137: sysdate, -- last_update_date
2138: pa_cc_utils.g_user_id, -- last_updated_by
2139: sysdate, -- creation_date
2140: pa_cc_utils.g_user_id, -- created_by
2141: pa_cc_utils.g_login_id, -- last_update_login
2142: in_line_num_reversed(i), -- line_num_reversed
2143: in_dist_line_id_reversed(i), -- dist_line_id_reversed
2144: in_reversed_flag(i), -- reversed_flag

Line 2141: pa_cc_utils.g_login_id, -- last_update_login

2137: sysdate, -- last_update_date
2138: pa_cc_utils.g_user_id, -- last_updated_by
2139: sysdate, -- creation_date
2140: pa_cc_utils.g_user_id, -- created_by
2141: pa_cc_utils.g_login_id, -- last_update_login
2142: in_line_num_reversed(i), -- line_num_reversed
2143: in_dist_line_id_reversed(i), -- dist_line_id_reversed
2144: in_reversed_flag(i), -- reversed_flag
2145: in_denom_tp_currency_code(i), -- denom_tp_currency_code

Line 2171: pa_cc_utils.g_program_application_id, -- program_application_id

2167: in_rule_percentage(i), -- rule_percentage
2168: in_reference_1(i), -- reference_1
2169: in_reference_2(i), -- reference_2
2170: in_reference_3(i), -- reference_3
2171: pa_cc_utils.g_program_application_id, -- program_application_id
2172: pa_cc_utils.g_program_id, -- program_id
2173: sysdate, -- program_update_date
2174: /* Added for cross proj*/
2175: in_tp_amt_type_code(i),

Line 2172: pa_cc_utils.g_program_id, -- program_id

2168: in_reference_1(i), -- reference_1
2169: in_reference_2(i), -- reference_2
2170: in_reference_3(i), -- reference_3
2171: pa_cc_utils.g_program_application_id, -- program_application_id
2172: pa_cc_utils.g_program_id, -- program_id
2173: sysdate, -- program_update_date
2174: /* Added for cross proj*/
2175: in_tp_amt_type_code(i),
2176: in_project_tp_rate_type(i),

Line 2199: pa_cc_utils.g_program_application_id);

2195:
2196: /*IF g_mrc_enabled
2197: THEN
2198: log_message('5150: MRC Enabled; calling mass insert for MRC:'||
2199: pa_cc_utils.g_program_application_id);
2200:
2201: pa_mc_borrlent.bl_mc_insert
2202: (
2203: p_primary_sob_id => pa_cc_utils.g_primary_sob_id

Line 2203: p_primary_sob_id => pa_cc_utils.g_primary_sob_id

2199: pa_cc_utils.g_program_application_id);
2200:
2201: pa_mc_borrlent.bl_mc_insert
2202: (
2203: p_primary_sob_id => pa_cc_utils.g_primary_sob_id
2204: ,p_prvdr_org_id => in_prvdr_org_id
2205: ,p_rsob_id => pa_cc_utils.g_reporting_sob_id
2206: ,p_rcurrency_code => pa_cc_utils.g_reporting_curr_code
2207: ,p_cc_dist_line_id => in_cc_dist_line_id

Line 2205: ,p_rsob_id => pa_cc_utils.g_reporting_sob_id

2201: pa_mc_borrlent.bl_mc_insert
2202: (
2203: p_primary_sob_id => pa_cc_utils.g_primary_sob_id
2204: ,p_prvdr_org_id => in_prvdr_org_id
2205: ,p_rsob_id => pa_cc_utils.g_reporting_sob_id
2206: ,p_rcurrency_code => pa_cc_utils.g_reporting_curr_code
2207: ,p_cc_dist_line_id => in_cc_dist_line_id
2208: ,p_expenditure_item_id => in_expenditure_item_id
2209: ,p_line_num => in_line_num

Line 2206: ,p_rcurrency_code => pa_cc_utils.g_reporting_curr_code

2202: (
2203: p_primary_sob_id => pa_cc_utils.g_primary_sob_id
2204: ,p_prvdr_org_id => in_prvdr_org_id
2205: ,p_rsob_id => pa_cc_utils.g_reporting_sob_id
2206: ,p_rcurrency_code => pa_cc_utils.g_reporting_curr_code
2207: ,p_cc_dist_line_id => in_cc_dist_line_id
2208: ,p_expenditure_item_id => in_expenditure_item_id
2209: ,p_line_num => in_line_num
2210: ,p_line_type => in_line_type

Line 2219: ,p_login_id => pa_cc_utils.g_login_id

2215: ,p_denom_transfer_price => in_denom_transfer_price
2216: ,p_dist_line_id_reversed => in_dist_line_id_reversed
2217: ,p_prvdr_cost_reclass_code => in_reference_2
2218: ,p_cdl_line_num => in_reference_3
2219: ,p_login_id => pa_cc_utils.g_login_id
2220: ,p_program_id => pa_cc_utils.g_program_id
2221: ,p_program_application_id => pa_cc_utils.g_program_application_id
2222: ,p_request_id => pa_cc_utils.g_request_id
2223: ,p_debug_mode => pa_cc_utils.g_debug_mode

Line 2220: ,p_program_id => pa_cc_utils.g_program_id

2216: ,p_dist_line_id_reversed => in_dist_line_id_reversed
2217: ,p_prvdr_cost_reclass_code => in_reference_2
2218: ,p_cdl_line_num => in_reference_3
2219: ,p_login_id => pa_cc_utils.g_login_id
2220: ,p_program_id => pa_cc_utils.g_program_id
2221: ,p_program_application_id => pa_cc_utils.g_program_application_id
2222: ,p_request_id => pa_cc_utils.g_request_id
2223: ,p_debug_mode => pa_cc_utils.g_debug_mode
2224: );

Line 2221: ,p_program_application_id => pa_cc_utils.g_program_application_id

2217: ,p_prvdr_cost_reclass_code => in_reference_2
2218: ,p_cdl_line_num => in_reference_3
2219: ,p_login_id => pa_cc_utils.g_login_id
2220: ,p_program_id => pa_cc_utils.g_program_id
2221: ,p_program_application_id => pa_cc_utils.g_program_application_id
2222: ,p_request_id => pa_cc_utils.g_request_id
2223: ,p_debug_mode => pa_cc_utils.g_debug_mode
2224: );
2225: END IF;*/

Line 2222: ,p_request_id => pa_cc_utils.g_request_id

2218: ,p_cdl_line_num => in_reference_3
2219: ,p_login_id => pa_cc_utils.g_login_id
2220: ,p_program_id => pa_cc_utils.g_program_id
2221: ,p_program_application_id => pa_cc_utils.g_program_application_id
2222: ,p_request_id => pa_cc_utils.g_request_id
2223: ,p_debug_mode => pa_cc_utils.g_debug_mode
2224: );
2225: END IF;*/
2226:

Line 2223: ,p_debug_mode => pa_cc_utils.g_debug_mode

2219: ,p_login_id => pa_cc_utils.g_login_id
2220: ,p_program_id => pa_cc_utils.g_program_id
2221: ,p_program_application_id => pa_cc_utils.g_program_application_id
2222: ,p_request_id => pa_cc_utils.g_request_id
2223: ,p_debug_mode => pa_cc_utils.g_debug_mode
2224: );
2225: END IF;*/
2226:
2227: END IF; -- If g_icnt > 0

Line 2301: in_prvdr_org_id(i) := pa_cc_utils.g_prvdr_org_id;

2297: -- performed for a reporting set of books across operating units and
2298: -- hence a combination of operating units may be present in a single
2299: -- call
2300:
2301: in_prvdr_org_id(i) := pa_cc_utils.g_prvdr_org_id;
2302:
2303: -- The following reference_1, reference_2 and reference_3 columns are
2304: -- only populated by the InterCompany invoicing and the MRC upgrade
2305: -- processes. Reference_2 (type of provider reclass base) and

Line 2481: last_updated_by = pa_cc_utils.g_user_id,

2477: in_project_tp_currency_code(i),project_tp_currency_code),
2478: projfunc_tp_currency_code = decode(in_upd_type(i), 'U',
2479: in_projfunc_tp_currency_code(i),projfunc_tp_currency_code),
2480: /*End Cross proj*/
2481: last_updated_by = pa_cc_utils.g_user_id,
2482: last_update_login = pa_cc_utils.g_login_id,
2483: last_update_date = sysdate,
2484: request_id = pa_cc_utils.g_request_id,
2485: program_application_id = pa_cc_utils.g_program_application_id,

Line 2482: last_update_login = pa_cc_utils.g_login_id,

2478: projfunc_tp_currency_code = decode(in_upd_type(i), 'U',
2479: in_projfunc_tp_currency_code(i),projfunc_tp_currency_code),
2480: /*End Cross proj*/
2481: last_updated_by = pa_cc_utils.g_user_id,
2482: last_update_login = pa_cc_utils.g_login_id,
2483: last_update_date = sysdate,
2484: request_id = pa_cc_utils.g_request_id,
2485: program_application_id = pa_cc_utils.g_program_application_id,
2486: program_id = pa_cc_utils.g_program_id,

Line 2484: request_id = pa_cc_utils.g_request_id,

2480: /*End Cross proj*/
2481: last_updated_by = pa_cc_utils.g_user_id,
2482: last_update_login = pa_cc_utils.g_login_id,
2483: last_update_date = sysdate,
2484: request_id = pa_cc_utils.g_request_id,
2485: program_application_id = pa_cc_utils.g_program_application_id,
2486: program_id = pa_cc_utils.g_program_id,
2487: program_update_date = sysdate
2488: WHERE rowid = in_RowId(i);

Line 2485: program_application_id = pa_cc_utils.g_program_application_id,

2481: last_updated_by = pa_cc_utils.g_user_id,
2482: last_update_login = pa_cc_utils.g_login_id,
2483: last_update_date = sysdate,
2484: request_id = pa_cc_utils.g_request_id,
2485: program_application_id = pa_cc_utils.g_program_application_id,
2486: program_id = pa_cc_utils.g_program_id,
2487: program_update_date = sysdate
2488: WHERE rowid = in_RowId(i);
2489:

Line 2486: program_id = pa_cc_utils.g_program_id,

2482: last_update_login = pa_cc_utils.g_login_id,
2483: last_update_date = sysdate,
2484: request_id = pa_cc_utils.g_request_id,
2485: program_application_id = pa_cc_utils.g_program_application_id,
2486: program_id = pa_cc_utils.g_program_id,
2487: program_update_date = sysdate
2488: WHERE rowid = in_RowId(i);
2489:
2490: log_message('5500: -- Rows updated = ' || to_char(sql%ROWCOUNT));

Line 2502: p_primary_sob_id => pa_cc_utils.g_primary_sob_id

2498: log_message('5600: first line id passed ' || in_cc_dist_line_id(1));
2499:
2500: pa_mc_borrlent.bl_mc_update
2501: (
2502: p_primary_sob_id => pa_cc_utils.g_primary_sob_id
2503: ,p_prvdr_org_id => in_prvdr_org_id
2504: ,p_rsob_id => pa_cc_utils.g_reporting_sob_id
2505: ,p_rcurrency_code => pa_cc_utils.g_reporting_curr_code
2506: ,p_cc_dist_line_id => in_cc_dist_line_id

Line 2504: ,p_rsob_id => pa_cc_utils.g_reporting_sob_id

2500: pa_mc_borrlent.bl_mc_update
2501: (
2502: p_primary_sob_id => pa_cc_utils.g_primary_sob_id
2503: ,p_prvdr_org_id => in_prvdr_org_id
2504: ,p_rsob_id => pa_cc_utils.g_reporting_sob_id
2505: ,p_rcurrency_code => pa_cc_utils.g_reporting_curr_code
2506: ,p_cc_dist_line_id => in_cc_dist_line_id
2507: ,p_line_type => in_line_type
2508: ,p_upd_type => in_upd_type

Line 2505: ,p_rcurrency_code => pa_cc_utils.g_reporting_curr_code

2501: (
2502: p_primary_sob_id => pa_cc_utils.g_primary_sob_id
2503: ,p_prvdr_org_id => in_prvdr_org_id
2504: ,p_rsob_id => pa_cc_utils.g_reporting_sob_id
2505: ,p_rcurrency_code => pa_cc_utils.g_reporting_curr_code
2506: ,p_cc_dist_line_id => in_cc_dist_line_id
2507: ,p_line_type => in_line_type
2508: ,p_upd_type => in_upd_type
2509: ,p_expenditure_item_date => in_expenditure_item_date

Line 2516: ,p_login_id => pa_cc_utils.g_login_id

2512: ,p_acct_tp_exchange_rate => in_acct_tp_exchange_rate
2513: ,p_denom_transfer_price => in_denom_transfer_price
2514: ,p_prvdr_cost_reclass_code => in_reference_2
2515: ,p_cdl_line_num => in_reference_3
2516: ,p_login_id => pa_cc_utils.g_login_id
2517: ,p_program_id => pa_cc_utils.g_program_id
2518: ,p_program_application_id => pa_cc_utils.g_program_application_id
2519: ,p_request_id => pa_cc_utils.g_request_id
2520: ,p_debug_mode => pa_cc_utils.g_debug_mode

Line 2517: ,p_program_id => pa_cc_utils.g_program_id

2513: ,p_denom_transfer_price => in_denom_transfer_price
2514: ,p_prvdr_cost_reclass_code => in_reference_2
2515: ,p_cdl_line_num => in_reference_3
2516: ,p_login_id => pa_cc_utils.g_login_id
2517: ,p_program_id => pa_cc_utils.g_program_id
2518: ,p_program_application_id => pa_cc_utils.g_program_application_id
2519: ,p_request_id => pa_cc_utils.g_request_id
2520: ,p_debug_mode => pa_cc_utils.g_debug_mode
2521: );

Line 2518: ,p_program_application_id => pa_cc_utils.g_program_application_id

2514: ,p_prvdr_cost_reclass_code => in_reference_2
2515: ,p_cdl_line_num => in_reference_3
2516: ,p_login_id => pa_cc_utils.g_login_id
2517: ,p_program_id => pa_cc_utils.g_program_id
2518: ,p_program_application_id => pa_cc_utils.g_program_application_id
2519: ,p_request_id => pa_cc_utils.g_request_id
2520: ,p_debug_mode => pa_cc_utils.g_debug_mode
2521: );
2522:

Line 2519: ,p_request_id => pa_cc_utils.g_request_id

2515: ,p_cdl_line_num => in_reference_3
2516: ,p_login_id => pa_cc_utils.g_login_id
2517: ,p_program_id => pa_cc_utils.g_program_id
2518: ,p_program_application_id => pa_cc_utils.g_program_application_id
2519: ,p_request_id => pa_cc_utils.g_request_id
2520: ,p_debug_mode => pa_cc_utils.g_debug_mode
2521: );
2522:
2523: log_message('5650: Finished MRC update');

Line 2520: ,p_debug_mode => pa_cc_utils.g_debug_mode

2516: ,p_login_id => pa_cc_utils.g_login_id
2517: ,p_program_id => pa_cc_utils.g_program_id
2518: ,p_program_application_id => pa_cc_utils.g_program_application_id
2519: ,p_request_id => pa_cc_utils.g_request_id
2520: ,p_debug_mode => pa_cc_utils.g_debug_mode
2521: );
2522:
2523: log_message('5650: Finished MRC update');
2524:

Line 2922: last_updated_by = pa_cc_utils.g_user_id,

2918: (in_projfunc_tp_exchange_rate(i)),projfunc_tp_exchange_rate),
2919: projfunc_transfer_price = decode(in_upd_type(i), 'U',
2920: in_projfunc_transfer_price(i),projfunc_transfer_price),
2921: /*End Cross proj*/
2922: last_updated_by = pa_cc_utils.g_user_id,
2923: last_update_login = pa_cc_utils.g_login_id,
2924: last_update_date = sysdate,
2925: request_id = pa_cc_utils.g_request_id,
2926: program_application_id = pa_cc_utils.g_program_application_id,

Line 2923: last_update_login = pa_cc_utils.g_login_id,

2919: projfunc_transfer_price = decode(in_upd_type(i), 'U',
2920: in_projfunc_transfer_price(i),projfunc_transfer_price),
2921: /*End Cross proj*/
2922: last_updated_by = pa_cc_utils.g_user_id,
2923: last_update_login = pa_cc_utils.g_login_id,
2924: last_update_date = sysdate,
2925: request_id = pa_cc_utils.g_request_id,
2926: program_application_id = pa_cc_utils.g_program_application_id,
2927: program_id = pa_cc_utils.g_program_id,

Line 2925: request_id = pa_cc_utils.g_request_id,

2921: /*End Cross proj*/
2922: last_updated_by = pa_cc_utils.g_user_id,
2923: last_update_login = pa_cc_utils.g_login_id,
2924: last_update_date = sysdate,
2925: request_id = pa_cc_utils.g_request_id,
2926: program_application_id = pa_cc_utils.g_program_application_id,
2927: program_id = pa_cc_utils.g_program_id,
2928: program_update_date = sysdate
2929: WHERE rowid = in_RowId(i);

Line 2926: program_application_id = pa_cc_utils.g_program_application_id,

2922: last_updated_by = pa_cc_utils.g_user_id,
2923: last_update_login = pa_cc_utils.g_login_id,
2924: last_update_date = sysdate,
2925: request_id = pa_cc_utils.g_request_id,
2926: program_application_id = pa_cc_utils.g_program_application_id,
2927: program_id = pa_cc_utils.g_program_id,
2928: program_update_date = sysdate
2929: WHERE rowid = in_RowId(i);
2930:

Line 2927: program_id = pa_cc_utils.g_program_id,

2923: last_update_login = pa_cc_utils.g_login_id,
2924: last_update_date = sysdate,
2925: request_id = pa_cc_utils.g_request_id,
2926: program_application_id = pa_cc_utils.g_program_application_id,
2927: program_id = pa_cc_utils.g_program_id,
2928: program_update_date = sysdate
2929: WHERE rowid = in_RowId(i);
2930:
2931: log_message('6450: -- Rows updated = ' || to_char(sql%ROWCOUNT));

Line 2962: pa_cc_utils.log_message('log_message: ' || p_message);

2958: PROCEDURE log_message( p_message IN VARCHAR2) IS
2959: BEGIN
2960:
2961: IF P_DEBUG_MODE = 'Y' THEN
2962: pa_cc_utils.log_message('log_message: ' || p_message);
2963: END IF;
2964:
2965: END log_message;
2966:

Line 2974: pa_cc_utils.set_curr_function(p_function);

2970:
2971: PROCEDURE set_curr_function(p_function IN VARCHAR2) IS
2972: BEGIN
2973:
2974: pa_cc_utils.set_curr_function(p_function);
2975:
2976: END;
2977:
2978: -------------------------------------------------------------------------------

Line 2985: pa_cc_utils.reset_curr_function;

2981:
2982: PROCEDURE reset_curr_function IS
2983: BEGIN
2984:
2985: pa_cc_utils.reset_curr_function;
2986:
2987: END;
2988:
2989: