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 11551: c := dbms_sql.open_cursor;

11547: n NUMBER;
11548: l_custom BOOLEAN;
11549:
11550: BEGIN
11551: c := dbms_sql.open_cursor;
11552: l_sql := 'select ' || proc ||
11553: '(:attrval,:lang,:attr,:entity,:ctx) from dual';
11554: dbms_sql.parse(c,l_sql,2);
11555: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');

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

11550: BEGIN
11551: c := dbms_sql.open_cursor;
11552: l_sql := 'select ' || proc ||
11553: '(:attrval,:lang,:attr,:entity,:ctx) from dual';
11554: dbms_sql.parse(c,l_sql,2);
11555: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');
11556: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
11557: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
11558: DBMS_SQL.BIND_VARIABLE(c,':entity','x');

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

11551: c := dbms_sql.open_cursor;
11552: l_sql := 'select ' || proc ||
11553: '(:attrval,:lang,:attr,:entity,:ctx) from dual';
11554: dbms_sql.parse(c,l_sql,2);
11555: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');
11556: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
11557: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
11558: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
11559: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');

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

11552: l_sql := 'select ' || proc ||
11553: '(:attrval,:lang,:attr,:entity,:ctx) from dual';
11554: dbms_sql.parse(c,l_sql,2);
11555: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');
11556: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
11557: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
11558: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
11559: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
11560: n:=DBMS_SQL.execute(c);

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

11553: '(:attrval,:lang,:attr,:entity,:ctx) from dual';
11554: dbms_sql.parse(c,l_sql,2);
11555: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');
11556: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
11557: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
11558: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
11559: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
11560: n:=DBMS_SQL.execute(c);
11561: dbms_sql.close_cursor(c);

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

11554: dbms_sql.parse(c,l_sql,2);
11555: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');
11556: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
11557: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
11558: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
11559: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
11560: n:=DBMS_SQL.execute(c);
11561: dbms_sql.close_cursor(c);
11562: RETURN TRUE;

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

11555: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');
11556: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
11557: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
11558: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
11559: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
11560: n:=DBMS_SQL.execute(c);
11561: dbms_sql.close_cursor(c);
11562: RETURN TRUE;
11563: EXCEPTION

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

11556: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
11557: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
11558: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
11559: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
11560: n:=DBMS_SQL.execute(c);
11561: dbms_sql.close_cursor(c);
11562: RETURN TRUE;
11563: EXCEPTION
11564: WHEN OTHERS THEN

Line 11561: dbms_sql.close_cursor(c);

11557: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
11558: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
11559: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
11560: n:=DBMS_SQL.execute(c);
11561: dbms_sql.close_cursor(c);
11562: RETURN TRUE;
11563: EXCEPTION
11564: WHEN OTHERS THEN
11565: dbms_sql.close_cursor(c);

Line 11565: dbms_sql.close_cursor(c);

11561: dbms_sql.close_cursor(c);
11562: RETURN TRUE;
11563: EXCEPTION
11564: WHEN OTHERS THEN
11565: dbms_sql.close_cursor(c);
11566: RETURN FALSE;
11567: END;
11568:
11569: FUNCTION has_context(proc VARCHAR2) RETURN BOOLEAN IS

Line 11580: c := dbms_sql.open_cursor;

11576: n NUMBER;
11577: l_custom BOOLEAN;
11578:
11579: BEGIN
11580: c := dbms_sql.open_cursor;
11581: l_sql := 'select ' || proc ||
11582: '(:record_id,:entity,:attr,:ctx) from dual';
11583: dbms_sql.parse(c,l_sql,2);
11584: DBMS_SQL.BIND_VARIABLE(c,':record_id','x');

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

11579: BEGIN
11580: c := dbms_sql.open_cursor;
11581: l_sql := 'select ' || proc ||
11582: '(:record_id,:entity,:attr,:ctx) from dual';
11583: dbms_sql.parse(c,l_sql,2);
11584: DBMS_SQL.BIND_VARIABLE(c,':record_id','x');
11585: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
11586: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
11587: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');

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

11580: c := dbms_sql.open_cursor;
11581: l_sql := 'select ' || proc ||
11582: '(:record_id,:entity,:attr,:ctx) from dual';
11583: dbms_sql.parse(c,l_sql,2);
11584: DBMS_SQL.BIND_VARIABLE(c,':record_id','x');
11585: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
11586: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
11587: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
11588: n:=DBMS_SQL.execute(c);

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

11581: l_sql := 'select ' || proc ||
11582: '(:record_id,:entity,:attr,:ctx) from dual';
11583: dbms_sql.parse(c,l_sql,2);
11584: DBMS_SQL.BIND_VARIABLE(c,':record_id','x');
11585: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
11586: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
11587: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
11588: n:=DBMS_SQL.execute(c);
11589: dbms_sql.close_cursor(c);

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

11582: '(:record_id,:entity,:attr,:ctx) from dual';
11583: dbms_sql.parse(c,l_sql,2);
11584: DBMS_SQL.BIND_VARIABLE(c,':record_id','x');
11585: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
11586: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
11587: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
11588: n:=DBMS_SQL.execute(c);
11589: dbms_sql.close_cursor(c);
11590: RETURN TRUE;

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

