eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PSB_YEAR_TYPE_PVT dependencies on PSB_BUDGET_YEAR_TYPES

Line 54: FROM psb_budget_year_types

50:
51: --
52: SELECT count(*)
53: INTO l_seq_count
54: FROM psb_budget_year_types
55: WHERE sequence_number = p_year_type_seq
56: AND ((p_year_type_id IS NULL ) OR
57: ( budget_year_type_id <> p_year_type_id)) ;
58: --

Line 140: FROM psb_budget_year_types

136: SELECT max(decode(year_category_type, 'PY', sequence_number)),
137: min(decode(year_category_type, 'PP', sequence_number)),
138: min(decode(year_category_type, 'CY', sequence_number)),
139: 1
140: FROM psb_budget_year_types
141: GROUP BY 1 ;
142: --
143: BEGIN
144:

Line 314: FROM psb_budget_year_types

310:
311: -- API body
312: SELECT count(*)
313: INTO l_cy_count
314: FROM psb_budget_year_types
315: WHERE year_category_type = 'CY'
316: AND ((p_year_type_id IS NULL) OR
317: (budget_year_type_id <> p_year_type_id));
318: --

Line 536: FROM psb_budget_year_types

532:
533: --
534: SELECT count(*)
535: INTO l_seq_count
536: FROM psb_budget_year_types
537: WHERE name = p_name
538: AND ((p_year_type_id IS NULL ) OR
539: ( budget_year_type_id <> p_year_type_id)) ;
540: --

Line 646: cursor C is select ROWID from PSB_BUDGET_YEAR_TYPES

642: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_ROW';
643: l_api_version CONSTANT NUMBER := 1.0;
644: l_seq_count NUMBER ;
645:
646: cursor C is select ROWID from PSB_BUDGET_YEAR_TYPES
647: where BUDGET_YEAR_TYPE_ID = p_BUDGET_YEAR_TYPE_ID
648: ;
649: BEGIN
650:

Line 675: insert into PSB_BUDGET_YEAR_TYPES (

671: -- Initialize API return status to success
672:
673: p_return_status := FND_API.G_RET_STS_SUCCESS;
674:
675: insert into PSB_BUDGET_YEAR_TYPES (
676: BUDGET_YEAR_TYPE_ID,
677: YEAR_CATEGORY_TYPE,
678: NAME,
679: SEQUENCE_NUMBER,

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 804: from PSB_BUDGET_YEAR_TYPES

800: ) is
801: cursor c is select
802: YEAR_CATEGORY_TYPE,
803: SEQUENCE_NUMBER
804: from PSB_BUDGET_YEAR_TYPES
805: where BUDGET_YEAR_TYPE_ID = p_BUDGET_YEAR_TYPE_ID
806: for update of BUDGET_YEAR_TYPE_ID nowait;
807: recinfo c%rowtype;
808:

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 978: update PSB_BUDGET_YEAR_TYPES set

974: -- Initialize API return status to success
975:
976: p_return_status := FND_API.G_RET_STS_SUCCESS;
977:
978: update PSB_BUDGET_YEAR_TYPES set
979: YEAR_CATEGORY_TYPE = p_YEAR_CATEGORY_TYPE,
980: SEQUENCE_NUMBER = p_SEQUENCE_NUMBER,
981: LAST_UPDATE_DATE = p_LAST_UPDATE_DATE,
982: LAST_UPDATED_BY = p_LAST_UPDATED_BY,

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 1101: delete from PSB_BUDGET_YEAR_TYPES

1097: if (sql%notfound) then
1098: raise no_data_found;
1099: end if;
1100:
1101: delete from PSB_BUDGET_YEAR_TYPES
1102: where BUDGET_YEAR_TYPE_ID = p_BUDGET_YEAR_TYPE_ID;
1103:
1104: if (sql%notfound) then
1105: 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 1164: from PSB_BUDGET_YEAR_TYPES B

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
1166: );
1167:
1168: update PSB_BUDGET_YEAR_TYPES_TL T set (

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: