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

APPS.CN_REASONS_PUB dependencies on FND_API

Line 28: payment_worksheet_id number := fnd_api.g_miss_num,

24: -- History
25: -- 04/02/02 Rao.Chenna Created
26: -- 06/16/03 Julia Huang Added show_last_analyst_note for 11.5.10
27: TYPE worksheet_rec IS RECORD(
28: payment_worksheet_id number := fnd_api.g_miss_num,
29: role_id number := fnd_api.g_miss_num,
30: worksheet_status varchar2(30) := fnd_api.g_miss_char,
31: payrun_name varchar2(80) := fnd_api.g_miss_char,
32: payrun_id number := fnd_api.g_miss_num,

Line 29: role_id number := fnd_api.g_miss_num,

25: -- 04/02/02 Rao.Chenna Created
26: -- 06/16/03 Julia Huang Added show_last_analyst_note for 11.5.10
27: TYPE worksheet_rec IS RECORD(
28: payment_worksheet_id number := fnd_api.g_miss_num,
29: role_id number := fnd_api.g_miss_num,
30: worksheet_status varchar2(30) := fnd_api.g_miss_char,
31: payrun_name varchar2(80) := fnd_api.g_miss_char,
32: payrun_id number := fnd_api.g_miss_num,
33: pay_period_id number := fnd_api.g_miss_num,

Line 30: worksheet_status varchar2(30) := fnd_api.g_miss_char,

26: -- 06/16/03 Julia Huang Added show_last_analyst_note for 11.5.10
27: TYPE worksheet_rec IS RECORD(
28: payment_worksheet_id number := fnd_api.g_miss_num,
29: role_id number := fnd_api.g_miss_num,
30: worksheet_status varchar2(30) := fnd_api.g_miss_char,
31: payrun_name varchar2(80) := fnd_api.g_miss_char,
32: payrun_id number := fnd_api.g_miss_num,
33: pay_period_id number := fnd_api.g_miss_num,
34: payrun_status varchar2(80) := fnd_api.g_miss_char,

Line 31: payrun_name varchar2(80) := fnd_api.g_miss_char,

27: TYPE worksheet_rec IS RECORD(
28: payment_worksheet_id number := fnd_api.g_miss_num,
29: role_id number := fnd_api.g_miss_num,
30: worksheet_status varchar2(30) := fnd_api.g_miss_char,
31: payrun_name varchar2(80) := fnd_api.g_miss_char,
32: payrun_id number := fnd_api.g_miss_num,
33: pay_period_id number := fnd_api.g_miss_num,
34: payrun_status varchar2(80) := fnd_api.g_miss_char,
35: period_name varchar2(30) := fnd_api.g_miss_char,

Line 32: payrun_id number := fnd_api.g_miss_num,

28: payment_worksheet_id number := fnd_api.g_miss_num,
29: role_id number := fnd_api.g_miss_num,
30: worksheet_status varchar2(30) := fnd_api.g_miss_char,
31: payrun_name varchar2(80) := fnd_api.g_miss_char,
32: payrun_id number := fnd_api.g_miss_num,
33: pay_period_id number := fnd_api.g_miss_num,
34: payrun_status varchar2(80) := fnd_api.g_miss_char,
35: period_name varchar2(30) := fnd_api.g_miss_char,
36: salesrep_id number := fnd_api.g_miss_num,

Line 33: pay_period_id number := fnd_api.g_miss_num,

29: role_id number := fnd_api.g_miss_num,
30: worksheet_status varchar2(30) := fnd_api.g_miss_char,
31: payrun_name varchar2(80) := fnd_api.g_miss_char,
32: payrun_id number := fnd_api.g_miss_num,
33: pay_period_id number := fnd_api.g_miss_num,
34: payrun_status varchar2(80) := fnd_api.g_miss_char,
35: period_name varchar2(30) := fnd_api.g_miss_char,
36: salesrep_id number := fnd_api.g_miss_num,
37: resource_id number := fnd_api.g_miss_num,

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

30: worksheet_status varchar2(30) := fnd_api.g_miss_char,
31: payrun_name varchar2(80) := fnd_api.g_miss_char,
32: payrun_id number := fnd_api.g_miss_num,
33: pay_period_id number := fnd_api.g_miss_num,
34: payrun_status varchar2(80) := fnd_api.g_miss_char,
35: period_name varchar2(30) := fnd_api.g_miss_char,
36: salesrep_id number := fnd_api.g_miss_num,
37: resource_id number := fnd_api.g_miss_num,
38: salesrep_name varchar2(360) := fnd_api.g_miss_char,

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

31: payrun_name varchar2(80) := fnd_api.g_miss_char,
32: payrun_id number := fnd_api.g_miss_num,
33: pay_period_id number := fnd_api.g_miss_num,
34: payrun_status varchar2(80) := fnd_api.g_miss_char,
35: period_name varchar2(30) := fnd_api.g_miss_char,
36: salesrep_id number := fnd_api.g_miss_num,
37: resource_id number := fnd_api.g_miss_num,
38: salesrep_name varchar2(360) := fnd_api.g_miss_char,
39: employee_number varchar2(30) := fnd_api.g_miss_char,

Line 36: salesrep_id number := fnd_api.g_miss_num,

32: payrun_id number := fnd_api.g_miss_num,
33: pay_period_id number := fnd_api.g_miss_num,
34: payrun_status varchar2(80) := fnd_api.g_miss_char,
35: period_name varchar2(30) := fnd_api.g_miss_char,
36: salesrep_id number := fnd_api.g_miss_num,
37: resource_id number := fnd_api.g_miss_num,
38: salesrep_name varchar2(360) := fnd_api.g_miss_char,
39: employee_number varchar2(30) := fnd_api.g_miss_char,
40: pay_group_id number := fnd_api.g_miss_num,

Line 37: resource_id number := fnd_api.g_miss_num,

33: pay_period_id number := fnd_api.g_miss_num,
34: payrun_status varchar2(80) := fnd_api.g_miss_char,
35: period_name varchar2(30) := fnd_api.g_miss_char,
36: salesrep_id number := fnd_api.g_miss_num,
37: resource_id number := fnd_api.g_miss_num,
38: salesrep_name varchar2(360) := fnd_api.g_miss_char,
39: employee_number varchar2(30) := fnd_api.g_miss_char,
40: pay_group_id number := fnd_api.g_miss_num,
41: pay_group_name varchar2(80) := fnd_api.g_miss_char);

Line 38: salesrep_name varchar2(360) := fnd_api.g_miss_char,

34: payrun_status varchar2(80) := fnd_api.g_miss_char,
35: period_name varchar2(30) := fnd_api.g_miss_char,
36: salesrep_id number := fnd_api.g_miss_num,
37: resource_id number := fnd_api.g_miss_num,
38: salesrep_name varchar2(360) := fnd_api.g_miss_char,
39: employee_number varchar2(30) := fnd_api.g_miss_char,
40: pay_group_id number := fnd_api.g_miss_num,
41: pay_group_name varchar2(80) := fnd_api.g_miss_char);
42: --

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

35: period_name varchar2(30) := fnd_api.g_miss_char,
36: salesrep_id number := fnd_api.g_miss_num,
37: resource_id number := fnd_api.g_miss_num,
38: salesrep_name varchar2(360) := fnd_api.g_miss_char,
39: employee_number varchar2(30) := fnd_api.g_miss_char,
40: pay_group_id number := fnd_api.g_miss_num,
41: pay_group_name varchar2(80) := fnd_api.g_miss_char);
42: --
43: TYPE notes_rec IS RECORD(

Line 40: pay_group_id number := fnd_api.g_miss_num,

36: salesrep_id number := fnd_api.g_miss_num,
37: resource_id number := fnd_api.g_miss_num,
38: salesrep_name varchar2(360) := fnd_api.g_miss_char,
39: employee_number varchar2(30) := fnd_api.g_miss_char,
40: pay_group_id number := fnd_api.g_miss_num,
41: pay_group_name varchar2(80) := fnd_api.g_miss_char);
42: --
43: TYPE notes_rec IS RECORD(
44: reason_history_id number := fnd_api.g_miss_num,

Line 41: pay_group_name varchar2(80) := fnd_api.g_miss_char);

37: resource_id number := fnd_api.g_miss_num,
38: salesrep_name varchar2(360) := fnd_api.g_miss_char,
39: employee_number varchar2(30) := fnd_api.g_miss_char,
40: pay_group_id number := fnd_api.g_miss_num,
41: pay_group_name varchar2(80) := fnd_api.g_miss_char);
42: --
43: TYPE notes_rec IS RECORD(
44: reason_history_id number := fnd_api.g_miss_num,
45: reason_id number := fnd_api.g_miss_num,

Line 44: reason_history_id number := fnd_api.g_miss_num,

40: pay_group_id number := fnd_api.g_miss_num,
41: pay_group_name varchar2(80) := fnd_api.g_miss_char);
42: --
43: TYPE notes_rec IS RECORD(
44: reason_history_id number := fnd_api.g_miss_num,
45: reason_id number := fnd_api.g_miss_num,
46: updated_table varchar2(30) := fnd_api.g_miss_char,
47: upd_table_id number := fnd_api.g_miss_num,
48: reason varchar2(4000) := fnd_api.g_miss_char,

Line 45: reason_id number := fnd_api.g_miss_num,

41: pay_group_name varchar2(80) := fnd_api.g_miss_char);
42: --
43: TYPE notes_rec IS RECORD(
44: reason_history_id number := fnd_api.g_miss_num,
45: reason_id number := fnd_api.g_miss_num,
46: updated_table varchar2(30) := fnd_api.g_miss_char,
47: upd_table_id number := fnd_api.g_miss_num,
48: reason varchar2(4000) := fnd_api.g_miss_char,
49: reason_code varchar2(30) := fnd_api.g_miss_char,

Line 46: updated_table varchar2(30) := fnd_api.g_miss_char,

42: --
43: TYPE notes_rec IS RECORD(
44: reason_history_id number := fnd_api.g_miss_num,
45: reason_id number := fnd_api.g_miss_num,
46: updated_table varchar2(30) := fnd_api.g_miss_char,
47: upd_table_id number := fnd_api.g_miss_num,
48: reason varchar2(4000) := fnd_api.g_miss_char,
49: reason_code varchar2(30) := fnd_api.g_miss_char,
50: reason_meaning varchar2(80) := fnd_api.g_miss_char,

Line 47: upd_table_id number := fnd_api.g_miss_num,

43: TYPE notes_rec IS RECORD(
44: reason_history_id number := fnd_api.g_miss_num,
45: reason_id number := fnd_api.g_miss_num,
46: updated_table varchar2(30) := fnd_api.g_miss_char,
47: upd_table_id number := fnd_api.g_miss_num,
48: reason varchar2(4000) := fnd_api.g_miss_char,
49: reason_code varchar2(30) := fnd_api.g_miss_char,
50: reason_meaning varchar2(80) := fnd_api.g_miss_char,
51: lookup_type varchar2(30) := fnd_api.g_miss_char,

Line 48: reason varchar2(4000) := fnd_api.g_miss_char,

44: reason_history_id number := fnd_api.g_miss_num,
45: reason_id number := fnd_api.g_miss_num,
46: updated_table varchar2(30) := fnd_api.g_miss_char,
47: upd_table_id number := fnd_api.g_miss_num,
48: reason varchar2(4000) := fnd_api.g_miss_char,
49: reason_code varchar2(30) := fnd_api.g_miss_char,
50: reason_meaning varchar2(80) := fnd_api.g_miss_char,
51: lookup_type varchar2(30) := fnd_api.g_miss_char,
52: update_flag varchar2(30) := fnd_api.g_miss_char,

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

45: reason_id number := fnd_api.g_miss_num,
46: updated_table varchar2(30) := fnd_api.g_miss_char,
47: upd_table_id number := fnd_api.g_miss_num,
48: reason varchar2(4000) := fnd_api.g_miss_char,
49: reason_code varchar2(30) := fnd_api.g_miss_char,
50: reason_meaning varchar2(80) := fnd_api.g_miss_char,
51: lookup_type varchar2(30) := fnd_api.g_miss_char,
52: update_flag varchar2(30) := fnd_api.g_miss_char,
53: dml_flag varchar2(30) := fnd_api.g_miss_char,

Line 50: reason_meaning varchar2(80) := fnd_api.g_miss_char,

46: updated_table varchar2(30) := fnd_api.g_miss_char,
47: upd_table_id number := fnd_api.g_miss_num,
48: reason varchar2(4000) := fnd_api.g_miss_char,
49: reason_code varchar2(30) := fnd_api.g_miss_char,
50: reason_meaning varchar2(80) := fnd_api.g_miss_char,
51: lookup_type varchar2(30) := fnd_api.g_miss_char,
52: update_flag varchar2(30) := fnd_api.g_miss_char,
53: dml_flag varchar2(30) := fnd_api.g_miss_char,
54: attribute_category varchar2(30) := fnd_api.g_miss_char,

Line 51: lookup_type varchar2(30) := fnd_api.g_miss_char,

47: upd_table_id number := fnd_api.g_miss_num,
48: reason varchar2(4000) := fnd_api.g_miss_char,
49: reason_code varchar2(30) := fnd_api.g_miss_char,
50: reason_meaning varchar2(80) := fnd_api.g_miss_char,
51: lookup_type varchar2(30) := fnd_api.g_miss_char,
52: update_flag varchar2(30) := fnd_api.g_miss_char,
53: dml_flag varchar2(30) := fnd_api.g_miss_char,
54: attribute_category varchar2(30) := fnd_api.g_miss_char,
55: attribute1 varchar2(30) := fnd_api.g_miss_char,

Line 52: update_flag varchar2(30) := fnd_api.g_miss_char,

48: reason varchar2(4000) := fnd_api.g_miss_char,
49: reason_code varchar2(30) := fnd_api.g_miss_char,
50: reason_meaning varchar2(80) := fnd_api.g_miss_char,
51: lookup_type varchar2(30) := fnd_api.g_miss_char,
52: update_flag varchar2(30) := fnd_api.g_miss_char,
53: dml_flag varchar2(30) := fnd_api.g_miss_char,
54: attribute_category varchar2(30) := fnd_api.g_miss_char,
55: attribute1 varchar2(30) := fnd_api.g_miss_char,
56: attribute2 varchar2(30) := fnd_api.g_miss_char,

Line 53: dml_flag varchar2(30) := fnd_api.g_miss_char,

49: reason_code varchar2(30) := fnd_api.g_miss_char,
50: reason_meaning varchar2(80) := fnd_api.g_miss_char,
51: lookup_type varchar2(30) := fnd_api.g_miss_char,
52: update_flag varchar2(30) := fnd_api.g_miss_char,
53: dml_flag varchar2(30) := fnd_api.g_miss_char,
54: attribute_category varchar2(30) := fnd_api.g_miss_char,
55: attribute1 varchar2(30) := fnd_api.g_miss_char,
56: attribute2 varchar2(30) := fnd_api.g_miss_char,
57: attribute3 varchar2(30) := fnd_api.g_miss_char,

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

50: reason_meaning varchar2(80) := fnd_api.g_miss_char,
51: lookup_type varchar2(30) := fnd_api.g_miss_char,
52: update_flag varchar2(30) := fnd_api.g_miss_char,
53: dml_flag varchar2(30) := fnd_api.g_miss_char,
54: attribute_category varchar2(30) := fnd_api.g_miss_char,
55: attribute1 varchar2(30) := fnd_api.g_miss_char,
56: attribute2 varchar2(30) := fnd_api.g_miss_char,
57: attribute3 varchar2(30) := fnd_api.g_miss_char,
58: attribute4 varchar2(30) := fnd_api.g_miss_char,

Line 55: attribute1 varchar2(30) := fnd_api.g_miss_char,

51: lookup_type varchar2(30) := fnd_api.g_miss_char,
52: update_flag varchar2(30) := fnd_api.g_miss_char,
53: dml_flag varchar2(30) := fnd_api.g_miss_char,
54: attribute_category varchar2(30) := fnd_api.g_miss_char,
55: attribute1 varchar2(30) := fnd_api.g_miss_char,
56: attribute2 varchar2(30) := fnd_api.g_miss_char,
57: attribute3 varchar2(30) := fnd_api.g_miss_char,
58: attribute4 varchar2(30) := fnd_api.g_miss_char,
59: attribute5 varchar2(30) := fnd_api.g_miss_char,

Line 56: attribute2 varchar2(30) := fnd_api.g_miss_char,

52: update_flag varchar2(30) := fnd_api.g_miss_char,
53: dml_flag varchar2(30) := fnd_api.g_miss_char,
54: attribute_category varchar2(30) := fnd_api.g_miss_char,
55: attribute1 varchar2(30) := fnd_api.g_miss_char,
56: attribute2 varchar2(30) := fnd_api.g_miss_char,
57: attribute3 varchar2(30) := fnd_api.g_miss_char,
58: attribute4 varchar2(30) := fnd_api.g_miss_char,
59: attribute5 varchar2(30) := fnd_api.g_miss_char,
60: attribute6 varchar2(30) := fnd_api.g_miss_char,

Line 57: attribute3 varchar2(30) := fnd_api.g_miss_char,

53: dml_flag varchar2(30) := fnd_api.g_miss_char,
54: attribute_category varchar2(30) := fnd_api.g_miss_char,
55: attribute1 varchar2(30) := fnd_api.g_miss_char,
56: attribute2 varchar2(30) := fnd_api.g_miss_char,
57: attribute3 varchar2(30) := fnd_api.g_miss_char,
58: attribute4 varchar2(30) := fnd_api.g_miss_char,
59: attribute5 varchar2(30) := fnd_api.g_miss_char,
60: attribute6 varchar2(30) := fnd_api.g_miss_char,
61: attribute7 varchar2(30) := fnd_api.g_miss_char,

Line 58: attribute4 varchar2(30) := fnd_api.g_miss_char,

54: attribute_category varchar2(30) := fnd_api.g_miss_char,
55: attribute1 varchar2(30) := fnd_api.g_miss_char,
56: attribute2 varchar2(30) := fnd_api.g_miss_char,
57: attribute3 varchar2(30) := fnd_api.g_miss_char,
58: attribute4 varchar2(30) := fnd_api.g_miss_char,
59: attribute5 varchar2(30) := fnd_api.g_miss_char,
60: attribute6 varchar2(30) := fnd_api.g_miss_char,
61: attribute7 varchar2(30) := fnd_api.g_miss_char,
62: attribute8 varchar2(30) := fnd_api.g_miss_char,

Line 59: attribute5 varchar2(30) := fnd_api.g_miss_char,

55: attribute1 varchar2(30) := fnd_api.g_miss_char,
56: attribute2 varchar2(30) := fnd_api.g_miss_char,
57: attribute3 varchar2(30) := fnd_api.g_miss_char,
58: attribute4 varchar2(30) := fnd_api.g_miss_char,
59: attribute5 varchar2(30) := fnd_api.g_miss_char,
60: attribute6 varchar2(30) := fnd_api.g_miss_char,
61: attribute7 varchar2(30) := fnd_api.g_miss_char,
62: attribute8 varchar2(30) := fnd_api.g_miss_char,
63: attribute9 varchar2(30) := fnd_api.g_miss_char,

Line 60: attribute6 varchar2(30) := fnd_api.g_miss_char,

56: attribute2 varchar2(30) := fnd_api.g_miss_char,
57: attribute3 varchar2(30) := fnd_api.g_miss_char,
58: attribute4 varchar2(30) := fnd_api.g_miss_char,
59: attribute5 varchar2(30) := fnd_api.g_miss_char,
60: attribute6 varchar2(30) := fnd_api.g_miss_char,
61: attribute7 varchar2(30) := fnd_api.g_miss_char,
62: attribute8 varchar2(30) := fnd_api.g_miss_char,
63: attribute9 varchar2(30) := fnd_api.g_miss_char,
64: attribute10 varchar2(30) := fnd_api.g_miss_char,

Line 61: attribute7 varchar2(30) := fnd_api.g_miss_char,

57: attribute3 varchar2(30) := fnd_api.g_miss_char,
58: attribute4 varchar2(30) := fnd_api.g_miss_char,
59: attribute5 varchar2(30) := fnd_api.g_miss_char,
60: attribute6 varchar2(30) := fnd_api.g_miss_char,
61: attribute7 varchar2(30) := fnd_api.g_miss_char,
62: attribute8 varchar2(30) := fnd_api.g_miss_char,
63: attribute9 varchar2(30) := fnd_api.g_miss_char,
64: attribute10 varchar2(30) := fnd_api.g_miss_char,
65: attribute11 varchar2(30) := fnd_api.g_miss_char,

Line 62: attribute8 varchar2(30) := fnd_api.g_miss_char,

58: attribute4 varchar2(30) := fnd_api.g_miss_char,
59: attribute5 varchar2(30) := fnd_api.g_miss_char,
60: attribute6 varchar2(30) := fnd_api.g_miss_char,
61: attribute7 varchar2(30) := fnd_api.g_miss_char,
62: attribute8 varchar2(30) := fnd_api.g_miss_char,
63: attribute9 varchar2(30) := fnd_api.g_miss_char,
64: attribute10 varchar2(30) := fnd_api.g_miss_char,
65: attribute11 varchar2(30) := fnd_api.g_miss_char,
66: attribute12 varchar2(30) := fnd_api.g_miss_char,

Line 63: attribute9 varchar2(30) := fnd_api.g_miss_char,

59: attribute5 varchar2(30) := fnd_api.g_miss_char,
60: attribute6 varchar2(30) := fnd_api.g_miss_char,
61: attribute7 varchar2(30) := fnd_api.g_miss_char,
62: attribute8 varchar2(30) := fnd_api.g_miss_char,
63: attribute9 varchar2(30) := fnd_api.g_miss_char,
64: attribute10 varchar2(30) := fnd_api.g_miss_char,
65: attribute11 varchar2(30) := fnd_api.g_miss_char,
66: attribute12 varchar2(30) := fnd_api.g_miss_char,
67: attribute13 varchar2(30) := fnd_api.g_miss_char,

Line 64: attribute10 varchar2(30) := fnd_api.g_miss_char,

60: attribute6 varchar2(30) := fnd_api.g_miss_char,
61: attribute7 varchar2(30) := fnd_api.g_miss_char,
62: attribute8 varchar2(30) := fnd_api.g_miss_char,
63: attribute9 varchar2(30) := fnd_api.g_miss_char,
64: attribute10 varchar2(30) := fnd_api.g_miss_char,
65: attribute11 varchar2(30) := fnd_api.g_miss_char,
66: attribute12 varchar2(30) := fnd_api.g_miss_char,
67: attribute13 varchar2(30) := fnd_api.g_miss_char,
68: attribute14 varchar2(30) := fnd_api.g_miss_char,

Line 65: attribute11 varchar2(30) := fnd_api.g_miss_char,

61: attribute7 varchar2(30) := fnd_api.g_miss_char,
62: attribute8 varchar2(30) := fnd_api.g_miss_char,
63: attribute9 varchar2(30) := fnd_api.g_miss_char,
64: attribute10 varchar2(30) := fnd_api.g_miss_char,
65: attribute11 varchar2(30) := fnd_api.g_miss_char,
66: attribute12 varchar2(30) := fnd_api.g_miss_char,
67: attribute13 varchar2(30) := fnd_api.g_miss_char,
68: attribute14 varchar2(30) := fnd_api.g_miss_char,
69: attribute15 varchar2(30) := fnd_api.g_miss_char,

Line 66: attribute12 varchar2(30) := fnd_api.g_miss_char,

62: attribute8 varchar2(30) := fnd_api.g_miss_char,
63: attribute9 varchar2(30) := fnd_api.g_miss_char,
64: attribute10 varchar2(30) := fnd_api.g_miss_char,
65: attribute11 varchar2(30) := fnd_api.g_miss_char,
66: attribute12 varchar2(30) := fnd_api.g_miss_char,
67: attribute13 varchar2(30) := fnd_api.g_miss_char,
68: attribute14 varchar2(30) := fnd_api.g_miss_char,
69: attribute15 varchar2(30) := fnd_api.g_miss_char,
70: last_update_date date := fnd_api.g_miss_date,

Line 67: attribute13 varchar2(30) := fnd_api.g_miss_char,

63: attribute9 varchar2(30) := fnd_api.g_miss_char,
64: attribute10 varchar2(30) := fnd_api.g_miss_char,
65: attribute11 varchar2(30) := fnd_api.g_miss_char,
66: attribute12 varchar2(30) := fnd_api.g_miss_char,
67: attribute13 varchar2(30) := fnd_api.g_miss_char,
68: attribute14 varchar2(30) := fnd_api.g_miss_char,
69: attribute15 varchar2(30) := fnd_api.g_miss_char,
70: last_update_date date := fnd_api.g_miss_date,
71: last_updated_by number := fnd_api.g_miss_num,

Line 68: attribute14 varchar2(30) := fnd_api.g_miss_char,

64: attribute10 varchar2(30) := fnd_api.g_miss_char,
65: attribute11 varchar2(30) := fnd_api.g_miss_char,
66: attribute12 varchar2(30) := fnd_api.g_miss_char,
67: attribute13 varchar2(30) := fnd_api.g_miss_char,
68: attribute14 varchar2(30) := fnd_api.g_miss_char,
69: attribute15 varchar2(30) := fnd_api.g_miss_char,
70: last_update_date date := fnd_api.g_miss_date,
71: last_updated_by number := fnd_api.g_miss_num,
72: last_updated_username varchar2(100) := fnd_api.g_miss_char,

Line 69: attribute15 varchar2(30) := fnd_api.g_miss_char,

65: attribute11 varchar2(30) := fnd_api.g_miss_char,
66: attribute12 varchar2(30) := fnd_api.g_miss_char,
67: attribute13 varchar2(30) := fnd_api.g_miss_char,
68: attribute14 varchar2(30) := fnd_api.g_miss_char,
69: attribute15 varchar2(30) := fnd_api.g_miss_char,
70: last_update_date date := fnd_api.g_miss_date,
71: last_updated_by number := fnd_api.g_miss_num,
72: last_updated_username varchar2(100) := fnd_api.g_miss_char,
73: object_version_number number := fnd_api.g_miss_num);

Line 70: last_update_date date := fnd_api.g_miss_date,

66: attribute12 varchar2(30) := fnd_api.g_miss_char,
67: attribute13 varchar2(30) := fnd_api.g_miss_char,
68: attribute14 varchar2(30) := fnd_api.g_miss_char,
69: attribute15 varchar2(30) := fnd_api.g_miss_char,
70: last_update_date date := fnd_api.g_miss_date,
71: last_updated_by number := fnd_api.g_miss_num,
72: last_updated_username varchar2(100) := fnd_api.g_miss_char,
73: object_version_number number := fnd_api.g_miss_num);
74: --

Line 71: last_updated_by number := fnd_api.g_miss_num,

67: attribute13 varchar2(30) := fnd_api.g_miss_char,
68: attribute14 varchar2(30) := fnd_api.g_miss_char,
69: attribute15 varchar2(30) := fnd_api.g_miss_char,
70: last_update_date date := fnd_api.g_miss_date,
71: last_updated_by number := fnd_api.g_miss_num,
72: last_updated_username varchar2(100) := fnd_api.g_miss_char,
73: object_version_number number := fnd_api.g_miss_num);
74: --
75: TYPE notes_tbl IS

Line 72: last_updated_username varchar2(100) := fnd_api.g_miss_char,

68: attribute14 varchar2(30) := fnd_api.g_miss_char,
69: attribute15 varchar2(30) := fnd_api.g_miss_char,
70: last_update_date date := fnd_api.g_miss_date,
71: last_updated_by number := fnd_api.g_miss_num,
72: last_updated_username varchar2(100) := fnd_api.g_miss_char,
73: object_version_number number := fnd_api.g_miss_num);
74: --
75: TYPE notes_tbl IS
76: TABLE OF notes_rec INDEX BY BINARY_INTEGER ;

Line 73: object_version_number number := fnd_api.g_miss_num);

69: attribute15 varchar2(30) := fnd_api.g_miss_char,
70: last_update_date date := fnd_api.g_miss_date,
71: last_updated_by number := fnd_api.g_miss_num,
72: last_updated_username varchar2(100) := fnd_api.g_miss_char,
73: object_version_number number := fnd_api.g_miss_num);
74: --
75: TYPE notes_tbl IS
76: TABLE OF notes_rec INDEX BY BINARY_INTEGER ;
77: --

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

83: Analyst Notes JSP.
84: Desc :
85: Parameters
86: IN : p_api_version IN NUMBER,
87: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
88: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
89: p_commit IN VARCHAR2 := CN_API.G_FALSE,
90: p_first IN NUMBER,
91: p_last IN NUMBER,

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

84: Desc :
85: Parameters
86: IN : p_api_version IN NUMBER,
87: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
88: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
89: p_commit IN VARCHAR2 := CN_API.G_FALSE,
90: p_first IN NUMBER,
91: p_last IN NUMBER,
92: p_payment_worksheet_id IN NUMBER,

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

107: x_notes_tbl populates the second section
108: --------------------------------------------------------------------------*/
109: PROCEDURE show_analyst_notes(
110: p_api_version IN NUMBER,
111: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
112: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
113: p_commit IN VARCHAR2 := CN_API.G_FALSE,
114: p_first IN NUMBER,
115: p_last IN NUMBER,

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

108: --------------------------------------------------------------------------*/
109: PROCEDURE show_analyst_notes(
110: p_api_version IN NUMBER,
111: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
112: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
113: p_commit IN VARCHAR2 := CN_API.G_FALSE,
114: p_first IN NUMBER,
115: p_last IN NUMBER,
116: p_payment_worksheet_id IN NUMBER,

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

130: Usage : This procedure is used to insert or update an analyst notes.
131: Desc :
132: Parameters
133: IN : p_api_version IN NUMBER,
134: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
135: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
136: p_commit IN VARCHAR2 := CN_API.G_FALSE,
137: p_notes_tbl IN cn_reasons_pub.notes_tbl
138:

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

131: Desc :
132: Parameters
133: IN : p_api_version IN NUMBER,
134: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
135: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
136: p_commit IN VARCHAR2 := CN_API.G_FALSE,
137: p_notes_tbl IN cn_reasons_pub.notes_tbl
138:
139: OUT NOCOPY : x_return_status OUT NOCOPY VARCHAR2,

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

146: will be copied to cn_reason_history table.
147: --------------------------------------------------------------------------*/
148: PROCEDURE manage_analyst_notes(
149: p_api_version IN NUMBER,
150: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
151: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
152: p_commit IN VARCHAR2 := CN_API.G_FALSE,
153: p_notes_tbl IN cn_reasons_pub.notes_tbl,
154: x_return_status OUT NOCOPY VARCHAR2,

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

147: --------------------------------------------------------------------------*/
148: PROCEDURE manage_analyst_notes(
149: p_api_version IN NUMBER,
150: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
151: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
152: p_commit IN VARCHAR2 := CN_API.G_FALSE,
153: p_notes_tbl IN cn_reasons_pub.notes_tbl,
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,

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

162: Usage : This procedure is used to remove the record from cn_reasons table
163: Desc :
164: Parameters
165: IN : p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
167: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
168: p_commit IN VARCHAR2 := CN_API.G_FALSE,
169: p_payment_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
170: p_reason_id IN NUMBER := FND_API.G_MISS_NUM,

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

163: Desc :
164: Parameters
165: IN : p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
167: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
168: p_commit IN VARCHAR2 := CN_API.G_FALSE,
169: p_payment_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
170: p_reason_id IN NUMBER := FND_API.G_MISS_NUM,
171: OUT NOCOPY : x_return_status OUT NOCOPY VARCHAR2,

Line 169: p_payment_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,

165: IN : p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
167: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
168: p_commit IN VARCHAR2 := CN_API.G_FALSE,
169: p_payment_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
170: p_reason_id IN NUMBER := FND_API.G_MISS_NUM,
171: OUT NOCOPY : x_return_status OUT NOCOPY VARCHAR2,
172: x_msg_count OUT NOCOPY NUMBER,
173: x_msg_data OUT NOCOPY VARCHAR2,

Line 170: p_reason_id IN NUMBER := FND_API.G_MISS_NUM,

166: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
167: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
168: p_commit IN VARCHAR2 := CN_API.G_FALSE,
169: p_payment_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
170: p_reason_id IN NUMBER := FND_API.G_MISS_NUM,
171: OUT NOCOPY : x_return_status OUT NOCOPY VARCHAR2,
172: x_msg_count OUT NOCOPY NUMBER,
173: x_msg_data OUT NOCOPY VARCHAR2,
174: x_loading_status OUT NOCOPY VARCHAR2

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

175: Notes :
176: --------------------------------------------------------------------------*/
177: PROCEDURE remove_analyst_notes(
178: p_api_version IN NUMBER,
179: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
180: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
181: p_commit IN VARCHAR2 := CN_API.G_FALSE,
182: p_payment_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
183: p_reason_id IN NUMBER := FND_API.G_MISS_NUM,

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

176: --------------------------------------------------------------------------*/
177: PROCEDURE remove_analyst_notes(
178: p_api_version IN NUMBER,
179: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
180: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
181: p_commit IN VARCHAR2 := CN_API.G_FALSE,
182: p_payment_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
183: p_reason_id IN NUMBER := FND_API.G_MISS_NUM,
184: x_return_status OUT NOCOPY VARCHAR2,

Line 182: p_payment_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,

178: p_api_version IN NUMBER,
179: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
180: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
181: p_commit IN VARCHAR2 := CN_API.G_FALSE,
182: p_payment_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
183: p_reason_id IN NUMBER := FND_API.G_MISS_NUM,
184: x_return_status OUT NOCOPY VARCHAR2,
185: x_msg_count OUT NOCOPY NUMBER,
186: x_msg_data OUT NOCOPY VARCHAR2,

Line 183: p_reason_id IN NUMBER := FND_API.G_MISS_NUM,

179: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
180: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
181: p_commit IN VARCHAR2 := CN_API.G_FALSE,
182: p_payment_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
183: p_reason_id IN NUMBER := FND_API.G_MISS_NUM,
184: x_return_status OUT NOCOPY VARCHAR2,
185: x_msg_count OUT NOCOPY NUMBER,
186: x_msg_data OUT NOCOPY VARCHAR2,
187: x_loading_status OUT NOCOPY VARCHAR2);

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

195: Analyst Notes JSP.
196: Desc :
197: Parameters
198: IN : p_api_version IN NUMBER,
199: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
200: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
201: p_commit IN VARCHAR2 := CN_API.G_FALSE,
202: p_first IN NUMBER,
203: p_last IN NUMBER,

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

196: Desc :
197: Parameters
198: IN : p_api_version IN NUMBER,
199: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
200: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
201: p_commit IN VARCHAR2 := CN_API.G_FALSE,
202: p_first IN NUMBER,
203: p_last IN NUMBER,
204: p_payment_worksheet_id IN NUMBER,

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

220: 11.5.10 by Julia Huang
221: --------------------------------------------------------------------------*/
222: PROCEDURE show_last_analyst_note(
223: p_api_version IN NUMBER,
224: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
225: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
226: p_commit IN VARCHAR2 := CN_API.G_FALSE,
227: p_payment_worksheet_id IN NUMBER,
228: p_table_name IN VARCHAR2,

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

221: --------------------------------------------------------------------------*/
222: PROCEDURE show_last_analyst_note(
223: p_api_version IN NUMBER,
224: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
225: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
226: p_commit IN VARCHAR2 := CN_API.G_FALSE,
227: p_payment_worksheet_id IN NUMBER,
228: p_table_name IN VARCHAR2,
229: p_lookup_type IN VARCHAR2,