APPS.PQP_ALIEN_EXPAT_TAXATION_PKG dependencies on PQP_ANALYZED_ALIEN_DATA

Line 3128: l_analyzed_data_id pqp_analyzed_alien_data.analyzed_data_id%type ;

3124: l_date_of_birth date ;
3125: l_sit_flag boolean ;
3126: l_analyzed_data_details_id
3127: pqp_analyzed_alien_details.analyzed_data_details_id%type;
3128: l_analyzed_data_id pqp_analyzed_alien_data.analyzed_data_id%type ;
3129: l_exemption_code pqp_analyzed_alien_details.exemption_code%type;
3130: l_withholding_rate
3131: pqp_analyzed_alien_details.withholding_rate%type ;
3132: l_wh_allowance

Line 3133: pqp_analyzed_alien_data.withldg_allow_eligible_flag%type;

3129: l_exemption_code pqp_analyzed_alien_details.exemption_code%type;
3130: l_withholding_rate
3131: pqp_analyzed_alien_details.withholding_rate%type ;
3132: l_wh_allowance
3133: pqp_analyzed_alien_data.withldg_allow_eligible_flag%type;
3134: l_income_code_sub_type
3135: pqp_analyzed_alien_details.income_code_sub_type%type ;
3136: l_constant_addl_tax pqp_analyzed_alien_details.constant_addl_tax%type ;
3137:

Line 3166: from pqp_analyzed_alien_data paadat ,

3162: exemption_code ,
3163: withholding_rate ,
3164: income_code_sub_type ,
3165: constant_addl_tax
3166: from pqp_analyzed_alien_data paadat ,
3167: pqp_analyzed_alien_details paadet ,
3168: per_people_f ppf ,
3169: per_assignments_f paf
3170: where paadat.analyzed_data_id = paadet.analyzed_data_id

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

4703:
4704:
4705: /****************************************************************************
4706: name : pqp_write_public
4707: Purpose : the procedure write data into PQP_ANALYZED_ALIEN_DATA,
4708: PQP_ANALYZED_ALIEN_DETAILS, and PQP_ANALYZED_ALIEN_DATA tables.
4709: Arguments :
4710: in
4711: Notes : public

Line 4708: PQP_ANALYZED_ALIEN_DETAILS, and PQP_ANALYZED_ALIEN_DATA tables.

4704:
4705: /****************************************************************************
4706: name : pqp_write_public
4707: Purpose : the procedure write data into PQP_ANALYZED_ALIEN_DATA,
4708: PQP_ANALYZED_ALIEN_DETAILS, and PQP_ANALYZED_ALIEN_DATA tables.
4709: Arguments :
4710: in
4711: Notes : public
4712: ****************************************************************************/

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

4888: where national_identifier = p_social_security_number
4889: and rownum =1;
4890: --
4891: -- The following cursor verifies whether an assignment exists in the given tax
4892: -- year in pqp_analyzed_alien_data table or not.
4893: --
4894: cursor c_assign_exists(p_assignment_id in number
4895: ,p_tax_year in number) is
4896: select analyzed_data_id

Line 4898: from pqp_analyzed_alien_data

4894: cursor c_assign_exists(p_assignment_id in number
4895: ,p_tax_year in number) is
4896: select analyzed_data_id
4897: ,object_version_number
4898: from pqp_analyzed_alien_data
4899: where assignment_id = p_assignment_id
4900: and tax_year = p_tax_year;
4901: --
4902: -- The following cursor verifies whether an income_code exists in

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

5356: -- ==============================================
5357: -- W4 record creation
5358: -- ==============================================
5359: -- A W4 record will be created under the following conditions.
5360: -- 1. no data is present in the PQP_ANALYZED_ALIEN_DATA (This happens
5361: -- for the first time only),
5362: -- 2. date_w4_signed field is not null in the
5363: -- PQP_ALIEN_TRANSACTION_DATA table.
5364: -- 3. Either of the following values is present

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

5462: hr_utility.set_location(l_proc, 130);
5463: -- The following cursor checks whether an assignment exists in
5464: -- pqp_alien_data table for a given year or not
5465: --
5466: l_logic_state := ' while inserting in PQP_ANALYZED_ALIEN_DATA:';
5467:
5468: if (c_assign_exists%isopen = true) then
5469: close c_assign_exists;
5470: end if;

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

5476: open c_assign_exists(l_cpa_assignment_id ,
5477: p_taxyear );
5478: --
5479: -- c_assign_exists checks whether the given assignment exists in
5480: -- the pqp_analyzed_alien_data_api table for the given year or not
5481: --
5482: fetch c_assign_exists into l_analyzed_data_id ,
5483: l_analyzed_data_ovn ;
5484: hr_utility.set_location(l_proc, 140);

Line 5497: pqp_analyzed_alien_data_api.create_analyzed_alien_data

5493: if (c_assign_exists%isopen = true) then
5494: close c_assign_exists;
5495: end if;
5496:
5497: pqp_analyzed_alien_data_api.create_analyzed_alien_data
5498: (p_validate => false
5499: ,p_analyzed_data_id => l_analyzed_data_id
5500: ,p_assignment_id => l_cpa_assignment_id
5501: ,p_data_source => 'PQP_US_ALIEN_WINDSTAR'

Line 5532: pqp_analyzed_alien_data_api.update_analyzed_alien_data

5528:
5529: if (c_assign_exists%isopen = true) then
5530: close c_assign_exists;
5531: end if;
5532: pqp_analyzed_alien_data_api.update_analyzed_alien_data
5533: (p_validate => false
5534: ,p_analyzed_data_id => l_analyzed_data_id
5535: ,p_assignment_id => l_cpa_assignment_id
5536: ,p_data_source => 'PQP_US_ALIEN_WINDSTAR'