DBA Data[Home] [Help]

APPS.OKC_NUMBER_SCHEME_GRP dependencies on FND_GLOBAL

Line 106: SELECT l_out||fnd_global.local_chr(26+decode(type,'L',96,'U',64))

102:
103: end if;
104:
105: If l_mod=0 then
106: SELECT l_out||fnd_global.local_chr(26+decode(type,'L',96,'U',64))
107: into l_out from dual;
108: return l_out;
109: else
110: SELECT l_out||fnd_global.local_chr(l_mod+decode(type,'L',96,'U',64))

Line 110: SELECT l_out||fnd_global.local_chr(l_mod+decode(type,'L',96,'U',64))

106: SELECT l_out||fnd_global.local_chr(26+decode(type,'L',96,'U',64))
107: into l_out from dual;
108: return l_out;
109: else
110: SELECT l_out||fnd_global.local_chr(l_mod+decode(type,'L',96,'U',64))
111: into l_out from dual;
112: return l_out;
113: end if;
114: end;

Line 626: l_string := l_string ||fnd_global.newline;

622: FOR i in 1..cr.sequence_level LOOP
623: l_string := ' '||l_string;
624: END LOOP;
625:
626: l_string := l_string ||fnd_global.newline;
627: l_concat_yn := cr.concatenation_yn;
628: l_out := l_out||l_string;
629: END LOOP;
630: END LOOP;

Line 639: created_by = Fnd_Global.User_Id,

635: Update OKC_NUMBER_SCHEMES_B SET
636: num_scheme_preview = x_out_string,
637: object_version_number = object_version_number+1,
638: creation_date = sysdate,
639: created_by = Fnd_Global.User_Id,
640: last_update_date = sysdate,
641: last_updated_by = Fnd_Global.User_Id,
642: last_update_login = Fnd_Global.Login_Id
643: WHERE num_scheme_id = p_num_scheme_id;

Line 641: last_updated_by = Fnd_Global.User_Id,

637: object_version_number = object_version_number+1,
638: creation_date = sysdate,
639: created_by = Fnd_Global.User_Id,
640: last_update_date = sysdate,
641: last_updated_by = Fnd_Global.User_Id,
642: last_update_login = Fnd_Global.Login_Id
643: WHERE num_scheme_id = p_num_scheme_id;
644: Commit;
645:

Line 642: last_update_login = Fnd_Global.Login_Id

638: creation_date = sysdate,
639: created_by = Fnd_Global.User_Id,
640: last_update_date = sysdate,
641: last_updated_by = Fnd_Global.User_Id,
642: last_update_login = Fnd_Global.Login_Id
643: WHERE num_scheme_id = p_num_scheme_id;
644: Commit;
645:
646: END IF;