APPS.ZX_TCM_CONTROL_PKG dependencies on ZX_REGISTRATIONS

Line 40: registration_id zx_registrations.registration_id%type,

36: -- calculationwe do not find any registration record in the database and cache and we keep on
37: -- searching the databse for a registration record for every tax line only to find that a
38: -- record does not exist in the database.
39: dummy_flag VARCHAR2(1),
40: registration_id zx_registrations.registration_id%type,
41: registration_type_code zx_registrations.registration_type_code%type,
42: registration_number zx_registrations.registration_number%type,
43: validation_rule zx_registrations.validation_rule%type,
44: tax_authority_id zx_registrations.tax_authority_id%type,

Line 41: registration_type_code zx_registrations.registration_type_code%type,

37: -- searching the databse for a registration record for every tax line only to find that a
38: -- record does not exist in the database.
39: dummy_flag VARCHAR2(1),
40: registration_id zx_registrations.registration_id%type,
41: registration_type_code zx_registrations.registration_type_code%type,
42: registration_number zx_registrations.registration_number%type,
43: validation_rule zx_registrations.validation_rule%type,
44: tax_authority_id zx_registrations.tax_authority_id%type,
45: rep_tax_authority_id zx_registrations.rep_tax_authority_id%type,

Line 42: registration_number zx_registrations.registration_number%type,

38: -- record does not exist in the database.
39: dummy_flag VARCHAR2(1),
40: registration_id zx_registrations.registration_id%type,
41: registration_type_code zx_registrations.registration_type_code%type,
42: registration_number zx_registrations.registration_number%type,
43: validation_rule zx_registrations.validation_rule%type,
44: tax_authority_id zx_registrations.tax_authority_id%type,
45: rep_tax_authority_id zx_registrations.rep_tax_authority_id%type,
46: coll_Tax_authority_id zx_registrations.coll_tax_authority_id%type,

Line 43: validation_rule zx_registrations.validation_rule%type,

39: dummy_flag VARCHAR2(1),
40: registration_id zx_registrations.registration_id%type,
41: registration_type_code zx_registrations.registration_type_code%type,
42: registration_number zx_registrations.registration_number%type,
43: validation_rule zx_registrations.validation_rule%type,
44: tax_authority_id zx_registrations.tax_authority_id%type,
45: rep_tax_authority_id zx_registrations.rep_tax_authority_id%type,
46: coll_Tax_authority_id zx_registrations.coll_tax_authority_id%type,
47: rounding_rule_code zx_registrations.rounding_rule_code%type,

Line 44: tax_authority_id zx_registrations.tax_authority_id%type,

40: registration_id zx_registrations.registration_id%type,
41: registration_type_code zx_registrations.registration_type_code%type,
42: registration_number zx_registrations.registration_number%type,
43: validation_rule zx_registrations.validation_rule%type,
44: tax_authority_id zx_registrations.tax_authority_id%type,
45: rep_tax_authority_id zx_registrations.rep_tax_authority_id%type,
46: coll_Tax_authority_id zx_registrations.coll_tax_authority_id%type,
47: rounding_rule_code zx_registrations.rounding_rule_code%type,
48: tax_jurisdiction_code zx_registrations.tax_jurisdiction_code%type,

Line 45: rep_tax_authority_id zx_registrations.rep_tax_authority_id%type,

41: registration_type_code zx_registrations.registration_type_code%type,
42: registration_number zx_registrations.registration_number%type,
43: validation_rule zx_registrations.validation_rule%type,
44: tax_authority_id zx_registrations.tax_authority_id%type,
45: rep_tax_authority_id zx_registrations.rep_tax_authority_id%type,
46: coll_Tax_authority_id zx_registrations.coll_tax_authority_id%type,
47: rounding_rule_code zx_registrations.rounding_rule_code%type,
48: tax_jurisdiction_code zx_registrations.tax_jurisdiction_code%type,
49: self_assess_flag zx_registrations.self_assess_flag%type,

Line 46: coll_Tax_authority_id zx_registrations.coll_tax_authority_id%type,

42: registration_number zx_registrations.registration_number%type,
43: validation_rule zx_registrations.validation_rule%type,
44: tax_authority_id zx_registrations.tax_authority_id%type,
45: rep_tax_authority_id zx_registrations.rep_tax_authority_id%type,
46: coll_Tax_authority_id zx_registrations.coll_tax_authority_id%type,
47: rounding_rule_code zx_registrations.rounding_rule_code%type,
48: tax_jurisdiction_code zx_registrations.tax_jurisdiction_code%type,
49: self_assess_flag zx_registrations.self_assess_flag%type,
50: registration_status_code zx_registrations.registration_status_code%type,

Line 47: rounding_rule_code zx_registrations.rounding_rule_code%type,

43: validation_rule zx_registrations.validation_rule%type,
44: tax_authority_id zx_registrations.tax_authority_id%type,
45: rep_tax_authority_id zx_registrations.rep_tax_authority_id%type,
46: coll_Tax_authority_id zx_registrations.coll_tax_authority_id%type,
47: rounding_rule_code zx_registrations.rounding_rule_code%type,
48: tax_jurisdiction_code zx_registrations.tax_jurisdiction_code%type,
49: self_assess_flag zx_registrations.self_assess_flag%type,
50: registration_status_code zx_registrations.registration_status_code%type,
51: registration_source_code zx_registrations.registration_source_code%type,

Line 48: tax_jurisdiction_code zx_registrations.tax_jurisdiction_code%type,

44: tax_authority_id zx_registrations.tax_authority_id%type,
45: rep_tax_authority_id zx_registrations.rep_tax_authority_id%type,
46: coll_Tax_authority_id zx_registrations.coll_tax_authority_id%type,
47: rounding_rule_code zx_registrations.rounding_rule_code%type,
48: tax_jurisdiction_code zx_registrations.tax_jurisdiction_code%type,
49: self_assess_flag zx_registrations.self_assess_flag%type,
50: registration_status_code zx_registrations.registration_status_code%type,
51: registration_source_code zx_registrations.registration_source_code%type,
52: registration_reason_code zx_registrations.registration_reason_code%type,

Line 49: self_assess_flag zx_registrations.self_assess_flag%type,

45: rep_tax_authority_id zx_registrations.rep_tax_authority_id%type,
46: coll_Tax_authority_id zx_registrations.coll_tax_authority_id%type,
47: rounding_rule_code zx_registrations.rounding_rule_code%type,
48: tax_jurisdiction_code zx_registrations.tax_jurisdiction_code%type,
49: self_assess_flag zx_registrations.self_assess_flag%type,
50: registration_status_code zx_registrations.registration_status_code%type,
51: registration_source_code zx_registrations.registration_source_code%type,
52: registration_reason_code zx_registrations.registration_reason_code%type,
53: party_tax_profile_id zx_registrations.party_tax_profile_id%type,

Line 50: registration_status_code zx_registrations.registration_status_code%type,

46: coll_Tax_authority_id zx_registrations.coll_tax_authority_id%type,
47: rounding_rule_code zx_registrations.rounding_rule_code%type,
48: tax_jurisdiction_code zx_registrations.tax_jurisdiction_code%type,
49: self_assess_flag zx_registrations.self_assess_flag%type,
50: registration_status_code zx_registrations.registration_status_code%type,
51: registration_source_code zx_registrations.registration_source_code%type,
52: registration_reason_code zx_registrations.registration_reason_code%type,
53: party_tax_profile_id zx_registrations.party_tax_profile_id%type,
54: tax zx_registrations.tax%type,

Line 51: registration_source_code zx_registrations.registration_source_code%type,

47: rounding_rule_code zx_registrations.rounding_rule_code%type,
48: tax_jurisdiction_code zx_registrations.tax_jurisdiction_code%type,
49: self_assess_flag zx_registrations.self_assess_flag%type,
50: registration_status_code zx_registrations.registration_status_code%type,
51: registration_source_code zx_registrations.registration_source_code%type,
52: registration_reason_code zx_registrations.registration_reason_code%type,
53: party_tax_profile_id zx_registrations.party_tax_profile_id%type,
54: tax zx_registrations.tax%type,
55: tax_regime_code zx_registrations.tax_regime_code%type,

