DBA Data[Home] [Help]

APPS.OKC_PAA_PVT dependencies on FND_GLOBAL

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

1057: l_paa_rec.pricing_attr_value_from,
1058: l_paa_rec.pricing_attr_value_to,
1059: l_paa_rec.comparison_operator,
1060: l_paa_rec.last_update_login,
1061: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
1062: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
1063: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
1064: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
1065: l_paa_rec.object_version_number);

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

1058: l_paa_rec.pricing_attr_value_to,
1059: l_paa_rec.comparison_operator,
1060: l_paa_rec.last_update_login,
1061: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
1062: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
1063: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
1064: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
1065: l_paa_rec.object_version_number);
1066: -- Set OUT values

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

1059: l_paa_rec.comparison_operator,
1060: l_paa_rec.last_update_login,
1061: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
1062: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
1063: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
1064: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
1065: l_paa_rec.object_version_number);
1066: -- Set OUT values
1067: x_paa_rec := l_paa_rec;

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

1060: l_paa_rec.last_update_login,
1061: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
1062: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
1063: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
1064: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
1065: l_paa_rec.object_version_number);
1066: -- Set OUT values
1067: x_paa_rec := l_paa_rec;
1068: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1155: l_paav_rec.CREATED_BY := FND_GLOBAL.USER_ID;

1151: l_paav_rec paav_rec_type := p_paav_rec;
1152: BEGIN
1153:
1154: l_paav_rec.CREATION_DATE := SYSDATE;
1155: l_paav_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1156: l_paav_rec.LAST_UPDATE_DATE := SYSDATE;
1157: l_paav_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1158: l_paav_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1159:

Line 1157: l_paav_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

1153:
1154: l_paav_rec.CREATION_DATE := SYSDATE;
1155: l_paav_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1156: l_paav_rec.LAST_UPDATE_DATE := SYSDATE;
1157: l_paav_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1158: l_paav_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1159:
1160: RETURN(l_paav_rec);
1161:

Line 1158: l_paav_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

1154: l_paav_rec.CREATION_DATE := SYSDATE;
1155: l_paav_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1156: l_paav_rec.LAST_UPDATE_DATE := SYSDATE;
1157: l_paav_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1158: l_paav_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1159:
1160: RETURN(l_paav_rec);
1161:
1162: END fill_who_columns;

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

2000: PRICING_ATTR_VALUE_FROM = l_def_paa_rec.pricing_attr_value_from,
2001: PRICING_ATTR_VALUE_TO = l_def_paa_rec.pricing_attr_value_to,
2002: COMPARISON_OPERATOR = l_def_paa_rec.comparison_operator,
2003: LAST_UPDATE_LOGIN = l_def_paa_rec.last_update_login,
2004: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_paa_rec.request_id),
2005: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_paa_rec.program_application_id),
2006: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_paa_rec.program_id),
2007: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_paa_rec.program_update_date,SYSDATE),
2008: OBJECT_VERSION_NUMBER = l_def_paa_rec.object_version_number

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

2001: PRICING_ATTR_VALUE_TO = l_def_paa_rec.pricing_attr_value_to,
2002: COMPARISON_OPERATOR = l_def_paa_rec.comparison_operator,
2003: LAST_UPDATE_LOGIN = l_def_paa_rec.last_update_login,
2004: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_paa_rec.request_id),
2005: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_paa_rec.program_application_id),
2006: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_paa_rec.program_id),
2007: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_paa_rec.program_update_date,SYSDATE),
2008: OBJECT_VERSION_NUMBER = l_def_paa_rec.object_version_number
2009: WHERE ID = l_def_paa_rec.id;

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

2002: COMPARISON_OPERATOR = l_def_paa_rec.comparison_operator,
2003: LAST_UPDATE_LOGIN = l_def_paa_rec.last_update_login,
2004: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_paa_rec.request_id),
2005: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_paa_rec.program_application_id),
2006: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_paa_rec.program_id),
2007: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_paa_rec.program_update_date,SYSDATE),
2008: OBJECT_VERSION_NUMBER = l_def_paa_rec.object_version_number
2009: WHERE ID = l_def_paa_rec.id;
2010:

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

2003: LAST_UPDATE_LOGIN = l_def_paa_rec.last_update_login,
2004: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_paa_rec.request_id),
2005: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_paa_rec.program_application_id),
2006: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_paa_rec.program_id),
2007: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_paa_rec.program_update_date,SYSDATE),
2008: OBJECT_VERSION_NUMBER = l_def_paa_rec.object_version_number
2009: WHERE ID = l_def_paa_rec.id;
2010:
2011: x_paa_rec := l_def_paa_rec;

Line 2099: l_paav_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

2095: l_paav_rec paav_rec_type := p_paav_rec;
2096: BEGIN
2097:
2098: l_paav_rec.LAST_UPDATE_DATE := SYSDATE;
2099: l_paav_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2100: l_paav_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2101: RETURN(l_paav_rec);
2102:
2103: END fill_who_columns;

Line 2100: l_paav_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

2096: BEGIN
2097:
2098: l_paav_rec.LAST_UPDATE_DATE := SYSDATE;
2099: l_paav_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2100: l_paav_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2101: RETURN(l_paav_rec);
2102:
2103: END fill_who_columns;
2104: ----------------------------------