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.BSC_LAUNCH_PAD_PVT dependencies on FND_FORM_FUNCTIONS

Line 176: | Description: it is a wrapper for FND_FORM_FUNCTIONS_PKG.INSERT_ROW function

172: /*===========================================================================+
173: |
174: | Name: INSERT_FORM_FUNCTION_VB
175: |
176: | Description: it is a wrapper for FND_FORM_FUNCTIONS_PKG.INSERT_ROW function
177: | This procedure is to be called from a VB program.
178: | If there is an error, the procedure inserts the error
179: | message in BSC_MESSAGE_LOGS table.
180: |

Line 205: DELETE FND_FORM_FUNCTIONS WHERE FUNCTION_ID = X_FUNCTION_ID;

201: ) IS
202: row_id VARCHAR2(30);
203:
204: BEGIN
205: DELETE FND_FORM_FUNCTIONS WHERE FUNCTION_ID = X_FUNCTION_ID;
206: DELETE FND_FORM_FUNCTIONS_TL WHERE FUNCTION_ID = X_FUNCTION_ID;
207: fnd_form_functions_pkg.INSERT_ROW( X_ROWID => row_id,
208: X_FUNCTION_ID => X_FUNCTION_ID,
209: X_WEB_HOST_NAME => X_WEB_HOST_NAME,

Line 206: DELETE FND_FORM_FUNCTIONS_TL WHERE FUNCTION_ID = X_FUNCTION_ID;

202: row_id VARCHAR2(30);
203:
204: BEGIN
205: DELETE FND_FORM_FUNCTIONS WHERE FUNCTION_ID = X_FUNCTION_ID;
206: DELETE FND_FORM_FUNCTIONS_TL WHERE FUNCTION_ID = X_FUNCTION_ID;
207: fnd_form_functions_pkg.INSERT_ROW( X_ROWID => row_id,
208: X_FUNCTION_ID => X_FUNCTION_ID,
209: X_WEB_HOST_NAME => X_WEB_HOST_NAME,
210: X_WEB_AGENT_NAME => X_WEB_AGENT_NAME,

Line 207: fnd_form_functions_pkg.INSERT_ROW( X_ROWID => row_id,

203:
204: BEGIN
205: DELETE FND_FORM_FUNCTIONS WHERE FUNCTION_ID = X_FUNCTION_ID;
206: DELETE FND_FORM_FUNCTIONS_TL WHERE FUNCTION_ID = X_FUNCTION_ID;
207: fnd_form_functions_pkg.INSERT_ROW( X_ROWID => row_id,
208: X_FUNCTION_ID => X_FUNCTION_ID,
209: X_WEB_HOST_NAME => X_WEB_HOST_NAME,
210: X_WEB_AGENT_NAME => X_WEB_AGENT_NAME,
211: X_WEB_HTML_CALL => X_WEB_HTML_CALL,

Line 242: | Description: it is a wrapper for FND_FORM_FUNCTIONS_PKG.UPDATE_ROW function

238: /*===========================================================================+
239: |
240: | Name: UPDATE_FORM_FUNCTION_VB
241: |
242: | Description: it is a wrapper for FND_FORM_FUNCTIONS_PKG.UPDATE_ROW function
243: | This procedure is to be called from a VB program.
244: | If there is an error, the procedure inserts the error
245: | message in BSC_MESSAGE_LOGS table.
246: |

Line 270: fnd_form_functions_pkg.UPDATE_ROW(X_FUNCTION_ID => X_FUNCTION_ID,

266: X_USER_ID in NUMBER
267: ) IS
268: row_id VARCHAR2(30);
269: BEGIN
270: fnd_form_functions_pkg.UPDATE_ROW(X_FUNCTION_ID => X_FUNCTION_ID,
271: X_WEB_HOST_NAME => X_WEB_HOST_NAME,
272: X_WEB_AGENT_NAME => X_WEB_AGENT_NAME,
273: X_WEB_HTML_CALL => X_WEB_HTML_CALL,
274: X_WEB_ENCRYPT_PARAMETERS => X_WEB_ENCRYPT_PARAMETERS,

Line 302: | Description: it is a wrapper for FND_FORM_FUNCTIONS_PKG.DELETE_ROW function

298: /*===========================================================================+
299: |
300: | Name: DELETE_FORM_FUNCTION_VB
301: |
302: | Description: it is a wrapper for FND_FORM_FUNCTIONS_PKG.DELETE_ROW function
303: | This procedure is to be called from a VB program.
304: | If there is an error, the procedure inserts the error
305: | message in BSC_MESSAGE_LOGS table.
306: |

Line 313: fnd_form_functions_pkg.DELETE_ROW(X_FUNCTION_ID => X_FUNCTION_ID);

309: PROCEDURE DELETE_FORM_FUNCTION_VB(X_FUNCTION_ID in NUMBER
310: ) IS
311: row_id VARCHAR2(30);
312: BEGIN
313: fnd_form_functions_pkg.DELETE_ROW(X_FUNCTION_ID => X_FUNCTION_ID);
314:
315: EXCEPTION
316: WHEN OTHERS THEN
317: BSC_MESSAGE.Add(x_message => SQLERRM,

Line 348: FROM FND_FORM_FUNCTIONS_VL

344: BEGIN
345: -- Name
346: SELECT count(*)
347: INTO h_count
348: FROM FND_FORM_FUNCTIONS_VL
349: WHERE FUNCTION_ID <> X_FUNCTION_ID
350: AND (FUNCTION_NAME = X_FUNCTION_NAME);
351: IF h_count > 0 THEN
352: h_val := 'N';

Line 358: FROM FND_FORM_FUNCTIONS_VL

354: END IF;
355: -- User Name
356: SELECT count(*)
357: INTO h_count
358: FROM FND_FORM_FUNCTIONS_VL
359: WHERE FUNCTION_ID <> X_FUNCTION_ID
360: AND (USER_FUNCTION_NAME = X_USER_FUNCTION_NAME);
361: IF h_count > 0 THEN
362: h_val := 'U';

Line 620: h_function_name FND_FORM_FUNCTIONS.function_name%TYPE;

616: h_user_id NUMBER;
617: h_menu_type VARCHAR2(30);
618: h_description VARCHAR2(240);
619:
620: h_function_name FND_FORM_FUNCTIONS.function_name%TYPE;
621: h_user_function_name VARCHAR2(80);
622: h_function_id_src NUMBER;
623:
624: CURSOR c_function_id IS

Line 626: FROM fnd_form_functions

622: h_function_id_src NUMBER;
623:
624: CURSOR c_function_id IS
625: SELECT function_id
626: FROM fnd_form_functions
627: WHERE function_name = h_function_name;
628:
629: CURSOR c_function_id_u IS
630: SELECT function_id

Line 631: FROM fnd_form_functions_vl

627: WHERE function_name = h_function_name;
628:
629: CURSOR c_function_id_u IS
630: SELECT function_id
631: FROM fnd_form_functions_vl
632: WHERE user_function_name = h_user_function_name;
633:
634: h_function_id NUMBER;
635: h_web_host_name VARCHAR2(80);

Line 758: ' FROM FND_MENU_ENTRIES@'||x_src_db_link||' SE, FND_FORM_FUNCTIONS_VL@'||x_src_db_link||' SF'||

754: -- and are not associated with the same menu in the target system.
755: -- We need to create those entries in the target menu.
756: -- Only see BSC functions
757: h_sql := 'SELECT SF.FUNCTION_NAME, SF.USER_FUNCTION_NAME, SF.FUNCTION_ID'||
758: ' FROM FND_MENU_ENTRIES@'||x_src_db_link||' SE, FND_FORM_FUNCTIONS_VL@'||x_src_db_link||' SF'||
759: ' WHERE SE.MENU_ID = :1 AND SE.FUNCTION_ID = SF.FUNCTION_ID AND'||
760: ' SF.APPLICATION_ID = 271 AND SF.FUNCTION_NAME NOT IN ('||
761: ' SELECT TF.FUNCTION_NAME FROM FND_MENU_ENTRIES TE, FND_FORM_FUNCTIONS TF'||
762: ' WHERE TE.MENU_ID = :2 AND TE.FUNCTION_ID = TF.FUNCTION_ID AND TF.APPLICATION_ID = 271)';

Line 761: ' SELECT TF.FUNCTION_NAME FROM FND_MENU_ENTRIES TE, FND_FORM_FUNCTIONS TF'||

757: h_sql := 'SELECT SF.FUNCTION_NAME, SF.USER_FUNCTION_NAME, SF.FUNCTION_ID'||
758: ' FROM FND_MENU_ENTRIES@'||x_src_db_link||' SE, FND_FORM_FUNCTIONS_VL@'||x_src_db_link||' SF'||
759: ' WHERE SE.MENU_ID = :1 AND SE.FUNCTION_ID = SF.FUNCTION_ID AND'||
760: ' SF.APPLICATION_ID = 271 AND SF.FUNCTION_NAME NOT IN ('||
761: ' SELECT TF.FUNCTION_NAME FROM FND_MENU_ENTRIES TE, FND_FORM_FUNCTIONS TF'||
762: ' WHERE TE.MENU_ID = :2 AND TE.FUNCTION_ID = TF.FUNCTION_ID AND TF.APPLICATION_ID = 271)';
763: /*' WHERE TE.MENU_ID = '||h_menu_id||' AND TE.FUNCTION_ID = TF.FUNCTION_ID AND TF.APPLICATION_ID = 271)';*/
764:
765: h_cursor1 := DBMS_SQL.OPEN_CURSOR;