11583: dbms_sql.parse(c,l_sql,2);
11584: DBMS_SQL.BIND_VARIABLE(c,':record_id','x');
11585: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
11586: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
11587: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
11588: n:=DBMS_SQL.execute(c);
11589: dbms_sql.close_cursor(c);
11590: RETURN TRUE;
11591: EXCEPTION

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

11584: DBMS_SQL.BIND_VARIABLE(c,':record_id','x');
11585: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
11586: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
11587: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
11588: n:=DBMS_SQL.execute(c);
11589: dbms_sql.close_cursor(c);
11590: RETURN TRUE;
11591: EXCEPTION
11592: WHEN OTHERS THEN

Line 11589: dbms_sql.close_cursor(c);

11585: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
11586: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
11587: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
11588: n:=DBMS_SQL.execute(c);
11589: dbms_sql.close_cursor(c);
11590: RETURN TRUE;
11591: EXCEPTION
11592: WHEN OTHERS THEN
11593: dbms_sql.close_cursor(c);

Line 11593: dbms_sql.close_cursor(c);

11589: dbms_sql.close_cursor(c);
11590: RETURN TRUE;
11591: EXCEPTION
11592: WHEN OTHERS THEN
11593: dbms_sql.close_cursor(c);
11594: RETURN FALSE;
11595: END;
11596:
11597:

Line 11619: c := dbms_sql.open_cursor;

11615: l_entity := FUNCS.ENTITY_NAME;
11616: l_attribute := FUNCS.ATTRIBUTE_NAME;
11617: l_procedure := FUNCS.PROCEDURE_NAME;
11618: l_trans_name := FUNCS.TRANSFORMATION_NAME;
11619: c := dbms_sql.open_cursor;
11620: l_sql := 'select ' || FUNCS.PROCEDURE_NAME ||
11621: '(:attrval,:lang,:attr,:entity) from dual';
11622: dbms_sql.parse(c,l_sql,2);
11623: dbms_sql.close_cursor(c);

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

11618: l_trans_name := FUNCS.TRANSFORMATION_NAME;
11619: c := dbms_sql.open_cursor;
11620: l_sql := 'select ' || FUNCS.PROCEDURE_NAME ||
11621: '(:attrval,:lang,:attr,:entity) from dual';
11622: dbms_sql.parse(c,l_sql,2);
11623: dbms_sql.close_cursor(c);
11624: EXCEPTION WHEN OTHERS THEN
11625: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANS_PROC_ERROR1');
11626: FND_MESSAGE.SET_TOKEN('PROC' ,l_procedure);

Line 11623: dbms_sql.close_cursor(c);

11619: c := dbms_sql.open_cursor;
11620: l_sql := 'select ' || FUNCS.PROCEDURE_NAME ||
11621: '(:attrval,:lang,:attr,:entity) from dual';
11622: dbms_sql.parse(c,l_sql,2);
11623: dbms_sql.close_cursor(c);
11624: EXCEPTION WHEN OTHERS THEN
11625: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANS_PROC_ERROR1');
11626: FND_MESSAGE.SET_TOKEN('PROC' ,l_procedure);
11627: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_entity);

Line 11646: c := dbms_sql.open_cursor;

11642: l_custom := TRUE;
11643: l_entity := FUNCS.ENTITY_NAME;
11644: l_attribute := FUNCS.ATTRIBUTE_NAME;
11645: l_procedure := FUNCS.custom_attribute_procedure;
11646: c := dbms_sql.open_cursor;
11647: l_sql := 'select ' || FUNCS.custom_attribute_procedure ||
11648: '(:record_id,:entity,:attr) from dual';
11649: dbms_sql.parse(c,l_sql,2);
11650: dbms_sql.close_cursor(c);

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

11645: l_procedure := FUNCS.custom_attribute_procedure;
11646: c := dbms_sql.open_cursor;
11647: l_sql := 'select ' || FUNCS.custom_attribute_procedure ||
11648: '(:record_id,:entity,:attr) from dual';
11649: dbms_sql.parse(c,l_sql,2);
11650: dbms_sql.close_cursor(c);
11651: EXCEPTION WHEN OTHERS THEN
11652: FND_MESSAGE.SET_NAME('AR', 'HZ_CUSTOM_PROC_ERROR1');
11653: FND_MESSAGE.SET_TOKEN('PROC' ,l_procedure);

Line 11650: dbms_sql.close_cursor(c);

11646: c := dbms_sql.open_cursor;
11647: l_sql := 'select ' || FUNCS.custom_attribute_procedure ||
11648: '(:record_id,:entity,:attr) from dual';
11649: dbms_sql.parse(c,l_sql,2);
11650: dbms_sql.close_cursor(c);
11651: EXCEPTION WHEN OTHERS THEN
11652: FND_MESSAGE.SET_NAME('AR', 'HZ_CUSTOM_PROC_ERROR1');
11653: FND_MESSAGE.SET_TOKEN('PROC' ,l_procedure);
11654: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_entity);

Line 11661: dbms_sql.close_cursor(c);

11657: END;
11658: END LOOP;
11659: EXCEPTION
11660: WHEN OTHERS THEN
11661: dbms_sql.close_cursor(c);
11662: RAISE FND_API.G_EXC_ERROR;
11663: END ;
11664:
11665: