[Home] [Help]
21: SELECT
22: DATA_EXTRACT_NAME
23: INTO CP_DATA_EXTRACT_NAME
24: FROM
25: PSB_DATA_EXTRACTS
26: WHERE DATA_EXTRACT_ID = P_DATA_EXTRACT_ID;
27: FND_MESSAGE.SET_NAME('PSB'
28: ,'PSB_ALL');
29: CP_POSITION_SETS := FND_MESSAGE.GET;
33: SELECT
34: DATA_EXTRACT_NAME
35: INTO CP_DATA_EXTRACT_NAME
36: FROM
37: PSB_DATA_EXTRACTS
38: WHERE DATA_EXTRACT_ID = P_DATA_EXTRACT_ID;
39: SELECT
40: NAME
41: INTO CP_POSITION_SETS