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 FND_API

Line 11: stock_exchange_id NUMBER := FND_API.G_MISS_NUM,

7: ------------------ #1 stock_markets_rec_type -------------------
8: ----------------------------------------------------------------
9:
10: TYPE stock_markets_rec_type IS RECORD(
11: stock_exchange_id NUMBER := FND_API.G_MISS_NUM,
12: country_of_residence VARCHAR2(60) := FND_API.G_MISS_CHAR,
13: stock_exchange_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
14: stock_exchange_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
15: wh_update_date DATE := FND_API.G_MISS_DATE);

Line 12: country_of_residence VARCHAR2(60) := FND_API.G_MISS_CHAR,

8: ----------------------------------------------------------------
9:
10: TYPE stock_markets_rec_type IS RECORD(
11: stock_exchange_id NUMBER := FND_API.G_MISS_NUM,
12: country_of_residence VARCHAR2(60) := FND_API.G_MISS_CHAR,
13: stock_exchange_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
14: stock_exchange_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
15: wh_update_date DATE := FND_API.G_MISS_DATE);
16:

Line 13: stock_exchange_code VARCHAR2(60) := FND_API.G_MISS_CHAR,

9:
10: TYPE stock_markets_rec_type IS RECORD(
11: stock_exchange_id NUMBER := FND_API.G_MISS_NUM,
12: country_of_residence VARCHAR2(60) := FND_API.G_MISS_CHAR,
13: stock_exchange_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
14: stock_exchange_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
15: wh_update_date DATE := FND_API.G_MISS_DATE);
16:
17:

Line 14: stock_exchange_name VARCHAR2(240) := FND_API.G_MISS_CHAR,

10: TYPE stock_markets_rec_type IS RECORD(
11: stock_exchange_id NUMBER := FND_API.G_MISS_NUM,
12: country_of_residence VARCHAR2(60) := FND_API.G_MISS_CHAR,
13: stock_exchange_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
14: stock_exchange_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
15: wh_update_date DATE := FND_API.G_MISS_DATE);
16:
17:
18: ----------------------------------------------------------------

Line 15: wh_update_date DATE := FND_API.G_MISS_DATE);

11: stock_exchange_id NUMBER := FND_API.G_MISS_NUM,
12: country_of_residence VARCHAR2(60) := FND_API.G_MISS_CHAR,
13: stock_exchange_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
14: stock_exchange_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
15: wh_update_date DATE := FND_API.G_MISS_DATE);
16:
17:
18: ----------------------------------------------------------------
19: ------------------ #2 security_issued_rec_type ----------------

Line 24: security_issued_id NUMBER := FND_API.G_MISS_NUM,

20: ----------------------------------------------------------------
21:
22:
23: TYPE security_issued_rec_type IS RECORD(
24: security_issued_id NUMBER := FND_API.G_MISS_NUM,
25: estimated_total_amount NUMBER := FND_API.G_MISS_NUM,
26: stock_exchange_id NUMBER := FND_API.G_MISS_NUM,
27: security_issued_class VARCHAR2(30) := FND_API.G_MISS_CHAR,
28: security_issued_name VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 25: estimated_total_amount NUMBER := FND_API.G_MISS_NUM,

21:
22:
23: TYPE security_issued_rec_type IS RECORD(
24: security_issued_id NUMBER := FND_API.G_MISS_NUM,
25: estimated_total_amount NUMBER := FND_API.G_MISS_NUM,
26: stock_exchange_id NUMBER := FND_API.G_MISS_NUM,
27: security_issued_class VARCHAR2(30) := FND_API.G_MISS_CHAR,
28: security_issued_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
29: total_amount_in_a_currency VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 26: stock_exchange_id NUMBER := FND_API.G_MISS_NUM,

22:
23: TYPE security_issued_rec_type IS RECORD(
24: security_issued_id NUMBER := FND_API.G_MISS_NUM,
25: estimated_total_amount NUMBER := FND_API.G_MISS_NUM,
26: stock_exchange_id NUMBER := FND_API.G_MISS_NUM,
27: security_issued_class VARCHAR2(30) := FND_API.G_MISS_CHAR,
28: security_issued_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
29: total_amount_in_a_currency VARCHAR2(240) := FND_API.G_MISS_CHAR,
30: stock_ticker_symbol VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 27: security_issued_class VARCHAR2(30) := FND_API.G_MISS_CHAR,

23: TYPE security_issued_rec_type IS RECORD(
24: security_issued_id NUMBER := FND_API.G_MISS_NUM,
25: estimated_total_amount NUMBER := FND_API.G_MISS_NUM,
26: stock_exchange_id NUMBER := FND_API.G_MISS_NUM,
27: security_issued_class VARCHAR2(30) := FND_API.G_MISS_CHAR,
28: security_issued_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
29: total_amount_in_a_currency VARCHAR2(240) := FND_API.G_MISS_CHAR,
30: stock_ticker_symbol VARCHAR2(60) := FND_API.G_MISS_CHAR,
31: security_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,

Line 28: security_issued_name VARCHAR2(240) := FND_API.G_MISS_CHAR,

24: security_issued_id NUMBER := FND_API.G_MISS_NUM,
25: estimated_total_amount NUMBER := FND_API.G_MISS_NUM,
26: stock_exchange_id NUMBER := FND_API.G_MISS_NUM,
27: security_issued_class VARCHAR2(30) := FND_API.G_MISS_CHAR,
28: security_issued_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
29: total_amount_in_a_currency VARCHAR2(240) := FND_API.G_MISS_CHAR,
30: stock_ticker_symbol VARCHAR2(60) := FND_API.G_MISS_CHAR,
31: security_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
32: begin_date DATE := FND_API.G_MISS_DATE,

Line 29: total_amount_in_a_currency VARCHAR2(240) := FND_API.G_MISS_CHAR,

25: estimated_total_amount NUMBER := FND_API.G_MISS_NUM,
26: stock_exchange_id NUMBER := FND_API.G_MISS_NUM,
27: security_issued_class VARCHAR2(30) := FND_API.G_MISS_CHAR,
28: security_issued_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
29: total_amount_in_a_currency VARCHAR2(240) := FND_API.G_MISS_CHAR,
30: stock_ticker_symbol VARCHAR2(60) := FND_API.G_MISS_CHAR,
31: security_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
32: begin_date DATE := FND_API.G_MISS_DATE,
33: party_id NUMBER := FND_API.G_MISS_NUM,

Line 30: stock_ticker_symbol VARCHAR2(60) := FND_API.G_MISS_CHAR,

26: stock_exchange_id NUMBER := FND_API.G_MISS_NUM,
27: security_issued_class VARCHAR2(30) := FND_API.G_MISS_CHAR,
28: security_issued_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
29: total_amount_in_a_currency VARCHAR2(240) := FND_API.G_MISS_CHAR,
30: stock_ticker_symbol VARCHAR2(60) := FND_API.G_MISS_CHAR,
31: security_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
32: begin_date DATE := FND_API.G_MISS_DATE,
33: party_id NUMBER := FND_API.G_MISS_NUM,
34: end_date DATE := FND_API.G_MISS_DATE,

Line 31: security_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,

27: security_issued_class VARCHAR2(30) := FND_API.G_MISS_CHAR,
28: security_issued_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
29: total_amount_in_a_currency VARCHAR2(240) := FND_API.G_MISS_CHAR,
30: stock_ticker_symbol VARCHAR2(60) := FND_API.G_MISS_CHAR,
31: security_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
32: begin_date DATE := FND_API.G_MISS_DATE,
33: party_id NUMBER := FND_API.G_MISS_NUM,
34: end_date DATE := FND_API.G_MISS_DATE,
35: wh_update_date DATE := FND_API.G_MISS_DATE,

Line 32: begin_date DATE := FND_API.G_MISS_DATE,

28: security_issued_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
29: total_amount_in_a_currency VARCHAR2(240) := FND_API.G_MISS_CHAR,
30: stock_ticker_symbol VARCHAR2(60) := FND_API.G_MISS_CHAR,
31: security_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
32: begin_date DATE := FND_API.G_MISS_DATE,
33: party_id NUMBER := FND_API.G_MISS_NUM,
34: end_date DATE := FND_API.G_MISS_DATE,
35: wh_update_date DATE := FND_API.G_MISS_DATE,
36: status VARCHAR2(1) := FND_API.G_MISS_CHAR);

Line 33: party_id NUMBER := FND_API.G_MISS_NUM,

29: total_amount_in_a_currency VARCHAR2(240) := FND_API.G_MISS_CHAR,
30: stock_ticker_symbol VARCHAR2(60) := FND_API.G_MISS_CHAR,
31: security_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
32: begin_date DATE := FND_API.G_MISS_DATE,
33: party_id NUMBER := FND_API.G_MISS_NUM,
34: end_date DATE := FND_API.G_MISS_DATE,
35: wh_update_date DATE := FND_API.G_MISS_DATE,
36: status VARCHAR2(1) := FND_API.G_MISS_CHAR);
37:

Line 34: end_date DATE := FND_API.G_MISS_DATE,

30: stock_ticker_symbol VARCHAR2(60) := FND_API.G_MISS_CHAR,
31: security_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
32: begin_date DATE := FND_API.G_MISS_DATE,
33: party_id NUMBER := FND_API.G_MISS_NUM,
34: end_date DATE := FND_API.G_MISS_DATE,
35: wh_update_date DATE := FND_API.G_MISS_DATE,
36: status VARCHAR2(1) := FND_API.G_MISS_CHAR);
37:
38: ----------------------------------------------------------------

Line 35: wh_update_date DATE := FND_API.G_MISS_DATE,

31: security_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
32: begin_date DATE := FND_API.G_MISS_DATE,
33: party_id NUMBER := FND_API.G_MISS_NUM,
34: end_date DATE := FND_API.G_MISS_DATE,
35: wh_update_date DATE := FND_API.G_MISS_DATE,
36: status VARCHAR2(1) := FND_API.G_MISS_CHAR);
37:
38: ----------------------------------------------------------------
39: ------------------ #3 financial_reports_rec_type ---------------

Line 36: status VARCHAR2(1) := FND_API.G_MISS_CHAR);

32: begin_date DATE := FND_API.G_MISS_DATE,
33: party_id NUMBER := FND_API.G_MISS_NUM,
34: end_date DATE := FND_API.G_MISS_DATE,
35: wh_update_date DATE := FND_API.G_MISS_DATE,
36: status VARCHAR2(1) := FND_API.G_MISS_CHAR);
37:
38: ----------------------------------------------------------------
39: ------------------ #3 financial_reports_rec_type ---------------
40: ----------------------------------------------------------------

Line 43: financial_report_id NUMBER := FND_API.G_MISS_NUM,

39: ------------------ #3 financial_reports_rec_type ---------------
40: ----------------------------------------------------------------
41:
42: TYPE financial_reports_rec_type IS RECORD(
43: financial_report_id NUMBER := FND_API.G_MISS_NUM,
44: date_report_issued DATE := FND_API.G_MISS_DATE,
45: party_id NUMBER := FND_API.G_MISS_NUM,
46: document_reference VARCHAR2(120) := FND_API.G_MISS_CHAR,
47: issued_period VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 44: date_report_issued DATE := FND_API.G_MISS_DATE,

40: ----------------------------------------------------------------
41:
42: TYPE financial_reports_rec_type IS RECORD(
43: financial_report_id NUMBER := FND_API.G_MISS_NUM,
44: date_report_issued DATE := FND_API.G_MISS_DATE,
45: party_id NUMBER := FND_API.G_MISS_NUM,
46: document_reference VARCHAR2(120) := FND_API.G_MISS_CHAR,
47: issued_period VARCHAR2(60) := FND_API.G_MISS_CHAR,
48: requiring_authority VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 45: party_id NUMBER := FND_API.G_MISS_NUM,

41:
42: TYPE financial_reports_rec_type IS RECORD(
43: financial_report_id NUMBER := FND_API.G_MISS_NUM,
44: date_report_issued DATE := FND_API.G_MISS_DATE,
45: party_id NUMBER := FND_API.G_MISS_NUM,
46: document_reference VARCHAR2(120) := FND_API.G_MISS_CHAR,
47: issued_period VARCHAR2(60) := FND_API.G_MISS_CHAR,
48: requiring_authority VARCHAR2(60) := FND_API.G_MISS_CHAR,
49: type_of_financial_report VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 46: document_reference VARCHAR2(120) := FND_API.G_MISS_CHAR,

42: TYPE financial_reports_rec_type IS RECORD(
43: financial_report_id NUMBER := FND_API.G_MISS_NUM,
44: date_report_issued DATE := FND_API.G_MISS_DATE,
45: party_id NUMBER := FND_API.G_MISS_NUM,
46: document_reference VARCHAR2(120) := FND_API.G_MISS_CHAR,
47: issued_period VARCHAR2(60) := FND_API.G_MISS_CHAR,
48: requiring_authority VARCHAR2(60) := FND_API.G_MISS_CHAR,
49: type_of_financial_report VARCHAR2(60) := FND_API.G_MISS_CHAR,
50: wh_udpate_id DATE := FND_API.G_MISS_DATE,

Line 47: issued_period VARCHAR2(60) := FND_API.G_MISS_CHAR,

43: financial_report_id NUMBER := FND_API.G_MISS_NUM,
44: date_report_issued DATE := FND_API.G_MISS_DATE,
45: party_id NUMBER := FND_API.G_MISS_NUM,
46: document_reference VARCHAR2(120) := FND_API.G_MISS_CHAR,
47: issued_period VARCHAR2(60) := FND_API.G_MISS_CHAR,
48: requiring_authority VARCHAR2(60) := FND_API.G_MISS_CHAR,
49: type_of_financial_report VARCHAR2(60) := FND_API.G_MISS_CHAR,
50: wh_udpate_id DATE := FND_API.G_MISS_DATE,
51: report_start_date DATE := FND_API.G_MISS_DATE,

Line 48: requiring_authority VARCHAR2(60) := FND_API.G_MISS_CHAR,

44: date_report_issued DATE := FND_API.G_MISS_DATE,
45: party_id NUMBER := FND_API.G_MISS_NUM,
46: document_reference VARCHAR2(120) := FND_API.G_MISS_CHAR,
47: issued_period VARCHAR2(60) := FND_API.G_MISS_CHAR,
48: requiring_authority VARCHAR2(60) := FND_API.G_MISS_CHAR,
49: type_of_financial_report VARCHAR2(60) := FND_API.G_MISS_CHAR,
50: wh_udpate_id DATE := FND_API.G_MISS_DATE,
51: report_start_date DATE := FND_API.G_MISS_DATE,
52: report_end_date DATE := FND_API.G_MISS_DATE,

Line 49: type_of_financial_report VARCHAR2(60) := FND_API.G_MISS_CHAR,

45: party_id NUMBER := FND_API.G_MISS_NUM,
46: document_reference VARCHAR2(120) := FND_API.G_MISS_CHAR,
47: issued_period VARCHAR2(60) := FND_API.G_MISS_CHAR,
48: requiring_authority VARCHAR2(60) := FND_API.G_MISS_CHAR,
49: type_of_financial_report VARCHAR2(60) := FND_API.G_MISS_CHAR,
50: wh_udpate_id DATE := FND_API.G_MISS_DATE,
51: report_start_date DATE := FND_API.G_MISS_DATE,
52: report_end_date DATE := FND_API.G_MISS_DATE,
53: audit_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,

Line 50: wh_udpate_id DATE := FND_API.G_MISS_DATE,

46: document_reference VARCHAR2(120) := FND_API.G_MISS_CHAR,
47: issued_period VARCHAR2(60) := FND_API.G_MISS_CHAR,
48: requiring_authority VARCHAR2(60) := FND_API.G_MISS_CHAR,
49: type_of_financial_report VARCHAR2(60) := FND_API.G_MISS_CHAR,
50: wh_udpate_id DATE := FND_API.G_MISS_DATE,
51: report_start_date DATE := FND_API.G_MISS_DATE,
52: report_end_date DATE := FND_API.G_MISS_DATE,
53: audit_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
54: consolidated_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,

Line 51: report_start_date DATE := FND_API.G_MISS_DATE,

47: issued_period VARCHAR2(60) := FND_API.G_MISS_CHAR,
48: requiring_authority VARCHAR2(60) := FND_API.G_MISS_CHAR,
49: type_of_financial_report VARCHAR2(60) := FND_API.G_MISS_CHAR,
50: wh_udpate_id DATE := FND_API.G_MISS_DATE,
51: report_start_date DATE := FND_API.G_MISS_DATE,
52: report_end_date DATE := FND_API.G_MISS_DATE,
53: audit_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
54: consolidated_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
55: estimated_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,

Line 52: report_end_date DATE := FND_API.G_MISS_DATE,

48: requiring_authority VARCHAR2(60) := FND_API.G_MISS_CHAR,
49: type_of_financial_report VARCHAR2(60) := FND_API.G_MISS_CHAR,
50: wh_udpate_id DATE := FND_API.G_MISS_DATE,
51: report_start_date DATE := FND_API.G_MISS_DATE,
52: report_end_date DATE := FND_API.G_MISS_DATE,
53: audit_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
54: consolidated_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
55: estimated_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
56: fiscal_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,

Line 53: audit_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,

49: type_of_financial_report VARCHAR2(60) := FND_API.G_MISS_CHAR,
50: wh_udpate_id DATE := FND_API.G_MISS_DATE,
51: report_start_date DATE := FND_API.G_MISS_DATE,
52: report_end_date DATE := FND_API.G_MISS_DATE,
53: audit_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
54: consolidated_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
55: estimated_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
56: fiscal_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
57: final_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,

Line 54: consolidated_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,

50: wh_udpate_id DATE := FND_API.G_MISS_DATE,
51: report_start_date DATE := FND_API.G_MISS_DATE,
52: report_end_date DATE := FND_API.G_MISS_DATE,
53: audit_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
54: consolidated_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
55: estimated_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
56: fiscal_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
57: final_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
58: forecast_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,

Line 55: estimated_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,

51: report_start_date DATE := FND_API.G_MISS_DATE,
52: report_end_date DATE := FND_API.G_MISS_DATE,
53: audit_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
54: consolidated_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
55: estimated_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
56: fiscal_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
57: final_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
58: forecast_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
59: opening_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,

Line 56: fiscal_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,

52: report_end_date DATE := FND_API.G_MISS_DATE,
53: audit_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
54: consolidated_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
55: estimated_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
56: fiscal_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
57: final_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
58: forecast_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
59: opening_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
60: proforma_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,

Line 57: final_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,

53: audit_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
54: consolidated_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
55: estimated_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
56: fiscal_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
57: final_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
58: forecast_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
59: opening_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
60: proforma_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
61: qualified_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,

Line 58: forecast_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,

54: consolidated_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
55: estimated_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
56: fiscal_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
57: final_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
58: forecast_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
59: opening_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
60: proforma_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
61: qualified_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
62: restated_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,

Line 59: opening_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,

55: estimated_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
56: fiscal_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
57: final_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
58: forecast_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
59: opening_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
60: proforma_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
61: qualified_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
62: restated_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
63: signed_by_principals_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,

Line 60: proforma_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,

56: fiscal_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
57: final_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
58: forecast_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
59: opening_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
60: proforma_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
61: qualified_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
62: restated_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
63: signed_by_principals_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
64: trial_balance_ind VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 61: qualified_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,

57: final_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
58: forecast_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
59: opening_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
60: proforma_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
61: qualified_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
62: restated_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
63: signed_by_principals_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
64: trial_balance_ind VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: unbalanced_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,

Line 62: restated_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,

58: forecast_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
59: opening_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
60: proforma_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
61: qualified_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
62: restated_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
63: signed_by_principals_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
64: trial_balance_ind VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: unbalanced_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
66: content_source_type VARCHAR2(30) := G_MISS_CONTENT_SOURCE_TYPE,

Line 63: signed_by_principals_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,

59: opening_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
60: proforma_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
61: qualified_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
62: restated_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
63: signed_by_principals_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
64: trial_balance_ind VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: unbalanced_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
66: content_source_type VARCHAR2(30) := G_MISS_CONTENT_SOURCE_TYPE,
67: status VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 64: trial_balance_ind VARCHAR2(240) := FND_API.G_MISS_CHAR,

60: proforma_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
61: qualified_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
62: restated_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
63: signed_by_principals_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
64: trial_balance_ind VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: unbalanced_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
66: content_source_type VARCHAR2(30) := G_MISS_CONTENT_SOURCE_TYPE,
67: status VARCHAR2(1) := FND_API.G_MISS_CHAR,
68: actual_content_source VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 65: unbalanced_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,

61: qualified_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
62: restated_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
63: signed_by_principals_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
64: trial_balance_ind VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: unbalanced_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
66: content_source_type VARCHAR2(30) := G_MISS_CONTENT_SOURCE_TYPE,
67: status VARCHAR2(1) := FND_API.G_MISS_CHAR,
68: actual_content_source VARCHAR2(30) := FND_API.G_MISS_CHAR
69: );

Line 67: status VARCHAR2(1) := FND_API.G_MISS_CHAR,

63: signed_by_principals_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
64: trial_balance_ind VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: unbalanced_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
66: content_source_type VARCHAR2(30) := G_MISS_CONTENT_SOURCE_TYPE,
67: status VARCHAR2(1) := FND_API.G_MISS_CHAR,
68: actual_content_source VARCHAR2(30) := FND_API.G_MISS_CHAR
69: );
70:
71:

Line 68: actual_content_source VARCHAR2(30) := FND_API.G_MISS_CHAR

64: trial_balance_ind VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: unbalanced_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
66: content_source_type VARCHAR2(30) := G_MISS_CONTENT_SOURCE_TYPE,
67: status VARCHAR2(1) := FND_API.G_MISS_CHAR,
68: actual_content_source VARCHAR2(30) := FND_API.G_MISS_CHAR
69: );
70:
71:
72:

Line 80: financial_number_id NUMBER := FND_API.G_MISS_NUM,

76: ----------------------------------------------------------------
77:
78:
79: TYPE financial_numbers_rec_type IS RECORD(
80: financial_number_id NUMBER := FND_API.G_MISS_NUM,
81: financial_report_id NUMBER := FND_API.G_MISS_NUM,
82: financial_number NUMBER := FND_API.G_MISS_NUM,
83: financial_number_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
84: financial_units_applied NUMBER := FND_API.G_MISS_NUM,

Line 81: financial_report_id NUMBER := FND_API.G_MISS_NUM,

77:
78:
79: TYPE financial_numbers_rec_type IS RECORD(
80: financial_number_id NUMBER := FND_API.G_MISS_NUM,
81: financial_report_id NUMBER := FND_API.G_MISS_NUM,
82: financial_number NUMBER := FND_API.G_MISS_NUM,
83: financial_number_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
84: financial_units_applied NUMBER := FND_API.G_MISS_NUM,
85: financial_number_currency VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 82: financial_number NUMBER := FND_API.G_MISS_NUM,

78:
79: TYPE financial_numbers_rec_type IS RECORD(
80: financial_number_id NUMBER := FND_API.G_MISS_NUM,
81: financial_report_id NUMBER := FND_API.G_MISS_NUM,
82: financial_number NUMBER := FND_API.G_MISS_NUM,
83: financial_number_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
84: financial_units_applied NUMBER := FND_API.G_MISS_NUM,
85: financial_number_currency VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: projected_actual_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 83: financial_number_name VARCHAR2(60) := FND_API.G_MISS_CHAR,

79: TYPE financial_numbers_rec_type IS RECORD(
80: financial_number_id NUMBER := FND_API.G_MISS_NUM,
81: financial_report_id NUMBER := FND_API.G_MISS_NUM,
82: financial_number NUMBER := FND_API.G_MISS_NUM,
83: financial_number_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
84: financial_units_applied NUMBER := FND_API.G_MISS_NUM,
85: financial_number_currency VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: projected_actual_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
87: wh_update_date DATE := FND_API.G_MISS_DATE,

Line 84: financial_units_applied NUMBER := FND_API.G_MISS_NUM,

80: financial_number_id NUMBER := FND_API.G_MISS_NUM,
81: financial_report_id NUMBER := FND_API.G_MISS_NUM,
82: financial_number NUMBER := FND_API.G_MISS_NUM,
83: financial_number_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
84: financial_units_applied NUMBER := FND_API.G_MISS_NUM,
85: financial_number_currency VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: projected_actual_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
87: wh_update_date DATE := FND_API.G_MISS_DATE,
88: content_source_type VARCHAR2(30) := G_MISS_CONTENT_SOURCE_TYPE,

Line 85: financial_number_currency VARCHAR2(240) := FND_API.G_MISS_CHAR,

81: financial_report_id NUMBER := FND_API.G_MISS_NUM,
82: financial_number NUMBER := FND_API.G_MISS_NUM,
83: financial_number_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
84: financial_units_applied NUMBER := FND_API.G_MISS_NUM,
85: financial_number_currency VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: projected_actual_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
87: wh_update_date DATE := FND_API.G_MISS_DATE,
88: content_source_type VARCHAR2(30) := G_MISS_CONTENT_SOURCE_TYPE,
89: status VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 86: projected_actual_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

82: financial_number NUMBER := FND_API.G_MISS_NUM,
83: financial_number_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
84: financial_units_applied NUMBER := FND_API.G_MISS_NUM,
85: financial_number_currency VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: projected_actual_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
87: wh_update_date DATE := FND_API.G_MISS_DATE,
88: content_source_type VARCHAR2(30) := G_MISS_CONTENT_SOURCE_TYPE,
89: status VARCHAR2(1) := FND_API.G_MISS_CHAR
90: );

Line 87: wh_update_date DATE := FND_API.G_MISS_DATE,

83: financial_number_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
84: financial_units_applied NUMBER := FND_API.G_MISS_NUM,
85: financial_number_currency VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: projected_actual_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
87: wh_update_date DATE := FND_API.G_MISS_DATE,
88: content_source_type VARCHAR2(30) := G_MISS_CONTENT_SOURCE_TYPE,
89: status VARCHAR2(1) := FND_API.G_MISS_CHAR
90: );
91:

Line 89: status VARCHAR2(1) := FND_API.G_MISS_CHAR

85: financial_number_currency VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: projected_actual_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
87: wh_update_date DATE := FND_API.G_MISS_DATE,
88: content_source_type VARCHAR2(30) := G_MISS_CONTENT_SOURCE_TYPE,
89: status VARCHAR2(1) := FND_API.G_MISS_CHAR
90: );
91:
92:
93: ----------------------------------------------------------------

Line 99: certification_id NUMBER := FND_API.G_MISS_NUM,

95: ----------------------------------------------------------------
96:
97:
98: TYPE certifications_rec_type IS RECORD(
99: certification_id NUMBER := FND_API.G_MISS_NUM,
100: certification_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
101: party_id NUMBER := FND_API.G_MISS_NUM,
102: current_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: expires_on_date DATE := FND_API.G_MISS_DATE,

Line 100: certification_name VARCHAR2(240) := FND_API.G_MISS_CHAR,

96:
97:
98: TYPE certifications_rec_type IS RECORD(
99: certification_id NUMBER := FND_API.G_MISS_NUM,
100: certification_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
101: party_id NUMBER := FND_API.G_MISS_NUM,
102: current_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: expires_on_date DATE := FND_API.G_MISS_DATE,
104: grade VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 101: party_id NUMBER := FND_API.G_MISS_NUM,

97:
98: TYPE certifications_rec_type IS RECORD(
99: certification_id NUMBER := FND_API.G_MISS_NUM,
100: certification_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
101: party_id NUMBER := FND_API.G_MISS_NUM,
102: current_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: expires_on_date DATE := FND_API.G_MISS_DATE,
104: grade VARCHAR2(30) := FND_API.G_MISS_CHAR,
105: issued_by_authority VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 102: current_status VARCHAR2(30) := FND_API.G_MISS_CHAR,

98: TYPE certifications_rec_type IS RECORD(
99: certification_id NUMBER := FND_API.G_MISS_NUM,
100: certification_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
101: party_id NUMBER := FND_API.G_MISS_NUM,
102: current_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: expires_on_date DATE := FND_API.G_MISS_DATE,
104: grade VARCHAR2(30) := FND_API.G_MISS_CHAR,
105: issued_by_authority VARCHAR2(60) := FND_API.G_MISS_CHAR,
106: issued_on_date DATE := FND_API.G_MISS_DATE,

Line 103: expires_on_date DATE := FND_API.G_MISS_DATE,

99: certification_id NUMBER := FND_API.G_MISS_NUM,
100: certification_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
101: party_id NUMBER := FND_API.G_MISS_NUM,
102: current_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: expires_on_date DATE := FND_API.G_MISS_DATE,
104: grade VARCHAR2(30) := FND_API.G_MISS_CHAR,
105: issued_by_authority VARCHAR2(60) := FND_API.G_MISS_CHAR,
106: issued_on_date DATE := FND_API.G_MISS_DATE,
107: wh_update_date DATE := FND_API.G_MISS_DATE,

Line 104: grade VARCHAR2(30) := FND_API.G_MISS_CHAR,

100: certification_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
101: party_id NUMBER := FND_API.G_MISS_NUM,
102: current_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: expires_on_date DATE := FND_API.G_MISS_DATE,
104: grade VARCHAR2(30) := FND_API.G_MISS_CHAR,
105: issued_by_authority VARCHAR2(60) := FND_API.G_MISS_CHAR,
106: issued_on_date DATE := FND_API.G_MISS_DATE,
107: wh_update_date DATE := FND_API.G_MISS_DATE,
108: status VARCHAR2(1) := FND_API.G_MISS_CHAR);

Line 105: issued_by_authority VARCHAR2(60) := FND_API.G_MISS_CHAR,

101: party_id NUMBER := FND_API.G_MISS_NUM,
102: current_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: expires_on_date DATE := FND_API.G_MISS_DATE,
104: grade VARCHAR2(30) := FND_API.G_MISS_CHAR,
105: issued_by_authority VARCHAR2(60) := FND_API.G_MISS_CHAR,
106: issued_on_date DATE := FND_API.G_MISS_DATE,
107: wh_update_date DATE := FND_API.G_MISS_DATE,
108: status VARCHAR2(1) := FND_API.G_MISS_CHAR);
109:

Line 106: issued_on_date DATE := FND_API.G_MISS_DATE,

102: current_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: expires_on_date DATE := FND_API.G_MISS_DATE,
104: grade VARCHAR2(30) := FND_API.G_MISS_CHAR,
105: issued_by_authority VARCHAR2(60) := FND_API.G_MISS_CHAR,
106: issued_on_date DATE := FND_API.G_MISS_DATE,
107: wh_update_date DATE := FND_API.G_MISS_DATE,
108: status VARCHAR2(1) := FND_API.G_MISS_CHAR);
109:
110: ----------------------------------------------------------------

Line 107: wh_update_date DATE := FND_API.G_MISS_DATE,

103: expires_on_date DATE := FND_API.G_MISS_DATE,
104: grade VARCHAR2(30) := FND_API.G_MISS_CHAR,
105: issued_by_authority VARCHAR2(60) := FND_API.G_MISS_CHAR,
106: issued_on_date DATE := FND_API.G_MISS_DATE,
107: wh_update_date DATE := FND_API.G_MISS_DATE,
108: status VARCHAR2(1) := FND_API.G_MISS_CHAR);
109:
110: ----------------------------------------------------------------
111: ------------------ #6 industrial_reference_rec_type ---------

Line 108: status VARCHAR2(1) := FND_API.G_MISS_CHAR);

104: grade VARCHAR2(30) := FND_API.G_MISS_CHAR,
105: issued_by_authority VARCHAR2(60) := FND_API.G_MISS_CHAR,
106: issued_on_date DATE := FND_API.G_MISS_DATE,
107: wh_update_date DATE := FND_API.G_MISS_DATE,
108: status VARCHAR2(1) := FND_API.G_MISS_CHAR);
109:
110: ----------------------------------------------------------------
111: ------------------ #6 industrial_reference_rec_type ---------
112: ----------------------------------------------------------------

Line 115: industry_reference_id NUMBER := FND_API.G_MISS_NUM,

111: ------------------ #6 industrial_reference_rec_type ---------
112: ----------------------------------------------------------------
113:
114: TYPE industrial_reference_rec_type IS RECORD(
115: industry_reference_id NUMBER := FND_API.G_MISS_NUM,
116: industry_reference VARCHAR2(60) := FND_API.G_MISS_CHAR,
117: party_id NUMBER := FND_API.G_MISS_NUM,
118: issued_by_authority VARCHAR2(60) := FND_API.G_MISS_CHAR,
119: name_of_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 116: industry_reference VARCHAR2(60) := FND_API.G_MISS_CHAR,

112: ----------------------------------------------------------------
113:
114: TYPE industrial_reference_rec_type IS RECORD(
115: industry_reference_id NUMBER := FND_API.G_MISS_NUM,
116: industry_reference VARCHAR2(60) := FND_API.G_MISS_CHAR,
117: party_id NUMBER := FND_API.G_MISS_NUM,
118: issued_by_authority VARCHAR2(60) := FND_API.G_MISS_CHAR,
119: name_of_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
120: recognized_as_of_date DATE := FND_API.G_MISS_DATE,

Line 117: party_id NUMBER := FND_API.G_MISS_NUM,

113:
114: TYPE industrial_reference_rec_type IS RECORD(
115: industry_reference_id NUMBER := FND_API.G_MISS_NUM,
116: industry_reference VARCHAR2(60) := FND_API.G_MISS_CHAR,
117: party_id NUMBER := FND_API.G_MISS_NUM,
118: issued_by_authority VARCHAR2(60) := FND_API.G_MISS_CHAR,
119: name_of_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
120: recognized_as_of_date DATE := FND_API.G_MISS_DATE,
121: wh_update_date DATE := FND_API.G_MISS_DATE,

Line 118: issued_by_authority VARCHAR2(60) := FND_API.G_MISS_CHAR,

114: TYPE industrial_reference_rec_type IS RECORD(
115: industry_reference_id NUMBER := FND_API.G_MISS_NUM,
116: industry_reference VARCHAR2(60) := FND_API.G_MISS_CHAR,
117: party_id NUMBER := FND_API.G_MISS_NUM,
118: issued_by_authority VARCHAR2(60) := FND_API.G_MISS_CHAR,
119: name_of_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
120: recognized_as_of_date DATE := FND_API.G_MISS_DATE,
121: wh_update_date DATE := FND_API.G_MISS_DATE,
122: status VARCHAR2(1) := FND_API.G_MISS_CHAR);

Line 119: name_of_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,

115: industry_reference_id NUMBER := FND_API.G_MISS_NUM,
116: industry_reference VARCHAR2(60) := FND_API.G_MISS_CHAR,
117: party_id NUMBER := FND_API.G_MISS_NUM,
118: issued_by_authority VARCHAR2(60) := FND_API.G_MISS_CHAR,
119: name_of_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
120: recognized_as_of_date DATE := FND_API.G_MISS_DATE,
121: wh_update_date DATE := FND_API.G_MISS_DATE,
122: status VARCHAR2(1) := FND_API.G_MISS_CHAR);
123:

Line 120: recognized_as_of_date DATE := FND_API.G_MISS_DATE,

116: industry_reference VARCHAR2(60) := FND_API.G_MISS_CHAR,
117: party_id NUMBER := FND_API.G_MISS_NUM,
118: issued_by_authority VARCHAR2(60) := FND_API.G_MISS_CHAR,
119: name_of_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
120: recognized_as_of_date DATE := FND_API.G_MISS_DATE,
121: wh_update_date DATE := FND_API.G_MISS_DATE,
122: status VARCHAR2(1) := FND_API.G_MISS_CHAR);
123:
124: ----------------------------------------------------------------

Line 121: wh_update_date DATE := FND_API.G_MISS_DATE,

117: party_id NUMBER := FND_API.G_MISS_NUM,
118: issued_by_authority VARCHAR2(60) := FND_API.G_MISS_CHAR,
119: name_of_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
120: recognized_as_of_date DATE := FND_API.G_MISS_DATE,
121: wh_update_date DATE := FND_API.G_MISS_DATE,
122: status VARCHAR2(1) := FND_API.G_MISS_CHAR);
123:
124: ----------------------------------------------------------------
125: ------------------ #7 industrial_classes_rec_typ ------------

Line 122: status VARCHAR2(1) := FND_API.G_MISS_CHAR);

118: issued_by_authority VARCHAR2(60) := FND_API.G_MISS_CHAR,
119: name_of_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
120: recognized_as_of_date DATE := FND_API.G_MISS_DATE,
121: wh_update_date DATE := FND_API.G_MISS_DATE,
122: status VARCHAR2(1) := FND_API.G_MISS_CHAR);
123:
124: ----------------------------------------------------------------
125: ------------------ #7 industrial_classes_rec_typ ------------
126: ----------------------------------------------------------------

Line 130: industrial_class_id NUMBER := FND_API.G_MISS_NUM,

126: ----------------------------------------------------------------
127:
128:
129: TYPE industrial_classes_rec_type IS RECORD(
130: industrial_class_id NUMBER := FND_API.G_MISS_NUM,
131: industrial_code_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
132: code_primary_segment VARCHAR2(60) := FND_API.G_MISS_CHAR,
133: industrial_class_source VARCHAR2(60) := FND_API.G_MISS_CHAR,
134: code_description VARCHAR2(2000) := FND_API.G_MISS_CHAR,

Line 131: industrial_code_name VARCHAR2(60) := FND_API.G_MISS_CHAR,

127:
128:
129: TYPE industrial_classes_rec_type IS RECORD(
130: industrial_class_id NUMBER := FND_API.G_MISS_NUM,
131: industrial_code_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
132: code_primary_segment VARCHAR2(60) := FND_API.G_MISS_CHAR,
133: industrial_class_source VARCHAR2(60) := FND_API.G_MISS_CHAR,
134: code_description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
135: wh_update_date DATE := FND_API.G_MISS_DATE);

Line 132: code_primary_segment VARCHAR2(60) := FND_API.G_MISS_CHAR,

128:
129: TYPE industrial_classes_rec_type IS RECORD(
130: industrial_class_id NUMBER := FND_API.G_MISS_NUM,
131: industrial_code_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
132: code_primary_segment VARCHAR2(60) := FND_API.G_MISS_CHAR,
133: industrial_class_source VARCHAR2(60) := FND_API.G_MISS_CHAR,
134: code_description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
135: wh_update_date DATE := FND_API.G_MISS_DATE);
136:

Line 133: industrial_class_source VARCHAR2(60) := FND_API.G_MISS_CHAR,

129: TYPE industrial_classes_rec_type IS RECORD(
130: industrial_class_id NUMBER := FND_API.G_MISS_NUM,
131: industrial_code_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
132: code_primary_segment VARCHAR2(60) := FND_API.G_MISS_CHAR,
133: industrial_class_source VARCHAR2(60) := FND_API.G_MISS_CHAR,
134: code_description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
135: wh_update_date DATE := FND_API.G_MISS_DATE);
136:
137: ----------------------------------------------------------------

Line 134: code_description VARCHAR2(2000) := FND_API.G_MISS_CHAR,

130: industrial_class_id NUMBER := FND_API.G_MISS_NUM,
131: industrial_code_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
132: code_primary_segment VARCHAR2(60) := FND_API.G_MISS_CHAR,
133: industrial_class_source VARCHAR2(60) := FND_API.G_MISS_CHAR,
134: code_description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
135: wh_update_date DATE := FND_API.G_MISS_DATE);
136:
137: ----------------------------------------------------------------
138: ------------------ #8 industrial_class_app_rec_type ---------

Line 135: wh_update_date DATE := FND_API.G_MISS_DATE);

131: industrial_code_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
132: code_primary_segment VARCHAR2(60) := FND_API.G_MISS_CHAR,
133: industrial_class_source VARCHAR2(60) := FND_API.G_MISS_CHAR,
134: code_description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
135: wh_update_date DATE := FND_API.G_MISS_DATE);
136:
137: ----------------------------------------------------------------
138: ------------------ #8 industrial_class_app_rec_type ---------
139: ----------------------------------------------------------------

Line 142: code_applied_id NUMBER := FND_API.G_MISS_NUM,

138: ------------------ #8 industrial_class_app_rec_type ---------
139: ----------------------------------------------------------------
140:
141: TYPE industrial_class_app_rec_type IS RECORD(
142: code_applied_id NUMBER := FND_API.G_MISS_NUM,
143: begin_date DATE := FND_API.G_MISS_DATE,
144: party_id NUMBER := FND_API.G_MISS_NUM,
145: end_date DATE := FND_API.G_MISS_DATE,
146: industrial_class_id NUMBER := FND_API.G_MISS_NUM,

Line 143: begin_date DATE := FND_API.G_MISS_DATE,

139: ----------------------------------------------------------------
140:
141: TYPE industrial_class_app_rec_type IS RECORD(
142: code_applied_id NUMBER := FND_API.G_MISS_NUM,
143: begin_date DATE := FND_API.G_MISS_DATE,
144: party_id NUMBER := FND_API.G_MISS_NUM,
145: end_date DATE := FND_API.G_MISS_DATE,
146: industrial_class_id NUMBER := FND_API.G_MISS_NUM,
147: wh_update_date DATE := FND_API.G_MISS_DATE,

Line 144: party_id NUMBER := FND_API.G_MISS_NUM,

140:
141: TYPE industrial_class_app_rec_type IS RECORD(
142: code_applied_id NUMBER := FND_API.G_MISS_NUM,
143: begin_date DATE := FND_API.G_MISS_DATE,
144: party_id NUMBER := FND_API.G_MISS_NUM,
145: end_date DATE := FND_API.G_MISS_DATE,
146: industrial_class_id NUMBER := FND_API.G_MISS_NUM,
147: wh_update_date DATE := FND_API.G_MISS_DATE,
148: content_source_type VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 145: end_date DATE := FND_API.G_MISS_DATE,

141: TYPE industrial_class_app_rec_type IS RECORD(
142: code_applied_id NUMBER := FND_API.G_MISS_NUM,
143: begin_date DATE := FND_API.G_MISS_DATE,
144: party_id NUMBER := FND_API.G_MISS_NUM,
145: end_date DATE := FND_API.G_MISS_DATE,
146: industrial_class_id NUMBER := FND_API.G_MISS_NUM,
147: wh_update_date DATE := FND_API.G_MISS_DATE,
148: content_source_type VARCHAR2(60) := FND_API.G_MISS_CHAR,
149: importance_ranking VARCHAR2(240) := FND_API.G_MISS_CHAR);

Line 146: industrial_class_id NUMBER := FND_API.G_MISS_NUM,

142: code_applied_id NUMBER := FND_API.G_MISS_NUM,
143: begin_date DATE := FND_API.G_MISS_DATE,
144: party_id NUMBER := FND_API.G_MISS_NUM,
145: end_date DATE := FND_API.G_MISS_DATE,
146: industrial_class_id NUMBER := FND_API.G_MISS_NUM,
147: wh_update_date DATE := FND_API.G_MISS_DATE,
148: content_source_type VARCHAR2(60) := FND_API.G_MISS_CHAR,
149: importance_ranking VARCHAR2(240) := FND_API.G_MISS_CHAR);
150:

Line 147: wh_update_date DATE := FND_API.G_MISS_DATE,

143: begin_date DATE := FND_API.G_MISS_DATE,
144: party_id NUMBER := FND_API.G_MISS_NUM,
145: end_date DATE := FND_API.G_MISS_DATE,
146: industrial_class_id NUMBER := FND_API.G_MISS_NUM,
147: wh_update_date DATE := FND_API.G_MISS_DATE,
148: content_source_type VARCHAR2(60) := FND_API.G_MISS_CHAR,
149: importance_ranking VARCHAR2(240) := FND_API.G_MISS_CHAR);
150:
151:

Line 148: content_source_type VARCHAR2(60) := FND_API.G_MISS_CHAR,

144: party_id NUMBER := FND_API.G_MISS_NUM,
145: end_date DATE := FND_API.G_MISS_DATE,
146: industrial_class_id NUMBER := FND_API.G_MISS_NUM,
147: wh_update_date DATE := FND_API.G_MISS_DATE,
148: content_source_type VARCHAR2(60) := FND_API.G_MISS_CHAR,
149: importance_ranking VARCHAR2(240) := FND_API.G_MISS_CHAR);
150:
151:
152: --------------------- #1 -----------------------------

Line 149: importance_ranking VARCHAR2(240) := FND_API.G_MISS_CHAR);

145: end_date DATE := FND_API.G_MISS_DATE,
146: industrial_class_id NUMBER := FND_API.G_MISS_NUM,
147: wh_update_date DATE := FND_API.G_MISS_DATE,
148: content_source_type VARCHAR2(60) := FND_API.G_MISS_CHAR,
149: importance_ranking VARCHAR2(240) := FND_API.G_MISS_CHAR);
150:
151:
152: --------------------- #1 -----------------------------
153:

Line 156: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

152: --------------------- #1 -----------------------------
153:
154: procedure create_stock_markets(
155: p_api_version IN NUMBER,
156: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
157: p_commit IN VARCHAR2:= FND_API.G_FALSE,
158: p_stock_markets_rec IN STOCK_MARKETS_REC_TYPE,
159: x_return_status OUT NOCOPY VARCHAR2,
160: x_msg_count OUT NOCOPY NUMBER,

Line 157: p_commit IN VARCHAR2:= FND_API.G_FALSE,

153:
154: procedure create_stock_markets(
155: p_api_version IN NUMBER,
156: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
157: p_commit IN VARCHAR2:= FND_API.G_FALSE,
158: p_stock_markets_rec IN STOCK_MARKETS_REC_TYPE,
159: x_return_status OUT NOCOPY VARCHAR2,
160: x_msg_count OUT NOCOPY NUMBER,
161: x_msg_data OUT NOCOPY VARCHAR2,

Line 163: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

159: x_return_status OUT NOCOPY VARCHAR2,
160: x_msg_count OUT NOCOPY NUMBER,
161: x_msg_data OUT NOCOPY VARCHAR2,
162: x_stock_exchange_id OUT NOCOPY NUMBER,
163: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
164: );
165:
166: procedure update_stock_markets(
167: p_api_version IN NUMBER,

Line 168: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

164: );
165:
166: procedure update_stock_markets(
167: p_api_version IN NUMBER,
168: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
169: p_commit IN VARCHAR2:= FND_API.G_FALSE,
170: p_stock_markets_rec IN STOCK_MARKETS_REC_TYPE,
171: p_last_update_date IN OUT NOCOPY DATE,
172: x_return_status OUT NOCOPY VARCHAR2,

Line 169: p_commit IN VARCHAR2:= FND_API.G_FALSE,

165:
166: procedure update_stock_markets(
167: p_api_version IN NUMBER,
168: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
169: p_commit IN VARCHAR2:= FND_API.G_FALSE,
170: p_stock_markets_rec IN STOCK_MARKETS_REC_TYPE,
171: p_last_update_date IN OUT NOCOPY DATE,
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,

Line 175: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

171: p_last_update_date IN OUT NOCOPY DATE,
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2,
175: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
176: );
177:
178: --------------------- #2 -----------------------------
179: procedure create_security_issued(

Line 181: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

177:
178: --------------------- #2 -----------------------------
179: procedure create_security_issued(
180: p_api_version IN NUMBER,
181: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
182: p_commit IN VARCHAR2:= FND_API.G_FALSE,
183: p_security_issued_rec IN SECURITY_ISSUED_REC_TYPE,
184: x_return_status OUT NOCOPY VARCHAR2,
185: x_msg_count OUT NOCOPY NUMBER,

Line 182: p_commit IN VARCHAR2:= FND_API.G_FALSE,

178: --------------------- #2 -----------------------------
179: procedure create_security_issued(
180: p_api_version IN NUMBER,
181: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
182: p_commit IN VARCHAR2:= FND_API.G_FALSE,
183: p_security_issued_rec IN SECURITY_ISSUED_REC_TYPE,
184: x_return_status OUT NOCOPY VARCHAR2,
185: x_msg_count OUT NOCOPY NUMBER,
186: x_msg_data OUT NOCOPY VARCHAR2,

Line 188: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

184: x_return_status OUT NOCOPY VARCHAR2,
185: x_msg_count OUT NOCOPY NUMBER,
186: x_msg_data OUT NOCOPY VARCHAR2,
187: x_security_issued_id OUT NOCOPY NUMBER,
188: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
189: );
190:
191:
192: procedure update_security_issued(

Line 194: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

190:
191:
192: procedure update_security_issued(
193: p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
195: p_commit IN VARCHAR2:= FND_API.G_FALSE,
196: p_security_issued_rec IN SECURITY_ISSUED_REC_TYPE,
197: p_last_update_date IN OUT NOCOPY DATE,
198: x_return_status OUT NOCOPY VARCHAR2,

Line 195: p_commit IN VARCHAR2:= FND_API.G_FALSE,

191:
192: procedure update_security_issued(
193: p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
195: p_commit IN VARCHAR2:= FND_API.G_FALSE,
196: p_security_issued_rec IN SECURITY_ISSUED_REC_TYPE,
197: p_last_update_date IN OUT NOCOPY DATE,
198: x_return_status OUT NOCOPY VARCHAR2,
199: x_msg_count OUT NOCOPY NUMBER,

Line 201: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

197: p_last_update_date IN OUT NOCOPY DATE,
198: x_return_status OUT NOCOPY VARCHAR2,
199: x_msg_count OUT NOCOPY NUMBER,
200: x_msg_data OUT NOCOPY VARCHAR2,
201: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
202: );
203:
204: --------------------- #3 -----------------------------
205: /* Obsolete V1 API

Line 208: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

204: --------------------- #3 -----------------------------
205: /* Obsolete V1 API
206: procedure create_financial_reports(
207: p_api_version IN NUMBER,
208: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
209: p_commit IN VARCHAR2:= FND_API.G_FALSE,
210: p_financial_reports_rec IN FINANCIAL_REPORTS_REC_TYPE,
211: x_return_status OUT NOCOPY VARCHAR2,
212: x_msg_count OUT NOCOPY NUMBER,

Line 209: p_commit IN VARCHAR2:= FND_API.G_FALSE,

205: /* Obsolete V1 API
206: procedure create_financial_reports(
207: p_api_version IN NUMBER,
208: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
209: p_commit IN VARCHAR2:= FND_API.G_FALSE,
210: p_financial_reports_rec IN FINANCIAL_REPORTS_REC_TYPE,
211: x_return_status OUT NOCOPY VARCHAR2,
212: x_msg_count OUT NOCOPY NUMBER,
213: x_msg_data OUT NOCOPY VARCHAR2,

Line 215: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

211: x_return_status OUT NOCOPY VARCHAR2,
212: x_msg_count OUT NOCOPY NUMBER,
213: x_msg_data OUT NOCOPY VARCHAR2,
214: x_financial_report_id OUT NOCOPY NUMBER,
215: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
216: );
217:
218:
219: procedure update_financial_reports(

Line 221: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

217:
218:
219: procedure update_financial_reports(
220: p_api_version IN NUMBER,
221: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
222: p_commit IN VARCHAR2:= FND_API.G_FALSE,
223: p_financial_reports_rec IN FINANCIAL_REPORTS_REC_TYPE,
224: p_last_update_date IN OUT NOCOPY DATE,
225: x_return_status OUT NOCOPY VARCHAR2,

Line 222: p_commit IN VARCHAR2:= FND_API.G_FALSE,

218:
219: procedure update_financial_reports(
220: p_api_version IN NUMBER,
221: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
222: p_commit IN VARCHAR2:= FND_API.G_FALSE,
223: p_financial_reports_rec IN FINANCIAL_REPORTS_REC_TYPE,
224: p_last_update_date IN OUT NOCOPY DATE,
225: x_return_status OUT NOCOPY VARCHAR2,
226: x_msg_count OUT NOCOPY NUMBER,

Line 228: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

224: p_last_update_date IN OUT NOCOPY DATE,
225: x_return_status OUT NOCOPY VARCHAR2,
226: x_msg_count OUT NOCOPY NUMBER,
227: x_msg_data OUT NOCOPY VARCHAR2,
228: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
229: );
230:
231: --------------------- #4 -----------------------------
232:

Line 235: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

231: --------------------- #4 -----------------------------
232:
233: procedure create_financial_numbers(
234: p_api_version IN NUMBER,
235: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
236: p_commit IN VARCHAR2:= FND_API.G_FALSE,
237: p_financial_numbers_rec IN FINANCIAL_NUMBERS_REC_TYPE,
238: x_return_status OUT NOCOPY VARCHAR2,
239: x_msg_count OUT NOCOPY NUMBER,

Line 236: p_commit IN VARCHAR2:= FND_API.G_FALSE,

232:
233: procedure create_financial_numbers(
234: p_api_version IN NUMBER,
235: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
236: p_commit IN VARCHAR2:= FND_API.G_FALSE,
237: p_financial_numbers_rec IN FINANCIAL_NUMBERS_REC_TYPE,
238: x_return_status OUT NOCOPY VARCHAR2,
239: x_msg_count OUT NOCOPY NUMBER,
240: x_msg_data OUT NOCOPY VARCHAR2,

Line 242: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

238: x_return_status OUT NOCOPY VARCHAR2,
239: x_msg_count OUT NOCOPY NUMBER,
240: x_msg_data OUT NOCOPY VARCHAR2,
241: x_financial_number_id OUT NOCOPY NUMBER,
242: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
243: );
244:
245:
246: procedure update_financial_numbers(

Line 248: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

244:
245:
246: procedure update_financial_numbers(
247: p_api_version IN NUMBER,
248: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
249: p_commit IN VARCHAR2:= FND_API.G_FALSE,
250: p_financial_numbers_rec IN FINANCIAL_NUMBERS_REC_TYPE,
251: p_last_update_date IN OUT NOCOPY DATE,
252: x_return_status OUT NOCOPY VARCHAR2,

Line 249: p_commit IN VARCHAR2:= FND_API.G_FALSE,

245:
246: procedure update_financial_numbers(
247: p_api_version IN NUMBER,
248: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
249: p_commit IN VARCHAR2:= FND_API.G_FALSE,
250: p_financial_numbers_rec IN FINANCIAL_NUMBERS_REC_TYPE,
251: p_last_update_date IN OUT NOCOPY DATE,
252: x_return_status OUT NOCOPY VARCHAR2,
253: x_msg_count OUT NOCOPY NUMBER,

Line 255: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

251: p_last_update_date IN OUT NOCOPY DATE,
252: x_return_status OUT NOCOPY VARCHAR2,
253: x_msg_count OUT NOCOPY NUMBER,
254: x_msg_data OUT NOCOPY VARCHAR2,
255: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
256: );
257: */
258:
259: --------------------- #5 -----------------------------

Line 263: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

259: --------------------- #5 -----------------------------
260:
261: procedure create_certifications(
262: p_api_version IN NUMBER,
263: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
264: p_commit IN VARCHAR2:= FND_API.G_FALSE,
265: p_certifications_rec IN CERTIFICATIONS_REC_TYPE,
266: x_return_status OUT NOCOPY VARCHAR2,
267: x_msg_count OUT NOCOPY NUMBER,

Line 264: p_commit IN VARCHAR2:= FND_API.G_FALSE,

260:
261: procedure create_certifications(
262: p_api_version IN NUMBER,
263: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
264: p_commit IN VARCHAR2:= FND_API.G_FALSE,
265: p_certifications_rec IN CERTIFICATIONS_REC_TYPE,
266: x_return_status OUT NOCOPY VARCHAR2,
267: x_msg_count OUT NOCOPY NUMBER,
268: x_msg_data OUT NOCOPY VARCHAR2,

Line 270: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

266: x_return_status OUT NOCOPY VARCHAR2,
267: x_msg_count OUT NOCOPY NUMBER,
268: x_msg_data OUT NOCOPY VARCHAR2,
269: x_certification_id OUT NOCOPY NUMBER,
270: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
271: );
272:
273:
274: procedure update_certifications(

Line 276: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

272:
273:
274: procedure update_certifications(
275: p_api_version IN NUMBER,
276: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
277: p_commit IN VARCHAR2:= FND_API.G_FALSE,
278: p_certifications_rec IN CERTIFICATIONS_REC_TYPE,
279: p_last_update_date IN OUT NOCOPY DATE,
280: x_return_status OUT NOCOPY VARCHAR2,

Line 277: p_commit IN VARCHAR2:= FND_API.G_FALSE,

273:
274: procedure update_certifications(
275: p_api_version IN NUMBER,
276: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
277: p_commit IN VARCHAR2:= FND_API.G_FALSE,
278: p_certifications_rec IN CERTIFICATIONS_REC_TYPE,
279: p_last_update_date IN OUT NOCOPY DATE,
280: x_return_status OUT NOCOPY VARCHAR2,
281: x_msg_count OUT NOCOPY NUMBER,

Line 283: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

279: p_last_update_date IN OUT NOCOPY DATE,
280: x_return_status OUT NOCOPY VARCHAR2,
281: x_msg_count OUT NOCOPY NUMBER,
282: x_msg_data OUT NOCOPY VARCHAR2,
283: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
284: );
285:
286: --------------------- #6 -----------------------------
287:

Line 290: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

286: --------------------- #6 -----------------------------
287:
288: procedure create_industrial_reference(
289: p_api_version IN NUMBER,
290: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
291: p_commit IN VARCHAR2:= FND_API.G_FALSE,
292: p_industrial_reference_rec IN INDUSTRIAL_REFERENCE_REC_TYPE,
293: x_return_status OUT NOCOPY VARCHAR2,
294: x_msg_count OUT NOCOPY NUMBER,

Line 291: p_commit IN VARCHAR2:= FND_API.G_FALSE,

287:
288: procedure create_industrial_reference(
289: p_api_version IN NUMBER,
290: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
291: p_commit IN VARCHAR2:= FND_API.G_FALSE,
292: p_industrial_reference_rec IN INDUSTRIAL_REFERENCE_REC_TYPE,
293: x_return_status OUT NOCOPY VARCHAR2,
294: x_msg_count OUT NOCOPY NUMBER,
295: x_msg_data OUT NOCOPY VARCHAR2,

Line 297: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

293: x_return_status OUT NOCOPY VARCHAR2,
294: x_msg_count OUT NOCOPY NUMBER,
295: x_msg_data OUT NOCOPY VARCHAR2,
296: x_industry_reference_id OUT NOCOPY NUMBER,
297: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
298: );
299:
300:
301: procedure update_industrial_reference(

Line 303: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

299:
300:
301: procedure update_industrial_reference(
302: p_api_version IN NUMBER,
303: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
304: p_commit IN VARCHAR2:= FND_API.G_FALSE,
305: p_industrial_reference_rec IN INDUSTRIAL_REFERENCE_REC_TYPE,
306: p_last_update_date IN OUT NOCOPY DATE,
307: x_return_status OUT NOCOPY VARCHAR2,

Line 304: p_commit IN VARCHAR2:= FND_API.G_FALSE,

300:
301: procedure update_industrial_reference(
302: p_api_version IN NUMBER,
303: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
304: p_commit IN VARCHAR2:= FND_API.G_FALSE,
305: p_industrial_reference_rec IN INDUSTRIAL_REFERENCE_REC_TYPE,
306: p_last_update_date IN OUT NOCOPY DATE,
307: x_return_status OUT NOCOPY VARCHAR2,
308: x_msg_count OUT NOCOPY NUMBER,

Line 310: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

306: p_last_update_date IN OUT NOCOPY DATE,
307: x_return_status OUT NOCOPY VARCHAR2,
308: x_msg_count OUT NOCOPY NUMBER,
309: x_msg_data OUT NOCOPY VARCHAR2,
310: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
311: );
312:
313: --------------------- #7 -----------------------------
314:

Line 317: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

313: --------------------- #7 -----------------------------
314:
315: procedure create_industrial_classes(
316: p_api_version IN NUMBER,
317: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
318: p_commit IN VARCHAR2:= FND_API.G_FALSE,
319: p_industrial_classes_rec IN INDUSTRIAL_CLASSES_REC_TYPE,
320: x_return_status OUT NOCOPY VARCHAR2,
321: x_msg_count OUT NOCOPY NUMBER,

Line 318: p_commit IN VARCHAR2:= FND_API.G_FALSE,

314:
315: procedure create_industrial_classes(
316: p_api_version IN NUMBER,
317: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
318: p_commit IN VARCHAR2:= FND_API.G_FALSE,
319: p_industrial_classes_rec IN INDUSTRIAL_CLASSES_REC_TYPE,
320: x_return_status OUT NOCOPY VARCHAR2,
321: x_msg_count OUT NOCOPY NUMBER,
322: x_msg_data OUT NOCOPY VARCHAR2,

Line 324: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

320: x_return_status OUT NOCOPY VARCHAR2,
321: x_msg_count OUT NOCOPY NUMBER,
322: x_msg_data OUT NOCOPY VARCHAR2,
323: x_industrial_class_id OUT NOCOPY NUMBER,
324: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
325: );
326:
327:
328: procedure update_industrial_classes(

Line 330: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

326:
327:
328: procedure update_industrial_classes(
329: p_api_version IN NUMBER,
330: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
331: p_commit IN VARCHAR2:= FND_API.G_FALSE,
332: p_industrial_classes_rec IN INDUSTRIAL_CLASSES_REC_TYPE,
333: p_last_update_date IN OUT NOCOPY DATE,
334: x_return_status OUT NOCOPY VARCHAR2,

Line 331: p_commit IN VARCHAR2:= FND_API.G_FALSE,

327:
328: procedure update_industrial_classes(
329: p_api_version IN NUMBER,
330: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
331: p_commit IN VARCHAR2:= FND_API.G_FALSE,
332: p_industrial_classes_rec IN INDUSTRIAL_CLASSES_REC_TYPE,
333: p_last_update_date IN OUT NOCOPY DATE,
334: x_return_status OUT NOCOPY VARCHAR2,
335: x_msg_count OUT NOCOPY NUMBER,

Line 337: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

333: p_last_update_date IN OUT NOCOPY DATE,
334: x_return_status OUT NOCOPY VARCHAR2,
335: x_msg_count OUT NOCOPY NUMBER,
336: x_msg_data OUT NOCOPY VARCHAR2,
337: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
338: );
339:
340: --------------------- #8 -----------------------------
341:

Line 344: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

340: --------------------- #8 -----------------------------
341:
342: procedure create_industrial_class_app(
343: p_api_version IN NUMBER,
344: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
345: p_commit IN VARCHAR2:= FND_API.G_FALSE,
346: p_industrial_class_app_rec IN INDUSTRIAL_CLASS_APP_REC_TYPE,
347: x_return_status OUT NOCOPY VARCHAR2,
348: x_msg_count OUT NOCOPY NUMBER,

Line 345: p_commit IN VARCHAR2:= FND_API.G_FALSE,

341:
342: procedure create_industrial_class_app(
343: p_api_version IN NUMBER,
344: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
345: p_commit IN VARCHAR2:= FND_API.G_FALSE,
346: p_industrial_class_app_rec IN INDUSTRIAL_CLASS_APP_REC_TYPE,
347: x_return_status OUT NOCOPY VARCHAR2,
348: x_msg_count OUT NOCOPY NUMBER,
349: x_msg_data OUT NOCOPY VARCHAR2,

Line 351: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

347: x_return_status OUT NOCOPY VARCHAR2,
348: x_msg_count OUT NOCOPY NUMBER,
349: x_msg_data OUT NOCOPY VARCHAR2,
350: x_code_applied_id OUT NOCOPY NUMBER,
351: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
352: );
353:
354: procedure update_industrial_class_app(
355: p_api_version IN NUMBER,

Line 356: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

352: );
353:
354: procedure update_industrial_class_app(
355: p_api_version IN NUMBER,
356: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
357: p_commit IN VARCHAR2:= FND_API.G_FALSE,
358: p_industrial_class_app_rec IN INDUSTRIAL_CLASS_APP_REC_TYPE,
359: p_last_update_date IN OUT NOCOPY DATE,
360: x_return_status OUT NOCOPY VARCHAR2,

Line 357: p_commit IN VARCHAR2:= FND_API.G_FALSE,

353:
354: procedure update_industrial_class_app(
355: p_api_version IN NUMBER,
356: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
357: p_commit IN VARCHAR2:= FND_API.G_FALSE,
358: p_industrial_class_app_rec IN INDUSTRIAL_CLASS_APP_REC_TYPE,
359: p_last_update_date IN OUT NOCOPY DATE,
360: x_return_status OUT NOCOPY VARCHAR2,
361: x_msg_count OUT NOCOPY NUMBER,

Line 363: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

359: p_last_update_date IN OUT NOCOPY DATE,
360: x_return_status OUT NOCOPY VARCHAR2,
361: x_msg_count OUT NOCOPY NUMBER,
362: x_msg_data OUT NOCOPY VARCHAR2,
363: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
364: );
365:
366:
367: procedure get_current_financial_report(

Line 369: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

365:
366:
367: procedure get_current_financial_report(
368: p_api_version IN NUMBER,
369: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
370: p_financial_report_id IN NUMBER,
371: x_financial_reports_rec OUT NOCOPY FINANCIAL_REPORTS_REC_TYPE,
372: x_return_status IN OUT NOCOPY VARCHAR2,
373: x_msg_count OUT NOCOPY NUMBER,

Line 379: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

375: );
376:
377: procedure get_current_financial_number(
378: p_api_version IN NUMBER,
379: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
380: p_financial_number_id IN NUMBER,
381: x_financial_numbers_rec OUT NOCOPY FINANCIAL_NUMBERS_REC_TYPE,
382: x_return_status IN OUT NOCOPY VARCHAR2,
383: x_msg_count OUT NOCOPY NUMBER,