APPS.PSB_YEAR_TYPE_PVT dependencies on PSB_BUDGET_YEAR_TYPES_TL

Line 697: insert into PSB_BUDGET_YEAR_TYPES_TL (

693: p_LAST_UPDATED_BY,
694: p_LAST_UPDATE_LOGIN
695: );
696:
697: insert into PSB_BUDGET_YEAR_TYPES_TL (
698: BUDGET_YEAR_TYPE_ID,
699: NAME,
700: DESCRIPTION,
701: LAST_UPDATE_DATE,

Line 723: from PSB_BUDGET_YEAR_TYPES_TL T

719: from FND_LANGUAGES L
720: where L.INSTALLED_FLAG in ('I', 'B')
721: and not exists
722: (select NULL
723: from PSB_BUDGET_YEAR_TYPES_TL T
724: where T.BUDGET_YEAR_TYPE_ID = p_BUDGET_YEAR_TYPE_ID
725: and T.LANGUAGE = L.LANGUAGE_CODE);
726:
727: open c;

Line 813: from PSB_BUDGET_YEAR_TYPES_TL

809: cursor c1 is select
810: NAME,
811: DESCRIPTION,
812: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
813: from PSB_BUDGET_YEAR_TYPES_TL
814: where BUDGET_YEAR_TYPE_ID = p_BUDGET_YEAR_TYPE_ID
815: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
816: for update of BUDGET_YEAR_TYPE_ID nowait;
817:

Line 990: update PSB_BUDGET_YEAR_TYPES_TL set

986: if (sql%notfound) then
987: raise no_data_found;
988: end if;
989:
990: update PSB_BUDGET_YEAR_TYPES_TL set
991: NAME = p_NAME,
992: DESCRIPTION = p_DESCRIPTION,
993: LAST_UPDATE_DATE = p_LAST_UPDATE_DATE,
994: LAST_UPDATED_BY = p_LAST_UPDATED_BY,

Line 1094: delete from PSB_BUDGET_YEAR_TYPES_TL

1090: -- Initialize API return status to success
1091:
1092: p_return_status := FND_API.G_RET_STS_SUCCESS;
1093:
1094: delete from PSB_BUDGET_YEAR_TYPES_TL
1095: where BUDGET_YEAR_TYPE_ID = p_BUDGET_YEAR_TYPE_ID;
1096:
1097: if (sql%notfound) then
1098: raise no_data_found;

Line 1161: delete from PSB_BUDGET_YEAR_TYPES_TL T

1157:
1158: procedure ADD_LANGUAGE
1159: is
1160: begin
1161: delete from PSB_BUDGET_YEAR_TYPES_TL T
1162: where not exists
1163: (select NULL
1164: from PSB_BUDGET_YEAR_TYPES B
1165: where B.BUDGET_YEAR_TYPE_ID = T.BUDGET_YEAR_TYPE_ID

Line 1168: update PSB_BUDGET_YEAR_TYPES_TL T set (

1164: from PSB_BUDGET_YEAR_TYPES B
1165: where B.BUDGET_YEAR_TYPE_ID = T.BUDGET_YEAR_TYPE_ID
1166: );
1167:
1168: update PSB_BUDGET_YEAR_TYPES_TL T set (
1169: NAME,
1170: DESCRIPTION
1171: ) = (select
1172: B.NAME,

Line 1174: from PSB_BUDGET_YEAR_TYPES_TL B

1170: DESCRIPTION
1171: ) = (select
1172: B.NAME,
1173: B.DESCRIPTION
1174: from PSB_BUDGET_YEAR_TYPES_TL B
1175: where B.BUDGET_YEAR_TYPE_ID = T.BUDGET_YEAR_TYPE_ID
1176: and B.LANGUAGE = T.SOURCE_LANG)
1177: where (
1178: T.BUDGET_YEAR_TYPE_ID,

Line 1183: from PSB_BUDGET_YEAR_TYPES_TL SUBB, PSB_BUDGET_YEAR_TYPES_TL SUBT

1179: T.LANGUAGE
1180: ) in (select
1181: SUBT.BUDGET_YEAR_TYPE_ID,
1182: SUBT.LANGUAGE
1183: from PSB_BUDGET_YEAR_TYPES_TL SUBB, PSB_BUDGET_YEAR_TYPES_TL SUBT
1184: where SUBB.BUDGET_YEAR_TYPE_ID = SUBT.BUDGET_YEAR_TYPE_ID
1185: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1186: and (SUBB.NAME <> SUBT.NAME
1187: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 1190: insert into PSB_BUDGET_YEAR_TYPES_TL (

1186: and (SUBB.NAME <> SUBT.NAME
1187: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
1188: ));
1189:
1190: insert into PSB_BUDGET_YEAR_TYPES_TL (
1191: BUDGET_YEAR_TYPE_ID,
1192: NAME,
1193: DESCRIPTION,
1194: LAST_UPDATE_DATE,

Line 1212: from PSB_BUDGET_YEAR_TYPES_TL B, FND_LANGUAGES L

1208: B.CREATED_BY,
1209: B.CREATION_DATE,
1210: L.LANGUAGE_CODE,
1211: B.SOURCE_LANG
1212: from PSB_BUDGET_YEAR_TYPES_TL B, FND_LANGUAGES L
1213: where L.INSTALLED_FLAG in ('I', 'B')
1214: and B.LANGUAGE = userenv('LANG')
1215: and not exists
1216: (select NULL

Line 1217: from PSB_BUDGET_YEAR_TYPES_TL T

1213: where L.INSTALLED_FLAG in ('I', 'B')
1214: and B.LANGUAGE = userenv('LANG')
1215: and not exists
1216: (select NULL
1217: from PSB_BUDGET_YEAR_TYPES_TL T
1218: where T.BUDGET_YEAR_TYPE_ID = B.BUDGET_YEAR_TYPE_ID
1219: and T.LANGUAGE = L.LANGUAGE_CODE);
1220: end ADD_LANGUAGE;
1221: