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 3109: l_user_id := FND_GLOBAL.USER_ID;

3105: j :=0;
3106:
3107: l_org_id := MO_GLOBAL.GET_CURRENT_ORG_ID();
3108: l_curr_code := OKL_AM_UTIL_PVT.get_functional_currency;
3109: l_user_id := FND_GLOBAL.USER_ID;
3110: l_login_id := FND_GLOBAL.LOGIN_ID;
3111: l_conc_req_id := FND_GLOBAL.CONC_REQUEST_ID;
3112: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
3113: l_conc_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;

Line 3110: l_login_id := FND_GLOBAL.LOGIN_ID;

3106:
3107: l_org_id := MO_GLOBAL.GET_CURRENT_ORG_ID();
3108: l_curr_code := OKL_AM_UTIL_PVT.get_functional_currency;
3109: l_user_id := FND_GLOBAL.USER_ID;
3110: l_login_id := FND_GLOBAL.LOGIN_ID;
3111: l_conc_req_id := FND_GLOBAL.CONC_REQUEST_ID;
3112: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
3113: l_conc_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;
3114: l_lang := USERENV('LANG');

Line 3111: l_conc_req_id := FND_GLOBAL.CONC_REQUEST_ID;

3107: l_org_id := MO_GLOBAL.GET_CURRENT_ORG_ID();
3108: l_curr_code := OKL_AM_UTIL_PVT.get_functional_currency;
3109: l_user_id := FND_GLOBAL.USER_ID;
3110: l_login_id := FND_GLOBAL.LOGIN_ID;
3111: l_conc_req_id := FND_GLOBAL.CONC_REQUEST_ID;
3112: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
3113: l_conc_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;
3114: l_lang := USERENV('LANG');
3115: WHILE i is not null LOOP

Line 3112: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;

3108: l_curr_code := OKL_AM_UTIL_PVT.get_functional_currency;
3109: l_user_id := FND_GLOBAL.USER_ID;
3110: l_login_id := FND_GLOBAL.LOGIN_ID;
3111: l_conc_req_id := FND_GLOBAL.CONC_REQUEST_ID;
3112: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
3113: l_conc_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;
3114: l_lang := USERENV('LANG');
3115: WHILE i is not null LOOP
3116: l_tqlv_rec := null_out_defaults(p_tqlv_tbl(i));

Line 3113: l_conc_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;

3109: l_user_id := FND_GLOBAL.USER_ID;
3110: l_login_id := FND_GLOBAL.LOGIN_ID;
3111: l_conc_req_id := FND_GLOBAL.CONC_REQUEST_ID;
3112: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
3113: l_conc_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;
3114: l_lang := USERENV('LANG');
3115: WHILE i is not null LOOP
3116: l_tqlv_rec := null_out_defaults(p_tqlv_tbl(i));
3117:

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

4188: MODIFIED_YN = l_def_tql_rec.modified_yn,
4189: DEFAULTED_YN = l_def_tql_rec.defaulted_yn,
4190: TAXED_YN = l_def_tql_rec.taxed_yn,
4191: ORG_ID = l_def_tql_rec.org_id,
4192: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,
4193: FND_GLOBAL.CONC_REQUEST_ID),l_def_tql_rec.request_id),
4194: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,
4195: FND_GLOBAL.PROG_APPL_ID),l_def_tql_rec.program_application_id),
4196: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,

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

4189: DEFAULTED_YN = l_def_tql_rec.defaulted_yn,
4190: TAXED_YN = l_def_tql_rec.taxed_yn,
4191: ORG_ID = l_def_tql_rec.org_id,
4192: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,
4193: FND_GLOBAL.CONC_REQUEST_ID),l_def_tql_rec.request_id),
4194: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,
4195: FND_GLOBAL.PROG_APPL_ID),l_def_tql_rec.program_application_id),
4196: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,
4197: FND_GLOBAL.CONC_PROGRAM_ID),l_def_tql_rec.program_id),

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

4190: TAXED_YN = l_def_tql_rec.taxed_yn,
4191: ORG_ID = l_def_tql_rec.org_id,
4192: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,
4193: FND_GLOBAL.CONC_REQUEST_ID),l_def_tql_rec.request_id),
4194: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,
4195: FND_GLOBAL.PROG_APPL_ID),l_def_tql_rec.program_application_id),
4196: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,
4197: FND_GLOBAL.CONC_PROGRAM_ID),l_def_tql_rec.program_id),
4198: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,

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

4191: ORG_ID = l_def_tql_rec.org_id,
4192: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,
4193: FND_GLOBAL.CONC_REQUEST_ID),l_def_tql_rec.request_id),
4194: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,
4195: FND_GLOBAL.PROG_APPL_ID),l_def_tql_rec.program_application_id),
4196: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,
4197: FND_GLOBAL.CONC_PROGRAM_ID),l_def_tql_rec.program_id),
4198: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,
4199: SYSDATE),NULL,l_def_tql_rec.program_update_date,SYSDATE),

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

4192: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,
4193: FND_GLOBAL.CONC_REQUEST_ID),l_def_tql_rec.request_id),
4194: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,
4195: FND_GLOBAL.PROG_APPL_ID),l_def_tql_rec.program_application_id),
4196: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,
4197: FND_GLOBAL.CONC_PROGRAM_ID),l_def_tql_rec.program_id),
4198: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,
4199: SYSDATE),NULL,l_def_tql_rec.program_update_date,SYSDATE),
4200:

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

4193: FND_GLOBAL.CONC_REQUEST_ID),l_def_tql_rec.request_id),
4194: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,
4195: FND_GLOBAL.PROG_APPL_ID),l_def_tql_rec.program_application_id),
4196: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,
4197: FND_GLOBAL.CONC_PROGRAM_ID),l_def_tql_rec.program_id),
4198: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,
4199: SYSDATE),NULL,l_def_tql_rec.program_update_date,SYSDATE),
4200:
4201: ATTRIBUTE_CATEGORY = l_def_tql_rec.attribute_category,

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

4194: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,
4195: FND_GLOBAL.PROG_APPL_ID),l_def_tql_rec.program_application_id),
4196: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,
4197: FND_GLOBAL.CONC_PROGRAM_ID),l_def_tql_rec.program_id),
4198: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,
4199: SYSDATE),NULL,l_def_tql_rec.program_update_date,SYSDATE),
4200:
4201: ATTRIBUTE_CATEGORY = l_def_tql_rec.attribute_category,
4202: ATTRIBUTE1 = l_def_tql_rec.attribute1,

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

4493: ) RETURN tqlv_rec_type IS
4494: l_tqlv_rec tqlv_rec_type := p_tqlv_rec;
4495: BEGIN
4496: l_tqlv_rec.LAST_UPDATE_DATE := SYSDATE;
4497: l_tqlv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
4498: l_tqlv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
4499: RETURN(l_tqlv_rec);
4500: END fill_who_columns;
4501: ----------------------------------

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

4494: l_tqlv_rec tqlv_rec_type := p_tqlv_rec;
4495: BEGIN
4496: l_tqlv_rec.LAST_UPDATE_DATE := SYSDATE;
4497: l_tqlv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
4498: l_tqlv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
4499: RETURN(l_tqlv_rec);
4500: END fill_who_columns;
4501: ----------------------------------
4502: -- FUNCTION populate_new_record --