DBA Data[Home] [Help]

APPS.OKL_TQD_PVT dependencies on FND_GLOBAL

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

919: l_tqd_rec.number_of_units,
920: l_tqd_rec.kle_id,
921: l_tqd_rec.tql_id,
922: l_tqd_rec.org_id,
923: decode(FND_GLOBAL.CONC_REQUEST_ID, -1, NULL, FND_GLOBAL.CONC_REQUEST_ID),
924: decode(FND_GLOBAL.PROG_APPL_ID, -1, NULL, FND_GLOBAL.PROG_APPL_ID),
925: decode(FND_GLOBAL.CONC_PROGRAM_ID, -1, NULL, FND_GLOBAL.CONC_PROGRAM_ID),
926: decode(FND_GLOBAL.CONC_REQUEST_ID, -1, NULL, SYSDATE),
927: l_tqd_rec.created_by,

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

920: l_tqd_rec.kle_id,
921: l_tqd_rec.tql_id,
922: l_tqd_rec.org_id,
923: decode(FND_GLOBAL.CONC_REQUEST_ID, -1, NULL, FND_GLOBAL.CONC_REQUEST_ID),
924: decode(FND_GLOBAL.PROG_APPL_ID, -1, NULL, FND_GLOBAL.PROG_APPL_ID),
925: decode(FND_GLOBAL.CONC_PROGRAM_ID, -1, NULL, FND_GLOBAL.CONC_PROGRAM_ID),
926: decode(FND_GLOBAL.CONC_REQUEST_ID, -1, NULL, SYSDATE),
927: l_tqd_rec.created_by,
928: l_tqd_rec.creation_date,

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

921: l_tqd_rec.tql_id,
922: l_tqd_rec.org_id,
923: decode(FND_GLOBAL.CONC_REQUEST_ID, -1, NULL, FND_GLOBAL.CONC_REQUEST_ID),
924: decode(FND_GLOBAL.PROG_APPL_ID, -1, NULL, FND_GLOBAL.PROG_APPL_ID),
925: decode(FND_GLOBAL.CONC_PROGRAM_ID, -1, NULL, FND_GLOBAL.CONC_PROGRAM_ID),
926: decode(FND_GLOBAL.CONC_REQUEST_ID, -1, NULL, SYSDATE),
927: l_tqd_rec.created_by,
928: l_tqd_rec.creation_date,
929: l_tqd_rec.last_updated_by,

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

922: l_tqd_rec.org_id,
923: decode(FND_GLOBAL.CONC_REQUEST_ID, -1, NULL, FND_GLOBAL.CONC_REQUEST_ID),
924: decode(FND_GLOBAL.PROG_APPL_ID, -1, NULL, FND_GLOBAL.PROG_APPL_ID),
925: decode(FND_GLOBAL.CONC_PROGRAM_ID, -1, NULL, FND_GLOBAL.CONC_PROGRAM_ID),
926: decode(FND_GLOBAL.CONC_REQUEST_ID, -1, NULL, SYSDATE),
927: l_tqd_rec.created_by,
928: l_tqd_rec.creation_date,
929: l_tqd_rec.last_updated_by,
930: l_tqd_rec.last_update_date,

Line 1004: l_tqdv_rec.CREATED_BY := FND_GLOBAL.USER_ID;

1000: ) RETURN tqdv_rec_type IS
1001: l_tqdv_rec tqdv_rec_type := p_tqdv_rec;
1002: BEGIN
1003: l_tqdv_rec.CREATION_DATE := SYSDATE;
1004: l_tqdv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1005: l_tqdv_rec.LAST_UPDATE_DATE := l_tqdv_rec.CREATION_DATE;
1006: l_tqdv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1007: l_tqdv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1008: RETURN(l_tqdv_rec);

Line 1006: l_tqdv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

1002: BEGIN
1003: l_tqdv_rec.CREATION_DATE := SYSDATE;
1004: l_tqdv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1005: l_tqdv_rec.LAST_UPDATE_DATE := l_tqdv_rec.CREATION_DATE;
1006: l_tqdv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1007: l_tqdv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1008: RETURN(l_tqdv_rec);
1009: END fill_who_columns;
1010: --------------------------------------------------

Line 1007: l_tqdv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

1003: l_tqdv_rec.CREATION_DATE := SYSDATE;
1004: l_tqdv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1005: l_tqdv_rec.LAST_UPDATE_DATE := l_tqdv_rec.CREATION_DATE;
1006: l_tqdv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1007: l_tqdv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1008: RETURN(l_tqdv_rec);
1009: END fill_who_columns;
1010: --------------------------------------------------
1011: -- Set_Attributes for:OKL_TXD_QUOTE_LINE_DTLS_V --

Line 1631: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,

1627: NUMBER_OF_UNITS = l_def_tqd_rec.number_of_units,
1628: KLE_ID = l_def_tqd_rec.kle_id,
1629: TQL_ID = l_def_tqd_rec.tql_id,
1630: ORG_ID = l_def_tqd_rec.org_id,
1631: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,
1632: FND_GLOBAL.CONC_REQUEST_ID),l_def_tqd_rec.request_id),
1633: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,
1634: FND_GLOBAL.PROG_APPL_ID),l_def_tqd_rec.program_application_id),
1635: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,

Line 1632: FND_GLOBAL.CONC_REQUEST_ID),l_def_tqd_rec.request_id),

1628: KLE_ID = l_def_tqd_rec.kle_id,
1629: TQL_ID = l_def_tqd_rec.tql_id,
1630: ORG_ID = l_def_tqd_rec.org_id,
1631: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,
1632: FND_GLOBAL.CONC_REQUEST_ID),l_def_tqd_rec.request_id),
1633: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,
1634: FND_GLOBAL.PROG_APPL_ID),l_def_tqd_rec.program_application_id),
1635: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,
1636: FND_GLOBAL.CONC_PROGRAM_ID),l_def_tqd_rec.program_id),

Line 1633: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,

1629: TQL_ID = l_def_tqd_rec.tql_id,
1630: ORG_ID = l_def_tqd_rec.org_id,
1631: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,
1632: FND_GLOBAL.CONC_REQUEST_ID),l_def_tqd_rec.request_id),
1633: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,
1634: FND_GLOBAL.PROG_APPL_ID),l_def_tqd_rec.program_application_id),
1635: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,
1636: FND_GLOBAL.CONC_PROGRAM_ID),l_def_tqd_rec.program_id),
1637: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,

Line 1634: FND_GLOBAL.PROG_APPL_ID),l_def_tqd_rec.program_application_id),

1630: ORG_ID = l_def_tqd_rec.org_id,
1631: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,
1632: FND_GLOBAL.CONC_REQUEST_ID),l_def_tqd_rec.request_id),
1633: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,
1634: FND_GLOBAL.PROG_APPL_ID),l_def_tqd_rec.program_application_id),
1635: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,
1636: FND_GLOBAL.CONC_PROGRAM_ID),l_def_tqd_rec.program_id),
1637: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,
1638: SYSDATE),NULL,l_def_tqd_rec.program_update_date,SYSDATE),

Line 1635: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,

1631: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,
1632: FND_GLOBAL.CONC_REQUEST_ID),l_def_tqd_rec.request_id),
1633: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,
1634: FND_GLOBAL.PROG_APPL_ID),l_def_tqd_rec.program_application_id),
1635: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,
1636: FND_GLOBAL.CONC_PROGRAM_ID),l_def_tqd_rec.program_id),
1637: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,
1638: SYSDATE),NULL,l_def_tqd_rec.program_update_date,SYSDATE),
1639: CREATED_BY = l_def_tqd_rec.created_by,

Line 1636: FND_GLOBAL.CONC_PROGRAM_ID),l_def_tqd_rec.program_id),

1632: FND_GLOBAL.CONC_REQUEST_ID),l_def_tqd_rec.request_id),
1633: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,
1634: FND_GLOBAL.PROG_APPL_ID),l_def_tqd_rec.program_application_id),
1635: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,
1636: FND_GLOBAL.CONC_PROGRAM_ID),l_def_tqd_rec.program_id),
1637: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,
1638: SYSDATE),NULL,l_def_tqd_rec.program_update_date,SYSDATE),
1639: CREATED_BY = l_def_tqd_rec.created_by,
1640: CREATION_DATE = l_def_tqd_rec.creation_date,

Line 1637: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,

1633: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,
1634: FND_GLOBAL.PROG_APPL_ID),l_def_tqd_rec.program_application_id),
1635: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,
1636: FND_GLOBAL.CONC_PROGRAM_ID),l_def_tqd_rec.program_id),
1637: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,
1638: SYSDATE),NULL,l_def_tqd_rec.program_update_date,SYSDATE),
1639: CREATED_BY = l_def_tqd_rec.created_by,
1640: CREATION_DATE = l_def_tqd_rec.creation_date,
1641: LAST_UPDATED_BY = l_def_tqd_rec.last_updated_by,

Line 1717: l_tqdv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

1713: ) RETURN tqdv_rec_type IS
1714: l_tqdv_rec tqdv_rec_type := p_tqdv_rec;
1715: BEGIN
1716: l_tqdv_rec.LAST_UPDATE_DATE := SYSDATE;
1717: l_tqdv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1718: l_tqdv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1719: RETURN(l_tqdv_rec);
1720: END fill_who_columns;
1721: ----------------------------------

Line 1718: l_tqdv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

1714: l_tqdv_rec tqdv_rec_type := p_tqdv_rec;
1715: BEGIN
1716: l_tqdv_rec.LAST_UPDATE_DATE := SYSDATE;
1717: l_tqdv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1718: l_tqdv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1719: RETURN(l_tqdv_rec);
1720: END fill_who_columns;
1721: ----------------------------------
1722: -- FUNCTION populate_new_record --