69:
70:
71: /* standard WHO */
72: l_date := SYSDATE;
73: l_updated_by := FND_GLOBAL.USER_ID;
74: l_login_id := FND_GLOBAL.LOGIN_ID;
75:
76: /* standard concurrent program info */
77: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
70:
71: /* standard WHO */
72: l_date := SYSDATE;
73: l_updated_by := FND_GLOBAL.USER_ID;
74: l_login_id := FND_GLOBAL.LOGIN_ID;
75:
76: /* standard concurrent program info */
77: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
78: l_program_application_id := FND_GLOBAL.PROG_APPL_ID;
73: l_updated_by := FND_GLOBAL.USER_ID;
74: l_login_id := FND_GLOBAL.LOGIN_ID;
75:
76: /* standard concurrent program info */
77: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
78: l_program_application_id := FND_GLOBAL.PROG_APPL_ID;
79: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
80:
81:
74: l_login_id := FND_GLOBAL.LOGIN_ID;
75:
76: /* standard concurrent program info */
77: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
78: l_program_application_id := FND_GLOBAL.PROG_APPL_ID;
79: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
80:
81:
82: IF ((in_op_code = 'INSERT') OR (in_op_code = 'UPDATE')) THEN
75:
76: /* standard concurrent program info */
77: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
78: l_program_application_id := FND_GLOBAL.PROG_APPL_ID;
79: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
80:
81:
82: IF ((in_op_code = 'INSERT') OR (in_op_code = 'UPDATE')) THEN
83:
289: BEGIN
290:
291: /* standard WHO */
292: l_date := SYSDATE;
293: l_user_id := FND_GLOBAL.USER_ID;
294: l_login_id := FND_GLOBAL.LOGIN_ID;
295:
296: /* standard concurrent program info */
297: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
290:
291: /* standard WHO */
292: l_date := SYSDATE;
293: l_user_id := FND_GLOBAL.USER_ID;
294: l_login_id := FND_GLOBAL.LOGIN_ID;
295:
296: /* standard concurrent program info */
297: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
298: l_prog_application_id := FND_GLOBAL.PROG_APPL_ID;
293: l_user_id := FND_GLOBAL.USER_ID;
294: l_login_id := FND_GLOBAL.LOGIN_ID;
295:
296: /* standard concurrent program info */
297: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
298: l_prog_application_id := FND_GLOBAL.PROG_APPL_ID;
299: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
300:
301: IF (in_op_code = 'INSERT') THEN
294: l_login_id := FND_GLOBAL.LOGIN_ID;
295:
296: /* standard concurrent program info */
297: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
298: l_prog_application_id := FND_GLOBAL.PROG_APPL_ID;
299: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
300:
301: IF (in_op_code = 'INSERT') THEN
302:
295:
296: /* standard concurrent program info */
297: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
298: l_prog_application_id := FND_GLOBAL.PROG_APPL_ID;
299: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
300:
301: IF (in_op_code = 'INSERT') THEN
302:
303: INSERT INTO so_line_attributes