Line 52: registration_reason_code zx_registrations.registration_reason_code%type,

48: tax_jurisdiction_code zx_registrations.tax_jurisdiction_code%type,
49: self_assess_flag zx_registrations.self_assess_flag%type,
50: registration_status_code zx_registrations.registration_status_code%type,
51: registration_source_code zx_registrations.registration_source_code%type,
52: registration_reason_code zx_registrations.registration_reason_code%type,
53: party_tax_profile_id zx_registrations.party_tax_profile_id%type,
54: tax zx_registrations.tax%type,
55: tax_regime_code zx_registrations.tax_regime_code%type,
56: inclusive_tax_flag zx_registrations.inclusive_tax_flag%type,

Line 53: party_tax_profile_id zx_registrations.party_tax_profile_id%type,

49: self_assess_flag zx_registrations.self_assess_flag%type,
50: registration_status_code zx_registrations.registration_status_code%type,
51: registration_source_code zx_registrations.registration_source_code%type,
52: registration_reason_code zx_registrations.registration_reason_code%type,
53: party_tax_profile_id zx_registrations.party_tax_profile_id%type,
54: tax zx_registrations.tax%type,
55: tax_regime_code zx_registrations.tax_regime_code%type,
56: inclusive_tax_flag zx_registrations.inclusive_tax_flag%type,
57: -- has_tax_exemptions_flag zx_registrations.has_tax_exemptions_flag%type,

Line 54: tax zx_registrations.tax%type,

50: registration_status_code zx_registrations.registration_status_code%type,
51: registration_source_code zx_registrations.registration_source_code%type,
52: registration_reason_code zx_registrations.registration_reason_code%type,
53: party_tax_profile_id zx_registrations.party_tax_profile_id%type,
54: tax zx_registrations.tax%type,
55: tax_regime_code zx_registrations.tax_regime_code%type,
56: inclusive_tax_flag zx_registrations.inclusive_tax_flag%type,
57: -- has_tax_exemptions_flag zx_registrations.has_tax_exemptions_flag%type,
58: effective_from date,

Line 55: tax_regime_code zx_registrations.tax_regime_code%type,

51: registration_source_code zx_registrations.registration_source_code%type,
52: registration_reason_code zx_registrations.registration_reason_code%type,
53: party_tax_profile_id zx_registrations.party_tax_profile_id%type,
54: tax zx_registrations.tax%type,
55: tax_regime_code zx_registrations.tax_regime_code%type,
56: inclusive_tax_flag zx_registrations.inclusive_tax_flag%type,
57: -- has_tax_exemptions_flag zx_registrations.has_tax_exemptions_flag%type,
58: effective_from date,
59: effective_to date,

Line 56: inclusive_tax_flag zx_registrations.inclusive_tax_flag%type,

52: registration_reason_code zx_registrations.registration_reason_code%type,
53: party_tax_profile_id zx_registrations.party_tax_profile_id%type,
54: tax zx_registrations.tax%type,
55: tax_regime_code zx_registrations.tax_regime_code%type,
56: inclusive_tax_flag zx_registrations.inclusive_tax_flag%type,
57: -- has_tax_exemptions_flag zx_registrations.has_tax_exemptions_flag%type,
58: effective_from date,
59: effective_to date,
60: rep_party_tax_name zx_registrations.rep_party_tax_name%type,

Line 57: -- has_tax_exemptions_flag zx_registrations.has_tax_exemptions_flag%type,

53: party_tax_profile_id zx_registrations.party_tax_profile_id%type,
54: tax zx_registrations.tax%type,
55: tax_regime_code zx_registrations.tax_regime_code%type,
56: inclusive_tax_flag zx_registrations.inclusive_tax_flag%type,
57: -- has_tax_exemptions_flag zx_registrations.has_tax_exemptions_flag%type,
58: effective_from date,
59: effective_to date,
60: rep_party_tax_name zx_registrations.rep_party_tax_name%type,
61: legal_registration_id zx_registrations.legal_registration_id%type,

