DBA Data[Home] [Help]

APPS.HZ_MAP_PARTY_PUB dependencies on HZ_ORGANIZATION_INFO_V2PUB

Line 72: p_fin_rep_rec IN OUT NOCOPY HZ_ORGANIZATION_INFO_V2PUB.financial_report_rec_type,

68:
69:
70: procedure store_financial_report(
71: --p_fin_rep_rec IN OUT NOCOPY hz_org_info_pub.financial_reports_rec_type,
72: p_fin_rep_rec IN OUT NOCOPY HZ_ORGANIZATION_INFO_V2PUB.financial_report_rec_type,
73: p_interface_rec IN OUT NOCOPY HZ_PARTY_INTERFACE%ROWTYPE,
74: x_return_status IN OUT NOCOPY VARCHAR2
75: );
76:

Line 81: p_fin_num_rec IN OUT NOCOPY HZ_ORGANIZATION_INFO_V2PUB.financial_number_rec_type,

77:
78: procedure store_financial_number(
79: p_interface_rec IN OUT NOCOPY HZ_PARTY_INTERFACE%ROWTYPE,
80: --p_fin_num_rec IN OUT NOCOPY hz_org_info_pub.financial_numbers_rec_type,
81: p_fin_num_rec IN OUT NOCOPY HZ_ORGANIZATION_INFO_V2PUB.financial_number_rec_type,
82: p_new_fin_report IN VARCHAR2,
83: p_type_of_financial_report IN VARCHAR2,
84: x_return_status IN OUT NOCOPY VARCHAR2
85: );

Line 129: l_fin_rep_rec IN OUT NOCOPY HZ_ORGANIZATION_INFO_V2PUB.FINANCIAL_REPORT_REC_TYPE,

125:
126: procedure do_assign_financial_report(
127: p_interface_rec IN HZ_PARTY_INTERFACE%ROWTYPE,
128: --l_fin_rep_rec IN OUT NOCOPY HZ_ORG_INFO_PUB.FINANCIAL_REPORTS_REC_TYPE,
129: l_fin_rep_rec IN OUT NOCOPY HZ_ORGANIZATION_INFO_V2PUB.FINANCIAL_REPORT_REC_TYPE,
130: p_type_of_financial_report IN HZ_FINANCIAL_REPORTS.TYPE_OF_FINANCIAL_REPORT%type
131: );
132:
133: PROCEDURE create_dynamic_lookups(

Line 2310: l_fin_rep_rec HZ_ORGANIZATION_INFO_V2PUB.financial_report_rec_type;

2306: l_location_rec hz_location_v2pub.location_rec_type;
2307: --l_credit_ratings_rec hz_party_info_pub.credit_ratings_rec_type;
2308: l_credit_ratings_rec hz_party_info_v2pub.credit_rating_rec_type;
2309: --l_fin_rep_rec hz_org_info_pub.financial_reports_rec_type;
2310: l_fin_rep_rec HZ_ORGANIZATION_INFO_V2PUB.financial_report_rec_type;
2311: --l_fin_num_rec hz_org_info_pub.financial_numbers_rec_type;
2312: l_fin_num_rec HZ_ORGANIZATION_INFO_V2PUB.financial_number_rec_type;
2313: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;
2314: l_phone_rec hz_contact_point_v2pub.phone_rec_type := HZ_CONTACT_POINT_V2PUB.G_MISS_PHONE_REC;

Line 2312: l_fin_num_rec HZ_ORGANIZATION_INFO_V2PUB.financial_number_rec_type;

2308: l_credit_ratings_rec hz_party_info_v2pub.credit_rating_rec_type;
2309: --l_fin_rep_rec hz_org_info_pub.financial_reports_rec_type;
2310: l_fin_rep_rec HZ_ORGANIZATION_INFO_V2PUB.financial_report_rec_type;
2311: --l_fin_num_rec hz_org_info_pub.financial_numbers_rec_type;
2312: l_fin_num_rec HZ_ORGANIZATION_INFO_V2PUB.financial_number_rec_type;
2313: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;
2314: l_phone_rec hz_contact_point_v2pub.phone_rec_type := HZ_CONTACT_POINT_V2PUB.G_MISS_PHONE_REC;
2315: l_code_assignment_rec hz_classification_v2pub.code_assignment_rec_type;
2316: l_organization_profile_id NUMBER;

Line 3048: l_fin_rep_rec IN OUT NOCOPY HZ_ORGANIZATION_INFO_V2PUB.FINANCIAL_REPORT_REC_TYPE,

3044:
3045: procedure do_assign_financial_report(
3046: p_interface_rec IN HZ_PARTY_INTERFACE%ROWTYPE,
3047: --l_fin_rep_rec IN OUT NOCOPY HZ_ORG_INFO_PUB.FINANCIAL_REPORTS_REC_TYPE,
3048: l_fin_rep_rec IN OUT NOCOPY HZ_ORGANIZATION_INFO_V2PUB.FINANCIAL_REPORT_REC_TYPE,
3049: p_type_of_financial_report IN HZ_FINANCIAL_REPORTS.TYPE_OF_FINANCIAL_REPORT%type
3050: ) IS
3051: BEGIN
3052:

Line 4800: p_fin_rep_rec IN OUT NOCOPY HZ_ORGANIZATION_INFO_V2PUB.financial_report_rec_type,

4796: |
4797: +===========================================================================*/
4798:
4799: procedure do_store_financial_report(
4800: p_fin_rep_rec IN OUT NOCOPY HZ_ORGANIZATION_INFO_V2PUB.financial_report_rec_type,
4801: --p_fin_rep_rec IN OUT NOCOPY hz_org_info_pub.financial_reports_rec_type,
4802: x_new_fin_report OUT NOCOPY VARCHAR2,
4803: x_return_status IN OUT NOCOPY VARCHAR2
4804: ) IS

Line 4865: HZ_ORGANIZATION_INFO_V2PUB.update_financial_report(

4861: --
4862: arp_util.debug('HZ_MAP_PARTY_PUB.STORE_FINANCIAL_REPORT: update financial report for DNB');
4863:
4864: p_fin_rep_rec.created_by_module := NULL;
4865: HZ_ORGANIZATION_INFO_V2PUB.update_financial_report(
4866: 'F',
4867: p_fin_rep_rec,
4868: l_ovn,
4869: x_return_status,

Line 4904: HZ_ORGANIZATION_INFO_V2PUB.create_financial_report(

4900:
4901: x_new_fin_report := 'Y';
4902:
4903: p_fin_rep_rec.created_by_module := 'TCA_DNB_MAPPING';
4904: HZ_ORGANIZATION_INFO_V2PUB.create_financial_report(
4905: 'F',
4906: p_fin_rep_rec,
4907: p_fin_rep_rec.financial_report_id,
4908: x_return_status,

Line 4957: p_fin_rep_rec IN OUT NOCOPY HZ_ORGANIZATION_INFO_V2PUB.financial_report_rec_type,

4953: +===========================================================================*/
4954:
4955: procedure store_financial_report(
4956: --p_fin_rep_rec IN OUT NOCOPY hz_org_info_pub.financial_reports_rec_type,
4957: p_fin_rep_rec IN OUT NOCOPY HZ_ORGANIZATION_INFO_V2PUB.financial_report_rec_type,
4958: p_interface_rec IN OUT NOCOPY HZ_PARTY_INTERFACE%ROWTYPE,
4959: x_return_status IN OUT NOCOPY VARCHAR2
4960: ) IS
4961: --l_fin_num_rec hz_org_info_pub.financial_numbers_rec_type;

Line 4962: l_fin_num_rec HZ_ORGANIZATION_INFO_V2PUB.financial_number_rec_type;

4958: p_interface_rec IN OUT NOCOPY HZ_PARTY_INTERFACE%ROWTYPE,
4959: x_return_status IN OUT NOCOPY VARCHAR2
4960: ) IS
4961: --l_fin_num_rec hz_org_info_pub.financial_numbers_rec_type;
4962: l_fin_num_rec HZ_ORGANIZATION_INFO_V2PUB.financial_number_rec_type;
4963: l_new_fin_report VARCHAR2(1);
4964: BEGIN
4965:
4966:

Line 5027: p_fin_num_rec IN OUT NOCOPY HZ_ORGANIZATION_INFO_V2PUB.financial_number_rec_type,

5023:
5024: procedure store_financial_number(
5025: p_interface_rec IN OUT NOCOPY HZ_PARTY_INTERFACE%ROWTYPE,
5026: --p_fin_num_rec IN OUT NOCOPY hz_org_info_pub.financial_numbers_rec_type,
5027: p_fin_num_rec IN OUT NOCOPY HZ_ORGANIZATION_INFO_V2PUB.financial_number_rec_type,
5028: p_new_fin_report IN VARCHAR2,
5029: p_type_of_financial_report IN VARCHAR2,
5030: x_return_status IN OUT NOCOPY VARCHAR2
5031: ) IS

Line 5600: p_fin_num_rec IN OUT NOCOPY HZ_ORGANIZATION_INFO_V2PUB.financial_number_rec_type,

5596: +===========================================================================*/
5597:
5598: procedure do_store_financial_number(
5599: --p_fin_num_rec IN OUT NOCOPY hz_org_info_pub.financial_numbers_rec_type ,
5600: p_fin_num_rec IN OUT NOCOPY HZ_ORGANIZATION_INFO_V2PUB.financial_number_rec_type,
5601: p_new_fin_report IN VARCHAR2,
5602: p_fin_num_tab IN fin_num_table,
5603: x_return_status IN OUT NOCOPY VARCHAR2
5604: ) IS

Line 5620: HZ_ORGANIZATION_INFO_V2PUB.create_financial_number(

5616:
5617: arp_util.debug('HZ_MAP_PARTY_PUB.DO_STORE_FINANCIAL_NUMBER: financial report is new');
5618:
5619: p_fin_num_rec.created_by_module := 'TCA_DNB_MAPPING';
5620: HZ_ORGANIZATION_INFO_V2PUB.create_financial_number(
5621: 'F',
5622: p_fin_num_rec,
5623: l_financial_number_id,
5624: x_return_status,

Line 5669: HZ_ORGANIZATION_INFO_V2PUB.update_financial_number(

5665: arp_util.debug('HZ_MAP_PARTY_PUB.DO_STORE_FINANCIAL_NUMBER: financial report exists: fin num exists');
5666:
5667:
5668: p_fin_num_rec.created_by_module := NULL;
5669: HZ_ORGANIZATION_INFO_V2PUB.update_financial_number(
5670: 'F',
5671: p_fin_num_rec,
5672: l_ovn,
5673: x_return_status,

Line 5692: HZ_ORGANIZATION_INFO_V2PUB.create_financial_number(

5688:
5689: arp_util.debug('HZ_MAP_PARTY_PUB.DO_STORE_FINANCIAL_NUMBER: financial report is not new: fin num does not exist');
5690:
5691: p_fin_num_rec.created_by_module := 'TCA_DNB_MAPPING';
5692: HZ_ORGANIZATION_INFO_V2PUB.create_financial_number(
5693: 'F',
5694: p_fin_num_rec,
5695: l_financial_number_id,
5696: x_return_status,