APPS.PQP_ALIEN_EXPAT_TAXATION_PKG dependencies on PQP_ANALYZED_ALIEN_DATA

Line 3132: l_analyzed_data_id pqp_analyzed_alien_data.analyzed_data_id%type ;

3128: l_date_of_birth date ;
3129: l_sit_flag boolean ;
3130: l_analyzed_data_details_id
3131: pqp_analyzed_alien_details.analyzed_data_details_id%type;
3132: l_analyzed_data_id pqp_analyzed_alien_data.analyzed_data_id%type ;
3133: l_exemption_code pqp_analyzed_alien_details.exemption_code%type;
3134: l_withholding_rate
3135: pqp_analyzed_alien_details.withholding_rate%type ;
3136: l_wh_allowance

Line 3137: pqp_analyzed_alien_data.withldg_allow_eligible_flag%type;

3133: l_exemption_code pqp_analyzed_alien_details.exemption_code%type;
3134: l_withholding_rate
3135: pqp_analyzed_alien_details.withholding_rate%type ;
3136: l_wh_allowance
3137: pqp_analyzed_alien_data.withldg_allow_eligible_flag%type;
3138: l_income_code_sub_type
3139: pqp_analyzed_alien_details.income_code_sub_type%type ;
3140: l_constant_addl_tax pqp_analyzed_alien_details.constant_addl_tax%type ;
3141:

Line 3170: from pqp_analyzed_alien_data paadat ,

3166: exemption_code ,
3167: withholding_rate ,
3168: income_code_sub_type ,
3169: constant_addl_tax
3170: from pqp_analyzed_alien_data paadat ,
3171: pqp_analyzed_alien_details paadet ,
3172: per_people_f ppf ,
3173: per_assignments_f paf
3174: where paadat.analyzed_data_id = paadet.analyzed_data_id

Line 4722: Purpose : the procedure write data into PQP_ANALYZED_ALIEN_DATA,

4718:
4719:
4720: /****************************************************************************
4721: name : pqp_write_public
4722: Purpose : the procedure write data into PQP_ANALYZED_ALIEN_DATA,
4723: PQP_ANALYZED_ALIEN_DETAILS, and PQP_ANALYZED_ALIEN_DATA tables.
4724: Arguments :
4725: in
4726: Notes : public

Line 4723: PQP_ANALYZED_ALIEN_DETAILS, and PQP_ANALYZED_ALIEN_DATA tables.

4719:
4720: /****************************************************************************
4721: name : pqp_write_public
4722: Purpose : the procedure write data into PQP_ANALYZED_ALIEN_DATA,
4723: PQP_ANALYZED_ALIEN_DETAILS, and PQP_ANALYZED_ALIEN_DATA tables.
4724: Arguments :
4725: in
4726: Notes : public
4727: ****************************************************************************/

Line 4907: -- year in pqp_analyzed_alien_data table or not.

4903: where national_identifier = p_social_security_number
4904: and rownum =1;
4905: --
4906: -- The following cursor verifies whether an assignment exists in the given tax
4907: -- year in pqp_analyzed_alien_data table or not.
4908: --
4909: cursor c_assign_exists(p_assignment_id in number
4910: ,p_tax_year in number) is
4911: select analyzed_data_id

Line 4913: from pqp_analyzed_alien_data

4909: cursor c_assign_exists(p_assignment_id in number
4910: ,p_tax_year in number) is
4911: select analyzed_data_id
4912: ,object_version_number
4913: from pqp_analyzed_alien_data
4914: where assignment_id = p_assignment_id
4915: and tax_year = p_tax_year;
4916: --
4917: -- The following cursor verifies whether an income_code exists in

Line 5375: -- 1. no data is present in the PQP_ANALYZED_ALIEN_DATA (This happens

5371: -- ==============================================
5372: -- W4 record creation
5373: -- ==============================================
5374: -- A W4 record will be created under the following conditions.
5375: -- 1. no data is present in the PQP_ANALYZED_ALIEN_DATA (This happens
5376: -- for the first time only),
5377: -- 2. date_w4_signed field is not null in the
5378: -- PQP_ALIEN_TRANSACTION_DATA table.
5379: -- 3. Either of the following values is present

Line 5481: l_logic_state := ' while inserting in PQP_ANALYZED_ALIEN_DATA:';

5477: hr_utility.set_location(l_proc, 130);
5478: -- The following cursor checks whether an assignment exists in
5479: -- pqp_alien_data table for a given year or not
5480: --
5481: l_logic_state := ' while inserting in PQP_ANALYZED_ALIEN_DATA:';
5482:
5483: if (c_assign_exists%isopen = true) then
5484: close c_assign_exists;
5485: end if;

Line 5495: -- the pqp_analyzed_alien_data_api table for the given year or not

5491: open c_assign_exists(l_cpa_assignment_id ,
5492: p_taxyear );
5493: --
5494: -- c_assign_exists checks whether the given assignment exists in
5495: -- the pqp_analyzed_alien_data_api table for the given year or not
5496: --
5497: fetch c_assign_exists into l_analyzed_data_id ,
5498: l_analyzed_data_ovn ;
5499: hr_utility.set_location(l_proc, 140);

Line 5512: pqp_analyzed_alien_data_api.create_analyzed_alien_data

5508: if (c_assign_exists%isopen = true) then
5509: close c_assign_exists;
5510: end if;
5511:
5512: pqp_analyzed_alien_data_api.create_analyzed_alien_data
5513: (p_validate => false
5514: ,p_analyzed_data_id => l_analyzed_data_id
5515: ,p_assignment_id => l_cpa_assignment_id
5516: ,p_data_source => 'PQP_US_ALIEN_WINDSTAR'

Line 5547: pqp_analyzed_alien_data_api.update_analyzed_alien_data

5543:
5544: if (c_assign_exists%isopen = true) then
5545: close c_assign_exists;
5546: end if;
5547: pqp_analyzed_alien_data_api.update_analyzed_alien_data
5548: (p_validate => false
5549: ,p_analyzed_data_id => l_analyzed_data_id
5550: ,p_assignment_id => l_cpa_assignment_id
5551: ,p_data_source => 'PQP_US_ALIEN_WINDSTAR'