Line 60: rep_party_tax_name zx_registrations.rep_party_tax_name%type,

56: inclusive_tax_flag zx_registrations.inclusive_tax_flag%type,
57: -- has_tax_exemptions_flag zx_registrations.has_tax_exemptions_flag%type,
58: effective_from date,
59: effective_to date,
60: rep_party_tax_name zx_registrations.rep_party_tax_name%type,
61: legal_registration_id zx_registrations.legal_registration_id%type,
62: default_registration_flag zx_registrations.default_registration_flag%type,
63: bank_id zx_registrations.bank_id%type,
64: bank_branch_id zx_registrations.bank_branch_id%type,

Line 61: legal_registration_id zx_registrations.legal_registration_id%type,

57: -- has_tax_exemptions_flag zx_registrations.has_tax_exemptions_flag%type,
58: effective_from date,
59: effective_to date,
60: rep_party_tax_name zx_registrations.rep_party_tax_name%type,
61: legal_registration_id zx_registrations.legal_registration_id%type,
62: default_registration_flag zx_registrations.default_registration_flag%type,
63: bank_id zx_registrations.bank_id%type,
64: bank_branch_id zx_registrations.bank_branch_id%type,
65: bank_account_num zx_registrations.bank_account_num%type,

Line 62: default_registration_flag zx_registrations.default_registration_flag%type,

58: effective_from date,
59: effective_to date,
60: rep_party_tax_name zx_registrations.rep_party_tax_name%type,
61: legal_registration_id zx_registrations.legal_registration_id%type,
62: default_registration_flag zx_registrations.default_registration_flag%type,
63: bank_id zx_registrations.bank_id%type,
64: bank_branch_id zx_registrations.bank_branch_id%type,
65: bank_account_num zx_registrations.bank_account_num%type,
66: legal_location_id zx_registrations.legal_location_id%type,

Line 63: bank_id zx_registrations.bank_id%type,

59: effective_to date,
60: rep_party_tax_name zx_registrations.rep_party_tax_name%type,
61: legal_registration_id zx_registrations.legal_registration_id%type,
62: default_registration_flag zx_registrations.default_registration_flag%type,
63: bank_id zx_registrations.bank_id%type,
64: bank_branch_id zx_registrations.bank_branch_id%type,
65: bank_account_num zx_registrations.bank_account_num%type,
66: legal_location_id zx_registrations.legal_location_id%type,
67: record_type_code zx_registrations.record_type_code%type,

Line 64: bank_branch_id zx_registrations.bank_branch_id%type,

60: rep_party_tax_name zx_registrations.rep_party_tax_name%type,
61: legal_registration_id zx_registrations.legal_registration_id%type,
62: default_registration_flag zx_registrations.default_registration_flag%type,
63: bank_id zx_registrations.bank_id%type,
64: bank_branch_id zx_registrations.bank_branch_id%type,
65: bank_account_num zx_registrations.bank_account_num%type,
66: legal_location_id zx_registrations.legal_location_id%type,
67: record_type_code zx_registrations.record_type_code%type,
68: request_id zx_registrations.request_id%type,

Line 65: bank_account_num zx_registrations.bank_account_num%type,

61: legal_registration_id zx_registrations.legal_registration_id%type,
62: default_registration_flag zx_registrations.default_registration_flag%type,
63: bank_id zx_registrations.bank_id%type,
64: bank_branch_id zx_registrations.bank_branch_id%type,
65: bank_account_num zx_registrations.bank_account_num%type,
66: legal_location_id zx_registrations.legal_location_id%type,
67: record_type_code zx_registrations.record_type_code%type,
68: request_id zx_registrations.request_id%type,
69: program_application_id zx_registrations.program_application_id%type,

Line 66: legal_location_id zx_registrations.legal_location_id%type,

62: default_registration_flag zx_registrations.default_registration_flag%type,
63: bank_id zx_registrations.bank_id%type,
64: bank_branch_id zx_registrations.bank_branch_id%type,
65: bank_account_num zx_registrations.bank_account_num%type,
66: legal_location_id zx_registrations.legal_location_id%type,
67: record_type_code zx_registrations.record_type_code%type,
68: request_id zx_registrations.request_id%type,
69: program_application_id zx_registrations.program_application_id%type,
70: program_id zx_registrations.program_id%type,

Line 67: record_type_code zx_registrations.record_type_code%type,

63: bank_id zx_registrations.bank_id%type,
64: bank_branch_id zx_registrations.bank_branch_id%type,
65: bank_account_num zx_registrations.bank_account_num%type,
66: legal_location_id zx_registrations.legal_location_id%type,
67: record_type_code zx_registrations.record_type_code%type,
68: request_id zx_registrations.request_id%type,
69: program_application_id zx_registrations.program_application_id%type,
70: program_id zx_registrations.program_id%type,
71: program_login_id zx_registrations.program_login_id%type,

Line 68: request_id zx_registrations.request_id%type,

64: bank_branch_id zx_registrations.bank_branch_id%type,
65: bank_account_num zx_registrations.bank_account_num%type,
66: legal_location_id zx_registrations.legal_location_id%type,
67: record_type_code zx_registrations.record_type_code%type,
68: request_id zx_registrations.request_id%type,
69: program_application_id zx_registrations.program_application_id%type,
70: program_id zx_registrations.program_id%type,
71: program_login_id zx_registrations.program_login_id%type,
72: account_id zx_registrations.account_id%type,

Line 69: program_application_id zx_registrations.program_application_id%type,

65: bank_account_num zx_registrations.bank_account_num%type,
66: legal_location_id zx_registrations.legal_location_id%type,
67: record_type_code zx_registrations.record_type_code%type,
68: request_id zx_registrations.request_id%type,
69: program_application_id zx_registrations.program_application_id%type,
70: program_id zx_registrations.program_id%type,
71: program_login_id zx_registrations.program_login_id%type,
72: account_id zx_registrations.account_id%type,
73: ACCOUNT_SITE_ID zx_registrations.ACCOUNT_SITE_ID%type,

Line 70: program_id zx_registrations.program_id%type,

66: legal_location_id zx_registrations.legal_location_id%type,
67: record_type_code zx_registrations.record_type_code%type,
68: request_id zx_registrations.request_id%type,
69: program_application_id zx_registrations.program_application_id%type,
70: program_id zx_registrations.program_id%type,
71: program_login_id zx_registrations.program_login_id%type,
72: account_id zx_registrations.account_id%type,
73: ACCOUNT_SITE_ID zx_registrations.ACCOUNT_SITE_ID%type,
74: -- site_use_id HZ_CUST_SITE_USES_ALL.site_use_id%type,

Line 71: program_login_id zx_registrations.program_login_id%type,

67: record_type_code zx_registrations.record_type_code%type,
68: request_id zx_registrations.request_id%type,
69: program_application_id zx_registrations.program_application_id%type,
70: program_id zx_registrations.program_id%type,
71: program_login_id zx_registrations.program_login_id%type,
72: account_id zx_registrations.account_id%type,
73: ACCOUNT_SITE_ID zx_registrations.ACCOUNT_SITE_ID%type,
74: -- site_use_id HZ_CUST_SITE_USES_ALL.site_use_id%type,
75: geo_type_classification_code HZ_CUST_SITE_USES_ALL.tax_classification%TYPE,

Line 72: account_id zx_registrations.account_id%type,

68: request_id zx_registrations.request_id%type,
69: program_application_id zx_registrations.program_application_id%type,
70: program_id zx_registrations.program_id%type,
71: program_login_id zx_registrations.program_login_id%type,
72: account_id zx_registrations.account_id%type,
73: ACCOUNT_SITE_ID zx_registrations.ACCOUNT_SITE_ID%type,
74: -- site_use_id HZ_CUST_SITE_USES_ALL.site_use_id%type,
75: geo_type_classification_code HZ_CUST_SITE_USES_ALL.tax_classification%TYPE,
76: tax_classification_code zx_registrations.tax_classification_code%type,

Line 73: ACCOUNT_SITE_ID zx_registrations.ACCOUNT_SITE_ID%type,

69: program_application_id zx_registrations.program_application_id%type,
70: program_id zx_registrations.program_id%type,
71: program_login_id zx_registrations.program_login_id%type,
72: account_id zx_registrations.account_id%type,
73: ACCOUNT_SITE_ID zx_registrations.ACCOUNT_SITE_ID%type,
74: -- site_use_id HZ_CUST_SITE_USES_ALL.site_use_id%type,
75: geo_type_classification_code HZ_CUST_SITE_USES_ALL.tax_classification%TYPE,
76: tax_classification_code zx_registrations.tax_classification_code%type,
77: attribute1 zx_registrations.attribute1%type,

Line 76: tax_classification_code zx_registrations.tax_classification_code%type,

72: account_id zx_registrations.account_id%type,
73: ACCOUNT_SITE_ID zx_registrations.ACCOUNT_SITE_ID%type,
74: -- site_use_id HZ_CUST_SITE_USES_ALL.site_use_id%type,
75: geo_type_classification_code HZ_CUST_SITE_USES_ALL.tax_classification%TYPE,
76: tax_classification_code zx_registrations.tax_classification_code%type,
77: attribute1 zx_registrations.attribute1%type,
78: attribute2 zx_registrations.attribute2%type,
79: attribute3 zx_registrations.attribute3%type,
80: attribute4 zx_registrations.attribute4%type,

Line 77: attribute1 zx_registrations.attribute1%type,

73: ACCOUNT_SITE_ID zx_registrations.ACCOUNT_SITE_ID%type,
74: -- site_use_id HZ_CUST_SITE_USES_ALL.site_use_id%type,
75: geo_type_classification_code HZ_CUST_SITE_USES_ALL.tax_classification%TYPE,
76: tax_classification_code zx_registrations.tax_classification_code%type,
77: attribute1 zx_registrations.attribute1%type,
78: attribute2 zx_registrations.attribute2%type,
79: attribute3 zx_registrations.attribute3%type,
80: attribute4 zx_registrations.attribute4%type,
81: attribute5 zx_registrations.attribute5%type,

Line 78: attribute2 zx_registrations.attribute2%type,

74: -- site_use_id HZ_CUST_SITE_USES_ALL.site_use_id%type,
75: geo_type_classification_code HZ_CUST_SITE_USES_ALL.tax_classification%TYPE,
76: tax_classification_code zx_registrations.tax_classification_code%type,
77: attribute1 zx_registrations.attribute1%type,
78: attribute2 zx_registrations.attribute2%type,
79: attribute3 zx_registrations.attribute3%type,
80: attribute4 zx_registrations.attribute4%type,
81: attribute5 zx_registrations.attribute5%type,
82: attribute6 zx_registrations.attribute6%type,

Line 79: attribute3 zx_registrations.attribute3%type,

75: geo_type_classification_code HZ_CUST_SITE_USES_ALL.tax_classification%TYPE,
76: tax_classification_code zx_registrations.tax_classification_code%type,
77: attribute1 zx_registrations.attribute1%type,
78: attribute2 zx_registrations.attribute2%type,
79: attribute3 zx_registrations.attribute3%type,
80: attribute4 zx_registrations.attribute4%type,
81: attribute5 zx_registrations.attribute5%type,
82: attribute6 zx_registrations.attribute6%type,
83: attribute7 zx_registrations.attribute7%type,

Line 80: attribute4 zx_registrations.attribute4%type,

76: tax_classification_code zx_registrations.tax_classification_code%type,
77: attribute1 zx_registrations.attribute1%type,
78: attribute2 zx_registrations.attribute2%type,
79: attribute3 zx_registrations.attribute3%type,
80: attribute4 zx_registrations.attribute4%type,
81: attribute5 zx_registrations.attribute5%type,
82: attribute6 zx_registrations.attribute6%type,
83: attribute7 zx_registrations.attribute7%type,
84: attribute8 zx_registrations.attribute8%type,

Line 81: attribute5 zx_registrations.attribute5%type,

77: attribute1 zx_registrations.attribute1%type,
78: attribute2 zx_registrations.attribute2%type,
79: attribute3 zx_registrations.attribute3%type,
80: attribute4 zx_registrations.attribute4%type,
81: attribute5 zx_registrations.attribute5%type,
82: attribute6 zx_registrations.attribute6%type,
83: attribute7 zx_registrations.attribute7%type,
84: attribute8 zx_registrations.attribute8%type,
85: attribute9 zx_registrations.attribute9%type,

Line 82: attribute6 zx_registrations.attribute6%type,

78: attribute2 zx_registrations.attribute2%type,
79: attribute3 zx_registrations.attribute3%type,
80: attribute4 zx_registrations.attribute4%type,
81: attribute5 zx_registrations.attribute5%type,
82: attribute6 zx_registrations.attribute6%type,
83: attribute7 zx_registrations.attribute7%type,
84: attribute8 zx_registrations.attribute8%type,
85: attribute9 zx_registrations.attribute9%type,
86: attribute10 zx_registrations.attribute10%type,

Line 83: attribute7 zx_registrations.attribute7%type,

79: attribute3 zx_registrations.attribute3%type,
80: attribute4 zx_registrations.attribute4%type,
81: attribute5 zx_registrations.attribute5%type,
82: attribute6 zx_registrations.attribute6%type,
83: attribute7 zx_registrations.attribute7%type,
84: attribute8 zx_registrations.attribute8%type,
85: attribute9 zx_registrations.attribute9%type,
86: attribute10 zx_registrations.attribute10%type,
87: attribute11 zx_registrations.attribute11%type,

Line 84: attribute8 zx_registrations.attribute8%type,

80: attribute4 zx_registrations.attribute4%type,
81: attribute5 zx_registrations.attribute5%type,
82: attribute6 zx_registrations.attribute6%type,
83: attribute7 zx_registrations.attribute7%type,
84: attribute8 zx_registrations.attribute8%type,
85: attribute9 zx_registrations.attribute9%type,
86: attribute10 zx_registrations.attribute10%type,
87: attribute11 zx_registrations.attribute11%type,
88: attribute12 zx_registrations.attribute12%type,

Line 85: attribute9 zx_registrations.attribute9%type,

81: attribute5 zx_registrations.attribute5%type,
82: attribute6 zx_registrations.attribute6%type,
83: attribute7 zx_registrations.attribute7%type,
84: attribute8 zx_registrations.attribute8%type,
85: attribute9 zx_registrations.attribute9%type,
86: attribute10 zx_registrations.attribute10%type,
87: attribute11 zx_registrations.attribute11%type,
88: attribute12 zx_registrations.attribute12%type,
89: attribute13 zx_registrations.attribute13%type,

Line 86: attribute10 zx_registrations.attribute10%type,

82: attribute6 zx_registrations.attribute6%type,
83: attribute7 zx_registrations.attribute7%type,
84: attribute8 zx_registrations.attribute8%type,
85: attribute9 zx_registrations.attribute9%type,
86: attribute10 zx_registrations.attribute10%type,
87: attribute11 zx_registrations.attribute11%type,
88: attribute12 zx_registrations.attribute12%type,
89: attribute13 zx_registrations.attribute13%type,
90: attribute14 zx_registrations.attribute14%type,

Line 87: attribute11 zx_registrations.attribute11%type,

83: attribute7 zx_registrations.attribute7%type,
84: attribute8 zx_registrations.attribute8%type,
85: attribute9 zx_registrations.attribute9%type,
86: attribute10 zx_registrations.attribute10%type,
87: attribute11 zx_registrations.attribute11%type,
88: attribute12 zx_registrations.attribute12%type,
89: attribute13 zx_registrations.attribute13%type,
90: attribute14 zx_registrations.attribute14%type,
91: attribute15 zx_registrations.attribute15%type,

Line 88: attribute12 zx_registrations.attribute12%type,

84: attribute8 zx_registrations.attribute8%type,
85: attribute9 zx_registrations.attribute9%type,
86: attribute10 zx_registrations.attribute10%type,
87: attribute11 zx_registrations.attribute11%type,
88: attribute12 zx_registrations.attribute12%type,
89: attribute13 zx_registrations.attribute13%type,
90: attribute14 zx_registrations.attribute14%type,
91: attribute15 zx_registrations.attribute15%type,
92: attribute_category zx_registrations.attribute_category%type,

Line 89: attribute13 zx_registrations.attribute13%type,

85: attribute9 zx_registrations.attribute9%type,
86: attribute10 zx_registrations.attribute10%type,
87: attribute11 zx_registrations.attribute11%type,
88: attribute12 zx_registrations.attribute12%type,
89: attribute13 zx_registrations.attribute13%type,
90: attribute14 zx_registrations.attribute14%type,
91: attribute15 zx_registrations.attribute15%type,
92: attribute_category zx_registrations.attribute_category%type,
93: party_type_code zx_party_tax_profile.party_type_code%type,

Line 90: attribute14 zx_registrations.attribute14%type,

86: attribute10 zx_registrations.attribute10%type,
87: attribute11 zx_registrations.attribute11%type,
88: attribute12 zx_registrations.attribute12%type,
89: attribute13 zx_registrations.attribute13%type,
90: attribute14 zx_registrations.attribute14%type,
91: attribute15 zx_registrations.attribute15%type,
92: attribute_category zx_registrations.attribute_category%type,
93: party_type_code zx_party_tax_profile.party_type_code%type,
94: supplier_flag zx_party_tax_profile.supplier_flag%type,

Line 91: attribute15 zx_registrations.attribute15%type,

87: attribute11 zx_registrations.attribute11%type,
88: attribute12 zx_registrations.attribute12%type,
89: attribute13 zx_registrations.attribute13%type,
90: attribute14 zx_registrations.attribute14%type,
91: attribute15 zx_registrations.attribute15%type,
92: attribute_category zx_registrations.attribute_category%type,
93: party_type_code zx_party_tax_profile.party_type_code%type,
94: supplier_flag zx_party_tax_profile.supplier_flag%type,
95: customer_flag zx_party_tax_profile.customer_flag%type,

Line 92: attribute_category zx_registrations.attribute_category%type,

88: attribute12 zx_registrations.attribute12%type,
89: attribute13 zx_registrations.attribute13%type,
90: attribute14 zx_registrations.attribute14%type,
91: attribute15 zx_registrations.attribute15%type,
92: attribute_category zx_registrations.attribute_category%type,
93: party_type_code zx_party_tax_profile.party_type_code%type,
94: supplier_flag zx_party_tax_profile.supplier_flag%type,
95: customer_flag zx_party_tax_profile.customer_flag%type,
96: site_flag zx_party_tax_profile.site_flag%type,

Line 125: p_account_type_code IN zx_registrations.account_type_code%TYPE,

121:
122: PROCEDURE GET_TAX_REGISTRATION(
123: p_parent_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,
124: p_site_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,
125: p_account_type_code IN zx_registrations.account_type_code%TYPE,
126: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
127: p_tax IN ZX_TAXES_B.TAX%TYPE,
128: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
129: p_jurisdiction_code IN ZX_JURISDICTIONS_B.TAX_JURISDICTION_CODE%TYPE,

Line 130: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,

126: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
127: p_tax IN ZX_TAXES_B.TAX%TYPE,
128: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
129: p_jurisdiction_code IN ZX_JURISDICTIONS_B.TAX_JURISDICTION_CODE%TYPE,
130: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
131: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
132: p_site_use_id IN HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE,
133: p_zx_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,
134: p_ret_record_level OUT NOCOPY VARCHAR2,

Line 131: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,

127: p_tax IN ZX_TAXES_B.TAX%TYPE,
128: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
129: p_jurisdiction_code IN ZX_JURISDICTIONS_B.TAX_JURISDICTION_CODE%TYPE,
130: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
131: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
132: p_site_use_id IN HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE,
133: p_zx_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,
134: p_ret_record_level OUT NOCOPY VARCHAR2,
135: p_return_status OUT NOCOPY VARCHAR2);