APPS.HZ_ORG_INFO_PUB dependencies on HZ_FINANCIAL_NUMBERS

Line 902: SELECT hz_financial_numbers_s.nextval

898: THEN
899: l_count := 1;
900:
901: WHILE l_count >0 LOOP
902: SELECT hz_financial_numbers_s.nextval
903: INTO l_financial_number_id from dual;
904:
905: SELECT count(*)
906: INTO l_count

Line 907: FROM HZ_FINANCIAL_NUMBERS

903: INTO l_financial_number_id from dual;
904:
905: SELECT count(*)
906: INTO l_count
907: FROM HZ_FINANCIAL_NUMBERS
908: WHERE financial_number_id = l_financial_number_id;
909: END LOOP;
910: ELSE
911: l_count := 0;

Line 915: FROM HZ_FINANCIAL_NUMBERS

911: l_count := 0;
912:
913: SELECT count(*)
914: INTO l_count
915: FROM HZ_FINANCIAL_NUMBERS
916: WHERE financial_number_id = l_financial_number_id;
917:
918: IF l_count > 0 THEN
919: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');

Line 1004: HZ_FINANCIAL_NUMBERS_PKG.INSERT_ROW(

1000: -- handler. Need to update p_financial_numbers_rec first.
1001: p_financial_numbers_rec.financial_number_id := l_financial_number_id;
1002: /*
1003: -- call table handler to insert a row
1004: HZ_FINANCIAL_NUMBERS_PKG.INSERT_ROW(
1005: x_rowid => l_rowid,
1006: x_financial_number_id => p_financial_numbers_rec.financial_number_id,
1007: x_financial_report_id => p_financial_numbers_rec.financial_report_id,
1008: x_financial_number => p_financial_numbers_rec.financial_number,

Line 1096: db_actual_content_source hz_financial_numbers.actual_content_source%TYPE;

1092: x_return_status IN OUT NOCOPY VARCHAR2
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;

Line 1128: FROM HZ_FINANCIAL_NUMBERS

1124: BEGIN
1125: -- check last update date.
1126: SELECT rowid, last_update_date, actual_content_source
1127: INTO l_rowid, l_last_update_date, db_actual_content_source
1128: FROM HZ_FINANCIAL_NUMBERS
1129: WHERE financial_number_id = p_financial_numbers_rec.financial_number_id
1130: AND to_char(last_update_date, 'DD-MON-YYYY HH:MI:SS') =
1131: to_char(p_last_update_date, 'DD-MON-YYYY HH:MI:SS')
1132: FOR UPDATE NOWAIT;

Line 1137: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_FINANCIAL_NUMBERS');

1133:
1134: EXCEPTION
1135: WHEN NO_DATA_FOUND THEN
1136: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1137: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_FINANCIAL_NUMBERS');
1138: FND_MSG_PUB.ADD;
1139: RAISE FND_API.G_EXC_ERROR;
1140: END;
1141:

Line 1217: HZ_FINANCIAL_NUMBERS_PKG.UPDATE_ROW(

1213: -- handler. Need to update p_financial_numbers_rec first.
1214: NULL;
1215: /*
1216: -- call table handler to update a row
1217: HZ_FINANCIAL_NUMBERS_PKG.UPDATE_ROW(
1218: x_rowid => l_rowid,
1219: x_financial_number_id => p_financial_numbers_rec.financial_number_id,
1220: x_financial_report_id => p_financial_numbers_rec.financial_report_id,
1221: x_financial_number => p_financial_numbers_rec.financial_number,

Line 5667: FROM hz_financial_numbers

5663: x_financial_numbers_rec.projected_actual_flag,
5664: x_financial_numbers_rec.wh_update_date,
5665: x_financial_numbers_rec.content_source_type,
5666: x_financial_numbers_rec.status
5667: FROM hz_financial_numbers
5668: WHERE financial_number_id = p_financial_number_id;
5669:
5670: EXCEPTION
5671: WHEN NO_DATA_FOUND THEN