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_ACTCOL_WF_TL

Line 1177: l_column_prompt1 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%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;
1181: l_column_prompt5 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;

Line 1178: l_column_prompt2 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%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;
1181: l_column_prompt5 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;
1182: l_column_prompt6 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;

Line 1179: l_column_prompt3 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%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;
1181: l_column_prompt5 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;
1182: l_column_prompt6 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;
1183: l_column_prompt7 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;

Line 1180: l_column_prompt4 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%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;
1181: l_column_prompt5 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;
1182: l_column_prompt6 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;
1183: l_column_prompt7 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;
1184: l_column_prompt8 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;

Line 1181: l_column_prompt5 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%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;
1181: l_column_prompt5 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;
1182: l_column_prompt6 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;
1183: l_column_prompt7 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;
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;

Line 1182: l_column_prompt6 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;
1181: l_column_prompt5 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;
1182: l_column_prompt6 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;
1183: l_column_prompt7 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;
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;

Line 1183: l_column_prompt7 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;
1181: l_column_prompt5 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;
1182: l_column_prompt6 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;
1183: l_column_prompt7 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;
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:

Line 1184: l_column_prompt8 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;

1180: l_column_prompt4 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;
1181: l_column_prompt5 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;
1182: l_column_prompt6 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;
1183: l_column_prompt7 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;
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;

Line 1185: l_column_prompt9 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;

1181: l_column_prompt5 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;
1182: l_column_prompt6 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;
1183: l_column_prompt7 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;
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 */

Line 1186: l_column_prompt10 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;

1182: l_column_prompt6 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;
1183: l_column_prompt7 GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE DEFAULT NULL;
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;

Line 1195: l_temp_prompt GMA_ACTCOL_WF_TL.COLUMN_PROMPT%TYPE;

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
1199: WHERE activity_id = l_activity_id