APPS.CN_GET_TX_DATA_PUB dependencies on FND_API

Line 19: commission_header_id number := fnd_api.g_miss_num,

15: --+ 08/08/2005 Hithanki R12 Version
16: --
17:
18: TYPE adj_rec_type IS RECORD(
19: commission_header_id number := fnd_api.g_miss_num,
20: direct_salesrep_number varchar2(30) := fnd_api.g_miss_char,
21: direct_salesrep_name varchar2(360) := fnd_api.g_miss_char,
22: direct_salesrep_id number := fnd_api.g_miss_num,
23: processed_period_id number := fnd_api.g_miss_num,

Line 20: direct_salesrep_number varchar2(30) := fnd_api.g_miss_char,

16: --
17:
18: TYPE adj_rec_type IS RECORD(
19: commission_header_id number := fnd_api.g_miss_num,
20: direct_salesrep_number varchar2(30) := fnd_api.g_miss_char,
21: direct_salesrep_name varchar2(360) := fnd_api.g_miss_char,
22: direct_salesrep_id number := fnd_api.g_miss_num,
23: processed_period_id number := fnd_api.g_miss_num,
24: processed_period varchar2(30) := fnd_api.g_miss_char,

Line 21: direct_salesrep_name varchar2(360) := fnd_api.g_miss_char,

17:
18: TYPE adj_rec_type IS RECORD(
19: commission_header_id number := fnd_api.g_miss_num,
20: direct_salesrep_number varchar2(30) := fnd_api.g_miss_char,
21: direct_salesrep_name varchar2(360) := fnd_api.g_miss_char,
22: direct_salesrep_id number := fnd_api.g_miss_num,
23: processed_period_id number := fnd_api.g_miss_num,
24: processed_period varchar2(30) := fnd_api.g_miss_char,
25: processed_date date := fnd_api.g_miss_date,

Line 22: direct_salesrep_id number := fnd_api.g_miss_num,

18: TYPE adj_rec_type IS RECORD(
19: commission_header_id number := fnd_api.g_miss_num,
20: direct_salesrep_number varchar2(30) := fnd_api.g_miss_char,
21: direct_salesrep_name varchar2(360) := fnd_api.g_miss_char,
22: direct_salesrep_id number := fnd_api.g_miss_num,
23: processed_period_id number := fnd_api.g_miss_num,
24: processed_period varchar2(30) := fnd_api.g_miss_char,
25: processed_date date := fnd_api.g_miss_date,
26: rollup_date date := fnd_api.g_miss_date,

Line 23: processed_period_id number := fnd_api.g_miss_num,

19: commission_header_id number := fnd_api.g_miss_num,
20: direct_salesrep_number varchar2(30) := fnd_api.g_miss_char,
21: direct_salesrep_name varchar2(360) := fnd_api.g_miss_char,
22: direct_salesrep_id number := fnd_api.g_miss_num,
23: processed_period_id number := fnd_api.g_miss_num,
24: processed_period varchar2(30) := fnd_api.g_miss_char,
25: processed_date date := fnd_api.g_miss_date,
26: rollup_date date := fnd_api.g_miss_date,
27: transaction_amount number := fnd_api.g_miss_num,

Line 24: processed_period varchar2(30) := fnd_api.g_miss_char,

20: direct_salesrep_number varchar2(30) := fnd_api.g_miss_char,
21: direct_salesrep_name varchar2(360) := fnd_api.g_miss_char,
22: direct_salesrep_id number := fnd_api.g_miss_num,
23: processed_period_id number := fnd_api.g_miss_num,
24: processed_period varchar2(30) := fnd_api.g_miss_char,
25: processed_date date := fnd_api.g_miss_date,
26: rollup_date date := fnd_api.g_miss_date,
27: transaction_amount number := fnd_api.g_miss_num,
28: transaction_amount_orig number := fnd_api.g_miss_num,

Line 25: processed_date date := fnd_api.g_miss_date,

21: direct_salesrep_name varchar2(360) := fnd_api.g_miss_char,
22: direct_salesrep_id number := fnd_api.g_miss_num,
23: processed_period_id number := fnd_api.g_miss_num,
24: processed_period varchar2(30) := fnd_api.g_miss_char,
25: processed_date date := fnd_api.g_miss_date,
26: rollup_date date := fnd_api.g_miss_date,
27: transaction_amount number := fnd_api.g_miss_num,
28: transaction_amount_orig number := fnd_api.g_miss_num,
29: quantity number := fnd_api.g_miss_num,

Line 26: rollup_date date := fnd_api.g_miss_date,

22: direct_salesrep_id number := fnd_api.g_miss_num,
23: processed_period_id number := fnd_api.g_miss_num,
24: processed_period varchar2(30) := fnd_api.g_miss_char,
25: processed_date date := fnd_api.g_miss_date,
26: rollup_date date := fnd_api.g_miss_date,
27: transaction_amount number := fnd_api.g_miss_num,
28: transaction_amount_orig number := fnd_api.g_miss_num,
29: quantity number := fnd_api.g_miss_num,
30: discount_percentage number := fnd_api.g_miss_num,

Line 27: transaction_amount number := fnd_api.g_miss_num,

23: processed_period_id number := fnd_api.g_miss_num,
24: processed_period varchar2(30) := fnd_api.g_miss_char,
25: processed_date date := fnd_api.g_miss_date,
26: rollup_date date := fnd_api.g_miss_date,
27: transaction_amount number := fnd_api.g_miss_num,
28: transaction_amount_orig number := fnd_api.g_miss_num,
29: quantity number := fnd_api.g_miss_num,
30: discount_percentage number := fnd_api.g_miss_num,
31: margin_percentage number := fnd_api.g_miss_num,

Line 28: transaction_amount_orig number := fnd_api.g_miss_num,

24: processed_period varchar2(30) := fnd_api.g_miss_char,
25: processed_date date := fnd_api.g_miss_date,
26: rollup_date date := fnd_api.g_miss_date,
27: transaction_amount number := fnd_api.g_miss_num,
28: transaction_amount_orig number := fnd_api.g_miss_num,
29: quantity number := fnd_api.g_miss_num,
30: discount_percentage number := fnd_api.g_miss_num,
31: margin_percentage number := fnd_api.g_miss_num,
32: orig_currency_code varchar2(15) := fnd_api.g_miss_char,

Line 29: quantity number := fnd_api.g_miss_num,

25: processed_date date := fnd_api.g_miss_date,
26: rollup_date date := fnd_api.g_miss_date,
27: transaction_amount number := fnd_api.g_miss_num,
28: transaction_amount_orig number := fnd_api.g_miss_num,
29: quantity number := fnd_api.g_miss_num,
30: discount_percentage number := fnd_api.g_miss_num,
31: margin_percentage number := fnd_api.g_miss_num,
32: orig_currency_code varchar2(15) := fnd_api.g_miss_char,
33: exchange_rate number := fnd_api.g_miss_num,

Line 30: discount_percentage number := fnd_api.g_miss_num,

26: rollup_date date := fnd_api.g_miss_date,
27: transaction_amount number := fnd_api.g_miss_num,
28: transaction_amount_orig number := fnd_api.g_miss_num,
29: quantity number := fnd_api.g_miss_num,
30: discount_percentage number := fnd_api.g_miss_num,
31: margin_percentage number := fnd_api.g_miss_num,
32: orig_currency_code varchar2(15) := fnd_api.g_miss_char,
33: exchange_rate number := fnd_api.g_miss_num,
34: status_disp varchar2(80) := fnd_api.g_miss_char,

Line 31: margin_percentage number := fnd_api.g_miss_num,

27: transaction_amount number := fnd_api.g_miss_num,
28: transaction_amount_orig number := fnd_api.g_miss_num,
29: quantity number := fnd_api.g_miss_num,
30: discount_percentage number := fnd_api.g_miss_num,
31: margin_percentage number := fnd_api.g_miss_num,
32: orig_currency_code varchar2(15) := fnd_api.g_miss_char,
33: exchange_rate number := fnd_api.g_miss_num,
34: status_disp varchar2(80) := fnd_api.g_miss_char,
35: status varchar2(30) := fnd_api.g_miss_char,

Line 32: orig_currency_code varchar2(15) := fnd_api.g_miss_char,

28: transaction_amount_orig number := fnd_api.g_miss_num,
29: quantity number := fnd_api.g_miss_num,
30: discount_percentage number := fnd_api.g_miss_num,
31: margin_percentage number := fnd_api.g_miss_num,
32: orig_currency_code varchar2(15) := fnd_api.g_miss_char,
33: exchange_rate number := fnd_api.g_miss_num,
34: status_disp varchar2(80) := fnd_api.g_miss_char,
35: status varchar2(30) := fnd_api.g_miss_char,
36: trx_type_disp varchar2(80) := fnd_api.g_miss_char,

Line 33: exchange_rate number := fnd_api.g_miss_num,

29: quantity number := fnd_api.g_miss_num,
30: discount_percentage number := fnd_api.g_miss_num,
31: margin_percentage number := fnd_api.g_miss_num,
32: orig_currency_code varchar2(15) := fnd_api.g_miss_char,
33: exchange_rate number := fnd_api.g_miss_num,
34: status_disp varchar2(80) := fnd_api.g_miss_char,
35: status varchar2(30) := fnd_api.g_miss_char,
36: trx_type_disp varchar2(80) := fnd_api.g_miss_char,
37: trx_type varchar2(30) := fnd_api.g_miss_char,

Line 34: status_disp varchar2(80) := fnd_api.g_miss_char,

30: discount_percentage number := fnd_api.g_miss_num,
31: margin_percentage number := fnd_api.g_miss_num,
32: orig_currency_code varchar2(15) := fnd_api.g_miss_char,
33: exchange_rate number := fnd_api.g_miss_num,
34: status_disp varchar2(80) := fnd_api.g_miss_char,
35: status varchar2(30) := fnd_api.g_miss_char,
36: trx_type_disp varchar2(80) := fnd_api.g_miss_char,
37: trx_type varchar2(30) := fnd_api.g_miss_char,
38: reason varchar2(80) := fnd_api.g_miss_char,

Line 35: status varchar2(30) := fnd_api.g_miss_char,

31: margin_percentage number := fnd_api.g_miss_num,
32: orig_currency_code varchar2(15) := fnd_api.g_miss_char,
33: exchange_rate number := fnd_api.g_miss_num,
34: status_disp varchar2(80) := fnd_api.g_miss_char,
35: status varchar2(30) := fnd_api.g_miss_char,
36: trx_type_disp varchar2(80) := fnd_api.g_miss_char,
37: trx_type varchar2(30) := fnd_api.g_miss_char,
38: reason varchar2(80) := fnd_api.g_miss_char,
39: reason_code varchar2(30) := fnd_api.g_miss_char,

Line 36: trx_type_disp varchar2(80) := fnd_api.g_miss_char,

32: orig_currency_code varchar2(15) := fnd_api.g_miss_char,
33: exchange_rate number := fnd_api.g_miss_num,
34: status_disp varchar2(80) := fnd_api.g_miss_char,
35: status varchar2(30) := fnd_api.g_miss_char,
36: trx_type_disp varchar2(80) := fnd_api.g_miss_char,
37: trx_type varchar2(30) := fnd_api.g_miss_char,
38: reason varchar2(80) := fnd_api.g_miss_char,
39: reason_code varchar2(30) := fnd_api.g_miss_char,
40: comments varchar2(1800) := fnd_api.g_miss_char,

Line 37: trx_type varchar2(30) := fnd_api.g_miss_char,

33: exchange_rate number := fnd_api.g_miss_num,
34: status_disp varchar2(80) := fnd_api.g_miss_char,
35: status varchar2(30) := fnd_api.g_miss_char,
36: trx_type_disp varchar2(80) := fnd_api.g_miss_char,
37: trx_type varchar2(30) := fnd_api.g_miss_char,
38: reason varchar2(80) := fnd_api.g_miss_char,
39: reason_code varchar2(30) := fnd_api.g_miss_char,
40: comments varchar2(1800) := fnd_api.g_miss_char,
41: trx_batch_id number := fnd_api.g_miss_num,

Line 38: reason varchar2(80) := fnd_api.g_miss_char,

34: status_disp varchar2(80) := fnd_api.g_miss_char,
35: status varchar2(30) := fnd_api.g_miss_char,
36: trx_type_disp varchar2(80) := fnd_api.g_miss_char,
37: trx_type varchar2(30) := fnd_api.g_miss_char,
38: reason varchar2(80) := fnd_api.g_miss_char,
39: reason_code varchar2(30) := fnd_api.g_miss_char,
40: comments varchar2(1800) := fnd_api.g_miss_char,
41: trx_batch_id number := fnd_api.g_miss_num,
42: created_by number := fnd_api.g_miss_num,

Line 39: reason_code varchar2(30) := fnd_api.g_miss_char,

35: status varchar2(30) := fnd_api.g_miss_char,
36: trx_type_disp varchar2(80) := fnd_api.g_miss_char,
37: trx_type varchar2(30) := fnd_api.g_miss_char,
38: reason varchar2(80) := fnd_api.g_miss_char,
39: reason_code varchar2(30) := fnd_api.g_miss_char,
40: comments varchar2(1800) := fnd_api.g_miss_char,
41: trx_batch_id number := fnd_api.g_miss_num,
42: created_by number := fnd_api.g_miss_num,
43: creation_date date := fnd_api.g_miss_date,

Line 40: comments varchar2(1800) := fnd_api.g_miss_char,

36: trx_type_disp varchar2(80) := fnd_api.g_miss_char,
37: trx_type varchar2(30) := fnd_api.g_miss_char,
38: reason varchar2(80) := fnd_api.g_miss_char,
39: reason_code varchar2(30) := fnd_api.g_miss_char,
40: comments varchar2(1800) := fnd_api.g_miss_char,
41: trx_batch_id number := fnd_api.g_miss_num,
42: created_by number := fnd_api.g_miss_num,
43: creation_date date := fnd_api.g_miss_date,
44: last_updated_by number := fnd_api.g_miss_num,

Line 41: trx_batch_id number := fnd_api.g_miss_num,

37: trx_type varchar2(30) := fnd_api.g_miss_char,
38: reason varchar2(80) := fnd_api.g_miss_char,
39: reason_code varchar2(30) := fnd_api.g_miss_char,
40: comments varchar2(1800) := fnd_api.g_miss_char,
41: trx_batch_id number := fnd_api.g_miss_num,
42: created_by number := fnd_api.g_miss_num,
43: creation_date date := fnd_api.g_miss_date,
44: last_updated_by number := fnd_api.g_miss_num,
45: last_update_login number := fnd_api.g_miss_num,

Line 42: created_by number := fnd_api.g_miss_num,

38: reason varchar2(80) := fnd_api.g_miss_char,
39: reason_code varchar2(30) := fnd_api.g_miss_char,
40: comments varchar2(1800) := fnd_api.g_miss_char,
41: trx_batch_id number := fnd_api.g_miss_num,
42: created_by number := fnd_api.g_miss_num,
43: creation_date date := fnd_api.g_miss_date,
44: last_updated_by number := fnd_api.g_miss_num,
45: last_update_login number := fnd_api.g_miss_num,
46: last_update_date date := fnd_api.g_miss_date,

Line 43: creation_date date := fnd_api.g_miss_date,

39: reason_code varchar2(30) := fnd_api.g_miss_char,
40: comments varchar2(1800) := fnd_api.g_miss_char,
41: trx_batch_id number := fnd_api.g_miss_num,
42: created_by number := fnd_api.g_miss_num,
43: creation_date date := fnd_api.g_miss_date,
44: last_updated_by number := fnd_api.g_miss_num,
45: last_update_login number := fnd_api.g_miss_num,
46: last_update_date date := fnd_api.g_miss_date,
47: attribute_category varchar2(30) := fnd_api.g_miss_char,

Line 44: last_updated_by number := fnd_api.g_miss_num,

40: comments varchar2(1800) := fnd_api.g_miss_char,
41: trx_batch_id number := fnd_api.g_miss_num,
42: created_by number := fnd_api.g_miss_num,
43: creation_date date := fnd_api.g_miss_date,
44: last_updated_by number := fnd_api.g_miss_num,
45: last_update_login number := fnd_api.g_miss_num,
46: last_update_date date := fnd_api.g_miss_date,
47: attribute_category varchar2(30) := fnd_api.g_miss_char,
48: attribute1 varchar2(240) := fnd_api.g_miss_char,

Line 45: last_update_login number := fnd_api.g_miss_num,

41: trx_batch_id number := fnd_api.g_miss_num,
42: created_by number := fnd_api.g_miss_num,
43: creation_date date := fnd_api.g_miss_date,
44: last_updated_by number := fnd_api.g_miss_num,
45: last_update_login number := fnd_api.g_miss_num,
46: last_update_date date := fnd_api.g_miss_date,
47: attribute_category varchar2(30) := fnd_api.g_miss_char,
48: attribute1 varchar2(240) := fnd_api.g_miss_char,
49: attribute2 varchar2(240) := fnd_api.g_miss_char,

Line 46: last_update_date date := fnd_api.g_miss_date,

42: created_by number := fnd_api.g_miss_num,
43: creation_date date := fnd_api.g_miss_date,
44: last_updated_by number := fnd_api.g_miss_num,
45: last_update_login number := fnd_api.g_miss_num,
46: last_update_date date := fnd_api.g_miss_date,
47: attribute_category varchar2(30) := fnd_api.g_miss_char,
48: attribute1 varchar2(240) := fnd_api.g_miss_char,
49: attribute2 varchar2(240) := fnd_api.g_miss_char,
50: attribute3 varchar2(240) := fnd_api.g_miss_char,

Line 47: attribute_category varchar2(30) := fnd_api.g_miss_char,

43: creation_date date := fnd_api.g_miss_date,
44: last_updated_by number := fnd_api.g_miss_num,
45: last_update_login number := fnd_api.g_miss_num,
46: last_update_date date := fnd_api.g_miss_date,
47: attribute_category varchar2(30) := fnd_api.g_miss_char,
48: attribute1 varchar2(240) := fnd_api.g_miss_char,
49: attribute2 varchar2(240) := fnd_api.g_miss_char,
50: attribute3 varchar2(240) := fnd_api.g_miss_char,
51: attribute4 varchar2(240) := fnd_api.g_miss_char,

Line 48: attribute1 varchar2(240) := fnd_api.g_miss_char,

44: last_updated_by number := fnd_api.g_miss_num,
45: last_update_login number := fnd_api.g_miss_num,
46: last_update_date date := fnd_api.g_miss_date,
47: attribute_category varchar2(30) := fnd_api.g_miss_char,
48: attribute1 varchar2(240) := fnd_api.g_miss_char,
49: attribute2 varchar2(240) := fnd_api.g_miss_char,
50: attribute3 varchar2(240) := fnd_api.g_miss_char,
51: attribute4 varchar2(240) := fnd_api.g_miss_char,
52: attribute5 varchar2(240) := fnd_api.g_miss_char,

Line 49: attribute2 varchar2(240) := fnd_api.g_miss_char,

45: last_update_login number := fnd_api.g_miss_num,
46: last_update_date date := fnd_api.g_miss_date,
47: attribute_category varchar2(30) := fnd_api.g_miss_char,
48: attribute1 varchar2(240) := fnd_api.g_miss_char,
49: attribute2 varchar2(240) := fnd_api.g_miss_char,
50: attribute3 varchar2(240) := fnd_api.g_miss_char,
51: attribute4 varchar2(240) := fnd_api.g_miss_char,
52: attribute5 varchar2(240) := fnd_api.g_miss_char,
53: attribute6 varchar2(240) := fnd_api.g_miss_char,

Line 50: attribute3 varchar2(240) := fnd_api.g_miss_char,

46: last_update_date date := fnd_api.g_miss_date,
47: attribute_category varchar2(30) := fnd_api.g_miss_char,
48: attribute1 varchar2(240) := fnd_api.g_miss_char,
49: attribute2 varchar2(240) := fnd_api.g_miss_char,
50: attribute3 varchar2(240) := fnd_api.g_miss_char,
51: attribute4 varchar2(240) := fnd_api.g_miss_char,
52: attribute5 varchar2(240) := fnd_api.g_miss_char,
53: attribute6 varchar2(240) := fnd_api.g_miss_char,
54: attribute7 varchar2(240) := fnd_api.g_miss_char,

Line 51: attribute4 varchar2(240) := fnd_api.g_miss_char,

47: attribute_category varchar2(30) := fnd_api.g_miss_char,
48: attribute1 varchar2(240) := fnd_api.g_miss_char,
49: attribute2 varchar2(240) := fnd_api.g_miss_char,
50: attribute3 varchar2(240) := fnd_api.g_miss_char,
51: attribute4 varchar2(240) := fnd_api.g_miss_char,
52: attribute5 varchar2(240) := fnd_api.g_miss_char,
53: attribute6 varchar2(240) := fnd_api.g_miss_char,
54: attribute7 varchar2(240) := fnd_api.g_miss_char,
55: attribute8 varchar2(240) := fnd_api.g_miss_char,

Line 52: attribute5 varchar2(240) := fnd_api.g_miss_char,

48: attribute1 varchar2(240) := fnd_api.g_miss_char,
49: attribute2 varchar2(240) := fnd_api.g_miss_char,
50: attribute3 varchar2(240) := fnd_api.g_miss_char,
51: attribute4 varchar2(240) := fnd_api.g_miss_char,
52: attribute5 varchar2(240) := fnd_api.g_miss_char,
53: attribute6 varchar2(240) := fnd_api.g_miss_char,
54: attribute7 varchar2(240) := fnd_api.g_miss_char,
55: attribute8 varchar2(240) := fnd_api.g_miss_char,
56: attribute9 varchar2(240) := fnd_api.g_miss_char,

Line 53: attribute6 varchar2(240) := fnd_api.g_miss_char,

49: attribute2 varchar2(240) := fnd_api.g_miss_char,
50: attribute3 varchar2(240) := fnd_api.g_miss_char,
51: attribute4 varchar2(240) := fnd_api.g_miss_char,
52: attribute5 varchar2(240) := fnd_api.g_miss_char,
53: attribute6 varchar2(240) := fnd_api.g_miss_char,
54: attribute7 varchar2(240) := fnd_api.g_miss_char,
55: attribute8 varchar2(240) := fnd_api.g_miss_char,
56: attribute9 varchar2(240) := fnd_api.g_miss_char,
57: attribute10 varchar2(240) := fnd_api.g_miss_char,

Line 54: attribute7 varchar2(240) := fnd_api.g_miss_char,

50: attribute3 varchar2(240) := fnd_api.g_miss_char,
51: attribute4 varchar2(240) := fnd_api.g_miss_char,
52: attribute5 varchar2(240) := fnd_api.g_miss_char,
53: attribute6 varchar2(240) := fnd_api.g_miss_char,
54: attribute7 varchar2(240) := fnd_api.g_miss_char,
55: attribute8 varchar2(240) := fnd_api.g_miss_char,
56: attribute9 varchar2(240) := fnd_api.g_miss_char,
57: attribute10 varchar2(240) := fnd_api.g_miss_char,
58: attribute11 varchar2(240) := fnd_api.g_miss_char,

Line 55: attribute8 varchar2(240) := fnd_api.g_miss_char,

51: attribute4 varchar2(240) := fnd_api.g_miss_char,
52: attribute5 varchar2(240) := fnd_api.g_miss_char,
53: attribute6 varchar2(240) := fnd_api.g_miss_char,
54: attribute7 varchar2(240) := fnd_api.g_miss_char,
55: attribute8 varchar2(240) := fnd_api.g_miss_char,
56: attribute9 varchar2(240) := fnd_api.g_miss_char,
57: attribute10 varchar2(240) := fnd_api.g_miss_char,
58: attribute11 varchar2(240) := fnd_api.g_miss_char,
59: attribute12 varchar2(240) := fnd_api.g_miss_char,

Line 56: attribute9 varchar2(240) := fnd_api.g_miss_char,

52: attribute5 varchar2(240) := fnd_api.g_miss_char,
53: attribute6 varchar2(240) := fnd_api.g_miss_char,
54: attribute7 varchar2(240) := fnd_api.g_miss_char,
55: attribute8 varchar2(240) := fnd_api.g_miss_char,
56: attribute9 varchar2(240) := fnd_api.g_miss_char,
57: attribute10 varchar2(240) := fnd_api.g_miss_char,
58: attribute11 varchar2(240) := fnd_api.g_miss_char,
59: attribute12 varchar2(240) := fnd_api.g_miss_char,
60: attribute13 varchar2(240) := fnd_api.g_miss_char,

Line 57: attribute10 varchar2(240) := fnd_api.g_miss_char,

53: attribute6 varchar2(240) := fnd_api.g_miss_char,
54: attribute7 varchar2(240) := fnd_api.g_miss_char,
55: attribute8 varchar2(240) := fnd_api.g_miss_char,
56: attribute9 varchar2(240) := fnd_api.g_miss_char,
57: attribute10 varchar2(240) := fnd_api.g_miss_char,
58: attribute11 varchar2(240) := fnd_api.g_miss_char,
59: attribute12 varchar2(240) := fnd_api.g_miss_char,
60: attribute13 varchar2(240) := fnd_api.g_miss_char,
61: attribute14 varchar2(240) := fnd_api.g_miss_char,

Line 58: attribute11 varchar2(240) := fnd_api.g_miss_char,

54: attribute7 varchar2(240) := fnd_api.g_miss_char,
55: attribute8 varchar2(240) := fnd_api.g_miss_char,
56: attribute9 varchar2(240) := fnd_api.g_miss_char,
57: attribute10 varchar2(240) := fnd_api.g_miss_char,
58: attribute11 varchar2(240) := fnd_api.g_miss_char,
59: attribute12 varchar2(240) := fnd_api.g_miss_char,
60: attribute13 varchar2(240) := fnd_api.g_miss_char,
61: attribute14 varchar2(240) := fnd_api.g_miss_char,
62: attribute15 varchar2(240) := fnd_api.g_miss_char,

Line 59: attribute12 varchar2(240) := fnd_api.g_miss_char,

55: attribute8 varchar2(240) := fnd_api.g_miss_char,
56: attribute9 varchar2(240) := fnd_api.g_miss_char,
57: attribute10 varchar2(240) := fnd_api.g_miss_char,
58: attribute11 varchar2(240) := fnd_api.g_miss_char,
59: attribute12 varchar2(240) := fnd_api.g_miss_char,
60: attribute13 varchar2(240) := fnd_api.g_miss_char,
61: attribute14 varchar2(240) := fnd_api.g_miss_char,
62: attribute15 varchar2(240) := fnd_api.g_miss_char,
63: attribute16 varchar2(240) := fnd_api.g_miss_char,

Line 60: attribute13 varchar2(240) := fnd_api.g_miss_char,

56: attribute9 varchar2(240) := fnd_api.g_miss_char,
57: attribute10 varchar2(240) := fnd_api.g_miss_char,
58: attribute11 varchar2(240) := fnd_api.g_miss_char,
59: attribute12 varchar2(240) := fnd_api.g_miss_char,
60: attribute13 varchar2(240) := fnd_api.g_miss_char,
61: attribute14 varchar2(240) := fnd_api.g_miss_char,
62: attribute15 varchar2(240) := fnd_api.g_miss_char,
63: attribute16 varchar2(240) := fnd_api.g_miss_char,
64: attribute17 varchar2(240) := fnd_api.g_miss_char,

Line 61: attribute14 varchar2(240) := fnd_api.g_miss_char,

57: attribute10 varchar2(240) := fnd_api.g_miss_char,
58: attribute11 varchar2(240) := fnd_api.g_miss_char,
59: attribute12 varchar2(240) := fnd_api.g_miss_char,
60: attribute13 varchar2(240) := fnd_api.g_miss_char,
61: attribute14 varchar2(240) := fnd_api.g_miss_char,
62: attribute15 varchar2(240) := fnd_api.g_miss_char,
63: attribute16 varchar2(240) := fnd_api.g_miss_char,
64: attribute17 varchar2(240) := fnd_api.g_miss_char,
65: attribute18 varchar2(240) := fnd_api.g_miss_char,

Line 62: attribute15 varchar2(240) := fnd_api.g_miss_char,

58: attribute11 varchar2(240) := fnd_api.g_miss_char,
59: attribute12 varchar2(240) := fnd_api.g_miss_char,
60: attribute13 varchar2(240) := fnd_api.g_miss_char,
61: attribute14 varchar2(240) := fnd_api.g_miss_char,
62: attribute15 varchar2(240) := fnd_api.g_miss_char,
63: attribute16 varchar2(240) := fnd_api.g_miss_char,
64: attribute17 varchar2(240) := fnd_api.g_miss_char,
65: attribute18 varchar2(240) := fnd_api.g_miss_char,
66: attribute19 varchar2(240) := fnd_api.g_miss_char,

Line 63: attribute16 varchar2(240) := fnd_api.g_miss_char,

59: attribute12 varchar2(240) := fnd_api.g_miss_char,
60: attribute13 varchar2(240) := fnd_api.g_miss_char,
61: attribute14 varchar2(240) := fnd_api.g_miss_char,
62: attribute15 varchar2(240) := fnd_api.g_miss_char,
63: attribute16 varchar2(240) := fnd_api.g_miss_char,
64: attribute17 varchar2(240) := fnd_api.g_miss_char,
65: attribute18 varchar2(240) := fnd_api.g_miss_char,
66: attribute19 varchar2(240) := fnd_api.g_miss_char,
67: attribute20 varchar2(240) := fnd_api.g_miss_char,

Line 64: attribute17 varchar2(240) := fnd_api.g_miss_char,

60: attribute13 varchar2(240) := fnd_api.g_miss_char,
61: attribute14 varchar2(240) := fnd_api.g_miss_char,
62: attribute15 varchar2(240) := fnd_api.g_miss_char,
63: attribute16 varchar2(240) := fnd_api.g_miss_char,
64: attribute17 varchar2(240) := fnd_api.g_miss_char,
65: attribute18 varchar2(240) := fnd_api.g_miss_char,
66: attribute19 varchar2(240) := fnd_api.g_miss_char,
67: attribute20 varchar2(240) := fnd_api.g_miss_char,
68: attribute21 varchar2(240) := fnd_api.g_miss_char,

Line 65: attribute18 varchar2(240) := fnd_api.g_miss_char,

61: attribute14 varchar2(240) := fnd_api.g_miss_char,
62: attribute15 varchar2(240) := fnd_api.g_miss_char,
63: attribute16 varchar2(240) := fnd_api.g_miss_char,
64: attribute17 varchar2(240) := fnd_api.g_miss_char,
65: attribute18 varchar2(240) := fnd_api.g_miss_char,
66: attribute19 varchar2(240) := fnd_api.g_miss_char,
67: attribute20 varchar2(240) := fnd_api.g_miss_char,
68: attribute21 varchar2(240) := fnd_api.g_miss_char,
69: attribute22 varchar2(240) := fnd_api.g_miss_char,

Line 66: attribute19 varchar2(240) := fnd_api.g_miss_char,

62: attribute15 varchar2(240) := fnd_api.g_miss_char,
63: attribute16 varchar2(240) := fnd_api.g_miss_char,
64: attribute17 varchar2(240) := fnd_api.g_miss_char,
65: attribute18 varchar2(240) := fnd_api.g_miss_char,
66: attribute19 varchar2(240) := fnd_api.g_miss_char,
67: attribute20 varchar2(240) := fnd_api.g_miss_char,
68: attribute21 varchar2(240) := fnd_api.g_miss_char,
69: attribute22 varchar2(240) := fnd_api.g_miss_char,
70: attribute23 varchar2(240) := fnd_api.g_miss_char,

Line 67: attribute20 varchar2(240) := fnd_api.g_miss_char,

63: attribute16 varchar2(240) := fnd_api.g_miss_char,
64: attribute17 varchar2(240) := fnd_api.g_miss_char,
65: attribute18 varchar2(240) := fnd_api.g_miss_char,
66: attribute19 varchar2(240) := fnd_api.g_miss_char,
67: attribute20 varchar2(240) := fnd_api.g_miss_char,
68: attribute21 varchar2(240) := fnd_api.g_miss_char,
69: attribute22 varchar2(240) := fnd_api.g_miss_char,
70: attribute23 varchar2(240) := fnd_api.g_miss_char,
71: attribute24 varchar2(240) := fnd_api.g_miss_char,

Line 68: attribute21 varchar2(240) := fnd_api.g_miss_char,

64: attribute17 varchar2(240) := fnd_api.g_miss_char,
65: attribute18 varchar2(240) := fnd_api.g_miss_char,
66: attribute19 varchar2(240) := fnd_api.g_miss_char,
67: attribute20 varchar2(240) := fnd_api.g_miss_char,
68: attribute21 varchar2(240) := fnd_api.g_miss_char,
69: attribute22 varchar2(240) := fnd_api.g_miss_char,
70: attribute23 varchar2(240) := fnd_api.g_miss_char,
71: attribute24 varchar2(240) := fnd_api.g_miss_char,
72: attribute25 varchar2(240) := fnd_api.g_miss_char,

Line 69: attribute22 varchar2(240) := fnd_api.g_miss_char,

65: attribute18 varchar2(240) := fnd_api.g_miss_char,
66: attribute19 varchar2(240) := fnd_api.g_miss_char,
67: attribute20 varchar2(240) := fnd_api.g_miss_char,
68: attribute21 varchar2(240) := fnd_api.g_miss_char,
69: attribute22 varchar2(240) := fnd_api.g_miss_char,
70: attribute23 varchar2(240) := fnd_api.g_miss_char,
71: attribute24 varchar2(240) := fnd_api.g_miss_char,
72: attribute25 varchar2(240) := fnd_api.g_miss_char,
73: attribute26 varchar2(240) := fnd_api.g_miss_char,

Line 70: attribute23 varchar2(240) := fnd_api.g_miss_char,

66: attribute19 varchar2(240) := fnd_api.g_miss_char,
67: attribute20 varchar2(240) := fnd_api.g_miss_char,
68: attribute21 varchar2(240) := fnd_api.g_miss_char,
69: attribute22 varchar2(240) := fnd_api.g_miss_char,
70: attribute23 varchar2(240) := fnd_api.g_miss_char,
71: attribute24 varchar2(240) := fnd_api.g_miss_char,
72: attribute25 varchar2(240) := fnd_api.g_miss_char,
73: attribute26 varchar2(240) := fnd_api.g_miss_char,
74: attribute27 varchar2(240) := fnd_api.g_miss_char,

Line 71: attribute24 varchar2(240) := fnd_api.g_miss_char,

67: attribute20 varchar2(240) := fnd_api.g_miss_char,
68: attribute21 varchar2(240) := fnd_api.g_miss_char,
69: attribute22 varchar2(240) := fnd_api.g_miss_char,
70: attribute23 varchar2(240) := fnd_api.g_miss_char,
71: attribute24 varchar2(240) := fnd_api.g_miss_char,
72: attribute25 varchar2(240) := fnd_api.g_miss_char,
73: attribute26 varchar2(240) := fnd_api.g_miss_char,
74: attribute27 varchar2(240) := fnd_api.g_miss_char,
75: attribute28 varchar2(240) := fnd_api.g_miss_char,

Line 72: attribute25 varchar2(240) := fnd_api.g_miss_char,

68: attribute21 varchar2(240) := fnd_api.g_miss_char,
69: attribute22 varchar2(240) := fnd_api.g_miss_char,
70: attribute23 varchar2(240) := fnd_api.g_miss_char,
71: attribute24 varchar2(240) := fnd_api.g_miss_char,
72: attribute25 varchar2(240) := fnd_api.g_miss_char,
73: attribute26 varchar2(240) := fnd_api.g_miss_char,
74: attribute27 varchar2(240) := fnd_api.g_miss_char,
75: attribute28 varchar2(240) := fnd_api.g_miss_char,
76: attribute29 varchar2(240) := fnd_api.g_miss_char,

Line 73: attribute26 varchar2(240) := fnd_api.g_miss_char,

69: attribute22 varchar2(240) := fnd_api.g_miss_char,
70: attribute23 varchar2(240) := fnd_api.g_miss_char,
71: attribute24 varchar2(240) := fnd_api.g_miss_char,
72: attribute25 varchar2(240) := fnd_api.g_miss_char,
73: attribute26 varchar2(240) := fnd_api.g_miss_char,
74: attribute27 varchar2(240) := fnd_api.g_miss_char,
75: attribute28 varchar2(240) := fnd_api.g_miss_char,
76: attribute29 varchar2(240) := fnd_api.g_miss_char,
77: attribute30 varchar2(240) := fnd_api.g_miss_char,

Line 74: attribute27 varchar2(240) := fnd_api.g_miss_char,

70: attribute23 varchar2(240) := fnd_api.g_miss_char,
71: attribute24 varchar2(240) := fnd_api.g_miss_char,
72: attribute25 varchar2(240) := fnd_api.g_miss_char,
73: attribute26 varchar2(240) := fnd_api.g_miss_char,
74: attribute27 varchar2(240) := fnd_api.g_miss_char,
75: attribute28 varchar2(240) := fnd_api.g_miss_char,
76: attribute29 varchar2(240) := fnd_api.g_miss_char,
77: attribute30 varchar2(240) := fnd_api.g_miss_char,
78: attribute31 varchar2(240) := fnd_api.g_miss_char,

Line 75: attribute28 varchar2(240) := fnd_api.g_miss_char,

71: attribute24 varchar2(240) := fnd_api.g_miss_char,
72: attribute25 varchar2(240) := fnd_api.g_miss_char,
73: attribute26 varchar2(240) := fnd_api.g_miss_char,
74: attribute27 varchar2(240) := fnd_api.g_miss_char,
75: attribute28 varchar2(240) := fnd_api.g_miss_char,
76: attribute29 varchar2(240) := fnd_api.g_miss_char,
77: attribute30 varchar2(240) := fnd_api.g_miss_char,
78: attribute31 varchar2(240) := fnd_api.g_miss_char,
79: attribute32 varchar2(240) := fnd_api.g_miss_char,

Line 76: attribute29 varchar2(240) := fnd_api.g_miss_char,

72: attribute25 varchar2(240) := fnd_api.g_miss_char,
73: attribute26 varchar2(240) := fnd_api.g_miss_char,
74: attribute27 varchar2(240) := fnd_api.g_miss_char,
75: attribute28 varchar2(240) := fnd_api.g_miss_char,
76: attribute29 varchar2(240) := fnd_api.g_miss_char,
77: attribute30 varchar2(240) := fnd_api.g_miss_char,
78: attribute31 varchar2(240) := fnd_api.g_miss_char,
79: attribute32 varchar2(240) := fnd_api.g_miss_char,
80: attribute33 varchar2(240) := fnd_api.g_miss_char,

Line 77: attribute30 varchar2(240) := fnd_api.g_miss_char,

73: attribute26 varchar2(240) := fnd_api.g_miss_char,
74: attribute27 varchar2(240) := fnd_api.g_miss_char,
75: attribute28 varchar2(240) := fnd_api.g_miss_char,
76: attribute29 varchar2(240) := fnd_api.g_miss_char,
77: attribute30 varchar2(240) := fnd_api.g_miss_char,
78: attribute31 varchar2(240) := fnd_api.g_miss_char,
79: attribute32 varchar2(240) := fnd_api.g_miss_char,
80: attribute33 varchar2(240) := fnd_api.g_miss_char,
81: attribute34 varchar2(240) := fnd_api.g_miss_char,

Line 78: attribute31 varchar2(240) := fnd_api.g_miss_char,

74: attribute27 varchar2(240) := fnd_api.g_miss_char,
75: attribute28 varchar2(240) := fnd_api.g_miss_char,
76: attribute29 varchar2(240) := fnd_api.g_miss_char,
77: attribute30 varchar2(240) := fnd_api.g_miss_char,
78: attribute31 varchar2(240) := fnd_api.g_miss_char,
79: attribute32 varchar2(240) := fnd_api.g_miss_char,
80: attribute33 varchar2(240) := fnd_api.g_miss_char,
81: attribute34 varchar2(240) := fnd_api.g_miss_char,
82: attribute35 varchar2(240) := fnd_api.g_miss_char,

Line 79: attribute32 varchar2(240) := fnd_api.g_miss_char,

75: attribute28 varchar2(240) := fnd_api.g_miss_char,
76: attribute29 varchar2(240) := fnd_api.g_miss_char,
77: attribute30 varchar2(240) := fnd_api.g_miss_char,
78: attribute31 varchar2(240) := fnd_api.g_miss_char,
79: attribute32 varchar2(240) := fnd_api.g_miss_char,
80: attribute33 varchar2(240) := fnd_api.g_miss_char,
81: attribute34 varchar2(240) := fnd_api.g_miss_char,
82: attribute35 varchar2(240) := fnd_api.g_miss_char,
83: attribute36 varchar2(240) := fnd_api.g_miss_char,

Line 80: attribute33 varchar2(240) := fnd_api.g_miss_char,

76: attribute29 varchar2(240) := fnd_api.g_miss_char,
77: attribute30 varchar2(240) := fnd_api.g_miss_char,
78: attribute31 varchar2(240) := fnd_api.g_miss_char,
79: attribute32 varchar2(240) := fnd_api.g_miss_char,
80: attribute33 varchar2(240) := fnd_api.g_miss_char,
81: attribute34 varchar2(240) := fnd_api.g_miss_char,
82: attribute35 varchar2(240) := fnd_api.g_miss_char,
83: attribute36 varchar2(240) := fnd_api.g_miss_char,
84: attribute37 varchar2(240) := fnd_api.g_miss_char,

Line 81: attribute34 varchar2(240) := fnd_api.g_miss_char,

77: attribute30 varchar2(240) := fnd_api.g_miss_char,
78: attribute31 varchar2(240) := fnd_api.g_miss_char,
79: attribute32 varchar2(240) := fnd_api.g_miss_char,
80: attribute33 varchar2(240) := fnd_api.g_miss_char,
81: attribute34 varchar2(240) := fnd_api.g_miss_char,
82: attribute35 varchar2(240) := fnd_api.g_miss_char,
83: attribute36 varchar2(240) := fnd_api.g_miss_char,
84: attribute37 varchar2(240) := fnd_api.g_miss_char,
85: attribute38 varchar2(240) := fnd_api.g_miss_char,

Line 82: attribute35 varchar2(240) := fnd_api.g_miss_char,

78: attribute31 varchar2(240) := fnd_api.g_miss_char,
79: attribute32 varchar2(240) := fnd_api.g_miss_char,
80: attribute33 varchar2(240) := fnd_api.g_miss_char,
81: attribute34 varchar2(240) := fnd_api.g_miss_char,
82: attribute35 varchar2(240) := fnd_api.g_miss_char,
83: attribute36 varchar2(240) := fnd_api.g_miss_char,
84: attribute37 varchar2(240) := fnd_api.g_miss_char,
85: attribute38 varchar2(240) := fnd_api.g_miss_char,
86: attribute39 varchar2(240) := fnd_api.g_miss_char,

Line 83: attribute36 varchar2(240) := fnd_api.g_miss_char,

79: attribute32 varchar2(240) := fnd_api.g_miss_char,
80: attribute33 varchar2(240) := fnd_api.g_miss_char,
81: attribute34 varchar2(240) := fnd_api.g_miss_char,
82: attribute35 varchar2(240) := fnd_api.g_miss_char,
83: attribute36 varchar2(240) := fnd_api.g_miss_char,
84: attribute37 varchar2(240) := fnd_api.g_miss_char,
85: attribute38 varchar2(240) := fnd_api.g_miss_char,
86: attribute39 varchar2(240) := fnd_api.g_miss_char,
87: attribute40 varchar2(240) := fnd_api.g_miss_char,

Line 84: attribute37 varchar2(240) := fnd_api.g_miss_char,

80: attribute33 varchar2(240) := fnd_api.g_miss_char,
81: attribute34 varchar2(240) := fnd_api.g_miss_char,
82: attribute35 varchar2(240) := fnd_api.g_miss_char,
83: attribute36 varchar2(240) := fnd_api.g_miss_char,
84: attribute37 varchar2(240) := fnd_api.g_miss_char,
85: attribute38 varchar2(240) := fnd_api.g_miss_char,
86: attribute39 varchar2(240) := fnd_api.g_miss_char,
87: attribute40 varchar2(240) := fnd_api.g_miss_char,
88: attribute41 varchar2(240) := fnd_api.g_miss_char,

Line 85: attribute38 varchar2(240) := fnd_api.g_miss_char,

81: attribute34 varchar2(240) := fnd_api.g_miss_char,
82: attribute35 varchar2(240) := fnd_api.g_miss_char,
83: attribute36 varchar2(240) := fnd_api.g_miss_char,
84: attribute37 varchar2(240) := fnd_api.g_miss_char,
85: attribute38 varchar2(240) := fnd_api.g_miss_char,
86: attribute39 varchar2(240) := fnd_api.g_miss_char,
87: attribute40 varchar2(240) := fnd_api.g_miss_char,
88: attribute41 varchar2(240) := fnd_api.g_miss_char,
89: attribute42 varchar2(240) := fnd_api.g_miss_char,

Line 86: attribute39 varchar2(240) := fnd_api.g_miss_char,

82: attribute35 varchar2(240) := fnd_api.g_miss_char,
83: attribute36 varchar2(240) := fnd_api.g_miss_char,
84: attribute37 varchar2(240) := fnd_api.g_miss_char,
85: attribute38 varchar2(240) := fnd_api.g_miss_char,
86: attribute39 varchar2(240) := fnd_api.g_miss_char,
87: attribute40 varchar2(240) := fnd_api.g_miss_char,
88: attribute41 varchar2(240) := fnd_api.g_miss_char,
89: attribute42 varchar2(240) := fnd_api.g_miss_char,
90: attribute43 varchar2(240) := fnd_api.g_miss_char,

Line 87: attribute40 varchar2(240) := fnd_api.g_miss_char,

83: attribute36 varchar2(240) := fnd_api.g_miss_char,
84: attribute37 varchar2(240) := fnd_api.g_miss_char,
85: attribute38 varchar2(240) := fnd_api.g_miss_char,
86: attribute39 varchar2(240) := fnd_api.g_miss_char,
87: attribute40 varchar2(240) := fnd_api.g_miss_char,
88: attribute41 varchar2(240) := fnd_api.g_miss_char,
89: attribute42 varchar2(240) := fnd_api.g_miss_char,
90: attribute43 varchar2(240) := fnd_api.g_miss_char,
91: attribute44 varchar2(240) := fnd_api.g_miss_char,

Line 88: attribute41 varchar2(240) := fnd_api.g_miss_char,

84: attribute37 varchar2(240) := fnd_api.g_miss_char,
85: attribute38 varchar2(240) := fnd_api.g_miss_char,
86: attribute39 varchar2(240) := fnd_api.g_miss_char,
87: attribute40 varchar2(240) := fnd_api.g_miss_char,
88: attribute41 varchar2(240) := fnd_api.g_miss_char,
89: attribute42 varchar2(240) := fnd_api.g_miss_char,
90: attribute43 varchar2(240) := fnd_api.g_miss_char,
91: attribute44 varchar2(240) := fnd_api.g_miss_char,
92: attribute45 varchar2(240) := fnd_api.g_miss_char,

Line 89: attribute42 varchar2(240) := fnd_api.g_miss_char,

85: attribute38 varchar2(240) := fnd_api.g_miss_char,
86: attribute39 varchar2(240) := fnd_api.g_miss_char,
87: attribute40 varchar2(240) := fnd_api.g_miss_char,
88: attribute41 varchar2(240) := fnd_api.g_miss_char,
89: attribute42 varchar2(240) := fnd_api.g_miss_char,
90: attribute43 varchar2(240) := fnd_api.g_miss_char,
91: attribute44 varchar2(240) := fnd_api.g_miss_char,
92: attribute45 varchar2(240) := fnd_api.g_miss_char,
93: attribute46 varchar2(240) := fnd_api.g_miss_char,

Line 90: attribute43 varchar2(240) := fnd_api.g_miss_char,

86: attribute39 varchar2(240) := fnd_api.g_miss_char,
87: attribute40 varchar2(240) := fnd_api.g_miss_char,
88: attribute41 varchar2(240) := fnd_api.g_miss_char,
89: attribute42 varchar2(240) := fnd_api.g_miss_char,
90: attribute43 varchar2(240) := fnd_api.g_miss_char,
91: attribute44 varchar2(240) := fnd_api.g_miss_char,
92: attribute45 varchar2(240) := fnd_api.g_miss_char,
93: attribute46 varchar2(240) := fnd_api.g_miss_char,
94: attribute47 varchar2(240) := fnd_api.g_miss_char,

Line 91: attribute44 varchar2(240) := fnd_api.g_miss_char,

87: attribute40 varchar2(240) := fnd_api.g_miss_char,
88: attribute41 varchar2(240) := fnd_api.g_miss_char,
89: attribute42 varchar2(240) := fnd_api.g_miss_char,
90: attribute43 varchar2(240) := fnd_api.g_miss_char,
91: attribute44 varchar2(240) := fnd_api.g_miss_char,
92: attribute45 varchar2(240) := fnd_api.g_miss_char,
93: attribute46 varchar2(240) := fnd_api.g_miss_char,
94: attribute47 varchar2(240) := fnd_api.g_miss_char,
95: attribute48 varchar2(240) := fnd_api.g_miss_char,

Line 92: attribute45 varchar2(240) := fnd_api.g_miss_char,

88: attribute41 varchar2(240) := fnd_api.g_miss_char,
89: attribute42 varchar2(240) := fnd_api.g_miss_char,
90: attribute43 varchar2(240) := fnd_api.g_miss_char,
91: attribute44 varchar2(240) := fnd_api.g_miss_char,
92: attribute45 varchar2(240) := fnd_api.g_miss_char,
93: attribute46 varchar2(240) := fnd_api.g_miss_char,
94: attribute47 varchar2(240) := fnd_api.g_miss_char,
95: attribute48 varchar2(240) := fnd_api.g_miss_char,
96: attribute49 varchar2(240) := fnd_api.g_miss_char,

Line 93: attribute46 varchar2(240) := fnd_api.g_miss_char,

89: attribute42 varchar2(240) := fnd_api.g_miss_char,
90: attribute43 varchar2(240) := fnd_api.g_miss_char,
91: attribute44 varchar2(240) := fnd_api.g_miss_char,
92: attribute45 varchar2(240) := fnd_api.g_miss_char,
93: attribute46 varchar2(240) := fnd_api.g_miss_char,
94: attribute47 varchar2(240) := fnd_api.g_miss_char,
95: attribute48 varchar2(240) := fnd_api.g_miss_char,
96: attribute49 varchar2(240) := fnd_api.g_miss_char,
97: attribute50 varchar2(240) := fnd_api.g_miss_char,

Line 94: attribute47 varchar2(240) := fnd_api.g_miss_char,

90: attribute43 varchar2(240) := fnd_api.g_miss_char,
91: attribute44 varchar2(240) := fnd_api.g_miss_char,
92: attribute45 varchar2(240) := fnd_api.g_miss_char,
93: attribute46 varchar2(240) := fnd_api.g_miss_char,
94: attribute47 varchar2(240) := fnd_api.g_miss_char,
95: attribute48 varchar2(240) := fnd_api.g_miss_char,
96: attribute49 varchar2(240) := fnd_api.g_miss_char,
97: attribute50 varchar2(240) := fnd_api.g_miss_char,
98: attribute51 varchar2(240) := fnd_api.g_miss_char,

Line 95: attribute48 varchar2(240) := fnd_api.g_miss_char,

91: attribute44 varchar2(240) := fnd_api.g_miss_char,
92: attribute45 varchar2(240) := fnd_api.g_miss_char,
93: attribute46 varchar2(240) := fnd_api.g_miss_char,
94: attribute47 varchar2(240) := fnd_api.g_miss_char,
95: attribute48 varchar2(240) := fnd_api.g_miss_char,
96: attribute49 varchar2(240) := fnd_api.g_miss_char,
97: attribute50 varchar2(240) := fnd_api.g_miss_char,
98: attribute51 varchar2(240) := fnd_api.g_miss_char,
99: attribute52 varchar2(240) := fnd_api.g_miss_char,

Line 96: attribute49 varchar2(240) := fnd_api.g_miss_char,

92: attribute45 varchar2(240) := fnd_api.g_miss_char,
93: attribute46 varchar2(240) := fnd_api.g_miss_char,
94: attribute47 varchar2(240) := fnd_api.g_miss_char,
95: attribute48 varchar2(240) := fnd_api.g_miss_char,
96: attribute49 varchar2(240) := fnd_api.g_miss_char,
97: attribute50 varchar2(240) := fnd_api.g_miss_char,
98: attribute51 varchar2(240) := fnd_api.g_miss_char,
99: attribute52 varchar2(240) := fnd_api.g_miss_char,
100: attribute53 varchar2(240) := fnd_api.g_miss_char,

Line 97: attribute50 varchar2(240) := fnd_api.g_miss_char,

93: attribute46 varchar2(240) := fnd_api.g_miss_char,
94: attribute47 varchar2(240) := fnd_api.g_miss_char,
95: attribute48 varchar2(240) := fnd_api.g_miss_char,
96: attribute49 varchar2(240) := fnd_api.g_miss_char,
97: attribute50 varchar2(240) := fnd_api.g_miss_char,
98: attribute51 varchar2(240) := fnd_api.g_miss_char,
99: attribute52 varchar2(240) := fnd_api.g_miss_char,
100: attribute53 varchar2(240) := fnd_api.g_miss_char,
101: attribute54 varchar2(240) := fnd_api.g_miss_char,

Line 98: attribute51 varchar2(240) := fnd_api.g_miss_char,

94: attribute47 varchar2(240) := fnd_api.g_miss_char,
95: attribute48 varchar2(240) := fnd_api.g_miss_char,
96: attribute49 varchar2(240) := fnd_api.g_miss_char,
97: attribute50 varchar2(240) := fnd_api.g_miss_char,
98: attribute51 varchar2(240) := fnd_api.g_miss_char,
99: attribute52 varchar2(240) := fnd_api.g_miss_char,
100: attribute53 varchar2(240) := fnd_api.g_miss_char,
101: attribute54 varchar2(240) := fnd_api.g_miss_char,
102: attribute55 varchar2(240) := fnd_api.g_miss_char,

Line 99: attribute52 varchar2(240) := fnd_api.g_miss_char,

95: attribute48 varchar2(240) := fnd_api.g_miss_char,
96: attribute49 varchar2(240) := fnd_api.g_miss_char,
97: attribute50 varchar2(240) := fnd_api.g_miss_char,
98: attribute51 varchar2(240) := fnd_api.g_miss_char,
99: attribute52 varchar2(240) := fnd_api.g_miss_char,
100: attribute53 varchar2(240) := fnd_api.g_miss_char,
101: attribute54 varchar2(240) := fnd_api.g_miss_char,
102: attribute55 varchar2(240) := fnd_api.g_miss_char,
103: attribute56 varchar2(240) := fnd_api.g_miss_char,

Line 100: attribute53 varchar2(240) := fnd_api.g_miss_char,

96: attribute49 varchar2(240) := fnd_api.g_miss_char,
97: attribute50 varchar2(240) := fnd_api.g_miss_char,
98: attribute51 varchar2(240) := fnd_api.g_miss_char,
99: attribute52 varchar2(240) := fnd_api.g_miss_char,
100: attribute53 varchar2(240) := fnd_api.g_miss_char,
101: attribute54 varchar2(240) := fnd_api.g_miss_char,
102: attribute55 varchar2(240) := fnd_api.g_miss_char,
103: attribute56 varchar2(240) := fnd_api.g_miss_char,
104: attribute57 varchar2(240) := fnd_api.g_miss_char,

Line 101: attribute54 varchar2(240) := fnd_api.g_miss_char,

97: attribute50 varchar2(240) := fnd_api.g_miss_char,
98: attribute51 varchar2(240) := fnd_api.g_miss_char,
99: attribute52 varchar2(240) := fnd_api.g_miss_char,
100: attribute53 varchar2(240) := fnd_api.g_miss_char,
101: attribute54 varchar2(240) := fnd_api.g_miss_char,
102: attribute55 varchar2(240) := fnd_api.g_miss_char,
103: attribute56 varchar2(240) := fnd_api.g_miss_char,
104: attribute57 varchar2(240) := fnd_api.g_miss_char,
105: attribute58 varchar2(240) := fnd_api.g_miss_char,

Line 102: attribute55 varchar2(240) := fnd_api.g_miss_char,

98: attribute51 varchar2(240) := fnd_api.g_miss_char,
99: attribute52 varchar2(240) := fnd_api.g_miss_char,
100: attribute53 varchar2(240) := fnd_api.g_miss_char,
101: attribute54 varchar2(240) := fnd_api.g_miss_char,
102: attribute55 varchar2(240) := fnd_api.g_miss_char,
103: attribute56 varchar2(240) := fnd_api.g_miss_char,
104: attribute57 varchar2(240) := fnd_api.g_miss_char,
105: attribute58 varchar2(240) := fnd_api.g_miss_char,
106: attribute59 varchar2(240) := fnd_api.g_miss_char,

Line 103: attribute56 varchar2(240) := fnd_api.g_miss_char,

99: attribute52 varchar2(240) := fnd_api.g_miss_char,
100: attribute53 varchar2(240) := fnd_api.g_miss_char,
101: attribute54 varchar2(240) := fnd_api.g_miss_char,
102: attribute55 varchar2(240) := fnd_api.g_miss_char,
103: attribute56 varchar2(240) := fnd_api.g_miss_char,
104: attribute57 varchar2(240) := fnd_api.g_miss_char,
105: attribute58 varchar2(240) := fnd_api.g_miss_char,
106: attribute59 varchar2(240) := fnd_api.g_miss_char,
107: attribute60 varchar2(240) := fnd_api.g_miss_char,

Line 104: attribute57 varchar2(240) := fnd_api.g_miss_char,

100: attribute53 varchar2(240) := fnd_api.g_miss_char,
101: attribute54 varchar2(240) := fnd_api.g_miss_char,
102: attribute55 varchar2(240) := fnd_api.g_miss_char,
103: attribute56 varchar2(240) := fnd_api.g_miss_char,
104: attribute57 varchar2(240) := fnd_api.g_miss_char,
105: attribute58 varchar2(240) := fnd_api.g_miss_char,
106: attribute59 varchar2(240) := fnd_api.g_miss_char,
107: attribute60 varchar2(240) := fnd_api.g_miss_char,
108: attribute61 varchar2(240) := fnd_api.g_miss_char,

Line 105: attribute58 varchar2(240) := fnd_api.g_miss_char,

101: attribute54 varchar2(240) := fnd_api.g_miss_char,
102: attribute55 varchar2(240) := fnd_api.g_miss_char,
103: attribute56 varchar2(240) := fnd_api.g_miss_char,
104: attribute57 varchar2(240) := fnd_api.g_miss_char,
105: attribute58 varchar2(240) := fnd_api.g_miss_char,
106: attribute59 varchar2(240) := fnd_api.g_miss_char,
107: attribute60 varchar2(240) := fnd_api.g_miss_char,
108: attribute61 varchar2(240) := fnd_api.g_miss_char,
109: attribute62 varchar2(240) := fnd_api.g_miss_char,

Line 106: attribute59 varchar2(240) := fnd_api.g_miss_char,

102: attribute55 varchar2(240) := fnd_api.g_miss_char,
103: attribute56 varchar2(240) := fnd_api.g_miss_char,
104: attribute57 varchar2(240) := fnd_api.g_miss_char,
105: attribute58 varchar2(240) := fnd_api.g_miss_char,
106: attribute59 varchar2(240) := fnd_api.g_miss_char,
107: attribute60 varchar2(240) := fnd_api.g_miss_char,
108: attribute61 varchar2(240) := fnd_api.g_miss_char,
109: attribute62 varchar2(240) := fnd_api.g_miss_char,
110: attribute63 varchar2(240) := fnd_api.g_miss_char,

Line 107: attribute60 varchar2(240) := fnd_api.g_miss_char,

103: attribute56 varchar2(240) := fnd_api.g_miss_char,
104: attribute57 varchar2(240) := fnd_api.g_miss_char,
105: attribute58 varchar2(240) := fnd_api.g_miss_char,
106: attribute59 varchar2(240) := fnd_api.g_miss_char,
107: attribute60 varchar2(240) := fnd_api.g_miss_char,
108: attribute61 varchar2(240) := fnd_api.g_miss_char,
109: attribute62 varchar2(240) := fnd_api.g_miss_char,
110: attribute63 varchar2(240) := fnd_api.g_miss_char,
111: attribute64 varchar2(240) := fnd_api.g_miss_char,

Line 108: attribute61 varchar2(240) := fnd_api.g_miss_char,

104: attribute57 varchar2(240) := fnd_api.g_miss_char,
105: attribute58 varchar2(240) := fnd_api.g_miss_char,
106: attribute59 varchar2(240) := fnd_api.g_miss_char,
107: attribute60 varchar2(240) := fnd_api.g_miss_char,
108: attribute61 varchar2(240) := fnd_api.g_miss_char,
109: attribute62 varchar2(240) := fnd_api.g_miss_char,
110: attribute63 varchar2(240) := fnd_api.g_miss_char,
111: attribute64 varchar2(240) := fnd_api.g_miss_char,
112: attribute65 varchar2(240) := fnd_api.g_miss_char,

Line 109: attribute62 varchar2(240) := fnd_api.g_miss_char,

105: attribute58 varchar2(240) := fnd_api.g_miss_char,
106: attribute59 varchar2(240) := fnd_api.g_miss_char,
107: attribute60 varchar2(240) := fnd_api.g_miss_char,
108: attribute61 varchar2(240) := fnd_api.g_miss_char,
109: attribute62 varchar2(240) := fnd_api.g_miss_char,
110: attribute63 varchar2(240) := fnd_api.g_miss_char,
111: attribute64 varchar2(240) := fnd_api.g_miss_char,
112: attribute65 varchar2(240) := fnd_api.g_miss_char,
113: attribute66 varchar2(240) := fnd_api.g_miss_char,

Line 110: attribute63 varchar2(240) := fnd_api.g_miss_char,

106: attribute59 varchar2(240) := fnd_api.g_miss_char,
107: attribute60 varchar2(240) := fnd_api.g_miss_char,
108: attribute61 varchar2(240) := fnd_api.g_miss_char,
109: attribute62 varchar2(240) := fnd_api.g_miss_char,
110: attribute63 varchar2(240) := fnd_api.g_miss_char,
111: attribute64 varchar2(240) := fnd_api.g_miss_char,
112: attribute65 varchar2(240) := fnd_api.g_miss_char,
113: attribute66 varchar2(240) := fnd_api.g_miss_char,
114: attribute67 varchar2(240) := fnd_api.g_miss_char,

Line 111: attribute64 varchar2(240) := fnd_api.g_miss_char,

107: attribute60 varchar2(240) := fnd_api.g_miss_char,
108: attribute61 varchar2(240) := fnd_api.g_miss_char,
109: attribute62 varchar2(240) := fnd_api.g_miss_char,
110: attribute63 varchar2(240) := fnd_api.g_miss_char,
111: attribute64 varchar2(240) := fnd_api.g_miss_char,
112: attribute65 varchar2(240) := fnd_api.g_miss_char,
113: attribute66 varchar2(240) := fnd_api.g_miss_char,
114: attribute67 varchar2(240) := fnd_api.g_miss_char,
115: attribute68 varchar2(240) := fnd_api.g_miss_char,

Line 112: attribute65 varchar2(240) := fnd_api.g_miss_char,

108: attribute61 varchar2(240) := fnd_api.g_miss_char,
109: attribute62 varchar2(240) := fnd_api.g_miss_char,
110: attribute63 varchar2(240) := fnd_api.g_miss_char,
111: attribute64 varchar2(240) := fnd_api.g_miss_char,
112: attribute65 varchar2(240) := fnd_api.g_miss_char,
113: attribute66 varchar2(240) := fnd_api.g_miss_char,
114: attribute67 varchar2(240) := fnd_api.g_miss_char,
115: attribute68 varchar2(240) := fnd_api.g_miss_char,
116: attribute69 varchar2(240) := fnd_api.g_miss_char,

Line 113: attribute66 varchar2(240) := fnd_api.g_miss_char,

109: attribute62 varchar2(240) := fnd_api.g_miss_char,
110: attribute63 varchar2(240) := fnd_api.g_miss_char,
111: attribute64 varchar2(240) := fnd_api.g_miss_char,
112: attribute65 varchar2(240) := fnd_api.g_miss_char,
113: attribute66 varchar2(240) := fnd_api.g_miss_char,
114: attribute67 varchar2(240) := fnd_api.g_miss_char,
115: attribute68 varchar2(240) := fnd_api.g_miss_char,
116: attribute69 varchar2(240) := fnd_api.g_miss_char,
117: attribute70 varchar2(240) := fnd_api.g_miss_char,

Line 114: attribute67 varchar2(240) := fnd_api.g_miss_char,

110: attribute63 varchar2(240) := fnd_api.g_miss_char,
111: attribute64 varchar2(240) := fnd_api.g_miss_char,
112: attribute65 varchar2(240) := fnd_api.g_miss_char,
113: attribute66 varchar2(240) := fnd_api.g_miss_char,
114: attribute67 varchar2(240) := fnd_api.g_miss_char,
115: attribute68 varchar2(240) := fnd_api.g_miss_char,
116: attribute69 varchar2(240) := fnd_api.g_miss_char,
117: attribute70 varchar2(240) := fnd_api.g_miss_char,
118: attribute71 varchar2(240) := fnd_api.g_miss_char,

Line 115: attribute68 varchar2(240) := fnd_api.g_miss_char,

111: attribute64 varchar2(240) := fnd_api.g_miss_char,
112: attribute65 varchar2(240) := fnd_api.g_miss_char,
113: attribute66 varchar2(240) := fnd_api.g_miss_char,
114: attribute67 varchar2(240) := fnd_api.g_miss_char,
115: attribute68 varchar2(240) := fnd_api.g_miss_char,
116: attribute69 varchar2(240) := fnd_api.g_miss_char,
117: attribute70 varchar2(240) := fnd_api.g_miss_char,
118: attribute71 varchar2(240) := fnd_api.g_miss_char,
119: attribute72 varchar2(240) := fnd_api.g_miss_char,

Line 116: attribute69 varchar2(240) := fnd_api.g_miss_char,

112: attribute65 varchar2(240) := fnd_api.g_miss_char,
113: attribute66 varchar2(240) := fnd_api.g_miss_char,
114: attribute67 varchar2(240) := fnd_api.g_miss_char,
115: attribute68 varchar2(240) := fnd_api.g_miss_char,
116: attribute69 varchar2(240) := fnd_api.g_miss_char,
117: attribute70 varchar2(240) := fnd_api.g_miss_char,
118: attribute71 varchar2(240) := fnd_api.g_miss_char,
119: attribute72 varchar2(240) := fnd_api.g_miss_char,
120: attribute73 varchar2(240) := fnd_api.g_miss_char,

Line 117: attribute70 varchar2(240) := fnd_api.g_miss_char,

113: attribute66 varchar2(240) := fnd_api.g_miss_char,
114: attribute67 varchar2(240) := fnd_api.g_miss_char,
115: attribute68 varchar2(240) := fnd_api.g_miss_char,
116: attribute69 varchar2(240) := fnd_api.g_miss_char,
117: attribute70 varchar2(240) := fnd_api.g_miss_char,
118: attribute71 varchar2(240) := fnd_api.g_miss_char,
119: attribute72 varchar2(240) := fnd_api.g_miss_char,
120: attribute73 varchar2(240) := fnd_api.g_miss_char,
121: attribute74 varchar2(240) := fnd_api.g_miss_char,

Line 118: attribute71 varchar2(240) := fnd_api.g_miss_char,

114: attribute67 varchar2(240) := fnd_api.g_miss_char,
115: attribute68 varchar2(240) := fnd_api.g_miss_char,
116: attribute69 varchar2(240) := fnd_api.g_miss_char,
117: attribute70 varchar2(240) := fnd_api.g_miss_char,
118: attribute71 varchar2(240) := fnd_api.g_miss_char,
119: attribute72 varchar2(240) := fnd_api.g_miss_char,
120: attribute73 varchar2(240) := fnd_api.g_miss_char,
121: attribute74 varchar2(240) := fnd_api.g_miss_char,
122: attribute75 varchar2(240) := fnd_api.g_miss_char,

Line 119: attribute72 varchar2(240) := fnd_api.g_miss_char,

115: attribute68 varchar2(240) := fnd_api.g_miss_char,
116: attribute69 varchar2(240) := fnd_api.g_miss_char,
117: attribute70 varchar2(240) := fnd_api.g_miss_char,
118: attribute71 varchar2(240) := fnd_api.g_miss_char,
119: attribute72 varchar2(240) := fnd_api.g_miss_char,
120: attribute73 varchar2(240) := fnd_api.g_miss_char,
121: attribute74 varchar2(240) := fnd_api.g_miss_char,
122: attribute75 varchar2(240) := fnd_api.g_miss_char,
123: attribute76 varchar2(240) := fnd_api.g_miss_char,

Line 120: attribute73 varchar2(240) := fnd_api.g_miss_char,

116: attribute69 varchar2(240) := fnd_api.g_miss_char,
117: attribute70 varchar2(240) := fnd_api.g_miss_char,
118: attribute71 varchar2(240) := fnd_api.g_miss_char,
119: attribute72 varchar2(240) := fnd_api.g_miss_char,
120: attribute73 varchar2(240) := fnd_api.g_miss_char,
121: attribute74 varchar2(240) := fnd_api.g_miss_char,
122: attribute75 varchar2(240) := fnd_api.g_miss_char,
123: attribute76 varchar2(240) := fnd_api.g_miss_char,
124: attribute77 varchar2(240) := fnd_api.g_miss_char,

Line 121: attribute74 varchar2(240) := fnd_api.g_miss_char,

117: attribute70 varchar2(240) := fnd_api.g_miss_char,
118: attribute71 varchar2(240) := fnd_api.g_miss_char,
119: attribute72 varchar2(240) := fnd_api.g_miss_char,
120: attribute73 varchar2(240) := fnd_api.g_miss_char,
121: attribute74 varchar2(240) := fnd_api.g_miss_char,
122: attribute75 varchar2(240) := fnd_api.g_miss_char,
123: attribute76 varchar2(240) := fnd_api.g_miss_char,
124: attribute77 varchar2(240) := fnd_api.g_miss_char,
125: attribute78 varchar2(240) := fnd_api.g_miss_char,

Line 122: attribute75 varchar2(240) := fnd_api.g_miss_char,

118: attribute71 varchar2(240) := fnd_api.g_miss_char,
119: attribute72 varchar2(240) := fnd_api.g_miss_char,
120: attribute73 varchar2(240) := fnd_api.g_miss_char,
121: attribute74 varchar2(240) := fnd_api.g_miss_char,
122: attribute75 varchar2(240) := fnd_api.g_miss_char,
123: attribute76 varchar2(240) := fnd_api.g_miss_char,
124: attribute77 varchar2(240) := fnd_api.g_miss_char,
125: attribute78 varchar2(240) := fnd_api.g_miss_char,
126: attribute79 varchar2(240) := fnd_api.g_miss_char,

Line 123: attribute76 varchar2(240) := fnd_api.g_miss_char,

119: attribute72 varchar2(240) := fnd_api.g_miss_char,
120: attribute73 varchar2(240) := fnd_api.g_miss_char,
121: attribute74 varchar2(240) := fnd_api.g_miss_char,
122: attribute75 varchar2(240) := fnd_api.g_miss_char,
123: attribute76 varchar2(240) := fnd_api.g_miss_char,
124: attribute77 varchar2(240) := fnd_api.g_miss_char,
125: attribute78 varchar2(240) := fnd_api.g_miss_char,
126: attribute79 varchar2(240) := fnd_api.g_miss_char,
127: attribute80 varchar2(240) := fnd_api.g_miss_char,

Line 124: attribute77 varchar2(240) := fnd_api.g_miss_char,

120: attribute73 varchar2(240) := fnd_api.g_miss_char,
121: attribute74 varchar2(240) := fnd_api.g_miss_char,
122: attribute75 varchar2(240) := fnd_api.g_miss_char,
123: attribute76 varchar2(240) := fnd_api.g_miss_char,
124: attribute77 varchar2(240) := fnd_api.g_miss_char,
125: attribute78 varchar2(240) := fnd_api.g_miss_char,
126: attribute79 varchar2(240) := fnd_api.g_miss_char,
127: attribute80 varchar2(240) := fnd_api.g_miss_char,
128: attribute81 varchar2(240) := fnd_api.g_miss_char,

Line 125: attribute78 varchar2(240) := fnd_api.g_miss_char,

121: attribute74 varchar2(240) := fnd_api.g_miss_char,
122: attribute75 varchar2(240) := fnd_api.g_miss_char,
123: attribute76 varchar2(240) := fnd_api.g_miss_char,
124: attribute77 varchar2(240) := fnd_api.g_miss_char,
125: attribute78 varchar2(240) := fnd_api.g_miss_char,
126: attribute79 varchar2(240) := fnd_api.g_miss_char,
127: attribute80 varchar2(240) := fnd_api.g_miss_char,
128: attribute81 varchar2(240) := fnd_api.g_miss_char,
129: attribute82 varchar2(240) := fnd_api.g_miss_char,

Line 126: attribute79 varchar2(240) := fnd_api.g_miss_char,

122: attribute75 varchar2(240) := fnd_api.g_miss_char,
123: attribute76 varchar2(240) := fnd_api.g_miss_char,
124: attribute77 varchar2(240) := fnd_api.g_miss_char,
125: attribute78 varchar2(240) := fnd_api.g_miss_char,
126: attribute79 varchar2(240) := fnd_api.g_miss_char,
127: attribute80 varchar2(240) := fnd_api.g_miss_char,
128: attribute81 varchar2(240) := fnd_api.g_miss_char,
129: attribute82 varchar2(240) := fnd_api.g_miss_char,
130: attribute83 varchar2(240) := fnd_api.g_miss_char,

Line 127: attribute80 varchar2(240) := fnd_api.g_miss_char,

123: attribute76 varchar2(240) := fnd_api.g_miss_char,
124: attribute77 varchar2(240) := fnd_api.g_miss_char,
125: attribute78 varchar2(240) := fnd_api.g_miss_char,
126: attribute79 varchar2(240) := fnd_api.g_miss_char,
127: attribute80 varchar2(240) := fnd_api.g_miss_char,
128: attribute81 varchar2(240) := fnd_api.g_miss_char,
129: attribute82 varchar2(240) := fnd_api.g_miss_char,
130: attribute83 varchar2(240) := fnd_api.g_miss_char,
131: attribute84 varchar2(240) := fnd_api.g_miss_char,

Line 128: attribute81 varchar2(240) := fnd_api.g_miss_char,

124: attribute77 varchar2(240) := fnd_api.g_miss_char,
125: attribute78 varchar2(240) := fnd_api.g_miss_char,
126: attribute79 varchar2(240) := fnd_api.g_miss_char,
127: attribute80 varchar2(240) := fnd_api.g_miss_char,
128: attribute81 varchar2(240) := fnd_api.g_miss_char,
129: attribute82 varchar2(240) := fnd_api.g_miss_char,
130: attribute83 varchar2(240) := fnd_api.g_miss_char,
131: attribute84 varchar2(240) := fnd_api.g_miss_char,
132: attribute85 varchar2(240) := fnd_api.g_miss_char,

Line 129: attribute82 varchar2(240) := fnd_api.g_miss_char,

125: attribute78 varchar2(240) := fnd_api.g_miss_char,
126: attribute79 varchar2(240) := fnd_api.g_miss_char,
127: attribute80 varchar2(240) := fnd_api.g_miss_char,
128: attribute81 varchar2(240) := fnd_api.g_miss_char,
129: attribute82 varchar2(240) := fnd_api.g_miss_char,
130: attribute83 varchar2(240) := fnd_api.g_miss_char,
131: attribute84 varchar2(240) := fnd_api.g_miss_char,
132: attribute85 varchar2(240) := fnd_api.g_miss_char,
133: attribute86 varchar2(240) := fnd_api.g_miss_char,

Line 130: attribute83 varchar2(240) := fnd_api.g_miss_char,

126: attribute79 varchar2(240) := fnd_api.g_miss_char,
127: attribute80 varchar2(240) := fnd_api.g_miss_char,
128: attribute81 varchar2(240) := fnd_api.g_miss_char,
129: attribute82 varchar2(240) := fnd_api.g_miss_char,
130: attribute83 varchar2(240) := fnd_api.g_miss_char,
131: attribute84 varchar2(240) := fnd_api.g_miss_char,
132: attribute85 varchar2(240) := fnd_api.g_miss_char,
133: attribute86 varchar2(240) := fnd_api.g_miss_char,
134: attribute87 varchar2(240) := fnd_api.g_miss_char,

Line 131: attribute84 varchar2(240) := fnd_api.g_miss_char,

127: attribute80 varchar2(240) := fnd_api.g_miss_char,
128: attribute81 varchar2(240) := fnd_api.g_miss_char,
129: attribute82 varchar2(240) := fnd_api.g_miss_char,
130: attribute83 varchar2(240) := fnd_api.g_miss_char,
131: attribute84 varchar2(240) := fnd_api.g_miss_char,
132: attribute85 varchar2(240) := fnd_api.g_miss_char,
133: attribute86 varchar2(240) := fnd_api.g_miss_char,
134: attribute87 varchar2(240) := fnd_api.g_miss_char,
135: attribute88 varchar2(240) := fnd_api.g_miss_char,

Line 132: attribute85 varchar2(240) := fnd_api.g_miss_char,

128: attribute81 varchar2(240) := fnd_api.g_miss_char,
129: attribute82 varchar2(240) := fnd_api.g_miss_char,
130: attribute83 varchar2(240) := fnd_api.g_miss_char,
131: attribute84 varchar2(240) := fnd_api.g_miss_char,
132: attribute85 varchar2(240) := fnd_api.g_miss_char,
133: attribute86 varchar2(240) := fnd_api.g_miss_char,
134: attribute87 varchar2(240) := fnd_api.g_miss_char,
135: attribute88 varchar2(240) := fnd_api.g_miss_char,
136: attribute89 varchar2(240) := fnd_api.g_miss_char,

Line 133: attribute86 varchar2(240) := fnd_api.g_miss_char,

129: attribute82 varchar2(240) := fnd_api.g_miss_char,
130: attribute83 varchar2(240) := fnd_api.g_miss_char,
131: attribute84 varchar2(240) := fnd_api.g_miss_char,
132: attribute85 varchar2(240) := fnd_api.g_miss_char,
133: attribute86 varchar2(240) := fnd_api.g_miss_char,
134: attribute87 varchar2(240) := fnd_api.g_miss_char,
135: attribute88 varchar2(240) := fnd_api.g_miss_char,
136: attribute89 varchar2(240) := fnd_api.g_miss_char,
137: attribute90 varchar2(240) := fnd_api.g_miss_char,

Line 134: attribute87 varchar2(240) := fnd_api.g_miss_char,

130: attribute83 varchar2(240) := fnd_api.g_miss_char,
131: attribute84 varchar2(240) := fnd_api.g_miss_char,
132: attribute85 varchar2(240) := fnd_api.g_miss_char,
133: attribute86 varchar2(240) := fnd_api.g_miss_char,
134: attribute87 varchar2(240) := fnd_api.g_miss_char,
135: attribute88 varchar2(240) := fnd_api.g_miss_char,
136: attribute89 varchar2(240) := fnd_api.g_miss_char,
137: attribute90 varchar2(240) := fnd_api.g_miss_char,
138: attribute91 varchar2(240) := fnd_api.g_miss_char,

Line 135: attribute88 varchar2(240) := fnd_api.g_miss_char,

131: attribute84 varchar2(240) := fnd_api.g_miss_char,
132: attribute85 varchar2(240) := fnd_api.g_miss_char,
133: attribute86 varchar2(240) := fnd_api.g_miss_char,
134: attribute87 varchar2(240) := fnd_api.g_miss_char,
135: attribute88 varchar2(240) := fnd_api.g_miss_char,
136: attribute89 varchar2(240) := fnd_api.g_miss_char,
137: attribute90 varchar2(240) := fnd_api.g_miss_char,
138: attribute91 varchar2(240) := fnd_api.g_miss_char,
139: attribute92 varchar2(240) := fnd_api.g_miss_char,

Line 136: attribute89 varchar2(240) := fnd_api.g_miss_char,

132: attribute85 varchar2(240) := fnd_api.g_miss_char,
133: attribute86 varchar2(240) := fnd_api.g_miss_char,
134: attribute87 varchar2(240) := fnd_api.g_miss_char,
135: attribute88 varchar2(240) := fnd_api.g_miss_char,
136: attribute89 varchar2(240) := fnd_api.g_miss_char,
137: attribute90 varchar2(240) := fnd_api.g_miss_char,
138: attribute91 varchar2(240) := fnd_api.g_miss_char,
139: attribute92 varchar2(240) := fnd_api.g_miss_char,
140: attribute93 varchar2(240) := fnd_api.g_miss_char,

Line 137: attribute90 varchar2(240) := fnd_api.g_miss_char,

133: attribute86 varchar2(240) := fnd_api.g_miss_char,
134: attribute87 varchar2(240) := fnd_api.g_miss_char,
135: attribute88 varchar2(240) := fnd_api.g_miss_char,
136: attribute89 varchar2(240) := fnd_api.g_miss_char,
137: attribute90 varchar2(240) := fnd_api.g_miss_char,
138: attribute91 varchar2(240) := fnd_api.g_miss_char,
139: attribute92 varchar2(240) := fnd_api.g_miss_char,
140: attribute93 varchar2(240) := fnd_api.g_miss_char,
141: attribute94 varchar2(240) := fnd_api.g_miss_char,

Line 138: attribute91 varchar2(240) := fnd_api.g_miss_char,

134: attribute87 varchar2(240) := fnd_api.g_miss_char,
135: attribute88 varchar2(240) := fnd_api.g_miss_char,
136: attribute89 varchar2(240) := fnd_api.g_miss_char,
137: attribute90 varchar2(240) := fnd_api.g_miss_char,
138: attribute91 varchar2(240) := fnd_api.g_miss_char,
139: attribute92 varchar2(240) := fnd_api.g_miss_char,
140: attribute93 varchar2(240) := fnd_api.g_miss_char,
141: attribute94 varchar2(240) := fnd_api.g_miss_char,
142: attribute95 varchar2(240) := fnd_api.g_miss_char,

Line 139: attribute92 varchar2(240) := fnd_api.g_miss_char,

135: attribute88 varchar2(240) := fnd_api.g_miss_char,
136: attribute89 varchar2(240) := fnd_api.g_miss_char,
137: attribute90 varchar2(240) := fnd_api.g_miss_char,
138: attribute91 varchar2(240) := fnd_api.g_miss_char,
139: attribute92 varchar2(240) := fnd_api.g_miss_char,
140: attribute93 varchar2(240) := fnd_api.g_miss_char,
141: attribute94 varchar2(240) := fnd_api.g_miss_char,
142: attribute95 varchar2(240) := fnd_api.g_miss_char,
143: attribute96 varchar2(240) := fnd_api.g_miss_char,

Line 140: attribute93 varchar2(240) := fnd_api.g_miss_char,

136: attribute89 varchar2(240) := fnd_api.g_miss_char,
137: attribute90 varchar2(240) := fnd_api.g_miss_char,
138: attribute91 varchar2(240) := fnd_api.g_miss_char,
139: attribute92 varchar2(240) := fnd_api.g_miss_char,
140: attribute93 varchar2(240) := fnd_api.g_miss_char,
141: attribute94 varchar2(240) := fnd_api.g_miss_char,
142: attribute95 varchar2(240) := fnd_api.g_miss_char,
143: attribute96 varchar2(240) := fnd_api.g_miss_char,
144: attribute97 varchar2(240) := fnd_api.g_miss_char,

Line 141: attribute94 varchar2(240) := fnd_api.g_miss_char,

137: attribute90 varchar2(240) := fnd_api.g_miss_char,
138: attribute91 varchar2(240) := fnd_api.g_miss_char,
139: attribute92 varchar2(240) := fnd_api.g_miss_char,
140: attribute93 varchar2(240) := fnd_api.g_miss_char,
141: attribute94 varchar2(240) := fnd_api.g_miss_char,
142: attribute95 varchar2(240) := fnd_api.g_miss_char,
143: attribute96 varchar2(240) := fnd_api.g_miss_char,
144: attribute97 varchar2(240) := fnd_api.g_miss_char,
145: attribute98 varchar2(240) := fnd_api.g_miss_char,

Line 142: attribute95 varchar2(240) := fnd_api.g_miss_char,

138: attribute91 varchar2(240) := fnd_api.g_miss_char,
139: attribute92 varchar2(240) := fnd_api.g_miss_char,
140: attribute93 varchar2(240) := fnd_api.g_miss_char,
141: attribute94 varchar2(240) := fnd_api.g_miss_char,
142: attribute95 varchar2(240) := fnd_api.g_miss_char,
143: attribute96 varchar2(240) := fnd_api.g_miss_char,
144: attribute97 varchar2(240) := fnd_api.g_miss_char,
145: attribute98 varchar2(240) := fnd_api.g_miss_char,
146: attribute99 varchar2(240) := fnd_api.g_miss_char,

Line 143: attribute96 varchar2(240) := fnd_api.g_miss_char,

139: attribute92 varchar2(240) := fnd_api.g_miss_char,
140: attribute93 varchar2(240) := fnd_api.g_miss_char,
141: attribute94 varchar2(240) := fnd_api.g_miss_char,
142: attribute95 varchar2(240) := fnd_api.g_miss_char,
143: attribute96 varchar2(240) := fnd_api.g_miss_char,
144: attribute97 varchar2(240) := fnd_api.g_miss_char,
145: attribute98 varchar2(240) := fnd_api.g_miss_char,
146: attribute99 varchar2(240) := fnd_api.g_miss_char,
147: attribute100 varchar2(240) := fnd_api.g_miss_char,

Line 144: attribute97 varchar2(240) := fnd_api.g_miss_char,

140: attribute93 varchar2(240) := fnd_api.g_miss_char,
141: attribute94 varchar2(240) := fnd_api.g_miss_char,
142: attribute95 varchar2(240) := fnd_api.g_miss_char,
143: attribute96 varchar2(240) := fnd_api.g_miss_char,
144: attribute97 varchar2(240) := fnd_api.g_miss_char,
145: attribute98 varchar2(240) := fnd_api.g_miss_char,
146: attribute99 varchar2(240) := fnd_api.g_miss_char,
147: attribute100 varchar2(240) := fnd_api.g_miss_char,
148: quota_id number := fnd_api.g_miss_num,

Line 145: attribute98 varchar2(240) := fnd_api.g_miss_char,

141: attribute94 varchar2(240) := fnd_api.g_miss_char,
142: attribute95 varchar2(240) := fnd_api.g_miss_char,
143: attribute96 varchar2(240) := fnd_api.g_miss_char,
144: attribute97 varchar2(240) := fnd_api.g_miss_char,
145: attribute98 varchar2(240) := fnd_api.g_miss_char,
146: attribute99 varchar2(240) := fnd_api.g_miss_char,
147: attribute100 varchar2(240) := fnd_api.g_miss_char,
148: quota_id number := fnd_api.g_miss_num,
149: quota_name varchar2(80) := fnd_api.g_miss_char,

Line 146: attribute99 varchar2(240) := fnd_api.g_miss_char,

142: attribute95 varchar2(240) := fnd_api.g_miss_char,
143: attribute96 varchar2(240) := fnd_api.g_miss_char,
144: attribute97 varchar2(240) := fnd_api.g_miss_char,
145: attribute98 varchar2(240) := fnd_api.g_miss_char,
146: attribute99 varchar2(240) := fnd_api.g_miss_char,
147: attribute100 varchar2(240) := fnd_api.g_miss_char,
148: quota_id number := fnd_api.g_miss_num,
149: quota_name varchar2(80) := fnd_api.g_miss_char,
150: revenue_class_id number := fnd_api.g_miss_num,

Line 147: attribute100 varchar2(240) := fnd_api.g_miss_char,

143: attribute96 varchar2(240) := fnd_api.g_miss_char,
144: attribute97 varchar2(240) := fnd_api.g_miss_char,
145: attribute98 varchar2(240) := fnd_api.g_miss_char,
146: attribute99 varchar2(240) := fnd_api.g_miss_char,
147: attribute100 varchar2(240) := fnd_api.g_miss_char,
148: quota_id number := fnd_api.g_miss_num,
149: quota_name varchar2(80) := fnd_api.g_miss_char,
150: revenue_class_id number := fnd_api.g_miss_num,
151: revenue_class_name varchar2(30) := fnd_api.g_miss_char,

Line 148: quota_id number := fnd_api.g_miss_num,

144: attribute97 varchar2(240) := fnd_api.g_miss_char,
145: attribute98 varchar2(240) := fnd_api.g_miss_char,
146: attribute99 varchar2(240) := fnd_api.g_miss_char,
147: attribute100 varchar2(240) := fnd_api.g_miss_char,
148: quota_id number := fnd_api.g_miss_num,
149: quota_name varchar2(80) := fnd_api.g_miss_char,
150: revenue_class_id number := fnd_api.g_miss_num,
151: revenue_class_name varchar2(30) := fnd_api.g_miss_char,
152: trx_batch_name varchar2(30) := fnd_api.g_miss_char,

Line 149: quota_name varchar2(80) := fnd_api.g_miss_char,

145: attribute98 varchar2(240) := fnd_api.g_miss_char,
146: attribute99 varchar2(240) := fnd_api.g_miss_char,
147: attribute100 varchar2(240) := fnd_api.g_miss_char,
148: quota_id number := fnd_api.g_miss_num,
149: quota_name varchar2(80) := fnd_api.g_miss_char,
150: revenue_class_id number := fnd_api.g_miss_num,
151: revenue_class_name varchar2(30) := fnd_api.g_miss_char,
152: trx_batch_name varchar2(30) := fnd_api.g_miss_char,
153: source_trx_number varchar2(80) := fnd_api.g_miss_char,

Line 150: revenue_class_id number := fnd_api.g_miss_num,

146: attribute99 varchar2(240) := fnd_api.g_miss_char,
147: attribute100 varchar2(240) := fnd_api.g_miss_char,
148: quota_id number := fnd_api.g_miss_num,
149: quota_name varchar2(80) := fnd_api.g_miss_char,
150: revenue_class_id number := fnd_api.g_miss_num,
151: revenue_class_name varchar2(30) := fnd_api.g_miss_char,
152: trx_batch_name varchar2(30) := fnd_api.g_miss_char,
153: source_trx_number varchar2(80) := fnd_api.g_miss_char,
154: trx_sales_line_id number := fnd_api.g_miss_num,

Line 151: revenue_class_name varchar2(30) := fnd_api.g_miss_char,

147: attribute100 varchar2(240) := fnd_api.g_miss_char,
148: quota_id number := fnd_api.g_miss_num,
149: quota_name varchar2(80) := fnd_api.g_miss_char,
150: revenue_class_id number := fnd_api.g_miss_num,
151: revenue_class_name varchar2(30) := fnd_api.g_miss_char,
152: trx_batch_name varchar2(30) := fnd_api.g_miss_char,
153: source_trx_number varchar2(80) := fnd_api.g_miss_char,
154: trx_sales_line_id number := fnd_api.g_miss_num,
155: trx_line_id number := fnd_api.g_miss_num,

Line 152: trx_batch_name varchar2(30) := fnd_api.g_miss_char,

148: quota_id number := fnd_api.g_miss_num,
149: quota_name varchar2(80) := fnd_api.g_miss_char,
150: revenue_class_id number := fnd_api.g_miss_num,
151: revenue_class_name varchar2(30) := fnd_api.g_miss_char,
152: trx_batch_name varchar2(30) := fnd_api.g_miss_char,
153: source_trx_number varchar2(80) := fnd_api.g_miss_char,
154: trx_sales_line_id number := fnd_api.g_miss_num,
155: trx_line_id number := fnd_api.g_miss_num,
156: trx_id number := fnd_api.g_miss_num,

Line 153: source_trx_number varchar2(80) := fnd_api.g_miss_char,

149: quota_name varchar2(80) := fnd_api.g_miss_char,
150: revenue_class_id number := fnd_api.g_miss_num,
151: revenue_class_name varchar2(30) := fnd_api.g_miss_char,
152: trx_batch_name varchar2(30) := fnd_api.g_miss_char,
153: source_trx_number varchar2(80) := fnd_api.g_miss_char,
154: trx_sales_line_id number := fnd_api.g_miss_num,
155: trx_line_id number := fnd_api.g_miss_num,
156: trx_id number := fnd_api.g_miss_num,
157: comm_lines_api_id number := fnd_api.g_miss_num,

Line 154: trx_sales_line_id number := fnd_api.g_miss_num,

150: revenue_class_id number := fnd_api.g_miss_num,
151: revenue_class_name varchar2(30) := fnd_api.g_miss_char,
152: trx_batch_name varchar2(30) := fnd_api.g_miss_char,
153: source_trx_number varchar2(80) := fnd_api.g_miss_char,
154: trx_sales_line_id number := fnd_api.g_miss_num,
155: trx_line_id number := fnd_api.g_miss_num,
156: trx_id number := fnd_api.g_miss_num,
157: comm_lines_api_id number := fnd_api.g_miss_num,
158: source_doc_type varchar2(80) := fnd_api.g_miss_char,

Line 155: trx_line_id number := fnd_api.g_miss_num,

151: revenue_class_name varchar2(30) := fnd_api.g_miss_char,
152: trx_batch_name varchar2(30) := fnd_api.g_miss_char,
153: source_trx_number varchar2(80) := fnd_api.g_miss_char,
154: trx_sales_line_id number := fnd_api.g_miss_num,
155: trx_line_id number := fnd_api.g_miss_num,
156: trx_id number := fnd_api.g_miss_num,
157: comm_lines_api_id number := fnd_api.g_miss_num,
158: source_doc_type varchar2(80) := fnd_api.g_miss_char,
159: upside_amount number := fnd_api.g_miss_num,

Line 156: trx_id number := fnd_api.g_miss_num,

152: trx_batch_name varchar2(30) := fnd_api.g_miss_char,
153: source_trx_number varchar2(80) := fnd_api.g_miss_char,
154: trx_sales_line_id number := fnd_api.g_miss_num,
155: trx_line_id number := fnd_api.g_miss_num,
156: trx_id number := fnd_api.g_miss_num,
157: comm_lines_api_id number := fnd_api.g_miss_num,
158: source_doc_type varchar2(80) := fnd_api.g_miss_char,
159: upside_amount number := fnd_api.g_miss_num,
160: upside_quantity number := fnd_api.g_miss_num,

Line 157: comm_lines_api_id number := fnd_api.g_miss_num,

153: source_trx_number varchar2(80) := fnd_api.g_miss_char,
154: trx_sales_line_id number := fnd_api.g_miss_num,
155: trx_line_id number := fnd_api.g_miss_num,
156: trx_id number := fnd_api.g_miss_num,
157: comm_lines_api_id number := fnd_api.g_miss_num,
158: source_doc_type varchar2(80) := fnd_api.g_miss_char,
159: upside_amount number := fnd_api.g_miss_num,
160: upside_quantity number := fnd_api.g_miss_num,
161: uom_code varchar2(3) := fnd_api.g_miss_char,

Line 158: source_doc_type varchar2(80) := fnd_api.g_miss_char,

154: trx_sales_line_id number := fnd_api.g_miss_num,
155: trx_line_id number := fnd_api.g_miss_num,
156: trx_id number := fnd_api.g_miss_num,
157: comm_lines_api_id number := fnd_api.g_miss_num,
158: source_doc_type varchar2(80) := fnd_api.g_miss_char,
159: upside_amount number := fnd_api.g_miss_num,
160: upside_quantity number := fnd_api.g_miss_num,
161: uom_code varchar2(3) := fnd_api.g_miss_char,
162: forecast_id number := fnd_api.g_miss_num,

Line 159: upside_amount number := fnd_api.g_miss_num,

155: trx_line_id number := fnd_api.g_miss_num,
156: trx_id number := fnd_api.g_miss_num,
157: comm_lines_api_id number := fnd_api.g_miss_num,
158: source_doc_type varchar2(80) := fnd_api.g_miss_char,
159: upside_amount number := fnd_api.g_miss_num,
160: upside_quantity number := fnd_api.g_miss_num,
161: uom_code varchar2(3) := fnd_api.g_miss_char,
162: forecast_id number := fnd_api.g_miss_num,
163: program_id number := fnd_api.g_miss_num,

Line 160: upside_quantity number := fnd_api.g_miss_num,

156: trx_id number := fnd_api.g_miss_num,
157: comm_lines_api_id number := fnd_api.g_miss_num,
158: source_doc_type varchar2(80) := fnd_api.g_miss_char,
159: upside_amount number := fnd_api.g_miss_num,
160: upside_quantity number := fnd_api.g_miss_num,
161: uom_code varchar2(3) := fnd_api.g_miss_char,
162: forecast_id number := fnd_api.g_miss_num,
163: program_id number := fnd_api.g_miss_num,
164: request_id number := fnd_api.g_miss_num,

Line 161: uom_code varchar2(3) := fnd_api.g_miss_char,

157: comm_lines_api_id number := fnd_api.g_miss_num,
158: source_doc_type varchar2(80) := fnd_api.g_miss_char,
159: upside_amount number := fnd_api.g_miss_num,
160: upside_quantity number := fnd_api.g_miss_num,
161: uom_code varchar2(3) := fnd_api.g_miss_char,
162: forecast_id number := fnd_api.g_miss_num,
163: program_id number := fnd_api.g_miss_num,
164: request_id number := fnd_api.g_miss_num,
165: program_application_id number := fnd_api.g_miss_num,

Line 162: forecast_id number := fnd_api.g_miss_num,

158: source_doc_type varchar2(80) := fnd_api.g_miss_char,
159: upside_amount number := fnd_api.g_miss_num,
160: upside_quantity number := fnd_api.g_miss_num,
161: uom_code varchar2(3) := fnd_api.g_miss_char,
162: forecast_id number := fnd_api.g_miss_num,
163: program_id number := fnd_api.g_miss_num,
164: request_id number := fnd_api.g_miss_num,
165: program_application_id number := fnd_api.g_miss_num,
166: program_update_date date := fnd_api.g_miss_date,

Line 163: program_id number := fnd_api.g_miss_num,

159: upside_amount number := fnd_api.g_miss_num,
160: upside_quantity number := fnd_api.g_miss_num,
161: uom_code varchar2(3) := fnd_api.g_miss_char,
162: forecast_id number := fnd_api.g_miss_num,
163: program_id number := fnd_api.g_miss_num,
164: request_id number := fnd_api.g_miss_num,
165: program_application_id number := fnd_api.g_miss_num,
166: program_update_date date := fnd_api.g_miss_date,
167: adj_comm_lines_api_id number := fnd_api.g_miss_num,

Line 164: request_id number := fnd_api.g_miss_num,

160: upside_quantity number := fnd_api.g_miss_num,
161: uom_code varchar2(3) := fnd_api.g_miss_char,
162: forecast_id number := fnd_api.g_miss_num,
163: program_id number := fnd_api.g_miss_num,
164: request_id number := fnd_api.g_miss_num,
165: program_application_id number := fnd_api.g_miss_num,
166: program_update_date date := fnd_api.g_miss_date,
167: adj_comm_lines_api_id number := fnd_api.g_miss_num,
168: invoice_number varchar2(20) := fnd_api.g_miss_char,

Line 165: program_application_id number := fnd_api.g_miss_num,

161: uom_code varchar2(3) := fnd_api.g_miss_char,
162: forecast_id number := fnd_api.g_miss_num,
163: program_id number := fnd_api.g_miss_num,
164: request_id number := fnd_api.g_miss_num,
165: program_application_id number := fnd_api.g_miss_num,
166: program_update_date date := fnd_api.g_miss_date,
167: adj_comm_lines_api_id number := fnd_api.g_miss_num,
168: invoice_number varchar2(20) := fnd_api.g_miss_char,
169: invoice_date date := fnd_api.g_miss_date,

Line 166: program_update_date date := fnd_api.g_miss_date,

162: forecast_id number := fnd_api.g_miss_num,
163: program_id number := fnd_api.g_miss_num,
164: request_id number := fnd_api.g_miss_num,
165: program_application_id number := fnd_api.g_miss_num,
166: program_update_date date := fnd_api.g_miss_date,
167: adj_comm_lines_api_id number := fnd_api.g_miss_num,
168: invoice_number varchar2(20) := fnd_api.g_miss_char,
169: invoice_date date := fnd_api.g_miss_date,
170: order_number number := fnd_api.g_miss_num,

Line 167: adj_comm_lines_api_id number := fnd_api.g_miss_num,

163: program_id number := fnd_api.g_miss_num,
164: request_id number := fnd_api.g_miss_num,
165: program_application_id number := fnd_api.g_miss_num,
166: program_update_date date := fnd_api.g_miss_date,
167: adj_comm_lines_api_id number := fnd_api.g_miss_num,
168: invoice_number varchar2(20) := fnd_api.g_miss_char,
169: invoice_date date := fnd_api.g_miss_date,
170: order_number number := fnd_api.g_miss_num,
171: order_date date := fnd_api.g_miss_date,

Line 168: invoice_number varchar2(20) := fnd_api.g_miss_char,

164: request_id number := fnd_api.g_miss_num,
165: program_application_id number := fnd_api.g_miss_num,
166: program_update_date date := fnd_api.g_miss_date,
167: adj_comm_lines_api_id number := fnd_api.g_miss_num,
168: invoice_number varchar2(20) := fnd_api.g_miss_char,
169: invoice_date date := fnd_api.g_miss_date,
170: order_number number := fnd_api.g_miss_num,
171: order_date date := fnd_api.g_miss_date,
172: line_number number := fnd_api.g_miss_num,

Line 169: invoice_date date := fnd_api.g_miss_date,

165: program_application_id number := fnd_api.g_miss_num,
166: program_update_date date := fnd_api.g_miss_date,
167: adj_comm_lines_api_id number := fnd_api.g_miss_num,
168: invoice_number varchar2(20) := fnd_api.g_miss_char,
169: invoice_date date := fnd_api.g_miss_date,
170: order_number number := fnd_api.g_miss_num,
171: order_date date := fnd_api.g_miss_date,
172: line_number number := fnd_api.g_miss_num,
173: customer_id number := fnd_api.g_miss_num,

Line 170: order_number number := fnd_api.g_miss_num,

166: program_update_date date := fnd_api.g_miss_date,
167: adj_comm_lines_api_id number := fnd_api.g_miss_num,
168: invoice_number varchar2(20) := fnd_api.g_miss_char,
169: invoice_date date := fnd_api.g_miss_date,
170: order_number number := fnd_api.g_miss_num,
171: order_date date := fnd_api.g_miss_date,
172: line_number number := fnd_api.g_miss_num,
173: customer_id number := fnd_api.g_miss_num,
174: bill_to_address_id number := fnd_api.g_miss_num,

Line 171: order_date date := fnd_api.g_miss_date,

167: adj_comm_lines_api_id number := fnd_api.g_miss_num,
168: invoice_number varchar2(20) := fnd_api.g_miss_char,
169: invoice_date date := fnd_api.g_miss_date,
170: order_number number := fnd_api.g_miss_num,
171: order_date date := fnd_api.g_miss_date,
172: line_number number := fnd_api.g_miss_num,
173: customer_id number := fnd_api.g_miss_num,
174: bill_to_address_id number := fnd_api.g_miss_num,
175: ship_to_address_id number := fnd_api.g_miss_num,

Line 172: line_number number := fnd_api.g_miss_num,

168: invoice_number varchar2(20) := fnd_api.g_miss_char,
169: invoice_date date := fnd_api.g_miss_date,
170: order_number number := fnd_api.g_miss_num,
171: order_date date := fnd_api.g_miss_date,
172: line_number number := fnd_api.g_miss_num,
173: customer_id number := fnd_api.g_miss_num,
174: bill_to_address_id number := fnd_api.g_miss_num,
175: ship_to_address_id number := fnd_api.g_miss_num,
176: bill_to_contact_id number := fnd_api.g_miss_num,

Line 173: customer_id number := fnd_api.g_miss_num,

169: invoice_date date := fnd_api.g_miss_date,
170: order_number number := fnd_api.g_miss_num,
171: order_date date := fnd_api.g_miss_date,
172: line_number number := fnd_api.g_miss_num,
173: customer_id number := fnd_api.g_miss_num,
174: bill_to_address_id number := fnd_api.g_miss_num,
175: ship_to_address_id number := fnd_api.g_miss_num,
176: bill_to_contact_id number := fnd_api.g_miss_num,
177: ship_to_contact_id number := fnd_api.g_miss_num,

Line 174: bill_to_address_id number := fnd_api.g_miss_num,

170: order_number number := fnd_api.g_miss_num,
171: order_date date := fnd_api.g_miss_date,
172: line_number number := fnd_api.g_miss_num,
173: customer_id number := fnd_api.g_miss_num,
174: bill_to_address_id number := fnd_api.g_miss_num,
175: ship_to_address_id number := fnd_api.g_miss_num,
176: bill_to_contact_id number := fnd_api.g_miss_num,
177: ship_to_contact_id number := fnd_api.g_miss_num,
178: load_status varchar2(30) := fnd_api.g_miss_char,

Line 175: ship_to_address_id number := fnd_api.g_miss_num,

171: order_date date := fnd_api.g_miss_date,
172: line_number number := fnd_api.g_miss_num,
173: customer_id number := fnd_api.g_miss_num,
174: bill_to_address_id number := fnd_api.g_miss_num,
175: ship_to_address_id number := fnd_api.g_miss_num,
176: bill_to_contact_id number := fnd_api.g_miss_num,
177: ship_to_contact_id number := fnd_api.g_miss_num,
178: load_status varchar2(30) := fnd_api.g_miss_char,
179: revenue_type_disp varchar2(80) := fnd_api.g_miss_char,

Line 176: bill_to_contact_id number := fnd_api.g_miss_num,

172: line_number number := fnd_api.g_miss_num,
173: customer_id number := fnd_api.g_miss_num,
174: bill_to_address_id number := fnd_api.g_miss_num,
175: ship_to_address_id number := fnd_api.g_miss_num,
176: bill_to_contact_id number := fnd_api.g_miss_num,
177: ship_to_contact_id number := fnd_api.g_miss_num,
178: load_status varchar2(30) := fnd_api.g_miss_char,
179: revenue_type_disp varchar2(80) := fnd_api.g_miss_char,
180: revenue_type varchar2(15) := fnd_api.g_miss_char,

Line 177: ship_to_contact_id number := fnd_api.g_miss_num,

173: customer_id number := fnd_api.g_miss_num,
174: bill_to_address_id number := fnd_api.g_miss_num,
175: ship_to_address_id number := fnd_api.g_miss_num,
176: bill_to_contact_id number := fnd_api.g_miss_num,
177: ship_to_contact_id number := fnd_api.g_miss_num,
178: load_status varchar2(30) := fnd_api.g_miss_char,
179: revenue_type_disp varchar2(80) := fnd_api.g_miss_char,
180: revenue_type varchar2(15) := fnd_api.g_miss_char,
181: adjust_rollup_flag varchar2(1) := fnd_api.g_miss_char,

Line 178: load_status varchar2(30) := fnd_api.g_miss_char,

174: bill_to_address_id number := fnd_api.g_miss_num,
175: ship_to_address_id number := fnd_api.g_miss_num,
176: bill_to_contact_id number := fnd_api.g_miss_num,
177: ship_to_contact_id number := fnd_api.g_miss_num,
178: load_status varchar2(30) := fnd_api.g_miss_char,
179: revenue_type_disp varchar2(80) := fnd_api.g_miss_char,
180: revenue_type varchar2(15) := fnd_api.g_miss_char,
181: adjust_rollup_flag varchar2(1) := fnd_api.g_miss_char,
182: adjust_date date := fnd_api.g_miss_date,

Line 179: revenue_type_disp varchar2(80) := fnd_api.g_miss_char,

175: ship_to_address_id number := fnd_api.g_miss_num,
176: bill_to_contact_id number := fnd_api.g_miss_num,
177: ship_to_contact_id number := fnd_api.g_miss_num,
178: load_status varchar2(30) := fnd_api.g_miss_char,
179: revenue_type_disp varchar2(80) := fnd_api.g_miss_char,
180: revenue_type varchar2(15) := fnd_api.g_miss_char,
181: adjust_rollup_flag varchar2(1) := fnd_api.g_miss_char,
182: adjust_date date := fnd_api.g_miss_date,
183: adjusted_by varchar2(100) := fnd_api.g_miss_char,

Line 180: revenue_type varchar2(15) := fnd_api.g_miss_char,

176: bill_to_contact_id number := fnd_api.g_miss_num,
177: ship_to_contact_id number := fnd_api.g_miss_num,
178: load_status varchar2(30) := fnd_api.g_miss_char,
179: revenue_type_disp varchar2(80) := fnd_api.g_miss_char,
180: revenue_type varchar2(15) := fnd_api.g_miss_char,
181: adjust_rollup_flag varchar2(1) := fnd_api.g_miss_char,
182: adjust_date date := fnd_api.g_miss_date,
183: adjusted_by varchar2(100) := fnd_api.g_miss_char,
184: adjust_status_disp varchar2(80) := fnd_api.g_miss_char,

Line 181: adjust_rollup_flag varchar2(1) := fnd_api.g_miss_char,

177: ship_to_contact_id number := fnd_api.g_miss_num,
178: load_status varchar2(30) := fnd_api.g_miss_char,
179: revenue_type_disp varchar2(80) := fnd_api.g_miss_char,
180: revenue_type varchar2(15) := fnd_api.g_miss_char,
181: adjust_rollup_flag varchar2(1) := fnd_api.g_miss_char,
182: adjust_date date := fnd_api.g_miss_date,
183: adjusted_by varchar2(100) := fnd_api.g_miss_char,
184: adjust_status_disp varchar2(80) := fnd_api.g_miss_char,
185: adjust_status varchar2(20) := fnd_api.g_miss_char,

Line 182: adjust_date date := fnd_api.g_miss_date,

178: load_status varchar2(30) := fnd_api.g_miss_char,
179: revenue_type_disp varchar2(80) := fnd_api.g_miss_char,
180: revenue_type varchar2(15) := fnd_api.g_miss_char,
181: adjust_rollup_flag varchar2(1) := fnd_api.g_miss_char,
182: adjust_date date := fnd_api.g_miss_date,
183: adjusted_by varchar2(100) := fnd_api.g_miss_char,
184: adjust_status_disp varchar2(80) := fnd_api.g_miss_char,
185: adjust_status varchar2(20) := fnd_api.g_miss_char,
186: adjust_comments varchar2(2000) := fnd_api.g_miss_char,

Line 183: adjusted_by varchar2(100) := fnd_api.g_miss_char,

179: revenue_type_disp varchar2(80) := fnd_api.g_miss_char,
180: revenue_type varchar2(15) := fnd_api.g_miss_char,
181: adjust_rollup_flag varchar2(1) := fnd_api.g_miss_char,
182: adjust_date date := fnd_api.g_miss_date,
183: adjusted_by varchar2(100) := fnd_api.g_miss_char,
184: adjust_status_disp varchar2(80) := fnd_api.g_miss_char,
185: adjust_status varchar2(20) := fnd_api.g_miss_char,
186: adjust_comments varchar2(2000) := fnd_api.g_miss_char,
187: type varchar2(80) := fnd_api.g_miss_char,

Line 184: adjust_status_disp varchar2(80) := fnd_api.g_miss_char,

180: revenue_type varchar2(15) := fnd_api.g_miss_char,
181: adjust_rollup_flag varchar2(1) := fnd_api.g_miss_char,
182: adjust_date date := fnd_api.g_miss_date,
183: adjusted_by varchar2(100) := fnd_api.g_miss_char,
184: adjust_status_disp varchar2(80) := fnd_api.g_miss_char,
185: adjust_status varchar2(20) := fnd_api.g_miss_char,
186: adjust_comments varchar2(2000) := fnd_api.g_miss_char,
187: type varchar2(80) := fnd_api.g_miss_char,
188: pre_processed_code varchar2(30) := fnd_api.g_miss_char,

Line 185: adjust_status varchar2(20) := fnd_api.g_miss_char,

181: adjust_rollup_flag varchar2(1) := fnd_api.g_miss_char,
182: adjust_date date := fnd_api.g_miss_date,
183: adjusted_by varchar2(100) := fnd_api.g_miss_char,
184: adjust_status_disp varchar2(80) := fnd_api.g_miss_char,
185: adjust_status varchar2(20) := fnd_api.g_miss_char,
186: adjust_comments varchar2(2000) := fnd_api.g_miss_char,
187: type varchar2(80) := fnd_api.g_miss_char,
188: pre_processed_code varchar2(30) := fnd_api.g_miss_char,
189: comp_group_id number := fnd_api.g_miss_num,

Line 186: adjust_comments varchar2(2000) := fnd_api.g_miss_char,

182: adjust_date date := fnd_api.g_miss_date,
183: adjusted_by varchar2(100) := fnd_api.g_miss_char,
184: adjust_status_disp varchar2(80) := fnd_api.g_miss_char,
185: adjust_status varchar2(20) := fnd_api.g_miss_char,
186: adjust_comments varchar2(2000) := fnd_api.g_miss_char,
187: type varchar2(80) := fnd_api.g_miss_char,
188: pre_processed_code varchar2(30) := fnd_api.g_miss_char,
189: comp_group_id number := fnd_api.g_miss_num,
190: srp_plan_assign_id number := fnd_api.g_miss_num,

Line 187: type varchar2(80) := fnd_api.g_miss_char,

183: adjusted_by varchar2(100) := fnd_api.g_miss_char,
184: adjust_status_disp varchar2(80) := fnd_api.g_miss_char,
185: adjust_status varchar2(20) := fnd_api.g_miss_char,
186: adjust_comments varchar2(2000) := fnd_api.g_miss_char,
187: type varchar2(80) := fnd_api.g_miss_char,
188: pre_processed_code varchar2(30) := fnd_api.g_miss_char,
189: comp_group_id number := fnd_api.g_miss_num,
190: srp_plan_assign_id number := fnd_api.g_miss_num,
191: role_id number := fnd_api.g_miss_num,

Line 188: pre_processed_code varchar2(30) := fnd_api.g_miss_char,

184: adjust_status_disp varchar2(80) := fnd_api.g_miss_char,
185: adjust_status varchar2(20) := fnd_api.g_miss_char,
186: adjust_comments varchar2(2000) := fnd_api.g_miss_char,
187: type varchar2(80) := fnd_api.g_miss_char,
188: pre_processed_code varchar2(30) := fnd_api.g_miss_char,
189: comp_group_id number := fnd_api.g_miss_num,
190: srp_plan_assign_id number := fnd_api.g_miss_num,
191: role_id number := fnd_api.g_miss_num,
192: sales_channel varchar2(30) := fnd_api.g_miss_char,

Line 189: comp_group_id number := fnd_api.g_miss_num,

185: adjust_status varchar2(20) := fnd_api.g_miss_char,
186: adjust_comments varchar2(2000) := fnd_api.g_miss_char,
187: type varchar2(80) := fnd_api.g_miss_char,
188: pre_processed_code varchar2(30) := fnd_api.g_miss_char,
189: comp_group_id number := fnd_api.g_miss_num,
190: srp_plan_assign_id number := fnd_api.g_miss_num,
191: role_id number := fnd_api.g_miss_num,
192: sales_channel varchar2(30) := fnd_api.g_miss_char,
193: object_version_number number := fnd_api.g_miss_num,

Line 190: srp_plan_assign_id number := fnd_api.g_miss_num,

186: adjust_comments varchar2(2000) := fnd_api.g_miss_char,
187: type varchar2(80) := fnd_api.g_miss_char,
188: pre_processed_code varchar2(30) := fnd_api.g_miss_char,
189: comp_group_id number := fnd_api.g_miss_num,
190: srp_plan_assign_id number := fnd_api.g_miss_num,
191: role_id number := fnd_api.g_miss_num,
192: sales_channel varchar2(30) := fnd_api.g_miss_char,
193: object_version_number number := fnd_api.g_miss_num,
194: split_pct number := fnd_api.g_miss_num,

Line 191: role_id number := fnd_api.g_miss_num,

187: type varchar2(80) := fnd_api.g_miss_char,
188: pre_processed_code varchar2(30) := fnd_api.g_miss_char,
189: comp_group_id number := fnd_api.g_miss_num,
190: srp_plan_assign_id number := fnd_api.g_miss_num,
191: role_id number := fnd_api.g_miss_num,
192: sales_channel varchar2(30) := fnd_api.g_miss_char,
193: object_version_number number := fnd_api.g_miss_num,
194: split_pct number := fnd_api.g_miss_num,
195: split_status varchar2(30) := fnd_api.g_miss_char,

Line 192: sales_channel varchar2(30) := fnd_api.g_miss_char,

188: pre_processed_code varchar2(30) := fnd_api.g_miss_char,
189: comp_group_id number := fnd_api.g_miss_num,
190: srp_plan_assign_id number := fnd_api.g_miss_num,
191: role_id number := fnd_api.g_miss_num,
192: sales_channel varchar2(30) := fnd_api.g_miss_char,
193: object_version_number number := fnd_api.g_miss_num,
194: split_pct number := fnd_api.g_miss_num,
195: split_status varchar2(30) := fnd_api.g_miss_char,
196: commission_amount number := fnd_api.g_miss_num,

Line 193: object_version_number number := fnd_api.g_miss_num,

189: comp_group_id number := fnd_api.g_miss_num,
190: srp_plan_assign_id number := fnd_api.g_miss_num,
191: role_id number := fnd_api.g_miss_num,
192: sales_channel varchar2(30) := fnd_api.g_miss_char,
193: object_version_number number := fnd_api.g_miss_num,
194: split_pct number := fnd_api.g_miss_num,
195: split_status varchar2(30) := fnd_api.g_miss_char,
196: commission_amount number := fnd_api.g_miss_num,
197: role_name varchar2(60) := fnd_api.g_miss_char,

Line 194: split_pct number := fnd_api.g_miss_num,

190: srp_plan_assign_id number := fnd_api.g_miss_num,
191: role_id number := fnd_api.g_miss_num,
192: sales_channel varchar2(30) := fnd_api.g_miss_char,
193: object_version_number number := fnd_api.g_miss_num,
194: split_pct number := fnd_api.g_miss_num,
195: split_status varchar2(30) := fnd_api.g_miss_char,
196: commission_amount number := fnd_api.g_miss_num,
197: role_name varchar2(60) := fnd_api.g_miss_char,
198: comp_group_name varchar2(60) := fnd_api.g_miss_char,

Line 195: split_status varchar2(30) := fnd_api.g_miss_char,

191: role_id number := fnd_api.g_miss_num,
192: sales_channel varchar2(30) := fnd_api.g_miss_char,
193: object_version_number number := fnd_api.g_miss_num,
194: split_pct number := fnd_api.g_miss_num,
195: split_status varchar2(30) := fnd_api.g_miss_char,
196: commission_amount number := fnd_api.g_miss_num,
197: role_name varchar2(60) := fnd_api.g_miss_char,
198: comp_group_name varchar2(60) := fnd_api.g_miss_char,
199: pre_processed_code_disp varchar2(80) := fnd_api.g_miss_char,

Line 196: commission_amount number := fnd_api.g_miss_num,

192: sales_channel varchar2(30) := fnd_api.g_miss_char,
193: object_version_number number := fnd_api.g_miss_num,
194: split_pct number := fnd_api.g_miss_num,
195: split_status varchar2(30) := fnd_api.g_miss_char,
196: commission_amount number := fnd_api.g_miss_num,
197: role_name varchar2(60) := fnd_api.g_miss_char,
198: comp_group_name varchar2(60) := fnd_api.g_miss_char,
199: pre_processed_code_disp varchar2(80) := fnd_api.g_miss_char,
200: customer_name varchar2(50) := fnd_api.g_miss_char,

Line 197: role_name varchar2(60) := fnd_api.g_miss_char,

193: object_version_number number := fnd_api.g_miss_num,
194: split_pct number := fnd_api.g_miss_num,
195: split_status varchar2(30) := fnd_api.g_miss_char,
196: commission_amount number := fnd_api.g_miss_num,
197: role_name varchar2(60) := fnd_api.g_miss_char,
198: comp_group_name varchar2(60) := fnd_api.g_miss_char,
199: pre_processed_code_disp varchar2(80) := fnd_api.g_miss_char,
200: customer_name varchar2(50) := fnd_api.g_miss_char,
201: customer_number varchar2(30) := fnd_api.g_miss_char,

Line 198: comp_group_name varchar2(60) := fnd_api.g_miss_char,

194: split_pct number := fnd_api.g_miss_num,
195: split_status varchar2(30) := fnd_api.g_miss_char,
196: commission_amount number := fnd_api.g_miss_num,
197: role_name varchar2(60) := fnd_api.g_miss_char,
198: comp_group_name varchar2(60) := fnd_api.g_miss_char,
199: pre_processed_code_disp varchar2(80) := fnd_api.g_miss_char,
200: customer_name varchar2(50) := fnd_api.g_miss_char,
201: customer_number varchar2(30) := fnd_api.g_miss_char,
202: inventory_item_id number := fnd_api.g_miss_num,

Line 199: pre_processed_code_disp varchar2(80) := fnd_api.g_miss_char,

195: split_status varchar2(30) := fnd_api.g_miss_char,
196: commission_amount number := fnd_api.g_miss_num,
197: role_name varchar2(60) := fnd_api.g_miss_char,
198: comp_group_name varchar2(60) := fnd_api.g_miss_char,
199: pre_processed_code_disp varchar2(80) := fnd_api.g_miss_char,
200: customer_name varchar2(50) := fnd_api.g_miss_char,
201: customer_number varchar2(30) := fnd_api.g_miss_char,
202: inventory_item_id number := fnd_api.g_miss_num,
203: source_trx_id number := fnd_api.g_miss_num,

Line 200: customer_name varchar2(50) := fnd_api.g_miss_char,

196: commission_amount number := fnd_api.g_miss_num,
197: role_name varchar2(60) := fnd_api.g_miss_char,
198: comp_group_name varchar2(60) := fnd_api.g_miss_char,
199: pre_processed_code_disp varchar2(80) := fnd_api.g_miss_char,
200: customer_name varchar2(50) := fnd_api.g_miss_char,
201: customer_number varchar2(30) := fnd_api.g_miss_char,
202: inventory_item_id number := fnd_api.g_miss_num,
203: source_trx_id number := fnd_api.g_miss_num,
204: source_trx_line_id number := fnd_api.g_miss_num,

Line 201: customer_number varchar2(30) := fnd_api.g_miss_char,

197: role_name varchar2(60) := fnd_api.g_miss_char,
198: comp_group_name varchar2(60) := fnd_api.g_miss_char,
199: pre_processed_code_disp varchar2(80) := fnd_api.g_miss_char,
200: customer_name varchar2(50) := fnd_api.g_miss_char,
201: customer_number varchar2(30) := fnd_api.g_miss_char,
202: inventory_item_id number := fnd_api.g_miss_num,
203: source_trx_id number := fnd_api.g_miss_num,
204: source_trx_line_id number := fnd_api.g_miss_num,
205: source_trx_sales_line_id number := fnd_api.g_miss_num,

Line 202: inventory_item_id number := fnd_api.g_miss_num,

198: comp_group_name varchar2(60) := fnd_api.g_miss_char,
199: pre_processed_code_disp varchar2(80) := fnd_api.g_miss_char,
200: customer_name varchar2(50) := fnd_api.g_miss_char,
201: customer_number varchar2(30) := fnd_api.g_miss_char,
202: inventory_item_id number := fnd_api.g_miss_num,
203: source_trx_id number := fnd_api.g_miss_num,
204: source_trx_line_id number := fnd_api.g_miss_num,
205: source_trx_sales_line_id number := fnd_api.g_miss_num,
206: org_id number := fnd_api.g_miss_num,

Line 203: source_trx_id number := fnd_api.g_miss_num,

199: pre_processed_code_disp varchar2(80) := fnd_api.g_miss_char,
200: customer_name varchar2(50) := fnd_api.g_miss_char,
201: customer_number varchar2(30) := fnd_api.g_miss_char,
202: inventory_item_id number := fnd_api.g_miss_num,
203: source_trx_id number := fnd_api.g_miss_num,
204: source_trx_line_id number := fnd_api.g_miss_num,
205: source_trx_sales_line_id number := fnd_api.g_miss_num,
206: org_id number := fnd_api.g_miss_num,
207: terr_id number := fnd_api.g_miss_num,

Line 204: source_trx_line_id number := fnd_api.g_miss_num,

200: customer_name varchar2(50) := fnd_api.g_miss_char,
201: customer_number varchar2(30) := fnd_api.g_miss_char,
202: inventory_item_id number := fnd_api.g_miss_num,
203: source_trx_id number := fnd_api.g_miss_num,
204: source_trx_line_id number := fnd_api.g_miss_num,
205: source_trx_sales_line_id number := fnd_api.g_miss_num,
206: org_id number := fnd_api.g_miss_num,
207: terr_id number := fnd_api.g_miss_num,
208: preserve_credit_override_flag varchar2(1) := fnd_api.g_miss_char,

Line 205: source_trx_sales_line_id number := fnd_api.g_miss_num,

201: customer_number varchar2(30) := fnd_api.g_miss_char,
202: inventory_item_id number := fnd_api.g_miss_num,
203: source_trx_id number := fnd_api.g_miss_num,
204: source_trx_line_id number := fnd_api.g_miss_num,
205: source_trx_sales_line_id number := fnd_api.g_miss_num,
206: org_id number := fnd_api.g_miss_num,
207: terr_id number := fnd_api.g_miss_num,
208: preserve_credit_override_flag varchar2(1) := fnd_api.g_miss_char,
209: terr_name varchar2(2000) := fnd_api.g_miss_char);

Line 206: org_id number := fnd_api.g_miss_num,

202: inventory_item_id number := fnd_api.g_miss_num,
203: source_trx_id number := fnd_api.g_miss_num,
204: source_trx_line_id number := fnd_api.g_miss_num,
205: source_trx_sales_line_id number := fnd_api.g_miss_num,
206: org_id number := fnd_api.g_miss_num,
207: terr_id number := fnd_api.g_miss_num,
208: preserve_credit_override_flag varchar2(1) := fnd_api.g_miss_char,
209: terr_name varchar2(2000) := fnd_api.g_miss_char);
210:

Line 207: terr_id number := fnd_api.g_miss_num,

203: source_trx_id number := fnd_api.g_miss_num,
204: source_trx_line_id number := fnd_api.g_miss_num,
205: source_trx_sales_line_id number := fnd_api.g_miss_num,
206: org_id number := fnd_api.g_miss_num,
207: terr_id number := fnd_api.g_miss_num,
208: preserve_credit_override_flag varchar2(1) := fnd_api.g_miss_char,
209: terr_name varchar2(2000) := fnd_api.g_miss_char);
210:
211: TYPE adj_tbl_type IS

Line 208: preserve_credit_override_flag varchar2(1) := fnd_api.g_miss_char,

204: source_trx_line_id number := fnd_api.g_miss_num,
205: source_trx_sales_line_id number := fnd_api.g_miss_num,
206: org_id number := fnd_api.g_miss_num,
207: terr_id number := fnd_api.g_miss_num,
208: preserve_credit_override_flag varchar2(1) := fnd_api.g_miss_char,
209: terr_name varchar2(2000) := fnd_api.g_miss_char);
210:
211: TYPE adj_tbl_type IS
212: TABLE OF adj_rec_type INDEX BY BINARY_INTEGER ;

Line 209: terr_name varchar2(2000) := fnd_api.g_miss_char);

205: source_trx_sales_line_id number := fnd_api.g_miss_num,
206: org_id number := fnd_api.g_miss_num,
207: terr_id number := fnd_api.g_miss_num,
208: preserve_credit_override_flag varchar2(1) := fnd_api.g_miss_char,
209: terr_name varchar2(2000) := fnd_api.g_miss_char);
210:
211: TYPE adj_tbl_type IS
212: TABLE OF adj_rec_type INDEX BY BINARY_INTEGER ;
213: --

Line 348: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

344: on the search criteria given in the cntxsum.jsp.
345: --------------------------------------------------------------------------*/
346: PROCEDURE get_adj (
347: p_api_version IN NUMBER,
348: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
349: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
350: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
351: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
352: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,

Line 349: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

345: --------------------------------------------------------------------------*/
346: PROCEDURE get_adj (
347: p_api_version IN NUMBER,
348: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
349: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
350: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
351: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
352: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
353: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,

Line 350: p_org_id IN NUMBER := FND_API.G_MISS_NUM,

346: PROCEDURE get_adj (
347: p_api_version IN NUMBER,
348: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
349: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
350: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
351: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
352: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
353: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
354: p_calc_status IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 351: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,

347: p_api_version IN NUMBER,
348: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
349: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
350: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
351: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
352: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
353: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
354: p_calc_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
355: p_adj_status IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 352: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,

348: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
349: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
350: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
351: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
352: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
353: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
354: p_calc_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
355: p_adj_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
356: p_load_status IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 353: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,

349: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
350: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
351: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
352: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
353: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
354: p_calc_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
355: p_adj_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
356: p_load_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
357: p_invoice_num IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 354: p_calc_status IN VARCHAR2 := FND_API.G_MISS_CHAR,

350: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
351: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
352: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
353: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
354: p_calc_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
355: p_adj_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
356: p_load_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
357: p_invoice_num IN VARCHAR2 := FND_API.G_MISS_CHAR,
358: p_order_num IN NUMBER := FND_API.G_MISS_NUM,

Line 355: p_adj_status IN VARCHAR2 := FND_API.G_MISS_CHAR,

351: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
352: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
353: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
354: p_calc_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
355: p_adj_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
356: p_load_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
357: p_invoice_num IN VARCHAR2 := FND_API.G_MISS_CHAR,
358: p_order_num IN NUMBER := FND_API.G_MISS_NUM,
359: p_srch_attr_rec IN adj_rec_type,

Line 356: p_load_status IN VARCHAR2 := FND_API.G_MISS_CHAR,

352: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
353: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
354: p_calc_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
355: p_adj_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
356: p_load_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
357: p_invoice_num IN VARCHAR2 := FND_API.G_MISS_CHAR,
358: p_order_num IN NUMBER := FND_API.G_MISS_NUM,
359: p_srch_attr_rec IN adj_rec_type,
360: p_first IN NUMBER,

Line 357: p_invoice_num IN VARCHAR2 := FND_API.G_MISS_CHAR,

353: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
354: p_calc_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
355: p_adj_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
356: p_load_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
357: p_invoice_num IN VARCHAR2 := FND_API.G_MISS_CHAR,
358: p_order_num IN NUMBER := FND_API.G_MISS_NUM,
359: p_srch_attr_rec IN adj_rec_type,
360: p_first IN NUMBER,
361: p_last IN NUMBER,

Line 358: p_order_num IN NUMBER := FND_API.G_MISS_NUM,

354: p_calc_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
355: p_adj_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
356: p_load_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
357: p_invoice_num IN VARCHAR2 := FND_API.G_MISS_CHAR,
358: p_order_num IN NUMBER := FND_API.G_MISS_NUM,
359: p_srch_attr_rec IN adj_rec_type,
360: p_first IN NUMBER,
361: p_last IN NUMBER,
362: x_return_status OUT NOCOPY VARCHAR2,

Line 371: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

367: x_adj_count OUT NOCOPY NUMBER,
368: x_valid_trx_count OUT NOCOPY NUMBER);
369: PROCEDURE get_split_data(
370: p_api_version IN NUMBER,
371: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
372: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
373: p_comm_lines_api_id IN NUMBER DEFAULT NULL,
374: p_load_status IN VARCHAR2 DEFAULT NULL,
375: x_return_status OUT NOCOPY VARCHAR2,

Line 372: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

368: x_valid_trx_count OUT NOCOPY NUMBER);
369: PROCEDURE get_split_data(
370: p_api_version IN NUMBER,
371: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
372: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
373: p_comm_lines_api_id IN NUMBER DEFAULT NULL,
374: p_load_status IN VARCHAR2 DEFAULT NULL,
375: x_return_status OUT NOCOPY VARCHAR2,
376: x_msg_count OUT NOCOPY NUMBER,

Line 397: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

393: Notes :
394: --------------------------------------------------------------------------*/
395: PROCEDURE insert_api_record(
396: p_api_version IN NUMBER,
397: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
398: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
399: p_action IN VARCHAR2 DEFAULT NULL,
400: p_newtx_rec IN adj_rec_type,
401: x_api_id OUT NOCOPY NUMBER,

Line 398: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

394: --------------------------------------------------------------------------*/
395: PROCEDURE insert_api_record(
396: p_api_version IN NUMBER,
397: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
398: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
399: p_action IN VARCHAR2 DEFAULT NULL,
400: p_newtx_rec IN adj_rec_type,
401: x_api_id OUT NOCOPY NUMBER,
402: x_return_status OUT NOCOPY VARCHAR2,

Line 428: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

424: Notes :
425: --------------------------------------------------------------------------*/
426: PROCEDURE call_mass_update (
427: p_api_version IN NUMBER,
428: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
429: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
430: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
431: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
432: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,

Line 429: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

425: --------------------------------------------------------------------------*/
426: PROCEDURE call_mass_update (
427: p_api_version IN NUMBER,
428: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
429: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
430: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
431: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
432: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
433: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,

Line 430: p_org_id IN NUMBER := FND_API.G_MISS_NUM,

426: PROCEDURE call_mass_update (
427: p_api_version IN NUMBER,
428: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
429: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
430: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
431: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
432: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
433: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
434: p_calc_status IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 431: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,

427: p_api_version IN NUMBER,
428: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
429: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
430: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
431: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
432: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
433: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
434: p_calc_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
435: p_adj_status IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 432: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,

428: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
429: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
430: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
431: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
432: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
433: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
434: p_calc_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
435: p_adj_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
436: p_load_status IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 433: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,

429: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
430: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
431: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
432: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
433: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
434: p_calc_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
435: p_adj_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
436: p_load_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
437: p_invoice_num IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 434: p_calc_status IN VARCHAR2 := FND_API.G_MISS_CHAR,

430: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
431: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
432: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
433: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
434: p_calc_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
435: p_adj_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
436: p_load_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
437: p_invoice_num IN VARCHAR2 := FND_API.G_MISS_CHAR,
438: p_order_num IN NUMBER := FND_API.G_MISS_NUM,

Line 435: p_adj_status IN VARCHAR2 := FND_API.G_MISS_CHAR,

431: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
432: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
433: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
434: p_calc_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
435: p_adj_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
436: p_load_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
437: p_invoice_num IN VARCHAR2 := FND_API.G_MISS_CHAR,
438: p_order_num IN NUMBER := FND_API.G_MISS_NUM,
439: p_srch_attr_rec IN adj_rec_type,

Line 436: p_load_status IN VARCHAR2 := FND_API.G_MISS_CHAR,

432: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
433: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
434: p_calc_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
435: p_adj_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
436: p_load_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
437: p_invoice_num IN VARCHAR2 := FND_API.G_MISS_CHAR,
438: p_order_num IN NUMBER := FND_API.G_MISS_NUM,
439: p_srch_attr_rec IN adj_rec_type,
440: p_mass_adj_type IN VARCHAR2 DEFAULT NULL,

Line 437: p_invoice_num IN VARCHAR2 := FND_API.G_MISS_CHAR,

433: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
434: p_calc_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
435: p_adj_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
436: p_load_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
437: p_invoice_num IN VARCHAR2 := FND_API.G_MISS_CHAR,
438: p_order_num IN NUMBER := FND_API.G_MISS_NUM,
439: p_srch_attr_rec IN adj_rec_type,
440: p_mass_adj_type IN VARCHAR2 DEFAULT NULL,
441: p_adj_rec IN adj_rec_type,

Line 438: p_order_num IN NUMBER := FND_API.G_MISS_NUM,

434: p_calc_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
435: p_adj_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
436: p_load_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
437: p_invoice_num IN VARCHAR2 := FND_API.G_MISS_CHAR,
438: p_order_num IN NUMBER := FND_API.G_MISS_NUM,
439: p_srch_attr_rec IN adj_rec_type,
440: p_mass_adj_type IN VARCHAR2 DEFAULT NULL,
441: p_adj_rec IN adj_rec_type,
442: x_return_status OUT NOCOPY VARCHAR2,

Line 459: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

455: Notes :
456: --------------------------------------------------------------------------*/
457: PROCEDURE call_deal_assign(
458: p_api_version IN NUMBER,
459: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
460: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
461: p_from_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
462: p_to_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
463: p_invoice_number IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 460: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

456: --------------------------------------------------------------------------*/
457: PROCEDURE call_deal_assign(
458: p_api_version IN NUMBER,
459: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
460: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
461: p_from_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
462: p_to_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
463: p_invoice_number IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_order_number IN NUMBER := FND_API.G_MISS_NUM,

Line 461: p_from_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,

457: PROCEDURE call_deal_assign(
458: p_api_version IN NUMBER,
459: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
460: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
461: p_from_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
462: p_to_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
463: p_invoice_number IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_order_number IN NUMBER := FND_API.G_MISS_NUM,
465: p_adjusted_by IN VARCHAR2 := FND_GLOBAL.USER_NAME,

Line 462: p_to_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,

458: p_api_version IN NUMBER,
459: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
460: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
461: p_from_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
462: p_to_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
463: p_invoice_number IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_order_number IN NUMBER := FND_API.G_MISS_NUM,
465: p_adjusted_by IN VARCHAR2 := FND_GLOBAL.USER_NAME,
466: p_adjust_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 463: p_invoice_number IN VARCHAR2 := FND_API.G_MISS_CHAR,

459: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
460: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
461: p_from_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
462: p_to_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
463: p_invoice_number IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_order_number IN NUMBER := FND_API.G_MISS_NUM,
465: p_adjusted_by IN VARCHAR2 := FND_GLOBAL.USER_NAME,
466: p_adjust_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
467: x_return_status OUT NOCOPY VARCHAR2,

Line 464: p_order_number IN NUMBER := FND_API.G_MISS_NUM,

460: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
461: p_from_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
462: p_to_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
463: p_invoice_number IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_order_number IN NUMBER := FND_API.G_MISS_NUM,
465: p_adjusted_by IN VARCHAR2 := FND_GLOBAL.USER_NAME,
466: p_adjust_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
467: x_return_status OUT NOCOPY VARCHAR2,
468: x_msg_count OUT NOCOPY NUMBER,

Line 466: p_adjust_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,

462: p_to_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
463: p_invoice_number IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_order_number IN NUMBER := FND_API.G_MISS_NUM,
465: p_adjusted_by IN VARCHAR2 := FND_GLOBAL.USER_NAME,
466: p_adjust_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
467: x_return_status OUT NOCOPY VARCHAR2,
468: x_msg_count OUT NOCOPY NUMBER,
469: x_msg_data OUT NOCOPY VARCHAR2,
470: x_loading_status OUT NOCOPY VARCHAR2);

Line 492: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

488: Notes :
489: --------------------------------------------------------------------------*/
490: PROCEDURE call_split(
491: p_api_version IN NUMBER,
492: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
493: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
494: p_split_type IN VARCHAR2,
495: p_from_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
496: p_split_data_tbl IN split_data_tbl,

Line 493: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

489: --------------------------------------------------------------------------*/
490: PROCEDURE call_split(
491: p_api_version IN NUMBER,
492: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
493: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
494: p_split_type IN VARCHAR2,
495: p_from_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
496: p_split_data_tbl IN split_data_tbl,
497: p_comm_lines_api_id IN NUMBER := FND_API.G_MISS_NUM,

Line 495: p_from_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,

491: p_api_version IN NUMBER,
492: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
493: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
494: p_split_type IN VARCHAR2,
495: p_from_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
496: p_split_data_tbl IN split_data_tbl,
497: p_comm_lines_api_id IN NUMBER := FND_API.G_MISS_NUM,
498: p_invoice_number IN VARCHAR2 := FND_API.G_MISS_CHAR,
499: p_order_number IN NUMBER := FND_API.G_MISS_NUM,

Line 497: p_comm_lines_api_id IN NUMBER := FND_API.G_MISS_NUM,

493: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
494: p_split_type IN VARCHAR2,
495: p_from_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
496: p_split_data_tbl IN split_data_tbl,
497: p_comm_lines_api_id IN NUMBER := FND_API.G_MISS_NUM,
498: p_invoice_number IN VARCHAR2 := FND_API.G_MISS_CHAR,
499: p_order_number IN NUMBER := FND_API.G_MISS_NUM,
500: p_transaction_amount IN NUMBER,
501: p_adjusted_by IN VARCHAR2 := FND_GLOBAL.USER_NAME,

Line 498: p_invoice_number IN VARCHAR2 := FND_API.G_MISS_CHAR,

494: p_split_type IN VARCHAR2,
495: p_from_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
496: p_split_data_tbl IN split_data_tbl,
497: p_comm_lines_api_id IN NUMBER := FND_API.G_MISS_NUM,
498: p_invoice_number IN VARCHAR2 := FND_API.G_MISS_CHAR,
499: p_order_number IN NUMBER := FND_API.G_MISS_NUM,
500: p_transaction_amount IN NUMBER,
501: p_adjusted_by IN VARCHAR2 := FND_GLOBAL.USER_NAME,
502: p_adjust_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 499: p_order_number IN NUMBER := FND_API.G_MISS_NUM,

495: p_from_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
496: p_split_data_tbl IN split_data_tbl,
497: p_comm_lines_api_id IN NUMBER := FND_API.G_MISS_NUM,
498: p_invoice_number IN VARCHAR2 := FND_API.G_MISS_CHAR,
499: p_order_number IN NUMBER := FND_API.G_MISS_NUM,
500: p_transaction_amount IN NUMBER,
501: p_adjusted_by IN VARCHAR2 := FND_GLOBAL.USER_NAME,
502: p_adjust_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
503: p_org_id IN NUMBER := FND_API.G_MISS_NUM,

Line 502: p_adjust_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,

498: p_invoice_number IN VARCHAR2 := FND_API.G_MISS_CHAR,
499: p_order_number IN NUMBER := FND_API.G_MISS_NUM,
500: p_transaction_amount IN NUMBER,
501: p_adjusted_by IN VARCHAR2 := FND_GLOBAL.USER_NAME,
502: p_adjust_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
503: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
504: x_return_status OUT NOCOPY VARCHAR2,
505: x_msg_count OUT NOCOPY NUMBER,
506: x_msg_data OUT NOCOPY VARCHAR2,

Line 503: p_org_id IN NUMBER := FND_API.G_MISS_NUM,

499: p_order_number IN NUMBER := FND_API.G_MISS_NUM,
500: p_transaction_amount IN NUMBER,
501: p_adjusted_by IN VARCHAR2 := FND_GLOBAL.USER_NAME,
502: p_adjust_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
503: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
504: x_return_status OUT NOCOPY VARCHAR2,
505: x_msg_count OUT NOCOPY NUMBER,
506: x_msg_data OUT NOCOPY VARCHAR2,
507: x_loading_status OUT NOCOPY VARCHAR2);

Line 527: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

523: Notes :
524: --------------------------------------------------------------------------*/
525: PROCEDURE get_trx_lines(
526: p_api_version IN NUMBER,
527: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
528: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
529: p_header_id IN NUMBER := FND_API.G_MISS_NUM,
530: x_return_status OUT NOCOPY VARCHAR2,
531: x_msg_count OUT NOCOPY NUMBER,

Line 528: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

524: --------------------------------------------------------------------------*/
525: PROCEDURE get_trx_lines(
526: p_api_version IN NUMBER,
527: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
528: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
529: p_header_id IN NUMBER := FND_API.G_MISS_NUM,
530: x_return_status OUT NOCOPY VARCHAR2,
531: x_msg_count OUT NOCOPY NUMBER,
532: x_msg_data OUT NOCOPY VARCHAR2,

Line 529: p_header_id IN NUMBER := FND_API.G_MISS_NUM,

525: PROCEDURE get_trx_lines(
526: p_api_version IN NUMBER,
527: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
528: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
529: p_header_id IN NUMBER := FND_API.G_MISS_NUM,
530: x_return_status OUT NOCOPY VARCHAR2,
531: x_msg_count OUT NOCOPY NUMBER,
532: x_msg_data OUT NOCOPY VARCHAR2,
533: x_loading_status OUT NOCOPY VARCHAR2,

Line 555: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

551: Notes :
552: --------------------------------------------------------------------------*/
553: PROCEDURE get_trx_history(
554: p_api_version IN NUMBER,
555: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
556: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
557: p_adj_comm_lines_api_id IN NUMBER := FND_API.G_MISS_NUM,
558: x_return_status OUT NOCOPY VARCHAR2,
559: x_msg_count OUT NOCOPY NUMBER,

Line 556: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

552: --------------------------------------------------------------------------*/
553: PROCEDURE get_trx_history(
554: p_api_version IN NUMBER,
555: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
556: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
557: p_adj_comm_lines_api_id IN NUMBER := FND_API.G_MISS_NUM,
558: x_return_status OUT NOCOPY VARCHAR2,
559: x_msg_count OUT NOCOPY NUMBER,
560: x_msg_data OUT NOCOPY VARCHAR2,

Line 557: p_adj_comm_lines_api_id IN NUMBER := FND_API.G_MISS_NUM,

553: PROCEDURE get_trx_history(
554: p_api_version IN NUMBER,
555: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
556: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
557: p_adj_comm_lines_api_id IN NUMBER := FND_API.G_MISS_NUM,
558: x_return_status OUT NOCOPY VARCHAR2,
559: x_msg_count OUT NOCOPY NUMBER,
560: x_msg_data OUT NOCOPY VARCHAR2,
561: x_loading_status OUT NOCOPY VARCHAR2,

Line 582: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

578: Notes :
579: --------------------------------------------------------------------------*/
580: PROCEDURE get_cust_info(
581: p_api_version IN NUMBER,
582: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
583: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
584: p_comm_lines_api_id IN NUMBER,
585: p_load_status IN VARCHAR2,
586: x_return_status OUT NOCOPY VARCHAR2,

Line 583: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

579: --------------------------------------------------------------------------*/
580: PROCEDURE get_cust_info(
581: p_api_version IN NUMBER,
582: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
583: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
584: p_comm_lines_api_id IN NUMBER,
585: p_load_status IN VARCHAR2,
586: x_return_status OUT NOCOPY VARCHAR2,
587: x_msg_count OUT NOCOPY NUMBER,

Line 606: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

602: Notes :
603: --------------------------------------------------------------------------*/
604: PROCEDURE update_api_record(
605: p_api_version IN NUMBER,
606: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
607: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
608: p_newtx_rec IN adj_rec_type,
609: x_api_id OUT NOCOPY NUMBER,
610: x_return_status OUT NOCOPY VARCHAR2,

Line 607: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

603: --------------------------------------------------------------------------*/
604: PROCEDURE update_api_record(
605: p_api_version IN NUMBER,
606: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
607: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
608: p_newtx_rec IN adj_rec_type,
609: x_api_id OUT NOCOPY NUMBER,
610: x_return_status OUT NOCOPY VARCHAR2,
611: x_msg_count OUT NOCOPY NUMBER,

Line 632: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

628: Notes :
629: --------------------------------------------------------------------------*/
630: PROCEDURE call_load(
631: p_api_version IN NUMBER,
632: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
633: p_commit IN VARCHAR2 := FND_API.G_FALSE,
634: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
635: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
636: p_pr_date_from IN DATE,

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

629: --------------------------------------------------------------------------*/
630: PROCEDURE call_load(
631: p_api_version IN NUMBER,
632: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
633: p_commit IN VARCHAR2 := FND_API.G_FALSE,
634: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
635: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
636: p_pr_date_from IN DATE,
637: p_pr_date_to IN DATE,

Line 634: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

630: PROCEDURE call_load(
631: p_api_version IN NUMBER,
632: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
633: p_commit IN VARCHAR2 := FND_API.G_FALSE,
634: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
635: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
636: p_pr_date_from IN DATE,
637: p_pr_date_to IN DATE,
638: p_cls_rol_flag IN CHAR,

Line 635: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,

631: p_api_version IN NUMBER,
632: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
633: p_commit IN VARCHAR2 := FND_API.G_FALSE,
634: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
635: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
636: p_pr_date_from IN DATE,
637: p_pr_date_to IN DATE,
638: p_cls_rol_flag IN CHAR,
639: p_load_method IN VARCHAR2,