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