DBA Data[Home] [Help]

APPS.OKC_PAV_PVT dependencies on FND_GLOBAL

Line 1102: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),

1098: l_pav_rec.qualifier_attribute98,
1099: l_pav_rec.qualifier_attribute99,
1100: l_pav_rec.qualifier_attribute100,
1101: l_pav_rec.last_update_login,
1102: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
1103: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
1104: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
1105: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
1106: l_pav_rec.object_version_number);

Line 1103: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),

1099: l_pav_rec.qualifier_attribute99,
1100: l_pav_rec.qualifier_attribute100,
1101: l_pav_rec.last_update_login,
1102: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
1103: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
1104: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
1105: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
1106: l_pav_rec.object_version_number);
1107: -- Set OUT values

Line 1104: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),

1100: l_pav_rec.qualifier_attribute100,
1101: l_pav_rec.last_update_login,
1102: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
1103: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
1104: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
1105: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
1106: l_pav_rec.object_version_number);
1107: -- Set OUT values
1108: x_pav_rec := l_pav_rec;

Line 1105: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),

1101: l_pav_rec.last_update_login,
1102: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
1103: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
1104: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
1105: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
1106: l_pav_rec.object_version_number);
1107: -- Set OUT values
1108: x_pav_rec := l_pav_rec;
1109: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1170: l_pavv_rec.CREATED_BY := FND_GLOBAL.USER_ID;

1166: ) RETURN pavv_rec_type IS
1167: l_pavv_rec pavv_rec_type := p_pavv_rec;
1168: BEGIN
1169: l_pavv_rec.CREATION_DATE := SYSDATE;
1170: l_pavv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1171: l_pavv_rec.LAST_UPDATE_DATE := l_pavv_rec.CREATION_DATE;
1172: l_pavv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1173: l_pavv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1174: RETURN(l_pavv_rec);

Line 1172: l_pavv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

1168: BEGIN
1169: l_pavv_rec.CREATION_DATE := SYSDATE;
1170: l_pavv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1171: l_pavv_rec.LAST_UPDATE_DATE := l_pavv_rec.CREATION_DATE;
1172: l_pavv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1173: l_pavv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1174: RETURN(l_pavv_rec);
1175: END fill_who_columns;
1176: -----------------------------------------------

Line 1173: l_pavv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

1169: l_pavv_rec.CREATION_DATE := SYSDATE;
1170: l_pavv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1171: l_pavv_rec.LAST_UPDATE_DATE := l_pavv_rec.CREATION_DATE;
1172: l_pavv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1173: l_pavv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1174: RETURN(l_pavv_rec);
1175: END fill_who_columns;
1176: -----------------------------------------------
1177: -- Set_Attributes for:OKC_PRICE_ATT_VALUES_V --

Line 2761: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_pav_rec.request_id),

2757: QUALIFIER_ATTRIBUTE98 = l_def_pav_rec.qualifier_attribute98,
2758: QUALIFIER_ATTRIBUTE99 = l_def_pav_rec.qualifier_attribute99,
2759: QUALIFIER_ATTRIBUTE100 = l_def_pav_rec.qualifier_attribute100,
2760: LAST_UPDATE_LOGIN = l_def_pav_rec.last_update_login,
2761: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_pav_rec.request_id),
2762: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_pav_rec.program_application_id),
2763: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_pav_rec.program_id),
2764: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_pav_rec.program_update_date,SYSDATE),
2765: OBJECT_VERSION_NUMBER = l_def_pav_rec.object_version_number

Line 2762: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_pav_rec.program_application_id),

2758: QUALIFIER_ATTRIBUTE99 = l_def_pav_rec.qualifier_attribute99,
2759: QUALIFIER_ATTRIBUTE100 = l_def_pav_rec.qualifier_attribute100,
2760: LAST_UPDATE_LOGIN = l_def_pav_rec.last_update_login,
2761: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_pav_rec.request_id),
2762: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_pav_rec.program_application_id),
2763: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_pav_rec.program_id),
2764: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_pav_rec.program_update_date,SYSDATE),
2765: OBJECT_VERSION_NUMBER = l_def_pav_rec.object_version_number
2766: WHERE ID = l_def_pav_rec.id;

Line 2763: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_pav_rec.program_id),

2759: QUALIFIER_ATTRIBUTE100 = l_def_pav_rec.qualifier_attribute100,
2760: LAST_UPDATE_LOGIN = l_def_pav_rec.last_update_login,
2761: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_pav_rec.request_id),
2762: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_pav_rec.program_application_id),
2763: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_pav_rec.program_id),
2764: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_pav_rec.program_update_date,SYSDATE),
2765: OBJECT_VERSION_NUMBER = l_def_pav_rec.object_version_number
2766: WHERE ID = l_def_pav_rec.id;
2767:

Line 2764: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_pav_rec.program_update_date,SYSDATE),

2760: LAST_UPDATE_LOGIN = l_def_pav_rec.last_update_login,
2761: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_pav_rec.request_id),
2762: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_pav_rec.program_application_id),
2763: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_pav_rec.program_id),
2764: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_pav_rec.program_update_date,SYSDATE),
2765: OBJECT_VERSION_NUMBER = l_def_pav_rec.object_version_number
2766: WHERE ID = l_def_pav_rec.id;
2767:
2768: x_pav_rec := l_def_pav_rec;

Line 2830: l_pavv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

2826: ) RETURN pavv_rec_type IS
2827: l_pavv_rec pavv_rec_type := p_pavv_rec;
2828: BEGIN
2829: l_pavv_rec.LAST_UPDATE_DATE := SYSDATE;
2830: l_pavv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2831: l_pavv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2832: RETURN(l_pavv_rec);
2833: END fill_who_columns;
2834: ----------------------------------

Line 2831: l_pavv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

2827: l_pavv_rec pavv_rec_type := p_pavv_rec;
2828: BEGIN
2829: l_pavv_rec.LAST_UPDATE_DATE := SYSDATE;
2830: l_pavv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2831: l_pavv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2832: RETURN(l_pavv_rec);
2833: END fill_who_columns;
2834: ----------------------------------
2835: -- FUNCTION populate_new_record --