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,
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,
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,
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,
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);
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: ----------------------------------------------
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 --
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;
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');
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
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));
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:
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,
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),
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,
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),
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:
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,
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,
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: ----------------------------------
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 --