DBA Data[Home] [Help]

APPS.FND_SEQNUM dependencies on FND_GLOBAL

Line 831: docseq_type, init_value, v_startDate, v_endDate, SYSDATE, FND_GLOBAL.USER_ID,

827: AUDIT_TABLE_NAME, DB_SEQUENCE_NAME, MESSAGE_FLAG, TYPE, INITIAL_VALUE,
828: START_DATE, END_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE,
829: CREATED_BY, LAST_UPDATE_LOGIN )
830: values ( v_docSeqId, docseq_name, app_id, v_audTabNm, v_dbSeqNm, msg_flag,
831: docseq_type, init_value, v_startDate, v_endDate, SYSDATE, FND_GLOBAL.USER_ID,
832: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID );
833:
834: -- ok i assume all is well let's return SEQSUCC
835: return( FND_SEQNUM.SEQSUCC );

Line 832: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID );

828: START_DATE, END_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE,
829: CREATED_BY, LAST_UPDATE_LOGIN )
830: values ( v_docSeqId, docseq_name, app_id, v_audTabNm, v_dbSeqNm, msg_flag,
831: docseq_type, init_value, v_startDate, v_endDate, SYSDATE, FND_GLOBAL.USER_ID,
832: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID );
833:
834: -- ok i assume all is well let's return SEQSUCC
835: return( FND_SEQNUM.SEQSUCC );
836:

Line 1076: SYSDATE, FND_GLOBAL.USER_ID, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID );

1072: insert into FND_DOC_SEQUENCE_ASSIGNMENTS ( DOC_SEQUENCE_ASSIGNMENT_ID, DOC_SEQUENCE_ID,
1073: APPLICATION_ID, CATEGORY_CODE, SET_OF_BOOKS_ID, METHOD_CODE, START_DATE, END_DATE,
1074: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN )
1075: values ( v_seqAssID, v_docSeqId, app_id, cat_code, sob_id, met_code, v_startDate, v_endDate,
1076: SYSDATE, FND_GLOBAL.USER_ID, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID );
1077:
1078: begin /* update the table name for the Doc_Seq */
1079: UPDATE FND_DOCUMENT_SEQUENCES
1080: set TABLE_NAME = v_prdTabNm