4: G_MISS_CONTENT_SOURCE_TYPE CONSTANT VARCHAR2(30) := 'USER_ENTERED';
5:
6: -------------------------------------------------------------------------
7: TYPE credit_ratings_rec_type IS RECORD(
8: credit_rating_id NUMBER := FND_API.G_MISS_NUM,
9: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
10: party_id NUMBER := FND_API.G_MISS_NUM,
11: rating VARCHAR2(60) := FND_API.G_MISS_CHAR,
12: rated_as_of_date DATE := FND_API.G_MISS_DATE,
5:
6: -------------------------------------------------------------------------
7: TYPE credit_ratings_rec_type IS RECORD(
8: credit_rating_id NUMBER := FND_API.G_MISS_NUM,
9: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
10: party_id NUMBER := FND_API.G_MISS_NUM,
11: rating VARCHAR2(60) := FND_API.G_MISS_CHAR,
12: rated_as_of_date DATE := FND_API.G_MISS_DATE,
13: rating_organization VARCHAR2(240) := FND_API.G_MISS_CHAR,
6: -------------------------------------------------------------------------
7: TYPE credit_ratings_rec_type IS RECORD(
8: credit_rating_id NUMBER := FND_API.G_MISS_NUM,
9: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
10: party_id NUMBER := FND_API.G_MISS_NUM,
11: rating VARCHAR2(60) := FND_API.G_MISS_CHAR,
12: rated_as_of_date DATE := FND_API.G_MISS_DATE,
13: rating_organization VARCHAR2(240) := FND_API.G_MISS_CHAR,
14: wh_update_date DATE := FND_API.G_MISS_DATE,
7: TYPE credit_ratings_rec_type IS RECORD(
8: credit_rating_id NUMBER := FND_API.G_MISS_NUM,
9: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
10: party_id NUMBER := FND_API.G_MISS_NUM,
11: rating VARCHAR2(60) := FND_API.G_MISS_CHAR,
12: rated_as_of_date DATE := FND_API.G_MISS_DATE,
13: rating_organization VARCHAR2(240) := FND_API.G_MISS_CHAR,
14: wh_update_date DATE := FND_API.G_MISS_DATE,
15: comments VARCHAR2(240) := FND_API.G_MISS_CHAR,
8: credit_rating_id NUMBER := FND_API.G_MISS_NUM,
9: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
10: party_id NUMBER := FND_API.G_MISS_NUM,
11: rating VARCHAR2(60) := FND_API.G_MISS_CHAR,
12: rated_as_of_date DATE := FND_API.G_MISS_DATE,
13: rating_organization VARCHAR2(240) := FND_API.G_MISS_CHAR,
14: wh_update_date DATE := FND_API.G_MISS_DATE,
15: comments VARCHAR2(240) := FND_API.G_MISS_CHAR,
16: det_history_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
9: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
10: party_id NUMBER := FND_API.G_MISS_NUM,
11: rating VARCHAR2(60) := FND_API.G_MISS_CHAR,
12: rated_as_of_date DATE := FND_API.G_MISS_DATE,
13: rating_organization VARCHAR2(240) := FND_API.G_MISS_CHAR,
14: wh_update_date DATE := FND_API.G_MISS_DATE,
15: comments VARCHAR2(240) := FND_API.G_MISS_CHAR,
16: det_history_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
17: fincl_embt_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
10: party_id NUMBER := FND_API.G_MISS_NUM,
11: rating VARCHAR2(60) := FND_API.G_MISS_CHAR,
12: rated_as_of_date DATE := FND_API.G_MISS_DATE,
13: rating_organization VARCHAR2(240) := FND_API.G_MISS_CHAR,
14: wh_update_date DATE := FND_API.G_MISS_DATE,
15: comments VARCHAR2(240) := FND_API.G_MISS_CHAR,
16: det_history_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
17: fincl_embt_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
18: criminal_proceeding_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
11: rating VARCHAR2(60) := FND_API.G_MISS_CHAR,
12: rated_as_of_date DATE := FND_API.G_MISS_DATE,
13: rating_organization VARCHAR2(240) := FND_API.G_MISS_CHAR,
14: wh_update_date DATE := FND_API.G_MISS_DATE,
15: comments VARCHAR2(240) := FND_API.G_MISS_CHAR,
16: det_history_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
17: fincl_embt_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
18: criminal_proceeding_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
19: suit_judge_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
12: rated_as_of_date DATE := FND_API.G_MISS_DATE,
13: rating_organization VARCHAR2(240) := FND_API.G_MISS_CHAR,
14: wh_update_date DATE := FND_API.G_MISS_DATE,
15: comments VARCHAR2(240) := FND_API.G_MISS_CHAR,
16: det_history_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
17: fincl_embt_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
18: criminal_proceeding_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
19: suit_judge_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
20: claims_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
13: rating_organization VARCHAR2(240) := FND_API.G_MISS_CHAR,
14: wh_update_date DATE := FND_API.G_MISS_DATE,
15: comments VARCHAR2(240) := FND_API.G_MISS_CHAR,
16: det_history_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
17: fincl_embt_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
18: criminal_proceeding_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
19: suit_judge_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
20: claims_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
21: secured_flng_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
14: wh_update_date DATE := FND_API.G_MISS_DATE,
15: comments VARCHAR2(240) := FND_API.G_MISS_CHAR,
16: det_history_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
17: fincl_embt_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
18: criminal_proceeding_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
19: suit_judge_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
20: claims_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
21: secured_flng_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
22: fincl_lgl_event_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
15: comments VARCHAR2(240) := FND_API.G_MISS_CHAR,
16: det_history_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
17: fincl_embt_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
18: criminal_proceeding_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
19: suit_judge_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
20: claims_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
21: secured_flng_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
22: fincl_lgl_event_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
23: disaster_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
16: det_history_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
17: fincl_embt_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
18: criminal_proceeding_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
19: suit_judge_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
20: claims_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
21: secured_flng_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
22: fincl_lgl_event_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
23: disaster_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
24: oprg_spec_evnt_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
17: fincl_embt_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
18: criminal_proceeding_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
19: suit_judge_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
20: claims_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
21: secured_flng_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
22: fincl_lgl_event_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
23: disaster_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
24: oprg_spec_evnt_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
25: other_spec_evnt_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
18: criminal_proceeding_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
19: suit_judge_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
20: claims_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
21: secured_flng_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
22: fincl_lgl_event_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
23: disaster_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
24: oprg_spec_evnt_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
25: other_spec_evnt_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
26: content_source_type VARCHAR2(30) := G_MISS_CONTENT_SOURCE_TYPE,
19: suit_judge_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
20: claims_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
21: secured_flng_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
22: fincl_lgl_event_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
23: disaster_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
24: oprg_spec_evnt_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
25: other_spec_evnt_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
26: content_source_type VARCHAR2(30) := G_MISS_CONTENT_SOURCE_TYPE,
27: status VARCHAR2(1) := FND_API.G_MISS_CHAR,
20: claims_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
21: secured_flng_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
22: fincl_lgl_event_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
23: disaster_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
24: oprg_spec_evnt_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
25: other_spec_evnt_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
26: content_source_type VARCHAR2(30) := G_MISS_CONTENT_SOURCE_TYPE,
27: status VARCHAR2(1) := FND_API.G_MISS_CHAR,
28: avg_high_credit NUMBER := FND_API.G_MISS_NUM,
21: secured_flng_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
22: fincl_lgl_event_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
23: disaster_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
24: oprg_spec_evnt_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
25: other_spec_evnt_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
26: content_source_type VARCHAR2(30) := G_MISS_CONTENT_SOURCE_TYPE,
27: status VARCHAR2(1) := FND_API.G_MISS_CHAR,
28: avg_high_credit NUMBER := FND_API.G_MISS_NUM,
29: credit_score VARCHAR2(30) := FND_API.G_MISS_CHAR,
23: disaster_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
24: oprg_spec_evnt_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
25: other_spec_evnt_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
26: content_source_type VARCHAR2(30) := G_MISS_CONTENT_SOURCE_TYPE,
27: status VARCHAR2(1) := FND_API.G_MISS_CHAR,
28: avg_high_credit NUMBER := FND_API.G_MISS_NUM,
29: credit_score VARCHAR2(30) := FND_API.G_MISS_CHAR,
30: credit_score_age NUMBER := FND_API.G_MISS_NUM,
31: credit_score_class NUMBER := FND_API.G_MISS_NUM,
24: oprg_spec_evnt_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
25: other_spec_evnt_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
26: content_source_type VARCHAR2(30) := G_MISS_CONTENT_SOURCE_TYPE,
27: status VARCHAR2(1) := FND_API.G_MISS_CHAR,
28: avg_high_credit NUMBER := FND_API.G_MISS_NUM,
29: credit_score VARCHAR2(30) := FND_API.G_MISS_CHAR,
30: credit_score_age NUMBER := FND_API.G_MISS_NUM,
31: credit_score_class NUMBER := FND_API.G_MISS_NUM,
32: credit_score_commentary VARCHAR2(30) := FND_API.G_MISS_CHAR,
25: other_spec_evnt_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
26: content_source_type VARCHAR2(30) := G_MISS_CONTENT_SOURCE_TYPE,
27: status VARCHAR2(1) := FND_API.G_MISS_CHAR,
28: avg_high_credit NUMBER := FND_API.G_MISS_NUM,
29: credit_score VARCHAR2(30) := FND_API.G_MISS_CHAR,
30: credit_score_age NUMBER := FND_API.G_MISS_NUM,
31: credit_score_class NUMBER := FND_API.G_MISS_NUM,
32: credit_score_commentary VARCHAR2(30) := FND_API.G_MISS_CHAR,
33: credit_score_commentary2 VARCHAR2(30) := FND_API.G_MISS_CHAR,
26: content_source_type VARCHAR2(30) := G_MISS_CONTENT_SOURCE_TYPE,
27: status VARCHAR2(1) := FND_API.G_MISS_CHAR,
28: avg_high_credit NUMBER := FND_API.G_MISS_NUM,
29: credit_score VARCHAR2(30) := FND_API.G_MISS_CHAR,
30: credit_score_age NUMBER := FND_API.G_MISS_NUM,
31: credit_score_class NUMBER := FND_API.G_MISS_NUM,
32: credit_score_commentary VARCHAR2(30) := FND_API.G_MISS_CHAR,
33: credit_score_commentary2 VARCHAR2(30) := FND_API.G_MISS_CHAR,
34: credit_score_commentary3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: status VARCHAR2(1) := FND_API.G_MISS_CHAR,
28: avg_high_credit NUMBER := FND_API.G_MISS_NUM,
29: credit_score VARCHAR2(30) := FND_API.G_MISS_CHAR,
30: credit_score_age NUMBER := FND_API.G_MISS_NUM,
31: credit_score_class NUMBER := FND_API.G_MISS_NUM,
32: credit_score_commentary VARCHAR2(30) := FND_API.G_MISS_CHAR,
33: credit_score_commentary2 VARCHAR2(30) := FND_API.G_MISS_CHAR,
34: credit_score_commentary3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
35: credit_score_commentary4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
28: avg_high_credit NUMBER := FND_API.G_MISS_NUM,
29: credit_score VARCHAR2(30) := FND_API.G_MISS_CHAR,
30: credit_score_age NUMBER := FND_API.G_MISS_NUM,
31: credit_score_class NUMBER := FND_API.G_MISS_NUM,
32: credit_score_commentary VARCHAR2(30) := FND_API.G_MISS_CHAR,
33: credit_score_commentary2 VARCHAR2(30) := FND_API.G_MISS_CHAR,
34: credit_score_commentary3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
35: credit_score_commentary4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
36: credit_score_commentary5 VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: credit_score VARCHAR2(30) := FND_API.G_MISS_CHAR,
30: credit_score_age NUMBER := FND_API.G_MISS_NUM,
31: credit_score_class NUMBER := FND_API.G_MISS_NUM,
32: credit_score_commentary VARCHAR2(30) := FND_API.G_MISS_CHAR,
33: credit_score_commentary2 VARCHAR2(30) := FND_API.G_MISS_CHAR,
34: credit_score_commentary3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
35: credit_score_commentary4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
36: credit_score_commentary5 VARCHAR2(30) := FND_API.G_MISS_CHAR,
37: credit_score_commentary6 VARCHAR2(30) := FND_API.G_MISS_CHAR,
30: credit_score_age NUMBER := FND_API.G_MISS_NUM,
31: credit_score_class NUMBER := FND_API.G_MISS_NUM,
32: credit_score_commentary VARCHAR2(30) := FND_API.G_MISS_CHAR,
33: credit_score_commentary2 VARCHAR2(30) := FND_API.G_MISS_CHAR,
34: credit_score_commentary3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
35: credit_score_commentary4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
36: credit_score_commentary5 VARCHAR2(30) := FND_API.G_MISS_CHAR,
37: credit_score_commentary6 VARCHAR2(30) := FND_API.G_MISS_CHAR,
38: credit_score_commentary7 VARCHAR2(30) := FND_API.G_MISS_CHAR,
31: credit_score_class NUMBER := FND_API.G_MISS_NUM,
32: credit_score_commentary VARCHAR2(30) := FND_API.G_MISS_CHAR,
33: credit_score_commentary2 VARCHAR2(30) := FND_API.G_MISS_CHAR,
34: credit_score_commentary3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
35: credit_score_commentary4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
36: credit_score_commentary5 VARCHAR2(30) := FND_API.G_MISS_CHAR,
37: credit_score_commentary6 VARCHAR2(30) := FND_API.G_MISS_CHAR,
38: credit_score_commentary7 VARCHAR2(30) := FND_API.G_MISS_CHAR,
39: credit_score_commentary8 VARCHAR2(30) := FND_API.G_MISS_CHAR,
32: credit_score_commentary VARCHAR2(30) := FND_API.G_MISS_CHAR,
33: credit_score_commentary2 VARCHAR2(30) := FND_API.G_MISS_CHAR,
34: credit_score_commentary3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
35: credit_score_commentary4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
36: credit_score_commentary5 VARCHAR2(30) := FND_API.G_MISS_CHAR,
37: credit_score_commentary6 VARCHAR2(30) := FND_API.G_MISS_CHAR,
38: credit_score_commentary7 VARCHAR2(30) := FND_API.G_MISS_CHAR,
39: credit_score_commentary8 VARCHAR2(30) := FND_API.G_MISS_CHAR,
40: credit_score_commentary9 VARCHAR2(30) := FND_API.G_MISS_CHAR,
33: credit_score_commentary2 VARCHAR2(30) := FND_API.G_MISS_CHAR,
34: credit_score_commentary3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
35: credit_score_commentary4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
36: credit_score_commentary5 VARCHAR2(30) := FND_API.G_MISS_CHAR,
37: credit_score_commentary6 VARCHAR2(30) := FND_API.G_MISS_CHAR,
38: credit_score_commentary7 VARCHAR2(30) := FND_API.G_MISS_CHAR,
39: credit_score_commentary8 VARCHAR2(30) := FND_API.G_MISS_CHAR,
40: credit_score_commentary9 VARCHAR2(30) := FND_API.G_MISS_CHAR,
41: credit_score_commentary10 VARCHAR2(30) := FND_API.G_MISS_CHAR,
34: credit_score_commentary3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
35: credit_score_commentary4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
36: credit_score_commentary5 VARCHAR2(30) := FND_API.G_MISS_CHAR,
37: credit_score_commentary6 VARCHAR2(30) := FND_API.G_MISS_CHAR,
38: credit_score_commentary7 VARCHAR2(30) := FND_API.G_MISS_CHAR,
39: credit_score_commentary8 VARCHAR2(30) := FND_API.G_MISS_CHAR,
40: credit_score_commentary9 VARCHAR2(30) := FND_API.G_MISS_CHAR,
41: credit_score_commentary10 VARCHAR2(30) := FND_API.G_MISS_CHAR,
42: credit_score_date DATE := FND_API.G_MISS_DATE,
35: credit_score_commentary4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
36: credit_score_commentary5 VARCHAR2(30) := FND_API.G_MISS_CHAR,
37: credit_score_commentary6 VARCHAR2(30) := FND_API.G_MISS_CHAR,
38: credit_score_commentary7 VARCHAR2(30) := FND_API.G_MISS_CHAR,
39: credit_score_commentary8 VARCHAR2(30) := FND_API.G_MISS_CHAR,
40: credit_score_commentary9 VARCHAR2(30) := FND_API.G_MISS_CHAR,
41: credit_score_commentary10 VARCHAR2(30) := FND_API.G_MISS_CHAR,
42: credit_score_date DATE := FND_API.G_MISS_DATE,
43: credit_score_incd_default NUMBER := FND_API.G_MISS_NUM,
36: credit_score_commentary5 VARCHAR2(30) := FND_API.G_MISS_CHAR,
37: credit_score_commentary6 VARCHAR2(30) := FND_API.G_MISS_CHAR,
38: credit_score_commentary7 VARCHAR2(30) := FND_API.G_MISS_CHAR,
39: credit_score_commentary8 VARCHAR2(30) := FND_API.G_MISS_CHAR,
40: credit_score_commentary9 VARCHAR2(30) := FND_API.G_MISS_CHAR,
41: credit_score_commentary10 VARCHAR2(30) := FND_API.G_MISS_CHAR,
42: credit_score_date DATE := FND_API.G_MISS_DATE,
43: credit_score_incd_default NUMBER := FND_API.G_MISS_NUM,
44: credit_score_natl_percentile NUMBER := FND_API.G_MISS_NUM,
37: credit_score_commentary6 VARCHAR2(30) := FND_API.G_MISS_CHAR,
38: credit_score_commentary7 VARCHAR2(30) := FND_API.G_MISS_CHAR,
39: credit_score_commentary8 VARCHAR2(30) := FND_API.G_MISS_CHAR,
40: credit_score_commentary9 VARCHAR2(30) := FND_API.G_MISS_CHAR,
41: credit_score_commentary10 VARCHAR2(30) := FND_API.G_MISS_CHAR,
42: credit_score_date DATE := FND_API.G_MISS_DATE,
43: credit_score_incd_default NUMBER := FND_API.G_MISS_NUM,
44: credit_score_natl_percentile NUMBER := FND_API.G_MISS_NUM,
45: failure_score VARCHAR2(30) := FND_API.G_MISS_CHAR,
38: credit_score_commentary7 VARCHAR2(30) := FND_API.G_MISS_CHAR,
39: credit_score_commentary8 VARCHAR2(30) := FND_API.G_MISS_CHAR,
40: credit_score_commentary9 VARCHAR2(30) := FND_API.G_MISS_CHAR,
41: credit_score_commentary10 VARCHAR2(30) := FND_API.G_MISS_CHAR,
42: credit_score_date DATE := FND_API.G_MISS_DATE,
43: credit_score_incd_default NUMBER := FND_API.G_MISS_NUM,
44: credit_score_natl_percentile NUMBER := FND_API.G_MISS_NUM,
45: failure_score VARCHAR2(30) := FND_API.G_MISS_CHAR,
46: failure_score_age NUMBER := FND_API.G_MISS_NUM,
39: credit_score_commentary8 VARCHAR2(30) := FND_API.G_MISS_CHAR,
40: credit_score_commentary9 VARCHAR2(30) := FND_API.G_MISS_CHAR,
41: credit_score_commentary10 VARCHAR2(30) := FND_API.G_MISS_CHAR,
42: credit_score_date DATE := FND_API.G_MISS_DATE,
43: credit_score_incd_default NUMBER := FND_API.G_MISS_NUM,
44: credit_score_natl_percentile NUMBER := FND_API.G_MISS_NUM,
45: failure_score VARCHAR2(30) := FND_API.G_MISS_CHAR,
46: failure_score_age NUMBER := FND_API.G_MISS_NUM,
47: failure_score_class NUMBER := FND_API.G_MISS_NUM,
40: credit_score_commentary9 VARCHAR2(30) := FND_API.G_MISS_CHAR,
41: credit_score_commentary10 VARCHAR2(30) := FND_API.G_MISS_CHAR,
42: credit_score_date DATE := FND_API.G_MISS_DATE,
43: credit_score_incd_default NUMBER := FND_API.G_MISS_NUM,
44: credit_score_natl_percentile NUMBER := FND_API.G_MISS_NUM,
45: failure_score VARCHAR2(30) := FND_API.G_MISS_CHAR,
46: failure_score_age NUMBER := FND_API.G_MISS_NUM,
47: failure_score_class NUMBER := FND_API.G_MISS_NUM,
48: failure_score_commentary VARCHAR2(30) := FND_API.G_MISS_CHAR,
41: credit_score_commentary10 VARCHAR2(30) := FND_API.G_MISS_CHAR,
42: credit_score_date DATE := FND_API.G_MISS_DATE,
43: credit_score_incd_default NUMBER := FND_API.G_MISS_NUM,
44: credit_score_natl_percentile NUMBER := FND_API.G_MISS_NUM,
45: failure_score VARCHAR2(30) := FND_API.G_MISS_CHAR,
46: failure_score_age NUMBER := FND_API.G_MISS_NUM,
47: failure_score_class NUMBER := FND_API.G_MISS_NUM,
48: failure_score_commentary VARCHAR2(30) := FND_API.G_MISS_CHAR,
49: failure_score_commentary2 VARCHAR2(30) := FND_API.G_MISS_CHAR,
42: credit_score_date DATE := FND_API.G_MISS_DATE,
43: credit_score_incd_default NUMBER := FND_API.G_MISS_NUM,
44: credit_score_natl_percentile NUMBER := FND_API.G_MISS_NUM,
45: failure_score VARCHAR2(30) := FND_API.G_MISS_CHAR,
46: failure_score_age NUMBER := FND_API.G_MISS_NUM,
47: failure_score_class NUMBER := FND_API.G_MISS_NUM,
48: failure_score_commentary VARCHAR2(30) := FND_API.G_MISS_CHAR,
49: failure_score_commentary2 VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: failure_score_commentary3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
43: credit_score_incd_default NUMBER := FND_API.G_MISS_NUM,
44: credit_score_natl_percentile NUMBER := FND_API.G_MISS_NUM,
45: failure_score VARCHAR2(30) := FND_API.G_MISS_CHAR,
46: failure_score_age NUMBER := FND_API.G_MISS_NUM,
47: failure_score_class NUMBER := FND_API.G_MISS_NUM,
48: failure_score_commentary VARCHAR2(30) := FND_API.G_MISS_CHAR,
49: failure_score_commentary2 VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: failure_score_commentary3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
51: failure_score_commentary4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
44: credit_score_natl_percentile NUMBER := FND_API.G_MISS_NUM,
45: failure_score VARCHAR2(30) := FND_API.G_MISS_CHAR,
46: failure_score_age NUMBER := FND_API.G_MISS_NUM,
47: failure_score_class NUMBER := FND_API.G_MISS_NUM,
48: failure_score_commentary VARCHAR2(30) := FND_API.G_MISS_CHAR,
49: failure_score_commentary2 VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: failure_score_commentary3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
51: failure_score_commentary4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
52: failure_score_commentary5 VARCHAR2(30) := FND_API.G_MISS_CHAR,
45: failure_score VARCHAR2(30) := FND_API.G_MISS_CHAR,
46: failure_score_age NUMBER := FND_API.G_MISS_NUM,
47: failure_score_class NUMBER := FND_API.G_MISS_NUM,
48: failure_score_commentary VARCHAR2(30) := FND_API.G_MISS_CHAR,
49: failure_score_commentary2 VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: failure_score_commentary3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
51: failure_score_commentary4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
52: failure_score_commentary5 VARCHAR2(30) := FND_API.G_MISS_CHAR,
53: failure_score_commentary6 VARCHAR2(30) := FND_API.G_MISS_CHAR,
46: failure_score_age NUMBER := FND_API.G_MISS_NUM,
47: failure_score_class NUMBER := FND_API.G_MISS_NUM,
48: failure_score_commentary VARCHAR2(30) := FND_API.G_MISS_CHAR,
49: failure_score_commentary2 VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: failure_score_commentary3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
51: failure_score_commentary4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
52: failure_score_commentary5 VARCHAR2(30) := FND_API.G_MISS_CHAR,
53: failure_score_commentary6 VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: failure_score_commentary7 VARCHAR2(30) := FND_API.G_MISS_CHAR,
47: failure_score_class NUMBER := FND_API.G_MISS_NUM,
48: failure_score_commentary VARCHAR2(30) := FND_API.G_MISS_CHAR,
49: failure_score_commentary2 VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: failure_score_commentary3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
51: failure_score_commentary4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
52: failure_score_commentary5 VARCHAR2(30) := FND_API.G_MISS_CHAR,
53: failure_score_commentary6 VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: failure_score_commentary7 VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: failure_score_commentary8 VARCHAR2(30) := FND_API.G_MISS_CHAR,
48: failure_score_commentary VARCHAR2(30) := FND_API.G_MISS_CHAR,
49: failure_score_commentary2 VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: failure_score_commentary3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
51: failure_score_commentary4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
52: failure_score_commentary5 VARCHAR2(30) := FND_API.G_MISS_CHAR,
53: failure_score_commentary6 VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: failure_score_commentary7 VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: failure_score_commentary8 VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: failure_score_commentary9 VARCHAR2(30) := FND_API.G_MISS_CHAR,
49: failure_score_commentary2 VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: failure_score_commentary3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
51: failure_score_commentary4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
52: failure_score_commentary5 VARCHAR2(30) := FND_API.G_MISS_CHAR,
53: failure_score_commentary6 VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: failure_score_commentary7 VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: failure_score_commentary8 VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: failure_score_commentary9 VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: failure_score_commentary10 VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: failure_score_commentary3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
51: failure_score_commentary4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
52: failure_score_commentary5 VARCHAR2(30) := FND_API.G_MISS_CHAR,
53: failure_score_commentary6 VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: failure_score_commentary7 VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: failure_score_commentary8 VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: failure_score_commentary9 VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: failure_score_commentary10 VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: failure_score_date DATE := FND_API.G_MISS_DATE,
51: failure_score_commentary4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
52: failure_score_commentary5 VARCHAR2(30) := FND_API.G_MISS_CHAR,
53: failure_score_commentary6 VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: failure_score_commentary7 VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: failure_score_commentary8 VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: failure_score_commentary9 VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: failure_score_commentary10 VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: failure_score_date DATE := FND_API.G_MISS_DATE,
59: failure_score_incd_default NUMBER := FND_API.G_MISS_NUM,
52: failure_score_commentary5 VARCHAR2(30) := FND_API.G_MISS_CHAR,
53: failure_score_commentary6 VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: failure_score_commentary7 VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: failure_score_commentary8 VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: failure_score_commentary9 VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: failure_score_commentary10 VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: failure_score_date DATE := FND_API.G_MISS_DATE,
59: failure_score_incd_default NUMBER := FND_API.G_MISS_NUM,
60: failure_score_natnl_percentile NUMBER := FND_API.G_MISS_NUM,
53: failure_score_commentary6 VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: failure_score_commentary7 VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: failure_score_commentary8 VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: failure_score_commentary9 VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: failure_score_commentary10 VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: failure_score_date DATE := FND_API.G_MISS_DATE,
59: failure_score_incd_default NUMBER := FND_API.G_MISS_NUM,
60: failure_score_natnl_percentile NUMBER := FND_API.G_MISS_NUM,
61: failure_score_override_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: failure_score_commentary7 VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: failure_score_commentary8 VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: failure_score_commentary9 VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: failure_score_commentary10 VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: failure_score_date DATE := FND_API.G_MISS_DATE,
59: failure_score_incd_default NUMBER := FND_API.G_MISS_NUM,
60: failure_score_natnl_percentile NUMBER := FND_API.G_MISS_NUM,
61: failure_score_override_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: global_failure_score VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: failure_score_commentary8 VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: failure_score_commentary9 VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: failure_score_commentary10 VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: failure_score_date DATE := FND_API.G_MISS_DATE,
59: failure_score_incd_default NUMBER := FND_API.G_MISS_NUM,
60: failure_score_natnl_percentile NUMBER := FND_API.G_MISS_NUM,
61: failure_score_override_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: global_failure_score VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: debarment_ind VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: failure_score_commentary9 VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: failure_score_commentary10 VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: failure_score_date DATE := FND_API.G_MISS_DATE,
59: failure_score_incd_default NUMBER := FND_API.G_MISS_NUM,
60: failure_score_natnl_percentile NUMBER := FND_API.G_MISS_NUM,
61: failure_score_override_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: global_failure_score VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: debarment_ind VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: debarments_count NUMBER := FND_API.G_MISS_NUM,
57: failure_score_commentary10 VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: failure_score_date DATE := FND_API.G_MISS_DATE,
59: failure_score_incd_default NUMBER := FND_API.G_MISS_NUM,
60: failure_score_natnl_percentile NUMBER := FND_API.G_MISS_NUM,
61: failure_score_override_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: global_failure_score VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: debarment_ind VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: debarments_count NUMBER := FND_API.G_MISS_NUM,
65: debarments_date DATE := FND_API.G_MISS_DATE,
58: failure_score_date DATE := FND_API.G_MISS_DATE,
59: failure_score_incd_default NUMBER := FND_API.G_MISS_NUM,
60: failure_score_natnl_percentile NUMBER := FND_API.G_MISS_NUM,
61: failure_score_override_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: global_failure_score VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: debarment_ind VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: debarments_count NUMBER := FND_API.G_MISS_NUM,
65: debarments_date DATE := FND_API.G_MISS_DATE,
66: high_credit NUMBER := FND_API.G_MISS_NUM,
59: failure_score_incd_default NUMBER := FND_API.G_MISS_NUM,
60: failure_score_natnl_percentile NUMBER := FND_API.G_MISS_NUM,
61: failure_score_override_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: global_failure_score VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: debarment_ind VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: debarments_count NUMBER := FND_API.G_MISS_NUM,
65: debarments_date DATE := FND_API.G_MISS_DATE,
66: high_credit NUMBER := FND_API.G_MISS_NUM,
67: maximum_credit_currency_code VARCHAR2(240) := FND_API.G_MISS_CHAR,
60: failure_score_natnl_percentile NUMBER := FND_API.G_MISS_NUM,
61: failure_score_override_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: global_failure_score VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: debarment_ind VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: debarments_count NUMBER := FND_API.G_MISS_NUM,
65: debarments_date DATE := FND_API.G_MISS_DATE,
66: high_credit NUMBER := FND_API.G_MISS_NUM,
67: maximum_credit_currency_code VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: maximum_credit_rcmd NUMBER := FND_API.G_MISS_NUM,
61: failure_score_override_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: global_failure_score VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: debarment_ind VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: debarments_count NUMBER := FND_API.G_MISS_NUM,
65: debarments_date DATE := FND_API.G_MISS_DATE,
66: high_credit NUMBER := FND_API.G_MISS_NUM,
67: maximum_credit_currency_code VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: maximum_credit_rcmd NUMBER := FND_API.G_MISS_NUM,
69: paydex_norm VARCHAR2(3) := FND_API.G_MISS_CHAR,
62: global_failure_score VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: debarment_ind VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: debarments_count NUMBER := FND_API.G_MISS_NUM,
65: debarments_date DATE := FND_API.G_MISS_DATE,
66: high_credit NUMBER := FND_API.G_MISS_NUM,
67: maximum_credit_currency_code VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: maximum_credit_rcmd NUMBER := FND_API.G_MISS_NUM,
69: paydex_norm VARCHAR2(3) := FND_API.G_MISS_CHAR,
70: paydex_score VARCHAR2(3) := FND_API.G_MISS_CHAR,
63: debarment_ind VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: debarments_count NUMBER := FND_API.G_MISS_NUM,
65: debarments_date DATE := FND_API.G_MISS_DATE,
66: high_credit NUMBER := FND_API.G_MISS_NUM,
67: maximum_credit_currency_code VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: maximum_credit_rcmd NUMBER := FND_API.G_MISS_NUM,
69: paydex_norm VARCHAR2(3) := FND_API.G_MISS_CHAR,
70: paydex_score VARCHAR2(3) := FND_API.G_MISS_CHAR,
71: paydex_three_months_ago VARCHAR2(3) := FND_API.G_MISS_CHAR,
64: debarments_count NUMBER := FND_API.G_MISS_NUM,
65: debarments_date DATE := FND_API.G_MISS_DATE,
66: high_credit NUMBER := FND_API.G_MISS_NUM,
67: maximum_credit_currency_code VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: maximum_credit_rcmd NUMBER := FND_API.G_MISS_NUM,
69: paydex_norm VARCHAR2(3) := FND_API.G_MISS_CHAR,
70: paydex_score VARCHAR2(3) := FND_API.G_MISS_CHAR,
71: paydex_three_months_ago VARCHAR2(3) := FND_API.G_MISS_CHAR,
72: credit_score_override_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: debarments_date DATE := FND_API.G_MISS_DATE,
66: high_credit NUMBER := FND_API.G_MISS_NUM,
67: maximum_credit_currency_code VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: maximum_credit_rcmd NUMBER := FND_API.G_MISS_NUM,
69: paydex_norm VARCHAR2(3) := FND_API.G_MISS_CHAR,
70: paydex_score VARCHAR2(3) := FND_API.G_MISS_CHAR,
71: paydex_three_months_ago VARCHAR2(3) := FND_API.G_MISS_CHAR,
72: credit_score_override_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: cr_scr_clas_expl VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: high_credit NUMBER := FND_API.G_MISS_NUM,
67: maximum_credit_currency_code VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: maximum_credit_rcmd NUMBER := FND_API.G_MISS_NUM,
69: paydex_norm VARCHAR2(3) := FND_API.G_MISS_CHAR,
70: paydex_score VARCHAR2(3) := FND_API.G_MISS_CHAR,
71: paydex_three_months_ago VARCHAR2(3) := FND_API.G_MISS_CHAR,
72: credit_score_override_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: cr_scr_clas_expl VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: low_rng_delq_scr NUMBER := FND_API.G_MISS_NUM,
67: maximum_credit_currency_code VARCHAR2(240) := FND_API.G_MISS_CHAR,
68: maximum_credit_rcmd NUMBER := FND_API.G_MISS_NUM,
69: paydex_norm VARCHAR2(3) := FND_API.G_MISS_CHAR,
70: paydex_score VARCHAR2(3) := FND_API.G_MISS_CHAR,
71: paydex_three_months_ago VARCHAR2(3) := FND_API.G_MISS_CHAR,
72: credit_score_override_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: cr_scr_clas_expl VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: low_rng_delq_scr NUMBER := FND_API.G_MISS_NUM,
75: high_rng_delq_scr NUMBER := FND_API.G_MISS_NUM,
68: maximum_credit_rcmd NUMBER := FND_API.G_MISS_NUM,
69: paydex_norm VARCHAR2(3) := FND_API.G_MISS_CHAR,
70: paydex_score VARCHAR2(3) := FND_API.G_MISS_CHAR,
71: paydex_three_months_ago VARCHAR2(3) := FND_API.G_MISS_CHAR,
72: credit_score_override_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: cr_scr_clas_expl VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: low_rng_delq_scr NUMBER := FND_API.G_MISS_NUM,
75: high_rng_delq_scr NUMBER := FND_API.G_MISS_NUM,
76: delq_pmt_rng_prcnt NUMBER := FND_API.G_MISS_NUM,
69: paydex_norm VARCHAR2(3) := FND_API.G_MISS_CHAR,
70: paydex_score VARCHAR2(3) := FND_API.G_MISS_CHAR,
71: paydex_three_months_ago VARCHAR2(3) := FND_API.G_MISS_CHAR,
72: credit_score_override_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: cr_scr_clas_expl VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: low_rng_delq_scr NUMBER := FND_API.G_MISS_NUM,
75: high_rng_delq_scr NUMBER := FND_API.G_MISS_NUM,
76: delq_pmt_rng_prcnt NUMBER := FND_API.G_MISS_NUM,
77: delq_pmt_pctg_for_all_firms NUMBER := FND_API.G_MISS_NUM,
70: paydex_score VARCHAR2(3) := FND_API.G_MISS_CHAR,
71: paydex_three_months_ago VARCHAR2(3) := FND_API.G_MISS_CHAR,
72: credit_score_override_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: cr_scr_clas_expl VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: low_rng_delq_scr NUMBER := FND_API.G_MISS_NUM,
75: high_rng_delq_scr NUMBER := FND_API.G_MISS_NUM,
76: delq_pmt_rng_prcnt NUMBER := FND_API.G_MISS_NUM,
77: delq_pmt_pctg_for_all_firms NUMBER := FND_API.G_MISS_NUM,
78: num_trade_experiences NUMBER := FND_API.G_MISS_NUM,
71: paydex_three_months_ago VARCHAR2(3) := FND_API.G_MISS_CHAR,
72: credit_score_override_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: cr_scr_clas_expl VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: low_rng_delq_scr NUMBER := FND_API.G_MISS_NUM,
75: high_rng_delq_scr NUMBER := FND_API.G_MISS_NUM,
76: delq_pmt_rng_prcnt NUMBER := FND_API.G_MISS_NUM,
77: delq_pmt_pctg_for_all_firms NUMBER := FND_API.G_MISS_NUM,
78: num_trade_experiences NUMBER := FND_API.G_MISS_NUM,
79: paydex_firm_days VARCHAR2(15) := FND_API.G_MISS_CHAR,
72: credit_score_override_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: cr_scr_clas_expl VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: low_rng_delq_scr NUMBER := FND_API.G_MISS_NUM,
75: high_rng_delq_scr NUMBER := FND_API.G_MISS_NUM,
76: delq_pmt_rng_prcnt NUMBER := FND_API.G_MISS_NUM,
77: delq_pmt_pctg_for_all_firms NUMBER := FND_API.G_MISS_NUM,
78: num_trade_experiences NUMBER := FND_API.G_MISS_NUM,
79: paydex_firm_days VARCHAR2(15) := FND_API.G_MISS_CHAR,
80: paydex_firm_comment VARCHAR2(60) := FND_API.G_MISS_CHAR,
73: cr_scr_clas_expl VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: low_rng_delq_scr NUMBER := FND_API.G_MISS_NUM,
75: high_rng_delq_scr NUMBER := FND_API.G_MISS_NUM,
76: delq_pmt_rng_prcnt NUMBER := FND_API.G_MISS_NUM,
77: delq_pmt_pctg_for_all_firms NUMBER := FND_API.G_MISS_NUM,
78: num_trade_experiences NUMBER := FND_API.G_MISS_NUM,
79: paydex_firm_days VARCHAR2(15) := FND_API.G_MISS_CHAR,
80: paydex_firm_comment VARCHAR2(60) := FND_API.G_MISS_CHAR,
81: paydex_industry_days VARCHAR2(15) := FND_API.G_MISS_CHAR,
74: low_rng_delq_scr NUMBER := FND_API.G_MISS_NUM,
75: high_rng_delq_scr NUMBER := FND_API.G_MISS_NUM,
76: delq_pmt_rng_prcnt NUMBER := FND_API.G_MISS_NUM,
77: delq_pmt_pctg_for_all_firms NUMBER := FND_API.G_MISS_NUM,
78: num_trade_experiences NUMBER := FND_API.G_MISS_NUM,
79: paydex_firm_days VARCHAR2(15) := FND_API.G_MISS_CHAR,
80: paydex_firm_comment VARCHAR2(60) := FND_API.G_MISS_CHAR,
81: paydex_industry_days VARCHAR2(15) := FND_API.G_MISS_CHAR,
82: paydex_industry_comment VARCHAR2(50) := FND_API.G_MISS_CHAR,
75: high_rng_delq_scr NUMBER := FND_API.G_MISS_NUM,
76: delq_pmt_rng_prcnt NUMBER := FND_API.G_MISS_NUM,
77: delq_pmt_pctg_for_all_firms NUMBER := FND_API.G_MISS_NUM,
78: num_trade_experiences NUMBER := FND_API.G_MISS_NUM,
79: paydex_firm_days VARCHAR2(15) := FND_API.G_MISS_CHAR,
80: paydex_firm_comment VARCHAR2(60) := FND_API.G_MISS_CHAR,
81: paydex_industry_days VARCHAR2(15) := FND_API.G_MISS_CHAR,
82: paydex_industry_comment VARCHAR2(50) := FND_API.G_MISS_CHAR,
83: paydex_comment VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: delq_pmt_rng_prcnt NUMBER := FND_API.G_MISS_NUM,
77: delq_pmt_pctg_for_all_firms NUMBER := FND_API.G_MISS_NUM,
78: num_trade_experiences NUMBER := FND_API.G_MISS_NUM,
79: paydex_firm_days VARCHAR2(15) := FND_API.G_MISS_CHAR,
80: paydex_firm_comment VARCHAR2(60) := FND_API.G_MISS_CHAR,
81: paydex_industry_days VARCHAR2(15) := FND_API.G_MISS_CHAR,
82: paydex_industry_comment VARCHAR2(50) := FND_API.G_MISS_CHAR,
83: paydex_comment VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: suit_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
77: delq_pmt_pctg_for_all_firms NUMBER := FND_API.G_MISS_NUM,
78: num_trade_experiences NUMBER := FND_API.G_MISS_NUM,
79: paydex_firm_days VARCHAR2(15) := FND_API.G_MISS_CHAR,
80: paydex_firm_comment VARCHAR2(60) := FND_API.G_MISS_CHAR,
81: paydex_industry_days VARCHAR2(15) := FND_API.G_MISS_CHAR,
82: paydex_industry_comment VARCHAR2(50) := FND_API.G_MISS_CHAR,
83: paydex_comment VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: suit_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
85: lien_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
78: num_trade_experiences NUMBER := FND_API.G_MISS_NUM,
79: paydex_firm_days VARCHAR2(15) := FND_API.G_MISS_CHAR,
80: paydex_firm_comment VARCHAR2(60) := FND_API.G_MISS_CHAR,
81: paydex_industry_days VARCHAR2(15) := FND_API.G_MISS_CHAR,
82: paydex_industry_comment VARCHAR2(50) := FND_API.G_MISS_CHAR,
83: paydex_comment VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: suit_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
85: lien_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
86: judgement_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
79: paydex_firm_days VARCHAR2(15) := FND_API.G_MISS_CHAR,
80: paydex_firm_comment VARCHAR2(60) := FND_API.G_MISS_CHAR,
81: paydex_industry_days VARCHAR2(15) := FND_API.G_MISS_CHAR,
82: paydex_industry_comment VARCHAR2(50) := FND_API.G_MISS_CHAR,
83: paydex_comment VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: suit_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
85: lien_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
86: judgement_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
87: bankruptcy_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
80: paydex_firm_comment VARCHAR2(60) := FND_API.G_MISS_CHAR,
81: paydex_industry_days VARCHAR2(15) := FND_API.G_MISS_CHAR,
82: paydex_industry_comment VARCHAR2(50) := FND_API.G_MISS_CHAR,
83: paydex_comment VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: suit_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
85: lien_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
86: judgement_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
87: bankruptcy_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
88: no_trade_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
81: paydex_industry_days VARCHAR2(15) := FND_API.G_MISS_CHAR,
82: paydex_industry_comment VARCHAR2(50) := FND_API.G_MISS_CHAR,
83: paydex_comment VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: suit_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
85: lien_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
86: judgement_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
87: bankruptcy_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
88: no_trade_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
89: prnt_hq_bkcy_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
82: paydex_industry_comment VARCHAR2(50) := FND_API.G_MISS_CHAR,
83: paydex_comment VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: suit_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
85: lien_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
86: judgement_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
87: bankruptcy_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
88: no_trade_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
89: prnt_hq_bkcy_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
90: num_prnt_bkcy_filing NUMBER := FND_API.G_MISS_NUM,
83: paydex_comment VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: suit_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
85: lien_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
86: judgement_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
87: bankruptcy_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
88: no_trade_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
89: prnt_hq_bkcy_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
90: num_prnt_bkcy_filing NUMBER := FND_API.G_MISS_NUM,
91: prnt_bkcy_filg_type VARCHAR2(20) := FND_API.G_MISS_CHAR,
84: suit_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
85: lien_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
86: judgement_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
87: bankruptcy_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
88: no_trade_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
89: prnt_hq_bkcy_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
90: num_prnt_bkcy_filing NUMBER := FND_API.G_MISS_NUM,
91: prnt_bkcy_filg_type VARCHAR2(20) := FND_API.G_MISS_CHAR,
92: prnt_bkcy_filg_chapter NUMBER := FND_API.G_MISS_NUM,
85: lien_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
86: judgement_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
87: bankruptcy_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
88: no_trade_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
89: prnt_hq_bkcy_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
90: num_prnt_bkcy_filing NUMBER := FND_API.G_MISS_NUM,
91: prnt_bkcy_filg_type VARCHAR2(20) := FND_API.G_MISS_CHAR,
92: prnt_bkcy_filg_chapter NUMBER := FND_API.G_MISS_NUM,
93: prnt_bkcy_filg_date DATE := FND_API.G_MISS_DATE,
86: judgement_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
87: bankruptcy_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
88: no_trade_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
89: prnt_hq_bkcy_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
90: num_prnt_bkcy_filing NUMBER := FND_API.G_MISS_NUM,
91: prnt_bkcy_filg_type VARCHAR2(20) := FND_API.G_MISS_CHAR,
92: prnt_bkcy_filg_chapter NUMBER := FND_API.G_MISS_NUM,
93: prnt_bkcy_filg_date DATE := FND_API.G_MISS_DATE,
94: num_prnt_bkcy_convs NUMBER := FND_API.G_MISS_NUM,
87: bankruptcy_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
88: no_trade_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
89: prnt_hq_bkcy_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
90: num_prnt_bkcy_filing NUMBER := FND_API.G_MISS_NUM,
91: prnt_bkcy_filg_type VARCHAR2(20) := FND_API.G_MISS_CHAR,
92: prnt_bkcy_filg_chapter NUMBER := FND_API.G_MISS_NUM,
93: prnt_bkcy_filg_date DATE := FND_API.G_MISS_DATE,
94: num_prnt_bkcy_convs NUMBER := FND_API.G_MISS_NUM,
95: prnt_bkcy_conv_date DATE := FND_API.G_MISS_DATE,
88: no_trade_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
89: prnt_hq_bkcy_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
90: num_prnt_bkcy_filing NUMBER := FND_API.G_MISS_NUM,
91: prnt_bkcy_filg_type VARCHAR2(20) := FND_API.G_MISS_CHAR,
92: prnt_bkcy_filg_chapter NUMBER := FND_API.G_MISS_NUM,
93: prnt_bkcy_filg_date DATE := FND_API.G_MISS_DATE,
94: num_prnt_bkcy_convs NUMBER := FND_API.G_MISS_NUM,
95: prnt_bkcy_conv_date DATE := FND_API.G_MISS_DATE,
96: prnt_bkcy_chapter_conv VARCHAR2(60) := FND_API.G_MISS_CHAR,
89: prnt_hq_bkcy_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
90: num_prnt_bkcy_filing NUMBER := FND_API.G_MISS_NUM,
91: prnt_bkcy_filg_type VARCHAR2(20) := FND_API.G_MISS_CHAR,
92: prnt_bkcy_filg_chapter NUMBER := FND_API.G_MISS_NUM,
93: prnt_bkcy_filg_date DATE := FND_API.G_MISS_DATE,
94: num_prnt_bkcy_convs NUMBER := FND_API.G_MISS_NUM,
95: prnt_bkcy_conv_date DATE := FND_API.G_MISS_DATE,
96: prnt_bkcy_chapter_conv VARCHAR2(60) := FND_API.G_MISS_CHAR,
97: slow_trade_expl VARCHAR2(100) := FND_API.G_MISS_CHAR,
90: num_prnt_bkcy_filing NUMBER := FND_API.G_MISS_NUM,
91: prnt_bkcy_filg_type VARCHAR2(20) := FND_API.G_MISS_CHAR,
92: prnt_bkcy_filg_chapter NUMBER := FND_API.G_MISS_NUM,
93: prnt_bkcy_filg_date DATE := FND_API.G_MISS_DATE,
94: num_prnt_bkcy_convs NUMBER := FND_API.G_MISS_NUM,
95: prnt_bkcy_conv_date DATE := FND_API.G_MISS_DATE,
96: prnt_bkcy_chapter_conv VARCHAR2(60) := FND_API.G_MISS_CHAR,
97: slow_trade_expl VARCHAR2(100) := FND_API.G_MISS_CHAR,
98: negv_pmt_expl VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: prnt_bkcy_filg_type VARCHAR2(20) := FND_API.G_MISS_CHAR,
92: prnt_bkcy_filg_chapter NUMBER := FND_API.G_MISS_NUM,
93: prnt_bkcy_filg_date DATE := FND_API.G_MISS_DATE,
94: num_prnt_bkcy_convs NUMBER := FND_API.G_MISS_NUM,
95: prnt_bkcy_conv_date DATE := FND_API.G_MISS_DATE,
96: prnt_bkcy_chapter_conv VARCHAR2(60) := FND_API.G_MISS_CHAR,
97: slow_trade_expl VARCHAR2(100) := FND_API.G_MISS_CHAR,
98: negv_pmt_expl VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: pub_rec_expl VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: prnt_bkcy_filg_chapter NUMBER := FND_API.G_MISS_NUM,
93: prnt_bkcy_filg_date DATE := FND_API.G_MISS_DATE,
94: num_prnt_bkcy_convs NUMBER := FND_API.G_MISS_NUM,
95: prnt_bkcy_conv_date DATE := FND_API.G_MISS_DATE,
96: prnt_bkcy_chapter_conv VARCHAR2(60) := FND_API.G_MISS_CHAR,
97: slow_trade_expl VARCHAR2(100) := FND_API.G_MISS_CHAR,
98: negv_pmt_expl VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: pub_rec_expl VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: business_discontinued VARCHAR2(240) := FND_API.G_MISS_CHAR,
93: prnt_bkcy_filg_date DATE := FND_API.G_MISS_DATE,
94: num_prnt_bkcy_convs NUMBER := FND_API.G_MISS_NUM,
95: prnt_bkcy_conv_date DATE := FND_API.G_MISS_DATE,
96: prnt_bkcy_chapter_conv VARCHAR2(60) := FND_API.G_MISS_CHAR,
97: slow_trade_expl VARCHAR2(100) := FND_API.G_MISS_CHAR,
98: negv_pmt_expl VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: pub_rec_expl VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: business_discontinued VARCHAR2(240) := FND_API.G_MISS_CHAR,
101: spcl_event_comment VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: num_prnt_bkcy_convs NUMBER := FND_API.G_MISS_NUM,
95: prnt_bkcy_conv_date DATE := FND_API.G_MISS_DATE,
96: prnt_bkcy_chapter_conv VARCHAR2(60) := FND_API.G_MISS_CHAR,
97: slow_trade_expl VARCHAR2(100) := FND_API.G_MISS_CHAR,
98: negv_pmt_expl VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: pub_rec_expl VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: business_discontinued VARCHAR2(240) := FND_API.G_MISS_CHAR,
101: spcl_event_comment VARCHAR2(150) := FND_API.G_MISS_CHAR,
102: num_spcl_event NUMBER := FND_API.G_MISS_NUM,
95: prnt_bkcy_conv_date DATE := FND_API.G_MISS_DATE,
96: prnt_bkcy_chapter_conv VARCHAR2(60) := FND_API.G_MISS_CHAR,
97: slow_trade_expl VARCHAR2(100) := FND_API.G_MISS_CHAR,
98: negv_pmt_expl VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: pub_rec_expl VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: business_discontinued VARCHAR2(240) := FND_API.G_MISS_CHAR,
101: spcl_event_comment VARCHAR2(150) := FND_API.G_MISS_CHAR,
102: num_spcl_event NUMBER := FND_API.G_MISS_NUM,
103: spcl_event_update_date DATE := FND_API.G_MISS_DATE,
96: prnt_bkcy_chapter_conv VARCHAR2(60) := FND_API.G_MISS_CHAR,
97: slow_trade_expl VARCHAR2(100) := FND_API.G_MISS_CHAR,
98: negv_pmt_expl VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: pub_rec_expl VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: business_discontinued VARCHAR2(240) := FND_API.G_MISS_CHAR,
101: spcl_event_comment VARCHAR2(150) := FND_API.G_MISS_CHAR,
102: num_spcl_event NUMBER := FND_API.G_MISS_NUM,
103: spcl_event_update_date DATE := FND_API.G_MISS_DATE,
104: spcl_evnt_txt VARCHAR2(2000) := FND_API.G_MISS_CHAR,
97: slow_trade_expl VARCHAR2(100) := FND_API.G_MISS_CHAR,
98: negv_pmt_expl VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: pub_rec_expl VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: business_discontinued VARCHAR2(240) := FND_API.G_MISS_CHAR,
101: spcl_event_comment VARCHAR2(150) := FND_API.G_MISS_CHAR,
102: num_spcl_event NUMBER := FND_API.G_MISS_NUM,
103: spcl_event_update_date DATE := FND_API.G_MISS_DATE,
104: spcl_evnt_txt VARCHAR2(2000) := FND_API.G_MISS_CHAR,
105: actual_content_source VARCHAR2(30) := FND_API.G_MISS_CHAR
98: negv_pmt_expl VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: pub_rec_expl VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: business_discontinued VARCHAR2(240) := FND_API.G_MISS_CHAR,
101: spcl_event_comment VARCHAR2(150) := FND_API.G_MISS_CHAR,
102: num_spcl_event NUMBER := FND_API.G_MISS_NUM,
103: spcl_event_update_date DATE := FND_API.G_MISS_DATE,
104: spcl_evnt_txt VARCHAR2(2000) := FND_API.G_MISS_CHAR,
105: actual_content_source VARCHAR2(30) := FND_API.G_MISS_CHAR
106: );
99: pub_rec_expl VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: business_discontinued VARCHAR2(240) := FND_API.G_MISS_CHAR,
101: spcl_event_comment VARCHAR2(150) := FND_API.G_MISS_CHAR,
102: num_spcl_event NUMBER := FND_API.G_MISS_NUM,
103: spcl_event_update_date DATE := FND_API.G_MISS_DATE,
104: spcl_evnt_txt VARCHAR2(2000) := FND_API.G_MISS_CHAR,
105: actual_content_source VARCHAR2(30) := FND_API.G_MISS_CHAR
106: );
107:
100: business_discontinued VARCHAR2(240) := FND_API.G_MISS_CHAR,
101: spcl_event_comment VARCHAR2(150) := FND_API.G_MISS_CHAR,
102: num_spcl_event NUMBER := FND_API.G_MISS_NUM,
103: spcl_event_update_date DATE := FND_API.G_MISS_DATE,
104: spcl_evnt_txt VARCHAR2(2000) := FND_API.G_MISS_CHAR,
105: actual_content_source VARCHAR2(30) := FND_API.G_MISS_CHAR
106: );
107:
108:
101: spcl_event_comment VARCHAR2(150) := FND_API.G_MISS_CHAR,
102: num_spcl_event NUMBER := FND_API.G_MISS_NUM,
103: spcl_event_update_date DATE := FND_API.G_MISS_DATE,
104: spcl_evnt_txt VARCHAR2(2000) := FND_API.G_MISS_CHAR,
105: actual_content_source VARCHAR2(30) := FND_API.G_MISS_CHAR
106: );
107:
108:
109: TYPE financial_profile_rec_type IS RECORD(
106: );
107:
108:
109: TYPE financial_profile_rec_type IS RECORD(
110: financial_profile_id NUMBER := FND_API.G_MISS_NUM,
111: access_authority_date DATE := FND_API.G_MISS_DATE,
112: access_authority_granted VARCHAR2(1) := FND_API.G_MISS_CHAR,
113: balance_amount NUMBER := FND_API.G_MISS_NUM,
114: balance_verified_on_date DATE := FND_API.G_MISS_DATE,
107:
108:
109: TYPE financial_profile_rec_type IS RECORD(
110: financial_profile_id NUMBER := FND_API.G_MISS_NUM,
111: access_authority_date DATE := FND_API.G_MISS_DATE,
112: access_authority_granted VARCHAR2(1) := FND_API.G_MISS_CHAR,
113: balance_amount NUMBER := FND_API.G_MISS_NUM,
114: balance_verified_on_date DATE := FND_API.G_MISS_DATE,
115: financial_account_number VARCHAR2(60) := FND_API.G_MISS_CHAR,
108:
109: TYPE financial_profile_rec_type IS RECORD(
110: financial_profile_id NUMBER := FND_API.G_MISS_NUM,
111: access_authority_date DATE := FND_API.G_MISS_DATE,
112: access_authority_granted VARCHAR2(1) := FND_API.G_MISS_CHAR,
113: balance_amount NUMBER := FND_API.G_MISS_NUM,
114: balance_verified_on_date DATE := FND_API.G_MISS_DATE,
115: financial_account_number VARCHAR2(60) := FND_API.G_MISS_CHAR,
116: financial_account_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: TYPE financial_profile_rec_type IS RECORD(
110: financial_profile_id NUMBER := FND_API.G_MISS_NUM,
111: access_authority_date DATE := FND_API.G_MISS_DATE,
112: access_authority_granted VARCHAR2(1) := FND_API.G_MISS_CHAR,
113: balance_amount NUMBER := FND_API.G_MISS_NUM,
114: balance_verified_on_date DATE := FND_API.G_MISS_DATE,
115: financial_account_number VARCHAR2(60) := FND_API.G_MISS_CHAR,
116: financial_account_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
117: financial_org_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
110: financial_profile_id NUMBER := FND_API.G_MISS_NUM,
111: access_authority_date DATE := FND_API.G_MISS_DATE,
112: access_authority_granted VARCHAR2(1) := FND_API.G_MISS_CHAR,
113: balance_amount NUMBER := FND_API.G_MISS_NUM,
114: balance_verified_on_date DATE := FND_API.G_MISS_DATE,
115: financial_account_number VARCHAR2(60) := FND_API.G_MISS_CHAR,
116: financial_account_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
117: financial_org_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: financial_organization_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
111: access_authority_date DATE := FND_API.G_MISS_DATE,
112: access_authority_granted VARCHAR2(1) := FND_API.G_MISS_CHAR,
113: balance_amount NUMBER := FND_API.G_MISS_NUM,
114: balance_verified_on_date DATE := FND_API.G_MISS_DATE,
115: financial_account_number VARCHAR2(60) := FND_API.G_MISS_CHAR,
116: financial_account_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
117: financial_org_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: financial_organization_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
119: party_id NUMBER := FND_API.G_MISS_NUM,
112: access_authority_granted VARCHAR2(1) := FND_API.G_MISS_CHAR,
113: balance_amount NUMBER := FND_API.G_MISS_NUM,
114: balance_verified_on_date DATE := FND_API.G_MISS_DATE,
115: financial_account_number VARCHAR2(60) := FND_API.G_MISS_CHAR,
116: financial_account_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
117: financial_org_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: financial_organization_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
119: party_id NUMBER := FND_API.G_MISS_NUM,
120: wh_update_date DATE := FND_API.G_MISS_DATE,
113: balance_amount NUMBER := FND_API.G_MISS_NUM,
114: balance_verified_on_date DATE := FND_API.G_MISS_DATE,
115: financial_account_number VARCHAR2(60) := FND_API.G_MISS_CHAR,
116: financial_account_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
117: financial_org_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: financial_organization_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
119: party_id NUMBER := FND_API.G_MISS_NUM,
120: wh_update_date DATE := FND_API.G_MISS_DATE,
121: status varchar2(1) := FND_API.G_MISS_CHAR);
114: balance_verified_on_date DATE := FND_API.G_MISS_DATE,
115: financial_account_number VARCHAR2(60) := FND_API.G_MISS_CHAR,
116: financial_account_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
117: financial_org_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: financial_organization_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
119: party_id NUMBER := FND_API.G_MISS_NUM,
120: wh_update_date DATE := FND_API.G_MISS_DATE,
121: status varchar2(1) := FND_API.G_MISS_CHAR);
122:
115: financial_account_number VARCHAR2(60) := FND_API.G_MISS_CHAR,
116: financial_account_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
117: financial_org_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: financial_organization_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
119: party_id NUMBER := FND_API.G_MISS_NUM,
120: wh_update_date DATE := FND_API.G_MISS_DATE,
121: status varchar2(1) := FND_API.G_MISS_CHAR);
122:
123: ----------------------------------------------------------------------------
116: financial_account_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
117: financial_org_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: financial_organization_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
119: party_id NUMBER := FND_API.G_MISS_NUM,
120: wh_update_date DATE := FND_API.G_MISS_DATE,
121: status varchar2(1) := FND_API.G_MISS_CHAR);
122:
123: ----------------------------------------------------------------------------
124: /* Obsolete V1 API
117: financial_org_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: financial_organization_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
119: party_id NUMBER := FND_API.G_MISS_NUM,
120: wh_update_date DATE := FND_API.G_MISS_DATE,
121: status varchar2(1) := FND_API.G_MISS_CHAR);
122:
123: ----------------------------------------------------------------------------
124: /* Obsolete V1 API
125: procedure create_credit_ratings(
123: ----------------------------------------------------------------------------
124: /* Obsolete V1 API
125: procedure create_credit_ratings(
126: p_api_version IN NUMBER,
127: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
128: p_commit IN VARCHAR2:= FND_API.G_FALSE,
129: p_credit_ratings_rec IN CREDIT_RATINGS_REC_TYPE,
130: x_return_status OUT NOCOPY VARCHAR2,
131: x_msg_count OUT NOCOPY NUMBER,
124: /* Obsolete V1 API
125: procedure create_credit_ratings(
126: p_api_version IN NUMBER,
127: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
128: p_commit IN VARCHAR2:= FND_API.G_FALSE,
129: p_credit_ratings_rec IN CREDIT_RATINGS_REC_TYPE,
130: x_return_status OUT NOCOPY VARCHAR2,
131: x_msg_count OUT NOCOPY NUMBER,
132: x_msg_data OUT NOCOPY VARCHAR2,
130: x_return_status OUT NOCOPY VARCHAR2,
131: x_msg_count OUT NOCOPY NUMBER,
132: x_msg_data OUT NOCOPY VARCHAR2,
133: x_credit_rating_id OUT NOCOPY NUMBER,
134: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
135: );
136:
137:
138: procedure update_credit_ratings(
136:
137:
138: procedure update_credit_ratings(
139: p_api_version IN NUMBER,
140: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
141: p_commit IN VARCHAR2:= FND_API.G_FALSE,
142: p_credit_ratings_rec IN CREDIT_RATINGS_REC_TYPE,
143: p_last_update_date IN OUT NOCOPY DATE,
144: x_return_status OUT NOCOPY VARCHAR2,
137:
138: procedure update_credit_ratings(
139: p_api_version IN NUMBER,
140: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
141: p_commit IN VARCHAR2:= FND_API.G_FALSE,
142: p_credit_ratings_rec IN CREDIT_RATINGS_REC_TYPE,
143: p_last_update_date IN OUT NOCOPY DATE,
144: x_return_status OUT NOCOPY VARCHAR2,
145: x_msg_count OUT NOCOPY NUMBER,
143: p_last_update_date IN OUT NOCOPY DATE,
144: x_return_status OUT NOCOPY VARCHAR2,
145: x_msg_count OUT NOCOPY NUMBER,
146: x_msg_data OUT NOCOPY VARCHAR2,
147: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
148: );
149:
150: */
151: procedure create_financial_profile(
149:
150: */
151: procedure create_financial_profile(
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
154: p_commit IN VARCHAR2:= FND_API.G_FALSE,
155: p_financial_profile_rec IN FINANCIAL_PROFILE_REC_TYPE,
156: x_return_status OUT NOCOPY VARCHAR2,
157: x_msg_count OUT NOCOPY NUMBER,
150: */
151: procedure create_financial_profile(
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
154: p_commit IN VARCHAR2:= FND_API.G_FALSE,
155: p_financial_profile_rec IN FINANCIAL_PROFILE_REC_TYPE,
156: x_return_status OUT NOCOPY VARCHAR2,
157: x_msg_count OUT NOCOPY NUMBER,
158: x_msg_data OUT NOCOPY VARCHAR2,
156: x_return_status OUT NOCOPY VARCHAR2,
157: x_msg_count OUT NOCOPY NUMBER,
158: x_msg_data OUT NOCOPY VARCHAR2,
159: x_financial_profile_id OUT NOCOPY NUMBER,
160: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
161: );
162:
163:
164: procedure update_financial_profile(
162:
163:
164: procedure update_financial_profile(
165: p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
167: p_commit IN VARCHAR2:= FND_API.G_FALSE,
168: p_financial_profile_rec IN FINANCIAL_PROFILE_REC_TYPE,
169: p_last_update_date IN OUT NOCOPY DATE,
170: x_return_status OUT NOCOPY VARCHAR2,
163:
164: procedure update_financial_profile(
165: p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
167: p_commit IN VARCHAR2:= FND_API.G_FALSE,
168: p_financial_profile_rec IN FINANCIAL_PROFILE_REC_TYPE,
169: p_last_update_date IN OUT NOCOPY DATE,
170: x_return_status OUT NOCOPY VARCHAR2,
171: x_msg_count OUT NOCOPY NUMBER,
169: p_last_update_date IN OUT NOCOPY DATE,
170: x_return_status OUT NOCOPY VARCHAR2,
171: x_msg_count OUT NOCOPY NUMBER,
172: x_msg_data OUT NOCOPY VARCHAR2,
173: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
174: );
175:
176:
177: procedure get_current_credit_rating(
175:
176:
177: procedure get_current_credit_rating(
178: p_api_version IN NUMBER,
179: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
180: p_credit_rating_id IN NUMBER,
181: x_credit_ratings_rec OUT NOCOPY CREDIT_RATINGS_REC_TYPE,
182: x_return_status IN OUT NOCOPY VARCHAR2,
183: x_msg_count OUT NOCOPY NUMBER,