eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_ORG_INFO_PUB dependencies on HZ_FINANCIAL_REPORTS

Line 42: | HZ_FINANCIAL_REPORTS_PKG.INSERT_ROW(),HZ_FINANCIAL_REPORTS_PKG.UPDATE_ROW(),

38: | to caller.
39: |
40: | 16-MAR-01 Suresh P Bug No :1478910 Added the status column in
41: | HZ_CERTIFICATIONS_PKG.INSERT_ROW(),HZ_CERTIFICATION_PKG.UPDATE_ROW(),
42: | HZ_FINANCIAL_REPORTS_PKG.INSERT_ROW(),HZ_FINANCIAL_REPORTS_PKG.UPDATE_ROW(),
43: | HZ_FINANCIAL_NUMBER_PKG.INSERT_ROW(),HZ_FINANCIAL_NUMBER_PKG.UPDATE_ROW(),
44: | HZ_INDUSTRIAL_REFERENCE_PKG.INSERT_ROW(),HZ_INDUSTRIAL_REFERENCE_PKG.UPDATE_ROW,
45: | HZ_SECURITY_ISSUED_PKG.INSERT_ROW(),HZ_SECURITY_ISSUED_PKG.UPDATE_ROW.
46: +===========================================================================*/

Line 548: SELECT hz_financial_reports_s.nextval

544: THEN
545: l_count := 1;
546:
547: WHILE l_count >0 LOOP
548: SELECT hz_financial_reports_s.nextval
549: INTO l_financial_report_id from dual;
550:
551: SELECT count(*)
552: INTO l_count

Line 553: FROM HZ_FINANCIAL_REPORTS

549: INTO l_financial_report_id from dual;
550:
551: SELECT count(*)
552: INTO l_count
553: FROM HZ_FINANCIAL_REPORTS
554: WHERE financial_report_id = l_financial_report_id;
555: END LOOP;
556: ELSE
557: l_count := 0;

Line 561: FROM HZ_FINANCIAL_REPORTS

557: l_count := 0;
558:
559: SELECT count(*)
560: INTO l_count
561: FROM HZ_FINANCIAL_REPORTS
562: WHERE financial_report_id = l_financial_report_id;
563:
564: IF l_count > 0 THEN
565: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');

Line 588: HZ_FINANCIAL_REPORTS_PKG.INSERT_ROW(

584: -- handler. Need to update p_financial_reports_rec first.
585: p_financial_reports_rec.financial_report_id := l_financial_report_id;
586: /*
587: -- call table handler to insert a row
588: HZ_FINANCIAL_REPORTS_PKG.INSERT_ROW(
589: x_rowid => l_rowid,
590: x_financial_report_id => p_financial_reports_rec.financial_report_id,
591: x_date_report_issued => p_financial_reports_rec.date_report_issued,
592: x_party_id => p_financial_reports_rec.party_id,

Line 723: FROM hz_financial_reports

719: BEGIN
720: -- check last update date.
721: SELECT rowid, last_update_date
722: INTO l_rowid, l_last_update_date
723: FROM hz_financial_reports
724: where financial_report_id = p_financial_reports_rec.financial_report_id
725: AND to_char(last_update_date, 'DD-MON-YYYY HH:MI:SS') =
726: to_char(p_last_update_date, 'DD-MON-YYYY HH:MI:SS')
727: FOR UPDATE NOWAIT;

Line 732: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_FINANCIAL_REPORTS');

728:
729: EXCEPTION
730: WHEN NO_DATA_FOUND THEN
731: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
732: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_FINANCIAL_REPORTS');
733: FND_MSG_PUB.ADD;
734: RAISE FND_API.G_EXC_ERROR;
735: END;
736:

Line 781: HZ_FINANCIAL_REPORTS_PKG.UPDATE_ROW(

777: -- handler. Need to update p_financial_reports_rec first.
778: NULL;
779: /*
780: -- call table handler to update a row
781: HZ_FINANCIAL_REPORTS_PKG.UPDATE_ROW(
782: x_rowid => l_rowid,
783: x_financial_report_id => p_financial_reports_rec.financial_report_id,
784: x_date_report_issued => p_financial_reports_rec.date_report_issued,
785: x_party_id => p_financial_reports_rec.party_id,

Line 886: l_rep_content_source_type hz_financial_reports.content_source_type%TYPE;

882: x_return_status IN OUT NOCOPY VARCHAR2
883: ) IS
884:
885: l_financial_number_id NUMBER := p_financial_numbers_rec.financial_number_id;
886: l_rep_content_source_type hz_financial_reports.content_source_type%TYPE;
887: l_rep_actual_content_source hz_financial_reports.actual_content_source%TYPE;
888: l_rowid ROWID := NULL;
889: l_count NUMBER;
890: x_msg_count NUMBER;

Line 887: l_rep_actual_content_source hz_financial_reports.actual_content_source%TYPE;

883: ) IS
884:
885: l_financial_number_id NUMBER := p_financial_numbers_rec.financial_number_id;
886: l_rep_content_source_type hz_financial_reports.content_source_type%TYPE;
887: l_rep_actual_content_source hz_financial_reports.actual_content_source%TYPE;
888: l_rowid ROWID := NULL;
889: l_count NUMBER;
890: x_msg_count NUMBER;
891: x_msg_data VARCHAR2(2000);

Line 948: p_entity_name => 'HZ_FINANCIAL_REPORTS',

944: IF /*NVL(g_fin_mixnmatch_enabled, 'N') = 'Y' AND*/
945: l_rep_actual_content_source = G_MISS_CONTENT_SOURCE_TYPE
946: THEN
947: HZ_MIXNM_UTILITY.CheckUserCreationPrivilege (
948: p_entity_name => 'HZ_FINANCIAL_REPORTS',
949: p_entity_attr_id => g_fin_entity_attr_id,
950: p_mixnmatch_enabled => g_fin_mixnmatch_enabled,
951: p_actual_content_source => l_rep_actual_content_source,
952: x_return_status => x_return_status );

Line 1097: l_rep_content_source_type hz_financial_reports.content_source_type%TYPE;

1093: ) IS
1094:
1095: l_last_update_date DATE;
1096: db_actual_content_source hz_financial_numbers.actual_content_source%TYPE;
1097: l_rep_content_source_type hz_financial_reports.content_source_type%TYPE;
1098: l_rep_actual_content_source hz_financial_reports.actual_content_source%TYPE;
1099: l_rowid ROWID := NULL;
1100: x_msg_count NUMBER;
1101: x_msg_data VARCHAR2(2000);

Line 1098: l_rep_actual_content_source hz_financial_reports.actual_content_source%TYPE;

1094:
1095: l_last_update_date DATE;
1096: db_actual_content_source hz_financial_numbers.actual_content_source%TYPE;
1097: l_rep_content_source_type hz_financial_reports.content_source_type%TYPE;
1098: l_rep_actual_content_source hz_financial_reports.actual_content_source%TYPE;
1099: l_rowid ROWID := NULL;
1100: x_msg_count NUMBER;
1101: x_msg_data VARCHAR2(2000);
1102:

Line 1152: p_entity_name => 'HZ_FINANCIAL_REPORTS',

1148: THEN
1149: HZ_MIXNM_UTILITY.CheckUserUpdatePrivilege (
1150: p_actual_content_source => db_actual_content_source,
1151: p_new_actual_content_source => G_MISS_CONTENT_SOURCE_TYPE,
1152: p_entity_name => 'HZ_FINANCIAL_REPORTS',
1153: x_return_status => x_return_status );
1154: END IF;
1155:
1156: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 3487: p_entity_name => 'HZ_FINANCIAL_REPORTS',

3483: * For non-profile entities, the concept of select/de-select data-sources is obsoleted.
3484: * There is no need to check if the data-source is selected.
3485:
3486: HZ_MIXNM_UTILITY.LoadDataSources(
3487: p_entity_name => 'HZ_FINANCIAL_REPORTS',
3488: p_entity_attr_id => g_fin_entity_attr_id,
3489: p_mixnmatch_enabled => g_fin_mixnmatch_enabled,
3490: p_selected_datasources => g_fin_selected_datasources );
3491: *

Line 3495: p_entity_name => 'HZ_FINANCIAL_REPORTS',

3491: *
3492: -- END IF;
3493:
3494: HZ_MIXNM_UTILITY.AssignDataSourceDuringCreation (
3495: p_entity_name => 'HZ_FINANCIAL_REPORTS',
3496: p_entity_attr_id => g_fin_entity_attr_id,
3497: p_mixnmatch_enabled => g_fin_mixnmatch_enabled,
3498: p_selected_datasources => g_fin_selected_datasources,
3499: p_content_source_type => l_financial_reports_rec.content_source_type,

Line 3681: p_entity_name => 'HZ_FINANCIAL_REPORTS',

3677: * For non-profile entities, the concept of select/de-select data-sources is obsoleted.
3678: * There is no need to check if the data-source is selected.
3679:
3680: HZ_MIXNM_UTILITY.LoadDataSources(
3681: p_entity_name => 'HZ_FINANCIAL_REPORTS',
3682: p_entity_attr_id => g_fin_entity_attr_id,
3683: p_mixnmatch_enabled => g_fin_mixnmatch_enabled,
3684: p_selected_datasources => g_fin_selected_datasources );
3685:

Line 3855: p_entity_name => 'HZ_FINANCIAL_REPORTS',

3851: * For non-profile entities, the concept of select/de-select data-sources is obsoleted.
3852: * There is no need to check if the data-source is selected.
3853:
3854: HZ_MIXNM_UTILITY.LoadDataSources(
3855: p_entity_name => 'HZ_FINANCIAL_REPORTS',
3856: p_entity_attr_id => g_fin_entity_attr_id,
3857: p_mixnmatch_enabled => g_fin_mixnmatch_enabled,
3858: p_selected_datasources => g_fin_selected_datasources );
3859: *

Line 4033: p_entity_name => 'HZ_FINANCIAL_REPORTS',

4029: * For non-profile entities, the concept of select/de-select data-sources is obsoleted.
4030: * There is no need to check if the data-source is selected.
4031:
4032: HZ_MIXNM_UTILITY.LoadDataSources(
4033: p_entity_name => 'HZ_FINANCIAL_REPORTS',
4034: p_entity_attr_id => g_fin_entity_attr_id,
4035: p_mixnmatch_enabled => g_fin_mixnmatch_enabled,
4036: p_selected_datasources => g_fin_selected_datasources );
4037: *

Line 5555: FROM hz_financial_reports

5551: x_financial_reports_rec.content_source_type,
5552: x_financial_reports_rec.status,
5553: x_financial_reports_rec.actual_content_source
5554:
5555: FROM hz_financial_reports
5556: WHERE financial_report_id = p_financial_report_id;
5557:
5558: EXCEPTION
5559: WHEN NO_DATA_FOUND THEN