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.GMA_WFSTD_P dependencies on GMA_ACTDATA_WF

Line 14: l_column_name1 GMA_ACTDATA_WF.COLUMN_NAME1%TYPE DEFAULT NULL;

10: p_datastring IN VARCHAR2,
11: P_role OUT NOCOPY VARCHAR2
12: ) IS
13:
14: l_column_name1 GMA_ACTDATA_WF.COLUMN_NAME1%TYPE DEFAULT NULL;
15: l_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;
16: l_column_name2 GMA_ACTDATA_WF.COLUMN_NAME2%TYPE DEFAULT NULL;
17: l_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
18: l_column_name3 GMA_ACTDATA_WF.COLUMN_NAME3%TYPE DEFAULT NULL;

Line 15: l_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;

11: P_role OUT NOCOPY VARCHAR2
12: ) IS
13:
14: l_column_name1 GMA_ACTDATA_WF.COLUMN_NAME1%TYPE DEFAULT NULL;
15: l_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;
16: l_column_name2 GMA_ACTDATA_WF.COLUMN_NAME2%TYPE DEFAULT NULL;
17: l_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
18: l_column_name3 GMA_ACTDATA_WF.COLUMN_NAME3%TYPE DEFAULT NULL;
19: l_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;

Line 16: l_column_name2 GMA_ACTDATA_WF.COLUMN_NAME2%TYPE DEFAULT NULL;

12: ) IS
13:
14: l_column_name1 GMA_ACTDATA_WF.COLUMN_NAME1%TYPE DEFAULT NULL;
15: l_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;
16: l_column_name2 GMA_ACTDATA_WF.COLUMN_NAME2%TYPE DEFAULT NULL;
17: l_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
18: l_column_name3 GMA_ACTDATA_WF.COLUMN_NAME3%TYPE DEFAULT NULL;
19: l_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
20: l_column_name4 GMA_ACTDATA_WF.COLUMN_NAME4%TYPE DEFAULT NULL;

Line 17: l_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;

13:
14: l_column_name1 GMA_ACTDATA_WF.COLUMN_NAME1%TYPE DEFAULT NULL;
15: l_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;
16: l_column_name2 GMA_ACTDATA_WF.COLUMN_NAME2%TYPE DEFAULT NULL;
17: l_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
18: l_column_name3 GMA_ACTDATA_WF.COLUMN_NAME3%TYPE DEFAULT NULL;
19: l_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
20: l_column_name4 GMA_ACTDATA_WF.COLUMN_NAME4%TYPE DEFAULT NULL;
21: l_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;

Line 18: l_column_name3 GMA_ACTDATA_WF.COLUMN_NAME3%TYPE DEFAULT NULL;

14: l_column_name1 GMA_ACTDATA_WF.COLUMN_NAME1%TYPE DEFAULT NULL;
15: l_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;
16: l_column_name2 GMA_ACTDATA_WF.COLUMN_NAME2%TYPE DEFAULT NULL;
17: l_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
18: l_column_name3 GMA_ACTDATA_WF.COLUMN_NAME3%TYPE DEFAULT NULL;
19: l_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
20: l_column_name4 GMA_ACTDATA_WF.COLUMN_NAME4%TYPE DEFAULT NULL;
21: l_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
22: l_column_name5 GMA_ACTDATA_WF.COLUMN_NAME5%TYPE DEFAULT NULL;

Line 19: l_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;

15: l_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;
16: l_column_name2 GMA_ACTDATA_WF.COLUMN_NAME2%TYPE DEFAULT NULL;
17: l_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
18: l_column_name3 GMA_ACTDATA_WF.COLUMN_NAME3%TYPE DEFAULT NULL;
19: l_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
20: l_column_name4 GMA_ACTDATA_WF.COLUMN_NAME4%TYPE DEFAULT NULL;
21: l_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
22: l_column_name5 GMA_ACTDATA_WF.COLUMN_NAME5%TYPE DEFAULT NULL;
23: l_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;

Line 20: l_column_name4 GMA_ACTDATA_WF.COLUMN_NAME4%TYPE DEFAULT NULL;

16: l_column_name2 GMA_ACTDATA_WF.COLUMN_NAME2%TYPE DEFAULT NULL;
17: l_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
18: l_column_name3 GMA_ACTDATA_WF.COLUMN_NAME3%TYPE DEFAULT NULL;
19: l_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
20: l_column_name4 GMA_ACTDATA_WF.COLUMN_NAME4%TYPE DEFAULT NULL;
21: l_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
22: l_column_name5 GMA_ACTDATA_WF.COLUMN_NAME5%TYPE DEFAULT NULL;
23: l_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
24: l_column_name6 GMA_ACTDATA_WF.COLUMN_NAME6%TYPE DEFAULT NULL;

Line 21: l_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;

17: l_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
18: l_column_name3 GMA_ACTDATA_WF.COLUMN_NAME3%TYPE DEFAULT NULL;
19: l_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
20: l_column_name4 GMA_ACTDATA_WF.COLUMN_NAME4%TYPE DEFAULT NULL;
21: l_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
22: l_column_name5 GMA_ACTDATA_WF.COLUMN_NAME5%TYPE DEFAULT NULL;
23: l_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
24: l_column_name6 GMA_ACTDATA_WF.COLUMN_NAME6%TYPE DEFAULT NULL;
25: l_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;

Line 22: l_column_name5 GMA_ACTDATA_WF.COLUMN_NAME5%TYPE DEFAULT NULL;

18: l_column_name3 GMA_ACTDATA_WF.COLUMN_NAME3%TYPE DEFAULT NULL;
19: l_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
20: l_column_name4 GMA_ACTDATA_WF.COLUMN_NAME4%TYPE DEFAULT NULL;
21: l_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
22: l_column_name5 GMA_ACTDATA_WF.COLUMN_NAME5%TYPE DEFAULT NULL;
23: l_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
24: l_column_name6 GMA_ACTDATA_WF.COLUMN_NAME6%TYPE DEFAULT NULL;
25: l_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
26: l_column_name7 GMA_ACTDATA_WF.COLUMN_NAME7%TYPE DEFAULT NULL;

Line 23: l_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;

19: l_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
20: l_column_name4 GMA_ACTDATA_WF.COLUMN_NAME4%TYPE DEFAULT NULL;
21: l_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
22: l_column_name5 GMA_ACTDATA_WF.COLUMN_NAME5%TYPE DEFAULT NULL;
23: l_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
24: l_column_name6 GMA_ACTDATA_WF.COLUMN_NAME6%TYPE DEFAULT NULL;
25: l_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
26: l_column_name7 GMA_ACTDATA_WF.COLUMN_NAME7%TYPE DEFAULT NULL;
27: l_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;

Line 24: l_column_name6 GMA_ACTDATA_WF.COLUMN_NAME6%TYPE DEFAULT NULL;

20: l_column_name4 GMA_ACTDATA_WF.COLUMN_NAME4%TYPE DEFAULT NULL;
21: l_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
22: l_column_name5 GMA_ACTDATA_WF.COLUMN_NAME5%TYPE DEFAULT NULL;
23: l_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
24: l_column_name6 GMA_ACTDATA_WF.COLUMN_NAME6%TYPE DEFAULT NULL;
25: l_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
26: l_column_name7 GMA_ACTDATA_WF.COLUMN_NAME7%TYPE DEFAULT NULL;
27: l_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
28: l_column_name8 GMA_ACTDATA_WF.COLUMN_NAME8%TYPE DEFAULT NULL;

Line 25: l_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;

21: l_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
22: l_column_name5 GMA_ACTDATA_WF.COLUMN_NAME5%TYPE DEFAULT NULL;
23: l_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
24: l_column_name6 GMA_ACTDATA_WF.COLUMN_NAME6%TYPE DEFAULT NULL;
25: l_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
26: l_column_name7 GMA_ACTDATA_WF.COLUMN_NAME7%TYPE DEFAULT NULL;
27: l_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
28: l_column_name8 GMA_ACTDATA_WF.COLUMN_NAME8%TYPE DEFAULT NULL;
29: l_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;

Line 26: l_column_name7 GMA_ACTDATA_WF.COLUMN_NAME7%TYPE DEFAULT NULL;

22: l_column_name5 GMA_ACTDATA_WF.COLUMN_NAME5%TYPE DEFAULT NULL;
23: l_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
24: l_column_name6 GMA_ACTDATA_WF.COLUMN_NAME6%TYPE DEFAULT NULL;
25: l_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
26: l_column_name7 GMA_ACTDATA_WF.COLUMN_NAME7%TYPE DEFAULT NULL;
27: l_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
28: l_column_name8 GMA_ACTDATA_WF.COLUMN_NAME8%TYPE DEFAULT NULL;
29: l_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
30: l_column_name9 GMA_ACTDATA_WF.COLUMN_NAME9%TYPE DEFAULT NULL;

Line 27: l_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;

23: l_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
24: l_column_name6 GMA_ACTDATA_WF.COLUMN_NAME6%TYPE DEFAULT NULL;
25: l_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
26: l_column_name7 GMA_ACTDATA_WF.COLUMN_NAME7%TYPE DEFAULT NULL;
27: l_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
28: l_column_name8 GMA_ACTDATA_WF.COLUMN_NAME8%TYPE DEFAULT NULL;
29: l_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
30: l_column_name9 GMA_ACTDATA_WF.COLUMN_NAME9%TYPE DEFAULT NULL;
31: l_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;

Line 28: l_column_name8 GMA_ACTDATA_WF.COLUMN_NAME8%TYPE DEFAULT NULL;

24: l_column_name6 GMA_ACTDATA_WF.COLUMN_NAME6%TYPE DEFAULT NULL;
25: l_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
26: l_column_name7 GMA_ACTDATA_WF.COLUMN_NAME7%TYPE DEFAULT NULL;
27: l_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
28: l_column_name8 GMA_ACTDATA_WF.COLUMN_NAME8%TYPE DEFAULT NULL;
29: l_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
30: l_column_name9 GMA_ACTDATA_WF.COLUMN_NAME9%TYPE DEFAULT NULL;
31: l_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;
32: l_column_name10 GMA_ACTDATA_WF.COLUMN_NAME10%TYPE DEFAULT NULL;

Line 29: l_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;

25: l_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
26: l_column_name7 GMA_ACTDATA_WF.COLUMN_NAME7%TYPE DEFAULT NULL;
27: l_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
28: l_column_name8 GMA_ACTDATA_WF.COLUMN_NAME8%TYPE DEFAULT NULL;
29: l_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
30: l_column_name9 GMA_ACTDATA_WF.COLUMN_NAME9%TYPE DEFAULT NULL;
31: l_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;
32: l_column_name10 GMA_ACTDATA_WF.COLUMN_NAME10%TYPE DEFAULT NULL;
33: l_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;

Line 30: l_column_name9 GMA_ACTDATA_WF.COLUMN_NAME9%TYPE DEFAULT NULL;

26: l_column_name7 GMA_ACTDATA_WF.COLUMN_NAME7%TYPE DEFAULT NULL;
27: l_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
28: l_column_name8 GMA_ACTDATA_WF.COLUMN_NAME8%TYPE DEFAULT NULL;
29: l_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
30: l_column_name9 GMA_ACTDATA_WF.COLUMN_NAME9%TYPE DEFAULT NULL;
31: l_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;
32: l_column_name10 GMA_ACTDATA_WF.COLUMN_NAME10%TYPE DEFAULT NULL;
33: l_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;
34:

Line 31: l_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;

27: l_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
28: l_column_name8 GMA_ACTDATA_WF.COLUMN_NAME8%TYPE DEFAULT NULL;
29: l_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
30: l_column_name9 GMA_ACTDATA_WF.COLUMN_NAME9%TYPE DEFAULT NULL;
31: l_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;
32: l_column_name10 GMA_ACTDATA_WF.COLUMN_NAME10%TYPE DEFAULT NULL;
33: l_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;
34:
35: /* Temperory Place holders in intermediate search */

Line 32: l_column_name10 GMA_ACTDATA_WF.COLUMN_NAME10%TYPE DEFAULT NULL;

28: l_column_name8 GMA_ACTDATA_WF.COLUMN_NAME8%TYPE DEFAULT NULL;
29: l_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
30: l_column_name9 GMA_ACTDATA_WF.COLUMN_NAME9%TYPE DEFAULT NULL;
31: l_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;
32: l_column_name10 GMA_ACTDATA_WF.COLUMN_NAME10%TYPE DEFAULT NULL;
33: l_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;
34:
35: /* Temperory Place holders in intermediate search */
36: Temp_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;

Line 33: l_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;

29: l_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
30: l_column_name9 GMA_ACTDATA_WF.COLUMN_NAME9%TYPE DEFAULT NULL;
31: l_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;
32: l_column_name10 GMA_ACTDATA_WF.COLUMN_NAME10%TYPE DEFAULT NULL;
33: l_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;
34:
35: /* Temperory Place holders in intermediate search */
36: Temp_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;
37: Temp_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;

Line 36: Temp_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;

32: l_column_name10 GMA_ACTDATA_WF.COLUMN_NAME10%TYPE DEFAULT NULL;
33: l_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;
34:
35: /* Temperory Place holders in intermediate search */
36: Temp_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;
37: Temp_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
38: Temp_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
39: Temp_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
40: Temp_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;

Line 37: Temp_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;

33: l_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;
34:
35: /* Temperory Place holders in intermediate search */
36: Temp_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;
37: Temp_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
38: Temp_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
39: Temp_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
40: Temp_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
41: Temp_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;

Line 38: Temp_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;

34:
35: /* Temperory Place holders in intermediate search */
36: Temp_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;
37: Temp_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
38: Temp_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
39: Temp_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
40: Temp_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
41: Temp_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
42: Temp_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;

Line 39: Temp_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;

35: /* Temperory Place holders in intermediate search */
36: Temp_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;
37: Temp_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
38: Temp_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
39: Temp_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
40: Temp_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
41: Temp_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
42: Temp_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
43: Temp_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;

Line 40: Temp_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;

36: Temp_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;
37: Temp_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
38: Temp_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
39: Temp_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
40: Temp_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
41: Temp_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
42: Temp_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
43: Temp_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
44: Temp_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;

Line 41: Temp_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;

37: Temp_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
38: Temp_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
39: Temp_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
40: Temp_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
41: Temp_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
42: Temp_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
43: Temp_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
44: Temp_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;
45: Temp_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;

Line 42: Temp_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;

38: Temp_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
39: Temp_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
40: Temp_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
41: Temp_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
42: Temp_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
43: Temp_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
44: Temp_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;
45: Temp_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;
46:

Line 43: Temp_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;

39: Temp_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
40: Temp_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
41: Temp_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
42: Temp_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
43: Temp_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
44: Temp_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;
45: Temp_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;
46:
47:

Line 44: Temp_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;

40: Temp_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
41: Temp_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
42: Temp_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
43: Temp_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
44: Temp_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;
45: Temp_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;
46:
47:
48: /* To count number of Columns */

Line 45: Temp_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;

41: Temp_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
42: Temp_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
43: Temp_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
44: Temp_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;
45: Temp_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;
46:
47:
48: /* To count number of Columns */
49: l_column_count NUMBER;

Line 61: l_temp_col_name GMA_ACTDATA_WF.COLUMN_NAME1%TYPE;

57: l_delimiter varchar2(10);
58:
59: /* To get the temperory column name for the cursor */
60:
61: l_temp_col_name GMA_ACTDATA_WF.COLUMN_NAME1%TYPE;
62: l_temp_col_value GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE;
63:
64:
65: l_col_name_value VARCHAR2(100);

Line 62: l_temp_col_value GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE;

58:
59: /* To get the temperory column name for the cursor */
60:
61: l_temp_col_name GMA_ACTDATA_WF.COLUMN_NAME1%TYPE;
62: l_temp_col_value GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE;
63:
64:
65: l_col_name_value VARCHAR2(100);
66:

Line 119: FROM gma_actdata_wf

115: X_column_value9 VARCHAR2,
116: X_column_name10 VARCHAR2,
117: X_column_value10 VARCHAR2) IS
118: SELECT role
119: FROM gma_actdata_wf
120: WHERE activity_id = X_activity_id AND
121: nvl(column_name1,0) = nvl(X_column_name1,0) AND
122: nvl(column_value1,0) = nvl(X_column_value1,0) AND
123: nvl(column_name2,0) = nvl(X_column_name2,0) AND

Line 386: l_column_name1 GMA_ACTDATA_WF.COLUMN_NAME1%TYPE DEFAULT NULL;

382:
383: FUNCTION check_process_approval_req(p_wf_item_type VARCHAR2,
384: p_Process_name VARCHAR2,
385: p_datastring VARCHAR2) RETURN VARCHAR2 IS
386: l_column_name1 GMA_ACTDATA_WF.COLUMN_NAME1%TYPE DEFAULT NULL;
387: l_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;
388: l_column_name2 GMA_ACTDATA_WF.COLUMN_NAME2%TYPE DEFAULT NULL;
389: l_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
390: l_column_name3 GMA_ACTDATA_WF.COLUMN_NAME3%TYPE DEFAULT NULL;

Line 387: l_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;

383: FUNCTION check_process_approval_req(p_wf_item_type VARCHAR2,
384: p_Process_name VARCHAR2,
385: p_datastring VARCHAR2) RETURN VARCHAR2 IS
386: l_column_name1 GMA_ACTDATA_WF.COLUMN_NAME1%TYPE DEFAULT NULL;
387: l_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;
388: l_column_name2 GMA_ACTDATA_WF.COLUMN_NAME2%TYPE DEFAULT NULL;
389: l_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
390: l_column_name3 GMA_ACTDATA_WF.COLUMN_NAME3%TYPE DEFAULT NULL;
391: l_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;

Line 388: l_column_name2 GMA_ACTDATA_WF.COLUMN_NAME2%TYPE DEFAULT NULL;

384: p_Process_name VARCHAR2,
385: p_datastring VARCHAR2) RETURN VARCHAR2 IS
386: l_column_name1 GMA_ACTDATA_WF.COLUMN_NAME1%TYPE DEFAULT NULL;
387: l_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;
388: l_column_name2 GMA_ACTDATA_WF.COLUMN_NAME2%TYPE DEFAULT NULL;
389: l_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
390: l_column_name3 GMA_ACTDATA_WF.COLUMN_NAME3%TYPE DEFAULT NULL;
391: l_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
392: l_column_name4 GMA_ACTDATA_WF.COLUMN_NAME4%TYPE DEFAULT NULL;

Line 389: l_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;

385: p_datastring VARCHAR2) RETURN VARCHAR2 IS
386: l_column_name1 GMA_ACTDATA_WF.COLUMN_NAME1%TYPE DEFAULT NULL;
387: l_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;
388: l_column_name2 GMA_ACTDATA_WF.COLUMN_NAME2%TYPE DEFAULT NULL;
389: l_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
390: l_column_name3 GMA_ACTDATA_WF.COLUMN_NAME3%TYPE DEFAULT NULL;
391: l_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
392: l_column_name4 GMA_ACTDATA_WF.COLUMN_NAME4%TYPE DEFAULT NULL;
393: l_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;

Line 390: l_column_name3 GMA_ACTDATA_WF.COLUMN_NAME3%TYPE DEFAULT NULL;

386: l_column_name1 GMA_ACTDATA_WF.COLUMN_NAME1%TYPE DEFAULT NULL;
387: l_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;
388: l_column_name2 GMA_ACTDATA_WF.COLUMN_NAME2%TYPE DEFAULT NULL;
389: l_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
390: l_column_name3 GMA_ACTDATA_WF.COLUMN_NAME3%TYPE DEFAULT NULL;
391: l_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
392: l_column_name4 GMA_ACTDATA_WF.COLUMN_NAME4%TYPE DEFAULT NULL;
393: l_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
394: l_column_name5 GMA_ACTDATA_WF.COLUMN_NAME5%TYPE DEFAULT NULL;

Line 391: l_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;

387: l_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;
388: l_column_name2 GMA_ACTDATA_WF.COLUMN_NAME2%TYPE DEFAULT NULL;
389: l_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
390: l_column_name3 GMA_ACTDATA_WF.COLUMN_NAME3%TYPE DEFAULT NULL;
391: l_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
392: l_column_name4 GMA_ACTDATA_WF.COLUMN_NAME4%TYPE DEFAULT NULL;
393: l_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
394: l_column_name5 GMA_ACTDATA_WF.COLUMN_NAME5%TYPE DEFAULT NULL;
395: l_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;

Line 392: l_column_name4 GMA_ACTDATA_WF.COLUMN_NAME4%TYPE DEFAULT NULL;

388: l_column_name2 GMA_ACTDATA_WF.COLUMN_NAME2%TYPE DEFAULT NULL;
389: l_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
390: l_column_name3 GMA_ACTDATA_WF.COLUMN_NAME3%TYPE DEFAULT NULL;
391: l_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
392: l_column_name4 GMA_ACTDATA_WF.COLUMN_NAME4%TYPE DEFAULT NULL;
393: l_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
394: l_column_name5 GMA_ACTDATA_WF.COLUMN_NAME5%TYPE DEFAULT NULL;
395: l_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
396: l_column_name6 GMA_ACTDATA_WF.COLUMN_NAME6%TYPE DEFAULT NULL;

Line 393: l_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;

389: l_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
390: l_column_name3 GMA_ACTDATA_WF.COLUMN_NAME3%TYPE DEFAULT NULL;
391: l_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
392: l_column_name4 GMA_ACTDATA_WF.COLUMN_NAME4%TYPE DEFAULT NULL;
393: l_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
394: l_column_name5 GMA_ACTDATA_WF.COLUMN_NAME5%TYPE DEFAULT NULL;
395: l_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
396: l_column_name6 GMA_ACTDATA_WF.COLUMN_NAME6%TYPE DEFAULT NULL;
397: l_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;

Line 394: l_column_name5 GMA_ACTDATA_WF.COLUMN_NAME5%TYPE DEFAULT NULL;

390: l_column_name3 GMA_ACTDATA_WF.COLUMN_NAME3%TYPE DEFAULT NULL;
391: l_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
392: l_column_name4 GMA_ACTDATA_WF.COLUMN_NAME4%TYPE DEFAULT NULL;
393: l_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
394: l_column_name5 GMA_ACTDATA_WF.COLUMN_NAME5%TYPE DEFAULT NULL;
395: l_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
396: l_column_name6 GMA_ACTDATA_WF.COLUMN_NAME6%TYPE DEFAULT NULL;
397: l_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
398: l_column_name7 GMA_ACTDATA_WF.COLUMN_NAME7%TYPE DEFAULT NULL;

Line 395: l_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;

391: l_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
392: l_column_name4 GMA_ACTDATA_WF.COLUMN_NAME4%TYPE DEFAULT NULL;
393: l_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
394: l_column_name5 GMA_ACTDATA_WF.COLUMN_NAME5%TYPE DEFAULT NULL;
395: l_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
396: l_column_name6 GMA_ACTDATA_WF.COLUMN_NAME6%TYPE DEFAULT NULL;
397: l_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
398: l_column_name7 GMA_ACTDATA_WF.COLUMN_NAME7%TYPE DEFAULT NULL;
399: l_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;

Line 396: l_column_name6 GMA_ACTDATA_WF.COLUMN_NAME6%TYPE DEFAULT NULL;

392: l_column_name4 GMA_ACTDATA_WF.COLUMN_NAME4%TYPE DEFAULT NULL;
393: l_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
394: l_column_name5 GMA_ACTDATA_WF.COLUMN_NAME5%TYPE DEFAULT NULL;
395: l_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
396: l_column_name6 GMA_ACTDATA_WF.COLUMN_NAME6%TYPE DEFAULT NULL;
397: l_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
398: l_column_name7 GMA_ACTDATA_WF.COLUMN_NAME7%TYPE DEFAULT NULL;
399: l_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
400: l_column_name8 GMA_ACTDATA_WF.COLUMN_NAME8%TYPE DEFAULT NULL;

Line 397: l_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;

393: l_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
394: l_column_name5 GMA_ACTDATA_WF.COLUMN_NAME5%TYPE DEFAULT NULL;
395: l_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
396: l_column_name6 GMA_ACTDATA_WF.COLUMN_NAME6%TYPE DEFAULT NULL;
397: l_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
398: l_column_name7 GMA_ACTDATA_WF.COLUMN_NAME7%TYPE DEFAULT NULL;
399: l_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
400: l_column_name8 GMA_ACTDATA_WF.COLUMN_NAME8%TYPE DEFAULT NULL;
401: l_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;

Line 398: l_column_name7 GMA_ACTDATA_WF.COLUMN_NAME7%TYPE DEFAULT NULL;

394: l_column_name5 GMA_ACTDATA_WF.COLUMN_NAME5%TYPE DEFAULT NULL;
395: l_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
396: l_column_name6 GMA_ACTDATA_WF.COLUMN_NAME6%TYPE DEFAULT NULL;
397: l_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
398: l_column_name7 GMA_ACTDATA_WF.COLUMN_NAME7%TYPE DEFAULT NULL;
399: l_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
400: l_column_name8 GMA_ACTDATA_WF.COLUMN_NAME8%TYPE DEFAULT NULL;
401: l_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
402: l_column_name9 GMA_ACTDATA_WF.COLUMN_NAME9%TYPE DEFAULT NULL;

Line 399: l_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;

395: l_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
396: l_column_name6 GMA_ACTDATA_WF.COLUMN_NAME6%TYPE DEFAULT NULL;
397: l_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
398: l_column_name7 GMA_ACTDATA_WF.COLUMN_NAME7%TYPE DEFAULT NULL;
399: l_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
400: l_column_name8 GMA_ACTDATA_WF.COLUMN_NAME8%TYPE DEFAULT NULL;
401: l_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
402: l_column_name9 GMA_ACTDATA_WF.COLUMN_NAME9%TYPE DEFAULT NULL;
403: l_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;

Line 400: l_column_name8 GMA_ACTDATA_WF.COLUMN_NAME8%TYPE DEFAULT NULL;

396: l_column_name6 GMA_ACTDATA_WF.COLUMN_NAME6%TYPE DEFAULT NULL;
397: l_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
398: l_column_name7 GMA_ACTDATA_WF.COLUMN_NAME7%TYPE DEFAULT NULL;
399: l_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
400: l_column_name8 GMA_ACTDATA_WF.COLUMN_NAME8%TYPE DEFAULT NULL;
401: l_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
402: l_column_name9 GMA_ACTDATA_WF.COLUMN_NAME9%TYPE DEFAULT NULL;
403: l_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;
404: l_column_name10 GMA_ACTDATA_WF.COLUMN_NAME10%TYPE DEFAULT NULL;

Line 401: l_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;

397: l_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
398: l_column_name7 GMA_ACTDATA_WF.COLUMN_NAME7%TYPE DEFAULT NULL;
399: l_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
400: l_column_name8 GMA_ACTDATA_WF.COLUMN_NAME8%TYPE DEFAULT NULL;
401: l_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
402: l_column_name9 GMA_ACTDATA_WF.COLUMN_NAME9%TYPE DEFAULT NULL;
403: l_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;
404: l_column_name10 GMA_ACTDATA_WF.COLUMN_NAME10%TYPE DEFAULT NULL;
405: l_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;

Line 402: l_column_name9 GMA_ACTDATA_WF.COLUMN_NAME9%TYPE DEFAULT NULL;

398: l_column_name7 GMA_ACTDATA_WF.COLUMN_NAME7%TYPE DEFAULT NULL;
399: l_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
400: l_column_name8 GMA_ACTDATA_WF.COLUMN_NAME8%TYPE DEFAULT NULL;
401: l_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
402: l_column_name9 GMA_ACTDATA_WF.COLUMN_NAME9%TYPE DEFAULT NULL;
403: l_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;
404: l_column_name10 GMA_ACTDATA_WF.COLUMN_NAME10%TYPE DEFAULT NULL;
405: l_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;
406:

Line 403: l_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;

399: l_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
400: l_column_name8 GMA_ACTDATA_WF.COLUMN_NAME8%TYPE DEFAULT NULL;
401: l_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
402: l_column_name9 GMA_ACTDATA_WF.COLUMN_NAME9%TYPE DEFAULT NULL;
403: l_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;
404: l_column_name10 GMA_ACTDATA_WF.COLUMN_NAME10%TYPE DEFAULT NULL;
405: l_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;
406:
407: /* Temperory Place holders in intermediate search */

Line 404: l_column_name10 GMA_ACTDATA_WF.COLUMN_NAME10%TYPE DEFAULT NULL;

400: l_column_name8 GMA_ACTDATA_WF.COLUMN_NAME8%TYPE DEFAULT NULL;
401: l_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
402: l_column_name9 GMA_ACTDATA_WF.COLUMN_NAME9%TYPE DEFAULT NULL;
403: l_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;
404: l_column_name10 GMA_ACTDATA_WF.COLUMN_NAME10%TYPE DEFAULT NULL;
405: l_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;
406:
407: /* Temperory Place holders in intermediate search */
408: Temp_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;

Line 405: l_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;

401: l_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
402: l_column_name9 GMA_ACTDATA_WF.COLUMN_NAME9%TYPE DEFAULT NULL;
403: l_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;
404: l_column_name10 GMA_ACTDATA_WF.COLUMN_NAME10%TYPE DEFAULT NULL;
405: l_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;
406:
407: /* Temperory Place holders in intermediate search */
408: Temp_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;
409: Temp_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;

Line 408: Temp_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;

404: l_column_name10 GMA_ACTDATA_WF.COLUMN_NAME10%TYPE DEFAULT NULL;
405: l_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;
406:
407: /* Temperory Place holders in intermediate search */
408: Temp_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;
409: Temp_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
410: Temp_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
411: Temp_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
412: Temp_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;

Line 409: Temp_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;

405: l_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;
406:
407: /* Temperory Place holders in intermediate search */
408: Temp_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;
409: Temp_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
410: Temp_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
411: Temp_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
412: Temp_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
413: Temp_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;

Line 410: Temp_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;

406:
407: /* Temperory Place holders in intermediate search */
408: Temp_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;
409: Temp_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
410: Temp_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
411: Temp_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
412: Temp_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
413: Temp_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
414: Temp_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;

Line 411: Temp_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;

407: /* Temperory Place holders in intermediate search */
408: Temp_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;
409: Temp_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
410: Temp_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
411: Temp_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
412: Temp_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
413: Temp_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
414: Temp_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
415: Temp_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;

Line 412: Temp_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;

408: Temp_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;
409: Temp_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
410: Temp_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
411: Temp_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
412: Temp_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
413: Temp_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
414: Temp_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
415: Temp_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
416: Temp_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;

Line 413: Temp_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;

409: Temp_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
410: Temp_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
411: Temp_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
412: Temp_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
413: Temp_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
414: Temp_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
415: Temp_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
416: Temp_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;
417: Temp_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;

Line 414: Temp_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;

410: Temp_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
411: Temp_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
412: Temp_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
413: Temp_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
414: Temp_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
415: Temp_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
416: Temp_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;
417: Temp_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;
418:

Line 415: Temp_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;

411: Temp_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
412: Temp_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
413: Temp_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
414: Temp_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
415: Temp_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
416: Temp_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;
417: Temp_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;
418:
419:

Line 416: Temp_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;

412: Temp_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
413: Temp_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
414: Temp_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
415: Temp_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
416: Temp_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;
417: Temp_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;
418:
419:
420: /* To count number of Columns */

Line 417: Temp_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;

413: Temp_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
414: Temp_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
415: Temp_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
416: Temp_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;
417: Temp_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;
418:
419:
420: /* To count number of Columns */
421: l_column_count NUMBER;

Line 433: l_temp_col_name GMA_ACTDATA_WF.COLUMN_NAME1%TYPE;

429: l_delimiter varchar2(10);
430:
431: /* To get the temperory column name for the cursor */
432:
433: l_temp_col_name GMA_ACTDATA_WF.COLUMN_NAME1%TYPE;
434: l_temp_col_value GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE;
435:
436:
437: l_col_name_value VARCHAR2(100);

Line 434: l_temp_col_value GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE;

430:
431: /* To get the temperory column name for the cursor */
432:
433: l_temp_col_name GMA_ACTDATA_WF.COLUMN_NAME1%TYPE;
434: l_temp_col_value GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE;
435:
436:
437: l_col_name_value VARCHAR2(100);
438:

Line 760: l_column_name1 GMA_ACTDATA_WF.COLUMN_NAME1%TYPE DEFAULT NULL;

756: FUNCTION check_activity_approval_req(p_wf_item_type VARCHAR2,
757: p_Process_name VARCHAR2,
758: p_activity_name IN varchar2,
759: p_datastring VARCHAR2) RETURN VARCHAR2 IS
760: l_column_name1 GMA_ACTDATA_WF.COLUMN_NAME1%TYPE DEFAULT NULL;
761: l_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;
762: l_column_name2 GMA_ACTDATA_WF.COLUMN_NAME2%TYPE DEFAULT NULL;
763: l_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
764: l_column_name3 GMA_ACTDATA_WF.COLUMN_NAME3%TYPE DEFAULT NULL;

Line 761: l_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;

757: p_Process_name VARCHAR2,
758: p_activity_name IN varchar2,
759: p_datastring VARCHAR2) RETURN VARCHAR2 IS
760: l_column_name1 GMA_ACTDATA_WF.COLUMN_NAME1%TYPE DEFAULT NULL;
761: l_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;
762: l_column_name2 GMA_ACTDATA_WF.COLUMN_NAME2%TYPE DEFAULT NULL;
763: l_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
764: l_column_name3 GMA_ACTDATA_WF.COLUMN_NAME3%TYPE DEFAULT NULL;
765: l_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;

Line 762: l_column_name2 GMA_ACTDATA_WF.COLUMN_NAME2%TYPE DEFAULT NULL;

758: p_activity_name IN varchar2,
759: p_datastring VARCHAR2) RETURN VARCHAR2 IS
760: l_column_name1 GMA_ACTDATA_WF.COLUMN_NAME1%TYPE DEFAULT NULL;
761: l_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;
762: l_column_name2 GMA_ACTDATA_WF.COLUMN_NAME2%TYPE DEFAULT NULL;
763: l_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
764: l_column_name3 GMA_ACTDATA_WF.COLUMN_NAME3%TYPE DEFAULT NULL;
765: l_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
766: l_column_name4 GMA_ACTDATA_WF.COLUMN_NAME4%TYPE DEFAULT NULL;

Line 763: l_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;

759: p_datastring VARCHAR2) RETURN VARCHAR2 IS
760: l_column_name1 GMA_ACTDATA_WF.COLUMN_NAME1%TYPE DEFAULT NULL;
761: l_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;
762: l_column_name2 GMA_ACTDATA_WF.COLUMN_NAME2%TYPE DEFAULT NULL;
763: l_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
764: l_column_name3 GMA_ACTDATA_WF.COLUMN_NAME3%TYPE DEFAULT NULL;
765: l_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
766: l_column_name4 GMA_ACTDATA_WF.COLUMN_NAME4%TYPE DEFAULT NULL;
767: l_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;

Line 764: l_column_name3 GMA_ACTDATA_WF.COLUMN_NAME3%TYPE DEFAULT NULL;

760: l_column_name1 GMA_ACTDATA_WF.COLUMN_NAME1%TYPE DEFAULT NULL;
761: l_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;
762: l_column_name2 GMA_ACTDATA_WF.COLUMN_NAME2%TYPE DEFAULT NULL;
763: l_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
764: l_column_name3 GMA_ACTDATA_WF.COLUMN_NAME3%TYPE DEFAULT NULL;
765: l_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
766: l_column_name4 GMA_ACTDATA_WF.COLUMN_NAME4%TYPE DEFAULT NULL;
767: l_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
768: l_column_name5 GMA_ACTDATA_WF.COLUMN_NAME5%TYPE DEFAULT NULL;

Line 765: l_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;

761: l_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;
762: l_column_name2 GMA_ACTDATA_WF.COLUMN_NAME2%TYPE DEFAULT NULL;
763: l_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
764: l_column_name3 GMA_ACTDATA_WF.COLUMN_NAME3%TYPE DEFAULT NULL;
765: l_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
766: l_column_name4 GMA_ACTDATA_WF.COLUMN_NAME4%TYPE DEFAULT NULL;
767: l_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
768: l_column_name5 GMA_ACTDATA_WF.COLUMN_NAME5%TYPE DEFAULT NULL;
769: l_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;

Line 766: l_column_name4 GMA_ACTDATA_WF.COLUMN_NAME4%TYPE DEFAULT NULL;

762: l_column_name2 GMA_ACTDATA_WF.COLUMN_NAME2%TYPE DEFAULT NULL;
763: l_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
764: l_column_name3 GMA_ACTDATA_WF.COLUMN_NAME3%TYPE DEFAULT NULL;
765: l_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
766: l_column_name4 GMA_ACTDATA_WF.COLUMN_NAME4%TYPE DEFAULT NULL;
767: l_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
768: l_column_name5 GMA_ACTDATA_WF.COLUMN_NAME5%TYPE DEFAULT NULL;
769: l_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
770: l_column_name6 GMA_ACTDATA_WF.COLUMN_NAME6%TYPE DEFAULT NULL;

Line 767: l_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;

763: l_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
764: l_column_name3 GMA_ACTDATA_WF.COLUMN_NAME3%TYPE DEFAULT NULL;
765: l_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
766: l_column_name4 GMA_ACTDATA_WF.COLUMN_NAME4%TYPE DEFAULT NULL;
767: l_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
768: l_column_name5 GMA_ACTDATA_WF.COLUMN_NAME5%TYPE DEFAULT NULL;
769: l_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
770: l_column_name6 GMA_ACTDATA_WF.COLUMN_NAME6%TYPE DEFAULT NULL;
771: l_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;

Line 768: l_column_name5 GMA_ACTDATA_WF.COLUMN_NAME5%TYPE DEFAULT NULL;

764: l_column_name3 GMA_ACTDATA_WF.COLUMN_NAME3%TYPE DEFAULT NULL;
765: l_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
766: l_column_name4 GMA_ACTDATA_WF.COLUMN_NAME4%TYPE DEFAULT NULL;
767: l_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
768: l_column_name5 GMA_ACTDATA_WF.COLUMN_NAME5%TYPE DEFAULT NULL;
769: l_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
770: l_column_name6 GMA_ACTDATA_WF.COLUMN_NAME6%TYPE DEFAULT NULL;
771: l_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
772: l_column_name7 GMA_ACTDATA_WF.COLUMN_NAME7%TYPE DEFAULT NULL;

Line 769: l_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;

765: l_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
766: l_column_name4 GMA_ACTDATA_WF.COLUMN_NAME4%TYPE DEFAULT NULL;
767: l_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
768: l_column_name5 GMA_ACTDATA_WF.COLUMN_NAME5%TYPE DEFAULT NULL;
769: l_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
770: l_column_name6 GMA_ACTDATA_WF.COLUMN_NAME6%TYPE DEFAULT NULL;
771: l_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
772: l_column_name7 GMA_ACTDATA_WF.COLUMN_NAME7%TYPE DEFAULT NULL;
773: l_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;

Line 770: l_column_name6 GMA_ACTDATA_WF.COLUMN_NAME6%TYPE DEFAULT NULL;

766: l_column_name4 GMA_ACTDATA_WF.COLUMN_NAME4%TYPE DEFAULT NULL;
767: l_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
768: l_column_name5 GMA_ACTDATA_WF.COLUMN_NAME5%TYPE DEFAULT NULL;
769: l_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
770: l_column_name6 GMA_ACTDATA_WF.COLUMN_NAME6%TYPE DEFAULT NULL;
771: l_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
772: l_column_name7 GMA_ACTDATA_WF.COLUMN_NAME7%TYPE DEFAULT NULL;
773: l_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
774: l_column_name8 GMA_ACTDATA_WF.COLUMN_NAME8%TYPE DEFAULT NULL;

Line 771: l_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;

767: l_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
768: l_column_name5 GMA_ACTDATA_WF.COLUMN_NAME5%TYPE DEFAULT NULL;
769: l_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
770: l_column_name6 GMA_ACTDATA_WF.COLUMN_NAME6%TYPE DEFAULT NULL;
771: l_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
772: l_column_name7 GMA_ACTDATA_WF.COLUMN_NAME7%TYPE DEFAULT NULL;
773: l_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
774: l_column_name8 GMA_ACTDATA_WF.COLUMN_NAME8%TYPE DEFAULT NULL;
775: l_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;

Line 772: l_column_name7 GMA_ACTDATA_WF.COLUMN_NAME7%TYPE DEFAULT NULL;

768: l_column_name5 GMA_ACTDATA_WF.COLUMN_NAME5%TYPE DEFAULT NULL;
769: l_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
770: l_column_name6 GMA_ACTDATA_WF.COLUMN_NAME6%TYPE DEFAULT NULL;
771: l_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
772: l_column_name7 GMA_ACTDATA_WF.COLUMN_NAME7%TYPE DEFAULT NULL;
773: l_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
774: l_column_name8 GMA_ACTDATA_WF.COLUMN_NAME8%TYPE DEFAULT NULL;
775: l_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
776: l_column_name9 GMA_ACTDATA_WF.COLUMN_NAME9%TYPE DEFAULT NULL;

Line 773: l_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;

769: l_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
770: l_column_name6 GMA_ACTDATA_WF.COLUMN_NAME6%TYPE DEFAULT NULL;
771: l_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
772: l_column_name7 GMA_ACTDATA_WF.COLUMN_NAME7%TYPE DEFAULT NULL;
773: l_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
774: l_column_name8 GMA_ACTDATA_WF.COLUMN_NAME8%TYPE DEFAULT NULL;
775: l_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
776: l_column_name9 GMA_ACTDATA_WF.COLUMN_NAME9%TYPE DEFAULT NULL;
777: l_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;

Line 774: l_column_name8 GMA_ACTDATA_WF.COLUMN_NAME8%TYPE DEFAULT NULL;

770: l_column_name6 GMA_ACTDATA_WF.COLUMN_NAME6%TYPE DEFAULT NULL;
771: l_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
772: l_column_name7 GMA_ACTDATA_WF.COLUMN_NAME7%TYPE DEFAULT NULL;
773: l_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
774: l_column_name8 GMA_ACTDATA_WF.COLUMN_NAME8%TYPE DEFAULT NULL;
775: l_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
776: l_column_name9 GMA_ACTDATA_WF.COLUMN_NAME9%TYPE DEFAULT NULL;
777: l_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;
778: l_column_name10 GMA_ACTDATA_WF.COLUMN_NAME10%TYPE DEFAULT NULL;

Line 775: l_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;

771: l_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
772: l_column_name7 GMA_ACTDATA_WF.COLUMN_NAME7%TYPE DEFAULT NULL;
773: l_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
774: l_column_name8 GMA_ACTDATA_WF.COLUMN_NAME8%TYPE DEFAULT NULL;
775: l_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
776: l_column_name9 GMA_ACTDATA_WF.COLUMN_NAME9%TYPE DEFAULT NULL;
777: l_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;
778: l_column_name10 GMA_ACTDATA_WF.COLUMN_NAME10%TYPE DEFAULT NULL;
779: l_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;

Line 776: l_column_name9 GMA_ACTDATA_WF.COLUMN_NAME9%TYPE DEFAULT NULL;

772: l_column_name7 GMA_ACTDATA_WF.COLUMN_NAME7%TYPE DEFAULT NULL;
773: l_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
774: l_column_name8 GMA_ACTDATA_WF.COLUMN_NAME8%TYPE DEFAULT NULL;
775: l_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
776: l_column_name9 GMA_ACTDATA_WF.COLUMN_NAME9%TYPE DEFAULT NULL;
777: l_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;
778: l_column_name10 GMA_ACTDATA_WF.COLUMN_NAME10%TYPE DEFAULT NULL;
779: l_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;
780:

Line 777: l_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;

773: l_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
774: l_column_name8 GMA_ACTDATA_WF.COLUMN_NAME8%TYPE DEFAULT NULL;
775: l_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
776: l_column_name9 GMA_ACTDATA_WF.COLUMN_NAME9%TYPE DEFAULT NULL;
777: l_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;
778: l_column_name10 GMA_ACTDATA_WF.COLUMN_NAME10%TYPE DEFAULT NULL;
779: l_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;
780:
781: /* Temperory Place holders in intermediate search */

Line 778: l_column_name10 GMA_ACTDATA_WF.COLUMN_NAME10%TYPE DEFAULT NULL;

774: l_column_name8 GMA_ACTDATA_WF.COLUMN_NAME8%TYPE DEFAULT NULL;
775: l_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
776: l_column_name9 GMA_ACTDATA_WF.COLUMN_NAME9%TYPE DEFAULT NULL;
777: l_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;
778: l_column_name10 GMA_ACTDATA_WF.COLUMN_NAME10%TYPE DEFAULT NULL;
779: l_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;
780:
781: /* Temperory Place holders in intermediate search */
782: Temp_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;

Line 779: l_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;

775: l_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
776: l_column_name9 GMA_ACTDATA_WF.COLUMN_NAME9%TYPE DEFAULT NULL;
777: l_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;
778: l_column_name10 GMA_ACTDATA_WF.COLUMN_NAME10%TYPE DEFAULT NULL;
779: l_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;
780:
781: /* Temperory Place holders in intermediate search */
782: Temp_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;
783: Temp_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;

Line 782: Temp_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;

778: l_column_name10 GMA_ACTDATA_WF.COLUMN_NAME10%TYPE DEFAULT NULL;
779: l_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;
780:
781: /* Temperory Place holders in intermediate search */
782: Temp_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;
783: Temp_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
784: Temp_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
785: Temp_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
786: Temp_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;

Line 783: Temp_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;

779: l_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;
780:
781: /* Temperory Place holders in intermediate search */
782: Temp_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;
783: Temp_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
784: Temp_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
785: Temp_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
786: Temp_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
787: Temp_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;

Line 784: Temp_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;

780:
781: /* Temperory Place holders in intermediate search */
782: Temp_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;
783: Temp_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
784: Temp_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
785: Temp_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
786: Temp_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
787: Temp_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
788: Temp_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;

Line 785: Temp_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;

781: /* Temperory Place holders in intermediate search */
782: Temp_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;
783: Temp_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
784: Temp_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
785: Temp_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
786: Temp_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
787: Temp_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
788: Temp_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
789: Temp_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;

Line 786: Temp_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;

782: Temp_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;
783: Temp_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
784: Temp_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
785: Temp_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
786: Temp_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
787: Temp_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
788: Temp_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
789: Temp_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
790: Temp_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;

Line 787: Temp_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;

783: Temp_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
784: Temp_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
785: Temp_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
786: Temp_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
787: Temp_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
788: Temp_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
789: Temp_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
790: Temp_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;
791: Temp_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;

Line 788: Temp_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;

784: Temp_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
785: Temp_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
786: Temp_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
787: Temp_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
788: Temp_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
789: Temp_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
790: Temp_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;
791: Temp_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;
792:

Line 789: Temp_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;

785: Temp_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
786: Temp_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
787: Temp_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
788: Temp_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
789: Temp_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
790: Temp_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;
791: Temp_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;
792:
793:

Line 790: Temp_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;

786: Temp_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
787: Temp_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
788: Temp_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
789: Temp_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
790: Temp_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;
791: Temp_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;
792:
793:
794: /* To count number of Columns */

Line 791: Temp_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;

787: Temp_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
788: Temp_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
789: Temp_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
790: Temp_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;
791: Temp_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;
792:
793:
794: /* To count number of Columns */
795: l_column_count NUMBER;

Line 807: l_temp_col_name GMA_ACTDATA_WF.COLUMN_NAME1%TYPE;

803: l_delimiter varchar2(10);
804:
805: /* To get the temperory column name for the cursor */
806:
807: l_temp_col_name GMA_ACTDATA_WF.COLUMN_NAME1%TYPE;
808: l_temp_col_value GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE;
809:
810:
811: l_col_name_value VARCHAR2(100);

Line 808: l_temp_col_value GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE;

804:
805: /* To get the temperory column name for the cursor */
806:
807: l_temp_col_name GMA_ACTDATA_WF.COLUMN_NAME1%TYPE;
808: l_temp_col_value GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE;
809:
810:
811: l_col_name_value VARCHAR2(100);
812:

Line 865: FROM gma_actdata_wf

861: X_column_value9 VARCHAR2,
862: X_column_name10 VARCHAR2,
863: X_column_value10 VARCHAR2) IS
864: SELECT ENABLE_FLAG
865: FROM gma_actdata_wf
866: WHERE activity_id = X_activity_id AND
867: nvl(column_name1,0) = nvl(X_column_name1,0) AND
868: nvl(column_value1,0) = nvl(X_column_value1,0) AND
869: nvl(column_name2,0) = nvl(X_column_name2,0) AND

Line 1157: l_column_name1 GMA_ACTDATA_WF.COLUMN_NAME1%TYPE DEFAULT NULL;

1153: P_WFSTRING OUT NOCOPY VARCHAR2) IS
1154: l_sql_stmt VARCHAR2(4000);
1155: l_where_position Integer;
1156: l_key_Table Integer;
1157: l_column_name1 GMA_ACTDATA_WF.COLUMN_NAME1%TYPE DEFAULT NULL;
1158: l_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;
1159: l_column_name2 GMA_ACTDATA_WF.COLUMN_NAME2%TYPE DEFAULT NULL;
1160: l_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
1161: l_column_name3 GMA_ACTDATA_WF.COLUMN_NAME3%TYPE DEFAULT NULL;

Line 1158: l_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;

1154: l_sql_stmt VARCHAR2(4000);
1155: l_where_position Integer;
1156: l_key_Table Integer;
1157: l_column_name1 GMA_ACTDATA_WF.COLUMN_NAME1%TYPE DEFAULT NULL;
1158: l_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;
1159: l_column_name2 GMA_ACTDATA_WF.COLUMN_NAME2%TYPE DEFAULT NULL;
1160: l_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
1161: l_column_name3 GMA_ACTDATA_WF.COLUMN_NAME3%TYPE DEFAULT NULL;
1162: l_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;

Line 1159: l_column_name2 GMA_ACTDATA_WF.COLUMN_NAME2%TYPE DEFAULT NULL;

1155: l_where_position Integer;
1156: l_key_Table Integer;
1157: l_column_name1 GMA_ACTDATA_WF.COLUMN_NAME1%TYPE DEFAULT NULL;
1158: l_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;
1159: l_column_name2 GMA_ACTDATA_WF.COLUMN_NAME2%TYPE DEFAULT NULL;
1160: l_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
1161: l_column_name3 GMA_ACTDATA_WF.COLUMN_NAME3%TYPE DEFAULT NULL;
1162: l_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
1163: l_column_name4 GMA_ACTDATA_WF.COLUMN_NAME4%TYPE DEFAULT NULL;

Line 1160: l_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;

1156: l_key_Table Integer;
1157: l_column_name1 GMA_ACTDATA_WF.COLUMN_NAME1%TYPE DEFAULT NULL;
1158: l_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;
1159: l_column_name2 GMA_ACTDATA_WF.COLUMN_NAME2%TYPE DEFAULT NULL;
1160: l_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
1161: l_column_name3 GMA_ACTDATA_WF.COLUMN_NAME3%TYPE DEFAULT NULL;
1162: l_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
1163: l_column_name4 GMA_ACTDATA_WF.COLUMN_NAME4%TYPE DEFAULT NULL;
1164: l_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;

Line 1161: l_column_name3 GMA_ACTDATA_WF.COLUMN_NAME3%TYPE DEFAULT NULL;

1157: l_column_name1 GMA_ACTDATA_WF.COLUMN_NAME1%TYPE DEFAULT NULL;
1158: l_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;
1159: l_column_name2 GMA_ACTDATA_WF.COLUMN_NAME2%TYPE DEFAULT NULL;
1160: l_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
1161: l_column_name3 GMA_ACTDATA_WF.COLUMN_NAME3%TYPE DEFAULT NULL;
1162: l_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
1163: l_column_name4 GMA_ACTDATA_WF.COLUMN_NAME4%TYPE DEFAULT NULL;
1164: l_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
1165: l_column_name5 GMA_ACTDATA_WF.COLUMN_NAME5%TYPE DEFAULT NULL;

Line 1162: l_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;

1158: l_column_value1 GMA_ACTDATA_WF.COLUMN_VALUE1%TYPE DEFAULT NULL;
1159: l_column_name2 GMA_ACTDATA_WF.COLUMN_NAME2%TYPE DEFAULT NULL;
1160: l_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
1161: l_column_name3 GMA_ACTDATA_WF.COLUMN_NAME3%TYPE DEFAULT NULL;
1162: l_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
1163: l_column_name4 GMA_ACTDATA_WF.COLUMN_NAME4%TYPE DEFAULT NULL;
1164: l_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
1165: l_column_name5 GMA_ACTDATA_WF.COLUMN_NAME5%TYPE DEFAULT NULL;
1166: l_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;

Line 1163: l_column_name4 GMA_ACTDATA_WF.COLUMN_NAME4%TYPE DEFAULT NULL;

1159: l_column_name2 GMA_ACTDATA_WF.COLUMN_NAME2%TYPE DEFAULT NULL;
1160: l_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
1161: l_column_name3 GMA_ACTDATA_WF.COLUMN_NAME3%TYPE DEFAULT NULL;
1162: l_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
1163: l_column_name4 GMA_ACTDATA_WF.COLUMN_NAME4%TYPE DEFAULT NULL;
1164: l_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
1165: l_column_name5 GMA_ACTDATA_WF.COLUMN_NAME5%TYPE DEFAULT NULL;
1166: l_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
1167: l_column_name6 GMA_ACTDATA_WF.COLUMN_NAME6%TYPE DEFAULT NULL;

Line 1164: l_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;

1160: l_column_value2 GMA_ACTDATA_WF.COLUMN_VALUE2%TYPE DEFAULT NULL;
1161: l_column_name3 GMA_ACTDATA_WF.COLUMN_NAME3%TYPE DEFAULT NULL;
1162: l_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
1163: l_column_name4 GMA_ACTDATA_WF.COLUMN_NAME4%TYPE DEFAULT NULL;
1164: l_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
1165: l_column_name5 GMA_ACTDATA_WF.COLUMN_NAME5%TYPE DEFAULT NULL;
1166: l_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
1167: l_column_name6 GMA_ACTDATA_WF.COLUMN_NAME6%TYPE DEFAULT NULL;
1168: l_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;

Line 1165: l_column_name5 GMA_ACTDATA_WF.COLUMN_NAME5%TYPE DEFAULT NULL;

1161: l_column_name3 GMA_ACTDATA_WF.COLUMN_NAME3%TYPE DEFAULT NULL;
1162: l_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
1163: l_column_name4 GMA_ACTDATA_WF.COLUMN_NAME4%TYPE DEFAULT NULL;
1164: l_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
1165: l_column_name5 GMA_ACTDATA_WF.COLUMN_NAME5%TYPE DEFAULT NULL;
1166: l_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
1167: l_column_name6 GMA_ACTDATA_WF.COLUMN_NAME6%TYPE DEFAULT NULL;
1168: l_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
1169: l_column_name7 GMA_ACTDATA_WF.COLUMN_NAME7%TYPE DEFAULT NULL;

Line 1166: l_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;

1162: l_column_value3 GMA_ACTDATA_WF.COLUMN_VALUE3%TYPE DEFAULT NULL;
1163: l_column_name4 GMA_ACTDATA_WF.COLUMN_NAME4%TYPE DEFAULT NULL;
1164: l_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
1165: l_column_name5 GMA_ACTDATA_WF.COLUMN_NAME5%TYPE DEFAULT NULL;
1166: l_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
1167: l_column_name6 GMA_ACTDATA_WF.COLUMN_NAME6%TYPE DEFAULT NULL;
1168: l_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
1169: l_column_name7 GMA_ACTDATA_WF.COLUMN_NAME7%TYPE DEFAULT NULL;
1170: l_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;

Line 1167: l_column_name6 GMA_ACTDATA_WF.COLUMN_NAME6%TYPE DEFAULT NULL;

1163: l_column_name4 GMA_ACTDATA_WF.COLUMN_NAME4%TYPE DEFAULT NULL;
1164: l_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
1165: l_column_name5 GMA_ACTDATA_WF.COLUMN_NAME5%TYPE DEFAULT NULL;
1166: l_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
1167: l_column_name6 GMA_ACTDATA_WF.COLUMN_NAME6%TYPE DEFAULT NULL;
1168: l_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
1169: l_column_name7 GMA_ACTDATA_WF.COLUMN_NAME7%TYPE DEFAULT NULL;
1170: l_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
1171: l_column_name8 GMA_ACTDATA_WF.COLUMN_NAME8%TYPE DEFAULT NULL;

Line 1168: l_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;

1164: l_column_value4 GMA_ACTDATA_WF.COLUMN_VALUE4%TYPE DEFAULT NULL;
1165: l_column_name5 GMA_ACTDATA_WF.COLUMN_NAME5%TYPE DEFAULT NULL;
1166: l_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
1167: l_column_name6 GMA_ACTDATA_WF.COLUMN_NAME6%TYPE DEFAULT NULL;
1168: l_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
1169: l_column_name7 GMA_ACTDATA_WF.COLUMN_NAME7%TYPE DEFAULT NULL;
1170: l_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
1171: l_column_name8 GMA_ACTDATA_WF.COLUMN_NAME8%TYPE DEFAULT NULL;
1172: l_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;

Line 1169: l_column_name7 GMA_ACTDATA_WF.COLUMN_NAME7%TYPE DEFAULT NULL;

1165: l_column_name5 GMA_ACTDATA_WF.COLUMN_NAME5%TYPE DEFAULT NULL;
1166: l_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
1167: l_column_name6 GMA_ACTDATA_WF.COLUMN_NAME6%TYPE DEFAULT NULL;
1168: l_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
1169: l_column_name7 GMA_ACTDATA_WF.COLUMN_NAME7%TYPE DEFAULT NULL;
1170: l_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
1171: l_column_name8 GMA_ACTDATA_WF.COLUMN_NAME8%TYPE DEFAULT NULL;
1172: l_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
1173: l_column_name9 GMA_ACTDATA_WF.COLUMN_NAME9%TYPE DEFAULT NULL;

Line 1170: l_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;

1166: l_column_value5 GMA_ACTDATA_WF.COLUMN_VALUE5%TYPE DEFAULT NULL;
1167: l_column_name6 GMA_ACTDATA_WF.COLUMN_NAME6%TYPE DEFAULT NULL;
1168: l_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
1169: l_column_name7 GMA_ACTDATA_WF.COLUMN_NAME7%TYPE DEFAULT NULL;
1170: l_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
1171: l_column_name8 GMA_ACTDATA_WF.COLUMN_NAME8%TYPE DEFAULT NULL;
1172: l_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
1173: l_column_name9 GMA_ACTDATA_WF.COLUMN_NAME9%TYPE DEFAULT NULL;
1174: l_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;

Line 1171: l_column_name8 GMA_ACTDATA_WF.COLUMN_NAME8%TYPE DEFAULT NULL;

1167: l_column_name6 GMA_ACTDATA_WF.COLUMN_NAME6%TYPE DEFAULT NULL;
1168: l_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
1169: l_column_name7 GMA_ACTDATA_WF.COLUMN_NAME7%TYPE DEFAULT NULL;
1170: l_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
1171: l_column_name8 GMA_ACTDATA_WF.COLUMN_NAME8%TYPE DEFAULT NULL;
1172: l_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
1173: l_column_name9 GMA_ACTDATA_WF.COLUMN_NAME9%TYPE DEFAULT NULL;
1174: l_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;
1175: l_column_name10 GMA_ACTDATA_WF.COLUMN_NAME10%TYPE DEFAULT NULL;

Line 1172: l_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;

1168: l_column_value6 GMA_ACTDATA_WF.COLUMN_VALUE6%TYPE DEFAULT NULL;
1169: l_column_name7 GMA_ACTDATA_WF.COLUMN_NAME7%TYPE DEFAULT NULL;
1170: l_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
1171: l_column_name8 GMA_ACTDATA_WF.COLUMN_NAME8%TYPE DEFAULT NULL;
1172: l_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
1173: l_column_name9 GMA_ACTDATA_WF.COLUMN_NAME9%TYPE DEFAULT NULL;
1174: l_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;
1175: l_column_name10 GMA_ACTDATA_WF.COLUMN_NAME10%TYPE DEFAULT NULL;
1176: l_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;

Line 1173: l_column_name9 GMA_ACTDATA_WF.COLUMN_NAME9%TYPE DEFAULT NULL;

1169: l_column_name7 GMA_ACTDATA_WF.COLUMN_NAME7%TYPE DEFAULT NULL;
1170: l_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
1171: l_column_name8 GMA_ACTDATA_WF.COLUMN_NAME8%TYPE DEFAULT NULL;
1172: l_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
1173: l_column_name9 GMA_ACTDATA_WF.COLUMN_NAME9%TYPE DEFAULT NULL;
1174: l_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;
1175: l_column_name10 GMA_ACTDATA_WF.COLUMN_NAME10%TYPE DEFAULT NULL;
1176: l_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;
1177: l_column_prompt1 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;

Line 1174: l_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;

1170: l_column_value7 GMA_ACTDATA_WF.COLUMN_VALUE7%TYPE DEFAULT NULL;
1171: l_column_name8 GMA_ACTDATA_WF.COLUMN_NAME8%TYPE DEFAULT NULL;
1172: l_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
1173: l_column_name9 GMA_ACTDATA_WF.COLUMN_NAME9%TYPE DEFAULT NULL;
1174: l_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;
1175: l_column_name10 GMA_ACTDATA_WF.COLUMN_NAME10%TYPE DEFAULT NULL;
1176: l_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;
1177: l_column_prompt1 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;
1178: l_column_prompt2 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;

Line 1175: l_column_name10 GMA_ACTDATA_WF.COLUMN_NAME10%TYPE DEFAULT NULL;

1171: l_column_name8 GMA_ACTDATA_WF.COLUMN_NAME8%TYPE DEFAULT NULL;
1172: l_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
1173: l_column_name9 GMA_ACTDATA_WF.COLUMN_NAME9%TYPE DEFAULT NULL;
1174: l_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;
1175: l_column_name10 GMA_ACTDATA_WF.COLUMN_NAME10%TYPE DEFAULT NULL;
1176: l_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;
1177: l_column_prompt1 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;
1178: l_column_prompt2 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;
1179: l_column_prompt3 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;

Line 1176: l_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;

1172: l_column_value8 GMA_ACTDATA_WF.COLUMN_VALUE8%TYPE DEFAULT NULL;
1173: l_column_name9 GMA_ACTDATA_WF.COLUMN_NAME9%TYPE DEFAULT NULL;
1174: l_column_value9 GMA_ACTDATA_WF.COLUMN_VALUE9%TYPE DEFAULT NULL;
1175: l_column_name10 GMA_ACTDATA_WF.COLUMN_NAME10%TYPE DEFAULT NULL;
1176: l_column_value10 GMA_ACTDATA_WF.COLUMN_VALUE10%TYPE DEFAULT NULL;
1177: l_column_prompt1 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;
1178: l_column_prompt2 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;
1179: l_column_prompt3 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;
1180: l_column_prompt4 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;

Line 1188: l_activity_id GMA_ACTDATA_WF.ACTIVITY_ID%TYPE;

1184: l_column_prompt8 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;
1185: l_column_prompt9 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;
1186: l_column_prompt10 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;
1187:
1188: l_activity_id GMA_ACTDATA_WF.ACTIVITY_ID%TYPE;
1189: /* Cursor to get the column list for a given activity */
1190: V_cursor_id INTEGER;
1191: v_dummy INTEGER;
1192: Data_string Varchar2(2500);

Line 1194: l_temp_col_name GMA_ACTDATA_WF.COLUMN_NAME1%TYPE;

1190: V_cursor_id INTEGER;
1191: v_dummy INTEGER;
1192: Data_string Varchar2(2500);
1193: wf_Data_string Varchar2(2500);
1194: l_temp_col_name GMA_ACTDATA_WF.COLUMN_NAME1%TYPE;
1195: l_temp_prompt GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE;
1196: CURSOR Cur_Actcol_wf IS
1197: SELECT COLUMN_NAME,COLUMN_PROMPT
1198: FROM gma_actcol_wf_vl