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.HZ_PARTY_STAGE dependencies on DBMS_SQL

Line 11397: c := dbms_sql.open_cursor;

11393: n NUMBER;
11394: l_custom BOOLEAN;
11395:
11396: BEGIN
11397: c := dbms_sql.open_cursor;
11398: l_sql := 'select ' || proc ||
11399: '(:attrval,:lang,:attr,:entity,:ctx) from dual';
11400: dbms_sql.parse(c,l_sql,2);
11401: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');

Line 11400: dbms_sql.parse(c,l_sql,2);

11396: BEGIN
11397: c := dbms_sql.open_cursor;
11398: l_sql := 'select ' || proc ||
11399: '(:attrval,:lang,:attr,:entity,:ctx) from dual';
11400: dbms_sql.parse(c,l_sql,2);
11401: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');
11402: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
11403: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
11404: DBMS_SQL.BIND_VARIABLE(c,':entity','x');

Line 11401: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');

11397: c := dbms_sql.open_cursor;
11398: l_sql := 'select ' || proc ||
11399: '(:attrval,:lang,:attr,:entity,:ctx) from dual';
11400: dbms_sql.parse(c,l_sql,2);
11401: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');
11402: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
11403: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
11404: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
11405: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');

Line 11402: DBMS_SQL.BIND_VARIABLE(c,':lang','x');

11398: l_sql := 'select ' || proc ||
11399: '(:attrval,:lang,:attr,:entity,:ctx) from dual';
11400: dbms_sql.parse(c,l_sql,2);
11401: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');
11402: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
11403: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
11404: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
11405: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
11406: n:=DBMS_SQL.execute(c);

Line 11403: DBMS_SQL.BIND_VARIABLE(c,':attr','x');

11399: '(:attrval,:lang,:attr,:entity,:ctx) from dual';
11400: dbms_sql.parse(c,l_sql,2);
11401: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');
11402: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
11403: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
11404: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
11405: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
11406: n:=DBMS_SQL.execute(c);
11407: dbms_sql.close_cursor(c);

Line 11404: DBMS_SQL.BIND_VARIABLE(c,':entity','x');

11400: dbms_sql.parse(c,l_sql,2);
11401: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');
11402: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
11403: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
11404: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
11405: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
11406: n:=DBMS_SQL.execute(c);
11407: dbms_sql.close_cursor(c);
11408: RETURN TRUE;

Line 11405: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');

11401: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');
11402: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
11403: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
11404: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
11405: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
11406: n:=DBMS_SQL.execute(c);
11407: dbms_sql.close_cursor(c);
11408: RETURN TRUE;
11409: EXCEPTION

Line 11406: n:=DBMS_SQL.execute(c);

11402: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
11403: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
11404: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
11405: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
11406: n:=DBMS_SQL.execute(c);
11407: dbms_sql.close_cursor(c);
11408: RETURN TRUE;
11409: EXCEPTION
11410: WHEN OTHERS THEN

Line 11407: dbms_sql.close_cursor(c);

11403: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
11404: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
11405: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
11406: n:=DBMS_SQL.execute(c);
11407: dbms_sql.close_cursor(c);
11408: RETURN TRUE;
11409: EXCEPTION
11410: WHEN OTHERS THEN
11411: dbms_sql.close_cursor(c);

Line 11411: dbms_sql.close_cursor(c);

11407: dbms_sql.close_cursor(c);
11408: RETURN TRUE;
11409: EXCEPTION
11410: WHEN OTHERS THEN
11411: dbms_sql.close_cursor(c);
11412: RETURN FALSE;
11413: END;
11414:
11415: FUNCTION has_context(proc VARCHAR2) RETURN BOOLEAN IS

Line 11426: c := dbms_sql.open_cursor;

11422: n NUMBER;
11423: l_custom BOOLEAN;
11424:
11425: BEGIN
11426: c := dbms_sql.open_cursor;
11427: l_sql := 'select ' || proc ||
11428: '(:record_id,:entity,:attr,:ctx) from dual';
11429: dbms_sql.parse(c,l_sql,2);
11430: DBMS_SQL.BIND_VARIABLE(c,':record_id','x');

Line 11429: dbms_sql.parse(c,l_sql,2);

11425: BEGIN
11426: c := dbms_sql.open_cursor;
11427: l_sql := 'select ' || proc ||
11428: '(:record_id,:entity,:attr,:ctx) from dual';
11429: dbms_sql.parse(c,l_sql,2);
11430: DBMS_SQL.BIND_VARIABLE(c,':record_id','x');
11431: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
11432: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
11433: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');

Line 11430: DBMS_SQL.BIND_VARIABLE(c,':record_id','x');

11426: c := dbms_sql.open_cursor;
11427: l_sql := 'select ' || proc ||
11428: '(:record_id,:entity,:attr,:ctx) from dual';
11429: dbms_sql.parse(c,l_sql,2);
11430: DBMS_SQL.BIND_VARIABLE(c,':record_id','x');
11431: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
11432: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
11433: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
11434: n:=DBMS_SQL.execute(c);

Line 11431: DBMS_SQL.BIND_VARIABLE(c,':entity','x');

11427: l_sql := 'select ' || proc ||
11428: '(:record_id,:entity,:attr,:ctx) from dual';
11429: dbms_sql.parse(c,l_sql,2);
11430: DBMS_SQL.BIND_VARIABLE(c,':record_id','x');
11431: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
11432: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
11433: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
11434: n:=DBMS_SQL.execute(c);
11435: dbms_sql.close_cursor(c);

Line 11432: DBMS_SQL.BIND_VARIABLE(c,':attr','x');

11428: '(:record_id,:entity,:attr,:ctx) from dual';
11429: dbms_sql.parse(c,l_sql,2);
11430: DBMS_SQL.BIND_VARIABLE(c,':record_id','x');
11431: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
11432: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
11433: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
11434: n:=DBMS_SQL.execute(c);
11435: dbms_sql.close_cursor(c);
11436: RETURN TRUE;

Line 11433: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');

11429: dbms_sql.parse(c,l_sql,2);
11430: DBMS_SQL.BIND_VARIABLE(c,':record_id','x');
11431: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
11432: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
11433: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
11434: n:=DBMS_SQL.execute(c);
11435: dbms_sql.close_cursor(c);
11436: RETURN TRUE;
11437: EXCEPTION

Line 11434: n:=DBMS_SQL.execute(c);

11430: DBMS_SQL.BIND_VARIABLE(c,':record_id','x');
11431: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
11432: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
11433: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
11434: n:=DBMS_SQL.execute(c);
11435: dbms_sql.close_cursor(c);
11436: RETURN TRUE;
11437: EXCEPTION
11438: WHEN OTHERS THEN

Line 11435: dbms_sql.close_cursor(c);

11431: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
11432: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
11433: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
11434: n:=DBMS_SQL.execute(c);
11435: dbms_sql.close_cursor(c);
11436: RETURN TRUE;
11437: EXCEPTION
11438: WHEN OTHERS THEN
11439: dbms_sql.close_cursor(c);

Line 11439: dbms_sql.close_cursor(c);

11435: dbms_sql.close_cursor(c);
11436: RETURN TRUE;
11437: EXCEPTION
11438: WHEN OTHERS THEN
11439: dbms_sql.close_cursor(c);
11440: RETURN FALSE;
11441: END;
11442:
11443:

Line 11465: c := dbms_sql.open_cursor;

11461: l_entity := FUNCS.ENTITY_NAME;
11462: l_attribute := FUNCS.ATTRIBUTE_NAME;
11463: l_procedure := FUNCS.PROCEDURE_NAME;
11464: l_trans_name := FUNCS.TRANSFORMATION_NAME;
11465: c := dbms_sql.open_cursor;
11466: l_sql := 'select ' || FUNCS.PROCEDURE_NAME ||
11467: '(:attrval,:lang,:attr,:entity) from dual';
11468: dbms_sql.parse(c,l_sql,2);
11469: dbms_sql.close_cursor(c);

Line 11468: dbms_sql.parse(c,l_sql,2);

11464: l_trans_name := FUNCS.TRANSFORMATION_NAME;
11465: c := dbms_sql.open_cursor;
11466: l_sql := 'select ' || FUNCS.PROCEDURE_NAME ||
11467: '(:attrval,:lang,:attr,:entity) from dual';
11468: dbms_sql.parse(c,l_sql,2);
11469: dbms_sql.close_cursor(c);
11470: EXCEPTION WHEN OTHERS THEN
11471: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANS_PROC_ERROR1');
11472: FND_MESSAGE.SET_TOKEN('PROC' ,l_procedure);

Line 11469: dbms_sql.close_cursor(c);

11465: c := dbms_sql.open_cursor;
11466: l_sql := 'select ' || FUNCS.PROCEDURE_NAME ||
11467: '(:attrval,:lang,:attr,:entity) from dual';
11468: dbms_sql.parse(c,l_sql,2);
11469: dbms_sql.close_cursor(c);
11470: EXCEPTION WHEN OTHERS THEN
11471: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANS_PROC_ERROR1');
11472: FND_MESSAGE.SET_TOKEN('PROC' ,l_procedure);
11473: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_entity);

Line 11492: c := dbms_sql.open_cursor;

11488: l_custom := TRUE;
11489: l_entity := FUNCS.ENTITY_NAME;
11490: l_attribute := FUNCS.ATTRIBUTE_NAME;
11491: l_procedure := FUNCS.custom_attribute_procedure;
11492: c := dbms_sql.open_cursor;
11493: l_sql := 'select ' || FUNCS.custom_attribute_procedure ||
11494: '(:record_id,:entity,:attr) from dual';
11495: dbms_sql.parse(c,l_sql,2);
11496: dbms_sql.close_cursor(c);

Line 11495: dbms_sql.parse(c,l_sql,2);

11491: l_procedure := FUNCS.custom_attribute_procedure;
11492: c := dbms_sql.open_cursor;
11493: l_sql := 'select ' || FUNCS.custom_attribute_procedure ||
11494: '(:record_id,:entity,:attr) from dual';
11495: dbms_sql.parse(c,l_sql,2);
11496: dbms_sql.close_cursor(c);
11497: EXCEPTION WHEN OTHERS THEN
11498: FND_MESSAGE.SET_NAME('AR', 'HZ_CUSTOM_PROC_ERROR1');
11499: FND_MESSAGE.SET_TOKEN('PROC' ,l_procedure);

Line 11496: dbms_sql.close_cursor(c);

11492: c := dbms_sql.open_cursor;
11493: l_sql := 'select ' || FUNCS.custom_attribute_procedure ||
11494: '(:record_id,:entity,:attr) from dual';
11495: dbms_sql.parse(c,l_sql,2);
11496: dbms_sql.close_cursor(c);
11497: EXCEPTION WHEN OTHERS THEN
11498: FND_MESSAGE.SET_NAME('AR', 'HZ_CUSTOM_PROC_ERROR1');
11499: FND_MESSAGE.SET_TOKEN('PROC' ,l_procedure);
11500: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_entity);

Line 11507: dbms_sql.close_cursor(c);

11503: END;
11504: END LOOP;
11505: EXCEPTION
11506: WHEN OTHERS THEN
11507: dbms_sql.close_cursor(c);
11508: RAISE FND_API.G_EXC_ERROR;
11509: END ;
11510:
11511: