DBA Data[Home] [Help]

APPS.OKL_CIN_PVT dependencies on FND_GLOBAL

Line 1056: l_cin_rec.CREATED_BY := FND_GLOBAL.USER_ID;

1052: ) RETURN cin_rec_type IS
1053: l_cin_rec cin_rec_type := p_cin_rec;
1054: BEGIN
1055: l_cin_rec.CREATION_DATE := SYSDATE;
1056: l_cin_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1057: l_cin_rec.LAST_UPDATE_DATE := l_cin_rec.CREATION_DATE;
1058: l_cin_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1059: l_cin_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1060: l_cin_rec.REQUEST_ID := CASE WHEN FND_GLOBAL.CONC_REQUEST_ID = -1 THEN NULL ELSE FND_GLOBAL.CONC_REQUEST_ID END;

Line 1058: l_cin_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

1054: BEGIN
1055: l_cin_rec.CREATION_DATE := SYSDATE;
1056: l_cin_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1057: l_cin_rec.LAST_UPDATE_DATE := l_cin_rec.CREATION_DATE;
1058: l_cin_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1059: l_cin_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1060: l_cin_rec.REQUEST_ID := CASE WHEN FND_GLOBAL.CONC_REQUEST_ID = -1 THEN NULL ELSE FND_GLOBAL.CONC_REQUEST_ID END;
1061: l_cin_rec.PROGRAM_APPLICATION_ID := CASE WHEN FND_GLOBAL.PROG_APPL_ID = -1 THEN NULL ELSE FND_GLOBAL.PROG_APPL_ID END;
1062: l_cin_rec.PROGRAM_ID := CASE WHEN FND_GLOBAL.CONC_PROGRAM_ID = -1 THEN NULL ELSE FND_GLOBAL.CONC_PROGRAM_ID END;

Line 1059: l_cin_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

1055: l_cin_rec.CREATION_DATE := SYSDATE;
1056: l_cin_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1057: l_cin_rec.LAST_UPDATE_DATE := l_cin_rec.CREATION_DATE;
1058: l_cin_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1059: l_cin_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1060: l_cin_rec.REQUEST_ID := CASE WHEN FND_GLOBAL.CONC_REQUEST_ID = -1 THEN NULL ELSE FND_GLOBAL.CONC_REQUEST_ID END;
1061: l_cin_rec.PROGRAM_APPLICATION_ID := CASE WHEN FND_GLOBAL.PROG_APPL_ID = -1 THEN NULL ELSE FND_GLOBAL.PROG_APPL_ID END;
1062: l_cin_rec.PROGRAM_ID := CASE WHEN FND_GLOBAL.CONC_PROGRAM_ID = -1 THEN NULL ELSE FND_GLOBAL.CONC_PROGRAM_ID END;
1063: l_cin_rec.PROGRAM_UPDATE_DATE := CASE WHEN FND_GLOBAL.CONC_REQUEST_ID = -1 THEN NULL ELSE SYSDATE END;

Line 1060: l_cin_rec.REQUEST_ID := CASE WHEN FND_GLOBAL.CONC_REQUEST_ID = -1 THEN NULL ELSE FND_GLOBAL.CONC_REQUEST_ID END;

1056: l_cin_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1057: l_cin_rec.LAST_UPDATE_DATE := l_cin_rec.CREATION_DATE;
1058: l_cin_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1059: l_cin_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1060: l_cin_rec.REQUEST_ID := CASE WHEN FND_GLOBAL.CONC_REQUEST_ID = -1 THEN NULL ELSE FND_GLOBAL.CONC_REQUEST_ID END;
1061: l_cin_rec.PROGRAM_APPLICATION_ID := CASE WHEN FND_GLOBAL.PROG_APPL_ID = -1 THEN NULL ELSE FND_GLOBAL.PROG_APPL_ID END;
1062: l_cin_rec.PROGRAM_ID := CASE WHEN FND_GLOBAL.CONC_PROGRAM_ID = -1 THEN NULL ELSE FND_GLOBAL.CONC_PROGRAM_ID END;
1063: l_cin_rec.PROGRAM_UPDATE_DATE := CASE WHEN FND_GLOBAL.CONC_REQUEST_ID = -1 THEN NULL ELSE SYSDATE END;
1064: RETURN(l_cin_rec);

Line 1061: l_cin_rec.PROGRAM_APPLICATION_ID := CASE WHEN FND_GLOBAL.PROG_APPL_ID = -1 THEN NULL ELSE FND_GLOBAL.PROG_APPL_ID END;

1057: l_cin_rec.LAST_UPDATE_DATE := l_cin_rec.CREATION_DATE;
1058: l_cin_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1059: l_cin_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1060: l_cin_rec.REQUEST_ID := CASE WHEN FND_GLOBAL.CONC_REQUEST_ID = -1 THEN NULL ELSE FND_GLOBAL.CONC_REQUEST_ID END;
1061: l_cin_rec.PROGRAM_APPLICATION_ID := CASE WHEN FND_GLOBAL.PROG_APPL_ID = -1 THEN NULL ELSE FND_GLOBAL.PROG_APPL_ID END;
1062: l_cin_rec.PROGRAM_ID := CASE WHEN FND_GLOBAL.CONC_PROGRAM_ID = -1 THEN NULL ELSE FND_GLOBAL.CONC_PROGRAM_ID END;
1063: l_cin_rec.PROGRAM_UPDATE_DATE := CASE WHEN FND_GLOBAL.CONC_REQUEST_ID = -1 THEN NULL ELSE SYSDATE END;
1064: RETURN(l_cin_rec);
1065: END fill_who_columns;

Line 1062: l_cin_rec.PROGRAM_ID := CASE WHEN FND_GLOBAL.CONC_PROGRAM_ID = -1 THEN NULL ELSE FND_GLOBAL.CONC_PROGRAM_ID END;

1058: l_cin_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1059: l_cin_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1060: l_cin_rec.REQUEST_ID := CASE WHEN FND_GLOBAL.CONC_REQUEST_ID = -1 THEN NULL ELSE FND_GLOBAL.CONC_REQUEST_ID END;
1061: l_cin_rec.PROGRAM_APPLICATION_ID := CASE WHEN FND_GLOBAL.PROG_APPL_ID = -1 THEN NULL ELSE FND_GLOBAL.PROG_APPL_ID END;
1062: l_cin_rec.PROGRAM_ID := CASE WHEN FND_GLOBAL.CONC_PROGRAM_ID = -1 THEN NULL ELSE FND_GLOBAL.CONC_PROGRAM_ID END;
1063: l_cin_rec.PROGRAM_UPDATE_DATE := CASE WHEN FND_GLOBAL.CONC_REQUEST_ID = -1 THEN NULL ELSE SYSDATE END;
1064: RETURN(l_cin_rec);
1065: END fill_who_columns;
1066: ------------------------------------------

Line 1063: l_cin_rec.PROGRAM_UPDATE_DATE := CASE WHEN FND_GLOBAL.CONC_REQUEST_ID = -1 THEN NULL ELSE SYSDATE END;

1059: l_cin_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1060: l_cin_rec.REQUEST_ID := CASE WHEN FND_GLOBAL.CONC_REQUEST_ID = -1 THEN NULL ELSE FND_GLOBAL.CONC_REQUEST_ID END;
1061: l_cin_rec.PROGRAM_APPLICATION_ID := CASE WHEN FND_GLOBAL.PROG_APPL_ID = -1 THEN NULL ELSE FND_GLOBAL.PROG_APPL_ID END;
1062: l_cin_rec.PROGRAM_ID := CASE WHEN FND_GLOBAL.CONC_PROGRAM_ID = -1 THEN NULL ELSE FND_GLOBAL.CONC_PROGRAM_ID END;
1063: l_cin_rec.PROGRAM_UPDATE_DATE := CASE WHEN FND_GLOBAL.CONC_REQUEST_ID = -1 THEN NULL ELSE SYSDATE END;
1064: RETURN(l_cin_rec);
1065: END fill_who_columns;
1066: ------------------------------------------
1067: -- Set_Attributes for:OKL_CNSLD_AP_INVS --

Line 2125: l_cin_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

2121: ) RETURN cin_rec_type IS
2122: l_cin_rec cin_rec_type := p_cin_rec;
2123: BEGIN
2124: l_cin_rec.LAST_UPDATE_DATE := SYSDATE;
2125: l_cin_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2126: l_cin_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2127: l_cin_rec.REQUEST_ID := CASE WHEN FND_GLOBAL.CONC_REQUEST_ID = -1 THEN NULL ELSE FND_GLOBAL.CONC_REQUEST_ID END;
2128: l_cin_rec.PROGRAM_APPLICATION_ID := CASE WHEN FND_GLOBAL.PROG_APPL_ID = -1 THEN NULL ELSE FND_GLOBAL.PROG_APPL_ID END;
2129: l_cin_rec.PROGRAM_ID := CASE WHEN FND_GLOBAL.CONC_PROGRAM_ID = -1 THEN NULL ELSE FND_GLOBAL.CONC_PROGRAM_ID END;

Line 2126: l_cin_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

2122: l_cin_rec cin_rec_type := p_cin_rec;
2123: BEGIN
2124: l_cin_rec.LAST_UPDATE_DATE := SYSDATE;
2125: l_cin_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2126: l_cin_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2127: l_cin_rec.REQUEST_ID := CASE WHEN FND_GLOBAL.CONC_REQUEST_ID = -1 THEN NULL ELSE FND_GLOBAL.CONC_REQUEST_ID END;
2128: l_cin_rec.PROGRAM_APPLICATION_ID := CASE WHEN FND_GLOBAL.PROG_APPL_ID = -1 THEN NULL ELSE FND_GLOBAL.PROG_APPL_ID END;
2129: l_cin_rec.PROGRAM_ID := CASE WHEN FND_GLOBAL.CONC_PROGRAM_ID = -1 THEN NULL ELSE FND_GLOBAL.CONC_PROGRAM_ID END;
2130: l_cin_rec.PROGRAM_UPDATE_DATE := CASE WHEN FND_GLOBAL.CONC_REQUEST_ID = -1 THEN NULL ELSE SYSDATE END;

Line 2127: l_cin_rec.REQUEST_ID := CASE WHEN FND_GLOBAL.CONC_REQUEST_ID = -1 THEN NULL ELSE FND_GLOBAL.CONC_REQUEST_ID END;

2123: BEGIN
2124: l_cin_rec.LAST_UPDATE_DATE := SYSDATE;
2125: l_cin_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2126: l_cin_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2127: l_cin_rec.REQUEST_ID := CASE WHEN FND_GLOBAL.CONC_REQUEST_ID = -1 THEN NULL ELSE FND_GLOBAL.CONC_REQUEST_ID END;
2128: l_cin_rec.PROGRAM_APPLICATION_ID := CASE WHEN FND_GLOBAL.PROG_APPL_ID = -1 THEN NULL ELSE FND_GLOBAL.PROG_APPL_ID END;
2129: l_cin_rec.PROGRAM_ID := CASE WHEN FND_GLOBAL.CONC_PROGRAM_ID = -1 THEN NULL ELSE FND_GLOBAL.CONC_PROGRAM_ID END;
2130: l_cin_rec.PROGRAM_UPDATE_DATE := CASE WHEN FND_GLOBAL.CONC_REQUEST_ID = -1 THEN NULL ELSE SYSDATE END;
2131: RETURN(l_cin_rec);

Line 2128: l_cin_rec.PROGRAM_APPLICATION_ID := CASE WHEN FND_GLOBAL.PROG_APPL_ID = -1 THEN NULL ELSE FND_GLOBAL.PROG_APPL_ID END;

2124: l_cin_rec.LAST_UPDATE_DATE := SYSDATE;
2125: l_cin_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2126: l_cin_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2127: l_cin_rec.REQUEST_ID := CASE WHEN FND_GLOBAL.CONC_REQUEST_ID = -1 THEN NULL ELSE FND_GLOBAL.CONC_REQUEST_ID END;
2128: l_cin_rec.PROGRAM_APPLICATION_ID := CASE WHEN FND_GLOBAL.PROG_APPL_ID = -1 THEN NULL ELSE FND_GLOBAL.PROG_APPL_ID END;
2129: l_cin_rec.PROGRAM_ID := CASE WHEN FND_GLOBAL.CONC_PROGRAM_ID = -1 THEN NULL ELSE FND_GLOBAL.CONC_PROGRAM_ID END;
2130: l_cin_rec.PROGRAM_UPDATE_DATE := CASE WHEN FND_GLOBAL.CONC_REQUEST_ID = -1 THEN NULL ELSE SYSDATE END;
2131: RETURN(l_cin_rec);
2132: END fill_who_columns;

Line 2129: l_cin_rec.PROGRAM_ID := CASE WHEN FND_GLOBAL.CONC_PROGRAM_ID = -1 THEN NULL ELSE FND_GLOBAL.CONC_PROGRAM_ID END;

2125: l_cin_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2126: l_cin_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2127: l_cin_rec.REQUEST_ID := CASE WHEN FND_GLOBAL.CONC_REQUEST_ID = -1 THEN NULL ELSE FND_GLOBAL.CONC_REQUEST_ID END;
2128: l_cin_rec.PROGRAM_APPLICATION_ID := CASE WHEN FND_GLOBAL.PROG_APPL_ID = -1 THEN NULL ELSE FND_GLOBAL.PROG_APPL_ID END;
2129: l_cin_rec.PROGRAM_ID := CASE WHEN FND_GLOBAL.CONC_PROGRAM_ID = -1 THEN NULL ELSE FND_GLOBAL.CONC_PROGRAM_ID END;
2130: l_cin_rec.PROGRAM_UPDATE_DATE := CASE WHEN FND_GLOBAL.CONC_REQUEST_ID = -1 THEN NULL ELSE SYSDATE END;
2131: RETURN(l_cin_rec);
2132: END fill_who_columns;
2133: ----------------------------------

Line 2130: l_cin_rec.PROGRAM_UPDATE_DATE := CASE WHEN FND_GLOBAL.CONC_REQUEST_ID = -1 THEN NULL ELSE SYSDATE END;

2126: l_cin_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2127: l_cin_rec.REQUEST_ID := CASE WHEN FND_GLOBAL.CONC_REQUEST_ID = -1 THEN NULL ELSE FND_GLOBAL.CONC_REQUEST_ID END;
2128: l_cin_rec.PROGRAM_APPLICATION_ID := CASE WHEN FND_GLOBAL.PROG_APPL_ID = -1 THEN NULL ELSE FND_GLOBAL.PROG_APPL_ID END;
2129: l_cin_rec.PROGRAM_ID := CASE WHEN FND_GLOBAL.CONC_PROGRAM_ID = -1 THEN NULL ELSE FND_GLOBAL.CONC_PROGRAM_ID END;
2130: l_cin_rec.PROGRAM_UPDATE_DATE := CASE WHEN FND_GLOBAL.CONC_REQUEST_ID = -1 THEN NULL ELSE SYSDATE END;
2131: RETURN(l_cin_rec);
2132: END fill_who_columns;
2133: ----------------------------------
2134: -- FUNCTION populate_new_record --