DBA Data[Home] [Help]

APPS.HZ_MAP_PARTY_PUB dependencies on HZ_FINANCIAL_REPORTS

Line 130: p_type_of_financial_report IN HZ_FINANCIAL_REPORTS.TYPE_OF_FINANCIAL_REPORT%type

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(
134: p_party_interface_rec IN HZ_PARTY_INTERFACE%ROWTYPE,

Line 1022: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_FINANCIAL_REPORTS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');

1018: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_RELATIONSHIPS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
1019: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_LOCATIONS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
1020: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_CONTACT_POINTS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
1021: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_CREDIT_RATINGS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
1022: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_FINANCIAL_REPORTS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
1023: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_FINANCIAL_NUMBERS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
1024: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_CODE_ASSIGNMENTS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
1025: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_ORGANIZATION_INDICATORS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
1026: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_PARTY_SITES', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');

Line 3049: p_type_of_financial_report IN HZ_FINANCIAL_REPORTS.TYPE_OF_FINANCIAL_REPORT%type

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:
3053: l_fin_rep_rec.financial_report_id := NULL;

Line 4819: FROM hz_financial_reports

4815:
4816: BEGIN
4817: SELECT financial_report_id, last_update_date, object_version_number
4818: INTO p_fin_rep_rec.financial_report_id, l_last_update_date1, l_ovn
4819: FROM hz_financial_reports
4820: WHERE party_id = p_fin_rep_rec.party_id
4821: AND ACTUAL_CONTENT_SOURCE = p_fin_rep_rec.ACTUAL_CONTENT_SOURCE
4822:
4823: -- Bug 3202840 : User trunc while checking for DATE_REPORT_ISSED so that if it is purchased on