DBA Data[Home] [Help]

APPS.OKL_TQL_PVT dependencies on FND_GLOBAL

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

2458: l_tql_rec.modified_yn,
2459: l_tql_rec.defaulted_yn,
2460: l_tql_rec.taxed_yn,
2461: l_tql_rec.org_id,
2462: decode(FND_GLOBAL.CONC_REQUEST_ID, -1, NULL, FND_GLOBAL.CONC_REQUEST_ID),
2463: decode(FND_GLOBAL.PROG_APPL_ID, -1, NULL, FND_GLOBAL.PROG_APPL_ID),
2464: decode(FND_GLOBAL.CONC_PROGRAM_ID, -1, NULL, FND_GLOBAL.CONC_PROGRAM_ID),
2465: decode(FND_GLOBAL.CONC_REQUEST_ID, -1, NULL, SYSDATE),
2466: l_tql_rec.attribute_category,

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

2459: l_tql_rec.defaulted_yn,
2460: l_tql_rec.taxed_yn,
2461: l_tql_rec.org_id,
2462: decode(FND_GLOBAL.CONC_REQUEST_ID, -1, NULL, FND_GLOBAL.CONC_REQUEST_ID),
2463: decode(FND_GLOBAL.PROG_APPL_ID, -1, NULL, FND_GLOBAL.PROG_APPL_ID),
2464: decode(FND_GLOBAL.CONC_PROGRAM_ID, -1, NULL, FND_GLOBAL.CONC_PROGRAM_ID),
2465: decode(FND_GLOBAL.CONC_REQUEST_ID, -1, NULL, SYSDATE),
2466: l_tql_rec.attribute_category,
2467: l_tql_rec.attribute1,

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

2460: l_tql_rec.taxed_yn,
2461: l_tql_rec.org_id,
2462: decode(FND_GLOBAL.CONC_REQUEST_ID, -1, NULL, FND_GLOBAL.CONC_REQUEST_ID),
2463: decode(FND_GLOBAL.PROG_APPL_ID, -1, NULL, FND_GLOBAL.PROG_APPL_ID),
2464: decode(FND_GLOBAL.CONC_PROGRAM_ID, -1, NULL, FND_GLOBAL.CONC_PROGRAM_ID),
2465: decode(FND_GLOBAL.CONC_REQUEST_ID, -1, NULL, SYSDATE),
2466: l_tql_rec.attribute_category,
2467: l_tql_rec.attribute1,
2468: l_tql_rec.attribute2,

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

2461: l_tql_rec.org_id,
2462: decode(FND_GLOBAL.CONC_REQUEST_ID, -1, NULL, FND_GLOBAL.CONC_REQUEST_ID),
2463: decode(FND_GLOBAL.PROG_APPL_ID, -1, NULL, FND_GLOBAL.PROG_APPL_ID),
2464: decode(FND_GLOBAL.CONC_PROGRAM_ID, -1, NULL, FND_GLOBAL.CONC_PROGRAM_ID),
2465: decode(FND_GLOBAL.CONC_REQUEST_ID, -1, NULL, SYSDATE),
2466: l_tql_rec.attribute_category,
2467: l_tql_rec.attribute1,
2468: l_tql_rec.attribute2,
2469: l_tql_rec.attribute3,

Line 2710: l_tqlv_rec.CREATED_BY := FND_GLOBAL.USER_ID;

2706: ) RETURN tqlv_rec_type IS
2707: l_tqlv_rec tqlv_rec_type := p_tqlv_rec;
2708: BEGIN
2709: l_tqlv_rec.CREATION_DATE := SYSDATE;
2710: l_tqlv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
2711: l_tqlv_rec.LAST_UPDATE_DATE :=l_tqlv_rec.CREATION_DATE;
2712: l_tqlv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2713: l_tqlv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2714: RETURN(l_tqlv_rec);

Line 2712: l_tqlv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

2708: BEGIN
2709: l_tqlv_rec.CREATION_DATE := SYSDATE;
2710: l_tqlv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
2711: l_tqlv_rec.LAST_UPDATE_DATE :=l_tqlv_rec.CREATION_DATE;
2712: l_tqlv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2713: l_tqlv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2714: RETURN(l_tqlv_rec);
2715: END fill_who_columns;
2716: ----------------------------------------------

Line 2713: l_tqlv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

2709: l_tqlv_rec.CREATION_DATE := SYSDATE;
2710: l_tqlv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
2711: l_tqlv_rec.LAST_UPDATE_DATE :=l_tqlv_rec.CREATION_DATE;
2712: l_tqlv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2713: l_tqlv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2714: RETURN(l_tqlv_rec);
2715: END fill_who_columns;
2716: ----------------------------------------------
2717: -- Set_Attributes for:OKL_TXL_QUOTE_LINES_V --

Line 3103: l_user_id := FND_GLOBAL.USER_ID;

3099: j :=0;
3100:
3101: l_org_id := MO_GLOBAL.GET_CURRENT_ORG_ID();
3102: l_curr_code := OKL_AM_UTIL_PVT.get_functional_currency;
3103: l_user_id := FND_GLOBAL.USER_ID;
3104: l_login_id := FND_GLOBAL.LOGIN_ID;
3105: l_conc_req_id := FND_GLOBAL.CONC_REQUEST_ID;
3106: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
3107: l_conc_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;

Line 3104: l_login_id := FND_GLOBAL.LOGIN_ID;

3100:
3101: l_org_id := MO_GLOBAL.GET_CURRENT_ORG_ID();
3102: l_curr_code := OKL_AM_UTIL_PVT.get_functional_currency;
3103: l_user_id := FND_GLOBAL.USER_ID;
3104: l_login_id := FND_GLOBAL.LOGIN_ID;
3105: l_conc_req_id := FND_GLOBAL.CONC_REQUEST_ID;
3106: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
3107: l_conc_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;
3108: l_lang := USERENV('LANG');

Line 3105: l_conc_req_id := FND_GLOBAL.CONC_REQUEST_ID;

3101: l_org_id := MO_GLOBAL.GET_CURRENT_ORG_ID();
3102: l_curr_code := OKL_AM_UTIL_PVT.get_functional_currency;
3103: l_user_id := FND_GLOBAL.USER_ID;
3104: l_login_id := FND_GLOBAL.LOGIN_ID;
3105: l_conc_req_id := FND_GLOBAL.CONC_REQUEST_ID;
3106: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
3107: l_conc_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;
3108: l_lang := USERENV('LANG');
3109: WHILE i is not null LOOP

Line 3106: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;

3102: l_curr_code := OKL_AM_UTIL_PVT.get_functional_currency;
3103: l_user_id := FND_GLOBAL.USER_ID;
3104: l_login_id := FND_GLOBAL.LOGIN_ID;
3105: l_conc_req_id := FND_GLOBAL.CONC_REQUEST_ID;
3106: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
3107: l_conc_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;
3108: l_lang := USERENV('LANG');
3109: WHILE i is not null LOOP
3110: l_tqlv_rec := null_out_defaults(p_tqlv_tbl(i));

Line 3107: l_conc_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;

3103: l_user_id := FND_GLOBAL.USER_ID;
3104: l_login_id := FND_GLOBAL.LOGIN_ID;
3105: l_conc_req_id := FND_GLOBAL.CONC_REQUEST_ID;
3106: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
3107: l_conc_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;
3108: l_lang := USERENV('LANG');
3109: WHILE i is not null LOOP
3110: l_tqlv_rec := null_out_defaults(p_tqlv_tbl(i));
3111:

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

4178: MODIFIED_YN = l_def_tql_rec.modified_yn,
4179: DEFAULTED_YN = l_def_tql_rec.defaulted_yn,
4180: TAXED_YN = l_def_tql_rec.taxed_yn,
4181: ORG_ID = l_def_tql_rec.org_id,
4182: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,
4183: FND_GLOBAL.CONC_REQUEST_ID),l_def_tql_rec.request_id),
4184: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,
4185: FND_GLOBAL.PROG_APPL_ID),l_def_tql_rec.program_application_id),
4186: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,

Line 4183: FND_GLOBAL.CONC_REQUEST_ID),l_def_tql_rec.request_id),

4179: DEFAULTED_YN = l_def_tql_rec.defaulted_yn,
4180: TAXED_YN = l_def_tql_rec.taxed_yn,
4181: ORG_ID = l_def_tql_rec.org_id,
4182: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,
4183: FND_GLOBAL.CONC_REQUEST_ID),l_def_tql_rec.request_id),
4184: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,
4185: FND_GLOBAL.PROG_APPL_ID),l_def_tql_rec.program_application_id),
4186: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,
4187: FND_GLOBAL.CONC_PROGRAM_ID),l_def_tql_rec.program_id),

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

4180: TAXED_YN = l_def_tql_rec.taxed_yn,
4181: ORG_ID = l_def_tql_rec.org_id,
4182: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,
4183: FND_GLOBAL.CONC_REQUEST_ID),l_def_tql_rec.request_id),
4184: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,
4185: FND_GLOBAL.PROG_APPL_ID),l_def_tql_rec.program_application_id),
4186: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,
4187: FND_GLOBAL.CONC_PROGRAM_ID),l_def_tql_rec.program_id),
4188: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,

Line 4185: FND_GLOBAL.PROG_APPL_ID),l_def_tql_rec.program_application_id),

4181: ORG_ID = l_def_tql_rec.org_id,
4182: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,
4183: FND_GLOBAL.CONC_REQUEST_ID),l_def_tql_rec.request_id),
4184: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,
4185: FND_GLOBAL.PROG_APPL_ID),l_def_tql_rec.program_application_id),
4186: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,
4187: FND_GLOBAL.CONC_PROGRAM_ID),l_def_tql_rec.program_id),
4188: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,
4189: SYSDATE),NULL,l_def_tql_rec.program_update_date,SYSDATE),

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

4182: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,
4183: FND_GLOBAL.CONC_REQUEST_ID),l_def_tql_rec.request_id),
4184: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,
4185: FND_GLOBAL.PROG_APPL_ID),l_def_tql_rec.program_application_id),
4186: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,
4187: FND_GLOBAL.CONC_PROGRAM_ID),l_def_tql_rec.program_id),
4188: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,
4189: SYSDATE),NULL,l_def_tql_rec.program_update_date,SYSDATE),
4190:

Line 4187: FND_GLOBAL.CONC_PROGRAM_ID),l_def_tql_rec.program_id),

4183: FND_GLOBAL.CONC_REQUEST_ID),l_def_tql_rec.request_id),
4184: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,
4185: FND_GLOBAL.PROG_APPL_ID),l_def_tql_rec.program_application_id),
4186: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,
4187: FND_GLOBAL.CONC_PROGRAM_ID),l_def_tql_rec.program_id),
4188: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,
4189: SYSDATE),NULL,l_def_tql_rec.program_update_date,SYSDATE),
4190:
4191: ATTRIBUTE_CATEGORY = l_def_tql_rec.attribute_category,

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

4184: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,
4185: FND_GLOBAL.PROG_APPL_ID),l_def_tql_rec.program_application_id),
4186: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,
4187: FND_GLOBAL.CONC_PROGRAM_ID),l_def_tql_rec.program_id),
4188: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,
4189: SYSDATE),NULL,l_def_tql_rec.program_update_date,SYSDATE),
4190:
4191: ATTRIBUTE_CATEGORY = l_def_tql_rec.attribute_category,
4192: ATTRIBUTE1 = l_def_tql_rec.attribute1,

Line 4487: l_tqlv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

4483: ) RETURN tqlv_rec_type IS
4484: l_tqlv_rec tqlv_rec_type := p_tqlv_rec;
4485: BEGIN
4486: l_tqlv_rec.LAST_UPDATE_DATE := SYSDATE;
4487: l_tqlv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
4488: l_tqlv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
4489: RETURN(l_tqlv_rec);
4490: END fill_who_columns;
4491: ----------------------------------

Line 4488: l_tqlv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

4484: l_tqlv_rec tqlv_rec_type := p_tqlv_rec;
4485: BEGIN
4486: l_tqlv_rec.LAST_UPDATE_DATE := SYSDATE;
4487: l_tqlv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
4488: l_tqlv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
4489: RETURN(l_tqlv_rec);
4490: END fill_who_columns;
4491: ----------------------------------
4492: -- FUNCTION populate_new_record --