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.FV_1219_TRANSACTIONS dependencies on FV_SF1219_TEMP

Line 26: l_fund_code FV_SF1219_TEMP.fund_code%TYPE;

22: l_period_year GL_PERIODS.period_year%TYPE;
23:
24: l_rowid varchar2(25);
25:
26: l_fund_code FV_SF1219_TEMP.fund_code%TYPE;
27: l_name FV_SF1219_TEMP.name%TYPE;
28: l_name_keep FV_SF1219_TEMP.name%TYPE;
29: l_set_of_books_id FV_SF1219_TEMP.set_of_books_id%TYPE;
30: l_sf1219_type_code FV_SF1219_TEMP.sf1219_type_code%TYPE;

Line 27: l_name FV_SF1219_TEMP.name%TYPE;

23:
24: l_rowid varchar2(25);
25:
26: l_fund_code FV_SF1219_TEMP.fund_code%TYPE;
27: l_name FV_SF1219_TEMP.name%TYPE;
28: l_name_keep FV_SF1219_TEMP.name%TYPE;
29: l_set_of_books_id FV_SF1219_TEMP.set_of_books_id%TYPE;
30: l_sf1219_type_code FV_SF1219_TEMP.sf1219_type_code%TYPE;
31: l_reported_month FV_SF1219_TEMP.reported_month%TYPE;

Line 28: l_name_keep FV_SF1219_TEMP.name%TYPE;

24: l_rowid varchar2(25);
25:
26: l_fund_code FV_SF1219_TEMP.fund_code%TYPE;
27: l_name FV_SF1219_TEMP.name%TYPE;
28: l_name_keep FV_SF1219_TEMP.name%TYPE;
29: l_set_of_books_id FV_SF1219_TEMP.set_of_books_id%TYPE;
30: l_sf1219_type_code FV_SF1219_TEMP.sf1219_type_code%TYPE;
31: l_reported_month FV_SF1219_TEMP.reported_month%TYPE;
32: l_posted_date FV_SF1219_TEMP.posted_date%TYPE;

Line 29: l_set_of_books_id FV_SF1219_TEMP.set_of_books_id%TYPE;

25:
26: l_fund_code FV_SF1219_TEMP.fund_code%TYPE;
27: l_name FV_SF1219_TEMP.name%TYPE;
28: l_name_keep FV_SF1219_TEMP.name%TYPE;
29: l_set_of_books_id FV_SF1219_TEMP.set_of_books_id%TYPE;
30: l_sf1219_type_code FV_SF1219_TEMP.sf1219_type_code%TYPE;
31: l_reported_month FV_SF1219_TEMP.reported_month%TYPE;
32: l_posted_date FV_SF1219_TEMP.posted_date%TYPE;
33: l_reported_gl_period FV_SF1219_TEMP.reported_gl_period%TYPE;

Line 30: l_sf1219_type_code FV_SF1219_TEMP.sf1219_type_code%TYPE;

26: l_fund_code FV_SF1219_TEMP.fund_code%TYPE;
27: l_name FV_SF1219_TEMP.name%TYPE;
28: l_name_keep FV_SF1219_TEMP.name%TYPE;
29: l_set_of_books_id FV_SF1219_TEMP.set_of_books_id%TYPE;
30: l_sf1219_type_code FV_SF1219_TEMP.sf1219_type_code%TYPE;
31: l_reported_month FV_SF1219_TEMP.reported_month%TYPE;
32: l_posted_date FV_SF1219_TEMP.posted_date%TYPE;
33: l_reported_gl_period FV_SF1219_TEMP.reported_gl_period%TYPE;
34: l_amount FV_SF1219_TEMP.amount%TYPE;

Line 31: l_reported_month FV_SF1219_TEMP.reported_month%TYPE;

27: l_name FV_SF1219_TEMP.name%TYPE;
28: l_name_keep FV_SF1219_TEMP.name%TYPE;
29: l_set_of_books_id FV_SF1219_TEMP.set_of_books_id%TYPE;
30: l_sf1219_type_code FV_SF1219_TEMP.sf1219_type_code%TYPE;
31: l_reported_month FV_SF1219_TEMP.reported_month%TYPE;
32: l_posted_date FV_SF1219_TEMP.posted_date%TYPE;
33: l_reported_gl_period FV_SF1219_TEMP.reported_gl_period%TYPE;
34: l_amount FV_SF1219_TEMP.amount%TYPE;
35: l_batch_id FV_SF1219_TEMP.batch_id%TYPE;

Line 32: l_posted_date FV_SF1219_TEMP.posted_date%TYPE;

28: l_name_keep FV_SF1219_TEMP.name%TYPE;
29: l_set_of_books_id FV_SF1219_TEMP.set_of_books_id%TYPE;
30: l_sf1219_type_code FV_SF1219_TEMP.sf1219_type_code%TYPE;
31: l_reported_month FV_SF1219_TEMP.reported_month%TYPE;
32: l_posted_date FV_SF1219_TEMP.posted_date%TYPE;
33: l_reported_gl_period FV_SF1219_TEMP.reported_gl_period%TYPE;
34: l_amount FV_SF1219_TEMP.amount%TYPE;
35: l_batch_id FV_SF1219_TEMP.batch_id%TYPE;
36:

Line 33: l_reported_gl_period FV_SF1219_TEMP.reported_gl_period%TYPE;

29: l_set_of_books_id FV_SF1219_TEMP.set_of_books_id%TYPE;
30: l_sf1219_type_code FV_SF1219_TEMP.sf1219_type_code%TYPE;
31: l_reported_month FV_SF1219_TEMP.reported_month%TYPE;
32: l_posted_date FV_SF1219_TEMP.posted_date%TYPE;
33: l_reported_gl_period FV_SF1219_TEMP.reported_gl_period%TYPE;
34: l_amount FV_SF1219_TEMP.amount%TYPE;
35: l_batch_id FV_SF1219_TEMP.batch_id%TYPE;
36:
37: l_je_header_id gl_je_headers.je_header_id%TYPE;

Line 34: l_amount FV_SF1219_TEMP.amount%TYPE;

30: l_sf1219_type_code FV_SF1219_TEMP.sf1219_type_code%TYPE;
31: l_reported_month FV_SF1219_TEMP.reported_month%TYPE;
32: l_posted_date FV_SF1219_TEMP.posted_date%TYPE;
33: l_reported_gl_period FV_SF1219_TEMP.reported_gl_period%TYPE;
34: l_amount FV_SF1219_TEMP.amount%TYPE;
35: l_batch_id FV_SF1219_TEMP.batch_id%TYPE;
36:
37: l_je_header_id gl_je_headers.je_header_id%TYPE;
38: l_je_line_num gl_je_lines.je_line_num%TYPE;

Line 35: l_batch_id FV_SF1219_TEMP.batch_id%TYPE;

31: l_reported_month FV_SF1219_TEMP.reported_month%TYPE;
32: l_posted_date FV_SF1219_TEMP.posted_date%TYPE;
33: l_reported_gl_period FV_SF1219_TEMP.reported_gl_period%TYPE;
34: l_amount FV_SF1219_TEMP.amount%TYPE;
35: l_batch_id FV_SF1219_TEMP.batch_id%TYPE;
36:
37: l_je_header_id gl_je_headers.je_header_id%TYPE;
38: l_je_line_num gl_je_lines.je_line_num%TYPE;
39: l_currency_code gl_ledgers_public_v.currency_code%TYPE;

Line 41: l_reference_1 FV_SF1219_TEMP.reference_1%TYPE;

37: l_je_header_id gl_je_headers.je_header_id%TYPE;
38: l_je_line_num gl_je_lines.je_line_num%TYPE;
39: l_currency_code gl_ledgers_public_v.currency_code%TYPE;
40:
41: l_reference_1 FV_SF1219_TEMP.reference_1%TYPE;
42: l_reference_2 FV_SF1219_TEMP.reference_2%TYPE;
43: l_reference_3 FV_SF1219_TEMP.reference_3%TYPE;
44: l_reference_4 FV_SF1219_TEMP.reference_4%TYPE;
45: l_reference_5 FV_SF1219_TEMP.reference_5%TYPE;

Line 42: l_reference_2 FV_SF1219_TEMP.reference_2%TYPE;

38: l_je_line_num gl_je_lines.je_line_num%TYPE;
39: l_currency_code gl_ledgers_public_v.currency_code%TYPE;
40:
41: l_reference_1 FV_SF1219_TEMP.reference_1%TYPE;
42: l_reference_2 FV_SF1219_TEMP.reference_2%TYPE;
43: l_reference_3 FV_SF1219_TEMP.reference_3%TYPE;
44: l_reference_4 FV_SF1219_TEMP.reference_4%TYPE;
45: l_reference_5 FV_SF1219_TEMP.reference_5%TYPE;
46: l_reference_6 FV_SF1219_TEMP.reference_6%TYPE;

Line 43: l_reference_3 FV_SF1219_TEMP.reference_3%TYPE;

39: l_currency_code gl_ledgers_public_v.currency_code%TYPE;
40:
41: l_reference_1 FV_SF1219_TEMP.reference_1%TYPE;
42: l_reference_2 FV_SF1219_TEMP.reference_2%TYPE;
43: l_reference_3 FV_SF1219_TEMP.reference_3%TYPE;
44: l_reference_4 FV_SF1219_TEMP.reference_4%TYPE;
45: l_reference_5 FV_SF1219_TEMP.reference_5%TYPE;
46: l_reference_6 FV_SF1219_TEMP.reference_6%TYPE;
47: l_reference_9 FV_SF1219_TEMP.reference_9%TYPE;

Line 44: l_reference_4 FV_SF1219_TEMP.reference_4%TYPE;

40:
41: l_reference_1 FV_SF1219_TEMP.reference_1%TYPE;
42: l_reference_2 FV_SF1219_TEMP.reference_2%TYPE;
43: l_reference_3 FV_SF1219_TEMP.reference_3%TYPE;
44: l_reference_4 FV_SF1219_TEMP.reference_4%TYPE;
45: l_reference_5 FV_SF1219_TEMP.reference_5%TYPE;
46: l_reference_6 FV_SF1219_TEMP.reference_6%TYPE;
47: l_reference_9 FV_SF1219_TEMP.reference_9%TYPE;
48: l_exception_category FV_SF1219_TEMP.exception_category%TYPE;

Line 45: l_reference_5 FV_SF1219_TEMP.reference_5%TYPE;

41: l_reference_1 FV_SF1219_TEMP.reference_1%TYPE;
42: l_reference_2 FV_SF1219_TEMP.reference_2%TYPE;
43: l_reference_3 FV_SF1219_TEMP.reference_3%TYPE;
44: l_reference_4 FV_SF1219_TEMP.reference_4%TYPE;
45: l_reference_5 FV_SF1219_TEMP.reference_5%TYPE;
46: l_reference_6 FV_SF1219_TEMP.reference_6%TYPE;
47: l_reference_9 FV_SF1219_TEMP.reference_9%TYPE;
48: l_exception_category FV_SF1219_TEMP.exception_category%TYPE;
49: l_accomplish_month FV_SF1219_TEMP.accomplish_month%TYPE;

Line 46: l_reference_6 FV_SF1219_TEMP.reference_6%TYPE;

42: l_reference_2 FV_SF1219_TEMP.reference_2%TYPE;
43: l_reference_3 FV_SF1219_TEMP.reference_3%TYPE;
44: l_reference_4 FV_SF1219_TEMP.reference_4%TYPE;
45: l_reference_5 FV_SF1219_TEMP.reference_5%TYPE;
46: l_reference_6 FV_SF1219_TEMP.reference_6%TYPE;
47: l_reference_9 FV_SF1219_TEMP.reference_9%TYPE;
48: l_exception_category FV_SF1219_TEMP.exception_category%TYPE;
49: l_accomplish_month FV_SF1219_TEMP.accomplish_month%TYPE;
50: l_default_period_name FV_SF1219_TEMP.default_period_name%TYPE;

Line 47: l_reference_9 FV_SF1219_TEMP.reference_9%TYPE;

43: l_reference_3 FV_SF1219_TEMP.reference_3%TYPE;
44: l_reference_4 FV_SF1219_TEMP.reference_4%TYPE;
45: l_reference_5 FV_SF1219_TEMP.reference_5%TYPE;
46: l_reference_6 FV_SF1219_TEMP.reference_6%TYPE;
47: l_reference_9 FV_SF1219_TEMP.reference_9%TYPE;
48: l_exception_category FV_SF1219_TEMP.exception_category%TYPE;
49: l_accomplish_month FV_SF1219_TEMP.accomplish_month%TYPE;
50: l_default_period_name FV_SF1219_TEMP.default_period_name%TYPE;
51: l_obligation_date FV_SF1219_TEMP.obligation_date%TYPE;

Line 48: l_exception_category FV_SF1219_TEMP.exception_category%TYPE;

44: l_reference_4 FV_SF1219_TEMP.reference_4%TYPE;
45: l_reference_5 FV_SF1219_TEMP.reference_5%TYPE;
46: l_reference_6 FV_SF1219_TEMP.reference_6%TYPE;
47: l_reference_9 FV_SF1219_TEMP.reference_9%TYPE;
48: l_exception_category FV_SF1219_TEMP.exception_category%TYPE;
49: l_accomplish_month FV_SF1219_TEMP.accomplish_month%TYPE;
50: l_default_period_name FV_SF1219_TEMP.default_period_name%TYPE;
51: l_obligation_date FV_SF1219_TEMP.obligation_date%TYPE;
52: l_inter_agency_flag FV_SF1219_TEMP.inter_agency_flag%TYPE;

Line 49: l_accomplish_month FV_SF1219_TEMP.accomplish_month%TYPE;

45: l_reference_5 FV_SF1219_TEMP.reference_5%TYPE;
46: l_reference_6 FV_SF1219_TEMP.reference_6%TYPE;
47: l_reference_9 FV_SF1219_TEMP.reference_9%TYPE;
48: l_exception_category FV_SF1219_TEMP.exception_category%TYPE;
49: l_accomplish_month FV_SF1219_TEMP.accomplish_month%TYPE;
50: l_default_period_name FV_SF1219_TEMP.default_period_name%TYPE;
51: l_obligation_date FV_SF1219_TEMP.obligation_date%TYPE;
52: l_inter_agency_flag FV_SF1219_TEMP.inter_agency_flag%TYPE;
53: l_treasury_symbol FV_SF1219_TEMP.treasury_symbol%TYPE;

Line 50: l_default_period_name FV_SF1219_TEMP.default_period_name%TYPE;

46: l_reference_6 FV_SF1219_TEMP.reference_6%TYPE;
47: l_reference_9 FV_SF1219_TEMP.reference_9%TYPE;
48: l_exception_category FV_SF1219_TEMP.exception_category%TYPE;
49: l_accomplish_month FV_SF1219_TEMP.accomplish_month%TYPE;
50: l_default_period_name FV_SF1219_TEMP.default_period_name%TYPE;
51: l_obligation_date FV_SF1219_TEMP.obligation_date%TYPE;
52: l_inter_agency_flag FV_SF1219_TEMP.inter_agency_flag%TYPE;
53: l_treasury_symbol FV_SF1219_TEMP.treasury_symbol%TYPE;
54:

Line 51: l_obligation_date FV_SF1219_TEMP.obligation_date%TYPE;

47: l_reference_9 FV_SF1219_TEMP.reference_9%TYPE;
48: l_exception_category FV_SF1219_TEMP.exception_category%TYPE;
49: l_accomplish_month FV_SF1219_TEMP.accomplish_month%TYPE;
50: l_default_period_name FV_SF1219_TEMP.default_period_name%TYPE;
51: l_obligation_date FV_SF1219_TEMP.obligation_date%TYPE;
52: l_inter_agency_flag FV_SF1219_TEMP.inter_agency_flag%TYPE;
53: l_treasury_symbol FV_SF1219_TEMP.treasury_symbol%TYPE;
54:
55: l_treasury_symbol_id FV_SF1219_TEMP.treasury_symbol_id%TYPE;

Line 52: l_inter_agency_flag FV_SF1219_TEMP.inter_agency_flag%TYPE;

48: l_exception_category FV_SF1219_TEMP.exception_category%TYPE;
49: l_accomplish_month FV_SF1219_TEMP.accomplish_month%TYPE;
50: l_default_period_name FV_SF1219_TEMP.default_period_name%TYPE;
51: l_obligation_date FV_SF1219_TEMP.obligation_date%TYPE;
52: l_inter_agency_flag FV_SF1219_TEMP.inter_agency_flag%TYPE;
53: l_treasury_symbol FV_SF1219_TEMP.treasury_symbol%TYPE;
54:
55: l_treasury_symbol_id FV_SF1219_TEMP.treasury_symbol_id%TYPE;
56: l_record_type FV_SF1219_TEMP.record_type%TYPE;

Line 53: l_treasury_symbol FV_SF1219_TEMP.treasury_symbol%TYPE;

49: l_accomplish_month FV_SF1219_TEMP.accomplish_month%TYPE;
50: l_default_period_name FV_SF1219_TEMP.default_period_name%TYPE;
51: l_obligation_date FV_SF1219_TEMP.obligation_date%TYPE;
52: l_inter_agency_flag FV_SF1219_TEMP.inter_agency_flag%TYPE;
53: l_treasury_symbol FV_SF1219_TEMP.treasury_symbol%TYPE;
54:
55: l_treasury_symbol_id FV_SF1219_TEMP.treasury_symbol_id%TYPE;
56: l_record_type FV_SF1219_TEMP.record_type%TYPE;
57: l_alc_code FV_SF1219_TEMP.alc_code%TYPE;

Line 55: l_treasury_symbol_id FV_SF1219_TEMP.treasury_symbol_id%TYPE;

51: l_obligation_date FV_SF1219_TEMP.obligation_date%TYPE;
52: l_inter_agency_flag FV_SF1219_TEMP.inter_agency_flag%TYPE;
53: l_treasury_symbol FV_SF1219_TEMP.treasury_symbol%TYPE;
54:
55: l_treasury_symbol_id FV_SF1219_TEMP.treasury_symbol_id%TYPE;
56: l_record_type FV_SF1219_TEMP.record_type%TYPE;
57: l_alc_code FV_SF1219_TEMP.alc_code%TYPE;
58: l_temp_alc_code FV_SF1219_TEMP.alc_code%TYPE;
59: l_org_id FV_SF1219_TEMP.org_id%TYPE := mo_global.get_current_org_id;

Line 56: l_record_type FV_SF1219_TEMP.record_type%TYPE;

52: l_inter_agency_flag FV_SF1219_TEMP.inter_agency_flag%TYPE;
53: l_treasury_symbol FV_SF1219_TEMP.treasury_symbol%TYPE;
54:
55: l_treasury_symbol_id FV_SF1219_TEMP.treasury_symbol_id%TYPE;
56: l_record_type FV_SF1219_TEMP.record_type%TYPE;
57: l_alc_code FV_SF1219_TEMP.alc_code%TYPE;
58: l_temp_alc_code FV_SF1219_TEMP.alc_code%TYPE;
59: l_org_id FV_SF1219_TEMP.org_id%TYPE := mo_global.get_current_org_id;
60: l_group_name FV_SF1219_TEMP.group_name%TYPE;

Line 57: l_alc_code FV_SF1219_TEMP.alc_code%TYPE;

53: l_treasury_symbol FV_SF1219_TEMP.treasury_symbol%TYPE;
54:
55: l_treasury_symbol_id FV_SF1219_TEMP.treasury_symbol_id%TYPE;
56: l_record_type FV_SF1219_TEMP.record_type%TYPE;
57: l_alc_code FV_SF1219_TEMP.alc_code%TYPE;
58: l_temp_alc_code FV_SF1219_TEMP.alc_code%TYPE;
59: l_org_id FV_SF1219_TEMP.org_id%TYPE := mo_global.get_current_org_id;
60: l_group_name FV_SF1219_TEMP.group_name%TYPE;
61: l_accomplish_date FV_SF1219_TEMP.accomplish_date%TYPE;

Line 58: l_temp_alc_code FV_SF1219_TEMP.alc_code%TYPE;

54:
55: l_treasury_symbol_id FV_SF1219_TEMP.treasury_symbol_id%TYPE;
56: l_record_type FV_SF1219_TEMP.record_type%TYPE;
57: l_alc_code FV_SF1219_TEMP.alc_code%TYPE;
58: l_temp_alc_code FV_SF1219_TEMP.alc_code%TYPE;
59: l_org_id FV_SF1219_TEMP.org_id%TYPE := mo_global.get_current_org_id;
60: l_group_name FV_SF1219_TEMP.group_name%TYPE;
61: l_accomplish_date FV_SF1219_TEMP.accomplish_date%TYPE;
62: l_ref6_date_check FV_SF1219_TEMP.accomplish_date%TYPE;

Line 59: l_org_id FV_SF1219_TEMP.org_id%TYPE := mo_global.get_current_org_id;

55: l_treasury_symbol_id FV_SF1219_TEMP.treasury_symbol_id%TYPE;
56: l_record_type FV_SF1219_TEMP.record_type%TYPE;
57: l_alc_code FV_SF1219_TEMP.alc_code%TYPE;
58: l_temp_alc_code FV_SF1219_TEMP.alc_code%TYPE;
59: l_org_id FV_SF1219_TEMP.org_id%TYPE := mo_global.get_current_org_id;
60: l_group_name FV_SF1219_TEMP.group_name%TYPE;
61: l_accomplish_date FV_SF1219_TEMP.accomplish_date%TYPE;
62: l_ref6_date_check FV_SF1219_TEMP.accomplish_date%TYPE;
63: l_update_type FV_SF1219_TEMP.update_type%TYPE;

Line 60: l_group_name FV_SF1219_TEMP.group_name%TYPE;

56: l_record_type FV_SF1219_TEMP.record_type%TYPE;
57: l_alc_code FV_SF1219_TEMP.alc_code%TYPE;
58: l_temp_alc_code FV_SF1219_TEMP.alc_code%TYPE;
59: l_org_id FV_SF1219_TEMP.org_id%TYPE := mo_global.get_current_org_id;
60: l_group_name FV_SF1219_TEMP.group_name%TYPE;
61: l_accomplish_date FV_SF1219_TEMP.accomplish_date%TYPE;
62: l_ref6_date_check FV_SF1219_TEMP.accomplish_date%TYPE;
63: l_update_type FV_SF1219_TEMP.update_type%TYPE;
64: l_type FV_SF1219_TEMP.type%TYPE;

Line 61: l_accomplish_date FV_SF1219_TEMP.accomplish_date%TYPE;

57: l_alc_code FV_SF1219_TEMP.alc_code%TYPE;
58: l_temp_alc_code FV_SF1219_TEMP.alc_code%TYPE;
59: l_org_id FV_SF1219_TEMP.org_id%TYPE := mo_global.get_current_org_id;
60: l_group_name FV_SF1219_TEMP.group_name%TYPE;
61: l_accomplish_date FV_SF1219_TEMP.accomplish_date%TYPE;
62: l_ref6_date_check FV_SF1219_TEMP.accomplish_date%TYPE;
63: l_update_type FV_SF1219_TEMP.update_type%TYPE;
64: l_type FV_SF1219_TEMP.type%TYPE;
65: l_gl_period_name FV_SF1219_TEMP.gl_period_name%TYPE;

Line 62: l_ref6_date_check FV_SF1219_TEMP.accomplish_date%TYPE;

58: l_temp_alc_code FV_SF1219_TEMP.alc_code%TYPE;
59: l_org_id FV_SF1219_TEMP.org_id%TYPE := mo_global.get_current_org_id;
60: l_group_name FV_SF1219_TEMP.group_name%TYPE;
61: l_accomplish_date FV_SF1219_TEMP.accomplish_date%TYPE;
62: l_ref6_date_check FV_SF1219_TEMP.accomplish_date%TYPE;
63: l_update_type FV_SF1219_TEMP.update_type%TYPE;
64: l_type FV_SF1219_TEMP.type%TYPE;
65: l_gl_period_name FV_SF1219_TEMP.gl_period_name%TYPE;
66: l_processed_flag FV_SF1219_TEMP.processed_flag%TYPE;

Line 63: l_update_type FV_SF1219_TEMP.update_type%TYPE;

59: l_org_id FV_SF1219_TEMP.org_id%TYPE := mo_global.get_current_org_id;
60: l_group_name FV_SF1219_TEMP.group_name%TYPE;
61: l_accomplish_date FV_SF1219_TEMP.accomplish_date%TYPE;
62: l_ref6_date_check FV_SF1219_TEMP.accomplish_date%TYPE;
63: l_update_type FV_SF1219_TEMP.update_type%TYPE;
64: l_type FV_SF1219_TEMP.type%TYPE;
65: l_gl_period_name FV_SF1219_TEMP.gl_period_name%TYPE;
66: l_processed_flag FV_SF1219_TEMP.processed_flag%TYPE;
67: l_lines_exist FV_SF1219_TEMP.lines_exist%TYPE;

Line 64: l_type FV_SF1219_TEMP.type%TYPE;

60: l_group_name FV_SF1219_TEMP.group_name%TYPE;
61: l_accomplish_date FV_SF1219_TEMP.accomplish_date%TYPE;
62: l_ref6_date_check FV_SF1219_TEMP.accomplish_date%TYPE;
63: l_update_type FV_SF1219_TEMP.update_type%TYPE;
64: l_type FV_SF1219_TEMP.type%TYPE;
65: l_gl_period_name FV_SF1219_TEMP.gl_period_name%TYPE;
66: l_processed_flag FV_SF1219_TEMP.processed_flag%TYPE;
67: l_lines_exist FV_SF1219_TEMP.lines_exist%TYPE;
68:

Line 65: l_gl_period_name FV_SF1219_TEMP.gl_period_name%TYPE;

61: l_accomplish_date FV_SF1219_TEMP.accomplish_date%TYPE;
62: l_ref6_date_check FV_SF1219_TEMP.accomplish_date%TYPE;
63: l_update_type FV_SF1219_TEMP.update_type%TYPE;
64: l_type FV_SF1219_TEMP.type%TYPE;
65: l_gl_period_name FV_SF1219_TEMP.gl_period_name%TYPE;
66: l_processed_flag FV_SF1219_TEMP.processed_flag%TYPE;
67: l_lines_exist FV_SF1219_TEMP.lines_exist%TYPE;
68:
69: l_invoice_id AP_INVOICES_ALL.invoice_id%TYPE;

Line 66: l_processed_flag FV_SF1219_TEMP.processed_flag%TYPE;

62: l_ref6_date_check FV_SF1219_TEMP.accomplish_date%TYPE;
63: l_update_type FV_SF1219_TEMP.update_type%TYPE;
64: l_type FV_SF1219_TEMP.type%TYPE;
65: l_gl_period_name FV_SF1219_TEMP.gl_period_name%TYPE;
66: l_processed_flag FV_SF1219_TEMP.processed_flag%TYPE;
67: l_lines_exist FV_SF1219_TEMP.lines_exist%TYPE;
68:
69: l_invoice_id AP_INVOICES_ALL.invoice_id%TYPE;
70: l_vendor_id AP_INVOICES_ALL.vendor_id%TYPE;

Line 67: l_lines_exist FV_SF1219_TEMP.lines_exist%TYPE;

63: l_update_type FV_SF1219_TEMP.update_type%TYPE;
64: l_type FV_SF1219_TEMP.type%TYPE;
65: l_gl_period_name FV_SF1219_TEMP.gl_period_name%TYPE;
66: l_processed_flag FV_SF1219_TEMP.processed_flag%TYPE;
67: l_lines_exist FV_SF1219_TEMP.lines_exist%TYPE;
68:
69: l_invoice_id AP_INVOICES_ALL.invoice_id%TYPE;
70: l_vendor_id AP_INVOICES_ALL.vendor_id%TYPE;
71: l_payables_ia_paygroup FV_OPERATING_UNITS_ALL.payables_ia_paygroup%TYPE;

Line 129: FROM FV_SF1219_TEMP

125: processed_flag,
126: je_header_id,
127: je_line_num,
128: NVL(je_from_sla_flag,'N')
129: FROM FV_SF1219_TEMP
130: WHERE record_type not in ('P', 'N')
131: ORDER BY batch_id;
132:
133: CURSOR refund_cursor IS

Line 147: FROM fv_sf1219_temp

143: reference_2, reference_3,
144: reported_month, accomplish_date,
145: obligation_date, inter_agency_flag,
146: record_type, lines_exist, alc_code
147: FROM fv_sf1219_temp
148: WHERE name = 'Check for Void';
149:
150: PROCEDURE purge_temp_transactions;
151: PROCEDURE get_balance_account_segments;

Line 333: -- FV_SF1219_TEMP as well as FV_SF1219_MANUAL_LINES tables

329: ----------------------------------------------------------------------------
330: -- PROCEDURE PURGE_TEMP_TRANSACTIONS
331: ----------------------------------------------------------------------------
332: -- If the delete_corrections parameter is 'Y' delete all records of
333: -- FV_SF1219_TEMP as well as FV_SF1219_MANUAL_LINES tables
334: -- Otherwise delete records from FV_SF1219_TEMP other than record
335: -- type 'M' and 'N'. Records types of 'M' and 'N' are not deleted as
336: -- they have been assigned report lines and should be retained.
337: ----------------------------------------------------------------------------

Line 334: -- Otherwise delete records from FV_SF1219_TEMP other than record

330: -- PROCEDURE PURGE_TEMP_TRANSACTIONS
331: ----------------------------------------------------------------------------
332: -- If the delete_corrections parameter is 'Y' delete all records of
333: -- FV_SF1219_TEMP as well as FV_SF1219_MANUAL_LINES tables
334: -- Otherwise delete records from FV_SF1219_TEMP other than record
335: -- type 'M' and 'N'. Records types of 'M' and 'N' are not deleted as
336: -- they have been assigned report lines and should be retained.
337: ----------------------------------------------------------------------------
338: PROCEDURE PURGE_TEMP_TRANSACTIONS IS

Line 343: DELETE FROM fv_sf1219_temp;

339: l_module_name VARCHAR2(200) := g_module_name || 'PURGE_TEMP_TRANSACTIONS';
340: BEGIN
341: IF p_delete_corrections = 'Y'
342: THEN
343: DELETE FROM fv_sf1219_temp;
344: DELETE FROM fv_sf1219_manual_lines;
345: ELSE
346: DELETE FROM fv_sf1219_temp
347: WHERE record_type <> 'N';

Line 346: DELETE FROM fv_sf1219_temp

342: THEN
343: DELETE FROM fv_sf1219_temp;
344: DELETE FROM fv_sf1219_manual_lines;
345: ELSE
346: DELETE FROM fv_sf1219_temp
347: WHERE record_type <> 'N';
348:
349: DELETE FROM fv_sf1219_manual_lines
350: WHERE temp_record_id NOT IN

Line 352: FROM fv_sf1219_temp);

348:
349: DELETE FROM fv_sf1219_manual_lines
350: WHERE temp_record_id NOT IN
351: (SELECT temp_record_id
352: FROM fv_sf1219_temp);
353: END IF;
354: EXCEPTION
355: WHEN NO_DATA_FOUND THEN
356: NULL ;

Line 491: -- JE Batches are inserted into FV_SF1219_TEMP table from JE Batches/Lines.

487:
488: ----------------------------------------------------------------------------
489: -- PROCEDURE INSERT_BATCHES
490: ----------------------------------------------------------------------------
491: -- JE Batches are inserted into FV_SF1219_TEMP table from JE Batches/Lines.
492: -- JE Batches, which exists in Audit table, are omitted. Also, only those
493: -- accounts of JE lines are selected which have been setup by user in the
494: -- Accounts setup table.
495: -- Update_type and type are required to set 'processed flag' in

Line 512: l_string1 := 'INSERT INTO fv_sf1219_temp(

508:
509: BEGIN
510:
511:
512: l_string1 := 'INSERT INTO fv_sf1219_temp(
513: temp_record_id,
514: batch_id,
515: fund_code,
516: name,

Line 570: fv_sf1219_temp_s.NEXTVAL,

566:
567: /* Start for non-sla, upgraded 11i data */
568:
569: l_string2 := 'SELECT
570: fv_sf1219_temp_s.NEXTVAL,
571: glb.je_batch_id,
572: ffp.fund_value,
573: NVL(glb.name,''Manual''),
574: --glb.set_of_books_id,

Line 727: fv_sf1219_temp_s.NEXTVAL,

723:
724: /* Start for je_source is payables and je_category is non treasury */
725:
726: l_string2 := 'SELECT
727: fv_sf1219_temp_s.NEXTVAL,
728: glb.je_batch_id,
729: ffp.fund_value,
730: glb.name,
731: :b_sob,

Line 906: fv_sf1219_temp_s.NEXTVAL,

902:
903: /* Start for je_source is payables and je_category is non treasury */
904:
905: l_string2 := 'SELECT
906: fv_sf1219_temp_s.NEXTVAL,
907: glb.je_batch_id,
908: ffp.fund_value,
909: glb.name,
910: :b_sob,

Line 1086: fv_sf1219_temp_s.NEXTVAL,

1082:
1083: /* Start for je_source is payables and je_category is treasury confirmation */
1084:
1085: l_string2 := 'SELECT
1086: fv_sf1219_temp_s.NEXTVAL,
1087: glb.je_batch_id,
1088: ffp.fund_value,
1089: glb.name,
1090: :b_sob,

Line 1263: fv_sf1219_temp_s.NEXTVAL,

1259: /* Start for je_source is project and je_category is labour_cost */
1260:
1261:
1262: l_string2 := 'SELECT
1263: fv_sf1219_temp_s.NEXTVAL,
1264: glb.je_batch_id,
1265: ffp.fund_value,
1266: glb.name,
1267: :b_sob,

Line 1439: fv_sf1219_temp_s.NEXTVAL,

1435:
1436: /* Start for je_source is Receivables, based on ar_cash_receipt_history_all */
1437:
1438: l_string2 := 'SELECT
1439: fv_sf1219_temp_s.NEXTVAL,
1440: glb.je_batch_id,
1441: ffp.fund_value,
1442: glb.name,
1443: :b_sob,

Line 1620: fv_sf1219_temp_s.NEXTVAL,

1616: /* Start for je_source is Receivables, based on AR_RECEIVABLE_APPLICATIONS_ALL*/
1617:
1618:
1619: l_string2 := 'SELECT
1620: fv_sf1219_temp_s.NEXTVAL,
1621: glb.je_batch_id,
1622: ffp.fund_value,
1623: glb.name,
1624: :b_sob,

Line 1800: fv_sf1219_temp_s.NEXTVAL,

1796:
1797: /* Start for je_source is Receivables, based on AR_MISC_CASH_DISTRIBUTIONS_ALL */
1798:
1799: l_string2 := 'SELECT
1800: fv_sf1219_temp_s.NEXTVAL,
1801: glb.je_batch_id,
1802: ffp.fund_value,
1803: glb.name,
1804: :b_sob,

Line 1983: FROM fv_sf1219_temp

1979:
1980: -- Get the count of the number of records in the temp table.
1981: SELECT count(*)
1982: INTO no_of_tran
1983: FROM fv_sf1219_temp
1984: WHERE set_of_books_id = p_set_bks_id ;
1985:
1986: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1987: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 2008: -- end of this procedure this information is updated in fv_sf1219_temp table.

2004: -----------------------------------------------------------------------------
2005: -- Each record of temp table is processed to find other relevant information
2006: -- like accomplished date, date of obligation of the transaction required for
2007: -- 1219/1220 reports. SF1219 Record type is arrived for each record. At the
2008: -- end of this procedure this information is updated in fv_sf1219_temp table.
2009: --
2010: -- Different record types used during the process are :
2011: -- A - Auto, records which are assigned with a record type
2012: -- M - Manual, records which could not be assigned to a record type

Line 2042: INSERT INTO fv_sf1219_temp (

2038: -- whether pre-process has been run, in Transaction Correction Form and 1219
2039: -- Report. For convenience, org_id column will be populated with
2040: -- Legal Entity, for this record ONLY.
2041: l_module_name := g_module_name || 'PROCESS_1219_TRANSACTIONS';
2042: INSERT INTO fv_sf1219_temp (
2043: temp_record_id,
2044: batch_id,
2045: fund_code,
2046: name,

Line 2060: fv_sf1219_temp_s.NEXTVAL,

2056: last_update_date,
2057: last_updated_by,
2058: last_update_login)
2059: VALUES (
2060: fv_sf1219_temp_s.NEXTVAL,
2061: 0,
2062: 'NO FUND',
2063: 'P Batch',
2064: p_set_bks_id,

Line 2084: FROM fv_sf1219_temp

2080: -- PROCESSING BEGINS HERE WITH POPULATING THE Main Cursor TEMP_CURSOR
2081: -----------------------------------------------------------------------
2082: SELECT count(*)
2083: INTO transaction_count
2084: FROM fv_sf1219_temp
2085: WHERE record_type NOT IN ('P', 'N');
2086:
2087: IF transaction_count = 0
2088: THEN

Line 3291: INSERT INTO FV_SF1219_TEMP(

3287:
3288: -- Insert new record as record_type 'A'. (changes on 7-Jun-1999)
3289: -- This was being inserted as 'E'
3290: BEGIN
3291: INSERT INTO FV_SF1219_TEMP(
3292: temp_record_id,
3293: batch_id,
3294: fund_code,
3295: name,

Line 3334: fv_sf1219_temp_s.nextval,

3330: last_update_login,
3331: je_header_id,
3332: je_line_num)
3333: VALUES(
3334: fv_sf1219_temp_s.nextval,
3335: l_batch_id,
3336: l_fund_code,
3337: l_name,
3338: p_set_bks_id,

Line 3705: UPDATE fv_sf1219_temp

3701:
3702: l_record_type := 'M' ;
3703: l_accomplish_date := l_end_date1 ;
3704:
3705: UPDATE fv_sf1219_temp
3706: SET record_type = l_record_type,
3707: sf1219_type_code = 'MANUAL',
3708: alc_code = l_alc_code,
3709: accomplish_date = l_accomplish_date

Line 3760: UPDATE fv_sf1219_temp

3756: -- record to be shown up the 1219/1220 Report which
3757: -- caused this exception.
3758: l_record_type := 'O' ;
3759:
3760: UPDATE fv_sf1219_temp
3761: SET record_type = l_record_type,
3762: sf1219_type_code = 'VOID',
3763: alc_code = l_alc_code
3764: WHERE rowid = l_rowid;

Line 3848: -- Once all the relevant information is ready, update fv_sf1219_temp table

3844: l_lines_exist := 'Y' ;
3845: END IF;
3846: END IF ;
3847:
3848: -- Once all the relevant information is ready, update fv_sf1219_temp table
3849: UPDATE fv_sf1219_temp
3850: set sf1219_type_code = l_sf1219_type_code,
3851: reported_gl_period = l_reported_gl_period ,
3852: reported_month = l_reported_month,

Line 3849: UPDATE fv_sf1219_temp

3845: END IF;
3846: END IF ;
3847:
3848: -- Once all the relevant information is ready, update fv_sf1219_temp table
3849: UPDATE fv_sf1219_temp
3850: set sf1219_type_code = l_sf1219_type_code,
3851: reported_gl_period = l_reported_gl_period ,
3852: reported_month = l_reported_month,
3853: exception_category = l_exception_category,

Line 3875: p_error_msg := 'fv_sf1219_temp update failed' ;

3871: COMMIT;
3872:
3873: IF sqlcode < 0 THEN
3874: p_error_code := -1;
3875: p_error_msg := 'fv_sf1219_temp update failed' ;
3876: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,
3877: l_module_name||'.error33',p_error_msg);
3878: RETURN ;
3879: END IF;

Line 3888: DELETE from FV_SF1219_TEMP

3884: -- only if the parameter passed is not 'ALL' in which case no records
3885: -- are deleted
3886: IF UPPER(p_alc_code) <> 'ALL'
3887: THEN
3888: DELETE from FV_SF1219_TEMP
3889: WHERE record_type not in ('P')
3890: AND alc_code IS NOT NULL
3891: AND alc_code <> p_alc_code;
3892: END IF;

Line 3895: UPDATE fv_sf1219_temp fst

3891: AND alc_code <> p_alc_code;
3892: END IF;
3893:
3894: -- Get the supplement Number for the alc_code and period
3895: UPDATE fv_sf1219_temp fst
3896: SET supplement_number =
3897: (SELECT NVL(MAX(supplement_number), -1) + 1
3898: FROM fv_sf1219_audits fsa
3899: WHERE fst.alc_code = fsa.alc_code

Line 3925: -- Update REPORTED_MONTH and EXCEPTION_CATEGORY in FV_SF1219_TEMP table

3921:
3922: -----------------------------------------------------------------------------
3923: -- PROCEDURE SET_EXCEPTION_CATEGORY
3924: -----------------------------------------------------------------------------
3925: -- Update REPORTED_MONTH and EXCEPTION_CATEGORY in FV_SF1219_TEMP table
3926: ----------------------------------------------------------------------------
3927: PROCEDURE SET_EXCEPTION_CATEGORY is
3928: l_module_name VARCHAR2(200) := g_module_name || 'SET_EXCEPTION_CATEGORY';
3929: BEGIN

Line 4004: -- record, a new transaction is inserted in the FV_SF1219_TEMP table with

4000: ----------------------------------------------------------------------------
4001: -- This procedure, being called from procedure PROCESS_1219_TRANSACTIONS
4002: -- inserts new transactions for pre-defined Exceptions. In case any of the
4003: -- pre-defined exception categories occurrs during the process of each
4004: -- record, a new transaction is inserted in the FV_SF1219_TEMP table with
4005: -- record type as 'E'. These exception transactions are not to be reported
4006: -- on Report 1219/1220. All records inserted with record type 'E' are
4007: -- reported on Exception Report.
4008: ----------------------------------------------------------------------------

Line 4015: INSERT INTO fv_sf1219_temp(

4011: l_module_name VARCHAR2(200) := g_module_name || 'INSERT_EXCEPTIONS';
4012: BEGIN
4013: l_accomplish_month := to_char(l_accomplish_date,'MMYYYY') ;
4014:
4015: INSERT INTO fv_sf1219_temp(
4016: temp_record_id,
4017: batch_id,
4018: fund_code,
4019: name,

Line 4058: fv_sf1219_temp_s.nextval,

4054: last_update_login,
4055: je_header_id,
4056: je_line_num)
4057: VALUES(
4058: fv_sf1219_temp_s.nextval,
4059: l_batch_id,
4060: l_fund_code,
4061: l_name_keep,
4062: p_set_bks_id,

Line 4312: UPDATE fv_sf1219_temp

4308: IF l_record_type = 'R' AND l_group_name IS NOT NULL THEN
4309: l_lines_exist := 'Y';
4310: END IF;
4311:
4312: UPDATE fv_sf1219_temp
4313: SET sf1219_type_code = l_sf1219_type_code,
4314: reported_month = l_reported_month,
4315: exception_category = l_exception_category,
4316: accomplish_month = to_char(l_accomplish_date,'MMYYYY'),

Line 4331: DELETE fv_sf1219_temp

4327: AND reference_3 = l_reference_3
4328: AND name <> 'Check for Void'
4329: AND record_type = 'A';
4330:
4331: DELETE fv_sf1219_temp
4332: WHERE reference_2 = l_reference_2
4333: AND reference_3 = l_reference_3
4334: AND name = 'Check for Void';
4335:

Line 4345: UPDATE fv_sf1219_temp

4341: -- mass update. In case of each record processing original
4342: -- record should be
4343: -- made 'O' and new 'E' record should be inserted.
4344:
4345: UPDATE fv_sf1219_temp
4346: SET record_type = 'E',
4347: exception_category = 'VOID_MISSING_FRV',
4348: treasury_symbol = 'UNDEFINED'
4349: WHERE reference_2 = l_reference_2

Line 4378: -- 1219/1220 report. The amount against each record of FV_SF1219_TEMP is rolled

4374: -------------------------------------------------------------------------------
4375: -- PROCEDURE GROUP_REPORT_LINES
4376: -------------------------------------------------------------------------------
4377: -- The GROUP_REPORT_LINES procedure is called from Before Report trigger of
4378: -- 1219/1220 report. The amount against each record of FV_SF1219_TEMP is rolled
4379: -- up into FV_SF1219_ORG_TEMP table for each org_id and line_id, which was
4380: -- assigned in the form of Group Name during MAIN_1219 procedure. This table is
4381: -- used for reporting 1219/1220. Record Type 'A', 'M' and 'N' are selected for
4382: -- reporting. If the record type is 'M', 'N' or 'R' (without group_name) report

Line 4408: FROM FV_SF1219_TEMP fvt,

4404: INSERT into FV_SF1219_ORG_TEMP (org_id, alc_code, line_id, amount)
4405: SELECT p_def_org_id, fvt.alc_code,
4406: substr(fvt.group_name,1,3),
4407: sum(fvt.amount * fvr.multiplier)
4408: FROM FV_SF1219_TEMP fvt,
4409: FV_SF1219_REPORT_TEMPLATE fvr
4410: WHERE fvt.alc_code is not null
4411: AND ( fvt.record_type = 'A' OR
4412: (fvt.record_type = 'R' AND fvt.group_name IS NOT NULL))

Line 4419: FROM FV_SF1219_TEMP fvt,

4415:
4416: INSERT into FV_SF1219_ORG_TEMP (org_id, alc_code, line_id, amount)
4417: SELECT p_def_org_id, fvt.alc_code, fvm.line_id, sum(fvt.amount *
4418: DECODE(fvt.record_type, 'N', 1,fvr.multiplier))
4419: FROM FV_SF1219_TEMP fvt,
4420: FV_SF1219_MANUAL_LINES fvm,
4421: FV_SF1219_REPORT_TEMPLATE fvr
4422: WHERE fvt.alc_code IS NOT NULL
4423: AND ((fvt.record_type IN ('M', 'N')

Line 4431: FROM FV_SF1219_TEMP fvt

4427: GROUP BY fvt.alc_code, fvm.line_id;
4428:
4429: INSERT INTO FV_SF1219_ORG_TEMP (org_id, alc_code, line_id, amount)
4430: SELECT p_def_org_id, fvt.alc_code, '410' line_id, sum(fvt.amount * -1)
4431: FROM FV_SF1219_TEMP fvt
4432: WHERE fvt.alc_code is not null
4433: AND fvt.group_name is not null
4434: AND ( fvt.record_type = 'A' OR
4435: (fvt.record_type = 'R' AND fvt.group_name IS NOT NULL))

Line 4441: FROM fv_sf1219_temp

4437:
4438: COMMIT;
4439:
4440: SELECT alc_code INTO v_alc_code
4441: FROM fv_sf1219_temp
4442: WHERE record_type = 'P' ;
4443:
4444: INSERT INTO FV_SF1219_ORG_TEMP (org_id, alc_code, line_id, amount)
4445: SELECT p_def_org_id, fvam.alc_code, '100'

Line 4513: -- inserts records from FV_SF1219_TEMP table to FV_SF1219_AUDITS table, which

4509: -- PROCEDURE INSERT_AUDIT_TABLE
4510: -------------------------------------------------------------------------------
4511: -- The INSERT_AUDIT_TABLE procedure is called from After Report trigger of
4512: -- 1219/1220 report, only when report is run in Final mode. The procedure
4513: -- inserts records from FV_SF1219_TEMP table to FV_SF1219_AUDITS table, which
4514: -- have reported_month as 'CURRENT' or 'CURRENT / PRIOR', and org id is not null.
4515: -- These batches are excluded for any subsequent run.
4516: -- Also, it sets the processed_flag to 'Y' for fv_interagency_funds_all and
4517: -- fv_refunds_voids_all tables.

Line 4526: l2_reported_month FV_SF1219_TEMP.reported_month%TYPE ;

4522:
4523: PROCEDURE INSERT_AUDIT_TABLE(v_alc_code VARCHAR2) IS
4524: l_module_name VARCHAR2(200) := g_module_name || 'INSERT_AUDIT_TABLE';
4525:
4526: l2_reported_month FV_SF1219_TEMP.reported_month%TYPE ;
4527: l2_batch_id FV_SF1219_TEMP.batch_id%TYPE ;
4528: l2_reference_2 FV_SF1219_TEMP.reference_2%TYPE ;
4529: l2_reference_3 FV_SF1219_TEMP.reference_3%TYPE ;
4530: l2_inter_agency_flag FV_SF1219_TEMP.inter_agency_flag%TYPE ;

Line 4527: l2_batch_id FV_SF1219_TEMP.batch_id%TYPE ;

4523: PROCEDURE INSERT_AUDIT_TABLE(v_alc_code VARCHAR2) IS
4524: l_module_name VARCHAR2(200) := g_module_name || 'INSERT_AUDIT_TABLE';
4525:
4526: l2_reported_month FV_SF1219_TEMP.reported_month%TYPE ;
4527: l2_batch_id FV_SF1219_TEMP.batch_id%TYPE ;
4528: l2_reference_2 FV_SF1219_TEMP.reference_2%TYPE ;
4529: l2_reference_3 FV_SF1219_TEMP.reference_3%TYPE ;
4530: l2_inter_agency_flag FV_SF1219_TEMP.inter_agency_flag%TYPE ;
4531: l2_update_type FV_SF1219_TEMP.update_type%TYPE ;

Line 4528: l2_reference_2 FV_SF1219_TEMP.reference_2%TYPE ;

4524: l_module_name VARCHAR2(200) := g_module_name || 'INSERT_AUDIT_TABLE';
4525:
4526: l2_reported_month FV_SF1219_TEMP.reported_month%TYPE ;
4527: l2_batch_id FV_SF1219_TEMP.batch_id%TYPE ;
4528: l2_reference_2 FV_SF1219_TEMP.reference_2%TYPE ;
4529: l2_reference_3 FV_SF1219_TEMP.reference_3%TYPE ;
4530: l2_inter_agency_flag FV_SF1219_TEMP.inter_agency_flag%TYPE ;
4531: l2_update_type FV_SF1219_TEMP.update_type%TYPE ;
4532: l2_type FV_SF1219_TEMP.type%TYPE ;

Line 4529: l2_reference_3 FV_SF1219_TEMP.reference_3%TYPE ;

4525:
4526: l2_reported_month FV_SF1219_TEMP.reported_month%TYPE ;
4527: l2_batch_id FV_SF1219_TEMP.batch_id%TYPE ;
4528: l2_reference_2 FV_SF1219_TEMP.reference_2%TYPE ;
4529: l2_reference_3 FV_SF1219_TEMP.reference_3%TYPE ;
4530: l2_inter_agency_flag FV_SF1219_TEMP.inter_agency_flag%TYPE ;
4531: l2_update_type FV_SF1219_TEMP.update_type%TYPE ;
4532: l2_type FV_SF1219_TEMP.type%TYPE ;
4533: l2_gl_period_name FV_SF1219_TEMP.gl_period_name%TYPE ;

Line 4530: l2_inter_agency_flag FV_SF1219_TEMP.inter_agency_flag%TYPE ;

4526: l2_reported_month FV_SF1219_TEMP.reported_month%TYPE ;
4527: l2_batch_id FV_SF1219_TEMP.batch_id%TYPE ;
4528: l2_reference_2 FV_SF1219_TEMP.reference_2%TYPE ;
4529: l2_reference_3 FV_SF1219_TEMP.reference_3%TYPE ;
4530: l2_inter_agency_flag FV_SF1219_TEMP.inter_agency_flag%TYPE ;
4531: l2_update_type FV_SF1219_TEMP.update_type%TYPE ;
4532: l2_type FV_SF1219_TEMP.type%TYPE ;
4533: l2_gl_period_name FV_SF1219_TEMP.gl_period_name%TYPE ;
4534: l2_processed_flag FV_SF1219_TEMP.processed_flag%TYPE ;

Line 4531: l2_update_type FV_SF1219_TEMP.update_type%TYPE ;

4527: l2_batch_id FV_SF1219_TEMP.batch_id%TYPE ;
4528: l2_reference_2 FV_SF1219_TEMP.reference_2%TYPE ;
4529: l2_reference_3 FV_SF1219_TEMP.reference_3%TYPE ;
4530: l2_inter_agency_flag FV_SF1219_TEMP.inter_agency_flag%TYPE ;
4531: l2_update_type FV_SF1219_TEMP.update_type%TYPE ;
4532: l2_type FV_SF1219_TEMP.type%TYPE ;
4533: l2_gl_period_name FV_SF1219_TEMP.gl_period_name%TYPE ;
4534: l2_processed_flag FV_SF1219_TEMP.processed_flag%TYPE ;
4535: v_supp_number NUMBER;

Line 4532: l2_type FV_SF1219_TEMP.type%TYPE ;

4528: l2_reference_2 FV_SF1219_TEMP.reference_2%TYPE ;
4529: l2_reference_3 FV_SF1219_TEMP.reference_3%TYPE ;
4530: l2_inter_agency_flag FV_SF1219_TEMP.inter_agency_flag%TYPE ;
4531: l2_update_type FV_SF1219_TEMP.update_type%TYPE ;
4532: l2_type FV_SF1219_TEMP.type%TYPE ;
4533: l2_gl_period_name FV_SF1219_TEMP.gl_period_name%TYPE ;
4534: l2_processed_flag FV_SF1219_TEMP.processed_flag%TYPE ;
4535: v_supp_number NUMBER;
4536: l_reported_period VARCHAR2(6);

Line 4533: l2_gl_period_name FV_SF1219_TEMP.gl_period_name%TYPE ;

4529: l2_reference_3 FV_SF1219_TEMP.reference_3%TYPE ;
4530: l2_inter_agency_flag FV_SF1219_TEMP.inter_agency_flag%TYPE ;
4531: l2_update_type FV_SF1219_TEMP.update_type%TYPE ;
4532: l2_type FV_SF1219_TEMP.type%TYPE ;
4533: l2_gl_period_name FV_SF1219_TEMP.gl_period_name%TYPE ;
4534: l2_processed_flag FV_SF1219_TEMP.processed_flag%TYPE ;
4535: v_supp_number NUMBER;
4536: l_reported_period VARCHAR2(6);
4537: l_end_date DATE;

Line 4534: l2_processed_flag FV_SF1219_TEMP.processed_flag%TYPE ;

4530: l2_inter_agency_flag FV_SF1219_TEMP.inter_agency_flag%TYPE ;
4531: l2_update_type FV_SF1219_TEMP.update_type%TYPE ;
4532: l2_type FV_SF1219_TEMP.type%TYPE ;
4533: l2_gl_period_name FV_SF1219_TEMP.gl_period_name%TYPE ;
4534: l2_processed_flag FV_SF1219_TEMP.processed_flag%TYPE ;
4535: v_supp_number NUMBER;
4536: l_reported_period VARCHAR2(6);
4537: l_end_date DATE;
4538:

Line 4549: FROM FV_SF1219_TEMP

4545: update_type,
4546: type,
4547: gl_period_name,
4548: processed_flag
4549: FROM FV_SF1219_TEMP
4550: WHERE (update_type is not null
4551: OR type is not null )
4552: AND alc_code = v_alc_code
4553: ORDER BY batch_id ;

Line 4559: FROM fv_sf1219_temp

4555: -- Find the period for which 1219/1220 is being run
4556: BEGIN
4557: SELECT gl_period
4558: INTO p_gl_period
4559: FROM fv_sf1219_temp
4560: WHERE record_type = 'P'
4561: ORDER BY gl_period;
4562: EXCEPTION
4563: WHEN OTHERS THEN

Line 4576: FROM fv_sf1219_temp

4572:
4573: BEGIN
4574: SELECT set_of_books_id
4575: INTO p_set_bks_id
4576: FROM fv_sf1219_temp
4577: WHERE rownum = 1;
4578:
4579: SELECT chart_of_accounts_id
4580: INTO flex_num

Line 4669: FROM FV_SF1219_TEMP fvt

4665: fvt.je_line_num,
4666: fvt.inter_agency_flag,
4667: alc_code,
4668: v_supp_number --supplement_number
4669: FROM FV_SF1219_TEMP fvt
4670: WHERE fvt.reported_month in ('CURRENT / PRIOR','CURRENT')
4671: AND fvt.alc_code = v_alc_code --is not null
4672: AND ( (fvt.record_type = 'A' OR (fvt.record_type = 'R' AND
4673: fvt.group_name IS NOT NULL))

Line 4736: p_error_msg := 'fv_Sf1219_temp table update failed ' ;

4732:
4733: END IF ;
4734:
4735: IF (sqlcode < 0) THEN
4736: p_error_msg := 'fv_Sf1219_temp table update failed ' ;
4737: p_error_code := -1 ;
4738: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,
4739: l_module_name||'.error1',p_error_msg);
4740: RETURN ;

Line 4755: --DELETE FROM fv_sf1219_temp

4751: -- provided to prevent reporting same records again, just in case user runs the
4752: -- report without running pre-process.
4753: -- Keep only 'E' records for exception report. Exception report deletes all.
4754:
4755: --DELETE FROM fv_sf1219_temp
4756: --WHERE record_type <> 'E';
4757:
4758: --DELETE FROM fv_sf1219_manual_lines;
4759:

Line 4898: fv_sf1219_temp fvt

4894: FROM (SELECT SUM(decode(fvt.record_type,'N', fvt.amount,
4895: fvt.amount*fvr.multiplier))
4896: grp_amount, fvt.alc_code alc
4897: FROM fv_sf1219_report_template fvr,
4898: fv_sf1219_temp fvt
4899: WHERE substr(fvt.group_name,1,3) = fvr.line_id
4900: AND (fvt.record_type IN ('A') OR
4901: (fvt.record_type = 'R' AND fvt.group_name IS NOT NULL))
4902: AND fvt. alc_code = v_alc_code

Line 4910: fv_sf1219_temp fvt,

4906: SELECT SUM(decode(fvt.record_type,'N', fvt.amount,
4907: fvt.amount*fvr.multiplier))
4908: grp_amount, fvt.alc_code alc
4909: FROM fv_sf1219_report_template fvr,
4910: fv_sf1219_temp fvt,
4911: fv_sf1219_manual_lines fvm
4912: WHERE fvm.line_id = fvr.line_id
4913: AND fvt.temp_record_id = fvm.temp_record_id
4914: AND (fvt.record_type IN ('M','N') OR

Line 4930: FROM fv_sf1219_report_template fvr, fv_sf1219_temp fvt

4926: FROM (SELECT fvt.alc_code alc, SUBSTR(fvt.group_name,1,3) l_num,
4927: to_char(to_date(fvt.accomplish_month,'MMYYYY'),'MM/YY') acc_mon,
4928: SUM(decode(fvt.record_type,'N', fvt.amount,
4929: fvt.amount*fvr.multiplier)) grp_amt
4930: FROM fv_sf1219_report_template fvr, fv_sf1219_temp fvt
4931: WHERE substr(fvt.group_name,1,3) = fvr.line_id
4932: AND (fvt.record_type IN ('A') OR
4933: (fvt.record_type = 'R' AND fvt.group_name IS NOT NULL))
4934: AND fvt.alc_code = v_alc_code

Line 4944: fv_sf1219_temp fvt, fv_sf1219_manual_lines fvm

4940: to_char(to_date(fvt.accomplish_month,'MMYYYY'),'MM/YY') acc_mon,
4941: SUM(decode(fvt.record_type,'N', fvt.amount,
4942: fvt.amount*fvr.multiplier)) grp_amt
4943: FROM fv_sf1219_report_template fvr,
4944: fv_sf1219_temp fvt, fv_sf1219_manual_lines fvm
4945: WHERE fvm.line_id = fvr.line_id
4946: AND fvt.temp_record_id = fvm.temp_record_id
4947: AND (fvt.record_type IN ('M','N') OR
4948: (fvt.record_type = 'R' AND fvt.group_name IS NULL))

Line 4971: FROM fv_sf1219_temp fvt

4967: SUM(DECODE(fvt.record_type, 'A',
4968: DECODE(SUBSTR(fvt.group_name,4,1), 3, fvt.amount*-1, 0),
4969: 'R', DECODE(SUBSTR(fvt.group_name,4,1), 3, fvt.amount*-1, 0))) c3,
4970: fvt.alc_code alc
4971: FROM fv_sf1219_temp fvt
4972: WHERE (fvt.record_type = 'A' OR
4973: (fvt.record_type = 'R' AND fvt.group_name IS NOT NULL))
4974: AND fvt.alc_code = v_alc_code
4975: GROUP BY fvt.alc_code, fvt.treasury_symbol

Line 4987: FROM fv_sf1219_temp fvt, fv_sf1219_manual_lines fvm

4983: fvt.amount*-1,0),
4984: 'N', DECODE(fvm.column_no, 3, fvt.amount,0),
4985: 'R', DECODE(fvm.column_no, 3, fvt.amount*-1,0))) c3,
4986: fvt.alc_code alc
4987: FROM fv_sf1219_temp fvt, fv_sf1219_manual_lines fvm
4988: WHERE fvm.temp_record_id = fvt.temp_record_id
4989: AND fvt.alc_code = v_alc_code
4990: AND fvm.line_id = '410'
4991: AND (fvt.record_type IN ('M','N') OR

Line 5019: FROM fv_sf1219_temp

5015:
5016: BEGIN
5017: SELECT set_of_books_id
5018: INTO p_set_bks_id
5019: FROM fv_sf1219_temp
5020: WHERE rownum = 1;
5021:
5022: SELECT chart_of_accounts_id
5023: INTO flex_num

Line 5308: -- from fv_sf1219_temp for the ALC

5304:
5305: fv_flatfiles.create_flat_file(v_stmt);
5306:
5307: -- For the 'Final' run of the request set, delete all records
5308: -- from fv_sf1219_temp for the ALC
5309: -- but the P record and the M records that do not have any lines
5310: -- associated with them.
5311:
5312: DELETE from fv_sf1219_temp t

Line 5312: DELETE from fv_sf1219_temp t

5308: -- from fv_sf1219_temp for the ALC
5309: -- but the P record and the M records that do not have any lines
5310: -- associated with them.
5311:
5312: DELETE from fv_sf1219_temp t
5313: WHERE t.alc_code = v_alc_code
5314: AND EXISTS (SELECT 'X'
5315: FROM FV_SF1219_MANUAL_LINES m
5316: WHERE m.temp_record_id = t.temp_record_id

Line 5319: DELETE FROM fv_sf1219_temp

5315: FROM FV_SF1219_MANUAL_LINES m
5316: WHERE m.temp_record_id = t.temp_record_id
5317: AND t.record_type = 'M');
5318:
5319: DELETE FROM fv_sf1219_temp
5320: WHERE alc_code = v_alc_code
5321: AND record_type NOT IN ('P', 'M');
5322:
5323: -- If there are any records with record_type of M

Line 5330: FROM fv_sf1219_temp t

5326: -- also not be deleted.
5327:
5328: DELETE FROM fv_sf1219_manual_lines m
5329: WHERE NOT EXISTS (SELECT 'X'
5330: FROM fv_sf1219_temp t
5331: WHERE t.temp_record_id = m.temp_record_id
5332: AND t.record_type = 'M');
5333:
5334: DELETE FROM fv_sf1219_org_temp;