DBA Data[Home] [Help]

APPS.POA_DBI_COM_C dependencies on FND_GLOBAL

Line 42: l_login := fnd_global.login_id;

38: IF (v_check_flag=0) THEN
39:
40: -- Get the values for the WHO columns
41: l_start_time := SYSDATE;
42: l_login := fnd_global.login_id;
43: l_user := fnd_global.user_id;
44:
45: --Get the commodity id in the variable
46: SELECT po_commodities_s.NEXTVAL INTO v_nextval FROM dual;

Line 43: l_user := fnd_global.user_id;

39:
40: -- Get the values for the WHO columns
41: l_start_time := SYSDATE;
42: l_login := fnd_global.login_id;
43: l_user := fnd_global.user_id;
44:
45: --Get the commodity id in the variable
46: SELECT po_commodities_s.NEXTVAL INTO v_nextval FROM dual;
47: --Insert into the table po_commodities_b

Line 150: l_login := fnd_global.login_id;

146:
147: BEGIN
148: -- Get the values in the WHO columns
149: l_start_time := sysdate;
150: l_login := fnd_global.login_id;
151: l_user := fnd_global.user_id;
152: --Get the value of new commodity code into the variable v_commodity_code
153: v_commodity_code := fnd_message.get_string('POA','POA_DBI_DEFAULT_COMMODITY');
154: --Extract 40 characters and Trim the spaces

Line 151: l_user := fnd_global.user_id;

147: BEGIN
148: -- Get the values in the WHO columns
149: l_start_time := sysdate;
150: l_login := fnd_global.login_id;
151: l_user := fnd_global.user_id;
152: --Get the value of new commodity code into the variable v_commodity_code
153: v_commodity_code := fnd_message.get_string('POA','POA_DBI_DEFAULT_COMMODITY');
154: --Extract 40 characters and Trim the spaces
155: v_commodity_code := trim(substr(v_commodity_code,1,40));