Line 801: SELECT fnd_form_functions_s.nextval INTO h_function_id FROM DUAL;

797:
798: -- Create the function if does not exist. We know that it is a BSC function.
799: IF h_function_id = -1 THEN
800: -- Get the function_id
801: SELECT fnd_form_functions_s.nextval INTO h_function_id FROM DUAL;
802:
803: -- Get all info about the function in the source to create it in the target
804: h_web_host_name := NULL;
805: h_web_agent_name := NULL;

Line 823: ' FROM fnd_form_functions_vl@'||x_src_db_link||

819: h_sql := 'SELECT web_host_name, web_agent_name, web_html_call,'||
820: ' web_encrypt_parameters, web_secured, web_icon, object_id,'||
821: ' region_application_id, region_code, application_id,'||
822: ' form_id, parameters, type, description'||
823: ' FROM fnd_form_functions_vl@'||x_src_db_link||
824: ' WHERE function_name = :1';
825: /*' WHERE function_name = '''||h_function_name||'''';*/
826:
827: h_cursor2 := DBMS_SQL.OPEN_CURSOR;

Line 866: FND_FORM_FUNCTIONS_PKG.INSERT_ROW(

862: END IF;
863: DBMS_SQL.CLOSE_CURSOR(h_cursor2);
864:
865: -- call the api to create the function
866: FND_FORM_FUNCTIONS_PKG.INSERT_ROW(
867: X_ROWID => h_row_id,
868: X_FUNCTION_ID => h_function_id,
869: X_WEB_HOST_NAME => h_web_host_name,
870: X_WEB_AGENT_NAME => h_web_agent_name,