APPS.BIS_BUCKET_PVT dependencies on BIS_BUCKET_CUSTOMIZATIONS_S

Line 276: , p_site_id IN BIS_BUCKET_CUSTOMIZATIONS.site_id%TYPE

272: , p_user_id IN BIS_BUCKET_CUSTOMIZATIONS.user_id%TYPE
273: , p_responsibility_id IN BIS_BUCKET_CUSTOMIZATIONS.responsibility_id%TYPE
274: , p_application_id IN BIS_BUCKET_CUSTOMIZATIONS.application_id%TYPE
275: , p_org_id IN BIS_BUCKET_CUSTOMIZATIONS.org_id%TYPE
276: , p_site_id IN BIS_BUCKET_CUSTOMIZATIONS.site_id%TYPE
277: , p_page_id IN BIS_BUCKET_CUSTOMIZATIONS.page_id%TYPE
278: , p_function_id IN BIS_BUCKET_CUSTOMIZATIONS.function_id%TYPE
279: , p_range1_low IN BIS_BUCKET_CUSTOMIZATIONS.range1_low%TYPE
280: , p_range1_high IN BIS_BUCKET_CUSTOMIZATIONS.range1_high%TYPE

Line 324: UPDATE bis_bucket_customizations SET

320:
321: x_return_status := FND_API.G_RET_STS_SUCCESS;
322: FND_MSG_PUB.initialize;
323:
324: UPDATE bis_bucket_customizations SET
325: bucket_id = p_bucket_id,
326: user_id = p_user_id,
327: responsibility_id = p_responsibility_id,
328: application_id = p_application_id,

Line 643: UPDATE bis_bucket_customizations SET

639: END IF;
640: OPEN c_base_bucket;
641: FETCH c_base_bucket INTO l_base_bucket_rec;
642: IF(c_base_bucket%FOUND) THEN
643: UPDATE bis_bucket_customizations SET
644: user_id = NULL,
645: responsibility_id = NULL,
646: application_id = NULL,
647: org_id = NULL,

Line 1070: SELECT bis_bucket_customizations_s.nextval

1066: WHERE B.BUCKET_ID = l_bucket_id
1067: AND B.LANGUAGE = L.LANGUAGE_CODE
1068: );
1069:
1070: SELECT bis_bucket_customizations_s.nextval
1071: INTO l_id
1072: FROM DUAL;
1073:
1074: INSERT INTO bis_bucket_customizations

Line 1370: update BIS_BUCKET_CUSTOMIZATIONS set

1366: WHERE bucket_id = l_bucket_Id AND rownum < 2;
1367:
1368: IF (l_custom = 'F') THEN --update cust tables
1369:
1370: update BIS_BUCKET_CUSTOMIZATIONS set
1371: RANGE1_LOW = l_bis_bucket_rec.range1_low
1372: ,RANGE1_HIGH = l_bis_bucket_rec.range1_high
1373: ,RANGE2_LOW = l_bis_bucket_rec.range2_low
1374: ,RANGE2_HIGH = l_bis_bucket_rec.range2_high