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.JG_JGZZRCAK_XMLP_PKG dependencies on FND_SEQNUM

Line 1165: X0 := FND_SEQNUM.GET_NEXT_SEQUENCE(APPID, CAT_CODE, SOBID, MET_CODE, TRX_DATE, DBSEQNM, DBSEQID);

1161: ,DBSEQNM IN OUT NOCOPY VARCHAR2
1162: ,DBSEQID IN OUT NOCOPY INTEGER) RETURN NUMBER IS
1163: X0 NUMBER;
1164: BEGIN
1165: X0 := FND_SEQNUM.GET_NEXT_SEQUENCE(APPID, CAT_CODE, SOBID, MET_CODE, TRX_DATE, DBSEQNM, DBSEQID);
1166: /*STPROC.INIT('begin :X0 := FND_SEQNUM.GET_NEXT_SEQUENCE(:APPID, :CAT_CODE, :SOBID, :MET_CODE, :TRX_DATE, :DBSEQNM, :DBSEQID); end;');
1167: STPROC.BIND_O(X0);
1168: STPROC.BIND_I(APPID);
1169: STPROC.BIND_I(CAT_CODE);

Line 1166: /*STPROC.INIT('begin :X0 := FND_SEQNUM.GET_NEXT_SEQUENCE(:APPID, :CAT_CODE, :SOBID, :MET_CODE, :TRX_DATE, :DBSEQNM, :DBSEQID); end;');

1162: ,DBSEQID IN OUT NOCOPY INTEGER) RETURN NUMBER IS
1163: X0 NUMBER;
1164: BEGIN
1165: X0 := FND_SEQNUM.GET_NEXT_SEQUENCE(APPID, CAT_CODE, SOBID, MET_CODE, TRX_DATE, DBSEQNM, DBSEQID);
1166: /*STPROC.INIT('begin :X0 := FND_SEQNUM.GET_NEXT_SEQUENCE(:APPID, :CAT_CODE, :SOBID, :MET_CODE, :TRX_DATE, :DBSEQNM, :DBSEQID); end;');
1167: STPROC.BIND_O(X0);
1168: STPROC.BIND_I(APPID);
1169: STPROC.BIND_I(CAT_CODE);
1170: STPROC.BIND_I(SOBID);

Line 1194: FND_SEQNUM.GET_SEQ_NAME(APPID, CAT_CODE, SOBID, MET_CODE, TRX_DATE, DBSEQNM, DBSEQID, SEQASSID);

1190: ,DBSEQNM OUT NOCOPY VARCHAR2
1191: ,DBSEQID OUT NOCOPY INTEGER
1192: ,SEQASSID OUT NOCOPY INTEGER) IS
1193: BEGIN
1194: FND_SEQNUM.GET_SEQ_NAME(APPID, CAT_CODE, SOBID, MET_CODE, TRX_DATE, DBSEQNM, DBSEQID, SEQASSID);
1195: /*STPROC.INIT('begin FND_SEQNUM.GET_SEQ_NAME(:APPID, :CAT_CODE, :SOBID, :MET_CODE, :TRX_DATE, :DBSEQNM, :DBSEQID, :SEQASSID); end;');
1196: STPROC.BIND_I(APPID);
1197: STPROC.BIND_I(CAT_CODE);
1198: STPROC.BIND_I(SOBID);

Line 1195: /*STPROC.INIT('begin FND_SEQNUM.GET_SEQ_NAME(:APPID, :CAT_CODE, :SOBID, :MET_CODE, :TRX_DATE, :DBSEQNM, :DBSEQID, :SEQASSID); end;');

1191: ,DBSEQID OUT NOCOPY INTEGER
1192: ,SEQASSID OUT NOCOPY INTEGER) IS
1193: BEGIN
1194: FND_SEQNUM.GET_SEQ_NAME(APPID, CAT_CODE, SOBID, MET_CODE, TRX_DATE, DBSEQNM, DBSEQID, SEQASSID);
1195: /*STPROC.INIT('begin FND_SEQNUM.GET_SEQ_NAME(:APPID, :CAT_CODE, :SOBID, :MET_CODE, :TRX_DATE, :DBSEQNM, :DBSEQID, :SEQASSID); end;');
1196: STPROC.BIND_I(APPID);
1197: STPROC.BIND_I(CAT_CODE);
1198: STPROC.BIND_I(SOBID);
1199: STPROC.BIND_I(MET_CODE);

Line 1216: X0 := FND_SEQNUM.GET_NEXT_AUTO_SEQ(DBSEQNM);

1212:
1213: FUNCTION GET_NEXT_AUTO_SEQ(DBSEQNM IN VARCHAR2) RETURN NUMBER IS
1214: X0 NUMBER;
1215: BEGIN
1216: X0 := FND_SEQNUM.GET_NEXT_AUTO_SEQ(DBSEQNM);
1217: /*STPROC.INIT('begin :X0 := FND_SEQNUM.GET_NEXT_AUTO_SEQ(:DBSEQNM); end;');
1218: STPROC.BIND_O(X0);
1219: STPROC.BIND_I(DBSEQNM);
1220: STPROC.EXECUTE;

Line 1217: /*STPROC.INIT('begin :X0 := FND_SEQNUM.GET_NEXT_AUTO_SEQ(:DBSEQNM); end;');

1213: FUNCTION GET_NEXT_AUTO_SEQ(DBSEQNM IN VARCHAR2) RETURN NUMBER IS
1214: X0 NUMBER;
1215: BEGIN
1216: X0 := FND_SEQNUM.GET_NEXT_AUTO_SEQ(DBSEQNM);
1217: /*STPROC.INIT('begin :X0 := FND_SEQNUM.GET_NEXT_AUTO_SEQ(:DBSEQNM); end;');
1218: STPROC.BIND_O(X0);
1219: STPROC.BIND_I(DBSEQNM);
1220: STPROC.EXECUTE;
1221: STPROC.RETRIEVE(1

Line 1233: X0 := FND_SEQNUM.GET_NEXT_AUTO_SEQUENCE(APPID, CAT_CODE, SOBID, MET_CODE, TRX_DATE);

1229: ,MET_CODE IN VARCHAR2
1230: ,TRX_DATE IN VARCHAR2) RETURN NUMBER IS
1231: X0 NUMBER;
1232: BEGIN
1233: X0 := FND_SEQNUM.GET_NEXT_AUTO_SEQUENCE(APPID, CAT_CODE, SOBID, MET_CODE, TRX_DATE);
1234: /*STPROC.INIT('begin :X0 := FND_SEQNUM.GET_NEXT_AUTO_SEQUENCE(:APPID, :CAT_CODE, :SOBID, :MET_CODE, :TRX_DATE); end;');
1235: STPROC.BIND_O(X0);
1236: STPROC.BIND_I(APPID);
1237: STPROC.BIND_I(CAT_CODE);

Line 1234: /*STPROC.INIT('begin :X0 := FND_SEQNUM.GET_NEXT_AUTO_SEQUENCE(:APPID, :CAT_CODE, :SOBID, :MET_CODE, :TRX_DATE); end;');

1230: ,TRX_DATE IN VARCHAR2) RETURN NUMBER IS
1231: X0 NUMBER;
1232: BEGIN
1233: X0 := FND_SEQNUM.GET_NEXT_AUTO_SEQUENCE(APPID, CAT_CODE, SOBID, MET_CODE, TRX_DATE);
1234: /*STPROC.INIT('begin :X0 := FND_SEQNUM.GET_NEXT_AUTO_SEQUENCE(:APPID, :CAT_CODE, :SOBID, :MET_CODE, :TRX_DATE); end;');
1235: STPROC.BIND_O(X0);
1236: STPROC.BIND_I(APPID);
1237: STPROC.BIND_I(CAT_CODE);
1238: STPROC.BIND_I(SOBID);

Line 1254: X0 := FND_SEQNUM.GET_NEXT_AUTO_SEQUENCE(APPID, CAT_CODE, SOBID, MET_CODE, TRX_DATE);

1250: ,MET_CODE IN VARCHAR2
1251: ,TRX_DATE IN DATE) RETURN NUMBER IS
1252: X0 NUMBER;
1253: BEGIN
1254: X0 := FND_SEQNUM.GET_NEXT_AUTO_SEQUENCE(APPID, CAT_CODE, SOBID, MET_CODE, TRX_DATE);
1255: /* STPROC.INIT('begin :X0 := FND_SEQNUM.GET_NEXT_AUTO_SEQUENCE(:APPID, :CAT_CODE, :SOBID, :MET_CODE, :TRX_DATE); end;');
1256: STPROC.BIND_O(X0);
1257: STPROC.BIND_I(APPID);
1258: STPROC.BIND_I(CAT_CODE);

Line 1255: /* STPROC.INIT('begin :X0 := FND_SEQNUM.GET_NEXT_AUTO_SEQUENCE(:APPID, :CAT_CODE, :SOBID, :MET_CODE, :TRX_DATE); end;');

1251: ,TRX_DATE IN DATE) RETURN NUMBER IS
1252: X0 NUMBER;
1253: BEGIN
1254: X0 := FND_SEQNUM.GET_NEXT_AUTO_SEQUENCE(APPID, CAT_CODE, SOBID, MET_CODE, TRX_DATE);
1255: /* STPROC.INIT('begin :X0 := FND_SEQNUM.GET_NEXT_AUTO_SEQUENCE(:APPID, :CAT_CODE, :SOBID, :MET_CODE, :TRX_DATE); end;');
1256: STPROC.BIND_O(X0);
1257: STPROC.BIND_I(APPID);
1258: STPROC.BIND_I(CAT_CODE);
1259: STPROC.BIND_I(SOBID);

Line 1270: FND_SEQNUM.CREATE_GAPLESS_SEQUENCES;

1266: END GET_NEXT_AUTO_SEQUENCE;
1267:
1268: PROCEDURE CREATE_GAPLESS_SEQUENCES IS
1269: BEGIN
1270: FND_SEQNUM.CREATE_GAPLESS_SEQUENCES;
1271: /*STPROC.INIT('begin FND_SEQNUM.CREATE_GAPLESS_SEQUENCES; end;');
1272: STPROC.EXECUTE;*/
1273: END CREATE_GAPLESS_SEQUENCES;
1274:

Line 1271: /*STPROC.INIT('begin FND_SEQNUM.CREATE_GAPLESS_SEQUENCES; end;');

1267:
1268: PROCEDURE CREATE_GAPLESS_SEQUENCES IS
1269: BEGIN
1270: FND_SEQNUM.CREATE_GAPLESS_SEQUENCES;
1271: /*STPROC.INIT('begin FND_SEQNUM.CREATE_GAPLESS_SEQUENCES; end;');
1272: STPROC.EXECUTE;*/
1273: END CREATE_GAPLESS_SEQUENCES;
1274:
1275: /*FUNCTION CREATE_GAPLESS_SEQUENCE(SEQID IN NUMBER

Line 1279: X0 := FND_SEQNUM.CREATE_GAPLESS_SEQUENCE(SEQID,SEQASSID);

1275: /*FUNCTION CREATE_GAPLESS_SEQUENCE(SEQID IN NUMBER
1276: ,SEQASSID IN NUMBER) RETURN NUMBER IS
1277: X0 NUMBER;
1278: BEGIN
1279: X0 := FND_SEQNUM.CREATE_GAPLESS_SEQUENCE(SEQID,SEQASSID);
1280: STPROC.INIT('begin :X0 := FND_SEQNUM.CREATE_GAPLESS_SEQUENCE(:SEQID, :SEQASSID); end;');
1281: STPROC.BIND_O(X0);
1282: STPROC.BIND_I(SEQID);
1283: STPROC.BIND_I(SEQASSID);

Line 1280: STPROC.INIT('begin :X0 := FND_SEQNUM.CREATE_GAPLESS_SEQUENCE(:SEQID, :SEQASSID); end;');

1276: ,SEQASSID IN NUMBER) RETURN NUMBER IS
1277: X0 NUMBER;
1278: BEGIN
1279: X0 := FND_SEQNUM.CREATE_GAPLESS_SEQUENCE(SEQID,SEQASSID);
1280: STPROC.INIT('begin :X0 := FND_SEQNUM.CREATE_GAPLESS_SEQUENCE(:SEQID, :SEQASSID); end;');
1281: STPROC.BIND_O(X0);
1282: STPROC.BIND_I(SEQID);
1283: STPROC.BIND_I(SEQASSID);
1284: STPROC.EXECUTE;

Line 1295: X0 := FND_SEQNUM.GET_NEXT_USER_SEQUENCE(FDS_USER_ID, SEQASSID, SEQID);

1291: ,SEQASSID IN NUMBER
1292: ,SEQID IN NUMBER) RETURN NUMBER IS
1293: X0 NUMBER;
1294: BEGIN
1295: X0 := FND_SEQNUM.GET_NEXT_USER_SEQUENCE(FDS_USER_ID, SEQASSID, SEQID);
1296: /*STPROC.INIT('begin :X0 := FND_SEQNUM.GET_NEXT_USER_SEQUENCE(:FDS_USER_ID, :SEQASSID, :SEQID); end;');
1297: STPROC.BIND_O(X0);
1298: STPROC.BIND_I(FDS_USER_ID);
1299: STPROC.BIND_I(SEQASSID);

Line 1296: /*STPROC.INIT('begin :X0 := FND_SEQNUM.GET_NEXT_USER_SEQUENCE(:FDS_USER_ID, :SEQASSID, :SEQID); end;');

1292: ,SEQID IN NUMBER) RETURN NUMBER IS
1293: X0 NUMBER;
1294: BEGIN
1295: X0 := FND_SEQNUM.GET_NEXT_USER_SEQUENCE(FDS_USER_ID, SEQASSID, SEQID);
1296: /*STPROC.INIT('begin :X0 := FND_SEQNUM.GET_NEXT_USER_SEQUENCE(:FDS_USER_ID, :SEQASSID, :SEQID); end;');
1297: STPROC.BIND_O(X0);
1298: STPROC.BIND_I(FDS_USER_ID);
1299: STPROC.BIND_I(SEQASSID);
1300: STPROC.BIND_I(SEQID);