DBA Data[Home] [Help]

APPS.IGS_FI_1098T_EXTRACT_DATA dependencies on IGS_LOOKUP_VALUES

Line 22: g_v_label_tax_year igs_lookup_values.meaning%TYPE;

18: abshriva 9/11/05 Bug:4695680-Modification made in procedure'insert_1098t_data'
19: abshriva 26/10/05 Bug: 4697644-Modification made in procedure 'insert_1098t_data'
20: ***************************************************************** */
21:
22: g_v_label_tax_year igs_lookup_values.meaning%TYPE;
23: g_v_label_person igs_lookup_values.meaning%TYPE;
24: g_v_label_persgrp igs_lookup_values.meaning%TYPE;
25: g_v_label_override_excl igs_lookup_values.meaning%TYPE;
26: g_v_label_file_addr igs_lookup_values.meaning%TYPE;

Line 23: g_v_label_person igs_lookup_values.meaning%TYPE;

19: abshriva 26/10/05 Bug: 4697644-Modification made in procedure 'insert_1098t_data'
20: ***************************************************************** */
21:
22: g_v_label_tax_year igs_lookup_values.meaning%TYPE;
23: g_v_label_person igs_lookup_values.meaning%TYPE;
24: g_v_label_persgrp igs_lookup_values.meaning%TYPE;
25: g_v_label_override_excl igs_lookup_values.meaning%TYPE;
26: g_v_label_file_addr igs_lookup_values.meaning%TYPE;
27: g_v_label_test_run igs_lookup_values.meaning%TYPE;

Line 24: g_v_label_persgrp igs_lookup_values.meaning%TYPE;

20: ***************************************************************** */
21:
22: g_v_label_tax_year igs_lookup_values.meaning%TYPE;
23: g_v_label_person igs_lookup_values.meaning%TYPE;
24: g_v_label_persgrp igs_lookup_values.meaning%TYPE;
25: g_v_label_override_excl igs_lookup_values.meaning%TYPE;
26: g_v_label_file_addr igs_lookup_values.meaning%TYPE;
27: g_v_label_test_run igs_lookup_values.meaning%TYPE;
28: g_v_label_stdnt_name igs_lookup_values.meaning%TYPE;

Line 25: g_v_label_override_excl igs_lookup_values.meaning%TYPE;

21:
22: g_v_label_tax_year igs_lookup_values.meaning%TYPE;
23: g_v_label_person igs_lookup_values.meaning%TYPE;
24: g_v_label_persgrp igs_lookup_values.meaning%TYPE;
25: g_v_label_override_excl igs_lookup_values.meaning%TYPE;
26: g_v_label_file_addr igs_lookup_values.meaning%TYPE;
27: g_v_label_test_run igs_lookup_values.meaning%TYPE;
28: g_v_label_stdnt_name igs_lookup_values.meaning%TYPE;
29: g_v_line_sep CONSTANT VARCHAR2(100) := '+'||RPAD('-',75,'-')||'+';

Line 26: g_v_label_file_addr igs_lookup_values.meaning%TYPE;

22: g_v_label_tax_year igs_lookup_values.meaning%TYPE;
23: g_v_label_person igs_lookup_values.meaning%TYPE;
24: g_v_label_persgrp igs_lookup_values.meaning%TYPE;
25: g_v_label_override_excl igs_lookup_values.meaning%TYPE;
26: g_v_label_file_addr igs_lookup_values.meaning%TYPE;
27: g_v_label_test_run igs_lookup_values.meaning%TYPE;
28: g_v_label_stdnt_name igs_lookup_values.meaning%TYPE;
29: g_v_line_sep CONSTANT VARCHAR2(100) := '+'||RPAD('-',75,'-')||'+';
30:

Line 27: g_v_label_test_run igs_lookup_values.meaning%TYPE;

23: g_v_label_person igs_lookup_values.meaning%TYPE;
24: g_v_label_persgrp igs_lookup_values.meaning%TYPE;
25: g_v_label_override_excl igs_lookup_values.meaning%TYPE;
26: g_v_label_file_addr igs_lookup_values.meaning%TYPE;
27: g_v_label_test_run igs_lookup_values.meaning%TYPE;
28: g_v_label_stdnt_name igs_lookup_values.meaning%TYPE;
29: g_v_line_sep CONSTANT VARCHAR2(100) := '+'||RPAD('-',75,'-')||'+';
30:
31: g_b_non_zero_credits_flag BOOLEAN;

Line 28: g_v_label_stdnt_name igs_lookup_values.meaning%TYPE;

24: g_v_label_persgrp igs_lookup_values.meaning%TYPE;
25: g_v_label_override_excl igs_lookup_values.meaning%TYPE;
26: g_v_label_file_addr igs_lookup_values.meaning%TYPE;
27: g_v_label_test_run igs_lookup_values.meaning%TYPE;
28: g_v_label_stdnt_name igs_lookup_values.meaning%TYPE;
29: g_v_line_sep CONSTANT VARCHAR2(100) := '+'||RPAD('-',75,'-')||'+';
30:
31: g_b_non_zero_credits_flag BOOLEAN;
32: g_b_chg_crd_found BOOLEAN;

Line 36: g_v_label_name_control igs_lookup_values.meaning%TYPE;

32: g_b_chg_crd_found BOOLEAN;
33:
34: g_v_validation_status igs_fi_1098t_data.status_code%TYPE;
35:
36: g_v_label_name_control igs_lookup_values.meaning%TYPE;
37: g_v_label_tin igs_lookup_values.meaning%TYPE;
38: g_v_label_val_status igs_lookup_values.meaning%TYPE;
39: g_v_label_err_desc igs_lookup_values.meaning%TYPE;
40: g_v_label_correct_ret igs_lookup_values.meaning%TYPE;

Line 37: g_v_label_tin igs_lookup_values.meaning%TYPE;

33:
34: g_v_validation_status igs_fi_1098t_data.status_code%TYPE;
35:
36: g_v_label_name_control igs_lookup_values.meaning%TYPE;
37: g_v_label_tin igs_lookup_values.meaning%TYPE;
38: g_v_label_val_status igs_lookup_values.meaning%TYPE;
39: g_v_label_err_desc igs_lookup_values.meaning%TYPE;
40: g_v_label_correct_ret igs_lookup_values.meaning%TYPE;
41: g_v_label_box2 igs_lookup_values.meaning%TYPE;

Line 38: g_v_label_val_status igs_lookup_values.meaning%TYPE;

34: g_v_validation_status igs_fi_1098t_data.status_code%TYPE;
35:
36: g_v_label_name_control igs_lookup_values.meaning%TYPE;
37: g_v_label_tin igs_lookup_values.meaning%TYPE;
38: g_v_label_val_status igs_lookup_values.meaning%TYPE;
39: g_v_label_err_desc igs_lookup_values.meaning%TYPE;
40: g_v_label_correct_ret igs_lookup_values.meaning%TYPE;
41: g_v_label_box2 igs_lookup_values.meaning%TYPE;
42: g_v_label_box3 igs_lookup_values.meaning%TYPE;

Line 39: g_v_label_err_desc igs_lookup_values.meaning%TYPE;

35:
36: g_v_label_name_control igs_lookup_values.meaning%TYPE;
37: g_v_label_tin igs_lookup_values.meaning%TYPE;
38: g_v_label_val_status igs_lookup_values.meaning%TYPE;
39: g_v_label_err_desc igs_lookup_values.meaning%TYPE;
40: g_v_label_correct_ret igs_lookup_values.meaning%TYPE;
41: g_v_label_box2 igs_lookup_values.meaning%TYPE;
42: g_v_label_box3 igs_lookup_values.meaning%TYPE;
43: g_v_label_box4 igs_lookup_values.meaning%TYPE;

Line 40: g_v_label_correct_ret igs_lookup_values.meaning%TYPE;

36: g_v_label_name_control igs_lookup_values.meaning%TYPE;
37: g_v_label_tin igs_lookup_values.meaning%TYPE;
38: g_v_label_val_status igs_lookup_values.meaning%TYPE;
39: g_v_label_err_desc igs_lookup_values.meaning%TYPE;
40: g_v_label_correct_ret igs_lookup_values.meaning%TYPE;
41: g_v_label_box2 igs_lookup_values.meaning%TYPE;
42: g_v_label_box3 igs_lookup_values.meaning%TYPE;
43: g_v_label_box4 igs_lookup_values.meaning%TYPE;
44: g_v_label_box5 igs_lookup_values.meaning%TYPE;

Line 41: g_v_label_box2 igs_lookup_values.meaning%TYPE;

37: g_v_label_tin igs_lookup_values.meaning%TYPE;
38: g_v_label_val_status igs_lookup_values.meaning%TYPE;
39: g_v_label_err_desc igs_lookup_values.meaning%TYPE;
40: g_v_label_correct_ret igs_lookup_values.meaning%TYPE;
41: g_v_label_box2 igs_lookup_values.meaning%TYPE;
42: g_v_label_box3 igs_lookup_values.meaning%TYPE;
43: g_v_label_box4 igs_lookup_values.meaning%TYPE;
44: g_v_label_box5 igs_lookup_values.meaning%TYPE;
45: g_v_label_box6 igs_lookup_values.meaning%TYPE;

Line 42: g_v_label_box3 igs_lookup_values.meaning%TYPE;

38: g_v_label_val_status igs_lookup_values.meaning%TYPE;
39: g_v_label_err_desc igs_lookup_values.meaning%TYPE;
40: g_v_label_correct_ret igs_lookup_values.meaning%TYPE;
41: g_v_label_box2 igs_lookup_values.meaning%TYPE;
42: g_v_label_box3 igs_lookup_values.meaning%TYPE;
43: g_v_label_box4 igs_lookup_values.meaning%TYPE;
44: g_v_label_box5 igs_lookup_values.meaning%TYPE;
45: g_v_label_box6 igs_lookup_values.meaning%TYPE;
46: g_v_label_box8 igs_lookup_values.meaning%TYPE;

Line 43: g_v_label_box4 igs_lookup_values.meaning%TYPE;

39: g_v_label_err_desc igs_lookup_values.meaning%TYPE;
40: g_v_label_correct_ret igs_lookup_values.meaning%TYPE;
41: g_v_label_box2 igs_lookup_values.meaning%TYPE;
42: g_v_label_box3 igs_lookup_values.meaning%TYPE;
43: g_v_label_box4 igs_lookup_values.meaning%TYPE;
44: g_v_label_box5 igs_lookup_values.meaning%TYPE;
45: g_v_label_box6 igs_lookup_values.meaning%TYPE;
46: g_v_label_box8 igs_lookup_values.meaning%TYPE;
47: g_v_label_box9 igs_lookup_values.meaning%TYPE;

Line 44: g_v_label_box5 igs_lookup_values.meaning%TYPE;

40: g_v_label_correct_ret igs_lookup_values.meaning%TYPE;
41: g_v_label_box2 igs_lookup_values.meaning%TYPE;
42: g_v_label_box3 igs_lookup_values.meaning%TYPE;
43: g_v_label_box4 igs_lookup_values.meaning%TYPE;
44: g_v_label_box5 igs_lookup_values.meaning%TYPE;
45: g_v_label_box6 igs_lookup_values.meaning%TYPE;
46: g_v_label_box8 igs_lookup_values.meaning%TYPE;
47: g_v_label_box9 igs_lookup_values.meaning%TYPE;
48: g_v_label_boxval igs_lookup_values.meaning%TYPE;

Line 45: g_v_label_box6 igs_lookup_values.meaning%TYPE;

41: g_v_label_box2 igs_lookup_values.meaning%TYPE;
42: g_v_label_box3 igs_lookup_values.meaning%TYPE;
43: g_v_label_box4 igs_lookup_values.meaning%TYPE;
44: g_v_label_box5 igs_lookup_values.meaning%TYPE;
45: g_v_label_box6 igs_lookup_values.meaning%TYPE;
46: g_v_label_box8 igs_lookup_values.meaning%TYPE;
47: g_v_label_box9 igs_lookup_values.meaning%TYPE;
48: g_v_label_boxval igs_lookup_values.meaning%TYPE;
49:

Line 46: g_v_label_box8 igs_lookup_values.meaning%TYPE;

42: g_v_label_box3 igs_lookup_values.meaning%TYPE;
43: g_v_label_box4 igs_lookup_values.meaning%TYPE;
44: g_v_label_box5 igs_lookup_values.meaning%TYPE;
45: g_v_label_box6 igs_lookup_values.meaning%TYPE;
46: g_v_label_box8 igs_lookup_values.meaning%TYPE;
47: g_v_label_box9 igs_lookup_values.meaning%TYPE;
48: g_v_label_boxval igs_lookup_values.meaning%TYPE;
49:
50: g_v_package_name VARCHAR2(100) := 'igs.plsql.igs_fi_1098t_extract_data.';

Line 47: g_v_label_box9 igs_lookup_values.meaning%TYPE;

43: g_v_label_box4 igs_lookup_values.meaning%TYPE;
44: g_v_label_box5 igs_lookup_values.meaning%TYPE;
45: g_v_label_box6 igs_lookup_values.meaning%TYPE;
46: g_v_label_box8 igs_lookup_values.meaning%TYPE;
47: g_v_label_box9 igs_lookup_values.meaning%TYPE;
48: g_v_label_boxval igs_lookup_values.meaning%TYPE;
49:
50: g_v_package_name VARCHAR2(100) := 'igs.plsql.igs_fi_1098t_extract_data.';
51:

Line 48: g_v_label_boxval igs_lookup_values.meaning%TYPE;

44: g_v_label_box5 igs_lookup_values.meaning%TYPE;
45: g_v_label_box6 igs_lookup_values.meaning%TYPE;
46: g_v_label_box8 igs_lookup_values.meaning%TYPE;
47: g_v_label_box9 igs_lookup_values.meaning%TYPE;
48: g_v_label_boxval igs_lookup_values.meaning%TYPE;
49:
50: g_v_package_name VARCHAR2(100) := 'igs.plsql.igs_fi_1098t_extract_data.';
51:
52: e_resource_busy EXCEPTION;