DBA Data[Home] [Help]

APPS.PSB_MESSAGE_S dependencies on FND_GLOBAL

Line 4: l_new_line_char VARCHAR2(2000) := FND_GLOBAL.Newline;

1: PACKAGE BODY PSB_MESSAGE_S AS
2: /* $Header: PSBSTMSB.pls 120.3 2004/12/06 17:35:45 viraghun ship $ */
3:
4: l_new_line_char VARCHAR2(2000) := FND_GLOBAL.Newline;
5:
6: FUNCTION Get ( p_msg_index IN NUMBER ,
7: p_encoded IN VARCHAR2 := FND_API.G_TRUE )
8: RETURN VARCHAR2 IS

Line 140: l_conc_req_id NUMBER := NVL(FND_GLOBAL.CONC_REQUEST_ID, FND_API.G_MISS_NUM);

136:
137: l_msg_count NUMBER := p_msg_count ;
138: l_msg_data VARCHAR2(2000) := p_msg_data ;
139: l_msg_buf VARCHAR2(2000) ;
140: l_conc_req_id NUMBER := NVL(FND_GLOBAL.CONC_REQUEST_ID, FND_API.G_MISS_NUM);
141: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
142: l_seq_number NUMBER := 0 ;
143:
144: BEGIN

Line 141: l_user_id NUMBER := FND_GLOBAL.USER_ID ;

137: l_msg_count NUMBER := p_msg_count ;
138: l_msg_data VARCHAR2(2000) := p_msg_data ;
139: l_msg_buf VARCHAR2(2000) ;
140: l_conc_req_id NUMBER := NVL(FND_GLOBAL.CONC_REQUEST_ID, FND_API.G_MISS_NUM);
141: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
142: l_seq_number NUMBER := 0 ;
143:
144: BEGIN
145:

Line 349: l_conc_req_id NUMBER := NVL(FND_GLOBAL.CONC_REQUEST_ID, FND_API.G_MISS_NUM);

345: l_msg_buf VARCHAR2(3000);
346: l_max_seq_no NUMBER;
347: l_seq_no NUMBER;
348: l_loop_process BOOLEAN;
349: l_conc_req_id NUMBER := NVL(FND_GLOBAL.CONC_REQUEST_ID, FND_API.G_MISS_NUM);
350: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
351:
352: -- cursor to fetch the maximum of sequence
353: CURSOR l_seq_csr

Line 350: l_user_id NUMBER := FND_GLOBAL.USER_ID ;

346: l_max_seq_no NUMBER;
347: l_seq_no NUMBER;
348: l_loop_process BOOLEAN;
349: l_conc_req_id NUMBER := NVL(FND_GLOBAL.CONC_REQUEST_ID, FND_API.G_MISS_NUM);
350: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
351:
352: -- cursor to fetch the maximum of sequence
353: CURSOR l_seq_csr
354: IS