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.PAY_US_PSD_XML dependencies on PAY_US_PSD_XML

Line 1: PACKAGE BODY pay_us_psd_xml AS

1: PACKAGE BODY pay_us_psd_xml AS
2: /* $Header: payuspsdxml.pkb 120.3.12020000.15 2012/12/11 19:23:04 skchalla noship $ */
3:
4: /*
5: +============================================================================+

Line 11: pay_us_psd_xml

7: | Redwood Shores, California, USA |
8: | All rights reserved. |
9: +============================================================================+
10: Name
11: pay_us_psd_xml
12: File
13: payuspsdxml.pkb
14:
15: Purpose

Line 117: ('pay_us_psd_xml.bal_db_item - opening cursor', 10);

113:
114: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
115: BEGIN
116: hr_utility.set_location
117: ('pay_us_psd_xml.bal_db_item - opening cursor', 10);
118: -- Open the cursor
119: OPEN csr_defined_balance;
120: -- Fetch the value
121: FETCH csr_defined_balance

Line 126: ('pay_us_psd_xml.bal_db_item - no rows found from cursor', 20);

122: INTO l_defined_balance_id;
123: IF csr_defined_balance%NOTFOUND THEN
124: CLOSE csr_defined_balance;
125: hr_utility.set_location
126: ('pay_us_psd_xml.bal_db_item - no rows found from cursor', 20);
127: hr_utility.raise_error;
128: ELSE
129: hr_utility.set_location
130: ('pay_us_psd_xml.bal_db_item - fetched from cursor', 30);

Line 130: ('pay_us_psd_xml.bal_db_item - fetched from cursor', 30);

126: ('pay_us_psd_xml.bal_db_item - no rows found from cursor', 20);
127: hr_utility.raise_error;
128: ELSE
129: hr_utility.set_location
130: ('pay_us_psd_xml.bal_db_item - fetched from cursor', 30);
131: CLOSE csr_defined_balance;
132: END IF;
133: -- Return the value to the call
134: RETURN (l_defined_balance_id);

Line 374: hr_utility.set_location('pay_us_psd_xml.get_report_parameters', 10);

370: l_state_code pay_us_states.state_code%type;
371: l_period_start varchar2(200);
372: l_period_end varchar2(200);
373: BEGIN
374: hr_utility.set_location('pay_us_psd_xml.get_report_parameters', 10);
375: hr_utility.trace('Payroll_Action_Id '|| to_char(p_pactid));
376:
377: SELECT ppa.start_date,
378: ppa.effective_date,

Line 424: hr_utility.set_location('pay_us_psd_xml.get_report_parameters', 15);

420: p_period_start:= trunc(p_period_end,'YY');
421: end if;
422:
423:
424: hr_utility.set_location('pay_us_psd_xml.get_report_parameters', 15);
425: hr_utility.trace('Parameter Values ');
426: hr_utility.trace('Year Start '|| to_char(p_year_start,'dd-mon-yyyy'));
427: hr_utility.trace('Year End '|| to_char(p_year_end,'dd-mon-yyyy'));
428: hr_utility.trace('Business Group Id '|| to_char(p_business_group_id));

Line 438: ('PAY_US_PSD_XML.get_report_parameters', 40);

434: hr_utility.trace('p_period_end '|| p_period_end);
435: hr_utility.trace('p_tax_coll_dist_code '|| p_tax_coll_dist_code);
436:
437: hr_utility.set_location
438: ('PAY_US_PSD_XML.get_report_parameters', 40);
439: EXCEPTION
440: WHEN OTHERS THEN
441: hr_utility.trace('get_report_parameters procedure Raised Exception ');
442: hr_utility.trace('ERROR '||substr(SQLERRM,1,40));

Line 588: pay_us_psd_xml.get_parameter('TRANSFER_REPORTING_YEAR',ppa.legislative_parameters),

584: paa.payroll_action_id,
585: paa.assignment_action_id,
586: paa.assignment_id,
587: ppa.effective_date/*,
588: pay_us_psd_xml.get_parameter('TRANSFER_REPORTING_YEAR',ppa.legislative_parameters),
589: pay_us_psd_xml.get_parameter('TRANSFER_STATE',ppa.legislative_parameters),
590: pay_us_psd_xml.get_parameter('TRANSFER_PERIOD_TYPE',ppa.legislative_parameters) */ --Modified for Bug 14799833
591: FROM pay_assignment_actions paa,
592: pay_payroll_actions ppa

Line 589: pay_us_psd_xml.get_parameter('TRANSFER_STATE',ppa.legislative_parameters),

585: paa.assignment_action_id,
586: paa.assignment_id,
587: ppa.effective_date/*,
588: pay_us_psd_xml.get_parameter('TRANSFER_REPORTING_YEAR',ppa.legislative_parameters),
589: pay_us_psd_xml.get_parameter('TRANSFER_STATE',ppa.legislative_parameters),
590: pay_us_psd_xml.get_parameter('TRANSFER_PERIOD_TYPE',ppa.legislative_parameters) */ --Modified for Bug 14799833
591: FROM pay_assignment_actions paa,
592: pay_payroll_actions ppa
593: where ppa.payroll_action_id = paa.payroll_action_id

Line 590: pay_us_psd_xml.get_parameter('TRANSFER_PERIOD_TYPE',ppa.legislative_parameters) */ --Modified for Bug 14799833

586: paa.assignment_id,
587: ppa.effective_date/*,
588: pay_us_psd_xml.get_parameter('TRANSFER_REPORTING_YEAR',ppa.legislative_parameters),
589: pay_us_psd_xml.get_parameter('TRANSFER_STATE',ppa.legislative_parameters),
590: pay_us_psd_xml.get_parameter('TRANSFER_PERIOD_TYPE',ppa.legislative_parameters) */ --Modified for Bug 14799833
591: FROM pay_assignment_actions paa,
592: pay_payroll_actions ppa
593: where ppa.payroll_action_id = paa.payroll_action_id
594: -- and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 615: SELECT pay_us_psd_xml.get_parameter('TRANSFER_REPORTING_YEAR',ppa.legislative_parameters),

611: and ppa.report_type ='YREND'
612: and ppa.action_type = 'X';
613:
614: CURSOR c_get_report_params_ytd IS
615: SELECT pay_us_psd_xml.get_parameter('TRANSFER_REPORTING_YEAR',ppa.legislative_parameters),
616: pay_us_psd_xml.get_parameter('TRANSFER_STATE',ppa.legislative_parameters),
617: pay_us_psd_xml.get_parameter('TRANSFER_PERIOD_TYPE',ppa.legislative_parameters)
618: FROM pay_payroll_actions ppa
619: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 616: pay_us_psd_xml.get_parameter('TRANSFER_STATE',ppa.legislative_parameters),

612: and ppa.action_type = 'X';
613:
614: CURSOR c_get_report_params_ytd IS
615: SELECT pay_us_psd_xml.get_parameter('TRANSFER_REPORTING_YEAR',ppa.legislative_parameters),
616: pay_us_psd_xml.get_parameter('TRANSFER_STATE',ppa.legislative_parameters),
617: pay_us_psd_xml.get_parameter('TRANSFER_PERIOD_TYPE',ppa.legislative_parameters)
618: FROM pay_payroll_actions ppa
619: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
620: and ppa.report_type in ('PSD_MAG_XML')

Line 617: pay_us_psd_xml.get_parameter('TRANSFER_PERIOD_TYPE',ppa.legislative_parameters)

613:
614: CURSOR c_get_report_params_ytd IS
615: SELECT pay_us_psd_xml.get_parameter('TRANSFER_REPORTING_YEAR',ppa.legislative_parameters),
616: pay_us_psd_xml.get_parameter('TRANSFER_STATE',ppa.legislative_parameters),
617: pay_us_psd_xml.get_parameter('TRANSFER_PERIOD_TYPE',ppa.legislative_parameters)
618: FROM pay_payroll_actions ppa
619: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
620: and ppa.report_type in ('PSD_MAG_XML')
621: and ppa.action_type = 'X'

Line 1223: hr_utility.set_location( 'pay_us_psd_xml.range_cursor', 10);

1219:
1220:
1221: BEGIN
1222: -- hr_utility.trace_on(null,'LOCALXML');
1223: hr_utility.set_location( 'pay_us_psd_xml.range_cursor', 10);
1224:
1225:
1226:
1227: get_report_parameters( p_pactid,

Line 1240: hr_utility.set_location( 'pay_us_psd_xml.range_cursor', 20);

1236: l_period_end,
1237: l_tax_coll_dist_code
1238: );
1239:
1240: hr_utility.set_location( 'pay_us_psd_xml.range_cursor', 20);
1241:
1242: update pay_payroll_actions
1243: set effective_date = l_period_end
1244: WHERE payroll_action_id = p_pactid;

Line 1296: hr_utility.set_location( 'pay_us_psd_xml.range_cursor', 30);

1292: UPDATE pay_payroll_actions
1293: SET magnetic_file_name = l_report_file_name
1294: WHERE payroll_action_id = p_pactid;
1295:
1296: hr_utility.set_location( 'pay_us_psd_xml.range_cursor', 30);
1297:
1298: hr_utility.trace('Checking pre process rules');
1299: if(pay_us_psd_xml.preprocess_check(p_pactid,l_business_group_id, l_tax_coll_dist_code)) then
1300: hr_utility.trace('Pre process rules returned true');

Line 1299: if(pay_us_psd_xml.preprocess_check(p_pactid,l_business_group_id, l_tax_coll_dist_code)) then

1295:
1296: hr_utility.set_location( 'pay_us_psd_xml.range_cursor', 30);
1297:
1298: hr_utility.trace('Checking pre process rules');
1299: if(pay_us_psd_xml.preprocess_check(p_pactid,l_business_group_id, l_tax_coll_dist_code)) then
1300: hr_utility.trace('Pre process rules returned true');
1301: else
1302: hr_utility.trace('Pre process rules returned false');
1303: NULL;

Line 1312: hr_utility.set_location( 'pay_us_psd_xml.range_cursor', 40);

1308: pay_core_utils.push_token('record_name',message_preprocess);
1309: pay_core_utils.push_token('description',message_text);*/
1310: end if; -- End of pre process rules check
1311:
1312: hr_utility.set_location( 'pay_us_psd_xml.range_cursor', 40);
1313: hr_utility.trace( 'Value of the l_period_type is: '||l_period_type);
1314:
1315: IF l_report_type = 'PSD_MAG_XML' THEN
1316:

Line 1342: hr_utility.set_location( 'pay_us_psd_xml.range_cursor', 50);

1338: AND HOI2.ORG_INFORMATION2 is not null)
1339: AND ASG.payroll_id is not null
1340: AND :payroll_action_id is not null
1341: ORDER BY ASG.person_id';
1342: hr_utility.set_location( 'pay_us_psd_xml.range_cursor', 50);
1343: else
1344: --Modified for the Bug 15944697
1345: p_sqlstr := 'SELECT DISTINCT to_number(paa.serial_number)
1346: FROM pay_assignment_actions paa,

Line 1377: hr_utility.set_location( 'pay_us_psd_xml.range_cursor', 50);

1373: WHERE hoi.organization_id = paa.tax_unit_id
1374: AND hoi.org_information_context = ''PSD Reporting Rules''
1375: )
1376: ORDER BY to_number(paa.serial_number)';
1377: hr_utility.set_location( 'pay_us_psd_xml.range_cursor', 50);
1378: end if;
1379: END IF;
1380: hr_utility.trace( p_sqlstr);
1381:

Line 1403: hr_utility.set_location( 'pay_us_psd_xml.range_cursor', 60);

1399:
1400: end if;
1401: close c_w2_reporting_rules;
1402:
1403: hr_utility.set_location( 'pay_us_psd_xml.range_cursor', 60);
1404: hr_utility.trace('Finished with W2 Reporting Rules check ');
1405:
1406: open c_psd_reporting_rules(l_trans_legal_co_id);
1407:

Line 1425: hr_utility.set_location( 'pay_us_psd_xml.range_cursor', 70);

1421:
1422: end if;
1423: close c_psd_reporting_rules;
1424:
1425: hr_utility.set_location( 'pay_us_psd_xml.range_cursor', 70);
1426: hr_utility.trace('Finished with PSD Reporting Rules check ');
1427:
1428:
1429: l_archive := chk_gre_archive(p_pactid);

Line 1440: hr_utility.set_location( 'pay_us_psd_xml.range_cursor', 80);

1436: if g_archive_flag = 'N' then
1437:
1438: hr_utility.trace('range_cursor archiving transmitter data');
1439: hr_utility.trace('l_trans_legal_co_id: '||l_trans_legal_co_id);
1440: hr_utility.set_location( 'pay_us_psd_xml.range_cursor', 80);
1441:
1442: archive_gre_data(p_payroll_action_id => p_pactid,
1443: p_tax_unit_id => l_trans_legal_co_id);
1444:

Line 1459: hr_utility.set_location( 'pay_us_psd_xml.range_cursor', 80);

1455: null;
1456: else
1457: hr_utility.trace('range_cursor archiving employer data');
1458: hr_utility.trace('l_tax_unit_id: '||l_tax_unit_id);
1459: hr_utility.set_location( 'pay_us_psd_xml.range_cursor', 80);
1460:
1461: archive_gre_data(p_payroll_action_id => p_pactid,
1462: p_tax_unit_id => l_tax_unit_id);
1463:

Line 1474: hr_utility.set_location( 'pay_us_psd_xml.range_cursor', 90);

1470:
1471: hr_utility.trace('range_cursor done with archiving employer data ');
1472:
1473: end if;
1474: hr_utility.set_location( 'pay_us_psd_xml.range_cursor', 90);
1475:
1476:
1477: END range_cursor;
1478:

Line 2125: l_user_entity_id_tab pay_us_psd_xml.number_data_type_table;

2121: psd_rules_rec c_get_psd_rules%ROWTYPE;
2122:
2123: l_user_entity_id ff_database_items.user_entity_id%type;
2124: l_jurisdiction_code varchar2(100);
2125: l_user_entity_id_tab pay_us_psd_xml.number_data_type_table;
2126: l_value_tab pay_us_psd_xml.char240_data_type_table;
2127: l_object_version_number number;
2128: l_archive_item_id number;
2129: l_some_warning boolean;

Line 2126: l_value_tab pay_us_psd_xml.char240_data_type_table;

2122:
2123: l_user_entity_id ff_database_items.user_entity_id%type;
2124: l_jurisdiction_code varchar2(100);
2125: l_user_entity_id_tab pay_us_psd_xml.number_data_type_table;
2126: l_value_tab pay_us_psd_xml.char240_data_type_table;
2127: l_object_version_number number;
2128: l_archive_item_id number;
2129: l_some_warning boolean;
2130: l_arch_gre_step number := 0;

Line 2706: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_name

2702: hr_utility.set_location('action_archinit', 180);
2703:
2704: ln_psd_count := ln_psd_count + 1;
2705:
2706: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_name
2707: := lv_balance_name;
2708:
2709:
2710: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_type_id

Line 2710: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_type_id

2706: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_name
2707: := lv_balance_name;
2708:
2709:
2710: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_type_id
2711: := ln_balance_type_id;
2712: hr_utility.trace('lv_balance_name= ' ||lv_balance_name);
2713: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_name= ' ||
2714: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_name);

Line 2713: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_name= ' ||

2709:
2710: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_type_id
2711: := ln_balance_type_id;
2712: hr_utility.trace('lv_balance_name= ' ||lv_balance_name);
2713: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_name= ' ||
2714: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_name);
2715: hr_utility.trace('ln_balance_type_id= ' ||ln_balance_type_id);
2716: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_type_id= ' ||
2717: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_type_id);

Line 2714: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_name);

2710: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_type_id
2711: := ln_balance_type_id;
2712: hr_utility.trace('lv_balance_name= ' ||lv_balance_name);
2713: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_name= ' ||
2714: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_name);
2715: hr_utility.trace('ln_balance_type_id= ' ||ln_balance_type_id);
2716: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_type_id= ' ||
2717: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_type_id);
2718:

Line 2716: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_type_id= ' ||

2712: hr_utility.trace('lv_balance_name= ' ||lv_balance_name);
2713: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_name= ' ||
2714: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_name);
2715: hr_utility.trace('ln_balance_type_id= ' ||ln_balance_type_id);
2716: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_type_id= ' ||
2717: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_type_id);
2718:
2719:
2720: IF (instr(lv_balance_name, 'MONTH') <> 0) THEN

Line 2717: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_type_id);

2713: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_name= ' ||
2714: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_name);
2715: hr_utility.trace('ln_balance_type_id= ' ||ln_balance_type_id);
2716: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_type_id= ' ||
2717: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_type_id);
2718:
2719:
2720: IF (instr(lv_balance_name, 'MONTH') <> 0) THEN
2721:

Line 2722: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).qtd_def_bal_id

2718:
2719:
2720: IF (instr(lv_balance_name, 'MONTH') <> 0) THEN
2721:
2722: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).qtd_def_bal_id
2723: := NULL;
2724: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).month_def_bal_id
2725: := get_defined_balance_id(l_business_group_id,
2726: substr(lv_balance_name, 1 , (instr(lv_balance_name, 'MONTH')-2)),

Line 2724: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).month_def_bal_id

2720: IF (instr(lv_balance_name, 'MONTH') <> 0) THEN
2721:
2722: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).qtd_def_bal_id
2723: := NULL;
2724: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).month_def_bal_id
2725: := get_defined_balance_id(l_business_group_id,
2726: substr(lv_balance_name, 1 , (instr(lv_balance_name, 'MONTH')-2)),
2727: '_PER_JD_GRE_MONTH');
2728:

Line 2730: into pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).dbi_name

2726: substr(lv_balance_name, 1 , (instr(lv_balance_name, 'MONTH')-2)),
2727: '_PER_JD_GRE_MONTH');
2728:
2729: select USER_ENTITY_NAME
2730: into pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).dbi_name
2731: from ff_user_entities
2732: where creator_id= (pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).month_def_bal_id)
2733: and CREATOR_TYPE='B';
2734:

Line 2732: where creator_id= (pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).month_def_bal_id)

2728:
2729: select USER_ENTITY_NAME
2730: into pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).dbi_name
2731: from ff_user_entities
2732: where creator_id= (pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).month_def_bal_id)
2733: and CREATOR_TYPE='B';
2734:
2735: ELSIF (instr(lv_balance_name, 'QTD') <> 0) THEN
2736: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).month_def_bal_id

Line 2736: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).month_def_bal_id

2732: where creator_id= (pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).month_def_bal_id)
2733: and CREATOR_TYPE='B';
2734:
2735: ELSIF (instr(lv_balance_name, 'QTD') <> 0) THEN
2736: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).month_def_bal_id
2737: := NULL;
2738: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).qtd_def_bal_id
2739: := get_defined_balance_id(l_business_group_id,
2740: substr(lv_balance_name, 1 , (instr(lv_balance_name, 'QTD')-2)),

Line 2738: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).qtd_def_bal_id

2734:
2735: ELSIF (instr(lv_balance_name, 'QTD') <> 0) THEN
2736: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).month_def_bal_id
2737: := NULL;
2738: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).qtd_def_bal_id
2739: := get_defined_balance_id(l_business_group_id,
2740: substr(lv_balance_name, 1 , (instr(lv_balance_name, 'QTD')-2)),
2741: '_PER_JD_GRE_QTD');
2742: select USER_ENTITY_NAME

Line 2743: into pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).dbi_name

2739: := get_defined_balance_id(l_business_group_id,
2740: substr(lv_balance_name, 1 , (instr(lv_balance_name, 'QTD')-2)),
2741: '_PER_JD_GRE_QTD');
2742: select USER_ENTITY_NAME
2743: into pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).dbi_name
2744: from ff_user_entities
2745: where creator_id= (pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).qtd_def_bal_id)
2746: and CREATOR_TYPE='B';
2747: END IF;

Line 2745: where creator_id= (pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).qtd_def_bal_id)

2741: '_PER_JD_GRE_QTD');
2742: select USER_ENTITY_NAME
2743: into pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).dbi_name
2744: from ff_user_entities
2745: where creator_id= (pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).qtd_def_bal_id)
2746: and CREATOR_TYPE='B';
2747: END IF;
2748:
2749: hr_utility.set_location('action_archinit', 190);

Line 2751: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).dbi_name);

2747: END IF;
2748:
2749: hr_utility.set_location('action_archinit', 190);
2750: hr_utility.trace('PSD DBI Name= ' ||
2751: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).dbi_name);
2752: hr_utility.trace('lv_balance_name= ' ||lv_balance_name);
2753: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_name= ' ||
2754: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_name);
2755: hr_utility.trace('ln_balance_type_id= ' ||ln_balance_type_id);

Line 2753: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_name= ' ||

2749: hr_utility.set_location('action_archinit', 190);
2750: hr_utility.trace('PSD DBI Name= ' ||
2751: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).dbi_name);
2752: hr_utility.trace('lv_balance_name= ' ||lv_balance_name);
2753: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_name= ' ||
2754: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_name);
2755: hr_utility.trace('ln_balance_type_id= ' ||ln_balance_type_id);
2756: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_type_id= ' ||
2757: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_type_id);

Line 2754: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_name);

2750: hr_utility.trace('PSD DBI Name= ' ||
2751: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).dbi_name);
2752: hr_utility.trace('lv_balance_name= ' ||lv_balance_name);
2753: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_name= ' ||
2754: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_name);
2755: hr_utility.trace('ln_balance_type_id= ' ||ln_balance_type_id);
2756: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_type_id= ' ||
2757: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_type_id);
2758:

Line 2756: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_type_id= ' ||

2752: hr_utility.trace('lv_balance_name= ' ||lv_balance_name);
2753: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_name= ' ||
2754: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_name);
2755: hr_utility.trace('ln_balance_type_id= ' ||ln_balance_type_id);
2756: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_type_id= ' ||
2757: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_type_id);
2758:
2759: end loop;
2760: close c_get_psd_balances;

Line 2757: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_type_id);

2753: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_name= ' ||
2754: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_name);
2755: hr_utility.trace('ln_balance_type_id= ' ||ln_balance_type_id);
2756: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_type_id= ' ||
2757: pay_us_psd_xml.ltr_psd_tax_bal(ln_psd_count).balance_type_id);
2758:
2759: end loop;
2760: close c_get_psd_balances;
2761:

Line 2763: pay_us_psd_xml.ltr_psd_tax_bal.count);

2759: end loop;
2760: close c_get_psd_balances;
2761:
2762: hr_utility.trace('PSD Balance Loop Count = ' ||
2763: pay_us_psd_xml.ltr_psd_tax_bal.count);
2764:
2765: END action_archinit;
2766:
2767:

Line 2823: l_user_entity_id_tab pay_us_psd_xml.number_data_type_table;

2819:
2820: l_user_entity_id ff_database_items.user_entity_id%type;
2821: l_jurisdiction VARCHAR2(30);
2822:
2823: l_user_entity_id_tab pay_us_psd_xml.number_data_type_table;
2824: -- l_user_entity_tab pay_us_psd_xml.char240_data_type_table;
2825: l_value_tab pay_us_psd_xml.char240_data_type_table;
2826: l_object_version_number number;
2827: l_archive_item_id number;

Line 2824: -- l_user_entity_tab pay_us_psd_xml.char240_data_type_table;

2820: l_user_entity_id ff_database_items.user_entity_id%type;
2821: l_jurisdiction VARCHAR2(30);
2822:
2823: l_user_entity_id_tab pay_us_psd_xml.number_data_type_table;
2824: -- l_user_entity_tab pay_us_psd_xml.char240_data_type_table;
2825: l_value_tab pay_us_psd_xml.char240_data_type_table;
2826: l_object_version_number number;
2827: l_archive_item_id number;
2828: l_some_warning boolean;

Line 2825: l_value_tab pay_us_psd_xml.char240_data_type_table;

2821: l_jurisdiction VARCHAR2(30);
2822:
2823: l_user_entity_id_tab pay_us_psd_xml.number_data_type_table;
2824: -- l_user_entity_tab pay_us_psd_xml.char240_data_type_table;
2825: l_value_tab pay_us_psd_xml.char240_data_type_table;
2826: l_object_version_number number;
2827: l_archive_item_id number;
2828: l_some_warning boolean;
2829:

Line 3046: if pay_us_psd_xml.ltr_psd_tax_bal.count > 0 then

3042: end if; --period type
3043:
3044: if (l_psd_balance_value<>0) then
3045:
3046: if pay_us_psd_xml.ltr_psd_tax_bal.count > 0 then
3047: for k in pay_us_psd_xml.ltr_psd_tax_bal.first..
3048: pay_us_psd_xml.ltr_psd_tax_bal.last loop
3049:
3050: lv_balance_name :=

Line 3047: for k in pay_us_psd_xml.ltr_psd_tax_bal.first..

3043:
3044: if (l_psd_balance_value<>0) then
3045:
3046: if pay_us_psd_xml.ltr_psd_tax_bal.count > 0 then
3047: for k in pay_us_psd_xml.ltr_psd_tax_bal.first..
3048: pay_us_psd_xml.ltr_psd_tax_bal.last loop
3049:
3050: lv_balance_name :=
3051: pay_us_psd_xml.ltr_psd_tax_bal(k).balance_name;

Line 3048: pay_us_psd_xml.ltr_psd_tax_bal.last loop

3044: if (l_psd_balance_value<>0) then
3045:
3046: if pay_us_psd_xml.ltr_psd_tax_bal.count > 0 then
3047: for k in pay_us_psd_xml.ltr_psd_tax_bal.first..
3048: pay_us_psd_xml.ltr_psd_tax_bal.last loop
3049:
3050: lv_balance_name :=
3051: pay_us_psd_xml.ltr_psd_tax_bal(k).balance_name;
3052: ln_balance_type_id :=

Line 3051: pay_us_psd_xml.ltr_psd_tax_bal(k).balance_name;

3047: for k in pay_us_psd_xml.ltr_psd_tax_bal.first..
3048: pay_us_psd_xml.ltr_psd_tax_bal.last loop
3049:
3050: lv_balance_name :=
3051: pay_us_psd_xml.ltr_psd_tax_bal(k).balance_name;
3052: ln_balance_type_id :=
3053: pay_us_psd_xml.ltr_psd_tax_bal(k).balance_type_id;
3054: ln_qtd_def_bal_id :=
3055: pay_us_psd_xml.ltr_psd_tax_bal(k).qtd_def_bal_id;

Line 3053: pay_us_psd_xml.ltr_psd_tax_bal(k).balance_type_id;

3049:
3050: lv_balance_name :=
3051: pay_us_psd_xml.ltr_psd_tax_bal(k).balance_name;
3052: ln_balance_type_id :=
3053: pay_us_psd_xml.ltr_psd_tax_bal(k).balance_type_id;
3054: ln_qtd_def_bal_id :=
3055: pay_us_psd_xml.ltr_psd_tax_bal(k).qtd_def_bal_id;
3056: ln_month_def_bal_id :=
3057: pay_us_psd_xml.ltr_psd_tax_bal(k).month_def_bal_id;

Line 3055: pay_us_psd_xml.ltr_psd_tax_bal(k).qtd_def_bal_id;

3051: pay_us_psd_xml.ltr_psd_tax_bal(k).balance_name;
3052: ln_balance_type_id :=
3053: pay_us_psd_xml.ltr_psd_tax_bal(k).balance_type_id;
3054: ln_qtd_def_bal_id :=
3055: pay_us_psd_xml.ltr_psd_tax_bal(k).qtd_def_bal_id;
3056: ln_month_def_bal_id :=
3057: pay_us_psd_xml.ltr_psd_tax_bal(k).month_def_bal_id;
3058:
3059: hr_utility.trace('k ='||k);

Line 3057: pay_us_psd_xml.ltr_psd_tax_bal(k).month_def_bal_id;

3053: pay_us_psd_xml.ltr_psd_tax_bal(k).balance_type_id;
3054: ln_qtd_def_bal_id :=
3055: pay_us_psd_xml.ltr_psd_tax_bal(k).qtd_def_bal_id;
3056: ln_month_def_bal_id :=
3057: pay_us_psd_xml.ltr_psd_tax_bal(k).month_def_bal_id;
3058:
3059: hr_utility.trace('k ='||k);
3060: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(k).balance_name ='|| pay_us_psd_xml.ltr_psd_tax_bal(k).balance_name);
3061: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(k).balance_type_id ='||pay_us_psd_xml.ltr_psd_tax_bal(k).balance_type_id);

Line 3060: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(k).balance_name ='|| pay_us_psd_xml.ltr_psd_tax_bal(k).balance_name);

3056: ln_month_def_bal_id :=
3057: pay_us_psd_xml.ltr_psd_tax_bal(k).month_def_bal_id;
3058:
3059: hr_utility.trace('k ='||k);
3060: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(k).balance_name ='|| pay_us_psd_xml.ltr_psd_tax_bal(k).balance_name);
3061: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(k).balance_type_id ='||pay_us_psd_xml.ltr_psd_tax_bal(k).balance_type_id);
3062: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(k).qtd_def_bal_id ='||pay_us_psd_xml.ltr_psd_tax_bal(k).qtd_def_bal_id);
3063: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(k).month_def_bal_id ='||pay_us_psd_xml.ltr_psd_tax_bal(k).month_def_bal_id);
3064: hr_utility.trace('lv_balance_name ='||lv_balance_name);

Line 3061: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(k).balance_type_id ='||pay_us_psd_xml.ltr_psd_tax_bal(k).balance_type_id);

3057: pay_us_psd_xml.ltr_psd_tax_bal(k).month_def_bal_id;
3058:
3059: hr_utility.trace('k ='||k);
3060: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(k).balance_name ='|| pay_us_psd_xml.ltr_psd_tax_bal(k).balance_name);
3061: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(k).balance_type_id ='||pay_us_psd_xml.ltr_psd_tax_bal(k).balance_type_id);
3062: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(k).qtd_def_bal_id ='||pay_us_psd_xml.ltr_psd_tax_bal(k).qtd_def_bal_id);
3063: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(k).month_def_bal_id ='||pay_us_psd_xml.ltr_psd_tax_bal(k).month_def_bal_id);
3064: hr_utility.trace('lv_balance_name ='||lv_balance_name);
3065: hr_utility.trace('ln_balance_type_id ='||ln_balance_type_id);

Line 3062: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(k).qtd_def_bal_id ='||pay_us_psd_xml.ltr_psd_tax_bal(k).qtd_def_bal_id);

3058:
3059: hr_utility.trace('k ='||k);
3060: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(k).balance_name ='|| pay_us_psd_xml.ltr_psd_tax_bal(k).balance_name);
3061: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(k).balance_type_id ='||pay_us_psd_xml.ltr_psd_tax_bal(k).balance_type_id);
3062: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(k).qtd_def_bal_id ='||pay_us_psd_xml.ltr_psd_tax_bal(k).qtd_def_bal_id);
3063: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(k).month_def_bal_id ='||pay_us_psd_xml.ltr_psd_tax_bal(k).month_def_bal_id);
3064: hr_utility.trace('lv_balance_name ='||lv_balance_name);
3065: hr_utility.trace('ln_balance_type_id ='||ln_balance_type_id);
3066: hr_utility.trace('ln_qtd_def_bal_id='||ln_qtd_def_bal_id);

Line 3063: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(k).month_def_bal_id ='||pay_us_psd_xml.ltr_psd_tax_bal(k).month_def_bal_id);

3059: hr_utility.trace('k ='||k);
3060: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(k).balance_name ='|| pay_us_psd_xml.ltr_psd_tax_bal(k).balance_name);
3061: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(k).balance_type_id ='||pay_us_psd_xml.ltr_psd_tax_bal(k).balance_type_id);
3062: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(k).qtd_def_bal_id ='||pay_us_psd_xml.ltr_psd_tax_bal(k).qtd_def_bal_id);
3063: hr_utility.trace('pay_us_psd_xml.ltr_psd_tax_bal(k).month_def_bal_id ='||pay_us_psd_xml.ltr_psd_tax_bal(k).month_def_bal_id);
3064: hr_utility.trace('lv_balance_name ='||lv_balance_name);
3065: hr_utility.trace('ln_balance_type_id ='||ln_balance_type_id);
3066: hr_utility.trace('ln_qtd_def_bal_id='||ln_qtd_def_bal_id);
3067: hr_utility.trace('ln_month_def_bal_id ='||ln_month_def_bal_id);

Line 3068: hr_utility.trace('DBI ='||pay_us_psd_xml.ltr_psd_tax_bal(k).dbi_name);

3064: hr_utility.trace('lv_balance_name ='||lv_balance_name);
3065: hr_utility.trace('ln_balance_type_id ='||ln_balance_type_id);
3066: hr_utility.trace('ln_qtd_def_bal_id='||ln_qtd_def_bal_id);
3067: hr_utility.trace('ln_month_def_bal_id ='||ln_month_def_bal_id);
3068: hr_utility.trace('DBI ='||pay_us_psd_xml.ltr_psd_tax_bal(k).dbi_name);
3069:
3070: --if p_action_type in ('U', 'P') then
3071:
3072: if ln_qtd_def_bal_id is NULL then

Line 3085: l_user_entity_id:= get_user_entity_id('A_'||(pay_us_psd_xml.ltr_psd_tax_bal(k).dbi_name));

3081: hr_utility.trace('ln_bal_value (in qtd) ='||ln_bal_value);
3082: end if;
3083: hr_utility.trace('ln_bal_value = '|| ln_bal_value);
3084:
3085: l_user_entity_id:= get_user_entity_id('A_'||(pay_us_psd_xml.ltr_psd_tax_bal(k).dbi_name));
3086:
3087: ff_archive_api.create_archive_item(
3088: p_archive_item_id => l_archive_item_id
3089: ,p_user_entity_id => l_user_entity_id

Line 3224: g_proc_name := 'PAY_US_PSD_XML.';

3220: end archive_data;
3221:
3222: BEGIN
3223:
3224: g_proc_name := 'PAY_US_PSD_XML.';
3225: g_debug := hr_utility.debug_enabled;
3226: g_document_type := 'LOCAL_PSD_XML';
3227:
3228: END pay_us_psd_xml;

Line 3228: END pay_us_psd_xml;

3224: g_proc_name := 'PAY_US_PSD_XML.';
3225: g_debug := hr_utility.debug_enabled;
3226: g_document_type := 'LOCAL_PSD_XML';
3227:
3228: END pay_us_psd_xml;